JPH0567126A - Method and device for list calculation processing - Google Patents

Abstract

PURPOSE:To obtain a method and device for list calculation processing capable of easily confirming a cell on which an operation expression is set or a cell referred by the operation expression set on the cell in list calculation processing. CONSTITUTION:In the list calculation processing, a large number of cells are arranged on a display screen SC in matrix shape, and data is arranged and displayed on the desired cell of each cell, and the operation expression referring to another cell is set on a desired arbitrary cell. A computed result by the operation expression is displayed on the cell. At this time, the cell on which the operation expression is set is displayed by setting display attribute different from that of another cell. Also, the cell referred by the operation expression is displayed by setting the display attribute different from that of another cell by designating the cell on which one operation expression is set.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a spreadsheet processing method and device suitable for application to a spreadsheet device constructed by using a computer device or the like.

[0002]

2. Description of the Related Art Various kinds of spreadsheet software for utilizing a computer or the like to execute spreadsheets are commercially available. This type displays a table on the display screen in which rectangular grids separated by vertical and horizontal frame lines are arranged. Generally, this type of square is called a cell. In spreadsheet calculation, the operator inputs data to each cell in correspondence with the display screen. Different cell addresses are assigned to each cell, and each cell can be specified by this cell address. Each row in the table is assigned a row number and each column is assigned a column number. Generally, the cell address of each cell is specified by a row number and a column number, which allows the operator to refer to each cell. It should be noted that each cell is divided by actually displaying a frame line on the display screen, and there is a virtual one, in which the frame line is not displayed on the display screen. ..

When inputting data into a desired cell, the operator can specify the cell address to input the data. Generally, this type of device has a cell pointer, and when a cell address is designated, the cell pointer moves to the designated cell to determine a cell into which data can be input. Some cell pointers are configured to be movable by keys arranged on a keyboard or coordinate input means such as a mouse to facilitate cell selection. In any case, the operator selects a desired cell and inputs desired data into the cell using a keyboard or the like.

Each cell is configured to be able to display the calculation result of the data input to the desired cell. Therefore, an arithmetic expression can be set in each cell. In creating this arithmetic expression, each target cell is referred to by the cell address. When an arithmetic expression is set, the result of the operation is displayed in this cell. When it is necessary to confirm the cell in which the arithmetic expression is set or the arithmetic expression set in the cell during or after the creation of the table, the cell pointer is moved to the corresponding cell. As a result, in general, the arithmetic expression is displayed at the bottom of the display screen or the position of the cell,
By this, the operator can confirm that the desired arithmetic expression is set in the desired cell. In addition, it has a function to display or print the list of calculation formulas set in cells. Especially, when there are many cells with calculation formulas set, and the cells to which this calculation formula refers are complicated, the operator can calculate This makes it easier to check the formula.

The table can be set much larger than the display screen, and a part of this table is displayed on the display screen. Then, the display unit can be moved by a technique such as scrolling, so that the operator can check and operate the entire table.

References to this type of technology include Japanese Patent Laid-Open Nos. 63-138459 and 62-239267.
And JP-A-62-206664.

[0007]

In the conventional device described above, when an arithmetic expression is input to a cell, only the arithmetic result is displayed in the corresponding cell in the table. Therefore, in order to confirm the cell in which the arithmetic expression is set or the arithmetic expression itself, as described above, the cell pointer is moved to the corresponding position and the arithmetic expression is displayed at the lower part of the display screen. Also,
When there are many cells in which the arithmetic expressions are set and the reference cells of each arithmetic expression are intricately complicated, the arithmetic expression list is displayed or printed in order to confirm the entire reference relationship. This function is convenient for confirming what kind of arithmetic expression is set in which cell. However, in this type of spreadsheet apparatus, it is extremely important to confirm the cell in which the arithmetic expression is set and which cell the arithmetic expression set in a certain cell refers to. In the conventional one, only the calculation formula is displayed, and the operator sets the calculation formula from this formula,
Alternatively, the cells referred to by the arithmetic expressions set in the cells have to be confirmed one by one, and a large number of man-hours are spent for this confirmation work.

The present invention has been made in view of the above points, and an object of the present invention is to obtain a spreadsheet processing method and apparatus capable of improving operability.

Another object of the present invention is to obtain a spreadsheet processing method and apparatus in which it is easy to confirm the cells for which the arithmetic expressions are set.

Another object of the present invention is to provide a spreadsheet calculation method and apparatus which can intuitively confirm a cell for which an arithmetic expression is set.

Another object of the present invention is to provide a spreadsheet processing method and apparatus capable of easily finding an error in setting an arithmetic expression and improving operability.

Another object of the present invention is to obtain a spreadsheet processing method and apparatus in which the cells referred to by the arithmetic expression can be easily confirmed.

Another object of the present invention is to obtain a spreadsheet processing method and apparatus capable of intuitively confirming the confirmation of a cell referred to by an arithmetic expression.

Another object of the present invention is to provide a spreadsheet processing method and apparatus capable of easily detecting an error in a cell referred to by an arithmetic expression and improving operability.

[0015]

To achieve the above object, a feature of the present invention is to display a cell in which an arithmetic expression is set with a display attribute different from that of other cells. ..

As display attributes, the background of the cell, the background color,
Various types such as a character form of display data or a combination thereof can be used. The cells for which the arithmetic expressions are set may have the same display attributes or may have different display attributes.

Another feature of the present invention is that
This is because the display attribute of the cell referred to by the arithmetic expression set in an arbitrary cell is different from that of other cells.

In this case, the referenced cells may have the same display attribute as each other or may have different display attributes.

Further, a feature of the present invention is that, for one cell in which an arithmetic expression is set, a cell referred to by the arithmetic expression is displayed with a display attribute different from that of other cells. It is in.

In this case, the referenced cells may have the same display attribute or different display attributes. Furthermore,
In this case, the referenced cells may have the same display attributes as each other, and the cells in which the arithmetic expressions are set may have different display attributes from the referenced cells.

In the construction of the apparatus, at least an arithmetic cell storage section for storing information for specifying a cell for which an arithmetic expression is set, and a cell for which the arithmetic expression is set based on the stored contents of the arithmetic cell storage section. Cell display means for displaying a display attribute different from other cells on the display screen.

Preferably, the arithmetic cell storage unit stores at least information specifying a cell for which an arithmetic expression is set and a cell referred to by this arithmetic expression, and the cell display means stores the stored contents of the arithmetic cell storage unit. Based on this, a cell for which an arithmetic expression is set and a cell referred to by this arithmetic expression are displayed on the display screen with display attributes different from those of other cells. On this occasion,
The cell storing the arithmetic expression and the cell referred to by the arithmetic expression may be displayed with the same display attribute,
If different display attributes are adopted, they can be easily distinguished.

More preferably, the cell display means is responsive to the selection of any one cell for which an arithmetic expression has been set, and is referred to at least by the selected arithmetic expression based on the stored contents of the arithmetic cell storage section. Cell is displayed with a display attribute different from other cells on the display screen.

Further, in setting the display attribute of the cell, a cell display attribute storage section for storing the display attribute information of each cell stored in the operation cell storage section in advance is provided so that the cell display means displays the cell. The stored contents of the cell display attribute storage unit may be referred to. Then, preferably, the stored contents of the cell display attribute storage unit can be arbitrarily rewritten.

[0025]

With the above arrangement, among a large number of cells arranged in a matrix, a cell in which an arithmetic expression is set or a cell referred to by an arithmetic expression is displayed separately from other cells. Therefore, the confirmation is extremely easy and can be confirmed intuitively.

Therefore, it is possible to easily confirm cells for which an arithmetic expression needs to be set or for which it is not necessary, and it is possible to greatly improve the operability of table creation and confirmation.

Further, by designating a cell in which an arithmetic expression is set, the cells referred to by this arithmetic expression are displayed in a distinguishable manner, so that reference errors in the arithmetic expression can be confirmed intuitively and easily. Becomes

[0028]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention shown in the drawings will be described below.

FIG. 2 shows an example of a display screen SC of a computer device equipped with conventional spreadsheet software during spreadsheet processing. Here, a group of vertically arranged cells of a matrix forming a table is called a column.
The column symbols B, C, ... Are attached. A group of cells arranged beside the matrix is called a row, and row symbols 1, 2, 3, ... Are sequentially attached from the top. Each cell of the matrix represented by rows and columns is represented and specified by a combination of column and row symbols. Here, for example, the cell in which the numerical value “27” is displayed is the intersection of column D and two rows, so it is expressed as the cell of the “D2” coordinate. Similarly, the cell displaying the numerical value "12" is "C
It is expressed as a cell with 3 "coordinates. The same applies hereinafter.

Here, in the case of this example, cell D in the table of FIG.
The arithmetic expression "D2 = A1 * B2 + C3" is set in 2 and the arithmetic expression "D3 = A1-C2" is input and set in the cell D3. That is, in the cell D2,
An arithmetic expression is set to display the result of multiplying the numerical value input to the cell A1 and the numerical value input to the cell B2 and adding the numerical value of the cell C3 to this value. Similarly, in cell D3, an arithmetic expression for displaying the result of subtracting the numerical value input in cell C2 from the numerical value input in cell A1 is set. However, in FIG. 2, since only the calculation result is displayed in the cells D2 and D3 of the display screen, it is not known whether or not the desired calculation formula is input to these cells D2 and D3.

FIG. 1 (a) shows an example of a display screen SC which is an embodiment of the present invention. That is, according to this embodiment, the cells D2 and D3 in which the arithmetic expressions are set are displayed in a different color or in a hatching pattern from other cells, and which cells the arithmetic expressions are set in can be seen at a glance. Intuitive confirmation is possible. In addition, this distinction is
Various types such as a combination of colors, brightness, and hatching patterns can be adopted. FIG. 1B shows one cell and a cell referred to by an arithmetic expression set in this cell in an easily confirmable manner.
If “2” is selected, the cell referred to by the arithmetic expression set in the cell “D2” as shown in the figure, that is, the cell A1,
All of B2 and C3 are displayed with the same color or brightness or a hatching pattern. As a result, the operator can very easily and intuitively check the cell referred to by the arithmetic expression set in the cell “D2” on the display screen SC, and the workability can be significantly improved. it can.

Here, as a method of selecting a cell in which an arithmetic expression is input, various methods such as a method of designating a corresponding cell with a block cursor or a mouse, a method of inputting coordinates with a keyboard or the like are adopted as described above. can do.

FIG. 3 shows a list of arithmetic expressions in a window on the display screen SC. In this display state, the calculation cursor displayed in the window WIN, or the pattern such as the color or hatching corresponding to this calculation formula is displayed as a block cursor,
Alternatively, when the mouse or the like is selected, the screen shown in FIG. 1B is displayed. That is, if an arithmetic expression for the cell "D2" or a pattern such as a color or hatching corresponding to this arithmetic expression is selected, all the cells related to the cell "D2" are the same as shown in FIG. 1B. It is displayed in color, brightness, or a hatching pattern. Further, here, when an arithmetic expression regarding the cell “D3” or a pattern such as a color or hatching corresponding to this arithmetic expression is selected, all the cells related to the cell “D3”, that is, the cell “A1”,
"C2" will be displayed in the same color, luminance, or hatching pattern.

FIG. 4 is a block diagram showing the overall configuration of a computer device to which the present invention is applied. KB is a keyboard for inputting and instructing character data, numerical data, or various commands necessary for spreadsheets, and is provided with various keys necessary for inputting these various commands and the like. PM
Is a program storage unit that stores various processing programs constituting various processing means necessary for spreadsheet processing operation. C
The PU is a processing unit, which sequentially reads various processing programs stored in the program storage unit PM and executes spreadsheet processing based on various instructions from the keyboard. The DSP is a display unit, and the process of the spreadsheet processing is sequentially displayed on the display screen S.
Display on C. PD is a mouse as a coordinate input device for designating a cell. When various data relating to the spreadsheet is input from the keyboard KB, the processing unit CPU processes the data based on the processing program stored in the program storage unit PM and displays the result on the display screen SC of the display unit DSP. The DM is a data storage unit that temporarily stores input data, intermediate data necessary for performing various processes, and the like. The EXM is an external storage unit that stores and holds the created table file stored in the data storage unit DM for later use, etc. This is read out as needed and stored in the data storage unit DM. Displayed on the display DSP. Then, this is a processing target of the spreadsheet processing means stored in the program storage unit PM. This external storage device E
The XM generally has a storage capacity capable of storing a large number of table files, and these are managed by input / output by different table file names.

In order for this computer device to achieve such a spreadsheet function, for example, a program, which is spreadsheet software, is stored in the external storage device EXM, the program is read if necessary, and the program storage unit is stored. This is possible by storing and storing in the PM, and the processing unit CPU processing and executing this.

FIG. 5, FIG. 6 and FIG. 7 are views showing the data structure of the storage table provided by this embodiment. In FIG. 5, CALTBL is a storage table that stores cell address information, arithmetic expression information, and pattern number information. The program storage unit PM or the data storage unit DM in FIG.
The address is set in advance. The storage table CALTBL is composed of a large number of records, and each record has a storage unit CEL,
It has CAL and PATNO. Of these, the storage unit CEL
, Cell address information, storage unit CAL, arithmetic expression information,
Further, pattern number information is stored and stored in the storage unit PATNO. By the operation of the spreadsheet program, when the operator inputs the cell address and the arithmetic expression to be input to this cell, the specified cell address is stored in the cell address storage unit CEL.
Then, the information indicating the arithmetic expression is stored and stored in the arithmetic expression storage unit CAL. In the storage unit PATNO, pattern numbers are stored in advance in the order of 0, 1, 2, 3, ... This storage unit PATNO will be described later,
It is set considering the convenience of the operator and can be omitted.

The storage table PATTBL shown in FIG.
A storage unit that stores color information and pattern information corresponding to the storage unit PATNO of FIG.
Similar to the storage table CALTBL, the ATTBL also stores the program storage unit PM or the data storage unit D in FIG.
It is set to a predetermined address of M. Memory table PAT
The color information is stored in the storage unit COL of the TBL, and the storage unit PAT is stored.
Stores and stores pattern information. Memory table PAT
In the TBL, pattern numbers are set in order from the beginning corresponding to the record numbers 0, 1, 2, 3, ....
The color information storage unit CAL of each record stores predetermined color information, and the pattern information storage unit PAT stores predetermined pattern information. It should be noted that the operator may be allowed to change the combination of the color information and the pattern information or change the data itself with respect to the storage table PATTBL.

Storage table ATRCEL_TBL in FIG.
Is the cell address of the cell in which the arithmetic expression is input, or the cell address referred to by the arithmetic expression, and whether the corresponding cell address is the cell in which the arithmetic expression is input or the cell referenced by the arithmetic expression. The mark information for distinguishing between is stored. still,
When the program of this embodiment is activated, the storage table ATRCEL_TBL is initialized to all 0s.

The storage table ATRCEL_TBL is composed of a large number of records, and each record is a storage unit ATRCE.
L, ATRMARK. Of these, the memory unit ATR
The cell address information is stored in the CEL, and the cell identification mark information is stored in the storage unit ATRMARK.

In the present embodiment, the storage unit ATRMARK
Stores "0" when an arithmetic expression is set in the corresponding cell address and "1" when the corresponding cell address is a cell referred to by the arithmetic expression.

Further, in this embodiment, as shown in FIG. 1 (b), one arithmetic expression cell and the cell referred to by the arithmetic expression are displayed on the display screen SC with different display attributes. However, it is also possible to display a plurality of calculation formula cells and cells referenced by the calculation formulas on the display screen SC with the same display attribute. In this case, the storage table ATRCEL_
The first arithmetic expression is input to the TBL in order from the first record, and the cell address of the cell, the cell address of the cell referred to by this arithmetic expression, and the second, third, ... .. At this time, 0 and 1 are stored in the storage unit ATRMARK as described above. Further, when a plurality of arithmetic expression cells and cells referred to by the arithmetic expressions are displayed on the same display screen SC, it is possible to refer to the same cell among different arithmetic expressions. In this case, the display attributes of the reference cells of the respective calculation formulas are superimposed and displayed, or a specific display attribute indicating that the cells are referenced by multiple calculation formulas is set, and this display attribute is set. To display the cell.

Basically, the information in the storage unit ATRMARK shows whether the current display screen is as shown in FIG.
This is information for determining whether or not (b). Therefore, in the present embodiment, if the flag indicating the current state of the display screen SC is set and the flag is determined, the information in the storage unit ATRMARK can be omitted. Further, the cell address stored in the storage unit ATRCEL of the storage table ATRCEL_TBL is position information of a cell having a display attribute different from that of other cells, and is set in order to search a different display attribute cell at high speed. Therefore, when executing the program of this embodiment with sufficiently high-speed hardware,
Cell address stored in the storage table CALTBL,
Even if different display attribute cells are obtained each time from the calculation formula, the problem of the processing speed is eliminated, so that it can be omitted.

Storage table CAL shown in FIGS. 5 and 6
In the TBL and storage table PATTBL, the examples shown in FIGS. 1 and 3 are stored as actual data. Further, the storage table ATRCE shown in FIG.
L_TBL shows a state in which the example shown in FIG. 1A is stored and stored as actual data.

That is, in the case of FIG. 1A, the storage unit CA
The pattern number information corresponding to the corresponding cell address is read from LTBL, and the corresponding color information and pattern information is read from the storage table PATTBL based on this pattern number information. Then, the cell in which the arithmetic expression is input based on these pieces of information is displayed in this color and pattern.

In the case of FIG. 1B, the storage table CALT
The corresponding cell is displayed in the color and pattern indicated by the pattern number obtained by adding "5" to the pattern number obtained by reading from the BL. The location of this cell is stored in storage table C
It can be detected from the arithmetic expression information stored in the storage unit CAL of the ALTBL. For example, since the arithmetic expression input to the cell of the cell address D2 is "A1 * B2 + C3", the cells referred to by this arithmetic expression are A1, B2, C.
It becomes 3. Note that, here, the case where the color and the pattern of the cell referred to by the arithmetic expression are obtained by adding “5” to the content of the storage unit PATNO of the record in which the arithmetic expression is stored has been described. May be, for example, "1" added or "10" added. Alternatively, another storage unit PATTBL2 having the same data structure as the storage table PATTBL is provided, and the cell to which the arithmetic expression is input refers to the data in the storage table PATTBL, and the cell referred to by the arithmetic expression is the storage table PATTBL2. The color and pattern for displaying each cell may be determined by referring to this.

Further, in the storage section PATNO of the storage table CALTBL, 0,
Although the case where the data is stored as 1, 2, ... Is shown, the operator may be able to change the data in the storage unit PATNO. In this way, the operator can make a unique display according to the type of table. On the contrary, if the operator does not change the data value of the storage unit PATNO, the storage unit PATNO is not necessary. In this case, the correspondence with the storage unit PATTBL can be uniquely determined by the record number of the storage unit CALTBL.

Here, when the display of the cell referred to by the arithmetic expression set in the cell D2 in FIG. 1A is selected,
By referring to the storage table ATRCEL_TBL in FIG. 7A, records of cell addresses other than the corresponding cell address are sequentially read, and the display attribute of the cell position of the storage unit ATRCEL of this record is displayed in the same display as the cell not related to the operation. The attribute is displayed, that is, the normal display attribute as shown in FIG.
At this time, the information of this record is deleted from the storage table ATRCEL_TBL. Here, the display attribute of the cell address D3 of FIG. 1A is changed, and the record information of the cell address D3 of FIG. 7A is deleted.

Next, as shown in FIG. 1B, as described above, the storage table ATRCEL_TBL at this time is displayed.
Is FIG. 7 (b). That is, the cell address D2 is an arithmetic expression cell, and the cell addresses A1, B2, C3 are arithmetic expression reference cells.

Here, in order to change the screen display of FIGS. 1B to 1A, the storage table ATR of FIG. 7B is displayed.
The cell address of the storage unit ATRCEL of the CEL_TBL is displayed with the same display attribute as that of a cell not related to the operation, that is, a so-called normal display attribute. At this time, the storage table ATRCE
The information of the corresponding record is deleted from L_TBL.
Then, as described above, the storage tables CALTBL and PA are stored.
The corresponding cell may be displayed based on the information obtained from TTBL. At this time, the storage table ATRCEL_TB
L changes as shown in FIG.

FIG. 8, FIG. 9, FIG. 10, FIG. 11, FIG. 12, FIG. 13, FIG. 14, FIG. 15, FIG. 16 and FIG. 17 are flow charts showing the processing procedure forming the main part of the embodiment of the present invention. The program corresponding to this flowchart is stored in the program storage unit PM, and the processing unit CPU executes the program to achieve a predetermined function.

18 and 19 are diagrams showing the data structure of the storage unit used in this embodiment. Although details will be described later, this storage unit is used in the calculation reference cell display process of FIGS. 11 and 12 and the reference calculation cell position acquisition process of FIG. 17.

FIG. 8 is a flow chart showing the flow of the entire processing. When this program is activated, first, at step 100, input waiting processing of a signal that becomes a trigger by a keyboard, a mouse or the like is executed. Here, when a signal serving as a trigger is input, steps 110 and 12
The determination processes of 0, 130, 140, 150 and 160 are executed, and after the execution of these processes, the process returns to the trigger signal waiting process of step 100 again.

If it is determined in step 110 that an arithmetic expression has been input, then in step 170, all arithmetic expression cell display processing means shown in FIG. 9 are executed. Execution of the arithmetic expression cell display processing means here is performed in order to set the current display screen to the initial state, that is, the display screen state of FIG. For example, it is executed to change the display screen state of FIG. 1 (b) to the display screen state of FIG. 1 (a), but when the display screen state of FIG. There is no point in executing the processing means. In such a case, the storage table ATRCEL_TBL in FIG.
It is also possible not to execute all the arithmetic expression cell display processing means by determining whether or not the arithmetic reference cell is displayed from the information of the storage unit ATRMARK. Further, in the case of a display screen in which no arithmetic expression has been input, it is also possible not to execute all of the arithmetic expression cell display processing means by judging from the information in the storage unit ATRCEL.

Next, at step 180, the input processing means of the arithmetic expression shown in FIG. 10 is executed. Here, after the calculation result is calculated, the calculation result is displayed at the corresponding cell position on the display screen SC, and the corresponding cell is stored in advance in the storage table PAT.
This is a process of displaying the color and pattern set in TBL.

In addition, when the arithmetic expression is newly input,
The case of changing the already input arithmetic expression is determined in step 110, and the processes of steps 170 and 180 are executed.

Step 120 is a process of determining whether or not the input trigger information is a display of a cell in which all arithmetic expressions have been input. If it is determined that the display is for the cell in which the arithmetic expression is input, the following step processing 190 is performed.
Then, all the arithmetic expression cell display processing means similar to those in step 170 described above are executed. Here again, there is no point in executing step 190 if the display screen state of FIG. In such a case, as described above, by determining the information in the storage unit ATRMARK or the storage unit ATRCEL of the storage table ATRCEL_TBL, all the arithmetic expression display processing means in step 190 may not be executed.

Step 130 is a process for determining whether or not the cell referred to by the arithmetic expression is displayed. If it is determined in this step 130 that the operation reference cell is displayed, the operation reference cell display processing means described in detail in FIGS. 11 and 12 is executed in process 200.

Step 140 is a process for determining whether or not the list is displayed. If it is determined that the list is displayed in step 140, step 210 is executed as shown in FIG.
The list display process of No. 3 is executed.

In step 150, it is determined whether or not the arithmetic expression deleting process is executed.
If it is determined that the arithmetic expression is deleted at 0, step 22
At 0, the processing for deleting the arithmetic expression in FIG. 14 is executed. This deletion processing of the arithmetic expression is performed along with the deletion of the actual arithmetic expression, and the processing of making the corresponding arithmetic expression cell and the arithmetic reference cell displayed with different display attributes the cell display of the normal display attribute.

If it is determined in step 160 that the trigger information input is not the end of the entire spreadsheet processing, processing other than those described above, for example, inputting or printing numerical values or characters in general spreadsheet processing, is performed. Etc. are executed.

FIG. 9 is a flow chart showing a subroutine of a program which constitutes all the arithmetic expression cell display processing means described above. When this processing means is activated, first, in step 300, “0” is stored in the cell address temporary storage unit CAL_CEL that continues cell display with different display attributes. When the cell address is stored in the temporary storage unit CAL_CEL, all cells except the stored cell address are displayed in the normal display attribute cells, and when "0" is stored, all are displayed in the normal display attribute cell display. To do. That is, when "0" is stored in the temporary storage unit CAL_CEL, the display screen is as shown in FIG.

In the following step process 310, the normal attribute display processing means of the cell shown in FIG. 15 is executed. The information of the temporary storage unit CAL_CEL is determined in this processing means.

In the following step 320, the storage table CA
The cell is moved to the storage information position of the storage unit CEL of the LTBL. In the following step 330, the pattern number temporary storage P
The storage contents of the storage unit PATNO at this time are stored and stored in the ATM. Then, in step 340, the cell display processing means shown in FIG. 16 is executed. Here, the processing of steps 320 to 340 is processing for one arithmetic expression. Therefore, in order to display the arithmetic expression cells for each cell in which the arithmetic expression is input, in step 350, it is determined whether steps 320 to 340 have been executed for all the arithmetic expressions, and all the expressions are executed. If not,
If the processing is moved to step 320 and all the processing is completed, the processing means is ended.

Here, the processing of steps 320 to 340 is achieved by setting a pointer designating a record of the storage table CALTBL and sequentially updating it from the top record in step 350. Whether or not all the arithmetic expression cells have been displayed is determined based on the contents of the record pointed to by this pointer, based on the storage unit CEL or storage unit CA.
The content corresponding to L is determined, and it is determined whether the cell address or the arithmetic expression is stored here.

FIG. 10 is a flow chart showing a subroutine of a program which constitutes the above-mentioned arithmetic expression input processing means. In step 400, an operation is executed based on the input arithmetic expression and the operation result is calculated,
The calculation result is displayed at the corresponding cell position on the display screen SC. Next, in step 410, the input arithmetic expression,
And the cell address are stored in the storage units CAL and C of the storage unit CALTBL.
Store in EL respectively. Then, in step 420, the storage unit PA of the records stored in the storage units CAL and CEL.
The value previously stored in TNO is stored in the pattern number temporary storage unit PATM. Then, in step 430,
The processing is transferred to the cell display processing means shown in FIG. 16 and executed. As will be described later in detail, this cell display processing means is processing for displaying the corresponding cell in the color and pattern preset in the storage table PATTBL.

Here, in order to obtain the position of the record to be stored in step 410, a pointer for designating a record of the storage table CALTBL is set, the arithmetic expression and the cell address are stored in the record indicated by this pointer, and then the next storage is made. This is accomplished by sequentially updating this pointer to point to a possible record.

11 and 12 are flowcharts showing the subroutine of the calculation reference cell display processing means. When the display processing means is activated, first, at step 500, the pointer variable storage unit i is initialized to "0". In the following step 530, the storage table CALT
The cell address stored in the storage unit CEL of the i-th record of BL is stored in the temporary storage unit CEL_DAT. In the following step 540, it is determined whether or not the cell address specified in step 130 is equal to the cell address stored in step 530. If they are not equal, in step 650, "1" is added to the pointer variable storage unit i, and step 5
The processing of 30, 540 is repeated. Here, step 66
0 is a judgment as to whether or not all the arithmetic expression cells in the storage table CALTBL have been searched. For example, when the cell address in which the arithmetic expression has not been input is designated in step 130, an error buzzer is issued in the following step 670. , This subroutine ends.

If it is determined in step 540 that the cell address specified in step 130 and the cell address stored in step 530 are equal, in step 542, the cell address temporary storage unit CA that continues to display cells with different display attributes is displayed.
In L_CEL, the cell address of the arithmetic expression cell where the arithmetic reference cell is to be displayed, that is, the so-called current cell is stored, and in the following step 544, the normal attribute display processing means of the cell shown in FIG. 15 is executed.

In the following step 550, the storage table CA
The arithmetic expression stored in the storage unit CAL of the i-th record of LTBL is stored in the storage unit CAL_REC.

In the following step 560, the processing is transferred to the reference operation cell position processing means described in detail in FIG. 17 and executed. This reference calculation cell position acquisition processing will be described in detail later,
From the arithmetic expression stored in the storage unit CAL_REC, the cell position referred to by this arithmetic expression is acquired, and the storage unit CA
Store in LREF_TBL. FIG. 18 shows the storage unit CAL.
It is a figure which shows the data structure of REF_TBL, and it mentions later in full detail.

In step 570, the pointer variable storage j is initialized to "0". In the following step 580, the value of the storage content of the storage unit PATNO of the record is set to "5".
The value obtained by adding is stored in the pattern number temporary storage unit PATM as the pattern number. Here, in the present embodiment, the pattern number is obtained by adding "5" to the storage content of the storage unit PATNO, but it is not specified as "5" as described above.

At step 590, the storage unit CALREF_
The column symbol referenced by the corresponding arithmetic expression is acquired from the j-th position of TBL. In the following step 600, the storage unit CA
From the j + 1th position of LREF_TBL, the line symbol referenced by the corresponding arithmetic expression is acquired.

At step 610, which follows step 590,
The cell is moved to the column symbol / row symbol position acquired in 600. In the following step 620, the cell display processing described in detail in FIG. 16 is executed to display the corresponding cell in the color and pattern shown in the temporary storage section PATM.

At the following step 625, the storage table AT
Storage part ATR of the current cell position record of RCEL_TBL
Store "1" in MARK. The storage table ATRCEL_TBL of the current cell position is stored in the storage unit ATRCEL in the cell display process of step 620.

At the following step 630, "2" is added to the pointer variable storage unit i, and similarly, steps 590 to 590 are performed.
The process of step 630 is repeated. Where step 6
Reference numeral 40 is a determination as to whether or not all reference operation cells in the storage unit CALREF_TBL have been searched.

As a result, the display of FIG. 1B is achieved.

FIG. 13 is a flow chart showing a subroutine of a program forming the list display processing means.
When the display processing means is activated, first, in step 700, a window is set on the display screen SC and opened. This is possible with a general window technique, and a detailed description will be omitted. In step 710,
The arithmetic expression information is read from the storage unit CAL of the storage table CALTBL, and the pattern number information is read from the storage unit PATNO. In step 720, based on the pattern number information read in step 710, the storage table PATTBL
The color corresponding to the pattern number is read from the storage unit COL and the pattern is read from the storage unit PAT.

At step 730, a legend is displayed in the window WIN with the color and pattern obtained at step 720 as shown in FIG. In step 740, the arithmetic expression read in step 710 is displayed next to this legend. that's all,
Step processes 710 to 740 are list display processes for one arithmetic expression. Step 750 is a determination process for displaying a list of all arithmetic expressions, and it is determined whether or not there are still arithmetic expressions in the storage table CALTBL.
If not all arithmetic expressions are displayed, the process proceeds to step 7.
Then, the processing is moved to 10 and the above processing is executed again for the next arithmetic expression. In this case, this is achieved by setting a pointer designating a record of the storage table CALTBL and sequentially updating it from the first record in step 750. Whether or not there is an arithmetic expression is determined based on the content of the record pointed to by the pointer, the content corresponding to the storage unit CAL, and whether or not the arithmetic expression is stored therein.

Step 760 is a loop for waiting for an input of a signal which is a trigger for a keyboard, a mouse or the like. When a signal as a trigger is input by the operator, the window is closed in step 770 and the original screen is restored.

FIG. 14 is a flowchart showing a subroutine of the arithmetic expression deletion processing means. When this deletion processing means is activated, first, in step 800,
Erase the display of the current cell position. Erasing the display can be accomplished by writing spaces with normal display attributes.
In the following step 810, the record corresponding to the current cell position is searched and deleted from the storage table CALTBL.

Here, in the search for the record corresponding to the current cell position, a pointer for designating the record of the storage table CALTBL is set, and the information stored in the storage unit CEL of the record indicated by this pointer and the current cell position are set. This is accomplished by comparing and sequentially updating this pointer until a match is made.

To delete the record corresponding to the current cell position,
This is achieved by copying the information of the record at the next pointer position to the pointer position indicating the record obtained by the above search, updating this pointer to indicate the next record, and performing the same copy processing sequentially. .. In the following step 820, from the storage table ATRCEL_TBL,
Search for and delete the record corresponding to the current cell position.

Retrieval and deletion of the record corresponding to the current cell position can be achieved by the same processing as in step 800 described above. At this time, in the search processing of the record corresponding to the current cell position, the storage unit AT of the storage table ATRCEL_TBL is
RCEL is used.

At the following step 830, the storage table AT
It is determined whether or not there is a record with a mark other than “0” in the storage unit ATRMARK of RCEL_TBL. This determination processing is to determine whether or not the arithmetic expression reference cell is displayed with a different display attribute on the current display screen SC, and the storage unit ATRMARK is "0".
If it is not, it indicates that the arithmetic expression reference cell is displayed with a different display attribute.

When it is determined in step 830 that the arithmetic expression reference cell is displayed with a different display attribute, in the following step 840, the record of which it is determined that the storage unit ATRMARK of the storage table ATRCEL_TBL is other than 0, The cell is moved to the position of the information stored in the storage unit ATRCEL.

At the following step 850, the character at the current cell position is read out and stored, and then at step 860.
Then, after erasing the display of the current cell position, step 87
At 0, the character already read at step 850 is displayed at the current cell position with the normal display attribute.

After that, the process moves to step 820 again, and the record information of the current cell position is deleted from the storage table ATRCEL_TBL.

Here, steps 840 to 870 and step 820 are processing for one arithmetic expression reference cell. Therefore, when one arithmetic expression refers to a plurality of cells, the determination is made in step 830, and steps 840 to 840 are performed until all the cells referred to by the deleted arithmetic expression have normal display attributes. The process of 870 and step 820 is repeated.

As described in detail in the explanation of FIG. 7, in this embodiment, as shown in FIG. 1B, one arithmetic expression cell and the cell referred to by the arithmetic expression are displayed on the display screen SC. Are displayed with different display attributes from each other, it is possible to display a plurality of arithmetic expression cells and cells referred to by the arithmetic expressions on the same display screen SC. In this case, the storage table ATR
Since the cell address of one arithmetic expression cell and the cell address of the cell referred to by this arithmetic expression are stored in the CEL_TBL in this order, steps 840 to 870 and step 820 are performed only during the cells referred to by the consecutive arithmetic expressions. By executing the processing of (3), it becomes possible to display only the cells referred to by the corresponding arithmetic expression with the normal display attribute.

FIG. 15 is a flow chart showing a subroutine of the cell normal attribute display processing means. When this display processing means is activated, first, step 90
0, storage unit A from storage table ATRCEL_TBL
Read the information of TRCEL. Here, the read information is the cell address of the cell displayed with a different display attribute. In the following step 910, the storage unit CAL_CEL
Then, it is determined whether or not the information in the storage unit ATRCEL read in step 900 matches. Here, the storage unit C
As described above, AL_CEL is provided to specify not to change the display attribute of the cell at the cell address stored here.

At step 910, the storage unit CAL_CEL is stored.
If the information in the storage unit ATRCEL does not match, that is, if it is determined that the cell address stored in the storage unit ATRCEL is to be displayed with the normal display attribute, the cell of the storage unit ATRCEL is continued in step 920. Move the cell to the address. In the following step 930, the character at the current cell position is read and stored, and in the following step 940, the display of the current cell position is erased, and then in step 950, the character already read in step 930 is
Display at the current cell position with normal display attributes. Since what has been displayed with a different display attribute until now is displayed with a normal display attribute, the record information of the current cell position of the storage table ATRCEL_TBL is deleted in step 960.

The processing of steps 900 to 960 so far is processing for making a cell having one display attribute different from that of another cell having a normal display attribute. In order to continuously display a plurality of cells having different display attributes with the normal display attributes, it is determined in step 970 whether or not the processes of steps 900 to 960 have been executed for the cell addresses of the cells having different display attributes. Is performed, and if all have not been executed, the process proceeds to step 900.

In step 910, the storage unit CAL_
If the CEL and the information in the storage unit ATRCEL match, that is, if it is determined that the display attribute of the cell address stored in the storage unit ATRCEL is not changed, the process proceeds to step 970.

Here, to continuously execute the processing of steps 900 to 960, the storage table ATRCEL_T
This is achieved by setting a pointer designating a BL record and sequentially updating it from the top record in step 970. In step 970, it is determined whether or not there is a cell address with a different display attribute by determining the content corresponding to the storage unit ATRCEL from the content of the record pointed to by this pointer and determining whether or not the cell address is stored here. To do.

Further, the deletion processing of the record information at the current cell position in step 960 is performed by the above-mentioned storage table ATR.
Use a pointer to specify the CEL_TBL record,
The information after the pointer position indicating the next record is copied from the position of the current pointer indicating the record in which the current cell position is stored, that is, the information after the pointer position indicating the next record is moved as a whole. Achieve by doing.

FIG. 16 is a flow chart showing a subroutine of a program which constitutes the cell display processing means.
This display processing means performs steps 330, 420, 580.
Then, the record corresponding to the pattern number stored in the pattern number temporary storage unit PATM is acquired, and this is stored in the temporary storage unit PTM.
Store in AT_REC. In subsequent step 1010, the color information of the storage unit COL of the temporary storage unit PAT_REC is acquired and stored in the temporary storage unit COL_DAT. In the following step 1020, the pattern information of the storage unit PAT of the temporary storage unit PAT_REC is acquired, and this is acquired in the temporary storage unit P.
Store in AT_DAT.

Here, the temporary storage unit P of step 1000
The storage processing to AT_REC is performed in steps 1010 and 10
This is a process provided only for facilitating the description of 20 and can be omitted.

In step 1030, the character of the calculation result of the current cell position is read out, and this is read in the temporary storage section DSP_DAT
Remember. In the following step 1040, the current cell position is changed to C
Set to the color attribute of OL_DAT. Continued Step 1050
Then, the pattern information stored in step 1020 and the character of the operation result stored in step 1030 are displayed at the current cell position in an overlapping manner.

FIG. 17 is a flow chart showing a subroutine of the reference calculation cell position acquisition processing means. This reference calculation cell position acquisition processing means is activated,
First, in step 1100, the pointer variable storage units k and l and the switch variable storage unit S used in the present processing means.
FIG. 18 shows the data structure of W and the storage unit CALREF_TBL. In FIG. 18, the storage unit CALREF
In _TBL, the cell address referred to by the corresponding arithmetic expression is stored in the order of the column symbol and the row symbol. The terminator follows the final cell address referenced by the corresponding arithmetic expression. The storage unit CALREF_ shown in FIG.
The TBL shows a state in which the example shown in FIG. 1B is stored and stored as actual data.

In step 1110 of FIG. 17, the storage unit C in which the corresponding arithmetic expression in step 550 is stored.
The Kth data is taken out from AL_REC and stored in the temporary storage unit DAT_WORK. Here, the storage unit CA
The data structure of L_REC is shown in FIG. In FIG. 19, the storage unit CAL_REC stores a corresponding arithmetic expression. A pointer indicating the position of the row symbol, the column symbol, and the operation symbol is K, which is set in the reference operation cell position acquisition processing of FIG.

In step 1120 of FIG. 17, it is determined whether or not the switch variable storage unit SW is "0". The switch variable storage unit SW indicates whether the K-th data extracted from the storage unit CAL_REC is a column symbol or a row symbol, and when "0" is a column symbol or an operation symbol. It is shown that "1" is a line symbol.

If it is determined in step 1120 that the switch variable storage unit SW is "0", that is, the column symbol or the operation symbol, it is determined in the following step 1130 whether or not it is the column symbol. This determination is made by the temporary storage unit DA.
The determination is made as to whether or not the T_WORK data is within the range A to Z. If it is determined in step 1130 that it is a column symbol, in subsequent step 1140,
The temporary storage unit DAT_WO is stored at the position indicated by the pointer variable storage unit 1 of the storage unit CALREF_TBL described in detail in FIG.
Store the RK data.

In step 1150, the switch variable storage unit SW is set to "1", and it is instructed that the data to be extracted from the storage unit CAL_REC is a line symbol. In the following step 1160, this pointer is moved by adding "1" to the pointer variable storage unit l indicating the data storage position of the storage unit CALREF_TBL. Further, in step 1170, this pointer is moved by adding "1" to the pointer variable storage K indicating the data in the storage CAL_REC.

In step 1180, the storage unit CAL_RE is used.
This is a process for determining whether or not there is still data in C. This is determined by whether or not the data pointed to by the pointer variable storage unit K is a terminator.

In the above description, since only the first column symbol has been acquired, the processing moves to step 1110.
In the following step 1120, the switch variable storage unit SW is determined. Since the current switch variable storage unit SW is "1" and the data stored in step 1110 is a line symbol, the process proceeds to step 1190. In this step 1190, the data of the temporary storage unit DAT_WORK stored in step 1110 is stored in the position indicated by the pointer variable storage unit 1 of the storage unit CALREF_TBL.
In the following step 1200, the switch variable storage unit SW is set to "0" so that the data retrieved from the storage unit CAL_REC is a column symbol or an operation symbol. Then, the processing from step 1110 to step 1200 so far is repeated until there is no more data in the storage unit CAL_REC.

In the present embodiment, the range of the column symbols in the table is set to A to Z. However, for example, the range of the column symbols is A to Z, a to g, etc. If they can be designated separately, in step 1130, all the ranges that can be taken as column symbols may be determined. Also,
The storage unit CAL_REC in FIG. 19 always contains a normal arithmetic expression, and the arithmetic expression does not include code information such as spaces and tabs. It is assumed that these checks are all performed at the time of inputting the arithmetic expression in step 110.

As described above, according to the configuration of the embodiment, it is determined in step 110 in FIG. 8 that an arithmetic expression is input, and all the cells for which the arithmetic expression in the table is set are predetermined on the display screen SC. It is displayed with display attributes. Further, when the arithmetic expression is deleted, it is determined in step 150 of FIG. 8, and on the display screen SC, the arithmetic expression of the corresponding table is deleted, and at the same time, all cells referred to by the arithmetic expression are normally displayed. Displayed by attribute.

In addition, during or after the creation of the table,
When it is necessary to confirm the cell in which the arithmetic expression is set, the display instruction of the arithmetic expression cell is input. Then, this is determined in step 120 of FIG. 8, and all cells for which the arithmetic expressions in the table are set are displayed on the display screen SC with a predetermined display attribute. With these, the operator can easily and intuitively check the cell in which the arithmetic expression is set.
As a result, the operability of tabularity can be improved.

When it is necessary to confirm the cell referred to by the arithmetic expression set in one cell,
Input the display command of the calculation reference cell. Then, this is determined in step 130 of FIG. 8, and all cells referred to by this arithmetic expression are displayed with a predetermined display attribute on the display screen SC. As a result, the operator can easily and intuitively check the cells referred to by the arithmetic expression, can easily determine erroneous settings of the arithmetic expression, etc., and consequently improve the operability of table creation. it can. This is especially easy to find visually erroneous arithmetic expressions even if you input the wrong arithmetic expression when the arithmetic expression is complicated and greatly improves operability. can do.

Also, in the arithmetic expression list display, the display attribute is displayed together with the arithmetic expression. When the display attribute is selected with a keyboard, a mouse, or the like, the original tabular screen is displayed again, and the corresponding arithmetic expression and arithmetic expression reference cell can be displayed with the selected display attribute. Therefore, it is possible to easily retrieve the arithmetic expression, which greatly improves the operability for the user.

Incidentally, this kind of command may be inputted by a command, or a menu or the like may be displayed on the display screen SC and selected. Furthermore, by moving the cell pointer to the cell in which the arithmetic expression is set, the cell referred to by the arithmetic expression set in this cell may be automatically displayed with a predetermined display attribute.

In the above, in the embodiment, the case where the color and the hatching pattern are used as the display attributes of the cells has been described. However, the display attributes include the background, the background color, the character form of the display data, or a combination thereof. Various types can be used. When the display device is not in color display, gradation, hatching pattern, halftone pattern, reverse display, or the like can be used. In short, various display attributes can be used as long as the operator can distinguish from other cells, and the display attributes are not particularly limited to the above and a wide variety can be used. Is.

[0113]

As is apparent from the above description, according to the present invention, among a large number of cells arranged in a matrix, a cell in which an arithmetic expression is set or a cell referred to by the arithmetic expression is Since it is displayed separately from other cells, its confirmation becomes extremely easy and can be confirmed intuitively.
Therefore, it is possible to obtain a spreadsheet calculation method and apparatus which can improve the operability of the spreadsheet in the spreadsheet and consequently improve the efficiency of the spreadsheet.

[Brief description of drawings]

FIG. 1 is a display screen diagram showing an embodiment of the present invention.

FIG. 2 is a display screen diagram in general spreadsheet processing.

FIG. 3 is a display screen diagram showing an embodiment of the present invention.

FIG. 4 is a block diagram showing an example of the overall configuration of a computer device to which the present invention is applied.

FIG. 5 is a memory configuration diagram showing a configuration of a storage table showing an embodiment of the present invention.

FIG. 6 is a memory configuration diagram showing a configuration of a storage table showing an embodiment of the present invention.

FIG. 7 is a memory configuration diagram showing a configuration of a storage table showing an embodiment of the present invention.

FIG. 8 is a flowchart showing an overall processing flow showing an embodiment of the present invention.

FIG. 9 is a flowchart showing a flow of all arithmetic expression cell display processing according to the embodiment of the present invention.

FIG. 10 is a flowchart showing a flow of an arithmetic expression input processing means showing an embodiment of the present invention.

FIG. 11 is a flowchart showing a flow of a calculation reference cell display processing means showing an embodiment of the present invention.

FIG. 12 is a flowchart showing a flow of a calculation reference cell display processing means showing an embodiment of the present invention.

FIG. 13 is a flowchart showing a flow of a list display processing means showing an embodiment of the present invention.

FIG. 14 is a flow chart showing a flow of an arithmetic expression deletion processing means showing an embodiment of the present invention.

FIG. 15 is a flowchart showing a flow of a normal attribute display processing means of a cell showing an embodiment of the present invention.

FIG. 16 is a flowchart showing a flow of cell display processing means showing an embodiment of the present invention.

FIG. 17 is a flowchart showing a flow of a reference calculation cell position acquisition processing means showing an embodiment of the present invention.

FIG. 18 is a memory configuration diagram showing a configuration of a storage unit according to an embodiment of the present invention.

FIG. 19 is a memory configuration diagram showing a configuration of a storage unit showing an embodiment of the present invention.

[Explanation of symbols]

SC: Display screen, A, B, C, ...; Column symbols, 1, 2,
3, ...; Line symbol, CATTBL; Operation cell storage unit, PA
TTBL; cell display attribute storage unit, ATRCEL_TB
L: Cell storage unit of cell display attribute, 170, 190, 20
0,340,430,620; cell display means

Claims (44)

[Claims] 1. A large number of cells are arranged in a matrix on a display screen, data is arranged and displayed in a desired cell of each cell, and an arithmetic expression referring to other cells is set in a desired arbitrary cell. A spreadsheet calculation method characterized in that the calculation result of the calculation formula is displayed in the cell, and the display attribute of the cell in which the calculation formula is set is different from that of other cells. .. 2. The display according to claim 1, wherein when a cell in which an arithmetic expression is set is displayed with a different display attribute from other cells, the display is performed in response to a specific operation. Spreadsheet processing method. 3. The spreadsheet processing method according to claim 1, wherein the display attribute is a background of data displayed in each cell. 4. The spreadsheet processing method according to claim 3, wherein the background is a hatching pattern. 5. The spreadsheet calculation method according to claim 1, wherein the display attribute is a background color of the data displayed in each cell. 6. The spreadsheet processing method according to claim 1, wherein the display attribute is a form of a display character of data displayed in each cell. 7. The spreadsheet processing method according to claim 1, wherein cells for which an arithmetic expression is set are displayed with the same display attribute. 8. The spreadsheet processing method according to claim 1, wherein cells for which an arithmetic expression is set are displayed with display attributes different from each other. 9. A large number of cells are arranged in a matrix on a display screen, data is arranged and displayed in a desired cell of each cell, and an arithmetic expression referring to another cell is set in a desired arbitrary cell. , In the one in which the calculation result by the calculation formula is displayed in the cell, for each cell in which the calculation formula is set, the display attribute of the cell referred to by the calculation formula is different from other cells. A spreadsheet processing method characterized by displaying as. 10. When displaying, for each cell for which an arithmetic expression is set, a cell referred to by the arithmetic expression with a different display attribute from other cells, the display is performed in response to a specific operation. The spreadsheet calculation method according to claim 9, wherein the spreadsheet calculation method is performed. 11. The spreadsheet calculation method according to claim 9, wherein the display attribute is a background of data displayed in each cell. 12. The spreadsheet calculation method according to claim 11, wherein the background is a hatching pattern. 13. The spreadsheet calculation method according to claim 9, wherein the display attribute is a background color of data displayed in each cell. 14. The spreadsheet calculation method according to claim 9, wherein the display attribute is a form of a display character of data displayed in each cell. 15. The spreadsheet processing method according to claim 9, wherein cells referenced by an arithmetic expression set in one cell are displayed with the same display attribute. 16. A large number of cells are arranged in a matrix on a display screen, data is arranged and displayed in a desired cell of each cell, and an arithmetic expression referring to another cell is set in a desired arbitrary cell. , In the one in which the calculation result by the calculation formula is displayed in the cell, the display attribute of the cell referred to by the calculation formula is different from that of other cells with respect to one cell in which the calculation formula is set. A spreadsheet processing method characterized by displaying as. 17. When displaying a cell referred to by an arithmetic expression with a display attribute different from that of other cells, the display is performed in response to a specific operation. 16. The spreadsheet processing method described in 16. 18. The spreadsheet calculation method according to claim 16, wherein the specific operation specifies one cell in which an arithmetic expression is set. 19. The spreadsheet processing method according to claim 16, wherein the display attribute is a background of data displayed in each cell. 20. The spreadsheet processing method according to claim 19, wherein the background is a hatching pattern. 21. The spreadsheet calculation method according to claim 16, wherein the display attribute is a background color of data displayed in each cell. 22. The spreadsheet processing method according to claim 16, wherein the display attribute is a form of a display character of data displayed in each cell. 23. The spreadsheet calculation method according to claim 16, wherein the cells referred to by the arithmetic expression are displayed with the same display attribute. 24. A large number of cells are arranged in a matrix on a display screen, data is arranged and displayed in a desired cell of each cell, and an arithmetic expression referring to another cell is set in a desired arbitrary cell. , In which the calculation result by the calculation formula is displayed in the cell, based on the storage content of the calculation cell storage unit that stores at least information specifying the cell in which the calculation formula is set, and the storage content of the calculation cell storage unit. A spreadsheet processing device comprising: a cell display unit for displaying a cell in which the arithmetic expression is set, on the display screen with a display attribute different from that of other cells. 25. A specific operation detecting means for detecting an input of a specific operation is provided, and the cell display means is activated when the specific operation detecting means detects a predetermined specific operation. Spreadsheet processing device described. 26. The spreadsheet processing apparatus according to claim 24, wherein the display attribute is a background of data displayed in each cell. 27. The spreadsheet processing apparatus according to claim 26, wherein the background is a hatching pattern. 28. The spreadsheet processing apparatus according to claim 24, wherein the display attribute is a background color of data displayed in each cell. 29. The spreadsheet processing apparatus according to claim 24, wherein the display attribute is a form of a display character of data displayed in each cell. 30. The spreadsheet processing apparatus according to claim 24, wherein cells for which an arithmetic expression is set are displayed with the same display attribute. 31. The spreadsheet processing apparatus according to claim 24, wherein cells for which an arithmetic expression is set are displayed with display attributes different from each other. 32. A large number of cells are arranged in a matrix on a display screen, data is arranged and displayed in a desired cell of each cell, and an arithmetic expression referring to another cell is set in a desired arbitrary cell. In the display of the calculation result by the calculation formula in the cell, at least information for specifying the cell in which the calculation formula is set and a calculation cell storage unit for storing the cell referred to by the calculation formula, Cell display means for displaying, on the display screen, a cell in which the arithmetic expression has been set and a cell referred to by the arithmetic expression with display attributes different from those of other cells based on the stored contents of the arithmetic cell storage unit. A spreadsheet processing device comprising: 33. A specific operation detecting means for detecting an input of a specific operation is provided, and the cell display means is activated when the specific operation detecting means detects a predetermined specific operation. Spreadsheet processing device described. 34. The spreadsheet processing apparatus according to claim 32, wherein the display attribute is a background of data displayed in each cell. 35. The spreadsheet processing apparatus according to claim 32, wherein the background is a hatching pattern. 36. The spreadsheet processing apparatus according to claim 32, wherein the display attribute is a background color of data displayed in each cell. 37. The spreadsheet processing apparatus according to claim 32, wherein the display attribute is a form of a display character of data displayed in each cell. 38. The spreadsheet processing apparatus according to claim 32, wherein the cell in which the arithmetic expression is set and the cell to be referred to are displayed with display attributes different from each other. 39. The spreadsheet processing apparatus according to claim 32, wherein the referenced cells are displayed with the same display attribute. 40. A large number of cells are arranged in a matrix on a display screen, data is arranged and displayed in a desired cell of each cell, and an arithmetic expression referring to another cell is set in a desired arbitrary cell. In the display of the calculation result by the calculation formula in the cell, at least information for specifying the cell in which the calculation formula is set and a calculation cell storage unit for storing the cell referred to by the calculation formula, In response to the selection of any one cell for which an arithmetic expression is set, at least the cell referred to by the arithmetic expression set in the selected cell is displayed based on the stored contents of the arithmetic cell storage unit. A spreadsheet processing apparatus comprising cell display means for displaying a display attribute different from other cells on the screen. 41. A large number of cells are arranged in a matrix on a display screen, data is arranged and displayed in a desired cell of each cell, and an arithmetic expression referring to another cell is set in a desired arbitrary cell. , In the display of the calculation result by the calculation formula in the cell, at least a calculation cell storage unit that stores information specifying the cell in which the calculation formula is set, and each cell stored in the calculation cell storage unit. Correspondingly, a cell display attribute storage unit that stores the display attribute information for each cell in advance, and a cell in which the arithmetic expression is set based on the storage content of the arithmetic cell storage unit is set to another cell on the display screen. And a cell display means for displaying with a display attribute different from the above. 42. The cell display means is activated when the specific operation detection means for detecting an input of the specific operation is provided and the specific operation detection means detects a predetermined specific operation. Spreadsheet processing device described. 43. A large number of cells are arranged in a matrix on a display screen, data is arranged and displayed in a desired cell of each cell, and an arithmetic expression referring to another cell is set in a desired arbitrary cell. , An operation cell storage for displaying at least the information specifying the cell in which the operation expression is set and the cell referred to by the operation expression, in which the operation result by the operation expression is displayed in the cell Section, a cell display attribute storage section that stores in advance the display attribute information for each cell corresponding to each cell stored in the operation cell storage section, and the arithmetic expression based on the stored contents of the operation cell storage section. And a cell display means for displaying the set cell and the cell referred to by the arithmetic expression on the display screen with the display attribute stored in the cell display attribute storage section. apparatus. 44. A large number of cells are arranged in a matrix on a display screen, data is arranged and displayed in a desired cell of each cell, and an arithmetic expression referring to another cell is set in a desired arbitrary cell. , An operation cell storage for displaying at least the information specifying the cell in which the operation expression is set and the cell referred to by the operation expression, in which the operation result by the operation expression is displayed in the cell And a cell display attribute storage unit that stores at least display attribute information corresponding to each cell stored in the operation cell storage unit that is referred to in the arithmetic expression, and the arithmetic expression. In response to the selection of any one of the set cells, based on the storage content of the calculation cell storage unit, at least the cell referred to by the calculation formula set in the selected cell is stored in the cell display attribute storage. Department The stored formed by and a cell display means for displaying on the display screen by the display attribute table computing device.