JPH09293103A - Cell data scroll method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To realize a scroll operation in a cell to a cell which is range-selected when data cannot be stored in the display range of the cell, to facilitate the reference of data and to use a scroll bar and a key for table screen scrolling for the scroll operation in the cell by means of a specified switch. SOLUTION: A scroll direction/quantity by operation events (key input, mouse operation and the like) are calculated by means of a routine 40. Scroll display in the ell against the scroll direction/quantity, which are calculated in routines 70, 80 and 90, is executed. The scroll operation of the whole table and the data scroll operation in the cell are divided in a judgment part 10 by using the specified switch and the data scroll operation in the cell is realized with the same operation as the scroll operation of the whole table.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a cell data scroll method, and more particularly to a cell data scroll method for tabular data processing application software.

[0002]

2. Description of the Related Art As a conventional tabular data processing application software, for example, Microsoft Excel (EXCEL) is known. "Microsoft Excel User's Guide Microsoft Corporation 1
In the method described on page 118 of "Issued November 11, 994", when the character string is too long to fit in the cell, the character string is displayed to extend to the right cell. However, when data is entered in the cell on the right side, the protruding character string is hidden under the cell.

[0003]

The first problem of the above-mentioned conventional method is that, for application software that displays data in a tabular format, the format such as cell width and font is displayed or printed. If you decide to, the size of the cell is also decided to be a unique size, and depending on the length of the data, it may not be able to display in the cell, and the undisplayed part may not be displayed. Is.

The reason is that the above-mentioned conventional technique does not have the concept of scrolling the data in the cell, and the data is input so that the portion of the data to be displayed is in the cell. This is because it is a prerequisite.

The second problem is that when a new scroll function is added, an operation method different from the conventional one must be learned.

The reason is that the new function needs to be assigned with a new operation method corresponding to the new function.

It is an object of the present invention that, in application software for displaying tabular data, if all the data contents cannot be displayed in a specific cell, the cell is regarded as a pseudo window and It is possible to display the data of the invisible portion without changing the format such as the cell width and the font by enabling the data scrolling.

Regarding the operation of scrolling within the cell, a specific switch is provided without introducing a new operation method, and the scroll operation for the entire table window until then is changed by switching the switch.
This is to operate on the data in the cell and not require new attention to the operation method.

[0009]

The first cell data scrolling method of the present invention is to scroll the data displayed in the table-formatted range selection cell in the table-formatted data processing application software within the cell range, Enables data reference in the undisplayed area.

The second cell data scrolling method of the present invention is the first cell data scrolling method, and separates the operation for scrolling the entire table and the operation for scrolling in the cell by the changeover switch, and performs both operations by the same operation. Allow scrolling.

[0011]

Embodiments of the present invention will now be described in detail with reference to the drawings. FIG. 1 is a flow chart showing an operation of scrolling data in a cell according to the present invention. FIG. 2 is a diagram showing how the in-cell data of the present invention is displayed.

When an event relating to an operation such as a key operation or a mouse operation occurs, the processing of FIG. 1 is executed.

In FIG. 1, the determination unit 10 determines whether to perform conventional table scrolling or scroll processing within a cell by using a changeover switch. If the changeover switch is off (OFF), the conventional table scroll processing unit 20 is executed. Switch is on (O
If N), the routine 3 that is the in-cell scrolling process
0, 40, and WHILE statement 50 are executed.

The routine 30 is a routine for extracting a cell whose range is selected to be scrolled within the cell. The routine 40 is a routine for calculating how much the data scroll in the cell is performed by the operation.

The next WHILE statement 50 is executed by the number of range selection cells extracted in the routine 30. For example,
When cells A2 to A3 are selected as shown in FIG. 2C, the processes of routines 60 to 100 are performed in the order of the in-cell scroll process of A2 and the in-cell scroll process of A3.

The routine 60 is a routine for calculating the coordinates of the cell to be scrolled. In the routine 70, data scroll processing is performed on the coordinates for the range already calculated by the routine 40. The routine 80 is a routine for calculating the update range of the data display generated by the scroll. The routine 90 displays new data for the calculated update position.
The routine 100 is a routine for holding from which position the data in the cell is displayed, and the held position becomes a reference point for subsequent data drawing.

Next, the operation of the embodiment of the present invention will be described in detail with reference to FIGS.

As shown in FIG. 2, in the application software that processes data on the front screen, all the data actually stored ((a) in FIG. 2) is stored in the cell by setting the font, cell width, etc. It is not always displayed (FIG. 2 (b)).

Then, the user selects a range (for example, A2 and A3) in which the data in the cell is desired to be scrolled (FIG. 2 (c)) and presses the right arrow key to move one character of the data in the cell to the left. The display is shifted to (Fig. 2
(D)).

This operation will be described with reference to FIG.

First, the cells selected in the range of the routine 30 (in this case, A2 and A3) are extracted. In the routine 40, the scroll amount for one right arrow, that is, for one character is calculated. Then, the drawing processing of the in-cell scroll of the routines 60 to 100 is performed twice for A2 and A3, and WHIL
Loop with E sentence 50.

In the routine 60, the coordinates of the display data of the scrolled cells A2 and A3 are obtained.

Next, by the routine 70, the routine 40
Scroll for one character calculated in. at this point,
For example, the data of A2 becomes "BCDEE" in the software by the processing of the routine 70 in the cell. Therefore, the character position of the last "E" that must be updated by scrolling is calculated in the routine 80 by the display width, character size, etc., and is drawn in the routine 90 to obtain the data displayed as "BCDEE". Redisplay as "BCDEF".

The following routine 100 holds the information that the data display in the cell A2 starts from the character "B" and the data display in the cell A3 starts from the character "2". Exists.

[0025]

As described above, the first effect of the present invention is that a cell is regarded as a pseudo window.
It means that the data in it can be scrolled. As a result, it is not necessary to refer to the contents of the invisible part of the data that does not fit in the cell, and it is not necessary to input so that the part of the data that you want to display is positioned in the cell, which improves user operability. It is to improve.

The reason is that the user inputs the data in order to change the set display font or cell width in order to refer to the invisible portion of the data that does not fit in the cell, or to confirm the data in the input field. This is because there is no need to move the position or to input data considering the position displayed in the cell.

The second effect is that the data scroll in the cell and the normal screen scroll can be switched by a specific switch, and both can be performed by the same operation. As a result, the user does not have to learn an operation different from the conventional operation, and the in-cell scroll processing can be operated by a familiar operation.

[Brief description of drawings]

FIG. 1 is a flowchart showing an operation of scrolling data in a cell according to the present invention.

FIG. 2 is a diagram showing a state of displaying in-cell data of the present invention.

[Explanation of symbols]

 10 Judgment Unit 20 Routine 50 WHILE Statement 60-100 Routine

Claims (2)

[Claims] 1. A cell characterized in that the data displayed in a table-formatted range selection cell in a table-formatted data processing application software can be scrolled within the cell range to enable data reference in an undisplayed portion. Data scrolling method. 2. The cell data scrolling method according to claim 1, wherein an operation for scrolling the entire table and an operation for scrolling in the cell are separated by a changeover switch, and both scrolls can be performed by the same operation.