Method and system for constructing a formula in a spreadsheet

• US 5,890,174 A
• Filed: 11/16/1995
• Issued: 03/30/1999
• Est. Priority Date: 11/16/1995
• Status: Expired due to Term

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Martinez, Edward A., Khanna, Karan
• Primary Examiner(s): Nguyen, Phu K.
• Application Number:
  US08/558,820
• Time in Patent Office: 1,230 Days
• Field of Search: 395/938, 395/939, 395/940, 395/941, 395/932, 345/440, 707/503, 707/504, 707/509, 707/510
• US Class Current: 715/210
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A method and system for assisting a user in constructing a formula in a cell of a spreadsheet operating on a computer system. A function dialog box is displayed that lists various functions that may be selected by the user to be entered into the formula. By selecting a button in the function dialog box, an insert function dialog box is displayed that lists additional functions by category. When the user selects a function, a parameter dialog box associated with the selected function is displayed. Parameters may include cell addresses as well as numerical or other data entered directly by the user. The parameter dialog box displays the formula as it is being constructed. After the parameters have been entered, a result dialog box is displayed that allows the user to select the result cell in which to place the formula. The user selects the result cell and the result dialog box is removed from the display screen, the formula is entered in the result cell, and the result of the formula is displayed in the result cell.

Claims

1. In association with a computer system, a method for constructing a formula in a cell of a spreadsheet, comprising the steps of:

displaying a first dialog box that lists selectable functions;

accepting the selection of one of the functions for insertion into the formula;

displaying a second dialog box for the selection of parameters for the selected function;

accepting the selection of parameters; and

inserting the resultant formula into a result cell.

2. The method of claim 1 further comprising, before said inserting step:

displaying a third dialog box for selecting the result cell in which the formula is to be placed; and

accepting the selection of the desired result cell.

3. The method of claim 2 wherein a default result cell is identified as the current cell.

4. The method of claim 1 wherein the first dialog box includes a description of the selected function.

5. The method of claim 1 wherein the first dialog box includes instructions for selecting parameters.

6. The method of claim 1 wherein the first dialog box lists a plurality of predetermined, commonly-used functions.

7. The method of claim 6 wherein other functions are displayed by selecting a button in the first dialog box.

8. The method of claim 7 wherein the other functions are displayed in lists associated with a plurality of categories of functions.

9. The method of claim 8 wherein one category displays a predetermined number of functions that have been most recently selected.

10. The method of claim 1 wherein the parameters include at least one cell address identifying a cell in the spreadsheet.

11. The method of claim 10 wherein the cell address is selected by clicking on the cell with a mouse.

12. The method of claim 10 wherein the parameters include a contiguous block of cells that are selected by dragging a mouse over the block of cells.

13. The method of claim 10 wherein the parameters are selected by typing the cell addresses on a keyboard.

14. The method of claim 1 wherein the second dialog box displays suggested parameters.

15. The method of claim 14 wherein the suggested parameters include cells in the same column above the current cell including the cell adjacent to the current cell and all contiguous cells filled with data.

16. The method of claim 14 wherein the suggested parameters include cells in the same row to the left of the current cell including the cell adjacent to the current cell and all contiguous cells filled with data.

17. A computer system, including a program module that displays cells of a spreadsheet on a display, for constructing a formula in a cell of said spreadsheet, comprising:

means for displaying a first dialog box that lists selectable functions;

means for accepting the selection of one of said functions for insertion into said formula;

means for displaying a second dialog box for the selection of parameters for said selected function;

means for accepting the selection of said parameters; and

means for inserting the resultant formula into a result cell.

18. The system of claim 17 further comprising:

means for displaying a third dialog box for selecting said result cell in which said formula is to be placed; and

means for accepting the selection of said desired result cell.

19. The system of claim 18 wherein a default result cell is identified as the current cell.

20. The system of claim 17 wherein said first dialog box includes a description of said selected function.

21. The system of claim 17 wherein said first dialog box includes instructions for selecting said parameters.

22. The system of claim 17 wherein said first dialog box lists a plurality of predetermined, commonly-used functions.

23. The system of claim 22 wherein other functions are displayed by selecting a button in said first dialog box.

24. The system of claim 23 wherein said other functions are displayed in lists associated with a plurality of categories of functions.

25. The system of claim 24 wherein one said category displays a predetermined number of functions that have been most recently selected.

26. The system of claim 17 wherein said parameters include at least one cell address identifying a cell in said spreadsheet.

27. The system of claim 26 wherein the cell address is selected by clicking on said cell with a mouse.

28. The system of claim 26 wherein said parameters include a contiguous block of cells that are selected by dragging a mouse over the block of cells.

29. The system of claim 26 wherein said parameters are selected by typing the cell addresses on a keyboard.

30. The system of claim 17 wherein said second dialog box displays suggested parameters.

31. The system of claim 30 wherein said suggested parameters include cells in the same column above the current cell including the cell adjacent to the current cell and all contiguous cells filled with data.

32. The system of claim 30 wherein said suggested parameters include cells in the same row to the left of the current cell including the cell adjacent to the current cell and all contiguous cells filled with data.

33. A memory storage device for a computer program, said memory storage device storing a computer program that provides a method for constructing a formula in a cell of a spreadsheet, said method comprising the steps of:

displaying a first dialog box that lists selectable functions;

accepting the selection of one of the functions for insertion into the formula;

displaying a second dialog box for the selection of parameters for the selected function;

accepting the selection of parameters; and

inserting the resultant formula into a result cell.

34. The memory storage device of claim 33 wherein said method, before said inserting step, further comprises the steps of:

displaying a third dialog box for selecting the result cell in which the formula is to be placed; and

accepting the selection of the desired result cell.

35. The memory storage device of claim 34 wherein a default result cell is identified as the current cell.

36. The memory storage device of claim 33 wherein said first dialog box includes a description of the selected function.

37. The memory storage device of claim 33 wherein said first dialog box includes instructions for selecting parameters.

38. The memory storage device of claim 33 wherein said first dialog box lists a plurality of predetermined, commonly-used functions.

39. The memory storage device of claim 38 wherein other functions are displayed by selecting a button in said first dialog box.

40. The memory storage device of claim 39 wherein the other functions are displayed in lists associated with a plurality of categories of functions.

41. The memory storage device of claim 40 wherein one category displays a predetermined number of functions that have been most recently selected.

42. The memory storage device of claim 33 wherein said parameters include at least one cell address identifying a cell in the spreadsheet.

43. The memory storage device of claim 42 wherein said cell address is selected by clicking on the cell with a mouse.

44. The memory storage device of claim 42 wherein said parameters include a contiguous block of cells that are selected by dragging a mouse over the block of cells.

45. The memory storage device of claim 42 wherein said parameters are selected by typing the cell addresses on a keyboard.

46. The memory storage device of claim 33 wherein said second dialog box displays suggested parameters.

47. The memory storage device of claim 46 wherein said suggested parameters include cells in the same column above the current cell including the cell adjacent to the current cell and all contiguous cells filled with data.

48. The memory storage device of claim 46 wherein said suggested parameters include cells in the same row to the left of the current cell including the cell adjacent to the current cell and all contiguous cells filled with data.