Systems and methods providing dynamic spreadsheet functionality
First Claim
1. A method for dynamic spreadsheet reporting, comprising:
- a) providing an electronic spreadsheet having a plurality of cells that are arrayed in a defined number of columns and rows;
b) providing a database in communication with said electronic spreadsheet;
c) defining an expansion formula in at least one of said plurality of cells, said expansion formula functioning to control retrieval of data from said database and to automatically vary at least one of the defined number of said columns and rows to accommodate said data retrieval.
4 Assignments
0 Petitions
Accused Products
Abstract
An advantageous system and method are provided for supporting and/or enabling the creation of dynamic reports and/or data presentation(s) in connection with a spreadsheet-based application or program. The disclosed system and method offer a full complement of spreadsheet-based formatting and calculation capabilities. In addition, the system and method of the present disclosure may be used in conjunction with and/or incorporated as part of spreadsheet-based application(s) and/or program(s) found on stand-alone clients and/or networked clients. The disclosed system and method generally include an electronic spreadsheet having a plurality of cells that are arrayed in a defined number of columns and rows, a database in communication with the electronic spreadsheet, and an expansion formula that functions to control retrieval of data from the database and automatically varies/expands at least one of the defined number of columns and rows to accommodate the data retrieval.
-
Citations
24 Claims
-
1. A method for dynamic spreadsheet reporting, comprising:
-
a) providing an electronic spreadsheet having a plurality of cells that are arrayed in a defined number of columns and rows;
b) providing a database in communication with said electronic spreadsheet;
c) defining an expansion formula in at least one of said plurality of cells, said expansion formula functioning to control retrieval of data from said database and to automatically vary at least one of the defined number of said columns and rows to accommodate said data retrieval. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17, 18, 19, 20, 21, 22, 23, 24)
-
-
16. A system for supporting dynamic spreadsheet reporting, comprising a client that includes a processor and associated data storage containing at least one database, said processor adapted to process programmatic instructions associated with an electronic spreadsheet having a plurality of cells that are arrayed in a defined number of columns and rows;
- said programmatic instructions including at least one expansion formula inserted into in at least one of said plurality of cells, said expansion formula functioning to control retrieval of data from said at least one database and to automatically vary at least one of the defined number of said columns and rows to accommodate said data retrieval.
Specification