Abstract: 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.

Abstract: The present invention provides a method and apparatus for 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 focuses on reducing memory allocated for file storage. This is accomplished by optimizing the compression of individual spreadsheet files within a database record storage system. This method and apparatus of the present invention reduces the overall storage of spreadsheets within a spreadsheet program. The invention uses a collection of records to represent a spreadsheet file. In one embodiment, the invention stores spreadsheet file data in a first record. A second record stores access data of the spreadsheet file and cell data is stored on third or more records. The property data includes name, version, date information, and default cell format information of the spreadsheet file.

Abstract: The present invention provides a protocol for the transfer of files to and from electronic devices, especially wireless devices. In one embodiment, the present invention is used by these devices connected by any means to the source of the file. These means can be wireless, modem dial-up, or conduit of a PDA. Since the present invention is used by wireless devices which operate on limited and expensive wireless bandwidth, it is not verbose and “chatty” unlike prior art protocols based on clear-text HTML, XML, or HotSync. The present invention uses HTTP or HTTPS to connect two devices communicating with each other. HTTP is used since it is a protocol that is usually allowed to traverse virtual private network firewalls. The invention allows the server to maintain multiple sessions with different clients. These sessions will end automatically if no data is transferred after a certain length of time has elapsed. These different clients can connect and perform operations concurrently with each other.