JPH0642245B2 - Spreadsheet - Google Patents

Description

The present invention relates to a spreadsheet device in an interactive data processing system.

[Conventional technology]

Conventionally, in this type of spreadsheet device, a fifth screen is displayed on a display screen such as a display based on the stored table display data.
A table 10 of vertical and horizontal two-dimensional matrices as shown in the figure is displayed. When the user inputs a desired character, numerical value, or the like to each cell 11 of the above table with an input means such as a keyboard, the above input is made. The stored value can be stored and the above value can be displayed with the specified attribute. You can also enter an expression that indirectly determines the value by referring to another cell, and if such an expression is set, the value of the cell to which the expression refers Is changed, a processing device such as a CPU executes table calculation according to the above formula, displays the calculation result value of the formula, changes the data relation of the above table, and stores it in the main storage unit. Had a dialogue with the system. In addition, the above table usually has a command input section 12 for the user to give instructions to the table, select the squares to be instructed, change the input value / expression and attributes, copy the squares. -It is possible to perform operations such as moving, deleting, and changing the width of the queue. In other words, the selection of the squares in the table is basically performed by deciding the desired eye with the cursor movement key or the mouse and inputting the value with the keyboard using the edit command or the like.

[Problems to be Solved by the Invention]

However, in the above-described spreadsheet device, since the input operation and the value to be input are not explicit, when the user who is unfamiliar with the operation uses, the operation is not performed smoothly, it takes time to create the table, and the process is There was a problem of stagnation.

The present invention has been made in view of the above problems, and by providing a visual input method using a specific symbol, enables even an unfamiliar user to create a table explicitly and easily, and provides a better interactivity. An object is to provide a spreadsheet device having the same.

[Means for Solving the Problems]

In the present invention, display data of a table is stored, a predetermined table based on the display data is displayed according to a request, and a desired value is input to each square in the table with a keyboard or the like, and the input is performed. In a spreadsheet device that displays according to the value, storage means such as a memory for storing the data of the specific symbol showing the value corresponding to the square value, and a display etc. for displaying the stored data of the specific symbol Display means, change instruction means such as a mouse for instructing to change the data of the specific symbol displayed on the display, and data of the specific symbol and the data of the specific symbol displayed in response to the change instruction It is provided with a change control means such as a CPU for changing and controlling the cell value.

[Action]

By changing the data of the specific symbol corresponding to the value of the primary cell, the value of the primary cell is determined, and the data of the specific symbol and the data of the specific symbol displayed according to the value of the secondary cell determined above are determined. The value of the corresponding square is changed and redisplayed.

Therefore, any person can create an explicit and simple table, and the table can be created quickly.

〔Example〕

An embodiment of the present invention will be described in detail with reference to the drawings of FIGS.

FIG. 1 is a block diagram showing a schematic configuration of the present invention.
In the figure, the main storage unit 20 stores the display data of the table, the data of the specific symbol, and the square value corresponding to the data of the specific symbol.

The display control unit 21 causes the display unit 22 to display the display data of the table stored in the main storage unit 20, the data of the specific symbol, and the square value corresponding to the data of the specific symbol, by the control of the CPU described later. It is controlled accordingly.

The display unit 22 is composed of a display such as a CRT, and displays each data in the above table under the display control of the display control unit 21.

The keyboard 23 is used to input the square value by text of a spreadsheet device which is a conventional input method.

The mouse 24 gives an instruction to change the specific symbol displayed on the display unit 22. The keyboard 23 and mouse 24
The input of data from is performed via the keyboard control unit 25.

The CPU 26 controls the operation of each of the above-mentioned parts, and also performs a predetermined calculation, a specific symbol data, and a change control of the grid value corresponding to the specific symbol data.

The specific symbol has, for example, a symbol as shown in FIG. 2, and is changed by designating a desired position with a graphic cursor (hereinafter, referred to as “cursor”) 20 that is moved and displayed in association with the movement of the mouse 24. The design that you made is displayed again. That is, in the case of (a), the position of the gauge 28 is changed and set, and in the case of (b), the lighting display is changed and set,
In the case of (c), the character designated by the menu 29 is changed and set.

The data of the specific symbol is not limited to the symbol shown in FIG. 2, and it is possible to set a symbol of a type according to the application.

Next, regarding the specific symbol changing operation of the spreadsheet device, the third
A description will be given based on the flowchart in the figure.

In the figure, the mouse 27 is used to move the cursor 27 to the pattern 32 to be changed in each cell 31 in the table 30 shown in FIG. 4 (step 101), and a button (not shown) of the mouse 24 is clicked (step 102). ). When the button is clicked, the CPU 26 determines whether the clicked position is the design position (step 103).

Here, if the click position is a predetermined position of the symbol, the designated position information is input (step 104),
The position information is converted into the value of the cell and the value of the cell is changed and determined (step 105). That is, the position information is the position of the scale on which the cursor is present in the case of the gauge shown in FIG. 2 (a), and the cursor is in the switching lighting display shown in FIG. 2 (b). Which area it is in, and in the case of the menu shown in FIG. 2 (c), it is the selection of items to be displayed, and these are input as position information. Then, the CPU 26 determines the value of the above square by the changed formula and the formula that indirectly determines the value by referring to other squares. The determination is made, the value of the corresponding square in the main storage unit 20 is updated, and the display information of the display 22 is created according to the changed square value (step 106). Then, based on the display information and the updated grid value, the design and grid value on the screen of the display 22 are converted and re-displayed (step 10).
7).

Also, if the click position is not the position of the symbol,
Judged as the selection of squares by text (Step 10
8) In response to the data input by the keyboard 23, the value of the square and the design on the screen are changed and redisplayed on the display 22 (step 107).

Therefore, in the present invention, the value of the particular square is determined by instructing the change of the data of the particular symbol corresponding to the value of the square, and the data of the specific symbol displayed according to the value of the decided square and By changing and controlling the value of the squares corresponding to the data of the specific symbol and re-displaying, it is possible to input, change, and display the symbol as a unit, so that anyone can create an explicit and simple table. This makes it possible to create a table quickly and improve the processing capacity of the entire system.

[Effects of the Invention] As described above, in the present invention, the specific symbol is displayed in the displayed table, and the visual angle input by the specific symbol is enabled. It enables simple table creation, has better interactivity, and improves the processing capacity of the entire system.

[Brief description of drawings]

FIG. 1 is a block diagram showing a schematic configuration of a spreadsheet device according to the present invention, FIG. 2 is a diagram showing an example of a specific symbol displayed on a display, and FIG. 3 is a symbol change in the spreadsheet device of FIG. FIG. 4 is a flow chart for explaining the operation, FIG. 4 is a diagram showing an example of a table displayed on the display, and FIG. 5 is a diagram showing an example of a conventional table displayed on the display. 10,30 ... table, 11,31 ... cell, 20 ... main memory, 21 ... display control, 22 ... display, 23 ...
... keyboard, 24 ... mouse, 25 ... keyboard control section, 26 ... CPU, 31 ... specific symbol.

Claims (1)

[Claims] 1. A table display data is stored, a predetermined table based on the display data is displayed according to a request, a desired value is input to each square in the table, and the input value is set. In a spreadsheet device for displaying according to, storage means for storing data of a specific symbol showing a value corresponding to the value of the square, display means for displaying the data of the stored specific symbol, the display means Change instruction means for instructing to change the data of the specific symbol displayed on, and change control for changing and controlling the data of the specific symbol displayed in accordance with the change instruction and the value of the square corresponding to the data of the specific symbol A spreadsheet device characterized by comprising means.