Computerized spreadsheet with auto-calculator

• US 6,055,548 A
• Filed: 06/03/1996
• Issued: 04/25/2000
• Est. Priority Date: 06/03/1996
• Status: Expired due to Term

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Williams, David Russell Jr., Comer, Ross
• Primary Examiner(s): Feild, Joseph H.
• Application Number:
  US08/657,353
• Time in Patent Office: 1,422 Days
• Field of Search: 707/503, 707/504, 707/538, 345/346, 345/340, 345/335
• US Class Current: 715/212
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A computerized spreadsheet automatically calculates a function using a set of selected cells as the cells are selected and immediately displays the result in real-time, without requiring entry of a function into a cell to perform the calculations. The computerized spreadsheet has multiple cells which are selectable by an indicator, such as a pointer or highlight bar. As the author selects one or more cells, an auto-calculator automatically calculates a preset function using the one or more selected cells and displays the result. For example, suppose the function is to sum all the values in a group of cells. As the author selects the cells within the group, the auto-calculator quickly computes the sum of the presently selected cells and displays the result. If the author changes the selection, the calculation is continuously updated and displayed in real-time. In this manner, the author can view intermediate calculations without having to write or embed a formula for them within the spreadsheet.

Claims

1. A computer-implemented method for operating a computer application with spreadsheet functionality, comprising the following steps:

displaying a graphical user interface window having a plurality of cells operatively associated with the spreadsheet functionality and at least one data display region not operatively associated with the spreadsheet functionality;

enabling selection of one or more of the plurality of cells;

automatically computing an operator-defined function, based solely on the selected cells as inputs, to produce a result as the cells are being selected without entering the function into a non-selected cell; and

immediately displaying the result in the at least one region not operatively associated with the spreadsheet functionality.

2. A computer-implemented method as recited in claim 1, wherein the one or more selected cells contain data, and the computing step comprises automatically computing the operator-defined function based upon the data contained in the one or more cells.

3. A computer-implemented method as recited in claim 1, further comprising the following steps:

enabling a user to choose another function; and

subsequently automatically computing the other function using the selected cells.

4. A computer-implemented method as recited in claim 1, wherein the operator-defined function is selected from a group of functions comprising:

summation, maximum, minimum, average, count, and count number.

5. A computer-implemented method as recited in claim 1, wherein the graphical user interface window includes a toolbar having the at least one data display region not operatively associated with the spreadsheet functionality.

6. A computer-implemented method as recited in claim 1, wherein the graphical user interface window includes a movable pointer having the at least one data display region not operatively associated with the spreadsheet functionality adjacent to the pointer.

7. A computer-implemented method as recited in claim 1, wherein the computing step comprises automatically computing the function each time the selected cells changes from a first group of cells to a second group of cells.

8. A computer-implemented method as recited in claim 7, further comprising the step of displaying the result from said computation each time a computation is made.

9. A computer-implemented method as recited in claim 7, further comprising the step of displaying the result from said computation only after all of the cells are selected.

10. A computer-implemented method as recited in claim 7, wherein the computing step comprises the step of computing the function using repeatedly all of the selected cells.

11. A computer-implemented method as recited in claim 7, wherein the computing step comprises the following steps:

temporarily storing the result from said computation using all previously selected cells; and

computing a new result using the stored result and one or more newly selected cells.

12. A storage medium having executable instructions comprising:

instructions to form a graphical user interface window having a plurality of cells operatively associated with a spreadsheet functionality and at least one data display region not operatively associated with the spreadsheet functionality;

indicator instructions to select a set of one or more of the plurality of cells;

auto-calculator instructions to automatically calculate an operator-defined function in which the set of cells selected by the indicator are sole inputs and to produce a result as the set of cells is being selected by the indicator; and

interface instructions to immediately display the result computed by the auto-calculator as the set of cells is being selected in the at least one data display region not operatively associated with the spreadsheet functionality.

13. A storage medium as recited in claim 12, wherein the operator-function is from a group of functions comprising:

summation, maximum, minimum, average, count, and count number.

14. A storage medium as recited in claim 12, wherein the instructions to form a graphical user interface window form a toolbar having the at least one data display region not operatively associated with thc spreadsheet functionality.

15. A storage medium as recited in claim 12, wherein the instructions to form a graphical user interface window form a movable pointer and a tip window adjacent to the pointer, the tip window having the at least one data display region not operatively associated with the spreadsheet functionality.

16. A storage medium as recited in claim 12, wherein the auto-calculator instructions automatically calculates the operator-defined function each time the selected cells changes from a first group of cells to a second group of cells.

17. A storage medium as recited in claim 12, wherein the auto-calculator instructions automatically calculates the operator-defined function after all of the one or more cells have been selected.

18. A storage medium as recited in claim 12, wherein the auto-calculator instructions temporarily caches the result from a calculation involving all previously selected cells and automatically calculates a new result using the cached result and one or more newly selected cells.

19. A computer comprising:

a memory;

a processor;

a display;

an application stored in memory and executable on the processor, the application presenting on the display a graphical user interface having a plurality of selectable cells operatively associated with a spreadsheet functionality and at least one data display region not operatively associated with the spreadsheet functionality;

the application being configured to automatically calculate an operator-defined function based solely on one or more selected cells as inputs to produce a result and to immediately display the result in the at least one data display region not operatively associated with the spreadsheet functionality as those cells arc selected.

20. A computer as recited in claim 19, wherein the operator-defined function is from a group of functions comprising:

summation, maximum, minimum, average, count, and count number.

21. A computer as recited in claim 19, wherein:

the graphical user interface further includes a toolbar adjacent to the plurality of cells, the toolbar having the at least one data display region not operatively associated with the spreadsheet functionality.

22. A computer as recited in claim 19, wherein:

the graphical user interface further includes a movable pointer for selecting the cells and a tip window beside the pointer, the tip window having the at least one data display region not operatively associated with the spreadsheet functionality.

23. A computer as recited in claim 19, wherein the application is configured to automatically calculate the function and immediately display the result each time the selected cells changes from a first group of cells to a second group of cells.