Patent US5121499A successfully refreshed from Google Patents.
US5121499A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method for controlling the order of editing cells in a spreadsheet by evaluating entered next cell attribute of current cell
Assignee: International Business Machines Corp
•
Filing: 1991-07-25
•
Granted: 1992-06-09
•
Expires: 2011-07-25
Abstract
Abstract A mechanism allows for programming the order of cells for an operator to enter data in a spreadsheet. Each cell of the spreadsheet may be provided with a "next cell" attribute, and these attributes as well as other attributes for the cells are stored in a table. The "next cell" attribute may be a constant, such as the name of the next cell, or it may be a logic expression so that the next cell to be edited can be different depending on some condition. When the operator presses the NEXT CELL key, the "next cell" attribute is searched by accessing the attribute table, and if a "next cell" attribute is found, it is evaluated to determine the next cell to be edited.
Inventors
- 👤 Rex A. McCaskill
- 👤 Beverly H. Machart
- 👤 Harry E. O'Steen
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 20:50
CPC Classifications
G; G06; G06F; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18; G06F40/174
Claims Analysis
Total Claims: 8
Claim 1
Independent Claim
263 words
A computer implemented method of setting up a spreadsheet application program on a computer, said application program displaying a spreadsheet comprising intersecting rows and columns forming cells of the spreadsheet, each of said cells being defined by a data structure accessed by said spreadsheet application program and evaluated by said computer for the processing of displayed data, wherein the order of data entry to the cells of the spreadsheet by a user is controlled by the computer so that a user of the spreadsheet application program is directed from a current cell to a next cell of the spreadsheet for the purpose of making entries int eh cells of the spreadsheet in an order in which data is to be entered comprising the steps of; providing in said spreadsheet application program at least some of the cells of the spreadsheet with a "next cell" attribute as part of the data structure which defines the cell and which is evaluated by said computer to determine the next cell after the current cell for the entry of data; accessing an attribute editing function of said spreadsheet application program; entering data in fields of the data structure defining the "next cell" attribute of a selected plurality of cells of the spreadsheet to define said order of data entry to said selected plurality of cells of the spreadsheet; responding to a next cell command from the user by evaluating the entered "next cell" attribute of the current cell to determine the next cell to edit; and moving to the next cell identified by the "next cell" attribute.
Claim 2
Dependent Claim
263 words
A computer implemented method of setting up a spreadsheet application program on a computer, said application program displaying a spreadsheet comprising intersecting rows and columns forming cells of the spreadsheet, each of said cells being defined by a data structure accessed by said spreadsheet application program and evaluated by said computer for the processing of displayed data, wherein the order of data entry to the cells of the spreadsheet by a user is controlled by the computer so that a user of the spreadsheet application program is directed from a current cell to a next cell of the spreadsheet for the purpose of making entries int eh cells of the spreadsheet in an order in which data is to be entered comprising the steps of; providing in said spreadsheet application program at least some of the cells of the spreadsheet with a "next cell" attribute as part of the data structure which defines the cell and which is evaluated by said computer to determine the next cell after the current cell for the entry of data; accessing an attribute editing function of said spreadsheet application program; entering data in fields of the data structure defining the "next cell" attribute of a selected plurality of cells of the spreadsheet to define said order of data entry to said selected plurality of cells of the spreadsheet; responding to a next cell command from the user by evaluating the entered "next cell" attribute of the current cell to determine the next cell to edit; and moving to the next cell identified by the "next cell" attribute.
Claim 3
Dependent Claim
22 words
The method recited in claim 1 wherein the "next cell" attribute is a constant identifying a predetermined different cell in the spreadsheet.
Claim 4
Dependent Claim
40 words
The method recited in claim 1 wherein the "next cell" attribute is logic expression, said method further comprising the computer performed step of evaluating said logic expression to determine the identity of the next cell to edit in the spreadsheet.
Claim 5
Dependent Claim
75 words
The method recited in claim 1 further comprising the steps of: accessing a first cell of said plurality of selected and edited cells; locating cell attributes of a currently accessed cell; evaluating said "next cell" attribute and, upon entry of data in said currently accessed cell, moving to a cell identified by said "next cell" attribute; and repeating said locating, evaluating and moving steps until data has been entered in all of said selected cells.
Claim 6
Dependent Claim
150 words
A computer implemented data entry method for an electronic spreadsheet running on a computer comprising the steps of: providing the cells of the spreadsheet with a "next cell" attribute as part of the data structure which defines the cells; accessing an attribute editing function for the spreadsheet application program for each of a plurality of selected cells of the spreadsheet; inputting data in the "next cell" attribute data structure for said selected cells, which data defines an order of data entry for said selected cells of the spreadsheet; accessing a first cell of said plurality of selected cells; locating cell attributes of a currently accessed cell; evaluating said "next cell" attribute and, upon entry of data in said currently accessed cell, moving to a cell identified by said "next cell" attribute; and repeating said locating, evaluating and moving steps until data has been entered in all of said selected cells.
Claim 7
Dependent Claim
150 words
A computer implemented data entry method for an electronic spreadsheet running on a computer comprising the steps of: providing the cells of the spreadsheet with a "next cell" attribute as part of the data structure which defines the cells; accessing an attribute editing function for the spreadsheet application program for each of a plurality of selected cells of the spreadsheet; inputting data in the "next cell" attribute data structure for said selected cells, which data defines an order of data entry for said selected cells of the spreadsheet; accessing a first cell of said plurality of selected cells; locating cell attributes of a currently accessed cell; evaluating said "next cell" attribute and, upon entry of data in said currently accessed cell, moving to a cell identified by said "next cell" attribute; and repeating said locating, evaluating and moving steps until data has been entered in all of said selected cells.
Claim 8
Dependent Claim
81 words
The data entry method for an electronic spreadsheet recited in claim 5 wherein said data which defines an order of data entry comprises for at least one of said selected cells a Boolean expression which, when evaluated, identifies first or second cells of said plurality of selected cells of the spreadsheet, said method further comprising the steps of: evaluating said Boolean expression ; and if said Boolean expression is true moving to said first cell; otherwise, moving to said second cell.
References Cited (Backward Citations)
EP0075742A1
Cited
US4520457A
Cited
US4470129A
Cited
US4586158A
Cited
US4633430A
Cited
US4646250A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1995-06-09 | 1995-12-09 | 1996-06-09 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 1999-06-09 | 1999-12-09 | 2000-06-09 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2003-06-09 | 2003-12-09 | 2004-06-09 | $7700.00 | Window Closed / Lapsed |