Collapsing data cells in one or more reports in a spreadsheet
US10133721B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jun 20, 2013 |
| Grant date | Nov 20, 2018 |
| Priority date | — |
| Expiry date | Oct 28, 2035 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F40/177
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.