JP3006988B2 - Spreadsheet apparatus and data management method for spreadsheet apparatus - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a spreadsheet apparatus for displaying a data input area in a table format on a display device and processing the input data, and a data management method for the spreadsheet apparatus.

2. Description of the Related Art Spreadsheets for inputting data in a table displayed on a screen of a display device in an interactive manner and performing calculation processing are widely used. In such a spreadsheet apparatus, it is necessary to efficiently manage input data in order to reduce a response time and effectively use a data storage area.

[0003]

2. Description of the Related Art Conventionally, input data of a spreadsheet is managed by dividing a table into blocks, and all data input areas (data input areas of the table) in the block, including areas having no data input. Data was managed in block units.

FIG. 9 shows a data management method of a conventional spreadsheet apparatus. FIG. 9 shows column A, 1 row, 2 rows, 3 rows and column B, 1 row, 2 rows.
Rows and 3 rows are in block units for data management, C column 1
The case where rows, 2 rows, 3 rows and D column 1 row, 2 rows, 3 rows are used as a data management block unit is shown.

In FIG. 9, P is a spreadsheet device. 1
Reference numeral 00 denotes an input processing device that displays a table of a spreadsheet device on a display screen, determines the position of the input data in the table, and uses the data as input data. The figure shows a case where the data input area has three rows and four columns.

A data processing device 101 processes and manages data input to a table of the input processing device 100. In the input processing device 100, a data input area 111 is a data input area of a table. In the figure, the blank is a data non-input area. The figure shows a state where data is input to one and two rows in column A and two rows in column C.

In the data processing device 101, a data management device 115 manages data input to the data input area 111.

Reference numeral 116 denotes a data management block 1,
This is a block for managing data in columns A and B. 117
Is a data management block 2, which manages data in columns C and D.

Reference numeral 120 denotes management data in column A, one row,
It is composed of data values, attributes (color, character type, etc.) of input data, and the like. Reference numeral 121 denotes management data of column B, one row (not input).

A conventional data management method will be described with reference to FIG. When inputting data to the spreadsheet device P, the user positions the cursor on the data input area 111 of the table 110 displayed on the input processing device 100 and inputs data from the input device. For example, when data is input to D column 1 row, the D example 1 row cursor is moved and data is input.

The input data is managed by the data management device 11.
In 5, the input data was managed for each block. For example, the data management block 1 (116) includes the row 120 of column A and the row B managed by the block 1 (116) such as the data 120 in column A and row 1 and the data (uninput) 121 in column B and row 1. All data was managed regardless of the presence or absence of data input. Similarly, in the data management block 2 (117), all the data of the rows to be managed in the columns C and D are managed by the data management block 2 (117), including the rows without data input.

[0012]

As described above, the conventional spreadsheet apparatus secures a management area for data management even in a data input area where no data is input.
The data management size has become enormous, which not only wastes storage space but also has poor operation response.

An object of the present invention is to provide a spreadsheet apparatus and a data management method for the spreadsheet apparatus, which can reduce the data management size.

[0014]

FIG. 1 shows a basic configuration of the present invention. In FIG. 1, P is a spreadsheet device which displays a data input area in a table format on a display device and processes the input data.

An input processing device 1 displays a data input area in a table on a display device, determines the position of the input data in the table, and uses the data as input data.
A data processing device 2 processes and manages data input by the input processing device 1.

Reference numeral 3 denotes an input device. In the input processing device 1, reference numeral 11 denotes a data input area, which is a data input area of a table. The cursor is moved to the data input area 11 by the input device 3, and a data value is input. In the figure, a blank represents an uninput area of data, and the figure shows a state where data is input to one row and two rows in column A and two rows in column C.

In the data processing device 2, a data management device 15 manages input data.
Reference numeral 20 denotes a column management table for managing input data of a column by column management information.

Reference numeral 21 denotes a data management table, which comprises column management areas (25) and (26) for managing input data of a row for each column. Reference numeral 22 denotes a management data creation unit which creates a column management table 20, sets column management information in a column where data is input, and manages column management areas (25), (25), (25) in the data management table 21 based on the column management information. 26). The column management information includes a pointer for specifying the position of a column management area for managing input data of a column.

Reference numeral 25 denotes a column management area of column A, which is an area for holding input data management data of the row of column A. 2
5 'is data in column A, one row.

Reference numeral 25 "denotes data in column A, 2 rows. Reference numeral 26 denotes a column management area in column C, which is an area for holding the management data input to the row in column C.

Reference numeral 26 'denotes data in C column and 2 rows.

[0022]

In the basic configuration shown in FIG. 1, the input processing device 1 determines the position of the data input area 11 of the input data. The management data creation means 22 creates the column management table 20. Then, the column management information is set in the column management table 20 only for the column having the data input. For example, a pointer or the like indicating the position of the column management area 25 of column A is set in the column management table 20.

Further, the management data creating means 22 secures column management areas (25) and (26) for setting management data of the row of the corresponding column according to the column management information of the column management table 20,
Management data is created and set in the column management areas (25) and (26). For example, in the case of column A, management data (input data values, row numbers, attributes, etc.) for one and two rows of column A is created and set in the column management area (25) of column A. At this time, the management data of one row in column A has information (pointer or the like) for specifying the position of the management data in two rows of column A, thereby specifying the data area of two rows of column A. The management data of the two rows in column A is A
A pointer indicating an area where the management data of one row of the column exists is provided so that mutual positions can be recognized.
Then, the column management areas (25) and (26) are reserved only for rows having data. When a row for which data has been input is added, a pointer is set to the area for setting the management data of the row added to the management data of another row in the same column, and the pointer is added to the area specified by the pointer. Row management data is set.

Since there is no data input for column B, no column management information is set in the column management table 20. And
No column management area is reserved in the data management table 21. C
As for columns, column management information is set in column C of the column management table 20. Then, in accordance with the column management information, a column management area 26 of column C is secured, and management data (input data value, row number, etc.) of two rows of column C is set. Since there is no input data for the column D, no column management information is set in the column management table 20. Also, no column management area is secured.

[0025]

FIG. 2 shows an embodiment of the configuration of the spreadsheet apparatus according to the present invention. In FIG. 2, P is a spreadsheet device.

Reference numeral 31 denotes a spreadsheet program, which comprises an input processing program 35 and a data processing program 36. The input processing program 35 is a display 54
Has functions such as displaying a data input area in a table format.
The data processing program 36 has functions such as processing and managing data input to the data input area.

Reference numeral 32 denotes an input processing device, which comprises an input processing program 35, a CPU 50, a storage device 51, and a display 54. A data processing device 33 processes input data, and includes a data processing program 36, a CPU 50, and a storage device 51.

Reference numeral 35 denotes an input processing program. 36 is a data processing program. 37 is a data management program. Data management program 37, CPU (5
0), the storage device 51 constitutes a data management device.

Reference numeral 40 denotes management data creation means. 50 is a CPU. Reference numeral 51 denotes a storage device which secures areas such as a column management table area 52 and a data management table area 53.

Numeral 54 denotes a display for displaying a table of a spreadsheet program. An input device 55 is a keyboard, a mouse, and the like. Reference numeral 56 denotes a disk device for storing created data, inputting data, storing application programs, and the like.

FIG. 3 is a diagram showing an embodiment of the present invention.
This shows the initial state before data is input. In FIG.
32 is an input processing device.

Reference numeral 33 denotes a data processing device. In the input processing device 32, reference numeral 60 denotes a table, which is displayed on a display.

Reference numeral 61 denotes a data input area. In the data processing device 33, reference numeral 65 denotes a data management device.

Reference numeral 66 denotes a column management table. FIG. 4 is a diagram showing an embodiment of the present invention, and shows a state where data is input to a table. 32 is an input processing device.

Reference numeral 33 denotes a data processing device. In the input processing unit 32, reference numeral 60 denotes a table, "A" in column A, 1 row, "I" in column B, 1 row "U" in column A, 2 rows, "E" in column B, 2 rows, "E", column E A state in which “KA” is input in three rows and “KI” is input in four rows of E columns.

Reference numeral 61 denotes a data input area. In the data processing device 33, reference numeral 65 denotes a data management device.

Reference numeral 66 denotes a column management table. 67 is a data management table. Reference numeral 71 denotes a management area in column A.

Reference numeral 72 denotes a management area for column B. Reference numeral 73 denotes a management area in column E. Reference numeral 75 denotes management data, which indicates the structure of the management data, and is composed of a detail section for holding a line number, an attribute of input data, and the like, and a data section for holding an input data value. The figure shows input data of column A, one row, and shows a row number “1” and an input data value “a” (attributes are not shown).

Reference numeral 76 denotes a detailed part. 77 is a data part. According to the present invention, as shown in FIG. 4, management data is created only for data input to the input processing device 32 in the data management device. In the case of FIG. 4, the management area 7 in column A
In column 1, management data in column A is created by “1” indicating that the row is column A, and the data value “A”, and “2” indicating that row A is row 2 and the data value “u”. . Also,
“1” indicating that there is one row in column B in the management area 72 in column B
, The data value “i”, “2” indicating that the data is in column B, row 2 and the data value “e” create management data. Similarly, in the management area 73 of the column E, “3” and the data value “ka” indicating that it is the third row of the column E, and “4” and “4” indicating that it is the fourth row of the column E and the data value “ki” are used. Is created. Then, the management data of the data input area 61 having no input data is not created.

FIG. 5 shows a flow of the management data creation processing of the present invention. The flow will be described according to the numbers in FIG.
See). S1 The management data creation unit (see the management data creation unit 22 in FIG. 1) creates the column management table 66.

S2 Data is input to the input processing device 32. S3 The input processing device 32 determines the position of the data input area 61 where the input data is located. For example, when data is input to column B, one row, it is determined that data is input to column B, one row.

S4 The management data creation means sets column management information in column B of the column management table 66, and secures a column B management area (72). S5 Created column B data area (column B management area 7
The row number and the data value are stored in 2).

FIG. 6 is a diagram showing an embodiment of the data management method of the present invention. In FIG. 6, reference numeral 32 denotes an input processing device.

In the input processing device 32, reference numeral 60 denotes a table, "A" in column A, line 1; "A" in column A, line 2; "U" in column C, line 2; Indicates a state in which data is input.

Reference numeral 61 denotes a data input area. A storage device 51 secures a column management table 66 and a data management table 67.

In the storage device 51, reference numeral 66 denotes a column management table. Reference numeral 66 'denotes column management information having a pointer for designating the position of the column management area of the data management table 67.

Reference numeral 67 denotes a data management table, which is constituted by a column management area of a column in which data is input. The data management method of the present invention will be described with reference to FIG.

The management data creation means (see the management data creation means 22 in FIG. 1) stores column management information (pointers 66 ′ for designating the position of the column management area, Data width). If there is no data entry in the column, no column management information is created. Then, a column management area is created in the area specified by the pointer 66 'of the column management information in the column management table 66, and the row number and data value of the column are secured.

According to the example of FIG.
A data creation method of the data management table 67 will be described. When determining that there is data in column A, the management data creating means sets a pointer ($ 0000) for designating the column A management region (the region for reporting the leading data of column A). A management area for setting the head data of column A is secured at the position indicated by the pointer ($ 0000), and the management data of the head data of column A (one line "A") is set. The management data includes an area for the input data value "A" in the data part, a row number "" 1 "in the detail part, an attribute (color, character type, etc.), and an area for the management data next to the column A (" I "in two rows). Pointer to specify ($ 00
01). Further, the pointer ($ 0
001) in the area specified by the previous pointer ($ 0 indicating the position of the management data in row A, row 1).
000), data value, row number, etc.). In the example of the figure, since the data after the third row in the column A does not exist, the next pointer is set to Null.

Since there is no input data in the column B, the pointer of the management information of the column B in the column management table 66 is set to Null. Since there is input data in column C, a pointer ($ 0002) for designating the management area of column C is set in the column management information of column C in the column management table 66. The pointer ($ 0
002), a management area for column C is secured, and a pointer ($ 0003) for specifying the position of the input data at the head of column C ("U" in two rows) and the management data next to the row of column C is C
Set in the management area of the column. The pointer ($ 000
In accordance with 3), an area for setting management data of the next data in column C ("e" in three rows) is secured, and management data in three rows of column C is set. The management data of the third column of the C column is composed of the previous pointer ($ 0002), the input data value, the row number, and the pointer of the input data of the next C column (in the example of FIG.
Since there is no data after the fourth row in the column, the next pointer is "Nu
11 ".

A case where data is further input from the state of FIG. 6 will be described with reference to FIG. FIG. 7 shows a case in which “KA” is input in column A, line 3 and “KI” is input in column B, line 2.

The management data creation means creates management data corresponding to the column or row for which data has been input. For example, when data "?" Is input to the third row of column A, the pointer "Null" of the second row of column A before the input of the management area of column A is set to ($ 000).
4), and management data (previous pointer ($ 0001), data part "?", Line number "3", next pointer "Null") in row A column 3 is set in the area ($ 0004). Further, since “き” is input in the second row of the column B, the pointer 6 of the management information of the column B in the column management table 66
6 ′ “Null” becomes a pointer “$ 0005” that designates the head area of the B column, a management area of the B column is secured in that area, and the management data of the B row and two rows (no previous pointer, data part “ , Line number 2, next pointer "Null")
Is set.

FIG. 8 shows a flow of displaying input data on the screen according to the present invention. The description will be made according to the numbers shown in the figure. S1 Array number = 0 (in FIGS. 6 and 7, column A of the column management table 66) is read.

S2, S3 It is determined whether or not the content of the column management table indicated by the array number is $ 0. EOD (En
If it is not d of Data), the process proceeds to S4. If it is EOD, the process ends.

S4, S5 It is determined whether or not the contents of the column management table indicated by the array number are Null. Null
If it is not 1, the process proceeds to S6. If Null, the process proceeds to S12.

S6 The pointer of the column management table indicated by the array number is set to pointer 1 (pointer 1 is a variable). S
7, S8 It is determined whether or not the pointer 1 is Null. If Null, the process proceeds to S12. If not Null, the process proceeds to S9.

S9 The data management table indicated by the pointer 1 is read. S10 The data of the data part of the data management table is displayed at the row position of the information part (table).

S11 The next pointer in the data management table is set as the pointer 1, and the processing after S7 is repeated. S
12 The array element number is incremented by 1 and the processing after S2 is repeated.

[0059]

According to the present invention, in a spreadsheet apparatus,
Only the effective data of the rows and columns of the table are managed, and the data management area (column management area) is not secured for the area where no data has been input, so that the data management area can be reduced. In particular, when there are many data non-input areas, the data management area can be significantly reduced. Therefore, not only is the storage area not occupied uselessly, but also the data processing speed is greatly improved.

[Brief description of the drawings]

FIG. 1 is a diagram showing a basic configuration of the present invention.

FIG. 2 is a diagram showing an embodiment of a configuration of a spreadsheet apparatus of the present invention.

FIG. 3 is a diagram showing an embodiment of the present invention.

FIG. 4 is a diagram showing an embodiment of the present invention.

FIG. 5 is a diagram showing a flow of management data creation processing of the present invention.

FIG. 6 is a diagram showing an embodiment of the data management method of the present invention.

FIG. 7 is a diagram showing an embodiment of the data management method of the present invention.

FIG. 8 is a diagram showing a flow of screen display of input data.

FIG. 9 is a diagram showing a data management method of a conventional spreadsheet device.

[Explanation of symbols]

 1: Input processing device 2: Data processing device 3: Input device 10: Table 11: Data input area 20: Column management table 21: Data management table 22: Management data creation means 25: Column management area of column A 25 ': A Column 1 row data 25 ": Column A, row 2 data 26: Column C column management area 26 ': Example C row 2 data

──────────────────────────────────────────────────続 き Continued on front page (58) Field surveyed (Int.Cl. ⁷ , DB name) G06F 19/00

Claims (3)

(57) [Claims] 1. A data input area (11) in a tabular form on a display device.
An input processing device (1) for displaying the data, and the data input area (11)
In a spreadsheet device (P) having a data processing device (2) for processing data input to the table, one of a table (10) displayed on the display device is arranged in one of a vertical direction and a horizontal direction, and the other in a column. When a row is set, the data processing device (2) includes a column management table (20) having column management information of the table (10) and column management areas (25), (26) for managing row data for each column. Data management table (2)
1), and the management data generating means (22) transmits column management information only for the column having data input based on the table (10) to the column management table (20). )
A table calculation device for creating the column management areas (25) and (26) of only a row having input data of a column having input data according to the column management information. 2. A tabular data input area on a display device.
In the data management method of the spreadsheet device (P) for displaying data and processing the data input to the data input area (11),
Assuming that one of the vertical and horizontal directions of the table (10) displayed on the display device is a column and the other is a row, the spreadsheet device (P) generates a column having column management information of the table (10). A management data creation means (2) for creating a management table (20) and a data management table (21) having column management areas (25) and (26) for managing row data for each column.
2), the column management information is set in the column management table (20) only for the column having the data input based on the table (10), and the row having the input data of the column having the input data is set in accordance with the column management information. A data management method for a spreadsheet device, wherein only the column management areas (25) and (26) are created. 3. The column management information according to claim 2, wherein the column management information has a pointer for designating a column management area, and column management areas (25) and (26) for the column are provided in an area designated by the pointer. A data management method for a spreadsheet apparatus, wherein management data of rows in a column management area have pointers for designating respective areas, and management data is set in an area specified by the pointer.