Spreadsheet data validation method and apparatus, device, and medium

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.

Description

A form data verification method, device, equipment and medium

[0001] This application claims priority to the Chinese patent application with application number 202111643678.8 filed on December 29, 2021, and application name “A form data verification method, device, equipment and medium”, the entire contents of which are incorporated by reference into this application. Technical Field

[0002] The present application relates to the field of computer technology, and in particular to a table data verification method, apparatus, device and medium. Background Art

[0003] A spreadsheet, also known as an electronic data table, consists of a series of cells arranged in rows and columns. Cells can store values, calculations, text, and more. Currently, spreadsheets support data validation for cells, allowing you to apply certain restrictions to input data. For example, you can restrict a cell to only accept certain values.

[0004] However, the current data validation function of cells has weak limiting capabilities and cannot meet the needs of more accurate and standardized data entry.

[0005] Summary of the Invention

[0006] In view of this, the present application provides a table data verification method, device, equipment and medium to implement multi-faceted restrictions through the cell data verification function to meet the demand for more accurate and standardized data entry.

[0007] To achieve the above objectives, the technical solutions provided by this application are as follows:

[0008] In a first aspect of the present application, a table data verification method is provided, which may include:

[0009] In response to a setting operation triggered by a user, obtaining a data validation condition set for a target cell, the data validation condition including a first format and a data range;

[0010] In response to an input operation triggered by a user, obtaining target data input by the user in the target cell;

[0011] The format of the target data and the value of the target data are verified according to the data verification condition to obtain a verification result, in which the format of the target data is the second format corresponding to the target cell.

[0012] In a second aspect of the present application, a form data verification device is provided, which may include:

[0013] a first acquiring unit, configured to acquire, in response to a setting operation triggered by a user, a data validation condition set for a target cell, the data validation condition including a first format and a data range;

[0014] a second acquiring unit, configured to acquire target data input by the user in the target cell in response to an input operation triggered by the user;

[0015] The third acquisition unit is used to verify the format of the target data and the value of the target data according to the data verification condition to obtain a verification result, wherein the format of the target data is the second format corresponding to the target cell.

[0016] In a third aspect of the present application, an electronic device is provided, the device comprising: a processor and a memory;

[0017] The memory is used to store instructions or computer programs;

[0018] The processor is configured to execute the instructions or computer program in the memory, so that the electronic device executes the form data verification method described in the first aspect.

[0019] In a fourth aspect of the present application, a computer-readable storage medium is provided, wherein instructions are stored in the computer-readable storage medium. When the instructions are executed on a device, the device executes the form data verification method described in the first aspect.

[0020] In a fifth aspect of the present application, a computer program product is provided. When the computer program product is run on a computer, the computer is caused to execute the form data verification method described in the first aspect.

[0021] It can be seen that the embodiments of the present application have the following beneficial effects:

[0022] In the present application, the user can set the format of the target cell and the data validation conditions of the cell, wherein the data validation conditions include a first format and a data range. That is, the data validation conditions can not only verify the format of the data input in the cell, but also verify the range of the input data. When the user inputs the target data into the target cell, the target data is obtained, and the format of the target data and the value of the target data are verified using the set data validation conditions to obtain a verification result. The format of the target data is the second format corresponding to the target cell. That is, the format and value of the target data are verified simultaneously using the data validation conditions to ensure that the format and value of the input target data match the format and data range restricted in the data validation conditions, thereby improving the accuracy of the target data. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are only some embodiments recorded in this application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0024] FIG1 is a flow chart of a table data verification method provided in an embodiment of the present application;

[0025] FIG2a is a schematic diagram of an application scenario provided by an embodiment of the present application;

[0026] FIG2 b is a schematic diagram of a check box rendering provided by an embodiment of the present application;

[0027] FIG2c is a schematic diagram of a progress bar rendering provided by an embodiment of the present application;

[0028] FIG3 is a schematic diagram of the structure of a table data verification device provided in an embodiment of the present application;

[0029] FIG4 is a schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0030] In order to help those skilled in the art better understand the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative work are within the scope of protection of this application.

[0031] In actual applications, when users use tables to process data, they can set the data type in the cell format according to their own needs to ensure that the input data can be displayed according to the set data type. Among them, data types may include: general, numeric, currency, date, time, fraction, etc. Furthermore, in order to improve work efficiency and avoid the entry of illegal data, users can also set data validation for cells to define the data that can be entered or should be entered in the cell by setting the validation conditions of data validation. For example, the data types that can be selected for the validation conditions in data validation include: integers, decimals, time, date, text length, etc., and the corresponding data range can also be set for the data types (data formats) allowed to be input. For example, if the validation condition selected is date, and the start date is set to 2021 / 11 / 1 and the end date is set to 2021 / 11 / 21, then data validation only allows users to enter data between 2021 / 11 / 1-2021 / 11 / 21.

[0032] However, the current data validation function is relatively strict in validating the data range, and there are still defects in the validation of the data type, which cannot meet the requirements for more accurate and standardized information input. For example, the data type of the cell format set by the user is "numeric", the data type in the data validation conditions set for the cell is date, the start date is 2021 / 11 / 1, and the end date is 2021 / 11 / 21. When the data entered by the user is 44510, since the date corresponding to 44510 is 2021 / 11 / 10, the date is within the above date range, the data validation passes (only the data range is validated), and 44510.00 is displayed in the cell, not 2021 / 11 / 10; if the data entered by the user is 33100, since the date corresponding to the data is not within the above date range, it will be prompted that the input data is illegal.

[0033] Typically, when a user sets a data validation condition for a date, the data type will pass validation only if the data entered is a date. For example, if a user enters "2021 / 11 / 10" in a cell, both the data type and the value range will meet the validation criteria, and 2021 / 11 / 10 will be displayed in the cell. However, current data validation only supports data range validation, not number format validation, which cannot meet actual needs.

[0034] Based on this, an embodiment of the present application provides a table data validation method to limit the format of the cell when limiting the value of the cell, so that the input data meets actual needs.

[0035] To facilitate understanding of the technical solutions provided in the embodiments of the present application, they will be described below with reference to the accompanying drawings.

[0036] Referring to FIG1 , which is a flow chart of a table data verification method provided in an embodiment of the present application, as shown in FIG1 , the method may include:

[0037] S101: In response to a setting operation triggered by a user, obtaining a data verification condition set for a target cell.

[0038] In this embodiment, to ensure that the input data meets the preset conditions, the user can set a data validation condition for the target cell, where the data validation condition includes a first format and a data range. The data validation condition is used to verify whether the data entered by the user in the target cell meets the preset conditions, thereby ensuring that the input data meets the user's requirements.

[0039] The target cell may be one or more cells in a table, and the first format may include a data format and a rendering format. The data format is used to indicate the type of data input into the target cell, and the rendering format is used to indicate the style of presentation of the target cell. The data format may include a numeric type, a date type, a currency type, a time type, etc.; the rendering format may include a check box format, a progress bar format, a cell style, a font format, etc. The cell style may include a background style, a border style, etc.; the font style may include a font color, a font type, an alignment, etc. For example, when the format set by the user in data validation is a check box format, it will be determined whether the cell is rendered as a check box based on the user input data. That is, when setting data validation for a cell, the cell can also be rendered according to specific rendering rules, so that when the data entered in the cell meets the rendering rules, the cell can be rendered in the presentation style required by the user.

[0040] S102: In response to an input operation triggered by a user, obtaining target data input by the user in a target cell.

[0041] S103: Verify the format of the target data and the value of the target data according to the data verification condition to obtain a verification result.

[0042] In some embodiments of the present disclosure, when a user enters data into a target cell, the target data entered by the user is obtained and the format and value of the target data are verified using pre-set data validation conditions to obtain a validation result. The target data value can be a number, text, or other verifiable content type.

[0043] In some embodiments of the present disclosure, the target data input by the user may be data that meets the data validation conditions, or may be data that does not meet the data validation conditions. Therefore, the verification results may include legal data and illegal data. Furthermore, for data that does not meet the data validation conditions, it may include that the format of the target data does not meet the first format in the data validation conditions, and / or the value of the target data does not meet the data range in the data validation conditions. Among them, the format of the target data refers to the second format corresponding to the target cell, that is, the cell format set by the user, and the second format mainly refers to the data format in the cell format. In this embodiment, the priority of the first format is higher than the priority of the second format, that is, the data format in data validation has a higher priority than the data format in the cell format.

[0044] In some embodiments of the present disclosure, in response to the format of the target data not matching the data format in the data validation condition, and / or the value of the target data not matching the data range in the data validation condition, the target data is determined to be illegal data. Wherein, illegal data is invalid data. For example, the data format of the cell format set by the user is "value", the data format in the data validation condition set for the cell is date, the start date is 2021 / 11 / 1, and the end date is 2021 / 11 / 21. When the data entered by the user is 44510, the data format and data range of the target data will be verified. Since the data format of the target data is "value", which does not match the data format "date" in the data validation, the input data 44510 will be determined to be invalid data. For another example, if the data entered by the user is 33100, since the data format of the target data does not match the data format "date" in the data validation condition, and the date corresponding to the data is not within the above date range, the target data is determined to be invalid data.

[0045] In some embodiments of the present disclosure, when the first format is a rendering format and the value of the target data does not match the data range in the data validation condition, the target data is determined to be invalid data. That is, when the first format of data validation is a rendering format, each rendering format can have its corresponding data range. For example, when the rendering format is a checkbox format, it limits the cell input to 0 or 1. If the target data entered by the user is 2, the target data is determined to be invalid data; when the rendering format is a progress bar format, it limits the cell input to 0-1. If the target data entered by the user is 1.1, the target data is determined to be invalid data.

[0046] In some embodiments of the present disclosure, when it is determined through data validation that the target data is invalid data, a prompt message can also be displayed, and the prompt message is used to prompt that the target data is invalid data. For example, as shown in Figure 2a, the data format of the cell format set by the user is "numeric value", the data format in the data validation condition set for the cell is date, the start date is 2021 / 11 / 1, and the end date is 2021 / 11 / 21; the target data entered by the user is 40, and when the target data is verified according to the data validation condition, it is determined that the data is invalid data, and a prompt message is displayed. For another example, as shown in Figure 2b, the data validation condition set by the user is a check box, and the data input condition corresponding to the check box is 0 or 1. When the data entered by the user is 3, the data will be determined to be invalid data, and a prompt message will be displayed.

[0047] In some embodiments of the present disclosure, after determining the verification result, the target cell can also be rendered according to the verification result and the target data. That is, the content displayed in the target cell is determined according to the verification result and the target data. Specifically, in response to the first format being a data format and the verification result being invalid data, the target data is filled into the target cell and the target cell is marked. The mark is used to prompt the user that the data in the target cell does not meet the conditions for data verification. For example, as shown in Figure 2a, data 40 is stored in a cell, and a triangle is marked in the upper right corner of the cell to prompt the user that the data is invalid data through the triangle. Alternatively, in response to the first format being a data format and the verification result being valid data, the target data is filled into the target cell. That is, when the data format and value of the target data meet the data format and data range in the data verification conditions, the target data is directly displayed in the cell.

[0048] In some embodiments of the present disclosure, when the first format is a rendering format, in response to the verification result being valid data, the target cell is rendered according to the rendering format and the target data; in response to the verification result being invalid data, the target data is filled into the target cell and the target cell is marked. The marking of the target cell is used to indicate that the data in the target cell meets the conditions restricted by the data validation.

[0049] In some embodiments of the present disclosure, when the first format is a rendering format, in response to the verification result being valid data, rendering the target cell according to the rendering format and the target data may include:

[0050] When the first format is a checkbox format in the rendering format, the verification result is valid data, and the target data is a first value, a checkbox is displayed in the target cell and is selected. The first value can be pre-set and is not limited in this embodiment. For example, if the first value is 1 and the user enters 1 in the target table, a checkbox is displayed in the target table and is selected, as shown in the second checkbox in Figure 2b.

[0051] When the first format is a checkbox format in the rendering format, the validation result is valid data, and the target data is the second value, a checkbox is displayed in the target cell, and the checkbox is unchecked. The second value is different from the first value. For example, if the second value is 0 and the user enters 0 in the target table, the checkbox is displayed in the target table, but it is unchecked, as shown in the first checkbox in Figure 2b.

[0052] If the first format is a progress bar format in the rendering format and the verification result is valid data, a progress bar is rendered in the target cell based on the target data. The length of the progress bar is related to the value of the target data. For example, as shown in Figure 2c, if the data range corresponding to the progress bar is 0-1 and the user enters the target data as 0.5, the length of the progress bar rendered in the target cell will be half the length of the entire cell and the data 0.5 will be displayed.

[0053] It should be noted that when the first format is the checkbox format in the rendering format and the validation result is invalid data, the checkbox is not displayed in the target cell. In other words, when the target data entered by the user is invalid data, the checkbox is invisible. When the first format is the progress bar format in the rendering format and the validation result is invalid data, the progress bar is not rendered in the target cell.

[0054] In some embodiments of the present disclosure, in step 102, in response to an input operation triggered by the user, the target data entered by the user in the target cell is obtained; the target data entered by the user can be content data (for example, numbers, text, or pictures, etc.), or it can be format data, such as a cell background style, border style, structure format, etc.

[0055] In some embodiments of the present disclosure, when the target data is formatted data, the format of the target data and the value of the target data are verified according to the data verification condition in step 103, including: judging whether the format of the cell is consistent with the format set in the verification condition, and obtaining the verification result according to the judgment result. For example, if the verification condition is set to red as the background color of the cell, then the verification will fail if the user sets the color of the cell to yellow, and pass if it is set to red; or if the verification condition is set to one of merging cells, filtering cells, or freezing cells, then the verification will pass if the user sets the cell to the above format, and fail otherwise. This embodiment can directly verify the format of the cell, breaking through the limitation that traditional cell verification can only verify the input cell content, expanding the scope of cell verification, and enriching the verification methods in the spreadsheet editing process.

[0056] Based on the above method embodiment, the embodiment of the present application provides a form data verification device and an electronic device, which will be described below with reference to the accompanying drawings.

[0057] Refer to Figure 3, which is a structural diagram of a form data verification device according to an embodiment of the present application. As shown in Figure 3, the device may include: a first acquisition unit 301, a second acquisition unit 302 and a third acquisition unit 303.

[0058] A first acquiring unit 301 is configured to acquire, in response to a setting operation triggered by a user, a data validation condition set for a target cell, the data validation condition including a first format and a data range;

[0059] A second acquiring unit 302 is configured to acquire target data input by the user in the target cell in response to an input operation triggered by the user;

[0060] The third obtaining unit 303 is configured to verify the format of the target data and the value of the target data according to the data verification condition to obtain a verification result, wherein the format of the target data is the second format corresponding to the target cell.

[0061] In a specific implementation, the first format includes a data format and a rendering format, the data format is used to indicate the type of data input into the target cell, and the rendering format is used to indicate the style of the target cell.

[0062] In a specific implementation, the data format includes at least one or more of a numerical type, a date type, a currency type, and a time type; and the rendering format includes a check box format or a progress bar format.

[0063] In a specific implementation, the third acquisition unit 303 is specifically used to determine that the target data is invalid data in response to the format of the target data not matching the data format in the data verification condition, and / or the value of the target data not matching the data range in the data verification condition.

[0064] In a specific implementation, the third obtaining unit 303 is specifically configured to determine that the target data is invalid data in response to the first format being the rendering format and the data range of the target data not matching the data range in the data verification condition.

[0065] In a specific implementation, the device further includes: a display unit;

[0066] The display unit is used to display a prompt message, where the prompt message is used to prompt that the target data is invalid data.

[0067] In a specific implementation, the apparatus further includes: a processing unit;

[0068] The processing unit is configured to render the target cell according to the verification result and the target data.

[0069] In a specific implementation, the processing unit is specifically used to fill the target data into the target cell and mark the target cell in response to the first format being a data format and the verification result being invalid data; or, to fill the target data into the target cell in response to the first format being a data format and the verification result being valid data.

[0070] In a specific implementation, the processing unit is specifically used to render the target cell according to the rendering format and the target data in response to the first format being a rendering format and the verification result being valid data; or, in response to the first format being a rendering format and the verification result being invalid data, fill the target data into the target cell and mark the target cell.

[0071] In a specific implementation, the processing unit is specifically used to display a check box in the target cell in response to the first format being a check box format, the verification result being valid data, and the target data being a first value, and the check box is in a selected state; or, in response to the first format being a check box format, the verification result being valid data, and the target data being a second value, display a check box in the target cell in an unselected state.

[0072] In a specific implementation, the processing unit is specifically used to render a progress bar in the target cell according to the target data in response to the first format being a progress bar format and the verification result being valid data, and the length of the progress bar is related to the value of the target data.

[0073] In a specific implementation, the first format has a higher priority than the second format.

[0074] It should be noted that the implementation of each unit in this embodiment can refer to the above method embodiment, and this embodiment will not be repeated here.

[0075] Referring to FIG4 , a schematic diagram of the structure of an electronic device 400 suitable for implementing an embodiment of the present application is shown. The terminal device in the embodiment of the present application may include, but is not limited to, mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (portable Android devices), PMPs (Portable Media Players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), and fixed terminals such as digital TVs (televisions), desktop computers, and the like. The electronic device shown in FIG4 is merely an example and should not limit the functions and scope of use of the embodiments of the present application.

[0076] As shown in Figure 4, electronic device 400 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 401, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 402 or a program loaded from a storage device 408 into a random access memory (RAM) 403. Various programs and data required for the operation of electronic device 400 are also stored in RAM 403. Processing device 401, ROM 402, and RAM 403 are connected to each other via a bus 404. An input / output (I / O) interface 405 is also connected to bus 404.

[0077] Typically, the following devices may be connected to the I / O interface 405: an input device 406 including, for example, a touch screen, a touchpad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; an output device 407 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 408 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 409. The communication device 409 may allow the electronic device 400 to communicate with other devices wirelessly or by wire to exchange data. Although FIG4 shows the electronic device 400 with various devices, it should be understood that not all of the devices shown are required to be implemented or present. More or fewer devices may alternatively be implemented or present.

[0078] In particular, according to an embodiment of the present application, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present application includes a computer program product, which includes a computer program carried on a non-transitory computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network via the communication device 409, or installed from the storage device 408, or installed from the ROM 402. When the computer program is executed by the processing device 401, the above-mentioned functions defined in the method of the embodiment of the present application are performed.

[0079] The electronic device provided in the embodiment of the present application and the table data verification method provided in the above embodiment belong to the same inventive concept. For technical details not fully described in this embodiment, please refer to the above embodiment, and this embodiment has the same beneficial effects as the above embodiment.

[0080] An embodiment of the present application provides a computer-readable medium having a computer program stored thereon, wherein when the program is executed by a processor, the table data verification method as described in any of the above embodiments is implemented.

[0081] It should be noted that the computer-readable medium mentioned above in this application can be a computer-readable signal medium or a computer-readable storage medium, or any combination of the two. The computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or device, or any combination of the above. More specific examples of computer-readable storage media can include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this application, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, device, or device. In this application, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, which carries computer-readable program code. This propagated data signal can take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. A computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transport a program for use by or in conjunction with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium may be transmitted using any suitable medium, including but not limited to wires, optical cables, RF (radio frequency), etc., or any suitable combination thereof.

[0082] In some embodiments, the client and server can communicate using any currently known or later developed network protocol, such as HTTP (HyperText Transfer Protocol), and can be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or later developed network.

[0083] The computer-readable medium may be included in the electronic device, or may exist independently without being incorporated into the electronic device.

[0084] The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device executes the form data verification method.

[0085] Computer program code for performing the operations of the present application may be written in one or more programming languages, or a combination thereof, including, but not limited to, object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a stand-alone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0086] The flow charts and block diagrams in the accompanying drawings illustrate the possible architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present application. In this regard, each box in the flow chart or block diagram can represent a module, program segment or a part of code, and the module, program segment or a part of code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order than that marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram and / or flow chart, and the combination of the boxes in the block diagram and / or flow chart can be implemented by a dedicated hardware-based system that performs the specified function or operation, or can be implemented by a combination of dedicated hardware and computer instructions.

[0087] The units involved in the embodiments described in this application may be implemented in software or hardware. The name of a unit / module does not necessarily limit the unit itself. For example, a voice data acquisition module may also be described as a "data acquisition module."

[0088] The functions described above herein may be performed, at least in part, by one or more hardware logic components. For example, and without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chip (SOCs), complex programmable logic devices (CPLDs), and the like.

[0089] In the context of the present application, a machine-readable medium can be a tangible medium that can contain or store a program for use by an instruction execution system, device or equipment or used in combination with an instruction execution system, device or equipment. A machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared or semiconductor system, device or equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium can include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0090] It should be noted that the various embodiments in this specification are described in a progressive manner, with each embodiment focusing on the differences from other embodiments. Reference can be made to the common and similar parts between the various embodiments. For the systems or devices disclosed in the embodiments, since they correspond to the methods disclosed in the embodiments, the description is relatively simple, and the relevant parts can be referred to the method description.

[0091] It should be understood that in this application, "at least one (item)" means one or more, and "plurality" means two or more. "And / or" is used to describe the association relationship of associated objects, indicating that three relationships may exist. For example, "A and / or B" can mean: only A exists, only B exists, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally indicates that the previous and next associated objects are in an "or" relationship. "At least one of the following items" or similar expressions refers to any combination of these items, including any combination of single items or plural items. For example, at least one of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, c can be single or multiple.

[0092] It should also be noted that, in this document, relational terms such as first and second, etc., are used only to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "comprises," "comprising," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or device comprising a series of elements includes not only those elements, but also other elements not explicitly listed, or elements inherent to such process, method, article, or device. In the absence of further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of additional identical elements in the process, method, article, or device comprising the element.

[0093] The steps of the methods or algorithms described in conjunction with the embodiments disclosed herein may be implemented directly using hardware, a software module executed by a processor, or a combination of the two. The software module may be placed in a random access memory (RAM), internal memory, read-only memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.

[0094] The above description of the disclosed embodiments is intended to enable one skilled in the art to implement or use the present application. Various modifications to these embodiments will be readily apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application is not limited to the embodiments shown herein, but is intended to conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A table data verification method, characterized in that: The method comprises: In response to a setting operation triggered by a user, obtaining a data verification condition set for a target cell, wherein the data verification condition includes a first format and a data range; In response to an input operation triggered by a user, obtaining target data input by the user in the target cell; The format of the target data and the value of the target data are verified according to the data verification condition to obtain a verification result, wherein the format of the target data is a second format corresponding to the target cell.

2. The method according to claim 1, characterized in that The first format includes a data format and a rendering format, the data format is used to indicate the type of data input into the target cell, and the rendering format is used to indicate the style presented by the target cell.

3. The method according to claim 2, characterized in that The data format includes at least one or more of a numerical type, a date type, a currency type, and a time type; the rendering format includes a check box format and a progress bar format.

4. The method according to claim 2 or 3, characterized in that: The verifying the format of the target data and the value of the target data according to the data verification condition to obtain a verification result includes: In response to a format of the target data not matching a data format in the data verification condition, and / or a value of the target data not matching a data range in the data verification condition, the target data is determined to be invalid data.

5. The method according to claim 2 or 3, characterized in that: The verifying the format of the target data and the value of the target data according to the data verification condition to obtain a verification result includes: In response to the first format being the rendering format and the data range of the target data not matching the data range in the data verification condition, it is determined that the target data is invalid data.

6. The method according to claim 4 or 5, characterized in that: The method further comprises: A prompt message is displayed, where the prompt message is used to prompt that the target data is invalid data.

7. The method according to claim 1, characterized in that The method further comprises: The target cell is rendered according to the verification result and the target data.

8. The method according to claim 7, characterized in that The rendering of the target cell according to the verification result and the target data includes: In response to the first format being a data format and the verification result being invalid data, filling the target data into the target cell and marking the target cell; or, In response to the first format being a data format and the verification result being valid data, the target data is filled into the target cell.

9. The method according to claim 7, characterized in that: The rendering of the target cell according to the verification result and the target data includes: In response to the first format being a rendering format and the verification result being valid data, rendering the target cell according to the rendering format and the target data; or, In response to the first format being a rendering format and the verification result being invalid data, the target data is filled into the target cell, and the target cell is marked.

10. The method according to claim 9, characterized in that In response to the first format being a rendering format and the verification result being valid data, rendering the target cell according to the rendering format and the target data includes: In response to the first format being a check box format, the verification result being valid data, and the target data being a first value, displaying a check box in the target cell, the check box being in a selected state; or, In response to the first format being a check box format, the verification result being valid data, and the target data being a second value, a check box is displayed in the target cell, and the check box is in an unchecked state.

11. The method according to claim 9, characterized in that In response to the first format being a rendering format and the verification result being valid data, rendering the target cell according to the rendering format and the target data includes: In response to the first format being a progress bar format and the verification result being valid data, a progress bar is rendered in the target cell according to the target data, and the length of the progress bar is related to the value of the target data.

12. The method according to claim 1, characterized in that The first format has a higher priority than the second format.

13. A table data verification device, characterized in that: The device comprises: A first acquisition unit, configured to acquire a data validation condition set for a target cell in response to a setting operation triggered by a user, wherein the data validation condition includes a first format and a data range; A second acquisition unit, configured to acquire target data input by the user in the target cell in response to an input operation triggered by the user; The third acquisition unit is used to verify the format of the target data and the value of the target data according to the data verification condition to obtain a verification result, wherein the format of the target data is a second format corresponding to the target cell.

14. An electronic device, characterized in that: The device comprises: a processor and a memory; The memory is used to store instructions or computer programs; The processor is used to execute the instructions or computer programs in the memory so that the electronic device executes the form data verification method according to any one of claims 1 to 12.

15. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores instructions, and when the instructions are executed on a device, the device executes the form data verification method according to any one of claims 1 to 12.

16. A computer program product, characterized in that When the computer program product is run on a computer, the computer is enabled to execute the form data verification method according to any one of claims 1 to 12.

Images