JPS62239267A - Table processing system - Google Patents

Abstract

PURPOSE:To shift a cursor by an operator and to always display a guidance and a message by storing the guidance and the message as a calculating formula to give a special result. CONSTITUTION:When an operator inputs a calculating formula from a keyboard 11, a key input control part 12, since the head of an inputted key group is '+,' decides that the input contents are the calculating formula and delivers the input contents to a calculating formula registration processing part 16. The calculating formula registration processing part 16 investigates the delivered calculating formula, when a function symbol 'YenM' continues after '=,' knows that this is the designation for a guidance message and registers this to a guidance table 19. The calculating formula registration processing part 16, when the delivered calculating formula is the calculating formula except the above- mentioned contents, judges that this is the calculating formula by a conventional technics and registers it to a calculating formula table 14. Here, the guidance table 19 and the calculating can be removed by the search from the back.

Description

[Detailed Description of the Invention] [Industrial Application Field] The present invention relates to a table processing method, and particularly to a table processing operation.
The present invention relates to a table processing method related to the improvement of a simple table processing language that improves the operability when inputting data into a table that has already been created.

[Conventional technology]

With the spread of personal computers (PCs) and office automation (OA), word processing functions and simple languages for one-table processing have become widely used.

As mentioned above, the present invention relates to a table processing method that is an improvement on the above-mentioned simple language for table processing. here,
A simple language for table processing is a language that is stored on a computer's storage device.
A tabular electronic form arranged in a vertical and horizontal matrix is placed, and the calculation processing function of a computer is used to perform vertical and horizontal calculations and four arithmetic operations on the electronic form displayed on a display device.

With the simple language for table processing, operators can create tables of any size while looking at the screen on the display device, and simply define simple calculation formulas, allowing them to perform table processing that was previously done manually. It can be carried out.

For this reason, it is suitable for non-routine work, and can be used to create tables when an idea comes to mind.

Language for non-routine work is also called simple language.

On the other hand, in offices, there are many routine tasks such as daily invoice issuing tasks, and these routine tasks have traditionally been performed using RASI.
It is often written in a procedural language such as C or COBOL. In addition, there are many intermediate jobs between the above-mentioned non-routine work and regular work in the office, and as the functions of simple form words for table processing have been enhanced, the above-mentioned intermediate work (irregular, but It is increasingly being used for tasks that are performed repeatedly, or similar tasks that are handled slightly differently depending on the division.

[Problem that the invention seeks to solve]

The problem here is that the BASIC'e'C0BO
In tasks created using a procedural language such as L (in this case, inputting data into a displayed form), it is possible to provide effective guidance and messages to the operator at any time. In languages, arithmetic expressions can be defined in a table, but the table creator cannot freely create and display guidance and messages for the operator.

In particular, for tables that are used repeatedly on an irregular basis, even the creator of the table may forget how to operate the table, and if an operator other than the creator attempts to input data,
The creator may need to provide an explanation or create a guide.

Furthermore, as described in Japanese Patent Application Laid-open No. 59-69840, it has been proposed to predetermine the order in which the cursor moves to prevent erroneous operations, but this also involves displaying messages and guidance. has not been touched.

The purpose of the present invention is to solve the above-mentioned problems in conventional table processing methods, and to enable table creators to receive guidance and messages.
An object of the present invention is to provide a one-table processing power formula that allows the user to freely store the guidance and messages in the table and to display the above-mentioned guidance and messages at all times by moving the cursor by the operator.

[Means for solving problems]

The above object of the present invention is to provide means for storing guidance or messages corresponding to any cell in one table and means for analyzing operator input in a table processing method using a simple language for table processing. Achieved by a table processing method characterized in that when a user performs an operation to specify an arbitrary cell in a table, guidance or a message stored in the storage means corresponding to the specified cell is displayed. be done.

[Effect]

The present invention focuses on the fact that conventional simple languages have the function of storing calculation formulas, and realizes the above function by storing guidance and messages as calculation formulas that give special results. be.

Therefore, table creators can also use conventional RASIC or C0BOL.
As a simple language, guidance and messages can be defined as an extension of the work of defining calculation formulas, without having to perform tasks similar to programming, such as displaying guidance and messages in procedural languages such as .
Even for table creators, the ease of creating tables is not lost.

Furthermore, moving the cursor in an arbitrary order is called a catalog function or an automatic function in conventional simplified language, without waiting for the above-mentioned Japanese Patent Laid-Open No. 59-69840. By combining this with the function of storing and executing the operator's operating procedures, it is possible to realize a function in which the cursor can be moved in any order and guidance and messages can be displayed. This is true for COBOL and RA.
This makes it possible to expand the scope of application of a simple language for table processing to routine work, which was previously difficult to do without a procedural language such as SIC.

〔Example〕

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The principle of the present invention will be briefly explained below, and then embodiments will be explained in detail based on the drawings.

FIG. 2 is a diagram showing table processing according to an embodiment of the present invention. In the figure, 1 is the screen on the display device, 2 is the column symbol (A-E) in the simple language for table processing, and 3 is the row symbol (#1 to
#6). In simple language, each cell in a table is called a "cell," and its position is indicated by a column symbol and a row symbol. The cells in the hatched part indicated by 4 are rB2J
It is called.

The hatched portion is displayed in reverse video on the screen, and is called a "block cursor." This block cursor can be freely moved by the operator using cursor movement keys on the keyboard. 5 shows an example of guidance stored in the table according to the present invention, 6 shows a data input canister for inputting data, and 7 shows an example of calculation formulas and guidance messages stored in the table according to the invention. be.

In the example shown in FIG. 2, there were some problems with conventional table processing. These are the input of "category" in column B and "unit price" in column 0.

In other words, in the example shown in Figure 2, the operator is supposed to enter "1" for "sales" and "2" for "returns" as the "category" in column B. If you are not the creator of the table or if you do not have a manual, you will not be able to know such conditions.Similarly, the ``Unit Price'' column in the 0 column will have a negative value if it is a return. It is a promise to enter.

The above convention is that if table processing is written in a procedural language such as BASIC or COBOL, a guidance message should be issued when waiting for a keyboard input to execute the processing, but in a simple language , the feature of which is that you can input by moving the cursor arbitrarily, so it is not possible to issue a fixed guidance message.

As explained below, in the present invention, in order to solve the above-mentioned problems, the block cursor is set to B2. B3.
B4. When existing in B5 (hereinafter written as "B2:B5J"), please enter 1 category (1: Sales,
2: Returns)" is displayed in the guidance area 5, and when the block cursor is at C2: C5, the message "Please enter unit price. This provides a means for displaying a message in the guidance area 5, ``(Returns are negative)''.

An example of the calculation formula and guidance message stored in the table according to the present invention, shown as 7 in FIG. 2, will be explained below.

In 7, (1) 10E=C umbrella, (2)+#6=VS
UM (#2 : #5) is a calculation formula in the prior art, and (1) indicates that column E is the product of column 0 and column D, and the calculation result of unit price x quantity is placed in B2:B6. Indicates that it is to be substituted. Here, the “10” symbol at the beginning of the expression is
This indicates that the following data is a calculation formula. (
2) similarly indicates that the 6th line (total column) calculates the sum of all columns from the 2nd line to the 5th line.

(3) to (8) show definitions of guidance messages according to the present invention. Taking (6) as an example, +B2:
B5 = ¥M Please enter the ri category.

(1: Sales, 2: Returns)", when the block cursor is in B2:B5, please enter the "category" in the message area 5. (1: Sales.

2: Returned goods)''.

Here, ¥M is a function symbol to indicate that a message is displayed as a special function. Therefore, it does not have to be ¥M, but any symbol that can be distinguished from other functions etc. is sufficient.

As mentioned above, the key point of the present invention is to define messages and guidance in the same way as calculation formulas, and this allows non-routine work to use the block cursor in any order of operations, which is a feature of simple languages. Even if you move the block, guidance that matches the block cursor position can always be displayed, and the table creator is only aware that one more function has been added to the calculation formula execution part when creating a conventional table. You can define guidance.

Examples of the present invention will be specifically described below.

FIG. 1 is a diagram showing the configuration of a table processing device that is an embodiment of the present invention. In the figure, 11 is a keyboard, 12 is a key control unit that analyzes and determines the keys on the keyboard 11 pressed by the operator, 13 is a calculation formula search unit that searches for calculation formulas, and 14 is a storage unit for calculation formulas. a calculation formula table, 15 a calculation formula execution unit, 16 a calculation formula registration processing unit, 1
7 is a block cursor control unit that controls the movement of the block cursor; 18 is a guidance search unit that searches for stored guidance; 19 is a guidance table that stores guidance; 20 is a guidance display control unit;
Reference numeral 21 indicates a display device, and 22 indicates a calculation result display control section.

The operation of this embodiment configured as described above is as follows.

The operator proceeds with the work by pressing various keys on the keyboard 11 to perform input, and all keys pressed by the operator are sent to the key control unit 12. The keys input by the operator can be broadly divided into: (a) moving the block cursor, (b) registering calculation formulas, (c) registering guidance to be memorized, (d) inputting data into tables, and (e) other commands. Divided into inputs. Note that among the above, inputting other commands in (e) is omitted because it is not directly related to the present invention.

Hereinafter, a case will be described in which an operator registers a calculation formula or guidance, inputs data, or moves a block cursor using the table processing device shown in FIG.

When the operator first inputs the calculation formulas shown in FIG. 2 (1) to (8) from the keyboard 11, the key control unit 1
2 is because the beginning of the input key group is “+”,
It is determined that the input content is a calculation formula, and the input content is passed to the calculation formula registration processing section 16.

The calculation formula registration processing unit 16 examines the passed calculation formula, and
If the function symbol "\MPI" follows =JT, it is known that this is a specification for a guidance message, and this is registered in the guidance table 19.

If the passed calculation formula is a calculation formula other than the above, the calculation formula registration processing unit 16 determines that it is a calculation formula according to the prior art and registers it in the calculation formula table 14.

Here, the above-mentioned guidance table 19 and calculation formula table 14 are tables created in an auxiliary storage device such as a main storage device or a magnetic disk device of a convenience store.
The structure is such that it can be retrieved by searching later.

Further, if the input key group is data, the key manual control unit 12 sends the input data and coordinate position to the calculation formula search unit 13. The calculation formula search unit 13 searches the calculation formula table 14 to find a calculation formula related to the coordinates, and causes the calculation formula execution unit 15 to execute the calculation formula. The execution result is passed to the calculation result display control section 22 and displayed on the first display device 21.

Note that in FIG. 1, a portion displaying input data is omitted because it is not directly related to the portion.

Further, if the input data is a block cursor movement key, the key manual control unit 12 passes the information to the block cursor control unit 17. The block cursor control unit 17 moves the block cursor display position and notifies the guidance search unit 18 of the coordinate position.

The guidance search unit 18 searches the guidance table 1.
Search 9 for the searched guidance.

The information is passed to the guidance display control section 20. The guidance display control unit 20 passes the passed guidance to the display device 21 to display the guidance.

In this embodiment, this guidance is displayed in the guidance display area indicated by 5 in FIG. 2.

A flowchart of the processing of the key manual control section 12 described above is shown in FIG.

Although the guidance table 19 and calculation formula table 14 have been described as being provided separately on the actual flow side, it goes without saying that they may be integrated.

[Effects of the Invention] As described above, according to the present invention, a table creator can create guidance and
It is now possible to define messages, and once defined, it is possible to realize a table processing method that allows the operator to constantly display the guidance message corresponding to that cell simply by moving the block cursor. This has the following effects.

[Brief explanation of drawings]

FIG. 1 is a diagram showing the configuration of a table processing device that is an embodiment of the present invention, FIG. 2 is a diagram showing table processing as an example of its operation, and FIG. 3 is a flowchart of the processing of the key human control unit 12. be. 1: Screen on display device, 5: Guidance display area, 6
: Data input machine, 11: Keyboard, 12: Key manual control unit, 13: Calculation formula search unit, 14: Calculation formula table, 15: Calculation formula execution unit, 16: Calculation formula registration processing unit, 1
7: Block cursor control section, 18: Guidance search section, 19: Guidance table. 20: Guidance display control unit, 21: Display device, 22:
Calculation result display control section. Figure 2 Figure 3

Claims (1)

[Claims] 1. In a table processing method using a simple language for table processing, a means for storing guidance or messages corresponding to any cell in the table and a means for analyzing operator input is provided, so that the operator can input any cell in the table. A table processing method characterized in that when an operation is performed to designate a cell, guidance or a message stored in the storage means corresponding to the designated cell is displayed.