JPH02118771A - Data processor - Google Patents

Abstract

PURPOSE:To mask the squares being unnecessary at present from the display screen and to proceed the table calculation without providing a means to divide one table to plural areas by designating the squares unnecessary at the present step of the table calculation as the squares of the variable and masking it from the display screen. CONSTITUTION:The squares unnecessary at the present step of the table calculation out of the squares prepared as the component of a table is designated by a selecting means 111 as the squares of the variable which is not controlled by a matrix arrangement and controlled by a control means 117. A table calculating means 118 refers to the data in the squares of the variable and executes the table calculation of data in the squares of the matrix unit. The calculated result masks the data of the squares of the variable and simultaneously displays the squares of the matrix unit and only the data in it. Consequently, while the squares unnecessary at the present step of the table calculation is designated as the squares of the variable, the table calculation is successively executed, and thus, even when the table itself is not divided to plural areas, the unnecessary squares are not displayed and the table calculating work can be efficiently proceeded.

Description

[Detailed Description of the Invention] [Field of Industrial Application] The present invention relates to a data processing device that displays a plurality of squares on a display screen and performs spreadsheet calculations using data input in each square. It is.

[Conventional technology]

In recent years, interactive data processing devices have been widely used to perform various tasks in an interactive manner.2 These interactive data processing devices include a central processing unit that stores data and performs necessary processing, and a screen that displays processing results. A display device that displays information to notify the user, a keyboard and mouse (pointing device) that input data and instructions necessary for data processing,
It consists of a printing device that prints out the processing results and an external storage device that saves the data.When the necessary instructions are given using the keyboard or mouse, the response to the instructions is immediately reflected on the display screen, and the response By repeating the following instructions one after another, the user can obtain the desired processing result.

In such a data processing device, by displaying multiple squares in the row and column directions on the display screen and inputting data into each square, it is possible to perform spreadsheet calculations according to preset calculation formulas. Some have spreadsheet functions.

Figure 7 shows an example of a table used in spreadsheet processing, which consists of 20 squares 60 separated by row numbers "1" to "5" and column numbers "1" to "4". The table 61 is displayed on the screen of the display device, and the user is allowed to input data necessary for spreadsheet processing, such as characters and numerical values, into each square. That is, in the spreadsheet process for determining the sales amount as in the example shown in FIG. 7, 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, if 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.

In addition, the lower display screen of Table 61 includes a part that displays the number 62 of the square currently selected by the mouse, data 63 within the square currently selected, and the row and column directions of the square. A command input section 64 is provided for inputting commands for changing the width and attributes of the squares, commands for copying, moving, and deleting squares, and commands for changing data or calculation formulas within each square. It is configured so that necessary command selection and data input can be easily performed.

[Problem to be solved by the invention]

In the spreadsheet function mentioned above, all the data used in the spreadsheet must be stored in a box, and Table 61
The square 60 in the box is the place in the row direction and column direction! The data display area within each square is uniquely determined by the preset widths in the row and column directions. Therefore, it is necessary to allocate one square to data that is not particularly necessary for the user to use the table, such as the result of a certain calculation formula, and as a result, data that is not particularly necessary at the moment is also displayed. , the problem arises that it becomes difficult to see the epitome.

Therefore, measures are taken such as dividing one table into multiple areas and placing data that is not particularly necessary in current spreadsheet calculations out of sight. However, there is currently a problem in that if unnecessary data is placed away from the squares, the surface area of the metal face becomes large, which is inconvenient when referring to calculation formulas, etc.6 The present invention solves the problem of To provide a data processing device which is made to solve the problem and can hide unnecessary data from the display screen at the current stage of spreadsheet calculation without dividing one table into multiple areas. With the goal.

[Means to solve the problem]

The present invention provides a management means for managing arbitrarily designated squares among a plurality of squares as variable squares, and managing other squares as matrix unit squares; Referring to the selection means for selecting the square to be squared and the data input in the square of the variable, perform a table calculation of the data in the square of the matrix unit, and calculate the calculation result and the square of the matrix unit. and spreadsheet means for displaying only the data within on the display screen.

[Effect]

Among the squares created as constituent elements of the table, squares that are not required at the current stage of spreadsheet calculation are designated by the selection means as squares of variables that are not managed in matrix arrays, and are managed by the management means. The spreadsheet means performs a spreadsheet calculation of the data within the squares of the variables by referring to the data within the squares of the variables. Then, the calculation result hides the data of the variable squares, and only the matrix unit squares and the data therein are displayed at the same time.

Therefore, by sequentially performing spreadsheet calculations while specifying unnecessary cells as variable cells at the current stage of spreadsheet calculation, unnecessary cells will not be displayed without dividing the table into multiple areas. , you can proceed with spreadsheet work efficiently.

〔Example〕

FIG. 1 is a block diagram showing one embodiment of the present invention, which is composed of a central processing unit 10, a display device 11, a keyboard 12, and a mouse 13.
0 is composed of a control device 100 and a storage device 101.

The central processing unit 10 executes data processing such as spreadsheet processing according to commands input in an interactive manner, and controls data processing and display on the display device 11 as well as the keyboard 12 . A control device 100 is in charge of controlling data input from the mouse 13, and a storage device 101 stores data input during data processing or data resulting from processing.

The display device 11 displays tables and input data in spreadsheet processing and the like on its display screen.

The keyboard 12 is used to input data such as characters and formulas necessary for spreadsheet processing, and the mouse 13 is used to select commands necessary for spreadsheet processing and the like.

Figure 2 is a diagram showing the concept of processing processes such as generation, copying, and movement of squares during spreadsheet processing realized with the configuration shown in Figure 1. FIG. 4 is an explanatory diagram showing the relationship between and the square of the matrix unit. FIG. 4 is a diagram showing an example of a table when performing spreadsheet calculations with reference to the squares of variables. Fifth
6 and 6 are diagrams showing changes in the display contents on the display device screen in the process of FIG. 2.

Hereinafter, generation, management, etc. of squares used in spreadsheet processing will be explained with reference to FIGS. 2 to 6.

First, when you start the spreadsheet process, the following information appears at the bottom of the screen of the display device 11: 1. Create 1. Select 1. Edit, Copy, Move.

Erase and save commands will be displayed. Therefore, mouse 1
When the "generate" command is selected in step 3, a square of a predetermined size is generated by the generator 110 prepared in advance as a generation program in the control device 100. These squares are also displayed on the display device 1 through a management section 117 prepared as a square management program in the control device 100.
Transferred to 1. This causes the display screen to display the fifth
A square 40 as shown in Figure (b) is displayed. By first repeating this generation operation on a monthly basis, for example, a table 50 consisting of 5 rows and 4 columns of squares as shown in FIG. 4 is created. In this case, the identification number of each square is inputted from the keyboard 12 in order to distinguish each square. This is to be used for searching when referring to data within a square in spreadsheet processing.

This identification number is stored in the variable unit square management table 119 or the matrix unit square management table 12 of the management unit 117.
At 0, the position of each square and the data therein are grouped together and managed on a monthly basis. In addition, in FIGS. 5 and 6, the identification number is shown in the upper left corner of the square 40. Note that this identification number is for explanation purposes only and is not actually displayed.

Next, the number 40 is displayed as shown in Figure 5(b).
If the position is not the desired position, the "select" command is selected using the mouse 13. Then, the selection unit 115, which is prepared as a selection program in the control device 100, responds and instructs the user on the display screen to input the identification number that he or she wishes to select. If you enter the identification number of square 40 that does not move one position as character string data from the keyboard 12, square 40 will be selected and, for example, 0 will be displayed as bold square 40 as shown in Figure 5(c). Next, use the mouse 13 to select the "move" command. Then, the moving unit 115 in the control device 100 responds and instructs the user to input the destination position on the display screen. Therefore, when the destination position is input using the keyboard 12 or mouse 13, the square 40 whose position is to be changed on the display screen is shown in Fig. 5 (d).
) to the input destination position.

On the other hand, when inputting numerical data for performing spreadsheet calculations on the squares 40 shown in FIG. 5(c), the "edit" command is selected using the mouse 13. Then, the editing unit 112 in the control device 100 responds and instructs on the display screen to input data. Therefore, keyboard 12
For example, when numerical data "10" is inputted, this numerical data 10 is stored and displayed within the square 40 as shown in FIG. 5(e).

Next, if you want to copy the square 40 in FIG. Select by.

Then, the copying unit 114 in the control device 100 responds and instructs on the display screen to input the copying position. Therefore, when a copying position is input using the keyboard 12 or mouse 13, the square 40 is copied to the designated position and is displayed as a square 41 as shown in FIG. 5(f). At this time, the identification number "2" is set in the square 41, and the management section 117 is made to manage its position, range (size), and data using the identification number "2".

Next, in the display state of the squares as shown in FIG. 6(a), when the result of adding M "30" to the numerical value "10" in square 40 is stored in square 41, After selecting the square 41 with the mouse 13, the "edit" command is selected. Then, the ms unit 112 responds and instructs on the display screen to input numerical data or a calculation formula.

Therefore, input "(1)+30" as a calculation formula.Here, (1) represents the contents of square 40 of identification number "1". When the calculation formula is input, the spreadsheet processing unit 118 performs calculation according to the calculation formula and stores the result in the square 41. As a result, the number in square 41 is “10”.
" is updated to "40" as shown in FIG. 6(b).

Next, use the mouse 13 to select square 40 and move to the sixth square.
After setting the display state as shown in Figure (c), if you select the "m collection" command, the editing department 112 will respond.
Instruct on the display screen to input numerical data within 0. Therefore, when the data in square 40 is updated from "10" to "20" using the keyboard 12, the spreadsheet processing unit 118 automatically performs calculations using the above formula, and the data in square 41 is “50J (=20
+30) and the display state as shown in FIG.
After setting the display state as shown in Figure 6(e), click "Erase".
When the command is selected, the erasing unit 113 responds and erases the square 41. This causes the display screen to
The state shown in Figure (f) is reached.

In the above description, the horizontal lines 40 and 41 and the data therein are stored in the storage device 101, read out from the storage device 101 when various commands are selected, and read out from the storage device 101 again when the required processing is completed. It is stored within.

Next, the spreadsheet results shown in FIG. 6(f) are stored in an external storage device (
(not shown), select the "Save" command with the mouse 13. Then, the storage unit 116 responds and the spreadsheet results shown in FIG. 6<f) are stored in the external storage device.

Next, we will explain the case where spreadsheet processing is performed on the table 50 as shown in FIG.
If it is considered that square 51 is unnecessary at the current stage of data display or spreadsheet calculation, first designate square 51 as a variable square. This determination is made by selecting the "select" command with the mouse 13 and then inputting the identification number of square 51 to select the corresponding square 51, and inputting an identification number different from the matrix position. 0 For example, input the identification number "A". Then, the selected square 51 is stored in the management table 119 of the management unit 117 as a variable square.
and is displayed on the display device screen as shown by symbol 52 in the lower question of table 50 in FIG.

Next, in order to set data or calculation formula for square 51 of this variable, select the "edit" command with the mouse 13, set "10" as the data,
Set "Ml@1)+10" as the calculation formula. Here, (1@1) indicates the contents of square 51, and in the spreadsheet, "rlo±10" is referred to as a variable.

Further, the above calculation formula is displayed in the lower column of the table 50 in FIG. 4 as indicated by a symbol 53.

When the horizontal square 51 is set as a variable square, the relationship with other squares is set as shown in FIG. In other words, the variable square 51 is the matrix unit square 54 or 55.
It is treated as a subordinate to , and is referred to when performing spreadsheet calculations in matrix units. However, it is not displayed at all on the display device screen, only the squares of the matrix units are displayed.

Therefore, set calculation formula 'mA)X2+3J for square 54 of row number "1" and column number "2", and set calculation formula '(Al
/10J, the spreadsheet processing unit 118 refers to the content "20" in square 51 of the variable indicated by identification number A, obtains the calculation result '+20)X2+3=43J, and calculates square 54. Display it inside. Similarly r +20
)/=2'' is obtained and displayed in square 55.

Therefore, when performing complex spreadsheet calculations such as performing the next spreadsheet calculation based on one spreadsheet result, and then performing the next spreadsheet calculation based on that result, the calculation results obtained in the previous stage are used as variables. Once handled, the calculation results from the previous stage will not appear on the display screen and will be referenced only during spreadsheet calculations, making the table board extremely easy to read. Furthermore, since there is no need to arrange cells for data treated as variables in a separate area on the display screen, the display area of the table can be smaller, and spreadsheet calculations can be performed more efficiently.

〔Effect of the invention〕

As explained above, according to the present invention, squares that are not needed at the current stage of spreadsheet calculation are designated as variable squares and hidden from the display screen, so one table can be divided into multiple areas. Even if you do not take any measures, you can hide unnecessary squares from the display screen and proceed with the spreadsheet calculation. As a result, it becomes possible to efficiently perform spreadsheet calculations with a complex structure using a table with a simple structure.

[Brief explanation of the drawing]

Fig. 1 is a block diagram showing an embodiment of the present invention, Fig. 2 is an explanatory diagram showing the concept of processing processes such as generation, copying, and movement of squares, and Fig. 3 is a block diagram of variables and matrix units. Figure 4 is an explanatory diagram showing the relationship between the squares of variables, Figure 4 is a diagram showing an example of a table when performing spreadsheet calculations with reference to the squares of variables, Figures 5 and 6 are diagrams showing the relationship in the process of Figure 2. FIG. 7 is an explanatory diagram showing a general example of the display contents of the display screen when performing spreadsheet processing. 10...Central processing unit, 11...Display device, 12.
...Keyboard, 13...Mouse, 40.41.54
55.60...square, 51...variable square, 5
061...Table, 100...Control device, 101...
Storage device, 110... generation unit, 111... selection unit,
112...Editing department, 113...Erasing department, 114...
・Copying department, 115...Movement department, 116...Medical preservation department, 1
17... Management section, 118... Spreadsheet processing section. Figure 3 Figure 5 Figure 4

Claims (1)

[Claims] A data processing device that displays a plurality of squares and performs spreadsheet calculations using data input in each square, A management means that manages variables as squares and manages other squares as matrix unit squares, a selection means that selects and specifies the squares that should be the variable squares, and input within the variable squares. A data processing device comprising spreadsheet means for referring to the data stored in the matrix, performing a spreadsheet calculation of the data within the squares of the matrix unit, and displaying only the calculation results and the data within the squares of the matrix unit on a display device screen. .