MULTIDIMENSIONAL SPLIT VIEW FOR A PIVOT TABLE OR OTHER GRID-BASED COMPONENT

• US 20140351746A1
• Filed: 07/31/2013
• Published: 11/27/2014
• 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
• Granted Patent: US 9,778,834 B2
• Time in Patent Office: Days
• US Class Current: 715/784
• 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 for displaying tabular formatted data, comprising:

receiving tabular formatted data arranged in at least a first dimension;

displaying a portion of the tabular formatted data;

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

defining first and second data subsets of the tabular formatted data based on the split index;

displaying at least a portion of the first data subset in a first data pane and at least a portion of the second data subset in a second data pane; and

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 1, wherein the split command further includes a second split index for splitting in the second dimension, the method comprising:

defining 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.

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.

20. One or more tangible media including instructions executable by a processor for the method of claim 1.

21. A system comprising:

a client system;

a database storing tabular formatted data; 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 the method of claim 1.

12. A method comprising:

receive a split command and a data entity selection;

splitting a view of data into at least two adjacent data panes;

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

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

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

15. The method of claim 12, wherein the view of data 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.