Method in connection with a spreadsheet program

• US 20030226105A1
• Filed: 05/29/2003
• Published: 12/04/2003
• Est. Priority Date: 05/29/2002
• Status: Abandoned Application

• Current Assignee: Framtidsforum I & M AB
• Original Assignee: Framtidsforum I & M AB
• Inventors: Waldau, Mattias
• Application Number:
  US10/446,455
• Publication Number:
  US 20030226105A1
• Time in Patent Office: Days
• US Class Current: 715/503
• CPC Class Codes: G06F 16/9577 Optimising the visualization of content, e.g. distillation of HTML documents
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]

Abstract

A method in connection with spreadsheet programs wherein a spreadsheet is created 102 by a creator 100 on a computer having a display means, an entry device, and a processor for executing the spreadsheet program. The method is adapted to make the spreadsheet accessible to a remote user provided with a target computing environment device, and comprises the following steps:

a) compiling 103 the created spreadsheet in said computer by, in addition to conventional compilation, using a set of submodules, so that the compiled spreadsheet is a representation of the spreadsheet for the target computing environment;

b) transferring the compiled spreadsheet to the target computing environment device, and

c) enabling said remote user to use 101 the created spreadsheet, by using a target processing means in the target computing environment device without using the spreadsheet program.

Claims

1. Method in connection with spreadsheet programs wherein a spreadsheet is created by a creator (100) on a computer having a display means, an entry device, and a processor for executing the spreadsheet program, said method is adapted to make the spreadsheet accessible to a user (101) provided with a target computing environment device, and comprises the following step:

a) compiling (103) the created spreadsheet in said computer by, in addition to conventional compilation, using a set of submodules, so that the compiled spreadsheet is a representation of the spreadsheet for the target computing environment, wherein said representation enables a user to use the created spreadsheet in the target computing environment device without using the spreadsheet program.

2. Method according to claim 1, characterized in that said method comprises the following steps performed after step a):

b) transferring (104) the compiled spreadsheet to the target computing environment device, and

c) enabling said remote user to use (105) the created spreadsheet, by using a target processing means in the target computing environment device without using the spreadsheet program.

3. Method according to claim 2, characterized in that said target computing environment uses a web browser as target processing means using HTML with embedded JavaScript to do the calculations.

4. Method according to claim 2, characterized in that said target computing environment uses a WAP-browser as target processing means using WML to present the result and with embedded WMLScript to do the calculations.

5. Method according to claim 2, characterized in that said target computing environment uses a Java enabled device as target processing means using Java to do the calculations and the user interface.

6. Method according to claim 1, characterized in that the compilation step is automatically performed.

7. Method according to claim 2, characterized in that a run time library comprising functions in said spreadsheet is transferred together with said compiled spreadsheet.

8. Method according to claim 1, characterized in that said set of submodules includes a typing submodule adapted to infer types of spreadsheet cells to determine if the cell includes a string and/or a number and/or a Boolean in order to be able to compile it efficiently in a typed programming language.

9. Method according to claim 8, characterized in that if the typing submobdule cannot determine the type of the spreadsheet cell conversions are introduced into the representation.

10. Method according to claim 8, characterized in that if the typing submobdule cannot determine the type of the spreadsheet cell the contexts of all involved type requirements are used to create an error message that is presented to the creator.

11. Method according to claim 1, characterized in that said set of submodules includes a generate array access submodule adapted to represent the spreadsheet by using a set of variables, vectors and arrays.

12. Method according to claim 7 characterized in that said set of submodules includes a minimize runtime support submodule where the number of functions in said run time library is minimized by optimizing the use of variables, vectors and arrays to represent the spreadsheet.

13. Method according to claim 1, characterized in that said set of submodules includes a generate math submodule that handles error codes generated in the spreadsheet by mapping the error values to a single value “

not a number”

(NaN).

14. Method according to claim 7 characterized in that the run time library handles the NaN.

15. Method according to claim 1, characterized in that said set of submodules includes a retain meta level submodule that introduces specific function(s) that maps cell references to cell values and/or cell positions.

16. Method according to claim 2, characterized in that said set of submodules includes a submodule that embeds calculations within a user interface and is adapted to automatically generate a user interface that may be used in the target computing environment device.

17. Method according to claim 16, characterized in that the user interface looks like a spreadsheet and that the representation implements the validation and formatting of the original spreadsheet.

18. Method according to claim 2, characterized in that said set of submodules includes a generate component or class submodule that creates a source code representation that can be directly used within a programming environment.

19. Method according to claim 2, characterized in that said set of submodules includes a generate component or class submodule that creates an object code representation that can be directly used within the target computing environment.

20. Method according to claim 19, characterized in that said object code representation is generated for the Java virtual machine (JVM).

21. Method according to claim 19, characterized in that said object code representation is generated for the Microsoft Intermediary Language (MSIL).

22. Method according to claim 1, characterized in that said set of submodules includes a quality assurances submodule that generates test code that validates that the values calculated by the representation are the same as the ones calculated by the original spreadsheet.

23. Method according to claim 1, characterized in that said set of submodules includes a minimize recalculation submodule that splits the generated code and groups it according to the recalculation order required to calculate the values of the spreadsheet in order to only execute the necessary parts when performing the calculation.

24. Method according to claim 23, characterized in that said code is generated as a linear code.

25. Method according to claim 2, characterized in that said method comprises the following steps to be performed when one or many user(s) have received and used the spreadsheet by entering data in the spreadsheet:

d) processing the data entered in the spreadsheets in order to form one or many resulting spreadsheet(s),

e) providing said resulting spreadsheet(s) to a party requesting the entered data.