JPH0750470B2 - Data processing device - Google Patents

Description

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing device such as a word processor which performs a spreadsheet on a table displayed on a display screen.

[Prior Art] Conventionally, a word processor having a tabulation function capable of creating a table of an arbitrary size in a sentence has been put into practical use. Etc. can be easily created.

[Problems to be Solved by the Invention] However, in a word processor with a tabulation function of this kind, for example, when a sales management table is created, the total sales quantity and total amount by product or the total sales quantity and total sales amount Has to be calculated in advance by a small electronic calculator or the like, and as a result, there is a drawback that tabulation cannot be performed efficiently.

An object of the present invention is to perform an arbitrary table calculation on a table displayed on a display screen at an arbitrary data position, and to specify a recalculation position arbitrarily by an extremely simple operation to obtain the same format. It is to be able to execute the spreadsheet again.

[Means for Solving the Problem] The means of the present invention arbitrarily specifies a display means for displaying a table on a display screen and a calculation for performing a table calculation on the table displayed on the display screen. Calculation specifying means, in the table displayed on the display screen, a data position specifying means for arbitrarily specifying a data position to be subjected to spreadsheet calculation by a cursor position, and a data position storing means for storing the data position, The data in the table is read out based on the data position, the calculation control means for executing the calculation specified by the calculation specifying means based on the data, the cursor is displayed on the display screen, and the table calculation is executed. Based on the recalculation position, recalculation position designating means for arbitrarily designating the recalculation position by the cursor position, recalculation position storage means for storing the recalculation position, Change the data position, read the data of the table corresponding to the recalculation position based on the changed data position, and based on this data, a table of the same format as the calculation executed by the calculation control means. Recalculation control means for executing the calculation again is provided.

[Operation] The operation of the means of the present invention is as follows.

First, a table created in advance is displayed on the display screen. In this state, when the calculation specifying means arbitrarily specifies the calculation for the table calculation, and in the table displayed on the display screen by the data position specifying means, the data position targeted for the table calculation is arbitrarily specified by the cursor position. The data position is stored in the data position storage means, the calculation control means reads out the data in the table based on the stored data position, and the calculation designated by the calculation designation means is executed based on this data. Then, the recalculation position designating means displays a cursor on the display screen, and when the recalculation position for executing the spreadsheet is arbitrarily designated by the cursor position, the recalculation position is stored in the recalculation position storage means and recalculated. The calculation control means changes the data position based on the designated recalculation position, reads the data in the table corresponding to the recalculation position based on the changed data position, and calculates the calculation based on this data. A spreadsheet with the same format as the calculation performed by the control means is executed again.

[Embodiment] Hereinafter, the present invention will be specifically described with reference to FIGS. 1 to 9. The present embodiment shows an example applied to a word processor with a tabulation function.

Structure FIG. 1 is a basic block circuit diagram of this word processor. In the figure, 11 is the input part of this word processor,
Numeric key KA, character key KB, execution key KC, function key KD, cursor key KE, recalculation key KF, horizontal calculation key KG, vertical calculation key KH, tabulation key KI on this keyboard.
Is provided. Here, the recalculation key KF is a key that is operated when repeatedly executing the same format table calculation, and the horizontal calculation key KG executes the table calculation in the horizontal direction (column direction) of the table among various table calculations. A key for making a calculation and a vertical calculation key KH are keys for making a table calculation in the vertical direction (row direction) of the table. Furthermore, the tabulation key KJ is used to set the values in the table in the vertical direction,
It is a key to execute normal spreadsheets that accumulate horizontally. Then, the key input signal output from the input unit 11 corresponding to the operation key is sent to the input control unit 12 and converted into a key code, which is then taken in by the CPU (central processing unit) 13 to perform the input processing. Specify the program.

The CPU 13 executes an input process, a document creation process, a display process, a print process, etc. in accordance with a microprogram stored in advance, and can execute a spreadsheet in this embodiment. The CPU 13 is provided with a mode register M for designating various calculation modes (vertical calculation mode, horizontal calculation mode, table tabulation mode) during table calculation. The CPU 13 has a text memory (sentence memory) 14
Is connected, and the input document data is encoded and written.

The text memory 14 is composed of a RAM (random access memory), and the writing and reading operations of data are controlled under the control of the CPU 13, and the writing or reading address is specified according to the value of the text pointer 15.

The calculation buffer 16 temporarily stores the calculation procedure read from the calculation procedure memory 20 when executing the table calculation, and the contents thereof are sent to the calculation unit 17 to execute the table calculation according to the contents of the mode register M. It The calculation result calculated by the calculation unit 17 is taken into the CPU 13 and written in the text memory 14.

The display unit 18 is composed of, for example, a CRT display device, and has a CPU 13
The display control unit 19 converts the display data output from the display drive signal into a display drive signal to display one screen of data.

The calculation procedure memory 20 stores the calculation procedure for executing the spreadsheet calculation, and horizontal calculation and vertical calculation can be defined as the calculation procedure. Further, the output position memory 21 stores an output position at which position in the table the result of the table calculation is to be written, and this output position is represented by the two-dimensional coordinates of the text memory 14. The calculation procedure written in the calculation procedure memory 20 and the output position written in the output position memory 21 are arbitrarily set by the input unit 11.These contents are fetched by the CPU 13 at the time of executing the spreadsheet and calculated. Buffer 1
Set to 6.

The coordinate memory 22 stores various coordinate position data (x
₀ , y ₀ ), (α, β), (Δα, Δβ), (A, B) are stored, and these are used when inputting a formula for executing spreadsheet calculation or when executing spreadsheet calculation. Is taken into.

Operation First, a table surrounded by ruled lines is created in the text memory 14 according to a normal key operation procedure. For example, assume that a table as shown in FIG. 2 is created in the text memory 14. In this case, there are three vertical table items and three horizontal table items. Each table item except the lower three items and the right three items is “10” and “40” above. The numerical value (calculation target) that is two-dimensionally arranged like "20" and "30" is written under ".
In the figure, (1, 1) to (3, 3) correspond to the table items from the 1st row and 1st column to the 3rd row and 3rd column, and the text memory 14
The coordinate position of is determined with the upper left end in the figure as the base point (1, 1).

Next, a case will be described in which table calculation based on the table created in the text memory 14 as described above is executed.

FIG. 3 is a flowchart which is started when the horizontal calculation key KC is operated. With the table created in the text memory 14 displayed on the display unit 18, the cursor key KE is operated to move the cursor and set it at the reference position (upper left end position in FIG. 2) of the table. When the execution key KC is operated, the coordinate position (4, 2) is transferred and stored in the coordinate memory 22 as the reference position coordinate (x ₀ , y ₀ ) (steps S1, S).
2).

After inputting the reference coordinates of the table in this manner, the formula for performing the table calculation is then input. Then, in step S3, a formula input process of writing the formula input in accordance with the operation of the cursor key KE, the numeric key KA, and the function key KD into the calculation procedure memory 20 is executed.

Now, a horizontal calculation formula in which the numerical value entered in the table item in the text memory 14 is used as a variable A + 2 × B = A: Numerical value in table item (1, 1) B: Numerical value in table item (1, 2) When is input, the contents of the calculation procedure memory 20 become as shown in FIG.

Here, the numerical value A in the table item (1, 1) is (10) and the numerical value B in the table item (1, 2) is (40), but these numerical values are input to the calculation procedure memory 20. Instead, the coordinates in the table item in which they are stored are input. The coordinate position in this case is a part of the numerical value, for example, the corresponding coordinate of the upper digit is input.

After entering the desired formula in this way, press the execution key KC.
To operate. Then, the expression input process ends, and the process proceeds to the next step S4. Here, in order to specify at which position in the table (where in the text memory 14) the operation result data obtained by performing the horizontal calculation is to be operated, the cursor key KE is operated to move the cursor to the specified position. When is moved, the cursor coordinates at this time are changed to the output position memory 21.
To be stored in memory. In addition, the cursor coordinates at this time are output position coordinates (A,
B) is transferred (step S5). FIG. 8 shows a state in which the coordinate data thus input is stored in the output position memory 21.

Then, in the next step S6, in order to start execution of the horizontal calculation, first, the data in the head address area of the calculation procedure memory 20 is read. Here, in the example of FIG. 7, the coordinate data (6, 3) is read from the calculation procedure memory 20.
Then, the process proceeds to step S7, and after the arithmetic processing according to the data read from the calculation procedure memory 20 is executed, the process returns to step S6, and the calculation processing of the formula set in the calculation procedure memory 20 is completed until all the above-mentioned operations are completed. The operation of is repeated.

FIG. 4 is a flowchart showing the specific contents of the arithmetic processing (step S7) shown in FIG. When this flow is entered, the calculation process corresponding to the data read from the calculation procedure memory 20 is proceeded to. However, since the coordinate data (6, 3) is read from the calculation procedure memory 20 in the example of FIG.
In step S7-1, this coordinate data is set as the coordinate (a, b) in the coordinate memory 22. Then, the cursor is automatically moved to the coordinate (a, B) position (step
S7-2). In this case, since the X coordinate a is the X coordinate (6) read from the calculation procedure memory 20 and the Y coordinate B is the Y coordinate (3) of the output position, the coordinates (a, B) are (6, 3). ,
In this case, the coordinates are the same as the coordinates read from the calculation procedure memory 20. After that, cursor coordinates (a, B)
All the data in the table item at the position including is read and sequentially written from the head position of the operation buffer 16 (step S7-3). Here, when reading all the data from the corresponding table item, it is performed as follows. For example, in the table of the text memory 14 as shown in FIG. 2, when the numeric variable “10” in the table item at the position including the cursor coordinates (6, 3) is taken out, the cursor coordinates (6, 3) are used. Text pointer until the left ruled line code is searched
When the X coordinate of 15 is subtracted by "1" and the ruled line code is searched, this time, the X coordinate of the text pointer 15 is incremented by "1" and the X coordinate is moved to the right. Find the beginning. Then, when the head of the data is found, the data is sequentially taken out while moving one digit to the right from the head, and the rightward movement is continued until the next ruled line code comes. As a result, all the data stored in one item can be taken out in order from the beginning. As a result, in the above formula input processing, even if you do not specify the data storage area in the table item, that is, from the beginning to the end position, you only need to specify a part of the data All data in the table item can be retrieved. In this way, the numerical variables in one table item retrieved from the text memory 14 are
It is transferred to the calculation buffer 16.

Then, returning to step S6 in FIG. 3, the output position memory 21
The data in the next address area is read from
Since the function code "+" is read in the example of the figure, the process proceeds to step S7-4 in the flow of FIG. 4, and the function code read from the calculation procedure memory 20 is loaded into the operation buffer 16. Further, next, the numerical code is read from the calculation procedure memory 20, and in this case also, step S7-4 is executed and the numerical code is taken into the operation buffer 16 as it is. Then, next, the function code “×” is read from the calculation procedure memory 20 and loaded into the operation buffer 16.

Then, at the next timing, the coordinate data (10, 3) is read from the calculation procedure memory 20, and the process proceeds to steps S7-1 to S7-3. As a result, similarly to the above, all the numeric variables “40” are read out from the corresponding table items in the text memory 14 and loaded into the operation buffer 16.

Finally, when the “=” code is read from the calculation procedure memory 20, the process proceeds to step S7-5, and the calculation based on the contents of the calculation buffer 16 is executed. That is, the calculation of 10 + 2 × 40 = 90 is performed. Then, the calculation result is written in the correspondence table item of the text memory 14 by reading the coordinates (A, B) from the coordinate memory 22. That is, the coordinates (A, B)
In the present case (13, 3), in the table item (1, 3) containing this coordinate, the calculation result "90" is calculated in order from that coordinate position.
Is written.

In this way, the calculation procedure memory is accompanied by the detection of the "=" code.
Lateral calculation according to the formula preset in 20 is executed, and the answer is written in the specified position of the text memory 14, but after that,
Since the code is not stored in the next address area of the calculation procedure memory 20, the process then returns to step S3 in FIG. 3 and the expression input state for performing the horizontal calculation for the next line is set.

Now, when performing horizontal calculation on the second line shown in Fig. 2, if the calculation formula is the same as that on the first line except for numerical variables, specify only the output position of the table that outputs the calculation result. Then, also for the horizontal calculation on the second line, the formula (FIG. 7) on the first line is automatically selected, and the result (answer) is written in the designated output position.

That is, when the horizontal calculation formula in the first line is table item (1,1) + 2 × table item (1,2) → table item (1,3), the same formula is used in the second and subsequent lines. If the horizontal calculation that was performed is to be performed, simply specify the coordinate position in the table item that outputs the answer corresponding to each line, and use the formula adopted in the first line as it is, that is, the calculation procedure memory. The contents of 20 can be used as they are without being changed, and the horizontal calculation from the second line onward can be similarly performed. Therefore, table items (2, 3),
Simply specify the coordinates in (3, 3), (5, 3), table item (2, 1) + 2 x table item (2, 2) → table item (2, 3) table item (3, 1) ) + 2 × table item (3,2) → table item (3,3) table item (5,1) + 2 × table item (5,2) → table item (5,3).

In this way, since the formula adopted in the first line can be continuously used as it is in the second and subsequent lines, in the horizontal calculation in which the same formula is continuously calculated in the row direction, the formula input operation can be simplified. This is effective because it can save the memory and save the memory. Moreover, as in the above example, the fourth line can be skipped and the fifth line can be specified. Do not depend.

On the other hand, the vertical calculation is executed almost in the same way as the horizontal calculation, so its explanation is omitted. However, the vertical calculation is different from the horizontal calculation in that the specified directions are only the difference between the vertical direction and the horizontal direction. Similarly to the horizontal calculation, the calculation can be executed based on a desired expression by arbitrarily inputting the four arithmetic operators and constants.

In addition, tabulation is a totaling process that accumulates the numbers arranged in the horizontal direction of the table, or accumulates the numbers arranged in the vertical direction, such as horizontal or vertical totaling, and totalizing the calculation results of horizontal totaling. To execute.

Next, as shown in FIG. 9, in the case where a plurality of tables of the same format are created in the text memory 14, for example, after the table calculation for the first table A is completed, this is followed by the table of the table B. When performing calculation, the recalculation key KF is operated.
Then, the operation according to the flow of FIG. 5 is executed. That is, the cursor key KE is operated to set the cursor to the reference position (upper left end position in the figure) for the table B (step S11). Then, when the execution key KC is operated, the coordinate position is transferred to the coordinate memory 22 as the reference position coordinates (α, β) in Table B (step S12). Then, in the next step S13, the difference value is obtained based on the reference position coordinates (x ₀ , y ₀ ) of the table A and the reference position coordinates (α, β) of the table B set in the coordinate memory 22, This is set in the coordinate memory 22 as the changed coordinate amount (Δα, Δβ) of the reference position. Now, for example, the reference position coordinates (x ₀ , y ₀ ) in Table A are (4,
2) If the reference position coordinates (α, β) in Table B are (18, 10), the changed coordinate amounts (Δα, Δβ) are (14, 8).

In this way, when the change amounts (Δα, Δβ) of the reference position coordinates between Table A and Table B are obtained, in the next step S14, the current set mode is determined according to the contents of the mode register M, and in accordance therewith. A horizontal calculation process (step S15), a vertical calculation process (step S16), and a tabulation process (step S17) are executed.

FIG. 6 is a flow chart for explaining the horizontal calculation processing at the time of this recalculation. Here, FIG. 6 executes the horizontal calculation corresponding to steps S6 and S7 shown in FIG. 3, and when this flow is first entered, data is read from the first address area of the calculation procedure memory 20. (Step S15-
1), processing according to the type of the data is executed. That is, when the coordinate data is read from the calculation procedure memory 20, the process of reading the numerical data from the table item designated by the coordinate data and transferring it to the calculation buffer 16 is executed (steps S15-1 to S15-4). . In this case, step S15-
3, the point that the process of correcting the coordinate data (a, b) read from the calculation procedure memory 20 by the amount of the changed coordinate (Δα, Δβ) of the reference position is performed, otherwise, step S7- in FIG. The same as 1 to S7-3. Here, the coordinate correction process is performed by adding the changed coordinate amount (Δα, Δβ) to the coordinate data (a, b) read from the calculation procedure memory 20. Now, the coordinate data (6, 3) is read from the calculation procedure memory 20, and the table A and the table B are also read.
Since the difference from the reference position coordinates of and is (14, 8), the corrected coordinates (a + Δα, b + Δβ) are (20, 11).

Further, when the function code or the numeric code is read from the calculation procedure memory 20, it is transferred to the operation buffer 16 as it is (step S15-5).

Also, when the equal code (“=”) is read from the calculation procedure memory 20, it is similar to the case of FIG. 4, but the difference is that the coordinate correction processing is also performed in this case (step S15- 6, S15-7). That is, at the output position (A, B) for writing the calculation result, the changed coordinate amount (Δα,
The correction of the output position coordinates is performed by adding Δβ). Then, in the next step S15-8, it is also determined whether or not the output position data is stored in the next address area of the output position memory 21. Here, since the output position data for the horizontal calculation of the next second line is stored in the next address area of the output position memory 21 when the horizontal calculation of the first line is completed, the process returns to step S15-1. The same horizontal calculation process is executed for the second line. Then, in step S15-8, when the end of the horizontal calculation for all rows is detected,
Get out of this flow.

Although FIG. 6 has been described for the case of horizontal calculation, the same coordinate correction processing as described above is performed for vertical calculation processing and table aggregation processing.

In this way, when multiple tables of the same format are created in the text memory 14, when the calculation for the first table is completed and the calculation for the next table is executed, operate the recalculation key KF. At the same time, only by designating the reference position coordinates in this table, the calculation contents can be used as they are without changing the stored contents of the calculation procedure memory 20 and the output position memory 21. Therefore, in such a case, it is possible to repeatedly execute the spreadsheet of the same format as many times as possible with an extremely simple operation.

[Effects of the Invention] According to the present invention, it is possible to perform arbitrary table calculation on a table displayed on a display screen at any data position, and to specify a recalculation position arbitrarily by an extremely simple operation. Then, the same form of spreadsheet can be executed again.

[Brief description of drawings]

1 to 9 show an embodiment of the present invention, FIG. 1 is a basic block circuit diagram of a Japanese word processor to which the present invention is applied, and FIG. 2 is a sentence memory 14 shown in FIG.
FIG. 3 is a diagram showing a table created in FIG. 3, FIG. 3 is a flow chart for explaining the operation when performing horizontal calculation, and FIG. 4 is a flow chart for explaining the specific contents of the arithmetic processing shown in FIG. FIG. 5 is a flow chart for explaining the operation when recalculation is performed, FIG. 6 is a flow chart for explaining the specific contents of the horizontal calculation processing at the time of executing the recalculation shown in FIG. 5, and FIG. Storage state diagram of calculation procedure memory 20, 8th
The figure is a storage state diagram of the output position memory 21, and FIG. 9 is for explaining the reference position coordinates designated corresponding to each table when a plurality of tables of the same format are created in the calculation procedure memory 20. FIG. 11 …… input section, 13 …… CPU, 14 …… text memory, 16 ……
Computation buffer, 17 ... Computation unit, 20 ... Calculation procedure memory,
22 ... Coordinate memory.

Claims (1)

[Claims] Claim: What is claimed is: 1. Display means for displaying a table on a display screen, calculation specifying means for arbitrarily specifying a calculation for a table displayed on the display screen, and display means on the display screen. In the displayed table, data position specifying means for arbitrarily specifying the data position to be subjected to the table calculation by the cursor position, data position storing means for storing this data position, and data of the table based on the data position Read
A calculation control means for executing the calculation designated by the calculation designating means based on this data, a cursor is displayed on the display screen, and a recalculation position for executing the spreadsheet is arbitrarily designated by the cursor position. Recalculation position designating means, recalculation position storage means for storing the recalculation position, the data position is changed based on the recalculation position, and the recalculation position is supported based on the changed data position. Read the data in the table to
And a recalculation control means for re-executing a spreadsheet of the same format as the calculation executed by the calculation control means.