JP4940725B2 - Data display method - Google Patents

Description

  BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a display method for table software used in an information processing apparatus. The present invention relates to a display method that makes it easy to grasp the data contents of software.

  In information processing apparatuses, spreadsheet software that arranges a plurality of display cells on a display screen and inputs data into the display cells is widely used as management software for accounting departments and databases. This table software is, for example, management software driven on the OS of the window system. By listing a plurality of data on the vertical axis y and arranging each item on the horizontal axis X, a plurality of data can be obtained. Is displayed in a list format.

  In these table software, products are listed in “rows” in the y-direction of the vertical axis, and various items such as product codes, quantities, and unit prices are arranged in the “columns” in the x-direction of the horizontal axis. Therefore, if you look in the “row” direction, you can see the product code, quantity, etc. of the product at a glance. You can see at a glance. Furthermore, a calculation formula can be assigned to each “column” or “row” for aggregation, which is very convenient.

  However, this spreadsheet software has a problem that when the data amount of the product increases or the number of items increases, the entire display software cannot be displayed on the display screen. Therefore, in order to display row data and column data with a large amount of data on one screen, the display screen is divided vertically or horizontally, or vertically and horizontally, and each divided area can be scrolled independently. Some display cells that cannot be displayed on one screen can be arranged adjacent to each other.

Japanese Unexamined Patent Publication No. 2000-39967

  According to the conventional example, since the divided areas can be scrolled independently, it is possible to display the divided portion by moving the display cell to be compared with the bag. However, in this type of table software, the list display that arranges the display cells in a matrix form is a factor that is easy for the user to understand, but this is divided into multiple parts and each display area has its own display cell. When moving in the vertical and horizontal directions, there is a problem that it is difficult to understand the whole picture.

  Accordingly, an object of the present invention is to provide a display method of spreadsheet software that can display target data on one screen without impairing the list form.

  In order to achieve the above object, the present invention provides a display software display method in which a plurality of display cells in a matrix are arranged on a display screen and data is input to each display cell. Standard display mode that displays multiple display cells with fixed data name columns and item rows, and data name columns and item rows that are fixedly displayed by arranging multiple display cells in a matrix on the display screen A first display area to be displayed together with the second display area when row or column data of the first display area is selected, and display of the selected row or column data in the second display area A wrapping mode for wrapping and displaying a cell together with an item row or data name column corresponding to the row or column data is selectably provided.

  According to the present invention, in the display method of the spreadsheet software in which a window in which a plurality of matrix display cells are arranged is displayed on the display screen and data is input to each display cell, the data name is displayed in the window. Display a title area, an operation area having a plurality of operation buttons, and a work area for displaying a plurality of matrix display cells, and the plurality of matrix display cells are fixedly displayed on the work area. A standard mode for displaying with a data name column and an item row; a first display area for displaying a data name column and an item row fixedly arranged by arranging a plurality of display cells in a matrix on the work area; When row or column data of one display area is selected, a second display area is created in the work area, and the selected row or column is created in the second display area. To be provided to allow selection of the folded mode for folding display with entry line or data name column corresponding to display cells of column data in the row or column data.

  In this case, the second display area and the first display area are displayed side by side. In addition, the second display area is provided so as to interrupt the selected row or column of the first display area.

  According to the present invention, the selected row or column data can be folded and displayed in the second display area while displaying the first display area that displays the entire arrangement as it is. While maintaining, it is possible to grasp the entire selected target data.

  The table software according to the present invention will be specifically described below with reference to FIGS. In addition, the same site | part, direction, etc. are shown with the same code | symbol, and the overlapping description is abbreviate | omitted.

  First, with reference to FIG. 1 and FIG. 2, a schematic configuration of the spreadsheet software according to this embodiment will be described. FIG. 1 is a typical display screen diagram, and FIG. 2 is a device configuration diagram of an information processing apparatus in which the spreadsheet software is installed.

  In FIG. 2, the spreadsheet software can be installed on an extremely general personal computer. FIG. 2 is a block diagram showing an example of a personal computer that can operate by installing the spreadsheet software. This personal computer is composed of a control unit 1 for overall control of the personal computer, a display device 2, a keyboard 3, a mouse 4, a storage device 5 for storing various data, a printer 6, and a communication device connected to an external network. The

  The personal computer according to this embodiment can operate various software on the OS of the window system. This table software can be installed via a recording medium such as a CD or a DVD or the Internet connected via the communication device 7.

  The table software is stored in the storage device 5 when it is installed, as is the case with extremely general software. And this table software can be started up by the same method as a very general software in the state which started the personal computer on the window system.

  When the table software is selected, the control unit 1 is called from the storage device 5 and is driven on the memory in the control unit 1, and as shown in FIG. A window 100 capable of displaying the list 107 arranged in a matrix is displayed on the display screen of the display device 2.

  The window 100 includes a title area 101 arranged at the top, an operation area 102 including various operation buttons 104, and a work area 103 displaying a list 107. In this embodiment, the title area 101 is disposed at the top, the operation area 102 is disposed below the title area 101, and the work area 103 is disposed below the title area 101. However, the present invention is not limited to this arrangement.

  In this embodiment, by selecting the operation button 104 arranged in the operation area 102 with the mouse 4 or the keyboard 3, the data created previously from the storage device 5 is called and displayed in the work area 103. And new data can be created.

  One of the major features of this embodiment is that a plurality of display modes are provided, and various display methods can be selected by selecting the display modes.

  That is, the window 200 shown in FIG. 6B is a standard for displaying the list 107 in which the items created by the user are arranged as they are in the horizontal axis X direction and the data is arranged in the vertical axis Y direction over the entire work area 103. An example of the mode screen is shown.

  On the other hand, FIG. 5A shows that the work area 103 is divided into a first area 105 and a second area 106, the standard mode list 107 is displayed in the first area 105, and the second area 106 is The screen example in which the return mode 1 which displays the return list 108 of all the data of the column or row selected by the list 107 of a standard mode is selected is shown.

  In this embodiment, when the folding mode 1 is selected via the operation button in the operation area 102, a row or a column is selected from the state of the standard mode in (b) (a) the folding mode shown in FIG. 1 can be transferred.

  The table software according to the present embodiment will be described in detail below with reference to the screen examples shown in FIGS. 1 and 3 to 7 based on the operation flow diagram of FIG.

  First, when the table software is selected via a startup icon (not shown) on a display screen of a personal computer launched on the window system, the control unit 1 launches a program from the storage device 5 and displays the display device 2. A window according to the present embodiment is displayed on the display screen (step 51). In this window, an untitled title area 101 and an operation area 102 are displayed, and nothing is displayed in the work area 103. As shown in FIG. 1B by calling the previously created data stored in the storage device 5 via the operation button 104 in the operation area 102 or by selecting new creation. The previously created data or a matrix-like table with no data is displayed. In this embodiment, since the standard mode is set as the initial setting, various lists 107 can be created in this standard mode.

  In the following description, the description will be made from a state in which a list as shown in FIG. 1B is created or data created earlier is called.

  The control unit 1 monitors whether or not the folding mode 1 is selected via the operation button 104 in the operation area 102 in the state shown in FIG. 1B (step 52). If the loopback mode 1 is not selected, normal processing for initialization is executed (step 53). In this embodiment, if the stored data is stored in the storage device 5 in the state of the folding mode 1, the folding mode 1 becomes the initial setting value when the stored data is called.

  On the other hand, when the folding mode 1 is selected, it is monitored whether or not a row or column is selected (step 54) and whether or not a data area is selected (step 57).

  In step 54, when a row or column is selected, a second display area 106 is created (step 55), and a loopback list 108 of all data in the selected row or column is displayed in the second display area 106. Display (step 56).

  That is, in the standard mode shown in FIG. 1B, the data from x1 to x20 are arranged and displayed in order in the vertical Y direction, and the items from y1 to y20 are arranged in order in the horizontal X direction. In this embodiment, a scroll bar 109 for scrolling the list 107 in the X-axis direction is arranged below the work area 103, and a scroll bar 110 for scrolling the list in the Y-axis direction is arranged at the right end of the work area 103. Be placed. In addition, the data name column 111 is fixedly displayed on the left side of the list 107, and the item row 112 is fixedly displayed on the top of the list.

  When the “x5” row 111 a is selected from the state shown in FIG. 5B, the control unit 1 displays the second display area 106 below the work area 103 as shown in FIG. Created and displayed, and displays all the data in the row 111a of “x5” as a loopback list 108. (A) In the example of the figure, since there are items y1 to y20 in the horizontal axis X direction, the control unit 1 displays the item rows 112 of y1 to y20 and the display cells of x5 in the second display area 106. . In this display, the control unit 1 arranges the y1 to y20 in order from the left with respect to the length of the second display area 106 in the X-axis direction. It is folded and displayed in order from the left in the second row. In the example of FIG. (A), y1 to y20 are displayed in two rows, but if there are more items, they are displayed in three rows and four rows.

  On the other hand, when the column “y5” 112a is selected in the state of FIG. 1B, the control unit 1 creates and displays the second display area 106 below the work area 103, as shown in FIG. Then, all the data in the column 112a of “y5” is displayed as the loopback list 113. In the example of FIG. 4, since there is data from x1 to x20 in the vertical Y direction, the control unit 1 displays the data columns 111 and x5 from x1 to x20 in the second display area 106. In this display, the control unit 1 arranges the x1 to x20 in order from the left with respect to the length of the second display area 106 in the X-axis direction. It is folded and displayed in order from the left in the second row. In the example of FIG. 4, x1 to x20 are displayed in two rows, but if there are more items, they are displayed in three rows and four rows.

Next, when the display cell 107a that is the data area is selected in step 56 of FIG. 3, the list 107 is displayed so that the selected display cell 107a is displayed at the center of the work display area 103 or the first display area 105. Is scrolled (step 58). Then, an input in the selected display cell 107a is accepted (step 59).
For example, in FIG. 1A, when the display cell 107a that is the data area is selected, the control unit 1 scrolls the display cell 107a to the center of the first display area 105 as shown in FIG. indicate. On the other hand, in the second display area 105, a list 108 of all data corresponding to the row of the data name corresponding to 107a is displayed. Note that column data can be displayed in the second display area 105 by an operation in the operation area 102.

  In the example shown in FIG. 5, since a row or column is selected, it is displayed on the display screen 100 divided into two, but the display cell 107a is selected in the state shown in FIG. Then, the display cell 107a is displayed in the center in the state shown in FIG.

  Returning to FIG. 3, in this embodiment, the above-described operation is repeated until the spreadsheet software is turned off (step 60).

  Thus, in this embodiment, since the normal standard mode and the folding mode 1 can be selected and displayed, the table form can be selected according to the purpose of the user. Moreover, if the folding mode 1 is selected, the selected row or column data can be folded and displayed in the second display area 106 while displaying the first display area 105 that displays the entire arrangement as it is. The entire selected target data can be grasped in the form of the list 108 while maintaining the display form of the list 107.

  Furthermore, in this embodiment, by selecting the display cell 107a in the folding mode 1, the display cell 107a can be automatically displayed at the center of the screen, so that input and correction are easy.

  In this embodiment, whether or not the display cell 107a is arranged in the center can be set by operating the operation area 102.

  Next, the display screen in the folding mode 2 will be described with reference to FIGS. This folding mode 2 can be selected in place of the folding mode 1 in the setting of the operation area 102, and the operation flow is the same as that shown in FIG.

  In the folding mode 2, when the row 111a of “x5” is selected from the state shown in FIG. 1B, the control unit 1 selects “ The second display area 114 is created and displayed so as to interrupt the area of the row 111a of “x5”, and all the data of the row 111a of “x5” is displayed as the loopback list 108. In the example of FIG. 6, since there are items y1 to y20 in the horizontal axis X direction, the control unit 1 displays the item rows 112 and x5 display cells of y1 to y20 in the second display area 114. In this display, the control unit 1 displays the item arrangement in the horizontal axis X direction in accordance with the item row 112. Then, it is folded from the item y11 and displayed in the second row. In the example of FIG. 6, y1 to y20 are displayed in two rows, but if there are more items, they are displayed in three rows and four rows.

  On the other hand, when the “y5” column 112a is selected in FIG. 1B, the control unit 1 moves to the area of the selected “y5” column 112a in the list 107 as shown in FIG. 2 is created and displayed so as to interrupt the display area 115, and all data in the column 112 a of “y5” is displayed as a loopback list 108. In the example of FIG. 7, since there is data x1 to x20 in the vertical axis y direction, the control unit 1 displays the data name column 111 and x5 display cells x1 to x20 in the second display area 115. For this display, the control unit 1 displays the arrangement of data names in the Y-axis direction along the data name column 111. Then, it is folded from the item of x11 and displayed in the second column. In the example of FIG. 7, x1 to x20 are displayed in two columns, but if there are more items, they are displayed as three columns and four columns.

  In the above embodiment, the table software has been described as an example. However, if the data is displayed as a matrix table, the same effect can be obtained even if the data is displayed by other software. It is done.

It is a typical display screen figure of the spreadsheet software which concerns on this invention. It is a block diagram of an information processing apparatus in which spreadsheet software according to the present invention is installed. It is an operation | movement flowchart of the spreadsheet software which concerns on this invention. It is a typical display screen figure of the spreadsheet software which concerns on this invention. It is a display screen figure of the spreadsheet software which concerns on this invention. It is a display screen figure of the spreadsheet software which concerns on this invention. It is a display screen figure of the spreadsheet software which concerns on this invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Control part, 2 ... Display apparatus, 3 ... Keyboard, 4 ... Mouse, 5 ... Memory | storage device, 6 ... Printer, 7 ... Communication apparatus, 101 ... Title area, 102 ... Operation area, 103 ... Work area, 104 ... Operation Button 105 ... First area 106 106 Second area 107 ... List table 107a ... Display cell ... Wrapping list 108 Data name column 111, row 111a, item row 112, column 112a, ... window 100, ... window 200.

Claims (6)

In a data display method of arranging a plurality of matrix-like display cells on a display screen and displaying or inputting data in each display cell,
A standard mode for displaying a plurality of display cells in a matrix form on a display screen together with a fixed data name column and an item row ;
When a first display area to be displayed together with a data name column and an item row fixedly arranged by arranging a plurality of display cells in a matrix form on the display screen, and a row or column data in the first display area are selected A second display area is created, and a wrapping mode is selected in which a display cell of the selected row or column data is displayed together with an item row or data name column corresponding to the row or column data in the second display area. A data display method characterized by being provided. In a data display method for displaying a window in which a plurality of matrix display cells are arranged on a display screen and displaying or inputting data in each display cell,
A title area for displaying a data name in the window; an operation area having a plurality of operation buttons; and a work area for displaying a plurality of display cells in a matrix form.
A standard mode for displaying a plurality of display cells in a matrix form on the work area together with a fixedly displayed data name column and item rows ;
When a first display area to be displayed together with a data name column and an item row fixedly arranged by arranging a plurality of display cells in a matrix form on the work area, and a row or column data of the first display area are selected A second display area is created in the work area, and the display cell of the selected row or column data is displayed in the second display area together with the item row or data name column corresponding to the row or column data. A data display method characterized in that a loopback mode is selectable. In the display method according to claim 1 or 2,
The data display method, wherein the second display area is arranged side by side with the first display area. In the data display method according to claim 1 or 2,
The data display method, wherein the second display area is arranged in a format that interrupts the area of the selected row or column data. In one data display method in any one of Claims 1-4,
A centering mode for displaying the selected display cell at the center of the first display area when a plurality of display cells in the matrix form are selected ;
A data display method comprising displaying all display cells in a row or column of the selected display cell together with an item row or a data name column in the second display area . The data display method according to claim 5, wherein
The centering mode can be displayed so as to be selectable. A data display method, wherein:

Images