Method and system for direct cell formatting in a spreadsheet

Details Method and system for direct cell formatting in a spreadsheet Method and system for direct cell formatting in a spreadsheet

1994-11-08

1997-01-28

Feild, Joseph H.

395603, G06F 1730

Patent

active

055985190

ABSTRACT:
A method and system wherein data elements in cells of a spreadsheet may be assigned character attribute information, such as font type, font size, bold, italics, underline, etc., wherein the character attribute information is referred to as a format. Format information is stored in a font palette table. Each cell in the spreadsheet is identified by a unique identifier that includes a row identifier and a column identifier. A direct cell format (DCF) table stores an index into the font palette in association with the unique cell identifier. When a cell is to be displayed, the system looks up the stored index in the direct cell format table, retrieves the format information from the font palette, and applies the format to the cell data elements. When a new format is created, the system determines if the format is already extant. If so, the index to the extant format is stored in the direct cell format table. A wild card character stored as a row identifier or column identifier indicates that the entire column or row, respectively, has the same format. Character format information is not stored in individual cells, and cells may share the same format combinations by merely setting the cell index to point to a desired format information in the font palette.

REFERENCES:
patent: 4912629 (1990-03-01), Shuler, Jr.
patent: 5119465 (1992-06-01), Jack et al.
patent: 5231577 (1993-07-01), Koss
patent: 5280575 (1994-01-01), Young et al.
patent: 5295256 (1994-03-01), Bapat
patent: 5312478 (1994-05-01), Reed et al.
patent: 5317686 (1994-05-01), Salas et al.
patent: 5519861 (1996-05-01), Ryu et al.
Bruce, "Spreadsheet Showdown", Computer Shopper v14 n5, pp. 496-508. May 1994.
Anonymous, "Lab Test: Advanced Spreadsheets", PC User n228, pp. 104-121. Feb. 1994.

Affiliated with

Also associated with

Rating

Method and system for direct cell formatting 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 direct cell formatting 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 direct cell formatting in a spreadsheet will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-946922