JPH07192061A - Spreadsheet device and data management method of spreadsheet device - Google Patents

Abstract

(57) [Summary] [Purpose] The purpose is to reduce the data management size of a spreadsheet device and its data management method. [Structure] A data processing device in which 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.
(2) is a column management table (20) with the column management information of table (10)
And column management areas (25) and (26) that manage row data for each column
And a management data creation means (22) for creating a data management table (21) having
Column management information is set in the column management table (20) only for columns with data input based on (0), and a column management area (25) for only rows with input data of columns with input data according to the column management information, (26) is created.

Description

Detailed Description of the Invention

[0001]

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

2. Description of the Related Art A spreadsheet device for interactively inputting data into a table displayed on a screen of a display device and performing a calculation process is widely used. Such a spreadsheet device needs to efficiently manage the input data in order to shorten the response time and effectively use the data storage area.

[0003]

2. Description of the Related Art Conventionally, in the management of input data of a spreadsheet device, a table is divided into blocks, and the entire data input area (data input area of the table) inside the block is also included in the area without data input. Data was managed in block units.

FIG. 9 shows a data management method of a conventional spreadsheet apparatus. FIG. 9 shows columns A 1 row, 2 rows, 3 rows and B column 1 rows, 2
Row, 3 rows are the block unit for data management, and C column 1
The case where the rows, 2 rows, and 3 rows and the 1st row, 2nd row, and 3rd row of the D column are set in block units for data management is shown.

In FIG. 9, P is a spreadsheet device. 1
An input processing device 00 displays a table of the spreadsheet device on the display screen, determines the position of the input data in the table, and sets it as the input data. The figure shows the case of having a data input area of 3 rows and 4 columns.

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

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

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

Reference numeral 120 is management data for column A and row 1.
It is composed of data values of input data, attributes (color, character type, etc.). Reference numeral 121 is management data for column B and row 1 (not input).

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

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

[0012]

As described above, since the conventional spreadsheet apparatus secures the management area for data management even in the data input area where there is no data input,
Not only was the data management size enormous, the storage area wasted unnecessarily, but the operation response was also poor.

It is an object of the present invention to provide a spreadsheet device and a data management method for the spreadsheet device that can reduce the data management size.

[0014]

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

Reference numeral 1 denotes an input processing device which displays a data input area in a table format on a display device and judges the position of the input data in the table to be input data.
A data processor 2 processes and manages the data input by the input processor 1.

Reference numeral 3 is an input device. In the input processing device 1, 11 is 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 the data value is input. In the figure, blanks represent areas in which no data has been entered, and the figure shows a state in which data is entered in rows 1 and 2 of column A and 2 rows of column C.

In the data processing device 2, 15 is a data management device for managing input data.
A column management table 20 manages the input data of the columns by the column management information.

Reference numeral 21 is a data management table, which is composed of column management areas (25) and (26) for managing input data of rows for each column. Reference numeral 22 is a management data creating means for creating a column management table 20, setting column management information in a column having data input, and based on the column management information, column management areas (25), (25) of the data management table 21. 26). The column management information includes a pointer for designating the position of the column management area for managing the input data of the column.

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

Reference numeral 25 "is data in column A and two rows. Reference numeral 26 is 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 'is data in column C and row 2.

[0022]

In the basic configuration of FIG. 1, the input processing device 1 determines the position of the data input area 11 of the input data. The management data creating means 22 creates the column management table 20. Then, column management information is set in the column management table 20 only for columns having 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 the column management areas (25) and (26) for setting the management data of the row of the corresponding column according to the column management information of the column management table 20,
Create management data and set it in the column management areas (25) and (26). For example, in the case of the A column, the management data (input data value, line number, attribute, etc.) of the 1st and 2nd rows of the A column are created and set in the column management area (25) of the A column. At this time, the management data of the 1st row of the A column has the information (pointer, etc.) for designating the position of the management data of the 2nd row of the A column, thereby designating the data area of the 2nd row of the A column. In addition, the management data in the two rows of column A is A
A pointer indicating an area of the management data of one row of a column is provided so that the mutual positions can be recognized.
Then, the column management areas (25) and (26) are reserved only for a row having data. When a row with data input is added, the pointer of the area for setting the management data of the row added to the management data of the other row in the same column is set, and the pointer is added to the area specified by the pointer. Row management data is set.

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

[0025]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 2 shows an embodiment of the configuration of the spreadsheet apparatus of the present invention. In FIG. 2, P is a spreadsheet device.

A spreadsheet program 31 is composed of an input processing program 35 and a data processing program 36. The input processing program 35 is a display 54
Has a function such as displaying a tabular data input area,
The data processing program 36 has a function of 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 is constituted by a data processing program 36, a CPU 50, and a storage device 51.

Reference numeral 35 is 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 is a management data creating 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.

A display 54 displays a table of a spreadsheet program. An input device 55 is a keyboard, a mouse, or the like. A disk device 56 stores created data, inputs data, holds application programs and the like.

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

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

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

Reference numeral 66 is a column management table. FIG. 4 is a diagram showing an embodiment of the present invention, showing a state in which data is entered in a table. 32 is an input processing device.

Reference numeral 33 is a data processing device. In the input processing device 32, reference numeral 60 is a table in which A column has 1 row, “A”, B column has 1 row, “I”, A column has 2 rows, “U”, B column has 2 rows, “E”, and E column. The state in which "ka" is input in the third row and "ki" in the fourth row of the E column is shown.

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

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

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

Reference numeral 76 is a detailed portion. Reference numeral 77 is a data section. 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 of column A
1, the management data of the A column is created by "1" indicating that it is the 1st row of the A column and the data value "A", and by "2" indicating that it is the 2nd column of the A column 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 management data is created with the data value "i", "2" indicating that it is column B and two rows, and the data value "e". Similarly, in the management area 73 of the E column, the management data is “3” indicating that it is the third row of the E column and the data value “ka”, and “4” indicating that it is the fourth row of the E column and the data value “ki”. Is created. Then, the management data in the data input area 61 having no input data is not created.

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

Data is input to the S2 input processing device 32. The S3 input processing device 32 determines the position of the data input area 61 having the input data. For example, when the data is input to the B column and 1 row, it is determined that the data has been input to the B column and 1 row.

The S4 management data creating means sets the column management information in the B column of the column management table 66 and secures the B column management area (72). S5 Created B column data area (B column management area 7
Store the line number, data value, etc. 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 is an input processing device.

In the input processing device 32, a reference numeral 60 is a table in which A column has 1 row, "A", A column has 2 rows, "I", C column has 2 rows, "U", and C column has 2 rows. "Indicates that data is being input.

Reference numeral 61 is 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, 66 is a column management table. Reference numeral 66 'is column management information, which has a pointer for designating the position of the column management area of the data management table 67.

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

The management data creating means (see the management data creating means 22 in FIG. 1) uses the column management table 66 for the column having the data input in the table 60 to manage the column management information (pointer 66 'for designating the position of the column management area, It is configured by the data width, etc.). If there is no data input to the column, column management information will not be created. Then, the column management area is created in the area designated by the pointer 66 'of the column management information in the column management table 66, and the row number of the column and the data value are secured.

According to the example of FIG. 6, the column management table 66,
A method of creating data of the data management table 67 will be described. When the management data creating means determines that there is data in the A column, it sets a pointer (# 0000) for designating the A column management area (area for confirming the head data of the A row). A management area for setting the head data of the A column is secured at the position indicated by the pointer (# 0000), and the management data of the head data of the A column (1 row "A") is set. The management data has an input data value “A” in the data part, a line number “1” in the details part, attributes (color, character type, etc.), and the area of the next management data in column A (“i” in two lines). Pointer to specify (# 00
01). Furthermore, the pointer (# 0
(001) in the area designated by column A, two rows of management data (column A, one row of management data, the previous pointer (# 0
000), data value, line number, etc.) are set. In the example shown in the figure, since the data in the third and subsequent rows of column A does not exist, the next pointer is Null.

Since there is no input data in the B column, the pointer of the management information in the B column of the column management table 66 is Null. Since there is input data in the column C, the pointer (# 0002) designating the management area of the column C is set in the column management information of the column C of the column management table 66. The pointer (# 0
002), the management area of the C column is secured, and the pointer (# 0003) for designating the positions of the input data at the beginning of the C column (“u” in the second row) and the management data next to the row at the C column is C.
Set in the management area of the column. The pointer (# 000
According to 3), the area for setting the management data of the next data of column C (“E” of three rows) is secured, and the management data of three rows of column C is set. The management data of column C, 3 rows 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 the figure, C
Since there is no data in the 4th and subsequent rows of the column, the next pointer is
ll ”.

The case where data is further input from the state of FIG. 6 will be described with reference to FIG. FIG. 7 shows a case where “ka” is input in the third row of column A and “ki” is input in the second row of column B.

The management data creating means creates management data corresponding to the columns and rows to which data has been input. For example, when the data “ka” is input to the third row of the A column, the pointer “Null” of the second row of the A column before the input of the management area of the A column becomes (# 000
4), and the management data (previous pointer (# 0001), data section "ka", row number "3", next pointer "Null") of column A, 3 rows is set in the area (# 0004). Further, since “ki” is entered in the second row of the B column, the pointer 6 of the management information of the B column of the column management table 66
6 '"Null" becomes a pointer "# 0005" for designating the first area of the B column, the management area of the B column is secured in that area, and the management data of 2 rows of the B column (no previous pointer, data section , Line number 2, next pointer "Null")
Is set.

FIG. 8 shows the flow of screen display of input data according to the present invention. Description will be given according to the numbers shown. S1 The array element number = 0 (in the case of FIGS. 6 and 7, the 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 element number ≠ 0. EOD (En
If not 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 element number is Null. Nul
If not l, proceed to S6. If it is Null, the process proceeds to S12.

S6 The pointer of the column management table indicated by the array element 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 it is 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 section of the data management table is displayed at the row position of the information section (table).

S11 The next pointer of 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 device,
Only the valid data of rows and columns of the table is managed, and the data management area (column management area) is not secured for the area where no data is entered, so the data management area can be reduced. In particular, when there are many areas where no data has been entered, the data management area can be greatly reduced. Therefore, the storage area is not wastefully occupied, and the data processing speed is significantly improved.

[Brief description of drawings]

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

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

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

FIG. 4 is a diagram showing an example 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 a data management method of the present invention.

FIG. 7 is a diagram showing an embodiment of a 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 apparatus.

[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 creating means 25: Column management area of column A 25 ': A Column 1 row data 25 ": Column A 2 row data 26: Column C column management area 26 ': C Example 2 row data

Claims (3)

[Claims] 1. A data input area in tabular form on a display device (11)
Input processing device (1) for displaying and the data input area (11)
In a spreadsheet device (P) provided with a data processing device (2) for processing the data input to the table, one of the vertical and horizontal directions of the table (10) displayed on the display device is arranged in columns and the other is When the data processing device (2) has a row, the data processing device (2) has 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 management data creating means (22) for creating the column management table (20) for the column management information only for the columns having data input based on the table (10). )
And a column management area (25), (26) of only a row with input data of a column with input data is created according to the column management information. 2. A data input area in tabular form on a display device (11)
In the data management method of the spreadsheet device (P) for displaying data and processing the data input to the data input area (11),
When one of the vertical direction and the horizontal direction of the table (10) displayed on the display device is a column and the other is a row, the spreadsheet device (P) is a column having column management information of the table (10). Management data creating 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), column management information is set in the column management table (20) only for columns with data input based on the table (10), and rows with input data in columns with input data are set according to the column management information. A data management method for a spreadsheet device, characterized in that 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 the column management area (25), (26) for the column is provided in the area designated by the pointer. A data management method for a spreadsheet device, wherein in the column management area, row management data have pointers for designating respective areas, and the management data are set in the areas designated by the pointers.