IP Library Granted Patent US 9,015,572
Granted Patent B2
US 9,015,572 · App. 12/286,721 · Granted Apr 21, 2015

Grouping tables

Inventors: Nathaniel Cleverly Lanza (Pittsburgh, PA); Christopher Douglas Weeldreyer (San Carlos, CA)
Assignee: Apple Inc.
G06F17/246
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,015,572
App. No.
12/286,721
Granted
Apr 21, 2015
Kind
B2
Abstract

Grouping a set of data is disclosed. In some embodiments, a set of data is grouped with respect to a column and/or a row associated with the set of data in response to receiving a selection of an option to group the set of data with respect to the column and/or the row. In some embodiments, the grouping of the set of data is based on real time values of the set of data and is automatically and dynamically updated in response to changes in the set of data.

Claims (26)

1. A computer program product for processing a table, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for:

receiving a selection of an option to group rows of a table of spreadsheet cells with respect to respective values of a plurality of columns of the table; and

grouping rows comprising the table according to values of the plurality of columns while continuing to provide spreadsheet functionality with respect to cells comprising the grouped table.

2. The computer program product recited in claim 1 , wherein a grouping of the table is based on real-time values of data comprising the table.

3. The computer program product recited in claim 1 , wherein a view and/or a grouping of the table is dynamically updated in response to a change in data comprising the table.

4. The computer program product recited in claim 1 , wherein grouping the table changes a view or layout of the table.

5. The computer program product recited in claim 1 , wherein grouping rows comprising the table comprises sorting rows comprising the table with respect to the plurality of columns.

6. The computer program product recited in claim 1 , wherein grouping rows comprising the table comprises pivoting a portion of the table associated with the plurality of columns.

7. The computer program product recited in claim 1 , further comprising computer instructions for creating one or more group divisions for the values comprising the plurality of columns.

8. The computer program product recited in claim 7 , wherein a group division is created for each unique value comprising the plurality of columns.

9. The computer program product recited in claim 7 , further comprising computer instructions for selecting an interval for group divisions of values comprising the plurality of columns.

10. The computer program product recited in claim 7 , further comprising computer instructions for adding a group division row to the table for each group division.

11. The computer program product recited in claim 7 , further comprising computer instructions for including one or more summary functions with one or more group divisions.

12. The computer program product recited in claim 11 , wherein one or more summary functions are dynamically updated in response to a change in the table that affects the one or more summary functions.

13. A system for processing a table, comprising:

a processor configured to:

receive a selection of an option to group rows of a table of spreadsheet cells with respect to respective values of a plurality of columns of the table; and

group rows comprising the table according to values of the plurality of columns while continuing to provide spreadsheet functionality with respect to cells comprising the grouped table; and

a memory coupled to the processor and configured to provide the processor with instructions.

14. The system recited in claim 13 , wherein a grouping of the table is based on real time values of data comprising the table.

15. The system recited in claim 13 , wherein a view and/or a grouping of the table is dynamically updated in response to a change in data comprising the table.

16. A method for processing a table, comprising:

receiving a selection of an option to group rows of a table of spreadsheet cells with respect to respective values of a plurality of columns of the table and

using a processor to group rows comprising the table according to values of the plurality of columns while continuing to provide spreadsheet functionality with respect to cells comprising the grouped table.

17. The method recited in claim 16 , wherein a grouping of the table is based on real time values of data comprising the table.

18. The method recited in claim 16 , wherein a view and/or a grouping of the table is dynamically updated in response to a change in data comprising the table.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 30, 2008
From: LANZA, NATHANIEL CLEVERLY; WEELDREYER, CHRISTOPHER DOUGLAS
To: APPLE INC.
Reel/Frame 021702/0148 →
Continuity (2)
Continuation In Part 11647936 · Dec 28, 2006
Related Publication 20090106310A1 · Apr 23, 2009