Table collaborative editing method and device based on version control

Abstract

The embodiment of the invention provides a table collaborative editing method and device based on version control, and the method comprises the steps: responding to a table filling task, creating a target filling table, and enabling each cell to correspond to one filling task; allocating the plurality of filling persons according to the filling task, and generating a cell version corresponding to the specific filling person of the cell after allocation; the filling person obtains the control authority of the allocated cell version and selects a processing mode for the cell according to the task condition; the downstream filling person repeats the current operation until the final filling person, and after distribution is completed, the cell version set of each cell forms a directed tree structure; and when the cell editing state corresponding to one cell version is a submission state, summarizing the content of the lower-level cell version, and finally summarizing the content to a first-time allocation person, so that a tree-shaped organization structure of cell-based filling table collaborative editing and authority control and matched data acquisition work is realized, and a multi-person management function of the table is realized.

Description

Technical Field

[0001] This invention relates to the field of data statistics and data processing technology, and in particular to a method and apparatus for collaborative editing of tables based on version control. Background Technology

[0002] Currently, data entry and aggregation using spreadsheet tools such as Excel or WPS is a crucial method for data collection. However, with increasingly detailed business management in financial institutions and strengthened macro-prudential supervision and auditing requirements, a single data collection task often involves numerous personnel from multiple departments and offices simultaneously, resulting in a massive workload for offline data entry, communication, collaboration, review, and aggregation. Online spreadsheet tools such as cloud-based document tools are existing solutions for handling this type of data work. However, these tools cannot match the hierarchical data collection organizational structure of layered task allocation and aggregation. Typically, data is collected within a small area at the same level, and then manually or using various tools to further aggregate the data before submitting it to the next higher level for processing.

[0003] Therefore, current online spreadsheet tools do not achieve the finest-grained collaboration at the cell level. Multiple people with different reporting hierarchies fill in the same cell at the same time, overlapping and seeing each other. Permissions cannot be further controlled, and the tree-like data collection organization structure that matches the layered allocation and aggregation of reporting tasks restricts its scope of use. Summary of the Invention

[0004] This invention provides a version control-based collaborative editing method and apparatus for tables, which solves the defects in the prior art where multiple people with different filling levels fill in the same cell at the same time, overlapping and seeing each other, and permissions cannot be further controlled. It realizes collaborative editing and permission control of the filling table, matching the tree-like organizational structure of data collection work.

[0005] This invention provides a version control-based collaborative table editing method, comprising: In response to a form filling task, a target form is created, wherein the form filling task includes the filler information and the form cell control permissions corresponding to each filler; Based on the information of the person filling out the form and the control permissions of the table cell corresponding to each person, a cell version corresponding to each cell is generated; Based on the form filling task and the cell version corresponding to each cell, cells are assigned to each person filling out the form, and the cells are assigned layer by layer to the final person filling out the form. Get the cell editing status of each cell after assignment; When the cell editing status of each cell is in the submitted state, the content of each cell is summarized.

[0006] In one possible implementation, the method further includes: When the information of the person filling out the form is a first-level person filling out the form, the cells in the target form filling form are generated into corresponding first-level sub-versions based on the control permissions of the table cells corresponding to each first-level person filling out the form. When the information of the person filling out the form is a second-level person filling out the form, the cells of the first-level sub-version are generated into corresponding second-level sub-versions based on the control permissions of the table cells corresponding to each second-level person filling out the form. The table cell control permissions of the first-level data filler are greater than those of the second-level data filler.

[0007] In one possible implementation, the method further includes: Based on the form filling task, the table cell control permissions of the first-level sub-version cells are assigned to the corresponding first-level filler, and the table cell control permissions of the second-level sub-version cells are assigned to the corresponding second-level filler.

[0008] In one possible implementation, the method further includes: Retrieve the information of the person filling out the current form; Determine the cell control permissions of the current form filler based on the current form filler information; Edit the corresponding cells according to the cell control permissions of the current form filler.

[0009] In one possible implementation, the method further includes: Obtain the submission command triggered after the current form filler edits the corresponding cell; Based on the submission command, the cell editing state is set to the submission state.

[0010] In one possible implementation, the method further includes: When the cell editing status of each cell is in the submitted state, the data entered for all versions corresponding to each cell is summarized.

[0011] The present invention also provides a version control-based collaborative table editing device, comprising the following modules: The table creation module is used to create a target form in response to a form filling task, wherein the form filling task includes the information of the person filling out the form and the control permissions of the table cells corresponding to each person filling out the form; The version generation module is used to generate a cell version corresponding to each cell based on the information of the person filling out the form and the control permissions of the table cell corresponding to each person filling out the form. The cell allocation module is used to allocate cells to each person filling out the form according to the form filling task and the cell version corresponding to each cell, and to allocate cells to the final person filling out the form layer by layer. The acquisition module is used to obtain the cell editing status of each cell after allocation; The summary module is used to summarize the contents of each cell when the cell editing state of each cell is in the submitted state.

[0012] The present invention also provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the version control-based collaborative editing method for tables as described above.

[0013] The present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the version-controlled table collaborative editing method as described above.

[0014] The present invention also provides a computer program product, including a computer program that, when executed by a processor, implements the version control-based collaborative table editing method as described above.

[0015] This invention provides a version-controlled collaborative editing method and apparatus for tables. It creates a target table in response to a table filling task, where the task includes information about the person filling out the form and the corresponding cell control permissions for each person. It generates a cell version for each cell based on the information and the cell control permissions. It assigns cells to each person based on the task and the cell version, distributing cells layer by layer to the final person filling out the form. It obtains the editing status of each assigned cell. When the editing status of each cell is "submitted," it summarizes the content of each cell. Compared to existing technologies where multiple people at different filling levels simultaneously fill out the same cell, resulting in overlapping and mutual visibility, and lack of further permission control, this solution achieves collaborative editing and permission control of the table by using cell version control for online collaborative editing. It matches the tree-like organizational structure of data collection work and enables multi-person table management. Attached Figure Description

[0016] To more clearly illustrate the technical solutions in this invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of this invention. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0017] Figure 1 This is one of the flowcharts of the version control-based collaborative table editing method provided by the present invention.

[0018] Figure 2 This is the second flowchart of the version control-based collaborative table editing method provided by the present invention.

[0019] Figure 3 This is a schematic diagram of the structure of the version control-based table collaborative editing device provided by the present invention.

[0020] Figure 4 This is a schematic diagram of the structure of the electronic device provided by the present invention. Detailed Implementation

[0021] To make the objectives, technical solutions, and advantages of this invention clearer, the technical solutions of this invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of this invention. All other embodiments obtained by those skilled in the art based on the embodiments of this invention without creative effort are within the scope of protection of this invention.

[0022] To facilitate understanding of the embodiments of the present invention, further explanations and descriptions will be provided below with reference to the accompanying drawings and specific embodiments. These embodiments do not constitute a limitation on the embodiments of the present invention.

[0023] Figure 1 This is one of the flowcharts illustrating the version control-based collaborative table editing method provided by the present invention, such as... Figure 1 As shown, the method includes the following: S11. In response to the form filling task, a target form is created, wherein the form filling task includes the filler information and the form cell control permissions corresponding to each filler.

[0024] This invention proposes an online table cell collaborative editing method based on version control to enable collaborative editing and access control of cells by personnel at different levels of the organizational structure, matching the tree-like organizational structure of data collection work.

[0025] First, the user creates a table and initiates a table completion task. Each cell corresponds to one completion task, and the system responds by creating a target table. A single cell is assigned to multiple users based on the completion task, generating a cell version specific to that user. The user acquires control permissions (edit, submit, or assign) for their assigned cell version and, depending on the task, chooses to edit, submit, or reassign the cell to downstream users (the assignment process is the same as cell assignment above). Downstream users repeat the current operation until the final user is reached. After assignment, the set of cell versions for each cell forms a directed tree structure. The table completion task includes user information and the corresponding table cell control permissions for each user. User information includes, but is not limited to, user position and identity information. The corresponding table cell control permissions for each user include, but are not limited to, cell control, completion, and assignment permissions.

[0026] S12. Generate a cell version corresponding to each cell based on the information of the person filling out the form and the control permissions of the table cell corresponding to each person filling out the form.

[0027] When the submitter information is a first-level submitter, the cells in the target submission table are used to generate corresponding first-level sub-versions based on the table cell control permissions corresponding to each first-level submitter. Optionally, when the submitter information is a second-level submitter, the cells in the first-level sub-versions are used to generate corresponding second-level sub-versions based on the table cell control permissions corresponding to each second-level submitter. The table cell control permissions for first-level submitters are greater than those for second-level submitters.

[0028] S13. Based on the form filling task and the cell version corresponding to each cell, assign cells to each person filling out the form, and assign cells layer by layer to the final person filling out the form.

[0029] Based on the form filling task, assign the table cell control permissions of the first-level sub-version cells to the corresponding first-level filler, and assign the table cell control permissions of the second-level sub-version cells to the corresponding second-level filler.

[0030] S14. Get the cell editing status of each cell after allocation.

[0031] Get the information of the person filling out the current form; determine the cell control permissions of the person filling out the current form based on the information of the person filling out the current form; edit the corresponding cell based on the cell control permissions of the person filling out the current form.

[0032] Furthermore, after the current user edits or fills in a cell, they can trigger a cell submission command, and the system will set the cell editing status to the submission status based on the submission command.

[0033] S15. When the cell editing state of each cell is in the submit state, the content of each cell is summarized.

[0034] When the cell editing status of a cell version is "submitted," the superior data entry personnel summarize the content of the subordinate cell versions. The summarized content includes the submitted content of multiple subordinate cell versions. After cell versions are summarized layer by layer, the content is finally summarized to the initial assignee, realizing collaborative editing and access control of the data entry form based on cells. This matches the tree-like organizational structure of the data collection work and enables multi-person management of the form.

[0035] Optionally, a user may have multiple cell versions simultaneously, meaning they have control, input, and allocation permissions for multiple cells. To facilitate user operation, features such as one-click summary and one-click submission can be added to improve efficiency. Furthermore, by allowing multiple users to control a single cell version, multi-user management functionality can be achieved.

[0036] This invention provides a version-controlled collaborative table editing method. It creates a target table in response to a table filling task, where the task includes information about the person filling out the form and the corresponding cell control permissions for each person. Based on this information and the cell control permissions, it generates a cell version for each cell. It then assigns cells to each person based on the task and the cell version, progressively allocating cells to the final person. The method obtains the editing status of each assigned cell. When the cell editing status is "submitted," it summarizes the content of each cell. Compared to existing technologies where multiple people at different levels simultaneously fill out the same cell, resulting in overlapping and mutual visibility, and lack of further permission control, this method achieves collaborative editing and permission control of the table through online cell version control. It matches the tree-like organizational structure of data collection, enabling multi-person table management and a systematic collaborative data filling process.

[0037] Figure 2 This is the second flowchart of the version control-based collaborative table editing method provided by the present invention, as shown below. Figure 2 As shown, the method includes the following: S21. When the information of the person filling out the form is a first-level person filling out the form, the corresponding first-level sub-version is generated from the cell in the target form filling form based on the control permissions of the table cell corresponding to each first-level person filling out the form.

[0038] S22. When the information of the person filling in the form is a second-level person filling in the form, the cells of the first-level sub-version are generated into the corresponding second-level sub-version based on the control permissions of the table cells corresponding to each second-level person filling in the form.

[0039] S23. Based on the form filling task, assign the table cell control permissions of the first-level sub-version cells to the corresponding first-level fillers, and assign the table cell control permissions of the second-level sub-version cells to the corresponding second-level fillers.

[0040] The following provides a unified explanation of S21-S23: This invention proposes an online table cell collaborative editing method based on version control to enable collaborative editing and access control of cells by personnel at different levels of the organizational structure, matching the tree-like organizational structure of data collection work.

[0041] First, the user creates a form and initiates a form filling task. The system responds by creating the target form. The form filling task includes the information of the person filling out the form and the corresponding cell control permissions for each person. The person filling out the form information includes, but is not limited to, their job title and identity information. The corresponding cell control permissions for each person include, but are not limited to, cell control, filling, and assignment permissions.

[0042] Furthermore, a cell can be assigned to the corresponding task manager (first-level data entry person) according to different requirements and division of responsibilities, and a cell can be assigned to multiple people.

[0043] Upon initial cell allocation, an initial cell version is created, owned by the task initiator. The system then generates multiple sub-versions of that cell version based on the allocation. Each assigned primary user corresponds to one sub-version and has control, submission, and allocation permissions for that version. Different versions within the same cell are isolated from each other; the parent version's cell owner can see the submissions of the sub-version's cell owner, but otherwise, the submissions are not visible to each other.

[0044] For example, when the person filling out the form is a first-level filler, the system will generate a corresponding first-level sub-version of the cells in the target form based on their corresponding table cell control permissions. This means that first-level fillers can edit cells within their permission scope, and their edits will create a new version, namely the first-level sub-version.

[0045] When the data entry user is a second-level data entry user, the system will generate a corresponding second-level sub-version from the first-level sub-version cells based on their corresponding table cell control permissions. Second-level data entry users can edit cells within their permission scope, but their edits are based on versions already edited by first-level data entry users.

[0046] S24. Obtain the information of the person filling out the current form, and determine the cell control permissions of the person filling out the current form based on the information of the person filling out the current form.

[0047] S25. Edit the corresponding cells according to the cell control permissions of the current form filler.

[0048] When the current form filler opens the form, the system determines whether the current form filler has the cell version for that cell. If they do, the filler has control over that cell. The user can fill in the cell or assign the cell to the next level of filler according to their responsibilities. After assignment, the system generates a sub-version of that version and authorizes it to the assigned next level of filler.

[0049] Repeat the cell assignment steps above until all table entry tasks are completely assigned. After task assignment is complete, all versions under that cell will form a tree structure, matching the data entry organization structure.

[0050] S26. Obtain the submission command triggered by the current form filler after editing the corresponding cell.

[0051] S27. Set the cell editing state to the submit state based on the submit instruction.

[0052] After a user completes the form and submits the cell, the system sets the user's cell editing status to submitted.

[0053] S28. When the cell editing status of each cell is in the submitted state, summarize the data entered for all versions corresponding to each cell.

[0054] Once all sub-versions under a cell version have been submitted, that is, when the cell editing status of each cell is in the submitted state, the version owner can summarize, modify, and submit the cell content.

[0055] Repeat the above steps until the task is submitted to the task initiator, who will then compile the data to form the final data.

[0056] Optionally, a user may have multiple cell versions simultaneously, meaning they have control, input, and allocation permissions for multiple cells. To facilitate user operation, features such as one-click summary and one-click submission can be added to improve efficiency. Furthermore, by allowing multiple users to control a single cell version, multi-user management functionality can be achieved.

[0057] This invention provides a version-controlled collaborative table editing method. It creates a target table in response to a table filling task, where the task includes information about the person filling out the form and the corresponding cell control permissions for each person. Based on the information and permissions, it generates a cell version for each cell. Cells are then assigned to each person based on the task and the cell version, progressively allocating cells to the final person. The method obtains the editing status of each assigned cell. When the cell editing status is "submitted," the content of each cell is summarized. This method enables online collaborative editing of table cells through version control, achieving collaborative editing and permission control of the form, matching the tree-like organizational structure of data collection, and realizing multi-person table management and a systematic collaborative data entry process.

[0058] The version control-based collaborative table editing device provided by the present invention will be described below. The version control-based collaborative table editing device described below can be referred to in correspondence with the version control-based collaborative table editing method described above.

[0059] Figure 3 This is a schematic diagram of the structure of the version control-based collaborative table editing device provided by the present invention, specifically including: The table creation module 301 is used to create a target form in response to a form filling task, wherein the form filling task includes the filler's information and the control permissions of the table cells corresponding to each filler. For detailed explanations, please refer to the relevant descriptions in the above method embodiments, which will not be repeated here.

[0060] Version generation module 302 is used to generate a cell version for each cell based on the information of the person filling out the form and the control permissions of the table cell corresponding to each person filling out the form. For detailed explanation, please refer to the relevant descriptions in the above method embodiments, which will not be repeated here.

[0061] The cell allocation module 303 is used to allocate cells to each person filling out the form according to the form filling task and the cell version corresponding to each cell, and to allocate cells layer by layer to the final person filling out the form. For detailed explanation, please refer to the relevant descriptions in the above method embodiments, which will not be repeated here.

[0062] The acquisition module 304 is used to acquire the cell editing status of each assigned cell. For detailed explanations, please refer to the relevant descriptions in the above method embodiments; they will not be repeated here.

[0063] The summary module 305 is used to summarize the content of each cell when the cell editing state of each cell is in the submitted state. For detailed explanation, please refer to the relevant descriptions in the above method embodiments, which will not be repeated here.

[0064] Figure 4 An example is a schematic diagram of the physical structure of an electronic device, such as... Figure 4 As shown, the electronic device may include a processor 810, a communications interface 820, a memory 830, and a communication bus 840, wherein the processor 810, communications interface 820, and memory 830 communicate with each other via the communication bus 840. The processor 810 can call logical instructions in the memory 830 to execute a version-controlled collaborative table editing method. This method includes: creating a target table in response to a table filling task, wherein the table filling task includes information about the person filling out the form and the table cell control permissions corresponding to each person filling out the form; generating a cell version corresponding to each cell based on the information about the person filling out the form and the table cell control permissions corresponding to each person filling out the form; allocating cells to each person filling out the form based on the table filling task and the cell version corresponding to each cell, allocating cells layer by layer to the final person filling out the form; obtaining the cell editing status of each allocated cell; and summarizing the content of each cell when the cell editing status of each cell is in the submitted state.

[0065] Furthermore, the logical instructions in the aforementioned memory 830 can be implemented as software functional units and, when sold or used as independent products, can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, or a part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0066] On the other hand, the present invention also provides a computer program product, which includes a computer program that can be stored on a non-transitory computer-readable storage medium. When the computer program is executed by a processor, the computer can execute the version control-based collaborative table editing method provided by the above methods. The method includes: creating a target form in response to a form filling task, wherein the form filling task includes filler information and table cell control permissions corresponding to each filler; generating a cell version corresponding to each cell based on the filler information and the table cell control permissions corresponding to each filler; allocating cells to each filler based on the form filling task and the cell version corresponding to each cell, and allocating cells layer by layer to the final filler; obtaining the cell editing status of each cell after allocation; and summarizing the content of each cell when the cell editing status of each cell is a submitted status.

[0067] In another aspect, the present invention also provides a non-transitory computer-readable storage medium storing a computer program thereon, which, when executed by a processor, implements the version-controlled collaborative table editing method provided by the above methods. The method includes: creating a target table in response to a table filling task, wherein the table filling task includes filler information and table cell control permissions corresponding to each filler; generating a cell version corresponding to each cell based on the filler information and the table cell control permissions corresponding to each filler; allocating cells to each filler according to the table filling task and the cell version corresponding to each cell, distributing cells layer by layer to the final filler; obtaining the cell editing status of each allocated cell; and summarizing the content of each cell when the cell editing status of each cell is in a submitted state.

[0068] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without any creative effort.

[0069] Through the above description of the embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus necessary general-purpose hardware platforms, and of course, it can also be implemented by hardware. Based on this understanding, the above technical solutions, in essence or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute the methods described in the various embodiments or some parts of the embodiments.

[0070] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A version control-based collaborative table editing method, characterized in that, include: In response to a form filling task, a target form is created, wherein the form filling task includes the filler information and the form cell control permissions corresponding to each filler; Based on the information of the person filling out the form and the control permissions of the table cell corresponding to each person, a cell version corresponding to each cell is generated; Based on the form filling task and the cell version corresponding to each cell, cells are assigned to each person filling out the form, and the cells are assigned layer by layer to the final person filling out the form. Get the cell editing status of each cell after assignment; When the cell editing status of each cell is in the submitted state, the content of each cell is summarized.

2. The method according to claim 1, characterized in that, The step of generating a cell version for each cell based on the information of the person filling out the form and the control permissions of the table cell corresponding to each person includes: When the information of the person filling out the form is a first-level person filling out the form, the cells in the target form filling form are generated into corresponding first-level sub-versions based on the control permissions of the table cells corresponding to each first-level person filling out the form. When the information of the person filling out the form is a second-level person filling out the form, the cells of the first-level sub-version are generated into corresponding second-level sub-versions based on the control permissions of the table cells corresponding to each second-level person filling out the form. The table cell control permissions of the first-level data filler are greater than those of the second-level data filler.

3. The method according to claim 2, characterized in that, The step of assigning cells to each person filling out the form based on the form filling task and the cell version corresponding to each cell includes: Based on the form filling task, the table cell control permissions of the first-level sub-version cells are assigned to the corresponding first-level filler, and the table cell control permissions of the second-level sub-version cells are assigned to the corresponding second-level filler.

4. The method according to claim 3, characterized in that, Before obtaining the cell editing status of each assigned cell, the process includes: Retrieve the information of the person currently filling out the form; Determine the cell control permissions of the current form filler based on the current form filler information; Edit the corresponding cells according to the cell control permissions of the current form filler.

5. The method according to claim 4, characterized in that, The process of obtaining the cell editing status of each assigned cell includes: Obtain the submission command triggered after the current form filler edits the corresponding cell; Based on the submission command, the cell editing state is set to the submission state.

6. The method according to claim 5, characterized in that, When the cell editing state of each cell is in the submitted state, the content of each cell is summarized, including: When the cell editing status of each cell is in the submitted state, the data entered for all versions corresponding to each cell is summarized.

7. A version-controlled collaborative table editing device, characterized in that, include: The table creation module is used to create a target form in response to a form filling task, wherein the form filling task includes the information of the person filling out the form and the control permissions of the table cells corresponding to each person filling out the form; The version generation module is used to generate a cell version corresponding to each cell based on the information of the person filling out the form and the control permissions of the table cell corresponding to each person filling out the form. The cell allocation module is used to allocate cells to each person filling out the form according to the form filling task and the cell version corresponding to each cell, and to allocate cells to the final person filling out the form layer by layer. The acquisition module is used to obtain the cell editing status of each cell after allocation; The summary module is used to summarize the contents of each cell when the cell editing state of each cell is in the submitted state.

8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and running on the processor, characterized in that, When the processor executes the computer program, it implements the version-controlled collaborative table editing method as described in any one of claims 1 to 6.

9. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the version control-based collaborative table editing method as described in any one of claims 1 to 6.

10. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by the processor, it implements the version control-based collaborative table editing method as described in any one of claims 1 to 6.

Images