JPH0454667A - Table calculating device - Google Patents

Abstract

PURPOSE:To facilitate the systematic processing by allocating plural tables to a display area which can display one table, managing systematically these tables, and designating one table in each table, based on the sequence by this management. CONSTITUTION:When a table name B of a table 112B is designated from in a menu of a table group 112 by operating a mouse, the table name B is informed to a table managing means 111 from a table designating means 114 and the means 111 selects the table 112B from the table group 112, and displays the table 112B on a screen through a display means 113. In this case, the table 112B is displayed on one window, and also, a state that a table 112C, 112D, and a table 112A are superposed successively on the lower side of the table 112B is displayed. That is, in one window, each table of the table group 112 is superposed and displayed, and on the uppermost side which a user can look at, the selected table 112B is displayed. In such a way, each table which is superposed can be turned over.

Description

[Detailed description of the invention]

[Industrial Application Field] The present invention relates to a spreadsheet device that displays a plurality of squares on a display screen and performs spreadsheet calculations based on data input into each square. [Background Art] In recent years, interactive data systems that perform various tasks in an interactive manner have been widely used. 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. The computer is equipped with a keyboard and mouse (pointing device W) for manually entering commands, a printing device for outputting a hard copy 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 the instruction is immediately reflected on the display screen.
By repeatedly issuing new instructions in response to this response, the processing result desired by the user can be obtained. By the way, this interactive data system is a spreadsheet system that displays multiple squares in rows and columns on the display screen, and when data is input into each square, a spreadsheet calculation is performed according to a preset calculation formula. Some have functions. Figure 9 shows an example of a table used for table = 1 arithmetic processing, with 20 squares 90 separated by row numbers "1" and "5" and column numbers "1" to "4". A table 91 consisting of the following is displayed on a display device drawing, and the user is allowed to enter data necessary for spreadsheet processing, such as characters and numerical values, into each box. That is, in the spreadsheet process for determining the sales amount as in the example shown in FIG. 9, the user is required to input the product name, its unit price, and the number of products. Then, the preset calculation formula (sales amount - unit price
The sales amount for each product name is automatically calculated based on the number of items) and displayed in the sales amount column. In this case, when the unit price or quantity of each product name is changed, the spreadsheet calculation is executed again using the latest data, so that the calculation results are always consistent with the data that is the basis of the spreadsheet calculation. The display screen at the bottom of Table 91 includes a part that displays the number 92 of the square currently selected by the mouse, data 93 for the mouth of the square currently selected, and the row and column directions of the square. A command input unit 94 is provided for inputting commands for changing the width or attributes, or commands for copying, moving, or deleting the squares, and commands for changing the data or calculation formula for each square. It is structured in such a way that you can easily select the necessary commands and data manually. If you want to manually enter the desired data into one square in the table, use the cursor movement keys on the keyboard or the mouse to specify the square to which you want to input the data, and then use the edit command. Desired data may be input by operating the keyboard. Additionally, in an interactive data system, multiple tables may be displayed on a display screen using multiple windows. That is, a plurality of windows can be distributed and arranged at arbitrary positions on the screen of the display device, and each table can be expanded and displayed on these windows. Therefore, the display format is such that one table is assigned to one window. [Problems to be Solved by the Invention] However, in conventional spreadsheet devices in interactive data systems, one table is assigned to each of a plurality of multi-windows scattered within the display screen. Not only does this tend to distract the user's perspective, but even though the six tables have interrelationships, these tables cannot be organized and displayed. For example, when simulating bank remittance transfers, a series of inputs must be made across multiple tables, and after making some entries in one table, inputs must be made in other tables in the next order. However, if the six tables were scattered at arbitrary positions, it would be a lot of processing! It was just going to be lIt. SUMMARY OF THE INVENTION Therefore, an object of the present invention is to provide a spreadsheet device with excellent interactivity that can collectively manage a plurality of tables and smoothly perform a series of processes on these tables. [Means for Solving the Problems] A spreadsheet device according to the present invention allocates a plurality of tables to a display area capable of displaying one table, and includes a management means for managing these tables in order, and a management means for managing these tables in order. a designation means for designating one of the tables based on the order by the means; a display means for displaying the table designated by the designation means; and an edit for editing the table displayed by the display means. a deleting means for deleting the table specified by the specifying means; and an inserting and adding means for inserting and adding a new table to each of the tables. [Operation] According to the present invention, a plurality of tables are managed in an orderly manner by the management means, so that six tables are managed based on this order.
A desired table can be specified from among the tables. The specified table is displayed and you can edit it. You can also delete the specified table from each of the above tables,
New tables can be inserted and added to each of the above tables. Therefore, it is possible to easily perform systematic processing on each of the tables. [Embodiments] Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings. FIG. 1 is a block diagram showing an interactive data system to which an embodiment of the spreadsheet device according to the present invention is applied.
3, of which the central processing unit fI
O is composed of a control device 100 and a storage device 101. The central processing bag
3, and the storage device 101 stores the data, processing result data, and the like. The display device 11 is used to display tables and input data for table calculation processing and the like on its display screen. The keyboard 12 is used to manually enter data such as characters and =1 formulas required for spreadsheet processing, and the mouse 13 is used to select commands necessary for spreadsheet processing and the like. Fig. 2 is a diagram showing the concept of various processes of the spreadsheet device realized with the configuration shown in Fig. 1, and Figs. 8 is a flowchart showing a series of processes such as selection, deletion, insertion, addition, etc. that are performed, and FIG. 8 is a diagram showing the display form of the display device screen in this embodiment. Now, a process for displaying a desired table on the full display device will be described according to the flowchart of FIG. First, when you start the spreadsheet device, the display screen appears! A group of commands (not shown) such as edit, table designation, button display, deletion, addition, and insertion are displayed at the bottom of the screen No. 11. Here, by operating the mouse 13, the cursor on the display screen is positioned at the position of the command for specifying the table, and when the click button attached to the mouse 13 is pressed, the command is selected. When this table-specified command is selected, the control device 100
The table management means 111 prepared in advance as a table management program is activated, and the table management means 111 reads data regarding the table group 112 stored in advance in the storage device 10, and displays the menu of this table group 112. The display means 113 is notified of the table names A to D of the six tables 112A to 112D belonging to the group. Display means 1
13 displays the menu of the table group 112 on the screen of the display device 11 (step 301 in FIG. 3). Here, by operating the mouse 13, table group 1
For example, if table name B of table 112B is specified from among the 12 menus, table name B of table 112B is specified by control device 100.
The table specifying means 114 in the table management means 111 is notified (step 302 in FIG. 3). In response, table management means 111 selects table 112B from table group 112 and displays table 112B on the screen of display device 11 through display means 113 (step 3o3 in FIG. 3). At this time, the screen of the display device fll has a display format as shown in FIG. As is clear, Table 1120 and Table 112D are below Table 112B.
, Table 112A are displayed in a sequentially overlapping manner. That is, the six tables of the table group 112 are displayed one on top of the other in one window, and the selected table 112B is displayed at the top that the user can see. In such a display form, the six stacked tables can be turned over by performing the process shown in the flowchart of FIG. First, when a button display command is selected by operating the mouse 13, the table management means 111 generates two display buttons and transfers these two display buttons to the display means 113. The display means 113 displays two display buttons on the screen of the display device 11 (step 401 in FIG. 4). One of these two display buttons C Display device 1
This is a next page display button for specifying the display of the second table from the top in the table group 112 displayed on the screen of table group 1, and the other is the button for displaying the next page.
This is a previous page display button for instructing display of the lowermost table in 12. Here, when the button for displaying the next page is designated by operating the mouse 13, the table specifying means 114 notifies the table managing means 111 of this fact, and the table managing means 111 changes the display to the table on the next page. (4th
Step 402 in the figure). Then, the table management means 111 identifies the table name C of the table corresponding to the next page from the currently displayed table 112B (step 403 in FIG. 4), selects the table 112C with this table name C, and 1120 as display means 11
3 on the screen of the display device 111 (step 404 in FIG. 4). As a result, table 1120 is displayed in one window instead of table 112B, and table 1120 is displayed in one window.
Table 112D, table 112A, and table 112B are sequentially stacked below 2C. Also, instead of displaying Table 112C on the next page, Table 112B
To display the table corresponding to the previous page, press mouse 13
When you specify the button for displaying the previous page by operating
The table specifying means 114 notifies the table managing means 111 of this fact, and the table managing means 111 determines whether to change the display to the table on the previous page (step 405 in FIG. 4). When this determination is made, the table management means 111 displays the currently displayed table 112B.
Step 40 in Fig. 4 to identify the table name A of the table corresponding to the previous page, that is, the lowest table of the six stacked tables.
6). Select table 112A with table name A, and select table 112A.
is displayed on the screen of the display device 11 through the display means 113 (step 404 in FIG. 4). Therefore, by selecting and instructing either the next page display button or the previous page display button, the display can be updated sequentially from the currently displayed table to the table directly below it (for example, Table 112A→112B→112C→
112D → 112A), and the display is updated sequentially from the currently displayed table to the lowest table of the six stacked tables (for example, table 112A → 112D → 11
2C→112B→112A). Next, a procedure for displaying a desired table by manually inputting macro commands without using the procedures in FIGS. 3 and 4 will be described according to the flowchart in FIG. 5. First, when a macro command for specifying a table to be displayed is inputted by operating the keyboard 12, the table management means 111 analyzes the macro command (step 5 in FIG. 5).
01), thereby identifying the table name of the specified table (step 5.2 in FIG. 5). Here, if the table name of the specified table is rBJ, the table management means 111 selects the table 112B with the table name B from the table group 112, and
12B is displayed on the screen of the display device 11 through the display means 113 (step 503' in FIG. 5). This results in
Table 112B will be displayed in the display format shown in FIG. Next, the process for deleting a desired table from the table group 112 will be described according to the flowchart of FIG. First, use the mouse 13 to select a desired table name from the menu of the table group 112 displayed on the screen of the display device 11, and thereby display the table to be deleted at the top of the six stacked tables. (Step 601 in Figure 6)
). Then, by operating the mouse 13, when a deletion command is selected from among the displayed commands a, table deletion means 115 prepared in advance as a deletion program in the control device 100 is activated (see FIG. 6). Step 602). When the table deletion means 115 is activated, it determines whether there is one table belonging to the table group 112 through the table management means 111 (step 603 in FIG. 6), and if there is one table, the table group 112 is deleted. Terminate processing without deleting tables to prevent them from disappearing. Further, if it is determined that a plurality of tables belong to the table group 112, the table deletion means 115 deletes the previously selected table (step 604 in FIG. 6). Here, if the deleted table is the last table, that is, table 112D of table group 112 (step 605 in FIG.
), the table corresponding to the page before the deleted table, that is, Table 11
20 is selected (step 606 in FIG. 6), this table 1120 is displayed, and the other six tables are superimposed below the line table. Furthermore, if the deleted table is not the last table (step 605 in Figure 6), the corresponding table is selected from the deleted tables on the next page (step 607 in Figure 6).
), this table is displayed and the other six tables are superimposed below the line table. Therefore, if you want to delete the desired table, select the line table and display

[7. If the number of tables belonging to the table group is not one, the line table will be deleted. If this table is the last table in the table group, the corresponding table is selected and displayed on the page before the line table. Furthermore, if the deleted table is not the last table in the table group, the corresponding table is selected and displayed on the next page from the line table. Next, the process for adding and inserting a new table to the table group 112 will be described according to the flowchart of FIG. First, use the mouse 13 to select a desired table name from the menu of the table group 112 displayed on the screen of the display device 11, and select the table corresponding to the page before the new table to be inserted. (Step 701 in FIG. 7). Then, by operating the mouse 13, the user selects an additional command from the displayed command group or selects an insert command. Here, when an additional command is selected, the table adding means 11 prepared in advance as an additional program in the control device]OO
6 is activated (step 702 in FIG. 7), and the table adding means 116 adds a new table to the table group 112 as the last table of the table group 112, that is, the next table after 112D (step 703 in FIG. 7). ). At this time, a new table is selected and the table group 112 is displayed with the line table at the top (step 704 in FIG. 7). On the other hand, when the insert command is selected from the displayed command group, the table inserting means 117 prepared in advance as an insert program in the control device 100 is activated (
In step 7o5 of FIG. 7, the table insertion means 117 inserts a new table as a corresponding table on the next page from the already displayed tables (step 706 of FIG. 7). After this, a new table is selected and the table group 112 is selected with the line table at the top.
is displayed (step 7.4 in FIG. 7). By the way, when an editing command is selected from the displayed command group by operating the mouse 13, the input editing means 118 in the control device 100 responds.
Instructions are given on the screen of the display device 11 to input data such as characters and numbers. At this time, by operating the keyboard 12, desired data can be entered in the squares of the selected and displayed table, and relational expressions between the squares can be set. In addition, when updating the value of a square that has already been entered in the displayed table, the square updating means 119 in the control device 100 is activated, and by operating the keyboard 12, the value of the square is first updated. Can be updated. Therefore, editing and updating can be performed in the same manner as before. In the above embodiment, each time a table is deleted, added, inserted, etc. to a table group, the data regarding the table group in the tenth storage device is updated. [Effects of the Invention] As explained above, according to the spreadsheet device according to the present invention,
Multiple tables are managed in an orderly manner, and the desired table can be specified from among the six tables based on this order, so the specified table can be displayed, edited, deleted, inserted, and added in a systematic manner. can be done. That is, a plurality of tables can be managed all at once, and a series of processes for these tables can be performed smoothly and with excellent interactivity.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing an interactive data system to which an embodiment of the spreadsheet device according to the present invention is applied; FIG. 2 is a block diagram showing the concept of various processes in the spreadsheet device of this embodiment; 4 and 5 are flowcharts showing the process for displaying a desired table in this embodiment, and FIG. 6 is a flowchart showing the process for deleting a desired table in this embodiment. Figure 7 is a flowchart showing the process for inserting and adding a new table in this embodiment, Figure 8 is a diagram illustrating the display form on the display screen in this embodiment, and Figure 9 is a general spreadsheet. FIG. 3 is a diagram showing an example of a table used in the device. 10...Central processing unit, 11...Display device, 12.
...keyboard, 13...mouse, 100...control device, 101...storage device, 111...input editing means, 112...table group, 113...display means,
114...Table designation means, 115...Table deletion means, 1
16... Table addition means, 117... Table insertion means, 11
8...Manual editing means, 9...Masukuchi value updating means. Figure 1 91 Table 90 Figure 9

Claims (1)

[Claims] In a spreadsheet device that displays a table consisting of a plurality of squares and performs spreadsheet calculations based on data input in each square, a display area that can display one table is claimed. management means for allocating a plurality of tables and managing these tables in order; designation means for designating one of the tables based on the order determined by the management means; a display means for displaying a table; an editing means for editing the table displayed by the display means; a deletion means for deleting the table specified by the specification means; and inserting and adding a new table to each of the tables. A spreadsheet device comprising: an insertion/adding means for inserting and adding information.