Method and system for constructing a formula in a spreadsheet

Details Method and system for constructing a formula in a spreadsheet Method and system for constructing a formula in a spreadsheet

1995-11-16

1999-03-30

Nguyen, Phu K.

Data processing: database and file management or data structures

Database design

Data structure types

G06F 1500

Patent

active

058901744

ABSTRACT:
A method and system for assisting a user in constructing a formula in a cell of a spreadsheet operating on a computer system. A function dialog box is displayed that lists various functions that may be selected by the user to be entered into the formula. By selecting a button in the function dialog box, an insert function dialog box is displayed that lists additional functions by category. When the user selects a function, a parameter dialog box associated with the selected function is displayed. Parameters may include cell addresses as well as numerical or other data entered directly by the user. The parameter dialog box displays the formula as it is being constructed. After the parameters have been entered, a result dialog box is displayed that allows the user to select the result cell in which to place the formula. The user selects the result cell and the result dialog box is removed from the display screen, the formula is entered in the result cell, and the result of the formula is displayed in the result cell.

REFERENCES:
patent: 5255356 (1993-10-01), Michelman et al.
patent: 5280575 (1994-01-01), Young et al.
patent: 5652889 (1997-07-01), Sites

Affiliated with

Also associated with

Rating

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1225771