JPH03286362A - Table calculating device - Google Patents

Abstract

PURPOSE:To set a cell label to a notion familiar to the persons by providing a new label setting part and a cell label change/selection part. CONSTITUTION:A cell label setting part 7 is added to the next stage of a cell label change/selection part 3 so that a cell label can be set to an optional type in addition to an A1 type and a C1R1 type. In this case, the cell labels of a table calculation sheet can be turned into the labels of notions familiar to the persons like the names of objects, the unit prices, the amounts of money, etc. In addition, it is possible to evade such an inconvenient case where the label length is increased in response to the increase of the number of rows and columns. Thus a user can easily handle the labels.

Description

[Detailed description of the invention] [Industrial application field]

The present invention relates to a spreadsheet device that can prevent previously set formulas from being accidentally destroyed and can arbitrarily change cell labels.

[Conventional technology]

In spreadsheet devices equipped with computer functions, by displaying a spreadsheet on the display and entering the number to be calculated into a cell (a column divided by rows and columns) of the spreadsheet, calculations can be performed in another cell. Getting results is being done. Conventionally, the expression format for the cell position (cell location 1) is A1.
Two types are commonly used: type and C1R1 type. Figure 5 shows an example of a spreadsheet expressed in Al type,
FIG. 6 shows an example of a spreadsheet expressed in C1R1 format. In the spreadsheet shown in Figure 5, the column labels (names) are A for the first column, B for the second column, C, D..., Z, AA, etc.
It is represented by alphabets like AB,..., AZ, BA,.... The row labels are 1. 2. Hereafter 3.4. It is expressed numerically like... Since the upper leftmost cell coordinates are indicated by AI, this expression format is called the Al type. In the spreadsheet shown in Figure 6, the column labels are C1C2, .
. . , and the row labels are R1, R2, . . . The upper leftmost cell coordinates are indicated by C1R1, so this expression format is called the C1R1 type. FIG. 3 shows a bronch configuration diagram of the conventional spreadsheet X device.
In FIG. 3, 1 is an input section, 2 is a command discrimination section, and 3
4 is a cell label change selection section, 4 is a default label switching section, 5 is an input/edit processing section, and 6 is another processing section. Before starting an operation, select the menu for the operation you are trying to perform from the displayed operation menus.An example of an operation menu is the "Input/Edit" menu for manually inputting numerical values into the cells of a spreadsheet. There is also a "Print" menu to print out the calculation results. When an operation menu is selected, a command determined according to the type of operation is issued from the input unit 1. The input command is determined by the command discriminator 2.
It is determined whether it is an editing command or something else. If it is a manual/editing command, the cell label change selection section 3 selects whether to change the expression format of the cell label of the spreadsheet. As mentioned above, there are only two expression formats, Al type and C1R1 type, so the first spreadsheet displayed is A1.
If it is a C1R1 type, the user will have to choose whether or not to change it to the C1R1 type. If you want to change it, use the default label switching unit 4 to switch to the other default label, C1R1 type (the first spreadsheet displayed is C1R1).
If it is type 1, there is no need to switch). In the input/edit processing section 5, numerical values are manually entered from the human input section 1 into the spreadsheet sort cells determined as described above. Additionally, the results of those numerical calculations are displayed in separate cells. To add the calculation formula to a cell, select another operation menu and use the operation of the other processing unit 6 to add the cent.For example, in the spreadsheet shown in FIG. 5, FCIII contains the unit price input in cell FBIIII. cell FA1 for the item
If you want to display the amount including consumption tax for the number of items entered, set the following formula. It is assumed that the consumption tax rate of 3% is paid in the cell FC114. FAIII X FBIIIIX ((PC114+10
0)+100) According to this formula, 109.18, which is the calculation result of 2x53 x (3+100)+100, is displayed on the FCIII. Regarding the spreadsheet shown in FIG. 6, human labor and calculation results are displayed in the same manner.

[Problem to be Solved by the Invention 8] (Problems) However, the conventional spreadsheet device described above has the following problems. The first problem is that cell labels for Al type and C1R1 type are bland and difficult for people to understand, and when the number of columns and rows increases, they become long and difficult for users to handle. be. The second problem is that if you accidentally enter a numerical value into a cell whose calculation formula is in cents, the formula that was in cents will be destroyed. (Description of Problem) First, the first problem will be explained. If you input the number of objects into an Al type cell FAIII, rFAll is a symbol that has nothing to do with the number of objects, so it would be bland and difficult for people to understand.
The length of cell labels increases as the number of columns and rows increases.
This is especially severe for the C1R1 type. Next, the second problem will be explained. There is usually a difference between a person (programmer) who sets calculation formulas on a spreadsheet to create a given spreadsheet, and a person (user) who manually inputs numbers into the spreadsheet. It is. In order to make operations easier for any of the above-mentioned tasks, the input method is to press a number key or letter key, and then press an execution key (e.g. return key). It's the same way. Therefore, if a user enters a number by mistake into a cell with a set formula, the set formula will be destroyed. In this case, the formula must be set again,
Restoration will take time and effort. An object of the present invention is to solve the above-mentioned problems.

[Means to solve the problem]

In order to solve the above problems, in the spreadsheet device of the present invention, in order to make the cell labels of the spreadsheet more familiar to people and not to make them long even when the number of rows and columns increases,
a default label switching unit that switches cell labels of a spreadsheet expressed in the Al type expression format or the C1R1 type expression format to the other of the two expression formats; and a new label switching unit that newly sets the cell labels. The cell label setting section includes a label setting section, and a cell label change selection section that operates the default label switching section or the new label setting section according to an instruction at the time of input. In addition, in order to prevent the formula entered into a cell from being destroyed due to a human error, an input section is provided that has a formula editing menu and a formula end menu as operation menus, a flag memory, and the formula editing menu. a flag setting section that sets a flag in the flag memory when j, - is selected and releases the flag in the flag memory when the formula end menu is selected; It is equipped with a flag determination section that determines the state of the flag, and a message display section that displays a message according to the state of the flag, and it is possible to edit the formula only when the flag is set for the cell containing the formula. It was decided to.

[For production]

With the above configuration, by operating the new label setting section, the cell label of the spreadsheet can be changed to a label with a concept that is familiar to people, such as the name of an item, unit price, or amount of money. Furthermore, even if the number of rows and columns increases, the Rahel will not become longer. In addition, a new ceremony editing menu and ceremony end menu have been added.
A flag is set when the formula editing menu is selected, and the flag is cleared when the formula editing menu is selected. The cell determining unit determines whether the cell selected by the cursor or the like is a cell with 2 set or not. When the cell contains a formula, the flag determination unit detects the state of the flag,
Editing of 2 is only possible when the flag is set.

【Example】

Embodiments of the present invention will be described in detail below with reference to the drawings. FIG. 1 is a block diagram of a spreadsheet device of the present invention. The symbols correspond to those in FIG. 7 is a new Rahel setting section, 8 is a flag setting section, and 9
1 is a cell discriminating section, ] is a flag discriminating section, 11 is a flag memory, 12 is a message display section, and K is a label setting block. The first structural feature of the present invention is to replace the cell label with the conventional A.
The new label setting section 7 is added after the cell label change selection section 3 so that it can be set arbitrarily in addition to the type I and CI Rl type. The second feature is that the cell determining unit 9. Flag determination unit 10. The main points are that a flag memory 11 and a message display section 12 are newly installed. In the present invention, "Edit formula" and "End formula" are provided in the operation menu.
A new menu has been created, and the corresponding commands are given for each menu. When setting a formula in a cell, select the operation menu ``edit formula'' and then select the operation menu ``end 1 formula'' when you finish setting the formula. When the formula editing menu is selected, the flag setting unit 8 sets a flag in the flag memory 11 and a formula can be set in the cell, but when the formula end menu is selected, the flag is cleared and cents cannot be set. The flag determining section 10 determines whether or not the flag is set, and the message display section 12 displays a message in accordance with the determination result. FIG. 2 is a flowchart illustrating the operation of the spreadsheet device of the present invention. Item numbers ■ to [stocks] in the following explanation correspond to steps ■ to [stocks] in the flowchart. ■ Determine whether or not the input/edit menu has been selected from among the various operation menus. When the input/edit menu is selected, a corresponding command is issued from the input section 1, and the command is discriminated by the command discriminating section 27 and executed. ■ There are many operation menus other than the input/edit menu, but it is determined whether the expression editing menu is selected from among them. This is also performed by the command determination unit 2. ■ Similarly, determine whether the ceremony end menu has been selected. ■ Check whether to use the default label Al type or C1R1 type as the cell label, or to set a new label. This is performed by the cell label change selection section 3 according to instructions from the person operating the spreadsheet device. ■ If you want to use a default label, specify either Al type or C1R1 type. The spreadsheet currently displayed on the display is Al
If it is type A1, you can leave it as is if you want to use type A1. If you want to use the C1R1 type, switch it using the default label switching section 4. ■ If you want to change to a new label, set it in the new label setting section 7. In this case, the user can arbitrarily assign a label. Figure 7 shows an example of spreadsheet sort expressed using new labels. In this example, the spreadsheet initially displayed on the display is a table like the one shown in Figure 5 expressed in Al type. This is a calculation sheet with some cell labels set as shown. That is, the column labels FA, FB, and FC are changed to new labels such as "Quantity,""UnitPrice," and "Amount," respectively, and the row labels 111 and 112 are changed to "Mikan," and "Amount," respectively. The label has been changed to "Apple." Furthermore, the cell FB114 immediately before the cell containing r3J, which represents the consumption tax rate of 3%, is labeled "Tax rate J." By making the above changes, the step [phase] When setting calculation number 2, the expression can be expressed with a new label.For example, the price number 2 for oranges is as follows: "Number of oranges x unit price of oranges x ((tax rate + 100) + 1
00 ) J In other words, an expression can be expressed using a label with a concept that is easy for people to understand, and even if the number of columns or rows increases, the label will not become long. ■ The display of spreadsheet N-1 on the display,
Update to what is specified or set using STEAPE■,■. In addition, steps ■～■ are in the block, but
This blower processing is performed by the label setting pro shown in Figure 1.
It will be held in 2020. ■ When you select the expression editing menu, the command determination section 2
A signal is sent to the flag setting section 8, and the signal is sent to the flag memory J1.
flag. ■ When you select the expression end menu, the command determination unit 2
A signal is sent to the flag setting section 8, and the signal is sent to the flag memory 11.
clear the flag. ■ When an operation menu (eg, print menu) other than the input/edit menu, formula edit menu, or formula end menu is selected, the process corresponding to that operation menu is executed. ■ The following sections are related to input to the cells of the spreadsheet. First, it is determined whether the cell selected with a cursor or the like has a formula set, or whether a numerical value should simply be entered. This is done in the cell discrimination section 9. For example, in the spreadsheet shown in Figure 5, cell FAIII
is the cell in which you should enter a numerical value, so when you select this cell, it does not mean that you have selected the second cell. At this time, proceed to step O. However, since cell FCIII is a cell in which a formula for calculating an amount is set, when this cell is selected, the cell containing the formula is selected. At this time,
Proceed to step @. (2) When a cell in which "2" is selected is selected, the flag determining section 10 checks whether or not a flag is set. ■ Not flagged (that is, unflagged)
Sometimes, a signal is sent to the message display section 12 to display a message indicating that the cell can only be edited after selecting the formula editing menu. In this case, the set expression cannot be modified in any way, so the expression is protected. Even if you select a cell where O2 is set, if the flag is set, or if you select a cell where O2 is not set, you can freely manually edit the cell. I can do it. Manual entry of numbers into cells where numbers should be entered is also done here. If you want to add a new formula to a cell or modify an existing formula, you can do that in this step as well. FIG. 4 shows a spreadsheet for explaining how to edit formulas. In this example, there is a field marked ``Edit formula'' in the spreadsheet notebook, and by selecting this field with the cursor or mouse, it is assumed that the formula editing menu j- has been selected. . Therefore, for example, the hatched cell C2 has cell A2
If you want to display the product of the numerical value r300 input in cell B2 and the numerical value "5" input in cell B2, do as follows. First, select the formula editing menu, then select the cell with diagonal lines, and enter rA2 in the field to the right of the formula editing field.
Write the formula "XB2". This causes this formula to be sent to cell C2. As described above, the spreadsheet device of the present invention provides the following effects. - The cell labels of the spreadsheet can be set to concepts that are easy for people to understand, and even if the number of columns and rows in the spreadsheet increases, the spreadsheet will not become long. ■ By making it impossible to edit a cell in which 2 is set until after selecting the formula editing menu and setting a flag, it is possible to prevent the 2 that was set from being destroyed due to human error when inputting numerical values. There will be no need to be rejected. In addition, on the upper side, there is a configuration that allows you to set a new label in addition to the default label for the cell label of the spreadsheet notebook,
Although a spreadsheet device has been shown that is equipped with both a structure that prevents the spreadsheet from being destroyed due to human error, it is also possible to use a spreadsheet device that has either one of them.

【Effect of the invention】 [Brief explanation of drawings]

Fig. 1...Block configuration diagram 2 of the spreadsheet device of the present invention
Fig. 3: A flowchart explaining the operation of the spreadsheet device of the present invention. Fig. 3: Block diagram of a conventional spreadsheet device. Fig. 4: Spreadsheet sheet explaining how to edit formulas. Figure 5: Example 6 of a spreadsheet notebook expressed in Al type
Figure...Example of a spreadsheet expressed in C1R1 typeFigure 7...In the spreadsheet diagram expressed using new labels, l is the input section, 2 is the command discrimination section, and 3 is the cell label change A selection section, 4 a default label switching section, 5 an input/edit processing section, 6 another processing section, 7 a new label setting section, 8 a flag setting section, 9 a cell discrimination section, 10 a flag discrimination section, 11 is a flag memory, and 12 is a message display section.

Claims (2)

[Claims] (1) A default label switching unit that switches the cell label of a spreadsheet expressed in the A1 type expression format or the C1R1 type expression format to the other of the two expression formats, and a new cell label. A spreadsheet device comprising: a new label setting section for setting a new label; and a cell label change selection section for operating the default label switching section or the new label setting section according to an instruction at the time of input. (2) an input section having a formula editing menu and a formula end menu as operation menus; a flag memory; when the formula editing menu is selected, a flag is set in the flag memory; and when the formula end menu is selected, a flag is set in the flag memory; a flag setting unit that cancels the flag in the flag memory; a flag determining unit that determines the status of the flag for the selected cell of the spreadsheet; and a message display unit that displays a message according to the status of the flag. A spreadsheet device comprising: a cell in which a formula is set, and formula editing is enabled only when a flag is set.