Back to results
US 6,651,216 B1Granted
Efficiently navigating a workbook linked to a database
OwnerDave Sullivan, Matthew Garth McLuckieinventors
Life of this patent
Estimating the term…
Abstract
A way to navigate efficiently among worksheets in a workbook linked to a database that involves double-clicking on a cell in a page showing totals and having the detail page associated with cell be displayed.
Claims2
In a computer system having a workbook and a database, an improved method for using said workbook comprising:
- (a) providing Detail pages in said workbook where the number of Detail pages can be determined by examining the contents of said database;
- (b) providing a Totals page that has detail columns (56) to present information that summarizes data in said workbook's Detail pages;
- (c) displaying Item rows (50) on all said Totals and Detail pages;
- (d) receiving as input from a user an entry to a cell on one of said Detail pages;
- (e) in response to step (d), recalculating the values of said detail column(s) of said Totals page, and updating said database to reflect the user's entry.
- (f) receiving as input from a user a double-click on an Item row (50) in one of said detail columns (56) in said Totals page;
- (g) in response to step 1(f), displaying the Detail page associated with said detail column.
4 more elements
In a computer system having a workbook and a database, an improved method for using said workbook comprising:
- (a) providing a worksheet with detail columns (60);
- (b) providing a total values (55) column on said worksheet that adds values in said detail columns;
- (c) displaying Item rows (50) on said worksheet where the number of Item rows displayed in said workbook can be determined by examining the contents of said database;
- (d) means, responsive to user input consisting of a double-click on a detail column in the Totals page, for displaying the Detail page associated with said detail column in such a manner as to obscure at least a portion of said Totals page.
1 more element
Dependencies are inferred from the claim text.