Systems and methods providing dynamic spreadsheet functionality

Details Systems and methods providing dynamic spreadsheet functionality Systems and methods providing dynamic spreadsheet functionality

2006-07-25

2006-07-25

Hong, Stephen (Department: 2178)

Data processing: presentation processing of document, operator i

Presentation processing of document

Layout

C715S252000, C715S252000, C715S252000, C715S252000, C715S252000

Reexamination Certificate

active

07082569

ABSTRACT:
An advantageous system and method are provided for supporting and/or enabling the creation of dynamic reports and/or data presentation(s) in connection with a spreadsheet-based application or program. The disclosed system and method offer a full complement of spreadsheet-based formatting and calculation capabilities. In addition, the system and method of the present disclosure may be used in conjunction with and/or incorporated as part of spreadsheet-based application(s) and/or program(s) found on stand-alone clients and/or networked clients. The disclosed system and method generally include an electronic spreadsheet having a plurality of cells that are arrayed in a defined number of columns and rows, a database in communication with the electronic spreadsheet, and an expansion formula that functions to control retrieval of data from the database and automatically varies/expands at least one of the defined number of columns and rows to accommodate the data retrieval.

REFERENCES:
patent: 4989141 (1991-01-01), Lyons et al.
patent: 5165012 (1992-11-01), Crandall et al.
patent: 5189608 (1993-02-01), Lyons et al.
patent: 5233513 (1993-08-01), Doyle
patent: 5247611 (1993-09-01), Norden-Paul et al.
patent: 5303146 (1994-04-01), Ammirato et al.
patent: 5321803 (1994-06-01), Ditter, Jr.
patent: 5359724 (1994-10-01), Earle
patent: 5371675 (1994-12-01), Greif et al.
patent: 5381332 (1995-01-01), Wood
patent: 5390296 (1995-02-01), Crandall et al.
patent: 5444842 (1995-08-01), Bentson et al.
patent: 5682526 (1997-10-01), Smokoff et al.
patent: 5701499 (1997-12-01), Capson et al.
patent: 5727161 (1998-03-01), Purcell et al.
patent: 5799286 (1998-08-01), Morgan et al.
patent: 5883623 (1999-03-01), Cseri
patent: 5893124 (1999-04-01), Ogaki et al.
patent: 5933830 (1999-08-01), Williams
patent: 5991741 (1999-11-01), Speakman et al.
patent: 6026459 (2000-02-01), Huppenthal
patent: 6055548 (2000-04-01), Comer et al.
patent: 6073107 (2000-06-01), Minkiewicz et al.
patent: 6076152 (2000-06-01), Huppenthal et al.
patent: 6115690 (2000-09-01), Wong
patent: 6128602 (2000-10-01), Northington et al.
patent: 6317750 (2001-11-01), Tortolani et al.
patent: 0997834 (2000-05-01), None
PCT International Search Report dated Jun. 4, 2002.
http://www.srcsoftware.com/inet—bud.htm, I*Net Budgeting—The Web Enabled Budgeting Solution from SRC, 2000.
Hyperion Essbase Release 6, Spreadsheet Add-in User's Guide for Excel, Internet Article: Hyperion Essbase. Hyperion Solutions Corporation, 'Online! 2000, XP002224232 Sunnyvale, CA Retrieved from the Internet: <URL:http://www.essbase.com/techdocs/essbase/essbase—60/Docs/PDF/essexcel.pdf> 'retreived on Dec. 09, 2002! part of Chapter 2: A Basic Hyperion Essbase Tutorial part of Chapter 3: An Advanced Hyperion Essbase Tutorial, pp. 2-49-pp. 2-91; pp. 3-9-pp. 3-57.
Applix TM1 Perspectives, Internet Article. Applix, Inc., 'Online! Mar. 1999, XP002224231 Retrieved from the Internet; <URL:http://www.klesse.de/res/pdf—tm1perspectives.pdf> 'retrieved on Dec. 9, 2002! Kapitel 4: Arbeitsblatter für Datenanalyseverwenden, p. 4-1-p. 4-36.
Getting Started With OLAP@Work for Microsoft Excel, Internet Article: OLAP@Work Inc., 'Online! 1999, XP002224233 Retrieved from the Internet: <URL:http://www.groovemarketing.ca/pdf/Simp—GS.PDF> 'retrieved on Dec. 9, 2002!.
Shiena, M., OutlookSoft's Everest TM: A Collaborative Portal For Enterprise Budgeting, Internet Article: The Aberdeen Group Impact Report, 'Online! Aug. 5, 2000, XP002224236 Retrieved From the Internet:: <URL:http://web.archive.org/web/20021209072834/http://www.outlooksoft.com/whitepapers/OS—aberdeen.pdf>, 'retrieved on Dec. 9, 2002!.
Pendse, N., OLP Omnipresent, BYTE, 'Online! Feb. 1998, XP002224235, Retrieved from the Internet: <URL:http://www.byte.com/art/9802/sec6/art7.htm> 'retrieved on Dec. 6, 2002!.
European Search Report dated Jan. 2, 2003.

Affiliated with

Also associated with

Rating

Systems and methods providing dynamic spreadsheet functionality does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Systems and methods providing dynamic spreadsheet functionality, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Systems and methods providing dynamic spreadsheet functionality will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3600704