CN112784559A - Electronic form editing method and device and electronic equipment - Google Patents

Electronic form editing method and device and electronic equipment Download PDF

Info

Publication number
CN112784559A
CN112784559A CN202010162666.2A CN202010162666A CN112784559A CN 112784559 A CN112784559 A CN 112784559A CN 202010162666 A CN202010162666 A CN 202010162666A CN 112784559 A CN112784559 A CN 112784559A
Authority
CN
China
Prior art keywords
edited
user
table area
information
locking
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.)
Pending
Application number
CN202010162666.2A
Other languages
Chinese (zh)
Inventor
陈波
晁云曈
朱军行
陈嘉丰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Kingsoft Office Software Inc
Zhuhai Kingsoft Office Software Co Ltd
Original Assignee
Beijing Kingsoft Office Software Inc
Zhuhai Kingsoft Office Software Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Kingsoft Office Software Inc, Zhuhai Kingsoft Office Software Co Ltd filed Critical Beijing Kingsoft Office Software Inc
Priority to CN202010162666.2A priority Critical patent/CN112784559A/en
Publication of CN112784559A publication Critical patent/CN112784559A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/17Details of further file system functions
    • G06F16/176Support for shared access to files; File sharing support
    • G06F16/1767Concurrency control, e.g. optimistic or pessimistic approaches
    • G06F16/1774Locking methods, e.g. locking methods for file systems allowing shared and concurrent access to files

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The embodiment of the invention provides a method and a device for editing an electronic form and electronic equipment, wherein the method comprises the following steps: the method comprises the steps that locking information of a to-be-edited table area selected by a current user in an electronic table is obtained, wherein the locking information comprises state information which represents whether the to-be-edited table area is in a locking state or not and user information of the locking user when the to-be-edited table area is in the locking state; if the state information indicates that the table area to be edited is in a non-locking state, determining that the current user is allowed to edit the table area to be edited; if the state information shows that the table area to be edited is in a locked state, acquiring user information of a current user; determining whether the current user is allowed to edit the table area to be edited or not based on the comparison result of the user information of the locked user and the user information of the current user; the technical scheme provided by the embodiment of the invention can reduce the probability of falsely changing data of other people during multi-person collaborative editing.

Description

Electronic form editing method and device and electronic equipment
Technical Field
The present invention relates to the field of electronic document technologies, and in particular, to a method and an apparatus for editing a spreadsheet, and an electronic device.
Background
When a spreadsheet is edited by multiple persons in a collaborative manner, the multiple persons often edit in the same table area, and the content of the table area has the problems of data conflict and confusion.
For this reason, the existing solutions are: setting different table areas by an initiator aiming at different input personnel in advance; for example: the first person can only edit lines 1-10 and the second person can only edit lines 11-20.
However, the above method has a significant drawback: because the set area and authority are fixed, the initially set area may not be enough for the corresponding entry personnel to use as the entry data is more and more, and the corresponding table area needs to be set for the increased entry personnel as the entry personnel is more and more, so that the initiator needs to reset at intervals. Therefore, the above method is complicated and the efficiency is low.
Disclosure of Invention
An embodiment of the invention provides a method and a device for editing an electronic form and electronic equipment, and aims to solve the problems of complexity and low efficiency in editing the same form area by multiple people in the prior art. The specific technical scheme is as follows:
the embodiment of the invention provides an editing method of an electronic form, which comprises the following steps:
the method comprises the steps that locking information of a to-be-edited table area selected by a current user in an electronic table is obtained, wherein the locking information comprises state information which represents whether the to-be-edited table area is in a locking state or not and user information of a locking user when the to-be-edited table area is in the locking state, and the locking user is a user for locking the to-be-edited table area;
if the state information is non-locking state information which represents that the table area to be edited is in a non-locking state, determining that the current user is allowed to edit the table area to be edited;
if the state information is locking state information which represents that the table area to be edited is in a locking state, acquiring user information of the current user;
and determining whether to allow the current user to edit the table area to be edited based on a comparison result of the user information of the locked user and the user information of the current user.
Further, the determining whether to allow the current user to edit the table area to be edited based on the comparison result between the user information of the locked user and the user information of the current user includes:
if the user information of the locked user is inconsistent with the user information of the current user, determining that the current user is not allowed to edit the table area to be edited;
and if the user information of the locked user is consistent with the user information of the current user, determining that the current user is allowed to edit the table area to be edited.
Further, if the state information is non-lock state information indicating that the table area to be edited is in a non-lock state, determining that the current user is allowed to edit the table area to be edited includes:
if the state information is non-locking state information which represents that the table area to be edited is in a non-locking state, setting the state information as the locking state information, and setting user information of a locking user of the table area to be edited as the user information of the current user;
and determining that the current user is allowed to edit the table area to be edited.
Further, the setting the state information as the locking state information includes:
setting the state information as permanent locking state information which represents that the table area to be edited is in a permanent locking state;
the method further comprises the following steps:
and keeping the table area to be edited in a permanent locking state within a first preset time length after the current user stops editing the table area to be edited.
Further, the setting the state information as the locking state information includes:
setting the state information as temporary locking state information which represents that the table area to be edited is in a temporary locking state;
the method further comprises the following steps:
and when the time length for the current user to stop editing the table area to be edited reaches a second preset time length, converting the state of the table area to be edited into a non-locking state.
An embodiment of the present invention further provides an apparatus for editing an electronic form, including:
the electronic form editing device comprises a first obtaining unit, a second obtaining unit and a display unit, wherein the first obtaining unit is used for obtaining locking information of a to-be-edited form area selected by a current user in an electronic form, the locking information comprises state information indicating whether the to-be-edited form area is in a locking state or not and user information of a locking user when the to-be-edited form area is in the locking state, and the locking user is a user for locking the to-be-edited form area;
a first determining unit, configured to determine that the current user is allowed to edit the table area to be edited if the state information is non-lock state information indicating that the table area to be edited is in a non-lock state;
a second obtaining unit, configured to obtain user information of the current user if the state information is locking state information indicating that the table area to be edited is in a locking state;
a second determining unit, configured to determine whether to allow the current user to edit the table area to be edited based on a comparison result between the user information of the locked user and the user information of the current user.
Further, the second determining unit is specifically configured to determine that the current user is not allowed to edit the table area to be edited if the user information of the locked user is inconsistent with the user information of the current user; and if the user information of the locked user is consistent with the user information of the current user, determining that the current user is allowed to edit the table area to be edited.
Further, the first determining unit includes:
a setting subunit, configured to set, if the state information is non-locking state information indicating that the table area to be edited is in a non-locking state, the state information as the locking state information, and set user information of a locking user of the table area to be edited as user information of the current user;
and the determining subunit is used for determining that the current user is allowed to edit the table area to be edited.
Further, the setting subunit is specifically configured to, if the state information is non-lock state information indicating that the table area to be edited is in a non-lock state, set the state information as permanent lock state information indicating that the table area to be edited is in a permanent lock state, and set user information of a lock user of the table area to be edited as user information of the current user;
the setting subunit is further configured to keep the table area to be edited in a permanently locked state within a first preset duration after the current user stops editing the table area to be edited.
Further, the setting subunit is specifically configured to, if the state information is non-lock state information indicating that the table area to be edited is in a non-lock state, set the state information as temporary lock state information indicating that the table area to be edited is in a temporary lock state, and set user information of a lock user of the table area to be edited as user information of the current user;
the setting subunit is further configured to convert the state of the table area to be edited into a non-locked state when the time length for the current user to stop editing the table area to be edited reaches a second preset time length.
The embodiment of the invention also provides electronic equipment which comprises a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory complete mutual communication through the communication bus;
a memory for storing a computer program;
and the processor is used for realizing any one of the steps of the electronic form editing method when executing the program stored in the memory.
The embodiment of the present invention further provides a computer-readable storage medium, in which a computer program is stored, and when the computer program is executed by a processor, the steps of the method for editing the electronic form described above are implemented.
Embodiments of the present invention further provide a computer program product containing instructions, which when run on a computer, cause the computer to execute any one of the above methods for editing a spreadsheet.
The embodiment of the invention has the following beneficial effects:
the method, the device and the electronic equipment for editing the electronic form, provided by the embodiment of the invention, can aim at the form area to be edited selected by the current user in the electronic form; acquiring locking information of the table area to be edited, wherein the locking information of the table area to be edited comprises state information which represents whether the table area to be edited is in a locking state or not and user information of a locking user when the table area to be edited is in the locking state, and the locking user is a user for locking the table area to be edited; if the state information is non-locking state information which represents that the table area to be edited is in a non-locking state, determining that the current user is allowed to edit the table area to be edited; if the state information is locking state information which represents that the table area to be edited is in a locking state, acquiring user information of a current user, and determining whether the current user is allowed to edit the table area to be edited or not based on a comparison result of the user information of the locking user and the user information of the current user; by adopting the technical scheme provided by the embodiment of the invention, if the table area to be edited is locked by other users, the current user is not allowed to edit the table area to be edited, the probability of falsely changing data of other users can be reduced when multiple users edit the table area in a cooperative manner, the phenomena of data conflict and disorder of the content of the table area caused by editing the table area by multiple users are reduced to a certain extent, the setting by an initiator is not needed, the use requirement of the input personnel can be met, and the cooperation efficiency is improved.
Of course, not all of the advantages described above need to be achieved at the same time in the practice of any one product or method of the invention.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of an editing method of an electronic form according to an embodiment of the present invention;
FIG. 2 is a flowchart of another method for editing a spreadsheet according to an embodiment of the present invention;
FIG. 3 is a schematic structural diagram of an apparatus for editing a spreadsheet according to an embodiment of the present invention;
fig. 4 is a structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The embodiment of the invention provides an editing method of a spreadsheet, which specifically comprises the following steps as shown in fig. 1:
step 101, acquiring locking information of a to-be-edited form area selected by a current user in an electronic form, wherein the locking information includes state information indicating whether the to-be-edited form area is in a locking state and user information of a locking user when the to-be-edited form area is in the locking state, and the locking user is a user for locking the to-be-edited form area.
Step 102, judging whether the state information indicates that the table area to be edited is in a locked state, if so, entering step 103, and if not, entering step 105.
And 103, acquiring the user information of the current user.
And step 104, determining whether to allow the current user to edit the table area to be edited based on the comparison result of the user information of the locked user and the user information of the current user.
Step 105, determining to allow the current user to edit the table area to be edited.
By adopting the method for editing the electronic form, provided by the embodiment of the invention, if the form area to be edited is locked by other users, the current user is not allowed to edit the form area to be edited, so that the probability of mistakenly changing data of other users during multi-user collaborative editing can be reduced, the phenomena of data conflict and disorder of the content of the form area caused by editing in the same form area by multiple users are favorably reduced, the redeployment of an initiator is not needed, the use requirements of entry personnel can be met, and the collaboration efficiency is improved.
The above-described method provided by the embodiments of the present invention is described in detail below.
An embodiment of the present invention further provides a method for editing a spreadsheet, as shown in fig. 2, the method specifically includes the following steps:
step 201, aiming at a table area to be edited selected by a current user in the electronic table, obtaining locking information of the table area to be edited.
Specifically, the locking information may include state information indicating whether the table area to be edited is in a locked state, and user information of a locking user when the table area to be edited is in the locked state, where the locking user is a user who locks the table area to be edited, and the user information may be a nickname of the user, or may be other information that can mark the user, and this embodiment of the application is not limited herein.
Further, the table area to be edited is at least one of a cell, a row and a column; when the table area to be edited is a cell and the current user selects the cell in the electronic table, the cell is considered to be the table area to be edited selected by the current user; when the table area to be edited is a row, the current user selects a cell in the electronic table, and then the row where the cell is located is considered as the table area to be edited selected by the current user, and when the table area to be edited is a column, the current user selects the cell in the electronic table, and then the column where the cell is located is considered as the table area to be edited selected by the current user.
Step 202, judging whether the state information indicates that the table area to be edited is in a locked state; if yes, go to step 203; if not, step 205 is entered.
That is, if the state information is the lock state information indicating that the table area to be edited is in the lock state, step 203 is entered; if the status information is the non-lock status information indicating that the table area to be edited is in the non-lock status, step 205 is entered.
Step 203, acquiring the user information of the current user.
Specifically, if the state information is lock state information indicating that the table area to be edited is in a lock state, user information of the current user is acquired.
And step 204, determining whether to allow the current user to edit the table area to be edited or not based on the comparison result of the user information of the locked user and the user information of the current user.
Specifically, if the user information of the locked user is inconsistent with the user information of the current user, determining that the current user is not allowed to edit the table area to be edited; and if the user information of the locked user is consistent with the user information of the current user, determining that the current user is allowed to edit the table area to be edited.
Step 205, acquiring the user information of the current user.
Specifically, if the state information is non-lock state information indicating that the table area to be edited is in a non-lock state, the user information of the current user is acquired.
Step 206, the status information is set as locked status information.
That is, the state of the table area to be edited is set to the lock state.
The above steps 205 and 206 are not in strict sequence, and may also be executed simultaneously.
In one embodiment, the state information is set as permanent locking state information indicating that the table area to be edited is in a permanent locking state; and keeping the table area to be edited in a permanent locking state within a first preset time length after the current user stops editing the table area to be edited.
The size of the first preset duration can be adjusted according to actual use requirements, and the embodiment of the application is not limited herein; for example: the first preset time period may be permanent or 1 hour.
In another embodiment, the state information is set as temporary locking state information indicating that the table area to be edited is in a temporary locking state; and when the time length of the current user for stopping editing the table area to be edited reaches a second preset time length, converting the state of the table area to be edited into a non-locking state.
The size of the second preset duration can be adjusted according to actual use requirements, and the embodiment of the application is not limited herein; for example: the second preset time period may be 0 minute or 5 minutes, and when the second preset time period is set to 0, it may be understood that, when the current user stops editing the table area to be edited, the state of the table area to be edited is converted into the non-locked state.
Step 207, setting the user information of the locking user of the table area to be edited as the user information of the current user.
That is to say, the table area to be edited is locked by the current user, that is, the current user is the locking user of the table area to be edited, so that other users can be prevented from editing the table area to be edited.
In step 208, it is determined that the current user is allowed to edit the table area to be edited.
Specifically, it may be directly determined that the current user is allowed to edit the table area to be edited, or it may be determined that the current user is allowed to edit the table area to be edited based on a comparison result between the user information of the current user and the user information of the locked user of the table area to be edited. It can be understood by those skilled in the art that the current user is the locking user of the table area to be edited, and then the user information of the current user is consistent with the user information of the locking user of the table area to be edited, so that the current user is determined to be allowed to edit the table area to be edited.
Corresponding to the above method for editing a spreadsheet provided by the embodiment of the present invention, an embodiment of the present invention further provides an apparatus for editing a spreadsheet, as shown in fig. 3, fig. 3 is a schematic structural diagram of an apparatus for editing a spreadsheet provided by the embodiment of the present invention, and specifically includes:
a first obtaining unit 301, configured to obtain, for a table area to be edited selected by a current user in an electronic table, locking information of the table area to be edited, where the locking information includes state information indicating whether the table area to be edited is in a locked state and user information of a locking user when the table area to be edited is in a locked state, where the locking user is a user who locks the table area to be edited.
A first determining unit 302, configured to determine that the current user is allowed to edit the table area to be edited if the state information is non-locking state information indicating that the table area to be edited is in a non-locking state.
A second obtaining unit 303, configured to obtain the user information of the current user if the state information is locking state information indicating that the table area to be edited is in a locking state.
A second determining unit 304, configured to determine whether to allow the current user to edit the table area to be edited based on a comparison result between the user information of the locked user and the user information of the current user.
Further, the second determining unit 304 is specifically configured to determine that the current user is not allowed to edit the table area to be edited if the user information of the locked user is inconsistent with the user information of the current user; and if the user information of the locked user is consistent with the user information of the current user, determining that the current user is allowed to edit the table area to be edited.
Further, the first determining unit 302 includes:
and the setting subunit is configured to set the state information as the locked state information and set the user information of the locked user in the table area to be edited as the user information of the current user, if the state information is non-locked state information indicating that the table area to be edited is in a non-locked state.
And the determining subunit is used for determining that the current user is allowed to edit the table area to be edited.
Further, the setting subunit is specifically configured to, if the state information is non-lock state information indicating that the table area to be edited is in a non-lock state, set the state information as permanent lock state information indicating that the table area to be edited is in a permanent lock state, and set user information of a lock user of the table area to be edited as the user information of the current user.
The setting subunit is further configured to keep the table area to be edited in a permanently locked state within a first preset duration after the current user stops editing the table area to be edited.
Further, the setting subunit is specifically configured to, if the state information is non-lock state information indicating that the table area to be edited is in a non-lock state, set the state information as temporary lock state information indicating that the table area to be edited is in a temporary lock state, and set user information of a lock user of the table area to be edited as the user information of the current user.
The setting subunit is further configured to convert the state of the table area to be edited into a non-locked state when the time length for the current user to stop editing the table area to be edited reaches a second preset time length.
An embodiment of the present invention further provides an electronic device, as shown in fig. 4, including a processor 401, a communication interface 402, a memory 403, and a communication bus 404, where the processor 401, the communication interface 402, and the memory 403 complete mutual communication through the communication bus 404,
a memory 403 for storing a computer program;
the processor 401 is configured to implement the steps of any of the above-described spreadsheet editing methods when executing the program stored in the memory 403.
The communication bus mentioned in the electronic device may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The communication bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown, but this does not mean that there is only one bus or one type of bus.
The communication interface is used for communication between the electronic equipment and other equipment.
The Memory may include a Random Access Memory (RAM) or a Non-Volatile Memory (NVM), such as at least one disk Memory. Optionally, the memory may also be at least one memory device located remotely from the processor.
The Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; but also Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components.
In another embodiment of the present invention, a computer-readable storage medium is further provided, in which a computer program is stored, and the computer program, when executed by a processor, implements the steps of any of the above methods for editing a spreadsheet.
In yet another embodiment of the present invention, there is also provided a computer program product containing instructions which, when run on a computer, cause the computer to perform the method for editing any of the spreadsheets in the above embodiments.
In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, cause the processes or functions described in accordance with the embodiments of the invention to occur, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored in a computer readable storage medium or transmitted from one computer readable storage medium to another, for example, from one website site, computer, server, or data center to another website site, computer, server, or data center via wired (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device, such as a server, a data center, etc., that incorporates one or more of the available media. The usable medium may be a magnetic medium (e.g., floppy Disk, hard Disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., Solid State Disk (SSD)), among others.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
All the embodiments in the present specification are described in a related manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, as for the apparatus, the electronic device, the computer-readable storage medium and the computer program product, since they are substantially similar to the method embodiments, the description is relatively simple, and in relation to the description, reference may be made to some parts of the description of the method embodiments.
The above description is only for the preferred embodiment of the present invention, and is not intended to limit the scope of the present invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention shall fall within the protection scope of the present invention.

Claims (12)

1. A method for editing a spreadsheet, comprising:
the method comprises the steps that locking information of a to-be-edited table area selected by a current user in an electronic table is obtained, wherein the locking information comprises state information which represents whether the to-be-edited table area is in a locking state or not and user information of a locking user when the to-be-edited table area is in the locking state, and the locking user is a user for locking the to-be-edited table area;
if the state information is non-locking state information which represents that the table area to be edited is in a non-locking state, determining that the current user is allowed to edit the table area to be edited;
if the state information is locking state information which represents that the table area to be edited is in a locking state, acquiring user information of the current user;
and determining whether to allow the current user to edit the table area to be edited based on a comparison result of the user information of the locked user and the user information of the current user.
2. The method according to claim 1, wherein the determining whether to allow the current user to edit the table area to be edited based on the comparison result between the user information of the locked user and the user information of the current user comprises:
if the user information of the locked user is inconsistent with the user information of the current user, determining that the current user is not allowed to edit the table area to be edited;
and if the user information of the locked user is consistent with the user information of the current user, determining that the current user is allowed to edit the table area to be edited.
3. The method according to claim 1, wherein the determining that the current user is allowed to edit the table area to be edited if the status information is non-lock status information indicating that the table area to be edited is in a non-lock status comprises:
if the state information is non-locking state information which represents that the table area to be edited is in a non-locking state, setting the state information as the locking state information, and setting user information of a locking user of the table area to be edited as the user information of the current user;
and determining that the current user is allowed to edit the table area to be edited.
4. The method of claim 3, wherein the setting the status information to the locked status information comprises:
setting the state information as permanent locking state information which represents that the table area to be edited is in a permanent locking state;
the method further comprises the following steps:
and keeping the table area to be edited in a permanent locking state within a first preset time length after the current user stops editing the table area to be edited.
5. The method of claim 3, wherein the setting the status information to the locked status information comprises:
setting the state information as temporary locking state information which represents that the table area to be edited is in a temporary locking state;
the method further comprises the following steps:
and when the time length for the current user to stop editing the table area to be edited reaches a second preset time length, converting the state of the table area to be edited into a non-locking state.
6. An apparatus for editing a spreadsheet, comprising:
the electronic form editing device comprises a first obtaining unit, a second obtaining unit and a display unit, wherein the first obtaining unit is used for obtaining locking information of a to-be-edited form area selected by a current user in an electronic form, the locking information comprises state information indicating whether the to-be-edited form area is in a locking state or not and user information of a locking user when the to-be-edited form area is in the locking state, and the locking user is a user for locking the to-be-edited form area;
a first determining unit, configured to determine that the current user is allowed to edit the table area to be edited if the state information is non-lock state information indicating that the table area to be edited is in a non-lock state;
a second obtaining unit, configured to obtain user information of the current user if the state information is locking state information indicating that the table area to be edited is in a locking state;
a second determining unit, configured to determine whether to allow the current user to edit the table area to be edited based on a comparison result between the user information of the locked user and the user information of the current user.
7. The apparatus according to claim 6, wherein the second determining unit is specifically configured to determine that the current user is not allowed to edit the table area to be edited if the user information of the locked user is inconsistent with the user information of the current user; and if the user information of the locked user is consistent with the user information of the current user, determining that the current user is allowed to edit the table area to be edited.
8. The apparatus of claim 6, wherein the first determining unit comprises:
a setting subunit, configured to set, if the state information is non-locking state information indicating that the table area to be edited is in a non-locking state, the state information as the locking state information, and set user information of a locking user of the table area to be edited as user information of the current user;
and the determining subunit is used for determining that the current user is allowed to edit the table area to be edited.
9. The apparatus according to claim 8, wherein the setting subunit is configured to, if the status information is non-lock status information indicating that the table area to be edited is in a non-lock status, set the status information as permanent lock status information indicating that the table area to be edited is in a permanent lock status, and set user information of a lock user of the table area to be edited as user information of the current user;
the setting subunit is further configured to keep the table area to be edited in a permanently locked state within a first preset duration after the current user stops editing the table area to be edited.
10. The apparatus according to claim 8, wherein the setting subunit is configured to, if the status information is non-lock status information indicating that the table area to be edited is in a non-lock status, set the status information as temporary lock status information indicating that the table area to be edited is in a temporary lock status, and set user information of a lock user of the table area to be edited as user information of the current user;
the setting subunit is further configured to convert the state of the table area to be edited into a non-locked state when the time length for the current user to stop editing the table area to be edited reaches a second preset time length.
11. An electronic device is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor and the communication interface are used for realizing mutual communication by the memory through the communication bus;
a memory for storing a computer program;
a processor for implementing the method steps of any one of claims 1 to 5 when executing a program stored in the memory.
12. A computer-readable storage medium, characterized in that a computer program is stored in the computer-readable storage medium, which computer program, when being executed by a processor, carries out the method steps of any one of the claims 1-5.
CN202010162666.2A 2020-03-10 2020-03-10 Electronic form editing method and device and electronic equipment Pending CN112784559A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010162666.2A CN112784559A (en) 2020-03-10 2020-03-10 Electronic form editing method and device and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010162666.2A CN112784559A (en) 2020-03-10 2020-03-10 Electronic form editing method and device and electronic equipment

Publications (1)

Publication Number Publication Date
CN112784559A true CN112784559A (en) 2021-05-11

Family

ID=75749991

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010162666.2A Pending CN112784559A (en) 2020-03-10 2020-03-10 Electronic form editing method and device and electronic equipment

Country Status (1)

Country Link
CN (1) CN112784559A (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030117447A1 (en) * 2001-12-21 2003-06-26 Mujica P. Gayle Individually locked cells on a spreadsheet
CN105468769A (en) * 2015-12-08 2016-04-06 国网浙江省电力公司宁波供电公司 Editing method and system of electric power telecommunication geographic information
CN105531694A (en) * 2013-06-15 2016-04-27 微软技术许可有限责任公司 Showing presence of multiple authors in a spreadsheet
US20160321215A1 (en) * 2015-04-28 2016-11-03 Workiva Inc. Footnote formatting and layout of multi-section documents
CN110008455A (en) * 2019-03-13 2019-07-12 平安科技(深圳)有限公司 Table edit method, apparatus, computer equipment and storage medium

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030117447A1 (en) * 2001-12-21 2003-06-26 Mujica P. Gayle Individually locked cells on a spreadsheet
CN105531694A (en) * 2013-06-15 2016-04-27 微软技术许可有限责任公司 Showing presence of multiple authors in a spreadsheet
US20160321215A1 (en) * 2015-04-28 2016-11-03 Workiva Inc. Footnote formatting and layout of multi-section documents
CN105468769A (en) * 2015-12-08 2016-04-06 国网浙江省电力公司宁波供电公司 Editing method and system of electric power telecommunication geographic information
CN110008455A (en) * 2019-03-13 2019-07-12 平安科技(深圳)有限公司 Table edit method, apparatus, computer equipment and storage medium

Similar Documents

Publication Publication Date Title
JP5925373B1 (en) Communication support system
CN106161397A (en) There is the electronic installation of Anti-addiction function, Anti-addiction management system and method
WO2018176835A1 (en) Barrage management method and apparatus, memory and server
EP3547611A1 (en) Communication system, communication method, and information processing apparatus
US20150052201A1 (en) Updating time-related information in post to make it more relevant for the requester on subsequent retrieval of post
WO2016184092A1 (en) Terminal operation method and apparatus
CN113705179A (en) Document collaborative editing method and device and electronic equipment
CN107451464B (en) Prompt message output method and device
CN108184131B (en) Broadcasting reminding method and device and readable storage medium
JP5325919B2 (en) Authentication apparatus and method
CN114417282A (en) User permission determining method and device, electronic equipment and storage medium
TWI791820B (en) User authorization method, device, computer device and storage media in offline mode
CN111553130A (en) Chapter title style conversion method and device, electronic equipment and storage medium
CN110673790A (en) Hard disk control method and device, electronic equipment and storage medium
CN107229875A (en) Terminal method for secret protection and system
CN112784559A (en) Electronic form editing method and device and electronic equipment
CN111475078B (en) Method, device and equipment for checking screen locking message and computer readable medium
CN109981873B (en) Address book permission opening method and device and electronic equipment
JP5981663B2 (en) Information processing apparatus, information processing method, program, storage medium, and password input apparatus
CN114186966A (en) Document approval method, system, device and computer readable storage medium
CN112631808B (en) Data synchronization method, device, electronic equipment and storage medium
CN114613046A (en) User permission configuration method, device, equipment and medium for cell access control
JP2015188160A (en) Information processing apparatus, image reading system, and program
EP3862900A1 (en) Module-based dynamic passwords
CN112256820B (en) Document positioning 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