CN115879429B - Electronic form verification method and device, electronic equipment and storage medium - Google Patents
Electronic form verification method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN115879429B CN115879429B CN202310081072.2A CN202310081072A CN115879429B CN 115879429 B CN115879429 B CN 115879429B CN 202310081072 A CN202310081072 A CN 202310081072A CN 115879429 B CN115879429 B CN 115879429B
- Authority
- CN
- China
- Prior art keywords
- editing
- user
- designated
- cell
- electronic form
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present disclosure provides a method, an apparatus, an electronic device and a storage medium for checking an electronic form, including: responding to editing operation of a user, and intercepting editing matters generated when the user edits designated cells of the electronic form; setting the editing item as a to-be-checked attribute of the designated cell; obtaining a verification result of the attribute to be verified of the designated cell; and responding to the verification result of verification passing, and editing the designated cells of the electronic table according to the editing matters.
Description
Technical Field
The disclosure relates to the field of computer data processing, and in particular relates to a method and a device for checking a spreadsheet, electronic equipment and a storage medium.
Background
The electronic forms become an important mode for enterprises to collect data, so that multi-person online collaborative processing of the table data can be realized, and the data processing efficiency is greatly improved. However, since data in some cells in some forms are very important, the data may affect the calculation result of other important data in the forms, and when many people cooperate to process the electronic forms, misoperation of the cells may occur, so that the error rate of filling in the form data is increased.
Disclosure of Invention
The present disclosure provides a method, an apparatus, an electronic device, and a storage medium for verifying an electronic form, so as to at least solve the above technical problems in the prior art.
According to a first aspect of the present disclosure, there is provided a spreadsheet verification method comprising: responding to editing operation of a user, and intercepting editing matters generated when the user edits designated cells of the electronic form; setting the editing item as a to-be-checked attribute of the designated cell; obtaining a verification result of the attribute to be verified of the designated cell; and responding to the verification result of verification passing, and editing the designated cells of the electronic table according to the editing matters.
In one embodiment, the method further comprises: and responding to a verification result that the verification is not passed, and keeping the designated cells of the electronic table unchanged.
In one embodiment, after the editing operation of the user, before intercepting the editing event generated when the user edits the designated cell of the electronic form, the method further includes: and opening the editing state of the designated cell in the electronic table so that the user edits the designated cell.
In an embodiment, after the responding to the editing operation of the user, before opening the editing state of the designated cell in the electronic table, the method further includes: and determining that the user has editing authority of the designated cell.
In an embodiment, after intercepting the editing event generated when the user edits the designated cell of the electronic form, the method further includes: and deleting the editing matters and generating first prompt information for prompting a user that the editing matters do not meet the requirements when the editing matters are determined to not meet the preset conditions.
In an embodiment, the method further includes, after the editing state of the specified cell in the electronic form is opened to enable the user to edit the specified cell: locking the editing state of the designated cell for other users; correspondingly, after the designated cells of the electronic form are edited according to the editing matters in response to the verification result that the verification is passed, the method further comprises: and unlocking the editing state of the designated cell for the other user.
In one embodiment, after intercepting the editing event generated when the user edits the designated cell of the electronic form, the method further includes: generating a second prompt for indicating that the edit item of the specified cell in the electronic form is being checked.
According to a second aspect of the present disclosure, there is provided a spreadsheet verification apparatus, the apparatus comprising: an interception unit, configured to intercept editing items generated when a user edits a specified cell of a spreadsheet in response to an editing operation by the user; the conversion unit is used for taking the editing item as the attribute to be verified of the designated cell; the acquisition unit is used for acquiring a verification result of the attribute to be verified of the designated cell; and the execution unit is used for responding to the verification result of verification passing, and editing the designated cells of the electronic table according to the editing matters.
According to a third aspect of the present disclosure, there is provided an electronic device comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein, the liquid crystal display device comprises a liquid crystal display device,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the spreadsheet verification method described in the present disclosure.
According to a fourth aspect of the present disclosure, there is provided a non-transitory computer-readable storage medium storing computer instructions for causing the computer to perform the spreadsheet verification method of the present disclosure.
According to the electronic form verification method, the electronic form verification device, the electronic equipment and the storage medium, firstly, when the electronic form responds to the editing operation of a user, editing matters generated when the user edits the designated cells of the electronic form are intercepted, namely, when the user edits the designated cells, the contents in the designated cells are not immediately modified; and setting the editing matters as to-be-checked attributes of the designated cells, checking the to-be-checked attributes, and editing the designated cells of the electronic form according to the editing matters when the checking result is that the checking is passed. Therefore, the editing and modifying of the designated cells are determined when the verification passes through the verification by verifying the attribute to be verified with the editing matters as contents, and the accuracy of data modification of the designated cells in the electronic form is improved.
It should be understood that the description in this section is not intended to identify key or critical features of the embodiments of the disclosure, nor is it intended to be used to limit the scope of the disclosure. Other features of the present disclosure will become apparent from the following specification.
Drawings
The above, as well as additional purposes, features, and advantages of exemplary embodiments of the present disclosure will become readily apparent from the following detailed description when read in conjunction with the accompanying drawings. Several embodiments of the present disclosure are illustrated by way of example, and not by way of limitation, in the figures of the accompanying drawings, in which:
in the drawings, the same or corresponding reference numerals indicate the same or corresponding parts.
FIG. 1 is a schematic diagram illustrating a flowchart of a method for verifying a spreadsheet according to an embodiment of the present disclosure;
FIG. 2 illustrates a second flowchart of an implementation of a spreadsheet verification method according to an embodiment of the present disclosure;
FIG. 3 shows a schematic diagram I of a spreadsheet verification device according to an embodiment of the present disclosure;
FIG. 4 illustrates a schematic diagram II of a spreadsheet verification device according to an embodiment of the present disclosure;
fig. 5 shows a schematic diagram of a composition structure of an electronic device according to an embodiment of the present disclosure.
Detailed Description
In order to make the objects, features and advantages of the present disclosure more comprehensible, the technical solutions in the embodiments of the present disclosure will be clearly described in conjunction with the accompanying drawings in the embodiments of the present disclosure, and it is apparent that the described embodiments are only some embodiments of the present disclosure, but not all embodiments. Based on the embodiments in this disclosure, all other embodiments that a person skilled in the art would obtain without making any inventive effort are within the scope of protection of this disclosure.
To reduce the error rate of electronic form editing content in a multi-person collaboration state, one embodiment of the present disclosure provides a method for electronic form verification, as shown in fig. 1, the method comprising:
In this embodiment, the designated cells are cells in which the additional verification attribute is set in the electronic form, and the editing operation by the user may include deleting the original content in the designated cells or inputting new content to replace the original content in the designated cells. When the user edits the designated cell, the editing item is prevented from directly modifying the designated cell, i.e., the edited editing item cannot be directly modified.
Step 102, setting the editing item as the to-be-verified attribute of the designated cell.
Wherein the attribute to be verified is an attribute related to the user, that is, only the specified user is visible, and the editing item can be subjected to a verification operation.
Step 103, obtaining a verification result of the attribute to be verified of the designated cell.
After the attribute to be verified of the designated cell is generated, a verification request is required to be sent to at least one user with verification authority, so that the user with verification authority feeds back a verification result according to the verification request.
The verification result is a judgment made after the user with verification authority verifies the to-be-verified attribute of which the editing matters are contents, and is mainly divided into a positive result and a negative result. For example, the user adds a predetermined meeting record to the meeting schedule record table, and the content of the editing matters may be "department a 10 a.m. at 2022, 11, 9: 00 conferences in conference hall 1 ", after receiving the verification request of the attribute to be verified, the manager of the user with verification authority, such as department A, verifies and audits the participants, conference time and conference place in the editing matter content, and feeds back the corresponding verification result. The positive result is that the user with the verification authority agrees to schedule the scheduled meeting, and the negative result is disagreement. In addition, the user with authority can check whether the attribute to be checked has sensitive information or not according to the actual meaning of the picture or the text in the editing matters or whether the attribute to be checked accords with laws and regulations, company regulations and the like.
And 104, responding to the verification result of verification passing, and editing the designated cells of the electronic form according to the editing matters.
By adopting the electronic form verification method, firstly, the electronic form responds to the editing operation of the user and intercepts editing matters generated when the user edits the appointed cells of the electronic form, namely, when the user edits the appointed cells, the content in the appointed cells is not immediately modified; and setting the editing matters as to-be-checked attributes of the designated cells, checking the to-be-checked attributes, and editing the designated cells of the electronic form according to the editing matters when the checking result is that the checking is passed. Therefore, the editing and modifying of the designated cells are determined when the verification passes through the verification by verifying the attribute to be verified with the editing matters as contents, and the accuracy of data modification of the designated cells in the electronic form is improved.
In one embodiment, as shown in fig. 2, the method further comprises:
In this embodiment, after receiving a verification result that the verification fed back from the user with the verification authority fails, the designated cells of the electronic form are kept unchanged. Further, first warning information which is not checked is generated, and the first warning information is displayed in the interactive interface to inform a user of the reason that the designated cell cannot be edited.
In one embodiment, after responding to the editing operation of the user, before intercepting editing matters generated when the user edits the designated cells of the electronic form, the method further comprises: the edit status of the specified cells in the electronic form is opened so that the user edits the specified cells.
Before the user executes the editing operation, the cells in the electronic table are all in a locked state, and after the command generated by the editing operation of the user is responded, the editing state of the designated cell corresponding to the editing operation of the user is opened, so that the user edits the designated cell to generate editing items.
In one embodiment, after responding to the editing operation of the user, before opening the editing state of the designated cells in the electronic table, the method further comprises: it is determined that the user has editing rights for the specified cell.
In the present embodiment, before opening the edit status of the electronic form, it is necessary to determine whether the user has the edit authority of the corresponding designated cell. The editing authority can be the authority for editing all cells (including the designated cells corresponding to the editing operation) in the whole electronic table; the editing authority may also be authority for editing all cells (including the designated cells corresponding to the editing operation) in the designated area in the electronic form, for example, the editing authority for all cells in the designated row or the designated column; the editing authority may be specific to the designated cell (i.e., the designated cell corresponding to the editing operation).
The manner of determining whether the user has editing rights may be: the identity information of the user, such as the user name, the identity identification number and other information for identifying the identity of the user, is obtained, the identity information of the user is matched with the authority configuration information of the designated cell, the authority configuration information is the set of the user identity information which is allowed to be edited by the designated cell, and when the matching is successful, the user is determined to have editing authority.
In one embodiment, after responding to the editing operation of the user, before opening the editing state of the designated cell in the electronic table, if it is determined that the user has no editing right on the designated cell, the method further comprises: the edit status of the specified cell in the spreadsheet is locked.
When the matching of the identity information of the user and the authority configuration information of the designated cell fails, namely, the user is determined to have no editing authority, the editing state of the designated cell in the electronic form is locked, so that the user cannot edit the designated cell, namely, editing items cannot be generated, and therefore, the electronic form can be prevented from being edited by an illegal (namely, unauthorized) user.
In addition, the method of judging whether the user has the editing authority can also be to set the password for the designated cell, whether the user has the editing authority for the designated cell is determined by judging whether the input password is correct, and the method of determining whether the user has the editing authority is not limited in the disclosure.
The editing state of the designated cell is locked in this embodiment, that is, the user is not allowed to edit the designated cell. Further, a second alarm message prompting the user not to have editing authority is generated while the editing state of the designated cell is locked, and the second alarm message is displayed in the interactive interface to inform the user of the reason that the designated cell cannot be edited.
In one embodiment, after intercepting the editing matters generated when the user edits the designated cells of the electronic form, the method further comprises: when the editing matters are determined to be not in accordance with the preset conditions, deleting the editing matters and generating first prompt information for prompting a user that the editing matters are not in accordance with the requirements.
Here, the preset condition may be: edit type, format of content, numerical range, etc. Wherein:
the edit type may include deletion, modification, replacement, or the like. Assuming that the preset editing type is modified and not deletable, if the editing type indicated by the editing item is deletable, determining that the preset condition is not met;
the format of the content may include: the type of content, such as text or pictures. Assuming that the type of the preset content is a picture, if the editing item indicates that the input content is a text, determining that the preset condition is not met;
the format of the content may also include: the data amount of the content, for example, the number of words. Assuming that the preset content is 100 characters, if the edit item indicates that the input content exceeds 100 characters, determining that the preset condition is not met;
the numerical range refers to a range of numerical values input by the unit cell, for example, 20-100, and if the edit item indicates that the input numerical value is 200, the preset condition is determined not to be met.
It should be noted that, the electronic form is generally created by a user, and the attribute of the electronic form and the attribute of each cell in the electronic form are different according to different user requirements, so the preset condition corresponding to each cell can be set according to the attribute of the cell and the attribute of the electronic form to which the cell belongs, which is not limited in the disclosure.
When the editing item does not accord with the preset condition, deleting the editing item and generating first prompt information, and displaying the first prompt information in the interactive interface so as to prompt the user to execute the editing operation again. The first prompt information can also indicate part or all of contents which do not meet the preset conditions in the editing matters, and can be used as a basis when the user executes the editing operation again.
In one embodiment, the editing state of the designated cells in the open electronic form, so that after the user edits the designated cells, further includes: the edit status of the designated cell is locked to other users.
When the electronic form receives the edit operation of a user on the appointed cell, only the edit state of the appointed cell is opened for the user, and the edit state of the appointed cell in the electronic form is locked for other users, so that the appointed cell in the electronic form can be prevented from receiving the edit operation of different users at the same time, and the accuracy of the edited content in the appointed cell is ensured.
Correspondingly, in response to the verification result of verification passing, after editing the designated cells of the electronic form according to the editing matters, the method further comprises: the edit status of the specified cell is unlocked for other users.
After the designated cell is modified according to the completion of the editing matters, the editing state of the designated cell in the electronic table can be unlocked for other users so as to continuously respond to the editing operation of the designated cell by other users.
In one embodiment, after intercepting the editing event generated when the user edits the designated cell of the electronic form, the method further comprises: a second hint information is generated that indicates that the edit item of the specified cell in the spreadsheet is being checked.
Because the user with the verification authority needs a certain time to verify and judge the editing matters as the to-be-verified attributes of the contents after receiving the verification request, in the verification process, the second prompt information indicating that the editing matters are being verified is displayed in the interactive interface to prompt the user that the editing matters are being verified and checked, and according to the prompt information, the user can know the verification progress of the unit cells in real time
According to an embodiment of the present disclosure, there is also provided a spreadsheet verification apparatus, as shown in fig. 3, including:
an interception unit 301 for intercepting editing matters generated when a user edits a designated cell of the electronic form in response to an editing operation of the user;
a conversion unit 302, configured to take the editing item as a to-be-verified attribute of the specified cell;
an obtaining unit 303, configured to obtain a verification result of the attribute to be verified of the specified cell;
and the execution unit 304 is used for editing the designated cells of the electronic table according to the editing matters in response to the verification result of verification.
In one embodiment, the executing unit 304 is further configured to keep the designated cells of the spreadsheet unchanged in response to the verification result that the verification fails.
In an embodiment, as shown in fig. 4, the interception unit 301 further includes a control subunit 3011:
the control subunit 3011 is configured to open an edit status of a specified cell in the electronic form to enable the user to edit the specified cell in response to an edit event generated when the user edits the specified cell of the electronic form after an edit operation by the user is intercepted.
In an embodiment, as shown in fig. 4, the interception unit 301 further includes a determination subunit 3012:
the determining subunit 3012 is configured to determine that the user has editing rights to the specified cell, in response to a user's editing operation before opening an editing state of the specified cell in the electronic form.
In an embodiment, the determining subunit 3012 is further configured to lock the edit status of the specified cells in the spreadsheet while determining that the user has no edit permission.
In an embodiment, as shown in fig. 4, the apparatus further includes an interaction unit 305:
after intercepting the editing matters generated when the user edits the designated cells of the electronic form, when it is determined that the editing matters do not meet the preset conditions, the executing unit 304 is further configured to delete the editing matters, and at the same time, the interaction unit 305 generates first prompting information for prompting the user that the editing matters do not meet the requirements.
In an embodiment, the control subunit 3011 is further configured to lock the edit status of the designated cell to other users after the designated cell is edited by the user by designating the edit status of the cell in the open electronic table; correspondingly, in response to the verification result that the verification passes, after editing the designated cells of the electronic form according to the editing matters, the control subunit 3011 is further configured to unlock the editing state of the designated cells for other users.
In an embodiment, after intercepting the editing event generated when the user edits the specified cell of the electronic form, the interaction unit 305 is further configured to generate a second hint information for indicating that the editing event of the specified cell in the electronic form is being checked.
According to embodiments of the present disclosure, the present disclosure also provides an electronic device and a readable storage medium.
Fig. 5 shows a schematic block diagram of an example electronic device 500 that may be used to implement embodiments of the present disclosure. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular telephones, smartphones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the disclosure described and/or claimed herein.
As shown in fig. 5, the apparatus 500 includes a computing unit 501 that can perform various suitable actions and processes according to a computer program stored in a Read Only Memory (ROM) 502 or a computer program loaded from a storage unit 508 into a Random Access Memory (RAM) 503. In the RAM 503, various programs and data required for the operation of the device 500 can also be stored. The computing unit 501, ROM 502, and RAM 503 are connected to each other by a bus 504. An input/output (I/O) interface 505 is also connected to bus 504.
Various components in the device 500 are connected to the I/O interface 505, including: an input unit 506 such as a keyboard, a mouse, etc.; an output unit 507 such as various types of displays, speakers, and the like; a storage unit 508 such as a magnetic disk, an optical disk, or the like; and a communication unit 509 such as a network card, modem, wireless communication transceiver, etc. The communication unit 509 allows the device 500 to exchange information/data with other devices via a computer network such as the internet and/or various telecommunication networks.
The computing unit 501 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of computing unit 501 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various computing units running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, etc. The computing unit 501 performs the various methods and processes described above, such as a spreadsheet verification method. For example, in some embodiments, the spreadsheet verification method may be implemented as a computer software program tangibly embodied on a machine-readable medium, such as storage unit 508. In some embodiments, part or all of the computer program may be loaded and/or installed onto the device 500 via the ROM 502 and/or the communication unit 509. When the computer program is loaded into RAM 503 and executed by computing unit 501, one or more steps of the spreadsheet verification method described above may be performed. Alternatively, in other embodiments, the computing unit 501 may be configured to perform the spreadsheet verification method in any other suitable manner (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuit systems, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems On Chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.
Program code for carrying out methods of the present disclosure may be written in any combination of one or more programming languages. These program code may be provided to a processor or controller of a general purpose computer, special purpose computer, or other programmable data processing apparatus such that the program code, when executed by the processor or controller, causes the functions/operations specified in the flowchart and/or block diagram to be implemented. The program code may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. The machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, 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 disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and pointing device (e.g., a mouse or trackball) by which a user can provide input to the computer. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), and the internet.
The computer system may include a client and a server. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server may be a cloud server, a server of a distributed system, or a server incorporating a blockchain.
It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps recited in the present disclosure may be performed in parallel or sequentially or in a different order, provided that the desired results of the technical solutions of the present disclosure are achieved, and are not limited herein.
Furthermore, the terms "first," "second," and the like, are used for descriptive purposes only and are not to be construed as indicating or implying a relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include at least one such feature. In the description of the present disclosure, the meaning of "a plurality" is two or more, unless explicitly defined otherwise.
The foregoing is merely specific embodiments of the disclosure, but the protection scope of the disclosure is not limited thereto, and any person skilled in the art can easily think about changes or substitutions within the technical scope of the disclosure, and it is intended to cover the scope of the disclosure. Therefore, the protection scope of the present disclosure shall be subject to the protection scope of the claims.
Claims (7)
1. A method for verifying a spreadsheet, comprising:
responding to editing operation of a user, and determining that the user has editing authority of a designated cell; opening the editing state of the designated cell in the electronic table so that the user edits the designated cell; locking the editing state of the designated cell for other users; intercepting editing matters generated when the user edits the designated cells of the electronic form;
setting the editing item as a to-be-checked attribute of the designated cell;
obtaining a verification result of the attribute to be verified of the designated cell;
responding to a verification result of verification passing, and editing the designated cells of the electronic table according to the editing matters; and unlocking the editing state of the designated cell for the other user.
2. The method according to claim 1, characterized in that the method further comprises:
and responding to a verification result that the verification is not passed, and keeping the designated cells of the electronic table unchanged.
3. The method of claim 1, wherein after intercepting the editing event generated when the user edits the designated cell of the electronic form, further comprising:
and deleting the editing matters and generating first prompt information for prompting a user that the editing matters do not meet the requirements when the editing matters are determined to not meet the preset conditions.
4. The method of claim 1, wherein after intercepting the editing event generated when the user edits the designated cell of the electronic form, the method further comprises:
generating a second prompt for indicating that the edit item of the specified cell in the electronic form is being checked.
5. A spreadsheet verification device, said device comprising:
an interception unit, configured to intercept editing items generated when a user edits a specified cell of a spreadsheet in response to an editing operation by the user;
the interception unit comprises a control subunit: the control subunit is used for responding to the editing operation of the user, and before intercepting editing matters generated when the user edits the designated cells of the electronic form, opening the editing state of the designated cells in the electronic form so as to enable the user to edit the designated cells; the control subunit is further configured to lock an edit status of a designated cell in the electronic form;
the interception unit further comprises a determination subunit: the determining subunit is used for determining that the user has editing authority for the designated cell after responding to the editing operation of the user and before opening the editing state of the designated cell in the electronic table;
the conversion unit is used for taking the editing item as the attribute to be verified of the designated cell;
the acquisition unit is used for acquiring a verification result of the attribute to be verified of the designated cell;
an execution unit for editing the designated cells of the electronic form according to the editing matters in response to the verification result of verification
The control subunit is further configured to unlock the edit status of the specified cell for other users.
6. An electronic device, comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein, the liquid crystal display device comprises a liquid crystal display device,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method of any one of claims 1-4.
7. A non-transitory computer readable storage medium storing computer instructions for causing the computer to perform the method of any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310081072.2A CN115879429B (en) | 2023-02-01 | 2023-02-01 | Electronic form verification method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310081072.2A CN115879429B (en) | 2023-02-01 | 2023-02-01 | Electronic form verification method and device, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115879429A CN115879429A (en) | 2023-03-31 |
| CN115879429B true CN115879429B (en) | 2023-06-27 |
Family
ID=85760895
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310081072.2A Active CN115879429B (en) | 2023-02-01 | 2023-02-01 | Electronic form verification method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115879429B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109597978A (en) * | 2018-11-02 | 2019-04-09 | 天津字节跳动科技有限公司 | Edit methods, device, storage medium and the electronic equipment of online electrical form |
| CN111966669A (en) * | 2020-06-29 | 2020-11-20 | 山东浪潮通软信息科技有限公司 | Report data verification method, equipment and medium |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109522533A (en) * | 2018-10-12 | 2019-03-26 | 平安科技（深圳）有限公司 | Table edit method, apparatus, equipment and medium based on web data |
| CN109815659A (en) * | 2018-12-15 | 2019-05-28 | 深圳壹账通智能科技有限公司 | Safety certifying method, device, electronic equipment and storage medium based on WEB project |
| CN110008455B (en) * | 2019-03-13 | 2024-05-03 | 平安科技（深圳）有限公司 | Table editing method, apparatus, computer device and storage medium |
| CN110825634A (en) * | 2019-11-04 | 2020-02-21 | 深圳前海微众银行股份有限公司 | Parameter quality checking method, device and equipment and computer readable storage medium |
| CN113688416A (en) * | 2020-05-18 | 2021-11-23 | 阿里巴巴集团控股有限公司 | Authority processing method and device |
| CN114997127A (en) * | 2022-06-15 | 2022-09-02 | 平安银行股份有限公司 | Financial data acquisition method, computer device and storage medium |
-
2023
- 2023-02-01 CN CN202310081072.2A patent/CN115879429B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109597978A (en) * | 2018-11-02 | 2019-04-09 | 天津字节跳动科技有限公司 | Edit methods, device, storage medium and the electronic equipment of online electrical form |
| CN111966669A (en) * | 2020-06-29 | 2020-11-20 | 山东浪潮通软信息科技有限公司 | Report data verification method, equipment and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115879429A (en) | 2023-03-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11075917B2 (en) | Tenant lockbox | |
| US10887338B2 (en) | Creating notes on lock screen | |
| EP0736827A2 (en) | Security administration for electronic data processing | |
| CN112764737B (en) | Intelligent low-code technology platform system | |
| CN109460400B (en) | System and method for establishing safety baseline library of power monitoring system | |
| CN112380533A (en) | Method for checking security baseline of computer terminal | |
| CN115688133A (en) | Data processing method, device, equipment and storage medium | |
| CN111274643A (en) | Three-dimensional intelligent design collaboration platform development method | |
| CN111178017A (en) | Method and device for generating flow chart, storage medium and electronic equipment | |
| CN115879429B (en) | Electronic form verification method and device, electronic equipment and storage medium | |
| CN111915186A (en) | Multi-source data management system for city infrastructure construction | |
| CN112464176B (en) | Authority management method and device, electronic equipment and storage medium | |
| CN114637672A (en) | Automatic data testing method and device, computer equipment and storage medium | |
| CN115774581A (en) | Method and related apparatus for executing robot feet | |
| CN111897883A (en) | Entity model construction method and device, electronic equipment and medium | |
| CN111985902B (en) | Cross-system information collaborative management method, device, equipment and storage medium | |
| CN117311675B (en) | Service configuration method and device related to distributed system and electronic equipment | |
| US20240119156A1 (en) | System and method for automated software development compliance verification and auditing | |
| CN115114670B (en) | File unlocking method and device based on external link, network disk and storage medium | |
| RU2783782C1 (en) | System and method for managing notifications | |
| CN111832072B (en) | Method and system for preventing illegal operation of log platform | |
| US20230033027A1 (en) | Workflow management via a communication platform | |
| CN115439104A (en) | Business auditing method, device, equipment and storage medium | |
| CN114219453A (en) | Task processing method and device, electronic equipment and storage medium | |
| CN117708848A (en) | Project management method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |