JPH08147127A - Method and device for displaying spread sheet - Google Patents

Abstract

PURPOSE: To facilitate handling by setting a minimum cell having minimum cell width and height in a spread sheet and combining minimum cells to set classification cells and combining classification cells to constitute and display the spread sheet. CONSTITUTION: The cell width and the cell height of the minimum cell are set by a minimum cell setting means 11. Classification cells which define the sizes of cells actually used in the spread sheet are set by a classification cell setting means 12. The user sets how many times the cell width and the cell height of each classification are as large as those of the minimum cell, and simultaneously, the classification cell setting means 12 gives a peculiar classification cell number to each classification cell. A spread sheet constituting means 1 sets the number of rows and the number of columns of the spread sheet by user's operation on the assumption that the spread sheet consists of only minimum cells. Next, the constituting means 13 gives minimum cell discrimination numbers to minimum cells from the upper left to the lower right to generate general cells.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a spreadsheet display method and apparatus for displaying a spreadsheet composed of a plurality of cells.

[0002]

2. Description of the Related Art A conventional spreadsheet display device is shown in FIG.
~ It demonstrates using FIG. FIG. 8 is a block diagram showing an example of the configuration of the spreadsheet display device. Figure 9
FIG. 6 is an explanatory diagram showing a spreadsheet in which the cell width and cell height of all cells are constant. FIG. 10 is an explanatory diagram showing a spreadsheet in which the cell width is changed in column units or the cell height is changed in row units. FIG.
It is explanatory drawing showing the spreadsheet at the time of freely setting the cell width and cell height in a cell unit. 12 and 13 are explanatory views for explaining a method of displaying the spreadsheet shown in FIG. 11 on the conventional spreadsheet display device.

In FIG. 8, 1 is a matrix setting means, 2 is a cell width cell height setting means, and 3 is a display means. A cell is a column in a spreadsheet, and character information or a numerical value is shown in the column, or a user writes character information or a numerical value.

The matrix setting means 1 sets the number of vertical rows and the number of horizontal columns of the spreadsheet.

The cell width cell height setting means 2 is used by the user to set the cell width and the cell height. The cell width can be set for each column in the spreadsheet and the cell height can be set for each row in the spreadsheet.

The display means 3 displays a spreadsheet composed of the matrix setting means 1 and the cell width cell height setting means 2.

Next, a method for a user to create and display a spreadsheet in the spreadsheet display device configured as described above will be described.

First, as shown in FIG. 10, the matrix setting means 1
By setting the number of vertical rows and the number of horizontal columns, a grid-like spreadsheet 4a as shown in FIG. 9 is created. The grid-like spreadsheet is a spreadsheet having the same cell width in the same column and the same cell height in the same row.

Next, using the cell width cell height setting means 2,
The cell width 5 of each column and the cell height 6 of each row are set. Then, the display means 3 displays the spreadsheet 4b in which the number of rows and columns and the cell width and the cell height are set.

With the above, the creation of the spreadsheet itself is completed, and thereafter, the macro function for performing the desired processing and the data necessary for the processing are written in each cell according to the application of the spreadsheet to operate the spreadsheet. Performed and applied to business processing and statistical processing.

[0011]

However, in the spreadsheet display device as shown in FIG. 8 described above, the grid-like spreadsheet 4b as shown in FIG.
Can only be created and displayed.

In the spreadsheet 4c shown in FIG. 11, the cell width 7 of the cell C1 is different from the other cell width 5 of the same column, and the cell height 8 of the cell C2 is different from the other cell heights of the same row. Therefore, the concept of a matrix cannot be established in the spreadsheet 4c, and the spreadsheet 4c cannot be created and displayed by the spreadsheet display device described in the related art.

Conventionally, therefore, when displaying a spreadsheet such as the spreadsheet 4c in which the cell width in the same column and the cell height in the same row are not constant, first, the cell width in the same column as shown in FIG. A grid-like spreadsheet 4d having a constant cell height within the same row is created, and the ruled lines L1 and L2 are erased so that the adjacent cells are like one cell. A spreadsheet 4e equivalent to the spreadsheet 4c shown was created (FIG. 13).

However, even if the cells are apparently combined and displayed by, for example, deleting the ruled lines between a plurality of adjacent cells, since the cells are substantially a plurality of cells, the attributes of the cells are changed. When doing so, it is necessary to modify the attributes of all of the plurality of cells, the user must always understand the relationship between the cells that have been apparently combined, and even when moving the cursor in the spreadsheet Since it does not move along the cell but moves along the actual cell, the movement of the keystroke and the cursor do not match, impairing the operation feeling, and it is also difficult to create the spreadsheet when the table structure of the spreadsheet becomes complicated There was a problem that became.

The present invention has been made to solve the above problems, and an object of the present invention is to set a free cell width and cell height independently for each cell constituting a spreadsheet. Even if you set a free cell width and cell height for each cell, the keystroke and cursor movement match, and you can change the attribute only once for a general cell, which is easy to handle. It is to provide a spreadsheet display method and apparatus.

[0016]

In order to solve the above problems, the present invention provides a spreadsheet display method for displaying a spreadsheet composed of a plurality of cells. Setting a minimum cell having the minimum cell width and cell height in the spreadsheet, setting the type cells by combining the minimum cells, and configuring the spreadsheet by combining the type cells to display the spreadsheet Is a method characterized by.

Further, in the invention according to claim 2, in a spreadsheet display device having a display means for displaying a spreadsheet composed of a plurality of cells, a cell width and a cell height in the spreadsheet are minimum. A minimum cell setting means for setting a minimum cell, a type cell setting means for setting a type cell by combining the minimum cells, and a spreadsheet configuring means for configuring a spreadsheet by combining the type cells. Characterizing

[0018]

With the above configuration, in the invention according to claim 1, the cell width and cell height of the minimum cell in the spreadsheet are set, and the type cells are set by combining the minimum cells. However, since the type cells are combined to form a spreadsheet, it is possible to freely set the cell width and the cell height of each cell in the spreadsheet, and the spreadsheet including the cells in which the cell width and cell height are freely set. Can be displayed.

According to the second aspect of the invention, the minimum cell setting means sets the cell width and cell height of the minimum cell in the spreadsheet, and the type cell setting means combines the minimum cells to classify. Since a cell is set and a spreadsheet is configured by combining the above-mentioned type cells by the spreadsheet configuration means, the cell width and cell height of each cell in the spreadsheet can be freely set, and the cell width and cell height can be freely set. A spreadsheet containing the populated cells can be displayed.

[0020]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described with reference to FIGS. FIG. 1 is a block diagram showing the configuration of a spreadsheet display device. FIG. 2 is an explanatory diagram showing an example of the cell width and cell height of the type cell. FIG. 3 is an explanatory diagram illustrating that the type cell is configured by combining the minimum cells. FIG. 4 is an explanatory diagram showing a spreadsheet in the case where all are composed of the minimum cells. FIG. 5 is an explanatory diagram for explaining assigning the minimum cell identification number to all the minimum cells of the spreadsheet constituted by the minimum cells. Figure 6
FIG. 6 is an explanatory diagram for explaining that a type cell is arranged in a spreadsheet composed of minimum cells. FIG. 7 is an explanatory diagram showing the spreadsheet that has been created.

In this embodiment, three types of cells, that is, a minimum cell, a type cell, and a general cell are used. Therefore, the general cell, the type cell, and the minimum cell will be described first.

The general cell is a cell to be operated when the user operates the spreadsheet, and corresponds to the cell described in the prior art. Therefore, it is the general cell that the user can see when the spreadsheet is displayed, the character information and the numerical value are displayed in the general cell, and the user writes the character and the numerical value in the general cell.

The type cell is a cell that defines the cell width and cell height of a general cell that is actually used in the spreadsheet. Since a general cell can be classified into a plurality of types depending on the size of the cell, a type cell indicating the cell width, which is the cell size, is required for each classification.

The minimum cell is the largest cell among cells having a cell width and a cell height capable of dividing all type cells used in the spreadsheet by integer values. Therefore,
By multiplying the cell width of the minimum cell and the cell height by an integer, the size of each type of cell can be obtained.

In FIG. 1, 11 is a minimum cell setting means,
Reference numeral 12 is a type cell setting means, 13 is a spreadsheet construction means, and 3 is a display means.

The minimum cell setting means 11 is for setting the cell width and cell height of the minimum cell by the operation of the user.

The type cell setting means 12 sets the size of the type cell which is the type of the general cell actually used in the spreadsheet by the user's operation, and the cell width and cell height of the type cell. And are set by integer multiples of the smallest cell.

The spreadsheet forming means 13 sets the number of rows in the vertical direction and the number of columns in the horizontal direction of the spreadsheet when the spreadsheet is composed of only the minimum cells by the user's operation. The spreadsheet is constructed by arranging the type cells without any gaps in the spreadsheet.

The display means 3 displays the spreadsheet constructed by the spreadsheet construction means 13.

Next, a method for the user to create and display a spreadsheet in the spreadsheet display device configured as described above will be described.

First, the minimum cell setting means 11 sets the cell width and cell height of the minimum cell. The cell width and the cell height of the minimum cell are the largest among the cell width cell heights in which all the type cells can be divided by integer values as described above. Specifically, as shown in FIG. 2A, FIG. 2B, and FIG. 2C, the size of 1 × 4 (characters), 2 × 2 (characters), and 2 × 4 (characters) When the type cells C3, C4, and C5 are used in a spreadsheet, they are cells of a size commonly included in various types of cells, and if the common cell is multiplied by an integer, 1 × 4 (characters) A cell from which a 2 × 2 (character) or 2 × 4 (character) cell is obtained is the 1 × 2 (character) cell shown in FIG. 2 (d). The cell corresponds to the smallest cell.

Next, the type cell setting means 12 sets a type cell that defines the size of the cell actually used in the spreadsheet. The user sets, for each type cell, how many times the cell width of the smallest cell is the cell height,
At the same time, the type cell setting means 12 gives a unique type cell number to each type cell. Set the number of type cells as many as the number of types of general cell sizes used in the spreadsheet.

When the type cells shown in FIGS. 3 (a), 3 (b) and 3 (c) are used in a spreadsheet, the user has 1 × for the type cell C6 shown in FIG. 3 (a). 2 times (indicating that the minimum cell is vertically 1 times and horizontally 2 times) is set, and 2 × is set in the type cell C7 shown in FIG. 3B.
3 times is set in the type cell C8 shown in FIG. 3C, and the type cell setting means 12 sets the type cell number “1” in the type cell C6 and the type cell number “in the type cell C7. 2 ",
The type cell number “3” is given to the type cell C8.

Then, the spreadsheet constructing means 13 sets the number of rows in the vertical direction and the number of columns in the horizontal direction of the spreadsheet by a user operation when all the cells in the spreadsheet are the minimum cells. The spreadsheet is grid-like because it consists of only the smallest cells. As an example, FIG. 4 shows a spreadsheet 1 with 7 rows and 6 columns.
5a is shown.

Next, as shown in FIG. 5, the spread sheet forming means 13 gives a minimum cell identification number, which is a unique serial number, from the upper left to the lower right of each minimum cell in the spreadsheet 15b.

After each minimum cell identification number has been assigned, the user places a type cell in the spreadsheet.

When the type cell is arranged in the spreadsheet, a general cell is generated, and the general cell is the general cell number which is the serial number of the general cell, the type cell number of the type cell, the position in the spreadsheet where the type cell is arranged, It has, as general cell information, the minimum cell identification number of the minimum cell included in the position where the type cell is arranged.

For example, when the type cell C7 is arranged at the upper left of the spreadsheet, the cell information of the general cell generated by arranging the type cell C7 is "general cell number" because the general cell number is the first general cell generated. 1 ”is given,
The type cell number is “2” given by the type cell setting means 12.
Is. In addition, the coordinates of the smallest cell of {(1,1), (1,2)} are given as the position of the type cell in the spreadsheet, and the smallest of the smallest cells included in the position where the type cell is arranged. The cell identification numbers "1" and "7" are given as cell information.

After arranging the type cell C7 at the upper left of the spreadsheet and then arranging the type cells C6, C6 and C7 on the left adjacent thereto in order, the type cells are arranged as in the spreadsheet 15c shown in FIG.

As shown in FIG. 7, the spreadsheet 15
The configuration of the spreadsheet is completed by arranging the type cells in d without any gap or overlapping, and the spreadsheet is displayed by the display means 3.

Since the spreadsheet is created as described above, the general cell and the minimum cell are linked through the minimum cell identification number, and the relationship between the general cells can be grasped through the minimum cell identification number. it can. Therefore, when there is a cursor on a certain general cell and the cursor is moved to the right general cell, from the smallest cell identification number of the smallest cell located at the rightmost end among the smallest cells linked to the ordinary cell at the current cursor position, By knowing the smallest cell identification number of the smallest cell adjacent to the right side of the smallest cell, and searching the ordinary cell linked to the smallest cell identification number of the smallest cell adjacent to the right side, the right side of the ordinary cell at the current cursor position Since the general cell can be known, when the cursor movement key is pressed once, the cursor moves to the right general cell. That is, the keystroke and the movement of the cursor match, and the operation of moving the cursor can be performed without impairing the feeling of operation.

When the user changes the cell attributes such as the character color and the font to the general cell, the cell attributes of all the minimum cells linked to the general cell that the user has instructed to change are changed at once. Therefore, even if a general cell is large, you can change the attribute only once for one general cell, and you do not need to change the attributes of multiple cells, so you can change the attributes without omission or error. .

[0043]

Since the spreadsheet display device of the present invention is constructed as described above, according to the invention of claim 1, each cell forming the spreadsheet has a free cell width and cell height. Even if you set a free cell width and cell height for each cell, the keystroke and cursor movement match, and you can change the attribute only once for a general cell, which is easy to handle. It is possible to provide a spreadsheet display method.

According to the invention of claim 2, claim 1
Each cell that makes up the spreadsheet can have a free cell width and cell height, and even if a free cell width and cell height are set for each cell, keystrokes and cursor movements can be made uniform. However, the operation of changing the attribute needs to be performed only once for each general cell, and the effect is that it is possible to provide a spreadsheet display device that is easy to handle.

[Brief description of drawings]

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

FIG. 2 is an explanatory diagram showing an example of cell widths and cell heights of type cells.

FIG. 3 is an explanatory diagram illustrating that a type cell is composed of a minimum cell.

FIG. 4 is an explanatory diagram showing a spreadsheet in the case where all are composed of minimum cells.

FIG. 5 is an explanatory diagram for explaining that the minimum cell identification number is assigned to all the minimum cells of the spreadsheet including the minimum cells.

FIG. 6 is an explanatory diagram for explaining arranging type cells in a spreadsheet composed of minimum cells.

FIG. 7 is an explanatory diagram showing a spreadsheet that has been created.

FIG. 8 is a block diagram showing an example of a configuration of a conventional spreadsheet display device.

FIG. 9 is an explanatory diagram showing a spreadsheet in which the cell width and cell height of all cells are constant.

FIG. 10 is an explanatory diagram showing a spreadsheet in which the cell width is changed in units of columns or the cell width is changed in units of rows.

FIG. 11 is an explanatory diagram showing a spreadsheet in which a cell width and a cell height are freely set in cell units.

FIG. 12 is an explanatory diagram illustrating a method of displaying the spreadsheet shown in FIG. 11 on a conventional spreadsheet display device.

FIG. 13 is an explanatory diagram illustrating a method of displaying the spreadsheet shown in FIG. 11 on a conventional spreadsheet display device.

[Explanation of symbols]

 3 Display Means 11 Minimum Cell Setting Means 12 Type Cell Setting Means 13 Spreadsheet Constructing Means

Claims (2)

[Claims] 1. A spreadsheet display method for displaying a spreadsheet composed of a plurality of cells, wherein a minimum cell having a minimum cell width and a minimum cell height in the spreadsheet is set, and the minimum cells are combined to sort. A spreadsheet display method comprising setting a cell, combining the type cells to form a spreadsheet, and displaying the spreadsheet. 2. A spread cell display device having a display means for displaying a spreadsheet composed of a plurality of cells, wherein a minimum cell setting means for setting a minimum cell having a minimum cell width and cell height in the spreadsheet. When,
A spreadsheet display device comprising: a type cell setting unit configured to combine the minimum cells to set a type cell; and a spreadsheet configuration unit configured to combine the type cells to form a spreadsheet.