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:
May. 22, 2012
Filed:
Jun. 18, 2008
Robert C. Collie, Redmond, WA (US);
Amir Netz, Bellevue, WA (US);
Paul J. Sanders, Mercer Island, WA (US);
Cristian Petculescu, Redmond, WA (US);
Robert C. Collie, Redmond, WA (US);
Amir Netz, Bellevue, WA (US);
Paul J. Sanders, Mercer Island, WA (US);
Cristian Petculescu, Redmond, WA (US);
Microsoft Corporation, Redmond, WA (US);
Abstract
Various technologies and techniques are disclosed for utilizing spreadsheet references with grouped aggregate views. A grouped aggregate view feature enables a user to create a grouped aggregate view of data. A calculation feature enables the user to calculations for the grouped aggregate view of data that are based upon relative or absolute references to data in the grouped aggregate view. Input is received from a user to write a calculation within a first cell in a grouped aggregate view. Input is received from the user to select a second cell to reference when writing the calculation. The user is presented with available references that are relevant to data contained in the second cell. Input is received from the user to select one of the available references that are relevant for the second cell. The selected one of the available references is placed into the first cell.