Method and system for direct cell formatting in a spreadsheet
First Claim
1. An improved method of formatting cells and characters in a computer spreadsheet, comprising the steps of:
- allocating a worksheet data array having a plurality of cells containing data elements;
allocating a first table for storing cell format information which represents the appearance of the cells and the data elements within the cells;
allocating a second table separately from said data array for storing an index pointing to an item of cell format information stored in the first table, the second table storing the index in association with cell identifying information;
generating an index to the item of cell format information stored in the first table;
storing the cell format information in the first table according to the index;
storing the index to the cell format information in at least one location in the second table; and
displaying a selected cell in accordance with the stored cell format information.
2 Assignments
0 Petitions
Accused Products
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.
-
Citations
46 Claims
-
1. An improved method of formatting cells and characters in a computer spreadsheet, comprising the steps of:
-
allocating a worksheet data array having a plurality of cells containing data elements; allocating a first table for storing cell format information which represents the appearance of the cells and the data elements within the cells; allocating a second table separately from said data array for storing an index pointing to an item of cell format information stored in the first table, the second table storing the index in association with cell identifying information; generating an index to the item of cell format information stored in the first table; storing the cell format information in the first table according to the index; storing the index to the cell format information in at least one location in the second table; and displaying a selected cell in accordance with the stored cell format information. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. An improved method of formatting cells and characters in a spreadsheet, comprising the steps of:
-
allocating a worksheet data array having a plurality of cells containing data elements; allocating a first table for storing cell format information which represents the appearance of the cells and the data elements within the cells; allocating a second table separate from said data array for storing an index pointing to cell format information stored in the first table; combining predetermined elements of cell format information to create a default cell format; generating an index to the default cell format; storing the default cell format in the first table according to the index; storing the index to the default cell format in at least one location in the second table; and initializing each of the cells with the index to point to the default cell format. - View Dependent Claims (11, 12, 13, 14)
-
-
15. For use with a computer application program, a system for displaying character information with formatting, comprising:
-
a data array for storing information corresponding to a character or group of characters that are displayed according to a selected one of a plurality of display formats; a first table for storing a plurality of display formats; a second table for storing an index to one of said plurality of display formats in association with an identifier associated with a character or group of characters stored in said data array; means responsive to being provided with said identifier for retrieving said index to said one of said plurality of display formats from said second table; means responsive to said retrieved index for retrieving a selected one of said plurality of display formats from said first table; and means for imposing said selected one of said plurality of display formats upon said character or group of characters in said data array. - View Dependent Claims (16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)
-
-
27. A method of formatting a spreadsheet having data stored in a data array and displayed in a plurality of cells on a display, comprising the steps of:
-
allocating a first table that stores a plurality of display formats; generating an index for each display format in the first table; allocating a second table separately from the data array that stores a plurality of cell identifiers in association with indices into said first table; storing an index to each utilized display format in said second table; associating one of the indices with each cell in said second table; and displaying each cell in the spreadsheet according to the display format stored in the first table for the index associated with the cell. - View Dependent Claims (28, 29)
-
-
30. An improved spreadsheet structure comprising:
-
a plurality of data cells displayed according to one or more display formats, each data cell associated with a cell identifier; a first table for storing the display formats; a second table separate from said data array for storing an index to one of the display formats stored in said first table in association with a cell identifier; and means for associating one of the indices with the display identifier for each cell such that the data in each cell is displayed according to the display format associated with the index for the cell. - View Dependent Claims (31, 32, 33, 34, 35, 36)
-
-
37. An improved method of formatting cells and characters in a computer spreadsheet, comprising the steps of:
-
allocating a worksheet having a plurality of cells containing data elements; allocating a first table for storing cell format information which represents the appearance of the cells and the data elements within the cells; allocating a second table for storing an index pointing to an item of cell format information stored in the first table; generating an index to the item of cell format information stored in the first table; storing the cell format information in the first table according to the index; storing the index to the cell format information in at least one location in the second table; for a new format, searching the first table to determine if the new format is already extant; if the new format is already extant, assigning the index for the extant format to the cell identifier in the second table; if the new format is not already extant, creating a new index to the next location in the first table and assigning the new index for the new format to the cell identifier in the second table; maintaining a format usage counter indicative of the instances of usage of a predetermined format; storing the usage counter in the first table in association with the format information; incrementing the format usage counter each time a new or modified format is created that corresponds to the predetermined format; locating an entry in the second table corresponding to a selected cell utilizing a binary search; if the binary search indicates that a wild card character is stored in either a row identifier or a column identifier for the selected cell, retrieving the index for the initial entry of the entire row or column, respectively; otherwise, retrieving the index associated with the row identifier and column identifier of the selected cell; utilizing the retrieved index from the preceding two retrieving steps to retrieve cell format information from the first table; displaying the selected cell in accordance with the stored cell format information. - View Dependent Claims (38, 39)
-
-
40. For use with a computer application program, a system for displaying character information with formatting, comprising:
-
a first table for storing a plurality of display formats; a second table for storing an index to one of said plurality of display formats in association with an identifier associated with a character or group of characters; a character or group of characters that are displayed according to one of said plurality of display formats; means responsive to being provided with said identifier for retrieving said index to said one of said plurality of display formats from said second table; means responsive to said retrieved index for retrieving a selected one of said plurality of display formats from said first table; and means for imposing said selected one of said plurality of display formats upon said character or group of characters; means for searching said first table to determine if a particular display format is already stored therein, wherein for a new format, said searching means searches said first table to determine if said new format is already extant; means for assigning the index for an extant format to said identifier in said second table if the new format is already extant; means for creating a new index to another location in said first table and assigning said new index for the new format to said identifier in said second table if the new format is not already extant; means for maintaining a format usage counter indicative of the instances of usage of a predetermined format; means for storing said format usage counter in said first table in association with said display formats; and means for incrementing said format usage counter each time a new or modified format is created that corresponds to said predetermined format. - View Dependent Claims (41)
-
-
42. An improved method of formatting cells and characters in a spreadsheet, comprising the steps of:
-
allocating a worksheet having a plurality of cells containing data elements; allocating a first table for storing cell format information which represents the appearance of the cells and the data elements within the cells; allocating a second table for storing an index pointing to cell format information stored in the first table; combining predetermined elements of cell format information to create a default cell format; generating an index to the default cell format; storing the default cell format in the first table according to the index; storing the index to the default cell format in at least one location in the second table; and initializing each of the cells with the index to point to the default cell format; recalling the index for a cell of interest; recalling the format pointed to by the index; modifying the cell format information in accordance with a desired format to generate modified cell format information; determining whether the modified cell format information is already extant in the first table; in response to determination that the modified cell format information is already extant in the first table, incrementing a format usage counter and storing the index to the extant format in the second table; and in response to determination that the modified cell format information is not already extant in the first table, storing the modified cell format information in the first table, creating a new index to the modified cell format information, and storing the new index in the second table. - View Dependent Claims (43)
-
-
44. A method of formatting a spreadsheet having data displayed in a plurality of cells, comprising the steps of:
-
allocating a first table that stores a plurality of display formats; generating an index for each display format in the first table; allocating a second table that stores a plurality of cell identifiers in association with indices into said first table; storing an index to each utilized display format in said second table; associating one of the indices with each cell in said second table; displaying each cell according to the display format for the index associated with the cell; in response to a user command to modify a format for a selected cell, creating a modified display format; searching the first table to determine if the modified format is already extant; if the modified format is already extant, incrementing a format usage counter associated with the extant display format; assigning the index for the extant display format to the selected cell; and displaying the selected cell according to the modified format.
-
-
45. An improved spreadsheet structure comprising:
-
a plurality of data cells displayed according to one or more display formats; a first table for storing the display formats; a second table for storing an index to one of the display formats stored in said first table in association with a cell identifier; means for associating one of the indices with the display identifier for each cell such that each cell is displayed according to the display format associated with the index for the cell; means for maintaining a format usage counter indicative of the usages of display formats; and means for incrementing the format usage counter when a cell is formatted with an already extant display format. - View Dependent Claims (46)
-
Specification