Method and apparatus for formula evaluation in spreadsheets on small devices

• US 7,793,210 B2
• Filed: 01/30/2001
• Issued: 09/07/2010
• Est. Priority Date: 01/30/2001
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Oracle America, Inc. (Oracle Corporation)
• Inventors: Rank, Paul J., Pampuch, John C.
• Primary Examiner(s): Ries; Laurie
• Assistant Examiner(s): Nguyen; Maikhanh
• Application Number:
  US09/774,354
• Publication Number:
  US 20020143829A1
• Time in Patent Office: 3,507 Days
• Field of Search: 715/503, 715/538, 715/501.1, 715/504, 715/523, 715/200, 715/201, 715/203, 715/212, 715/226, 715/239, 715/242, 715/248, 715/249, 715/255, 715/273, 715/700, 715/205, 715/209, 715/210, 715/219, 715/229, 715/231, 715/234, 715/256, 715/267, 715/276, 345/169, 709/232, 709/237, 710/61, 717/106, 717/136, 717/137, 717/140
• US Class Current: 715/212
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A method and apparatus is provided for enabling a spreadsheet program with formula support on small devices (like PDAs) while minimizing the amount of memory space used by the program and the accompanying compiled code during transfer of files from the desktop to the small devices. The user can download a spreadsheet file from the desktop to the small device via a conduit. A conduit is any 2-way communication device which connects a desktop to a small device and allows the transfer of data. Conduit software can convert the data to be transferred into a format understandable by both the desktop and PDA programs. The conduit software can also evaluate and parse the formulas and functions needed by the current file before the transfer and generate compiled code for the functions needed by the current file before transfer.

Claims

1. A method in a data processing system including at least a first and a second device for evaluating a spreadsheet file, the method comprising:

obtaining, by a conduit in said data processing system, said spreadsheet file in a first format on said first device;

converting, by said conduit, said spreadsheet file to a second format associated with said second device, such that said spreadsheet file when in said second format occupies less memory space than said spreadsheet file when in said first format and wherein said converting takes place outside of a memory of said second device and further comprises;

determining one or more formulas associated with said spreadsheet file that are necessary for the operation of the spreadsheet file on said second device; and

parsing and evaluating the one or more formulas and compiling code associated with the one or more formulas while converting said spreadsheet file to said second format; and

transferring, by said conduit, said spreadsheet file to said second device.

2. The method of claim 1 wherein said first device is a computer.

3. The method of claim 2 wherein said second device is a small device.

4. The method of claim 3 wherein said small device is a Personal Digital Assistant (PDA).

5. A computer program product comprising:

a non-transitory computer-readable medium having computer readable program code embodied therein configured to evaluate a spreadsheet file, said computer program product comprising;

computer readable code configured to cause a conduit to obtain said spreadsheet file in a first format on a first device wherein said conduit includes a computer processor configured to read the computer readable program code;

computer readable code configured to cause said conduit to convert said spreadsheet file to a second format associated with a second device, such that said spreadsheet file when in said second format occupies less memory space than said spreadsheet file when in said first format and wherein said converting takes place outside of a memory of said second device, determine one or more formulas associated with said spreadsheet file that are necessary for the operation of the spreadsheet file on said second device, parse and evaluate the one or more formulas, and compile code associated with the one or more formulas while converting said spreadsheet file to said second format and

computer readable code configured to cause said conduit to transfer said spreadsheet file to said second device.

6. The computer program product of claim 5 wherein said first device is a computer.

7. The computer program product of claim 6 wherein said second device is a small device.

8. The computer program product of claim 7 wherein said small device is a Personal Digital Assistant (PDA).

9. A data processing system, comprising:

means for obtaining a spreadsheet file in a first format on a first device in the data processing system; and

means for converting said spreadsheet file to a second format associated with a second device in the data processing system, wherein the spreadsheet file in the second format occupies less memory space than the spreadsheet file in the first format and wherein the converting takes place outside of a memory of the second device and further comprises;

determining at least one formula associated with the spreadsheet file that is necessary for operation of the spreadsheet file on the second device;

parsing and evaluating the at least one formula and compiling code associated with the at least one formula while converting the spreadsheet file to the second format; and

transferring the spreadsheet file to the second device.

10. The system of claim 9, wherein the first device is a computer.

11. The system of claim 10, wherein the second device is a small device.

12. The system of claim 11, wherein said small device is a Personal Digital Assistant (PDA).