Method and apparatus for a file format for storing spreadsheet compactly
View Patent ↗Methods and Systems in accordance with the present invention provide a file format for storing spreadsheets compactly on PDAs. PDAs only contain a limited amount of computer memory due to their small size and processing ability. To reduce memory constraints caused by PDA spreadsheet applications, the present invention reduces memory allocated for file storage by optimizing the compression of individual spreadsheet files within a database record storage system. This method and system in accordance with the present invention uses a collection of records to represent a spreadsheet file.
1. A method in a data processing apparatus for accessing cell data of a spreadsheet file cell in a record-based computer readable-medium, comprising:
determining whether cell data location information for a selected spreadsheet file cell is contained in a first grid record of a plurality of grid records, each grid record storing a mapping between a plurality of spreadsheet file cells and the location of their corresponding cell data location information in a cell data record implemented in the record-based computer readable-medium;
if the cell data location information is contained in the first grid record, determining the cell data location information from the first grid record;
determining the location of cell data corresponding to the spreadsheet file cell in the cell data record based on the cell data location information; and
extracting the cell data from the cell data record,
wherein the cell data location information indicates the location of cell data in the cell data record, the cell data location information is a 16 bit matrix, and the first 10 bits of the 16 bit matrix indicate the cell data record containing the cell data, and the last 6 bits of the 16 bit matrix indicated the location of the cell data within the cell data record.
2. The method of claim 1 , further comprising:
if the cell data location information is not contained in the first grid record, determining whether the cell data location information is contained in a second grid record.
3. The method of claim 2 , wherein determining whether cell data location information for a selected spreadsheet file cell is contained in a first grid record includes comparing a column number of the spreadsheet file cell to a column value range of the second grid record.
4. The method of claim 1 , further comprising:
determining from a property record property information of the spreadsheet file.
5. The method of claim 1 , wherein determining whether cell data location information for a selected spreadsheet file cell is contained in a first grid record includes comparing a column number of the spreadsheet file cell to a column value range of the first grid record.
6. The method of claim 1 , where the cell data location information indicates a value of zero if the spreadsheet file cell is empty.
7. The method of claim 1 , wherein the data processing apparatus is a personal digital assistant.
8. A computer-readable medium having stored thereon computer-executable instructions for causing a computer to execute a method for accessing cell data of a spreadsheet file cell in a record-based memory, the method comprising the steps of:
determining whether cell data location information for a selected spreadsheet file cell is contained in a first grid record of a plurality of grid records, each grid record storing a mapping between a plurality of spreadsheet file cells and the location of their corresponding cell data location information in a cell data record implemented in the record-based computer readable-medium;
if the cell data location information is contained in the first grid record, determining the cell data location information from the first grid record;
determining the location of cell data corresponding to the spreadsheet file cell in the cell data record based on the cell data location information; and
extracting the cell data from the cell data record,
wherein the cell data location information indicates the location of cell data in the cell data record, the cell data location information is a 16 bit matrix, and the first 10 bits of the 16 bit matrix indicate the cell data record containing the cell data, and the last 6 bits of the 16 bit matrix indicated the location of the cell data within the cell data record.
9. The computer-readable medium of claim 8 , further comprising the step of:
if the cell data location information is not contained in the first grid record, determining whether the cell data location information is contained in a second grid record.
10. The computer-readable medium of claim 9 , wherein determining whether-cell data location information for a selected spreadsheet file cell is contained in a first grid record includes comparing a column number of the spreadsheet file cell to a column value range of the second grid record.
11. The computer-readable medium of claim 8 , further comprising the step of:
determining from a property record property information of the spreadsheet file.
12. The computer-readable medium of claim 8 , wherein determining whether cell data location information for a selected spreadsheet file cell is contained in a first grid record includes comparing a column number of the spreadsheet file cell to a column value range of the first grid record.
13. The computer-readable medium of claim 8 , where the cell data location information indicates a value of zero if the spreadsheet file cell is empty.
14. The computer-readable medium of claim 8 , wherein the computer-readable medium is contained in a personal digital assistant.