An Automatic Locking Method for Modifying Table Cells

Abstract

This application relates to an automatic locking method for modifying table cells. According to the total value of data in the upper-level dimension, based on historical data analysis, the values of cells in the lower-level dimension of the table are automatically allocated, and the total value of the data in the modified table is locked; when clicking on a cell in the lower-level dimension that needs to be modified, the user is prompted with the range of values that can be modified in the lower-level dimension; the user enters the modified value in the cell of the lower-level dimension, the modified cell is locked, and based on historical data analysis, the values of other cells in the table are automatically allocated. It is possible to adjust the data by manually modifying the data of a single cell, and then the manually modified cell will be automatically locked, and based on the analysis of historical data again, the quantities of other cells will be allocated. Applying this function to a list with a determined total value can achieve rapid adjustment of table data and prevent the mutual influence of modified data. It reduces the operational complexity of table cells and improves the efficiency of table data processing.

Description

Technical Field

[0001] The present disclosure relates to the technical field of table applications, and particularly to a method, a system, and an electronic device for automatically locking modified table cells. Background Art

[0002] In existing table application tools, after a cell is modified, the user needs to manually click to lock the table to avoid being modified and not affecting each other.

[0003] The way that the user manually clicks to lock the table is very inconvenient when making a task plan. For example, when allocating the quantity of products to different provinces, it is necessary to estimate the percentage of the sales volume of last month allocated to ten provinces respectively. However, since there is a special activity in one province this month that requires additional cooperation and the quantity of goods is not unlimited, it is necessary to transfer quotas from other provinces. If the above traditional method of manually clicking to lock the table is adopted, it is necessary to first fill in the quota of this province, then manually calculate the remaining quota, and fill in the table one by one according to the percentage of the sales volume of last month. Such operations are time-consuming and cumbersome, and are prone to errors. Especially when the table has a large number of columns and hierarchical levels, there will be a lot of manual calculations, the operation complexity is higher, and the efficiency is reduced. Summary of the Invention

[0004] To solve the above problems, the present application proposes a method, a system, and an electronic device for automatically locking modified table cells.

[0005] On the one hand, the present application proposes a method for automatically locking modified table cells, including the following steps:

[0006] Calculate the total value of the data of the upper-level dimension in the table;

[0007] According to the total value of the data of the upper-level dimension, based on historical data analysis, automatically allocate the cell values of the lower-level dimension in the table, and lock the total value of the data in the modified table;

[0008] Click on the cell of the lower-level dimension that needs to be modified, and prompt the user for the range of values that can be modified for the lower-level dimension;

[0009] The user enters the modified value in the cell of the lower-level dimension, locks the modified cell, and based on historical data analysis, automatically allocates the cell values of other lower-level dimensions in the table.

[0010] As an optional implementation of the present application, calculating the total value of the data of the upper-level dimension in the table includes:

[0011] Obtain the data values of each upper-level dimension in the table;

[0012] Sum up the data values of each upper-level dimension to obtain the total value of the data of the upper-level dimension in the table.

[0013] As an alternative implementation of the present application, based on historical data analysis, it includes:

[0014] Obtain historical data in the table, including the total value of the superior dimension and the data values of each subordinate dimension in the superior dimension;

[0015] Analyze and calculate the historical proportion of each subordinate dimension based on the historical data in the table;

[0016] Save the historical proportion in the background database.

[0017] As an alternative implementation of the present application, according to the total value of the superior dimension and based on historical data analysis, automatically allocate the numerical values of the subordinate dimension cells in the table and lock the total value of the modified table, including:

[0018] Readjust and modify the total value of the superior dimension in the table according to the total value of the superior dimension;

[0019] Based on historical data analysis, automatically re-allocate the numerical values in each subordinate dimension cell in the table so that the sum of the numerical values in each subordinate dimension cell is equal to the total value of the superior dimension;

[0020] Call the table locking component to lock the superior dimension cell of the modified total value and display the locking mark of the modified superior dimension cell on the table.

[0021] As an alternative implementation of the present application, click on the subordinate dimension cell that needs to be modified to prompt the user for the range of values that can be modified for the subordinate dimension, including:

[0022] Click on the subordinate dimension cell that needs to be modified as the target cell;

[0023] Calculate the upper limit of the value of the target cell:

[0024] Obtain the data value of the superior dimension of the target cell and the locked value at this level, where the locked value at this level refers to: the sum of the numerical values of other subordinate dimension cells in the superior dimension except the target cell;

[0025] Calculate the difference between the data value of the superior dimension and the locked value at this level as the upper limit of the value of the target cell;

[0026] In the target cell, display the upper limit of the value of the target cell and prompt the user for the maximum allowable modification value of this target cell.

[0027] As an alternative implementation of the present application, the user enters the modified value in the lower-level dimension cell, locks the modified cell, and automatically allocates the values of other lower-level dimension cells in the table based on historical data analysis, including:

[0028] Enter the allowable modified value in the target cell and call the table locking component to lock the modified target cell;

[0029] Based on historical data analysis, automatically re-allocate the values of other lower-level dimension cells in the upper-level dimension except the target cell.

[0030] As an alternative implementation of the present application, optionally, when modifying the target cell, it further includes:

[0031] Select whether to lock the target cell:

[0032] If so, when modifying the values of other lower-level dimension cells except the target cell, automatically unlock;

[0033] Conversely, when modifying the values of other lower-level dimension cells except the target cell, remind the user again whether to select locking.

[0034] On the other hand, the present application proposes a system for implementing the automatic locking method for modifying table cells, including:

[0035] A total value calculation module for calculating the total value of the data in the upper-level dimension of the table;

[0036] A numerical value allocation module for automatically allocating the values of the lower-level dimension cells in the table according to the total value of the data in the upper-level dimension and based on historical data analysis, and locking the total value of the modified table;

[0037] A prompt module for clicking on the lower-level dimension cell that needs to be modified to prompt the user with the range of allowable modified values for the lower-level dimension;

[0038] A locking module for the user to enter the modified value in the lower-level dimension cell, lock the modified cell, and automatically allocate the values of other lower-level dimension cells in the table based on historical data analysis.

[0039] On the other hand, the present application also proposes an electronic device, including:

[0040] A processor;

[0041] A memory for storing the executable instructions that can be executed by the processor;

[0042] Wherein, when the processor is configured to execute the executable instructions, it implements the automatic locking method for modifying table cells as described above.

[0043] Technical effects of the present invention:

[0044] In this application, the total value of the data in the upper-level dimension in the table is calculated; based on the total value of the data in the upper-level dimension and historical data analysis, the values of the cells in the lower-level dimension of the table are automatically allocated, and the total value of the modified table is locked; when clicking on the cell in the lower-level dimension that needs to be modified, the user is prompted with the range of values that can be modified for the lower-level dimension; the user enters the modified value in the cell of the lower-level dimension, the modified cell is locked, and based on historical data analysis, the values of the other cells in the lower-level dimension of the table are automatically allocated. It is possible to adjust the data by manually modifying the data of a single cell, and then the manually modified cell will be automatically locked, and based on the analysis of historical data again, the quantities of other cells will be allocated. Applying this function to a list with a determined total value can achieve quick adjustment of the table data and prevent the mutual influence of modifying other data.

[0045] When the table has a large number of columns and hierarchical levels, adopting this solution for locking calculations can reduce the operational complexity of the table cells and improve the efficiency of table data processing.

[0046] Other features and aspects of the present disclosure will become clear from the following detailed description of the exemplary embodiments with reference to the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] The drawings included in and constituting a part of this specification, together with the specification, illustrate the exemplary embodiments, features, and aspects of the present disclosure and are used to explain the principles of the present disclosure.

[0048] Figure 1 It is shown as a schematic diagram of the implementation process of the present invention;

[0049] Figure 2 It is shown as the table of this year before modification of the present invention;

[0050] Figure 3 It is shown as a schematic diagram of the modification target total of the present invention;

[0051] Figure 4 It is shown as a schematic diagram of modifying the lower-level data according to the sales ratio of last year and locking the total value of the present invention;

[0052] Figure 5 It is shown as a schematic diagram of the locked modification of the upper-level dimension "First Quarter" of the present invention;

[0053] Figure 6 It is shown as a schematic diagram of automatically allocating the values of other cells after the modification of the upper-level dimension "First Quarter" of the present invention;

[0054] Figure 7Schematic diagram showing the locked modification of the lower-level dimension "January" of the present invention;

[0055] Figure 8 Schematic diagram showing the automatic allocation of numerical values of other cells after the modification of the lower-level dimension "January" of the present invention;

[0056] Figure 9 Schematic diagram showing the application of the electronic device of the present invention. Detailed implementation manners

[0057] Various exemplary embodiments, features, and aspects of the present disclosure will be described in detail below with reference to the accompanying drawings. The same reference numerals in the drawings denote elements having the same or similar functions. Although various aspects of the embodiments are shown in the drawings, the drawings are not necessarily drawn to scale unless otherwise specified.

[0058] The term "exemplary" used herein means "serving as an example, embodiment, or illustration". Any embodiment described herein as "exemplary" is not necessarily to be construed as superior to or better than other embodiments.

[0059] In addition, for a better description of the present disclosure, numerous specific details are given in the following detailed implementation manners. Those skilled in the art should understand that the present disclosure can be implemented without some specific details. In some instances, well-known means, elements, and circuits have not been described in detail so as to highlight the gist of the present disclosure.

[0060] In the present application, the application architecture of an existing table can be adopted for implementation, and the functional components of the existing table can be called for use. For example, a table locking component is used to lock cells.

[0061] In the present application, the upper and lower levels of dimensions are the dimension levels set in the product. For example, when modifying an annual sales plan table and setting the time dimension level as year / quarter / month, when modifying the sales volume of a month, the quarter is the upper-level dimension of the month. For specific details, reference can be made to the description of the embodiments in the subsequent embodiments.

[0062] Embodiment 1

[0063] As Figure 1 shown, on the one hand, the present application provides a method for automatically locking the modification of table cells, including the following steps:

[0064] S1. Calculate the total value of the data in the upper-level dimension of the table;

[0065] S2. According to the total value of the data in the upper-level dimension and based on historical data analysis, automatically allocate the numerical values of the cells in the lower-level dimension of the table, and lock the total value of the data in the modified table;

[0066] S3. Click on the lower-level dimension cell that needs to be modified, and prompt the user for the range of values that can be modified for the lower-level dimension;

[0067] S4. The user enters the modified value in the lower-level dimension cell, locks the modified cell, and based on historical data analysis, automatically assigns the values of other lower-level dimension cells in the table.

[0068] This solution mainly automatically assigns the value of each cell in the lower-level dimension according to the total sum of the data in the upper-level dimension and based on historical data analysis. Users can adjust the data by manually modifying the data of a single cell, and then the manually modified cell will be automatically locked. And based on historical data analysis again, the quantities of other cells will be re-assigned. Apply this function to a list with a determined total value to quickly adjust the table data and prevent the modification of other data from affecting each other.

[0069] Data product tables automatically assign the values of lower-level cells according to the upper-level total value and based on historical data analysis, prompt the modification range. After modifying a single cell, the modified cell is automatically locked, and the values of other cells are re-assigned, and other related products.

[0070] The following will be described in conjunction with a detailed solution and the accompanying drawings of the embodiments. Take the sales table as an example.

[0071] As an optional implementation solution of the present application, calculating the total value of the data in the upper-level dimension in the table includes:

[0072] Obtain the data values of each upper-level dimension in the table;

[0073] Sum up the data values of each upper-level dimension to obtain the total value of the data in the upper-level dimension in the table.

[0074] The total sum of the data in the upper-level dimension can be automatically generated by the system or manually input by the user. For example, the initial sales target of the whole company this year is the sales amount of last year, but the user can also update and input it according to their own business conditions and market conditions.

[0075] As Figure 2 shown, for example, the cell of the upper-level dimension "First Quarter" (data value is 300), which contains 3 lower-level dimension cells, January, February, and March, with data values of 150, 100, and 50 respectively. There are a total of four upper-level dimensions. The total value of the data of the 4 upper-level dimensions is 1200.

[0076] As an optional implementation solution of the present application, based on historical data analysis includes:

[0077] Obtain the historical data in the table, including the total value of the data in the upper-level dimension and the data values of each lower-level dimension in the upper-level dimension;

[0078] Analyze and calculate the historical proportions of each lower-level dimension based on the historical data in the table;

[0079] Save the historical proportions in the background database.

[0080] Historical data analysis mainly involves the sales data of each upper and lower level dimension last year. You can retrieve and view the sales table of last year to obtain the total value of the upper-level dimension and the data values of each lower-level dimension within the upper-level dimension, and calculate the sales ratio of last year based on this. It can be calculated by the user themselves or automatically by the table system.

[0081] As an optional implementation scheme of this application, based on the total value of the upper-level dimension and according to historical data analysis, automatically allocate the cell values of the lower-level dimension in the table and lock the total value of the modified table, including:

[0082] Readjust and modify the total value of the upper-level dimension in the table according to the total value of the upper-level dimension;

[0083] According to historical data analysis, automatically reallocate the values in each cell of the lower-level dimension in the table so that the sum of the values in each cell of the lower-level dimension is equal to the total value of the upper-level dimension;

[0084] Call the table locking component to lock the cell of the upper-level dimension with the modified total value and display the locking mark of the modified cell of the upper-level dimension on the table.

[0085] As Figure 3 shown, readjust and modify the total value of the upper-level dimension in the table, that is, adjust the total value of the upper-level dimension in the table. For example, the user modifies the target total, such as changing 1200 to the total sales target for this year: 2400.

[0086] After modification, the table system will display "Table Locking Component" in each cell to remind the user whether to lock the modified value (the value re-entered into the cell) after modification.

[0087] When the startup lock is enabled, after modifying the data in the upper-level cell, the system will automatically calculate the percentage of the lower-level cells based on historical data (which needs to be calculated through big data by the table system itself), and reallocate the data of the lower-level cells so that the sum of the lower-level totals is equal to the value of the upper level.

[0088] As Figure 4 shown, after the total value is modified and locked, the locking status of the total value cell of the table is displayed through zebra stripes on the total value cell.

[0089] As an alternative implementation of this application, when the user clicks on a lower-level dimension cell that needs to be modified, a prompt will show the range of values that can be modified for the lower-level dimension, including:

[0090] Click on the lower-level dimension cell that needs to be modified as the target cell.

[0091] Calculate the upper limit of the value of the target cell:

[0092] Obtain the data value of the upper-level dimension of the target cell and the locked value at this level. Here, the locked value at this level refers to the sum of the values of other lower-level dimension cells in the upper-level dimension except the target cell.

[0093] Calculate the difference between the data value of the upper-level dimension and the locked value at this level as the upper limit of the value of the target cell.

[0094] In the target cell, display the upper limit of the value of the target cell and prompt the user for the maximum allowable modification value for this target cell.

[0095] In this solution, the user can modify the value of the target cell at this level (quarter) or at the lower level (month).

[0096] The target cell is determined by the user. After initially selecting the target cell and modifying the value in the target cell, the values of other lower-level dimension cells can be automatically adjusted according to the historical sales ratios of each lower-level dimension cell.

[0097] As Figure 5 shown, for the modification illustration of the upper-level dimension, when modifying the cell data of the upper-level dimension, lock the other upper-level dimension cells. The user can adjust the data by manually modifying the data of a single cell.

[0098] When the total value is locked and the data at the same level needs to be adjusted, when the user clicks on the target cell (such as the value where the first quarter is located) to edit the value, a prompt will show the modifiable range based on the value of the upper-level dimension and the locked value at this level (such as the sum of the values of the second, third, and fourth quarters, which is the locked value). The formula is "Maximum modification range = Value of the upper-level dimension - Sum of the locked values". After modification, the remaining unlocked cells will reallocate the data of the cells at this level according to the percentage calculated from the historical data.

[0099] As Figure 6 shown, when the value in the first quarter cell is modified to 1200, it will be automatically locked and shown as the locked state. The other lower-level dimension cells will automatically recalculate and fill in the values according to the historical analysis sales ratio.

[0100] As Figure 7As shown in the figure, it is a schematic diagram for modifying the values of lower-level dimensions. When it is necessary to modify the target cell (lower-level dimension cell) under a certain upper-level dimension, the lower-level dimension cells in the upper-level dimension except the target cell are locked. When modifying the value in the January cell (target cell) in the first quarter, the values in the February and March cells will be locked.

[0101] In this embodiment, it is preferred to modify and lock the target cell in the lower-level dimension.

[0102] As an alternative implementation of this application, the user enters the modified value in the lower-level dimension cell, locks the modified cell, and automatically allocates the values of other lower-level dimension cells in the table based on historical data analysis, including:

[0103] Enter the allowable modified value in the target cell and call the table locking component to lock the modified target cell;

[0104] Based on historical data analysis, automatically re-allocate the values of other lower-level dimension cells in the upper-level dimension except the target cell.

[0105] As Figure 8 As shown in the figure, it is a schematic diagram of the table when the user actively modifies January in the first quarter. When modifying the value in the January cell (target cell) in the first quarter, the values in the February and March cells will be locked. The sum of the locked values is calculated to be 540. Therefore, the maximum value of the January value can be calculated to be 660, and 660 is automatically entered or manually entered.

[0106] After input, lock the January cell where 660 is located and display the locked state.

[0107] As an alternative implementation of this application, optionally, when modifying the target cell, it further includes:

[0108] Select whether to lock the target cell:

[0109] If so, when modifying the values of other lower-level dimension cells except the target cell, the lock is automatically released;

[0110] Conversely, when modifying the values of other lower-level dimension cells except the target cell, the user is reminded again whether to select locking.

[0111] When the user modifies a cell, they can choose to check the box to lock the modification result or not. When choosing to lock the modification result, the user will default to checking it when modifying other cells until it is switched to not locking the modification result. Since the user's modifications are usually continuous, it can help the user reduce the number of operation steps. After locking the modification result, the locked state will be displayed in zebra stripes on the table, and when hovering over the cell, an unlock button will be displayed.

[0112] Unlocked cells can click on the icon to lock the cell, which is consistent with the automatic locking logic.

[0113] Perform quantity allocation for other cells and apply this function to a list with a determined total value to quickly adjust the table data and prevent the modification of other data from affecting each other.

[0114] Specific maximum value display reminders and locked state display reminders can be implemented in combination with the functional components of the table system.

[0115] The input of the above steps can be that the user manually enters a value and other cells are automatically allocated, or it can be automatically allocated by the system.

[0116] Obviously, those skilled in the art should understand that to implement all or part of the processes in the above embodiments, it can be completed by instructing relevant hardware through a computer program. The program can be stored in a computer-readable storage medium. When the program is executed, it can include the processes of the above control embodiments. Those skilled in the art can understand that to implement all or part of the processes in the above embodiments, it can be completed by instructing relevant hardware through a computer program. The program can be stored in a computer-readable storage medium. When the program is executed, it can include the processes of the above control embodiments. Among them, the storage medium can be a magnetic disk, an optical disc, a Read-Only Memory (ROM), a Random Access Memory (RAM), a Flash Memory, a Hard Disk Drive (abbreviation: HDD), or a Solid-State Drive (SSD), etc.; the storage medium can also include a combination of the above types of memories.

[0117] Embodiment 2

[0118] Based on the implementation principle of Embodiment 1, on the other hand, this application proposes a system for implementing the method for automatically locking the modification of table cells, including:

[0119] A total value calculation module for calculating the total value of the data in the upper-level dimension in the table;

[0120] A numerical allocation module, which is used to automatically allocate the values of the cells in the lower-level dimension in the table according to the total value of the data in the upper-level dimension based on historical data analysis, and lock the total value of the data in the modified table.

[0121] A prompt module, which is used to click on the cell in the lower-level dimension that needs to be modified and prompt the user for the range of values that can be modified in the lower-level dimension.

[0122] A locking module, which is used for the user to input the modified value in the cell of the lower-level dimension, lock the modified cell, and automatically allocate the values of the other cells in the lower-level dimension in the table based on historical data analysis.

[0123] For the functions and interactions of the various functional modules of the above system, please understand them in combination with the technical principles of Embodiment 1, and they can be understood in combination with the functions of the existing table.

[0124] Each module or step of the present invention described above can be implemented by a general-purpose computing system. They can be concentrated on a single computing system or distributed on a network composed of multiple computing systems. Optionally, they can be implemented by program codes executable by the computing system. Thus, they can be stored in the storage system and executed by the computing system, or they can be separately made into individual integrated circuit modules, or multiple modules or steps among them can be made into a single integrated circuit module to be implemented. In this way, the present invention is not limited to any specific combination of hardware and software.

[0125] Embodiment 3

[0126] As Figure 9 shown, further, on the other hand, the present application also proposes an electronic device, including:

[0127] A processor;

[0128] A memory for storing processor-executable instructions;

[0129] Wherein, the processor is configured to implement the automatic locking method for modifying table cells when executing the executable instructions.

[0130] The electronic device in the embodiments of the present disclosure includes a processor and a memory for storing processor-executable instructions. Among them, the processor is configured to implement the automatic locking method for modifying table cells described in any one of the foregoing when executing the executable instructions.

[0131] Here, it should be noted that the number of processors can be one or more. At the same time, in the electronic device in the embodiments of the present disclosure, an input system and an output system can also be included. Among them, the processor, the memory, the input system, and the output system can be connected through a bus or in other ways, and specific limitations are not made here.

[0132] The memory, as a computer-readable storage medium, can be used to store software programs, computer-executable programs, and various modules, such as the programs or modules corresponding to the automatic locking method for modifying table cells in the embodiments of the present disclosure. The processor executes various functional applications and data processing of the electronic device by running the software programs or modules stored in the memory.

[0133] The input system can be used to receive input numbers or signals. Among them, the signal can be a key signal related to the user settings and function control of the device / terminal / server. The output system can include display devices such as a display screen.

[0134] The embodiments of the present disclosure have been described above. The above description is exemplary and not exhaustive, and is not limited to the disclosed embodiments. Many modifications and variations are obvious to those of ordinary skill in the art in the technical field without departing from the scope and spirit of the described embodiments. The selection of the terms used herein is intended to best explain the principles of the embodiments, the practical application, or the technical improvement of the technology in the market, or to enable other ordinary skill in the art in the technical field to understand the disclosed embodiments.

Claims

1. An automatic locking method for modifying table cells, characterized in that, it includes the following steps: Calculate the total value of the data in the upper-level dimension of the table; According to the total value of the data in the upper-level dimension and based on historical data analysis, automatically allocate the numerical values of the lower-level dimension cells in the table, and lock the total value of the modified table; Click on the lower-level dimension cell that needs to be modified, and prompt the user for the range of modifiable numerical values of the lower-level dimension, including: Click on the lower-level dimension cell that needs to be modified as the target cell; Calculate the upper limit of the numerical value of the target cell: Obtain the data value of the upper-level dimension of the target cell and the locked numerical value at this level, where the locked numerical value at this level refers to: the sum of the numerical values of other lower-level dimension cells in the upper-level dimension except the target cell; Calculate the difference between the data value of the upper-level dimension and the locked numerical value at this level as the upper limit of the numerical value of the target cell; In the target cell, display the upper limit of the numerical value of the target cell and prompt the user for the maximum allowable modification value of this target cell; The user enters the modified numerical value in the lower-level dimension cell, locks the modified cell, and based on historical data analysis, automatically allocates the numerical values of other lower-level dimension cells in the table.

2. The automatic locking method for modifying table cells according to claim 1, characterized in that, calculating the total value of the data in the upper-level dimension of the table includes: Obtain the data values of each upper-level dimension in the table; Sum up the data values of each upper-level dimension to obtain the total value of the data in the upper-level dimension of the table.

3. The automatic locking method for modifying table cells according to claim 1, characterized in that, the historical data analysis includes: Obtain the historical data in the table, including the total value of the data in the upper-level dimension and the data values of each lower-level dimension in the upper-level dimension; According to the historical data in the table, analyze and calculate the historical proportion of each lower-level dimension; Save the historical proportion in the background database.

4. The automatic locking method for modifying table cells according to claim 1, characterized in that, according to the total value of the data in the upper-level dimension and based on historical data analysis, automatically allocate the numerical values of the lower-level dimension cells in the table, and lock the total value of the modified table, including: According to the total value of the data in the upper-level dimension, readjust and modify the total value of the data in the upper-level dimension of the table; Based on historical data analysis, automatically re-allocate the numerical values in each lower-level dimension cell in the table so that the sum of the numerical values in each lower-level dimension cell is equal to the total value of the data in the upper-level dimension; Call the table locking component to lock the upper-level dimension cell of the modified total value and display the locking mark of the modified upper-level dimension cell on the table.

5. The automatic locking method for modifying table cells according to claim 1, characterized in that, when the user enters the modified numerical value in the lower-level dimension cell, locks the modified cell, and based on historical data analysis, automatically allocates the numerical values of other lower-level dimension cells in the table, including: Enter the allowable modified numerical value in the target cell and call the table locking component to lock the modified target cell; Automatically redistribute the values in the lower-level dimension cells other than the target cell in the upper-level dimension based on historical data analysis.

6. A method for automatically locking the modification of table cells according to claim 5, characterized in that, when modifying the target cell, it further includes: selecting whether to lock the target cell: if so, when modifying the values in the lower-level dimension cells other than the target cell, automatically unlock; otherwise, when modifying the values in the lower-level dimension cells other than the target cell, remind the user again whether to select locking.

7. A system for implementing the method for automatically locking the modification of table cells according to any one of claims 1-6, characterized in that, it includes: a total value calculation module for calculating the total value of the data in the upper-level dimension of the table; a value distribution module for automatically distributing the values of the lower-level dimension cells in the table according to the total value of the data in the upper-level dimension based on historical data analysis, and locking the total value of the modified table; a prompt module for clicking on the lower-level dimension cell to be modified to prompt the user for the range of values that can be modified in the lower-level dimension, including: clicking on the lower-level dimension cell to be modified as the target cell; calculating the upper limit of the value of the target cell: obtaining the data value of the upper-level dimension of the target cell and the locked value of this level, where the locked value of this level refers to: the sum of the values of other lower-level dimension cells in the upper-level dimension except the target cell; calculating the difference between the data value of the upper-level dimension and the locked value of this level as the upper limit of the value of the target cell; displaying the upper limit of the value of the target cell in the target cell and prompting the user for the maximum allowable modification value of this target cell; a locking module for the user to input the modified value in the lower-level dimension cell, locking the modified cell, and automatically distributing the values of other lower-level dimension cells in the table based on historical data analysis.

8. An electronic device, characterized in that, it includes: a processor; a memory for storing instructions executable by the processor; wherein, the processor is configured to implement the method for automatically locking the modification of table cells according to any one of claims 1-6 when executing the executable instructions.

Images