JPH04222053A - Table calculater device - Google Patents

Abstract

PURPOSE:To systematically execute table calculation from a master table to a slave table or from the slave table to the master table by managing plural tables by specific hierarchical structure. CONSTITUTION:A hierarchical management means sets up a pointer A pointing out the 1st table 21 to be the master table as the management data of the 2nd table 22 to be the slave table. In addition, the hierarchical management means allocates a pointer B pointing out the slave table 22 to one measure of the master table 21. Thereby the master table 21 can be accessed based upon the pointer A to be the management data of the slave table 22. On the other hand, the slave table 22 can be accessed based upon the pointer B to be the data allocated to one measure of the master table 21. Thereby the slave table belongs to the master table 21 and data can be edited while mutually relating the data of respective measures of the master tables 21 to the data of respective measures of the slave table 22.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a spreadsheet device that displays a table having a plurality of squares and performs spreadsheet calculations based on data input to each square of the table.

0002

2. Description of the Related Art In recent years, interactive data systems have been widely used to perform various tasks in an interactive manner. This interactive data system is configured using personal computers, workstations, etc., and includes a central processing unit that stores data and performs necessary processing, a display device that displays processing results on a display screen, and a display device that displays data necessary for data processing. It is equipped with a keyboard and mouse (pointing input device) for inputting information and commands, a printing device for outputting hard copies of data as needed, an external storage device for storing data, etc. In such an interactive data system, when a necessary instruction is given using the keyboard or mouse, the response to this instruction is immediately reflected on the display screen, and new instructions are repeatedly issued in response to this response. As a result, the processing result that the user is looking for can be obtained.

By the way, this interactive data system displays a plurality of squares in rows and columns on the display screen, and when data is input into each square, a spreadsheet is calculated according to preset calculation rules. There are some that have a spreadsheet function that allows you to do this.

FIG. 6 shows an example of a table used for spreadsheet processing, with row numbers "1" to "5" and column numbers "1" to "5".
Table 6 consisting of 20 squares 60 separated by "4"
1 is displayed on the screen of the display device, and the user is prompted to input data necessary for spreadsheet processing, such as characters and numbers, into each square. That is, in the spreadsheet process for determining the sales amount as in the example shown in FIG. 6, the user is required to input the product name, its unit price, and the number of products. Then, the sales amount for each product name is automatically calculated according to a preset calculation rule (sales amount = unit price x number of items) and displayed in the sales amount column.

[0005] In this case, when the unit price or quantity of each product name is changed, the spreadsheet is re-executed using the latest data, so that the data on which the spreadsheet is based and the calculation results always match.

Furthermore, on the display screen below the table 61, the position 62 of the square currently selected by the mouse, the data 63 of the currently selected square, and the calculation rule for the currently selected square are displayed. 64, commands for changing the row and column widths and attributes of the squares, commands for copying, moving, and deleting the squares, and data or calculations within each square. A command input section 65 for inputting commands for changing rules is provided, and it is possible to select necessary commands and input data and calculation rules. Here, for example, 4 columns 2
Assuming that a square in a row is selected, square position 6
"4@2" indicating 4 columns and 2 rows is displayed as 2, and "6,200,000" is displayed as data 63 of the square.
is displayed. Also, if you select and execute the "Rule" command at this time, the calculation rule 64 (2 columns 2
Data for the square in the row) × (data for the square in the 3rd column and 2nd row)
The calculation formula "2@2*3@2" is displayed.

[0007]

[Problem to be Solved by the Invention] However, in conventional spreadsheet devices, when using multiple tables in a mutual relationship, these tables are managed as being at the same level, and the upper table and lower table are Because the vertical management structure such as tables was not clearly defined, it was difficult to edit related tables while being aware of the vertical management structure.

SUMMARY OF THE INVENTION Accordingly, an object of the present invention is to provide a spreadsheet device in which a plurality of tables have mutual relationships based on a hierarchical structure.

[0009]

[Means for Solving the Problems] In the present invention, in order to have a plurality of tables have mutual relationships based on a predetermined hierarchical structure, the predetermined hierarchical structure is such that a child table belongs to a square of a parent table. It is formed by

0010

[Operation] According to the present invention, a child table can be assigned to a square of a parent table, and furthermore, when a child table is regarded as a parent, another child table can be assigned to a square of the parent table. Since it is possible to allocate tables, it is possible to manage multiple tables in a hierarchical structure.

[0011]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings.

FIG. 1 is a functional block diagram showing an embodiment of a spreadsheet device according to the present invention. In the figure, selection means 1 is for selecting and specifying tables, squares, etc. of tables.

The generating means 2 is for generating a table, and the number of columns and rows of the table are specified here.

The editing means 3 is for allocating data to the squares of the table, and here characters, numerical values, calculation rules, etc. as data are specified.

The copying means 4 is for copying data assigned to a square in a table to another square, and here both the source and destination squares are designated. As a result, the same data is assigned to both the copy source and copy destination squares.

The moving means 5 is for moving the data assigned to a square in the table to another square, and both the source and destination squares are designated here. As a result, the data in the source square is erased and the data is assigned to the destination square.

The area changing means 6 is for changing the column width and row width of the table, and the column width and row width are specified here. This changes the size of the squares in the table.

The erasing means 7 is for erasing the table and erasing and initializing the data assigned to the squares of the table. A square is specified.

The respective contents specified by these selection means 1, generation means 2, editing means 3, copying means 4, moving means 5, area changing means 6 and erasing means 7 are reflected in the management means 8, and are In response, the management means 8 creates or erases a table on the display screen of the display means 9, or stores the table in the storage means 10.

Further, in this embodiment, a child table belonging to a square of a table can be set, and in this case, the table having the corresponding square becomes a parent table for the child table. The management means 8 is provided with a hierarchy management means 8-1, and this hierarchy management means 8-
1 maintains the relationship between the parent table and the child table.

Here, as shown in FIG. 2, the first table 21
and second table 22 are set, and first table 2
1 is the parent table and the second table 22 is the child table.
The hierarchy management means 8-1 sets a pointer A pointing to the first table 21, which is the parent table, as management data for the second table 22. In addition, the hierarchy management means 8-1 is a child table, which is a second table 2.
A pointer B pointing to 2 is assigned to one square of the first table 21 as data.

Therefore, the first table 21, that is, the parent table, can be accessed based on pointer A, which is the management data of the second table 22, and the pointer A that is assigned to one square of the first table 21 can be accessed. The second table, that is, the child table, can be accessed based on pointer B as the data.

FIG. 3 shows the hardware configuration of the spreadsheet device of the embodiment shown in FIG. 1, which includes a central processing unit 31, a keyboard 32, a mouse 33, and a display device 34. Here, the control unit 3 in the central processing unit 31
1-1, the keyboard 32 and the mouse 33 are the selection means 1, the generation means 2, the editing means 3, and the copying means 4 shown in FIG.
, the moving means 5, the area changing means 6, and the erasing means 7. Further, the control section 31-1 in the central processing unit 31 realizes the functions of the management means 8 shown in FIG. Furthermore, the storage unit 3 in the central processing unit 31
2-2 realizes the function of the storage means 10 shown in FIG. Further, the control section 31-1 and the display device 34 in the central processing unit 31 realize the function of the display means 9 shown in FIG.

Now, the operation of the spreadsheet device having such a configuration will be described in more detail with reference to FIGS. 4 and 5.

First, on the display screen of the display means 9, the screen shown in FIG.
Assume that a table 41 as shown in a) is displayed. In this table 41, the square in column 1, row 1 has the value 10, the square in column 2, row 1 has the value 30, and the square in column 1, row 2 has the value 2.
0 is assigned as data, and no data is assigned to the squares in the second column and second row.

Here, by operating the mouse 33, the cursor (not shown) on the display screen is moved to 2 in Table 41.
When the user moves to the square in column 2, row 2 and further presses a button (not shown) attached to the mouse 33 to specify the square in column 2, row 2, selection means 1 Figure 4(b) shows the squares in the second column and second row of Table 41.
Displayed in a thick frame as shown in .

[0027] Thereafter, by operating the mouse 33, the cursor is moved on the display screen, and "create n" is selected from the command menu (not shown) displayed in advance.
When a command called "ew table" is specified, the selection means 1 notifies the management means 8 of the command, and the hierarchy management means 8-1 in the management means 8 selects the child table from the square in the second column and second row of table 41. It is set as the square to be allocated, and table 41 is set as the parent table for the child table.

[0028] When the square in the second row and second row of the parent table 41 is set as the square to which the child table is allocated, the child table can be created in the corresponding square by subsequent operations. This child table is created using the same procedure as for a normal table. That is, when the generation means 2 is activated by operating the keyboard 32 and the mouse 33 and the number of columns and rows of the child table is specified, the generation means 2 generates the second part of the parent table 41 as shown in FIG. 4(c). The child table 42 is displayed in a square in column 2 and row 2. Here, the child table 42 is formed as a table with two columns and two rows.

The child table 42 created in this way can be edited using the same procedure as for a normal table. for example,
When the mouse 33 is operated to move the cursor on the display screen to specify a square in the first column and first row in the child table 42, the selection means 1 selects the corresponding square as shown in FIG. 4(d). Display with a thick frame. Thereafter, when the cursor is moved on the display screen by operating the mouse 33 and a command indicating editing is specified from the command menu displayed in advance, the editing means 3 is activated, and then the keyboard 32
When the value "3" is input by operating , the editing means 3 assigns the value "3" to the square of the first column and the first row of the child table 42 as shown in FIG. 5(a).

Subsequently, by operating the mouse 33, the square of the second column and first row in the child table 42 is designated, and by further operating the keyboard 32, the calculation rule "{1@
1}+5", the editing means 3 inputs the corresponding calculation rule "
{1@1}+5'' is assigned to the square of the second column and first row of the child table 42.

[0031] This calculation rule "{1@1}+5" indicates that the value "5" is added to the data in the square of the first column and the first row in the child table 42, and here the value "5" is added to the data in the square of the first column and the first row. Since the eye data has the value “3”, according to the calculation rule, it is 3+
The solution 5=8 is obtained, and the value “8” of this solution is shown in Figure 5 (
As shown in b), it is displayed in a square of two columns and one row.

Similarly, specify the square of the 2nd column and 2nd row in the child table 42, and use the calculation rule "{../1@1}+{2@1
}”, this calculation rule “{. ．． /1@1}
+{2@1}” is assigned to the corresponding square. This calculation rule indicates that the data in column 1 and row 1 in the parent table 41 and the data in column 2 and row 1 in the child table 42 are to be added. Here, the data in column 1 and row 1 in the parent table 41 has the value "10".
” and the data in column 2 and row 1 in the child table 42 has the calculation rule “{1@1}+5”, so the calculation rule in the square in column 2 and row 2 in the child table 42 is “{. ．． /1@1}
+{2@1}”, the solution 10+{3+5}=18 is obtained, and the value “18” of this solution is the square in the second column and second row of the child table 42, as shown in Figure 5(c). will be displayed.

Next, in the state shown in FIG. 5(c), specify the square in the 1st column and 1st row of the parent table 41, and set the value "5".
”, the data in the corresponding cell is changed from the value “10” to the value “5”. At this time, the calculation rule for the cell in the second column and second row in the child table 42 is “{. ．． /1@1}+{2@
1}" relates to the data in the first column and first row of the parent table 41, so the calculation rule is re-performed and a new solution of 5+{3+5}=13 is obtained. This new solution The value "13" is displayed in the square of the second column and second row of the child table 42 in place of the original value "18" as shown in FIG. 5(d). Also, as shown in FIG. 5(c) In the state shown in , if you specify a square in the first column and first row of the child table 42 and enter the value "0", the data in the corresponding square will be set to the value "3".
" is changed to the value "0". At this time, the calculation rule for the second column, first row, square in the child table 42 is "{1@1}+5".
is involved in the square of the first column and the first row in the child table 42, so
A new solution of 0+5=5 is found according to the calculation rule. This new solution value "5" is displayed in the square of the second column and first row of the child table 42, as shown in FIG. 5(e), instead of the original value "8". Furthermore, the calculation rule for the square of the second column and second row in the child table 42 is “{../1@1}+{2@
1}” is related to the data in the second column, first row, square in the child table 42, the calculation rule is executed again, and a new solution of 10+{0+5}=15 is obtained.This new solution The value "15" is displayed in the square of the second column and second row of the child table 42, as shown in FIG. 5(e), instead of the original value "18".

In this way, if the child table 42 is assigned as the data in each square of the parent table 41, the child table 42 will belong to the parent table 41, and the data in each square in the parent table 41 and each data in the child table 42 will be assigned. It is possible to edit the data of the squares while relating them to each other.

Then, the hierarchy management means 8-1 in the management means 8 allocates the pointer pointing to the child table 42 to the square of the second column and second row of the parent table 41, and also points the parent table 41. This pointer is set as the management data of the child table 42. In addition, the hierarchy management means 8-1 is the parent table 4
1 and the child table 42 in the storage means 10, the pointer to the child table 42 is stored as the data in the second column, second row, square in the parent table 41, and the pointer to the parent table 41 is stored in the child table 42. Store as management data. Therefore, when reading the parent table 41 and the child table 42 from the storage means 10, the mutual relationship between the parent table 41 and the child table 42 can be reproduced.

Next, when deleting the child table 42, move the cursor on the display screen by operating the mouse 33 and specify the square in the second column and second row in the parent table 41. is displayed in a thick frame as shown in FIG. 4(c). Thereafter, when the cursor is moved on the display screen by operating the mouse 33 and a command indicating erasing is specified from the command menu displayed in advance, the erasing means 7 is activated, and the erasing means 7 is activated as shown in FIG. Delete the child table 42 as shown in e). At this time, the hierarchical management means 8-1 in the management means 8 erases the pointer A to the parent table 41 that has been set as the management data of the child table 42, and also points the pointer A to the second column and second row of the parent table 41 to The pointer B to the child table 42 allocated as data is deleted.

Therefore, child tables assigned to squares of the parent table 41 can be freely created and deleted.

In the above embodiment, the child table is displayed within the square of the parent table, but it is also possible to display the parent table and the child table in completely different spaces on the display screen or in two windows. You can also do this. In this way, the space for displaying the child table is not limited and it becomes easier to see.

[0039] Furthermore, each child table may be assigned to each square of the parent table. In this case, a pointer to each child table is assigned to each square of the parent table, and a pointer to the parent table is also assigned to each square of the parent table. This is set as management data for each child table, thereby maintaining the mutual relationship between the parent table and each child table.

Furthermore, a child table may be regarded as a parent and a child table may be created for this table. In this case, a multilayered hierarchical structure such as a parent table, child table, and grandchild table can be constructed. Therefore, it is possible to perform spreadsheet calculations in a step-by-step manner, such as from a higher-level table to a lower-level table, or from a lower-level table to a higher-level table, while recognizing the hierarchical structure.

[0041]

[Effects of the Invention] As explained above, according to the present invention, a hierarchical structure is formed in which a child table belongs to a square of a parent table. Spreadsheet calculations can be performed systematically from a table to a lower-level table, or from a lower-level table to a higher-level table.

[Brief explanation of the drawing]

FIG. 1 is a functional block diagram showing an embodiment of a spreadsheet device according to the present invention.

FIG. 2 is a diagram showing the mutual relationship between a parent table and a child table in the embodiment shown in FIG. 1;

FIG. 3 is a block diagram schematically showing the hardware configuration of the embodiment shown in FIG. 1;

FIG. 4 is a diagram illustrating a display mode of a parent table and a child table.

FIG. 5 is a diagram illustrating a display mode of a parent table and a child table.

FIG. 6 is a diagram illustrating a conventional spreadsheet.

[Explanation of symbols]

1...Selection means 2... Generation means 3...Editing means 4... Copying means 5...Means of transportation 6... Area changing means 7... Erasing means 8...Management means 8-1...Hierarchy management means 9...Display means 10...Storage means 21...First table 22...Second table 31...Central processing unit 32...Keyboard 33...Mouse 34...Display device 41...Parent table 42…Child table

Claims (1)

[Claims] [Claim 1] A spreadsheet device that displays a table having a plurality of squares and performs spreadsheet calculations based on data entered in each square of the table, which mutually have a relationship based on a predetermined hierarchical structure. A spreadsheet device comprising a plurality of tables, wherein the predetermined hierarchical structure is formed by child tables belonging to cells of a parent table.