Collapsing data cells in one or more reports in a spreadsheet

• US 10,133,721 B2
• Filed: 06/20/2013
• Issued: 11/20/2018
• Est. Priority Date: 11/12/2004
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Thanu, Lakshmi N., Eberhardy, Peter, Huang, Dylan Hai, Yang, Xiaohong Mark
• Primary Examiner(s): Paula, Cesar
• Assistant Examiner(s): Faber, David
• Application Number:
  US13/923,189
• Publication Number:
  US 20130290823A1
• Time in Patent Office: 1,979 Days
• CPC Class Codes: G06F 40/106 Display of layout of documents; Previewing
• CPC Class Codes: G06F 40/166 Editing, e.g. inserting or deleting
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Data cells in a spreadsheet report are collapsed and expanded without disrupting other spreadsheet data. A user may want to drill down on data corresponding to a parent member of the report to display more detailed information about the parent member. Likewise, a user may want to drill up the displayed information corresponding to the parent member to hide detailed information associated with the parent member. Before expanding or collapsing a report, the spreadsheet is scanned for information to determine whether the display of other data in the spreadsheet would be disrupted by the expansion/collapse. The information may include cross join information associated with the parent member, the number of child members associated with the parent member, the dimension of the report created by the parent member and the associated child members, and other reports that may be linked to the report that includes the parent member.

Claims

1. A method for collapsing data cells in one or more reports of a spreadsheet having a limited number of cells, comprising:

receiving a request to collapse child cells associated with a parent cell of a first report;

scanning the spreadsheet for information related to the parent cell and the associated child cells including determining when at least one other report is linked to the first report;

collapsing the child cells in the first report based on the information by preventing the child cells associated with the parent cells from being displayed in the first report without disrupting the layout of data in areas of the spreadsheet external to the first report; and

collapsing the parent member in the at least one other report when it is determined that the at least one other report is linked to the parent member in the first report.

2. The method of claim 1, wherein the first report comprises a free-form report.

3. The method of claim 1, wherein scanning the spreadsheet for information further comprises scanning the spreadsheet for cross-join information associated with the first report.

4. The method of claim 1, wherein the first report is a cross-joined report that assembles data from a plurality of sources.

5. The method of claim 1, wherein scanning the spreadsheet for information further comprises scanning the spreadsheet for data cells that are dependent on the parent member, a number of child members associated with the parent member, and a dimension of the first report created by the parent member and the associated child members.

6. The method of claim 1, further comprising determining whether a batch of child members is associated with the parent member.

7. The method of claim 1, further comprising copying a format and a formula associated with the parent member to the associated child members.

8. A hardware computer storage medium for collapsing data cells in one or more reports of a spreadsheet having a limited number of cells, comprising:

receiving a request to collapse child cells associated with a parent cell of a first report;

scanning the spreadsheet for information related to the parent cell and the associated child cells including determining when at least one other report is linked to the first report; and

collapsing the child cells in the first report based on the information by preventing the child cells associated with the parent cells from being displayed in the first report without disrupting the layout of data in areas of the spreadsheet external to the first report; and

collapsing the parent member in the at least one other report when it is determined that the at least one other report is linked to the parent member in the first report.

9. The hardware computer storage medium of claim 8, wherein collapsing the child cells comprises removing a row containing a child cell from the spreadsheet.

10. The hardware computer storage medium of claim 8, wherein collapsing the child cells comprises removing a row containing a child cell from the first report.

11. The hardware computer storage medium of claim 8, wherein collapsing the child cells comprises moving a row containing a sibling cell to be proximate a row containing the parent cell.

12. The hardware computer storage medium of claim 8, wherein collapsing the child cells comprises at least one of:

removing a column containing a child cell from the spreadsheet;

removing a column containing a child cell from the first report, or moving a column containing a sibling cell to be proximate a column containing the parent cell.

13. The hardware computer storage medium of claim 8, wherein the information comprises at least one of:

a total number of data cells in the first report;

a dimension of the first report;

data cells in the first report that are dependent on other data cells external to the first report within the spreadsheet, or cross-join information associated with the first report.

14. The hardware computer storage medium of claim 8, wherein the information comprises data cells in the first report that are dependent on other data cells external to the first report within the spreadsheet and cross-join information associated with the first report.

15. A system for collapsing data cells in one or more reports of a spreadsheet having a limited number of cells, comprising:

a processing unit and a computer storage medium;

an application configured to perform actions using the processor, comprising;

receiving a request to collapse child cells associated with a parent cell of a first report;

scanning the spreadsheet for information related to the parent cell and the associated child cells including determining when at least one other report is linked to the first report;

collapsing the child cells in the first report based on the information by preventing the child cells associated with the parent cells from being displayed in the first report without disrupting the layout of data in areas of the spreadsheet external to the first report; and

collapsing the parent member in the at least one other report when it is determined that the at least one other report is linked to the parent member in the first report.

16. The system of claim 15, wherein retrieving information related to the parent cell further comprises scanning the spreadsheet for at least one of:

cross-join information associated with the first report;

data cells that are dependent on the parent cell;

a number of child cells associated with the parent cell, or a dimension of the first report created by the parent cell and the associated child cells.

17. The system of claim 15, wherein collapsing the child cells comprises removing a row containing a child cell from the spreadsheet.

18. The system of claim 15, wherein collapsing the child cells

comprises at least one of:

removing a row containing a child cell from the first report, moving a row containing a sibling cell to be proximate a row containing the parent cell, removing a column containing a child cell from the spreadsheet;

removing a column containing a child cell from the first report, or moving a column containing a sibling cell to be proximate a column containing the parent cell.

19. The system of claim 15, wherein scanning the spreadsheet for information further comprises scanning the spreadsheet for cross-join information associated with the first report.

20. The system of claim 15, wherein the first report is a cross-joined report that assembles data from a plurality of sources.