JPH1115622A - Spreadsheet instructing method and its device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce errors in generating a calculating formula and to improve operability by interactively indicating the kind of a table and the cell position of an item to be the object of calculation and preparing the calculating formula of a routine table so as to easily calculate the table without caring about the calculating formula. SOLUTION: A storing part 3 stores calculating formula data 8 for a routine table corresponding to the routine table. A control part 4 by a microprocessor controlling each part includes a routine table calculating formula generation control part 5 controlling the calculating formula preparation of the routine table. Then a display part 2 displays guidance promoting the indication of the starting position cell of spreadsheet for each item of a quantity, a unit price, etc. Corresponding to this, the starting position cell of one item is indicated by the key or the pointing device of an input part 1 and the starting position cell is stored in the part 3 by the operation of an execution key, etc., and then guidance for designating to which cell to calculate is displayed on the part 2 to sequentially indicate spreadsheet.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method and an apparatus for instructing a spreadsheet having a function of automatically creating a formula for a stylized table.

[0002]

2. Description of the Related Art Conventionally, when creating a table formula,
It is created by specifying the cell position and operator to be operated.

[0003] In addition, even when a plurality of formulas in the table are prepared, they are prepared one by one.

[0004]

However, in the above-mentioned conventional technique, when a stylized calculation formula is created, it is necessary to specify a cell position, an operator, and the like, and it takes time to create the calculation formula. There is such a problem.

When a plurality of formulas are created, the formulas (cell positions) related to the formulas may be specified several times because the formulas are created one by one. Has a problem that

An object of the present invention is to select a type of a target table and specify the cell position of each item to be calculated only once interactively when creating a formula for a fixed table. Another object of the present invention is to make it possible to easily create a table calculation formula without being conscious of the calculation formula, thereby reducing errors in formula calculation and improving operability (reducing the number of procedures).

[0007]

The object of the present invention is to store tabular information including a plurality of cells for inputting numerical values and the like in a storage device and calculate the spreadsheet with the tabular information displayed on a display device. In the method, guidance for prompting a start position cell of a spreadsheet for each item such as quantity or unit price is displayed on a display device, and in response to this, the start position cell of one item is indicated by a key or a pointing device. After the start position cell is stored in the storage device by the operation of the execution key or the like, guidance is displayed on the display device to specify up to which cell the calculation is to be performed, and the spreadsheet calculation instruction method or the device sequentially performs the spreadsheet instruction. You. According to this configuration, when creating a formula for a stylized table, it is possible to easily specify the type of the table and the cell position of the item to be calculated, and easily calculate the table without being aware of the formula. Can be performed.

[0008]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings using a Japanese word processor as an example.

FIG. 1 shows an example of a hardware configuration of a document creating apparatus for implementing the present invention.

In FIG. 1, reference numeral 1 denotes an input unit such as a keyboard for inputting an instruction for inputting a character, a key line or the like, or a pointing device such as a mouse for specifying an operation target or inputting a key line or the like. is there. 2 is a liquid crystal display or CR that displays document information such as characters and key lines.
It is a display unit such as a T display. A data storage unit 3 stores characters, key line data, and the like.

The storage unit 3 stores fixed-form table calculation formula data 8 corresponding to the fixed-form table.

Reference numeral 4 denotes a control unit such as a microprocessor for controlling each unit. The control unit 4 includes a fixed-form table calculation formula creation control unit 5 for controlling creation of a fixed-form table calculation formula.

The fixed-table-calculation-formula creating control unit 5 includes an item cell position input instructing unit 6 for instructing an input of an item cell position of a table, and the cell position input by the item cell position input instructing unit 6 and the cell position. It has a calculation formula creation execution unit 7 for creating a calculation formula from the formula data 8 for a fixed table.

FIG. 2 is a flow chart of a fixed-form table calculation formula creation process in which a calculation formula of a fixed-form table created in a document can be created by simply designating the position of an item (cell) in the table. . The flowchart of the fixed-table calculation formula creation process will be described below using the process of creating the calculation formula of the estimate in FIG. 5 as an example.

[0015] When the fixed-table calculation formula creation function is selected,
First, at step 21, a fixed-form calculation menu screen as shown in FIG. 6 is displayed.

Next, at step 22, the user selects a table format. Here, since the estimate corresponds to the slip format, the slip format is selected.

Next, at step 23, guidance for indicating the reference position (first row, first column) of the table as shown in FIG. 7 is displayed, and at step 24, when the reference position is designated as the "article name" column. Each cell is recognized as shown in FIG.

Next, the formula data corresponding to the type of the fixed table selected in step 26 is called from the fixed formula table data 8 in the storage unit 3. The called data is shown in FIG.
10 and the item cell position table of FIG. 10, and the data corresponding to the selected fixed table type is called.

The calculation formula data of FIG. 9 stores the calculation formulas of the corresponding fixed form table in advance, and in the case of the slip shown as an example, four calculation formulas are stored.

FIG. 10 is a table for storing the cell position of each item appearing in the calculation formula data of FIG. 9, and has a column for storing the cell position of each item or a numerical value (immediate value).

A calculation formula is created based on the information of the item cell position table of FIG. 10 and the calculation formula data of FIG.

The storage of information in the item cell position table is as follows.
In step 27, it is determined whether or not the information of the item name in the item cell position table has been determined. If there is any information that has not been determined, the item cell position input instruction processing in step 28 performs an input to the item cell position table. Information storage is performed.

The item cell position input instruction processing will be described below with reference to the flowchart of FIG.

First, at step 31, a message corresponding to the item name of the item cell position table is displayed.

In the case of the item name “quantity (start)”, FIG.
As shown in the guidance column, "Where is the starting position of" Quantity "? Is displayed, and a state of waiting for key input (waiting for cell position designation) in FIG. 11 is entered.

If the user designates the "quantity" cell position in step 33, the designated cell is highlighted in step 34-1. In this state, guidance for where to put the next "amount" is displayed, and step 34-2 is displayed.
Waits for a key input and waits for the next cell specification. When a key is input, the cell position is determined in step 34-3, and the obtained cell position is stored in the item cell position table.

In the case of the item name “quantity (start)”, FIG.
If the cell of the black-and-white inverted part is designated, then 2 rows and 2 columns are stored as the cell position information of the item cell position table of the item name "quantity (start)".

In the table of this example, the item name of the table is also "quantity". However, depending on the table, it may be "number". In this case, the user is the same as "quantity". You need to indicate the meaning item.

In the same manner, each item name “unit price (start)”, “amount”
(Start), "Quantity / Unit Price / Amount (End)" and "Total Amount" (FIGS. 12 to 15) are displayed, and when the user specifies the position, the cell position is displayed in the item cell position table. Stored as information.

On the other hand, for an item such as "tax rate" which may not have a cell position in the table, a message guidance display in step 31 is displayed as shown in FIG. By pressing the key, numerical values can be entered.

If the tax rate input key is depressed, the process moves to step 35 in the input judgment of step 33, and FIG.
A window for inputting numerical values is displayed as shown in step 3.
The key 6 (numerical value) waits for input.

Here, when a numerical value is input, step 3
The numerical value obtained in step 7 is stored in the item cell position table.
If the end key is pressed in step 32, the item cell position input instruction processing ends.

In this example, assuming that the user has also specified the cell positions of “total tax-included amount” and “consumption tax amount” with respect to the guidance in FIGS. 18 and 19, the item cell position table is as shown in FIG. Determine.

As shown in FIG. 20, the cell position table stores information on either the cell position or the numerical value when looking at each item.

If an end instruction is specified in step 33, all the formulas may not be required depending on the table, and therefore, the formula is executed without storing all the item cell position tables. It may proceed to processing.

When the item cell position table is determined as described above, the process proceeds from step 27 to step 29,
The calculation formula creation process of step 29 is performed.

Next, the calculation formula creation processing will be described with reference to the flowchart of FIG.

First, in step 41, the data of the first calculation formula is extracted.

In the case of the illustrated example, there is calculation formula data as shown in FIG. 9, and the first calculation formula data ““ quantity ”*“ unit price ”=“ amount ”()” is extracted.

Next, at step 42, it is confirmed by referring to the item cell position table whether or not the cell positions of all the item names of the calculation formula or the numerical values are determined.

If there is an undetermined item name, the process proceeds to step 44, where this formula is not created.

If all the item cell positions have been determined, at step 42, the item names of the calculation formula are replaced with cell positions or numerical values to complete the calculation formula. "Quantity""Unitprice"
The calculation formula data is rewritten with reference to the item cell position table for the cell position of “money”, and the calculation formula is completed as “2 columns × 3 columns = 4 columns (2 rows to 4 rows)”.

Subsequently, at step 44, it is confirmed whether or not there is a next calculation formula. If not, the process is terminated. If there is, the next calculation formula is taken out, and the processing from step 42 is performed again.

In the case of such an example, four calculation formulas are completed as shown in FIG.

[0045]

As described above, when a standardized table is created, it is possible to easily indicate the type of the table and the cell position of the item to be calculated without having to be aware of the calculation formula. Spreadsheet calculations can be performed, making it unnecessary to create calculation formulas, eliminating errors in formula creation, and greatly improving operability.

[Brief description of the drawings]

FIG. 1 is a diagram showing an example of a hardware configuration of a document creation device for implementing the present invention.

FIG. 2 is a flowchart for realizing a routine table calculation formula creation control process according to the present invention.

FIG. 3 is a flowchart for realizing an item cell position input instruction process according to the present invention.

FIG. 4 is a flowchart for realizing a calculation formula creation execution process according to the present invention.

FIG. 5 is a fixed-form table sample for explaining an example of the present invention.

FIG. 6 is a screen example of a routine calculation formula creation menu according to the present invention.

FIG. 7 is a screen example when a standard table reference position is specified in the present invention.

FIG. 8 is an explanatory example of a standard table reference position in the present invention.

FIG. 9 is an explanatory example of calculation formula data in the present invention.

FIG. 10 is an explanatory example of an item cell position table according to the present invention.

FIG. 11 is a screen example 1 at the time of implementation in the present invention.

FIG. 12 is a screen example 2 at the time of implementation in the present invention.

FIG. 13 is a screen example 3 at the time of implementation in the present invention.

FIG. 14 is a screen example 4 at the time of implementation in the present invention.

FIG. 15 is a screen example 5 at the time of implementation in the present invention.

FIG. 16 is a screen example 6 at the time of implementation in the present invention.

FIG. 17 is a screen example 7 at the time of implementation in the present invention.

FIG. 18 is a screen example 8 at the time of implementation in the present invention.

FIG. 19 is a screen example 9 at the time of implementation in the present invention.

FIG. 20 is an example of determining a screen cell position table at the time of implementation in the present invention.

FIG. 21 is an example of completion of a calculation formula at the time of implementation in the present invention.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Input part, 2 ... Display part, 3 ... Storage part, 4 ... Control part, 3
1, 32, 33, 34-1 to 4 ... steps of processing.

Claims (3)

[Claims] 1. A method of storing tabular information including a plurality of cells for inputting numerical values and the like in a storage device and performing a spreadsheet calculation with the tabular information displayed on a display device. Is displayed on the display device for prompting the user to specify the start position cell of the spreadsheet for each item, and the start position cell of one item is indicated by a key or a pointing device in response thereto, and the start position is operated by operating the execution key or the like. A spreadsheet instructing method for displaying, on a display device, guidance for designating up to which cell to calculate after storing cells in a storage device, and sequentially instructing spreadsheets. 2. An input unit such as a keyboard or a pointing device which is operated by a key operation to input an instruction to create a document by a key input, a data storage unit for storing data input by the input unit, and the storage unit In a table calculation instruction method and apparatus comprising a display unit for displaying data stored in a storage unit and a control unit for controlling the input unit and the display unit, when creating a stylized table calculation formula, the input unit A spreadsheet calculation instruction apparatus comprising a fixed-form table calculation formula creating means for creating a calculation formula by referring to the fixed-form table calculation formula data in the storage unit by indicating the type of the table and the cell position of each item of the table from . 3. The spreadsheet instructing apparatus according to claim 2, further comprising an item cell position input indicating means for interactively indicating a cell position of each item in the table.