JPH0656606B2 - Word processor - Google Patents

Description

The present invention relates to word processors.

Tables containing numerical information are often described in office documents.

Therefore, the word processor is equipped with a tabulation function.

Then, in a simple word processor, for example, it is necessary to enter numerical values in all columns such as a product name column, a quantity column, a unit price column, and an amount column in a quotation statement prepared or prepared.

Therefore, it is conceivable to automatically calculate a numerical value and display or print the calculation result at a predetermined position.

Note that such automatic calculation and display is well known as shown in JP-A-56-155441 (G06F3 / 14) and the like.

By the way, a subtotal column and a total column may exist in the columns in the table.

The present application provides a word processor in which the operation work for the operator is reduced when automatic calculation is performed in a table including a subtotal column and a total column.

The present invention will be specifically described below with reference to the drawings showing an embodiment of a Japanese word processor.

FIG. 1 is a block diagram showing a schematic configuration of a Japanese word processor according to the present invention, and FIG. 2 is a keyboard layout diagram. In the figure, 1 is a JIS layout keyboard, 2 is a CPU
Is a control unit including 3 and various memories for storing a control program, storing an input sentence, a dictionary, and the like, 4 is a CRT, and 5 is a printer.

The text input from the keyboard 1 or kana or romaji is referred to the data in the memory 3 and converted into the text data mixed with kanji by the control unit 2 and stored in the text memory forming the memory 3 and displayed on the CRT 4. Will be done. Then, this sentence is printed by the printer 5 by giving a print command and stored in a floppy disk provided as an external memory of the memory 3 so that it can be used for subsequent printing.

Although this word processor has a tabulation function, it can draw vertical and horizontal ruled lines instead of just a tab function. In each column (frame) of the table formed by these ruled lines, block editing ( In other words, when the input characters reach the right end of each column, a line feed is made to the left end in the same column).

The operation means for drawing ruled lines is as follows. That is, first, the cursor is moved to a position on the CRT4 screen that should be the start of the ruled line, and the "ruled line" key 111 is pressed. The control unit 2 executes a predetermined screen editing program in response to this keystroke signal, and the type of ruled line (fine line, thick line, double line, broken line, etc.)
In order to select, the pattern for guiding this is displayed. A ruled line of the corresponding type is displayed at the cursor position by the required operation for selection (keystroke 112 corresponding to a predetermined ruled line). Then the operator presses the "control" key 11
While holding down 3, press one of the four cursor movement keys 114
Hit the key to move the cursor in the desired direction. As a result, vertical or horizontal ruled lines can be freely drawn. To delete and correct the ruled line, position the cursor on the upper (or left) edge of the vertical (or horizontal) ruled line you want to delete and press the delete key 118
Type the key. Then, after moving the cursor to the lower (or right) end of the portion desired to be deleted, the "execute" key 115 is pressed. As a result, the corresponding part is deleted.

The code relating to the display or printing of such ruled lines is a 16-bit 4-digit binary hexadecimal notation code, and a font for displaying ruled lines or printing ruled lines is assigned to each code. Of the 16-bit data, the upper 8 bits indicate the ruled line code, and the lower 4 bits specify the font pattern. In this embodiment, the printing font is 32 × 32, and C
The RT screen display fonts are each composed of 24 × 24 dot marix, but in the case of ruled line fonts, an extremely limited part of these matrices is used. That is, as schematically shown in FIG. 3A, a region 31 showing a ruled line portion extending upward from the center, a region 32 showing a ruled line portion extending downward, a region 33 showing a ruled line portion extending leftward, and a rightward direction. This is the area 34 that indicates the ruled line portion extending to, but the ruled line information (none, thin line, double line, thick line) of each area is divided into 2 bits each from the upper 8 bits of the lower 8 bits of the 16-bit code. Allocated. And without the ruled line: 00, thin line: 01, double line: 10, thick line: 11, so the lower 8 bits are 00000000, there is no ruled line in that part, 0000
0101 is a horizontal thin line extending over the entire width of the font as shown in FIG. 3 (b), and 00000001 is a horizontal thin line appearing only in the right half of the font as shown in FIG. 11111111 is a bold cross intersection as shown in FIG. 3 (d), and 10100000 is a double line extending in the entire vertical direction of the font as shown in FIG. 3 (e). Therefore, from the code written in the text memory, it can be identified that the display content corresponding to the code is a ruled line (by the upper 8 bits) and the type of the ruled line (by the lower 8 bits).

Now, it is assumed that a ruled line is drawn as shown in FIG. 4 by the above-mentioned operation, and the required characters and numerical values are written in the respective columns. The operation of the control unit 2 in the case of a normal text input including such a tabulation is called an edit mode. The operation of the control unit 2 that should perform the calculation process according to the present invention, that is, the calculation mode and the edit mode. The relationship is as shown in FIG. The CRT that changes according to the key operation shown in Fig. 5 below.
The processing operation of the control unit 2 will be described based on FIG. 6 showing the screen of FIG.

First, in the row (horizontal column) that requires vertical calculation (total calculation of numerical values in the same column) such as the total amount column, press the key to display the line type mark on the left side table element of the corresponding line. Operate.

Three types of line types are available: "subtotal" mark, "total" mark, and "exclude" mark. After moving the cursor to the position to be displayed, press the "Control" key 113 respectively. Character key 117 "S",
Type "G" and "J" respectively (note that alphanumeric key 11
Press 8) to display the required mark.

The "subtotal" mark indicates the total for the lines above it or for the line above the "subtotal" mark and below the closest subtotal mark to the "subtotal" mark. The line positions to be displayed, in the example of FIG. 4, are displayed in the lines of A total and B total. The "total" is displayed at the line position where the total for the line of the "subtotal" mark is entered, that is, the total line in the example of FIG. Also, the "exclude" mark is displayed on the lines excluded from the vertical and horizontal calculations.

Then, as shown in FIG. 4, the cursor K is positioned on the left shoulder of the table to be calculated, and the "calculate" key 116 is pressed. As a result, the control unit 2 enters the operation in the calculation mode. The control unit 2 identifies the table to be calculated from the code contents of the text memory corresponding to the cursor position. That is, in the shoulder portion of the table, the lower 8 bits b of the code relating to the ruled line of this portion b
_{7, b 6, b 5,} b 4, b 3, showing a b _2, b _1, 2 bit and borders to the right in b indicate the borders of the out under the direction of _{0 (b 5, b 4)} ( Both 2 bits of b ₁ and b ₀ are not 00 (that is, a thin line, a double line or a thick line is, for example, , The remaining 4 bits b ₇ , b ₆ ,
Since b ₃ and b ₂ are 00 (the line does not appear), the table is specified by detecting this code. Therefore, a portion of the table that does not appear on the screen is also recognized as a part of the same table, and the following operations are similarly performed by scrolling the screen. The calculation is performed regardless of whether it is displayed on the screen.

When the code stored in the text memory corresponding to the cursor position does not satisfy the above condition, a predetermined error message is displayed.

The control unit 2 enters the operator designation mode which is the first step of the calculation mode, and the screen of the CRT 4 is displayed on the next line of the header unit 35 (however, the line marked with "exclusion" is The top line without the "exclude" mark, if any),
A display prompting to erase the display of the numbers and proceed with the operation for designating the operator in the column of this line (in the drawing, the vertical ruled line portion 2
(Represented by a heavy line) and a predetermined guide message is displayed. The cursor K is located at the first digit in the leftmost column. The "calculation" key 116 allows the control unit to easily identify the second line of the table and the vertical ruled line that divides it horizontally by using a ruled line code or the like depending on the position of the cursor K when the key is pressed. Although it is assumed that the table has a header portion, the presence / absence of the header portion may be designated so that the calculation can be performed for the table without the header portion.

Next, to specify the operator, press the "+" key 1171, This is performed by the "*" key 1173 and the "/" key 1174. In Fig. 6 (a), the product of the quantity and unit price is calculated, and the amount of this product is displayed and printed in the amount column, + is displayed in the quantity column, * in the unit price column, and = in the amount column. specify. The “tab” key 119 is used to instruct the movement from the operator designation for the − column to the adjacent column. Since the product of the present invention can calculate the subtotal and the total for the columns containing +,-, = in the row having each mark, it is necessary to take that into consideration when designating the operator, and the total quantity is also required in the above example. Therefore, in order to make this a multiplicand processed in substantially the same way as the augend at the time of addition, + is specified in the column.

After specifying the operator in this way, the "Execute" key 115
When the key is pressed, the control unit 2 receives this and then shifts to the edit designation mode to display a predetermined guide message as shown in Fig. 6 (b), and the editor to be described next should be input first. The vertical ruled line in the second row of the column is a double thick line.

The editor is for designating the notation method of the result related to the vertical or horizontal calculation, and the numerical value is keyed in by the N among the character keys 117 by the designated maximum digit number. In the example of FIG. 6, three digits are enough, so NNN is keyed in. When inputting character data such as \ or%, piece, book, etc. before and after N input for such numerical data, and when inputting scale between N, those characters and symbols are also added according to the calculation result. Will also be displayed and printed. In this embodiment, the half-width key 120
Is provided so that half-width characters can be input. By inputting N half-width characters, for example, it is possible to display with a half-width number after the decimal point. If an overflow condition occurs in which the number of digits of the calculation result is larger than the number of N's input, when the execution of the calculation is instructed as described later, * is displayed in the corresponding column for the number of N Complete the input.

If you press the "Tab" key 119 after entering three N's in the quantity column [Fig. 6 (b) shows this state], skip the unit price column that is irrelevant to the display of calculation results and display the amount column. The double bold line moves to. When the required N, letters, and symbols are also keyed in to this column to bring them to the state of FIG. 6 (c), when the "execute" key 115 is pressed, the control unit 2 enters the batch calculation mode and vertically according to the specified operator. , Horizontal calculation is performed, and display and print are performed according to the specified editor. In this case, it is needless to say that numerical data is calculated irrespective of these even when non-numerical values such as ¥, yen, and individual are shown in the column. Figure 6 (d) shows the result, but "Excluded"
As mentioned above, the marked lines are not included in the calculation. Upon completion of the calculation, the control unit returns from the calculation mode to the edit mode.

Then, as shown in FIG. 5, after the editor has been designated, the cursor K is on the ruled line at the left end, and the "execute" key 115
When the key is pressed, the control unit 2 enters the sequential calculation mode, performs one-digit calculation, and displays and prints the result of the horizontal calculation of the row in the column of the column where the operator is =. The cursor is positioned on the leftmost ruled line of the next line and is in a state of waiting for the next execution of the "execute" key 115. It goes without saying that the horizontal calculation of the line is performed by pressing the "execute" key 115.

In the case of such a sequential calculation mode, the input work can be carried out while confirming the calculation result for each line. It is also possible to switch to the batch calculation mode after checking the first line.

By the way, if there is a mistake in the designation of the operator or editor as described above, or if the "Cancel" key 121 is pressed in the operator designation mode, the editor designation mode or the sequential calculation mode, the input mode is entered, The cursor will be positioned on the leftmost ruled line and a predetermined error message will be displayed.

The control unit 2 selects “↑” or “↓” from the cursor movement keys 114.
By pressing the "→" key, the input mode is returned to the operator designation mode. In the case of the above-mentioned designation error, the cursor is not moved up or down or rightward as a correction input, so that the edit mode is substantially automatically returned. Further, the control unit 2 returns to the edit mode by pressing the "end" key 122. Therefore, when it is desired to end the calculation, the "end" key 122 is pressed to return to normal document creation.

When printing a document, it is preferable not to print line type marks such as "subtotal" that are not particularly necessary.

Now, with reference to FIG. 7, designation of calculation by an operator will be described. The examples shown in the first and second lines of FIG. 7 relate only to addition and subtraction. The examples shown in the third and fourth lines relate to multiplication and division. =
For fields with keys, constants can be added,
A value obtained by adding 10 to the sum of columns A to C is displayed and printed in the D column of the fifth row. The value obtained by subtracting 10 from the sum of the A and B columns is displayed and printed in the C column of the sixth row. Lines 7 and 8 show examples of constant division (average calculation) and multiplication (100-percentage calculation). Note that the example in the ninth row shows an example in which only vertical calculation is performed for columns A, C, and E. The operator in this case may be + or =.

As is apparent from the above description, the word processor of the present invention has the number 1 in the table in which columns are divided by vertical ruled lines.
Or, for each of a plurality of columns, the first operator (+, −, ×, ÷) such as addition, subtraction, multiplication, division, etc., which is common when horizontally calculating the numerical data of each row in the same column, is specified, and A means for designating a designated column to display or print this lateral calculation result with the second operator (=), a means for displaying the designated operator on a specific line, and a specification for designating a predetermined operator. A means to specify the row to display or print the subtotal calculation result of multiple rows of numerical data for a column, and a means to specify the row to display or print the total calculation result obtained by adding the subcalculation results of the same column And a means for displaying a small calculation mark on the line displaying or printing the subtotal calculation result and a total calculation mark on the line displaying the total calculation result, and the calculation based on the specified operator for each line. Run every Means for calculating the subtotal of the numerical data of a plurality of lines up to the line where the check mark is displayed, and performing the calculation for summing the obtained subtotals for each of the specific columns, the specified column in the table, and the specified line And a means for displaying or printing the calculation result in the specific column.

That is, according to the present invention, when the calculation of the subtotal and the calculation of the total of the small calculation results are designated, the small calculation mark and the total calculation mark are displayed, so that the subtotal and the total are calculated. There is no fear of entering a wrong number in a line.

The present invention can also be applied to a Japanese word processor or a European word processor equipped with an all character arrangement tablet type keyboard.

[Brief description of drawings]

FIG. 1 is a block diagram schematically showing the configuration of the product of the present invention, FIG. 2 is a keyboard layout diagram, FIGS. 3 (a) to (e) are explanatory diagrams of ruled line fonts, and FIG. 4 is an example of a table. FIG. 5 is an explanatory view showing an outline of a processing mode of the control unit, FIGS. 6 (a) to 6 (d) are explanatory views showing a screen in the calculation mode, and FIG. 7 is an example of an operator. It is explanatory drawing which shows and its function. 1 ... keyboard, 2 ... control unit, 3 ... memory, 4 ... CR
T, 5 ... Printer.

 ─────────────────────────────────────────────────── ─── Continuation of the front page (56) References JP-A-47-13843 (JP, A) JP-A-56-155441 (JP, A) JP-A-57-191769 (JP, A) JP-A-58- 189760 (JP, A)

Claims (1)

[Claims] 1. A first addition, subtraction, multiplication, division, etc. common to one or a plurality of columns in a table in which columns are divided by vertical ruled lines, when the numerical data of each row in the same column is horizontally calculated. Specify the operator (+,-, ×, ÷), and specify the specified operator to display or print this horizontal calculation result with the second operator (=) and the specified operator. The method of displaying in the row of, the method of specifying the row for displaying or printing the calculation result of the subtotal of the numerical data of multiple rows for the specific column for which the predetermined operator is specified, and the small calculation result of the same column are combined. A means to specify the row to display or print the total calculation result in the corresponding column, and a small calculation mark on the row to display or print the total calculation result, and the total calculation to the row to display or print the total calculation result Means to display the mark and the specified calculation Perform calculations based on each row,
A means for calculating a subtotal of numerical data of a plurality of lines up to the line where the small calculation output mark is displayed, and performing a calculation for summing the obtained subtotals for each of the specific columns, a designated column in the table, and And a means for displaying or printing the calculation result in a specific column of the designated row.