Cell content filling method and device, equipment and storage medium
By configuring the collaboration permissions when cell autofill in the table, the collaboration security problem caused by cell autofill in the table collaboration scenario is solved, ensuring the security of the table content.
Patent Information
- Application Number
- CN202411592368.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-08
- Publication Date
- 2025-02-25
AI Technical Summary
The prior art does not consider the permission configuration problem when cells are automatically filled with content in table collaboration scenarios, resulting in the originally protected cell content being exposed to users who should not access these contents, undermining the cooperation security of tables.
By responsive to the cell fill instruction, determine the fill area and the start cell in the table, and if the fill permissions are included in the instruction, configure collaborative permissions for independent cells in the fill area based on the start cell, ensuring that only users should be able to access and fill these contents.
It effectively solves the collaboration security issues that may be brought about by the cell autofill function in the form collaboration scenario, ensures the security of table collaboration, and prevents unauthorized exposure of protected content.
Smart Images
Figure CN119514507A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of electronic spreadsheets, and in particular to a method, device, equipment and storage medium for filling cell contents. Background Art
[0002] In spreadsheet processing software, cell autofill is a common and powerful function that allows users to efficiently copy or expand data in a spreadsheet.
[0003] In the prior art, the cell auto-fill function involves two types of filling, namely content filling and format filling. Among them, content filling refers to filling the cell to be filled with cell content, which is not limited to strings of types such as values, dates, and texts. Format filling refers to formatting the cell to be filled, which is not limited to the format of the cell content (such as font, font size, color, bold, etc.) and the layout style of the cell (such as merging method).
[0004] However, in the table collaboration scenario, the existing technology does not consider the permission configuration issue when cells are automatically filled with content, which may cause the originally protected cell content to be copied to other cells due to filling, resulting in exposure from other cells to users who should not have access to these contents, thereby destroying the collaborative security of the table. Summary of the invention
[0005] The present application provides a cell content filling method, device, equipment and storage medium to solve the technical problem in the prior art that the permission configuration problem when automatically filling cells with content is not considered in the table collaboration scenario, which is likely to cause the originally protected cell content to be exposed to users who should not have access to such content, thereby destroying the collaborative security of the table.
[0006] In a first aspect, the present application provides a method for filling cell content, the method comprising:
[0007] In response to the cell filling instruction, determining a filling area and a starting cell in the table;
[0008] In the case where the cell filling instruction indicates that filling permissions are included, collaboration permissions are configured for independent cells in the filling area according to the starting cell, wherein the independent cells are cells in the table that can be regarded as independent logical entities.
[0009] In a possible implementation manner, after determining the filling area and the starting cell in the table in response to the cell filling instruction, the method further includes:
[0010] In the case where the cell filling instruction also indicates filling content, the independent cells in the filling area are filled with content based on the cell content in the starting cell.
[0011] In a possible implementation manner, after determining the filling area and the starting cell in the table in response to the cell filling instruction, the method further includes:
[0012] In a case where the cell filling instruction also indicates format filling, the cell layout of the filling area is adjusted based on the layout information of the starting cell.
[0013] In a possible implementation, configuring collaboration permissions for independent cells in the filling area according to the starting cell includes:
[0014] Collaboration permissions are configured for independent cells in the fill area after adjusting the cell layout according to the starting cell.
[0015] In a possible implementation, it further includes:
[0016] In the case where the cell filling instruction also indicates filling content, based on the cell content in the starting cell, the independent cells in the filling area after the cell layout is adjusted are filled with content.
[0017] In a possible implementation manner, after determining the filling area and the starting cell in the table in response to the cell filling instruction, the method further includes:
[0018] In a case where the cell filling instruction indicates that format filling is included, the cell layout of the filling area is adjusted based on the layout information of the starting cell.
[0019] In a possible implementation, configuring collaboration permissions for independent cells in the filling area according to the starting cell includes:
[0020] Acquire the collaboration permission configuration information of the starting cell as the target collaboration permission configuration information;
[0021] Collaboration permissions are configured for independent cells in the fill area according to the target collaboration permission configuration information.
[0022] In a possible implementation, configuring collaboration permissions for independent cells in the filling area according to the starting cell includes:
[0023] In the case where the starting cells include two or more, acquiring the collaboration permission configuration information of each of the starting cells in an arrangement order to obtain a target collaboration permission configuration information sequence;
[0024] Collaboration permissions are configured for independent cells in the fill area according to the target collaboration permission configuration information sequence.
[0025] In a possible implementation, the filling of the independent cells in the filling area with content based on the cell content in the starting cell includes:
[0026] In the case where it is determined that the operating user of the cell filling instruction has the cooperation authority for the starting cell, the independent cells in the filling area are filled with content based on the cell content in the starting cell.
[0027] In a possible implementation manner, the step of determining that the operating user of the cell filling instruction has collaboration authority over the starting cell includes:
[0028] In the case where it is determined that the operating user of the cell filling instruction has the specified authority, it is determined that the operating user of the cell filling instruction has the collaboration authority for the starting cell; wherein the specified authority is the authority for performing authority management on the table.
[0029] In a second aspect, the present application provides a cell content filling device, the device comprising:
[0030] A determination module, for determining a filling area and a starting cell in a table in response to a cell filling instruction;
[0031] A permission configuration module is used to configure collaboration permissions for independent cells in the filling area according to the starting cell when the cell filling instruction indicates that the filling permission is included, wherein the independent cell is a cell in the table that can be regarded as an independent logical entity.
[0032] In a possible implementation, the device further includes:
[0033] A content filling module is used to fill the independent cells in the filling area with content based on the cell content in the starting cell after determining the filling area and the starting cell in the table in response to the cell filling instruction, if the cell filling instruction indicates that it also includes filling content.
[0034] In a possible implementation, the device further includes:
[0035] The format filling module is used to adjust the cell layout of the filling area based on the layout information of the starting cell after determining the filling area and the starting cell in the table in response to the cell filling instruction, if the cell filling instruction indicates that it also includes format filling.
[0036] In a possible implementation, the permission configuration module is specifically used to:
[0037] Collaboration permissions are configured for independent cells in the fill area after adjusting the cell layout according to the starting cell.
[0038] In a possible implementation manner, the content filling module is further used to:
[0039] Based on the cell content in the starting cell, the independent cells in the filling area after the cell layout is adjusted are filled with content.
[0040] In a possible implementation, the permission configuration module is specifically used to:
[0041] Acquire the collaboration permission configuration information of the starting cell as the target collaboration permission configuration information;
[0042] Collaboration permissions are configured for independent cells in the fill area according to the target collaboration permission configuration information.
[0043] In a possible implementation, the permission configuration module is specifically used to:
[0044] In the case where the starting cells include two or more, acquiring the collaboration permission configuration information of each of the starting cells in an arrangement order to obtain a target collaboration permission configuration information sequence;
[0045] Collaboration permissions are configured for independent cells in the fill area according to the target collaboration permission configuration information sequence.
[0046] In a possible implementation, the content filling module includes:
[0047] A permission checking unit, used to determine whether the operating user of the cell filling instruction has the cooperation permission for the starting cell;
[0048] A filling unit is used to fill the independent cells in the filling area with content based on the cell content in the starting cell when it is determined that the operating user of the cell filling instruction has the cooperation authority for the starting cell.
[0049] In a possible implementation manner, the permission verification unit is specifically used to:
[0050] In the case where it is determined that the operating user of the cell filling instruction has the specified authority, it is determined that the operating user of the cell filling instruction has the collaboration authority for the starting cell; wherein the specified authority is the authority for performing authority management on the table.
[0051] In a third aspect, the present application provides a device comprising: a processor and a memory, wherein the processor is used to execute a cell content filling program stored in the memory to implement the cell content filling method described in any one of the first aspects.
[0052] In a fourth aspect, the present application provides a storage medium storing one or more programs, and the one or more programs can be executed by one or more processors to implement the cell content filling method described in any one of the first aspects.
[0053] The above-mentioned technical scheme provided by the embodiment of the present application has the following advantages over the prior art: the method provided by the embodiment of the present application, by responding to a cell fill instruction, determines a fill area and a starting cell in a table, and when the cell fill instruction indicates that fill permissions are included, configures collaboration permissions for independent cells in the fill area according to the starting cell, thereby realizing the addition of refined permission management for the cell automatic fill function in the table collaboration scenario, which can effectively solve the collaboration security issues that may be caused by the cell automatic fill function in the table collaboration scenario, and can ensure the security of table collaboration. BRIEF DESCRIPTION OF THE DRAWINGS
[0054] 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.
[0055] 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.
[0056] 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.
[0057] Figure 1 A flowchart of an embodiment of a method for filling cell content provided in an embodiment of the present application;
[0058] Figure 2An example diagram of the fill type selection interface;
[0059] Figure 3 A flowchart of another method for filling cell contents provided in an embodiment of the present application;
[0060] Figure 4 A flowchart of another method for filling cell contents provided in an embodiment of the present application;
[0061] Figure 5 A schematic diagram of adjusting the cell layout of the fill area based on the layout information of the start cell;
[0062] Figure 6 A flowchart of another method for filling cell contents provided in an embodiment of the present application;
[0063] Figure 7 A block diagram of an embodiment of a cell content filling device provided in an embodiment of the present application;
[0064] Figure 8 A schematic diagram of the structure of a device provided in an embodiment of the present application. DETAILED DESCRIPTION
[0065] 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.
[0066] 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.
[0067] In order to solve the technical problem that the prior art does not consider the permission configuration when automatically filling in cell content in a table collaboration scenario, which is likely to cause the originally protected cell content to be exposed to users who should not have access to such content, thereby destroying the collaborative security of the table, the present application provides a cell content filling method, apparatus, device and storage medium, which can realize the addition of refined permission management for the cell auto-fill function in a table collaboration scenario, which can effectively solve the collaborative security problems that may be caused by the cell auto-fill function in the table collaboration scenario, and can ensure the security of table collaboration.
[0068] Figure 1 The flowchart of an embodiment of a method for filling cell contents provided in the embodiment of the present application is as follows. Figure 1 As shown, the method comprises the following steps:
[0069] Step 101: In response to a cell filling instruction, determine a filling area and a starting cell in a table.
[0070] Step 102: When the cell filling instruction indicates that the filling permission is included, configure the collaboration permission for the independent cells in the filling area according to the starting cell, wherein the independent cells are cells in the table that can be regarded as independent logical entities.
[0071] For ease of understanding, step 101 and step 102 are described uniformly below:
[0072] 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.
[0073] 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.
[0074] The cell fill instruction is used to instruct the cells in the table to be filled. When processing the cell fill instruction, it involves determining the following three key elements: the starting cell, the fill area, and the fill type.
[0075] The starting cell refers to the cell that the user wants to refer to during the entire cell auto-fill process, usually the cell selected by the user. The starting cell can be one or more cells. When the starting cell includes multiple cells, these cells are usually adjacent, for example, these cells are located in the same row or the same column, and for example, these cells are located in adjacent rows or columns, such as two rows and two columns.
[0076] The fill area refers to the range of cells that the user wants to automatically fill in cells. The range can include one or more cells and is usually selected by the user. The fill area is usually located in the same row or column as the starting cell. For example, the starting cell is cell A1 (the cell located in row 1 of column A in the table), and the fill area is the area consisting of cells A2:A6, or the fill area is the area consisting of cells B1:H1. For another example, the starting cells include cells A1, B1, A2, and B2, and the fill area is the area consisting of cells A3:B6.
[0077] In the technical solution of the embodiment of the present application, three basic filling types are provided, namely filling content, filling format, and filling permission. Among them, filling content refers to filling cell content in the cell to be filled based on the cell content in the starting cell, and is not limited to character strings of types such as values, dates, and texts. Fill format refers to formatting the cell to be filled based on the starting cell, and is not limited to setting the format of the cell content (such as font, font size, color, bold, alignment, etc.) and setting the layout style of the cell (such as merging method). Fill permission refers to setting permissions for the cell to be filled based on the starting cell. The permission setting determines which users can access, edit, copy, comment or delete automatically filled cell content, such as read-only permission, edit permission, copy permission, comment permission, etc.
[0078] In the technical solution of the embodiment of the present application, each of the above-mentioned filling types can be used alone or in combination. When two or more filling types are combined and applied, a new filling type can be obtained.
[0079] For example, filling only the format means only setting the format of the cells to be filled, without filling the cell content therein (or deleting or not changing the original cell content in the case where the cells to be filled originally have cell content), and not setting permissions for them. Filling only the content (also known as filling without formatting) means only filling the cell content in the cells to be filled, without changing the formatting (generally speaking, when the cell content is not formatted, the spreadsheet processing software will apply the default format to the cell content), and not setting permissions for them. Filling only the permissions means only setting the permissions of the cells to be filled, without filling the cell content therein (or not changing the original cell content in the case where the cells to be filled originally have cell content), and not changing the formatting.
[0080] Filling with format is a combination of filling content and filling format, which means filling the cell content in the cell to be filled, and formatting the cell to be filled. For example, the cell to be filled can be formatted first, and then the cell content is filled in the formatted cell. Filling with permissions is a combination of filling content and filling permissions, which means filling the cell content in the cell to be filled, and setting permissions for the cell to be filled. Filling with format and permissions is a combination of filling content, filling format and filling permissions, which means filling the cell content in the cell to be filled, and formatting and setting permissions for the cell to be filled. For example, the cell to be filled can be formatted first, and then the cell content is filled in the formatted cell, and permissions are set. As for the specific implementation of filling content, filling format and filling permissions, they will be explained in different embodiments below, which will not be described in detail here.
[0081] Based on the above description, in one embodiment, the cell fill instruction indicates the fill type, and the fill type mentioned here is, for example, any of the fill types including filling format only, filling content only, filling permissions only, filling with format and with permissions, filling with format and filling with permissions, etc. The embodiment of the present application does not limit this.
[0082] As an optional implementation method, the user can select the starting cell in the table, then place the mouse on the small square (fill handle) in the lower right corner of the starting cell, hold down the left mouse button, and drag the fill handle downward or to the left. After the user releases the mouse, a menu icon may be displayed in the lower right corner of the cell where the fill handle is currently located. The user clicks on the menu icon to trigger the expansion of the menu list, which includes at least the above-mentioned fill types, and the user can then select the desired fill type. After the user selects the fill type, the cell fill instruction will be triggered. At this point, in response to the cell fill instruction, the fill area, the starting cell, and the fill type indicated by the cell fill instruction are determined in the table.
[0083] For example, if the user wants to use cell C1 (the cell in column C and row 1 in the table) as the starting cell and wants to automatically fill cells C2:C6 based on this starting cell, the user can select cell C1, place the mouse on the small square (fill handle) in the lower right corner of cell C1, hold down the left mouse button, drag the fill handle downward until the mouse is released at cell C6. Figure 2 As shown, after the user releases the mouse, a menu icon 21 may be displayed in the lower right corner of cell C6. The user clicks the menu icon to trigger the expansion of the menu list, which includes at least the above-mentioned fill types, and the user can select the desired fill type. After the user selects the fill type, the cell fill instruction will be triggered. At this time, in response to the cell fill instruction, the starting cell determined in the table is cell C1, the fill area is cells C2:C6, and the fill type is the fill type selected by the user in the menu list, for example, only fill permissions.
[0084] Further, as described in step 102, when the cell filling instruction indicates that the filling permission is included, the cooperation permission is configured for the independent cells in the filling area according to the starting cell.
[0085] Among them, the filling type indicated by the cell filling instruction involves permission filling. For example, when the indicated filling type is filling only with permissions, filling with permissions, filling with formatting, and filling with permissions, it is determined that the cell filling instruction indicates including filling permissions.
[0086] Independent cells in the fill area are cells in the fill area that can be regarded as independent logical entities. This is usually manifested as independent cells being merged cells or ordinary cells, where ordinary cells are not merged cells and are not child cells of any merged cells. For example, assuming that the fill area includes cells A and B, where cell B is a merged cell formed by merging cells B1 and B2, then cells A and B are independent cells, and cells B1 and B2 are child cells of merged cell B, not independent cells.
[0087] Configuring collaboration permissions for independent cells in the fill area based on the starting cell generally means that independent cells in the fill area inherit the collaboration permissions of the starting cell. For example, if the collaboration permission set for the starting cell is "viewable only by user A", then the independent cells in the fill area will inherit the collaboration permission, so that the automatically filled content in the fill area is also restricted to be viewable only by user A. This can prevent the automatically filled content from being exposed to users other than user A, and because the automatically filled content is determined based on the content of the starting cell, it can prevent the cell content in the starting cell from being exposed to users other than user A through reverse reasoning of the filled content, thereby ensuring the security of table collaboration. On the other hand, users do not need to manually set collaboration permissions for each cell in the fill area, which greatly saves users' time and energy. Furthermore, due to the consistency of the collaboration permission settings, collaboration barriers caused by incorrect collaboration permission configuration can be avoided.
[0088] Accordingly, in one embodiment, the specific implementation of configuring collaboration permissions for independent cells in the filling area according to the starting cell includes: obtaining the collaboration permission configuration information of the starting cell as the target collaboration permission configuration information; and configuring collaboration permissions for the independent cells in the filling area according to the target collaboration permission configuration information.
[0089] For example, in the above example, the collaboration permission configuration information "only user A can view" of the starting cell is obtained as the target collaboration permission configuration information, and the collaboration permission "only user A can view" is configured for the independent cells in the filling area.
[0090] In addition, as described above, there may be two or more starting cells. In actual applications, the collaboration permissions of the two or more starting cells may not be the same. At this time, as an optional implementation method, the specific implementation of configuring collaboration permissions for independent cells in the filling area according to the starting cells includes: when there are two or more starting cells, obtaining the collaboration permission configuration information of each starting cell in the order of arrangement to obtain the target collaboration permission configuration information sequence; configuring collaboration permissions for the independent cells in the filling area according to the target collaboration permission configuration information sequence.
[0091] For example, there are two starting cells, cell C1 and cell C2. Assume that the collaboration permission of cell C1 is "only user A can view", and the collaboration permission of cell C2 is "only user B can view". According to the above description, the collaboration permission configuration information of each starting cell is obtained in the order of arrangement, and the target collaboration permission configuration information sequence is obtained as "only user A can view", "only user B can view", and in the order of arrangement, every two independent cells in the filled area will inherit the target collaboration permission configuration information sequence. The permission configuration finally formed by such processing, for example, is as follows: cell C3 and cell C5 inherit the collaboration permission of cell C1 "only user A can view", cell C4 and cell C6 inherit the collaboration permission of cell C1 "only user B can view", and so on.
[0092] As another optional implementation method, the specific implementation of configuring collaboration permissions for independent cells in the filling area based on the starting cell includes: when the starting cells include two or more, obtaining collaboration permission configuration information of the two or more starting cells, determining the highest level of collaboration permission configuration information among these collaboration permission configuration information as target collaboration permission configuration information, and configuring collaboration permissions for the independent cells in the filling area according to the target collaboration permission configuration information.
[0093] For example, there are two starting cells, cell C1 and cell C2. Assume that the collaboration permission of cell C1 is "only level 1 users can view", and the collaboration permission of cell C2 is "only level 2 users and above can view". The highest level of collaboration permission configuration information among the two collaboration permission configuration information is "only level 1 users can view". According to the above description, "only level 1 users can view" is used as the target collaboration permission configuration information, and the collaboration permission "only level 1 users can view" is configured for the independent cells in the fill area.
[0094] By making the independent cells in the fill area inherit the highest level of collaboration permissions in the starting cell, it is possible to prevent the cell contents in the starting cell from being exposed to users who should not have access to the cell contents. For example, in the above example, it is possible to prevent the cell contents in the starting cell C1 from being exposed to secondary users, thus ensuring the security of table collaboration.
[0095] The technical solution provided in the embodiment of the present application determines the fill area and the starting cell in the table in response to the cell fill instruction, and when the cell fill instruction indicates that the fill permission is included, configures the collaboration permission for the independent cells in the fill area according to the starting cell, thereby realizing the addition of refined permission management for the cell automatic fill function in the table collaboration scenario. This can effectively solve the collaboration security issues that may be caused by the cell automatic fill function in the table collaboration scenario, and can ensure the security of the table collaboration.
[0096] Figure 3 A flowchart of another method for filling cell content provided in an embodiment of the present application. Figure 3 The process shown in Figure 1 Based on the process shown, the following steps are included:
[0097] Step 301: In response to a cell filling instruction, determine a filling area and a starting cell in a table.
[0098] Step 302: When the cell filling instruction indicates that the filling content and the filling permission are included, the independent cells in the filling area are filled with content based on the cell content in the starting cell, and the collaboration permission is configured for the independent cells in the filling area according to the starting cell.
[0099] Wherein, when the filling type indicated by the cell filling instruction involves filling content and filling authority, for example, when the indicated filling type is filling with authority, it is determined that the cell filling instruction indicates including filling content and filling authority.
[0100] When the cell filling instruction indicates that filling content is included, the independent cells in the filling area are filled with content based on the cell content in the starting cell.
[0101] In one embodiment, the specific implementation of filling the independent cells in the filling area with content based on the cell content in the starting cell includes: filling the independent cells in the filling area with the cell content in the starting cell.
[0102] In this embodiment, it is equivalent to copying the cell content in the starting cell to the independent cell in the filling area. This content filling method is applicable to any type of string, and does not limit the number of starting cells. Specifically, in the case of only one starting cell, the cell content in the starting cell is copied to the independent cell in the filling area. For example, the user enters 1 in cell A1, and then drags the fill handle in the lower right corner of cell A1 to the required row, and the electronic spreadsheet processing software will automatically fill the number 1 in column A. In the case of two or more starting cells, the cell contents in the two or more starting cells are copied to the independent cells in the filling area in sequence. For example, the user enters "a" in cell A1, enters "b" in cell A2, then selects cell A1 and cell A2, drags the fill handle in the lower right corner of cell A2 to the required row, and the electronic spreadsheet processing software will automatically fill "a" in cell A3, automatically fill "b" in cell A4, automatically fill "a" in cell A5, and automatically fill "b" in cell A6, and so on.
[0103] As an alternative implementation, see Figure 2 For example, when the user selects the "Copy Cell" fill type in the menu list, the cell content in the starting cell will be filled in the independent cells in the fill area in the above copy fill method.
[0104] Further, in this embodiment, the specific implementation of configuring collaboration permissions for independent cells in the filling area according to the starting cell includes: obtaining the collaboration permission configuration information of the starting cell as the target collaboration permission configuration information; configuring collaboration permissions for independent cells in the filling area according to the target collaboration permission configuration information. Alternatively, in the case where the starting cell includes two or more, the collaboration permission configuration information of each starting cell is obtained in the order of arrangement to obtain a target collaboration permission configuration information sequence; and collaboration permissions are configured for independent cells in the filling area according to the target collaboration permission configuration information sequence. Alternatively, in the case where the starting cell includes two or more, the collaboration permission configuration information of two or more starting cells is obtained, the highest level of collaboration permission configuration information among these collaboration permission configuration information is determined as the target collaboration permission configuration information, and collaboration permissions are configured for independent cells in the filling area according to the target collaboration permission configuration information.
[0105] In another embodiment, the specific implementation of filling the independent cells in the filling area with content based on the cell content in the starting cell includes: filling the independent cells in the filling area with content in a sequential filling manner based on the cell content in the starting cell.
[0106] In this embodiment, it is equivalent to taking the cell content in the starting cell as the starting point, increasing by a certain step value, obtaining a data sequence, and sequentially filling the data content in the data sequence into the independent cells in the filling area. Exemplarily, according to the filling sequence of the independent cells in the filling area, the cell content in the starting cell is sequentially adjusted according to the step value to obtain the filling content of each independent cell in the filling area. This content filling method is generally suitable for strings of types such as numbers, dates, and texts.
[0107] The filling order of independent cells in the filling area refers to the order of automatic filling in the filling area. In the vertical filling scenario, the filling order of independent cells in the filling area is usually from top to bottom, and in the horizontal filling scenario, the filling order of independent cells in the filling area is usually from left to right. Of course, other orders are not excluded, such as from bottom to top, from right to left, and the embodiments of the present application do not limit this.
[0108] According to the filling order of the independent cells in the filling area, the cell content in the starting cell is adjusted step by step according to the step value in sequence, and the specific implementation of obtaining the filling content of each independent cell in the filling area includes: for the first independent cell in the filling area, the cell content in the starting cell is adjusted according to the step value (such as increasing the step value on the basis of the cell content in the starting cell) to obtain the filling content of the first independent cell. For the second independent cell in the filling area, the filling content of the first independent cell is adjusted according to the step value (such as increasing the step value on the basis of the cell content in the starting cell) to obtain the filling content of the second independent cell. For the third independent cell in the filling area, the filling content of the second independent cell is adjusted according to the step value (such as increasing the step value on the basis of the cell content in the starting cell) to obtain the filling content of the third independent cell. And so on, which will not be repeated here.
[0109] It should be noted that the filling area is filled with independent cells as the granularity, not with the smallest cell as the granularity, and when the cell layout of the filling area is adjusted due to format filling, the filling of content and permissions will also be based on the independent cells in the filling area after the cell layout is adjusted. This will be explained in detail in the subsequent embodiments and will not be described in detail here.
[0110] For example, if a user wants to fill column A of a table with an increasing number sequence starting from 1, the user can enter 1 in cell A1, and then drag the fill handle in the lower right corner of cell A1 to the desired row, and the spreadsheet processing software will automatically fill column A with the corresponding number sequence.
[0111] It should be noted that the above example is only a simple example of sequence filling. In actual applications, a more flexible sequence filling method can be set. This flexibility is usually reflected in the flexible setting of the step value. Based on this, in one embodiment, the specific implementation of filling the independent cells in the filling area with content based on the cell content in the starting cell includes: determining a target step value; based on the cell content in the starting cell, filling the independent cells in the filling area with content in a sequence filling method according to the target step value.
[0112] As an optional implementation, when there is only one starting cell, a default value, such as 1, may be determined as the target step value.
[0113] As another optional implementation, when there is only one starting cell, the user can also flexibly set the target step value according to actual needs. For example, if the user wants to fill an increasing even number sequence starting from 2 in column A of the table, the user can enter 2 in cell A1 and then set the target step value to 2. Then, when the user selects cell A1 and drags the fill handle in the lower right corner of cell A1 to the desired row, the spreadsheet processing software will automatically fill 4 in cell A2, 6 in cell A3, 8 in cell A4, and so on, to automatically fill the corresponding even number sequence in column A.
[0114] As another optional implementation, when there are two starting cells, the difference between the cell contents of the two starting cells can be determined as the target step value. For example, if the user wants to fill an increasing even number sequence starting from 2 in column A of the table, the user can enter 2 in cell A1, enter 4 in cell A2, then select cell A1 and cell A2, and drag the fill handle at the lower right corner of cell A2 to the desired row, and the spreadsheet processing software will automatically fill the corresponding even number sequence in column A.
[0115] As another optional implementation, when the starting cells include three or more than three cells, the target step value can be a single value or a number sequence in other forms, such as an arithmetic sequence, a geometric sequence, and the like.
[0116] For example, assuming that the starting cells include cell A1, cell A2, and cell A3, the cell content in cell A1 is 2, the cell content in cell A2 is 4, and the cell content in cell A3 is 6. It can be seen that the regularity between the cell contents of the three starting cells is increasing by 2, so the target step value can be determined to be 2. Based on this, the cell content 8 is filled in cell A4, the cell content 10 is filled in cell A5, and so on.
[0117] Assume again that the starting cells include cell A1, cell A2, cell A3, and cell A4, wherein the cell content in cell A1 is 1, the cell content in cell A2 is 2, the cell content in cell A3 is 4, and the cell content in cell A4 is 7. It can be seen that the regularity between the cell contents of each of the four starting cells is: arithmetic progression 1, 2, 3, ..., then the target step value can be determined to be the arithmetic progression 1, 2, 3, .... Accordingly, for the first independent cell in the filling area, the cell content 7 in the last starting cell is increased according to the step value 4, and the filling content 11 of the first independent cell is obtained. For the second independent cell in the filling area, the filling content 7 of the first independent cell is increased according to the step value 5, and the filling content 16 of the second independent cell is obtained. For the third independent cell in the filling area, the filling content 16 of the second independent cell is increased according to the step value 6, and the filling content 22 of the third independent cell is obtained. And so on, which will not be repeated here.
[0118] One more point is added here. When the starting cell includes multiple columns (or multiple rows), the target step value is determined for each column separately. This can also be understood as performing automatic cell filling for each column separately.
[0119] Further, in this embodiment, the specific implementation of configuring collaboration permissions for independent cells in the filling area according to the starting cell includes: obtaining the collaboration permission configuration information of the starting cell as the target collaboration permission configuration information; configuring collaboration permissions for independent cells in the filling area according to the target collaboration permission configuration information. Alternatively, in the case where the starting cell includes two or more, the collaboration permission configuration information of each starting cell is obtained in the order of arrangement to obtain a target collaboration permission configuration information sequence; and collaboration permissions are configured for independent cells in the filling area according to the target collaboration permission configuration information sequence. Alternatively, in the case where the starting cell includes two or more, the collaboration permission configuration information of two or more starting cells is obtained, the highest level of collaboration permission configuration information among these collaboration permission configuration information is determined as the target collaboration permission configuration information, and collaboration permissions are configured for independent cells in the filling area according to the target collaboration permission configuration information.
[0120] As an alternative implementation, see Figure 2 For example, when the user selects the fill type "Fill in sequence" in the menu list, the cell content in the starting cell will be filled in the independent cells in the fill area in the above sequence filling method.
[0121] For other related descriptions of step 301 and step 302, see Figure 1 The explanations in the process shown will not be repeated here.
[0122] Figure 3 The illustrated embodiment not only automatically fills in the cell contents, but also takes into account the permission settings of the cells involved in the automatic filling. This processing method ensures that the cells that automatically fill in the content maintain consistency in collaboration permissions with the starting cell, thereby preventing the cell contents in the starting cell from being exposed to users who should not have access to the cell contents, thereby ensuring the security of table collaboration.
[0123] Figure 4 A flow chart of another embodiment of a method for filling cell content provided in an embodiment of the present application. Figure 4 The process shown in Figure 1 Based on the process shown, the following steps are included:
[0124] Step 401: In response to a cell filling instruction, determine a filling area and a starting cell in a table.
[0125] Step 402: When the cell filling instruction includes a filling format and filling permissions, the cell layout of the filling area is adjusted based on the layout information of the starting cell, and the collaboration permissions are configured for the independent cells in the filling area after the cell layout is adjusted according to the starting cell.
[0126] Wherein, when the filling type indicated by the cell filling instruction involves the filling format and the filling permission, for example, when the indicated filling type is filling with format and filling with permission, it is determined that the cell filling instruction indication includes the filling format and the filling permission.
[0127] In one embodiment, when the cell filling instruction indicates that the filling format is included, the cell layout of the filling area is adjusted based on the layout information of the starting cell. This is equivalent to applying the format of the starting cell to the filling area, or it can be said that the independent cells in the filling area inherit the format of the starting cell. The format here can include the format of the cell content (such as font, font size, color, alignment, etc.) and the layout of the cell (such as merging method, etc.).
[0128] As an exemplary application scenario, if the user wants to set the cell contents of the cells in column A of the table to bold and center them, the cell contents in cell A1 can be set to bold and center them, then cell A1 can be selected and the fill handle at the lower right corner of cell A1 can be dragged to the desired row. The spreadsheet processing software will automatically apply this format of bold and center to other cells in column A.
[0129] The above describes the inheritance of cell content format through specific examples. In practical applications, it also involves the inheritance of cell layout. For ease of understanding, the following example is shown:
[0130] See also Figure 5 In the example of (a), cell A1 is the starting cell, and cell A1 is a merged cell, specifically a merged cell formed by merging two sub-cells (cell A1 and cell A2). Then, when formatting column A in the table based on the merged cell A1, cells A3 and A4 are merged, cells A5 and A6 are merged, cells A7 and A8 are merged, and so on.
[0131] See also Figure 5 In the example of (b), cells A1 and A3 are the starting cells, and cell A1 is a merged cell, specifically a merged cell formed by merging two sub-cells (cell A1 and cell A2). Then, when formatting column A in the table based on the merged cells A1 and A3, cells A4 and A5 are merged, cells A7 and A8 are merged, cells A10 and A11 are merged, and so on.
[0132] Further, in this embodiment, the specific implementation of configuring collaboration permissions for independent cells in the filling area according to the starting cell includes: obtaining the collaboration permission configuration information of the starting cell as the target collaboration permission configuration information; configuring collaboration permissions for the independent cells in the filling area after adjusting the cell layout according to the target collaboration permission configuration information. Alternatively, in the case where the starting cell includes two or more, the collaboration permission configuration information of each starting cell is obtained in the order of arrangement to obtain a target collaboration permission configuration information sequence; and the collaboration permissions for the independent cells in the filling area after adjusting the cell layout are configured according to the target collaboration permission configuration information sequence. Alternatively, in the case where the starting cell includes two or more, the collaboration permission configuration information of two or more starting cells is obtained, the lowest level of collaboration permission configuration information among these collaboration permission configuration information is determined as the target collaboration permission configuration information, and the collaboration permissions are configured for the independent cells in the filling area after adjusting the cell layout according to the target collaboration permission configuration information. For example, in the above assumption, the lowest level of collaboration permission is "viewable only by first-level users". Therefore, the collaboration permission of independent cells in the filling area after adjusting the cell layout should be configured as "viewable only by first-level users". This can ensure that the cell content filled in the filling area will not be exposed to second-level users and other users with lower permission levels, thereby avoiding the cell content filled in the starting cell from being exposed to second-level users and other users with lower permission levels.
[0133] For other related descriptions of step 401 and step 402, see Figure 1 The explanations in the process shown will not be repeated here.
[0134] Figure 4 The illustrated embodiment not only automatically fills in the format of cells, but also takes into account the permission settings of the cells involved in the automatic filling. This processing method ensures that the cells with automatically filled content maintain consistency in collaboration permissions with the starting cells, thereby preventing the cell contents in the starting cells from being exposed to users who should not have access to the cell contents, thereby ensuring the security of table collaboration.
[0135] Figure 6 A flowchart of another method for filling cell content provided in an embodiment of the present application. Figure 6 The process shown is based on the process shown above and includes the following steps:
[0136] Step 601: In response to a cell filling instruction, determine a filling area and a starting cell in a table.
[0137] Step 602: When the cell fill instruction includes fill content, fill format, and fill permissions, adjust the cell layout of the fill area based on the layout information of the starting cell, then fill the independent cells in the fill area after the cell layout is adjusted based on the cell content in the starting cell, and configure collaboration permissions for the independent cells in the fill area after the cell layout is adjusted according to the starting cell.
[0138] Among them, when the filling type indicated by the cell filling instruction involves filling content, filling format and filling permissions, for example, when the indicated filling type is filling with format and filling with permissions, it is determined that the cell filling instruction indication includes filling content, format and permissions.
[0139] To facilitate understanding, the following example is shown:
[0140] Example 1: If the user wants to fill a number sequence starting from 1 in column A of the table, and wants the number sequence to be bold and centered in the cell, and wants the number sequence to be viewed only, then the user can enter 1 in cell A1, set its format to bold and centered, and set the collaboration permission of cell A1 to "read-only permission". Then drag the fill handle in the lower right corner of cell A1 to the required row, and the spreadsheet processing software will automatically fill the corresponding number sequence in column A, set the format of each number to bold and centered, and set the collaboration permission of each cell to "read-only permission".
[0141] Example 2: The user wants to fill a sequence of increasing numbers starting from 1 in column A of the table, and wants each number to be displayed in a merged cell, and wants the sequence of numbers to be viewed only. Then the user can merge cell A1 and cell A2, then enter 1 in the merged cell A1, and set the collaboration permission of the merged cell A1 to "read-only permission". Then drag the fill handle in the lower right corner of cell A1 to the required row, and the spreadsheet processing software will fill the format of the merged cell A1 in column A, such as: merge cell A3 and cell A4 to get merged cell A3, merge cell A5 and cell A6 to get merged cell A5, merge cell A7 and cell A8 to get merged cell A7, and so on. After that, the spreadsheet processing software fills the sequence of numbers in column A after adjusting the cell layout, such as: fill the number 2 in the merged cell A3, fill the number 3 in the merged cell A5, fill the number 4 in the merged cell A7, and so on. And configure the collaboration permission "read-only permission" for merged cell A3, merged cell A5, and merged cell A7.
[0142] From the above examples, it can be seen that when format filling involves cell layout adjustment, the cell layout of the filling area is adjusted first, and then the content filling and permission filling are performed on the filling area after the cell layout is adjusted.
[0143] Those skilled in the art will appreciate that the above is merely a simple example of simultaneously filling cells with content, format, and permissions. In actual applications, the technical solution provided in the embodiments of the present application may be applied to implement more complex cell automatic filling scenarios, and the embodiments of the present application do not impose any restrictions on this.
[0144] Figure 6 The illustrated embodiment not only performs automatic filling of cell contents and formats, but also takes into account the permission settings of the cells involved in the automatic filling. This processing method allows the cells that automatically fill in the contents to maintain consistency in collaboration permissions with the starting cells, thereby preventing the cell contents in the starting cells from being exposed to users who should not have access to the cell contents, thereby ensuring the security of table collaboration.
[0145] Based on any of the above embodiments, the present application also provides the following embodiments: filling independent cells in the filling area with content based on the cell content in the starting cell, including: filling independent cells in the filling area with content based on the cell content in the starting cell when it is determined that the operating user of the cell filling instruction has the collaboration authority for the starting cell.
[0146] Among them, determining that the operating user of the cell fill instruction has the collaboration permission for the starting cell includes: when determining that the operating user of the cell fill instruction has the specified permission, determining that the operating user of the cell fill instruction has the collaboration permission for the starting cell; wherein, the specified permission is the permission to manage permissions on the table.
[0147] Optionally, when the operating user is the creator or manager of the table, the operating user has the above-specified permissions.
[0148] This embodiment ensures the collaborative security of the table by verifying the collaboration authority of the operating user for the starting cell before automatically filling the cells. In this embodiment, the operating user is allowed to trigger the automatic filling of other cells in the table based on the starting cell only if the operating user has the specified authority, which can further ensure the security of the table collaboration.
[0149] Figure 7 This is a block diagram of an embodiment of a cell content filling device provided in an embodiment of the present application. Figure 7 As shown, the device comprises:
[0150] A determination module 71, for determining a filling area and a starting cell in a table in response to a cell filling instruction;
[0151] The permission configuration module 72 is used to configure collaboration permissions for independent cells in the filling area according to the starting cell when the cell filling instruction indicates that the filling permission is included, wherein the independent cell is a cell in the table that can be regarded as an independent logical entity.
[0152] In a possible implementation, the device further includes:
[0153] A content filling module is used to fill the independent cells in the filling area with content based on the cell content in the starting cell after determining the filling area and the starting cell in the table in response to the cell filling instruction, if the cell filling instruction indicates that it also includes filling content.
[0154] In a possible implementation, the device further includes:
[0155] A format filling module is used to adjust the cell layout of the filling area based on the layout information of the starting cell after determining the filling area and the starting cell in the table in response to the cell filling instruction, if the cell filling instruction indicates that it also includes format filling.
[0156] In a possible implementation, the permission configuration module 72 is specifically used to:
[0157] Collaboration permissions are configured for independent cells in the fill area after adjusting the cell layout according to the starting cell.
[0158] In a possible implementation manner, the content filling module is further used to:
[0159] Based on the cell content in the starting cell, the independent cells in the filling area after the cell layout is adjusted are filled with content.
[0160] In a possible implementation, the permission configuration module 72 is specifically used to:
[0161] Acquire the collaboration permission configuration information of the starting cell as the target collaboration permission configuration information;
[0162] Collaboration permissions are configured for independent cells in the fill area according to the target collaboration permission configuration information.
[0163] In a possible implementation, the permission configuration module 72 is specifically used to:
[0164] In the case where the starting cells include two or more, acquiring the collaboration permission configuration information of each of the starting cells in an arrangement order to obtain a target collaboration permission configuration information sequence;
[0165] Collaboration permissions are configured for independent cells in the fill area according to the target collaboration permission configuration information sequence.
[0166] In a possible implementation, the content filling module includes:
[0167] A permission checking unit, used to determine whether the operating user of the cell filling instruction has the cooperation permission for the starting cell;
[0168] A filling unit is used to fill the independent cells in the filling area with content based on the cell content in the starting cell when it is determined that the operating user of the cell filling instruction has the cooperation authority for the starting cell.
[0169] In a possible implementation manner, the permission verification unit is specifically used to:
[0170] In the case where it is determined that the operating user of the cell filling instruction has the specified authority, it is determined that the operating user of the cell filling instruction has the collaboration authority for the starting cell; wherein the specified authority is the authority for performing authority management on the table.
[0171] like Figure 8 As shown, an embodiment of the present application provides a 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.
[0172] Memory 113, used for storing computer programs;
[0173] In one embodiment of the present application, the processor 111 is used to execute the program stored in the memory 113 to implement the cell content filling method provided by any of the above method embodiments, including:
[0174] In response to the cell filling instruction, determining a filling area and a starting cell in the table;
[0175] In the case where the cell filling instruction indicates that filling permissions are included, collaboration permissions are configured for independent cells in the filling area according to the starting cell, wherein the independent cells are cells in the table that can be regarded as independent logical entities.
[0176] An embodiment of the present application also 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 cell content filling method provided in any of the aforementioned method embodiments are implemented.
[0177] 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.
[0178] 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.
[0179] It should be understood that the terms used in the text 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 in the text 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.
[0180] 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 method for filling cell content, characterized in that: The method comprises: In response to the cell filling instruction, determining a filling area and a starting cell in the table; In the case where the cell filling instruction indicates that filling permissions are included, collaboration permissions are configured for independent cells in the filling area according to the starting cell, wherein the independent cells are cells in the table that can be regarded as independent logical entities.
2. The method according to claim 1, characterized in that After determining the filling area and the starting cell in the table in response to the cell filling instruction, the method further includes: In the case where the cell filling instruction also indicates filling content, the independent cells in the filling area are filled with content based on the cell content in the starting cell.
3. The method according to claim 1 or 2, characterized in that: After determining the filling area and the starting cell in the table in response to the cell filling instruction, the method further includes: In a case where the cell filling instruction also indicates format filling, the cell layout of the filling area is adjusted based on the layout information of the starting cell.
4. The method according to claim 3, characterized in that The configuring the collaboration permission for the independent cells in the filling area according to the starting cell includes: Collaboration permissions are configured for independent cells in the fill area after adjusting the cell layout according to the starting cell.
5. The method according to claim 3, characterized in that: Also includes: In the case where the cell filling instruction also indicates filling content, based on the cell content in the starting cell, the independent cells in the filling area after the cell layout is adjusted are filled with content.
6. The method according to claim 1, characterized in that The configuring the collaboration permission for the independent cells in the filling area according to the starting cell includes: Acquire the collaboration permission configuration information of the starting cell as the target collaboration permission configuration information; Collaboration permissions are configured for independent cells in the fill area according to the target collaboration permission configuration information.
7. The method according to claim 1, characterized in that The configuring the collaboration permission for the independent cells in the filling area according to the starting cell includes: In the case where the starting cells include two or more, acquiring the collaboration permission configuration information of each of the starting cells in an arrangement order to obtain a target collaboration permission configuration information sequence; Collaboration permissions are configured for independent cells in the fill area according to the target collaboration permission configuration information sequence.
8. The method according to claim 2, characterized in that: The step of filling the independent cells in the filling area with content based on the cell content in the starting cell includes: When it is determined that the user operating the cell filling instruction has the cooperation authority for the starting cell, the independent cells in the filling area are filled with content based on the cell content in the starting cell.
9. The method according to claim 8, characterized in that The step of determining that the operating user of the cell filling instruction has cooperation authority over the starting cell includes: In the case where it is determined that the operating user of the cell filling instruction has the specified authority, it is determined that the operating user of the cell filling instruction has the collaboration authority for the starting cell; wherein the specified authority is the authority for performing authority management on the table.
10. A cell content filling device, characterized in that: The device comprises: A determination module, for determining a filling area and a starting cell in a table in response to a cell filling instruction; A permission configuration module is used to configure collaboration permissions for independent cells in the filling area according to the starting cell when the cell filling instruction indicates that the filling permission is included, wherein the independent cell is a cell in the table that can be regarded as an independent logical entity.
11. A device, characterized in that: include: A processor and a memory, wherein the processor is used to execute a cell content filling program stored in the memory to implement the cell content filling method described in any one of claims 1 to 9.
12. 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 cell content filling method described in any one of claims 1-9.