JPH10187679A - Table processor and storage medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce the size of a table by decreasing the number of cells when many table data are processed. SOLUTION: A computer system 1 can store plural pieces of cell data in cell information corresponding to one cell of a table. Then call data to be displayed in the table are stored, one by one, so they can be stored in a table data file 10 while pieces of data made to correspond to one cell of the table. When the table is outputted to a display part 7 and a print part 8, pieces data can be read out of each piece of cell information of table data. When the pieces of data are read out of the one piece of cell information, the pieces of data are displayed in one cell area of the outputted table. Therefore, the table which consists of many data can be reduced in size by decreasing the number of the cells.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a table processing apparatus,
More specifically, the present invention relates to a table processing apparatus that processes table data in units of cells using spreadsheet software or the like.

[0002]

2. Description of the Related Art Generally, for example, a word processor (Wo
rd Processor) and personal computer (Personal C)
In an arithmetic processing device such as an omputer) or an engineering work station (Engineering Work Station), various table data can be created in cell units using a spreadsheet application program and output (displayed, printed, etc.). , Can be used as a table processing device.

In the above-described table processing apparatus that creates a table in cell units, for example, each cell in the table has, for example,
Numerical data, character data, arithmetic expression data, and the like can be input and set. In some cases, image data or the like other than the data described above can be input and set in the cell.

[0004]

By the way, in a general table processing apparatus, that is, a spreadsheet application program operated by a computer or the like, basically,
One data is stored in one cell. That is, one cell stores one numerical data, one character data, one arithmetic expression data, or one image data, except for ancillary data such as a format, a positional relationship between cells, and a relation between cells. Will be done. When the table data is output, one numerical value, one character string, one image, or one operation result is displayed or printed for each cell area constituting the table.

[0005] For example, in a table composed of cells arranged in a plurality of columns, when the number of data stored in the cells in the horizontal row of the table is large, if this is simply output, this is output. In many cases, the columns become too long to fit on the screen or paper.In such a case, the size and arrangement of characters and cells must be changed, and the table must be edited to fit on the screen or paper. It took time and effort to make the table.

An object of the present invention is to reduce the number of cells and reduce the size of a table in processing table data having a large number of data.

[0007]

According to a first aspect of the present invention, there is provided a table processing apparatus for processing table data comprising a plurality of cells, wherein data corresponding to each cell of the table data is stored. A storage means for storing and storing a plurality of data corresponding to one cell, and reading out the data corresponding to each cell stored in the storage means for each cell; And a plurality of cell areas respectively corresponding to the plurality of cells, and a plurality of cell areas respectively corresponding to the plurality of cells. Output a table in which the read data is displayed, and output the plurality of data in one cell area corresponding to the cell from which the plurality of data is read. And having a stage.

According to the above arrangement, the storage means stores a plurality of data corresponding to one cell, and the reading means reads a plurality of data corresponding to one cell from the storage means. The output means can output a table in which a plurality of data are displayed in one cell area corresponding to one cell. Therefore, a table in which a plurality of data are displayed in one cell region can be easily created, and the number of cells in the table can be reduced by displaying a plurality of data in one cell region. Therefore, the size of the table can be made compact.

For example, in a horizontally long table in which one cell is stored in each cell, two or more pieces of data arranged side by side and displayed for each cell area are replaced with one cell. If you display it vertically in the area,
The number of cells arranged horizontally can be reduced to 横 or less, and the horizontal length of the table can be reduced to 以下 or less. Therefore, without performing the editing process (change of the format such as the character size and cell size) that was conventionally performed to fit a table having a large number of data in a limited space, the number of data in the limited space is not required. It is possible to print many tables,
The work of creating a table can be made more efficient.

According to a second aspect of the present invention, in the table processing device, the storage means displays all of a plurality of data stored corresponding to one cell in a cell area corresponding to the cell, or Storing selection information for determining whether to select a part of data from a plurality of data and to display the selected data in the cell area, wherein the reading unit stores the selection information together with the data stored corresponding to each cell; From the storage means, the output means, based on the selection information read by the reading means, selects all or a part of the data corresponding to one cell for each of the cells, The selected data is displayed in each cell area corresponding to each of the cells.

According to the above configuration, when outputting a table in which a plurality of data are stored corresponding to one cell, all data corresponding to the cell is stored in a cell area corresponding to one cell. Instead of being displayed, only data selected based on the selection information can be displayed. That is, even if a plurality of data are stored in one cell, display or non-display in a table can be selected for each data.

According to a third aspect of the present invention, in the table processing apparatus, the storage means is capable of storing image data corresponding to the cell, and the output means is configured to store the image data based on the selection information.
In outputting a plurality of image data or image data and character data to one cell area, the plurality of image data or image data and character data are combined in a superimposed state, and the data combined in the cell area Is displayed.

According to the above arrangement, when a plurality of image data or image data and character data are displayed in one cell area, the plurality of image data or image data and character data are combined in a superimposed state. Can be displayed. Therefore, a display combining a plurality of image data and a display combining image data and character data can be performed. In addition, when the display area of the image data is relatively large, when a plurality of image data or character data and image data are displayed so as not to overlap each other in one cell area, a large area is required as the cell area. However, the size of the cell region can be reduced by displaying these data in a single cell region in a state where they are superimposed on each other.
Therefore, the size of the table can be reduced.

According to a fourth aspect of the present invention, there is provided a table processing apparatus, comprising: an instruction means for designating an arbitrary cell area of a displayed table; and an arbitrary cell area of the table being designated by the instruction means. When there is data not selected and displayed by the output means in the designated cell area, output control means for displaying the data not displayed is provided.

According to the above arrangement, the data not displayed in the cell area by the arrangement of the second aspect can be used, for example, by designating the cell area on the display screen without rewriting the selection information stored in the storage means. Can easily be seen. Therefore, all data stored in the storage means can be easily confirmed on the display screen.

In the table processing apparatus according to a fifth aspect of the present invention, when displaying a plurality of data in a cell area corresponding to the cell, the storage means is arranged to indicate an arrangement of each data in one cell area. Information, the reading means reads out the arrangement information together with the data stored corresponding to each cell from the storage means, and the output means displays a plurality of data in one cell area. The arrangement of a plurality of data in the cell area is determined based on the arrangement information read by the reading means, and the plurality of data is displayed in the cell area.

According to the above configuration, when a plurality of data are displayed in one cell area, the arrangement can be performed based on the arrangement information stored in advance. Can be arranged up and down, or the order of arrangement of each data can be determined in advance. Therefore, in a horizontally long table, data is arranged vertically in one cell to reduce the length of the table in the horizontal direction. In a vertically long table, data is arranged horizontally in one cell and left and right in a cell. The length in the vertical direction can be shortened. In addition, by arranging the data arrangement order in advance, even if a plurality of data are displayed in one cell area, the data can be displayed regularly.

According to a sixth aspect of the present invention, in the storage medium storing a computer-executable program, the storage medium corresponding to each cell of the table data for processing the table data including a plurality of cells. A computer-readable program code capable of storing a plurality of data corresponding to one cell for each cell, and storing each data for each cell. In addition to reading out the data stored corresponding to each cell, and reading out the data corresponding to each cell, a plurality of data can be read out from the cell stored correspondingly by a computer readable computer. It is composed of a program code and a plurality of cell areas respectively corresponding to the plurality of cells. A table in which data read for each cell is displayed is output, and when data read for each cell is displayed in the corresponding cell area, a cell from which a plurality of data is read is displayed. And a computer readable program code for displaying the plurality of data in a cell region corresponding to the program.

[0019]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Preferred embodiments of the present invention will be described below in detail with reference to the drawings. 1 and 2 are diagrams showing a computer system to which a table processing device according to the present invention is applied.

First, the configuration will be described. FIG. 1 is a block diagram of a computer system 1 to which the present invention is applied. In the figure, the computer system 1 includes an input unit 2, a mouse 3, a processing work memory 4, an image file 5, a CPU 6, a display unit 7, It comprises a printing unit 8, an image reader 9, a table data file 10, a storage device 11, and a storage medium 12, and each unit is connected by a bus 13.

The input unit 2 has function keys, numerical keys, character keys, and other keys, and outputs various operation signals to the CPU 6 according to each key input operation by the user. The mouse 3 is a pointing device that performs designation of icons and operation menus displayed on the display screen of the display unit 7 or selection and selection of cells constituting table data.
The relative position coordinate data and the click signal are output to the CPU 6.

The processing work memory 4 is used to edit the image data read from the image file 5 when the CPU 6 synthesizes a plurality of image data or synthesizes character data and image data. Is formed. Image file 5
Is a memory for storing a plurality of image data read by the image reader 9.

CPU (Central Processing Unit) 6
Is a central processing unit that controls each unit of the computer system 1 according to various control programs and application programs stored in the storage device 11 and the storage medium 12. Specifically, when inputting data corresponding to each cell of the table, the CPU 6 stores a plurality of data in the table data file 10 or the storage medium 12 in association with one cell, and displays the table. A function of outputting a plurality of data in a state where a plurality of data are displayed in a cell area of a table corresponding to the cell when a plurality of data are stored in one cell when the data is output from the unit 7 or the printing unit 8; When outputting a table with multiple data displayed in one cell area,
A function of outputting a table in a state where data is arranged and displayed in the cell area in accordance with display order information described later.

When a plurality of data are stored in one cell, the CPU 6 selects a part of the plurality of data and selects the selected data in the cell area of the table corresponding to the cell. A function that outputs a table with only data displayed, and when multiple image data is stored in one cell, or when character data and image data are stored, these data are combined and superimposed A function to output a table in a state where the table is displayed in the cell area corresponding to the cell, and an arbitrary cell area of the table displayed on the screen of the display unit 7 is designated by the mouse 3 and When a plurality of data are stored in the corresponding cell and only a part of the data is displayed in the cell area, the data not displayed is displayed on the display unit 7. It has that function and, a function to output the table to appear by specified data in a state of being attached to any of the cell region by mouse 3 as described above.

The display unit 7 is a CRT (Cathode Ray Tube)
And a liquid crystal display.
The display data input through the display unit 6 is displayed. Printing unit 8
Is print data (for example,
Table data) on paper. Image Reader 9
Is scanned over the set document to be read,
The original image is read at a predetermined resolution and stored in the image file 5 as image data.

The table data file 10 is a memory for storing a table data file formed by arranging a plurality of cell data processed by the CPU 6. FIG. 2 is a diagram showing the data structure of the table data file stored in the table data file 10. In the figure, a table data file includes table data overall information S1 for managing the table data file, an overall format S2 which is data of a format set for the entire table data, and a cell which is data for each cell. Information c1, c2 to cn (S3).

The table data overall information S1 includes, for example, data names, information on table data storage areas in the table data file 10, the number of columns and rows of table data cells, the date of data creation, and the date of data modification. It contains management information of table data. In the overall format S2, the font type set in the table (0: Mincho, 1 Gothic, etc.), font size (0: 8 points, 1:10 points, etc.), character assignment (0: left justified) , 1: center, 2: right justified, etc.),
Numerical format (0: standard, 1: 3 digit separation, etc.), size of each cell, format for characters outside table margins (font type, font size, character assignment, numeric format, etc.),
It includes the default colors of table areas and ruled lines. As will be described later, the format can be set for each cell and each data. If a format item that is the same as the above-described overall format is set for a cell, the cell setting has priority. In addition, when an item of a format that is the same as the entire format or the cell format is set in the data, the format of the data has priority.

In this example of the table processing device, a plurality of data can be stored in one cell, and the data structure of each cell information S3 has cell coordinate data (cell coordinate data indicating a cell position in the table). (Two-dimensional coordinates of (X, Y)) S
4, cell format S5 set for each cell, and cell data d1, d2 to dm (S6) corresponding to a plurality of data stored in one cell. Here, the cell format S5 is, for example, the color of the cell area of the table to be output. However, the font type, font size, character assignment, numeric format, and multiple It may include the assignment of the display position of each data when the data is registered.

Each cell data S6 is composed of data S7 registered in a cell, a data format S8 set for each data S7, a display order U1, and a logical operation U2. For example, when the table is output, the data S7 includes numerical data, character data, and image data that are actually displayed in each cell area of the table, and an operation in which the calculation result is displayed in each cell of the table. And an expression. The data format S8 is a format set for each data, for example, a font type and a font size set for each data. For example, the data format S8 includes a character layout, a numerical format, and a color. Is also good. The information of the data format S8 includes the type of the data S7 (numeric value,
(Characters, arithmetic expressions, images, etc.).

The display order U1 is information indicating the order of display positions when a plurality of data S7 are stored in one cell. For example, a plurality of data S7 are displayed vertically in one cell area. In such a case, the data S7 is arranged above and below the data S7 in the display order. Therefore, when displaying a plurality of data S7 in one cell area according to the display order U1,
The arrangement position of the plurality of data S7 is determined, and the display order U1 is arrangement information indicating the arrangement position of the data S7 in one cell region.

The above-mentioned logical operation U2 includes one cell information S3
Is displayed in a state where the plurality of image data S7 or the image data S7 and the character data S7 are superimposed on each other, or the plurality of image data S7 or the image data S7 and the character data S7 are displayed. This is information indicating whether only the selected data S7 is to be displayed in the form of a logical operation. For example, one cell information S
3 stores a plurality of image data S7 or a plurality of image data S7 and character data S7, a logical operation U of each cell data S6 including each data S7.
If "OR" is stored in item 2, the plurality of image data S7 or the image data S7 and the character data S7 are combined and output in a state of being superimposed on each other.

In this case, each data S7 is basically displayed in a superimposed manner in the same cell area. Therefore, the items of the display order U1 indicating the arrangement order in one cell area are the same. Must store numeric values. When the character data S7 is superimposed on the image data S7 to be synthesized, the layout position of the character data S7 in the area of the image data S7 may be specified as a format.

When a plurality of image data S7 or the image data S7 and the character data S7 are stored in one cell information S3, the item of the logical operation U2 of each cell data S6 including each data S7 is included in the item. "AN
If "D" is stored, only one of the image data S7 or the image data S7 and the character data S7 is displayed. In this case, the information of the display order U1 becomes the information indicating the priority, and the data S6 of the cell data S6 having the smallest numerical value of the display order U1.
7 is selected and displayed. That is, the information of the logical operation U2 and the information of the display order U1 are selection information when selecting and displaying some data S7 among the plurality of data S7 in one cell region.

The storage device 11 reads and writes data from and to the storage medium 12. The storage medium 12 is constituted by a magnetic or optical recording medium or a semiconductor memory. The storage medium 12 may be fixedly provided in the storage device 11 or may be detachably mounted on the storage device 11. The storage medium 19 stores in advance a program for realizing the functions of table creation processing (FIG. 5), data input processing (FIG. 6), display processing (FIG. 7), and cell selection processing (FIG. 9). Various data such as data processed by these programs is stored.

The program, data, and the like stored in the storage medium 12 may be received and stored from another device connected via a communication line or the like. A configuration may be adopted in which a storage device 11 having the storage medium 12 is provided on another connected device side, and programs, data, and the like stored in the storage medium 12 are used via a communication line. The above is the configuration of the computer system 1 according to the present embodiment.
Note that the image file 5 and the table data file 10 may be predetermined storage areas provided in the storage medium 12 of the storage device 11 as a matter of course.

Next, the operation will be described. C of this embodiment
Regarding table creation processing, data input processing, display processing, and cell selection processing executed in the PU 6, an example of display of table data shown in FIG. 3, an example of a data structure of cell information shown in FIG. A description will be given based on a flowchart shown in FIG. 7, a display example of another table data shown in FIG. 8, and a flowchart shown in FIG. 5, 6, and 7
A program for realizing each function described in the flowchart shown in FIG. 9 is stored in the storage medium 12 of the storage device 11 in the form of a program code readable by the CPU 6.

First, the table creation processing (FIG. 5) and the data input processing (FIG. 6) executed by the CPU 6 will be described. In the table creation processing, when the operator selects creation of a new table from the menu, a table in which a large number of cell regions are arranged vertically and horizontally is displayed on the screen.
Further, in this state, the entire format S2 can be input.

In this state, for example, if the operator designates an arbitrary cell area with the mouse 3, the data S
Cell information S having a specific cell coordinate S4 to which 7 is to be input
3 is in the designated state, and the frame of the cell area designated by the operator is highlighted and displayed. Then, the cell data S6 to which the data S7 is to be input is set in the cell information S3 corresponding to the cell coordinates S4 of the cell area designated by the operator (step A1). In this case,
By selecting a format from the menu, the cell format S5 can be entered. If the cell format S5 is not entered, the default cell format S5 or the entire format S5 is entered.
The format specified in step 2 is set. For simplicity of description, it is assumed that the color of the cell area is set as the cell format S5 as shown in the data structure of FIG.

Here, for example, if the operator specifies the cell 2-A in the table shown in FIG.
The cell coordinates S4 shown in FIG.
This means that cell data S7 for inputting No. 7 is set.
In this state, it becomes possible to input data to the cell information S3 having the cell coordinates S4, and a data input process is performed (step A2).

The data input processing is performed as shown in the flowchart of FIG. In the state where the cell area is specified by the mouse 3 as described above, the type of the data S7 to be input by the operator, for example, characters, numerical values, images, arithmetic expressions, and the like can be selected and specified from a menu. It is determined whether or not the type of the data S7 has been designated (step B1). Then, the data S7 to be input
Is specified by the operator, the type of data S7 is set (step B2). In addition,
In the data structures of FIGS. 2 and 4, the item of the data type is omitted.

If the type of data S7 is, for example, a character set as a default setting, and it is determined that the type of data S7 is not specified by the operator, the default setting is retained. Becomes
When the cell area is designated by the mouse 3 as described above, the operator sets the cell data S6 as an item.
The data format S7, the display order U1, and the logical operation U2 can be specified from a menu, and a set value can be input to the specified item of the cell data S6. Whether or not the item of the cell data S6 is specified Is determined (step B3).

When each item of the cell data S6 is designated, the designated item of the cell data S6 is
Input setting values (data format, display order, logical operation)
Is set (step B4). In a state where the cell area is specified by the mouse 3, each item other than the data S7 of the cell data S6 is sequentially specified, and the set value can be sequentially input to each item.

In addition, default setting values are set in advance for items other than the data S7 of the cell data S6.
When the operator designates the item of the cell data S7 and does not input the set value, the default set value is set to each item of the cell data S6 as it is. Note that the default setting value of the display order U1 is the specified cell information S
3 is input when the first data S7 is input, and thereafter, every time data is input to the same cell information S3, an incremented (+1) value is input. The default setting value of the logical operation U2 is no logical operation.

In FIG. 4, the information input as the data format S8 is limited to the type and size of the font in order to simplify the description. Then, in the state where the cell area is specified by the mouse 3 as described above, when the operator performs input from the input unit 2 without specifying the type of the data S7 or specifying the item of the cell data S6,
This input value is used as data S7 stored in the cell data S6 and stored in the table data of the table data file 10 (step B5).

When the image data S7 is input, the image data is input from the image reader 9 and stored in the image file 5, and the image data stored in the image file 5 has arbitrary cell coordinates S4. By associating with the cell information S3, the image data is registered as the data S7 of the cell data S of the cell information S3. Even after the data input, if the operator specifies the type of the data S7 or the item of the cell data S6, the data S7
And the set value of each item of the cell data S6 can be changed. Then, after the data input, the process proceeds to the next step of the data input in the flowchart of FIG.

Then, in the table creation processing, after data is input in the data input processing, it is determined whether or not the operator has pressed the return key (step A3). When it is determined that the operator has pressed the return key, the process returns to step A2, and the above-described data input processing shown in the flowchart of FIG. 6 is performed again. That is,
A plurality of data S corresponding to one cell (cell information S3)
7 can be sequentially input. For example, in the cell information S3 of the cell coordinates 2-A shown in FIG. 4A, three times of data input processing is performed for one cell information S3. By doing so, three cell data (data S7
S6 is stored.

If it is not determined after the data input that the operator has pressed the return key, it is determined whether or not the operator has designated the next cell area on the screen with the mouse 3 (step A4). If the next cell area is specified, the process returns to step A1, and the above processing is performed on the cell information S3 corresponding to the newly specified cell area. Further, after the data input, in a state where it is not determined that the operator has pressed the return key and it is not determined that the operator has designated the next cell area, it is determined whether or not the operator has selected the end from the menu ( Step A5). Here, if it is determined that the end has been designated by the operator, the table creation processing ends.

That is, if the operator presses the return key after data input, data input processing is performed again on the cell information S3 in which data S7 has been input, and the operator specifies the next cell area. In this case, the data input processing is performed on the newly designated cell area, and when the operator selects the end, the table creation processing ends. If the operator does not press the return key, does not specify the next cell area, and does not select “end”, the apparatus enters a waiting state.

Next, the display processing will be described. First, when the data name of the table data to be displayed is designated by a predetermined operation of the input unit 2 or the mouse 3, the table data of the designated data name is searched from the table data file 10, and as shown in the flowchart of FIG. Then, the cell data S6 is obtained from the cell information S3 having the smaller value of the cell coordinate S4 in the searched table data (step C1).

Then, the cell data S6 in the cell
Is checked with reference to the contents of the data structure of the cell information S3 shown in FIG. 2 (step C2). If there is no cell data S6 in the cell information S3, the process ends. Basically, in the above table creation processing, the table data is stored in the table data file 1.
When the cell information S3 is stored in the cell information S3, the cell information S3 in which the value of the cell coordinate S4 is smaller than the cell information S3 having the largest value in the cell information S3 of the cell information S3 to which the data of the table data is input
3, the cell data S6 is set. When the cell data S6 is stored in the cell information S3 from which the cell data S6 is obtained,
The first cell data S6 of the cell information S3 is read (step C3).

Then, it is determined whether or not the next cell data S6 exists in the cell information S3 (step C4). If there is the next cell data S6, the next cell data S6 is read and the next cell data S6 is read. If there is no S6, the process proceeds to the next step. That is, if there is a plurality of cell data S6 in one cell information S3, all the cell data S6 in one cell information S3 are sequentially read. After reading all the cell data S6 of one cell information S3, the item of the display order U1 in the cell data S6 is determined (step C5), and the logical operation U2 calculation in the cell data S6 is performed. The item is determined (Step C6).

Then, the display order U1 of the above cell data is displayed.
Of the logical operation U2, the data format S8, the cell format S5, and the overall format S2, the data S7 to be displayed on the screen of the display unit 7 is edited, and the edited data S7 is displayed on the screen of the display unit. In the corresponding cell area of the table. At this time, as shown in FIG. 4A, for example, as shown in FIG. 4A, the cell information S3 includes "00001", "Tomoyuki Nihei", and " If three character data "Itoyuki" are stored, and the display order of these is 1, 2, and 3 and there is no logical operation, the processing is performed as follows. First, when these data are displayed in one cell area, since there is no logical operation, no data synthesis or data selection is performed, and three data are displayed in one cell area and three data are displayed. Two data are displayed in the display order, for example, up and down.

That is, the display shown in the cell area of the cell coordinates 2-A in the table of FIG. 3 is displayed, and three character data are displayed up and down in one cell area. The length of the table can be reduced as compared with the case where the cells are displayed side by side in each cell area. If each cell data S6 of the cell information S3 is as shown in FIG. 4B, the image data (here, the portrait shown in the table of FIG. 3) is used as the data S7 of one cell information S3. ) And character data "Tomoyuki Nihei" are stored, their display order U1 is set to 1 and the logical operation U2 is set to "OR", so that these data are combined at the same position. Will be displayed.

That is, the display is at the cell coordinates 2-D in the table of FIG. 3, and the portrait image data and the character data are combined in a superimposed state and displayed in one cell area. In FIG. 3, the character data is superimposed on the lower part of the image data. For example, as the layout data at the time of combining, it is possible to align the bottom, the top, the center, the right, the left, and the center. It may be instructed.
Then, after the display processing of one cell is performed as described above, the process returns to the first step, and the display processing of the next cell information S3 is performed. Then, the above processing is repeated until there is no cell information S3 having the cell data S6.

By the above processing, a table in which a plurality of data S7 are displayed in one cell area can be output. Further, when displaying a plurality of data S7 in one cell area, the data S7 can be displayed side by side according to the display order U1 of each data S7 registered in one cell information S3. When the logical operation U2 is set in the cell data S6, for example, image data and character data or image data can be combined and displayed in a superimposed state, and selected from a plurality of data S7. It is possible to display only one of the data S7. Then, as described above, the display unit 7
Can be printed out from the printing unit 8.

Next, as described above, a plurality of data S7 are stored in one cell information S3, and at the time of display processing, a plurality of data S7 stored in one cell information S3 are calculated by a logical operation U2. In the case where only one data S7 is displayed and the other data S7 is hidden, the cell selection processing for displaying the hidden data in the selected cell area is described in the table of FIG. This will be described with reference to the flowchart of FIG. First, in the table displayed on the screen of the display unit 7 by the above-described display processing, for example,
The operator designates one cell area of the table with the mouse 3. At this time, the CPU 6 determines whether there is any hidden data in the designated cell area (step D1).

That is, it is determined whether "AND" is stored in the item of the logical operation U2 of the cell data S6 of the cell information S3 having the cell coordinates S4 corresponding to the designated cell area. Then, the logical operation U2 of the cell data S6
If “AND” is not stored in the item “”, the process ends. If “AND” is stored,
The data S7 is read from the cell data S6 in which the item of the display order U1 among the cell data S6 of the designated cell information S3 is 2 or later (step D2).

Next, the hidden data S7 read as described above is displayed as a sub-window W on the screen of the display unit 7, for example, as shown in FIG. 8 (step D).
3). Here, the operator can see all the data S7 hidden in the designated cell area by the display on the sub-window W. The operator selects necessary data S7 among the data S7 on the sub-window W with the mouse 3 or the like, and then selects an arbitrary cell area of the table with the mouse 3 or the like, thereby selecting the selected data S7.
Can be pasted to the selected cell area. Furthermore, the sub-window W can be closed by the operator clicking the close button c of the sub-window w with the mouse 3.

Then, the CPU 6 determines whether or not the data S7 on the sub-window W has been designated (step D4), and in a state where the data S7 on the sub-window W has not been designated by the operator, the operator closes the close button c. Is determined (step D5). When it is determined that the close button c has been clicked by the operator,
The sub-window w is closed, and the process ends.

On the other hand, when it is determined that the data S7 has been designated, the designated data S7 is pasted on the cell area designated by the operator and the table is displayed again (step D).
6) End the cell selection process. When the data S7 specified by the operator is pasted on the specified cell area, the specified data S7 may be stored in the cell information S3 corresponding to the specified cell area,
The data S7 may be simply pasted only on the display screen.

For example, according to the above processing, the image data I of the portrait shown in FIG. 8 and the character data T indicating the main address book of the portrait are registered in one cell, and the logical operation of each data S7 is performed. Are registered as the display order U1 of the image data I, and 2 are registered as the display order U1 of the character data T. When the table having the data S7 is displayed, only the image data I is displayed, and the character data T is hidden.

Here, when the operator designates the cell area in which the image data I is displayed by the mouse 3, the sub-window W is displayed and the character data T hidden on the sub-window W is displayed. Will be. Therefore, the hidden data S7 can be easily confirmed. Here, if the operator presses the close button C of the sub-window W, the sub-window W disappears from the screen. When the operator designates character data T on the sub-window W and then designates an arbitrary cell area on the table, the character data I is pasted on an arbitrary cell area, and Since the character data T is displayed, the hidden data S7 can be easily pasted on the table and used.

That is, according to the above-described processing, a plurality of data S7 are registered in one cell information S3, and only a part of the data S7 registered by the display processing is displayed. When the hidden data S7 is hidden, the hidden data S7 can be easily displayed and confirmed, and the hidden data S7 can be easily pasted to an arbitrary cell area of the table. Can be easily used. As described above, according to the table processing apparatus of this example, it is possible to register a plurality of data S7 in each cell information S3 of the table, and to output a plurality of data to each cell region of the table when outputting the table. Since S7 can be displayed, the number of cells can be reduced with respect to the number of data registered in the table, and the size of the table can be reduced.

For example, in a table, there are a large number of data arranged side by side, and when each data is stored in one cell, the number of cells arranged in a row increases. In the case where the size is exceeded, by registering a plurality of data in one cell, the horizontal size of the table can be compressed so that it fits in the paper size. Further, when a plurality of data are registered in one cell, it is possible to hide data that does not necessarily need to be displayed by the items of the logical operation.

Further, a plurality of image data displayed in one cell or a combination of image data and character data can be displayed by the above logical operation. Also,
When there is data hidden by the above logical operation, by specifying a cell having hidden data on the display screen, the hidden data can be displayed and confirmed. Further, since the hidden data can be arbitrarily assigned to the cell and displayed, the hidden data can be easily used for creating / editing a table.

[0066]

According to the table processing apparatus according to the first aspect of the present invention, the number of cells in a table can be reduced by allocating a plurality of data to one cell, so that the size of the table can be reduced. It can be. Therefore,
Conventionally, a table with a large number of data can be printed on a limited amount of paper without performing the editing process that was conventionally performed to fit a table with a large amount of data on a limited amount of paper. Can be made more efficient.

According to the table processing apparatus of the present invention, not all data corresponding to the cell is displayed in one cell of the table, but only the data selected based on the selection information. Can be displayed, so that display or non-display in a table can be selected for each data even when a plurality of data are stored in one cell.

According to the table processing apparatus of the present invention, when displaying a plurality of image data or image data and character data in one cell area, a plurality of image data or image data and character data are displayed. Can be combined and displayed in a superimposed state. Therefore, a display combining a plurality of image data and a display combining image data and character data can be performed. In addition, when the display area of the image data is relatively large, when a plurality of image data or character data and image data are displayed so as not to overlap each other in one cell area, a large area is required as the cell area. However, the size of the cell region can be reduced by displaying these data in a single cell region in a state where they are superimposed on each other. Therefore, the size of the table can be reduced.

According to the table processing apparatus of the fourth aspect of the present invention, the data not displayed in the cell area by the configuration of the second aspect can be stored in the cell area by designating the cell area on a display screen, for example. The selection information stored in the means can be easily viewed without rewriting. Therefore, all data stored in the storage means can be easily confirmed on the display screen.

According to the table processing device of the fifth aspect of the present invention, when displaying a plurality of data in one cell area,
Since the arrangement can be performed based on the arrangement information stored in advance, for example, a plurality of data are arranged vertically in one cell, and the arrangement order of each data is determined in advance. be able to.

According to the storage medium of the sixth aspect of the present invention, in a computer system that executes a program stored in the storage medium, when processing table data composed of a plurality of cells, one cell is stored in one cell. By allocating a plurality of data, the number of cells in the table can be reduced, so that the size of the table can be made compact.

[Brief description of the drawings]

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

FIG. 2 is a diagram showing a data structure of table data stored in a table data file of the computer system.

FIG. 3 is a diagram showing an example of a table output result by the computer system.

FIG. 4 is a diagram showing an example of cell information of table data used in the computer system.

FIG. 5 is a flowchart of a table creation process executed by the computer system.

FIG. 6 is a flowchart of a data input process executed by the computer system.

FIG. 7 is a flowchart of a display process executed by the computer system.

FIG. 8 is a diagram showing a display example of a table by the computer system.

FIG. 9 is a flowchart of a cell selection process executed by the computer system.

[Explanation of symbols]

 Reference Signs List 1 computer system 2 input unit 3 mouse 4 processing work memory 5 image file 6 CPU 7 display unit 8 printing unit 9 image reader 10 table data file 11 storage device 12 storage medium S3 cell information S6 cell data S7 data

 ────────────────────────────────────────────────── ─── Continued on the front page (72) Inventor Makoto Tokiwa 3-2-1, Sakaemachi, Hamura-shi, Tokyo Casio Computer Co., Ltd. Hamura Technical Center

Claims (6)

[Claims] 1. A table processing apparatus for processing table data composed of a plurality of cells, wherein data is stored corresponding to each cell of the table data, and a plurality of data is stored corresponding to each cell. Reading means for reading out the data corresponding to each cell stored in the storage means for each cell, and reading out the plurality of data from the cell in which a plurality of data are stored correspondingly. Means, comprising a plurality of cell areas respectively corresponding to the plurality of cells, and outputting a table displaying data read out for each cell by the reading means in each of the cell areas; Output means for displaying the plurality of data in one cell area corresponding to the cell from which the data has been read. 2. The storage means displays all of a plurality of data stored corresponding to one cell in a cell area corresponding to the cell, or selects a part of data from the plurality of data. The selection information for determining whether to display in the cell area, the reading means reads the selection information from the storage means together with the data stored corresponding to each cell, and the output means Selecting all or a part of data corresponding to one cell for each of the cells based on the selection information read by the reading unit, and selecting the selected data for each of the cells. 2. The table processing device according to claim 1, wherein the information is displayed in each cell area. 3. The storage means is capable of storing image data corresponding to a cell, and the output means is configured to convert a plurality of image data or image data and character data into one based on the selection information. 3. The table processing according to claim 2, wherein when outputting to the cell area, the plurality of image data or the image data and the character data are combined in a superimposed state, and the data combined in the cell area is displayed. apparatus. 4. An instructing means for instructing an arbitrary cell area of a displayed table; and an instructing means for instructing an arbitrary cell area of the table, whereby the designated cell area is selected by the output means. 4. The table processing apparatus according to claim 2, further comprising output control means for displaying the data which has not been displayed when there is data which has not been displayed. 5. When displaying a plurality of data in the cell area of the cell, the storage means stores arrangement information indicating an arrangement of each data in one cell area, and the reading means stores the information in each cell. The arrangement information is read from the storage means together with the data stored correspondingly, and the output means displays the plurality of data in one cell area based on the arrangement information read by the reading means. 5. The table processing apparatus according to claim 1, wherein an arrangement of the plurality of data in the cell area is determined, and the plurality of data are displayed in the cell area. 6. In a storage medium storing a computer-executable program, in order to process table data composed of a plurality of cells,
A computer capable of storing data corresponding to each cell of table data and storing a plurality of data corresponding to one cell for each cell when storing data for each cell. The program code and the data stored corresponding to each cell are read out for each cell, and when the data corresponding to each cell is read, the plurality of data are read from the cell where the plurality of data are stored correspondingly. A computer-readable program code for reading a plurality of cells, and a table including a plurality of cell areas respectively corresponding to the plurality of cells, and displaying data read out for each cell in each of the cell areas is output At the same time, when displaying the data read for each cell in the corresponding cell area, a plurality of data are read. Storage medium, characterized in that the cell area corresponding to the issued cell computer to display a plurality of data stores a program comprising a program code readable.