US5721847A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and system for linking controls with cells of a spreadsheet
Assignee: Microsoft Technology Licensing LLC
•
Filing: 1997-02-03
•
Granted: 1998-02-24
•
Expires: 2017-02-03
Abstract
Abstract A method and apparatus for inserting a selected graphic control within a spreadsheet, chart, or dialog sheet. The graphic control can be selected from a Forms button toolbar and then positioned within a desired workspace of a spreadsheet program. The graphic controls provided on the Forms button toolbar include a check box, an option box, a list box, a drop-down box, a combination list-edit box, a combination drop-down list-edit box, a scrollbar, and a spinner. A Format Object properties dialog box is also provided on the Forms button toolbar to enable the user to set various parameters for the graphic control. These parameters include an identification of the cell within the spreadsheet to which the graphic control is bi-directionally linked. If the user manipulates the graphic control, a value in the spreadsheet cell that is linked to the graphic control changes in a corresponding fashion. Similarly, any change to the spreadsheet cell linked to the graphic control is reflected within the graphic control. With this tool, the user can apply graphic controls to the spreadsheet program without requiring the user be skilled in programming.
Inventors
- 👤 Jeffrey J. Johnson
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-01 03:16
CPC Classifications
G; G06; G06F; G06F3/00; G06F3/01; G06F3/048; G06F3/0484; G06F3/04847; G06F3/0481; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18; G06F9/00; G06F9/06; G06F9/44; G06F9/455; G06F9/45504; G06F9/45508; G06F9/45512
Claims Analysis
Total Claims: 38
Claim 1
Independent Claim
144 words
A method for enabling a user to graphically control a cell of a spreadsheet, comprising the steps of: (a) providing a toolbar on which is disposed a graphic representation of a control; (b) enabling the user to select the graphic representation of the control on the toolbar and position a copy of the graphic representation of the control in a workspace selected by the user on a display, said workspace comprising one of the spreadsheet, a dialog sheet, a chart, and a macro sheet; and (c) enabling the user to link said cell of the spreadsheet to the control without requiring the user to enter code to effect the link, linkage of said cell to the control causing a value in said cell to change as the user varies a corresponding parameter of the control by graphically manipulating the control with a user interface.
Claim 2
Independent Claim
144 words
A method for enabling a user to graphically control a cell of a spreadsheet, comprising the steps of: (a) providing a toolbar on which is disposed a graphic representation of a control; (b) enabling the user to select the graphic representation of the control on the toolbar and position a copy of the graphic representation of the control in a workspace selected by the user on a display, said workspace comprising one of the spreadsheet, a dialog sheet, a chart, and a macro sheet; and (c) enabling the user to link said cell of the spreadsheet to the control without requiring the user to enter code to effect the link, linkage of said cell to the control causing a value in said cell to change as the user varies a corresponding parameter of the control by graphically manipulating the control with a user interface.
Claim 3
Dependent Claim
63 words
The method of claim 1, further comprising the step of enabling the user to size the graphic representation of the control in the workspace, by selecting a first position in the workspace as a first corner of the control, and then dragging a cursor in the display to a second position in the workspace to indicate a diagonally opposite corner of the control.
Claim 4
Dependent Claim
44 words
The method of claim 1, further comprising the step of enabling the user to select a menu item that opens a dialog box in which the user identifies said cell to which the control is linked, said link comprising a property of the control.
Claim 5
Dependent Claim
31 words
The method of claim 3, wherein the user is enabled to identify said cell to which the control is linked in the dialog box by selecting said cell in the spreadsheet.
Claim 6
Dependent Claim
50 words
The method of claim 1, further comprising the step of enabling the user to identify the cell to which the control is linked by selecting a dialog box used for entry of a formula in a toolbar, and then selecting said cell in the spreadsheet while the control is selected.
Claim 7
Dependent Claim
37 words
The method of claim 1, wherein the control comprises one of a check box, an option box, a list box, a drop-down box, a combination list-edit box, a combination drop-down list-edit box, a scrollbar, and a spinner.
Claim 8
Dependent Claim
30 words
The method of claim 1, wherein a change in the value of said cell to which the control is linked causes a corresponding change in the parameter of the control.
Claim 9
Dependent Claim
50 words
The method of claim 1, wherein the control comprises one of a list box, a drop-down box, a combination list-edit box, and a combination drop-down list-edit box, further comprising the step of enabling the user to indicate a range of cells in the spreadsheet as line entries in the control.
Claim 10
Dependent Claim
51 words
The method of claim 8, wherein selection of one of the line entries in the range of cells causes a numeric value to be returned in said cell to which the control is linked, said numeric value corresponding to an ordinal number of the line entry selected in the line entries.
Claim 11
Dependent Claim
56 words
The method of claim 1, wherein the control comprises a scrollbar, further comprising the step of enabling the user to specify a minimum value and a maximum value for a range of values encompassed by the scrollbar as the user graphically manipulates a slider in the scrollbar from one extreme position to an opposite extreme position.
Claim 12
Dependent Claim
37 words
The method of claim 10, further comprising the step of enabling the user to specify an incremental change in the value each time that the user clicks on an arrow of the scrollbar with a pointing device.
Claim 13
Dependent Claim
29 words
The method of claim 10, further comprising the step of enabling the user to specify an incremental change in the value each time that the user pages the scrollbar.
Claim 14
Dependent Claim
49 words
The method of claim 1, wherein the control comprises a spinner, further comprising the step of enabling the user to specify a start value and an end value for a range of values encompassed by the spinner as the user selects one of two arrows displayed in the spinner.
Claim 15
Dependent Claim
35 words
The method of claim 13, further comprising the step of enabling the user to specify an incremental change in the value that will occur each time that the user graphically manipulates one of the arrows.
Claim 16
Dependent Claim
40 words
The method of claim 1, wherein the control comprises an option box in a group of option boxes, the value in said cell to which the control is linked comprising an ordinal number of the option box within said group.
Claim 17
Dependent Claim
49 words
The method of claim 1, wherein the control comprises a check box, said cell to which the check box is linked having a true value if the user enters a check into the check box and a false value if the check is not entered in the check box.
Claim 18
Dependent Claim
56 words
The method of claim 1, wherein the control comprises a check box, said check box displaying a check if the user enters a non-zero number in said cell to which the check box is linked, but not displaying a check if the user enters a zero in said cell to which the check box is linked.
Claim 19
Dependent Claim
25 words
The method of claim 1, further comprising the step of enabling the user to link one cell of the spreadsheet to a plurality of controls.
Claim 20
Dependent Claim
26 words
The method of claim 18, wherein a change to the value of said one cell causes said plurality of controls to change in a corresponding manner.
Claim 21
Dependent Claim
45 words
The method of claim 1, wherein if any other cell in the spreadsheet includes a formula that depends upon the value of said cell to determine a result, said result is repetitively recalculated as the user continues to manipulate the control linked to said cell.
Claim 22
Independent Claim
101 words
A method for controlling a value in a selected cell of a spreadsheet, comprising the steps of: (a) inserting a control in a workspace comprising one of the spreadsheet, a chart, a dialog sheet, and a macro sheet; (b) linking the control to the selected cell of the spreadsheet without requiring the user to enter code to effect the link; and (c) varying a parameter of the control by graphically manipulating the control, a value in said selected cell changing in a corresponding manner as the parameter changes as a result of the linking of the control to the selected cell.
Claim 23
Independent Claim
101 words
A method for controlling a value in a selected cell of a spreadsheet, comprising the steps of: (a) inserting a control in a workspace comprising one of the spreadsheet, a chart, a dialog sheet, and a macro sheet; (b) linking the control to the selected cell of the spreadsheet without requiring the user to enter code to effect the link; and (c) varying a parameter of the control by graphically manipulating the control, a value in said selected cell changing in a corresponding manner as the parameter changes as a result of the linking of the control to the selected cell.
Claim 24
Dependent Claim
34 words
The method of claim 21, wherein the control comprises one of a check box, an option box, a list box, a combination list-edit box, a combination drop-down list-edit box, a scrollbar, and a spinner.
Claim 25
Dependent Claim
25 words
The method of claim 21, wherein a change in the value of the specific cell causes a corresponding change in the parameter of the control.
Claim 26
Dependent Claim
30 words
The method of claim 21, further comprising the step of repetitively recalculating all formulas that depend upon the value of the specific cell as the control parameter continues to change.
Claim 27
Dependent Claim
26 words
The method of claim 21, further comprising the step of repetitively updating any chart that depends upon the value of the specific cell in the spreadsheet.
Claim 28
Dependent Claim
76 words
The method of claim 21, further comprising the step of linking the specific cell in the spreadsheet to a plurality of controls, so that a change in the parameter of any of the plurality of controls caused by manipulating the control causes a corresponding change in the value of the specific cell and a change in the value of the specific cell causes a corresponding change in the parameters of each of the plurality of controls.
Claim 29
Dependent Claim
49 words
The method of claim 21, wherein the control comprises one of a list box, a drop-down box, a combination list-edit box, and a combination drop-down list-edit box, further comprising the step of specifying a range of cells in the spreadsheet that are user selectable entries in said one control.
Claim 30
Dependent Claim
21 words
The method of claim 21, further comprising the step of specifying incremental changes in the parameter as the control is manipulated.
Claim 31
Dependent Claim
186 words
A spreadsheet system comprising: a personal computer having a central processing unit, a memory, a display screen, a user interface, and a non-volatile storage unit, said memory storing program instructions that control operation of the central processing unit so that it functions as a spreadsheet application, said program instructions further causing said central processing unit to: (a) display a plurality of control icons on the display screen in order to enable a user to select a control icon with the user interface and to position a graphic control represented by the control icon in a workspace comprising one of the spreadsheet, a chart, a dialog sheet, and a macro sheet, appearing on the display screen; (b) specify a cell in the spreadsheet to which the graphic control selected by the user is linked without requiring the user to enter code to effect the link; and (c) vary a value of said cell as the user changes a parameter of the graphic control by manipulating it with the user interface, said value varying as the control is manipulated because said cell is linked to the graphic control.
Claim 32
Dependent Claim
186 words
A spreadsheet system comprising: a personal computer having a central processing unit, a memory, a display screen, a user interface, and a non-volatile storage unit, said memory storing program instructions that control operation of the central processing unit so that it functions as a spreadsheet application, said program instructions further causing said central processing unit to: (a) display a plurality of control icons on the display screen in order to enable a user to select a control icon with the user interface and to position a graphic control represented by the control icon in a workspace comprising one of the spreadsheet, a chart, a dialog sheet, and a macro sheet, appearing on the display screen; (b) specify a cell in the spreadsheet to which the graphic control selected by the user is linked without requiring the user to enter code to effect the link; and (c) vary a value of said cell as the user changes a parameter of the graphic control by manipulating it with the user interface, said value varying as the control is manipulated because said cell is linked to the graphic control.
Claim 33
Dependent Claim
42 words
The spreadsheet system of claim 29, wherein the program instructions are further operative to cause the parameter of the graphic control to change as the user changes the value in said cell of the spreadsheet that is linked to the graphic control.
Claim 34
Dependent Claim
41 words
The spreadsheet system of claim 29, wherein the program instructions further cause any other cells of the spreadsheet that depend upon the value of said cell to repetitively recalculate as the user continues to change the parameter of the graphic control.
Claim 35
Dependent Claim
57 words
The spreadsheet system of claim 29, wherein the program instructions enable the user to set a plurality of variables that define properties of the graphic control using a dialog box that is opened on the display screen, said properties being retained with the spreadsheet when the spreadsheet is stored as a file on the non-volatile storage unit.
Claim 36
Dependent Claim
45 words
The spreadsheet system of claim 29, wherein the program instructions cause any chart that depends upon the value of said cell that is linked to the graphic control to change as the user manipulates the graphic control with the user interface, to vary the parameter.
Claim 37
Dependent Claim
38 words
The spreadsheet system of claim 29, wherein the control comprise one of a check box, an option box, a list box, a drop-down box, a combination list-edit box, a combination drop-down list-edit box, a scrollbar, and a spinner.
Claim 38
Dependent Claim
56 words
The spreadsheet system of claim 29, wherein the program instructions further enable the user to assign a procedure to the graphic control that is linked to said cell, the value of said cell being updated in response to the user manipulating the graphic control, and the central processing unit then executing the procedure using said value.
References Cited (Backward Citations)
US5226118A
Cited
US5432940A
Cited
US5432903A
Cited
US5367633A
Cited
US5434965A
Cited
US5446842A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-02-23 | 2001-08-25 | 2002-02-24 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-02-23 | 2005-08-25 | 2006-02-24 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-02-23 | 2009-08-25 | 2010-02-24 | $7700.00 | Window Closed / Lapsed |