Methods and apparatus for generating a spreadsheet report template
US7370271B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 9, 2003 |
| Grant date | May 6, 2008 |
| Priority date | — |
| Expiry date | Aug 7, 2024 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F40/18
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods and apparatus for generating a report template for generation of a spreadsheet report are disclosed. First, a grid including a plurality of cells is displayed. One or more database fields for which data is to be obtained from a database are identified, where each of the database fields is associated with a separate group with which one or more rows in the grid can be associated. One or more groups as defined by the one or more database fields are then associated with a corresponding set of one or more rows in the grid, thereby associating cells within the set of rows with the corresponding group. A user may then enter information within one or more of the plurality of cells of the displayed grid, where the received information indicates at least one of a format of the spreadsheet report to be created and information to be displayed in one or more cells of the spreadsheet report. The report template is then generated from the received information such that the groups are associated with the received information corresponding to placement of the received information within the grid. The received information may, for instance, include a formula or formatting commands.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.