JPH04306B2 - - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to an electronic display device having a display screen, such as a word processor or the like.

[Conventional technology]

When creating documents while viewing the display screen using an electronic display device such as a word processor, there are many cases in which multiple documents are created by replacing only specific numerical values. For example, this is the case when entering the quantity, unit price, amount, etc. of products in an estimate.

[Problem to be solved by the invention]

Office computers allow calculations to be performed by inputting numerical values later, but the setting of calculation formulas for the calculations must be written in a program, which is extremely troublesome.
In particular, to calculate data input into an arbitrary area on the display screen and data input into another arbitrary area, and display the calculation results in an area different from the above area in the row or column direction. The problem was that the program settings were complicated.

An object of the present invention is to enable easy setting of calculations between data input into an arbitrary area on a display screen and data input into another arbitrary area.

[Means to solve the problem]

The means of the present invention are as follows.

a specifying means for specifying an area at an arbitrary row/column position among a plurality of areas arranged in the row and column directions on the display screen; and specifying the area specified by the specifying means in the corresponding area on the display screen. a first display control means for identifying the position by a display area frame of a size set for the area; an input means for inputting numerical data into each of the display areas on the display screen; a setting means for setting a calculation formula consisting of the names of areas in other rows or columns on the display screen for the selected area; It is provided with a calculation means for performing calculations based on input numerical data, and a second display control means for displaying the results of the calculations within the display area frame of the area in which the calculation formula is set.

[Effect]

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

An area at an arbitrary row/column position specified on the display screen is identified and displayed by a display area frame having a size set for that area. Then, for the specified area, a calculation formula consisting of the names of areas at other row/column positions on the display screen can be set by the setting means. After these settings, data is input sequentially into each display area on the display screen, and when data is input into the display area corresponding to each name included in the above calculation formula, the calculation means is input. Substitute the calculated data into the calculation formula and execute the calculation. Then, the calculation result is displayed within the display area frame of the area where the calculation formula is set.

Therefore, when setting a calculation formula consisting of the name of an area in another row/column position in a display area at a given row/column position in a two-dimensional area on the display screen, the position and size on the display screen must be set. After checking, you can easily set it up.

〔Example〕

Hereinafter, one embodiment of the present invention will be described with reference to the drawings. FIG. 1 shows the external structure, in which 1 is a word processor main body, and 2 is a printer connected to this word processor main body 1. As shown in FIG. The word processor body 1 is provided with floppy disk (FDD) sections 3a, 3b, a CRT display screen 4, and a key input device 5. This key input device 5 is
Keyboards 6a to 6c for inputting Japanese characters such as kanji
It also includes a keyboard 7 for inputting numerical data and various functional data. and,
This keyboard 7 includes, for example, a numeric keypad, alphanumeric key, cursor key, TAB key, calculation instruction key, total key, print key, currency keys such as yen (¥), dollar ($), and "numeric" keys. ,
Keys with functions such as "area", "execution", "YES", and "NO" are provided.

Next, referring to FIG. 2, the electronic circuit provided within the word processor main body 1 will be explained. In FIG. 2, reference numeral 11 denotes a microprogram control circuit, which is composed of, for example, a ROM (read/write memory), and stores various control microprograms. The microprogram control circuit 11 includes a key input device 5,
I/O controller 12, RAM for data storage
(Random access memory) 13, numeric table 14, details of which will be described later, arithmetic circuit 15, editing circuit 16, cursor controller 17, message
RAM18 etc. are connected. And the above I/O
The controller 12 controls data transfer between the printer 2, floppy disk, and RAM 13 according to instructions from the microprogram control circuit 11. Further, key input data from the key input device 5 is given to this RAM 13. Furthermore, the RAM 13 is the microprogram control circuit 1
1 controls the numerical table 14 and the arithmetic circuit 15.
Data is written and read between.
The editing circuit 16 also edits the document memory 19, into which data is written from the numerical value table 14. The data read from the document memory 19 is then sent to the display controller 20. Further, the display controller 20 receives cursor data from the cursor controller 17 as well as messages read from the message RAM 18. The above display controller 20
outputs display data to the CRT display unit 4 via a character generator (not shown) or the like in accordance with the input data.

The numerical value table 14 consists of areas _A1 to _A9 , as shown in FIG. 3, with names in area _A1 , currency symbols in area _A2 , numerical values in area _A3 , and area _A4 . is the start address of the numerical display area "from", _A5 area is the end address of the numerical display area "to", _A6 area is the frame flag,
The _A7 area stores repetition information, the _A8 area stores an input flag indicating how far the calculation has been made, and the _A9 area stores the calculation formula. In this case, the above-mentioned framing flag is written in the _A6 area before the name is defined, but is erased after the name is defined. Further, the repetition information in the _A7 area is information indicating how many times and in how many lines the defined name is to be repeated.

Next, the operation of the above embodiment will be explained. For example, if we are to create the estimate table shown in Figure 4a,
First, as shown in Figure 4b, Japanese sentences in kanji, kana, etc. are created sequentially starting from the last one, but numerical data such as amounts are not input, and the Japanese sentences are created either during or after the Japanese sentence is created. Performs area specification processing. When data is input from the key input device 5 when creating the above document, first,
The data is stored in the RAM 13 and then written into the document memory 19 from the microprogram control circuit 11 via the editing circuit 16. Then, for example, after completing the creation of the Japanese sentence, the numerical region is defined. In the case of Figure 4 a, "Amplifier"..."Total"
After creating the documents up to this point, define the numerical range for the list price of "Amplifier": "¥89,000". This numerical value area definition is processed according to the flowchart shown in FIG. 5 by operating the "numeric value" key provided on the keyboard 7. First, operate the ``numeric'' key as described above, then move the cursor to the beginning of the area to be defined, and then operate the ``area'' key as shown in step _X1 of FIG. When this "area" key is operated, the process advances to step _X2 , and the address indicated by the cursor is set in the FROM area _A4 of the numerical table 14. Next, move the cursor to the _end of the area you want to define above, as shown in _step
Operate the keys. By operating this "area" key, the process advances to the next step _X5 , and the address indicated by the cursor is set in the TO area _A5 of the numerical table 14. Thereafter, as shown in step _X6 , flag data is written in the frame flag area _A6 of the numerical value table 14, and the designated area is inverted and displayed in a frame. Then, if necessary, enter the currency symbol, in this case the yen symbol ¥, as shown in step X ₇ . When you enter this yen symbol, the currency symbol is written in the currency symbol area _A2 of the numerical value table 14, and the step
In X ₉ , the currency symbol ¥ is displayed in the specified area above. In step _X10 , a name such as "A" is input by operating the alphabet keys. With _this key operation _, the process advances _to step A”
Display. Next, operate the "Execute" key as shown in step _X13 . This key operation advances to _step
to be displayed. At this time, if you do not want to repeat the process, press the "NO" key as shown in step _X15 . If this "NO" key is operated, the process of specifying the numerical value area is completed. If you wish to repeat the process, press the "YES" key as shown in step _X16 . If the "YES" key has been operated, the process advances to _step In accordance with the above message, the operator enters a numerical value n, for example "4", as shown in _step
A Set to ₇ . When the above numerical value n is input, the process advances to step _X19 , and the message ``Please input the repeat interval'' is displayed. From this display _, enter the repeat interval 1 as shown in _step
Set to . In the case of FIG. 4, the document data is displayed every other line, so the value of 1 is "1". Then, if you input the above repetition interval 1,
Proceed to step X ₂₁ and repeat area FROM−
TO address calculation is performed by the arithmetic circuit 15. In the address calculation at this time, the numerical value area for the product name "Chyuna" in FIG. 4 is determined.
Then, in step _X22 , the data obtained in step _X21 is set in FROM area _A4 and TO area _A5 in the row next to name A in the numerical value table 14. Next, the process proceeds to step _X23 , where the designated area is inverted and framed.
Then proceed to step X ₂₄ and select FROM-TO above.
It is determined whether data has been set to the area the number of times n set in step _X18 . If the result of the above determination is NO, the process returns to step _X21 and the same process is repeated. When the nth process is completed, the determination result in step _X24 becomes YES, and the numerical region setting process ends. Note that in the above process, X ₁ , X ₃ , X ₄ , X ₇ , X ₁₀ , X ₁₃ , X ₁₅ ,
In key input steps such as X ₁₆ , X ₁₈ and X ₂₀ , a key wait signal is sent from the microprogram control circuit 11 to the key input device 5 until the key is operated.

After defining the numerical range for the list price as described above, the numerical range for the multiplication rate, price, total, etc. is similarly defined.

Next, define calculation formulas for calculating prices, totals, etc.
The definition of this calculation formula is "Calculation formula" on the keyboard 7.
By operating the keys, the process is performed according to the flow shown in FIG. First, when the _above -mentioned "calculation formula" key is operated, "1. Definition" and "2.・The message "Reference" is displayed. In the case of formula definition, operate the numeric key "1" as shown in step Y ₂ , and select "1.Definition".
Specify. Step Y ₃ according to the above definition specification
As shown in the figure, "1.Continuous" and "2.Individual" are displayed in the console area 4A of the CRT display section 4. If you want to do it continuously, press the numeric key "1" and select "1/Continuous" as shown in step Y ₄ .
Specify. Step Y ₅ due to the above continuous specification
The first name, that is, the first name "A" registered in the numerical value table 14 is displayed in the console area 4A as shown in FIG. There is no need to define an expression for this name "A", so press the "Execute" key to pass. By operating this execution key, the next name "B" is read from the numerical table 14 and displayed on the console area 4A. There is no need to define an expression for this "B", so
Operate the "Run" key to pass. By operating this execution key, the next name "C" is entered in the numerical table 14.
and displayed on the console area 4A. This name "C" refers to the price and it is necessary to define a formula, so in step Y ₆ , define "C = A × B", that is, the multiplication formula of "list price" and "multiplying rate" by key operation. . Then step
Proceed to Y ₇ and go to calculation formula area A ₉ of numerical table 14
Write the above calculation formula into . Thereafter, the frame flag in area A ₆ in the numerical table 14 is reset, and the CRT display section 4 is reset as shown in step Y ₈ .
Configure the frame for name C above. and,
At step _Y9 , it is determined whether the process has progressed to the last name. If the last name has not been completed, return to step _Y5 and repeat the same process. In the example in Figure 4, the calculation formula for the name "D",
In other words, define the calculation formula for summing the values of each C by key operation, and
Write in _A9 . Then, when you finish defining the expressions for all the names, the judgment result of step Y ₉ is
The result is YES and the calculation formula definition flow ends.

On the other hand, in step Y ₃ above, in response to the display of "1/Continuous" and "2/Individual", the numerical key "2"
If you specify "2.Individual" as shown in step _Y10 by operating the key, enter the name "C" to be defined by operating the keys as shown in step _Y11 . By specifying this name "C", step Y ₁₂
A search within the numerical value table 14 is performed as shown in FIG. Then press "C" as shown in step Y ₁₃ .
Once a formula is defined, the formula is set in the formula area _A9 in the numerical value table ₁₄ in step Y14. Next, as shown in step _Y15 , frame removal processing is performed. After that, if you specify the name "D" to be defined next, step Y ₁₁
~Y ₁₅ processing is repeated. Then, when you finish defining the formula for a given name,
Y Operate the "Execute" key as shown in ₁₆ . Operation of this "execute" key ends the calculation formula definition flow.

In addition, in step Y ₁ above, "1. Definition",
When "2.Reference" is displayed, if you operate the numeric key "2" to specify "2.Reference" as shown in step _Y17 , the contents of the numerical table 14 will be displayed in step _Y18 . are read out, and a list is displayed in step _Y19 as shown in FIG. This list display includes "In use", "Formula is undefined", "Area is undefined", as shown in Figure 7.
This is done for 4 items of ``mismatch in number of repetitions''.
"In use" above is the name "C" where the expression is defined,
"D", "Expression is undefined" means that the area is defined and does not appear in the expression "A", "B", "Area is undefined" means that the area is defined but there is no area The name "repetition number mismatch" is a name for which the number of repetitions does not match in the repetition calculation formula. This "repetition number mismatch" is caused by, for example, "C=A×B", where A and B
This is a case where the number of repetitions is different. Check the definition status of the calculation formula by displaying the list in step Y ₁₉ above, and if it is not defined correctly, press the "Execute" key as shown in step Y ₂₀ to return to step Y ₁ and repeat the definition operation. Do this. Also,
If the definition is correct, press the "END" key as shown in step _Y21 to end the calculation formula definition flow.

The basic document created as described above is stored on the floppy disk. When used, the document file name is designated and loaded from the floppy disk into the document memory 19, and necessary items are loaded into the numerical table 14. By loading this document, the steps shown in Figure 8 will be executed.
Proceeding to _Z1 , the document including the numerical area is displayed on the CRT display unit 4 as shown in FIG. 7b. In this state, a cursor is displayed in the first numerical value area as shown in step _Z2 . Then, as shown in step _Z3 , numerical values are input by key operation. In this example,
First, enter the list price of the amplifier, ``89,000,'' and press the ``TAB'' key. By inputting the above numerical value, the process advances to step _Z4 , where the highlighted display of the area corresponding to the input numerical value is erased and the display is switched to normal display. Next, the process proceeds to the calculation and numerical table set processing shown in step _Z5 , but no calculation is performed at this point, and numerical inputs are written in the numerical table 14. Then, in step _Z6 , the input flag of area _A7 in the numerical value table 14 is set. Next, as shown in step _Z7 , the cursor is moved to the next numerical value area, for example, the multiplication rate numerical value area, and then in step _Z8 it is determined whether data writing to all numerical value areas has been completed. If the writing of data has not been completed, the process returns to step _Z3 and waits for a key input. In this state, enter a value for the multiplication rate, for example "0.8", and press "TAB"
Operate the keys. Step Z ₄ by inputting the above numerical value
Proceed to step Z ₅ and calculate "C=A×B".
In other words, the calculation of "89000 x 0.8 = 71200" is performed in the arithmetic circuit 15, and the calculation result is displayed in the numerical table 1.
It is written to the numerical value area _A3 in 4. Further, at this time, the calculation "D=total C" is performed, and is written in the numerical area _A3 for the name D and displayed on the CRT display section 4. Thereafter, by inputting the list prices and multiplication rates for "Tyuna", "Speaker", and "Player" in the same manner, the price and total value of each product are determined and written in the corresponding numerical area _A3 . After inputting list prices and multiplication rates for all products, the process proceeds from step _Z8 to step _Z9 after completing the calculation, and enters a state of waiting for key input. Then, 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 under the control of the microprogram circuit 11, and sent to the printer 2, where it is sent to step Z. The printing process shown in ₁₀ is performed. That is, this step _Z10 is as shown in Fig. 4a.
As shown in FIG. 2, the content displayed on the CRT display section 4 is sent from the document memory 19 to the printer 2 and printed.

〔Effect of the invention〕

According to the present invention, a calculation formula consisting of the names of areas in other rows and columns can be set for a display area in an arbitrary row and column position in a two-dimensional area on a display screen, and furthermore, when making the above settings, , the specified display area can be easily set after confirming the position and size of the specified display area on the display screen.

[Brief explanation of drawings]

The drawings show one embodiment of the present invention; FIG. 1 is an external perspective view, FIG. 2 is a circuit configuration diagram, and FIG. 3 is a diagram showing the storage configuration of the numerical table in FIG. 2.
Figures 4 a and b are diagrams showing examples of display when creating a quotation sheet;
Figure 5 is a flowchart showing the operation of numerical region definition, Figure 6 is a flowchart showing the operation of calculating formula definition, Figure 7 is a diagram showing an example of display when referring to the definition state, and Figure 8 is a document This is a flowchart showing the operation during loading. 1... Word processor body, 2... Printer, 3a, 3b... Floppy disk unit, 4...
...CRT display section, 4A...Console area, 5
... Key input device, 6a to 6c, 7 ... Keyboard, 14 ... Numerical table, 15 ... Arithmetic circuit,
19...Document memory.

Claims (1)

[Scope of Claims] 1. A specifying means for specifying an area at an arbitrary row/column position among a plurality of areas arranged in row and column directions on a display screen; and an area specified by the specifying means, The first screen is identified and displayed at the corresponding position on the display screen by a display area frame of the size set for that area.
display control means for inputting numerical data into each of the above-mentioned display areas on the display screen; and names of areas in other rows or columns on the display screen for the area specified by the above-mentioned specifying means; a setting means for setting a calculation formula consisting of; a calculation means for performing calculations based on the numerical data input within the display area frame of the area corresponding to each name included in the calculation formula; An electronic display device comprising: second display control means for displaying within a display area frame of an area in which the calculation formula is set.