Method and apparatus for using label references in spreadsheet f

Details Method and apparatus for using label references in spreadsheet f Method and apparatus for using label references in spreadsheet f

1997-07-01

1999-11-16

Lintz, Paul R.

Data processing: database and file management or data structures

Database design

Data structure types

345333, 345335, 707500, 707503, 707507, G06F 1730

Patent

active

059874813

ABSTRACT:
A system for referencing a range of cells in a spreadsheet formula by using label references. The label references are used to identify labels within the spreadsheet which, in turn, refer to a range of cells. First, a formula is parsed in order to identify any label references within the formula. Second, the cells of the spreadsheet are searched in order to generate a list of labels within the spreadsheet that match the label references identified in the formula. Third, each of the labels are examined and a preferred label set is selected. The preferred label set represents the actual labels that were intended by the formula references. Finally, the range of cells referenced by the preferred label set is determined. Thus, a user is able to reference a cell within a spreadsheet table by entering column and row labels that intersect at that cell.

REFERENCES:
patent: 5101476 (1992-03-01), Kukla
patent: 5317686 (1994-05-01), Salas et al.
patent: 5371675 (1994-12-01), Greif et al.
patent: 5784545 (1998-07-01), Anderson et al.
patent: 5832532 (1998-11-01), Kennedy et al.
patent: 5842018 (1998-11-01), Atkinson et al.
patent: 5883623 (1999-03-01), Cseri
Improv 1.0, Lootus Development Corp., CMP Accession No.: CRW19930215S9852, Computer Retail Week, n 336, 15, Feb. 1993.
Quattro Pro 5.0, Borland International Inc., CMP Accession No.: CRW19930920S3838, Computer Retail Week, 1993, n 348, 17, Sep. 1993.
Quattro Pro 5.0 for Windows Workgroup Edition * 1-2-3 Release 4.01 * Excel Version 5.0--Spreadsheet Champs In The Spotlight, Jonathan Blackwood, Windows Magazine, 1994, n 504, 238 CMP Accession No.: WIN19940401S4374, Apr. 1994.

Affiliated with

Also associated with

Rating

Method and apparatus for using label references in spreadsheet f does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for using label references in spreadsheet f, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for using label references in spreadsheet f will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1337690