JPH1040314A - Display device for spread sheet - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve an operability and maintenance. SOLUTION: A unit chart synthesizing part 12 is newly added to unit chart holding means 10 and 11, and a display part 13 provided at the display device of a spread sheet. The unit chart holding means 10 and 11 hold the chart data of the spared sheet of a unit chart and display information for displaying the data. Also, the unit chart synthesizing part 12 holds data obtained by alternately synthesizing the data from the unit chart holding parts 10 and 11 by each line. Therefore, the data can be synthesized by each column, and the arbitrary number of spread sheets of the unit chart holding parts can be synthesized. Also, the display part 13 displays the display image of the spread sheets synthesized by the unit chart synthesizing part 12 on a screen or the like. Thus, the mutual charts can be easily compared and changed by expressing them in the plural spread sheets by using the unit chart synthesizing part 12.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a display device for a plurality of spreadsheets, and more particularly to a display device for a spreadsheet which combines a plurality of spreadsheets into one spreadsheet and displays it on a screen.

[0002]

2. Description of the Related Art Conventionally, there is a spreadsheet display device of this type as shown in FIG. In general, according to the data of each spreadsheet (table), the data is displayed in an independent spreadsheet. In this case, the A table indicated by 60 in FIG.
0 is displayed based on the spreadsheet table data and 60 column width and row height information as display information. Table B indicated by reference numeral 61 in FIG. 7 is a separate spreadsheet completely independent of 60, and has table data of spreadsheet 61 and 6
The display is performed with reference to the column width and row height information as the display information of No. 1.

[0003] As another conventional example, there is a method of displaying as a separate table in another area of one spread as in a display example of 62 in FIG. In this case, the data to be displayed at 62 has position information indicating whether to display the tables 60 and 61.
Display Table and Table B.

[0004]

However, in the conventional spreadsheet display device, when comparing a plurality of tables, it was necessary to compare the cell contents at a plurality of distant positions. That is, in such a display device, when comparing row A-1 and column A-1 of table A with row B-1 and column B-1 of table B, table A and table B become independent. Therefore, it is necessary to search for each position and compare the contents of the cell, and there is a problem that lack of quickness occurs.

In the conventional display device, when editing between a plurality of tables, it is necessary to change the contents of a plurality of distant positions. This is because when trying to change row A-1, column A-1 of table A and row B-1, column B-1 of table B, table A and table B are independent, Has to be changed to find the position of the cell, and the processing becomes complicated.

An object of the present invention is to facilitate comparison between a plurality of tables and improve operability.

[0007] Another object of the present invention is to facilitate change over a plurality of tables and improve maintainability.

[0008]

As a means for solving the above problems, a spreadsheet display device of the present invention is newly added to a single table holding means and a display means of a conventional spreadsheet display device. It is configured by adding a table combining means. The single table holding unit holds table data of a single table spreadsheet and display information for displaying the data. The single-table synthesizing unit holds data obtained by alternately synthesizing the data from the single-table holding unit for each row.
Therefore, it is also possible to alternately combine the data for each column in the same manner as described above. Also, an arbitrary number of spreadsheets of the single table holding means can be synthesized.

The display means can display a display image of the spreadsheet synthesized by the single-table synthesizing means on a screen or the like.

Therefore, the spreadsheet display device of the present invention can be expressed in a plurality of spreadsheets by using the single-table synthesizing means, so that comparison and change between tables can be easily performed. .

[0011]

DESCRIPTION OF THE PREFERRED EMBODIMENTS A spreadsheet display device according to an embodiment of the present invention will be described in detail with reference to the drawings.
FIG. 1 is an explanatory diagram showing the configuration of a spreadsheet display device according to one embodiment of the present invention.

The apparatus shown in FIG.
1, a display unit 13 and a single-table synthesizing unit 12.
The single table holding unit 10 stores a single table in a matrix of rows A-1, A-2, and A-3 and columns A-1, A-2, and A-3 of the A table. Further, the single table holding unit 11 stores the rows B-1, B-2, and B-3 of the table B.
And a matrix of columns B-1, B-2, and B-3.
The single-table combining unit 12 holds data obtained by alternately combining display data from the single-table holding units 10 and 11 for each row.
That is, the single-table combining unit 12 can combine the table A of the single-table holding unit 10 and the table B of the single-table holding unit 11 to create the A + B table. The single-table combining unit 1 described above may be configured to combine display data alternately for each column. Further, the single-table synthesizing unit 12 may synthesize a spreadsheet of an arbitrary number of single-table holding units (not shown).

The display unit 13 displays a combined display image of the spreadsheet combined by the single-table combining unit 12 on a screen. Thereby, for example, comparison or change between a plurality of tables can be easily performed from the display image synthesized by the single-table synthesis unit 12 while watching the screen.

By using the single-table synthesizing unit 12 of the present embodiment, a plurality of spreadsheets can be expressed in one spreadsheet, so that comparison and change between tables can be performed easily. Thus, in the apparatus of the present embodiment, comparison between a plurality of tables can be facilitated, and operability can be improved. Further, in the apparatus of the present embodiment, the change over a plurality of tables can be easily performed, so that the maintainability of the apparatus can be improved.

Next, a specific example of the spreadsheet display device according to the embodiment of the present invention will be described in detail with reference to FIGS.

In the specific example shown in FIG. 2, the apparatus is configured using a plurality of single-table holding units. In this device, a display device using a conventional display method shown in FIG. 7 can be used to hold table data of a single-table spreadsheet and display information for displaying the data. The single table holding units 20 and 21 include a table data storage unit 23 and a display information storage unit 24.
Table data 100 of a single-table spreadsheet and display information 101 for displaying the data.

The single-table synthesizing section 22 includes a plurality of single-table holding sections 2.
In order to create data that can be displayed by synthesizing data from 0 and 21, each table data is read from the single table holding units 20 and 21 in units of rows or columns, and the read table data 100 is sequentially read. The display information is read out in units of one row or one column from the combined table data storage unit 26 and the single table holding units 20 and 21 which are stored side by side, and the combined display information of the combined table is read by the read display information 101. Is composed of a combined display information creation unit 25 and a combined display information storage unit 27 for creating the. The display unit 13 can use a conventional display unit. The display unit 13 creates a display image from the spreadsheet table data and display information synthesized by the single-table synthesis unit 22, and displays the display image on the screen by the display unit 13.

A plurality of single table holders 20, 21 shown in FIG.
Is a table shown in FIG.
And hold it. The single-table synthesizing unit 22 first reads out the table data of the plurality of single-table holding units every eleven rows to create the composite table data 120. Next, a plurality of single table holding units 2
According to 0 and 21, the display data is read out for each row, and the combined display information creation unit 25 creates the combined display information of the combination table.

The display unit 13 can display a spreadsheet based on the table data and display information created in the single-table synthesizing unit 22, so that the operator can compare and change tables with each other while looking at the screen. Can be easier.
The single-table combining unit 22 described above processes the table data 100 and the display information 101 for each row, but the single-table combining unit 22 processes the table data and the display information for each column. May be used.

In the case of the example shown in FIG.
31, two table storage units 31 are used, and the table unit 100A of the table A and the single table storage unit 3 are stored in the respective storage units of the single table storage unit 30.
1 holds the table data 100B of the table B. Single table holder 3
0 holds the table data of the A table and the display information for displaying the data, and the single table holding unit 31 holds the table data of the B table and the display information for displaying the data.

The single-table synthesizing unit 32 includes two single-table holding units 3
In order to combine and display the data from 0 and 31, each table data is read from the single table holding unit in a unit of one row or one column, and the read table data is arranged in order and stored.
An A + B display information creation unit 35 for reading each display information from the storage unit for B table data and the single table holding unit in units of rows or columns and creating display information of a table synthesized from the read display information; It is composed of an A + B display information storage unit. The display unit 13 can create a display image from the A + B table data and the A + B display information of the spreadsheet synthesized by the single-table synthesizing unit 32 and display the display image on a screen or the like.

The single table holding units 30 and 31 of the apparatus shown in FIG. 3 divide the table A and the table B into table data and display information and hold them.
The single-table synthesizing unit 32 first reads out one row of the A-table data in the single-table holding unit 30 and stores it in the A + B table data. Next, one row of the B table data in the single table holding unit 31 is read, and A + B table data is additionally stored. By repeating the above operation until there is no more table data, the A table data 14 shown in FIG.
A + B table data can be created from 0 and B table data 141.

Next, an example of reading column width data of display information from the single table holding units 30 and 31 shown in FIG. 3 will be described with reference to FIG. The column width data of the display information from the single table holding units 30 and 31 is read out, and the A + B display information creating unit 35 stores the large column widths 150 and 151 of the A and B tables as the column width information 153 of A + B. .

On the other hand, the line height information is stored in the A + B display information creating unit 3.
By extracting the display information of the A table and the display information of the B table of the single table holding units 30 and 31 alternately from FIG. 5, each information of the A table and the B table can be extracted. In the above-described embodiments, the table A and the table B are arranged for each row. However, the display information can be extracted by similarly arranging the table A and the table B for each column.

Next, the operation of the embodiment shown in FIG. 6 will be described with reference to the flowchart. In describing this operation, FIGS. 4 and 5 will be referred to.

In FIG. 6, step 100 (hereinafter referred to as S
Table data A and B shown in FIG.
The row pointer of the table data 141 is set to 1. next,
In S102, one line is read (read) from the A table data 140 and added to the A + B table data 142. Also, one row is read from the B table data 141, and the A + B table data 142 is read.
Add to In step S104, it is determined whether the added data is in the last line. When the additional data is in the last row (YES in S104), the process proceeds to S106, and the row pointers of the display information 143 of Table A and the display information 144 of Table B shown in FIG. Note that S104
In S107, if the corresponding row is not the last row in S107 (NO in S104), the process proceeds to S108, the row pointer is incremented by 1, and the process returns to S102 again.

Next, in S110 following S106, the column width is read from the display information 143 of Table A shown in FIG. 5, and the column width is read from the display information of Table B. next,
In S112, the column widths of the display information 143 of the table A and the display information 144 of the table B are compared, and the larger column width is saved as the display information of the table A + B. Next, proceeding to S114,
The row height pointer of the table data 140 and the B table data 141 is set to 1
Set to.

The process further proceeds to S116, where the A table data 140
The row height is read by one row, and the row height is added to the display information 145 of the A + B table. The row height is read by one row from the B table data 141, and the row height is added to the display information 145 of the A + B table. Next, the process proceeds to S118, and it is determined whether or not the information on the added line height is in the last line. If the added row is the last row (YES in S118), the above processing is terminated, and the added row is not the last row (NO in S104).
In the case of, the process proceeds to S120, where the row height pointer is incremented by 1 and S
Return to 116 again.

With the above processing, the display unit 13 can display the spreadsheet based on the A + B table data and the A + B display information created by the single table combining unit 35 in FIG. Can speed up comparisons and changes between tables.

[0030]

As described above, according to the spreadsheet display device of the present invention, since information of a plurality of tables is located in adjacent cells, when the information is synthesized in units of one row, the spreadsheet information is displayed one at a time. When the cells are combined on a column-by-column basis, by comparing adjacent cells on the left and right, comparison between a plurality of tables can be easily performed.

Further, according to the present invention, since information of a plurality of tables is located in adjacent cells, the vertical direction is obtained when the information is combined in one row, and the horizontal direction is obtained when the information is combined in one column. Can be changed between adjacent cells, so that it is easy to change between a plurality of tables.

[Brief description of the drawings]

FIG. 1 is an explanatory diagram showing a configuration of a spreadsheet display device according to an embodiment of the present invention.

FIG. 2 is an explanatory diagram showing a specific example of the display device shown in FIG.

FIG. 3 is an explanatory diagram showing a specific example of the display device shown in FIG. 1;

FIG. 4 is an explanatory diagram showing a specific example of the display device shown in FIG. 1;

FIG. 5 is an explanatory diagram showing a specific example of the display device shown in FIG. 1;

FIG. 6 is an explanatory diagram showing a specific example of the display device shown in FIGS. 5 and 6;

FIG. 7 is an explanatory diagram showing a specific example of a conventional spreadsheet display device.

[Explanation of symbols]

 Reference Signs List 10 single table holding unit 11 single table holding unit 12 single table combining unit 13 display unit 20 single table holding unit 22 single table combining unit 23 table data storage unit 24 display information storage unit 25 combined display information creation unit 26 combined table data storage unit 27 Combined display information storage unit 30 Single table holding unit 31 Single table holding unit 32 Single table combining unit 35 A + B table display information creating unit

Claims (4)

[Claims] 1. First and second table data storage means for storing table data and display information for displaying the table data, and table data read from the first and second table data storage means. And a combination table data storage unit for storing the combination data, and a display unit for displaying a display image of the spreadsheet on a screen based on the combination data stored in the combination table data storage unit. Spreadsheet display device. 2. The table data storage means comprises: first storage means for storing table data consisting of rows and columns; and second storage means for storing data for displaying the table data. The spreadsheet display device according to claim 1, wherein: 3. A composite table data storage means for inputting the table data from a plurality of the table data storage means and storing the table data as composite table data, and reading from the composite table data storage means. 2. The apparatus according to claim 1, further comprising: a creating unit that creates combined display information based on the tabulated data; and a combined display information storage unit that stores the combined display information created by the creating unit. 3. Spreadsheet display device. 4. The spreadsheet display device according to claim 1, wherein said table data storage means stores column width information and row height information of said display information.