Animated spreadsheet for dynamic display of constraint graphs

• US 6,256,649 B1
• Filed: 06/17/1998
• Issued: 07/03/2001
• Est. Priority Date: 06/17/1998
• Status: Expired due to Term

• Current Assignee: Xerox Corporation (Xerox Holdings Corp.)
• Original Assignee: Xerox Corporation (Xerox Holdings Corp.)
• Inventors: Niemeyer, Gregory, Chang, Bay-Wei, Igarashi, Takeo, Mackinlay, Jock D., Zellweger, Polle T.
• Primary Examiner(s): Feild, Joseph H.
• Application Number:
  US09/098,903
• Time in Patent Office: 1,112 Days
• Field of Search: 707/503, 707/501, 707/509, 707/538, 707/8, 707/104, 345/440, 345/473
• US Class Current: 715/212
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

An augmented spreadsheet presentation provides for selecting a region of user focus in a primary body of data displayed as an array of cells, with two or more displayed cells of the array of cells being logically linked by a constraint graph. Two or more displayed cells can be linked by color or symbol animations in response to selected user focus with a mouse or other cursor. Complex animations that successively illustrate multiple constraint graph paths are possible.

Claims

1. A method for augmenting a spreadsheet presentation on a display, the method comprising the steps of

selecting a region of user focus in an array of cells, wherein two or more displayed cells of the array of cells are logically linked by a constraint graph, and

providing animated linkages between the two or more displayed cells logically linked by the constraint graph in response to selected user focus.

2. The method of claim 1, wherein the animated linkages are displayed as an animated sequence that includes color transitions between the two or more displayed cells.

3. The method of claim 1, wherein the animated linkages are displayed as an animated sequence that includes symbol movements between the two or more displayed cells.

4. The method of claim 1, wherein the animated linkages are displayed as an animated sequence that includes color transitions or symbol movements between the two or more displayed cells.

5. The method of claim 1, wherein the animated linkages are displayed as an animated sequence that includes drop shadow cell animations between the two or more displayed cells.

6. A method for augmenting a spreadsheet presentation on a display by demonstrating multiple constraint graph paths, the method comprising the steps of

providing a first set of animated linkages along a first constraint graph path between two or more displayed cells logically linked by the constraint graph, and

providing a second set of animated linkages along a second constraint graph path between the two or more displayed cells logically linked by the constraint graph.

7. The method of claim 6 wherein the first set of animated linkages and the second set of animated linkages are displayed as animated sequences between the two or more displayed cells that are concurrently presented.

8. The method of claim 6 wherein the first set of animated linkages and the second set of animated linkages are displayed as animated sequences between the two or more displayed cells that are temporally overlapped, with the second animated linkage beginning before completion of the first animated linkage.

9. The method of claim 6 wherein the first set of animated linkages and the second set of animated linkages are displayed as animated sequences between the two or more displayed cells that are temporally distinct, with the second animated linkage beginning after completion of the first animated linkage.

10. The method of claim 6, wherein the animated linkages are displayed as an animated sequence that includes color transitions between the two or more displayed cells.

11. The method of claim 6, wherein the animated linkages are displayed as an animated sequence that includes symbol movements between the two or more displayed cells.

12. The method of claim 6, wherein the animated linkages are displayed as an animated sequence that includes color transitions or symbol movements between said two or more displayed cells.

13. The method of claim 6, wherein the animated linkages are displayed as an animated sequence that includes drop shadow cell animations between the two or more displayed cells.

14. The method of claim 6, wherein the first animated linkage is initiated in response to user focus.