Methods for compiling formulas stored in an electronic spreadshe

Details Methods for compiling formulas stored in an electronic spreadshe Methods for compiling formulas stored in an electronic spreadshe

1995-07-18

1997-05-27

Kriess, Kevin A.

39518501, 3951851, 395800, 395940, G06F 1100

Patent

active

056339984

ABSTRACT:
An electronic spreadsheet system of the present invention includes a Formula Evaluator having a preferred interface and methods for compiling spreadsheet formulas into native machine language for a target processor/coprocessor. Methods are provided for improved cell lookups, whereby a system memory address for a cell record may be compiled directly into the machine language sequence for a compiled formula. Additional methods are provided for simplifying error checking. The methods adapt NaN (IEEE format) values for encoding spreadsheet ERR and NA values, so that the on-chip logic of the coprocessor may be employed for correctly propagating ERR and NA values. Preferred auditing methodology is also described, which includes further modifying the format of NaN values so that a NaN encoding an ERR or NA also embeds the address of the originating cell (i.e., the first cell which first gave rise to the ERR or NA value).

REFERENCES:
patent: 4912657 (1990-03-01), Saxton et al.
patent: 5293615 (1994-03-01), Amada
patent: 5317687 (1994-05-01), Salas et al.
patent: 5371675 (1994-12-01), Greif et al.
"Programming the 80387 Coprocessor," Prakash Chandra, BYTE, Mar. 1988, pp. 207-215.
"Theory and Practice (Floating-Point Arithmetic)", Tom Ochs Computer Language, vol. V6 N 3, Mar. 1989, pp.. 67-76.
"Understanding the IEEE Floating-Point Standard," Allen Samuels, Microprocessor Report. Apr. 15, 1992, p. 16 (4).

Affiliated with

Also associated with

Rating

Methods for compiling formulas stored in an electronic spreadshe does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Methods for compiling formulas stored in an electronic spreadshe, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Methods for compiling formulas stored in an electronic spreadshe will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2335352