JPH09128179A - Method for controlling display of table format data - Google Patents

Abstract

PROBLEM TO BE SOLVED: To efficiently execute display control based upon graphical user interface(GUI) operation by structuring table format data by a rectangle information array consisting of row rectangles and column rectangles and controlling the display of the data. SOLUTION: Table format data are structured by the rectangle information array 19 including row rectangles 141 to 144 and column rectangles 131 to 134 and the display of display data in a data display area 12 are controlled. Areas on which the column rectangles 131 to 134 intersect with the row rectangles 141 to 144 are processed by GUT processing as data display areas. Each rectangle information includes coordinate information and a data identifiction number and forms a row (or column) rectangle information array.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an application program (hereinafter abbreviated as AP) for displaying a part of tabular data having an arbitrary number of columns and rows in a window of a system having a graphical user interface (hereinafter abbreviated as GUI). ) Display control method.

[0002]

2. Description of the Related Art An instruction regarding display of tabular data in a window by an AP and display based on a GUI operation from the system to the AP is performed by interposing window coordinate information. When the AP makes a display request, the display position is calculated from the size of the data display area and the like, and the display request is issued to the system. At this time, the drawing rectangle range of the tabular data needs to calculate the drawing start position and the drawing end position each time. When the system makes a redraw request for tabular data that has already been displayed, the area of the tabular data that must be actually redrawn based on its coordinate position is the reverse of the AP display request. It becomes necessary to calculate by the calculation method of. Feedback such as reverse display of an area operated by a user on the GUI requires determination of display data to be reversed from the coordinates notified from the system and complicated calculation of the rectangular coordinates thereof.

FIG. 7 shows a conventional display control method for tabular data.
This will be described with reference to (a) and FIG. 7 (b). Referring to FIG. 7A for explaining the case of scrolling tabular data, when columns 731 to 733 of the data display area 73 before scrolling are scrolled leftward, column 731 is hidden on the left and column 734 is displayed on the right. Is added, and the data display area 75 after scrolling is displayed. The column rectangle information 711 to 713 before the scroll becomes the column rectangle information 792 to 794 after the scroll by the process 76 of subtracting the moving position X of the scroll. Referring to the flowchart of FIG. 7 (b) for explaining the operation of the conventional display control method, the bitmap which is the display data of the data display area 73 is transferred by -X for the moving position X by the scroll described above (step 81). The position information of the rectangular information 712 and 713 which is displayed even after scrolling is subtracted by X (step 82). Further, a newly displayed column 734 is drawn by X (step 83).

As described above, the AP directly scrolls the display data that has already been displayed by the scroll amount. Moreover, since new control information for displaying the display data is generated, a new memory is required for the control information area, and the area cannot be reused. Moreover, the bitmap position coordinates of the display data must be directly processed.

[0005]

By expressing the tabular data as a rectangular information array of rows and columns and forming the array into a ring structure, the required memory amount of the control information area for display control can be reduced and re-creation can be achieved. Make available. Further, by processing the coordinate information included in the rectangular information of the array, it becomes unnecessary to directly process the coordinate information of the display data.

[0006]

The object of the present invention is to provide an AP
Controls GUI operations for tabular data by operating the row rectangular information array and the column rectangular information array, and reduces the required memory for control information to simplify the processing of moving, generating, and updating display data in tabular data. To do.

Therefore, according to the method of the present invention, tabular data is represented by a row rectangle corresponding to a row and a column rectangle corresponding to a column, and row rectangle information indicating each of the row rectangles is linked in a ring shape. A rectangular area in the tabular data is specified by a row rectangular information array and a column rectangular information array formed by annularly linking the column rectangular information indicating each of the column rectangles,
In a display control method of tabular data for displaying the rectangular area in a window, a row display range defined by adjacent row rectangle information in the row rectangle information array and column rectangle information adjacent in the column rectangle information array are defined. A rectangular area surrounded by a defined column display range is visualized in the window as a data display area, and a graphical user interface operation for the data display area is executed by an operation of the row rectangular information array and the column rectangular information array. Characterize.

The row rectangle information and the column rectangle information include the upper left and lower right coordinate positions and identification numbers of the row rectangle and the column rectangle, respectively, in the data display area.

[0009]

Next, the present invention will be described with reference to the drawings.

First, referring to FIG. 1 showing one embodiment of the method of the present invention, FIGS. 2A and 2B for explaining the relationship among the data display area on the window, the tabular data and the rectangular information.
A description will be given with reference to (b) and FIG. 2 (c). AP is Figure 2
The tabular data 21 as shown in (a) is displayed in the data display area 1
2 is displayed, the rectangular area 23 of the display data displayed in the data display area 12 of FIG.
It corresponds to a part of 1. The column rectangles 131 to 134 arranged in the column direction and the row rectangles 141 to 144 arranged in the row direction in the data display area 12 of FIG. 1 correspond to the columns and rows of the tabular data 21. The numbers of the column rectangles 131 to 134 and the row rectangles 141 to 144 in FIG. 1 can be changed depending on the size of the data display area 12 or the size of the display character. The column rectangles 131 to 134 and the row rectangles 141 to 144 include the items shown in the rectangle information array 19 of FIG. The rectangular information array 19 is an array of rectangular information 1101 to 110n, and the number of rectangular information pieces in the array is the number of column rectangles or row rectangles of the tabular data 21 displayed in the data display area 12 as a processing target. Even if the tabular data 21 in FIG. 2A has, for example, 255 columns and 100,000 rows,
If the number of columns to be processed is 50 and the number of rows is 100, the array number of the rectangular information array of columns is 50, and the array number of rectangular information arrays of 100 is 100.

In order to treat the rectangular area 23 as the column rectangles 131 to 134 and the row rectangles 141 to 144, it is necessary to hold the contents of the rectangle information. The rectangular information content 111 that must be held at any given time is the number of rectangular information items displayed in the data display area 12. The number of arrays of the rectangular information array 19 configured by the rectangular information 1101 to 110n is the number of column rectangles or row rectangles that will be displayed as a processing target. It is not necessary to prepare column rectangle information and row rectangle information for all row rectangles and column rectangles of the tabular data 21. That is, the tabular data 21
Is very large, the rectangular information array 19 is limited to the rectangular information to be processed.

The rectangular information array 19 shown in FIG. 2 (b) has a column rectangular information array 15 and a row rectangular information array 17 each having a ring structure by the logical ring structure 112 of the rectangular information array shown in FIG. 2 (c). Is structured into In the logical ring structure 112 of this rectangular information array, the array element number

Sequence number [n-1] precedes [0]

After the [0], the rectangular information array 19 is handled as the array number [1]. Rectangular information array 1
It is equivalent to calculating 19 with ModuloN. In each of the column rectangular information array 15 and the row rectangular information array 17 of FIG. 1 which are logically ring structured, a column display range 16 and a row display range 18 indicating a range displayed in the data display area 12 at an arbitrary time point. The row or column indicated by the data identification number of the rectangular information 111 within this range is displayed in the data display area 12. Next, according to the method of this embodiment, the GUI
A case where an operation is performed on the data display area 12 will be described.

The scrolling operation of the rectangular information array in the first embodiment of this method will be described. Each piece of rectangle information of the rectangle information array 19 is provided in correspondence with the number of columns and rows of the column rectangle or the row rectangle to be processed. The rectangular information array 19 is
By treating it as a logical ring structure 112 of the rectangular information array, it is regarded as a ring structure such as the column rectangular information array 15 and the row rectangular information array 17. In the column rectangular information array 15 and the row rectangular information array 17 which are ring-structured, the data display area 12
There is a column display range 16 and a row display range 18 displayed in
The range displayed in the data display area 12 at any time is shown.

The case where the display data in the data display area 12 is scrolled will be described with reference to FIGS. 3A and 3B and with reference to FIG. 3C. In the column rectangular information array 310 for the 31 display data, the identification numbers [1] to [4] shown in the column display range 35 are displayed. Here, when one column is scrolled to the left and the column 33 is hidden and the hidden column 34 appears, the column rectangular information array 310 is rotated 36 (FIG. 3C).
314). By this rotation 36, the column rectangular information array 310 becomes the column rectangular information array 311 in FIG. 3B, and the column display range 312 becomes the array numbers [2] to [5] (step 315). Rectangle information 37 of sequence number [1]
Is eliminated from the column display range 312, and the rectangular information 38 of the column 313 appearing in the scrolled data display area 32 is used. The array element number of the rectangle information 37 is not changed. By rotating 36 the ring structure of the column rectangle information array 310 before scrolling, the change of the rectangle information in the scroll processing is completed. Data display area 3 after scrolling
2 may be displayed only in the column display range 312 (step 316). If the number of sequences is 50, the sequence numbers [47], [48], [49],

When [0] is set as the column display range and one column is scrolled to the left, array numbers [48], [49],

[0] and [1] are displayed. These are all calculated by the modulo operation 112 in FIG.

The operation of updating the already displayed display data in the second embodiment of this method will be described with reference to FIGS.
A description will be given with reference to FIG. 4C with reference to FIG. When the change data 42 is already displayed in the data display area 41, the rectangular coordinate area of the change data 42 is obtained. Display data value "80" of the unit area determined by the fourth column and the third row
Is updated to "100". The data display area 41 already displayed is defined by the column display range 45 and the row display range 46, and the column display range 4 is determined by the data identification number of the rectangular information.
5 in the fourth column of the rectangular information 47 and the row display range 46 in the third
The rectangle information 48 of the row is determined (step 4 in FIG. 4C).
09 and step 410). The AP updates the display data of the rectangular area 42 defined by the columns and rows and draws it (step 411). Since the rectangular information of the screen display (upper left and lower right coordinate positions of the rectangle) is held in the rectangular information array, the coordinate position of the rectangular area 42 in the data display area to be redrawn can be determined.

When redrawing the display data in the data display area in the third embodiment of this method, the operation for determining the display data will be described with reference to FIGS. 5 (a), 5 (b) and 5
With reference to FIG. 5C, description will be made with reference to FIG. The system erases a part of the display area 51, and the drawing request area 52
Is notified by the coordinates (x1, y1)-(x2, y2), the minimum rectangle including the drawing request area 52 is obtained. First, the column minimum rectangle 53 including x1 and x2 is set to the column display range 45.
(Step 516 in FIG. 5D). Similarly,
A row minimum rectangle 54 including y1 and y2 is obtained (step 5)
17). The AP determines the coordinate position in the data display area 51 to be redrawn by obtaining the intersecting rectangle of the column minimum rectangle 53 and the row minimum rectangle 54 (step 518).

6 (a) and 6 (b) showing a click operation in the operation of calculating the rectangular coordinate position and the display data range by the feedback of the GUI operation performed by the user in the fourth embodiment of this method. , FIG. 6 (c) and FIG. 6 (d), FIG. 6 (e), FIG. 6 (f) showing the drag operation.
This will be described with reference to FIG. When a user operates a pointing device such as a mouse, the operation must be fed back to the screen. For example, when the mask is clicked or dragged, the operation is notified by coordinates from the system. Explaining the case of the click operation, the user points the designated position 62 in the data display area 61 in FIG. 6A. The system notifies the designated position 62 by coordinate information (x, y). Based on the coordinate information, the column rectangle 63 and the row rectangle 64 of FIG. 6B can be obtained, and the intersection area 65 of the two rectangles can be obtained. When the intersection area 65 of the two rectangles 63 and 64 is known, the reverse display of FIG. 6C is instructed for the coordinates.

Explaining the case of the drag operation,
The method of obtaining the drag start position 69 in FIG. 6D is the same as the click operation. The drag start area 610 is determined from the drag start position 69. The user moves the mouse cursor at any place, which is also the same as the click operation. The drag end position 611 in FIG. 6E is set. From the row rectangle 68 and the column rectangle 67 at the drag start position 69, the minimum area 614 including the two rectangles of the column rectangle 612 and the row rectangle 613 at the drag end position 611 is obtained,
The coordinates of the minimum area 614 in FIG.

According to the above description of the embodiments, it is shown that the display control method using the structured rectangular information array is suitable for the display control of the tabular data by the GUI operation in the data display area.

[0020]

As described above, according to the present invention,
The display control information based on the rectangular information array configured by the rectangular information of rows and columns can minimize the memory capacity of the control information area.

Further, according to the present invention, the rectangular information array of rows and columns can be cyclically used by making the array of information rectangular.

Further, according to the present invention, when the display data of the already displayed data display area is displayed again by updating or the like, the coordinate position of the data in the data display area can be easily obtained.

Further, according to the present invention, when the system makes a redrawing request for a partial area in the data display area, the display data corresponding thereto can be easily obtained.

Further, according to the present invention, the rectangular coordinate position and the display data range of the feedback of the mouse operation performed by the user can be easily calculated.

[Brief description of the drawings]

FIG. 1 is a diagram showing a relationship between a display portion of tabular data showing a method of the present invention and a rectangular information array of rows and columns.

FIG. 2 is a diagram (a) showing a correspondence between a data display area and tabular data, and a diagram (b) showing a row (or column) rectangular information array and rectangular information contents of the embodiment, a diagram (c). FIG. 3 is a diagram showing that the rectangular information array is structured into a ring.

FIG. 3A is a diagram showing a data display area before scrolling and a rectangular information array, FIG. 3B is a data display area after scrolling and a rectangular information array, and FIG. It is a figure which shows the flow of a rectangle information arrangement operation, respectively.

FIG. 4A is a data display area and rectangle information relating to redrawing of display data, FIG. 4B is a data display area after updating, and FIG. 4C is a redrawing by updating display data. It is a figure which respectively shows the flow regarding.

FIG. 5A is a drawing request area, FIG. 5B is a rectangular operation relating to redrawing, FIG. 5C is display data in an updated data display area, and FIG. FIG. 6 is a diagram showing a flow of a rectangular operation relating to redrawing of data in a drawing request area.

6A, 6B, 6C, 6C, 6C, 6D, 6C, and 6C show a rectangular operation of a click operation relating to feedback of a user's mouse operation, and FIGS. Rectangle operation of drag operation related to feedback of mouse operation,
FIG.

FIG. 7A is a diagram showing a scroll operation of a data display area of tabular data according to the related art, and FIG. 7B is a diagram showing a flow of the scroll operation.

[Explanation of symbols]

 12 data display area 131 to 134 column rectangle 141 to 144 row rectangle 15 column rectangle information array 16 column display area 17 row rectangle information array 18 row display range 19 row (or column) rectangle information array 1101 to 110n row (or column) rectangle Information 111 Row (or column) rectangle information content 112 Logical ring structure of rectangle information array

Claims (2)

[Claims] 1. A row rectangle information array in which tabular data is represented by a row rectangle corresponding to a row and a column rectangle corresponding to a column, and row rectangle information indicating each of the row rectangles is linked in a ring shape. A display control method of tabular data in which a rectangular area in the tabular data is designated by a column rectangular information array in which column rectangular information indicating each of the column rectangles is annularly linked and the rectangular area is displayed in a window. There is a rectangular area surrounded by a row display range defined by adjacent row rectangle information in the row rectangle information array and a column display range defined by adjacent column rectangle information in the column rectangular information array as a data display area. It is visualized in a window, and the graphical user interface operation for the data display area is performed by the operation of the row rectangular information array and the column rectangular information array. Display control method tabular data to. 2. The row rectangle information and the column rectangle information include upper left and lower right coordinate positions and identification numbers of the row rectangle and the column rectangle, respectively, in the data display area. A method for controlling display of tabular data according to item 1.