JPH0340061A - Word processor - Google Patents

Abstract

PURPOSE:To generate the document at a high speed by designating an operator being common to numerical data of each line in the same train to the respective trains in a table, designating an arbitrary line from a calculation based on this operator, executing a calculation based on this operator at every line except this line, and displaying or printing a result of calculation to a designated train in the table. CONSTITUTION:A control part enters into an operator designation mode, curtails the display of a character and a numeral of the next line of a header part, executes the display for urging to advance an operation for designating an operator to a column of this line, and also, displays a prescribed guide message. Also, the subject processor is provided with a means for designating an operator being common to numerical data of each line of the same train with respect to one or plural trains, respectively in a table, a means for displaying the designated operator in a specific line, a means for designating to exclude arbitrarily a line from a calculation based on the operator, and a means for executing the calculation based on the operator at every line except the designated line and displaying or printing a result of calculation to the designated train in the table. In such a way, a quick generation of a document can be realized.

Description

[Detailed description of the invention] The present invention relates to a word processor, and in particular, to a word processor equipped with a tabulation function, which automatically calculates numerical values in a table, displays the calculation results in a predetermined column, and prints the results. It proposes a word processor.

Tables containing numerical information are often included in office documents. For this purpose, 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 many cases, text and numbers 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 for each inquiry, the product name column and quantity in the quotation details table are prepared in this general-purpose form. It is common to fill in columns, unit price columns, amount columns, etc. with 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, and also automatically displays or prints the calculation results in a table to instantly perform accurate calculations and tabulations to create documents. The purpose of this invention is to provide a word processor that achieves high speed.

The present invention will be specifically explained below based on 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 control section including a CPU, 3 is various types of memory for storing control programs, input sentences, dictionary sections, etc., 4 is a CRT, and 5 is a printer.

Sentences input in kana or romaji from the keyboard 1 are converted into data containing kanji in the control unit 2 by referring to the data in the memory 3, and stored in the text memory at the bottom of the memory 3, and then transferred to the CRT 4. It will be displayed. Then, by giving a print command, this text is printed by the printer 5 and stored in 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 tab function, it can also remove vertical and horizontal ruled lines, and block editing ( In other words, when the input characters reach the right end of each column, a line break is made to the left end of the same column.

The operation means 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. Control unit 2
uses this keystroke signal to advance a predetermined screen editing program and displays a pattern to guide the selection of the type of ruled line (thin line, thick line, double line, broken line, etc.).

Required operations for selection (numeric keypad 1 corresponding to the specified ruled line)
12 keystrokes) to display the corresponding type of ruled line at the cursor position. Next, the operator presses the "control" key 113
While pressing , press one of the four cursor movement keys 114 to move the cursor in the desired direction. This allows you to freely draw vertical or horizontal ruled lines. To delete or correct a ruled line, place the cursor at the top (or left) end of the vertical (or horizontal) ruled line you want to delete, press the delete key 11
Press key 8. and move the cursor under the part you want to delete (
(or right) After moving to the end, press the "depth" key 115. This causes the corresponding portion to be deleted.

The code for displaying or printing such ruled lines 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. 16
The upper 8 bits of the bit data indicate a ruled line code, and the lower 4 bits specify the font pattern. In this embodiment, the printing font is 32x32, and the CRT screen display font is 24x24 dot matrix, but in the case of ruled line fonts, only a very limited portion of these matrices are used. Ru. In other words, as schematically shown in FIG. 3(a), 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 right direction. This is the area 34 indicating the ruled line portion extending to the left side, and the ruled line information (none, thin line, double line, thick line) of each area is divided into two bits each from the upper side of the lower eight bits of the above 16-bit code. It is an assignment. And no ruled line: 00, thin line: 01. Double line: 10,
Thick line: This is represented by 11, so the lower 8 bits are o.
oooooooo has no borders in that part, 0000010
1 is a horizontal thin line that extends across the entire left and right width of the font, as shown in Figure 3 (b), and 00000001 is a horizontal thin line that appears only in the right half of the font (a dashed line is drawn as a continuation of this line), as shown in Figure 3 (c). ), 11111111 is shown in Figure 3 (
D) As shown in the thick line cross section, 10100000
becomes 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 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 that is to perform calculation processing according to the present invention, that is, the calculation mode and the editing mode. The relationship is as shown in FIG.

The processing operations of the control section 2 will be explained below based on FIG. 5 and FIG. 6, which shows 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.

The line types are "Subtotal" mark, "Total" mark and "
There are three types of "Exclude" marks. After moving the cursor to the position where it should be displayed, hold down the "Control" key 113 and press "S" on the letter key 117.
”, r G J, and “J” (however, the alphanumeric keys 118 are pressed in advance), the required marks are displayed.

For the "Subtotal" mark, enter the total for the rows above that row, or the total for the rows above the "Subtotal" mark and below the upper subtotal mark closest to the "Subtotal" mark. In the example of FIG. 4, they are displayed in the A total and B total rows. "Total" is "subtotal"
The line position where the total for the line of the mark is written is displayed, in the example of FIG. 4, the total line is displayed. Also "excluded"
Marks are displayed on lines that are 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 "calculate" 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. That is, at the shoulder of the table, the lower 8 bits of the code related to the ruled line in this area are 1) Y+ bs.

b=, b4. Of bl, bl, bl, and be, the two bits (bl, b,) that indicate the downward ruled line and the two bits (bl, b=) that indicate the rightward ruled line are not 00 (that is, The remaining 4 bits by,
Since b,, b,, bt are OO (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 recognized as part of the same table, and the following operations are performed in the same way by scrolling the screen. Also, calculations are made in depth regardless of whether they appear on the screen 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 CRT 4 screen as shown in FIG. If there is, the display of letters and numbers in the top line without the "exclude" mark will disappear, and a display prompting you to proceed with the operation of specifying an operator in the column of this line (in the drawing, the vertical ruled line part will be changed to 2). (represented by a heavy thick line), and a predetermined guide message is displayed. The cursor has the first character in the leftmost column.
be placed on a girder. Depending on the position of the cursor 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 part of the header exists in the table, the presence or absence of the header may be specified at the bottom so that calculations can also be performed on a table without part of the header.

"= Next, specify the operator: r-) - J key 117 L key" -1172, "Next" key 1173, "/" key 1174
carried out by In Figure 6 (a), calculate the product of quantity and unit price, and display and print the amount of this product in the amount column.
Specify + in the quantity column, US in the unit price column, and = in the amount column. Moving from the operator specification in the - column to the next column is instructed by the "tab" key 119. The product of the present invention calculates subtotals and totals for columns containing + and -1= in the rows with each mark, so it is necessary to take this into consideration when specifying operators, and the above example also requires the total quantity. Therefore, in order to make this a multiplicand that is processed substantially in the same way as the summand during addition, we designate 10 in that column.

FIG. 7 shows the functions of the operators for an example of five columns.

The columns in the 1st and 2nd rows are related only to addition and subtraction, and the columns in the 3rd and 4th rows are related to multiplication and division. Constants are allowed to be added to columns with = keys, and the D column of the 5th row is the sum of A-C columns plus 10, and the 0 column of the 6th row is A.
, the sum of column B, and the values obtained by subtracting 10 from each other are displayed and printed. Line 7.8 shows constant division (average calculation) and multiplication (10
0 fraction calculation) is shown. Note that the column of the 9th row is A,
An example is shown in which only vertical calculations are performed for columns C and E. Note that the operator in this case may be 10 or =.

After specifying the operator in this way, "Depth" key 11
When key 5 is pressed, the control section 2 receives this and then shifts to the edit specification mode, displays a predetermined guide message as shown in FIG. The vertical ruled line in the second row of the power column is 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 specified maximum number of digits. In the example in Figure 6, 3
Since there are enough digits, key in NNN. If you enter character data such as ¥ or %, piece, book, etc. before or after N input for numerical data, and if you enter scale value between N, enter those characters and symbols along with the calculation result. will also 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 input of N, when the depth of calculation is specified as described later, display as many rice as the number of N in the corresponding column and repeat N. Confirm the input.

If you press the "Tab" key 119 after entering the three N's in the quantity column (Figure 6 (b) shows this state), the calculation results will be displayed, skipping the unit price column that is unrelated to printing and displaying the amount column. A double thick line moves to . This field also includes the required N and letters,
When the "depth" key 115 is pressed after keying in a symbol to create the state shown in FIG. Display and print according to the specified editor.

In this case, even when non-numeric values such as ¥, yen, and pieces are shown in the width, the numerical data will of course be calculated independently from these. FIG. 6(d) shows the results, but as described above, rows marked with "exclusion" marks are not included in the calculations. Upon completion of the calculation, the control section returns from the calculation mode to the editing mode.

As shown in FIG. 5, after specifying the editor, press the "Depth" key 11 while the cursor K is on the leftmost ruled line.
When key 5 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 in that row 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 "depth" key 115 to be pressed. It goes without saying that when the "depth" key 115 is pressed, horizontal calculations for that row are 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 there is a specification error when specifying an operator or editor as described above, or if you press the "Cancel" key 121 in operator specification mode, collection specification mode, or sequential calculation mode, the mode returns to input mode. The cursor is placed on the leftmost ruled line, and a predetermined error message is displayed.

The control unit 2 uses “↑” and “↓” of the cursor movement keys 114.
By pressing the "→" key, the input mode is returned to the operator specification mode. 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 unit 2 returns to the editing mode by pressing the "end" key 122. Therefore, if you want to end the calculation, you can press the "end" key 122 and return to normal document creation.

Note that when printing a document, it is preferable not to print unnecessary line type marks such as "subtotal".

As is clear from the above description, according to the present invention, for each of one or more columns in a table, there is a means for specifying an operator that is common to numerical data in each row in the same column, and a means for specifying an operator that is common to numerical data in each row in the same column, and means for displaying in rows, means for specifying to exclude any row from calculations based on the operator, and depth for each row of calculations based on the operator excluding the specified row;
Since the table includes means for displaying or printing calculation results in designated columns in the table, rows other than those to be calculated can be provided in the table, and the versatility of the table format can be improved.

Note that 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]

Figure 1 is a block diagram schematically showing the tank bottom of the product of the present invention, Figure 2 is a keyboard layout diagram, Figures 3 (A) to (E) are illustrations of ruled line fonts, and Figure 4 is an example of a table. 5 is an explanatory diagram showing an outline of the processing mode of the control unit. Figures 6 (a) to (d) are explanatory diagrams showing screens in calculation mode. It is an explanatory diagram showing an example and its function. DESCRIPTION OF SYMBOLS 1...Keyboard, 2...Control unit, 3...Memory, 4...CRT, 5...Printer. 5 Figure 7

Claims (1)

[Claims] (1) For each of one or more columns in a table, means for specifying an operator common to numerical data in each row in the same column, means for displaying the specified operator in a specific row, and the operator means for specifying the exclusion of any row from calculations based on the operator, and depth for each row of calculations based on the operator excluding the specified rows, and displaying or printing the calculation results in specified columns in the table. A word processor characterized by comprising means.