Method and system for formulaically redirecting and...

Details Method and system for formulaically redirecting and... Method and system for formulaically redirecting and...

2004-03-30

2008-10-28

Hutton, Doug (Department: 2176)

Data processing: presentation processing of document, operator i

Presentation processing of document

Spreadsheet

C715S220000, C715S267000

Reexamination Certificate

active

07444584

ABSTRACT:
Methods and systems are provided for formulaically redirecting and modifying formula set operations in a spreadsheet application. A spreadsheet application may link the contents of one spreadsheet cell to other spreadsheet cells so that changes in one cell are reflected in linked cells. Three spreadsheet functions are provided which allow for formulaically redirecting and modifying formula set operations in a spreadsheet application. A first spreadsheet function, SETATREF, redirects a formula set in one spreadsheet cell to another spreadsheet cell. The SETATREF function may also allow a formula set to one spreadsheet cell to be redirected to and modified in a second spreadsheet cell. A second spreadsheet function, SETATREFEXPR, redirects a formula set to a formulaic location within a spreadsheet cell. A third function, SETATREFEVAL, allows for an evaluation of a formula at formula set-time.

REFERENCES:
patent: 5499180 (1996-03-01), Ammirato et al.
patent: 5708827 (1998-01-01), Kaneko et al.
patent: 5721847 (1998-02-01), Johnson
patent: 5883623 (1999-03-01), Cseri
patent: 5890174 (1999-03-01), Khanna et al.
patent: 5893123 (1999-04-01), Tuinenga
patent: 6157934 (2000-12-01), Khan et al.
patent: 6225996 (2001-05-01), Gibb et al.
patent: 6430584 (2002-08-01), Comer et al.
patent: 6438565 (2002-08-01), Ammirato et al.
patent: 6640234 (2003-10-01), Coffen et al.
patent: 6701485 (2004-03-01), Igra et al.
patent: 7082569 (2006-07-01), Voshell
patent: 7266763 (2007-09-01), Peyton-Jones et al.
patent: 2002/0091871 (2002-07-01), Cahill et al.
patent: 2004/0044954 (2004-03-01), Hosea
patent: WO 02/17074 (2002-02-01), None
A. Gupta, “Application of PC Spreadsheet Software for Non-linear Parameter Optimization”, JCPT, vol. 37, No. 3, Mar. 1998, pp. 51-54.
P. Blattner et al., “Microsoft Excel Functions in Practice”, Sep. 1999, pp. 1-14.
C. Dasgupta et al., “Excel Spreadsheet Tutorial”, Revised Feb. 1999, pp. 2-58.
Shiozawa et al., “3D Interactive Visualization for Inter-Cell Dependencies of Spreadsheet”, Department of Information and Computer Science, Keio University, Yokohama Japan, pp. 1-4, no date.
M. Chipman, “Editing XML Data with Microsoft Office Word 2003 and Microsoft Office Excel 2003”, MCW Technologies, Feb. 2004, pp. 1-8.

Affiliated with

Also associated with

Rating

Method and system for formulaically redirecting and... 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 system for formulaically redirecting and..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for formulaically redirecting and... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4009393