Interactive data entry validation and problem correction in a table component in a spreadsheet driven by a web service
AssigneeOracle International Corporation
InventorsEdmund A. Davis, Shaun Logan, Brian Rowles
Life of this patent
Estimating the term…
Abstract
Implementations generally relate to a spreadsheet add-in that provides data entry validation. As described in more detail herein, the spreadsheet add-in integrates a spreadsheet-based table component with a remote web service. The spreadsheet add-in uses web service metadata to validate data that a user enters into the spreadsheet. The spreadsheet add-in provides immediate feedback on errors in an interactive fashion for the user. Furthermore, during a data upload process, any errors that are reported by the web service are displayed in context such that the user may quickly affect corrections.
Claims20
A method for validating a user-provided data entry to a spreadsheet at a client device with web service metadata, the method comprising:
- making a request, at the client device, for web service metadata from a web service;
- determining one or more requirements of the web service based on the metadata, the one or more requirements including one or more of whether a field is required, whether a field is read-only, if a particular data type is needed;
- accepting the user-provided data entry into a spreadsheet;
- validating if the user-provided data entry meets one or more of the requirements of the web service metadata without an additional query to the web service;
- and
- indicating an invalid data entry on the spreadsheet if the user-provided data entry does not meet one or more of the requirements of the web service metadata.
A non-transitory computer-readable storage medium carrying program instructions thereon, the instructions when executed by one or more processors cause the one or more processors to perform operations comprising:
- making a request, at a client device, for web service metadata from a web service;
- determining one or more requirements of the web service based on the metadata, the one or more requirements including one or more of whether a field is required, whether a field is read-only, if a particular data type is needed;
- accepting a user-provided data entry into a spreadsheet;
- validating if the user-provided data entry meets one or more of the requirements of the web service metadata without an additional query to the web service;
- and
- indicating an invalid data entry on the spreadsheet if the user-provided data entry does not meet one or more of the requirements of the web service metadata.
An apparatus comprising:
- one or more processors;
- and
- logic encoded in one or more non-transitory computer-readable storage media for execution by the one or more processors and when executed operable to perform operations comprising:
- making a request, at a client device, for web service metadata from a web service;
- determining one or more requirements of the web service based on the metadata, the one or more requirements including one or more of whether a field is required, whether a field is read-only, if a particular data type is needed;
- accepting a user-provided data entry into a spreadsheet;
- validating if the user-provided data entry meets one or more of the requirements of the web service metadata without an additional query to the web service;
- and
- indicating an invalid data entry if the user-provided data entry does not meet one or more of the requirements of the web service metadata.
Dependencies are inferred from the claim text.