JPH05242120A - Electronic display device - Google Patents

Abstract

PURPOSE:To enable an operator to easily set a calculation expression by setting a storage means storing with a name set by a name setting means and the calculation expression including the stored name as a variable. CONSTITUTION:Optional display areas are specified for display data displayed on a display screen by an area specifying means, and optional names consisting of desired character strings are set in the respective display areas by the name setting means and then stored in a RAM 13. Further, the calculation expression including the names as variables is set by an expression setting means separately. Then, when numerical data are inputted to the respective display areas by a key input device 5, an arithmetic circuit 15 performs an arithmetic operation based on the numerical data inputted to the display areas corresponding to the names included in the calculation expression according to the calculation expression. Therefore, list of the optionally assigned names can be displayed and when the calculation expression is set, the operator can easily recognize which name is usable.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an electronic display device having a calculation function for performing calculation based on numerical data input on a display screen.

[0002]

2. Description of the Related Art When a document is created by a word processor, it is often the case that the text is the same and a plurality of documents are created by replacing only specific numerical values. For example, this is a case where the quantity, unit price, amount of money, etc. of a product are entered in an estimate or the like. In an office computer, of course, it is possible to input numerical values later to perform calculations, but since the word processor is a "document creation device", it does not have such a function. Therefore, in the conventional word processor, the quantity and the unit price must be substituted for each document, and the amount must be calculated after separately calculating, which is very troublesome.

An electronic computer having a spreadsheet function, such as the electronic computer disclosed in Japanese Patent Laid-Open No. 47-13843, is desired by inputting data to each column in the table. It is known that a calculation is performed and the calculation result can be output to a desired column.

[0004]

However, the above-mentioned electronic computer does not sufficiently disclose the calculation function on the display screen, and therefore, the numerical data input to each display area on the display screen is not disclosed. No contrivances have been made to set calculation formulas as variables or assign desired arbitrary names to the above display areas to make it extremely easy for the operator to set calculation formulas or specify calculation formulas. It was

An object of the present invention is to allow an arbitrary name desired by an operator to be assigned to each display area when setting a calculation formula having each display area on a display screen as a variable. By making it possible to display a list of arbitrarily set names, the operator can easily set the above calculation formula.

[0006]

The means of the present invention are as follows.

An area designating means for designating an arbitrary display area on the display data displayed on the display screen and an arbitrary name consisting of a desired character string for each display area designated by the area designating means Name setting means to be set, storage means for storing the name set by the name setting means, formula setting means for setting a calculation formula having the name stored in the name storage means as a variable, and the display areas An input means for inputting numerical data, an arithmetic means for executing an operation according to the above-mentioned calculation formula based on the numerical data inputted in the display area corresponding to the name included in the above-mentioned calculation formula, and a predetermined operation Display control means for displaying a list of names stored in the name storage means on the display screen,
Equipped with.

[0008]

The operation of the means of the present invention is as follows.

An arbitrary display area is designated on the display data displayed on the display screen by the area designating means, and an arbitrary name consisting of a desired character string is set for each display area by the name setting means. When set, each of these names is stored in the storage means. Separately from this, the formula setting means sets a calculation formula using the above name as a variable.
After that, when numerical data is input to each of the display areas by the input means, the calculation means follows the above calculation formula based on the numerical data input to the display area corresponding to the name included in the calculation formula. Perform an operation. Then, when a predetermined operation is performed by the operator, the display control means displays a list of names stored in the name storage means on the display screen.

Therefore, when setting a calculation formula in which each display area on the display screen is a variable, an arbitrary name desired by the operator can be assigned to each display area. A list of arbitrarily assigned names can be displayed, and the operator can easily understand which name can be used when setting the above calculation formula.

[0011]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment will be described below with reference to the drawings. FIG. 1 shows an external configuration. Reference numeral 1 is a word processor main body, and 2 is a printer connected to the word processor main body 1. The word processor body 1 is provided with floppy disk (FDD) units 3a and 3b, a CRT display unit 4, and a key input device 5. This key input device 5
Includes a keyboard 7 for inputting numerical data and various function data, as well as keyboards 6a to 6c for inputting Japanese characters such as Chinese characters. On the keyboard 7, for example, numeric keys, alphabet keys, cursor keys, TAB (tab) keys, calculation instruction keys, total keys, print keys, currency keys such as yen ($), dollar ($), and , "Area", "execute", "YES", "N"
A key having a function such as "O" is provided.

Next, the electronic circuit provided in the word processor main body 1 will be described with reference to FIG. In FIG. 2, 11 is a microprogram control circuit, for example, R
It is composed of an OM (Read Only Memory) and stores various control microprograms.
The micro program control circuit 11 includes a key input device 5, an I / O controller 12, a data storage RAM (random access memory) 13, a numerical table 14 whose details will be described later, an arithmetic circuit 15, and an editing circuit 1.
6, cursor controller 17, message RAM 18
Etc. are connected.

The I / O controller 12 is
Data transfer between the printer 2 and the floppy disk and the RAM 13 is controlled in accordance with a command from the micro program control circuit 11. Further, the RAM 13 is supplied with key input data from the key input data from the key input device 5. Further, the RAM 13 is controlled by the microprogram control circuit 11 to write and read data with the numerical table 14 and the arithmetic circuit 15.

Further, the editing circuit 16 is provided in the document memory 1
9 is edited, and data is written in the document memory 19 from the numerical table 14. And
The data read from the document memory 19 is sent to the display controller 20. Further, the cursor data is input from the cursor controller 17 and the message read from the message RAM 18 is input to the display controller 20. The display controller 20 outputs display data to the CRT display unit 4 via a character generator (not shown) or the like according to the input data.

As shown in FIG. 3, the numerical table 14 is composed of areas A1 to A9. The A1 area has a name, the A2 area has a currency symbol, the A3 area has a numerical value, and the A4 area has a numerical value. Area start address "fr
om ", the end address" to "of the above numerical value display area in the A5 area, a framed flag in the A6 area, repeated information in the A7 area, an input flag indicating to what extent the A8 area is calculated, and an A9 area in the A9 area. It is designed to store the calculation formula. In this case, the framing flag of the A6 area is written before the name is defined, but it is erased when it is defined. The repetition information in the A7 area is information indicating how many rows the defined name is repeated and how many times.

Next, the operation of the above embodiment will be described. For example, if the estimation table shown in FIG. 4A is created,
First, as shown in Fig. 4 (b), Japanese sentences such as kanji and kana are created one by one from the beginning, but numerical data such as the amount of money is not input, either during or after the completion of Japanese sentence creation. A process for designating the area or the like is performed. When data is input from the key input device 5 when creating the document, it is first stored in the RAM 13 and then written in the document memory 19 from the micro program control circuit 11 through the editing circuit 16.

Then, for example, after the creation of the Japanese sentence is completed, the numerical area is defined. In the case of FIG. 4A, after creating documents up to "Amplifier" ... "Total",
Define the numerical value area for the fixed price "¥ 89,000" of "Amplifier". This numerical value area definition is processed according to the flow charts shown in FIGS. 5 and 6 by operating the “numerical value” key provided on the keyboard 7. First, the "numerical value" key is operated as described above, and then the cursor is moved to the head of the area to be defined, and then the "area" key is operated as shown in step X1 of FIG. When this "area" key is operated, the flow advances to step X2 to set the address indicated by the cursor in the FROM area A4 of the numerical table 14.

Then, as shown in step X3, the cursor is moved to the end of the area to be defined, and then the "area" key is operated as shown in step X4. By operating this "area" key, the next step X5
Then, the process proceeds to step S6 and the address indicated by the cursor is set in the TO area A5 of the numerical table 14. After that, as shown in step X6, the flag data is written in the framed flag area A6 of the numerical table 14, and the designated area is reversed and the framed display is made.

Thereafter, if necessary, a currency symbol as shown in step X7, that is, a yen symbol \ in this case is input. When you enter this yen symbol, the currency symbol is written in the currency symbol area A2 of the numerical table 14, and step X9
In, the currency symbol \ is displayed in the designated area. In step X10, the alphabet key is operated to input a name such as "A". By this key operation, the process proceeds to step X11 to set the name "A" in the name area A1 of the numerical table 14, and in step X12, the name "A" together with the yen symbol "\" is set in the designated area as shown in FIG. 4B. Is displayed.

Then, as shown in step X13 of FIG. 6, the "execute" key is operated. By this key operation, the process proceeds to step X14 to read the message "Repeat?" Stored in the message RAM 18 and display it in the console area 4A of the CRT display unit 4. At this time, if it is not repeated, the "NO" key is operated as shown in step X15. When the "NO" key is operated, the specification process of the numerical area is completed. Also,
When repeating, as shown in step X16, "Y
Operate the "ES" key. If the "YES" key is operated, the process proceeds to step X17, where the message RAM
The message “Please input the number of repeats” is read from 18 and displayed on the CRT display unit 4.

According to the above message, the operator inputs a numerical value n, for example, "4" as shown in step X18, and sets it in the repetitive information area A7 of the numerical value table 14.
When the above numerical value n is entered, the process proceeds to step X19, and the message "Enter repeat interval" is displayed. With this display, as shown in step X20, the repeat interval L
Enter, and repeat information area A7
Set to. In the case of FIG. 4, since the document data is displayed every other line, the value of L is “1”. When the repeat interval L is input, the operation proceeds to step X21, and the FROM-TO address of the repeat area is calculated by the arithmetic circuit 15. In the address calculation at this time, the numerical value area for the product name "tuner" in FIG. 4 is obtained. Then, in step X22, the data obtained in step X21 is set in the FROM area A4 and TO area A5 in the line next to the name A in the numerical table 14.

Next, in step X23, the designated area is highlighted and framed. Then, the process proceeds to step X24, and it is determined whether or not the data set in the FROM-TO area has been completed the number of times of the value n set in step X18. If the result of the determination is NO, the process returns to step X21 and the same processing is repeated. When the processing of n times is completed, the determination result of step X24 becomes YES and the setting processing of the numerical value area is completed.

In the above processing, X1, X3,
In the key input step of X4, X7, X10, X13, X15, X16, X18, X20, etc., a key wait signal is sent from the microprogram control circuit 11 to the key input device 5 until the key operation is performed. After defining the numerical area for the fixed price as described above, the numerical area for the multiplication rate, price, total, etc. is similarly defined.

Next, a calculation formula for obtaining prices, totals, etc. will be defined. The definition of this calculation formula is "calculation formula" on the keyboard 7.
The operation is performed according to the flow shown in FIGS. 7 and 8 by operating the key. First, when the "calculation formula" key is operated, "1. definition" and "2. reference" are displayed in the console area 4A of the CRT display section 4 under the control of the microprogram control circuit 11 as shown in step Y1 of FIG. Message is displayed.

In the case of the calculation formula definition, the numerical key "1" is operated as shown in step Y2 to specify "1. definition". By the above definition designation, "1. continuous" and "2. individual" are displayed in the console area 4A of the CRT display section 4 as shown in step Y3. In case of continuous operation, the numerical key "1" is operated to specify "1. continuous" as shown in step Y4. By the above continuous designation, as shown in step Y6, the first name, that is, the first name "A" registered in the numerical table 14 is displayed in the console area 4A. Since it is not necessary to define an expression for this name "A", the "execute" key is operated to pass.

By the operation of this execution key, the next name "B"
Is read from the numerical table 14 and displayed in the console area 4A. Since there is no need to define an expression for this "B" either, the "execute" key is operated to pass. By the operation of this execution key, the next name "C" is read from the numerical value table 14 and displayed in the console area 4A. Since this name "C" is for the price and it is necessary to define the formula, "C = A ×" is calculated in step SY6.
B ”That is, the multiplication expression of“ fixed price ”and“ multiplication rate ”is defined by key operation.

Next, in step Y7, the above formula is written in the formula area A9 of the numerical table 14. After that, the framing flag in the area A6 in the numerical table 14 is reset, and the CRT is displayed as shown in step Y8.
The frame for the name C on the display unit 4 is released. Then, in step Y9, it is determined whether or not the name has reached the last name. If the last name is not over,
Returning to step Y5, the same processing is repeated. In the example of FIG. 4, the calculation formula for the name “D”, that is, the calculation formula for summing the values of each C is defined by key operation, and the numerical table 1
Write in the formula area A9 of 4. Then, when the definition of the expressions for all the names is completed, the judgment result of step Y9 becomes YES, and the calculation expression definition flow ends.

On the other hand, in step Y3, in response to the display of "1. continuous" and "2. individual", the numerical key "2" is operated to specify "2. individual" as shown in step Y10. In this case, as shown in step Y11, the name "C" defined by the key operation is input. A search in the numerical value table 14 is performed by designating the name "C". Then, when the formula for "C" is defined as shown in step Y13, the formula is set in the formula area A9 in the numerical table 14 in step Y14.

Then, as shown in step Y15, the process of releasing the frame is performed. Then, next, when the name "D" to be defined is designated, the processes of steps Y11 to Y15 are repeated. Then, when the calculation formula definition for the predetermined name is completed, the "execute" key is operated as shown in step Y16. The operation of the "execute" key ends the flow of the calculation formula definition.

When "1. Definition" and "2. Reference" are displayed in step Y1, the numeric key "2" is operated to select "2. If "reference" is designated, the contents of the numerical value table 14 are read in step Y18, and a list display is performed in step Y19 as shown in FIG. As shown in FIG. 9, this list display is performed for four items of "in use", "expression is undefined", "area is undefined", and "repeat count mismatch". The above "in use" is the name "C", "D" where the formula is defined, and the "undefined formula" is the name "A", "B" which is defined in the area and does not appear in the formula.
"Area is undefined" is a name that has been defined in the expression and has no area, and "Inconsistency in repeat count" is a name in which the repeat count is inconsistent in the calculation formula for repeats. This "repeat count mismatch"
In this case, for example, in “C = A × B”, the number of repetitions of A and B is different. The definition state of the calculation formula is confirmed by the list display in step Y19, and if it is not correctly defined, the "execute" key is operated as shown in step Y20 to return to step Y1 and the definition operation is performed again. If it is defined correctly, step Y21
As shown in, the "END" key is operated to end the calculation formula definition flow.

The basic document created as described above is stored in the floppy disk. When using, specify the document file name and load it from the floppy disk to the document memory 19, and
The necessary items are loaded into the numerical value table 14. By this document loading, the process proceeds to step Z1 in FIG. 10, and the document including the numerical area is displayed on the CRT display unit 4 as shown in FIG. 4 (b). In this state, the cursor is displayed in the numerical value leading area as shown in step Z2.

After that, as shown in step Z3, a numerical value is input by a key operation. In this example, first, the fixed price "89,000" for the amplifier is input and the "TAB" key is operated. When the above numerical value is input, the process proceeds to step Z4, and the reverse display of the area corresponding to the input numerical value is erased to switch to the normal display. Next, the calculation and processing of the numerical value table set shown in step Z5 are proceeded, but at this point the calculation is not performed and the numerical value input is written in the numerical value table 14.

Then, in step Z6, the input flag of the A7 area in the numerical table 14 is set. Next, as shown in step Z7, the cursor is moved to the next numerical value area, for example, the multiplication numerical value area, and then it is judged in step Z8 whether or not the data writing to all the numerical value areas is completed. If the writing of data has not been completed, the process returns to step Z3 and waits for key input. In this state, a numerical value for the multiplication factor, for example, "0.8" is input and the "TAB" key is operated. By inputting the above numerical values, the process proceeds to step Z5 via step Z4 to calculate "C = A × B", that is, "8.
The calculation of “9,000 × 0.8 = 71,200” is performed by the arithmetic circuit 15, and the calculation result is written in the numerical value area A3 in the numerical value table 14. At this time, the calculation of “D = total C” is performed, and the numerical area A in the name D is calculated.
It is written in 3 and displayed on the CRT display unit 4.

Similarly, by inputting the fixed price and the multiplication rate for the "tuner", "speaker", and "player", the price and the total value of each product are obtained and written in the corresponding numerical area A3. Then, when the input of the fixed price and the multiplication rate for all the products is completed, after the completion of the calculation, the process proceeds from step Z8 to step Z9 to wait for the key input. When the "print" key is operated in this state, the contents of the document memory 19 are read out to the I / O controller 12 via the editing circuit 16 by the control of the microprogram circuit 11 and sent to the printer 2 to be sent to the step Z.
The printing process shown in 10 is performed. That is, in step Z10, the contents displayed on the CRT display section 4 are sent from the document memory 19 to the printer 2 and printed, as shown in FIG.

[0035]

According to the present invention, when setting a calculation formula in which each display area on the display screen is a variable, an arbitrary name desired by an operator can be assigned to each display area. Along with this, a list of arbitrarily assigned names can be displayed, and the operator can easily grasp which name can be used when setting the above calculation formula.

[Brief description of drawings]

FIG. 1 is an external perspective view of an electronic display device according to an embodiment of the present invention.

FIG. 2 is a circuit configuration diagram in the embodiment.

FIG. 3 is a diagram showing a storage configuration of a numerical table in FIG.

FIG. 4 is a diagram showing a display example at the time of creating a quotation table.

FIG. 5 is a flowchart showing an operation of defining a numerical area.

FIG. 6 is a flowchart showing an operation of defining a numerical area.

FIG. 7 is a flowchart showing the operation of defining a calculation formula.

FIG. 8 is a flowchart showing the operation of defining a calculation formula.

FIG. 9 is a diagram showing a display example when referring to a definition state.

FIG. 10 is a flowchart showing an operation when loading a document.

[Explanation of symbols]

1 ... Word processor main body, 2 ... Printer, 3
a, 3b ... Floppy disk part, 4 ... CRT display part, 4A ... Console area, 5 ... Key input device, 6a-6c, 7 ... Keyboard, 14 ... Numerical table, 15 ... Arithmetic circuit, 19 ... Document memory.

Claims (1)

[Claims] 1. An area designating means for designating an arbitrary display area on display data displayed on a display screen, and an arbitrary character string consisting of a desired character string for each display area designated by the area designating means. Name setting means for setting a name, storage means for storing the name set by the name setting means, expression setting means for setting a calculation formula having the name stored in the name storage means as a variable, An input means for inputting numerical data in the display area, an arithmetic means for executing an operation in accordance with the above-mentioned calculation formula based on the numerical data inputted in the display area corresponding to the name included in the above-mentioned calculation expression; And a display control unit for displaying a list of names stored in the name storage unit on the display screen by the operation.