JPS6385961A - Text processor with table calculation function - Google Patents

Abstract

PURPOSE:To efficiently prepare a table, by enabling vertical tabulation, or horizontal tabulation to be executed based on a numeric value (two-dimensional numeric value) in the table generated on a text memory, for example, in a case that a sales managing table is generated, in a word processor with table preparation function. CONSTITUTION:The text memory 14 is constituted of a RAM, and the write and the read of data is performed under control of a CPU13, and also, the write address or the read address of the memory is designated according to the value of a text pointer 15. A working RAM is formed in constitution having a P register, and a Q register, and the P register and the Q register are arithmetic registers used at time of tabulating the table. A coordinate memory 17 is a memory to store a various kinds of coordinate position data on the text memory 14, and those register and memory are used at the time of executing the calculation of the table, and are fetched in the CPU13. A display part 18 displays the data of one picture by converting a displaying data outputted from the CPU13 to a display driving signal at a display control part 19.

Description

[Detailed Description of the Invention] [Field of Industrial Application of IIe] This invention provides a word processor Kaya with a spreadsheet function that cumulatively adds up numerical values in a table created on a text memory in the vertical or horizontal direction. It relates to a text processing device.

[Summary of the Invention] This invention is capable of creating a table surrounded by M lines in one text memory.In a word processor, etc., the numbers arranged two-dimensionally in one table can be horizontally or By cumulating the total in each vertical direction and writing the cumulative value in the designated table item of the text memory, it is possible to perform vertical and horizontal totals based on the table created in the text memory.

[Prior Art] Conventionally, word processors have been put into practical use that are equipped with a tabulation unit that can create tables of any size in text memory, and this allows them to be used to create sales management tables, report cards, or estimates. Tables etc. can be easily created.

[Problems to be Solved by the Invention] However, in this type of word processor with tabulation function, when creating a sales management table, for example, it is difficult to calculate the total number of sales by product, the total amount, the total number of sales, or the total sales. The amount has to be calculated in advance using a small electronic calculator or the like, which has the disadvantage that tabulation cannot be done efficiently.

This invention was made against the background of the above-mentioned circumstances, and its purpose is to perform vertical and horizontal aggregation based on the numerical values (two-dimensional numerical values) in the table created on the text memory. An object of the present invention is to provide a text processing device with a spreadsheet function.

[Means for Solving the Problems J] Figure 1 is a block diagram of the machine part of this invention. In Figure 1, 1 is a text memory, and 2 is a list of multiple table items constituting a table created in the text memory l. A first specifying means for specifying at least two table items in order to specify the range of all table items to be subjected to calculation, and 3 a plurality of tables forming the table created in the text memory 1. A second specifying means for specifying at least one table item among the items into which the calculation result should be written; 4 specifies each table item within the range specified by the second specifying means 3 sequentially from the vertical or horizontal direction; @Calculation means 5 reads the numerical values included in the specified table items from the text memory 1 and totals them vertically or horizontally.
This is a writing means for writing the calculation result data obtained by the calculation means 4 into the table item designated by the second designation means 3.

[Function] The function of this invention will be explained. First, one sentence memory
Create a table surrounded by ruled lines, and write the numerical values to be calculated in this table.In this state, use the first specifying means 2 to select the target of calculation among each table item in the table. Specify the range of all table items to be included. In this case, for example, while looking at a table displayed on a CRT screen, the cursor is operated by operating a cursor key to position the cursor at at least the start point and end point of the range to be calculated, and the position coordinates are respectively taken in. In this way, when the range to be calculated is specified, operator stage 4 executes horizontal aggregation processing that sequentially reads and totals the numbers arranged horizontally in the table. Executes vertical aggregation processing in which numerical values arranged in the direction are sequentially read and totaled.

The calculation result data obtained in this way is stored in the writing means 5.
under the control of the second specifying means 3.

[Example] Hereinafter, this invention will be specifically described based on an example shown in FIGS. 2 to 5. Note that this embodiment shows an example in which the present invention is applied to a Japanese word processor with tabulation function.

Figure 2 is a basic block circuit diagram of this word processor. 11 in Figure 2 is the input section of this word processor. On this keyboard, there are number keys KA and letter keys K.
B. Execution +-KC1777 A button key KD, a cursor key KE, and a tabulation key KF are provided. Note that the table aggregation key KF is a key for starting execution of horizontal aggregation and vertical aggregation. Thus, the key human power signals outputted from the input unit 11 in response to the operation keys are sent to the input control unit 12 and converted into key codes, and then taken into the CPU (central processing circuit) 13. Specifies the input processing program.

The CPU 13 performs input processing, text creation processing, and display processing according to the microprogram stored in advance. etc., and in this embodiment, spreadsheet calculations (table tabulation) are also executed. A text memory 14 is connected to the CPU 13.

The text memory 14 is constituted by a RAM (random access memory), and data writing and reading operations 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 work RAM 16 controls data writing and reading operations under the control of the CPU 13, and has a P register and a Q register.
This is a register for ri.

The coordinate memory 17 stores various coordinate position data (x, y), (xo, yo), (xl, y) on the text memory 14.
+ ), (X2, 72), and (x3173), which are used when executing spreadsheets and are
Incorporated into 13.

The display unit 18 is composed of, for example, a CR7 display device,
The display data output from the CPU 13 is sent to the display control unit 1.
By converting the signal into a display drive signal at step 9, data for one screen is displayed.

To-gei First 1 Follow the normal key operation procedure to select the text memory 14.
For example, suppose that a table as shown in FIG. 3 is created in the text memory 14.

In this case, each table item that makes up the table is provided 3 vertically and 3 horizontally, and each table item except for 3 on the bottom and 3 on the right has "lO", r40J, R20 below, r
3 (H) Numerical values are written in a two-dimensional array. In Figure 1, (l, 1) to (3, 3) are the table items from the 1st row, 1st digit to the 3rd row, 3rd digit. , and the coordinate position of the one-sentence memory 14 is determined with the upper left end in the figure as the base point (l, 1).

Next, when performing tabulation based on the table in the text memory 14 created as described above, the table tabulation function -KF is operated. Then, the operation according to the flow shown in FIG. 4 starts to be executed. First, while the table created in the text memory 14 is displayed on the display section 18, operate the cursor key KE to move the cursor and set the cursor to the standard position of the table (top left position in FIG. 3). (Step 31)
When the execution key KCI is operated, the current cursor coordinates, for example (4, 2), are set in the coordinate memory 17 as the reference position coordinates (xo, yo) (step S2).

After inputting the reference position of the table in this way, the table created in the one-sentence memory 14 is then JIIIR, and the range to be tabulated is specified among the multiple table items. In this case, This is done by specifying two points, the start and end points of the target range. First, operate the cursor key KE to align the cursor with the starting point position of the target range (step S3), and then operate the execution key KC, the current cursor coordinates are stored in the coordinate memory 17 as the starting point position e! (x
i.

y+) (step S4), followed by
The cursor key KE is operated to move the cursor to the end point of the target range (step S5).

Then, when the execution key KC is operated, the current cursor coordinates are stored in the coordinate memory 17 as the end point position coordinates (X2, Vz
) (step S6).

Next, move the cursor to the output position where the calculation result is to be written in the table (step S7), and operate the execution key KC, the current cursor coordinates will be stored in the coordinate memory 17 as the output position coordinates (X3, 73 ) (step S8).

When the various coordinate input processes are completed in this way, MI aggregation and vertical aggregation are executed within the specified range. Here, in the example shown in Fig. 3, the starting point position (x+, y+
) as (6,3), the end point position n(X2,72) as (10,5), and the output position and coordinate (X3
, y3) is designated as (13, 7).

In this case, the Y coordinate of the output position is 73=7. Y of end point δ
Since the coordinate is y2=5, 73 > y in step S9
It is detected that the following relationship holds true. The process then proceeds to step 310, where the X coordinate x3 of the output position and the X coordinate x2 of the end point position are compared to determine whether the relationship X3>X2 holds. Now, X3=13,
Since X2=10, vertical aggregation processing (step 311)
is executed, and horizontal aggregation processing (step S12)
is executed, and then a process (step S13) of totalizing the horizontal totaling results is performed.

On the other hand, the output position coordinates (x3.73) are (13,5
) is specified, it becomes 13”V2, which is detected in step S9 and the process proceeds to step 314.
Then, only horizontal aggregation processing is performed. Furthermore, if (10,7) is specified as the output position coordinate (x3.72), then X3 = X2, which is detected in step S10 and the process proceeds to step 315.
Only vertical aggregation processing is performed.

Next, the above-mentioned horizontal aggregation process will be specifically explained with reference to FIG. When entering this flow, first move the cursor to the starting point position coordinates (x+, y+) (step 521).
), then all item data is read from table lookup [1 including the current cursor coordinates and transferred to the P register in the work RAM 16. p, a, now, if the starting point position coordinates (x+, y+) are (6, 3), the table item (
1,1) is read out and transferred to the P register. Here, when all data is read from table item (1, l), it is performed as follows.

First, xP! is searched from the current cursor position 6 (6, 3) until the leftward ruled line code is searched. The mark is subtracted by rlJ, and when the rightward π-line code is searched, the X coordinate is added by rlJ to move the X coordinate to the right, and the beginning of the data is found. When the beginning of the data is found, the data is sequentially taken out while moving one digit to the right from the beginning, and the movement to the right continues until the next ruled line code is reached. This allows all data recorded in one item to be retrieved in order from the beginning. therefore,
All data in a table item can be retrieved by simply specifying a part of the data without specifying the data recording area in the table item, that is, the position from the beginning to the end.

The data within the first table drawing date retrieved from the text memory 14 in this way is stored in the P register and then transferred to the Q register (step 523). As a result, the Q register contains the table items (l, Data (10) in 1) will be set.

Then, in the next step S24, the X coordinate currently on the normal line is moved one digit to the right and that coordinate is set as the current position coordinate (x, y) in the coordinate memory 17. In this case, this current The position coordinates (x, y) are (9, 3). Therefore, the X coordinate of the current position is x=9. Since the X coordinate of the end point position is x2=10, step S2
5, it is detected that x < In this case, by performing the same operation as step S22 described above, all data stored in the current specification table item (1, ?) is read out and put into the P register. It is now loaded into the P register. Now, the P register is set to (40) and the Q register is set to (10), so the next step S2
When these are accumulated in step 7 and the result is transferred to the P register, the value of the P register becomes (50). Thereafter, the process returns to step 323 to accumulate the data in the next table item. In this case, since the number of items to be horizontally totaled is (2) as shown in FIG. 3, this is detected in step 325 and the process proceeds to step 528.

In this step 528, the contents of the Q register in which the calculation result data obtained by such horizontal aggregation are set are read out and the coordinate position 21C on the text memory 14 is read out.
x3. y). In this case, the X coordinate of the output position is x3=13. Since the Y coordinate of the current position l is Y=3, the @ calculation result (50) in the Q register is the table item (1, 3
) is written sequentially starting from the coordinates (13, 3).

Then, in the next step S29, the Y coordinate of the current position and the Y coordinate of the end point position are compared.

Now, since the Y coordinate of the current position is yz=3 and the Y coordinate of the end point position is y2=5, a line feed process (step 530) is performed in order to move on to the next horizontal aggregation process. Here, as shown in Figure 3, each table item has the size of two lines in the vertical direction, so the Y coordinate of the current position is plus "
2" increment processing is executed. As a result, in the present case, y=5. Then, in the next step S31, the cursor is moved to the coordinates (x+, y). Now, the X coordinate of the starting point position is x1=6, and the Y coordinate of the current position is
Since the coordinates are V=5, the cursor is at the coordinates (6, 5)
It will move to position t. When the cursor is moved to the coordinate position 21 (6, 5) in the table item (2, l) on the second line in this way, the process returns to step S22 and the table item (
Data (20) is read from 2, 1) and transferred to the P register. Then, the same process as described in 1 above is executed, and the horizontal total value (50) in the 2nd row is obtained and written into the 2nd table entry (2, 3).

When the horizontal aggregation for the second row is completed in this way, the Y coordinate of the current position is y=2. Since the Y coordinate of the end point position y2=2, this is detected in step 529, and the horizontal totalization is thereby completed.

On the other hand, although the flowchart for vertical aggregation is omitted from illustration, the vertical calculation is basically the same as the horizontal calculation, with the only difference being the processing direction of up and down and left and right compared to the horizontal calculation.

In this way, in this embodiment, when performing table aggregation, it is possible to perform table aggregation within the desired range by simply specifying the coordinate positions of three points, and the calculation results can also be written to the desired position. Therefore, a variety of tabulations can be performed with simple operations.

In the embodiment described above, the totalization process of summing up the results of horizontal aggregation is executed at the end of the spreadsheet calculation, but the results of vertical aggregation may also be cumulated.

[Effect of the invention] As explained in detail above, this invention stores M! in one sentence memory. It is possible to create a table surrounded by l.Using a powerful word processor, etc., the numbers arranged two-dimensionally in the table are totaled horizontally or vertically within a pre-specified range, and the cumulative value is added to the specified table in the text memory. Since the data is written within the specified date, it is possible to perform vertical and horizontal aggregation based on the table created in the text memory. In addition, it is possible to perform table aggregation in a desired range by specifying at least three points, and it is also possible to write the calculation results in a desired position, which has the effect of making it possible to perform a wide variety of table aggregation.

[Brief explanation of the drawing]

FIG. 1 is a block diagram of this invention, FIGS. 2 to 5 show an embodiment of this invention, FIG. 2 is a basic block circuit diagram of a word processor to which this invention is applied, and FIG. is a diagram showing the table created in the text memory 14 shown in Fig. 2, Fig. 4 is a flowchart for explaining the overall operation of spreadsheet processing, and Fig. 5 is a horizontal aggregation shown in Fig. 4. It is a flowchart for explaining the specific contents of processing. 11...Input section, 13...CPU, 1
4...statement, 6 memory, 16...work RAM, 17...coordinate memory. Patent applicant Casio Computer Co., Ltd. Agent Patent attorney Machi 1) Tadashi Toshi Figure 1 Figure 2

Claims (1)

[Scope of Claim] In a text processing device equipped with a tabulation function that creates a table surrounded by ruled lines in a text memory, there is provided a text processing device that includes a tabulation function that creates a table surrounded by ruled lines in a text memory, a first specifying means for specifying at least two table items in order to specify the range of all table items to be targeted; a second specifying means for specifying at least one table item to be written, and sequentially specifying each table item within the range specified by the second specifying means from the vertical direction or the horizontal direction, and the specified table item. a calculation means for reading the included numerical values from the text memory and summing them vertically or horizontally, and writing the calculation result data obtained by the calculation means into the table item specified by the second specification means. 1. A text processing device with a spreadsheet function, characterized by comprising a writing means.