US 11,443,109 B2Granted

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…

Loading patent…

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

Dependent claims

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.

5 more elements

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.

5 more elements

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.

8 more elements

Dependencies are inferred from the claim text.

Facts

Application: 17/364,720Filed 30 Jun 2021 · continuation
Priority: 28 Sep 2017
Published: US 2021/0326520 A121 Oct 2021
Granted: 13 Sep 2022
Term ends: Not estimatedThe source records don’t support an estimate.

Classification4 codes

G06F 40/18
Of tables; using ruled lines: of spreadsheets
G06F 16/907
Details of database functions independent of the retrieved data types: retrieval characterised by using metadata, e.g. metadata not derived from…
G06F 16/958
Retrieval from the web: organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
G06F
Computing and data processing

Family

Application62/565,069Us provisional application · filed 28 Sep 2017
Application16/145,051Parent of this continuation · filed 27 Sep 2018
US 2021/0326520 A1Pre-grant publication · published 21 Oct 2021
US 11,080,476 B2Parent of this continuation
US 2019/0095414 A1Published application
US 11,443,109 B2This patent

From the US filing history. Foreign family members aren’t listed.

Timeline

Citations

Open elsewhere

Building an agent or pulling many patents? Use the API or MCP server instead of scraping pages. Get an API key