Multidimensional split view for a pivot table or other grid-based component

• US 9,778,834 B2
• Filed: 07/31/2013
• Issued: 10/03/2017
• Est. Priority Date: 05/23/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Evans, James, van den Broek, Hendrik
• Primary Examiner(s): Bashore, William
• Assistant Examiner(s): Distefano, Gregory A
• Application Number:
  US13/956,263
• Publication Number:
  US 20140351746A1
• Time in Patent Office: 1,525 Days
• Field of Search: 715784
• CPC Class Codes: G06F 2203/04803 Split screen, i.e. subdividing the display area or the window area into separate subareas
• CPC Class Codes: G06F 3/0485 Scrolling or panning
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A data view may be into multiple data panes. Splits between data panes may be horizontal or vertical, allowing data panes to be arranged horizontally and vertically. Scroll boundaries are set for each pair of adjacent data panes, such that each data pane may only scroll through a portion of the data on its side of the scroll boundary. Data panes may be scrolled independently in the direction of a split. Data panes may be scrolled together perpendicular to the direction of a split.

Claims

1. A method, performed by a computer system, for displaying tabular formatted data that cannot be legibly displayed in its entirety on a single display screen, comprising:

generating a graphical user interface screen including a display area on the single display screen for displaying tabular formatted data;

receiving the tabular formatted data from a computer database, wherein the tabular formatted data is configured as a single table providing a contiguous single view of the tabular formatted data arranged in at least a first dimension, and wherein the tabular formatted data is too large to be legibly displayed in its entirety within the display area as the single table;

while maintaining continuity of the single table, displaying only a portion of the tabular formatted data in the display area;

receiving a split command from a user, wherein the split command includes a split index for splitting the tabular formatted data in at least the first dimension while maintaining continuity of the single table;

defining contiguous first and second non-overlapping data subsets of the tabular formatted data based on the split index, wherein the first data subset and the second data subset form the single table;

based on the split command, separating the display area in a first data pane and a second data pane;

displaying a first portion of the first data subset in the first data pane and a second portion of the second data subset in the second data pane, wherein the first portion of the first data subset and the second portion of second data subset displayed form the displayed portion of the tabular formatted data; and

while maintaining continuity of the single table, limiting the first data pane to a first scroll range in the first dimension corresponding with the first data subset and the second data pane to a second scroll range in the first dimension corresponding with the second data subset.

2. The method of claim 1, wherein defining the first and second data subsets of the tabular formatted data comprises:

setting a first scroll boundary based on the split index.

3. The method of claim 1, wherein defining the first and second data subsets of the tabular formatted data comprises:

partitioning the tabular formatted data into the first and second data subsets.

4. The method of claim 1, wherein limiting the first data pane to the first scroll range and the second data pane to the second scroll range further comprises:

receiving a scroll input including a selection of the first or second data pane;

determining if the scroll input would cause the selected data pane to scroll outside its corresponding data subset;

in response to the determination that the scroll input would cause the selected data pane to scroll outside its corresponding data subset, modifying the scroll input to be limited to its corresponding data subset; and

scrolling the selected data pane by the potentially modified scroll input.

5. The method of claim 1, further comprising:

displaying a table header for the tabular formatted data.

6. The method of claim 5, comprising receiving scroll inputs for the table header.

7. The method of claim 1, wherein the tabular formatted data is further arranged in a second dimension.

8. The method of claim 7, comprising:

jointly scrolling the first and second data panes in the second dimension in response to a scroll input in the first dimension.

9. The method of claim 7, wherein the split command further includes a second split index for splitting in the second dimension, the method comprising:

defining contiguous third and fourth data subsets of the tabular formatted data based on the split index;

displaying at least a portion of the third data subset in a third data pane and at least a portion of the fourth data subset in a fourth data pane; and

limiting the third data pane to a third scroll range in the second dimension corresponding with the third data subset and the fourth data pane to a fourth scroll range in the second dimension corresponding with the second data subset, wherein the first, second, third, and fourth data subsets form the single table.

10. The method of claim 9, comprising:

jointly scrolling the third and fourth data panes in the first dimension in response to a scroll input directed in the first dimension.

11. The method of claim 9, comprising:

displaying table headers for the portion of the tabular formatted data; and

jointly scrolling the table headers with the data panes.

12. A method, performed by a computer system, for displaying tabular formatted data that cannot be legibly displayed in its entirety on a single display screen in a graphical user interface, comprising:

receiving the tabular formatted data from a computer database, wherein the tabular formatted data is configured as a single table providing a contiguous single view of the tabular formatted data which is too large to be legibly displayed in its entirety on the display screen within a display area as the single table;

in the graphical user interface, creating a view area for tabular formatted data displayed as the single table;

while maintaining continuity of the single table, displaying only a portion of the tabular formatted data in the view area;

receiving a split command and a data entity selection;

while maintaining the continuity of the single table, splitting the tabular formatted data into at least two contiguous non-overlapping subsets, based on the split command and the data entity selection;

splitting the view area into at least two adjacent data panes, wherein each data pane is associated with one subset, and wherein each data pane is configured to only display tabular formatted data from its associated subset, and wherein an arrangement of the data panes prevents contradicting relative locations of viewable and scrollable data from their respective subsets, wherein viewable portions of the at least two subsets define contiguous non-overlapping portions of the single table; and

setting at least a first scroll boundary for the data panes based on the data entity selection.

13. The method of claim 12, further comprising:

receiving a scroll input including a selection of at least one of the data panes;

determining if the scroll input would cause the selected data pane to cross the first scroll boundary;

in response to the determination that the scroll input would cause the selected data pane to cross the scroll boundary, modifying the scroll input to be limited to the first scroll boundary; and

scrolling the selected data pane by the potentially modified scroll input.

14. The method of claim 12, wherein the view area is a table view.

15. The method of claim 12, wherein the view area is split into at least four adjacent data panes.

16. The method of claim 12, setting at least a second scroll boundary for the data panes based on the data entity selection.

17. The method of claim 16, wherein the first scroll boundary is perpendicular to the second scroll boundary.

18. The method of claim 12, wherein the first scroll boundary is based on a table row of the data entity selection.

19. The method of claim 12, wherein the first scroll boundary is based on a table column of the data entity selection.

20. A tangible, non-transitory computer-readable information storage medium including instructions executable by a processor for a method of displaying tabular formatted data that cannot be legibly displayed in its entirety on a single display screen in a graphical user interface screen, the method comprising:

generating a display area on the single display screen for displaying tabular formatted data configured as a single table in the user interface;

receiving the tabular formatted data from a computer database, wherein the tabular formatted data is configured as a single table providing a contiguous single view of the tabular formatted data arranged in at least a first dimension, and wherein the tabular formatted data is too large to be legibly displayed in its entirety within the display area as the single table;

while maintaining continuity of the single table, displaying only a portion of the tabular formatted data in the display area;

receiving a split command from a user, wherein the split command includes a split index for splitting the tabular formatted data in at least the first dimension while maintaining continuity of the single table;

defining contiguous first and second non-overlapping data subsets of the tabular formatted data based on the split index, wherein the first data subset and the second data subset form the single table;

based on the user'"'"'s split command, separating the area in a first data pane and a second data pane;

displaying a first portion of the first data subset in the first data pane and a second portion of the second data subset in the second data pane, wherein the first portion of the first data subset and the second portion of second data subset displayed form the displayed portion of the tabular formatted data; and

while maintaining continuity of the single table, limiting the first data pane to a first scroll range in the first dimension corresponding with the first data subset and the second data pane to a second scroll range in the first dimension corresponding with the second data subset.

21. A system comprising:

a client system including a graphical user interface screen;

a database storing tabular formatted data that cannot be legibly displayed in its entirety within a display area as a single table on a single display screen; and

an application server connected with the database and the client system via at least one network, wherein the application server is adapted to retrieve the tabular formatted data from the database and communicate the retrieved tabular formatted data with the client system;

wherein the client system includes an application including instructions executable by the client system to perform a method comprising;

generating a display area for displaying the tabular formatted data in the graphical user interface;

receiving the tabular formatted data from the database, wherein the tabular formatted data is configured as a single table providing a contiguous single view of the tabular formatted data arranged in at least a first dimension, and wherein the tabular formatted data is too large to be legibly displayed in its entirety within the display area as the single table on the display screen;

while maintaining continuity of the single table, displaying a portion of the tabular formatted data in the display area;

receiving a split command from a user, wherein the split command includes a split index for splitting the tabular formatted data in at least the first dimension;

defining contiguous first and second non-overlapping data subsets of the tabular formatted data based on the split index, wherein the first data subset and the second data subset form the single table;

based on the user'"'"'s split command, separating the display area in a first data pane and a second data pane;

displaying a first portion of the first data subset in the first data pane and a second portion of the second data subset in the second data pane, wherein the first portion of the first data subset and the second portion of second data subset displayed form the displayed portion of the tabular formatted data; and

while maintaining the continuity of the single table, limiting the first data pane to a first scroll range in the first dimension corresponding with the first data subset and the second data pane to a second scroll range in the first dimension corresponding with the second data subset.