Title:
SPREADSHEET DATA VALIDATION METHOD AND APPARATUS, DEVICE, AND MEDIUM
Document Type and Number:
WIPO Patent Application WO/2023/124937
Kind Code:
A1
Abstract:
The present application discloses a spreadsheet data validation method. Specifically, a user may set a format of a target cell and a data validation condition of the cell, and the data validation condition comprises a first format and a data range. That is, the data validation condition can not only validate a format of input data in the cell, but also validate a range of the input data. When the user inputs target data to the target cell, the target data is obtained, and a format of the target data and a value of the target data are validated by using the set data validation condition to obtain the validation result. The format of the target data is a second format corresponding to the target cell. That is, the format and value of the target data are simultaneously validated by using the data validation condition, so as to ensure that the format and value of the input target data match the format and the data range limited in the data validation condition, thereby improving the accuracy of the target data.
Inventors:
LIN ZIHUAN (CN)
WEN WEIJIA (CN)
TAN SHUMING (CN)
WEN WEIJIA (CN)
TAN SHUMING (CN)
Application Number:
PCT/CN2022/138370
Publication Date:
July 06, 2023
Filing Date:
December 12, 2022
Export Citation:
Assignee:
BEIJING ZITIAO NETWORK TECHNOLOGY CO LTD (CN)
International Classes:
G06F40/174
Foreign References:
| CN114357954A | 2022-04-15 | |||
| US20170357628A1 | 2017-12-14 | |||
| US20070101252A1 | 2007-05-03 | |||
| CN112507677A | 2021-03-16 | |||
| CN111400380A | 2020-07-10 |
Attorney, Agent or Firm:
SINOTALEN ATTORNEYS AT LAW (CN)
Download PDF: