×

Systems and methods providing dynamic spreadsheet functionality

  • US 7,082,569 B2
  • Filed: 01/11/2002
  • Issued: 07/25/2006
  • Est. Priority Date: 01/17/2001
  • Status: Expired due to Term
First Claim
Patent Images

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) receiving an expansion formula in at least one of said plurality of cells that comprises at least one dimension member and instructions for expansion, said expansion formula functioning to control retrieval of data associated with said at least one dimension member;

    d) in response to rendering said electronic spreadsheet, using said at least one dimension member from said expansion formula to query said database to retrieve data associated with said at least one dimension member from said database;

    e) storing said retrieved data associated with said at least one dimension member from said expansion formula in a cache for use to respond to one or more queries to said database for said at least one dimension member;

    f) using said instructions for expansion from said expansion formula to automatically adjust at least one of the defined number of said columns and rows to accommodate said data responsive to said querying of said database; and

    g) populating said adjusted columns and rows with said retrieved data while maintaining the operation and functionality of said electronic spreadsheet.

View all claims
  • 4 Assignments
Timeline View
Assignment View
    ×
    ×