Table processing method and device, electronic equipment and storage medium

Abstract

The invention relates to a table processing method and device, electronic equipment and a storage medium, and the method comprises the steps: in response to a splitting operation on a target cell in a table, splitting the target cell to obtain at least two split cells; and configuring a cooperation permission for the at least two split cells. Therefore, the collaboration authority of the split cells can be effectively managed in a cell splitting scene, and the safety and smoothness of table collaboration are ensured.

Description

Technical Field

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

[0002] Cell splitting refers to splitting a cell in a table into two or more cells in office software. It is a basic and powerful function in table processing.

[0003] In actual applications, there is a special application scenario when splitting cells: the cell before splitting is configured with collaboration permissions, and the collaboration permissions mainly involve restrictions on operations such as access, editing, and copying of the content in the cell.

[0004] In such scenarios, if you simply split the cells without considering the permission configuration of the split cells, the originally protected cell contents may be exposed to users who should not have access to the contents, thereby undermining the collaborative security of the table. Summary of the invention

[0005] The present application provides a table processing method, device, electronic device and storage medium to solve the technical problem in the prior art that when splitting cells, cells are only split but the permission configuration of the cells after the split is not considered, which is likely to destroy the collaborative security of the table.

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

[0007] In response to a split operation on a target cell in the table, split the target cell to obtain at least two split cells;

[0008] Collaboration permissions are configured for the at least two split cells.

[0009] In a possible implementation, in response to the splitting operation on the target cell in the table, splitting the target cell to obtain at least two split cells includes:

[0010] In response to a split operation on a target cell in a table, acquiring cell layout information indicated by the split operation;

[0011] The target cell is split according to the cell layout information to obtain at least two split cells.

[0012] In a possible implementation manner, the target cell is a merged cell, and in response to a split operation on the target cell in the table, obtaining the cell layout information indicated by the split operation includes:

[0013] In response to a split operation on a target cell in a table, original cell layout information of the target cell is acquired, where the original cell layout information refers to layout information of at least two original cells that are merged to form the target cell;

[0014] The original cell layout information is determined as the cell layout information indicated by the split operation.

[0015] In a possible implementation manner, in response to a split operation on a target cell in a table, obtaining cell layout information indicated by the split operation includes:

[0016] In response to a split operation on a target cell in a table, obtaining cell content in the target cell;

[0017] Splitting the cell content according to a preset splitting rule to obtain at least two split contents;

[0018] The cell layout information that matches the at least two split contents is determined as the cell layout information indicated by the split operation.

[0019] In a possible implementation manner, in response to the splitting operation on the target cell in the table, splitting the target cell to obtain at least two split cells further includes:

[0020] Fill the at least two split cells with cell content according to the split operation.

[0021] In a possible implementation manner, filling the at least two split cells with cell content according to the split operation includes:

[0022] According to the split operation, copy and fill the cell content of the target cell into each of the split cells; or,

[0023] According to the split operation, the cell content of the target cell is filled into the specified split cell; or,

[0024] According to the splitting operation, the split contents obtained according to the splitting rule are filled into the split cells in a manner that complies with the preset content filling rule.

[0025] In a possible implementation manner, when the target cell is a merged cell, filling the at least two split cells with cell content according to the split operation includes:

[0026] Obtaining original cell content in an original cell corresponding to the target cell, where the original cell refers to a cell that is merged to form the target cell;

[0027] Fill each of the split cells with the corresponding original cell content.

[0028] In a possible implementation manner, configuring collaboration permissions for the at least two split cells includes:

[0029] Obtain target collaboration permission configuration information of the target cell;

[0030] The collaboration authority is configured for each of the split cells according to the target collaboration authority configuration information.

[0031] In a possible implementation manner, configuring collaboration permissions for the at least two split cells includes:

[0032] Acquire original collaboration permission configuration information of the original cell corresponding to the target cell;

[0033] For each of the split cells, the collaboration permission is configured for the split cell according to the original collaboration permission configuration information of the original cell corresponding to the split cell.

[0034] In a possible implementation manner, when the target cell is a merged cell, configuring collaboration permissions for the at least two split cells includes:

[0035] Acquire original collaboration permission configuration information of an original cell corresponding to the target cell, where the original cell refers to a cell that is merged to form the target cell;

[0036] For each of the split cells, the collaboration permission is configured for the split cell according to the original collaboration permission configuration information of the original cell corresponding to the split cell.

[0037] In a possible implementation manner, configuring collaboration permissions for the at least two split cells includes:

[0038] Obtain target collaboration permission configuration information of the target cell;

[0039] The collaboration authority is configured for each of the split cells according to the target collaboration authority configuration information.

[0040] In a possible implementation manner, configuring collaboration permissions for the at least two split cells includes:

[0041] In response to the permission configuration operation on the at least two split cells, collaboration permissions are configured for the at least two split cells.

[0042] In a possible implementation manner, configuring collaboration permissions for the at least two split cells includes:

[0043] For each of the split cells, a collaboration permission is configured for the split cell according to the cell content in the split cell.

[0044] In a possible implementation, in response to the splitting operation on the target cell in the table, splitting the target cell to obtain at least two split cells includes:

[0045] In response to a split operation on a target cell in a table, if it is determined that the current account has permission to perform the split operation on the target cell, the target cell is split to obtain at least two split cells.

[0046] In a possible implementation, in response to the splitting operation on the target cell in the table, splitting the target cell to obtain at least two split cells includes:

[0047] In response to a split operation on a target cell in a table, if it is determined that the split operation has an impact on adjacent cells of the target cell, determining whether the current account has a split permission on the target cell and an edit permission on the adjacent cells;

[0048] When it is determined that the current account has the splitting authority for the target cell and the editing authority for the adjacent cell, the target cell is split to obtain at least two split cells.

[0049] In a possible implementation, after the target cell is split in response to the split operation on the target cell in the table to obtain at least two split cells, the method further includes:

[0050] In the case where it is determined that the split operation has an impact on the neighboring cells of the target cell, adding a new cell to the table according to the at least two split cells, and determining the cells to be merged;

[0051] The cells to be merged are merged to obtain corresponding merged cells.

[0052] In a possible implementation manner, after merging the cells to be merged to obtain a corresponding merged cell, the method further includes:

[0053] Configure collaboration permissions for the merged cell.

[0054] In a second aspect, the present application provides a table processing device, the device comprising:

[0055] A cell splitting module, configured to split the target cell in the table in response to a splitting operation on the target cell, to obtain at least two split cells;

[0056] The permission configuration module is used to configure the collaboration permissions for the at least two split cells.

[0057] In a possible implementation, the cell splitting module includes:

[0058] A layout information acquisition unit, configured to, in response to a split operation on a target cell in a table, acquire cell layout information indicated by the split operation;

[0059] The layout splitting unit is used to split the target cell according to the cell layout information to obtain at least two split cells.

[0060] In a possible implementation manner, the target cell is a merged cell, and the layout information acquisition unit is specifically used to:

[0061] In response to a split operation on a target cell in a table, original cell layout information of the target cell is acquired, where the original cell layout information refers to layout information of at least two original cells that are merged to form the target cell;

[0062] The original cell layout information is determined as the cell layout information indicated by the split operation.

[0063] In a possible implementation manner, the layout information acquisition unit is specifically used to:

[0064] In response to a split operation on a target cell in a table, obtaining cell content in the target cell;

[0065] Splitting the cell content according to a preset splitting rule to obtain at least two split contents;

[0066] The cell layout information that matches the at least two split contents is determined as the cell layout information indicated by the split operation.

[0067] In a possible implementation, the cell splitting module further includes:

[0068] A content filling unit is used to fill the at least two split cells with cell content according to the split operation.

[0069] In a possible implementation manner, the content filling unit is specifically used to:

[0070] According to the split operation, copy and fill the cell content of the target cell into each of the split cells; or,

[0071] According to the split operation, the cell content of the target cell is filled into the specified split cell; or,

[0072] According to the splitting operation, the split contents obtained according to the splitting rule are filled into the split cells in a manner that complies with the preset content filling rule.

[0073] In a possible implementation manner, the content filling unit is specifically used to:

[0074] In the case where the target cell is a merged cell, obtaining original cell content in an original cell corresponding to the target cell, where the original cell refers to a cell merged to form the target cell;

[0075] Fill each of the split cells with the corresponding original cell content.

[0076] In a possible implementation, the permission configuration module is specifically used to:

[0077] Obtain target collaboration permission configuration information of the target cell;

[0078] The collaboration authority is configured for each of the split cells according to the target collaboration authority configuration information.

[0079] In a possible implementation, the permission configuration module is specifically used to:

[0080] Acquire original collaboration permission configuration information of the original cell corresponding to the target cell;

[0081] For each of the split cells, the collaboration permission is configured for the split cell according to the original collaboration permission configuration information of the original cell corresponding to the split cell.

[0082] In a possible implementation, the permission configuration module is specifically used to:

[0083] In the case where the target cell is a merged cell, obtaining original collaboration permission configuration information of an original cell corresponding to the target cell, where the original cell refers to a cell that is merged to form the target cell;

[0084] For each of the split cells, the collaboration permission is configured for the split cell according to the original collaboration permission configuration information of the original cell corresponding to the split cell.

[0085] In a possible implementation, the permission configuration module is specifically used to:

[0086] Obtain target collaboration permission configuration information of the target cell;

[0087] The collaboration authority is configured for each of the split cells according to the target collaboration authority configuration information.

[0088] In a possible implementation, the permission configuration module is specifically used to:

[0089] In response to the permission configuration operation on the at least two split cells, collaboration permissions are configured for the at least two split cells.

[0090] In a possible implementation, the permission configuration module is specifically used to:

[0091] For each of the split cells, a collaboration permission is configured for the split cell according to the cell content in the split cell.

[0092] In a possible implementation manner, the cell splitting module is specifically used for:

[0093] In response to a split operation on a target cell in a table, if it is determined that the current account has permission to perform the split operation on the target cell, the target cell is split to obtain at least two split cells.

[0094] In a possible implementation manner, the cell splitting module is specifically used for:

[0095] In response to a split operation on a target cell in a table, if it is determined that the split operation has an impact on adjacent cells of the target cell, determining whether the current account has a split permission on the target cell and an edit permission on the adjacent cells;

[0096] When it is determined that the current account has the splitting authority for the target cell and the editing authority for the adjacent cell, the target cell is split to obtain at least two split cells.

[0097] In a possible implementation, the device further includes:

[0098] a cell changing module, configured to, after the target cell in the table is split in response to the split operation, split the target cell to obtain at least two split cells, and if it is determined that the split operation has an impact on adjacent cells of the target cell, add a new cell to the table according to the at least two split cells, and determine the cells to be merged;

[0099] The cells to be merged are merged to obtain corresponding merged cells.

[0100] In a possible implementation, the permission configuration module is further used to:

[0101] After merging the cells to be merged to obtain a corresponding merged cell, configuring collaboration permissions for the merged cell.

[0102] In a third aspect, the present application provides an electronic device, comprising: a processor and a memory, wherein the processor is used to execute a table processing program stored in the memory to implement the table processing method described in any one of the first aspects.

[0103] In a fourth aspect, the present application provides a storage medium storing one or more programs, wherein the one or more programs can be executed by one or more processors to implement the table processing method described in any one of the first aspects.

[0104] The above-mentioned technical scheme provided by the embodiment of the present application has the following advantages compared with the prior art: the method provided by the embodiment of the present application, by responding to the split operation of the target cell in the table, splits the target cell to obtain at least two split cells, and configures collaboration permissions for the split cells, thereby realizing effective management of the collaboration permissions of the split cells in the split cell scenario, and ensuring the security and smoothness of table collaboration. BRIEF DESCRIPTION OF THE DRAWINGS

[0105] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.

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

[0107] One or more embodiments are exemplarily described by pictures in the corresponding drawings, and these exemplified descriptions do not constitute limitations on the embodiments. Elements with the same reference numerals in the drawings represent similar elements, and unless otherwise stated, the figures in the drawings do not constitute proportional limitations.

[0108] Figure 1 A flowchart of an embodiment of a table processing method provided in an embodiment of the present application;

[0109] Figure 2 This is an example of setting cell permissions after cells are unmerged in the prior art;

[0110] Figure 3 A flowchart of another table processing method provided in an embodiment of the present application;

[0111] Figure 4 An example of cell layout style;

[0112] Figure 5 A flowchart of another table processing method provided in an embodiment of the present application;

[0113] Figure 6 This is an example diagram of the effect of copying and filling the cell content after splitting the cell provided in an embodiment of the present application;

[0114] Figure 7 An example diagram of the effect of restoring the original cell content after canceling cell merging is provided for an embodiment of the present application;

[0115] Figure 8 This is an example diagram of the effect of filling cell contents after splitting other cells provided in the embodiments of the present application;

[0116] Fig. 9 A flowchart of another table processing method provided in an embodiment of the present application;

[0117] Fig.10 A flowchart of another table processing method provided in an embodiment of the present application;

[0118] Fig.11 A flowchart of another table processing method provided in an embodiment of the present application;

[0119] Fig.12 A schematic diagram of the effect of adaptively adjusting the table layout structure after splitting cells provided in an embodiment of the present application;

[0120] Fig.13 A block diagram of an embodiment of a table processing device provided in an embodiment of the present application;

[0121] Fig.14A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0122] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of this application.

[0123] The disclosure below provides many different embodiments or examples to realize the different structures of the present application. In order to simplify the disclosure of the present application, the parts and settings of specific examples are described below. Of course, they are only examples, and the purpose is not to limit the present application. In addition, the present application can repeat reference numbers and / or letters in different examples. This repetition is for the purpose of simplification and clarity, and does not itself indicate the relationship between the various embodiments and / or settings discussed.

[0124] In order to solve the technical problem in the prior art that when splitting cells, cells are only split without considering the permission configuration of the split cells, which is likely to destroy the collaborative security of the table, the present application provides a table processing method, device, electronic device and storage medium, which can effectively manage the collaborative permissions of the split cells in the cell splitting scenario, thereby ensuring the security and smoothness of table collaboration.

[0125] Figure 1 A flowchart of an embodiment of a table processing method provided in an embodiment of the present application.

[0126] like Figure 1 As shown, the process includes the following steps:

[0127] Step 101: In response to a split operation on a target cell in a table, the target cell is split to obtain at least two split cells.

[0128] The above-mentioned table can be any table, which can be a table in a traditional format, such as a table in .xls, .xlsx and other formats, or a new generation of smart table, online table, and the embodiment of the present application does not limit this.

[0129] From the perspective of access methods, the above-mentioned table can be a collaborative document, which allows multiple users to collaboratively edit it online, or allows multiple users to spread it to each other through mobile storage media (such as USB flash drives) to collaboratively edit it. Taking online collaborative editing as an example, there are currently two different document collaboration methods, namely online collaborative documents and collaborative documents within a local area network. Among them, online collaborative documents are a way to share and edit documents through the Internet, store documents on a cloud server, allow multiple users to access, edit and comment on documents at the same time, and provide real-time collaboration and communication functions. Collaborative documents within a local area network refer to a method in which multiple users can edit and modify the same document in a local area network by sharing folders or using professional collaborative editing software. The table in the embodiment of the present application can be any of the above-mentioned collaborative documents, and the embodiment of the present application does not limit this.

[0130] The target cell refers to the cell to be split, which can be any cell in the table. The target cell can be a merged cell, that is, a cell formed by merging at least two consecutive independent cells in the table, or an independent cell. This embodiment of the application does not limit this.

[0131] In one embodiment, the user can select the target cell to be split in the table by operating the mouse or by inputting the cell position information, and then trigger the split operation on the selected target cell. For example, the cell position information input by the user is B7, which means that the cell at the 7th row and the B column in the table is the target cell to be split. Afterwards, the user triggers the split operation on the selected target cell by triggering the split cell icon in the table toolbar. In response to the split operation on the target cell, the target cell is split to obtain at least two split cells.

[0132] As for how to split the target cell to obtain at least two split cells, it will be explained in detail in the following through different embodiments, and will not be described in detail here.

[0133] Step 102: Configure collaboration permissions for at least two split cells.

[0134] In the technical solution of the embodiment of the present application, different permission collaboration areas can also be set for different collaboration accounts in the table, that is, different collaboration accounts can edit the corresponding permission collaboration areas in the table respectively. In other words, different areas in the table can have different collaboration permissions. Here, the area in the table can be an area formed by one or more cells. For example, a cell in a table can form an area, and for another example, cells in a row (or column) or certain rows (or columns) in a table can form an area. The embodiment of the present application does not limit the division of areas in the table. Collaboration on the table includes but is not limited to: editing, commenting or viewing, etc.

[0135] On this basis, as an exemplary application scenario, the target cell is originally configured with collaboration permissions. If the target cell is simply split without considering the permission configuration of the split cells, the originally protected cell content may be exposed to users who should not access the content, thereby destroying the collaborative security of the table. For example, see Figure 2 For example, cell A1 and cell B1 are merged to form cell 1, and the configured collaboration permission is: cell A1 can only be edited by user A (which also means that cell 1 can only be edited by user A). After canceling the merge of cell A1 and cell B1, the original collaboration permission is still retained: cell A1 can only be edited by user A. However, cell B1 does not have any permission configuration, so cell B1 can be edited by anyone. At this time, if the split cell B1 contains all or part of the content of cell 1, the content in cell 1 will be exposed to other users except user A, thereby destroying the collaboration security of the table.

[0136] In this regard, it can be seen from the description of step 102 that in the technical solution of the embodiment of the present application, after the target cell is split, the collaboration permission is configured for the split cell. Therefore, after the cell is split, the collaborative access to the split cell can be reasonably controlled, thereby ensuring the security and smoothness of the table collaboration.

[0137] As for how to configure collaboration permissions for the split cells, illustrative explanations are given below through different embodiments, which will not be described in detail here.

[0138] The technical solution provided in the embodiment of the present application, by responding to a split operation on a target cell in a table, splits the target cell to obtain at least two split cells, and configures collaboration permissions for the split cells, thereby effectively managing the collaboration permissions of the split cells in the split cell scenario and ensuring the security and smoothness of table collaboration.

[0139] In the technical solution of the embodiment of the present application, the target cell splitting process involves changes or settings in the following three aspects: cell layout, cell content, and cell permissions. Among them, the change of cell layout is the inevitable result of cell splitting, and in the technical solution of the embodiment of the present application, the change or setting of cell permissions is also an inevitable operation in the cell splitting scenario. In order to better understand the technical solution of the embodiment of the present application, the specific implementation of the above three aspects is explained below:

[0140] 1. Cell layout

[0141] Figure 3 A flowchart of another table processing method provided in an embodiment of the present application. Figure 3 The process shown in Figure 1 Based on the process shown in the figure, describe how to split the cell. Figure 3 As shown, the process includes the following steps:

[0142] Step 301: In response to a split operation on a target cell in a table, obtain cell layout information indicated by the split operation.

[0143] Step 302: Split the target cell according to the cell layout information to obtain at least two split cells.

[0144] The cell layout information indicated by the above split operation includes but is not limited to the number of rows and columns of the split cells, the size of the split cells, and other information.

[0145] In one embodiment, the target cell is a merged cell. The merged cell can be restored to multiple independent cells before merging through a split operation, which also means canceling the previous merged cell state. For example, the target cell is a merged cell formed by merging cells B7 and B8. Here, in response to the split operation on the merged cell, the merged cell can be split again into cells B7 and B8.

[0146] In this regard, as an optional implementation, in step 301, in response to the split operation of the target cell in the table, the specific implementation of obtaining the cell layout information indicated by the split operation includes: in response to the split operation of the target cell in the table, obtaining the original cell layout information of the target cell, the original cell layout information refers to the layout information of at least two original cells that are merged to form the target cell, including but not limited to the position (such as the number of rows and columns), size (width and height), alignment and other information of the original cells. ; Determine the original cell layout information as the cell layout information indicated by the split operation. Afterwards, the target cell can be split according to the cell layout information indicated by the split operation (that is, the original cell layout information of the multiple independent cells before the merger) to restore the target cell to the multiple independent cells before the merger.

[0147] Optionally, the above-mentioned response to the splitting operation of the target cell in the table refers to: responding to the selection operation of the target cell in the table and the triggering operation of the "Cancel Merge" function icon in the table toolbar. That is to say, when the user selects the merged cell in the table as the target cell to be split and triggers the "Cancel Merge" function icon in the table toolbar, the execution subject of the embodiment of the present application will restore the target cell to multiple independent cells before the merger according to the above-mentioned implementation method.

[0148] The above embodiment can ensure the consistency of the cell layout before merging and after canceling the merging by restoring the target cell to an independent cell before merging, which helps to maintain the smoothness of table collaboration.

[0149] In another embodiment, the target cell is a merged cell. The merged cell can also be flexibly split, and is not limited to restoring to multiple independent cells before the merger. For example, the target cell is a merged cell formed by merging cell B7 and cell B8. Here, in response to the split operation on the merged cell, the merged cell can be split into cells with three rows and one column, that is, three cells, or the merged cell can be split into cells with two rows and two columns, that is, four cells, or the merged cell can be split into cells with three rows and two columns, that is, six cells. Alternatively, the target cell is an independent cell, and flexible cell splitting can also be performed.

[0150] In this regard, as an optional implementation, when the user triggers a split operation on the target cell, the user can input the number of rows and columns of the split cell through the human-computer interaction interface. Here, the cell layout information indicated by the split operation on the target cell includes the number of rows and columns input by the user. Thus, the execution subject of the embodiment of the present application will split the target cell according to the number of rows and columns specified by the user, and obtain the split cell with the specified number of rows and columns.

[0151] As another optional implementation, when the user triggers the split operation on the target cell, the user can select the layout style of the split cell through the human-computer interaction interface. The layout style of the split cell refers to the appearance of the split cell, including but not limited to the number of rows and columns of the split cell, the position relationship between cells, border style and other visual aspects. For example, see Figure 4 , an example of a cell layout style. It can be said that the layout style presented by the cell is the appearance of the cell layout information, and when the layout information is adjusted, the layout style will also change synchronously.

[0152] Here, the cell layout information indicated by the split operation on the target cell includes the cell layout style selected by the user. Thus, the execution subject of the embodiment of the present application will split the target cell according to the cell layout style selected by the user to obtain the split cells that conform to the cell layout style.

[0153] The above-mentioned embodiments help to meet the complex application needs of users in various scenarios and improve the user experience by supporting flexible splitting of merged cells.

[0154] In another embodiment, the target cell is an independent cell or a merged cell, and the target cell has cell content. The target cell can be intelligently split based on the cell content.

[0155] As an optional implementation method, in step 301, in response to a split operation on a target cell in a table, the specific implementation of obtaining the cell layout information indicated by the split operation includes: in response to a split operation on a target cell in a table, obtaining the cell content in the target cell; splitting the cell content according to a preset splitting rule to obtain at least two split contents; and determining the cell layout information that conforms to the split contents as the cell layout information indicated by the split operation.

[0156] Optionally, the preset splitting rule may be splitting according to a preset delimiter, splitting according to a preset character interval, splitting according to character type, splitting according to content type, splitting by line, splitting according to content semantic analysis, and the like.

[0157] The preset delimiter can be a preset character, which can be used as the basis for splitting the string, and can be set to characters such as commas, dashes, semicolons, and line breaks. For example, if the cell content in the target cell is "abc-def-g" and the preset delimiter is "-", the content after splitting includes: "abc" "def" "g".

[0158] Among them, the preset character interval refers to the splitting basis according to the character number distribution law. For example, if the preset character interval is two characters, the interval between every two characters is used as the content after splitting. For example, the cell content in the target cell is "abcdefg". After splitting according to the preset character interval of two characters, the content after splitting includes: "ab" "cd" "ef" "g". For another example, the preset character interval indicates a character spacing law. Then the cell content is split according to the character spacing law to obtain the content after splitting. For example, the cell content in the target cell is "abcdefg", and the character spacing law is the character number distribution law of one character and two characters. After splitting the cell content according to the character spacing law, the content after splitting includes: "a" "bc" "d" "ef" "g".

[0159] The splitting by character type is to split characters of different character types into different split contents, and the character type may include at least one of the following: number type, letter type, punctuation type, Chinese type, etc. For example, if the cell content in the target cell is "abc123defg", after splitting by character type, the split contents include: "abc", "123", "defg".

[0160] The splitting by content type is to split the contents of different content types into different split contents, and the content type may include at least one of the following: picture, string, link, video, etc. For example, the cell content in the target cell is "

Picture

Picture

Picture

[0161] Among them, splitting by line can be similar to splitting by newline characters.

[0162] Among them, splitting by content semantic analysis refers to performing semantic analysis on the cell content in the target cell and determining to split the cell content into multiple split contents. For example, the cell content in the target cell is "first, ...; second, ...; third, ...;", and after splitting by content semantic analysis, the split contents include: "first, ...;" "second, ...;" "third, ...;". Specifically, one implementation method is to construct a prompt word including the cell content in the target cell, the prompt word also includes a natural language for indicating the splitting principle, and input the constructed prompt word into a pre-trained artificial intelligence model for processing to obtain the split content.

[0163] The cell layout information that conforms to the content after splitting refers to the layout information of the cell layout that can arrange each content after splitting respectively. As an optional implementation method, the number of the content after splitting can be determined first, and the number can be used as the number of cells obtained by splitting, and then the layout of these cells can be determined according to the number of cells. For example, when the number of cells is relatively small, these cells can be laid out in 1 row or 1 column, and when the number of cells is relatively large, these cells can be laid out in multiple rows and columns. Among them, the number of cells can be measured by setting a threshold, and the corresponding relationship between the number of cells and the cell layout can be pre-set, and then the layout of the cells can be determined according to the corresponding relationship. For example, the content after splitting includes 3, assuming that the threshold is set to 4, then the layout of the cells obtained by the 3 splits is determined to be laid out in 1 row or 1 column. For another example, the content after splitting includes 6, and assuming that the layout corresponding to the number of cells is 6 is 3 rows and 2 columns, then the layout of the cells obtained by splitting is determined to be laid out in 3 rows and 2 columns.

[0164] Thus, the cell layout information that conforms to the split content can be obtained, and the cell layout information is determined as the cell layout information indicated by the split operation.

[0165] In another embodiment, the target cell is an independent cell. Independent cells can also be flexibly split. For example, cell B7 is split into cells of multiple rows and one column, or cells of one row and multiple columns, or cells of multiple rows and multiple columns.

[0166] In this regard, as an optional implementation, when the user triggers a split operation on the target cell, the user can input the number of rows and columns of the split cell through the human-computer interaction interface. Here, the cell layout information indicated by the split operation on the target cell includes the number of rows and columns input by the user. Thus, the execution subject of the embodiment of the present application will split the target cell according to the number of rows and columns specified by the user, and obtain the split cell with the specified number of rows and columns.

[0167] As another optional implementation, when the user triggers the split operation on the target cell, the user can select the layout style of the split cell through the human-computer interaction interface. Here, the cell layout information indicated by the split operation on the target cell includes the cell layout style selected by the user, for example, see Figure 4 , the user selects cell layout style 1, then the cell layout style 1 is determined as the cell layout information indicated by the split operation. Thus, the execution subject of the embodiment of the present application will split the target cell according to the cell layout style selected by the user, and obtain the split cells that conform to the cell layout style.

[0168] Figure 3 The illustrated embodiment, in response to a split operation on a target cell in a table, obtains the cell layout information indicated by the split operation, splits the target cell according to the cell layout information, and obtains at least two split cells, thereby flexibly handling the splitting of merged cells and independent cells.

[0169] 2. Cell Content

[0170] Figure 5 A flowchart of another embodiment of a table processing method provided in an embodiment of the present application. Figure 5 The process shown in Figure 1 Based on the process shown in FIG. 1 , the processing of the cell content after the target cell is split is described. Figure 5 As shown, the process includes the following steps:

[0171] Step 501: In response to a split operation on a target cell in a table, the target cell is split to obtain at least two split cells.

[0172] Step 502: Fill at least two split cells with cell content according to the split operation.

[0173] In one embodiment, no matter the target cell is a merged cell or an independent cell, after the target cell is split into at least two cells, the content in the original target cell can be copied and filled into each of the split cells. Figure 6 .

[0174] In this regard, in this embodiment, the specific implementation of filling the cell content for at least two split cells according to the split operation includes: according to the split operation, copying the cell content of the target cell to fill each split cell.

[0175] The above embodiment can highly ensure the consistency of the cell contents in the cells before and after the splitting by copying the cell contents of the target cell and filling them into each split cell, which helps to maintain the smoothness of table collaboration.

[0176] In another embodiment, the target cell is a merged cell. For the merged cell, on the basis of restoring it to multiple independent cells before merging through the split operation, the cell content in the split cell can also be restored to the cell content in the independent cell before merging. For example, see Figure 7 .

[0177] In this regard, in this embodiment, the specific implementation of filling cell content for at least two split cells according to the split operation includes: obtaining the original cell content in the original cell corresponding to the target cell, the original cell refers to the cell merged to form the target cell; filling the corresponding original cell content for each split cell.

[0178] Optionally, the execution subject of the embodiment of the present application can record the cell content and changes to the cell content in the table in the form of logs, copies, or collaborative records, etc. This can achieve the above-mentioned ability to obtain the original cell content in the cell before the merge when the merged cell is unmerged.

[0179] The above embodiment can ensure the consistency of cell content before merging and after canceling the merge by restoring the target cell to the independent cell before merging, thereby restoring the cell content in the split cell to the cell content in the independent cell before merging. This helps to maintain the smoothness of table collaboration.

[0180] In another embodiment, no matter the target cell is a merged cell or an independent cell, the split cell can be flexibly filled with content, and if the target cell is a merged cell, even if the merged cell is restored to multiple independent cells before merging, the split cell can be flexibly filled with content. Figure 8 In the example of (a), the cell content in the target cell is filled into the cell in the first row and first column after the split, and no content is filled into other cells (cells other than the cells in the first row and first column after the split). That is, in this embodiment, the cell content of the target cell can be filled into the cell specified by the user after the split according to the split operation. For another example, see Figure 8In the example of (b), the cell content in the target cell is "abcdefg", and the cell content is split by row and filled into the split cells respectively. Here, the content after splitting by row can also be filled into the corresponding specified split cells respectively.

[0181] In another embodiment, when the user triggers the split operation on the target cell, the user can set the content filling rule through the human-computer interaction interface. The content filling rule can be used to specify the specific way to fill the split content into the split cell, such as specifying the number of fillings, the filling order, etc. Specifically, for example, copying the content twice in sequence to fill (see Figure 8 (b) Example), copy the cell content to fill each split cell (corresponding to Figure 6 ), cancel the merge and restore the original cell content (corresponding to Figure 7 ), copy only the cell contents to fill the first row and first column of the split cell (see Figure 8 (a) example), splitting the cell content according to the preset splitting rules and then filling the split cells according to the preset content filling rules, etc., which will not be given one by one here.

[0182] Therefore, the execution subject of the embodiment of the present application will fill the split cells with cell content according to the content filling rules specified by the user.

[0183] Optionally, the above content filling rules can be preset, such as presetting multiple content filling rules. When the user triggers the split operation on the target cell, the user selects the currently required content filling rule from the preset multiple content filling rules. Furthermore, the user can also customize the content filling rules according to actual needs, so as to achieve more flexible content filling of the split cells.

[0184] Among them, for the case where the cell content is split according to the preset splitting rule and then filled into the split cells, the splitting rule can be split according to the preset delimiter, split according to the preset character interval, split according to the character type, split according to the content type, split according to the line, split according to the content semantic analysis, etc. Afterwards, the content split according to the preset splitting rule is filled into the split cells according to the content rule.

[0185] It can also be seen from the above examples that in the technical solution of the embodiments of the present application, when the user triggers a split operation on the target cell, the user can set content filling rules through the human-computer interaction interface to trigger the execution subject of the embodiments of the present application to execute the post-split cell content filling solution provided by one of the above embodiments to fill the post-split cell content.

[0186] In addition, the above-mentioned flexible filling of the split cells with content also includes the user filling the split cells with customized content according to actual needs, rather than being limited to the cell content in the target cell. For example, the cell content in the target cell is "abcdefg", and after the target cell is split into two cells, the user enters "h" and "s" in the two cells respectively through the human-computer interaction interface and the input device.

[0187] Figure 5 In the illustrated embodiment, in response to a split operation on a target cell in a table, the target cell is split to obtain at least two split cells, and cell contents are filled into at least two split cells according to the split operation, so that merged cells and independent cells can be flexibly filled with cell contents after splitting.

[0188] 3. Cell Permissions

[0189] In one embodiment, after the target cell is split into at least two cells, the collaboration permissions of the split cells can be configured to be consistent with the original target cell. For example, the collaboration permissions of the original target cell are: only user A can view. Then, after the target cell is split to obtain at least two split cells, the collaboration permissions of each split cell can be configured to: only user A can view.

[0190] In this regard, in this embodiment, the specific implementation of configuring collaboration permissions for at least two split cells includes: obtaining the target collaboration permission configuration information of the target cell, and configuring collaboration permissions for each split cell according to the target collaboration permission configuration information. Among them, the target collaboration permission configuration information refers to the collaboration permission configuration information of the target cell, which is referred to as the target collaboration permission configuration information here for the convenience of description. Among them, the collaboration permission configuration information refers to the descriptive information for allocating and managing collaboration permissions for different users or user groups, and the collaboration permissions include but are not limited to access, edit, view, comment, share and other permissions. Furthermore, editable permissions may include but are not limited to the following permissions: inserting hyperlinks, setting cell formats, setting column formats, setting row formats, using automatic filtering, editing objects (including pictures, comments, etc.), and the like.

[0191] The above embodiment can ensure the consistency of collaboration permissions before and after cell splitting by configuring collaboration permissions consistent with the original target cell for the split cell after splitting the target cell into at least two cells, which helps maintain the security of the table and the smoothness of table collaboration.

[0192] In another embodiment, the target cell is a merged cell. For merged cells, on the basis of restoring them to multiple independent cells before the merger through a split operation, the collaboration permissions of the split cells can also be restored to the collaboration permissions of the independent cells before the merger. For example, the collaboration permissions of cell 1 are viewable only by user A, and the collaboration permissions of cell 2 are editable only by user A, and other users can view them. Assuming that cell 1 and cell 2 are merged to obtain a merged cell, and then the merged cell is split and restored to the original cell 1 and cell 2, regardless of the collaboration permissions of the merged cell, the collaboration permissions of cell 1 can be reconfigured to be viewable only by user A, and the collaboration permissions of cell 2 can be reconfigured to be editable only by user A, and other users can view them.

[0193] In this regard, in this embodiment, when the target cell is a merged cell, the specific implementation of configuring collaboration permissions for at least two split cells includes: obtaining the original collaboration permission configuration information of the original cell corresponding to the target cell, and for each split cell, configuring collaboration permissions for the split cell according to the original collaboration permission configuration information of the original cell corresponding to the split cell.

[0194] The above-mentioned embodiment can ensure the consistency of collaboration permissions of cells before merging and after canceling the merge by splitting the merged cells and restoring them into multiple independent cells before the merge, thereby helping to maintain the security of the table and the smoothness of table collaboration.

[0195] In another embodiment, regardless of whether the target cell is a merged cell or an independent cell, the collaboration permissions of the split cells can be flexibly configured as needed. For example, the collaboration permission of cell 1 is viewable only by user A, and the collaboration permission of cell 2 is editable only by user A, and other users can view it. Assuming that cell 1 and cell 2 are merged to obtain a merged cell, after which the merged cell is split and restored to the original cell 1 and cell, the collaboration permission of cell 1 can be reconfigured to be viewable by all users, and the collaboration permission of cell 2 can be reconfigured to be viewable only by user B. It can be seen that there is no constraint relationship between the collaboration permission of the cell after the cell merger is cancelled and the collaboration permission before the cell merger. For another example, the collaboration permission of cell 1 is viewable only by user A. When cell 1 is split into cell 11 and cell 12, the collaboration permission of cell 11 can be configured to be viewable by all users, and the collaboration permission of cell 12 can be configured to be viewable only by user B. It can be seen that there may also be no constraint relationship between the collaboration permission of the split cell and the collaboration permission of the target cell before the split.

[0196] In this regard, in this embodiment, the specific implementation of configuring the collaboration permissions for the at least two split cells includes: in response to the permission configuration operation on the at least two split cells, configuring the collaboration permissions for the at least two split cells.

[0197] As an optional implementation method, the user can perform permission configuration operations on at least two split cells through the human-computer interaction interface. Optionally, the user can directly input the collaboration permissions that he wants to set for the split cells through the human-computer interaction interface. Or, through the human-computer interaction interface, select the currently required collaboration permission configuration rules from the preset collaboration permission configuration rules.

[0198] Exemplarily, the execution subject of the embodiment of the present application can output some preset collaborative account sets on the human-computer interaction interface, and provide a collaborative permission setting function. The collaborative account set includes, for example: a set of all collaborative accounts of a table, a set of collaborative accounts of a target cell, and so on. Thus, the user can assign collaborative accounts to the split cells, and then set specific collaborative permissions for the assigned collaborative accounts. For example, if the user selects the set of collaborative accounts of the target cell and sets the collaborative permissions to editable, then the collaborative permissions will be set for the split cells: only the collaborative accounts of the target cell can be edited. This enables the user to assign multiple collaborative accounts to the split cells with one click. Of course, in actual applications, the user can also specify any collaborative account in a set or different sets as needed, and the embodiment of the present application does not limit this. In addition, referring to the above description, it can be seen that the editable permissions can be further subdivided into a variety of different permissions. Therefore, when the collaborative permissions are set to editable for the selected collaborative account, one or more permissions can be further selected from the editable permission set. This realizes more detailed permission management and can meet the complex scenario requirements of users.

[0199] The above embodiment can be applied to various scenarios by flexibly configuring the collaboration permissions of the split cells as needed after splitting the target cell into at least two cells, thereby meeting the complex needs of users in various scenarios and improving the user experience.

[0200] In yet another embodiment, no matter the target cell is a merged cell or an independent cell, the collaboration permission can be configured for the split cell according to the cell content in the split cell.

[0201] In an exemplary application scenario, the target cell is a merged cell. For the merged cell, after the split operation is performed to restore it to multiple independent cells before the merge, and the cell content in the split cells is also restored to the cell content in the independent cells before the merge, the collaboration permissions of the split cells are also restored to the collaboration permissions of the independent cells before the merge by default.

[0202] In another exemplary application scenario, the target cell is a merged cell. For the merged cell, after the split operation is performed to restore it to multiple independent cells before the merger, and the cell content in the merged cell is copied and filled into each cell after the split, the collaboration permission is configured for each cell after the split according to the collaboration permission of the target cell by default.

[0203] In another exemplary application scenario, the target cell is an independent cell. For the independent cell, after the independent cell is split into at least two cells by a split operation, and the cell content in the target cell is copied and filled into each of the split cells, the collaboration permission is configured for each of the split cells by default according to the collaboration permission of the target cell.

[0204] In another exemplary application scenario, if the cell content in the split cell includes a cloud document link, the collaboration permission of the cloud document link can be obtained, and the collaboration permission of the split cell can be configured according to the collaboration permission of the cloud document link.

[0205] For example, if the collaboration permission of the cloud document link is that only user A can view it, then the collaboration permission of the split cell is configured to be that only user A can view it.

[0206] The above embodiment can ensure the consistency of the collaboration permissions of the cell content itself and the collaboration permissions of the cell in which it is located by setting the collaboration permissions of the split cell according to the cell content in the split cell after splitting the target cell, which helps to maintain the security of the table content and the smoothness of the table collaboration.

[0207] The above explanations respectively explain the changes or settings of the three aspects of cell layout, cell content and cell permissions involved in the cell splitting process. Based on the above explanations, the following examples are given to automatically set cell content and cell permissions in the cell splitting scenario:

[0208] In one embodiment, the target cell is a merged cell, and on the basis of restoring the target cell to multiple independent cells before the merger through a split operation, the cell content in the split cell is automatically restored to the cell content in the independent cell before the merger, and the collaboration permissions of the split cell are automatically restored to the collaboration permissions of the independent cell before the merger.

[0209] For this, see Fig. 9 , is a flow chart of another embodiment of a table processing method provided in the present application. Fig. 9 As shown, the following steps are included:

[0210] Step 901: In response to a split operation on a merged cell, original cell layout information of the merged cell is obtained.

[0211] Step 902: split the merged cell according to the original cell layout information of the merged cell to obtain at least two split cells.

[0212] Step 903: Get the original cell content in the original cell corresponding to the merged cell, and fill each split cell with the corresponding original cell content.

[0213] Step 904: Obtain the original collaboration permission configuration information of the original cell corresponding to the target cell, and for each split cell, configure collaboration permissions for the split cell according to the original collaboration permission configuration information of the original cell corresponding to the split cell.

[0214] For example, the cell content in cell 1 is "h", and the collaboration permission is: only user A can view; the cell content in cell 2 is "s", and the collaboration permission is: only user B can view. Then merge cell 1 and cell 2 to obtain a merged cell. Afterwards, the split operation triggered on the merged cell is performed in accordance with the description of steps 901 to 904 above, and the merged cell is split again into cell 1 and cell 2, and the original cell content "h" in cell 1 is restored, and the original collaboration permission of cell 1 is restored: only user A can view. Similarly, the original cell content "s" in cell 2 is restored, and the original collaboration permission of cell 2 is restored: only user B can view.

[0215] Fig. 9The illustrated embodiment, in response to a split operation on merged cells in a table, restores the merged cells to independent cells before the merge, restores the cell contents in the split cells to the cell contents in the independent cells before the merge, and configures collaboration permissions for the split cells that are consistent with those of the cells before the merge. This ensures the consistency of cell contents and cell permissions before and after the merge, which helps maintain the security and smoothness of table collaboration.

[0216] In another embodiment, the target cell is a merged cell. On the basis of restoring the target cell to multiple independent cells before the merger through a split operation, the cell content in the target cell is automatically copied and filled into each cell after the split, and the collaboration permissions are automatically set for each cell after the split according to the collaboration permissions of the target cell.

[0217] For this, see Fig.10 , is a flow chart of another embodiment of a table processing method provided in the present application. Fig.10 As shown, the following steps are included:

[0218] Step 1001: In response to a split operation on a merged cell, original cell layout information of the merged cell is obtained.

[0219] Step 1002: split the merged cell according to the original cell layout information of the merged cell to obtain at least two split cells.

[0220] Step 1003: Copy the cell content of the target cell and fill it into each split cell.

[0221] Step 1004: Obtain target collaboration permission configuration information of the target cell, and configure collaboration permissions for each split cell according to the target collaboration permission configuration information.

[0222] For example, the cell content in cell 1 is "h", and the collaboration permission is: only user A can view; the cell content in cell 2 is "s", and the collaboration permission is: only user B can view. Then, cell 1 and cell 2 are merged to obtain a merged cell, the cell content in the merged cell is "h", and the collaboration permission for the merged cell is set to: only user A can view. Afterwards, the split operation triggered on the merged cell is described in steps 801 to 804 above, and the merged cell is split again into cell 1 and cell 2, and the cell content "h" in the merged cell is copied and filled into cell 1 and cell 2 respectively, and the collaboration permissions of cell 1 and cell 2 are set to: only user A can view.

[0223] Fig.10 The illustrated embodiment, in response to a split operation on a merged cell in a table, restores the merged cell to an independent cell before the merge, copies and fills the cell content in the merged cell into each cell after the split, and configures collaboration permissions that are consistent with the merged cell for each cell after the split. This ensures the consistency of the cell content and cell permissions of the merged cell after the merge is unmerged, which helps maintain the security and smoothness of table collaboration.

[0224] In another embodiment, the target cell is an independent cell, and based on the splitting operation to split the independent cell into at least two cells, the cell content in the target cell is automatically copied and filled into each of the split cells, and the collaboration permissions are automatically set for each of the split cells according to the collaboration permissions of the target cell.

[0225] For this, see Fig.11 , is a flow chart of another embodiment of a table processing method provided in the present application. Fig.11 As shown, the following steps are included:

[0226] Step 1101: In response to a split operation on a target cell, the target cell is split to obtain at least two split cells.

[0227] Step 1102: Copy the cell content of the target cell and fill it into each split cell.

[0228] Step 1103: Obtain target collaboration permission configuration information of the target cell, and configure collaboration permissions for each split cell according to the target collaboration permission configuration information.

[0229] For example, the cell content in cell 1 is "h", and the collaboration permission is: only user A can view. Then, cell 1 is split into cell 11 and cell 12. According to the description of steps 1101 to 1103 above, the cell content "h" in cell 1 is copied and filled into cells 11 and 12 respectively, and the collaboration permissions of cells 11 and 12 are set to: only user A can view.

[0230] Fig.11 The illustrated embodiment splits the cell in response to a split operation on a cell in a table, and copies the cell content in the cell to fill each of the split cells, and configures collaboration permissions consistent with the cell for each of the split cells. This ensures the consistency of the cell content and cell permissions before and after the cell split, which helps maintain the security and smoothness of table collaboration.

[0231] Based on any of the above embodiments, the present application also provides the following embodiments:

[0232] In one embodiment, in response to a split operation on a target cell in a table, splitting the target cell to obtain at least two split cells includes: in response to a split operation on a target cell in a table, splitting the target cell to obtain at least two split cells when it is determined that the current account has permission to perform a split operation on the target cell.

[0233] The current account refers to the currently logged-in account, that is, the account initiating the split operation. It can be seen that in this embodiment, the split cell operation triggered by the user is also subject to permission verification. If it is determined that the current account has the permission to perform the split operation on the target cell, the target cell is split to obtain at least two split cells. On the contrary, if it is determined that the current account does not have the permission to perform the split operation on the target cell, the split operation on the target cell is refused.

[0234] Optionally, the current account has the permission to split the target cell, including but not existing in the following situations: the current account is the creator of the table. Normally, the creator of the table has all permissions to the table and can perform all reasonable operations on the table; the current account is granted editing permissions to any cell in the table by the creator of the table; the current account is granted editing permissions to the target cell; the current account is granted the permission of the collaborative account that manages the document to the document collaboration permissions, that is, the current account can set the collaboration permissions of the collaborative account of the document; the current account has editing permissions to the target cell, etc.

[0235] The above embodiments help prevent unauthorized users from making inappropriate modifications to the table, and help maintain the integrity of the table data, especially in a team collaboration environment where different users may have different roles and permissions. Through the permission verification mechanism in the above embodiments, it can be ensured that users can only operate on the table within their permissions, thereby avoiding work conflicts and unnecessary coordination costs. This helps to improve the smoothness of team collaboration.

[0236] In practical applications, splitting a target cell in a table may affect the adjacent cells of the target cell.

[0237] In this embodiment, when it is determined that the cell layout information indicated by the split operation needs to increase the number of rows and columns of the table, it can be determined that splitting the target cell in the table will affect the neighboring cells of the target cell. For example, the number of rows and columns occupied by the target cell in the table is the first number of rows and the first number of columns, and the cell layout information indicated by the split operation indicates the second number of rows and the second number of columns. When the second number of rows is greater than the first number of rows, and / or the second number of columns is greater than the first number of columns, it is determined that the cell layout information indicated by the split operation needs to increase the number of rows and columns of the table, that is, it can be determined that splitting the target cell in the table will affect the neighboring cells of the target cell.

[0238] For example, see Fig.12 In the example of , if cell 3 is split into two rows and two columns of cells (including cells 31, 32, 33, and 34), the layout of cells 1 and 4 in the table will be affected, which will affect the beauty of the overall layout structure of the table and the readability of the table (see Fig.12 (Example of an intermediate state in the splitting effect).

[0239] In this regard, in one embodiment, in response to a split operation on a target cell in a table, the target cell is split to obtain at least two split cells, and it also includes: when it is determined that the split operation has an impact on adjacent cells of the target cell, a new cell is added to the table based on the at least two split cells, and the cells to be merged are determined; the cells to be merged are merged to obtain corresponding merged cells.

[0240] For example, in response to Fig.12 The split operation of cell 3 in the example is to split cell 3 into two rows and two columns, and add a cell on one side of cell 1 (such as the right side), and determine cell 1 and the added cell as cells to be merged, and add a cell on one side of cell 4 (such as the bottom), and determine cell 4 and the added cell as cells to be merged. The two cells to be merged are merged to obtain the corresponding merged cell. So far, we have Fig.12 The example shows the final effect of the table split.

[0241] Combination Fig.12 From the example, the above embodiment helps to improve the flexibility and dynamism of the table, and can avoid the split cell from having a significant impact on the layout of other cells in the table and even the overall layout structure of the table, thereby affecting the visual effect of the overall layout of the table.

[0242] On this basis, the technical solution of this application also proposes the following embodiments:

[0243] In response to a split operation on a target cell in a table, the target cell is split to obtain at least two split cells. The specific implementation includes: in response to a split operation on a target cell in a table, when it is determined that the split operation has an impact on adjacent cells of the target cell, determining whether the current account has the permission to split the target cell and whether it has the permission to edit adjacent cells; when it is determined that the current account has the permission to split the target cell and has the permission to edit adjacent cells, splitting the target cell to obtain at least two split cells.

[0244] For example, in response to Fig.12 The split operation of cell 3 in the example above affects the adjacent cells of cell 3 (including cell 1 and cell 4). Therefore, it is determined whether the current account has the split permission for cell 3 and the edit permission for cell 1 and cell 4. Cell 3 is split only when it is determined that the current account has the split permission for cell 3 and the edit permission for cell 1 and cell 4. If it is determined that the current account does not have the split permission for cell 3 or does not have the edit permission for cell 1 and / or cell 4, the split operation for cell 3 is rejected.

[0245] The above embodiment can ensure that unauthorized users are prevented from modifying the layout structure of the table, which helps to maintain the integrity of the table data and avoid work conflicts and unnecessary coordination costs in team collaboration scenarios, which helps to improve the smoothness of team collaboration.

[0246] In addition, in one embodiment, after merging the cells to be merged to obtain the corresponding merged cell, the method further includes: configuring collaboration permissions for the merged cell.

[0247] As an optional implementation, since the newly added cells and merged cells described above are affected by the splitting of the target cells and have nothing to do with the content of the cells themselves and the collaboration permissions of the cells themselves, the collaboration permissions for the merged cells can be configured according to the collaboration permissions of the original cells. Fig.10 The collaboration permission of the original cell 1 is: only user A can view it. After the layout of cell 1 is changed due to splitting cell 3, the collaboration permission of the changed cell 1 is still: only user A can view it.

[0248] The above processing method can maintain the consistency and rationality of cell collaboration permissions and avoid unnecessary permission conflicts or data security issues.

[0249] Fig.13 This is a block diagram of an embodiment of a table processing device provided in an embodiment of the present application. Fig.13 As shown, the device comprises:

[0250] A cell splitting module 1301 is used for splitting a target cell in a table to obtain at least two split cells in response to a splitting operation on the target cell in the table;

[0251] The permission configuration module 1302 is used to configure the collaboration permission for the at least two split cells.

[0252] In a possible implementation, the cell splitting module 1301 includes:

[0253] A layout information acquisition unit, configured to, in response to a split operation on a target cell in a table, acquire cell layout information indicated by the split operation;

[0254] The layout splitting unit is used to split the target cell according to the cell layout information to obtain at least two split cells.

[0255] In a possible implementation manner, the target cell is a merged cell, and the layout information acquisition unit is specifically used to:

[0256] In response to a split operation on a target cell in a table, original cell layout information of the target cell is acquired, where the original cell layout information refers to layout information of at least two original cells that are merged to form the target cell;

[0257] The original cell layout information is determined as the cell layout information indicated by the split operation.

[0258] In a possible implementation manner, the layout information acquisition unit is specifically used to:

[0259] In response to a split operation on a target cell in a table, obtaining cell content in the target cell;

[0260] Splitting the cell content according to a preset splitting rule to obtain at least two split contents;

[0261] The cell layout information that matches the at least two split contents is determined as the cell layout information indicated by the split operation.

[0262] In a possible implementation manner, the cell splitting module 1301 further includes:

[0263] A content filling unit is used to fill the at least two split cells with cell content according to the split operation.

[0264] In a possible implementation manner, the content filling unit is specifically used to:

[0265] According to the split operation, copy and fill the cell content of the target cell into each of the split cells; or,

[0266] According to the split operation, the cell content of the target cell is filled into the specified split cell; or,

[0267] According to the splitting operation, the split contents obtained according to the splitting rule are filled into the split cells in a manner that complies with the preset content filling rule.

[0268] In a possible implementation manner, the content filling unit is specifically used to:

[0269] In the case where the target cell is a merged cell, obtaining original cell content in an original cell corresponding to the target cell, where the original cell refers to a cell merged to form the target cell;

[0270] Fill each of the split cells with the corresponding original cell content.

[0271] In a possible implementation, the permission configuration module 1302 is specifically used to:

[0272] Obtain target collaboration permission configuration information of the target cell;

[0273] The collaboration authority is configured for each of the split cells according to the target collaboration authority configuration information.

[0274] In a possible implementation, the permission configuration module 1302 is specifically used to:

[0275] Acquire original collaboration permission configuration information of the original cell corresponding to the target cell;

[0276] For each of the split cells, the collaboration permission is configured for the split cell according to the original collaboration permission configuration information of the original cell corresponding to the split cell.

[0277] In a possible implementation, the permission configuration module 1302 is specifically used to:

[0278] In the case where the target cell is a merged cell, obtaining original collaboration permission configuration information of an original cell corresponding to the target cell, where the original cell refers to a cell that is merged to form the target cell;

[0279] For each of the split cells, the collaboration permission is configured for the split cell according to the original collaboration permission configuration information of the original cell corresponding to the split cell.

[0280] In a possible implementation, the permission configuration module 1302 is specifically used to:

[0281] Obtain target collaboration permission configuration information of the target cell;

[0282] The collaboration authority is configured for each of the split cells according to the target collaboration authority configuration information.

[0283] In a possible implementation, the permission configuration module 1302 is specifically used to:

[0284] In response to the permission configuration operation on the at least two split cells, collaboration permissions are configured for the at least two split cells.

[0285] In a possible implementation, the permission configuration module 1302 is specifically used to:

[0286] For each of the split cells, a collaboration permission is configured for the split cell according to the cell content in the split cell.

[0287] In a possible implementation, the cell splitting module 1301 is specifically used for:

[0288] In response to a split operation on a target cell in a table, if it is determined that the current account has permission to perform the split operation on the target cell, the target cell is split to obtain at least two split cells.

[0289] In a possible implementation, the cell splitting module 1301 is specifically used for:

[0290] In response to a split operation on a target cell in a table, if it is determined that the split operation has an impact on adjacent cells of the target cell, determining whether the current account has a split permission on the target cell and an edit permission on the adjacent cells;

[0291] When it is determined that the current account has the splitting authority for the target cell and the editing authority for the adjacent cell, the target cell is split to obtain at least two split cells.

[0292] In a possible implementation, the device further includes:

[0293] a cell changing module, configured to, after the target cell in the table is split in response to the split operation, split the target cell to obtain at least two split cells, and if it is determined that the split operation has an impact on adjacent cells of the target cell, add a new cell to the table according to the at least two split cells, and determine the cells to be merged;

[0294] The cells to be merged are merged to obtain corresponding merged cells.

[0295] In a possible implementation, the permission configuration module 1302 is further used to:

[0296] After merging the cells to be merged to obtain a corresponding merged cell, configuring collaboration permissions for the merged cell.

[0297] like Fig.14 As shown, an embodiment of the present application provides an electronic device, including a processor 111, a communication interface 112, a memory 113 and a communication bus 114, wherein the processor 111, the communication interface 112, and the memory 113 communicate with each other through the communication bus 114.

[0298] Memory 113, used for storing computer programs;

[0299] In one embodiment of the present application, the processor 111 is used to implement the table processing method provided by any one of the aforementioned method embodiments when executing the program stored in the memory 113, including:

[0300] In response to a split operation on a target cell in the table, split the target cell to obtain at least two split cells;

[0301] Collaboration permissions are configured for the at least two split cells.

[0302] An embodiment of the present application further provides a computer-readable storage medium on which a computer program is stored. When the computer program is executed by a processor, the steps of the table processing method provided in any of the aforementioned method embodiments are implemented.

[0303] The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0304] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a general hardware platform, and of course, by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the relevant technology can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0305] It should be understood that the terms used herein are only for the purpose of describing specific example embodiments and are not intended to be limiting. Unless the context clearly indicates otherwise, the singular forms "one", "an" and "said" as used herein may also be meant to include plural forms. The terms "include", "comprise", "contain", and "have" are inclusive, and therefore specify the existence of stated features, steps, operations, elements and / or parts, but do not exclude the existence or addition of one or more other features, steps, operations, elements, parts, and / or combinations thereof. The method steps, processes, and operations described herein are not interpreted as necessarily requiring them to be performed in the specific order described or illustrated, unless the execution order is clearly indicated. It should also be understood that additional or alternative steps may be used.

[0306] The above description is only a specific implementation of the present application, so that those skilled in the art can understand or implement the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein can be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest range consistent with the principles and novel features applied for herein.

Claims

1. A table processing method, characterized in that: The method comprises: In response to a split operation on a target cell in the table, split the target cell to obtain at least two split cells; Collaboration permissions are configured for the at least two split cells.

2. The method according to claim 1, characterized in that In response to the splitting operation on the target cell in the table, the target cell is split to obtain at least two split cells, including: In response to a split operation on a target cell in a table, acquiring cell layout information indicated by the split operation; The target cell is split according to the cell layout information to obtain at least two split cells.

3. The method according to claim 2, characterized in that The target cell is a merged cell, and in response to a split operation on the target cell in the table, obtaining cell layout information indicated by the split operation includes: In response to a split operation on a target cell in a table, original cell layout information of the target cell is acquired, where the original cell layout information refers to layout information of at least two original cells that are merged to form the target cell; The original cell layout information is determined as the cell layout information indicated by the split operation.

4. The method according to claim 2, characterized in that: The step of obtaining, in response to a split operation on a target cell in the table, cell layout information indicated by the split operation includes: In response to a split operation on a target cell in a table, obtaining cell content in the target cell; Splitting the cell content according to a preset splitting rule to obtain at least two split contents; The cell layout information that matches the at least two split contents is determined as the cell layout information indicated by the split operation.

5. The method according to any one of claims 1 to 4, characterized in that: In response to the splitting operation on the target cell in the table, the target cell is split to obtain at least two split cells, and further includes: Fill the at least two split cells with cell content according to the split operation.

6. The method according to claim 5, characterized in that The filling the at least two split cells with cell content according to the split operation includes: According to the split operation, copy and fill the cell content of the target cell into each of the split cells; or, According to the split operation, the cell content of the target cell is filled into the specified split cell; or, According to the splitting operation, the split contents obtained according to the splitting rule are filled into the split cells in a manner that complies with the preset content filling rule.

7. The method according to claim 5, characterized in that In the case where the target cell is a merged cell, filling the at least two split cells with cell content according to the split operation includes: Obtaining original cell content in an original cell corresponding to the target cell, where the original cell refers to a cell that is merged to form the target cell; Fill each of the split cells with the corresponding original cell content.

8. The method according to claim 6, characterized in that The configuring the collaboration rights for the at least two split cells includes: Obtain target collaboration permission configuration information of the target cell; The collaboration authority is configured for each of the split cells according to the target collaboration authority configuration information.

9. The method according to claim 7, characterized in that: The configuring the collaboration rights for the at least two split cells includes: Acquire original collaboration permission configuration information of the original cell corresponding to the target cell; For each of the split cells, the collaboration permission is configured for the split cell according to the original collaboration permission configuration information of the original cell corresponding to the split cell.

10. The method according to any one of claims 1 to 4, characterized in that: In the case where the target cell is a merged cell, configuring collaboration permissions for the at least two split cells includes: Acquire original collaboration permission configuration information of an original cell corresponding to the target cell, where the original cell refers to a cell that is merged to form the target cell; For each of the split cells, the collaboration permission is configured for the split cell according to the original collaboration permission configuration information of the original cell corresponding to the split cell.

11. The method according to any one of claims 1 to 4, characterized in that: The configuring the collaboration rights for the at least two split cells includes: Obtain target collaboration permission configuration information of the target cell; The collaboration authority is configured for each of the split cells according to the target collaboration authority configuration information.

12. The method according to any one of claims 1 to 4, characterized in that: The configuring the collaboration rights for the at least two split cells includes: In response to the permission configuration operation on the at least two split cells, collaboration permissions are configured for the at least two split cells.

13. The method according to any one of claims 1 to 4, characterized in that: The configuring the collaboration permissions for the at least two split cells includes: For each of the split cells, a collaboration permission is configured for the split cell according to the cell content in the split cell.

14. The method according to claim 1, characterized in that In response to the splitting operation on the target cell in the table, the target cell is split to obtain at least two split cells, including: In response to a split operation on a target cell in a table, if it is determined that the current account has permission to perform the split operation on the target cell, the target cell is split to obtain at least two split cells.

15. The method according to claim 1, characterized in that In response to the splitting operation on the target cell in the table, the target cell is split to obtain at least two split cells, including: In response to a split operation on a target cell in a table, if it is determined that the split operation has an impact on adjacent cells of the target cell, determining whether the current account has a split permission on the target cell and an edit permission on the adjacent cells; When it is determined that the current account has the splitting authority for the target cell and the editing authority for the adjacent cell, the target cell is split to obtain at least two split cells.

16. The method according to claim 1, characterized in that After the target cell is split in response to the split operation on the target cell in the table to obtain at least two split cells, the method further includes: In the case where it is determined that the split operation has an impact on the neighboring cells of the target cell, adding a new cell to the table according to the at least two split cells, and determining the cells to be merged; The cells to be merged are merged to obtain corresponding merged cells.

17. The method according to claim 16, characterized in that After merging the cells to be merged to obtain corresponding merged cells, the method further includes: Configure collaboration permissions for the merged cell.

18. A table processing device, characterized in that: The device comprises: A cell splitting module, configured to split the target cell in the table in response to a splitting operation on the target cell, to obtain at least two split cells; The permission configuration module is used to configure the collaboration permissions for the at least two split cells.

19. An electronic device, characterized in that: include: A processor and a memory, wherein the processor is used to execute a table processing program stored in the memory to implement the table processing method according to any one of claims 1 to 17.

20. A storage medium, characterized in that: The storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement the table processing method according to any one of claims 1 to 17.

Images