JPH10143579A - Table processor - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a table processor capable of outputting by modifying a cell by easy operation. SOLUTION: At the time of outputting a table in table output processing to table data stored in a table data storing part within a storing device, CPU2 reads cell data from table data to obtain an item name (title) from the cell address of read cell data and next retrieves an evaluation table file within the storage device 5. Then CPU 2 evaluates a cell value on a condition included in the pertinent record of the evaluation file to set chrominance information corresponding to the cell value and displays each cell on a display 8 based on set chrominance information or color-prints it from a printer 7.

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, and more particularly, to a table processing apparatus for outputting each cell in an output form based on a cell value of each cell.

[0002]

2. Description of the Related Art In recent years, various application programs such as spreadsheets and databases have been used in office computers and general-purpose computers mainly for office work, and tabulated data are output in tables of various formats. It has a table output function that enables it.

In order to output a table, it is necessary to set definition contents such as a format and an output form, and the setting is performed using, for example, a table definition function built in an application program. ing. In this table definition function, first, a table format is set, items to be output in the table and item definition contents are set, and a record file name (table file name) in which data to be output to the setting items is expanded is set. The output mode is set on the design screen.

When the table set in such a procedure is displayed on the screen, the type of data output for each cell expanded in the table is calculated from characters, numerical values, and a plurality of items. And the calculation result.

Further, as a conventional table definition function, there is provided a function of defining an output form of a cell in units of cells.
Using this definition function, cells can be output in color. Specifically, the color output of the cell is performed by defining the modification information of the cell. Specifically, first, the operator sets a color output target cell for performing color output, and then, in the designated color output target cell, the cell output condition and output type (color number, RGB value,.
・ ・) Etc. were defined and cells were output in color.

[0006]

However, in the conventional table definition function, as described above, the operator sets a color output target cell for performing color output, and then sets the color output target cell in the set color output target cell. Since the output condition and output type of the cell are defined and the cell is output in color, there are various problems as described below.

[0007] First, it is necessary to set colors on a cell-by-cell basis, and there is a problem that the amount of work is enormous. In such a case, there is a problem that the amount of work becomes enormous. Third, there is a problem that an error easily occurs because the setting is performed on a cell-by-cell basis.
It is necessary to understand the color output target cells, color output conditions, output types, etc., to use the table processing device, and to have a high level of data processing knowledge and to use the table processing device. .

An object of the present invention is to provide a table processing apparatus capable of modifying and outputting cells by a simple operation.

[0009]

According to the first aspect of the present invention,
A table processing device that outputs a table composed of a plurality of cells, a condition for evaluating a cell value for each item name of a row or a column commonly associated with the plurality of cells constituting the table, Storage means for storing decoration information corresponding to a condition for evaluating the cell value, and when outputting the table, for each cell, based on an item name corresponding to the cell and a cell value of the cell, The above object is achieved by providing output means for reading out the corresponding modification information stored in the storage means, outputting each cell in an output form corresponding to the read modification information, and outputting a table.

That is, according to the first aspect of the present invention, in the table processing apparatus for outputting a table composed of a plurality of cells, the storage means is commonly associated with the plurality of cells constituting the table. A condition for evaluating a cell value for each row or column item name and decoration information corresponding to the condition for evaluating the cell value are stored in association with each other, and the output unit outputs each table when outputting a table. Then, based on the item name corresponding to the cell and the cell value of the cell, the corresponding modification information stored in the storage means is read, and each cell is output and displayed in an output form corresponding to the read modification information. Is output.
Note that, in this specification, output means displaying on a display device, printing on a printing device, or the like.

Therefore, a condition for evaluating a cell value for each item name of a row or a column and modification information corresponding to the condition for evaluating the cell value are defined, and when a table is output (displayed or printed), the cell is evaluated. , The cell is output in an output form corresponding to the modification information based on the item name and the cell value of the cell, so that the cell can be modified and output by a simple operation. In addition, since the cells included in the column or row corresponding to the item name can be modified and output according to the condition for evaluating the cell value, the data of the column or row corresponding to the item name can be identified according to the evaluation condition. As a result, it is possible to easily identify a difference in data in the same item, and the convenience of the operator is improved.

[0012] In this case, as in the invention of claim 2,
It is effective that a condition for evaluating a cell value stored in the storage means and decoration information corresponding to the condition for evaluating the cell value can be arbitrarily set.

That is, according to the second aspect of the present invention, in the first aspect of the present invention, the condition for evaluating the cell value stored in the storage means and the modification information corresponding to the condition for evaluating the cell value are optional. Can be set to

Therefore, in addition to the effect of the first aspect of the present invention, it is possible to arbitrarily set the condition for evaluating the cell value and the modification information corresponding to the condition for evaluating the cell value. improves.

[0015] In this case, as in the third aspect of the present invention, the modification information includes color, character size, typeface, character color,
Any one or two of character fonts, shading, underlining, etc.
Specifying the above is effective.

That is, according to the third aspect of the present invention, in the first or second aspect of the present invention, the modification information includes any one of a color, a character size, a font, a character color, a character font, a shade, and an underline. Or 1 or 2 or more.

Therefore, it is possible to output the cell in various output forms, and it is possible to further diversify the output form of the cell.

In this case, it is effective that the decoration information is specified in association with the mutual relationship between the item name of the row and the item name of the column.

That is, according to the invention described in claim 4, in the invention described in any one of claims 1 to 3, the modification information is associated with the mutual relationship between the item name of the row and the item name of the column. Is specified.

Therefore, the row item name for the column item name,
Alternatively, it is possible to modify and output the cell by evaluating the column item name with respect to the row item name, thereby improving the usability of the operator.

According to a fifth aspect of the present invention, there is provided a table processing apparatus for outputting a table composed of a plurality of cells, wherein a row or a column commonly associated with the plurality of cells constituting the table is output. Storage means for storing a condition for evaluating a cell value for each item name and an output cell value corresponding to the condition for evaluating the cell value; and for outputting the table, each cell corresponds to the cell. An output unit that reads a corresponding output cell value stored in the storage unit based on the item name and the cell value of the cell, outputs the read output cell value into the cell, and outputs a table. The above-mentioned object is solved by providing the above.

That is, according to the fifth aspect of the present invention, in a table processing device for outputting a table composed of a plurality of cells, a table or a row or a column commonly associated with the plurality of cells constituting the table is provided. The condition for evaluating the cell value for each item name and the output cell value corresponding to the condition for evaluating the cell value are defined in association with each other, and the output means outputs the table to each cell when outputting the table. A corresponding output cell value stored in the storage means is read based on an item name corresponding to the cell and a cell value of the cell, and the read output cell value is output to the cell to output a table.

Therefore, a condition for evaluating a cell value for each row or column item name and an output cell value corresponding to the condition for evaluating the cell value are defined, and a table is output (displayed or printed).
In such a case, the output cell value based on the item name corresponding to the cell and the cell value of the cell is output to the cell, so that the cell included in the column or row corresponding to the item name is included in the cell. It is possible to output an output cell value according to a condition for evaluating a cell value of a cell, and as a result, it is possible to easily add new data or the like according to a certain condition, thereby performing advanced data processing. And the convenience of the operator is improved.

In this case, a condition for evaluating a cell stored in the cell stored in the storage means and an output cell value corresponding to the condition for evaluating the cell value are set as in the sixth aspect of the present invention. It is effective that it can be set arbitrarily.

That is, according to the invention described in claim 6, in the invention described in claim 5, the condition for evaluating the cell stored in the cell stored in the storage means and the condition for evaluating the cell value are satisfied. The output cell value to be set can be set arbitrarily.

Therefore, in addition to the effects of the invention described in claim 5, the condition for evaluating the cell and the output cell value corresponding to the condition for evaluating the cell value can be arbitrarily set, and the output cell to be output within the cell can be set. The degree of freedom in setting values is improved.

[0027]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Referring to FIGS.
An embodiment according to the present invention will be described. (First Embodiment) A first embodiment will be described in detail with reference to FIGS. FIGS. 1 to 7 are diagrams showing a first embodiment of a computer system to which a table processing apparatus of the present invention is applied.

First, the configuration will be described. FIG. 1 is a block diagram showing a main configuration of a computer system 1 according to the present embodiment. In FIG. 1, a computer system 1
Is composed of a CPU 2, an input device 3, a RAM 4, a storage device 5, a storage medium 6, a printing device 7, and a display device 8, and each unit is connected by a bus 9.

CPU (Central Processing Unit) 2
A window system program as a GUI stored in the storage device 5, an application program designated from various application programs corresponding to the window system, and various instructions or data input from the input device 3 in the RAM 4. Various processes are executed in accordance with the application program stored in the RAM 4 in accordance with the input instruction and the input data, and the processing results are stored in the work memory in the RAM 4 and displayed on the display device 8. Then, the processing result stored in the work memory 4a is stored in a storage destination in the storage device 5 designated by the input device 3 for input.

Further, in a table output process (see FIG. 6), which will be described later, which is performed on table data stored in a table data storage unit 5b in the storage device 5, the CPU 2 outputs a cell from the table data. The data is read, an item name (title) is obtained from the cell address of the read cell data, and then the storage device 5 is used with the obtained item name as a key.
In the evaluation storage means file 5a, evaluates the cell value under the conditions included in the corresponding record of the evaluation storage means file 5a, sets color information corresponding to the cell value, and sets each cell based on the set color information. Is displayed on the display device 8 or printed in color from the printing device 7.

The input device 3 includes a keyboard having cursor keys, numeric input keys, various function keys, and the like, and a mouse as a pointing device. The input device 3 outputs to the CPU 2 a pressing signal of a key pressed by the keyboard. And outputs an operation signal from the mouse to the CPU 2.

The RAM (Random Access Memory) 4
A work memory is provided for storing designated application programs, input instructions, input data, processing results, and the like.

The storage device 5 has a storage medium 6 in which programs, data and the like are stored in advance, and this storage medium 6 is constituted by a magnetic or optical recording medium or a semiconductor memory. The storage medium 6 is fixedly provided in the storage device 5 or is detachably mounted. The storage medium 6 includes a window system program as the GUI and various application programs corresponding to the window system. The print processing program and data processed by each processing program are stored. Further, as shown in FIG. 2, the storage device 5 includes an evaluation table file 5a and a table data storage unit 5b for storing table data.

The program, data, and the like stored in the storage medium 6 may be received and stored from another device connected via a communication line or the like. A storage device provided with the storage medium 6 may be provided on the other connected device side, and the program and data stored in the storage medium 6 may be used via a communication line.

The printing device 7 prints out print data (such as table data) input from the CPU 2 in a designated color.

The display device 8 is a CRT (Cathode Ray Tub).
e) and the like, and displays display data (table data and the like) input from the CPU 2 in a designated color.

Next, the operation of this embodiment will be described.

First, an example of table data stored in the table data storage unit 5b in the storage device 5 will be described with reference to FIG. Table data as shown in FIG. 3 is stored in the table data storage unit 5b according to the present embodiment.
"Current ratio" and "Equity ratio" are set as column items (column titles), and "Company A", "Company B", and "Company C" are set as line items (line titles). ing. Then, the data “170, 152, 14” of the row item “company A, company B, company C” for the column item “current ratio”
3 is input, and the data “6” of the row item “Company A, Company B, Company C” with respect to the column item “Equity ratio” is entered.
5, 22, 53 "are input.

Next, an example of the configuration of the evaluation table file 5a in the storage device 5 will be described with reference to FIG. As shown in FIG. 4, the evaluation table file 5a according to the present embodiment includes a maker-provided area 5a1 and a user-defined area 5a2, both of which can be customized.

FIG. 5 shows the evaluation table file 5a of FIG.
3 is a diagram showing an example of the record structure of FIG. That is, FIG.
In the evaluation table file, variable length records as shown in FIG. 5 are aggregated to form an evaluation table file.

The records shown in FIG. 5 are “title”,
“Condition N”, “Color N”, “CT”, “CJ”, “C
"C" and "CR". "Title"
Indicates a row item name (row title) or a column item name (column title) of the table, and can be expressed in a normalized manner such as * amount, * achievement rate. “Condition N” indicates a conditional expression for evaluating a cell value. It should be noted that anything that can be recognized as a cell value, such as characters and numerical values, is subject to the conditional expression. “Color N” is an example of the modification information, and is color information corresponding to the condition N. The color information is not limited to the color name, but may be an RGB value or the like. “CT” indicates the end of the title area,
“CJ” indicates the end of the condition N area, “CC” indicates the end of the color N area, and “CR” indicates the end of one record.

Incidentally, "condition" and "color" can be arbitrarily set to 1 to N in combination. Further, the “title”, “condition N”, and “color N” can be arbitrarily set by the operator. Further, the modification information is not limited to the above “color”. For example, a character size, a font, a character color, a character font, hatching, and underlining may be set.

In the example of the record shown in FIG. 5A, “flow rate” is set as the title, and “> 16” is set as the condition 1.
5 ”,“ blue ”as color 1 and“ 165 ≧ 165 ”as condition 2.
≧ 145 ”,“ 145> ”is set as the condition 3, and“ red ”is set as the color 3. In the example of the record shown in FIG.
As the condition 1, “> 60”, as the color 1, “blue”, as the condition 2, “60 ≧ 30”, and as the condition 3, “30 ≧ 30”
> ”, And“ Red ”is set as color 3 respectively.

Subsequently, the table output processing executed under the control of the CPU 2 will be described with reference to the flowchart shown in FIG. FIG. 6 is a flowchart for explaining a table output process executed under the control of the CPU 2. Programs for realizing the functions described in this flowchart are stored in the storage medium 6 in the form of program codes readable by the CPU 2.

First, the CPU 2 reads cell data from table data stored in the table data storage unit 5b in the storage device 5 (step S1). Next, an item name corresponding to the cell is acquired by referring to the item name (title) from the cell address of the cell from which the cell data has been read (step S).
2). Next, the evaluation table file 5a in the storage device 5 is searched using the obtained item name as a key (Step S).
3) The cell value is evaluated based on the conditions included in the searched record, and color information corresponding to the cell value is determined (step S4).

Then, a cell value is set (output) based on the determined color information (step S5). Next, the cell address is incremented by 1 (step S6), and it is determined whether or not the corresponding cell exists. If so, the process proceeds to step S1 to repeat the above operation. The table is displayed on the display device 8 or printed in color from the printing device 7 based on the color information set in the cell value of each cell (Step S).
8), the table output process ends.

Next, a specific output example of the table output processing will be described with reference to FIG. The output example shown in FIG.
FIG. 7 is a diagram showing an output example in which the table data shown in FIG. 6 is processed and output by the table output processing in FIG. 6 based on the evaluation table file 5a shown in FIG.

"170" is read as cell data from the table data shown in FIG. 3 (step S1), and
The "flow rate", which is the item name corresponding to the cell address of the read cell, is referred to (step S2), and the evaluation table file 5a shown in FIG. In step S3), the cell value is evaluated under the conditions included in the searched record (the record shown in FIG. 5A).
Since this corresponds to “> 165”, the corresponding color 1 “blue” is set.

Next, "152" is read as cell data from the table data shown in FIG.
1) Referring to the "flow ratio" which is an item name corresponding to the cell address of the read cell (step S2),
Next, the evaluation table file 5a is searched using the “flow ratio” as a key (step S3), and the cell value is evaluated under the conditions included in the searched record (the record in FIG. 5A). Contains the condition 2 “165 ≧
145 ", the corresponding color 2 is set. Since no color information is set for this color 2, no color is set for the cell.

Also, "143" is read as cell data from the table data shown in FIG.
1) Reference is made to "flow ratio" which is an item name corresponding to the cell address of the read cell (step S)
2) Next, the evaluation table file 5a is searched using the “flow ratio” as a key (step S3), and the cell value is evaluated under the conditions included in the searched record (the record in FIG. 5A). In this case, condition 3 “1”
45>", the corresponding color 3" red "is set.

Also, "65" is read as cell data from the table data shown in FIG.
1) Reference is made to the "capital ratio" which is an item name corresponding to the cell address of the read cell (step S)
2) Next, the evaluation table file 5a is searched using the "equity ratio" as a key (step S3),
The cell value is evaluated under the conditions included in the searched record (the record in FIG. 5B), and in this case, the condition 1
Since this corresponds to “> 65”, the corresponding color 1 “blue” is set.

Also, "22" is read as cell data from the table data shown in FIG.
1) Reference is made to the "capital ratio" which is an item name corresponding to the cell address of the read cell (step S)
2) Next, the evaluation table file 5a is searched using the "equity ratio" as a key (step S3),
The cell value is evaluated under the conditions included in the searched record (the record in FIG. 5B). In this case, the condition 3
Since this corresponds to “> 30”, the corresponding color 3 “red” is set.

Also, "53" is read as cell data from the table data shown in FIG.
1) Reference is made to the "capital ratio" which is an item name corresponding to the cell address of the read cell (step S)
2) Next, the evaluation table file 5a is searched using the "equity ratio" as a key (step S3),
The cell value is evaluated under the conditions included in the searched record (the record in FIG. 5B), and in this case, the condition 2
Since “60 ≧≧ 30”, the corresponding color 2 is set. Since no color information is set for this color 2, no color is set for the cell.

Accordingly, as shown in FIG. 7, the cells to which the cell values "170", "143", "65", and "22" have been input become "blue", "red",
“Blue” and “red” are color-displayed on the display device 8 or color-printed from the printing device 7 (the above-described step S).
8).

As described above, in this embodiment, a condition for evaluating a cell value for each column item name and color information corresponding to the condition for evaluating the cell value are defined in the evaluation table file 5a. When outputting (displaying or printing) a table, the cell is output in a color corresponding to the item name corresponding to the cell and the color information based on the cell value of the cell. The output can be modified. In addition, since the cells included in the column or row corresponding to the item name can be modified and output according to the condition for evaluating the cell value, the data of the column or row corresponding to the item name can be identified according to the evaluation condition. As a result, it is possible to easily identify a difference in data in the same item, and the convenience of the operator is improved.

It should be noted that the modification information may be set in association with the mutual relationship between the row item names and the column item names.

(Second Embodiment) Next, a second embodiment of the present invention will be described.
The table processing device according to the embodiment will be described. 8 to 11 are diagrams for explaining a table processing device according to the second embodiment.

The computer system according to the second embodiment has basically the same configuration as the computer system according to the first embodiment shown in FIG. 1, and the description of the configuration is omitted. .

The difference between the first embodiment and the second embodiment is that the first embodiment is different from the first embodiment in that the condition for evaluating the cell value for each column or row item name and the cell value Is defined as color information corresponding to the condition for evaluating, and according to the cell value,
While the cell color is changed and output, the second
In the embodiment, a condition for evaluating a cell value for each column or row item name and an output cell value corresponding to the condition for evaluating the cell value are defined, and output in a cell is performed according to the cell value. The point is that the output cell value to be changed is changed.

Next, the operation of the second embodiment will be described. First, in the second embodiment, an example of table data stored in the table data storage unit 5b in the storage device 5 shown in FIG. 2 will be described with reference to FIG. Table data as shown in FIG. 8 is stored in the table data storage unit 5b according to the present embodiment, and the table data includes column items (column titles).
Is set, and "Mr. A" and "Mr. B" are set as line items (line titles). Then, the line item “A” for the column item “express fare”
The data "Tokyo-Nagoya, Tokyo-Osaka" of "Mr. B" is input.

FIG. 9 is a diagram showing an example of the record structure of the evaluation table file 5a shown in FIG. 2 according to the second embodiment. The record shown in FIG.
“Title”, “condition N”, “output cell value N”, “C
T ”,“ CJ ”,“ CC ”, and“ CR. ”“ Title ”indicates a row item name (row title) or a column item name (column title) of the table. “Condition N” indicates a conditional expression for evaluating a cell value, and all the characters, numerical values, and the like recognized as cell values are subject to the conditional expression.
“Output cell value N” is a cell value for the condition N.
Since “CT”, “CJ”, “CC”, and “CR” have already been described with reference to FIG. 5, their description is omitted.

The “condition” and “output cell value” are 1 to
Any combination up to N can be set. “Title”, “condition N”, and “output cell value N” are:
The operator can set it arbitrarily.

Here, in the example of the record shown in FIG. 9A, the column item name "express fare" as the title, "Tokyo-Osaka" as the condition 1, and "$ 60" as the cell value 1
00 is the condition 2 and “Tokyo-Nagoya” is the cell value 2
Is set to “$ 4000”. In the example shown in FIG. 9B, the title “transfer fee”
However, as the condition 1, “telegraph” is set as the cell value 1 and “$ 3
00, “document” is set as the condition 2, and “$ 200” is set as the cell value 2.

Next, another embodiment of the table output process executed under the control of the CPU 2 will be described with reference to the flowchart shown in FIG.

FIG. 10 is a flowchart for explaining a table output process executed under the control of the CPU 2.
Programs for realizing the functions described in this flowchart are stored in the storage medium 6 in the form of program codes readable by the CPU 2.

In FIG. 10, first, the CPU 2 reads cell data from the table data stored in the table data storage unit 5b in the storage device 5 (step S11). Then
The item name (title) corresponding to the read cell address is referenced (acquired) (step S12). Then
Using the item name as a key, the evaluation table file 5a is searched (step S13), the cell value is evaluated under the conditions included in the searched record, and an output cell value corresponding to the cell value is determined (step S14). .

Then, the output cell value determined within the cell containing the cell value is set (output) (step S15).
Next, the cell address is incremented by 1 (step S16), and it is determined whether or not the corresponding cell exists (step S17). If it does exist, the process returns to step S11. If not, the process proceeds to step S18. Then, when outputting the table, the output cell value set in the cell is displayed on the display device 8 or color-printed by the printing device 7, and the table output process ends.

Next, a specific output example of the table output processing will be described with reference to FIG. The output example shown in FIG.
FIG. 11 is a diagram illustrating an output example in which the table data illustrated in FIG. 8 is processed and output by the table output process illustrated in FIG. 10 based on the evaluation table file 5a illustrated in FIG. 9. First, FIG.
"Tokyo-Osaka" as cell data from the table data shown in
Is read (step S11), the item name "express charge" corresponding to the cell address of the read cell is referred to (step S12), and the evaluation table file is set using the "express charge" as a key. 5a is searched (step S13 above), and the cell value is evaluated under the conditions included in the searched record (the record in FIG. 9A). In this case, the condition 2 corresponds to the condition 2 “Tokyo-Nagoya” Therefore, the corresponding output cell value 2 “$ 4000” is set.

Next, "Tokyo-Osaka" is read as cell data from the table data shown in FIG. 8 (step S1), and "Express train charge" which is an item name corresponding to the cell address of the read cell is entered. Referenced (step S
12) Then, the evaluation table file 5a is searched using the "express fare" as a key (step S13), and the cell value is evaluated under the conditions included in the searched record (the record in FIG. 9A). , In this case, condition 1
Since it corresponds to “Tokyo-Osaka”, the corresponding cell value 1 “￥”
6000 "is set.

Therefore, by the above processing, the output cell values "$ 4000" and "$ 6000" are output to the cells to which the cell data "Tokyo-Nagoya" and "Tokyo-Osaka" are input, respectively. Then, the table as shown in FIG. 11 is displayed in color on the display device 8 or printed in color from the printing device 7 (step S18).

As described above, in the present embodiment, the condition for evaluating the cell value for each item name in the row or column and the output cell value corresponding to the condition for evaluating the cell value are stored in the evaluation table file 5a. When a table is output (displayed or printed), an item name corresponding to the cell and an output cell value based on the cell value of the cell are output in the cell. In a cell included in a column or a row, an output cell value according to a condition for evaluating a cell value of the cell can be output, and as a result, new data or the like according to a certain condition can be easily added. Can perform advanced data processing,
Operator convenience is improved.

[0072]

According to the first aspect of the invention, a condition for evaluating a cell value for each row or column item name and modification information corresponding to the condition for evaluating the cell value are defined, and a table is output. At the time of (display or print), the cell is output in an output form according to the modification information based on the item name corresponding to the cell and the cell value of the cell, so that the cell can be modified by a simple operation. It is possible to output. In addition, since the cells included in the column or row corresponding to the item name can be modified and output according to the condition for evaluating the cell value, the data of the column or row corresponding to the item name can be identified according to the evaluation condition. As a result, it is possible to easily identify a difference in data in the same item, and the convenience of the operator is improved.

According to the second aspect of the present invention, in addition to the effects of the first aspect, a condition for evaluating a cell value and modification information corresponding to the condition for evaluating the cell value are arbitrarily set. As a result, the degree of freedom of the output form of the cell is improved.

According to the third aspect of the present invention, in addition to the effects of the first or second aspect of the present invention, it is possible to output a cell in various output forms, thereby further diversifying the output form of the cell. It becomes possible.

According to the invention set forth in claim 4, claims 1 to 5
In addition to the effects of the invention described in any one of the above items 3, it becomes possible to qualify and output a cell by evaluating it with the row item name for the column item name or the column item name for the row item name. Thus, the convenience of the operator is improved.

According to the fifth aspect of the present invention, a condition for evaluating a cell value and an output cell value corresponding to the condition for evaluating the cell value are defined for each row or column item name, and a table is output ( (Display or print), the item name corresponding to the cell and the output cell value based on the cell value of the cell are output in the cell, so that the cell name included in the column or row corresponding to the item name is output. In addition, it is possible to output an output cell value according to a condition for evaluating the cell value of the cell, and as a result, new data or the like according to a certain condition can be easily added. Processing can be performed, and the usability of the operator is improved.

According to the invention of claim 6, in addition to the effect of the invention of claim 5, it is possible to arbitrarily set a condition for evaluating a cell and an output cell value corresponding to the condition for evaluating the cell value. The degree of freedom in setting the output cell value to be output in the cell is improved.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a main configuration of a computer system according to a first embodiment to which a table processing device of the present invention is applied.

FIG. 2 is a diagram showing an evaluation table file and a table data storage unit stored in a storage device 5 of FIG. 1;

FIG. 3 is a diagram showing an example of table data stored in a table data storage unit.

FIG. 4 is a diagram showing a configuration of an evaluation table file.

FIG. 5 is a diagram showing a record structure of an evaluation table file.

FIG. 6 is a flowchart for explaining a table output process executed under the control of the CPU in FIG. 1;

FIG. 7 is a diagram illustrating an example of outputting a table in the table output process of FIG. 6;

FIG. 8 is a diagram illustrating an example of table data stored in a table data storage unit according to the second embodiment.

FIG. 9 is a diagram showing a record structure of an evaluation table file according to the second embodiment.

FIG. 10 is a flowchart illustrating a table output process executed under control of a CPU according to the second embodiment.

FIG. 11 is a diagram showing an example of outputting a table in the table output process of FIG. 10;

[Explanation of symbols]

 Reference Signs List 1 computer system 2 CPU 3 input device 4 RAM 5 storage device 5a evaluation table file 5b table data storage unit 6 storage medium 7 printing device 8 display device 9 bus

Claims (6)

[Claims] 1. A table processing apparatus for outputting a table composed of a plurality of cells, wherein a cell value is assigned to each row or column item name commonly associated with the plurality of cells constituting the table. Storage means for storing a condition to be evaluated and modification information corresponding to the condition for evaluating the cell value; and when outputting the table, for each cell, an item name corresponding to the cell and a cell of the cell Output means for reading the corresponding modification information stored in the storage means based on the value, outputting each cell in an output form corresponding to the read modification information, and outputting a table. Table processing equipment. 2. The table processing according to claim 1, wherein a condition for evaluating a cell value stored in said storage means and modification information corresponding to the condition for evaluating the cell value can be arbitrarily set. apparatus. 3. The decoration information includes color, character size, typeface,
3. The table processing apparatus according to claim 1, wherein one or more of a character color, a character font, hatching, and underlining are designated. 4. The table processing apparatus according to claim 1, wherein the decoration information is specified in association with a correlation between an item name of the row and an item name of a column. . 5. A table processing device for outputting a table composed of a plurality of cells, wherein a cell value is evaluated for each item name of a row or a column commonly associated with the plurality of cells constituting the table. And storage means for storing an output cell value corresponding to a condition for evaluating the cell value, and when outputting the table, for each cell, an item name corresponding to the cell and a cell of the cell Reading a corresponding output cell value stored in the storage means based on the value;
Output means for outputting a read output cell value into the cell to output a table, and a table processing device comprising: 6. A condition for evaluating a cell stored in a cell stored in the storage means and an output cell value corresponding to a condition for evaluating the cell value can be arbitrarily set. Item 6. The table processing device according to Item 5.