JPH10162086A - Table processing equipment - Google Patents

Abstract

(57) [Summary] [PROBLEMS] To perform comparison of numerical data without requiring cells other than a cell to be compared, and to output a comparison result to a cell to be compared. When a processing target table stored in a storage device or a RAM is displayed on a display device, a CPU is provided.
0 is the numerical data of the cell for each cell of the processing target table and the storage device 18 or the RAM 2 set in advance for each cell.
The numerical data is compared with the comparison data stored in 0, the numerical data is replaced with a graphic image corresponding to the result by the symbol table, and is displayed on the display device 14.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table processing apparatus for creating a table, and more particularly to display control of cells constituting the table.

[0002]

2. Description of the Related Art In recent years, a table processing apparatus using a personal computer or the like has been increasingly used. This table processing device completes a table sheet called a spreadsheet by inputting data to grids called cells arranged in rows and columns, and sets a calculation formula for the cells. , Automatically perform a spreadsheet,
Various table sheets, such as a sales table and a household account book, can be created.

In such a table processing apparatus,
It is possible to compare the numerical data of two cells and output the result. This is realized by using the function (＠IF function) provided by a general spreadsheet tool. doing.

[0004]

However, when the function of outputting the result of magnitude comparison of numerical data is realized by using a function as described above, a cell for describing the function is required in addition to the cell to be compared. And the comparison result cannot be output to the comparison target cell.

SUMMARY OF THE INVENTION It is an object of the present invention to make it possible to compare numerical data without requiring cells other than the cell to be compared and to output the comparison result to the cell to be compared. .

[0006]

The means of the present invention are as follows. The storage means stores a processing target table in which cells into which numerical data is to be stored are two-dimensionally arranged. The comparison information setting means sets the comparison information for each cell of the processing target table.
The output control means, when outputting the processing target table stored in the storage means, the numerical data stored in the storage means for each cell of the processing target table and the comparison information set by the comparison information setting means. Are compared, and the output expression form of the data in each cell is changed according to the result.

The operation of the means of the present invention is as follows. When, for example, displaying and outputting the processing target table stored in the storage means, the output control means compares, for each cell of the processing target table, the numerical data of the cell with the comparison information set by the comparison information setting means. The output expression form of data in each cell is changed according to the result. Therefore, when comparing the magnitudes of the numerical data, cells other than the cell to be compared are not required, and the comparison result can be output to the cell to be compared.

[0008]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, first to eleventh embodiments of the present invention will be described with reference to FIGS. FIG. 1A shows a configuration common to the table processing apparatuses according to the first to eleventh embodiments of the present invention. In FIG. 1, reference numeral 10 denotes a CPU that controls the entire table processing apparatus. is there. Reference numeral 12 denotes an input device such as a keyboard and a mouse.
Reference numeral 4 denotes a display device such as a CRT, and 16 denotes a printing device such as a page printer. Reference numeral 18 denotes a storage device such as a hard disk that stores programs for input control, file control, data processing control, etc., a table sheet, various tables described below, and other information. Reference numeral 20 denotes a RAM used as a work memory when the CPU 10 executes a program stored in the storage device 18. The RAM 20 stores the program, table sheets, various tables, and other information.

The programs and data stored in the storage device 18 may be stored in advance, or may be stored in a storage medium 2 such as a floppy disk or an optical (magnetic) disk.
2 and may be supplied by the communication line 24 and stored in the storage device 18. Alternatively, in addition to the program stored in the storage device 18, the CPU 10
It is also possible to directly execute a program stored in the storage medium 22 or a program provided via the communication line 24.

[First Embodiment] A first embodiment of a table processing apparatus having such a configuration will be described below. Now, as shown in FIG. 1B, a table sheet in which data is input to cells arranged vertically and horizontally by the operator is completed and stored in the storage device 18 (or the RAM 20). Shall be. In this table sheet, aaa, bb
Items b, ccc, ddd and AAA, BBB, CC
Numerical data is input to each cell designated by the factors C, DDD, and EEE.

In the first embodiment, the numerical data of each cell of such a table sheet is compared in magnitude with comparison data arbitrarily designated by an operator (for example, numerical data "20"). By converting the result into a graphic image (for example, an arrow symbol), a new table sheet as shown in FIG. 1C (hereinafter referred to as a comparison table sheet) is created and displayed on the display device 14. It is to do.

In order to create such a new comparison table sheet, in the first embodiment, the table sheet stored in the storage device 18 (or the RAM 20) stores information about the cell for each cell. The data structure of each cell information is as shown in FIG. That is, the cell information 26 includes cell position information, cell header information, cell control information, extended cell control information, character modification information, cell modification information, in-cell ruled line information, color information, and input character (numerical value) information. This is the same as the data structure of cell information in a conventional table processing device. In the first embodiment, the comparison information 28 is further added to this.

As shown in FIG. 2B, the comparison information 28 includes three elements: a comparison execution flag 28A, comparison data 28B, and storage data 28C. The comparison execution flag 28A is a flag (ON / OFF) as to whether the execution of the comparison function is enabled, and the comparison data 28B stores numerical data to be compared. In this case, the comparison execution flag and the comparison data can be arbitrarily set by the operator for the cell, are set when the table sheet is created, and are stored in the storage device 18 (or the RAM 20).

The stored data 28C stores a graphical symbol to be displayed at a corresponding cell position on a new table sheet when the comparison function is executed. What kind of graphical symbol is stored in the storage data 28C is based on the symbol table 30 shown in FIG. 2C stored in the storage device 18 (or the RAM 20). The symbol table 30 is a table showing what kind of graphical symbol is stored in the storage data 28C according to the comparison result. This graphical symbol may be arbitrarily set by the operator.

In the present embodiment, the comparison information 28 is added to the cell information 26. In addition to this, the whole table information (entire format), column information (column format), and row information ( Line format).

FIG. 2D is a flowchart of the comparison table sheet output operation executed by the CPU 10 in the first embodiment. That is, first, a target table sheet is specified according to the specification of the operator (Step S).
1) Specify the cell of this table sheet (step S)
2). Then, depending on the state of the comparison execution flag 28A in the comparison information 28 of the cell information 26 of the cell, whether the operator desires to output the numerical data of the cell as it is, or converts it into a graphical symbol and outputs it Is determined (step S3). When the comparison information flag 28A is OFF, the cell information 26
Numerical data stored in the input character (numerical value) information in the table is read (step S4), and the comparison information flag 28 is read.
If A is ON, output data generation processing, which will be described in detail later, is performed, and the graphical symbol is stored in the storage data 28C in the comparison information 28 of the cell information 26 (step S5). Then, cell data is generated according to each attribute information in the cell information 26 (step S6), and displayed on the display device 14 (step S7). Thereafter, if there is any unprocessed cell in the designated table sheet (step S8), the process returns to step S2, and the above process is repeated for the next cell.

In the first embodiment, the output data generation processing in step S5 is performed as shown in FIG. That is, first, the comparison data (for example, “20”) specified by the operator is fetched from the comparison data 28B in the comparison information 28 of the cell information 26 (step S10), and the comparison data and the input characters in the cell information 26 are read. A comparison is made with numerical data stored in (numerical) information (step S11). Then, a graphical symbol (in the present embodiment, an arrow symbol) corresponding to the result of the comparison is read from the symbol table 30 (step S12), and is used as output data to compare information 2 in the cell information 26.
8 (step S1).
3).

As described above, in the first embodiment, by comparing the comparison information in the cell, row, column, and overall format, the comparison result between the numerical data of the designated cell and any numerical data is graphically displayed. By expressing with a symbol and replacing the symbol with the numerical data of the designated cell and outputting it, it is possible to visually grasp the magnitude relationship between the numerical data.

Further, whether or not the comparison process is performed can be set by the comparison execution flag 28A. Therefore, two types of tables, ie, the same table sheet as the original and the comparison table sheet replaced with the graphical symbols from the data of one processing target table sheet are used. Not only can the sheets be switched and output, but by setting the comparison execution flag 28A on a cell-by-cell basis, a comparison table sheet in which only specific columns, only specific rows, or only specific cells have been replaced with graphical symbols can be displayed. It is also possible to output.

[Second Embodiment] Next, a second embodiment of the present invention will be described.
An embodiment will be described. In the above-described first embodiment, since the numerical data of the cell is replaced with the graphical symbol, the original numerical data and the graphical symbol expressing the comparison result cannot be output at the same time. In the second embodiment, as shown in FIG. 3A, original numerical data and graphical symbols are output simultaneously.

In this embodiment, the cell information 26 and the symbol table 30 are the same as those in the first embodiment, and the output operation of the comparison table sheet is also the same. In the second embodiment, the only difference is the output data generation processing in step S5.

FIG. 3B is a flowchart showing the output data generation processing in the second embodiment. First, the comparison data 28B in the comparison information 28 of the cell information 26 is shown.
From the comparison data specified by the operator (for example, "20")
(Step S20), and compares the comparison data with the numerical data stored in the input character (numeric) information in the cell information 26 (step S21). Then, a graphical symbol (arrow symbol in the present embodiment) corresponding to the result of the comparison is read from the symbol table 30 (step S22), and it is combined with numerical data (step S23), and the combined data is output. The data is stored in the storage data 28C in the comparison information 28 of the cell information 26 (step S24).

As described above, in the second embodiment, the numerical data is output by adding the graphical comparison expression symbol to the numerical data. The analysis by is also possible.

[Third Embodiment] Next, a third embodiment of the present invention will be described.
An embodiment will be described. In the third embodiment, a graphical comparison expression symbol that has been fixed in the first and second embodiments is replaced by a cell, row, or column unit.
More than one can be specified.

In the third embodiment, the comparison information 2
8 indicates a comparison execution flag 28 as shown in FIG.
A, comparison data 28B, and storage data 28C, as well as comparison symbol information 28D. The comparison symbol information 28D stores information for specifying the type of graphical symbol expressing the magnitude comparison result of the numerical data.

FIG. 3D shows a symbol table 30 according to the third embodiment. That is, in this case, two types of graphical symbols are included, and the type of graphical symbol to be used can be specified by the comparison symbol information 28D.

When the information indicating the first type of graphical symbol, which is a thick arrow symbol, is designated and stored by the operator as the comparison symbol information 28D, as shown in FIG. A comparison table sheet is obtained. On the other hand, when the information indicating the second type of graphical symbol, which is a circle, a triangle, or a square symbol, is designated and stored as the comparison symbol information 28D, the comparison symbol shown in FIG. A table sheet will be obtained.

The output processing of the comparison table sheet for obtaining the comparison table sheet is the same as that of the first embodiment except for the output data generation processing in step S5. FIG. 3G is a flowchart showing the output data generation processing in the third embodiment. First, the comparison data designated by the operator from the comparison data 28B in the comparison information 28 of the cell information 26 is shown. (Eg, “20”) is fetched (step S30), and the comparison data is compared with the numerical data stored in the input character (numeric) information in the cell information 26 (step S31). Further, a graphical symbol type specified by the comparison symbol information 28D in the comparison information 28 of the cell information 26 is designated (step S32), and a graphical symbol corresponding to the comparison result and corresponding to the graphical symbol type is designated. It is read from the symbol table 30 (step S33), and stored as output data in the storage data 28C in the comparison information 28 of the cell information 26 (step S34).

As described above, in the third embodiment, by managing the comparison symbol information 28D, a plurality of comparison symbols specified by the operator can be defined, and the expressive power of the comparison result is increased. Expressive power is improved.

[Fourth Embodiment] Next, a fourth embodiment of the present invention will be described.
An embodiment will be described. In the fourth embodiment, the magnitude comparison result is output to cells other than the comparison target cell.

Therefore, in the present embodiment, the comparison information 28 includes a comparison execution flag 28A and comparison data 28B and a comparison result output coordinate 2 as shown in FIG.
8E, and does not have the stored data 28C as in the above-described first to third embodiments.

Here, the comparison result output coordinates 28E are information indicating coordinates (cells) for outputting a graphical symbol representing a comparison result between the numerical data of the comparison target cell and the comparison data. For example, when a comparison result is output to each cell of an increase / decrease table from a data table created on one table sheet as shown in FIG. 5A, cell information 26 of each cell of the data table is output.
The comparison result output coordinates 28E in the comparison information 28
As shown in italic in FIG. 5B, cell coordinates indicated by “alphabet + number” are specified and stored by the operator (actually, this table does not exist). Then, the comparison result is converted by the same symbol table 30 as in the first embodiment described above, and
Is output to the cell indicated by the comparison result output coordinate 28E,
An increase / decrease table as a comparison table as shown in FIG. 5C is output to the display device 14 together with the original data table.

FIG. 4B is an operation flowchart of such a comparison table output process. That is, first, a target table is specified according to the specification of the operator (Step S).
1), the cell of this table is designated (step S2). Then, numerical data stored in the input character (numerical value) information in the cell information 26 is read (step S4), and cell data is generated according to each attribute information in the cell information 26 (step S6). 14 is displayed (step S7). Thereafter, it is determined whether or not the comparison execution flag 28A in the comparison information 28 of the cell information 26 of the cell is ON (step S3), and if it is OFF, the process returns to step S2. On the other hand, when the comparison information flag 28A is ON, the comparison data (for example, "20") designated by the operator is taken from the comparison data 28B in the comparison information 28 of the cell information 26 (step S40). The comparison data is compared with the numerical data stored in the input character (numeric) information in the cell information 26 (step S4).
1). Then, a graphical symbol (arrow symbol in the present embodiment) corresponding to the result of the comparison is stored in the symbol table 3.
It is read from 0 (step S42), and is output as output data to the coordinate table indicated by the comparison result output coordinate 28E in the comparison information 28 of the cell information 26 (step S43). If there is a cell that has not been processed yet in the designated table (step S8), the process returns to step S2, and the above processing is repeated for the next cell. In this way, the data table and the increase / decrease table are displayed on the display device 14 as shown in FIG.

As described above, in the fourth embodiment, the comparison result information is output to cells other than the cell to be compared, so that numerical values can be output to a table in a format different from the original table. The result of increasing or decreasing data can be expressed.

[Fifth Embodiment] Next, a fifth embodiment of the present invention will be described.
An embodiment will be described. In the fifth to fifth embodiments, as shown in FIG. 4C, numerical data of the magnitude comparison result is output from the output of only the magnitude comparison result in the first to fourth embodiments. Can be output.

In the case of this embodiment, the cell information 26 is the same as in the case of the above-described first embodiment, and the symbol table 30 is not used. The output operation of the comparison table sheet is the same as that of the first embodiment except for the output data generation processing in step S5.

FIG. 4D is a flowchart showing the output data generation processing in the fifth embodiment. First, the comparison data 28B in the comparison information 28 of the cell information 26 is shown.
From the comparison data specified by the operator (for example, "20")
(Step S50), and the difference between the comparison data and the numerical data stored in the input character (numeric) information in the cell information 26 is calculated (step S51). Then, the difference data and the numerical data are combined (step S52), and the combined data is stored as output data in the storage data 28C in the comparison information 28 of the cell information 26 (step S53).

As described above, in the fifth embodiment, by outputting the difference between the numerical data of the cell to be compared and the comparison data, a more detailed magnitude relationship can be grasped, and the data can be grasped. This is effective for performing detailed analysis.

[Sixth Embodiment] Next, a sixth embodiment of the present invention will be described.
An embodiment will be described. While the difference between the numerical data is output in the fifth embodiment, the sixth embodiment is different from the fifth embodiment.
In this embodiment, as shown in FIG. 6A, an increase / decrease rate of numerical data is output.

In the case of the present embodiment, the cell information 26 is the same as in the case of the above-described first embodiment, as in the case of the above-described fifth embodiment, and the symbol table 30 is not used. The sheet output operation is the same as that of the first embodiment, except for the output data generation processing in step S5.

FIG. 6B is a flowchart showing the output data generation processing in the sixth embodiment. First, the comparison data 28B in the comparison information 28 of the cell information 26 is shown.
From the comparison data specified by the operator (for example, "20")
(Step S60), and an increase / decrease rate of the numerical data stored in the input character (numeric) information in the cell information 26 with respect to the comparison data is calculated (step S61).
Then, the increase / decrease rate data and the numerical data are combined (step S62), and the combined data is used as output data to store data 2 in the comparison information 28 of the cell information 26
8C (step S63).

As described above, in the sixth embodiment, the rate of increase / decrease of the numerical data of the comparison target cell with respect to the comparison data is output, so that the sales amount, the profit amount, and the like are output in the form in which the amount of money is output. This is effective when measuring the growth rate.

[Seventh Embodiment] Next, a seventh embodiment of the present invention will be described.
An embodiment will be described. In the above-described first to sixth embodiments, physically defined comparison data is used. However, in the present embodiment, cells, rows, and
It can be logically specified using column coordinates.

Therefore, in the present embodiment, as shown in FIG. 6C, the comparison information 28 includes the comparison execution flag 28A and the stored data 28C and the comparison target cell coordinates 2
8F.

Here, the comparison target cell coordinates 28F are information indicating the coordinates of the comparison target cell in the comparison target table. For example, when the lower data table as shown in FIG. 7A is compared with the upper comparison target table and the result is output as a graphical symbol, the cell information 26 of each cell of the data table is output.
The comparison target cell coordinates 28F in the comparison information 28 of
As shown in italic in FIG. 7B, the cell coordinates of the comparison target table indicated by “alphabet + number” are designated and stored by the operator (actually, this table does not exist). Then, the comparison result is converted by the same symbol table 30 as in the above-described first embodiment, and a data table as a comparison table as shown in FIG. Is output.

The operation of outputting the comparison table in the seventh embodiment is the same as that of the first embodiment except for the output data generation processing in step S5. FIG.
(D) is a flowchart showing output data generation processing in the seventh embodiment. First, the operator stored in the comparison target cell coordinates 28F in the comparison information 28 of the cell information 26 specifies the output data generation processing. The data is fetched from the cell to be compared (step S70), and the comparison data is compared with the numerical data stored in the input character (numeric) information in the cell information 26 (step S71). Then, a graphical symbol (arrow symbol in the present embodiment) corresponding to the result of the comparison is read from the symbol table 30 (step S7).
2) It is stored as output data in the storage data 28C in the comparison information 28 of the cell information 26 (step S73).

As described above, according to the seventh embodiment, the comparison data can be linked to another table data by indirectly specifying the comparison data using the logical information of cells, rows, and columns. In addition, most of ordinary forms have a meaning in a matrix unit, so that the output of the comparison result can be designated according to the contents of the form.

[Eighth Embodiment] Next, an eighth embodiment of the present invention will be described.
An embodiment will be described. In the eighth embodiment, the stage of freely expressing the comparison result is defined by defining the range (increase / decrease range) of the difference data calculated as a result of the comparison of the numerical data and the corresponding expression symbol. It is made possible.

That is, in the present embodiment, the symbol table 3
Assuming that it is 0, the operator arbitrarily sets a table including an increase / decrease range and an expression symbol as shown in FIG. here,
The increase / decrease range is the range of the difference between the comparison data and the numerical data of the comparison target cell, and the expression symbol is a graphical symbol output according to the increase / decrease range.

The operation of outputting the comparison table sheet in the eighth embodiment is the same as that in the first embodiment, and a description thereof will be omitted. As a result, a comparison table sheet as shown in FIG. 8B is output.

As described above, in the eighth embodiment, by setting a plurality of expression symbols according to the increase / decrease range,
It is possible to output a valid comparison result according to the range of the numerical data of the form.

[Ninth Embodiment] Next, a ninth embodiment of the present invention will be described.
An embodiment will be described. While the first to eighth embodiments compare data with the same table sheet, the ninth embodiment enables comparison with data of another table sheet. It was done.

Therefore, in the ninth embodiment, as shown in FIG. 8C, the comparison information 28 includes the above-described comparison execution flag 28A, the stored data 28C, and the target sheet information 28G. The target sheet information 28G is
As shown in FIG. 8D, the storage device information 28G
1, sheet name 28G2 and target coordinates 28G3. Here, the storage device information 28G1 is information indicating which device, such as a hard disk, a floppy disk, or a magneto-optical disk, as the storage device 18 stores the target table sheet. The sheet name 28G2 is a sheet name including the directory path of the front sheet, and the target coordinates 28G3 are coordinate information of cells in the sheet to be compared.

FIG. 8E shows the target sheet information 28.
It is a figure showing the example of G. If the target coordinates 28G3 are not specified, the coordinates are assumed to be the same as the cell coordinates of the comparison source. Cell information 2 including such target sheet information 28G
When 6 is set in each cell of the table (comparison table) on the comparison source sheet in FIG. 9A, the comparison destination as shown in FIG. The comparison is performed on the table on the sheet (comparison destination table). As a result, a result table as shown in FIG. 9C is formed on the comparison source sheet.

The operation of outputting the comparison table in the ninth embodiment is the same as that of the first embodiment except for the output data generation processing in step S5. FIG.
(F) is a flowchart showing output data generation processing in the ninth embodiment. First, a sheet to be compared is specified according to target sheet information 28G in comparison information 28 of cell information 26. (Step S90), the data of the target coordinates is fetched (Step S91). Then, the comparison data and the input character (numerical value) in the cell information 26
The numerical data stored in the information is compared with the numerical data (step S92), and a graphical symbol (arrow symbol in the present embodiment) corresponding to the result of the comparison is read from the symbol table 30 (step S93). The output data is stored in the storage data 28C in the comparison information 28 of the cell information 26 (step S94).

As described above, in the ninth embodiment, the comparison can be performed with reference to the table data of another sheet, so that a plurality of forms having the same format such as monthly sales slips can be obtained. It is effective when divided and managed in a table sheet.

[Tenth Embodiment] Next, a tenth embodiment of the present invention will be described. In the above-described eighth embodiment, the symbol table 30 has to be manually generated, whereas in the tenth embodiment, the number of set levels and target area information to be compared are specified. In this case, it is automatically generated and the output processing of the comparison table sheet is performed. Here, the number of set levels is the number of divisions of the increase / decrease width as a comparison result, and the target area information is area information to be executed.

That is, in the table sheet as shown in FIG. 10A, for example, when the operator specifies the range from cell C3 to cell F5 as the target area and sets the number of set levels to three levels, The storage device 18 or the RAM 20 stores the logical expression execution information 32 including the number of set levels and the target area information as shown in FIG. Then, the CPU 10 generates the symbol table 30 based on the logical expression execution information 32.

FIG. 10C shows the symbol table 30.
5 is a flowchart of a creating operation. That is, first, in accordance with the specification of the operator, a target table sheet is specified (step S1), a target area is specified based on the logical expression execution information 32 (step S100), and the number of levels is specified. (Step S101). Next, the numerical data stored in the input character (numeric) information in the cell information 26 of each cell in the designated target area and the comparison data 28B in the comparison information 28 of the cell information 26 are stored. A difference from the comparison data (in this case, “20”) is calculated, and an increase / decrease range table as shown in FIG. 10D is generated from the result (step S102). Then, the maximum of these differences (ma
x), the minimum (min) value, and the specified number of levels, the symbol table 30 as shown in FIG.
Is created and stored in the storage device 18 or the RAM 20 (step S103).

The output operation of the comparison table sheet using the symbol table 30 created in this way is the same as that of the first embodiment, and the description is omitted, but the output of this comparison table sheet is omitted. By the operation, a comparison table sheet as shown in FIG.

As described above, in the tenth embodiment,
Unlike the above-described eighth embodiment, the increase / decrease range management table is automatically generated only by setting the number of set levels and the target area information. This can be easily specified.

[Eleventh Embodiment] Next, an eleventh embodiment of the present invention will be described. In the eleventh embodiment, the increase / decrease of the comparison result of the numerical data is represented by graphing in a cell in a matrix unit.

For this purpose, in the present embodiment, the operator designates the graphing execution information in advance and stores it in the storage device 18 or the RAM 20. The graphing execution information includes graphing area information, a graph direction, and a graph type. Here, the graphing area information is information indicating a cell area to be graphed, the graph direction is information indicating a graph output direction (row direction / column direction), and the graph type is output. This is information indicating the type of graph.

In this embodiment, as in the case of the third embodiment, a plurality of types of graph images can be selected, so that the type of graph is specified. This is not necessary if only images are used. FIG. 11A shows an example of the symbol table 30 for two types of graphs.

Thus, in the table sheet as shown in FIG. 11B, the output processing of the comparison table sheet is executed by specifying the graphing execution information 34 as shown in FIG. 11C. Then, a comparison table sheet as shown in FIG. 11D is obtained.

FIG. 12 is an operation flowchart of a comparison table sheet output process for obtaining such a comparison table sheet. That is, first, according to the specification of the operator, a target table sheet is specified (step S1), and cells of the table sheet are specified (step S2). Here, it is determined whether or not the specified cell is within the area indicated by the graphing area information in the graphing execution information 34 (step S110).

If it is not within the area, the numerical data stored in the input character (numerical value) information in the cell information 26 is read (step S4), and the cell data is read in accordance with each attribute information in the cell information 26. It is generated (step S6) and displayed on the display device 14 (step S6).
7). Thereafter, if there is any unprocessed cell in the designated table sheet (step S8), the process returns to step S2, and the above process is repeated for the next cell.

On the other hand, when it is within the graphing area, the comparison data designated by the operator from the comparison data 28B in the comparison information 28 of the cell information 26 (for example, "2
0 ”) (step S111), and compares the comparison data with numerical data stored in the input character (numeric) information in the cell information 26 (step S112). Then, a graph image corresponding to the result of the comparison is read from the symbol table 30 according to the graph type in the graphing execution information 34, and is displayed and output in the cell according to the graph direction in the graphing execution information 34. (Step S113). Thereafter, the process proceeds to step S8, and if there is a cell that has not been processed in the designated table sheet, the process returns to step S2 to repeat the above process for the next cell.

As described above, in the eleventh embodiment,
By graphing the comparison results in matrix units in the cells of the table, the comparison results can be handled as continuous data, so that it is easy to grasp the tendency of data in matrix units.

In the first to eleventh embodiments, the case where the comparison table is displayed and output on the display device 14 has been described. However, the present invention is similarly applicable to the case where the comparison table is printed and output on the printing device 16. Of course.

[0071]

According to the present invention, when comparing the magnitudes of numerical data, cells other than the cell to be compared are not required, and the comparison result can be output to the cell to be compared.

Also, the comparison result between the numerical data of the designated cell and any numerical data is represented by a graphical symbol,
By replacing the symbol with the numerical data of the designated cell and outputting it, the magnitude relation of the numerical data can be visually grasped.

[Brief description of the drawings]

FIG. 1A is a block diagram illustrating a configuration common to a table processing device according to first to eleventh embodiments of the present invention;
FIGS. 4B and 4C are diagrams showing a conversion source table sheet and a comparison table sheet obtained as a conversion result in the first embodiment, respectively.

2A is a diagram showing a cell data structure in the first embodiment, FIG. 2B is a diagram showing comparison information in FIG. 2A,
(C) is a diagram showing a symbol table in the first embodiment, (D) is an operation flowchart of the first embodiment, (E) is a flowchart of the output data generation processing in (D) It is.

FIG. 3A is a diagram showing a comparison table sheet as a conversion result in the second embodiment; FIG. 3B is a flowchart of output data generation processing in the second embodiment;
(C) is a diagram showing comparison information in the third embodiment,
(D) is a diagram showing a symbol table in the third embodiment, (E) and (F) are diagrams showing a comparison table sheet as a conversion result in the third embodiment, respectively.
(G) is a flowchart of an output data generation process according to the third embodiment.

FIG. 4A is a diagram showing comparison information according to a fourth embodiment, FIG. 4B is an operation flowchart of the fourth embodiment, and FIG. 4C is a conversion chart according to the fifth embodiment; It is a figure showing a comparison table sheet as a result, and (D) is a flow chart of output data generation processing in a 5th embodiment.

FIGS. 5A to 5C respectively show a conversion source table sheet, a table sheet not actually output for explaining output result coordinate information, and a conversion result in the fourth embodiment; FIG. 8 is a diagram showing a comparison table sheet to be obtained.

FIG. 6A is a diagram showing a comparison table sheet as a conversion result in the sixth embodiment, and FIG. 6B is a flowchart of output data generation processing in the sixth embodiment;
(C) is a diagram showing comparison information in the seventh embodiment, and (D) is a flowchart of output data generation processing in the seventh embodiment.

FIGS. 7A to 7C respectively show a conversion-source table sheet, a table sheet that is not actually output for explaining comparison target cell coordinates, and a conversion result in the seventh embodiment; FIG. 8 is a diagram showing a comparison table sheet to be obtained.

8A is a diagram showing a symbol table according to the eighth embodiment, FIG. 8B is a diagram showing a comparison table sheet as a conversion result according to the eighth embodiment, and FIG. Is a diagram showing comparison information in the ninth embodiment, (D) is a diagram showing target sheet information in (C), (E) is a diagram showing an example of target sheet information, (F) 33 is a flowchart of an output data generation process in the ninth embodiment.

FIGS. 9A to 9C are a table on a comparison source sheet (comparison table), a table on a comparison destination sheet (comparison destination table), and a comparison source sheet in the ninth embodiment, respectively. It is a figure showing a result table formed above.

10A is a diagram illustrating a conversion-source table sheet according to the tenth embodiment, FIG. 10B is a diagram illustrating logical expression execution information according to the tenth embodiment, and FIG. ) Is a flowchart of the symbol table creation operation according to the tenth embodiment, and (D) is an increase / decrease range table temporarily created for performing the symbol table creation operation according to the tenth embodiment. (E) is a diagram showing a symbol table in the tenth embodiment, and (F) is a diagram showing a comparison table sheet as a conversion result in the tenth embodiment. .

11A is a diagram illustrating a symbol table according to an eleventh embodiment, FIG. 11B is a diagram illustrating a conversion-source table sheet according to the eleventh embodiment, and FIG. It is a figure which shows the graphing execution information in 11th Embodiment, (D) is a figure which shows the comparison table sheet obtained as a conversion result in 11th Embodiment.

FIG. 12 is an operation flowchart of the eleventh embodiment.

[Explanation of symbols]

 Reference Signs List 10 CPU 12 input device 14 display device 16 printing device 18 storage device 20 RAM 22 storage medium 24 communication line 26 cell information 28 comparison information 28A comparison execution flag 28B comparison data 28C storage data 28D comparison symbol information 28E comparison result output coordinates 28F comparison target Cell coordinates 28G Target sheet information 30 Symbol table 32 Logical expression execution information 34 Graphing execution information

Claims (10)

[Claims] 1. A storage means for storing a processing target table in which cells storing numerical data are two-dimensionally arranged; a comparison information setting means for setting comparison information for each cell of the processing target table; When outputting the processing target table stored in the means, the numerical data stored in the storage means is compared with the comparison information set by the comparison information setting means for each cell of the processing target table, and the result is compared with the result. Output control means for changing an output expression form of data in each cell in response to the request. 2. The table processing apparatus according to claim 1, wherein the output control means replaces the numerical data with a graphic image corresponding to the comparison result and expresses the output. 3. The table processing apparatus according to claim 1, wherein said output control means outputs the numerical data by adding a graphic image corresponding to the comparison result to the numerical data. 4. A graphic image storage means for storing a plurality of types of graphic images corresponding to the comparison result, and a designating means for designating one of the plurality of types of graphic images stored in the graphic image storage means. 3. The apparatus according to claim 2, further comprising: when replacing the numerical data with a graphic image corresponding to the comparison result, the output control means uses a graphic image of the type specified by the specifying means. Table processing device as described. 5. The table processing apparatus according to claim 1, wherein the output control means outputs the numerical data as a difference of the comparison result. 6. The table processing apparatus according to claim 1, wherein the output control means expresses the numerical data by an increase / decrease rate of the comparison result. 7. A storage means for storing a processing target table in which cells containing numerical data are arranged two-dimensionally, a comparison target data setting means for setting comparison target data for each cell of the processing target table, Output cell position setting means for setting a cell position different from the cell to which the comparison result is to be output for each cell of the processing target table; and numerical data in each cell of the processing target table stored in the storage means And a comparison processing unit that compares the data with the comparison target data set by the comparison target data setting unit and outputs the result to the cell position set by the output cell position setting unit. 8. A storage means for storing a processing target table in which cells containing numerical data are arranged two-dimensionally, a comparison target data setting means for setting comparison target data for each cell of the processing target table, A table in which an increase / decrease range and its corresponding image are set; and a numerical data and a comparison target data stored in the storage means for each cell of the processing target table when the processing target table stored in the storage means is output. A table for comparing the comparison target data set by the setting means, searching the table based on the comparison result, and expressing the corresponding image as an image corresponding to the data in the cell; Processing equipment. 9. A storage means for storing first and second tables in which cells each storing numerical data are two-dimensionally arranged, and in each cell of the first table stored in said storage means. Comparing means for comparing the numerical data with the numerical data in each cell of the second table; and attribute changing means for changing the output attribute of any of the cells in the table according to the comparison result by the comparing means. A table processing apparatus, comprising: 10. A process for setting comparison information for each cell of the processing target table when outputting a processing target table in which cells containing numerical data are arranged two-dimensionally; A program for causing a computer to execute, for each cell, a process of comparing the numerical data of the cell with the comparison information, and a process of changing an output expression form of data in each cell according to the comparison result. A computer-readable recording medium that stores