User defined spreadsheet functions

Details User defined spreadsheet functions User defined spreadsheet functions

2007-09-04

2007-09-04

Hong, Stephen (Department: 2178)

Data processing: presentation processing of document, operator i

Presentation processing of document

Layout

C715S252000, C715S252000, C715S764000, C707S793000

Reexamination Certificate

active

10306937

ABSTRACT:
A method of creating a user-defined function in a spreadsheet application is provided. The user-defined function is callable by a calling label in the spreadsheet application. A formula is received in the spreadsheet application. The formula is transferred to a function sheet of the spreadsheet application to define at least a portion of a function body. An interface is defined by identifying the calling label, an input parameter and a result parameter of the user-defined function. The function body operates on an argument corresponding to the input parameter and generates a result corresponding to the result parameter. The interface is stored in association with the function body to create the user-defined function.

REFERENCES:
patent: 5603021 (1997-02-01), Spencer et al.
patent: 5890174 (1999-03-01), Khanna et al.
patent: 6055548 (2000-04-01), Comer et al.
patent: 6631497 (2003-10-01), Jamshidi et al.
patent: 6779151 (2004-08-01), Cahill et al.
patent: 6978261 (2005-12-01), Cotner et al.
patent: 6988241 (2006-01-01), Guttman et al.
patent: 2002/0091730 (2002-07-01), Bedford et al.
patent: 2002/0188629 (2002-12-01), Burfoot
patent: 2004/0133567 (2004-07-01), Witkowski et al.
patent: 2005/0015714 (2005-01-01), Cahill et al.
patent: 2005/0081141 (2005-04-01), Jonsson
patent: 2006/0036939 (2006-02-01), Hobbs et al.
patent: 2006/0224946 (2006-10-01), Barrett et al.
patent: 2007/0055945 (2007-03-01), Weber et al.
Microsoft Excel 2000, Screenshots, Dec. 31, 1999, pp. 1-3 and 8-11.
Microsoft Visual Basic 6.0, Screenshots, Dec. 31, 1999, pp. 4-7 (Same as Excel 2000 Screenshots).
Jones et al, “A User-Centred Approach to Functions in Excel”, Jun. 30, 2003, pp. 1-12, http://research.microsoft.com/˜simonpj/Papers/excel/excel.pdf.
Chris Clack and Lee Braine, “Object-Oriented Functional Spreadsheets”, Sep. 1997, Proc. 10th Glasgow Workshop on Functional Programming (GlaFP'97), pp. V11/1-116.
Ambler, Allen L; “Forms: Expanding the Visualness of Sheet Language” from Workshop on Visual Languages Aug. 19-21, 1987, Lenkoping Sweden; pp. 105-117.
Ambler, Allen L. and Burnet, Margaret M.; “Visual Forms of Iteration that Preserve Single Assignment” Journal of Visual Languages and Computing 1990 (1) pp. 159-181.
Ambler, Allen; “The Formulate Visual Programming Language : Representing Structured Data” Dr. Dobb's Journal, Aug. 1999 pp. 21-28.
Burnett, M.; Atwood, J.; Walpole-Djang, R.; Gottfried, H., Reichwein, J.; and Yang, S.; “Forms/3: A First-Order Visual Language to Explore the Boundaries of the Spreadsheet Paradigm”; Journal of Functional Programming; 2001; 51 pages.

Affiliated with

Also associated with

Rating

User defined spreadsheet functions does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with User defined spreadsheet functions, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and User defined spreadsheet functions will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3764877