UTILIZING SPREADSHEET REFERENCES WITH GROUPED AGGREGATE VIEWS

• US 20090319880A1
• Filed: 06/18/2008
• Published: 12/24/2009
• Est. Priority Date: 06/18/2008
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Collie, Robert C., Sanders, Paul J., Petculescu, Cristian, Netz, Amir
• Granted Patent: US 8,185,817 B2
• Time in Patent Office: Days
• US Class Current: 715/219
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

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.

Claims

1. A system for creating calculations within grouped aggregate views of spreadsheets:

a grouped aggregate view feature which enables a user to create a grouped aggregate view of data; and

a calculation feature which enables the user to create one or more calculations for the grouped aggregate view of data, the one or more calculations being based upon references to data in the grouped aggregate view.

2. The system of claim 1, wherein the references to data in the grouped aggregate view include relative references.

3. The system of claim 1, wherein the references to data in the grouped aggregate view include absolute references.

4. The system of claim 1, wherein the calculation feature allows the user to select a first cell in which to place a respective one of the calculations, and also allows the user to select a second cell to reference as part of the respective one of the calculations.

5. The system of claim 4, further comprising:

a toggle feature which allows the user to toggle between a list of available references for the second cell that can be selected as part of the one or more calculations, the available references being related to the data in the grouped aggregate view.

6. The system of claim 5, wherein the toggle feature is operable to display a list of absolute references and a list of relative references that can be selected as part of the one or more calculations.

7. The system of claim 1, wherein the calculation feature is operable to allow the user to directly enter into a selected cell a particular calculation containing an absolute reference to at least part of the data in the grouped aggregate view.

8. The system of claim 1, wherein the calculation feature is operable to allow the user to directly enter into a selected cell a particular calculation containing a relative reference to at least part of the data in the grouped aggregate view.

9. A method for enabling calculations to be written within a grouped aggregate view in a spreadsheet comprising the steps of:

receiving input from a user to write a calculation within a first cell in a grouped aggregate view in a spreadsheet;

receiving input from the user to select a second cell to reference when writing the calculation;

presenting the user with available references that are relevant to data contained in the second cell;

receiving input from the user to select one of the available references that are relevant for the second cell; and

putting the selected one of the available references into the first cell.

10. The method of claim 9, wherein the grouped aggregate view is a pivot table.

11. The method of claim 9, wherein the available references presented to the user include relative references that are relevant to the data of the second cell.

12. The method of claim 9, wherein the available references presented to the user include absolute references that are relevant to the data of the second cell.

13. The method of claim 9, wherein the available references presented to the user include relative references and absolute references that are relevant to the data of the second cell.

14. The method of claim 9, wherein prior to receiving input from the user to select one of the available references, receiving a selection from the user to toggle through the available references until a desired reference is reached.

15. A method for creating calculations for data in a grouped aggregate view comprising the steps of:

receiving input from a user to select a cell to reference when the user is writing a calculation in a particular cell;

determining a context of the selected cell;

offering the user a plurality of relative and absolute references that are relevant to the context of the selected cell; and

allowing the user to toggle through the offered references and select a desired reference.

16. The method of claim 15, further comprising the steps of:

placing the desired reference that was selected by the user into the particular cell where the calculation is being written.

17. The method of claim 16, further comprising the steps of:

when the user has finished creating the calculation in the particular cell, automatically populating additional cells with a respective variation of the calculation that is appropriate for the additional cells.

18. The method of claim 15, wherein the user can toggle through the offered references by pressing a keyboard shortcut.

19. The method of claim 18, wherein the keyboard shortcut is an [F4] key on a keyboard.

20. The method of claim 15, wherein the grouped aggregate view is a pivot table.