The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jun. 25, 2013
Filed:
Jul. 26, 2010
Lakshmi N. Thanu, Sammamish, WA (US);
Peter Eberhardy, Seattle, WA (US);
Dylan Hai Huang, Redmond, WA (US);
Xiaohong Mark Yang, Sammamish, WA (US);
Lakshmi N. Thanu, Sammamish, WA (US);
Peter Eberhardy, Seattle, WA (US);
Dylan Hai Huang, Redmond, WA (US);
Xiaohong Mark Yang, Sammamish, WA (US);
Microsoft Corporation, Redmond, WA (US);
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.