Spreadsheet programming

• US 20060224946A1
• Filed: 03/31/2005
• Published: 10/05/2006
• Est. Priority Date: 03/31/2005
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Barrett, Robert C., Maglio, Paul P., Haber, Eben M., Kandogan, Eser
• Application Number:
  US11/095,119
• Publication Number:
  US 20060224946A1
• Time in Patent Office: Days
• US Class Current: 715/210
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Spreadsheet programming model and language is extended to create objects, with their associated state and set of defined behaviors, as first-class spreadsheet cell residents. Desired object behaviors can be invoked by calling methods on the objects through an event-based imperative programming language that potentially modifies the state of an object. Expressions can also be defined by calling methods on objects that produce new objects in combination with operations on objects in other cells. Programming constructs are defined that allows users to perform a sequence of operations on one or more objects. Operations can also be performed automatically similar to spreadsheet triggering mechanism. Users can program to trigger operations either manually or automatically based on changes to objects, or based on conditions defined.

Claims

1. An electronic spreadsheet comprising:

at least one grid of cells; and

programming code statements within said at least one of said cells,

wherein said programming code statements comprise statements adapted to be sequentially applied.

2. The electronic spreadsheet according to claim 1, wherein said programming code statements can comprise statements that assign an object to a cell.

3. The electronic spreadsheet according to claim 1, wherein said programming code statements comprise statements that assign a collection of objects to a cell.

4. The electronic spreadsheet according to claim 1, wherein said programming code statements comprise statements that execute a method on an object in another cell.

5. The electronic spreadsheet according to claim 1, wherein said programming code statements comprise statements that execute a method on an object in another cell with parameters from objects in other cells in the grid.

6. The electronic spreadsheet according to claim 1, wherein said programming code statements comprise statements that execute a function on an object in another cell and assign the resultant object into the cell.

7. The electronic spreadsheet according to claim 1, wherein said programming code statements comprise statements that execute a method on a collection of objects in other cells.

8. The electronic spreadsheet according to claim 1, wherein said programming code statements comprise conditional statements.

9. The electronic spreadsheet according to claim 1, wherein said programming code statements comprise parameterizable user-defined statements.

10. The electronic spreadsheet according to claim 1, wherein said at least one of said cells comprises a block of multiple said programming code statements.

11. An electronic spreadsheet comprising:

at least one grid of cells; and

programming code statements within said at least one of said cells,

wherein said programming code statements comprise conditional statements utilizing “

on” and

“

when”

constructs.

12. The electronic spreadsheet according to claim 11, wherein said conditional statements comprise boolean expression conditions.

13. The electronic spreadsheet according to claim 11, wherein said conditional statements comprise object assignments changes.

14. The electronic spreadsheet according to claim 11, wherein said conditional statements comprise object property changes.

15. The electronic spreadsheet according to claim 11, wherein said conditional statements are made conditional on user interaction.

16. The electronic spreadsheet according to claim 11, wherein said conditional statements comprise spreadsheet events.

17. The electronic spreadsheet according to claim 11, wherein said conditional statements are made conditional on external process events.

18. The electronic spreadsheet according to claim 11, wherein said conditional statements comprise a user defined ordering of events.

19. The electronic spreadsheet according to claim 11, wherein said conditional statements comprise one of explicitly triggered statements and implicitly triggered statements by calling object methods.

20. The electronic spreadsheet according to claim 11, wherein said conditional statements comprise iterative statements.

21. The electronic spreadsheet according to claim 11, wherein said conditional statements comprise copy statements and distribution of objects statements.

22. An electronic spreadsheet comprising:

at least one grid of cells; and

programming code statements within said at least one of said cells,

wherein said programming code statements comprise conditional pause statements.

23. The electronic spreadsheet according to claim 22, wherein said programming code statement execute methods on objects using weak type matching.

24. An electronic spreadsheet comprising:

at least one grid of cells; and

programming code statements within said at least one of said cells,

wherein said programming code statements comprise statements adapted to one of;

insert programming code statements in other cells; and

modify programming code statement in other cells.

25. A method of using graphic objects in a spreadsheet, said method comprising:

mapping said graphic objects within said spreadsheet to interactor components;

receiving user interaction to activate at least one graphic object;

delaying processing of interactor components activated by said user interaction until a predetermined graphic object receives said user interaction;

processing all said interactor components activated by said user interaction once said predetermined graphic object receives said user interaction; and

reevaluating and reexecuting cells in said spreadsheet as required by objects, expressions, and commands within said spreadsheet during said processing of all said interactor components activated by said user interaction.

26. The method in claim 25, wherein said reevaluating and reexecuting of said cells is performed for all cells whenever values in corresponding dependent cells change during said processing of all said interactor components activated by said user interaction.

27. The method in claim 25, further comprising parsing said objects, expressions, and commands as they are entered into said spreadsheet to generate a graph of cell behaviors to control said reevaluating and reexecuting of said cells.

28. The method in claim 25, further comprising pushing data from said spreadsheet only after said reevaluating and reexecuting of said cells is complete.

29. The method in claim 25, wherein said mapping of object to interactor components can be performed by a user.

30. The method in claim 25, wherein said interactor components provide rendering and interaction capabilities for command-line interfaces, graphical user interfaces, and form-based web interfaces.

31. The method in claim 25, wherein the layout and the size of the said interactor components can be modified by the user to define the look of the application developed.