JPH0283776A - Chart calculating device - Google Patents

Abstract

PURPOSE:To improve throughput as a system by displaying a specific pattern into a chart to attain a visual input via the specific pattern and therefore enabling even an inexperienced user to produce a clear and simple chart. CONSTITUTION:A cursor 27 is moved by a mouse 24 to a pattern 32 to be changed and put in a square 31 of a chart 30, and a button (not shown here) of the mouse 24 is clicked. Thus a CPU 26 decides whether the clicked position is coincident the pattern 32 or not. If so, the designated information is inputted and changed into a square. The value of this square is decided with change. Thus the CPU 26 decide the value of the square by reference to the value of the changed square and an equation, if set, that decides indirectly the value of the relevant square with referring the value of another square. The value of the corresponding square of a main storage 20 is updated, and the display information is produced for a display 22 in accordance with the value of the changed square. The pattern and the value of the square displayed on the screen of the display 22 are changed and then displayed again.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a spreadsheet device in an interactive data processing system.

[Conventional technology]

Conventionally, this type of display training device displays a table 10 in the form of a two-dimensional vertical and horizontal matrix as shown in FIG. Therefore, when the knee amount A is entered in each item 11 of the above table using an input means such as a keyboard, the desired value such as letters and numbers is entered.
You can write/correct the input value above and display the above value with the specified attribute. You can also enter a formula that indirectly determines the value by referring to other squares. If such a formula is set, the user can When the value is changed, a processing device such as CP[J executes a table calculation according to the above formula, displays the calculated result value of the formula, changes the data relationship in the above table, and stores it in the main memory. By reading the text, Yup was able to interact with the system. The above table also has a command input section 12 for the user to give instructions to the table. It is possible to perform operations such as copying, moving, deleting, and changing the width of the matrix. That is, the selection of a square in a table was basically performed by determining the desired square using a cursor movement key or a mouse, and inputting the value using the keyboard using an editing command or the like.

(Problem to be Solved by the Invention) However, in the above-mentioned table calculation device, input operations and input values are not explicit, so when used by a user who is inexperienced with the operation, it is difficult to perform the operation smoothly. However, there was a problem in that it took a long time to create the table, and the process became stagnant.

The present invention has been made in view of the above-mentioned problems, and by providing a visual input method using specific symbols, even users who are inexperienced with operations can clearly and easily create tables, and achieve better interactivity. The task is to capture and supply a display device that has a table meter.

[Means for Solving the Problems] In the present invention, display data in a table is not recorded, a predetermined table based on the display data is displayed in response to a request, and each square in the table is In a table calculation device that inputs a desired value using a keyboard or the like and displays a display according to the input value, a memory or the like that stores data of a specific symbol indicating a value corresponding to the J-th value is used. a storage means, a display means such as a display for displaying the stored data of the specific symbol, a change instruction means such as a mouse for instructing to change the data of the specific symbol displayed on the display; It is provided with a change control means such as a CPU for changing and controlling the data of the displayed specific symbol and the value of the square opening corresponding to the data of the specific symbol.

(Effect) By instructing to change the j-ta of the phantom [, 6 r4, 1 constant degree symbol in the value of the first eye, the value of the first eye is determined,
The data of the specific symbol displayed according to the determined J value and the value of the square corresponding to -j゛- of the specific symbol are changed and displayed again.

Therefore, any person can create a table explicitly and easily, and the table can be created quickly.

〔Example〕

Embodiments of the present invention will be described in detail based on the drawings of FIGS. 1 to 4.

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

In the figure, the main storage unit 20 stores table display data, specific symbol data, and square values corresponding to the specific symbol data.

The display control unit 21 displays the data of the table stored in the main storage unit 20, the data of the specific symbol, and the value of the first eye corresponding to the f-ta of the specific symbol under the control of the CPU, which will be described later. It is controlled so that it is displayed on 22.

The display section 22 is composed of a display such as a CRT, and displays each data in the table based on the display control of the display control section 21.

The keyboard 23 is used for inputting square values using text in a table i1 calculator, which is a conventional input method.

The mouse 24 instructs to change the specific symbol displayed on the display section 22. The above keyboard 23 and mouse 2/
Data input from I is performed via the keyboard control section 25.

The CPU 26 controls the operations of the eight units described above, as well as performs predetermined calculations, specific symbol data, and changes control of the value of the deceiving eye corresponding to the specific symbol data.

The specific pattern includes, for example, a pattern as shown in FIG. 2, and a desired position is specified using a graphic cursor (hereinafter referred to as 1 cursor) 27 that moves and displays as the mouse 24 moves. In particular, the changed design is redisplayed. That is, in the case of (a), the position of the gauge 28 is changed and set, in the case of (b), the lighting display is changed and set, and in the case of (C), the character specified by the menu code 29 is changed and set. Ru.

Note that the specific symbol data is not limited to the symbols shown in FIG. 2, and various kinds of symbols can be set depending on the purpose.

Next, the specific symbol changing operation of the 2-note table counting device will be explained based on 71]-JA-1 in FIG.

In the figure, the mouse 24 is used to move the No.
The symbol 3 to be changed for each eye 31 in J-Table 30 shown in the figure
2 (Step 101), click a button (not shown) on the mouse 27'I (Step 102). ”
When the second button is clicked, the CPU 26 determines whether the clicked position is the position of the symbol or not (step 1).
03).

Here, if the above-mentioned click position is a predetermined position of the symbol, enter the specified position information.Step 10 /1
．． >, the above position information is converted into a square value, and the square value is changed and determined (step 105). In other words,
In the case of the gauge shown in FIG. 2(a), the above position information is the position of the scale where the cursor is located, and the position information in FIG.
In the case of the switching lighting display shown in b), it is the area in which the cursor is located, and in the case of the menu shown in Figure 2 (C), it is the selection of the displayed item, and these are the positions. It is input as information. And CPLI26
If a formula is set that indirectly determines the value by referring to the value of the changed square and another square, the value of the square above will be determined by the formula. is determined, the value of the corresponding square in the main storage section 20 is updated, and display information on the display 22 is created in accordance with the changed value of the square (step 106). Then, the above display 2 is displayed based on the above display information and the updated square value.
The symbols and square values on the screen No. 2 are converted and redisplayed (step 107).

In addition, if the above click position is not the position of the pattern, it is determined that the square is selected by the text, and step 10
8) The value of the square and the pattern on the screen are changed in accordance with the data input using the keyboard 23 and are redisplayed on the display 22 (step 107).

Therefore, in the present invention, the value of the eye is determined by instructing to change the data of the specific symbol corresponding to the value of the square, and the value of the eye is determined according to the determined value of the clam. By changing and re-displaying the value of the square corresponding to the data of the f-night and specific symbol, we have made it possible to input, change, and display the symbol all at once, so anyone can explicitly Tables can be created easily and quickly, and the processing capacity of the entire system can be improved.

(Effects of the Invention) As explained above, in this Komei, a specific symbol is displayed in the displayed table, and visual input using the specific symbol is made possible, so that even users who are inexperienced with the operation can clearly and clearly input the symbol. It enables simple table creation, provides better interactivity, and improves the processing capacity of the entire system.

FIG. 5 is a diagram showing an example of a conventional table displayed on a display.

10.30...Table, IL31...Meadow, 20
...Main storage unit, 21...Display control unit, 22...Display unit, 23...Keyboard, 24...Mouse, 25
...Keyboard control unit, 26...CPU, 31...
・Specific design.

[Brief explanation of the drawing]

Figure 1 shows the schematic configuration of the &Muro device according to the present invention.
Block diagram, Figure 2 shows an example of a specific symbol displayed on the f' display, Figure 7, Figure 3 shows the table fif-CI in Figure 1.
F1 to explain the pattern change operation in d3 on the device
-Chi v-l~, Figure 4 shows the table δ rainbow on the f' display.

Claims (1)

[Claims] Store display data of a table, display a predetermined table based on the display data in response to a request, input a desired value into each square in the table, and input the input value. A spreadsheet device that performs a display according to the value of the square, a storage means for storing data of a specific symbol indicating a value corresponding to the value of the square, a display means for displaying the stored data of the specific symbol, and the display. a change instruction means for instructing to change the data of a specific symbol displayed on the means; and a change control for changing and controlling the data of the displayed specific symbol and the value of the square corresponding to the data of the specific symbol in accordance with the change instruction. A spreadsheet device comprising a control means.