JP2003223606A - Display control program and recording medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To display a plurality of items in any cell so that the plurality of items can be simultaneously observed on a screen by installing a multiple display information table and a sort index and displaying original data at any position, displaying the sorted results of the data sorted by any items, and displaying the divided and integrated cells, display the sorted results of any items, divide the items in the cells and display them in the other cells and new cells, and delete the cells and integrate the items in the cells with those in the other existing cells on a display control program for displaying table data and a recording medium. <P>SOLUTION: This display control program comprises a means for preparing the multiple display information table for setting a column in which one or multiple columns of data in the table is set and a means for taking out the data in the column of the table and displaying the data in the set column referring to the multiple display information table. <P>COPYRIGHT: (C)2003,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a display control program for displaying table data and a recording medium.

[0002]

2. Description of the Related Art Conventionally, when a table is displayed on a screen, if the number of digits of cells in the horizontal direction is large, the table is pushed out from the right end of the screen, and scrolled to move it into the screen for display.

[0003]

As described above, in the conventional display method, the number of digits that can be viewed at the same time is determined, and in the case of a table that exceeds the number of digits, scroll and scroll in the corresponding cell. However, there is a problem that it is difficult to compare the data in the cells with each other.

Further, when a plurality of data are displayed in one cell to increase the content that can be viewed at the same time,
There is a problem that you cannot sort by specifying arbitrary data in a cell.

The present invention solves these problems.
Multiple display information table and sort index are provided so that the original data can be displayed at any position and the result of sorting by any item can be displayed, and the cells can be divided and integrated to be displayed at the same time on the screen. Display multiple items in any cell and display the sorting result of any item, divide the item in the cell and display in another cell or new cell, and delete the cell to make the item in the cell other existing It is intended to be integrated in the cell of.

[0006]

[Means for Solving the Problems] Means for solving the problems will be described with reference to FIG.

In FIG. 1, a processing device 1 executes various processes according to a program, and here, from a table creating means 2, a display means 3, a sorting means 4, a dividing means 5, an integrating means 6 and the like. It is composed.

The table creating means 2 creates a plural display information table 14 for setting in which digit the data of one or plural digits of the table is to be displayed.

The display means 3 takes out the data of the digit in the table and displays it in the digit set by referring to the plural display information table 14, or displays the data in the row set in the sort index 15. And so on.

The sorting means 4 sorts the data of the corresponding item in the table based on the item of the selected data when an arbitrary item is selected on the displayed screen.

The dividing means 5 includes a plurality of display information tables 14
The designated digit information in the digit corresponding to the item designated by is deleted, and the deleted digit information is newly created and set at the designated position.

The integrating means 6 includes a plurality of display information tables 14
The specified digit information in the digit corresponding to the item specified by is deleted, and the deleted digit information is added to the specified digit position.

The original data 12 is the original data of the table before being displayed. The plural display information table 14 is a table for setting in which digit the data of one or plural digits of the table is displayed.

The sort index 15 is used to set in which row the data of the row of the table is displayed.

Next, the operation will be described. The table creating means 2 sets and creates in the plural display information table 14 which digit the data of one or a plurality of digits of the table is to be displayed, and the displaying means 3 takes out the digit data of the table and displays a plurality of them. The information table 14 is referred to and displayed at the set digit.

At this time, the sorting means 4 sets which row the data of the row of the table is to be displayed on to create a sort index 15, and the display means 3 extracts the data of the row of the table and sets the sort index 15 to it. I am trying to display in the line that is set by reference.

When an arbitrary item is selected on the screen on which the sorting means 4 is displayed, the data of the corresponding item in the table is sorted based on the item of the selected data, and the sorted data is displayed. The sorting index 15 is set in the order of, and the sorting index 15 after the setting is displayed.

In addition, in response to the designation of division in which the dividing means 5 designates the item displayed on the screen, the designated digit information in the digit corresponding to the designated item is deleted from the plural display information table 14 and The deleted digit information is newly created and set at the designated position, and the display means 3 retrieves the digit data of the table and displays it at the digit set by referring to the plural-table information table 14. There is.

Further, in response to the designation of the integration by designating the item displayed on the screen by the integrating means 6, the designated digit information in the digit corresponding to the designated item is deleted from the plural display information table 14 and The deleted digit information is added to the designated digit position and set, and the display means 3 retrieves the digit data of the table and displays it in the digit set by referring to the plural-table information table 14. .

Therefore, by providing the plural display information table 14 and the sort index 15, the original data 12 is displayed at an arbitrary position and the result of sorting by an arbitrary item is displayed, or the cells are divided and integrated and displayed. This allows you to display multiple items in any cell so that you can see them on the screen at the same time, and display the sort result of any item, or divide the items in a cell and display them in other cells or new cells. Alternatively, it is possible to delete a cell and integrate the items in the cell into another existing cell.

[0021]

BEST MODE FOR CARRYING OUT THE INVENTION Next, embodiments and operations of the present invention will be sequentially described in detail with reference to FIGS.

FIG. 1 shows a system configuration diagram of the present invention.
In FIG. 1, a processing device 1 executes various processes according to a program loaded into a main memory (memory 11) from a recording medium (not shown), and here, a table creating means 2, a display means 3, and a sorting means. 4, the dividing unit 5, the integrating unit 6, and the like.

The table creating means 2 creates the multiple display information table 14 for setting which digit the data of one or more digits of the original table is to be displayed.

The display means 3 fetches the data of the digit in the table and displays it in the digit set by referring to the plural display information table 14, or displays the data in the row set in the sort index 15. And so on.

The sorting means 4 sorts the data of the corresponding item in the table based on the selected item (or data) when any item is selected on the displayed screen (Fig. 5 will be used later).

The dividing means 5 includes a plurality of display information tables 14
The designated digit information in the digit corresponding to the item designated by is deleted, and the deleted digit information is newly created and set at the designated position (which will be described later with reference to FIG. 6). ).

The integrating means 6 includes a plurality of display information tables 14
The designated digit information in the digit corresponding to the item designated from is deleted, and the deleted digit information is added to the designated digit position (described later with reference to FIG. 6).

The memory 11 stores and reads data and programs. Here, the original data 12, header information 13, plural display information table 14, sort index 15, display buffer 16 are used.
And so on.

The original data 12 is the original data of the table before being displayed. The header information 13 is header information (here, digit information) of the original data in the table before being displayed.

The plural display information table 14 is the original data 1
2 is a table for setting in which digit the data of one or a plurality of digits in the table of 2 is displayed.

The sort index 15 is the original data 12
It is to set in which row the data of the table table is displayed.

The display buffer 16 is for setting data in an image to be displayed on the screen, and is for the display means 3 to display on the screen as shown in the set image.

Next, the concept of the configuration of FIG. 1 will be described. In the table creation, the table creating means 2 creates the multiple display information table 14 by setting in the multiple display information table 14 which digit on the screen the digit of the table of the original data 12 is to be displayed.

For the display of, the display means 3 refers to the sort index 15 to retrieve the data of the set row of the table of the original data 12, and refers to the plural display information table 14 for the retrieved row data. Setting the corresponding digit position is repeated in order, and the display buffer 16 shown
Set as shown in. Then, it is displayed on the screen as set in the set display buffer 16.

At this time, the screen (same as the display buffer 16)
Corresponding to the designation of the designated division of the items displayed above, the designated digit information in the digits corresponding to the designated items from the multiple display information table 14 is deleted and the deleted digit information is placed at the designated position. Newly created and set, the digit data of the table is taken out and displayed at the digit set by referring to the multiple table information table 14.

In addition, corresponding to the designation of integration by designating the items displayed on the screen (same as the display buffer 16), the designated digit information in the digits corresponding to the designated items from the plural display information table 14 Add and set the deleted digit information to the specified existing digit position, retrieve the digit data of the table, and display it in the digit that is set by referring to the multiple table information table 14. There is.

A detailed description will be given below. FIG. 2 shows a flowchart (setting) for explaining the operation of the present invention.

In FIG. 2, S1 is a header part (name,
Set the width and arrangement. For example, as shown in the header information 13 of FIG. 1, this is the header information 1 of the original data 12.
3, name: -width: -arrangement: are set respectively, for example, name "A", width "20 dots", arrangement "right justification" (data is right-justified within a cell width of 20 dots (otherwise, left Align, display in))).

In step S2, the number of lines in the header section is initialized. Set the number of lines to be displayed in the cell of each digit. For example, if the name "B" is displayed in the first row and the name "C" is displayed in the second row, the second digit cell at the top of the display buffer 16 is displayed. Set as 2 lines.

In S3, display data is set in rows and columns.
This sets the data to be displayed in rows and columns (display data), as shown in the original data 12 in FIG.

In step S4, one row of data is read. S5
Retrieves the digit (digit data).

In step S6, information for displaying a plurality of lines is created. This sets the digit data extracted in S5 to the first row (or the second row) in the cell of the digit in the plural display information table 14.

In step S7, it is determined whether there is a next digit. In the case of YES, the process returns to S5 and is repeated for the next digit, and the data of all the digits in one row are set in the plural display information table 14. If NO, the process proceeds to S8.

In step S8, a sort index is created.
This sets the sort index 15 for one line created in S4 to S7 (sets which line of the display buffer 16 the line of the original data 12 is to be displayed in).

In step S9, it is determined whether there is a next line. In the case of YES, the process returns to S4 and the data of the next line (the line next to the original data 12) is read and repeated. In the case of NO, since the processing has been completed for all the rows, the processing ends.

By the above procedure, the original data 12 of FIG.
The multiple display information table 14 and the sort index 15 for displaying multiple lines in the display buffer 16.
(Initially, the row of the table of the original data 12 and the row set and displayed in the display buffer 16 match) are created as shown in the figure, for example. Then, according to the flowchart of FIG. 3 described later, the plural display information table 14 of FIG.
The original data 12 is set as shown in the display buffer 16 of FIG. 1 in accordance with the sorting index 16 and displayed in the same image as that shown in the display buffer 16 on a screen (not shown) (especially, the second cell of the second digit). “B” is displayed on the first line, “C” is displayed on the second line, and the corresponding data is displayed at the corresponding position).

FIG. 3 shows a flowchart (display) for explaining the operation of the present invention. This shows a flowchart in the case of displaying a plurality of data in a cell of a digit according to the plural display information table 14 and the sort index 16 created in FIGS. 2, 5A and 6A.

In FIG. 3, S11 designates the row and column of the cell to be displayed. This specifies the row and column of the cell to be displayed on the screen (display buffer 16 in FIG. 1), for example (row,
Digit) and specify (0.0).

In step S12, the row data is acquired from the sort index 15. This acquires the row data of the row of the cell to be displayed designated in S11 and the row data of the corresponding row of the original data 12 by referring to the sort index 15.

In step S13, the row information in the cell of the digit is acquired from the digit of the table. This is the plural display information table 14 for the digit of the cell to be displayed specified in S11.
Row information of the original data 12 displayed in the cell of the relevant digit (for example, the first row and the second row in the cell of the second digit of the plural display information table 14 of FIG. Line,
Get the line information for displaying the second line).

In step S14, actual data is acquired. This is to obtain the actual data of the row information obtained in S13, for example, in the above example, “789” and “bee” are obtained as the actual data of the first and second rows of the original data 12 of FIG. .

In step S15, it is determined whether the line in the column cell is the end. In the case of YES, since all the actual data of the row in the designated cell to be displayed can be acquired, it is displayed in the cell. In the above example, "789", 2 is displayed in the first row in the cell.
“Bee” is displayed on each line. On the other hand, if NO in S15, the process is repeated for the row in the next cell.

As described above, by repeating the process for displaying cells, the original data 12 is set as shown in the display buffer 16 in accordance with the plural display information table 14 and the sort index 15 shown in FIG.
The same image will be displayed on the screen (not shown).

FIG. 4 shows a display example of the present invention. In the illustrated display, the upper row is the header information 13 of FIG. 1, the data is sequentially displayed in the second and subsequent rows, and the 0th, third, fourth, and fifth digits are for one row of the original data 12, 1, 2, 6, At the digit, two lines of the original data 12 are displayed.

As described above, the plural display information table 14
By setting to and displaying two lines for any item, the length of the table in the horizontal direction can be shortened so that it can be displayed so that it fits within one screen. It becomes possible to easily compare the item data at a glance.

FIG. 5 shows an operation explanatory diagram (sort) of the present invention. This is set, for example, as shown in the sort index 15 of FIG. 1, and the original data 12 and the display buffer 16 are set.
The following is a procedure for specifying and sorting arbitrary items on the screen (display buffer 16) in the state where the lines are arranged in the same order.

FIG. 5A shows a flowchart.
In FIG. 5A, in S21, an item to be sorted is clicked. This is, for example, the display buffer 16 of FIG.
On the screen displayed with the same image based on (the display buffer 16 in FIG. 5B), for example, the mouse cursor is positioned on item C and clicked to specify the item to be sorted.

In S22, an event occurs. S23 is
Get the digits to sort. For example, for the item C on the display buffer 16 of FIG. 1 designated by clicking in S21, the corresponding digit of the original data 12 (here, 2 digit (item C)) is referred to by referring to the plural display information table 14. To get.

In step S24, the ascending order or the descending order is designated. This determines whether the sort is designated ascending or descending.

In step S25, the selected items are sorted to create a sort index. This is the item of the digit of the corresponding original data 12 clicked and designated in S21, and the original data 1 in the ascending or descending order designated in S24.
2 is sorted, for example, by the item C in the above example,
It is created as shown in the sort index 15 of FIG.

When the mouse cursor is positioned on item C on the screen (display buffer 16) and click and ascending order are designated by the above procedure, the sort index 15 of FIG. 1 is changed to the sort index 15 of FIG. 5B. Will be updated. Then, based on the sorted index 15 of FIG. 5B as a result of the sorting, the same setting is made as shown in the display buffer 16 of FIG. The sort result will be displayed as an image.

FIG. 5B shows the state after the item C on the display buffer 16 is specified and the ascending order is sorted in the state of FIG. As a result, even when the data of two rows of the original data 12 is displayed in the cell, it is possible to select and sort one of the two rows of the cell and display the sorted data according to the sorting result.

FIG. 6 shows an operation explanatory diagram (division / integration) of the present invention. This is to divide the item displayed in one cell and display it in another cell or a new cell, and to combine the items displayed in multiple cells into one cell to reduce the number of cells. The procedure for reduction is shown below.

FIG. 6A shows a flowchart.
In FIG. 6A, in S31, it is determined whether the division. This is a division that divides the item displayed in the cell into other cells or creates a new cell and displays it in the cell,
Alternatively, it is determined whether the items displayed in a plurality of cells are integrated into one cell to reduce the number of cells.
In the case of division, the process proceeds to S32. In case of integration, S3
Go to 3.

In S32, since it is determined that the display is divided in S31, the designated plural display information is deleted and new digit information is added. This is because, for example, after once deleting the item in the designated cell indicated by the arrow in (b-1) of FIG. 6 described later ((b-2) of FIG. 6), a new cell is added to the deleted item. Create and add each ((b-
3)).

In S33, since the integration is determined in S31, the designated plural pieces of display information are deleted and added to the existing digit information. This is, for example, (c-!) In FIG. 6 described later.
After once deleting the item in the designated cell indicated by the arrow ((c-2) in FIG. 6), it is added to the existing cell designated for the deleted item ((c-3) in FIG. 6). .

In step S34, a plurality of pieces of display information are regenerated. As a result, the plural display information table 1 after being divided and integrated
4 will be updated. Then, according to the above-described FIG. 3, the table data after the division and integration is displayed on the screen (display buffer 16).

By the above, the screen (display buffer 16)
If you specify an arbitrary item above and instruct to divide / unify, create a new cell for the item specified for division and display the item in that cell, or delete the cell of the item for which integration is specified and delete the existing cell. It becomes possible to display the item inside.

FIG. 6B shows a division example in which the items in the cell are divided into new cells. Part (b-1) of FIG. 6 shows a state in which division of the cells indicated by arrows among the four cells is instructed.

FIG. 6 (b-2) shows a state in which the cell instructed to be deleted is deleted. Part (b-3) of FIG. 6 shows a state in which cells are added, and items designated for division are set and displayed in the cells.

As described above, when the divided cells are designated, the items in the automatically designated cells can be set and displayed in the newly created cells.

FIG. 6C shows an integrated example in which items in a cell are integrated into an existing cell. (C-1) of FIG. 6 shows a state in which, out of the four cells, an instruction to integrate cells indicated by arrows is issued.

FIG. 6C-2 shows a state in which the cells instructed to be integrated are deleted. (C-3) of FIG. 6 shows a state in which the items in the deleted cell are integrated and displayed in the specified cell.

As described above, when the merged cell and the merge destination cell are designated, the items in the designated cell are automatically deleted, and it is possible to display the merged cell in the designated cell.

(Supplementary Note 1) In a computer-readable recording medium in which a display control program for displaying table data is recorded, a plurality of pieces of display information for setting in which digit the data of one or a plurality of digits of the table is to be displayed A computer-readable recording medium recording a program for causing a table to be created and a device for extracting the digit data of the table and displaying the digit at the set digit by referring to the plural display information table.

(Supplementary Note 2) A means for creating a sort index for setting which row the data of the table row is to be displayed in and a method for extracting the row data of the table and referring to the sort index are set. The computer-readable storage medium according to appendix 1, having recorded therein a program for causing it to function as a means for displaying the line.

(Supplementary Note 3) When an arbitrary item is selected on the displayed screen, a means for sorting the data of the corresponding item in the above table based on the item of the selected data, and the above sort. The computer-readable recording medium according to appendix 2, which stores a program for functioning as a means for setting the sort index in the order of the data after the setting and a means for displaying based on the set sort index after the setting.

(Supplementary Note 4) In response to the designation of division by designating the item displayed on the screen, the designated digit information in the digit corresponding to the designated item is deleted from the plural display information table and The computer-readable recording medium according to appendix 1, having recorded therein a program that functions as means for newly creating and setting deleted digit information at a designated position.

(Supplementary Note 5) In response to the designation of integration by designating the item displayed on the screen, the designated digit information in the digit corresponding to the designated item is deleted from the plural display information table and A computer-readable note 1 or note 5 storing a program for causing deleted digit information to be added and set at a designated digit position.
The recording medium described.

(Supplementary Note 6) In a display control program for displaying table data, a means for creating a plural display information table for setting which digit the data of one or a plurality of digits of the table is to be displayed, and the above table. A display control program for causing a computer to function as a means for taking out the digit data and displaying it at the digit set by referring to the plural display information table.

(Supplementary note 7) A method of creating a sort index for setting which row the data of the table row is displayed in, and a method of extracting the data of the row of the table and referring to the sort index are set. The display control program according to appendix 6 for causing a computer to function as means for displaying in a line.

[0082]

As described above, according to the present invention,
Plural display information table 14 and sort index 1
5 is provided to display the original data 12 at any position and the result of sorting by any item, so that multiple items are displayed in any cell so that they can be viewed simultaneously on the screen. In addition to displaying the sorting result of any item, dividing the item in the cell and displaying it in another cell or a new cell, deleting the cell and making the item in the cell inside other existing cells It becomes possible to integrate.

[Brief description of drawings]

FIG. 1 is a system configuration diagram of the present invention.

FIG. 2 is a flowchart (setting) for explaining the operation of the present invention.

FIG. 3 is a flowchart (display) for explaining the operation of the present invention.

FIG. 4 is a display example of the present invention.

FIG. 5 is an operation explanatory diagram (sort) of the present invention.

FIG. 6 is an operation explanatory diagram (division / integration) of the present invention.

[Explanation of symbols]

1: Processor 2: Table creation means 3: Display means 4: Sorting means 5: dividing means 6: Integration means 11: Memory 12: Original data 13: Header information 14: Multiple display information table 15: Sort index 16: Display buffer

Claims (5)

[Claims] 1. A computer-readable recording medium in which a display control program for displaying table data is recorded, and a plurality of display information tables for setting in which digit data of one or a plurality of digits of the table is displayed. A computer-readable recording medium storing a program for creating and a program for extracting the digit data in the table and displaying the digit data by referring to the plural display information table. 2. A means for creating a sort index for setting in which row the data of the row of the table is displayed, and a method of extracting the data of the row of the table and referring to the sort index. The computer-readable storage medium according to claim 1, which stores a program that causes it to function as means for displaying in a row. 3. When any item is selected on the displayed screen, a means for sorting the data of the corresponding item in the table based on the item of the selected data, and after the sorting. The computer-readable recording medium according to claim 2, wherein means for setting the sort index in the order of the rows of the data and a program for functioning as means for displaying based on the set sort index are recorded. 4. The designated digit information in the digit corresponding to the designated item is deleted from the plural display information table in response to the designation of division by designating the item displayed on the screen, and the deletion is performed. The computer-readable recording medium according to claim 1, wherein a computer program is recorded that causes a program to function as means for newly creating and setting digit information at a designated position. 5. A display control program for displaying table data, a means for creating a plurality of display information tables for setting which digit the data of one or more digits of the table are to be displayed, and the digits of the table. A display control program for causing a computer to function as a means for taking out the data of (1) and displaying it in a set digit by referring to the plural display information table.