JP4043329B2 - Table display method, display system, and computer program - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a table display method in a spreadsheet application or a WWW browser operating on a personal computer or a PDA.
[0002]
[Prior art]
FIG. 14 is a diagram showing an example of a conventional table display, and FIG. 15 is a diagram showing an example of a table display on a PDA when a heading portion is fixed.
[0003]
A heading portion of a table displayed by a spreadsheet application or a WWW browser, for example, a row or a column in which a field name or a record ID is stored is usually above or to the left of the table as shown in FIG. Is provided. Therefore, in order to refer to the data stored in the lower or right cell of the table, it is necessary to scroll the window. Then, as shown in FIG. 14B, the heading portion becomes invisible, so that the user cannot understand what the data of each cell means, or misreads the data depending on intuition. There is.
[0004]
Therefore, for example, as described in Japanese Patent Application Laid-Open No. 2000-293154, a method has been proposed in which a column corresponding to the heading portion is fixed so that the column is always displayed even if the window is scrolled. Yes.
[0005]
[Patent Document 1]
JP-A-2000-293154 [0006]
[Problems to be solved by the invention]
However, if the heading portion is fixed, the scrollable area in the table is narrowed, so that it may be difficult to see the table or the operability may deteriorate. In particular, when the display area is narrow, such as a PDA or a notebook personal computer of B5 size or smaller, if the heading portion MZ is fixed as shown in FIG. 15, the data display area DZ becomes remarkably narrow and difficult to use.
[0007]
In addition, when displaying a table on a high-resolution display having a resolution of XGA or higher, even if the heading part is displayed, if the heading part is separated from the cell that the user wants to refer to, the data is misread. May end up. This problem cannot be solved even by using a method of fixing a column corresponding to the heading part.
[0008]
The present invention has been made in view of such problems, and it is an object of the present invention to make it easier for a user to see a table than before.
[0009]
[Means for Solving the Problems]
Display system table according to the present invention includes storage means for storing the data of each cell constituting a table, a table display means for displaying all or part of the table, the user of Rousset Le is displayed Determining means for determining at least one of a row and a column to which the cell specified by the cell belongs, and cell information relating to the row or column to which the determined cell belongs is based on data of any cell belonging to the row or column. Cell information display means for displaying, and selection means for selecting any row or column of the table, wherein the cell information display means is determined when a row is selected by the selection means. Displays the cell information based on the data of the cell located at the intersection of the column to which the cell belongs and the row, and if a column is selected, is located at the intersection of the row to which the identified cell belongs and the column Displaying the cell information based on the data of that cell.
[0010]
Preferably, the cell information display means displays the cell information of the determined cell by pop-up at or near the position of the cell.
[0011]
Alternatively, the selection unit selects one of the rows in association with each row of the table, or selects one of the columns in association with each of the columns of the table, and the cell information display unit When a row is selected by the selection unit, the cell is based on data of a cell located at an intersection of a column to which the determined cell belongs and a row associated with the row to which the cell belongs by the selection unit. Display information, and if a column is selected, the cell based on the data of the cell located at the intersection of the row to which the determined cell belongs and the column associated with the column to which the cell belongs by the selection means Display information.
[0012]
DETAILED DESCRIPTION OF THE INVENTION
1 is a diagram showing the appearance of the display system 1, FIG. 2 is a diagram showing a hardware configuration of the display system 1, FIG. 3 is a diagram showing a functional configuration of the display system 1, and FIG. 4 is an example of a configuration of a table TL. FIG. 5 is a diagram illustrating an example of the window WN in an initial state, FIG. 6 is a diagram illustrating an example of the window WN when scrolling, and FIG. 7 is a flowchart illustrating an example of a flow of processing for pop-up display setting. 8 is a diagram showing an example of the setting information 71, FIG. 9 is a flowchart for explaining the processing flow of the display system 1, and FIGS. 10 to 13 are diagrams showing examples of pop-up display.
[0013]
The display system 1 in FIG. 1 is a system for displaying a table as shown in FIG. 5 or 6. As the display system 1, for example, a personal computer, a workstation, or a PDA (Personal Digital Assistant) is used.
[0014]
As shown in FIG. 2, the display system 1 includes a CPU 10a, a RAM 10b, a ROM 10c, a magnetic storage device 10d, a display device 10e, an input device 10f such as a mouse and a keyboard, and various interfaces such as a communication interface 10g. The
[0015]
The magnetic storage device 10d stores an operating system (OS), a table management program for displaying a table to be described later, table data HDT, and the like. The table data HDT is for defining a table, and includes, for example, a numerical value or a character string stored in each cell (cell) constituting the table. A mathematical expression or function such as “= C2 + C3” or “= SUM (D2: D9)” may be included. These programs and data are loaded into the RAM 10b as necessary, and the programs are executed by the CPU 10a.
[0016]
As the OS, for example, an OS adopting a GUI (Graphical User Interface) environment such as UNIX (registered trademark) having Windows (registered trademark), MacOS (registered trademark), or X Window System is used. According to these OSs, it is possible to manage information on the position of the mouse cursor (mouse pointer), that is, information on coordinates on the desktop or in the window, information on the size and position of the window, information on scrolling the window, and the like. These pieces of information can be given to the table management program.
[0017]
The table management program is spreadsheet software (application) that can be executed on any of the OSs described above. Alternatively, it may be a plug-in of a WWW browser that operates on any of the OSs described above. In the former case, a file having a format corresponding to the spreadsheet software is used as the table data HDT. Alternatively, a standard format file such as CSV (Comma Separated Value) may be used. In the latter case, a file or the like described in HTML (Hypertext Markup Language) or Java (registered trademark) is used as the table data HDT.
[0018]
With this configuration, the display system 1 includes a table data acquisition unit 101, a table definition unit 102, a table display unit 103, a cell determination unit 104, a pop-up setting unit 105, a pop-up display unit 106, as shown in FIG. Functions such as the mouse position monitoring unit 107 and the scroll monitoring unit 108 are realized.
[0019]
The table data acquisition unit 101 acquires the table data HDT by downloading it from a Web server on the Internet. Alternatively, a file created by a user of the display system 1 using spreadsheet software is acquired as table data HDT.
[0020]
The table definition unit 102 defines a table TL (table) as shown in FIG. 4 based on the acquired table data HDT. Specifically, the definition of what value is stored in each cell and the position (coordinate) of each cell when a predetermined position (for example, the upper left corner) of the table TL is used as a reference coordinate Define. For example, when the data of the cell “C27” is a function “= SUM (C2: C26)”, the total value of the values of each cell from “C2” to “C27” is obtained to obtain “C27”. Define the stored value. In addition, when the table data HDT contains information about the format, it is related to the background color, the thickness or type of ruled lines, or the size, typeface, position (such as right alignment or centering) of each cell, or color. Define.
[0021]
The table display unit 103 performs processing for displaying (outputting) the table TL (table) defined by the table definition unit 102 as shown in FIG. 4 as shown in FIG. When the size of the table is larger than the window WN, in the initial state, as shown in FIG. 5, the table TL is displayed so that the upper left corner is positioned near the upper left corner of the display area HR of the window WN. When the user wants to refer to the right side or the lower side of the table TL, the user can operate the scroll buttons SN1 to SN4 or the scroll bars SB1 and SB2 with the mouse to scroll the window WN. At this time, the table display unit 103 acquires information indicating the scroll amount from the scroll monitoring unit 108, determines the display range of the table TL based on the information, and displays the table TL as shown in FIG. 6, for example. .
[0022]
The cell discriminating unit 104 discriminates to which row and column of the table TL the cell pointed (pointed) by the mouse cursor MC belongs. That is, information indicating the position of the mouse cursor MC in the window WN and the amount of scrolling of the window WN is acquired from the mouse position monitoring unit 107 and the scroll monitoring unit 108, respectively. Find out if you are pointing to the position. Then, it is determined to which row and column the cell at the position pointed to by the mouse cursor MC belongs. Hereinafter, a cell pointed by the mouse cursor MC is referred to as a “target cell”.
[0023]
As shown in FIG. 6, the pop-up display unit 106 displays cell information 70 regarding the cell pointed by the mouse cursor MC (that is, the cell determined by the cell determination unit 104) as a pop-up PU. Hereinafter, displaying information by a pop-up PU is referred to as “pop-up display”. The pop-up display process is performed based on the setting by the pop-up setting unit 105.
[0024]
The pop-up setting unit 105 performs settings regarding what kind of content is displayed on the pop-up PU. This setting is performed based on whether or not the check boxes CR1, CR2,... Provided in the window WN shown in FIG.
[0025]
The check boxes CR1, CR2,... Correspond to the first column, the second column,. Check boxes CG1, CG2,... Correspond to the first row, the second row,. When viewing the table TL, the user selects a column (item, column) or row (item name or record) that he / she wants to particularly refer to, and checks a check box corresponding to it.
[0026]
For example, when the check box CR2 is checked as shown in FIG. 5, the pop-up setting unit 105 selects the second column of the table TL, and the information stored in this column, that is, the department name is pop-up displayed. Set as follows. At this time, the pop-up display unit 106 searches for cells in the same row as the row to which the cell of interest belongs among the cells belonging to the second column, and displays the information (part name) stored in this cell as shown in FIG. Is displayed on the pop-up PU. Similarly, when the check box CR1 is checked, the first column is selected, and the information stored in this column, that is, the value of the department code is set to pop up. At this time, the pop-up display unit 106 searches for cells in the same row as the row to which the cell of interest belongs among the cells belonging to the first column, and pops up the information (department code) stored in this cell.
[0027]
Further, for example, in FIG. 5, when the check box CG1 is checked, the pop-up setting unit 105 selects the first row of the table TL and stores the information stored in this row, that is, the item name (field name). Set so that pops up. At this time, the pop-up display unit 106 searches for cells in the same column as the column to which the cell of interest belongs among the cells belonging to the first row, and pops up the information (item name) stored in this cell. For example, in the case of the attention cell illustrated in FIG. 6, “July sales record” is displayed on the pop-up PU.
[0028]
That is, when an arbitrary row is selected by the pop-up setting unit 105, the information stored in the cell located at the intersection of this row and the column to which the target cell belongs is pop-up displayed. When an arbitrary column is selected, information stored in a cell located at the intersection of this column and the row to which the target cell belongs is displayed.
[0029]
Next, an application example of pop-up setting will be described with reference to FIG. When the check boxes of a plurality of columns, for example, the check boxes CR1 and CR2 are checked, both the department code and the department name are set to pop up. Thus, for example, when any cell in the seventh row is pointed by the mouse cursor, as shown in FIG. 10, “1006: Sixth sales office” pops up, and any cell in the tenth row points to Then, “1009: Ninth sales office” is pop-up displayed. Each value is separated by a symbol such as “:”.
[0030]
When the check boxes of a plurality of rows, for example, the check boxes CG1 and CG27 are checked, both the item name (field name) and the total are set to pop up. Thus, for example, when any cell in the fifth column is pointed out, a pop-up display of “May sale schedule: 68, 240” is displayed as shown in FIG.
[0031]
When both the row and the column are checked, for example, when the check boxes CG1, CR1, and CR2 are checked, the item name (field name), the department code, and the department name are set to pop up. . Thus, for example, when the cell in the 25th row and the 9th column is pointed out, as shown in FIG. 12, “July sale schedule / 1024: 24th sale place” is popped up. The row value and the column value are separated by a symbol such as “/”.
[0032]
It is also possible to set different pop-up display settings for each column.
For example, when the cell in the second column is pointed out, the information in the eighth column is displayed in a pop-up, and when the cell in the seventh column is pointed out, the information in the first and fourth columns is set in a pop-up display. be able to. Such setting is performed according to the procedure shown in the flowchart of FIG.
[0033]
First, the window WN in FIG. 5 is scrolled so that the second column is displayed. The mouse cursor is moved to an arbitrary position in the second column, and an action other than a click, for example, right click or double click is performed. As a result, the second column is designated, and the color of the check box CR2 in the second column is changed to a light color such as gray (# 211). Alternatively, an item for designating a column (for example, a menu for pulling down the column name or field name of each column of the table TL) may be provided, and designation may be performed using this.
[0034]
The window WN is scrolled so that the check box CR8 in the eighth column is displayed. Then, the check box CR8 is checked (# 212). Thereby, the setting for the second column is completed. The same procedure is repeated (Yes in # 213), the seventh column is specified (# 211), the check boxes CR1 and CR4 in the first column and the fourth column are checked (# 212), and the seventh column is checked. Make settings for the eyes.
[0035]
When any cell belonging to the seventh column (for example, the seventh row and the seventh column) is pointed in such a state, the first column (department code) and the fourth column are shown in FIG. Information regarding the eyes (April sales results) is displayed in a pop-up. Similarly, when any cell in the second column is pointed out, information on the eighth column (June sales performance) is displayed in a pop-up manner.
[0036]
Further, by performing such setting, setting information 71 as shown in FIG. 8A is generated. The column names “second column” and “seventh column” in the first column (first from the left) of the setting information 71 are the columns specified in step # 211 of FIG. 7 in the table TL of FIG. (Setting column). “1”, “2”,..., “11” in the first line (first row) of the setting information 71 also indicate column names of the table TL. The symbol “◯” indicates that the column is designated as a display column in step # 212 of FIG. For example, the ninth “◯” from the left in the second row of the setting information 71 is set so that the information in the eighth column of the table TL pops up when the second column of the table TL is pointed Means. The symbol “x” indicates that the column is not designated as a display column in step # 212 in FIG.
[0037]
Therefore, according to the setting information 71, when any cell in the second column of the table TL is pointed, the information in the eighth column is popped up, and when any cell in the seventh column is pointed, 1 is displayed. It can be seen that the settings are made so that the information in the columns and the fourth column is displayed in a pop-up manner. Since the setting information 71 is not set for columns other than the second and eighth columns of the table TL, pop-up display is not performed even if a cell belonging to these columns is pointed.
[0038]
Instead of FIG. 8A, setting information 71B indicating display / non-display of all the columns of the table TL may be generated as shown in FIG. 8B. Setting information 71 </ b> C indicating only the location where “◯” is set may be generated as shown in FIG. In addition, the same setting as that described above is possible for the rows of the table TL.
[0039]
Next, the flow of processing of the display system 1 in the present embodiment will be described with reference to the flowchart of FIG. The table data HDT is acquired from a Web server on the Internet (# 11). If there is setting information for pop-up display, the setting information is also acquired (# 12). A table TL as shown in FIG. 4 is defined based on the acquired table data HDT and the like, and a screen (window WN) of the table TL is displayed as shown in FIG. 5 (# 13).
[0040]
The position of the mouse cursor is acquired (# 14). If the mouse cursor is located inside the window WN and outside the table TL (that is, a setting area with a check box) (Yes in # 15), check the check boxes CR1, CR2,... And check boxes CG1, CG2,. Accepts input. Then, based on the presence / absence of the check, the pop-up display setting process is performed (# 21). Such processing is performed, for example, according to the procedure shown in FIG.
[0041]
If the mouse cursor is located in the area inside the table TL (Yes in # 16), it is determined which cell the mouse cursor points to (# 17). If the pop-up display is set (Yes in # 18), the pop-up display is performed on or near the determined cell (# 19). The processes in steps # 14 to # 19 are repeated as appropriate as long as the window WN continues to be displayed (No in # 20). The pop-up displayed in step # 19 may be closed after a certain time (for example, 5 to 10 seconds) has elapsed or when the mouse cursor is moved again.
[0042]
According to this embodiment, even a large-sized table that needs to be displayed across a plurality of screens can be displayed in a manner that is easy for the user to view without fixing the row or column corresponding to the heading portion. it can. In addition, since information is displayed by pop-up near the pointed cell, it can be confirmed quickly and easily. As described with reference to FIGS. 7 and 8, by setting different pop-up display for each column or row of the table, the pop-up display can be used efficiently to make the table easier to see.
[0043]
In this embodiment, when a cell is pointed, information is displayed using a pop-up. However, an area about the same size as the pop-up may be provided at the end of the window and displayed here.
[0044]
The pop-up display is performed when the cell is pointed by the mouse cursor, but may be performed when the cell is pointed by the character cursor or the cell pointer (cell cursor indicating the active cell). Or you may make it perform when the part by which the cell of the display surface of a display apparatus is displayed is touched with the light pen or the finger.
[0045]
In addition, the configuration of the entire display system 1 or each unit, the configuration and content of the table TL or the window WN, the processing content, the processing order, and the like can be appropriately changed in accordance with the spirit of the present invention.
(Appendix 1) A display method of a table in a computer,
Store the data of each cell constituting the table in a storage device,
Displaying all or part of the table on a display device;
Determining at least one of a row and a column to which a cell designated by a user among cells displayed on the display device belongs;
Displaying information on the row or column to which the determined cell belongs on the display device based on data of any cell belonging to the row or column, and executing by a computer
A table display method characterized by the above.
(Supplementary Note 2) Storage means for storing data of each cell constituting the table;
Table display means for displaying all or part of the table;
A discriminating means for discriminating at least one of a row and a column to which a cell specified by a user among displayed cells belongs;
Cell information display means for displaying cell information related to the row or column to which the determined cell belongs based on data of any cell belonging to the row or column;
A table display system characterized by comprising:
(Supplementary note 3) having a selection means for selecting any row or column in the table,
The cell information display means displays the cell information based on the data of the cell located at the intersection of the column to which the determined cell belongs and the row when the row is selected by the selection means. When selected, the cell information is displayed based on the data of the cell located at the intersection of the row to which the determined cell belongs and the column,
The display system according to attachment 2.
(Appendix 4) The cell information display means displays the cell information of the determined cell by pop-up at or near the position of the cell.
The display system according to Supplementary Note 2 or Supplementary Note 3.
(Supplementary Note 5) The selection means selects any row in association with each row of the table, or selects any column in association with each column in the table,
The cell information display means, when a row is selected by the selection means, based on the data of the cell located at the intersection of the column to which the determined cell belongs and the row associated with the row to which the cell belongs. The cell information is displayed. When a column is selected, the cell information is determined based on data of a cell located at the intersection of a row to which the determined cell belongs and a column associated with the column to which the cell belongs. indicate,
The display system according to appendix 3 or appendix 4.
(Supplementary note 6) A computer program for use in a computer having storage means for storing data of each cell constituting a table and displaying the table,
Processing to display all or part of the table on a display device;
A process of determining at least one of a row and a column to which a cell specified by a user among cells displayed on the display device belongs;
A process for displaying information on the row or column to which the determined cell belongs on the display device based on data of any cell belonging to the row or column;
A computer program for causing a computer to execute.
[0046]
【The invention's effect】
According to the present invention, it is possible to make the table easier to see for the user than before. According to the fourth aspect of the present invention, the field name of the cell to be referred to can be displayed in a place where it can be easily and easily confirmed by the user.
[Brief description of the drawings]
FIG. 1 is a diagram illustrating an appearance of a display system.
FIG. 2 is a diagram illustrating a hardware configuration of a display system.
FIG. 3 is a diagram showing a functional configuration of a display system.
FIG. 4 is a diagram illustrating an example of a configuration of a table.
FIG. 5 is a diagram illustrating an example of a window in an initial state.
FIG. 6 is a diagram illustrating an example of a window when scrolling.
FIG. 7 is a flowchart illustrating an example of a flow of processing for pop-up display setting.
FIG. 8 is a diagram illustrating an example of setting information.
FIG. 9 is a flowchart illustrating a processing flow of the display system.
FIG. 10 is a diagram illustrating an example of a pop-up display.
FIG. 11 is a diagram illustrating an example of a pop-up display.
FIG. 12 is a diagram illustrating an example of a pop-up display.
FIG. 13 is a diagram illustrating an example of a pop-up display.
FIG. 14 is a diagram showing an example of a conventional table display.
FIG. 15 is a diagram showing an example of display of a table in a PDA when a heading portion is fixed.
[Explanation of symbols]
1 Display system 10d Magnetic storage device (storage device, storage means)
10e Display device (display device)
103 Table display section (table display means)
104 Cell discrimination unit (discrimination means)
106 Pop-up display (cell information display means)
105 Pop-up setting section (selection means)

Claims (5)

Storage means for storing data of each cell constituting the table;
Table display means for displaying all or part of the table;
A discriminating means for discriminating at least one of a row and a column to which a cell specified by a user among displayed cells belongs;
Cell information display means for displaying cell information related to the row or column to which the determined cell belongs based on data of any cell belonging to the row or column;
Selecting means for selecting any row or column of the table,
The cell information display means displays the cell information based on the data of the cell located at the intersection of the column to which the determined cell belongs and the row when the row is selected by the selection means. When selected, the cell information is displayed based on the data of the cell located at the intersection of the row to which the determined cell belongs and the column,
Table display system characterized by that. The cell information display means displays the cell information of the determined cell by pop-up at or near the position of the cell.
The display system according to claim 1. The selection means selects any row in association with each row of the table, or selects any column in association with each column in the table,
The cell information display means, when a row is selected by the selection means, the cell located at the intersection of the column to which the determined cell belongs and the row associated with the row to which the cell belongs by the selection means. The cell information is displayed based on the data, and when a column is selected, the cell located at the intersection of the row to which the determined cell belongs and the column associated with the column to which the cell belongs by the selection means. Displaying the cell information based on the data;
The display system according to claim 1 or 2. A method of displaying a table on a computer,
The data of each cell constituting the table is stored in the storage means,
Display all or part of the table,
Determine at least one of the row and column to which the cell specified by the user among the displayed cells belongs,
Select any row or column in the table ,
When a row is selected, cell information related to the row or column to which the cell belongs is displayed based on the data of the cell located at the intersection of the column to which the determined cell belongs and the row, and the column is selected. In the case, the cell information of the cell is displayed based on the data of the cell located at the intersection of the row to which the determined cell belongs and the column.
A table display method characterized by the above. A computer program used in a computer that performs processing for displaying a table on a display device,
Processing for displaying all or part of the table on the display device based on the data of each cell constituting the table;
A process of determining at least one of a row and a column to which a cell specified by a user among displayed cells belongs,
Selecting any row or column of the table ;
When a row is selected, cell information related to the row or column to which the cell belongs is displayed based on the data of the cell located at the intersection of the column to which the determined cell belongs and the row, and the column is selected. In the case, the process of displaying the cell information of the cell based on the data of the cell located at the intersection of the row to which the determined cell belongs and the column,
A computer program for causing a computer to execute.

Images