A table data processing method and device, electronic equipment and storage medium

Abstract

The present application relates to a kind of table data processing method, device, electronic equipment and storage medium, the method comprises: when receiving the editing operation of operator to table, obtain the editing region corresponding to editing operation, at least one cell is included in editing region;In the case where the cell in editing region is not edited, the editing content corresponding to editing operation is written in editing region, and editing content is shown in editing region;The cell in editing region is set to have been protected, and grant the editing authority of operator to editing region.This application embodiment can realize for the editing region that has not been edited, it is automatically set to be protected after writing editing content, and grant editing authority, realize that only the effect that the person can modify the content that he fills in, other people cannot edit, avoid mutual modification to cover editing content, improve the security of table content, improve the accuracy of information collection, improve data collection efficiency.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of computers, and in particular to a table data processing method and device, electronic equipment and storage medium. BACKGROUND

[0002] With the development of the times, more and more people choose to use collaborative table tools when collecting information from multiple people, such as filling in epidemic information reporting and collecting student information.

[0003] However, in this process, the content filled in by the user A is inevitably modified and covered by the user B, resulting in unreliable collected information and reducing the efficiency of data collection to some extent. SUMMARY

[0004] To solve the above technical problems or at least partially solve the above technical problems, the present application provides a table data processing method and device, electronic equipment and storage medium.

[0005] In a first aspect, the present application provides a table data processing method, comprising:

[0006] When receiving an editing operation of an operator on a table, an editing area corresponding to the editing operation is obtained, and the editing area includes at least one cell;

[0007] In the case where none of the cells in the editing area has been edited, the editing content corresponding to the editing operation is written into the editing area, and the editing content is displayed in the editing area;

[0008] The cells in the editing area are set as protected, and the operator is granted editing permission of the editing area.

[0009] In a possible embodiment of the present application, after obtaining the editing area corresponding to the editing operation, the method further comprises:

[0010] In the case where at least one cell in the editing area has been edited by other operators, the writing of the editing content corresponding to the editing operation in the editing area is limited.

[0011] In a possible embodiment of the present application, after obtaining the editing area corresponding to the editing operation, the method further comprises:

[0012] In the case where none of the cells in the editing area has been edited by other operators, the editing content corresponding to the editing operation is written into the editing area, and the editing content is displayed in the editing area;

[0013] set a cell in the editing region as having been protected, and grant the operator editing authority over the editing region.

[0014] In a possible embodiment of the present application, after the editing region corresponding to the editing operation is acquired, the method further includes:

[0015] In a case where a first cell in the editing region is set as having been protected, it is determined that the first cell has been edited, the first cell being any cell in the editing region.

[0016] In a case where it is determined that the first operator has editing authority over a first cell in the editing region, it is determined that the first operator has edited the first cell.

[0017] In a possible embodiment of the present application, the method further includes:

[0018] In a case where an editing operation of the editing region by another operator is received, an operator who is earlier in a submission time is granted editing authority over the editing region.

[0019] In a possible embodiment of the present application, setting a cell in the editing region as having been protected, and granting the operator editing authority over the editing region includes:

[0020] Setting a protection identifier for at least one cell in the editing region to set a cell in the editing region as having been protected;

[0021] Setting an operator identifier for at least one cell in the editing region according to an identifier of the operator to grant the operator editing authority over the editing region.

[0022] In a possible embodiment of the present application, setting an operator identifier for at least one cell in the editing region according to an identifier of the operator includes:

[0023] In a case where an editing operation of the editing region by another operator is received, setting the operator identifier according to an identifier of an operator who is earlier in a submission time to grant the operator who is earlier in the submission time editing authority over the editing region.

[0024] In a possible embodiment of the present application, the method further includes:

[0025] In a case where a first cell in the editing region is set with a protection identifier, it is determined that the first cell is set as having been protected, the first cell being any cell in the editing region.

[0026] In a case where a first cell in the editing region is provided with an operator identifier of a first operator, it is determined that the first operator has an editing right of the first cell.

[0027] In a second aspect, the embodiments of the present application further provide a table data processing method, comprising:

[0028] When receiving an editing operation of an operator on a table, an editing region corresponding to the editing operation is acquired, and the editing region comprises at least one cell;

[0029] A protection identifier of at least one cell in the editing region is acquired.

[0030] Based on the protection identifier of at least one cell in the editing region, an editing right of the editing operation on the editing region is authenticated, and an authentication result is obtained.

[0031] Based on the authentication result, a write of the editing operation on the editing region is controlled.

[0032] In a possible embodiment of the present application, based on the authentication result, the write of the editing operation on the editing region is controlled, comprising:

[0033] In a case where the authentication result is that the editing region is unprotected, editing content corresponding to the editing operation is written into the editing region, and the editing content is displayed in the editing region;

[0034] A cell in the editing region is set as having been protected, and the operator is granted an editing right of the editing region.

[0035] In a possible embodiment of the present application, the cell in the editing region is set as having been protected, and the operator is granted the editing right of the editing region, comprising:

[0036] A protection identifier is set for at least one cell in the editing region.

[0037] An operator identifier is set for at least one cell in the editing region according to an identifier of the operator.

[0038] In a possible embodiment of the present application, the operator identifier is set for at least one cell in the editing region according to the identifier of the operator, comprising:

[0039] In a case where an editing operation of another operator on the editing region is received, the operator identifier is set according to an identifier of an operator whose submission time is earlier.

[0040] In a possible embodiment of the present application, the writing of the editing operation into the editing area is controlled based on the authentication result, and the method further includes:

[0041] In a case where the authentication result is that the editing area is protected and the operator has editing permission, the editing content corresponding to the editing operation is written into the editing area, and the editing content is displayed in the editing area.

[0042] A cell in the editing area is set as protected, and the operator is granted editing permission for the editing area.

[0043] In a possible embodiment of the present application, the writing of the editing operation into the editing area is controlled based on the authentication result, and the method further includes:

[0044] In a case where the authentication result is no editing permission, the writing of the editing content corresponding to the editing operation into the editing area is limited.

[0045] In a possible embodiment of the present application, the editing permission of the editing operation in the editing area is authenticated based on the protection identifier of at least one cell in the editing area, and an authentication result is obtained, and the method includes:

[0046] In a case where the protection identifier of at least one cell in the editing area is determined to indicate that the editing area is unprotected, the authentication result is determined to be that the editing area is unprotected.

[0047] In a possible embodiment of the present application, the editing permission of the editing operation in the editing area is authenticated based on the protection identifier of at least one cell in the editing area, and an authentication result is obtained, and the method includes:

[0048] In a case where the protection identifier of at least one cell in the editing area is determined to indicate that the editing area has been edited by itself, the authentication result is determined to be that the editing area is protected and has editing permission.

[0049] In a possible embodiment of the present application, the editing permission of the editing operation in the editing area is authenticated based on the protection identifier of at least one cell in the editing area, and an authentication result is obtained, and the method includes:

[0050] In a case where the protection identifier of at least one cell in the editing area is determined to indicate that the editing area has been edited by another operator, the authentication result is determined to be no editing permission.

[0051] In a third aspect, the embodiments of the present application further provide a table data processing apparatus, including:

[0052] The first obtaining module is configured to obtain an editing region corresponding to the editing operation of the operator when receiving the editing operation of the operator on the table, the editing region including at least one cell;

[0053] The first writing module is configured to write the editing content corresponding to the editing operation into the editing region and display the editing content in the editing region when none of the cells in the editing region is edited.

[0054] The setting module is configured to set the cells in the editing region as having been protected and grant the editing permission of the editing region to the operator.

[0055] In a possible embodiment of the present application, the apparatus further includes:

[0056] The limiting writing module is configured to limit writing the editing content corresponding to the editing operation into the editing region when at least one cell in the editing region is edited by another operator.

[0057] In a possible embodiment of the present application, the apparatus further includes:

[0058] The writing and displaying module is configured to write the editing content corresponding to the editing operation into the editing region and display the editing content in the editing region when none of the cells in the editing region is edited by another operator.

[0059] The setting and granting module is configured to set the cells in the editing region as having been protected and grant the editing permission of the editing region to the operator.

[0060] In a possible embodiment of the present application, the apparatus further includes:

[0061] The first determining module is configured to determine that a first cell in the editing region is edited when the first cell is set as having been protected, the first cell being any cell in the editing region.

[0062] The second determining module is configured to determine that a first operator edits a first cell in the editing region when it is determined that the first operator has the editing permission of the first cell.

[0063] In a possible embodiment of the present application, the apparatus further includes:

[0064] The permission granting module is configured to grant the editing permission of the editing region to an operator who is earlier in time than another operator when receiving the editing operation of the another operator on the editing region.

[0065] In a possible embodiment of the present application, the setting module comprises:

[0066] The first setting unit is configured to set a protection identifier for at least one of the cells in the editing area, so as to set the cells in the editing area as protected.

[0067] The second setting unit is configured to set an operator identifier for at least one of the cells in the editing area according to the identifier of the operator, so as to grant the operator the editing authority of the editing area.

[0068] In a possible embodiment of the present application, the second setting unit is further configured to:

[0069] In a case where an editing operation of the editing area by another operator is received, the operator identifier is set according to the identifier of the operator who submits earlier, so as to grant the operator who submits earlier the editing authority of the editing area.

[0070] In a possible embodiment of the present application, the apparatus further comprises:

[0071] The third determining module is configured to determine that a first cell in the editing area is set as protected in a case where the first cell is set with a protection identifier, wherein the first cell is any cell in the editing area.

[0072] The fourth determining module is configured to determine that a first operator has the editing authority of a first cell in the editing area in a case where the first cell is set with the operator identifier of the first operator.

[0073] In a fourth aspect, the embodiments of the present application further provide a table data processing apparatus, comprising:

[0074] The second obtaining module is configured to obtain an editing area corresponding to an editing operation of a table by an operator when the editing operation is received, wherein the editing area comprises at least one cell.

[0075] The third obtaining module is configured to obtain a protection identifier of at least one cell in the editing area.

[0076] The authentication module is configured to authenticate the editing authority of the editing operation in the editing area based on the protection identifier of at least one cell in the editing area, to obtain an authentication result.

[0077] The control module is configured to control the writing of the editing operation to the editing area based on the authentication result.

[0078] In a possible embodiment of the present application, the control module comprises:

[0079] a first writing unit, configured to write, in a case where the authentication result is that the editing region is unprotected, editing content corresponding to the editing operation into the editing region, and display the editing content in the editing region;

[0080] a second setting unit, configured to set a cell in the editing region as having been protected, and grant the operator editing permission for the editing region.

[0081] In a possible embodiment of the present application, the second setting unit comprises:

[0082] a first setting sub-unit, configured to set a protection identifier for at least one cell in the editing region;

[0083] a second setting sub-unit, configured to set an operator identifier for at least one cell in the editing region according to the identifier of the operator.

[0084] In a possible embodiment of the present application, the second setting sub-unit is further configured to:

[0085] In a case where an editing operation of another operator for the editing region is received, the operator identifier is set according to the identifier of the operator whose submission time is earlier.

[0086] In a possible embodiment of the present application, the control module comprises:

[0087] a second writing unit, configured to write, in a case where the authentication result is that the editing region is protected and the operator has editing permission, editing content corresponding to the editing operation into the editing region, and display the editing content in the editing region;

[0088] a setting granting unit, configured to set a cell in the editing region as having been protected, and grant the operator editing permission for the editing region.

[0089] In a possible embodiment of the present application, the control module comprises:

[0090] a restriction writing unit, configured to restrict writing, in a case where the authentication result is no editing permission, editing content corresponding to the editing operation into the editing region.

[0091] In a possible embodiment of the present application, the authentication module comprises:

[0092] a first determining unit, configured to determine, in a case where it is determined based on the protection identifier of at least one cell in the editing region that the editing region is unprotected, that the authentication result is that the editing region is unprotected.

[0093] In a possible embodiment of the present application, the authentication module comprises:

[0094] The second determining unit is configured to determine that the authentication result is that the editing region is protected and has editing permission when it is determined based on the protection identifier of at least one cell in the editing region that the editing region has been edited by itself.

[0095] In a possible embodiment of the present application, the authentication module comprises:

[0096] The third determining unit is configured to determine that the authentication result is no editing permission when it is determined based on the protection identifier of at least one cell in the editing region that the editing region has been edited by another operator.

[0097] In a fifth aspect, the present application provides an electronic device, comprising 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;

[0098] The memory is configured to store a computer program.

[0099] The processor is configured to execute the program stored on the memory, and implement the table data processing method of any one of the first aspect or the table data processing method of any one of the second aspect.

[0100] In a sixth aspect, the present application provides a computer readable storage medium, wherein the computer readable storage medium stores a table data processing method program, and the table data processing method program is executed by a processor to implement the steps of the table data processing method of any one of the first aspect or the table data processing method of any one of the second aspect.

[0101] Compared with the prior art, the above technical solution provided by the embodiments of the present application has the following advantages:

[0102] The embodiments of the present application can write the editing content corresponding to the editing operation into the editing region in the case that it is determined that all the cells in the editing region have not been edited, display the editing content in the editing region, set the cells in the editing region as having been protected, and grant the operator the editing permission of the editing region, thereby realizing that the editing region which has not been edited is automatically set as protected and granted the editing permission after the editing content is written, achieving the effect that only the person who fills in the content can modify the filled content, and other people cannot edit, avoiding the case that the written content is modified by other people when multiple operators collaboratively edit the table, improving the security of the table content, improving the accuracy of information collection, and improving the data collection efficiency. BRIEF DESCRIPTION OF DRAWINGS

[0103] The accompanying drawings, which are incorporated herein and constitute part of this specification, illustrate embodiments consistent with the application and serve to explain the principles of the application.

[0104] In order to more clearly illustrate the technical solutions of the embodiments of the present application or the prior art, the accompanying drawings needed to be used in the embodiments or prior art description will be briefly introduced as follows. Obviously, for those of ordinary skill in the art, the other drawings can also be obtained based on these drawings without any creative work.

[0105] Figure 1 A flow chart of a table data processing method provided by an embodiment of the present application;

[0106] Figure 2 A flow chart of another table data processing method provided by an embodiment of the present application;

[0107] Figure 3 A flow chart of another table data processing method provided by an embodiment of the present application;

[0108] Figure 4 A flow chart of step S302 in the method; Figure 2

[0109] A flow chart of another table data processing method provided by an embodiment of the present application; Figure 5

[0110] A schematic diagram of a table provided by an embodiment of the present application; Figure 6

[0111] A schematic diagram of an editing area provided by an embodiment of the present application; Figure 7

[0112] A schematic diagram of another editing area provided by an embodiment of the present application; Figure 8

[0113] A flow chart of step S604 in the method; Figure 9 Figure 5 Another flow chart of step S604 in the method;

[0114] Figure 10 A schematic diagram of a restriction editing prompt provided by an embodiment of the present application; Figure 5

[0115] A schematic diagram of another editing area provided by an embodiment of the present application; Figure 11

[0116] A schematic diagram of another editing area provided by an embodiment of the present application; Figure 12

[0117] Figure 13 ​​Another schematic view of an edit area provided by an embodiment of the present application;

[0118] Figure 14 A schematic view of a content protection setting entry provided by an embodiment of the present application;

[0119] Figure 15 Another schematic view of a content protection setting entry provided by an embodiment of the present application;

[0120] Figure 16 A schematic view of a content protection state prompt provided by an embodiment of the present application;

[0121] Figure 17 A schematic view of a content protection closing entry provided by an embodiment of the present application;

[0122] Figure 18 A schematic view of a content protection closing state prompt provided by an embodiment of the present application;

[0123] Figure 19 A structural diagram of a table data processing apparatus provided by an embodiment of the present application;

[0124] Figure 20 Another structural diagram of a table data processing apparatus provided by an embodiment of the present application;

[0125] Figure 21 A structural diagram of an electronic device provided by an embodiment of the present application. DETAILED DESCRIPTION

[0126] In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all the embodiments of the present application. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative work fall within the protection scope of the present application.

[0127] In the process of using the collaborative form tool product, it is inevitable that the filled content is modified and covered by each other, for example, the content filled by user A is changed by user B, resulting in unreliable collected information, and reducing the efficiency of data collection to some extent. Therefore, the embodiment of the present application provides a form data processing method, which can write the editing content corresponding to the editing operation into the editing area under the condition that it is determined that all the cells in the editing area have not been edited, and display the editing content in the editing area, set the cells in the editing area as protected, and grant the operator editing permission of the editing area, thereby realizing that the editing area which has not been edited is automatically set as protected and editing permission is granted after the editing content is written, realizing the effect that only the filler can modify the filled content, avoiding the situation that the written content is modified by others when multiple operators collaborate to edit the form, improving the security of the form content, improving the accuracy of information collection, and improving the efficiency of data collection.

[0128] As shown in Figure 1 The form data processing method provided by the embodiment of the present application can include the following steps:

[0129] Step S101, when receiving the editing operation of the operator on the form, acquiring an editing area corresponding to the editing operation, the editing area including at least one cell;

[0130] In the embodiment of the present application, the editing area refers to the cell operated by the editing operation, or the row where the cell operated by the editing operation is located, or the column where the cell operated by the editing operation is located, etc., and the editing area includes at least one cell.

[0131] After acquiring the at least one cell in the editing area, the protection identifier of the at least one cell in the editing area can be acquired, and in the embodiment of the present application, the protection identifier is used to indicate the editing protection state of the cell. Specifically, when the cell is edited and protected, the protection identifier of the cell is set, indicating that the cell has been edited. When the cell is not edited and protected, the protection identifier of the cell is not set, indicating that the cell has not been edited.

[0132] Based on the protection identifier of the at least one cell in the editing area, the editing permission of the editing operation in the editing area can be authenticated to obtain an authentication result. Specifically, the authentication result includes that all the cells in the editing area have not been edited, that there is at least one cell in the editing area edited by other operators, and that all the cells in the editing area have not been edited by other operators.

[0133] After obtaining the authentication result, the writing of the editing operation to the editing area can be controlled based on the authentication result, which can be specifically seen in the following embodiments.

[0134] In one embodiment of the present application, in step S102, if none of the cells in the editing region has been edited, the editing content corresponding to the editing operation is written into the editing region, and the editing content is displayed in the editing region.

[0135] If none of the cells in the editing region has been edited, it means that all the cells in the editing region are blank cells, the editing content can be directly written into the editing region, and in order to facilitate the user to view, the editing content can be displayed in the editing region.

[0136] In step S103, the cells in the editing region are set to be protected, and the operator is granted the editing permission of the editing region.

[0137] After the editing content is written into the editing region, in order to protect the editing content from being tampered by others, the cells in the editing region can be set to be protected, and the operator is granted the editing permission of the editing region.

[0138] Further, in one embodiment, if it is detected that the content of a cell is deleted, the protection of the cell is cancelled, and any operator is allowed to edit the cell. One form of cancelling the protection of the cell is to delete the protection identifier corresponding to the cell.

[0139] In another embodiment, if it is detected that the content of a cell is deleted, the protection of the cell is still maintained.

[0140] The embodiment of the present application can write the editing content corresponding to the editing operation into the editing region if it is determined that none of the cells in the editing region has been edited, and display the editing content in the editing region. The cells in the editing region are set to be protected, and the operator is granted the editing permission of the editing region. Further, the editing region which has not been edited is automatically set to be protected and granted the editing permission after the editing content is written, the effect that only the person who fills in the content can modify the filled content and others cannot edit is realized, the situation that the written content is modified by others when multiple operators collaboratively edit the table is avoided, the security of the table content is improved, the accuracy of information collection is improved, and the data collection efficiency is improved.

[0141] In another embodiment of the present application, after the editing region corresponding to the editing operation is obtained in step S101, as shown in Figure 2 , the method further comprises:

[0142] In step S201, if at least one cell in the editing region has been edited by other operators, the writing of the editing content corresponding to the editing operation in the editing region is limited.

[0143] The fact that at least one cell in the editing area has been edited by another operator indicates that the editing content edited by the other operator in the cell of the editing area needs to be protected and cannot be tampered with by anyone other than the other operator, such as the current operator (the current operator is different from the other operator). Therefore, the editing content of the current operator needs to be restricted from being written into the editing area, that is, the editing content is prohibited from being written into the editing area.

[0144] The embodiment of the present application can limit the writing of editing content into the editing area when it is determined that at least one cell in the editing area has been edited by another operator, thereby protecting the editing content in the editing area that has been edited by the other operator and avoiding the modification of the editing content edited by the other operator by the current operator. The effect that only the person who fills in the content can modify the filled-in content and other people cannot edit is achieved, the situation that the written content is modified by other people when multiple operators collaboratively edit a table is avoided, the security of the content of the table is improved, the accuracy of information collection is improved, and the efficiency of data collection is improved.

[0145] In another embodiment of the present application, after the editing area corresponding to the editing operation is obtained in step S101, as shown in Figure 2 , the method further includes:

[0146] Step S301, in the case that none of the cells in the editing area has been edited by another operator, the editing content corresponding to the editing operation is written into the editing area, and the editing content is displayed in the editing area.

[0147] The fact that none of the cells in the editing area has been edited by another operator indicates that all the cells of the editing area have not been edited by another operator, that is, all the cells of the editing area have been edited by the current operator. In this case, the current operator may need to modify the editing content written in the past, so the editing content can be written into the editing area, the existing editing content in the editing area is overwritten with new editing content, and the editing content can be displayed in the editing area for the convenience of the user.

[0148] Step S302, the cells in the editing area are set to have been protected, and the operator is granted the editing permission of the editing area.

[0149] After the editing content is written into the editing area, in order to protect the editing content from being tampered with by others, the cells in the editing area can be set to have been protected, and the operator is granted the editing permission of the editing area.

[0150] The embodiment of the present application can write the editing content corresponding to the editing operation into the editing region and display the editing content in the editing region in the case that it is determined that none of the cells in the editing region is edited by other operators, set the cells in the editing region as protected, and grant the operator the editing permission of the editing region, thereby allowing the current operator to modify the editing content in the editing region which has been edited by the current operator itself, realizing the effect that only the filler can modify the filled content and others cannot edit, avoiding the case that the written content is modified by others when multiple operators collaboratively edit the table, improving the security of the table content, improving the accuracy of information collection, and improving the data collection efficiency.

[0151] In another embodiment of the present application, after the editing region corresponding to the editing operation is obtained in step S101, as shown in Figure 3 , the method further comprises:

[0152] In step S401, in the case that the first cell in the editing region is set as protected, it is determined that the first cell is edited, and the first cell is any cell in the editing region.

[0153] After the editing region corresponding to the editing operation is obtained, it can be determined whether any cell in the editing region is protected. In the case that any cell, i.e. the first cell, in the editing region is protected, it is determined that the first cell is edited.

[0154] Specifically, in the case that the first cell in the editing region is provided with a protection identifier, it is determined that the first cell is set as protected, and the first cell is any cell in the editing region.

[0155] In step S402, in the case that the first operator has the editing permission of the first cell in the editing region, it is determined that the first operator edits the first cell.

[0156] After the first cell is determined to be edited, it can be determined whether the first operator has the editing permission of the first cell. If it is determined that the first operator has the editing permission of the first cell, it is determined that the first operator edits the first cell.

[0157] Specifically, in the case that the first operator is granted the editing permission of the first cell, the operator identifier of the first operator is associated and set for the first cell. Further, in the case that the first cell in the editing region is provided with the operator identifier of the first operator, it is determined that the first operator has the editing permission of the first cell.

[0158] After obtaining the editing region, the embodiment of the present application can determine the first cell in the editing region that has been edited and the first operator who edits the first cell, and then can facilitate determining whether the cell in the editing region has been edited by other operators.

[0159] In the process of multi-person collaborative editing of the table, there can be a case that at least two operators edit the editing region at the same time. In order to protect the editing content written first, in another embodiment of the present application, the method further includes:

[0160] In the case that the editing operation of the editing region by the other operator is received, the editing permission of the editing region is granted to the operator whose submission time is earlier.

[0161] That is, the submission time is taken as the basis for determining the editing content written first. For example, in the case that Zhang and Li fill in the cell A at the same time, if the submission time of Zhang submitting the table is earlier, Zhang has the editing permission of the cell A. For example, the submission time can be determined according to the time when the operator clicks the "submit" button, or can be determined according to the time when the cursor leaves the editing region of the cell.

[0162] The embodiment of the present application can grant the editing permission of the editing region to the operator who submits first in the case that at least two operators input editing operations to the editing region, and realize the explicit determination of the editing permission in the case that at least two operators edit the editing region, thereby providing an accurate basis for determining when the effect that only the person who fills in can modify the filled content and others cannot edit is realized, ensuring the safety of the table content, improving the accuracy of information collection, and improving the efficiency of data collection.

[0163] In another embodiment of the present application, as shown in Figure 4 Step S302 sets the cells in the editing region as having been protected and grants the editing permission of the editing region to the operator, including:

[0164] Step S501 sets a protection identifier for at least one cell in the editing region to set the cells in the editing region as having been protected;

[0165] In order to mark that the cells in the editing region have been protected, a protection identifier can be set for at least one cell in the editing region, so as to determine whether the cells in the editing region have been edited by other operators when the editing region is obtained next time.

[0166] Step S502 sets an operator identifier for at least one cell in the editing region according to the identifier of the operator to grant the editing permission of the editing region to the operator.

[0167] In order to mark the editing permission of the editor to the editing area, the identifier of the editor is set for at least one cell in the editing area, so that when the editing area is acquired next time, it is determined whether the cell in the editing area is edited by other editors.

[0168] In another embodiment of the present application, the step S502 sets the identifier of the editor for at least one cell in the editing area according to the identifier of the editor, comprising:

[0169] In the case of receiving the editing operation of the editing area by other editors, the identifier of the editor is set according to the identifier of the editor whose submission time is earlier, so as to grant the editing permission of the editing area to the editor whose submission time is earlier.

[0170] That is, in order to grant the editing permission of the editing area to the editor whose submission time is earlier, the identifier of the editor is set for the editing area according to the identifier of the editor whose submission time is earlier, so that when the editing area is acquired next time, it is determined whether the cell in the editing area is edited by other editors.

[0171] As shown in Figure 5 The table data processing method provided by the embodiment of the present application can include the following steps:

[0172] Step S601, when receiving the editing operation of the editor to the table, acquiring the editing area corresponding to the editing operation, the editing area including at least one cell.

[0173] In the embodiment of the present application, the table can refer to the Excel table to be edited, multi-dimensional table, etc. For example, as shown in Figure 6 When the user needs to edit the content of the table, the editing operation is input in the table, the editing operation is the operation of writing content in the editing area in the table, the editing area refers to the cell operated by the editing operation, or the row where the cell operated by the editing operation is located, or the column where the cell operated by the editing operation is located, etc. For example, the editing operation is the operation of entering content in one cell, or the operation of pasting the pre-copied content to five cells, etc.

[0174] The at least one cell input by the user is the editing area, that is, the editing area includes at least one cell. The acquisition of the editing area can refer to the acquisition of the area information of the editing area, the area information of the editing area refers to the coordinate array of the coordinate information of at least one cell in the editing area. In the embodiment of the present application, each cell has independent coordinate information. For example, as shown in Figure 7When the editing region includes 1 cell (as indicated by the bolded frame line), the region information includes coordinate information of the 1 cell. Figure 8 When the editing region includes 9 cells (as indicated by the bolded frame line), the region information includes coordinate information of the 9 cells.

[0175] After the user inputs the editing operation, the editing operation corresponding to the editing operation can be obtained according to the editing operation, that is, the coordinate information of one or more cells in the editing region is obtained, and a coordinate array is obtained.

[0176] In step S602, the protection identifier of at least one cell in the editing region is obtained.

[0177] In the prior art, the coordinates of the cells or regions that need to be limited are stored in a separate data file in advance, for example, cell a is set to be filled in only by user A, cell b is set to be filled in only by user B, or any header corresponding cell is set as a protected region and cannot be changed. When the user edits the table, it is verified whether the region edited by the user is a protected region based on the data file, so as to achieve the protection effect. However, each time another separate data file needs to be read and verified, which takes a lot of time and is low in efficiency. Therefore, in the embodiments of the present application, the protection identifier can be stored in the cell of the table, and further, only the corresponding cell in the table needs to be read, which greatly improves the data acquisition efficiency compared with reading the protection information of the table in a separate data file in the prior art.

[0178] In the embodiments of the present application, the protection identifier is used to indicate the editing protection state of the cell. When the cell is not edited, there is no protection identifier in the cell, or the protection identifier is a default protection identifier. For example, the default identifier can be 0. After the cell is edited, the protection identifier in the cell is automatically set to a preset identifier. For example, the preset identifier can be 1, or the default identifier can also be set to 1, and the preset identifier can also be set to 0. In actual application, the value of the protection identifier can also be set to other values according to actual needs, which is not limited in the present application.

[0179] In this step, after the editing region is determined, the corresponding cells are found according to the coordinates of the cells in the editing region, and the protection identifiers associated with the cells are obtained.

[0180] In step S603, the editing authority of the editing operation in the editing region is authenticated based on the protection identifier of at least one cell in the editing region, and an authentication result is obtained.

[0181] In the embodiments of the present application, the authentication result can refer to the permission of editing the cells in the editing region, and the authentication result includes: the editing region is unprotected, the editing region is protected and has editing permission, and no editing permission. Specifically, the editing region is unprotected corresponds to the case that there is no protected cell in the editing region; the editing region is protected and has editing permission corresponds to the case that there is a protected cell in the editing region, and the operators of the protected cells are all the same as the current operator; no editing permission corresponds to the case that there is a protected cell in the editing region, and at least part of the operators of the protected cells are not the current operator. Wherein, the editing region is unprotected and the editing region is protected and has editing permission means that the editing operation has write permission to the editing region, allowing the editing operation to write content to the editing region, and no editing permission means that the editing operation does not have write permission to the editing region, prohibiting the editing operation from writing content to the editing region.

[0182] For example, when Zhang San and Li Si fill in the table shown in the following table, the fourth row is the information of Zhang San, and the fifth row is the information of Li Si. Therefore, the editing operation input by Zhang San has editing permission to the fourth row, the editing operation input by Zhang San does not have editing permission to the fifth row, the editing operation input by Li Si has editing permission to the fifth row, and does not have editing permission to the fourth row. Figure 6

[0183] When Zhang San inputs the editing operation, the write permission of the editing operation in the editing region can be authenticated based on the editing region corresponding to the editing operation and the protection identifiers of the cells in the editing region. When the editing region is the blank area of the fourth row (neither Zhang San nor Li Si has edited this area), the authentication result of the editing region being unprotected is obtained. When the editing region is the non-blank area of the first row (for example, Zhang San has edited this area), the authentication result of the editing region being protected and having editing permission is obtained. When the editing region is the blank area of the second row (Li Si has edited this area) or the non-blank area of the second row (Li Si has edited this area), the authentication result of no editing permission is obtained.

[0184] Similarly, when Li Si inputs the editing operation, the write permission of the editing operation in the editing region can be authenticated based on the editing region corresponding to the editing operation and the protection identifiers of the cells in the editing region. When the editing region is the blank area of the fifth row (Li Si has not edited this area), the authentication result of the editing region being unprotected is obtained. When the editing region is the non-blank area of the second row (Li Si has edited this area), the authentication result of the editing region being protected and having editing permission is obtained. When the editing region is the blank area of the first row (Zhang San has not edited this area) or the non-blank area of the first row (Zhang San has edited this area), the authentication result of no editing permission is obtained. ​

[0185] Step S604 controls the write of the editing operation to the editing region based on the authentication result.

[0186] In the embodiments of the present application, in order to facilitate the control of the write of the editing region according to the authentication result, a corresponding control strategy can be set in advance for different authentication results, that is, the corresponding relationship between the authentication result and the control strategy, as shown in Table 1 below:

[0187] Table 1

[0188]

[0189] In this step, the control strategy corresponding to the authentication result obtained by authentication can be acquired in the corresponding relationship between the preset authentication result and the control strategy, and then the write of the editing operation to the editing region is controlled according to the acquired control strategy.

[0190] In the embodiments of the present application, the write permission of the editing operation to the editing region is authenticated based on the protection identifier of each cell in the editing region, and then the write of the editing operation to the editing region is controlled according to the control strategy corresponding to the authentication result, that is, the write of the editing operation is controlled according to the write permission of the editing operation to the editing region. Only when the editing operation has the write permission to the editing region, the write is allowed, and when the editing operation does not have the write permission to the editing region, the write is prohibited, so as to avoid the mutual modification and covering of the editing content, improve the security of the table content, improve the accuracy of information collection, and improve the data collection efficiency.

[0191] In another embodiment of the present application, as shown in Figure 9 Step S604 controls the write of the editing operation to the editing region based on the authentication result, including:

[0192] Step S701, in the case that the authentication result is that the editing region is unprotected, the editing content corresponding to the editing operation is written to the editing region, and the editing content is displayed in the editing region;

[0193] In the case that the authentication result is that the editing region is unprotected, the content is allowed to be written to the editing region, and accordingly, when the write of the editing operation to the editing region is controlled according to the control strategy, the editing content corresponding to the editing operation can be directly written to the editing region.

[0194] Step S702, the cells in the editing region are set as protected, and the editing permission of the operator to the editing region is granted.

[0195] Specifically, setting the cells in the editing region as protected and granting the operator the editing permission of the editing region includes: setting a protection identifier for at least one of the cells in the editing region; and setting an operator identifier for at least one of the cells in the editing region according to the identifier of the operator.

[0196] That is, in order to protect the written editing content, the protection identifier and the operator identifier need to be set for the cells in the editing region, that is, the protection identifier in each cell in the editing region is set as a preset protection identifier, and the operator identifier is set according to the user identifier corresponding to the input editing operation, so that when subsequent other people want to edit any cell in the editing region, an authentication result of no editing permission is obtained through authentication, and writing content to the editing region is prohibited, thereby realizing protection of the written data in the cell.

[0197] In an embodiment of the present application, setting the operator identifier for at least one of the cells in the editing region according to the identifier of the operator includes: in the case that an editing operation of another operator to the editing region is received, setting the operator identifier according to the identifier of the operator whose submission time is earlier.

[0198] In actual application, when all the cells in the editing region are blank cells, there may be a case that at least two users simultaneously write content to the editing region, that is, when at least two editing operations corresponding to the editing content write the editing region, the submission time when each user writes the content and performs a submission operation (such as clicking a close button or a save button, etc.) can be obtained, the identifier of the second operator whose submission time is earlier is determined, the operator identifier is set as the identifier of the second operator whose submission time is earlier, and the protection identifier stored in at least one of the cells in the editing region is set.

[0199] In another embodiment of the present application, as shown in Figure 10 Step S604 controls the writing of the editing operation to the editing region based on the authentication result, and further includes:

[0200] Step S801, in the case that the authentication result is that the editing region is protected and has the editing permission, writes the editing content corresponding to the editing operation to the editing region, and displays the editing content in the editing region;

[0201] In a case where it is determined that the authentication result is that the editing region is protected and the editing right is available, there is a protected cell in the editing region, but the operator of the protected cell is the same as the current operator, and the editing region is allowed to be written with content, and accordingly, in the case of controlling the writing of the editing operation to the editing region according to the control policy, the editing content corresponding to the editing operation can be directly allowed to be written to the editing region, and only the same user can modify the written content, thereby protecting the written data in the cell in the editing region.

[0202] In step S802, the cell in the editing region is set to be protected, and the operator is granted the editing right to the editing region.

[0203] Specifically, setting the cell in the editing region to be protected and granting the operator the editing right to the editing region includes: setting a protection identifier for at least one cell in the editing region; and setting an operator identifier for at least one cell in the editing region according to the identifier of the operator.

[0204] In another embodiment of the present application, the writing of the editing operation to the editing region is controlled based on the authentication result, including:

[0205] In a case where the authentication result is that the editing right is not available, the editing region is limited to be written with the editing content corresponding to the editing operation.

[0206] In a case where it is determined that the authentication result is that the editing right is not available, there is a protected cell in the editing region, and the editing region is prohibited to be written with content, and accordingly, in the case of controlling the writing of the editing operation to the editing region according to the control policy, the editing content corresponding to the editing operation can be directly limited to be written to the editing region, thereby protecting the written data in the cell in the editing region. In actual application, in order to enhance the interactivity, a limit editing prompt as shown in FIG. 8B can be popped up. Figure 11

[0207] In another embodiment of the present application, the editing right of the editing operation to the editing region is authenticated based on the protection identifier of at least one cell in the editing region, and an authentication result is obtained, including:

[0208] In a case where it is determined that the editing region is not protected based on the protection identifier of at least one cell in the editing region, it is determined that the authentication result is that the editing region is not protected.

[0209] Specifically, first, the number of identifiers of the first operator identifiers corresponding to at least one cell is obtained.

[0210] ​In the embodiments of the present application, the first operator identifier is used to indicate the historical operator of the cell. When the cell is a blank cell, the historical operator is a default value, such as 0. When the cell is a non-blank cell, the operator who last edited the cell is the historical operator, and the identifier of the operator is the first operator identifier.

[0211] Each cell has a unique first operator identifier, and the first operator identifier of each cell can also be stored in the cell to improve reading and use efficiency.

[0212] The first operator identifiers of different cells can be the same or different, so there can be repeated operator identifiers in the at least one historical operator identifier. For example, when the first operator identifiers in the editing area (such as the thickened frame in the figure) shown in FIG. 2 are obtained, two first operator identifiers of Zhang San and two first operator identifiers of Li Si will be obtained. The number of identifiers in the embodiments of the present application refers to the number of first operator identifiers that are different from each other in the at least one obtained operator identifier. Figure 12

[0213] In this step, the first operator identifier corresponding to at least one cell can be obtained, and the at least one first operator identifier can be de-duplicated, that is, the repeated first operator identifiers are removed, and the non-repeated first operator identifiers are left. The first operator identifiers after de-duplication are counted to obtain the number of identifiers. For example, after de-duplicating two first operator identifiers of Zhang San and two first operator identifiers of Li Si, one first operator identifier of Zhang San and one first operator identifier of Li Si are obtained, and the first operator identifiers after de-duplication are counted to obtain the number of identifiers 2.

[0214] Secondly, the region protection identifier is determined according to the protection identifier corresponding to each of the cells.

[0215] The region protection identifier is used to indicate the editing protection state of the editing area. The editing protection state is used to indicate whether there is an editing protection cell in the editing area, that is, whether there is an editing protection cell in the editing area. For example, when the region protection identifier is 1, it indicates that there is an editing protection cell in the editing area, and when the region protection identifier is 0, it indicates that there is no editing protection cell in the editing area.

[0216] In this step, the protection identifier corresponding to at least one of the cells can be logically operated to obtain the region protection identifier. Specifically, the logical operation can refer to logical or operation and the like.

[0217] For example, it is assumed that when the cell is not edited, the protection identifier in the cell is 0, and after the cell is edited, the protection identifier in the cell is 1. When the editing area shown in FIG. 2 is selected, Figure 6 ​The region protection identifier is 1, which indicates that there is an edit-protected cell in the edit region. For example, when the edit region shown in FIG. 4 is selected, the protection identifiers of the four cells are logically ORed, and the region protection identifier is 0, which indicates that there is no edit-protected cell in the edit region. Figure 13 The region protection identifier is 1, which indicates that there is an edit-protected cell in the edit region. For example, when the edit region shown in FIG. 4 is selected, the protection identifiers of the four cells are logically ORed, and the region protection identifier is 0, which indicates that there is no edit-protected cell in the edit region.

[0218] The authentication result is determined according to the region protection identifier and the number of identifiers.

[0219] In an embodiment of the present application, if the region protection identifier is equal to a first preset value, which indicates that there is no edit-protected cell in the edit region, the authentication result is directly determined to be that the edit region is unprotected, and the content is allowed to be written into the edit region.

[0220] In another embodiment of the present application, if the region protection identifier is equal to a second preset value, the number of identifiers is equal to one, and the first operator identifier is the same as the second operator identifier corresponding to the edit operation, that is, there is a protected cell in the edit region, and the operator of the protected cell is the same as the current operator, that is, the edit region has been edited by itself, the authentication result is determined to be that the edit region is protected and has editing permission.

[0221] In the case that the region protection identifier is equal to the second preset value, which indicates that there is an edit-protected cell in the edit region, it is determined whether the number of identifiers is greater than or equal to two. In the case that the number of identifiers is equal to one and the first operator identifier is the same as the second operator identifier of the operator inputting the edit operation, the authentication result is determined to be that the edit region is protected and has editing permission, that is, there is a protected cell in the edit region, and the operator of the protected cell is the same as the current operator, and the content is allowed to be written into the edit region.

[0222] In another embodiment of the present application, if the region protection identifier is equal to the second preset value, and the number of identifiers is greater than or equal to two, the authentication result is determined to be no editing permission, which includes that there is a protected cell in the edit region.

[0223] Or,

[0224] If the region protection identifier is equal to the second preset value, the number of identifiers is equal to one, and the first operator identifier is different from the second operator identifier corresponding to the edit operation, the authentication result is determined to be the no editing permission.

[0225] In a case where it is determined that the editing region has been edited by other operators based on the protection identifier of at least one cell in the editing region, the authentication result is determined to be no editing permission.

[0226] In a case where the region protection identifier is equal to the second preset value, indicating that there is a protected cell in the editing region, it is determined whether the number of identifiers is greater than or equal to 2. If yes, the authentication result is determined to be no editing permission, that is, there is a protected cell in the editing region, and writing content to the editing region is prohibited. If the number of identifiers is equal to 1, it is further determined whether the second operator identifier of the operator inputting the editing operation is different from the only first operator identifier in the editing region. If yes, the authentication result is also determined to be no editing permission, that is, there is a protected cell in the editing region, and writing content to the editing region is prohibited.

[0227] The embodiment of the present application can determine the authentication result according to the region protection identifier of the editing region and the number of identifiers in the editing region, and can determine the authentication result in a large range as a whole by calculating the region protection identifier and the number of identifiers, which is less computationally intensive and saves system resources compared with determining the writing permission of each cell respectively.

[0228] In actual application, for the convenience of users, for example, Figure 14 as shown, the setting entry of content protection can be displayed when the user right-clicks the sheet bar of the table, or the setting entry of content protection can be automatically displayed when the user clicks any cell after creating a new table, as shown in Figure 15 After the user selects to set content protection, the user can be prompted to enter the content protection state, as shown in Figure 16 When the user does not need content protection, the user can display the closing entry of content protection by right-clicking the sheet bar of the table again, as shown in Figure 17 After the user selects to close content protection, the user can be prompted to enter the closed content protection state, as shown in Figure 18

[0229] In another embodiment of the present application, a table data processing apparatus is also provided, as shown in Figure 19 The apparatus comprises:

[0230] The first obtaining module 11 is configured to obtain an editing region corresponding to an editing operation of an operator on a table when the editing operation is received, the editing region comprising at least one cell.

[0231] The first writing module 12 is configured to write editing content corresponding to the editing operation into the editing region and display the editing content in the editing region in a case where none of the cells in the editing region has been edited.

[0232] ​The setting module 13 is configured to set the cells in the editing area as having been protected and grant the operator the editing permission of the editing area.

[0233] In a possible implementation of the present application, the apparatus further includes:

[0234] The limiting writing module is configured to limit writing the editing content corresponding to the editing operation in the editing area in a case where at least one cell in the editing area is edited by other operators.

[0235] In a possible implementation of the present application, the apparatus further includes:

[0236] The writing and displaying module is configured to write the editing content corresponding to the editing operation in the editing area and display the editing content in the editing area in a case where no cell in the editing area is edited by other operators.

[0237] The setting and granting module is configured to set the cells in the editing area as having been protected and grant the operator the editing permission of the editing area.

[0238] In a possible implementation of the present application, the apparatus further includes:

[0239] The first determining module is configured to determine that a first cell in the editing area is edited in a case where the first cell is set as having been protected, the first cell being any cell in the editing area.

[0240] The second determining module is configured to determine that the first operator edits the first cell in a case where it is determined that the first operator has the editing permission of the first cell in the editing area.

[0241] In a possible implementation of the present application, the apparatus further includes:

[0242] The permission granting module is configured to grant the operator who is earlier in time to submit the editing operation of the editing area the editing permission of the editing area in a case where the editing operation of the editing area by other operators is received.

[0243] In a possible implementation of the present application, the setting module includes:

[0244] The first setting unit is configured to set a protection identifier for at least one cell in the editing area to set the cells in the editing area as having been protected.

[0245] The second setting unit is configured to set an operator identifier for at least one cell in the editing area according to the identifier of the operator, so as to grant the operator editing permission of the editing area.

[0246] In a possible embodiment of the present application, the second setting unit is further configured to:

[0247] In a case where an editing operation of another operator on the editing area is received, the operator identifier is set according to the identifier of the operator whose submission time is earlier, so as to grant the operator whose submission time is earlier editing permission of the editing area.

[0248] In a possible embodiment of the present application, the device further includes:

[0249] The third determining module is configured to determine that a first cell in the editing area is set to be protected in a case where the first cell is set with a protection identifier, wherein the first cell is any cell in the editing area.

[0250] The fourth determining module is configured to determine that a first operator has editing permission of a first cell in the editing area in a case where the first cell is set with an operator identifier of the first operator.

[0251] In another embodiment of the present application, as shown in Figure 20 The present application also provides a table data processing device, which includes:

[0252] The second obtaining module 21 is configured to obtain an editing area corresponding to an editing operation of an operator on a table when the editing operation is received, wherein the editing area includes at least one cell.

[0253] The third obtaining module 22 is configured to obtain a protection identifier of at least one cell in the editing area.

[0254] The authentication module 23 is configured to authenticate editing permission of the editing operation on the editing area based on the protection identifier of at least one cell in the editing area, to obtain an authentication result.

[0255] The control module 24 is configured to control writing of the editing operation on the editing area based on the authentication result.

[0256] In a possible embodiment of the present application, the control module includes:

[0257] The first writing unit is configured to write editing content corresponding to the editing operation into the editing area and display the editing content in the editing area in a case where the authentication result is that the editing area is unprotected.

[0258] The second setting unit is configured to set a cell in the editing area as protected and grant the operator editing permission of the editing area.

[0259] In a possible embodiment of the present application, the second setting unit comprises:

[0260] The first setting sub-unit is configured to set a protection identifier for at least one cell in the editing area.

[0261] The second setting sub-unit is configured to set an operator identifier for at least one cell in the editing area according to the identifier of the operator.

[0262] In a possible embodiment of the present application, the second setting sub-unit is further configured to:

[0263] In a case where an editing operation of another operator on the editing area is received, the operator identifier is set according to the identifier of the operator whose submission time is earlier.

[0264] In a possible embodiment of the present application, the control module comprises:

[0265] The second writing unit is configured to write the editing content corresponding to the editing operation into the editing area and display the editing content in the editing area in a case where the authentication result is that the editing area is protected and has editing permission.

[0266] The setting granting unit is configured to set a cell in the editing area as protected and grant the operator editing permission of the editing area.

[0267] In a possible embodiment of the present application, the control module comprises:

[0268] The limiting writing unit is configured to limit writing of the editing content corresponding to the editing operation into the editing area in a case where the authentication result is no editing permission.

[0269] In a possible embodiment of the present application, the authentication module comprises:

[0270] The first determining unit is configured to determine that the authentication result is that the editing area is unprotected in a case where it is determined that the editing area is unprotected based on the protection identifier of at least one cell in the editing area.

[0271] In a possible embodiment of the present application, the authentication module comprises:

[0272] The second determining unit is configured to determine that the authentication result is that the editing region is protected and has editing permission when it is determined that the editing region has been edited by itself based on the protection identifier of at least one cell in the editing region.

[0273] In a possible embodiment of the present application, the authentication module comprises:

[0274] The third determining unit is configured to determine that the authentication result is no editing permission when it is determined that the editing region has been edited by another operator based on the protection identifier of at least one cell in the editing region.

[0275] In another embodiment of the present application, an electronic device is also provided, comprising 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.

[0276] The memory is configured to store a computer program.

[0277] The processor is configured to execute the program stored in the memory to implement the table data processing method in any of the preceding method embodiments.

[0278] The electronic device provided by the embodiment of the present application implements, through the processor executing the program stored in the memory, when receiving an editing operation of an operator on a table, acquiring an editing region corresponding to the editing operation, the editing region comprising at least one cell; in the case that none of the cells in the editing region has been edited, writing editing content corresponding to the editing operation into the editing region and displaying the editing content in the editing region; setting the cells in the editing region as having been protected and granting the operator editing permission of the editing region.

[0279] The embodiment of the present application can write editing content corresponding to an editing operation into an editing region and display the editing content in the editing region in the case that none of the cells in the editing region has been edited, set the cells in the editing region as having been protected and grant the operator editing permission of the editing region, thereby realizing that an editing region that has not been edited is automatically set as protected and granted editing permission after writing editing content, realizing the effect that only the person who fills in can modify the content filled in by him, avoiding the case that the content written by an operator is modified by other operators when multiple operators edit a table cooperatively, improving the security of table content, improving the accuracy of information collection and improving the efficiency of data collection.

[0280] Alternatively, the electronic device provided by the embodiment of the present application, the processor realizes the following by executing the program stored on the memory: when receiving an editing operation of an operator on a table, an editing region corresponding to the editing operation is obtained, the editing region including at least one cell; a protection identifier of at least one cell in the editing region is obtained, the protection identifier being used to indicate an editing protection state of the cell; based on the protection identifier of at least one cell in the editing region, the editing permission of the editing operation on the editing region is authenticated to obtain an authentication result; and based on the authentication result, the writing of the editing operation on the editing region is controlled.

[0281] The embodiment of the present application authenticates the writing permission of the editing operation on the editing region based on the protection identifier of each cell in the editing region, and controls the writing of the editing operation on the editing region according to the control strategy corresponding to the authentication result, that is, the writing of the editing operation is controlled according to the writing permission of the editing operation on the editing region, and the writing is allowed only when the editing operation has the writing permission on the editing region, and the writing is prohibited when the editing operation does not have the writing permission on the editing region, thereby avoiding mutual modification and covering of editing content, improving the security of table content, improving the accuracy of information collection, and improving the efficiency of data collection.

[0282] The communication bus 1140 mentioned in the above electronic device can be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus, etc. The communication bus 1140 can be divided into an address bus, a data bus, a control bus, etc. For the convenience of representation, Figure 21 In the above electronic device, only one thick line is used to represent the communication bus 1140, but it does not mean that there is only one bus or only one type of bus.

[0283] The communication interface 1120 is used for communication between the above electronic device and other devices.

[0284] The memory 1130 can include a random access memory (RAM) and can also include a non-volatile memory, such as at least one disk memory. Optionally, the memory can also be at least one storage device located away from the aforementioned processor.

[0285] The processor 1110 described above can be a general processor, including a central processing unit (CPU), a network processor (NP), etc.; can also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field-programmable gate array (FPGA) or other programmable logic device, a discrete gate or transistor logic device, a discrete hardware component.

[0286] In yet another embodiment of the present application, a computer readable storage medium is also provided, and a table data processing method program is stored on the computer readable storage medium, and the table data processing method program, when executed by a processor, implements the steps of the table data processing method according to any one of the method embodiments.

[0287] It should be noted that, in this document, relational terms such as "first" and "second", and the like, are 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. Moreover, the terms "comprises", "comprising", or any other variations 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 can include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without limitation, an element preceded by "comprises... a" does not, without more constraints, foreclose the existence of additional identical elements in the process, method, article, or apparatus that comprises the element.

[0288] The above description is merely that of specific embodiments of the present application, to enable a person skilled in the art to understand or implement the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein can be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application is not to be limited to the embodiments shown herein but is to accord with the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for processing tabular data, characterized in that, include: When an operator's editing operation on the table is received, the editing area corresponding to the editing operation is obtained. The editing area includes at least one cell, and the cell is set with a protection identifier and a first operator identifier. The method further includes: Obtain the number of identifiers corresponding to at least one of the cells, representing the first operator identifier; A region protection identifier is determined based on the protection identifier corresponding to each cell, wherein the region protection identifier is obtained by performing a logical operation on the protection identifier corresponding to at least one cell; The authentication result is determined based on the area protection sign and the number of such signs. The step of determining the authentication result based on the regional protection identifier and the number of the identifiers includes: If the area protection identifier is equal to a second preset value, and the number of identifiers is greater than or equal to two, the authentication result is determined to be no editing permission. No editing permission includes: the existence of a protected cell within the editing area, and at least one cell within the editing area has been edited by another operator; or, if the area protection identifier is equal to the second preset value, the number of identifiers is equal to one, and the first operator identifier and the second operator identifier corresponding to the editing operation are different, the authentication result is determined to be no editing permission, and at least one cell within the editing area has been edited by another operator. If none of the cells in the editing area have been edited, the edited content corresponding to the editing operation will be written into the editing area and displayed in the editing area. Set the cells in the editing area to protected and grant the operator editing permissions to the editing area.

2. The method according to claim 1, characterized in that, After obtaining the editing area corresponding to the editing operation, the method further includes: If at least one cell in the editing area has been edited by another operator, the editing content corresponding to the editing operation is restricted from being written into the editing area.

3. The method according to claim 1, characterized in that, After obtaining the editing area corresponding to the editing operation, the method further includes: If none of the cells in the editing area have been edited by other operators, the edited content corresponding to the editing operation will be written into the editing area and displayed in the editing area. Set the cells in the editing area to protected and grant the operator editing permissions to the editing area.

4. The method according to any one of claims 1-3, characterized in that, After obtaining the editing area corresponding to the editing operation, the method further includes: If the first cell in the editing area is set to be protected, it is determined that the first cell has been edited, and the first cell is any cell in the editing area; If it is determined that the first operator has editing permissions for the first cell in the editing area, it is determined that the first operator has edited the first cell.

5. The method according to claim 4, characterized in that, The method further includes: If an operator receives an editing operation on the editing area from another operator, the operator whose submission time was earlier shall be granted editing permission for the editing area.

6. The method according to claim 4, characterized in that, Setting the cells in the editing area to protected and granting the operator editing permissions to the editing area includes: Set a protection flag for at least one cell within the editing area to mark the cell in the editing area as protected; An operator identifier is set for at least one cell within the editing area based on the operator's identifier, thereby granting the operator editing permissions for the editing area.

7. The method according to claim 6, characterized in that, Setting an operator identifier for at least one cell within the editing area based on the operator's identifier includes: Upon receiving an editing operation from another operator on the editing area, the operator identifier is set according to the identifier of the operator who submitted the operation first, so as to grant the operator who submitted the operation first the editing permission to the editing area.

8. The method according to claim 6, characterized in that, The method further includes: If the first cell in the editing area is marked with a protection flag, it is determined that the first cell is set to be protected, wherein the first cell is any cell in the editing area; If the first cell in the editing area has an operator identifier for the first operator, it is determined that the first operator has editing permissions for the first cell.

9. A method for processing tabular data, characterized in that, include: When an operator's editing operation on the table is received, the editing area corresponding to the editing operation is obtained. The editing area includes at least one cell, and the cell is set with a protection identifier and a first operator identifier. Obtain the protection identifier of at least one cell in the editing area, the protection identifier being used to indicate the editing protection status of the cell; Based on the protection identifier of at least one cell in the editing area, the editing permission of the editing operation in the editing area is authenticated, and the authentication result is obtained; The authentication of editing permissions for the editing operation in the editing area is performed based on the protection identifier of at least one cell in the editing area, and the authentication result is obtained, including: Obtain the number of identifiers corresponding to at least one of the cells, representing the first operator identifier; A region protection identifier is determined based on the protection identifier corresponding to each cell, wherein the region protection identifier is obtained by performing a logical operation on the protection identifier corresponding to at least one cell; The authentication result is determined based on the area protection marker and the number of such markers; The step of determining the authentication result based on the regional protection identifier and the number of the identifiers includes: If the area protection identifier is equal to the second preset value and the number of identifiers is greater than or equal to two, the authentication result is determined to be no editing permission; or, if the area protection identifier is equal to the second preset value, the number of identifiers is equal to one, and the first operator identifier and the second operator identifier corresponding to the editing operation are different, the authentication result is determined to be no editing permission. The authentication result is used to control the writing of the editing area by the editing operation.

10. The method according to claim 9, characterized in that, Controlling the writing of the editing area by the editing operation based on the authentication result includes: If the authentication result indicates that the editing area is unprotected, the edited content corresponding to the editing operation is written into the editing area and displayed in the editing area; Set the cells in the editing area to protected and grant the operator editing permissions to the editing area.

11. The method according to claim 9, characterized in that, Controlling the writing of the editing area by the editing operation based on the authentication result includes: If the authentication result indicates that the editing area is protected and the user has editing permissions, the edited content corresponding to the editing operation is written into the editing area and displayed in the editing area. Set the cells in the editing area to protected and grant the operator editing permissions to the editing area.

12. The method according to claim 9, characterized in that, Controlling the writing of the editing area by the editing operation based on the authentication result includes: When the authentication result indicates no editing permission, the editing content corresponding to the editing operation is restricted from being written into the editing area.

13. A tabular data processing device, characterized in that, include: The first acquisition module is used to acquire the editing area corresponding to the editing operation when it receives an operator's editing operation on the table. The editing area includes at least one cell, and the cell is set with a protection identifier and a first operator identifier. The device further includes: obtaining the number of identifiers of a first operator identifier corresponding to at least one of the cells; determining a region protection identifier based on a protection identifier corresponding to each cell, wherein the region protection identifier is obtained by performing a logical operation on the protection identifiers corresponding to at least one of the cells; determining an authentication result based on the region protection identifier and the number of identifiers; the determination of the authentication result based on the region protection identifier and the number of identifiers includes: determining the authentication result as no editing permission when the region protection identifier is equal to a second preset value and the number of identifiers is greater than or equal to two, wherein no editing permission includes: there are protected cells in the editing area and at least one cell in the editing area has been edited by another operator; or, determining the authentication result as no editing permission when the region protection identifier is equal to the second preset value, the number of identifiers is equal to one, and the first operator identifier and the second operator identifier corresponding to the editing operation are different, and at least one cell in the editing area has been edited by another operator; The first writing module is used to write the edited content corresponding to the editing operation into the editing area when none of the cells in the editing area have been edited, and to display the edited content in the editing area; The settings module is used to set the cells in the editing area as protected and grant the operator editing permissions to the editing area.

14. A tabular data processing device, characterized in that, include: The second acquisition module is used to acquire the editing area corresponding to the editing operation when it receives an operator's editing operation on the table. The editing area includes at least one cell, and the cell is set with a protection identifier and a first operator identifier. The third acquisition module is used to acquire the protection identifier of at least one cell in the editing area, the protection identifier being used to indicate the editing protection status of the cell; The authentication module is used to authenticate the editing permissions of the editing operation in the editing area based on the protection identifier of at least one cell in the editing area, and obtain the authentication result; The method of authenticating the editing permission of the editing operation in the editing area based on the protection identifier of at least one cell in the editing area to obtain an authentication result includes: obtaining the identifier count of the first operator identifier corresponding to at least one cell; determining the area protection identifier according to the protection identifier corresponding to each cell, wherein the area protection identifier is obtained by performing a logical operation on the protection identifiers corresponding to at least one cell; determining the authentication result according to the area protection identifier and the identifier count; the method of determining the authentication result according to the area protection identifier and the identifier count includes: determining the authentication result as no editing permission when the area protection identifier is equal to a second preset value and the identifier count is greater than or equal to two; or determining the authentication result as no editing permission when the area protection identifier is equal to the second preset value, the identifier count is equal to one, and the first operator identifier and the second operator identifier corresponding to the editing operation are different. The control module is used to control the writing of the editing operation to the editing area based on the authentication result.

15. An electronic device, characterized in that, It includes a processor, a communication interface, a memory, and a communication bus, wherein the processor, the communication interface, and the memory communicate with each other through the communication bus; Memory, used to store computer programs; A processor, when executing a program stored in a memory, implements the tabular data processing method according to any one of claims 1 to 8 or the tabular data processing method according to any one of claims 9 to 12.

16. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a program for a table data processing method, which, when executed by a processor, implements the steps of the table data processing method according to any one of claims 1-8 or any one of claims 9-12.

Images