METHOD FOR EXPANDING AND COLLAPSING DATA CELLS IN A SPREADSHEET REPORT
1 Assignment
0 Petitions
Accused Products
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.
15 Citations
59 Claims
-
1-39. -39. (canceled)
-
40. A method for collapsing data cells in one or more reports 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. - View Dependent Claims (41, 42, 43, 44, 45, 46)
-
-
47. A computer-readable 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. - View Dependent Claims (48, 49, 50, 51, 52, 53, 54)
-
-
55. A system for collapsing data cells in one or more reports in one or more reports of a spreadsheet having a limited number of cells, comprising:
-
a processor and a computer-readable 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; 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. - View Dependent Claims (56, 57, 58, 59)
-
Specification