JP3002011B2 - Display method of table data - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method of displaying tabular data read by a data processing device.

[0002]

2. Description of the Related Art In a data processing device such as a personal computer or a word processor, data described in a table is widely used in various fields such as planning and simulation of a business plan. Usually, rows and columns of a table are numbered for identification. FIG. 10 is an example of a table read on such a data processing device. In this example, each cell in the table is called a cell, and is described using row (R) and column (C) numbers. For example, cell 101
Is described as R2C3.

When a table is read, a comparative reference may be made by paying attention to only some of the items in the table in order to determine the validity of the data or to check the tendency of the data. For example, in the table of FIG. 11 (a), paying attention to products such as refrigerators and washing machines, and examining a sales ratio of each product,
Alternatively, this is the case where sales between manufacturers are compared. For this purpose, the conventional table data display system has a "mask function" for temporarily hiding designated (plural) rows and columns.

The operation of the mask function will be described below with reference to FIGS. 11 (a), 12 (a) and 13 (a). FIG. 11A shows an example of a product-specific sales plan table. In this table, when it is desired to compare and refer to items for each product such as a refrigerator and a washing machine, it is difficult to perform a comparison operation because items for each manufacturer are interposed in this state. Therefore, the above-described mask function is used. For example, in FIG. 11A, when it is desired to compare items for each product, items for each manufacturer are not required. Operation 11
After specifying a range of unnecessary item lines as in 4a to 114d, mask processing is executed to hide these item lines from the screen. This result is shown in FIG. Further, when it is desired to compare the items for each product field in FIG. 12A, the ranges of the operations 121a to 121b are designated in the same manner, and the mask processing is executed again. The result is shown in FIG.
Is shown in If the user wants to restore the hidden item line, a process for redisplay is executed.

[0005]

As described above, in the conventional table data display system, when it is desired to display the table by switching the items to be compared and referenced, the row and column range designation operation is performed as described above. Later, it is necessary to execute the mask function.
However, when the display mode is frequently switched, the mask operation needs to be repeated many times, and there is a problem that the operation becomes complicated. In particular, this problem appears remarkably when the size of the table is large. An object of the present invention is to improve this problem, and it is an object of the present invention to efficiently compare and refer to information described in a table.

[0006]

According to the first aspect of the present invention, there is provided a data processing apparatus having a table data display system, comprising: (a) a hierarchy defining means for defining a row hierarchy and a column hierarchy of a table based on a tree structure; And (b) clause closing means for hiding the lower hierarchy of the row and column specified according to the hierarchical structure of (a), and (c) the row and row specified according to the hierarchical structure of (b). Clause opening means for setting a lower hierarchy of a column to a redisplay state.

The data processing apparatus having the second table data display system according to the present invention comprises: (a) hierarchy definition means for defining a hierarchy of table rows based on a tree structure; Clause closing means for hiding the lower hierarchy of the line designated according to the hierarchical structure of (c), and (c) opening of the clause for redisplaying the lower hierarchy of the line designated according to the hierarchical structure of (a) Means.

Further, the data processing apparatus provided with the third table data display method according to the present invention comprises: (a) a hierarchy definition means for defining a hierarchy of a table column based on a tree structure;
Clause closing means for hiding the lower hierarchy of the column specified according to the hierarchical structure of (c), and (c) opening of the clause for redisplaying the lower hierarchy of the column specified according to the hierarchical structure of (a) Means.

That is, in the first table data display method of the present invention, each of the hierarchy definition means, the clause open means, and the clause close means is divided into row means and column means. The row hierarchy definition means connects a plurality of rows of the table data with directional links, and defines a hierarchical structure (tree structure) related to the rows. FIG. 15 shows a conceptual diagram of an example of this tree structure. Here, the node 151 is called a root. When an arbitrary node is selected, a node adjacent to that node, which is closer to the root, is called a parent (node), and the other nodes are called children (nodes). For example, node 15
The parent of 3a is a node 152a, and the children of the node 152a are a node 153a and a node 153b. A descendant of a certain node refers to a node (other than the root) constituting the subtree in a subtree in which the node is considered as a root. For example, descendants of the node 152a are the nodes 153a, 153b, 154a, and 154b.

On the other hand, the row closing means hides, from the screen, descendant rows of the specified row based on the tree structure. Further, the line opening means redisplays a line of a descendant of the specified line on the screen. Further, the column hierarchy definition unit, the column open unit, and the column close unit perform a process when the unit related to the row is applied to the column.

Further, in the second table data display system of the present invention, only the means of the rows of the first table data display system are used. Further, in the third tabular data display system of the present invention, only the means of the columns of the first tabular data display system are used.

[0012]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram showing an embodiment of a data processing apparatus having a first table data display method according to the present invention, and FIGS. 2 to 8 are processing flowcharts of the table data display method.

In FIG. 1, a control unit 11, a memory 17,
The components 18a to 18d are connected by a bus 18. The memory 17 is composed of a RAM, and includes a table data storage unit 17c for storing the table data itself, and hierarchical data storage units 17a to 17b for storing a hierarchical structure defined for the table data. Table data storage unit 17c
Is read from the disk drive 18c. The data in the hierarchy storage units 17a to 17b is stored in the keyboard 1
8b is set based on the definition information of the hierarchical structure input from 8b. The control unit 11 is composed of a program stored in a ROM or a RAM, and is a layer defining means 1 which is a feature of the present invention.
3, a node opening means 14 and a node closing means 15 are provided. The means 13 to 15 further comprise means 13a, 14a, 15a each of which is a row and means 13b, 14b, 1 of a column.
5b, when the means 13 to 15 are executed, both the row and column means are activated. The row hierarchy definition means 13a defines hierarchy data 17a for connecting a plurality of rows of table data by hierarchy. The row closing unit 15a sets a mask attribute on the row using the hierarchical data 17a. The row opening means 14a cancels the mask attribute set by the row closing means 15a. The column hierarchy definition unit 13b, the column open unit 14b, and the column close unit 15b perform the same process on the column as the row unit. Further, the display means 16 displays only the rows and columns for which the mask attribute is not set on the CRT display 18d.

Each of the above means is activated by the hierarchical data control unit 12 at appropriate times based on control information input from the keyboard 18b. The open / close means 14 and 15 change the display format of the table data, but do not change the table data itself stored in the table data storage unit 17c.

FIG. 2 is a flowchart showing an overall image of the processing procedure. In step 21, the user reads a table as shown in FIG. Next, in step 22a, the user is requested to specify a command to be executed. A step 22b checks the designated command, and if it is an end command, terminates the processing in FIG. If not, the processing from step 22c is started.
Steps 22c to 22e activate command processing from steps 23a, 24a, and 25a, respectively, when the specified command is one of hierarchy definition, open, and close. If not, the process proceeds to step 27 to execute the corresponding command processing. When these command processes are completed, the processes from step 22a are repeated.

Steps 23a to 23b correspond to the hierarchy definition
3 is used to define the hierarchical structure of the table for rows and columns. FIG. 9 shows the contents of the hierarchical data storage section 16a when the hierarchical structure relating to the rows is defined in the table of FIG. 11 (a).

When the hierarchy is expressed as a data structure, a tree structure shown on the left side of FIG. 9 is used. One node of this tree structure corresponds to one row of the table, and each row holds row information shown on the right side of FIG. This row information is managed by a one-dimensional array storing the addresses. For example, the row information of row R5 can be obtained by referring to the memory area indicated by the fifth address in the array.

In the row information 91, a number 93 indicates a parent row number in the tree structure, and a number 94 indicates a child row number. For example, paying attention to the row information of row R5 in FIG.
Since 9 is the parent of the row R5, the row number “9” of the parent is stored in the number 93 of R5. Rows R3 and R4 are R
Since it is a child of 5, the number 94 stores the child numbers “3” and “4”. Further, "-" indicates that the corresponding line number does not exist. The tree structure is described by the data structure storing the row numbers of the parent and child of each row. The display attribute 92 controls the display ON / OFF of a row and is set when the row is opened / closed. Although FIG. 9 shows only the data structure of a row, a similar data structure (column information) is constructed for a column.

FIG. 3 is a flowchart of the row hierarchy definition process 23a. This processing corresponds to the row hierarchy definition means 13a. There are various methods for defining a tree structure. Here, a procedure for defining a parent-child structure as a constituent unit in a top-down manner from the highest hierarchy to the lowest hierarchy will be described. Step 31 asks the user whether to define a row hierarchy. Here, if no is selected, the process of FIG. 3 ends. This is the case when only the column hierarchy is defined. If yes is selected, a request is made to the user in step 32 to designate one row at the top of the tree (root) Rp, and the process in FIG. 4 is started in step 33.

In FIG. 4, a step 41 inquires of the user whether there is a child row candidate. If no is specified here, the process of FIG. 4 ends, and the process returns to the start source process. If yes is specified, the user is requested in step 42 to specify one or more rows of the child Rc of Rp. Steps 43a to 43c perform repetitive control for executing steps 44a to 44e for all designated Rc. Step 44a consists of Rp and Rc
Are connected by a directed link. That is, the line number of Rp is stored in the number 93 of Rc, and the line number of Rc is stored in any of the numbers 94, 95,... Of Rp. Steps 44b-44
e restarts the processing of FIG. 4 by regarding one of Rc as Rp. As described above, the processing in FIG. 4 is nested inside, and the parent-child structure is defined in a top-down manner based on the nesting. The column hierarchy definition process 23b also defines the column tree structure in the same procedure as the row process.

When the hierarchical structure of the table is defined, the table is opened / closed in steps 24a to 24b and steps 25a to 25b. In the present embodiment, four processes of row opening, column opening, row closing, and column closing are prepared. Here, closing a row indicates a process of hiding a row of a descendant of the specified row from the screen. Opening a line refers to a process of redisplaying a line hidden by the above-described closing process on the screen. Opening a column and closing a column are similar to row processing. In addition,
Each process of open / close only sets / cancels data, and the actual screen display is performed by the screen display routine 26 of FIG.
Is performed with reference to the internal data.

The data for controlling the opening / closing of the row is the display attribute 92 shown in FIG. Display attribute 92
Is composed of a display control bit 92b and an opening / closing control bit 92a. These bits are 0 (open / display on) in the initial state. The display control bit 92 holds the display on / off state of the current row. That is, when the value is 0, the line is displayed, and when the value is 1, it is not displayed. The open / close control bit 92a indicates the open / closed state of the current row, that is, the display on / off state of the descendant row. Therefore, when a row is in the closed state, all descendants of the row are in the display-off state.

By the way, the closing process sets the open / close control bit of the specified row to 1 (close) in order to erase the descendants of the specified row from the screen, and sets the display control bits of all descendants of the row to 1 (closed). (Turn off. Hereinafter, the closing process will be described in detail with reference to the flowchart of FIG. FIG. 5 is a flowchart of the row closing process 25a. This processing corresponds to the row closing means 15a. Step 51a requests the user to designate one or more rows Rp to be closed. Here, by omitting the designation of Rp, the row closing process of FIG. 5 can be completed. If Rp is specified, step 52
a Start the following processes. Steps 52a to 52c include:
Repetitive control for executing steps 53a to 53b is performed for all Rp. Step 53a sets the open / close control bit 92a in FIG. 9 to the closed state for one Rp. A step 53b sets the display control bits 92b of all descendants of Rp to the display off state.

As described above, the processing in FIG. 5 only sets the display attributes of the rows, and the actual display is performed by the screen redisplay processing 26. For example, when the row close command is executed in FIG. 11A and the rows 111a to 111d are designated as Rp, FIG.
2 (a) is obtained. 11 and 12 show the state of the display attribute 92 at this time, and the underlined portions in FIG. 12 show changes before and after closing. In this case, step 53 a
111d is set to the closed state, and step 53b sets the descendants of those rows to the display off state. However, the display attributes of the rows 111a to 111d maintain the display ON state. Thus, closing a row affects the display state of its descendants, but does not affect the display state of the row itself.

FIG. 13B shows a case where the row close command is executed in the same manner as in FIG.
Shows the result when specified as. Again, row 112
The descendants a to 112b are in the display-off state, but their lines themselves are in the display-on state.

Here, the open processing is to restore the row to the state before the close processing was performed. That is, the line (only) deleted from the screen by the previous closing process is displayed. Therefore, the open process sets the open / close control bit of the designated row to 0 (open) and sets the display control bit of the descendant to 0 (on).
However, if a descendant has a closed row,
Leave the display state of the descendants of the closed row (to return to the previous state).

Hereinafter, the open process will be described in detail with reference to the flowchart of FIG. 6 is a flowchart of the row open processing 24a. This processing is performed by the row opening means 14
corresponds to a. Step 61a is a process for opening a row R
Asks the user to specify one or more lines of p.
Here, by omitting the designation of Rp, the row open processing in FIG. 6 can be completed. If Rp is designated, the processing of step 62a and thereafter is started. Step 6
2a to 62c are steps 63a to 63c for all Rp.
An iterative control for executing 63b is performed. Step 63
a sets the open / close control bit 92a in FIG. 9 to the open state for one Rp. Step 63b activates the processing in FIG. 7 to set the display state of the descendants of Rp.

In FIG. 7, steps 71 to 72 check the line information 91 in FIG. 9 for Rp. If Rp is a leaf (no descendants) or is in a closed state, the processing in FIG. The process returns to the activation source process. Otherwise, the processing of step 73a and thereafter is started. Step 73a
73c is the same as step 74 for all children Rc of Rp.
It performs repetitive control for executing a to 74e. Step 74a determines the display control bit 92b in FIG. 9 for one Rc.
Is set to the display on state. Steps 74b to 74e
Considers one of Rc as Rp and restarts the process of FIG.

As described above, the processing of FIG. 7 is nested inside, and the descendants of FIG. 6Rp are sequentially set to the display ON state based on the nesting. However, step 7
As shown in FIG. 2, when a closed row is detected, no further nesting is performed, so that if the descendants of Rp are descendants of the closed row at the same time, the display state does not change. 6 and 7, only the display attribute is set, and the actual display is performed by the screen redisplay processing 26. For example, a row open command is executed in FIG.
When 112b is designated as Rp, the process returns to the table of FIG. In this case, step 63a is performed in rows 112a-112b.
Is set to the open state, and step 63b is executed in line 111a.
To 111d are set to the display ON state. But row 11
Since 1a to 111d are closed, their descendants keep the display off state. Thus, opening a row does not affect the display state of descendants of the closed row.
This is to reproduce the display state before the row is closed. To return the state of FIG. 12A to the state of FIG. 11A, the line open command is executed again, and the lines 111a to 111a are executed.
11d is designated as Rp.

On the other hand, the column open processing 24b and the column close processing 25b change the display attribute of a column in the same procedure as that of the row. For example, when the column close command is executed in FIG. 13A and the columns 131a to 131b are designated, the table in FIG. 14 is obtained. When the column open command is executed in FIG. 14 and the columns 141a to 141b are designated, the process returns to the table of FIG.

When the open / close processing is completed, the processing result is displayed on the screen in step 26. FIG. 8 is a flowchart showing the processing procedure for screen display. This processing corresponds to the display means 16 and displays on the screen cells whose rows and columns are both in the display ON state. In step 81a, the display position of the data is set at the upper left corner of the screen, and the line number at the upper end of the screen is set as the parameter i. A step 81b checks the display control bit 92b of the row i, and if the display is on, activates the processing of the step 82a and thereafter. If not, the flow shifts to step 81e to update the row number i, and the processing from step 81b is repeated for a new i. In step 82a, the display position is set to the left end of the screen and the column number at the left end of the screen is set to the parameter j while keeping the position of the row. In step 82b, the display control bit 92b in column j is checked, and if the display is on, the processing in step 82c and thereafter is started. Otherwise, step 82g
And the column number j is updated, and the processing from step 82b is repeated for the new j. Steps 82c to 82d
Checks the display width required to display column j, and if the right margin on the screen satisfies the width, activates the processing of step 82e and thereafter. Otherwise, step 81c
Move to A step 82e displays the data on the memory of the cell indicated by i and j at the display position. A step 82f advances the display position to the next column on the screen. A step 82g updates the column number j and repeats the processing from the step 82b. A step 81c checks whether or not the display position is at the lower end of the screen, and if so, considers that the screen display has been completed and terminates the processing of FIG. Otherwise, after moving the display position to the next line in step 81d, the line number i is updated in step 81e, and the processing from step 81b is repeated.

As described above, when the first table data display method of the present invention is used, the display on / off of the rows and columns can be controlled in accordance with the hierarchical structure defined in the table. This has the effect that comparison and reference can be performed quickly and efficiently. In the present embodiment, an example in which the tree structure is defined for the entire table has been described. However, the same processing result can be obtained when the tree structure is defined only in a part of the table.

In the second table data display system according to the present invention, the means 13b, 14b, 15b and storage unit 17b of FIG. 1, the step 22b of FIG. 2, and the steps 31b, 32b, 33b of FIG. Omitted. That is, only the switching of the table related to the row is performed.

In the third table data display method according to the present invention, the means 13a, 14a, 15 shown in FIG.
a and the storage unit 17a, step 22a in FIG. 2, and steps 31a, 32a and 33a in FIG. 3 are omitted. That is, only the switching of the table related to the row is performed.

[0035]

As described above, according to the table data display method of the present invention, a hierarchical structure of a table represented by a tree structure is defined for each of rows and columns, and the display of rows and columns is turned on according to the hierarchical structure. By introducing a mechanism for controlling the on / off operation, there is an effect that the information described in the table can be compared and referred to quickly and efficiently.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of a data processing apparatus having a first table data display method according to the present invention.

FIG. 2 is a flowchart showing an overall image of a processing procedure.

FIG. 3 is a flowchart showing a row hierarchy definition process.

FIG. 4 is a flowchart illustrating a parent-child row definition process.

FIG. 5 is a flowchart showing a row closing process.

FIG. 6 is a flowchart showing a row open process.

FIG. 7 is a flowchart showing a descendant open process.

FIG. 8 is a flowchart showing a screen redisplay process.

FIG. 9 is an explanatory diagram showing a data structure on a memory.

FIG. 10 is an explanatory diagram showing an example of a table on the data processing device.

FIG. 11 is a diagram of a screen display example showing a sales plan table for each product as an example.

FIG. 12 is a screen display example showing, as an example, a product-specific sales plan table after mask processing;

FIG. 13 is a diagram of a screen display example showing, as an example, a product-specific sales plan table after mask processing is performed again.

FIG. 14 is a diagram showing an example of a screen display when a column closed command is executed, taking as an example a product-specific sales plan table after mask processing again.

FIG. 15 is a conceptual diagram of a tree structure.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 11 Control part 12 Hierarchical data control part 13 Hierarchy definition means 13a Hierarchy definition means of a row 13b Hierarchy definition means of a column 14 Clause opening means 14a Row opening means 14b Column opening means 15 Clause closing means 15a Row closing means 15b Column closing means 16 Display Means 17 Memory 17a Hierarchical data storage unit in row 17b Hierarchical data storage unit in column 17c Table data storage unit 18 Bus 18a CPU 18b Keyboard 18c Disk drive 18d CRT display 91 Line information 92 Line display attribute 92a Open / close control bit 92b Display control bit 93 Pointer to parent row information 94 Pointer to child row information

Claims (3)

(57) [Claims] 1. A data processing apparatus for displaying table data, comprising: (a) a hierarchy definition means for defining a row hierarchy and a column hierarchy of a table based on a tree structure;
Clause closing means for hiding the lower hierarchy of rows and columns specified according to the hierarchical structure of (c), and (c) redisplaying the lower hierarchy of rows and columns specified according to the hierarchical structure of (a) And a section opening means for controlling display / non-display of rows and columns of the table. 2. A data processing device for displaying table data, comprising: (a) a hierarchy definition means for defining a hierarchy of table rows based on a tree structure; and (b) a hierarchy specified in accordance with the hierarchy structure of (a). Clause closing means for hiding the lower hierarchy of the row that has been hidden, and (c) clause opening means for redisplaying the lower hierarchy of the row specified according to the hierarchical structure of (a),
A display method of a table, wherein display / non-display of a row of the table is controlled. 3. A data processing apparatus for displaying table data, comprising: (a) a hierarchy definition means for defining a hierarchy of table columns based on a tree structure; Clause closing means for hiding the lower hierarchy of the column that has been set, and (c) clause opening means for redisplaying the lower hierarchy of the column specified according to the hierarchy structure of (A),
A display method of a table, wherein display / non-display of a column of the table is controlled.