Systems and methods for integrating computations into compound documents

• US 5,630,126 A
• Filed: 12/13/1994
• Issued: 05/13/1997
• Est. Priority Date: 12/13/1994
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Redpath, Richard J.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US08/354,687
• Time in Patent Office: 882 Days
• Field of Search: 395/600, 395/575, 395/148, 364/401
• US Class Current: 1/1
• CPC Class Codes: G06F 40/166 Editing, e.g. inserting or deleting
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Systems and methods for creating and integrating computations within compound documents wherein a compound document having a plurality of integrated computations is created in a computing environment. The compound document is configured to include a document text part and a plurality of math parts positioned in a plurality of locations. A selected first set of math parts within the compound document are expressed as computational functions of a second math part contained within the compound document. If a value is assigned to the second math part, the computational functions of each math part in the selected first set are automatically reevaluated and displayed.

Claims

1. A system for integrating computations into a compound document in a computing environment including a computing platform, said computation integrating system comprising:

means for configuring a compound document including a document text and first, second and third math parts at corresponding first, second and third locations within said compound document, each math part comprising a name, an associated formula and an associated value, wherein the second formula is a computational function of the first value, and wherein the name of said third math part is identical to the name of said first math part;

means, responsive to user input of a predetermined non-numeric string at said first location, for evaluating the first formula associated with the first math part to produce a result, for displaying said result at said first location and for assigning the result as the first value;

means, responsive to user input of a numeric string at said first location, for assigning said numeric string as the first value, without evaluating the first formula of the first math part;

means, responsive to assignment of a value to said first math part, for communicating the first value of the first math part to said second and third math parts;

means, responsive to receipt of said first value by said second math part, for reevaluating the second formula using the first value, and for displaying the reevaluated formula at the second location; and

means, responsive to receipt of said first value by said third math part, for displaying the first value at said third location.

2. A system according to claim 1 wherein said configuring means comprises a dialog box, for accepting user input of a formula and a name for a math part.

3. A system according to claim 1 wherein said configuring means further comprises a dialog box including a plurality of predefined formulas, and means for accepting user designation of one of said predefined formulas.

4. A system according to claim 1 wherein said non-numeric string comprises one of a math part name and a non numeric string which is responsive to user activation of an ENTER function.

5. A system according to claim 1 wherein said communicating means comprises means for generating a list for each of said math parts, each list including names of all remaining math parts, the formulas of which include the name of the associated math part.

6. A system for integrating computations into a document in a computing environment including a computing platform, said computation integrating system comprising:

means for configuring a compound document including a document text and a plurality of math cells at a corresponding plurality of spaced apart locations within said compound document, wherein selected first math cells are expressed as computational functions of a second math cell; and

means responsive to user input of a value into said second math cell, for reevaluating said first math cells and for displaying the reevaluated math cells at associated spaced apart locations within said compound document.

7. A system according to claim 6 wherein said configuring means comprises a dialog box, for accepting user input of a formula and a name for a math part.

8. A system according to claim 6 wherein said configuring means further comprises a dialog box including a plurality of predefined formulas, and means for accepting user designation of one of said predefined formulas.

9. A system according to claim 6 wherein said value comprises one of a math part name and a numeric string which is responsive to user activation of an ENTER function.

10. A system according to claim 6 wherein said communicating means comprises means for generating a list for each of said math parts, each list including names of all remaining math parts, the formulas of which include the name of the associated math part.

11. In a computing environment including a computing platform, a math part for use with a compound document comprising:

means for establishing an interface for user assignment of a name, a formula and a location in a compound document for each of a plurality of math parts;

means for linking with each math part, the names of remaining math parts which are used in the formula of the math part; and

means, responsive to user input of data into a math part, for communicating the result of processing the user data by the math part, to the linked math parts, such that results of user data input cause the linked math parts to update.

12. A system according to claim 11 wherein said configuring means comprises a dialog box, for accepting user input of a formula and a name for a math part.

13. A system according to claim 11 wherein said configuring means further comprises a dialog box including a plurality of predefined formulas, and means for accepting user designation of one of said predefined formulas.

14. A system according to claim 11 wherein said communicating means comprises means for generating a list for each of said math parts, each list including names of all remaining math parts, the formulas of which include the name of the associated math part.

15. A method for integrating computations into a compound document in a computing environment including a computing platform, said computation integrating method comprising the steps of:

configuring a compound document including a document text and first, second and third math parts at corresponding first, second and third locations within said compound document, each math part comprising a name, an associated formula and an associated value, wherein the second formula is a computational function of the first value, and wherein said third name is identical to said first name;

evaluating the first formula associated with the first math part to thereby produce a result in response to user input of a predetermined non-numeric string at said first location;

displaying said result at said first location;

assigning said result as the first value;

assigning said numeric string as the first value, without evaluating the first formula of the first math part, in response to user input of a numeric string at said first location;

communicating the first value of the first math part to said second and third math parts in response to assignment of a value to said first math part;

reevaluating the second formula using the first value in response to receipt of said first value by said second math part;

displaying the reevaluated formula at the second location in response to receipt of said first value by said second math part;

displaying the first value at said third location in response to receipt of said first value by said third math part.

16. A method according to claim 15 wherein said configuring step comprises the step of presenting a dialog box, for accepting user input of a formula and a name for a math part.

17. A method according to claim 15 wherein said configuring step further comprises the step of presenting a dialog box including a plurality of predefined formulas, and the step of the user accepting designation of one of said predefined formulas.

18. A method according to claim 15 wherein said communicating step comprises the step of generating a list for each of said math parts, each list including names of all remaining math parts, the formulas of which include the name of the associated math part.

19. A method for integrating computations into a document in a computing environment including a computing platform, said computation integrating method comprising the steps of:

configuring a compound document including a document text and a plurality of math cells at a corresponding plurality of spaced apart locations within said compound document, wherein selected first math cells are expressed as computational functions of a second math cell;

reevaluating said first math cells in response to user input of a value into said second math cell; and

displaying the reevaluated math cells at associated spaced apart locations within said compound document in response to user input of a value into said second math cell.

20. A method according to claim 19 wherein said configuring step comprises the step of presenting a dialog box for accepting user input of a formula and a name for a math part.

21. A method according to claim 19 wherein said configuring step further comprises the step of presenting a dialog box including a plurality of predefined formulas, and the step of the user accepting designation of one of said predefined formulas.

22. A method according to claim 19 wherein said communicating step comprises the step of generating a list for each of said math parts, each list including names of all remaining math parts, the formulas of which include the name of the associated math part.

23. Computer readable code comprising an object oriented math object for providing a mathematical calculation component in a compound document, said math object comprising:

first subprocesses responsive to input for evaluating the input in accordance with a first formula and producing a mathematical result;

second subprocesses for displaying the result at a user selectable position within the compound document, wherein the math object may be located by the user within the compound document as desired by the user; and

third subprocesses for linking said math object to other components within the compound document.

24. Computer readable code comprising an object oriented math object according to claim 23, wherein the input comprises, at least in part, a result produced by a different math object, and said first subprocesses reevaluates the input in accordance with the first formula after a new result from the different math object is received.

25. Computer readable code comprising an object oriented math object according to claim 23, wherein said third subprocesses link said math object to text components within the compound document and update the text components with the input to the first formula or the result produced by the math object as the input to the first formula are modified or the result is reevaluated.

26. In a computing environment, a system for providing an associable mathematical calculation component within a compound document, comprising:

means for locating a user viewable portion of the component within the compound document at a position specified by a user;

means for evaluating input to the component and producing a mathematical result in accordance with a mathematical formula;

means for displaying the mathematical result within the user viewable portion of the component within the compound document; and

means for linking the component to other elements within the compound document.

27. A system according to claim 26, wherein the mathematical formula is included in the input.

28. A system according to claim 26, wherein the mathematical formula is predefined within the component.

29. A system according to claim 26, wherein the input comprises, at least in part, data from other elements within the compound document, and said evaluating means re-evaluates the input in accordance with the mathematical formula whenever the input is updated.