Computerized spreadsheet with auto-calculator

• US 6,430,584 B1
• Filed: 03/14/2000
• Issued: 08/06/2002
• 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:
  US09/525,211
• Time in Patent Office: 875 Days
• Field of Search: 707/503-509, 707/538, 345/809
• 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:

enabling selection of one or more cells;

computing an operator defined function using the selected cells as the cells are selected; and

displaying a result from said computation as the cells are selected without confirming selection of the cells by entering the selection of the cells.

2. A computer-implemented method as recited in claim 1, wherein the operator defined function includes at least one function selected from a group of functions comprising:

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

3. In a computer application with spreadsheet functionality having individual cells, a computer-implemented method comprising the steps of:

receiving user input through a graphical user interface, the user input defining a selection of one or more cells;

in response, automatically computing a function based upon the selection of one or more cells as the one or more cells are being selected; and

through another portion of the graphical user interface, providing the user with a result from the automatically computed function without requiring the user to provide further input.

4. A computer-implemented method as recited in claim 3, wherein the automatically computed 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 3, wherein the graphical user interface includes a toolbar and providing the user with the result from the automatically computed function includes displaying the result in the toolbar.

6. A computer-implemented method as recited in claim 3, wherein the graphical user interface includes a movable pointer and providing the user with the result from the automatically computed function includes displaying the result adjacent to the pointer.

7. A computer readable medium having computer-executable instructions for performing acts comprising:

displaying a plurality of data entry fields within a graphical user interface;

receiving user input associated with a selection of at least one of the plurality of data entry fields;

based on the received user input, automatically performing at least one process using data operatively maintained within the selected at least one data entry field; and

without further user input, displaying at least one result from the automatically performed process to the user via the graphical user interface without modifying any of the plurality of data entry fields within the graphical user interface.