JP2001005444A - Data display device and storage medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To specify plural fixed rows in a table, and to scroll display the data contents after each fixed row. SOLUTION: When an upward scroll instruction is inputted in (c), a row pointer is made '5', and the fifth row of the table is selected. Since the fifth row isn't a title row, and a fixed flag is set in a third row, the table of the prescribed rows parts from the second row to the fifth row or below of the display picture are displayed as shown in (d). When the input of the upward scroll instruction is continued, the row pointer is made '6', and the sixth row of the table is selected. Since the sixth row is the title row, two rows parts are upward scrolled as shown in (e), and the title row of the sixth row is discriminated and displayed on the first row of the display picture, and the row pointer is made '7', and the data rows of the seventh row or below are displayed.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data display device and a storage medium for setting a plurality of special rows and columns in a table including a plurality of rows and columns of cells and performing display scrolling.

[0002]

2. Description of the Related Art In a conventional data display device, when a table composed of cells of a plurality of rows and a plurality of columns cannot display all data on a display screen, the table is scrolled up, down, left and right. Is moved to display the data of the entire table. At this time, it is necessary to specify the fixed display of the row or column (for example, title row or title column) that you do not want to scroll and limit the display scroll range. Making it possible.

[0003]

However, in the conventional data display device, only one row or column can be designated for fixed display.
In the case of a table having a plurality of title rows or title columns, only the data attached to the title rows or title columns are scrolled and displayed on the screen while simultaneously fixing the title rows or title columns. Could not do so, leaving room for improvement.

A plurality of different columns in a table have a title column, a title is input to a title column provided in a first row up to a middle row of the table, and a title column is placed in a different column from the middle row. If you want to handle data with different contents,
Since a plurality of title columns cannot be fixed, it is not possible to handle only the data while scrolling the data while each title column is displayed on the screen. As described above, when it is desired to provide a title column in a different column in the middle of a table, it is necessary to create another table because one table cannot cope with the title column. It was hanging.

[0005] An object of the present invention is to make it possible to designate a special row or a special column at a plurality of positions in a table composed of cells of a plurality of rows and a plurality of columns, thereby enabling a plurality of special rows or a special row to be specified in one table. A special column is designated so that the data contents of each special row or each special column can be scroll-displayed.

[0006]

According to an aspect of the present invention, there is provided a method for setting a special row or a special column at a plurality of positions in a table including cells of a plurality of rows and a plurality of columns. Means (corresponding to, for example, steps S2 and S3 of the flowchart in the table creation processing shown in FIG. 3) and designating means for designating a desired row or column in the table (when the user inputs the For example, it corresponds to designating a desired row or column with a keyboard or a mouse.) And setting by the setting unit at the closest position above or to the left of the row or column designated by the designation unit. Specifying means for specifying the specified special row or special column (for example, steps S16, S17 and S17 of the flowchart in the table display processing shown in FIG. 4). S19 to step S21) and display control means for fixedly displaying the special row or column specified by the specifying means on the display screen (for example, step S22 of the flowchart in the table display processing shown in FIG. 4). Corresponding).

According to the first aspect of the invention, the setting means causes a special row or a special column to be set at a plurality of positions in a table composed of cells of a plurality of rows and a plurality of columns. And specify the desired row or column in the
The special row or the special column set by the setting means at the closest position above or to the left of the row or the column specified by the specifying means is specified, and the display control means is specified by the specifying means. Special rows or special columns on the display screen.

Therefore, a special row or a special column can be set at a plurality of positions in a table including cells of a plurality of rows and a plurality of columns. For this reason, cell data having different contents (different from a data column or a data row, for example, an item row, an item column, etc.) can be stored in the middle of the row or column in one table without creating a plurality of tables. Can handle.

When a desired row or column is designated and displayed in the table, a special row or column corresponding to the contents of the cell data of the row or column can be always displayed. The meaning of the data in the row or column is always displayed on the display screen. For this reason, the user can easily grasp the contents (attributes and the like) of the desired cell when viewing the display screen.

According to a second aspect of the present invention, there is provided a data display device for displaying a plurality of rows and a plurality of columns of data in which a plurality of special rows or special columns are mixed, a designation means for designating a desired row or column in the data. (Corresponding to a user designating a desired row or column using the input device 3 of FIG. 1, for example, a keyboard or a mouse) and scrolling up and down or left and right with respect to the data of the plurality of rows and columns. Display control means for performing scroll display while leaving at least a special row or the special column at the closest position above or to the left of the row or column specified by the specifying means on the display screen. For example, steps S14 to S22 of the flowchart in the table display processing shown in FIG. 4 and the table display processing shown in FIG. Step S4 of the flowchart that
4 to step S54 and the like. ).

According to the second aspect of the present invention, in the data display apparatus for displaying data of a plurality of rows and columns in which a plurality of special rows or special columns are mixed, the specifying means may include a desired line in the data. Alternatively, when a column is designated and the display control means scrolls up and down or left and right with respect to the data of the plurality of rows and columns, the display control means at least above or to the left of the row or column designated by the designation means The scroll display can be performed while leaving the special row or the special column at the nearest position located on the display screen.

Therefore, when scrolling up and down or right and left cell data of a plurality of rows and columns in which a plurality of special rows or special columns are mixed, at least a special row or column corresponding to the contents of the cell data of a desired row or column is displayed. You can scroll while always displaying the special column,
The meaning of the data of the desired row or column is always displayed on the display screen.
For this reason, when the user scrolls up and down or left and right with respect to cell data of a plurality of rows and a plurality of columns in which a plurality of special rows or special columns are mixed, the user grasps at least desired cell contents (attributes, etc.) Can be scrolled.

[0013]

Embodiments of the present invention will be described below in detail with reference to the drawings. (First Embodiment) FIGS. 1 to 8 are diagrams showing the configuration and processing of a data display device 1 according to a first embodiment of the present invention. First, the configuration will be described.

FIG. 1 is a block diagram showing a main configuration of a data display device 1 according to the present embodiment. In FIG. 1, a data display device 1 includes a CPU 2, an input device 3,
It comprises a display device 4, a RAM 5, a storage device 6 and a storage medium 7, and each part except the storage medium 7 is connected to a bus 8.

CPU (Central Processing Unit) 2
Is an application program specified from various application programs corresponding to the data display device 1 stored in the storage medium 7 in the storage device 6,
Various data corresponding to various instructions input from the input device 3 are stored in a work memory area in the RAM 5, and each processing is executed according to the application program stored in the RAM 5 according to the input instructions and the input data. The result is stored in the work memory in the RAM 5 and displayed on the display device 4. Then, the processing result stored in the work memory area is stored in the storage destination of the storage medium 7 in the storage device 6 designated by the input device 3.

The CPU 2 executes table creation processing (see FIG. 3), which will be described later, according to a table creation processing program stored in the storage medium 7 in the storage device 6, and provides the user with cells in a plurality of rows and a plurality of columns. The table data is input, a title row is arbitrarily set at a plurality of positions, and this is set as a special row. A title column is set at a plurality of positions, and this is set as a special column.

Next, the CPU 2 executes a table display process (see FIG. 4, FIG. 5, FIG. 9, and FIG. 10) according to a table display program stored in the storage medium 7 in the storage device 6. First, the CPU 2 selects the first row of the table in the row pointer memory 5a and displays a predetermined number of rows from the first row of the display screen to the row selected in the row pointer memory 5a.
To be displayed. Next, when the user inputs an instruction to perform an upward scroll operation by using a key on the keyboard of the input device 3 or a mouse, the CPU 2 scrolls the table upward by one row and moves the position of the row pointer by one. Move to the lower row and select the second row of the table.

At this time, if the CPU 2 determines that the line selected in the line pointer memory 5a is a title line,
This title line is identified and displayed on the first line of the display screen and RA
The title flag is fixed by setting the fixed flag stored in M5. Then, the CPU 2 again moves the position of the row pointer to the next lower row, selects the third row in the table, and moves the row pointer memory 5a from the second row of the display screen by a predetermined number of rows equal to or less than the selected row. Is displayed on the display device 4. By repeating the above operation, the CPU 2 fixes a plurality of title lines and scrolls up and displays the data contents after the title lines.

When the user inputs a scroll operation in the downward direction, the CPU 2 scrolls the table downward by one line, and moves the position of the line pointer to the next higher line. If the position of the line pointer at this time is the title line, the position of the line pointer is further moved up one line.
Then, the nearest title line located above the selected line in the line pointer memory 5a is specified, the title line is identified and displayed on the first line of the display screen, and the line pointer is displayed from the second line on the display screen. The display device 4 displays a predetermined number of rows below the selected row in the memory 5a.

The input device 3 includes a keyboard and a pointing device such as a mouse on which a Kana key, a numerical key, various function keys and the like are arranged, and outputs a pressing signal of a key pressed on the keyboard and a mouse position signal to the CPU 2. I do.

The display device 4 is a CRT (Cathode Ray Tub).
e) and a display device configured to display display data input from the CPU 2.

A RAM (Random Access Memory) 5 is a C
When the PU 2 executes the various processing programs as the data display device 1, the PU 2 forms a program storage area for expanding the programs, and when the CPU 2 executes the table creation processing and the table display processing, the processing shown in FIG. As shown, a line pointer memory 5a for selecting a line desired by the user and identifying the selected line, and a fixed flag memory 5b for fixing a title line designated for fixed display and identifying this title line And a fixed line memory 5c for first displaying data lines below the title line designated for fixed display.
And are stored. The fixed flag memory 5b has
Multiple fixed flags can be stored,
A plurality of title lines can be fixedly displayed on the display screen of the display device 4.

The storage device 6 has a storage medium 7 in which programs, data and the like are stored in advance, and this storage medium 7 is constituted by a magnetic or optical storage medium or a semiconductor memory. The storage medium 7 is fixedly provided in the storage device 6 or is detachably mounted. The storage medium 7 stores the table creation program, the table display program, data processed by each program, and the like. I do.

The program, data, and the like stored in the storage medium 7 may be configured to be received and stored from another device connected via a communication line or the like. The storage medium 7 is stored in another connected device.
May be provided so that programs, data, and the like stored in the storage medium 7 are used via a communication line.

Next, the operation of the first embodiment will be described. First, the table creation processing executed by the CPU 2 will be described based on the flowchart shown in FIG.

In FIG. 3, first, the CPU 2 allows the user to input data into a table having a plurality of rows and a plurality of columns (step S1). When a special row is set in the table, a title row to be a special row is designated. Then, the line attribute title of the specified special line is set in the RAM 5 (step S2).

When a special column is set in the table, the CPU 2 causes a title column to be specified as a special column, and sets a column attribute title of the specified special column in the RAM 5 (step S3). The CPU 2 determines whether the end of these settings has been instructed in the title row as a special row or the title column as a special column in the table (step S4).
Determines the setting end instruction, ends the table creation processing, and completes the table creation as shown in FIG. Also, CP
If U2 determines that the end of the setting has not been instructed, the process returns to step S2 to repeatedly specify the title column or title line to be fixed again to the user and repeatedly set the attribute.

Here, the table shown in FIG. 6 will be described. It is assumed that the table of 16 rows and 3 columns shown in FIG. 6 is created by the table creation processing described above. It is assumed that the third, sixth, and twelfth rows of the table are set as title rows, and these three rows are set as special rows. Data corresponding to the contents A to I of each title is input to the third line, the sixth line, and the lines below the respective title lines on the twelfth line.

Next, the table display processing executed by the CPU 2 will be described with reference to the flowcharts shown in FIGS.
7 and the scroll display state transition diagrams of the tables shown in FIGS. 7 and 8. First, an operation of scrolling the table upward (hereinafter, upward scroll means scrolling the table upward with respect to the display screen, and the same applies to downward scroll) will be described.

In FIG. 4, first, the CPU 2 resets the fixed flag memory 5b set in the RAM 5 to return to the default (step S11). Then, in order to display the table of FIG. 6 created by the table creation processing on the display device 4, "1" is set in the row pointer memory 5a in the RAM 5 so as to set the row pointer in the first row of the table ( Step S12) On the display screen of the display device 4, the table for a predetermined row from the first row set to the row pointer is shown in FIG.
(Step S13). In the first embodiment, it is assumed that a table for four rows can always be displayed on the display screen.

In step S14, the CPU 2 determines whether or not a user inputs a scroll instruction for a table by operating a key on the keyboard of the input device 3 or a mouse operation. Is an instruction to scroll upward (step S15). If the instruction is an upward scroll instruction, the CPU 2 adds "1" to the row pointer memory 5a in the RAM 5 to obtain "2", and selects the second row of the table (step S16).

In step S17, the CPU 2 determines whether or not the selected second line is a title line.
If the second line is not a title line, it is determined whether the fixed flag memory 5b in the RAM 5 is set (step S18). If the fixed flag has not been set, the CPU 2 returns to step S13, moves the display position upward by one line at a time by scrolling upward as shown in FIG. Is displayed in a table for a predetermined row from the second row onward (step S1).
3).

If the input of the upward scroll instruction is continued (steps S14 and S15), the CPU 2 further adds "1" to the row pointer memory 5a in the RAM 5 to "3".
The third row of the table is selected (step S16), and it is determined whether or not the selected third row is a title row (step S17). In the table being displayed in FIG. 7, since the third line is the title line, the CPU 2 proceeds to step S19 and scrolls up one line as shown in FIG. The third title line is identified and displayed on the first line (step S19).

Then, the CPU 2 sets the fixed flag memory 5b in the RAM 5 to a set state (step S20).
"1" is further added to the row pointer memory 5a in the RAM 5 to obtain "4", and the fourth row of the table is selected (step S2).
1) The selected fourth line and subsequent lines are displayed from the second line of the display screen (step S22).

Next, the CPU 2 returns to step S14 and, when judging that the input of the upward scroll instruction is continued (steps S14 and S15), further adds "1" to the row pointer memory 5a in the RAM 5. Then, the fifth line of the table is selected (step S16), and it is determined whether or not the selected fifth line is a title line (step S17). In the table displayed in FIG. 7, since the fifth line is not a title line, the CPU 2 determines whether or not the fixed flag memory 5b in the RAM 5 is set (step S18). In the table displayed in FIG. 7, since the fixed flag is set in the third title line, the CPU 2
Displays a table of predetermined rows from the second row to the fifth row set to the row pointer on the display screen as shown in FIG. 7D (step S22).

Next, the CPU 2 returns to step S14.
When it is determined that the input of the upward scroll instruction is continued (steps S14 and S15), the RAM 5
Further, "1" is added to the row pointer memory 5a in the table to obtain "6", and the sixth row of the table is selected (step S1).
6) It is determined whether or not the selected sixth line is a title line (step S17). In the table displayed in FIG.
Since the sixth line is a title line, the CPU 2 moves to step S19, scrolls up two lines as shown in FIG. The line is identified and displayed (step S19).

Then, the CPU 2 sets the fixed flag 5b in the RAM 5 to a set state (step S20),
Further, "1" is added to the row pointer memory 5a in "5" to obtain "7", and the seventh row of the table is selected (step S2).
1) The selected seventh and subsequent lines are displayed from the second line of the display screen (step S22).

Next, the scroll operation in the downward direction of the table will be described. From the state where FIG. 7 (e) is displayed on the display screen, the CPU 2 returns to step S14 again, and when determining that the input of the upward scroll instruction is not continued (steps S14 and S15), proceeds to step S23. Then, it is determined whether the scroll instruction is a downward scroll instruction (step S23). If the instruction is a downward scroll instruction, the CPU 2
"1" is subtracted from the row pointer memory 5a in "6".
Then, the sixth line of the table is selected (step S24), and it is determined whether or not the selected sixth line is a title line (step S25).

In the table displayed in FIG. 8, since the sixth line is a title line, the CPU 2 subtracts “1” from the line pointer memory 5 a in the RAM 5 to obtain “5”, and the fifth line of the table is displayed. Is selected (step S27), and the nearest title line above the table from the selected fifth line is searched (step S28).

Then, in step S29, the CPU 2 determines whether or not there is a title line as a result of the search.
In the table being displayed in FIG. 8, since the third line is the nearest title line, the CPU 2 scrolls down two lines as shown in FIG. The title line of the line is identified and displayed (step S30). And CPU
2 returns to step S22, and displays a table for a predetermined row from the second row to the fifth row set as the row pointer from the second row on the display screen (step S22).

Then, returning to step S14, if the CPU 2 determines that the input of the downward scroll instruction is continued (steps S14, S15, S23), the CPU 2 sets the RA.
"1" is further subtracted from the row pointer memory 5a in M5 to obtain "4", and the fourth row of the table is selected (step S2).
4), it is determined whether or not the selected fourth line is a title line (step S25). In the table displayed in FIG.
Since the fourth line is not a title line, the CPU 2
It is determined whether or not the fixed flag 5b in 5 is set (step S26). In the table displayed in FIG. 8, since the fixed flag is set in the third title line,
The CPU 2 proceeds to step S22, and displays the selected fourth and subsequent lines from the second line of the display screen as shown in FIG. 4B (step S22).

Next, the CPU 2 returns to step S14, and determines that the input of the downward scroll instruction is continued (steps S14, S15, S23).
"1" is further subtracted from the row pointer memory 5a in M5 to "3", and the third row of the table is selected (step S2).
4) It is determined whether or not the selected third line is a title line (step S25). In the table displayed in FIG.
Since the third line is the title line, the CPU 2
Further, "1" is further subtracted from the row pointer memory 5a in the table to obtain "2", and the second row of the table is selected (step S2).
7) A search is made for the most recent title line above the table from the selected second line (step S28).

In the table shown in FIG. 6, there is no title line above the second line (step S29).
Resets the fixed flag 5b in the RAM 5 set to the third title line (step S31), returns to step S13, and scrolls down one line as shown in FIG. 8 (c). Then, the selected second and subsequent lines are displayed from the first line of the display screen.

Then, in step S14, the CPU
Step 2 determines whether a scroll operation has been performed by the user. A case where a user does not input a table scroll instruction by a key operation on the keyboard of the input device 3 or a mouse operation (step S14), and a case where such an operation is a scroll operation but not a vertical scroll but a horizontal scroll (Step S15,
In S23), the CPU 2 shifts to step S32 to execute processing other than those up and down scrolling, and thereafter ends the table display processing.

As described above, in the first embodiment, when a title row which is a special row is set at a plurality of positions in a table including a plurality of rows and a plurality of columns of cells, When a desired line is specified in, the closest title line located above the line among the plurality of title lines is specified, and the title line is displayed on the display screen.

Thus, when scrolling the display screen upward or downward with respect to a plurality of lines of data in which a plurality of title lines are mixed, at least the closest title line located above the designated line is displayed on the display screen. Can be left on.

Therefore, in the first embodiment,
Cell data of different contents can be handled in the middle of a row in one table, and when displaying cell data of a desired row, a title row corresponding to the content of the cell data is always displayed. The display can be scrolled up and down while being displayed.

Thus, the user can scroll and display while recognizing what kind of contents (attributes and the like) the cell data of the desired row is. It is possible to improve the operability and convenience when a table is created and the table is scroll-displayed on the display screen.

In the table display processing according to the first embodiment, a case has been described in which rows are fixedly displayed when scrolling up and down on the display screen. The same table display processing can be performed by fixing the columns for. In this case, the title column will be displayed on the far left,
In the first embodiment, the upward scroll corresponds to the right scroll, and the downward scroll corresponds to the left scroll. In the table display processing according to the first embodiment, a table is targeted, but the present invention is not limited to the table.
Similar processing can be performed on a document line or the like.

(Second Embodiment) FIGS. 9 to 13 are diagrams showing the processing and the like of the data display device 1 according to a second embodiment to which the present invention is applied.

In the first embodiment, the case where only one fixed flag is set on the display screen has been described.
It is also possible to set a fixed flag in a plurality of rows. In the second embodiment, a case will be described where the fixed flag is set to two lines and the display screen is scrolled.

The data display device 1 according to the second embodiment has the same configuration as the main part shown in FIG. 1 and the memory configuration shown in FIG. 2 in the first embodiment. The illustration and description of the configuration are omitted.

Further, the second embodiment will be described based on the table created by the table creation processing in the first embodiment. In the first embodiment, the display screen Although the case where four lines are displayed above has been described, in the second embodiment, the operation will be described for the case where five lines are displayed on the display screen.

The table display processing executed by the CPU 2 will be described with reference to the flowcharts shown in FIGS. 9 and 10, the tables shown in FIG. 6, and the scroll display state transition diagrams of the tables shown in FIGS. First, a scroll operation in the upward direction of the table will be described.

In FIG. 9, first, the CPU 2 resets the fixed flag memory 5b set in the RAM 5 to return to the default (step S41). Then, in order to display the table of FIG. 6 created by the table creation processing on the display device 4, "1" is set in the row pointer memory 5a in the RAM 5 so as to set the row pointer in the first row of the table ( Step S42), one of the tables displayed on the display device 4
In order to display the table from the line, the table 1 in the display device 4 is displayed.
A fixed row memory 5 in the RAM 5 so that the row is a fixed row.
"1" is set to c (step S43). The fixed line set in this way is specified to display the line below the line set in the previously set line pointer memory 5a from that line.

Then, the CPU 2 displays, on the display screen of the display device 4, a table of a predetermined line from the fixed line to the first line or less set as the line pointer as shown in FIG. 11A (step S44). . In the second embodiment, it is assumed that a table for five rows can be always displayed on the display screen.

In step S45, the CPU 2 determines whether or not a user has input a scroll instruction for a table by operating a key on the keyboard of the input device 3 or a mouse operation. Is an instruction to scroll upward (step S46).

In the case of an upward scroll instruction,
The CPU 2 adds "1" to the row pointer memory 5a in the RAM 5 to obtain "2", and selects the second row of the table (step S16).

In step S48, the CPU 2 determines whether or not the selected second line is a title line.
If the second line is not a title line, it is determined whether the fixed flag memory 5b in the RAM 5 is set (step S49). If the fixed flag has not been set, the CPU 2 returns to step S43, moves the display position upward by one line, and moves the display position upward by one line from the first line of the display screen, which is a fixed line, to a predetermined line below the second line set as a line pointer. A table for the rows is displayed (step S44).

When the input of the upward scroll instruction is continued (steps S45 and S46), the CPU 2 further adds "1" to the row pointer memory 5a in the RAM 5 to "3".
The third row of the table is selected (step S47), and it is determined whether or not the selected third row is a title row (step S48). In the table displayed in FIG. 11, since the third line is the title line, the CPU 2 proceeds to step S50.
Then, as shown in FIG. 11B, one line is scrolled up, and the third title line is highlighted on the first line of the display screen (step S50).

Then, the CPU 2 adds "1" to the fixed row memory 5c in the RAM 5 to obtain "2" (step S2).
51), the third line, which is the title line, is
The value is set in the fixed flag memory 5b in the AM 5 (step S52), "1" is further added to the row pointer memory 5a in the RAM 5 to obtain "4", and the fourth row of the table is selected (step S53). The selected fourth line and subsequent lines are displayed from the second line of the display screen, which is a fixed line (step S5).
4). The display state of the display device 4 at this time is as shown in FIG.

Next, the CPU 2 returns to step S45 and, when judging that the input of the upward scroll instruction is continued (steps S45 and S46), further adds "1" to the row pointer memory 5a in the RAM 5. Then, the fifth line of the table is selected (step S47), and it is determined whether or not the selected fifth line is a title line (step S48). In the table displayed in FIG. 11, since the fifth line is not a title line, the CPU 2 determines whether or not the fixed flag memory 5b in the RAM 5 is set (step S49). In the table being displayed in FIG. 11, since the fixed flag is set in the third title line,
The PU2 displays a table for a predetermined row from the second row of the display screen, which is a fixed row, to the fifth row or less set as the row pointer as shown in FIG. 11C (step S54).

Next, the CPU 2 returns to step S45 again.
When it is determined that the input of the upward scroll instruction is continued (steps S45 and S46), the RAM 5
Further, "1" is added to the row pointer memory 5a in the table to obtain "6", and the sixth row of the table is selected (step S4).
7) It is determined whether or not the selected sixth line is a title line (step S48). In the table displayed in FIG. 11, since the sixth line is the title line, the CPU 2 shifts to step S50, and as shown in FIG. The title line is highlighted (step S50).

Then, the CPU 2 adds "1" to the fixed row memory 5c in the RAM 5 to obtain "3" (step S3).
51) The title line is set as a fixed flag in the fixed flag memory 5b in the RAM 5 (step S52).
"1" is further added to the row pointer memory 5a in AM5 to obtain "7", and the seventh row of the table is selected (step S5).
3) The selected seventh and subsequent lines are displayed from the third line of the display screen, which is a fixed line (step S54). The display state of the display device 4 at this time is as shown in FIG.

Next, the CPU 2 returns to step S45 and, when judging that the input of the upward scroll instruction is continued (steps S45 and S46), further adds "1" to the row pointer memory 5a in the RAM 5. Then, the 8th line of the table is selected (step S47), and it is determined whether or not the selected 8th line is a title line (step S48). In the table displayed in FIG. 11, since the eighth line is not a title line, the CPU 2 determines whether or not the fixed flag memory 5b in the RAM 5 is set (step S49). In the table displayed in FIG. 11, since the fixed flag is set in the third and sixth title lines, the CPU 2 sets the line pointer from the third line of the display screen, which is the fixed line, to the line pointer. A table for a predetermined row below the eye is displayed (step S54).

Similarly, the upward scroll is executed by two lines, and the display state of the display device 4 when three lines are scrolled up is shown in FIG. 11 (e). The display state of No. 4 is shown in FIG.

Next, the scroll operation in the downward direction of the table will be described. From the state where FIG. 11D is displayed on the display screen, the CPU 2 returns to step S45 again, and when it is determined that the input of the upward scroll instruction has not been continued (steps S45 and S46), proceeds to step S55. Then, it is determined whether or not the scroll instruction is a downward scroll instruction (step S55). If the instruction is a downward scroll instruction, the CPU 2
"1" is subtracted from the row pointer memory 5a in "6".
Then, the sixth line of the table is selected (step S56), and it is determined whether or not the selected sixth line is a title line (step S57).

In the table displayed in FIG. 13, since the sixth line is the title line, the CPU 2 subtracts "1" from the fixed line memory 5c in the RAM 5 to set the fixed line to "2" (step S59). ), And "1" from the row pointer memory 5a.
Is subtracted to “5”, and the fifth row of the table is selected (step S60).

In step S61, the CPU 2 determines whether or not the fixed row currently stored in the fixed row memory 5c is "1". In the table displayed in FIG. 13, since the fixed row is “2”, the process proceeds to step S62 to reset the fixed flag memory 5b set in the sixth row (step S62).

Then, the CPU 2 returns to step S44, and as shown in FIG. 13 (g), displays a table of a predetermined row from the second row of the display screen, which is a fixed row, to the fifth row or less set as the row pointer from the second row. It is displayed on the display device 4 (step S44).

Next, in step S45, the CPU
Step 2 determines whether a scroll operation has been performed by the user. A case where a user does not input a table scrolling instruction by a key operation on the keyboard of the input device 3 or a mouse operation (step S45), and a case where such an operation is a scroll operation but not a vertical scroll but a horizontal scroll (Step S46,
In S55), the CPU 2 shifts to step S63, executes processes other than those up and down scrolls, and thereafter ends the table display process.

As described above, in the second embodiment, when a title row which is a special row is set at a plurality of positions in a table composed of cells of a plurality of rows and a plurality of columns, When a desired line is specified in, among the plurality of title lines, all the title lines located above the line are specified, and the title lines are displayed on the display screen.

Thus, when scrolling the display screen upward or downward with respect to a plurality of lines of data in which a plurality of title lines are mixed, at least all the title lines located above the designated line are displayed on the display screen. Can be left.

Therefore, also in the second embodiment, cell data having different contents can be handled from the middle of a row in one table, and the cell data of a desired row can be displayed. Can scroll up and down while always displaying at least a special line corresponding to the contents of the cell data.

Thus, the user can scroll and display while recognizing what kind of content (attributes and the like) the cell data of the desired row is. It is possible to improve the operability and convenience when a table is created and the table is scroll-displayed on the display screen.

In the table display processing according to the second embodiment, a case where a plurality of lines are fixedly displayed when scrolling up and down on the display screen has been described. The same table display processing can be performed by fixing a plurality of columns for scrolling. In this case, the title columns are displayed in a plurality of columns from the left side, and the upward scroll corresponds to the right scroll and the downward scroll corresponds to the left scroll in the second embodiment. In the table display processing according to the second embodiment, a table is targeted. However, the present invention is not limited to the table, and the same processing can be performed on a document line or the like.

Further, when a plurality of fixed flags are stored in the fixed flag memory 5b as shown in FIG. 12 (d), the display method of the display screen of the display device 4 is shown in FIG. 13 (h).
It is also possible to display only the upper half of the fixed flag other than the fixed flag set last as shown in FIG. In this case, since the upper half of the tenth line is also displayed as shown in FIG. 13H, the number of displayed lines increases, and the convenience for the user can be further improved.

[0078]

According to the first and fifth aspects of the present invention, a special row or a special column can be set at a plurality of positions in a table composed of cells of a plurality of rows and a plurality of columns. When a desired row or column is designated and displayed, a special row or column corresponding to the contents of the cell data of the row or column can be always displayed.

Therefore, the user can create different contents (data having different meanings of columns or rows) from the middle of the row or column in one table without creating a plurality of tables for each special row or special column. Can handle cell data. Further, when a table including a plurality of special rows or special columns is displayed on the display screen, the user can easily grasp the contents (attributes and the like) of desired cell data.

According to the second, third, fourth, and sixth aspects of the present invention, a special row or a special column is set at a plurality of positions in a table composed of cells of a plurality of rows and a plurality of columns. If a desired row or column is specified in the table, the special row or column that is the closest one above or to the left of the row or column is specified. A row or special column can be specified and the special row or special column can be displayed on the display screen. When scrolling up and down or left and right on this table, at least the specified row or column Scrolling can be performed with the leftmost special row or special column left on the display screen.

Therefore, when scrolling up and down or left and right on cell data of a plurality of rows and columns in which a plurality of special rows or special columns are mixed, at least the special data corresponding to the contents of the cell data of the desired row or column is displayed. You can scroll while always displaying rows or special columns.

Therefore, when the user scrolls up and down or left and right on cell data of a plurality of rows and columns in which a plurality of special rows or special columns are mixed, the user can change the contents (attributes and the like) of the desired cell data. It is possible to scroll and display while recognizing, and it is possible to create a table composed of cells of a plurality of rows and a plurality of columns and to improve operability and convenience when scrolling and displaying the table on a display screen.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a main configuration of a data display device 1 according to an embodiment to which the present invention is applied.

FIG. 2 is a diagram showing a memory configuration in a RAM 5 of FIG.

FIG. 3 is a flowchart illustrating a table creation process executed by a CPU 2 of FIG. 1;

FIG. 4 is a part of a flowchart showing a table display process according to the first embodiment executed by the CPU 2 of FIG. 1 (continued from FIG. 5).

FIG. 5 is a part of a flowchart showing a table display process in the first embodiment continued from FIG. 4;

FIG. 6 is a diagram showing a table created by the table creation process of FIG. 3;

FIG. 7 is a transition diagram of a display state when upward scrolling is performed a plurality of times in the table display processing according to the first embodiment.

FIG. 8 is a transition diagram of a display state when a downward scroll is performed a plurality of times in the table display processing according to the first embodiment.

FIG. 9 is a part of a flowchart showing a table display process according to the second embodiment executed by the CPU 2 of FIG. 1 (continued from FIG. 10).

FIG. 10 is a part of a flowchart showing a table display process in the second embodiment continued from FIG. 9;

FIG. 11 is a transition diagram of a display state when upward scrolling is performed a plurality of times in the table display processing according to the second embodiment.

FIG. 12 is a transition diagram of a display state when up scrolling is performed a plurality of times in the table display processing according to the second embodiment, and is a diagram showing a continuation of FIG. 11;

FIG. 13 is a diagram illustrating a transition state of a display state when a downward scroll is performed in the table display processing according to the second embodiment, and a diagram illustrating a modification of another display method according to the second embodiment.

[Explanation of symbols]

 Reference Signs List 1 data display device 2 CPU 3 input device 4 display device 5 RAM 5a row pointer memory 5b fixed flag memory 5c fixed row memory 6 storage device 7 storage medium 8 bus

Claims (6)

[Claims] 1. A setting means for setting a special row or a special column at a plurality of positions in a table comprising cells of a plurality of rows and a plurality of columns; a specifying means for specifying a desired row or a column in the table; Specifying means for specifying the special row or special column set by the setting means at the closest position above or to the left of the row or column specified by the specifying means; A display control means for fixedly displaying a row or a special column on a display screen. 2. A data display device for displaying data of a plurality of rows and columns in which a plurality of special rows or special columns are mixed, a designating means for designating a desired row or column in the data; When scrolling up and down or left and right for multiple columns of data, at least the closest special row or column located above or to the left of the row or column specified by the specifying means is displayed. A data display device, comprising: display control means for performing scroll display while remaining on a screen. 3. The display control means according to claim 2, wherein only the special row or column at the closest position above or to the left of the specified row or column is scroll-displayed while being left on the display screen. The data display device according to claim 2, wherein 4. The display control means according to claim 1, wherein said plurality of special rows or special columns located above or to the left of said designated row or designated column are scrolled and displayed on a display screen. Item 3. The data display device according to Item 2. 5. A storage medium storing a computer-executable program for scrolling a plurality of rows and a plurality of columns of data displayed on a data display device, the table comprising a plurality of rows and a plurality of columns of cells. A computer-executable program code for setting a special row or special at a plurality of positions in a table; a computer-executable program code for specifying a desired row or column in a table; Computer-executable program code for identifying the set special row or special column at the closest position above or to the left of the specified row or column; and A computer-executable program code for displaying on a display screen and a program including Storage medium for the butterflies. 6. A storage medium storing a computer-executable program for displaying a plurality of rows and a plurality of columns of data in which a plurality of special rows or special columns are mixed on a data display device, wherein: A computer-executable program code for designating a desired row or column, and when scrolling up and down or left and right with respect to the data of the plurality of rows and columns, at least the designated row or column And a computer-executable program code for performing scroll display in a state where the special row or the special column at the nearest position located above or to the left is left on the display screen. Storage medium.