JPH0589111A - Document creation device - Google Patents

Abstract

(57) [Summary] [Purpose] In a document creation device equipped with a database function, it is possible to arbitrarily specify the decimal point digit for the calculation result and display the decimal point according to the contents of the setting items. [Arrangement] The database control unit 3 is connected with an arithmetic control unit 9, a calculation formula setting memory 10, and a decimal point digit storage memory 11, and the arithmetic control unit 9 is connected to the calculation result storage memory 1.
3 and the processing result storage buffer 14 are connected. When the calculation formula is set and the decimal point digit is specified, the arithmetic control unit 9 stores the set formula in the calculation formula setting memory 10, and also stores the specified decimal point digit in the decimal point digit storage memory 11. The calculation is performed based on the calculation formula, and the calculation result is stored in the calculation result storage memory 13. This memory 13
A decimal point process is performed on the calculation result stored in the above step based on the designation of the decimal point digit, and the result is displayed on the screen.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a document creating apparatus having a card type database creating function.

[0002]

2. Description of the Related Art In recent years, a document creation device (word processor) having a card-type database creation function has been put into practical use. The function of this database is activated by original software. For example, by selecting a format from multiple types of samples and filling in the items, address book, business card management, customer management, member management, grade management, collection management You can easily create cards, ledgers, etc.

Further, in the database, calculations such as in-card calculation (four arithmetic operations, sum, average, maximum and minimum) and all card through-calculations (sum, average, maximum and standard deviation) can be performed. In this calculation, the digit position of the decimal point is indefinite, and the digit position of the decimal point varies depending on the calculation result.

[0004]

When the digit position of the decimal point is changed according to the calculation result as in the above-mentioned conventional method, it may be convenient in some cases, but the number of digits below the decimal point may be changed depending on the contents of the operation. It may be convenient to fix it because the calculation result is easier to see.

The present invention has been made in view of the above circumstances, and provides a document creation apparatus capable of fixing and displaying the number of digits after the decimal point at an arbitrarily designated position when a calculation process is performed by a database. The purpose is to do.

[0006]

According to the present invention, in a document preparation apparatus having a card-type database function, means for setting a calculation formula for card data created by the database function, and based on the calculation formula A calculation result storage means for storing the calculated result, a decimal point digit designating means for designating a decimal point digit for the calculation result calculated by the above calculation formula, and a calculation result stored in the calculation result storage means A decimal point processing means for processing the decimal point digit designated by the decimal point digit designating means and a display means for displaying a calculation result processed by this means are provided.

[0007]

[Function] Displays the decimal point digit designation screen when setting the calculation formula for the designated item. When a formula is set and a decimal point is designated on this display screen, calculation is performed based on the set formula. Further, the calculation result is subjected to processing such as rounding off to the designated decimal point digit, and the processing result is displayed on the screen. Therefore, the calculation result based on the calculation formula can be displayed by arbitrarily designating the decimal point digit, and the display state can be set in accordance with the contents of the setting items.

[0008]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of a database function part of a document creating apparatus according to an embodiment of the present invention. In FIG. 1, reference numeral 1 is a keyboard, which is provided with character keys, cursor keys, various function keys, and the like. Further, as the function designation keys, for example, "function 1" and "function 2" keys are provided, and various functions can be obtained by combining these "function 1" and "function 2" keys with other keys. It can be specified. Data necessary for document creation, database creation, etc. input from the keyboard 1 is sent to the database control unit 3 using a CPU or the like via the input control unit 2. The database control unit 3 sends the input data from the keyboard 1 or the result processed based on the input data to the display control unit 4 and displays it on the display device 5. The display device 5 is composed of, for example, an LCD.

The database control unit 3 has a ROM in which various control programs and guide messages are written.
6, a database setting information memory 7 that stores design information such as items of the database being input, a card data storage memory 8 that stores card data that has been input and additionally registered
Are connected.

The database control unit 3 also includes a calculation control unit 9 for executing calculation control, a calculation formula setting memory 10 for storing a set calculation formula, and a decimal point digit storage memory for storing a designated number of decimal places. 11 is connected. Further, the arithmetic control unit 9 is connected to a RAM 12 that stores arithmetic data. In the RAM 12, a calculation result storage memory 13 for storing the calculation result processed by the arithmetic control unit 9,
A processing result storage buffer 14 or the like is provided for storing the result of processing the above calculation result so as to obtain a designated decimal point. Next, the operation of the above embodiment will be described.

When a calculation formula is set for a card to be created, a "calculation formula setting" mode is designated in designing a new card. When this mode is designated, the database control unit 3 displays the "calculation formula setting" screen shown in FIG. In this case, the display screen shows an example of designing a new card relating to the “results table”, with an example of 40 characters per line and 20 lines per page. On this calculation formula setting screen, only the numeric type items among the setting items are displayed in a list. For example, "Grade" memory items, "Literature", "Mathematics", "Physics", etc. that store test results for each department, "Total" that sums the scores of each department, and "Average" that stores the average score Display the "Point" item. Further, in the calculation formula setting screen, work contents such as "1 setting end", "2 formula setting", "correction of formula" are displayed at the bottom,
The guide line 21 is set at the bottom line to display the message [After selecting the cursor, press the select / execute key].

In this display screen, when the "selection / execution" key is selected by selecting "setting of two formulas" with the cursor 22, the screen shown in FIG.
Move to the in-card calculation formula setting screen shown in. In this screen,
Move the cursor 22 to the first item "Grade", display the work content of "[Function 1] +" 1 "formula setting completed" on the guide line 21, and enter the answer on the guide line 21 with the cursor. Please select the item and press the select / execute key "message is displayed. The "answer" in this message indicates the calculation result by the calculation formula set later. Further, “[Function 1] +“ 1 ”expression setting end” of the work content indicates that the expression setting is ended by operating the “Function 1” key and the “1” key in combination. ..

If the calculation result is to be entered in the "total" item on the above display screen, the "k15 total" item is selected with the cursor 22 and the "select / execute" key is pressed.
By this key operation, the setting screen of the formula shown in FIG. 4 is displayed. In this display screen, the formula setting field is provided on the 15th line, the calculation formula setting elements are displayed on the 17th and 18th lines, and the guide line 21 displays “After setting the formula, press the select / execute key. "Please" message is displayed. The setting of the formula is set by sequentially specifying the setting elements of the calculation formula with the numerical keys.

When the "select / execute" key is pressed after setting the formula, the decimal point digit designation screen shown in FIG. 5 is displayed. In this screen, on the 17th line, [Do you want to specify the digits after the decimal point? ] Message is displayed, a selection box for [Do not perform] is provided on the 18th line, and a message for [If not selected is automatically calculated to fit in the area of the item] is displayed on the 19th line. .. Further, a message "Please select / execute key after selecting with cursor" is displayed on the guide line 21. Whether to specify the digits below the decimal point is selected with the cursor keys "←" and "→". If the user selects "No" to specify the digits below the decimal point, the set formula is stored in the calculation formula setting memory 10 and the calculation formula setting screen shown in FIG. 3 is returned to prepare for input of the next calculation formula.

When the user selects "Yes" to specify the digits below the decimal point, the decimal point digit designation screen shown in FIG. 6 is displayed. On this screen, specify the decimal places on the 17th to 19th lines, [Enter 0 if not specified], [Specifiable range is 0 to xx digits], "Calculation is Will be rounded off to the next designated digit ”message will be displayed.
After inputting the number of digits in the guide line 21, press the select / execute key] message is displayed. "0" is displayed in advance in the designated digit of the decimal point.

On this display screen, "0" is displayed in the designated digit.
When the "Select / execute" key is pressed while is displayed,
When the calculation process is performed so that it fits within the area of the item, a numerical value is entered in the digit designation column and the "select / execute" key is pressed, the calculation process according to the designated digit number is performed.

The decimal point processing for the calculation result will be described below with reference to the flowchart shown in FIG. The numerical value input to the digit designation column is set in the decimal point digit storage memory 11 when the "select / execute" key is pressed, and the arithmetic control unit 9 performs the decimal point processing according to the stored data.

That is, when the "select / execute" key is pressed after designating the digit of the decimal point, the arithmetic control unit 9 executes the calculation processing based on the calculation formula stored in the calculation formula setting memory 10 (step A1). ), And stores the calculation result in the calculation result storage memory 13. Next, the number of digits of the processing result storage buffer 14 configured in the RAM 12 is set according to the number of digits of the setting item, in this case, the number of digits of "k15 item".
After that, it is judged from the stored contents of the decimal point digit storage memory 11 whether a digit is designated (step A3). That is, when the numerical value stored in the decimal point digit storage memory 11 is "0", it is determined that no digit has been designated, and when the stored numerical value is "1" or more, it is determined that there is a digit designated.

When the decimal point digit is not specified, the raw data held in the calculation result storage memory 13 is taken out from the beginning and written in the processing result storage buffer 14. The database control unit 3 reads the data stored in the processing result storage buffer 14 and displays it on the screen of the display device 5 via the display control unit 4 (step A5). If this decimal point digit is not specified, right-justified display is performed.

If a digit is designated, the data held in the calculation result storage memory 13 is rounded off to the next digit of the designated digit (step A6), and the result is stored from the first digit to the processing result storage buffer. The set digit number of 14 is taken out and stored in the processing result storage buffer 14 (step A7). Now, for example, if the number of item digits is 10 and "3" is designated as the decimal point digit designation, the decimal point processing shown in FIG. 8 is performed (step A8). For example, if the answer stored in the calculation result storage memory 13 is “123.45”, “0” is supplemented to “123.450”, and if the answer is “123”, “ 000 "is supplemented to be" 123.000 ". Also, the answer is "12
In the case of 3.4567, the numerical value "7" in the fourth decimal place is rounded to "123.457", and the decimal places are aligned to three digits. In the above processing, commas are considered when comma processing is performed.

[0022]

As described above in detail, according to the present invention, it is possible to specify the decimal point digit for the calculation result together with the setting of the expression for the specified item so that the calculation result based on the calculation expression becomes the designated decimal point digit. Since the calculation result is processed and displayed, it is possible to arbitrarily specify the decimal point digit for the calculation result and display it, and the display state can be set according to the contents of the setting item and the like.

[Brief description of drawings]

FIG. 1 is a block diagram showing a circuit configuration of a document creation device according to an embodiment of the present invention.

FIG. 2 is a diagram showing a calculation formula setting screen in the embodiment.

FIG. 3 is a diagram showing a calculation formula setting screen.

FIG. 4 is a diagram showing a calculation formula setting screen.

FIG. 5 is a diagram showing a decimal point digit designation screen.

FIG. 6 is a diagram showing a decimal point digit designation screen.

FIG. 7 is a diagram showing a decimal point processing operation for a calculation result.

FIG. 8 is a diagram for explaining a decimal point processing operation.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Keyboard, 2 ... Input control part, 3 ... Database control part, 4 ... Display control part, 5 ... Display device, 6 ... ROM, 7
... database setting information memory, 8 ... card data storage memory, 9 ... arithmetic control unit, 10 ... calculation formula setting memory, 1
1 ... Decimal digit storage memory, 12 ... RAM, 13 ... Calculation result storage memory, 14 ... Processing result storage buffer.

Claims (1)

[Claims] 1. A document creation device having a card-type database function, means for setting a calculation formula for card data created by the database function, and a result calculated based on the calculation formula are stored. Calculation result storage means, decimal point digit designating means for designating the digit position of the decimal point for the calculation result calculated by the calculation formula, and calculation result data stored in the calculation result storage means,
A document creation apparatus comprising: a decimal point processing means for processing the decimal point digit designated by the decimal point digit designating means; and a display means for displaying a calculation result processed by this means.