Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1998-12-31
2003-10-28
Hong, Stephen S. (Department: 2178)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
06640234
ABSTRACT:
TECHNICAL FIELD
The present invention generally relates to formulas and formatting applied to cells in an electronic spreadsheet. More particularly, the present invention relates to the detection in an electronic spreadsheet of a list of cells having consistent formulas and/or formatting and extension of said formulas and/or formatting to include a cell appended to or edited within said list.
BACKGROUND OF THE INVENTION
Electronic spreadsheets organize information into a matrix of columns and rows. Each column within a row is referred to as a cell. Each cell of an electronic spreadsheet stores a data element or a formula that uses data elements from other cells to calculate a desired result. As an example, a formula may be used to calculate the sum of data elements stored in the cells comprising a column or a row of an electronic spreadsheet. To ease computation, electronic spreadsheets include built-in functions that perform most standard mathematical operations.
For on-screen viewing and printed output, electronic spreadsheets may also include functionality to apply a variety of formatting options to a cell. Exemplary formatting options include: font face, color, size and style; border style and color; background color; conditional formatting rules; etc. Formatting may usually be accomplished per cell or per a group of cells. Thus, a typical electronic spreadsheet may include a variety of different formats at any given time.
Prior electronic spreadsheets require a user to manually apply formulas and/or formatting to selected cells through commonly known user interface techniques, such as selecting options from a pull-down menu. Skilled users of such prior systems may also take advantage of built-in short-cuts, such as copy/paste functions, to extend formulas and/or formatting to include newly selected cells. In particular, shorts-cuts have proven effective for extending formulas and/or formatting to include cells that are appended to or edited within a list of cells having a consistent formula or format or aggregating formulas. However, short-cuts do not eliminate the need for manual user interaction in order to extend formulas and/or formatting. Thus, a significant drawback found in prior electronic spreadsheets is the inability to automatically extend, without instruction from the user, a formula or format to include a cell that is appended to or edited within a list of cells.
Accordingly, there is a need for an electronic spreadsheet that is able to recognize a list of cells having a consistent formula and/or formatting and/or aggregating formulas applied thereto and to automatically extend such consistent formula and/or formatting and/or aggregating formulas to include a cell that is appended to or edited within the list.
SUMMARY OF THE INVENTION
The present invention fulfills the needs in the art by providing an electronic spreadsheet with functionality for automatically extending, without user instruction, formulas and/or formatting to include new cells. Since the present invention extends formatting and formulas without user instruction to do so, care is taken to insure that the user would desire such an operation. Thus, the present invention only automatically extends formatting and formulas to include cells that appear to be extensions of or within existing lists of cells having consistent formulas or formatting applied thereto. A list is defined herein as a number of successive cells, in a row or a column, having a consistent data type. A previously blank newly edited cell is an extension of a list if it also has the consistent data type. Once an extension of a list is identified, the list is examined for consistent formatting and/or formulas and/or aggregating formulas. If the list has consistent formatting, the consistent formatting is automatically applied to the previously blank newly edited cell. If a first consistent formatting exists in a column list and a second consistent formatting exists in a row list, the first formatting of the column list may be given priority and applied to the previously blank newly edited cell. List-related formulas may exist in two forms: first, a number of the rows above the previously blank newly edited cell may have the same formula, with all supporting rows filled in on the same row as the previously blank newly edited cell, applied thereto; and second, an aggregating formula may reference a number of the cells in the list. If either of these types of formulas are detected they are automatically updated to include the previously blank newly edited cell.
REFERENCES:
patent: 5247611 (1993-09-01), Norden-Paul et al.
patent: 5255356 (1993-10-01), Michelman et al.
patent: 5396587 (1995-03-01), Reed et al.
patent: 5418898 (1995-05-01), Zand et al.
patent: 5418902 (1995-05-01), West et al.
patent: 5471575 (1995-11-01), Giansante
patent: 5510980 (1996-04-01), Peters
patent: 5535324 (1996-07-01), Alvarez et al.
patent: 5553215 (1996-09-01), Kaethler
patent: 5598519 (1997-01-01), Narayanan
patent: 5600584 (1997-02-01), Schlafly
patent: 5604854 (1997-02-01), Glassey
patent: 5685001 (1997-11-01), Capson et al.
patent: 5701499 (1997-12-01), Capson et al.
patent: 5708827 (1998-01-01), Kaneko et al.
patent: 5752253 (1998-05-01), Geymond et al.
patent: 5812983 (1998-09-01), Kumagai
patent: 5819293 (1998-10-01), Comer et al.
patent: 5881381 (1999-03-01), Yamashita et al.
patent: 5890174 (1999-03-01), Khanna et al.
patent: 5926822 (1999-07-01), Garman
patent: 5987481 (1999-11-01), Michelman et al.
patent: 6055548 (2000-04-01), Comer et al.
patent: 6055549 (2000-04-01), Takano
patent: 6112214 (2000-08-01), Graham et al.
patent: 6134563 (2000-10-01), Clancey et al.
patent: 6138130 (2000-10-01), Adler et al.
patent: 6216139 (2001-04-01), Listou
patent: 6292811 (2001-09-01), Clancey et al.
Anonymous, “Method and Apparatus for Automatic Character line fill of Decimal Fields.” IBM technical Disclosure Bulletin vol. 36, No. 10, pp. 155-156, Oct. 1993.*
Miastkowski, S. “Excel 5.0—a Quick-start Guide to Using Excel's Powerful New Features.” Macworld vol. 11, No. 10, pp. 146-151, Oct. 1994.*
Microsoft Corp. Help file on ‘series’ ‘repeated entries’, and ‘Auto Fill’ (screen shot) of Microsoft Excel 97 (1996), 6 pages, taken Mar. 2001.*
Crew, Ed, ed. “Lesson in Excel 97: Lesson One . . . ”, Web page tutorial on Excel 97 downloaded from pathways.uwe.ac.uk/Edict/Excel/Excel-01.asp on Mar. 29, 2002, 6 pages.*
Sonic.net. “Microsoft Excel 5.0 (tips on using MS Excel 5.0 repeat entries)” downloaded from www.sonic.net/~sbaumann/excel.html 5 pages on Apr. 2, 2002.
Coffen Robert Wayne
Igra Mark S.
Lowry Kent Rogers
Matteson Eric Lawrence
Hong Stephen S.
Merchant & Gould
Microsoft Corporation
LandOfFree
Extension of formulas and formatting in an electronic... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Extension of formulas and formatting in an electronic..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Extension of formulas and formatting in an electronic... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3140639