# US 11,443,109 B2 · Interactive data entry validation and problem correction in a table component in a spreadsheet driven by a web service > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,443,109 B2 - Document ID: US11443109B2 - Status: Granted - Kind: B2 - Application number: 17/364,720 - Filed: 2021-06-30 - Published: 2021-10-21 - Granted: 2022-09-13 - Earliest claimed: 2017-09-28 - Assignees: Oracle International Corporation - Applicants: Oracle International Corporation - Inventors: Edmund A. Davis; Shaun Logan; Brian Rowles - Web page: https://patentgrep.com/patent/US11443109B2 ## CPC - G06F 40/18: of spreadsheets (form-filling G06F40/174) - G06F 16/907: Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually - G06F 16/958: Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## 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. ## Claims ### Claim 1 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, by the client device, for web service metadata from a web service, wherein data for the spreadsheet is populated from the web service; determining one or more requirements of the web service based on the web service metadata; receiving the user-provided data entry into the spreadsheet for upload to the web service, wherein the user-provided data entry is a data change of the populated data from the web service; first tier validating of the data change, by the client device, if the user-provided data entry meets the one or more requirements of the web service metadata; second tier backend validating of the data change, using the web service, if the user-provided data entry meets one or more web service rules that are not also specified by the web services metadata; and indicating an invalid data entry on the spreadsheet if the data change fails to meet one or more of: the one or more requirements of the web service metadata or the one or more web service rules. ### Claim 2 (depends on 1) The method of claim 1, wherein the one or more requirements of the web service metadata include one or more properties for attributes and the one or more web service rules include one or more business rules for the data. ### Claim 3 (depends on 1) The method of claim 1, wherein the data from the web service includes headers in the spreadsheet and the user-provided data entry includes data under the headers. ### Claim 4 (depends on 1) The method of claim 1, wherein the data from the web service includes data under headers in the spreadsheet and the user-provided data entry includes changes to the data under the headers. ### Claim 5 (depends on 1) The method of claim 1, wherein the user-provided data entry is determined to be valid based on the one or more requirements of the web service metadata in the first tier validating but invalid based on a one or more web service rules in the second tier backend validating. ### Claim 6 (depends on 1) The method of claim 1, wherein indicating an invalid data entry includes displaying a list of two or more of: the one or more requirements of the web service metadata or the one or more web service rules, to be corrected. ### Claim 7 (depends on 1) The method of claim 1, wherein the second tier backend validating is initiated by a user-provided input. ### Claim 8 A non-transitory computer-readable storage medium carrying program instructions thereon for validating a user-provided data entry to a spreadsheet at a client device with web service metadata, the instructions when executed by one or more processors cause the one or more processors to perform operations comprising: making a request, by the client device, for web service metadata from a web service, wherein data for the spreadsheet is populated from the web service; determining one or more requirements of the web service based on the web service metadata; receiving the user-provided data entry into the spreadsheet for upload to the web service, wherein the user-provided data entry is a data change of the populated data from the web service; first tier validating of the data change, by the client device, if the user-provided data entry meets the one or more requirements of the web service metadata; second tier backend validating of the data change, using the web service, if the user-provided data entry meets one or more web service rules that are not also specified by the web services metadata; and indicating an invalid data entry on the spreadsheet if the data change fails to meet one or more of: the one or more requirements of the web service metadata or the one or more web service rules. ### Claim 9 (depends on 8) The non-transitory computer-readable storage medium of claim 8, wherein the one or more requirements of the web service metadata include one or more properties for attributes and the one or more web service rules include one or more business rules for the data. ### Claim 10 (depends on 8) The non-transitory computer-readable storage medium of claim 8, wherein the data from the web service includes headers in the spreadsheet and the user-provided data entry includes data under the headers. ### Claim 11 (depends on 8) The non-transitory computer-readable storage medium of claim 8, wherein the data from the web service includes data under headers in the spreadsheet and the user-provided data entry includes changes to the data under the headers. ### Claim 12 (depends on 8) The non-transitory computer-readable storage medium of claim 8, wherein the user-provided data entry is determined to be valid based on the one or more requirements of the web service metadata in the first tier validating but invalid based on a one or more web service rules in the second tier backend validating. ### Claim 13 (depends on 8) The non-transitory computer-readable storage medium of claim 8, wherein indicating an invalid data entry includes displaying a list of two or more of: the one or more requirements of the web service metadata or the one or more web service rules, to be corrected. ### Claim 14 (depends on 8) The non-transitory computer-readable storage medium of claim 8, wherein the second tier backend validating is initiated by a user-provided input. ### Claim 15 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 for validating a user-provided data entry to a spreadsheet at a client device with web service metadata, and when executed operable to perform operations comprising: making a request, by the client device, for web service metadata from a web service, wherein data for the spreadsheet is populated from the web service; determining one or more requirements of the web service based on the web service metadata; receiving the user-provided data entry into the spreadsheet for upload to the web service, wherein the user-provided data entry is a data change of the populated data from the web service; first tier validating of the data change, by the client device, if the user-provided data entry meets the one or more requirements of the web service metadata; second tier backend validating of the data change, using the web service, if the user-provided data entry meets one or more web service rules that are not also specified by the web services metadata; and indicating an invalid data entry on the spreadsheet if the data change fails to meet one or more of: the one or more requirements of the web service metadata or the one or more web service rules. ### Claim 16 (depends on 15) The apparatus of claim 15, wherein the one or more requirements of the web service metadata include one or more properties for attributes and the one or more web service rules include one or more business rules for the data. ### Claim 17 (depends on 15) The apparatus of claim 15, wherein the data from the web service includes data under headers in the spreadsheet and the user-provided data entry includes changes to the data under the headers. ### Claim 18 (depends on 15) The apparatus of claim 15, wherein the user-provided data entry is determined to be valid based on the one or more requirements of the web service metadata in the first tier validating but invalid based on a one or more web service rules in the second tier backend validating. ### Claim 19 (depends on 15) The apparatus of claim 15, wherein indicating an invalid data entry includes displaying a list of two or more of: the one or more requirements of the web service metadata or the one or more web service rules, to be corrected. ### Claim 20 (depends on 15) The apparatus of claim 15, wherein the second tier backend validating is initiated by a user-provided input.