A form data verification method, device, equipment and medium

Abstract

The embodiment of the present application discloses a table data verification method, specifically, a user can set the format of the target cell and the data verification condition of the cell, wherein the data verification condition includes a first format and a data range. That is, the data verification condition 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 verification condition to obtain a verification result. Among them, 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 at the same time using the data verification condition to ensure that the format and value of the input target data match the format and data range restricted in the data verification condition, thereby improving the accuracy of the target data.

Description

Technical Field

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

[0002] Spreadsheet, also known as electronic data table, is a cell consisting of a series of rows and columns. Cells can store values, calculations, text, etc. Currently, spreadsheets support setting data validation for cells, so as to use data validation to add certain restrictions to the input data. For example, restricting cells to only allow specific values ​​to be entered.

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

[0004] In view of this, the embodiments of the present application provide a table data verification method, device, equipment and medium to implement various restrictions through the data verification function of the cell, so as to meet the demand for more accurate and standardized data entry.

[0005] To achieve the above purpose, the technical solutions provided by the embodiments of the present application are as follows:

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

[0007] 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;

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

[0009] 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.

[0010] In a second aspect of an embodiment of the present application, a table data verification device is provided, which may include:

[0011] 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;

[0012] 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;

[0013] 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.

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

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

[0016] 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 described in the first aspect.

[0017] In a fourth aspect of the embodiments 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.

[0018] In a fifth aspect of the embodiments of the present application, a computer program product is provided. When the computer program product is run on a computer, the computer executes the table data verification method described in the first aspect.

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

[0020] In an embodiment of the present application, a user can set the format of a target cell and a data verification condition of the cell, wherein the data verification condition includes a first format and a data range. That is, the data verification condition 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 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 verification condition to obtain a verification result. Among them, 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 verification condition to ensure that the format and value of the input target data match the format and data range restricted in the data verification condition, thereby improving the accuracy of the target data. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0022] Figure 1 A flow chart of a table data verification method provided in an embodiment of the present application;

[0023] Figure 2a A schematic diagram of an application scenario provided for an embodiment of the present application;

[0024] Figure 2b A schematic diagram of a check box rendering provided in an embodiment of the present application;

[0025] Figure 2c A schematic diagram of a progress bar rendering provided in an embodiment of the present application;

[0026] Figure 3 A schematic diagram of the structure of a table data verification device provided in an embodiment of the present application;

[0027] Figure 4 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0028] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0029] 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, the data type 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 entered. 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.

[0030] However, the current data validation function is relatively strict in validating the data range, and the validation of the data type is still defective, 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 condition set for the cell is date, the start date is 2021 / 11 / 1, and the end date is 2021 / 11 / 21. When the user enters the data as 44510, since the date corresponding to 44510 is 2021 / 11 / 10, which 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 user enters the data as 33100, since the date corresponding to the data is not within the above date range, it will prompt that the input data is illegal.

[0031] Normally, the data type of the data validation condition set by the user is date. When entering data, the data can only pass the validation if and only if the data entered by the user is of date type. For example, when the user enters "2021 / 11 / 10" in a cell, the data type and value range both meet the set validation conditions, and 2021 / 11 / 10 is displayed in the cell. However, the current data validation only supports validation of data ranges, not validation of number formats, and cannot meet actual needs.

[0032] 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 the actual needs.

[0033] To facilitate understanding of the technical solution provided by the embodiments of the present application, it will be described below with reference to the accompanying drawings.

[0034] See also Figure 1 , which is a flow chart of a table data verification method provided in an embodiment of the present application, such as Figure 1 As shown, the method may include:

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

[0036] In this embodiment, in order to make the input data meet the preset conditions, the user can set a data verification condition for the target cell, and the data verification condition includes a first format and a data range. The data verification 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 needs.

[0037] 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 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 to render the cell as a check box based on the user input data. That is, when data validation is set for a cell, the cell may also be rendered according to a specific rendering rule, so that when the data entered in the cell meets the rendering rule, the user's desired presentation style may be rendered in the cell.

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

[0039] 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.

[0040] 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 of the target data and the value of the target data are verified using pre-set data verification conditions to obtain a verification result. The value of the target data can be a number, text, or other verifiable content type.

[0041] In some embodiments of the present disclosure, the target data input by the user may be data that meets the data verification conditions, or may be data that does not meet the data verification conditions. Therefore, the verification results may include legal data and illegal data. Further, the data that does not meet the data verification conditions may include that the format of the target data does not meet the first format in the data verification conditions, and / or the value of the target data does not meet the data range in the data verification 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 verification has a higher priority than the data format in the cell format.

[0042] 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. For example, 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. 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 "numeric value" and 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.

[0043] 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 may 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, 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.

[0044] In some embodiments of the present disclosure, when the target data is determined to be invalid data through data verification, a prompt message may be displayed to indicate that the target data is invalid data. Figure 2a As shown, 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; the target data entered by the user is 40. When validating the target data according to the data validation condition, if the data is determined to be invalid, a prompt message is displayed. For another example, Figure 2b As shown, 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.

[0045] In some embodiments of the present disclosure, after the verification result is determined, 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 data verification conditions. For example, Figure 2a As shown, the data 40 is stored in the cell, and a triangle is marked in the upper right corner of the cell to indicate that the data is invalid data. Alternatively, in response to the first format being the 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 condition, the target data is directly displayed in the cell.

[0046] 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 verification.

[0047] 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:

[0048] When the first format is a checkbox format in the rendering format, the verification result is valid data, and the target data is the first value, a checkbox is displayed in the target cell and the checkbox is in a selected state. The first value can be preset, and this embodiment is not limited here. 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 the checkbox is in a selected state. Figure 2b , as shown in the second check box in the

[0049] When the first format is the checkbox format in the rendering format, the verification result is valid data, and the target data is the second value, a checkbox is displayed in the target cell, and the checkbox is in an unchecked state. 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, a checkbox is displayed in the target table but the checkbox is in an unchecked state. Figure 2b , as shown in the first check box.

[0050] When 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 according to the target data, and the length of the progress bar is related to the value of the target data. Figure 2c The data range corresponding to the progress bar is 0-1, and the target data input by the user is 0.5. Then, the length of the progress bar rendered in the target cell is half of the length of the entire cell, and the data 0.5 is displayed.

[0051] It should be noted that when the first format is the checkbox format in the rendering format and the verification result is invalid data, the checkbox is not displayed in the target cell. That is, when the target data entered by the user is invalid data, the checkbox is not visible. When the first format is the progress bar format in the rendering format and the verification result is invalid data, the progress bar is not rendered in the target cell.

[0052] In some embodiments of the present disclosure, in step 102, in response to an input operation triggered by a user, target data input by the user in a target cell is obtained; the target data input 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.

[0053] 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: determining whether the format of the cell is consistent with the format set in the verification condition, and obtaining the verification result according to the determination result. For example, if the verification condition is set to red as the background color of the cell, then if the user sets the color of the cell to yellow, the verification will fail, but if it is set to red, the verification will pass; or if the verification condition is set to one of merging cells, filtering cells, or freezing cells, then if the user sets the cell to the above format, the verification will pass, otherwise the verification will fail. 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 electronic spreadsheet editing process.

[0054] 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 in conjunction with the accompanying drawings.

[0055] See also Figure 3 , which is a structural diagram of a table data verification device according to an embodiment of the present application, such as Figure 3 As shown, the device may include: a first acquisition unit 301, a second acquisition unit 302 and a third acquisition unit 303.

[0056] A first acquisition unit 301 is used 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;

[0057] A second acquisition unit 302 is used to acquire target data input by the user in the target cell in response to an input operation triggered by the user;

[0058] The third acquisition unit 303 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.

[0059] 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 presented by the target cell.

[0060] 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.

[0061] 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.

[0062] In a specific implementation, the third acquisition 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.

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

[0064] 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.

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

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

[0067] 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, in response to the first format being a data format and the verification result being valid data, fill the target data into the target cell.

[0068] 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.

[0069] 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, and the check box is in an unselected state.

[0070] 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.

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

[0072] 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.

[0073] See also Figure 4, which shows a schematic diagram of the structure of an electronic device 400 suitable for implementing the embodiment of the present application. 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), etc., and fixed terminals such as digital TVs (televisions), desktop computers, etc. Figure 4 The electronic device shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.

[0074] like Figure 4 As shown, the 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. In the RAM 403, various programs and data required for the operation of the electronic device 400 are also stored. The processing device 401, the ROM 402, and the RAM 403 are connected to each other via a bus 404. An input / output (I / O) interface 405 is also connected to the bus 404.

[0075] Typically, the following devices may be connected to the I / O interface 405: an input device 406 including, for example, a touch screen, a touch pad, 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 Figure 4 The electronic device 400 is shown with various devices, but it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed instead.

[0076] 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 through the communication device 409, or installed from the storage device 408, or installed from the ROM402. 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 executed.

[0077] 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. The technical details not fully described in this embodiment can be referred to the above embodiment, and this embodiment has the same beneficial effects as the above embodiment.

[0078] 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.

[0079] It should be noted that the computer-readable medium mentioned above in the present application may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may 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 may 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 the present application, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In the present application, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. The computer readable signal medium may also be any computer readable medium other than a computer readable storage medium, which may send, propagate or transmit 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 of the above.

[0080] In some embodiments, the client and the server may communicate using any currently known or future developed network protocol such as HTTP (HyperText Transfer Protocol), and may 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 future developed network.

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

[0082] 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.

[0083] 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 separate 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 via 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).

[0084] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present application. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the 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 square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square 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 square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

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

[0086] The functions described above herein may be performed at least in part by one or more hardware logic components. For example, 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 chips (SOCs), complex programmable logic devices (CPLDs), and the like.

[0087] In the context of the present application, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may 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 may 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.

[0088] It should be noted that the various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments, and the same or similar parts between the various embodiments can be referred to each other. For the system or device disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and the relevant parts can be referred to the method part description.

[0089] It should be understood that in the present 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 objects associated before and after are in an "or" relationship. "At least one of the following" or similar expressions refers to any combination of these items, including any combination of single 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.

[0090] It should also be noted that, in this article, relational terms such as first and second, etc. are only used 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 "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.

[0091] The steps of the method or algorithm 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), a memory, a read-only memory (ROM), an electrically programmable ROM, an electrically erasable programmable ROM, a register, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.

[0092] The above description of the disclosed embodiments enables those skilled in the art to implement or use the present application. Various modifications to these embodiments will be apparent to those 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 will not be limited to the embodiments shown herein, but will 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, a data validation condition set for a target cell is obtained, the data validation condition comprising a first format and a data range, the first format comprising a data format and a rendering format, the data format being used to indicate a type of data input into the target cell, the rendering format being used to indicate a style presented by the target cell, the data format comprising at least one or more of a numerical type, a date type, a currency type, and a time type; the rendering format comprising a check box format or a progress bar format; In response to an input operation triggered by a user, acquiring target data input by the user in the target cell, wherein the target data is content data or format data; 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 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.

3. The method according to claim 1, 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.

4. The method according to claim 2 or 3, 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.

5. 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.

6. The method according to claim 4, 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.

7. The method according to claim 4, 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.

8. The method according to claim 6, 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.

9. The method according to claim 6, 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.

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

11. A table data verification device, characterized in that: The device comprises: a first acquisition unit, configured to acquire, in response to a setting operation triggered by a user, a data validation condition set for a target cell, wherein the data validation condition includes a first format and a data range, wherein the first format includes a data format and a rendering format, wherein the data format is used to indicate a type of data input into the target cell, and the rendering format is used to indicate a style presented by the target cell, wherein 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; 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, wherein the target data is content data or format data; 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.

12. 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 10.

13. 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 10.

Images