JPH0433054A - Display device for table calculation - Google Patents

Abstract

PURPOSE:To improve speed for the work of an input by displaying a format, using method and input example corresponding to the condition of the input concerning a function when inputting a numerical formula. CONSTITUTION:A storing means 101 stores the format, using method and input example concerning the various functions. When an input means 103 inputs the function, a reading means 104 reads the format, using method and input example concerning the inputted function from the storing means 101, and a changing means 105 changes the input example to the one corresponding to the current input condition. Then, a display means 106 displays the changed input example. Thus, when inputting the numerical formula, the workability of the operation can be improved.

Description

DETAILED DESCRIPTION OF THE INVENTION (a) Field of Industrial Application This invention relates to a spreadsheet display device for displaying a table and inputting data into the table to perform various spreadsheet calculations.

(B) Conventional technology Conventionally, in this type of spreadsheet display device, a mathematical formula consisting of functions such as absolute value, square root, summation, etc. is input into the squares of the table, and numerical values calculated based on the mathematical formula are displayed in the table. It has the function of displaying images within the eyes.

(c) Problem to be solved by the invention However, in this type of spreadsheet display device,
When inputting a mathematical formula on the fold of a table, there was a problem in that the user had to refer to a manual about how to use functions and input examples.

This invention was made in consideration of these circumstances, and when inputting a mathematical formula, input examples are displayed according to the format of the function, how to use it, and the input situation. The present invention provides a spreadsheet display device that allows input of information.

(d) Means to solve the problem FIG. 1 is a block diagram showing the configuration of the present invention.

As shown in the figure, the present invention provides a spreadsheet display device that displays a table and performs various spreadsheet calculations by inputting data into the table, and provides formats, usage methods, and methods for various functions. Storage means 101 that stores input examples
and detection means 102 for detecting the current cursor position,
an input means 103 capable of inputting a function; a reading means 104 for reading out the format, usage method, and input example of the function inputted by the inputting means 103 from the storage means 101; Changing means 105 for changing the input example to an input example corresponding to the current input situation based on the current cursor position detected by the detecting means 102, and changing the format and usage method of the function read by the reading means 104. This is a spreadsheet display device comprising display means 106 for displaying input examples changed by means 105.

Note that the storage means 101 in the present invention may be any device that can store formats, usage methods, and input examples for various functions, and may include a large-capacity ROM, a magnetic storage medium such as a floppy disk, a hard disk, and its drive device. etc. are used.

Further, the input means 103 may be any device that can input or specify a function, and various input and specification devices such as a keyboard device, a tablet device, etc. are used.

Furthermore, as the detection means 102, the reading means 104, and the changing means 105, a microcomputer consisting of a CPU, ROM, and RAM 10 ports is usually used.

As the display means 106, a CRT display device including a buffer memory for display, an LC (liquid crystal)
A display device or the like is used.

(e) Effects According to the present invention, the storage means 10 stores formats, usage methods, and input examples for various functions. Further, the detection means 102 detects the current cursor position.

Then, when the function is input by the input means 103,
The reading means 104 reads out the format, usage method, and input example for the input function from the storage means 101, and the changing means 105 changes the input example therein to the current cursor position detected by the detection means 102. The format and usage of the function read out by the reading means 1 (14) and the input example changed by the changing means 105 are displayed on the display means 10B. Displayed by

Therefore, when inputting a mathematical formula, input examples are displayed according to the format of the function, how to use it, and the input situation, so that the workability of the operation is improved.

(f) Examples Hereinafter, the present invention will be described in detail based on examples shown in the drawings. Note that this invention is not limited to this.

FIG. 2 is a block diagram showing the configuration of an embodiment in which the present invention is applied to a personal computer.

In this figure, l is a keyboard equipped with keys for inputting functions such as numeric keys, character keys, and function keys, a release key, an area designation key, an input position change key, an execution key, a page turn key, etc. absolute value, square root,
A mathematical expression consisting of a function such as a summation is input to the control unit 2.

The control unit 2 performs various spreadsheet processing, which will be described later, using a spreadsheet program written in a program memory 3 consisting of a ROM.

4 is the spreadsheet data entered from the keyboard l.
It is a data memory consisting of self-memory RAM.

A format memory 5 stores formats, usage methods, and input examples for various functions such as absolute value, square root, and summation.

6 is a display device consisting of a CRT display device.

FIGS. 3 to 5 are explanatory diagrams showing display examples when inputting mathematical expressions.

As shown in FIG. 3, when inputting a mathematical formula, each function is assigned to a function key on the keyboard 1, displayed at the bottom of the display screen, and the function is input. In this operation, a key for setting the formula input mode is pressed, a screen as shown in FIG. 3 is displayed, and then a formula consisting of a function and an argument is input at the current cursor position.

In this case, when a function key is input, a function stored in association with the function key is input, and when a shift key (or a control key such as a control key) and a function key are pressed at the same time,
Displays input examples depending on the function format, usage, and input situation. Of course, the function format, usage,
The display of the input example may also be performed by other key processing.

When the shift key and the function key are pressed in the input state where the function description is not displayed on the screen as shown in FIG. 3, the input description of the corresponding function as shown in FIG. , its input format, argument input method, and input examples are displayed.

Also, if the input explanation for the relevant function has multiple pages,
As shown in FIG. 5, the page is displayed at the upper right of the input explanation text, and the operation method for displaying the next page and previous page is displayed in the function explanation column on the screen. In this case, the conversion/next candidate key changes the display to the next page's explanation, and the previous candidate key changes the display to the previous page's explanation.

FIG. 6 is an explanatory diagram showing an example of table input. As shown in this figure, when the cursor C is located, for example, in the 4th row and 4th column, when calculating the average value of a certain area, , as a spreadsheet, the area ■ (area from the 1st column to the 3rd column of the 4th row)
, or the average value of the area (region from the first row to the third row of the fourth column) is often found. Therefore, as an input example, as shown in FIG. 7, the current position of the cursor C is detected and a formula for calculating the average value of the area (2) or the area (2) is displayed. In other words, average (row 4 columns 1 to 3)... Formula to calculate the average value of area ■ Average (row l to 3 column 4) ...... Formula to calculate the average value of area ■ Input Show example.

In this way, the input example stored in the format memory 5 is changed to an input example corresponding to the current input situation based on the cursor position, and is displayed as an optimal input example according to each function.

In the display example described above, if the explanation of the function format is unnecessary, it can be deleted using the release key.

Furthermore, the function format explanation window is automatically cleared when changing the position of the table to be input, when enclosing a range by specifying an area, and when a formula is finalized (when the execution key is pressed).

If the explanation of the function format requires multiple pages, press the page turn key and display them one after another.

Furthermore, if another function is input while displaying the function explanation, the display is changed to that other function explanation.

If the formula input method is to display a function list in the window and select it by moving the cursor to input the function, move the cursor to the function you want to display in the function list window. moved and a certain key (
(can be assigned to any key) is typed, display the function format.

Next, the contents of the processing operation of the control section 2 will be explained according to the flowcharts shown in FIGS. 8 and 9.

First, in the formula input mode as shown in Figure 3,
When a key is pressed, if it is a function key (step Il), check whether it was pressed at the same time as the shift key or control key (step 12). The function format and input example are displayed (step 13), and if only the function key is pressed, normal function input processing is performed (step 14), and the process returns to step 11.

When the pressed key is a release key (step 1
5) Check whether the function format and input example are being displayed (step 16), and if so, delete the function format and input example (step 17); if not, cancel the formula. (Step 18)
, ends the process.

When the pressed key is an area specification key (step 19), processing A to be described later is performed (step 20),
Area designation processing is performed (step 21), and the process returns to step 11.

When the pressed key is an input position change key (step 22), processing A is performed (step 23), input position change processing is performed (step 24), and the process returns to step 11.

When the pressed key is an execution key (step 2
5), perform process A (step 26), confirm the formula (step 27), and end the process.

When the pressed key is a page turn key to the previous page or next page (step 28), it is checked whether the function format and input example are being displayed (step 29), and if so, the function format is further displayed. Check whether there are multiple pages of explanation (step 30), and if there are multiple pages, change the page (step 31). Also,
If it is not displayed in step 29 and if there is not a plurality of images in step 30, a buzzer sounds (step 32) and the process returns to step 11.

FIG. 9 is a flowchart showing the contents of process A shown in FIG. 8. As shown in this figure, process A checks whether the function format and input example are being displayed (step 51). , the function format and input example are deleted if they are being displayed (step 52).

In this way, when inputting a mathematical expression, input examples corresponding to the format of the function, how to use it, and the input situation are displayed, thereby improving the workability of the operation.

(G) Effects of the Invention According to this invention, when inputting a mathematical formula, the format of the function, how to use it, and input examples according to the input situation are displayed, so there is no need to refer to the manual, and inputting The work speed can be improved.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing the configuration of this invention, FIG. 2 is a block diagram showing the configuration of an embodiment of this invention, FIGS. 3 to 5 are explanatory diagrams showing examples of display when inputting mathematical formulas, and FIG. FIG. 7 is an explanatory diagram showing an example of an input example in a table, FIG. 7 is an explanatory diagram showing an example of display of an input example according to an input situation, and FIGS. 8 and 9 are flowcharts showing the operation of the embodiment. l...Keyboard, 2...Control unit, 3
...Program memory, 4...Data memory, 5...Format memory, 6...
...Display device. Figure 1

Claims (1)

[Claims] 1. In a spreadsheet display device that displays a table and performs various spreadsheet calculations by inputting data into the table, formats, usage methods, and input examples for various functions , a detection means for detecting the current cursor position, an input means capable of inputting a function, and a storage means for storing the format, usage method, and input example of the function input by the input means. a reading means for reading out the input example read from the reading means; a changing means for changing the input example read by the reading means into an input example according to the current input situation based on the current cursor position detected by the detection means; A spreadsheet display device comprising a display means for displaying a format and usage method for a function that has been changed, and an input example changed by a changing means.