Creating and managing structured data in an electronic spreadsheet
US7127672B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Aug 22, 2003 |
| Grant date | Oct 24, 2006 |
| Priority date | — |
| Expiry date | Aug 21, 2024 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F40/226
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
An electronic spreadsheet is provided for automatically creating, expanding, and validating lists of cells. A list is created by receiving a user request for selecting a cell range, identifying a list range for the selected cell range, determining a header row for the list range, and generating a border for surrounding the list range. A list is expanded by determining that one or more cells are adjacent to the list and automatically expanding the list to include the new cells. A list is validated by determining a data type of data entered into the list and comparing the data type of the data entered into the list to a list data type. If, as a result of the comparison, the data type of the data entered into the list does not match the list data type, then the data type of the data entered into the list is invalid.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.