JP2000003397A - Table processor, and storage medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve the scroll display function by identifying/displaying a column cell or a row cell which is newly displayed in a display area for a prescribed period at the time of scrolling/displaying table data. SOLUTION: When a 'left click' operation with a mouse is executed in a display area on the more outside than a list display area 5b displayed in a display screen 5a by a list designation display processing, the screen is scrolled to the left by the left end column cell width of list data, a right end column cell which is not displayed is half tone dot-meshed/displayed in the list display area 5b and a trimming line in the left outer frame position of the list display area 5b is deleted if a cell area which is not displayed exists on the right side of the right end part of the list display area 5b during display. When the cell area which is not displayed exists on the right outside from the right end part of the list display area 5b, half tone dot meshing/display of the cell at the right end part is released after prescribed time passes. When the cell area, which is not displayed, does not exist on the right outside, the trimming line is displayed in a right outer frame position and the half tone dot meshing display of the cell at the right end part is released after a prescribed time has passed.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table processing device for controlling a scroll display state of table data, and a storage medium storing a control program therefor.

[0002]

2. Description of the Related Art Conventionally, a spreadsheet program is used as a typical application program in a personal computer. In the spreadsheet program, when displaying table data of a plurality of rows and columns on a display screen, a scroll bar indicating a display range is displayed for a column cell or a row cell located in a display area of the table. A desired cell area can be scrolled and displayed in the display area by instructing a bar or an up / down / left / right cursor movement key.

[0003]

However, in the scroll display function in such a conventional spreadsheet program, for example, when the scroll display of a column cell in the left direction is performed, the left end is scrolled according to the scroll in the left direction. Since the column cells located in the column are sequentially hidden, and the hidden column cells located after the rightmost column are sequentially displayed, the following problem arises.

[0004] 1. If the user keeps their eyes off the display area during the scrolling operation and is not looking at the scrollbar display,
It is difficult to determine whether the table data has been scrolled. 2. If the number of column cells and row cells that make up the table data is larger than the number of column cells and row cells that can be displayed in the display area,
Since the movement of the scroll bar during the scroll operation is slight, it is difficult to grasp the state of the scrolled cell. 3. When similar data contents are repeatedly stored in the table data, it is difficult to grasp scrolled cell contents. 4. Due to the above-described inconvenience, there has also been a problem that the user mistakenly recognizes that the scroll operation has not been performed even though the user has performed the scroll operation, and performs a useless scroll operation again.

[0005] The above-mentioned problem similarly occurs in scroll display in the right direction and scroll display in the vertical direction.

SUMMARY OF THE INVENTION It is an object of the present invention to improve the scroll display function by identifying a column cell or a row cell newly displayed in a display area for a certain period when scrolling table data.

[0007]

According to the first aspect of the present invention,
In a table processing apparatus provided with a display means for scrollably displaying a partial area of table data of a plurality of rows and columns in a predetermined display area, a partial display of the table data is scroll-displayed in the predetermined display area. In this case, display control means for identifying and displaying a table data area newly displayed in the predetermined display area in accordance with the scroll direction is provided.

According to the first aspect of the present invention, there is provided a table processing apparatus including a display unit for displaying a partial area of table data of a plurality of rows and a column so as to be scrollable within a predetermined display area. When scrolling a partial area of the table data in the predetermined display area, a table data area newly displayed in the predetermined display area is identified and displayed according to the scroll direction.

Therefore, when the user performs a scroll instruction operation on the table data, the cell area newly displayed in the display area can be visually and reliably grasped according to the scroll direction, and the scroll instruction operation can be performed. Erroneous operation can be prevented, and operability and reliability of the spreadsheet program can be improved.

According to a third aspect of the present invention, in the table processing apparatus provided with display means for displaying a partial area of the table data of a plurality of rows and a column so as to be scrollable within the predetermined display area, When displaying a partial area of the table data, a display control means for identifying and displaying, in a specific display state, a table layout in a direction in which the table data is not displayed is provided.

According to the third aspect of the present invention, in the table processing apparatus provided with display means for displaying a partial area of table data of a plurality of rows and columns in a predetermined display area in a scrollable manner, the display control means When displaying a partial area of the table data in the predetermined display area, a table layout in a direction in which the table data is not displayed is identified and displayed in a specific display state.

Therefore, the presence / absence of a cell area outside the frame can be recognized at a glance from the identification display state of the table layout of the table data displayed in the display area.

According to a fifth aspect of the present invention, in the table processing apparatus provided with display means for displaying a partial area of the table data of a plurality of rows and a plurality of columns in a predetermined display area so as to be scrollable, the instruction relating to the scroll is provided. Display control means for displaying a predetermined scroll instruction area to be input on the display means, determining the type of instruction operation on the scroll instruction area, and performing scroll display of the table data in a direction corresponding to the type of instruction operation; It is characterized by having.

According to the fifth aspect of the present invention, in the table processing apparatus provided with display means for displaying a partial area of the table data of a plurality of rows and columns in a predetermined display area in a scrollable manner, the display control means Displays a predetermined scroll instruction area for inputting an instruction related to the scroll on the display means, determines a type of an instruction operation on the scroll instruction area, and displays the table data in a direction corresponding to the type of the instruction operation. Make scroll display.

Therefore, the operation of instructing scrolling of the table data can be simplified, and the operability at the time of scroll display can be improved.

[0016]

Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a diagram showing an embodiment of a computer system to which the present invention is applied.

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

CPU (Central Processing Unit) 2
Expands an application program specified from a system program stored in the storage device 7 and various application programs corresponding to the system into a program storage area (not shown) in the RAM 4 and is input from the input device 3. Various instructions or data are temporarily stored in the RAM 4, various processings are executed in accordance with the application programs stored in the storage device 7 in accordance with the input instructions and the input data, and the processing results are stored in the RAM 4. , On the display device 5. Then, the processing result stored in the RAM 4 is stored in a storage destination in the storage device 7 which is instructed to be input from the input device 3.

The CPU 2 executes a table designation display process (see FIG. 2) described later as a process corresponding to the spreadsheet program.
Is executed, and the designated table data is read out from the storage device 7 to display a border frame indicating the table display area on the display screen of the display device 3, and the top cell of the read table data is displayed in the table display area. If the cell is displayed so as to be at the upper left corner and there is a non-displayed cell area to the right outside of the right end of the table display area, the border frame at the right outer frame position of the table display area is deleted and the table display area is deleted. Indicates that there is a non-display cell outside the right end of.

Further, the CPU 2 executes a scroll instruction display process (see FIG. 3) described later as a process corresponding to the spreadsheet program, and displays the table display area 5b (see FIG. 3) displayed on the display screen 5a by the table designation display process. When a “left click” operation with the mouse is performed in a display area outside the display area outside the display area 5b, if there is a non-display cell area on the right side of the right end of the displayed table display area 5b, that table is displayed. The leftmost column cell is scrolled to the left by the width of the leftmost column cell, and the hidden rightmost column cell is shaded in the table display area 5b, the border line at the left outer frame position of the table display area 5b is deleted, and the table display area is further displayed. If there is a non-display cell area on the right outside from the right end of 5b, the shaded display of the right end cell is released after a certain time has passed, and if there is no non-display cell area on the right outside, the cell is located at the right outer frame position. After displaying the border line, at a certain time To cancel the shaded display of the right end portion of the cell after the lapse.

When a "right-click" operation with a mouse is performed in a display area outside the table display area 5b displayed in the display screen by the table designation display processing, the CPU 2 displays the currently displayed table. If there is a non-display cell area on the left side of the left end of the display area 5b, the table data is scrolled to the right by one column cell width to the left, and a new left end column cell is shaded in the table display area 5b. If the border line at the right outer frame position of the table display area 5b is deleted, and there is a non-display cell area on the left outside of the left end of the table display area 5b, the left end cell is shaded after a predetermined time has elapsed. If there is no non-displayed cell area on the left outer side, a border line is displayed at the left outer frame position, and after a predetermined time elapses, the hatched display of the left end cell is released.

The input device 3 includes a keyboard and a pointing device such as a mouse provided with a cursor key, numeral input keys, various function keys, and the like.
Output to 2.

A RAM (Random Access Memory) 4 is a C
The PU 2 forms a program storage area for expanding various programs when executing the various application programs, and forms a memory area for expanding data, table data, and the like processed when the CPU 2 executes the various processing. .

The display device 5 is a CRT (Cathode Ray Tub).
e) and the like, and display data (table data or the like) input from the CPU 2 is displayed. The printing device 6 has a CPU
The print data (table data, etc.) input from 2 is printed on a predetermined recording paper and output.

The storage device 7 has a storage medium 8 in which programs, data and the like are stored in advance, and this storage medium 8 is constituted by a magnetic or optical recording medium or a semiconductor memory. The storage medium 8 is fixedly provided in the storage device 7 or is detachably mounted. The storage medium 8 includes the system program, various application programs corresponding to the system, and a table designation display processing program. , A scroll instruction display processing program, and data processed by each processing program.

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

Next, the operation of this embodiment will be described. First, the table designation display process executed by the CPU 2 will be described with reference to the flowchart shown in FIG.

The spreadsheet program is started by the input operation of the input device 3 by the operator, and when the table data to be displayed is designated, the table designation display processing program is read from the storage medium 8 and expanded in the program storage area in the RAM 4. Then, the table designation display process shown in FIG. 2 is started. FIG.
First, the CPU 2 reads the specified table data from the storage device 7 (step S1), sets a table display area in the display screen 5a of the display device 5, and sets the table display area in the outer frame position of the table display area 5b. A frame line (broken line) as shown in FIG.
Is displayed (step S2).

Next, the CPU 2 displays the top cell constituting the read table data such that it is located at the upper left corner in the table display area 5b (step S3), and does not display the cell to the right outside of the right end of the table display area 5b. It is determined whether or not there is a cell area (step S4). If there is a non-display cell area on the right outside of the right end of the table display area 5b, the border frame at the right outer frame position of the table display area 5b is deleted as shown in FIG. 4B (step S5). ), Indicating that a non-display cell exists outside the right end of the table display area 5b, and ends the table designation display processing. If there is no non-display cell area on the right outside of the right end of the table display area, the table designation display processing is terminated.

FIG. 4 shows the table designation display process.
In the lower part of the table data displayed in the table display area 5b shown in (b), a table shift frame 5c for instructing scrolling of the table data is displayed.

Next, the scroll instruction display processing executed by the CPU 2 in response to the scroll instruction operation in the table shift frame 5c for the table data displayed in the table display area by the table designation display processing will be described with reference to the flowchart shown in FIG. Will be explained.

In this scroll instruction display processing,
If a left click operation with the mouse is performed within the table shift frame 5c, a left scroll instruction is given, and if a right click operation is performed, a right scroll instruction is given.

When the scroll instruction display processing of FIG. 3 is started, the CPU 2 first checks whether or not a "left click" operation has been performed with the mouse in the front shift frame 5c (step S11). When the operation is performed, it is determined whether or not there is a non-display cell area on the right side of the right end of the displayed table display area 5b (step S1).
2). If there is a non-display cell area on the right side of the right end of the table display area 5b, the "row A", which is the width of the left end column cell of the table data, is scrolled to the left to set a non-display state (step S13). All cells in the rightmost column are newly displayed in the table display area 5b.
It is determined whether or not display is possible (step S14). If display is not possible, the process proceeds to step S16. If display is possible, as shown in FIG. 4C, a new column cell "E column" at the right end is set in the table display area 5b. (Step S15).

Next, the CPU 2 determines whether or not a border line is displayed at the left outer frame position of the table display area 5b (step S16). If no border line is displayed, the process proceeds to step S18. If a border line is displayed, the border line is deleted at the left outer frame position (step S17). Further, the CPU 2 controls the table display area 5b.
It is determined whether or not there is a non-display cell area on the right outside of the right end of the (step S18). If there is a non-display cell area on the right outside of the right end of the table display area 5b, step S2
After a lapse of a predetermined time, the hatched display of the right end cell is released as shown in FIG. 5A, and the scroll instruction display process is terminated.

If there is no non-display cell area right outside the right end of the table display area 5b, it is determined whether or not a border line is displayed at the right outer frame position (step S1).
9). If the border line is displayed, the process proceeds to step S29. If the border line is not displayed, the border line is displayed at the right outer frame position (step S20), and the process proceeds to step S29. After a certain period of time, FIG.
As shown in (a), the shaded display of the right end cell is released, and the scroll instruction display processing ends.

If a "right click" operation with the mouse is performed in the table shift frame 5c in the process of step S11, the process proceeds to step S21, and the left end of the displayed table display area 5b is moved to step S21. It is determined whether there is a non-display cell area on the left side of the section. If there is no non-displayed cell area, the scroll instruction display process is terminated, and if there is a non-displayed cell area on the left side of the left end of the currently displayed table display area 5b, that is, the non-displayed “A column” Because there is
The column E is scrolled to the right by one column cell width to the left of the table data so as to be in a non-display state (step S22), and FIG.
As shown in (b), a new left-end column cell “column A” is shaded in the table display area 5b (step S2).
3).

Next, the CPU 2 determines whether or not a border line is displayed at the right outer frame position of the table display area 5b (step S24). If no border line is displayed, the process proceeds to step S26. If a border line is displayed, the border line at the right outer frame position is deleted (step S25). Further, the CPU 2 controls the table display area 5b.
It is determined whether or not there is a non-display cell area on the left outside of the left end of the table (step S26). If there is a non-display cell area on the left outside of the left end of the table display area 5b, step S29 is performed.
After a predetermined time has elapsed, the hatched display of the cell at the left end is released, and the scroll instruction display processing ends.

If there is no non-display cell area on the left outside of the left end of the table display area 5b, it is determined whether or not a border line is displayed at the left outer frame position (step S2).
7). If the border line is displayed, the process shifts to the process of step S29, and after a lapse of a predetermined time, the hatched display of the left end cell is released, and the scroll instruction display process ends,
If no border line is displayed, a border line is displayed at the left outer frame position (step S28), and after a predetermined time has elapsed, the hatched display of the left end cell is released (step S29).
This scroll instruction display processing ends.

As described above, in the computer system 1 according to the present embodiment, the table designation display processing and the scroll instruction display processing are executed as processing corresponding to the spreadsheet program, and are set in the display screen 5a of the display device 5. When displaying the table data in the table display area 5b to be displayed, the table display area 5
The border line of the right outer frame position is deleted to indicate that there is a non-displayed cell area outside the right end of b. Also, when scrolling horizontally, newly displayed column cells are kept constant. A time-shaded display is used to identify and display the scrolled cell area. Further, as a result of the scroll display, a left outer side is displayed to indicate that there is a non-displayed cell area outside the left end of the table display area 5b. Since the border line at the frame position is deleted, the cell range of the table data being displayed in the table display area 5b can be clearly expressed.

Therefore, the user can select the table display area 5b
The presence or absence of the cell area outside the frame can be recognized at a glance from the display state of the border line of the specified table data displayed in the table data, and the table is displayed according to the scroll direction when the user performs a scroll operation on the table data The cell area newly displayed in the area 5b can be reliably grasped visually, the erroneous scroll instruction operation can be prevented, and the operability and reliability of the spreadsheet program can be improved. .

In the above embodiment, the table display area 5
b, a table shift frame 5c is displayed on the lower side, and a left scroll display or a right scroll display of the table data is performed according to a "left click" operation or a "right click" operation with the mouse in the table shift frame 5c. Therefore, the table data can be scroll-displayed in a desired scroll direction by a simple instruction operation with the mouse, and the operability at the time of scroll display can be improved.

In this case, the left scroll display or the right scroll display of the table data is performed according to the "left click" operation or the "right click" operation with the mouse. Alternatively, the upper scroll display or the lower scroll display of the table data may be performed according to the “right-click” operation.

In the above-described embodiment, the processing contents when the table data is scrolled in the horizontal direction and the display example of the table data in the table display area 5b have been described. It is needless to say that the same processing content and display method can be used for displaying.

In the above embodiment, the table display area 5
The case where the border line at the right outer frame position or the border line at the left outer frame position is erased to indicate that there is a non-displayed cell area outside the right end or the left end of b is shown. Instead, for example, as shown in FIG. 6, a display mark such as “に” may be displayed at a portion where a non-display cell region exists.

Further, in the above embodiment, when scroll display is performed in the horizontal direction, a newly displayed column cell is shaded for a certain period of time to identify the scrolled cell area. However, the present invention is not limited to this expression form. For example, a new cell area may be blink-displayed for a certain period of time, or may be displayed in a different color.

[0046]

According to the table processing device of the first aspect and the storage medium of the eighth aspect of the present invention, when the user performs a scroll instruction operation on the table data, the display area is changed according to the scroll direction. It is possible to visually and reliably grasp a cell area newly displayed in the inside, prevent erroneous scroll instruction operation, and improve operability and reliability of the spreadsheet program.

According to the table processing device of the second aspect of the present invention, it is possible to save the trouble of returning the newly identified and displayed cell area to the normal display state.

According to the table processing device of the third aspect and the storage medium of the ninth aspect, the presence or absence of a cell area outside the frame from the identification display state of the table layout of the table data displayed in the display area. Can be recognized at a glance.

According to the table processing apparatus of the present invention, the presence / absence of a non-displayed cell area can be expressed by a simple specific display on the table layout.

According to the table processing apparatus of the invention described in claim 5 and the storage medium of the invention described in claim 10, it is possible to simplify the operation of instructing scrolling of the table data and to improve the operability at the time of scroll display. Can be done.

According to the table processing apparatus of the present invention, the table data can be scroll-displayed in a desired scroll direction by a simple instruction operation with the mouse, and the operability at the time of scroll display is improved. Can be improved.

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a main configuration of a computer system 1 according to an embodiment of the present invention.

FIG. 2 is a flowchart showing a table designation display process executed by a CPU 2 of FIG. 1;

FIG. 3 is a flowchart showing a scroll instruction display process executed by a CPU 2 of FIG. 1;

4A and 4B are diagrams showing a display state of table data displayed on the display device 5 of FIG. 1 by the table designation display process of FIG. 2 and the scroll instruction display process of FIG. 3; FIG.
Is a diagram in which a table display area 5b is displayed in FIG. 5, (b) is a diagram in which designated table data is displayed in the table display region 5b, and (c) is a diagram in which table data in the table display region 5b is scrolled to the left and displayed. is there.

5A and 5B are diagrams showing a display state of table data displayed on the display device 5 of FIG. 1 by the scroll instruction display process of FIG. 3; FIG. 5A shows a column cell located at the right end of the table display area 5b; FIG. 9B is a diagram in which the hatched display is canceled, and FIG. 9B is a diagram in which a column cell located at the left end of the table display area 5b is shaded.

FIG. 6 is a diagram showing an example in which a display mark indicating the existence of a non-display cell area located outside the right end of the table display area 5b in FIG. 1 is displayed.

[Explanation of symbols]

 Reference Signs List 1 computer system 2 CPU 3 input device 4 RAM 5 display device 6 printing device 7 storage device 8 storage medium 9 bus

Claims (10)

[Claims] 1. A table processing apparatus comprising a display means for scrollably displaying a partial area of table data of a plurality of rows and columns in a predetermined display area, wherein the table data is stored in the predetermined display area. A table processing apparatus, comprising: display control means for identifying and displaying a table data area newly displayed in a predetermined display area according to a scroll direction when a partial area is scroll-displayed. 2. The table processing apparatus according to claim 1, wherein said display control means cancels the identification display of said new table data area after a lapse of a predetermined time and returns to a normal display state. 3. A table processing apparatus comprising: display means for displaying a partial area of table data of a plurality of rows and columns in a predetermined display area so as to be scrollable. A table processing apparatus comprising: display control means for identifying and displaying a table layout in a direction in which the table data is not displayed when a partial area is displayed in a specific display state. 4. The apparatus according to claim 3, wherein said display control means does not display a special mark or display a border of the table in the direction of the table data not displayed as the specific display state. Table processing equipment. 5. A table processing apparatus comprising display means for scrollably displaying a partial area of table data of a plurality of rows and a plurality of columns in a predetermined display area, wherein a predetermined scroll instruction for inputting an instruction relating to the scroll is provided. Display control means for displaying an area on the display means, determining a type of an instruction operation on the scroll instruction area, and performing scroll display of the table data in a direction corresponding to the type of the instruction operation. Table processing equipment. 6. The display control means determines a left button instruction or a right button instruction in a mouse operation as the type of the instruction operation, and when the scroll instruction area is designated and the left button instruction is given, 6. The table processing apparatus according to claim 5, wherein a left scroll display of the table data is performed, and a right scroll display of the table data is performed when the scroll instruction area is designated and a right button instruction is performed. 7. The display control means determines a left button instruction or a right button instruction in a mouse operation as the type of the instruction operation, and when the scroll instruction area is designated and the left button instruction is given, 6. The table processing apparatus according to claim 5, wherein an up-scroll display of the table data is performed, and when the scroll instruction area is designated and a right button instruction is performed, a downward scroll display of the table data is performed. 8. A storage medium storing a computer-executable program for scrollably displaying a partial area of table data of a plurality of rows and a plurality of columns in a predetermined display area. When scrolling a partial area of the table data, a computer-executable program code for identifying and displaying a newly displayed table data area in the predetermined display area in accordance with the scroll direction is displayed. A storage medium storing a program including the program. 9. A storage medium storing a computer-executable program for scrollably displaying a partial area of table data of a plurality of rows and a plurality of columns in a predetermined display area. A program including a computer-executable program code for identifying and displaying a table layout in a specific display state in a direction in which the table data is not displayed when displaying a partial area of the table data at A storage medium characterized by storing therein. 10. A storage medium storing a computer-executable program for scrollably displaying a partial area of table data of a plurality of rows and a plurality of columns in a predetermined display area, wherein said instruction related to said scrolling is provided. For displaying a predetermined scroll instruction area on the display means for inputting a command, determining a type of an instruction operation for the scroll instruction area, and performing scroll display of the table data in a direction corresponding to the type of the instruction operation. A storage medium storing a program including a program code executable by a computer.