Method for controlling the order of editing cells in a spreadsheet by evaluating entered next cell attribute of current cell

• US 5,121,499 A
• Filed: 07/25/1991
• Issued: 06/09/1992
• Est. Priority Date: 05/30/1985
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Machart, Beverly H., McCaskill, Rex A., O'Steen, Harry E.
• Primary Examiner(s): Lee, Thomas C.
• Assistant Examiner(s): DONAGHUE, LARRY D
• Application Number:
  US07/735,698
• Time in Patent Office: 320 Days
• Field of Search: 364/419, 364/200 MS File, 364/900 MS File
• US Class Current: 715/212
• CPC Class Codes: G06F 40/174 Form filling; Merging
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

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.

Claims

1. 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.

2. The method recited in claim 1 wherein the "next cell" attribute is a constant identifying a predetermined different cell in the spreadsheet.

3. 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.

4. 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.

5. 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.

6. 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.