JPH0429106B2 - - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION The present invention relates to a word processor, and in particular, to a word processor that is equipped with a tabulation function, so that it can automatically calculate numerical values in a table, display the calculation results in a predetermined column, and print them out. This paper proposes a word processor based on the following features.

Tables containing numerical information are often included in office documents. For this reason, word processors are equipped with a tabulation function, but the draft of this table is rarely completed when inputting into a word processor; rather, the table is completed at the same time as input. In other words, there are many cases where the text and numbers in the table are entered. Word processors are often used to create standard documents.For example, a general-purpose form such as a quotation form is created in advance, and the product name field in the quotation details table is prepared in this general-purpose form for each inquiry case. , quantity field, unit price field, amount field, etc., are generally filled in by additional input. Therefore, it is necessary to calculate and input some fields, which may prevent the user from enjoying the advantage of quickly creating documents using a word processor.

The present invention utilizes the data processing ability of a word processor for the above calculations to automatically display or print the calculation results in a table, and also to display operators on specific lines. To provide a word processor capable of speeding up document creation by instantly performing accurate calculations and tabulations without causing calculation instruction errors.

The present invention will be specifically explained below with reference to 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 keyboard with a JIS layout, 2 is a control unit including a CPU, 3 is various memories for storing control programs, input text storage, dictionary units, etc., 4 is a CRT, and 5 is a printer.

The input from the keyboard 1 or the text entered in Roman letters is sent to the control unit 2 by referring to the data in the memory 3.
The data is converted into text data containing kanji and stored in the text memory that constitutes the memory 3, and is also displayed on the CRT 4. This text can then be printed to the printer by giving a print command.
The data is printed on a floppy disk provided as an external memory in the memory 3, so that it can be used for subsequent printing.

This word processor has a tabulation function, but it is not just a simple function; it can draw vertical and horizontal ruled lines, and block editing can be performed within each column (frame) of the table formed by these ruled lines. (In other words, when the input characters reach the right end of each column, a line break is made to the left end within the same column).

The operation procedure for drawing ruled lines is as follows. That is, first, the cursor is moved to the position on the CRT 4 screen where the starting end of the ruled line should be, and the ruled line key 111 is pressed. The control unit 2 executes a predetermined screen editing program based on this keystroke signal, and displays a pattern to guide the selection of the type of ruled line (thin line, thick line, double line, broken line, etc.). .
By performing the necessary selection operation (pressing the numeric keypad 112 corresponding to the desired ruled line), the corresponding type of ruled line is displayed at the cursor position. Next, while pressing down the control key 113, the operator presses one of the four cursor movement keys 114 for moving the cursor in a desired direction. This allows you to freely draw vertical or horizontal ruled lines. To delete or modify a ruled line, place the cursor at the top (or left) end of the vertical (or horizontal) ruled line you wish to delete and press the delete key 118. After moving the cursor to the bottom (or right) end of the part desired to be deleted, the user presses the execution key 115. This causes the corresponding portion to be deleted.

The code for displaying or printing such ruled lines is
It is a 16-bit 4-digit binary coded hexadecimal notation code, and a font for displaying or printing ruled lines is assigned to each code. The upper 8 bits of the 16-bit data indicate a ruled line code, and the lower 4 bits specify the font pattern. In this example, the printing font is composed of a 32 x 32 dot matrix, and the CRT screen display font is composed of a 24 x 24 dot matrix, but in the case of the ruled line font, only a very limited portion of these matrices is used. is used. That is, as shown schematically 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 region 33 extending rightward. This is the area 34 indicating the ruled line part, and the ruled line information (none, thin line, double line, thick line) for each area is assigned to two bits each from the upper side of the lower eight bits of the above 16-bit code. be. This is represented by no ruled line: 00, thin line: 01, double line: 10, and thick line: 11, so if the lower 8 bits are 00000000, there is no ruled line in that part, and 00000101 is the font as shown in Figure 3 B. A horizontal thin line extending the entire width on the left and right,
00000001 is a horizontal thin line that appears only in the right half of the font (a broken line is drawn as a continuation of this) as shown in Figure 3 C, 11111111 is the thick cross section as shown in Figure 3 D, and 10100000 is the third As shown in Figure E, this becomes a double line extending in the entire vertical direction of the font. Therefore, from the code written in the text memory, it is possible to identify that the display content corresponding to the code is a ruled line (based on the upper 8 bits) and the type of ruled line (based on the lower 8 bits).

Now, assume that the operations described above have been performed to draw ruled lines as shown in FIG. 4, and to write the required characters and numerical values in each column. The operation of the control unit 2 in the case of normal text input including such a tabulation is called the editing mode, but the operation of the control unit 2 to perform calculation processing according to the present invention, that is, the calculation mode and the editing mode. The relationship is as shown in FIGS. 5 and 8. The processing operations of the control unit 2 will be explained below based on FIGS. 5 and 8 and FIG. 6 showing the screen of the CRT 4 that changes according to key operations.

First, in rows (horizontal columns) that require vertical calculation (total calculation of numbers in the same column), such as the amount total column, press the key to display a line type mark outside the table on the left side of the corresponding row. I'll keep it.

There are three line types: subtotal mark, total mark, and exclusion mark. After moving the cursor to the position where you want it to be displayed,
Press the character keys 117 S, G, and J while holding down the control key 113 (however, press the alphanumeric key 118 in advance)
This will cause the required mark to be displayed.

The subtotal mark is the fourth row position where the total for the row above that row or the total for the row above the subtotal mark and below the upper subtotal mark closest to the subtotal mark is written. In the example shown in the figure, they are displayed in the A total and B total rows. The total is displayed in the row position where the total for the row of the subtotal mark is written, and in the diameter of FIG. 4, it is displayed in the row of the grand total. Exclusion marks are also displayed on lines to be excluded from vertical and horizontal calculations.

Next, as shown in FIG. 4, the cursor K is positioned on the left shoulder of the table to be calculated, and the calculation key 116 is pressed. This causes the control section 2 to enter operation in calculation mode. The control unit 2 specifies the table to be calculated from the code contents of the text memory corresponding to the cursor position. In other words, at the shoulder of the table, the lower 8 bits of the code related to the ruled line in this area are b ₇ , b ₆ ,
Of b ₅ , b ₄ , b ₃ , b ₂ , b ₁ , b ₀ , two bits (b ₅ , b ₄ ) indicate the downward ruled line, and (b ₁ , b _{0 )} indicate the rightward ruled line. ) are both not 00 (that is, a thin line, double line, or thick line will be displayed), and the remaining 4 bits b ₇ , b ₆ , b ₃ ,
Since _b2 is 00 (no line appears), the table is identified by detecting this code. Therefore, the portion of this table that does not appear on the screen is also recognized as part of the same table, and the following operations are performed in the same way by scrolling the screen. Also, calculations are performed regardless of whether the screen is displayed or not.

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

The control unit 2 enters the operator specification mode, which is the first step in the calculation mode, and displays the screen of the CRT 4 at the sixth step.
As shown in Figure A, the display of letters and numbers in the next line of the header section 35 (however, if there is a line with an exclusion mark, the topmost line without an exclusion mark) is reduced,
A display prompting you to proceed with the operation of specifying an operator is displayed in the column of this line (in the drawing, the vertical ruled line portion is represented by a double thick line), and a predetermined guide message is also displayed. Cursor K is the first one in the leftmost column.
be placed on a girder. Depending on the position of the cursor K when the calculation key 116 is pressed, the control unit can easily specify the second row of the table and the vertical ruled line dividing it horizontally using a ruled line code or the like. Note that although it is assumed that a header section exists in a table, the presence or absence of a header section may be specified so that calculations can be performed on a table without a header section.

Next, specify the operator using the + key 1171, =,
- key 1172, ≦ key 1173, and / key 1174. In Figure 6 A, calculate the product of quantity and unit price, and display the amount of this product in the amount column.
To print, specify + in the quantity column, 〓 in the unit price column, and = in the amount column. To move from the operator specification for the - column to the next column, press the tab key 11
9. The product of the present invention calculates subtotals and totals for columns containing +, -, and = in the rows with each mark, so it is necessary to take this into account when specifying operators. Since a sum is required, + is designated in that column so that this is a multiplicand that is processed substantially in the same way as the summand during addition.

After specifying the operator in this way, when the execution key 115 is pressed, the control unit 2 receives this and then shifts to the editor specification mode, displays a predetermined guide message as shown in FIG. The second column in which the editor described below should be entered first.
Make the vertical ruled line of the first row a double thick line.

The editor specifies the notation method for the results related to vertical or horizontal calculations, and numerical values are keyed in by N of the character keys 117 for the estimated maximum number of digits. In the example in Figure 6, 3 digits is sufficient, so
Key in NNN. If you input character data such as ¥, % pieces, book, etc. before or after N input for numerical data, and if you input scale value between N, enter those characters and symbols along with the calculation result. will be displayed and printed. In this embodiment, a half-width key 120 is provided to enable the input of half-width characters, and by inputting the half-width character N, it is possible to display, for example, half-width numbers below the decimal point. In addition, if an overflow situation occurs in which the number of digits in the calculation result is larger than the number of N inputs, when you instruct the calculation to be executed as described later, display 〓 for the number of N in the corresponding column and retry N. Confirm the input.

After entering three N's in the quantity field, press the tab key 1
When key 19 is pressed (FIG. 6B shows this state), the unit price column, which is unrelated to displaying and printing the calculation results, is skipped and a double thick line moves to the amount column. When the execution key 115 is pressed after keying in the required N, letters, and symbols in this field to create the state shown in Fig. 6 (c), the control unit 2 enters the batch calculation mode and calculates vertically and horizontally according to the specified operator. Execute the calculation, and display and print according to the specified editor. In this case, even when non-numeric values such as ¥, yen, pieces, etc. are shown in the column, the numerical data is of course calculated regardless of these. FIG. 6D shows the results, but as described above, lines marked with exclusion marks are not subject to calculation. Upon completion of the calculation, the control section returns from the calculation mode to the editing mode.

As shown in FIG. 5, when the execution key 115 is pressed while the cursor K is on the leftmost ruled line after specifying the editor, the control unit 2 enters the sequential calculation mode and calculates one line. The result of the horizontal calculation for that row is displayed and printed in the column where the operator is =. The cursor is positioned on the leftmost ruled line of the next line and waits for the next execution key 115 to be pressed. Needless to say, when the execution key 115 is pressed, the horizontal calculation for that row is performed.

In such a sequential calculation mode, it is possible to proceed with the input work while checking the calculation results for each line. It is also possible to switch to batch calculation mode after confirming the first row.

Now, if a specification error is made when specifying an operator or editor as described above, or if the cancel key 121 is pressed in operator specification mode, editor specification mode, or sequential calculation mode, the input mode is entered and the cursor is It is positioned on the leftmost ruled line, and a predetermined error message is displayed.

The control unit 2 returns from the input mode to the operator specification mode by pressing ↑, ↓, and → of the cursor movement keys 114. In the case of the above-mentioned specification error, the cursor is moved up or down or to the right in order to make a correction input, so the edit mode is essentially automatically returned to. Further, the control section 2 returns to the editing mode by pressing the end key 122. Therefore, if the user wants to end the calculation, he or she can press the end key 122 and return to normal document creation.

Note that when printing documents, it is preferable not to print unnecessary line type marks, subtotals, etc.

As mentioned above, in this embodiment, the table to be calculated can be specified simply by positioning the cursor on the left shoulder of the table, so there is no trouble at all.

Even if the table itself is not complete, that is, there is a possibility of extension to the right side or bottom of the table, and the borders at the right and bottom edges have not yet been drawn, the left shoulder of the table is completed. There is no problem in specifying tables, there is no problem in performing calculations, and there are advantages such as a high degree of freedom in operation.

By the way, with reference to FIG. 7, the specification of horizontal calculations using operators will be explained. The example shown in FIG. 7 is an example of five columns consisting of columns A to E. The example shown in the first and second lines of FIG. 5 concerns only addition and subtraction. The examples shown in the third and fourth lines are related to multiplication and division.
A constant is allowed to be added to the column having the = key, and the value obtained by adding 10 to the sum of columns A to C is displayed and printed in column D of the fifth row. The value obtained by subtracting 10 from the sum of columns A and B is displayed and printed in column C of the 6th row. The seventh and eighth lines 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 calculations are performed for columns A, C, and E. In addition,
The operator in this case may be + or =.

By the way, in the present invention, for each of one or more columns in a table partitioned by vertical ruled lines, operations such as addition, subtraction, multiplication, and division that are common when horizontally calculating numerical data in each row in the same column are performed. 1 operator (+, -,
x, /), a means for specifying a specified column in which the calculation result of this horizontal calculation is to be displayed using a second operator (=), a means for displaying the specified operator in a specific line, and a means for specifying this specification. Perform a calculation based on the operator on the specific row, and
Execution means for executing the same calculation based on the operator without adding the operator to the calculation target rows after the specific row, and means for displaying or printing the calculation result in the specified column in the table. We are prepared.

Therefore, in the present invention, when creating office documents, which is the main use of word processors, not only can calculation values in tables, which are often required, be completely automatically entered, but also common calculations for multiple lines can be performed completely automatically. In this case, there is no need to specify an operator for each line, which simplifies the input operation.

The present invention can also be applied to a Japanese word processor or a Roman word processor equipped with a full character layout tablet type keyboard.

[Brief explanation of drawings]

1 is a block diagram schematically showing the configuration of the product of the present invention, FIG. 2 is a keyboard layout diagram, FIG. FIG. 5 is an explanatory diagram showing an outline of the processing mode of the control unit; FIGS. 6A to 6D are explanatory diagrams showing screens in calculation mode; FIG. FIG. 8 is a diagram showing a flowchart. 1...Keyboard, 2...Control unit, 3...Memory, 4...CRT, 5...Printer.

Claims (1)

[Claims] 1. Addition, subtraction, multiplication, division, etc. that are common when performing horizontal calculations on numerical data in each row in the same column for one or more columns in a table partitioned by vertical ruled lines. A means for specifying a first operator (+, -, ×, /) and a specified column for displaying the calculation result of this horizontal calculation using a second operator (=); a means for displaying on a specific line, a calculation based on the specified operator on the specific line, and a means for displaying the specified operator on the specified line and subsequent lines for the operation even if the operator is not attached. 1. A word processor, comprising: execution means for executing the same calculation based on the table; and means for displaying or printing the calculation result in the designated column in the table. 2. The word processor according to claim 1, wherein the display of the operator on the specific line is executed only in a predetermined mode. 3. The word processor according to claim 1, wherein a constant can be added to the specified column in which the second operator (=) is specified. 4. The word processor according to claim 1, which allows specification of exclusion of the horizontal calculation among a plurality of lines.