JPH064528A - Rectangular scroll display system for spread sheet - Google Patents

Abstract

PURPOSE:To display at a high speed the vertical and horizontal scrolls produced by the movements of a window cursor. CONSTITUTION:An input control part 2 is provided to control the input of data and the input operation using a scroll key together with a data control part 3 which controls and stores the input data for each cell, a screen editing part 4 which edits the data stored in the part 3 into a screen display form and also calculated the area changed by the scroll, and a screen display control part 5 which copies the date shown on a screen in a prescribed rectangular range and also display the data edited by the part 4 on the screen.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a vertical and horizontal rectangular scroll display system for spreadsheets.

[0002]

2. Description of the Related Art Conventionally, in this type of scroll display, the already displayed table portion and the newly displayed portion are edited again and the entire screen is displayed again.

[0003]

In the above-mentioned conventional scroll display method, when scroll display is performed, cells that have already been displayed (the smallest unit box that constitutes the spreadsheet is shown. Further, each cell of the spreadsheet is shown. Is m
In the case of the column and the n-th row, it is called an mn cell. ) Data and the cell data of the newly displayed column or row must be edited again to display the previous screen. Therefore, since the data already edited and displayed on the screen is edited and displayed again, there is a drawback that the scroll operation that occurs when the window cursor is moved cannot be performed at high speed.

[0004]

According to the rectangular scroll display method of a spreadsheet of the present invention, an input control unit for controlling data input and input by a scroll key, and the input data is managed and stored in a unit of one cell. A data management unit, a screen editing unit that edits the cell unit data stored in this data management unit in a screen display format, and calculates the location changed by scrolling, and the data on the display screen is copied in a predetermined rectangular range. And a screen display control unit that displays the screen display format data edited by the screen editing unit on the display screen.

[0005]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of the present invention. In FIG. 1, the input control unit 2 analyzes the characters, numerical values, and ruled line information input by the operator and registers them in the data management unit 3, or analyzes the operation of the wind cursor movement key or the like designated by key input. The data management unit 3 manages the information obtained by the input control unit 2 on a cell-by-cell basis and stores it as cell data. The display editing unit 4 performs editing for displaying the cell data stored in the data management unit 3 on the screen, and calculates and edits a portion changed by scrolling. The screen display control unit 5 displays the data in the screen display format edited by the display editing unit 4. In addition, the data already displayed on the screen is copied in the rectangular range. Then, the overall control unit 1 controls each of these units.

Next, the operation of this embodiment will be described.

FIG. 2 is a diagram showing an example of a spreadsheet. The spreadsheet includes a cell 11 which is the minimum unit of the spreadsheet, a column number 13 of the spreadsheet,
Reference numeral 12 is a window cursor which is composed of line numbers 14 and 12. FIG. 3 is a diagram showing a spreadsheet before the rectangular scroll operation.

FIG. 4 and FIG. 5 are diagrams showing an example of a rectangular scroll operation in the right and down directions, respectively.

Here, the operation of the rectangular scroll when the window cursor is moved rightward will be described with reference to FIGS. 1 and 4.

First, when the operator presses the wind cursor movement key, the input control unit 2 determines in which direction the designated key moves the wind cursor. Upon receiving this information, the overall control unit 1 transfers control to the screen display control unit 5 and determines whether or not the wind cursor movement is accompanied by the scroll operation. If scrolling is not involved, the overall control unit 1 transfers control to the screen display control unit 5 to move the window cursor. When the wind cursor movement accompanied by scrolling occurs, the overall control unit 1 notifies the screen editing unit 4 of the cursor movement direction and passes control.

The screen editing unit 4 obtains the display start position after scrolling from the already displayed range of the screen, and updates the display contents of the screen by using the copy function in the rectangular range of the screen display control unit 5. (See FIG. 4B). Then, the screen editing unit 4 returns control to the overall control unit 1 when the editing of the newly displayed screen portion is completed, and the new display position (see FIG.
Notify P of (b). The overall control unit 1 notifies the screen display control unit 5 of this display position (P) and displays the new display location line by line. In the example of FIG. 4, 17 lines are displayed. When the scroll display of the screen ends, the screen display control unit 5 moves the window cursor (see FIG. 4C).

Next, the operation of the rectangular scroll when the window cursor is moved downward is shown in FIG.
~ It demonstrates with reference to the figure (c). The control in this case is the same as that in the case of moving the window cursor to the right direction shown in FIGS. 4A to 4C described above, except that the copy position 3 and the copy position 3 in the rectangular range of the screen display control unit 5 are changed. The range to be edited into a new display format by the screen editing unit 4 is different. In the vertical direction, the number of lines to be newly edited and displayed is 1.
Because of the line, it is faster than the horizontal rectangular scroll. FIG. 5B is a diagram showing a state in which the cell data of the new editing range in the downward movement of the window cursor is converted into the display format.

[0014]

As described above, according to the present invention, since the data which has already been displayed is copied and moved in the rectangular range, and only the data of the portion to be newly displayed on the screen is edited and displayed, the screen is displayed. No need to re-edit the whole data,
There is an effect that the scroll operation that occurs when the wind cursor moves can be performed at high speed.

[Brief description of drawings]

FIG. 1 is a configuration diagram showing an embodiment of the present invention.

FIG. 2 is a diagram showing an example of a spreadsheet.

FIG. 3 is a diagram showing a spreadsheet before a rectangular scroll operation.

FIG. 4 is a diagram showing an example of a rectangular scroll operation in the right direction.

FIG. 5 is a diagram showing an example of a downward rectangular scroll operation.

[Explanation of symbols]

 1 overall control unit 2 input control unit 3 data management unit 4 screen editing unit 5 screen display control unit 11 cell 12 window cursor 13 column number 14 line number

Claims (1)

[Claims] 1. A rectangular scroll display method for a spreadsheet in a display device, comprising: an input control unit for controlling data input and scroll key input; and data management for managing and storing the input data in units of cells. Section, the cell unit data stored in the data management section is edited in a screen display format, and a screen editing section that calculates a portion changed by scrolling, and the data on the display screen is copied in a predetermined rectangular range, And a screen display control unit for displaying data in the screen display format edited by the screen editing unit on the display screen.