JPH0557630B2 - - Google Patents

Description

[Detailed Description of the Invention] [Technical Field of the Invention] The present invention relates to a simplified language processing method in which a processing procedure is stored in an electronic sheet on a memory, and the processing procedure can be executed as needed. It is.

[Conventional technology and problems]

In conventional computer systems that can process simple languages, there are two methods for storing processing procedures: one is to store only the processing procedure in a separate file in a location other than the electronic sheet (such as a procedure file), and the other is to store the key data that instructs the processing. There is a method of storing it as item data on the electronic sheet, but both methods make it difficult to understand the processing procedure when you want to modify or change it, and it is necessary to modify the procedure when adding or deleting from the electronic sheet to be processed. , must be re-stored.

[Purpose of the invention]

The present invention is based on the above considerations, and includes:
Processing procedures are stored on the same electronic sheet where data (characters, numbers, function data, etc.) are stored in the same format as function data such as addition and average,
Furthermore, it is an object of the present invention to provide a simplified language processing method that allows a plurality of processing procedures to be defined within one electronic sheet.

[Structure of the invention]

Therefore, the simple language processing method of the present invention provides a simple language processing method that performs table processing, which includes a display device on which a table is displayed, and an electronic sheet in a memory in which data displayed in the table on the display screen is stored. In the processing method, there are command functions for displaying graphs based on the data on the electronic sheet, command functions for transferring data from other places to the electronic sheet, and command functions for saving the data on the electronic sheet to other places. A sequence of command functions selected from a command function set consisting of a command function for printing data on the electronic sheet, and other command functions is stored in the electric sheet as a processing procedure, and means for determining which position in a table on a display screen the storage position of a command function corresponds to and displaying a mark or character string corresponding to the command function in the corresponding position in the table on the display screen; and a set of command functions. a plurality of command function execution means for executing each of the plurality of command functions constituting the computer; and a control means for causing the corresponding command function execution means to execute the command function included in the processing procedure specified by the operator. It is characterized by having the following.

[Embodiments of the invention]

Hereinafter, the present invention will be explained with reference to examples.

FIG. 1 is a diagram showing an example of the configuration of an apparatus for implementing the present invention. In FIG. 1, 1 is a display device, 2 is a central processing unit, 3 is a keyboard, 4 is a memory, 4a is an electric sheet, 5 is an external storage device such as a floppy disk device or a magnetic disk device, 6 is a printer, and 7 indicates a table on the display screen.

FIG. 2 is a diagram showing an example of an electronic sheet and commands. In Figure 2, the leftmost 1, 2, 3,...
...indicates the row number, and A to F in the top row indicate the column number. Tokyo, Osaka, Fukuoka, Kanazawa, etc. are character data, and 2, 2, 1, . . . are numerical data.
@SUM(B2:B5), ...@SUM(E2:E5) indicate the calculation formula. For example, @SUM(B2:B5)
Instructs to add the numerical data in item frames B2 to B5. @GRAPH(B,
A6, B6:E6) shows a graph function to create a bar graph, and @GRAPH (C, A2: A5, E2: E5) shows a graph function to create a pie chart.
@GXS(B1:E1) and @GXS(E1) are auxiliary functions of graph functions. /MOVE(B5, B5:
E5, SALE4), /! ,.../PRINT (C8) is
Represents a command function. A sequence of command functions constitutes a processing procedure. Arithmetic expressions, graph functions, auxiliary functions, and command functions themselves are not displayed on the display screen, but 〓B is displayed instead of the bar graph function.
〓C is displayed instead of the pie chart function, /
[Post] is displayed instead of MOVE (B5, B5:E5, SALE4), and /! [Calculation] will be displayed instead. The following is as shown.

FIG. 3 is a diagram explaining the command function. /
MOVE (B5, B5:E5, SALE4) is a transfer/read command, and is a command for transferring character data, numerical data, etc. from a table stored in an external storage device to an electronic sheet in memory. The illustrated posting/reading command reads the data in item frames B5, C5, and E5 of the table named SALE4 from the external storage device and stores them in item frames B5, C5, D5, and E5 of the electronic sheet. Instructing. Figure 6 shows an example of a table named SALE4. /! is a recalculation command,
This is for recalculating on the electronic sheet. /GRAPH (C9) is a graph display command. The illustrated graph display command instructs to execute the graph function stored in item frame C9. /SAVE(SALET) is a save command, and the save command shown in the figure instructs that the data on the electronic sheet should be saved in an external storage device under the table name SALET. /PRINT
(A1:E6) is a print command, and the print commands shown in the figure are item frames A1, A2, ... of the electronic sheet.
Indicates that the coordinate range of E5 and E6 should be printed.

FIG. 4 is a diagram showing the control flow of the command function. If you try to execute the procedure in column F,
The operator specifies the range of the command string and instructs the execution of the command function. When the simple language processing program is instructed to start execution, it performs processing as shown in FIG.

Check whether there is a command function. Yes
If , process is performed, and if No, end.

Check whether it is a graph display command. If Yes, perform the process; if No, perform the process.

Display the graph.

Check whether it is a posting/reading command.
If Yes, perform the process; if No, perform the process.

Perform posting reading processing.

Check whether it is a print command. If Yes, perform the process; if No, perform the process.

Print.

Check whether it is a save command. If Yes, perform the process; if No, perform the process.

Save data on electronic sheets.

Check whether it is a recalculation command. If Yes, perform the process, and if No, return to the process.

Perform recalculation.

FIG. 5 is a diagram illustrating a transcription reading process using a transcription reading command. The posting/reading process is executed as follows.

Read the starting coordinates of the reading destination written in the posting/reading command.

Read data in the read range from a table stored in an external storage device.

Write data in the reading range on the table in order from the top coordinates of the electronic sheet.

When the transfer read command for the item frame F2 and the recalculation command for the item frame F3 of the electronic sheet shown in FIG. 2A are executed, the electronic sheet becomes as shown in FIG. 2B. When the graph display command in item box F4 in Figure 2 A is executed, the bar graph shown in Figure 7 A is displayed on the display screen, and when the graph display command in item frame F5 is executed, the bar graph shown in Figure 8 A is displayed on the display screen. When the pie chart is displayed on the display screen and the save command in item box F6 is executed, the table in Figure 2 B will be displayed.
It is saved on an external storage medium with the name SALET,
When the print command in item frame F7 is executed, the 9th
When the table in Figure A is printed and the print command in item box F8 is executed, the bar graph in Figure 7A is printed.

When the parameters of the print command in item box F8 of the electronic sheet shown in Figure 2 (B) are corrected from C8 to E8, the electronic sheet becomes as shown in Figure 2 (C).
When the print command in item box E8 in FIG. 2C is executed, the pie chart in FIG. 8A is printed.

If a new row is added between rows 5 and 6 of the table in Figure 2B, as shown in Figure 2D, each arithmetic expression is evaluated and coordinates). Therefore, the command function will be executed without re-entering it, and when the graph display command in item box F4 in Figure 2 D is executed, the bar graph in Figure 7 B will be displayed on the display screen. , When the graph display command in item frame F5 is executed, the pie chart in Figure 8 (B) is displayed on the display screen, and when the print command in item frame F8 is executed, the table in Figure 9 (B) is printed, and the item When the print command in frame F9 is executed, the bar graph in FIG. 7B is printed.

In the above embodiment, the processing procedure is stored in column F of the electronic sheet, but other processing procedures may be stored in column G (not shown), for example.

〔Effect of the invention〕

As is clear from the above explanation, according to the present invention, processing procedures can be easily stored on an electronic sheet without storing them in a special file, so even when data is updated, the electronic sheet at that point This has the effect that processing can be performed after checking the state of the data, and more accurate tabular data can be obtained.

[Brief explanation of the drawing]

FIG. 1 is a diagram showing an example of the configuration of a device for carrying out the present invention, FIG. 2 is a diagram explaining an electronic sheet of the present invention, and FIG. 3 is a diagram explaining a command function.
Figure 4 shows the control flow of the command function, Figure 5 shows the posting and reading process, and Figure 6 shows SALE4.
7 shows an example of a bar graph, FIG. 8 shows an example of a pie chart, and FIG. 9 shows an example of a table to be printed. 1...Display device, 2...Central processing unit, 3...
Keyboard, 4...Memory, 4a...Electronic sheet, 5...External storage device, 6...Printer, 7...
...table on the display screen.

Claims (1)

[Scope of Claims] 1. A simple language processing method for table processing comprising a display device on which a table is displayed and an electronic sheet in a memory in which data displayed in the table on the display screen is stored. Command functions for displaying graphs based on data on a sheet; Command functions for transferring data from elsewhere to an electronic sheet; Command functions for saving data on an electronic sheet elsewhere; Electronic A sequence of command functions selected from a command function set consisting of a command function for printing sheet data and other command functions is stored in the electronic sheet as a processing procedure, and the storage position of the command function on the electronic sheet is stored. a means for determining which position of a table on a display screen corresponds to a command function and displaying a mark or character string corresponding to the command function at a corresponding position of the table on a display screen; It is characterized by providing a plurality of command function execution means for executing each of the command functions, and a control means for causing the corresponding command function execution means to execute the command function included in the processing procedure specified by the operator. A simple language processing method that uses