Report Processing Method, Device, Equipment, and Storage Medium Based on a Report System

Abstract

The present application relates to a report processing method, apparatus, device, and storage medium based on a report system. The method includes: in the case where data needs to be automatically written into a report of the report system, determining at least one cell into which data needs to be automatically written; the at least one cell includes at least one target cell that is pre-customized and locked and in a custom-locked state; after the automatic data writing is completed, for each target cell, based on the absolute position of the target cell in the report before the automatic data writing, determining the target cell; covering the original cell information of the target cell to the target cell after the automatic data writing; the original cell information is the cell information of the target cell before the automatic data writing, and the target cell after being covered remains in the custom-locked state. Using this method can improve the flexibility of report processing.

Description

Technical Field

[0001] This application relates to the field of software technology, and in particular, to a report processing method, device, equipment, and storage medium based on a report system. Background Art

[0002] With the development of computers, people use the functions of computers for data processing and interface design to generate and display reports. Reports on computers can help enterprises access, format data, and present the data to users. Cells in a report can be manually modified by users. For example, the values or formulas in the cells are re-edited by users. Cells in a report can also be automatically written with data by a computer. For example, dimension value filling, re-fetching data, etc. are performed on the entire report, so that multiple cells in the report are automatically modified by the computer.

[0003] However, in some scenarios, there are cells in a report that users do not want to be automatically modified. For example, in order to avoid non-compliance of departmental expenses, cells for describing departmental expense specifications are set, etc. After the data is automatically written, the original cell information such as the data, style, and formula of these cells is lost, resulting in the enterprise being unable to use the report as expected and causing accidents. Therefore, such a report processing method is not flexible enough to meet the needs of users. Summary of the Invention

[0004] Based on this, in view of the above technical problems, it is necessary to provide a report processing method, device, computer equipment, storage medium, and computer program product based on a report system that can improve processing flexibility.

[0005] In a first aspect, this application provides a report processing method based on a report system. The method includes:

[0006] When it is necessary to automatically write data to a report in a report system, determine at least one cell to which data needs to be automatically written; at least one target cell in the at least one cell is in a custom locked state and is pre-customized and locked;

[0007] After the data is automatically written, for each target cell, determine the target cell based on the absolute position of the target cell in the report before the data is automatically written;

[0008] Overwrite the original cell information of the target cell to the target cell after the data is automatically written; the original cell information is the cell information of the target cell before the data is automatically written, and the target cell after being overwritten remains in the custom locked state.

[0009] In one embodiment, the report includes multiple regions, and the method further includes:

[0010] In response to a locking operation on a selected region in the report, set the cells within the selected region to a custom locked state.

[0011] In one embodiment, a locking control is provided in the report; the setting the state of the cells within the selected region to a custom locked state in response to a locking operation on the selected region in the report includes:

[0012] In response to a triggering operation on the locking control, display a set of locking region options; the set of locking region options includes multiple locking region options respectively for locking different regions;

[0013] Determine a target locking region option selected from the set of locking region options, and set the cells within the region indicated by the target locking region option to a custom locked state.

[0014] In one embodiment, the report further includes cells in an automatic locked state; the automatic locked state is set automatically according to the usage attributes of the cells; the method further includes:

[0015] In response to an unlocking operation on a selected region in the report, set the cells within the selected region and in a locked state to an unlocked state; wherein, the locked state is any one of the custom locked state and the automatic locked state.

[0016] In one embodiment, an unlocking control is provided in the report; the setting the cells within the selected region and in a locked state to an unlocked state in response to an unlocking operation on the selected region in the report includes:

[0017] In response to a triggering operation on the unlocking control, display a set of unlocking region options respectively for unlocking different regions;

[0018] Determine a target unlocking region option selected from the set of unlocking region options, and set the cells within the region indicated by the target locking region option and in a locked state to an unlocked state.

[0019] In one embodiment, the method further includes:

[0020] In response to a manual modification operation on any selected cell in the report, obtain the state of the selected cell;

[0021] If the state is a custom locking state or an automatic locking state, it is confirmed that modification of the selected cell is not supported;

[0022] If the state is an unlocked state, it is confirmed that modification of the selected cell is supported.

[0023] In one embodiment, the report is generated based on a distributed report template; the method further includes:

[0024] Determine a main report template; at least one cell in the main report template is in a custom locking state;

[0025] In response to a template distribution operation for the main report template, create a distributed report template that inherits the locking state of the cells in the main report template; the locking state includes the custom locking state;

[0026] In response to a report generation operation for the distributed report template, inherit the locking state of the cells in the distributed report template into the report.

[0027] In one embodiment, determining the target cell based on the absolute position of the target cell in the report before automatically writing data includes:

[0028] If the absolute position of the target cell is variable, determine the position change value of the target cell; the position change value is the change value of the absolute position of the target cell in the report before and after automatically writing data;

[0029] Based on the absolute position of the target cell before automatically writing data and the position change value, determine the new absolute position of the target cell after automatically writing data;

[0030] Determine the target cell after automatically writing data according to the new absolute position.

[0031] In one embodiment, when setting the cells in the selected area of the report that are in a locked state to an unlocked state in response to an unlocking operation for the selected area in the report includes:

[0032] In response to an unlocking operation for the selected area in the report, determine whether the operator of the unlocking operation has the unlocking permission for the selected area;

[0033] When the operator has the unlocking permission, set the cells in the selected area that are in a locked state to an unlocked state.

[0034] In a second aspect, the present application also provides a report processing device based on a report system. The device includes:

[0035] A determination module, configured to determine at least one cell for which data needs to be automatically written in the case where data needs to be automatically written into a report of the report system; at least one of the at least one cell is a target cell in a custom locked state that is pre-custom locked;

[0036] The determination module is further configured to, after the automatic data writing is completed, for each target cell, determine the target cell based on the absolute position of the target cell in the report before the automatic data writing;

[0037] A restoration module, configured to overwrite the original cell information of the target cell onto the target cell after the automatic writing; the original cell information is the cell information of the target cell before the automatic data writing, and the target cell after being overwritten remains in the custom locked state.

[0038] In a third aspect, the present application also provides a computer device. The computer device includes a memory and a processor, the memory stores a computer program, and the processor executes the steps of the above-mentioned report processing method based on the report system.

[0039] In a fourth aspect, the present application also provides a computer-readable storage medium. The computer-readable storage medium stores a computer program thereon, and the computer program is executed by the processor to perform the steps of the above-mentioned report processing method based on the report system.

[0040] In a fifth aspect, the present application also provides a computer program product. The computer program product includes a computer program, and the computer program is executed by the processor to perform the steps of the above-mentioned report processing method based on the report system.

[0041] The above-mentioned report processing method, device, computer equipment, storage medium and computer program product based on the report system, when it is necessary to automatically write data into the report of the report system, determine at least one cell that needs to be automatically written with data; at least one of the at least one cell includes at least one target cell in a custom locked state that is pre-custom locked. It can be understood that the custom locked state is a locked state defined by the user himself, that is, the target cell is specified by the user. After the automatic data writing is completed, for each target cell, based on the absolute position of the target cell in the report before the automatic data writing, determine the target cell. Overwrite the original cell information of the target cell to the target cell after the automatic data writing. Among them, the original cell information is the cell information of the target cell before the automatic data writing, and the target cell after being overwritten remains in the custom locked state. Therefore, the target cell after the automatic data writing retains the cell information before the automatic data writing, enabling the enterprise to use the report normally according to the expected requirements and reducing the error rate. And, according to the information in the cell information indicating the custom locked state, the target cell after the automatic data writing remains in the custom locked state. In the case of repeatedly executing the automatic data writing, the most original cell information of the target cell can still be retained. Therefore, the requirement that the cells specified by the user are not automatically modified is satisfied, thereby improving the flexibility of report processing. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] Figure 1 is a schematic flowchart of a report processing method based on a report system in an embodiment;

[0043] Figure 2 is a schematic diagram of the interface of a report processing method based on a report system in an embodiment;

[0044] Figure 3 is a schematic diagram of the interface of a report processing method based on a report system in an embodiment;

[0045] Figure 4 is a schematic diagram of the interface of a report processing method based on a report system in an embodiment;

[0046] Figure 5 is a schematic diagram of the interface of a report processing method based on a report system in an embodiment;

[0047] Figure 6 is a schematic diagram of the interface of a report processing method based on a report system in an embodiment;

[0048] Figure 7 is a schematic diagram of the interface of a report processing method based on a report system in an embodiment;

[0049] Figure 8 It is a structural block diagram of a report processing device based on a report system in an embodiment;

[0050] Figure 9 It is an internal structure diagram of a computer device in an embodiment. Specific implementation manners

[0051] In order to make the objectives, technical solutions and advantages of the present application clearer and more understandable, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0052] In an embodiment, as Figure 1 shown, a report processing method based on a report system is provided. In this embodiment, an example is given where this method is applied to a terminal. It can be understood that this method can also be applied to a server, and can also be applied to a system including a terminal and a server, and is implemented through the interaction between the terminal and the server. In this embodiment, the method includes the following steps:

[0053] S102, in the case where it is necessary to automatically write data to a report of a report system, determine at least one cell to which data needs to be automatically written; at least one cell includes at least one target cell in a custom locked state that is pre-custom locked.

[0054] Among them, the report system is a software system designed specifically for report data processing by combining computer technology with accounting report preparation methods. The locked state is used to represent the state in which a cell is locked. The custom locked state is a locked state obtained by the user's own definition, that is, the locked state specified by the user. There are many ways for the user to define. For example, the user can manually select a cell to specify it as the locked state, or enter the row and column information corresponding to the cell in the locked column to specify it as the locked state, etc. No limitation is made thereto.

[0055] In an embodiment, before the execution of step S102, if the area to which the target cell belongs is specified to be locked, the terminal sets the target cell to the custom locked state.

[0056] In an embodiment, the terminal displays a plurality of locked area options on the report system interface, and the locked area options are used to specify the areas that can be locked.

[0057] In an embodiment, the locked state includes a custom locked state and an automatic locked state. The automatic locked state is a locked state that is automatically locked according to the usage attribute of the cell. If an area is specified to be unlocked, the terminal sets the cells within the area and in the locked state to the unlocked state.

[0058] In one embodiment, the terminal displays multiple unlock area options on the report system interface, and the unlock area options are used to specify the areas that can be unlocked.

[0059] In one embodiment, the report system further includes a main report template. When distributing the main report template, the terminal creates a distributed report template that inherits the locked state of the cells in the main report template. When creating a report using the distributed report template, the terminal inherits the locked state of the cells in the distributed report template into the report.

[0060] In one embodiment, the report is edited using SpreadJS. SpreadJS is a pure front-end table control based on HTML (HyperText Markup Language), providing an operation interface and open interfaces similar to Excel (spreadsheet software). Integrating SpreadJS with the report system can quickly implement functions such as report import and export, data formatting, formula calculation, and online data filling.

[0061] S104, after the automatic data writing is completed, for each target cell, based on the absolute position of the target cell in the report before the automatic data writing, determine the target cell.

[0062] Among them, the absolute position is used to determine the target cell from multiple cells. It can be understood that different from the relative position, using the absolute position can exclude the interference of other relative factors.

[0063] In one embodiment, the absolute position of a cell in the report can be the row and column information of the cell.

[0064] Specifically, the process of the terminal executing the automatic data writing, it can be understood that the process of the automatic data writing is diversified. After the terminal confirms that the automatic data writing is completed, for each target cell, based on the absolute position of the target cell in the report before the automatic data writing, determine the target cell. It can be understood that this method does not require re-development of the automatic data writing process, does not interfere with the automatic data writing process, and can be decoupled from various automatic data writing processes, thereby reducing the development cost and the error rate.

[0065] In one embodiment, the terminal can determine whether the absolute position of the target cell is variable. If it is variable, the terminal determines the position change value of the target cell. The terminal determines the new absolute position of the target cell after the data is automatically written based on the position change value and the absolute position. After the data is automatically written, the target cell is determined according to the new absolute position. For example, in the case of filling dimension values in a report, the absolute position of the target cell may change. Therefore, the new absolute position is calculated based on the position change value, so as to determine the target cell, meeting different requirements and improving the flexibility of report processing.

[0066] In one embodiment, the terminal can determine whether to update the absolute position according to the cell position attribute or the data characteristics during the process of automatically writing data. Among them, the cell position attribute can be specified or default. For example, if the position attribute for the first cell is set to static, the terminal determines that the absolute position will not change before and after the data is automatically written. If the position attribute for the first cell is set to dynamic, the terminal determines that the absolute position can change before and after the data is automatically written. For example, rows 5 - 9 are the information of the first department, and rows 10 - 14 are the information of the second department. After a dimension filling, the first department adds 3 rows based on the original row 5, and the second department adds 4 rows based on the original row 10. If the cell in the automatically locked state for the second department was originally in row 11, then the cell in the automatically locked state can be updated to row 14 of the second department, that is, the absolute position has changed. It can be understood that by using the cell position attribute or the data characteristics during the process of automatically writing data to confirm whether a new absolute position needs to be calculated, various diverse requirements are met, and the flexibility of report processing is improved.

[0067] S206, overwrite the original cell information of the target cell to the target cell after the data is automatically written; the original cell information is the cell information of the target cell before the data is automatically written, and the overwritten target cell maintains the custom locked state.

[0068] Among them, the cell information is the information related to the cell, and can include at least one of the cell value, formula, locked state, etc.

[0069] Specifically, the terminal overwrites the original cell information of the target cell to the target cell after the data is automatically written. Among them, the original cell information is the cell information of the target cell before the data is automatically written, and the overwritten target cell maintains the custom locked state. It can be understood that the terminal can pre - save the original cell information before the data is automatically written, or the report system can default to generate a copy of the entire report, and then obtain the original cell information from the copy, etc. There is no limitation on this.

[0070] For example, as Figure 2 shown, Figure 2 the report shows the expense situation and its description for Department A. If Figure 2 there are no cells in the automatic locking state in Figure 2 after dimension filling of Figure 3 the report is as Figure 3 shown. Among them, Figure 3 does not retain the information of the cells in Figure 2 If Figure 2 cell 201 in Figure 2 is in the custom locking state, then after dimension filling of Figure 4 the report is as Figure 4 shown. Among them,

[0071] In one embodiment, each cell has a corresponding label for storing the annual, period, organization, project data type, dimension combination information, locking state, etc. of the cell. The terminal can traverse the cells in the report, determine the cells in the custom locking state according to the corresponding labels, and save the cell information of these cells in the custom locking state.

[0072] In one embodiment, before the cell is manually modified, the terminal obtains the state of the cell and determines whether it supports being manually modified according to the state of the cell. Among them, the state includes the custom locking state, the automatic locking state, and the unlocked state.

[0073] The above-mentioned report processing method based on a report system, when it is necessary to automatically write data into the reports of the report system, determines at least one cell that needs to have data automatically written into it; at least one of the at least one cell is a target cell in a custom locked state that is pre-customized and locked. It can be understood that the custom locked state is a locked state defined by the user himself, that is, the target cell is specified by the user. After the data is automatically written, for each target cell, based on the absolute position of the target cell in the report before the data is automatically written, the target cell is determined. The original cell information of the target cell is overwritten to the target cell after the data is automatically written. Among them, the original cell information is the cell information of the target cell before the data is automatically written, and the target cell after being overwritten remains in the custom locked state. Therefore, the target cell after being automatically written retains the cell information before the data is automatically written, enabling the enterprise to use the report normally according to the expected requirements and reducing the error rate. Moreover, according to the information in the cell information indicating the custom locked state, the target cell after being automatically written remains in the custom locked state. In the case of repeatedly executing the automatic data writing, the most original cell information of the target cell can still be retained. Therefore, the requirement that the cells specified by the user are not automatically modified is satisfied, thereby improving the flexibility of report processing.

[0074] In one embodiment, the report includes multiple regions, and the method further includes: in response to a locking operation on a selected region in the report, setting the cells in the selected region to the custom locked state.

[0075] Among them, the region includes at least one cell, which can be understood as a set of cells. The positions of the multiple cells in the region in the report can be discontinuous or continuous, and no limitation is made in this regard.

[0076] Specifically, the report includes multiple regions, and the terminal, in response to a locking operation on a selected region in the report, sets the cells in the selected region to the custom locked state.

[0077] In one embodiment, the region includes a formula region, and the formula region is composed of cells with formula information. It can be understood that the positions of the cells with formula information can be continuous or discontinuous, and these cells with formula information together form a formula region.

[0078] In one embodiment, the region includes a custom region, a formula region of the style scheme to which the report belongs, a formula region of the current table, and a formula region of all tables. Among them, the custom region refers to the region defined by the user himself. For example, it can be at least one cell selected by the user. The style scheme is a scheme of the style of the report, and the report has a corresponding style scheme. The report can be composed of multiple tables. The formula region of the current table is the formula region of the currently edited table, and the formula region of all tables is the formula region of all tables that make up the report.

[0079] In this embodiment, by performing a locking operation on the selected region, the cells within the selected region can be triggered to be set to the custom locked state. In this way, the user does not need to specify cells for locking one by one, and can lock a set of cells at one time, reducing user operations and reducing computer resource overhead.

[0080] In one embodiment, a locking control is provided in the report; in response to a locking operation on the selected region in the report, setting the state of the cells within the selected region to the custom locked state includes: in response to a triggering operation on the locking control, presenting a set of locking region options; the set of locking region options includes a plurality of locking region options for locking different regions respectively; determining a target locking region option selected from the set of locking region options, and setting the cells within the region indicated by the target locking region option to the custom locked state.

[0081] Specifically, a locking control is provided in the report. The terminal presents a set of locking region options in response to a triggering operation on the locking control. Among them, the set of locking region options includes a plurality of locking region options for locking different regions respectively. The terminal further determines a target locking region option selected from the set of locking region options according to the user's selection, and sets the cells within the region indicated by the target locking region option to the custom locked state. For example, as Figure 5 shown, the report system interface includes a "Lock" control for locking. The user clicks and triggers the "Lock" control, and the terminal presents a set of locking region options. The set of locking region options includes a plurality of locking region options for locking different regions respectively, namely options such as "Lock Selected Region", "Lock Style Formula Region", "Lock Current Table Formula Region", and "Lock All Table Formula Regions". It can be understood that the region corresponding to "Lock Selected Region" belongs to the custom region and is the region selected by the user. If the user selects "Lock Current Table Formula Region", the terminal determines the selected locking region option of "Lock Current Table Formula Region", and sets the cells within the region indicated by the locking region option of "Lock Current Table Formula Region", that is, the formula region of the current table, to the custom locked state.

[0082] In this embodiment, by presenting a set of locked area options, the user can select a target locked area option on the interface, so as to set the cells within the area indicated by the target locked area option to a custom locked state. In this way, the user can conveniently select the target locked area without manual input, reducing user operations and error rates.

[0083] In one embodiment, the report further includes cells in an automatically locked state; the automatically locked state is set automatically according to the usage attributes of the cells; the method further includes: in response to an unlocking operation on a selected area in the report, setting the cells within the selected area and in a locked state to an unlocked state; where the locked state is any one of the custom locked state and the automatically locked state.

[0084] Specifically, the report further includes cells in an automatically locked state. In response to an unlocking operation on a selected area in the report, the terminal traverses the cells within the selected area, determines the cells in a locked state, and sets these cells to an unlocked state; where the locked state is any one of the custom locked state and the automatically locked state.

[0085] In one embodiment, the usage attributes of the cells can be at least one of subtotal, total, summary, dimension header, etc. It can be understood that if the cells are statistical cells used to display information such as subtotals and totals, the terminal can set these statistical cells to an automatically locked state. For example, Figure 3 301 in is "subtotal", and the terminal can set 301 to a cell in an automatically locked state. Figure 6 601 in is a dimension header, and the terminal can also set 601 to a cell in an automatically locked state. For example, the user can unlock 601, and the terminal sets 601 to an unlocked state.

[0086] In this embodiment, the user can perform an unlocking operation to set the cells in the custom locked state and the automatically locked cells to an unlocked state, meeting the diverse customization needs of the user, and thus improving the flexibility of report processing.

[0087] In one embodiment, an unlocking control is provided in the report; in response to an unlocking operation on a selected area in the report, setting the cells within the selected area and in a locked state to an unlocked state includes: in response to a triggering operation on the unlocking control, presenting a set of unlocking area options for locking different areas; determining a target unlocking area option selected from the set of unlocking area options, and setting the cells within the area indicated by the target locked area option and in a locked state to an unlocked state.

[0088] Specifically, an unlocking control is provided in the report. In response to a triggering operation on the unlocking control, the terminal displays a set of unlocking area options for locking different areas respectively. The terminal determines the target unlocking area option selected from the set of unlocking area options, and sets the cells located within the area indicated by the target locking area option and in the locked state to the unlocked state. For example, as Figure 7 shown, the report system interface includes an "Unlock" control for unlocking. When the user clicks and triggers the "Unlock" control, the terminal displays a set of unlocking area options, which includes multiple unlocking area options for unlocking different areas respectively, namely "Unlock Selected Area", "Unlock Style Formula Area", "Unlock Current Table Formula Area", and "Unlock All Table Formula Areas". If the user selects "Unlock All Table Formula Areas", the terminal determines the selected locking area option of "Unlock All Table Formula Areas", and sets the cells located within the area indicated by the unlocking area option of "Unlock All Table Formula Areas", that is, within all table formula areas and in the locked state, to the unlocked state.

[0089] In this embodiment, by displaying the set of unlocking area options, the user can select the target unlocking area option on the interface, so that the cells located within the area indicated by the target unlocking area option and in the locked state are set to the unlocked state. In this way, the user can conveniently select the target unlocking area without manual input by the user, reducing user operations and the error rate.

[0090] In one embodiment, the method further includes: in response to a manual modification operation on any selected cell in the report, obtaining the state of the selected cell; if the state is the custom locking state or the automatic locking state, it is confirmed that the modification of the selected cell is not supported; if the state is the unlocked state, it is confirmed that the modification of the selected cell is supported.

[0091] Specifically, in response to a manual modification operation on any selected cell in a report, the terminal obtains the status of the selected cell. If the status is the custom lock state or the automatic lock state, it is confirmed that modification of the selected cell is not supported. If the status is the unlocked state, it is confirmed that modification of the selected cell is supported. For example, cell 601 is an automatically locked cell. When the user manually modifies cell 601, the terminal confirms that modification of cell 601 is not supported. If the user unlocks 601, the terminal sets 601 to the unlocked state. When 601 is in the unlocked state and the user manually modifies cell 601, the terminal confirms that modification of cell 601 is supported, that is, the user can perform manual modification. For another example, in a report of the budget summary type, the report system defaults to setting all cells to the automatic lock state. However, in some specific scenarios, the user needs to modify some calculation column formulas in the budget summary table. In this case, after the user unlocks the area where the cell to be modified is located, the terminal supports modification of the cell, that is, the user can modify some calculation column formulas in the budget summary table.

[0092] In this embodiment, by determining the status of the cell to determine whether to support manual modification of the selected cell, it is possible to avoid operating on cells that cannot be manually modified, improve the standardization of report usage, and reduce the error rate. Moreover, if a traditional report system is used to modify the dimension header, it is necessary to copy the original report data and then paste it into another newly created interface that is not created by the report system but can be freely edited for modification. However, the modified report no longer belongs to the report system and cannot be stored in the database of the report system, nor can the report processing functions provided by the report system be called. Compared with the traditional report system, this method can unlock the dimension header on the report system for manual modification, and the manually modified report can be synchronized to the database in the report system, enabling the report data to be normally saved and the report processing functions provided by the report system to be normally called. Without generating negative effects, the editing of the dimension header is realized, thereby improving the flexibility of report processing.

[0093] In one embodiment, the report is generated based on a distributed report template; the method further includes: determining a main report template; the main report template includes at least one cell in the custom lock state; in response to a template distribution operation on the main report template, creating a distributed report template that inherits the lock state of the cells in the main report template; the lock state includes the custom lock state; in response to a report generation operation on the distributed report template, inheriting the lock state of the cells in the distributed report template to the report.

[0094] Among them, the report template is the template used by the report, which can constrain the format of the report. The distributed report template is generated by distributing the main report template. For example, the main report template can be made by the first group, and the first group distributes the main report template to the first company, the second company, and the third company under the first group. After the first, second, and third companies obtain the distributed template, they can all modify and customize the distributed template on their respective distributed templates or use it to generate reports.

[0095] Specifically, in response to a template distribution operation for the main report template, the terminal creates a distributed report template that inherits the locked state of the cells in the main report template. Among them, the locked state includes a custom locked state. It can be understood that the cells belonging to the custom locked state in the distributed report template are the same as those in the main report template. In response to a report generation operation for the distributed report template, the terminal inherits the locked state of the cells in the distributed report template to the report. It can be understood that the cells belonging to the custom locked state in the report are the same as those in the distributed report template.

[0096] In this embodiment, between the main report template and the distributed report template, and between the distributed report template and the report, the locked state including the custom locked state of the cells is inherited. In this way, the use of the report can be standardized through the main report template, reducing user operations, reducing the error rate, and reducing the computer resource overhead.

[0097] In one embodiment, in response to an unlocking operation for a selected area in the report, it is judged whether the operator of the unlocking operation has the unlocking permission for the selected area; in the case where the operator has the unlocking permission, the cells within the selected area and in the locked state are set to the unlocked state. It can be understood that by judging the unlocking permission, it is avoided that users without the unlocking permission unlock the cells in the locked state, improving the security and standardization of the report use. Moreover, if the operation permission is set for the area where the cells in the custom locked state in the main template are located, users of the distributed template and the report cannot modify these cells in the locked state without the operation permission, thereby achieving the effect of centralized control, avoiding unauthorized modification by users without the unlocking permission, and improving the security and standardization of the entire report system.

[0098] In one embodiment, at least one cell includes a cell in an auto-lock state, and the method further includes: obtaining the absolute position of the auto-lock cell in the report before automatically writing data; after the automatic data writing is completed, for each auto-lock cell, determining the auto-lock cell after the automatic data writing based on the absolute position of the auto-lock cell in the report before the automatic data writing; and keeping the auto-lock cell in the auto-lock state. It can be understood that after the automatic data writing, the cells kept in auto-lock are still in the auto-lock state, and there is no need for the user to reset the relevant cells to the auto-lock state again, which reduces the user operation, error rate, and computer resource overhead.

[0099] In one embodiment, the terminal determines whether the absolute position of the auto-lock cell changes after the automatic data writing; if the absolute position of the auto-lock cell changes after the automatic data writing, determining the position change value of the auto-lock cell; and determining the new absolute position of the auto-lock cell after the automatic data writing based on the position change value and the absolute position before the automatic data writing. The auto-lock cell after the automatic data writing is determined according to the new absolute position. For example, in the case of filling dimension values in the report, the absolute position of the auto-lock cell may change. Therefore, the new absolute position is calculated based on the position change value, so as to determine the auto-lock cell, which meets different requirements and improves the flexibility of report processing.

[0100] It should be understood that although the steps in the flowcharts in some embodiments of the present application are shown in sequence according to the indication of the arrows, these steps do not necessarily need to be executed in the order indicated by the arrows. Unless there is a clear indication in this article, the execution of these steps has no strict order limitation, and these steps can be executed in other orders. Moreover, at least some of the steps in the flowchart may include multiple steps or multiple stages. These steps or stages do not necessarily need to be executed at the same moment, but can be executed at different moments. The execution order of these steps or stages does not necessarily need to be sequential, but can be executed alternately or in turn with at least some of the steps or stages in other steps or other steps.

[0101] Based on the same inventive concept, an embodiment of the present application further provides a report processing device based on a report system for implementing the above-mentioned report processing method based on a report system. The solution provided by this device to solve the problem is similar to the solution described in the above method. Therefore, the specific limitations in one or more embodiments of the report processing device based on a report system provided below can refer to the limitations on the report processing method based on a report system in the above text, and will not be repeated here.

[0102] In one embodiment, asFigure 8 As shown in the figure, a report processing device 800 based on a report system is provided, including: a determination module 802 and a restoration module 804, where:

[0103] The determination module 802 is configured to determine at least one cell to which data needs to be automatically written when it is necessary to automatically write data to a report of the report system; at least one of the at least one cell includes at least one target cell in a custom locked state that is pre-custom locked.

[0104] The determination module 802 is further configured to, after the automatic data writing is completed, for each target cell, determine the target cell based on the absolute position of the target cell in the report before the automatic data writing.

[0105] The restoration module 804 is configured to overwrite the original cell information of the target cell to the target cell after the automatic writing; the original cell information is the cell information of the target cell before the automatic data writing, and the overwritten target cell remains in the custom locked state.

[0106] In one embodiment, the report includes multiple regions, and the report processing device 800 is further configured to, in response to a locking operation on a selected region in the report, set the cells in the selected region to the custom locked state.

[0107] In one embodiment, a locking control is provided in the report; the report processing device 800 is further configured to, in response to a triggering operation on the locking control, display a set of locking region options; the set of locking region options includes multiple locking region options for locking different regions respectively; determine a target locking region option selected from the set of locking region options, and set the cells in the region indicated by the target locking region option to the custom locked state.

[0108] In one embodiment, the report further includes cells in an automatic locked state; the automatic locked state is automatically set according to the usage attribute of the cell; the report processing device 800 is further configured to, in response to an unlocking operation on a selected region in the report, set the cells in the selected region and in the locked state to the unlocked state; where the locked state is any one of the custom locked state and the automatic locked state.

[0109] In one embodiment, an unlocking control is provided in the report; the report processing device 800 is further configured to, in response to a triggering operation on the unlocking control, display a set of unlocking region options for unlocking different regions respectively; determine a target unlocking region option selected from the set of unlocking region options, and set the cells located in the region indicated by the target locking region option and in the locked state to the unlocked state.

[0110] In one embodiment, the report processing device 800 is further configured to, in response to a manual modification operation on any selected cell in the report, obtain the status of the selected cell; if the status is a custom lock state or an automatic lock state, confirm that modification of the selected cell is not supported; if the status is an unlocked state, confirm that modification of the selected cell is supported.

[0111] In one embodiment, the report is generated based on a distributed report template; the report processing device 800 is further configured to determine a main report template; at least one cell in the main report template is in a custom lock state; in response to a template distribution operation on the main report template, create a distributed report template that inherits the lock state of the cells in the main report template; the lock state includes a custom lock state; in response to a report generation operation on the distributed report template, inherit the lock state of the cells in the distributed report template into the report.

[0112] In one embodiment, the determining module 802 is further configured to, if the absolute position of the target cell is variable, determine the position change value of the target cell; the position change value is the change value of the absolute position of the target cell in the report before and after automatically writing data; determine the new absolute position of the target cell after automatically writing data based on the absolute position of the target cell before automatically writing data and the position change value; determine the target cell after automatically writing data according to the new absolute position.

[0113] In one embodiment, the report processing device 800 is further configured to, in response to an unlocking operation on a selected area in the report, determine whether the operator of the unlocking operation has the unlocking permission for the selected area; if the operator has the unlocking permission, set the cells in the selected area that are in the locked state to the unlocked state.

[0114] The above-mentioned report processing device based on the report system, when it is necessary to automatically write data into the reports of the report system, determines at least one cell that needs to be automatically written with data; at least one of the at least one cell is a target cell in a custom locked state that is pre-custom locked. It can be understood that the custom locked state is a locked state defined by the user himself, that is, the target cell is specified by the user. After the automatic data writing is completed, for each target cell, based on the absolute position of the target cell in the report before the automatic data writing, the target cell is determined. The original cell information of the target cell is overwritten to the target cell after the automatic data writing. Among them, the original cell information is the cell information of the target cell before the automatic data writing, and the target cell after being overwritten remains in the custom locked state. Therefore, the target cell after the automatic data writing retains the cell information before the automatic data writing, enabling the enterprise to use the report normally according to the expected requirements and reducing the error rate. Moreover, according to the information in the cell information indicating the custom locked state, the target cell after the automatic data writing remains in the custom locked state. In the case of repeatedly executing the automatic data writing, the most original cell information of the target cell can still be retained. Therefore, the requirement that the cells specified by the user are not automatically modified is met, thereby improving the flexibility of report processing.

[0115] For the specific limitations of the above-mentioned report processing device based on the report system, reference can be made to the limitations of the above-mentioned report processing method based on the report system in the previous text, which will not be elaborated here. Each module in the above-mentioned report processing device based on the report system can be implemented in whole or in part by software, hardware, and their combination. The above-mentioned modules can be embedded in the processor in the computer device in hardware form or independent of it, or stored in the memory in the computer device in software form, so that the processor can call and execute the operations corresponding to the above-mentioned modules.

[0116] In one embodiment, a computer device is provided. The computer device can be a terminal, and its internal structure diagram can be as Figure 9As shown in the figure. The computer device includes a processor, a memory, an input / output interface, a communication interface, a display unit, and an input device. Among them, the processor, the memory, and the input / output interface are connected through a system bus, and the communication interface, the display unit, and the input device are connected to the system bus through the input / output interface. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The input / output interface of the computer device is used to exchange information between the processor and external devices. The communication interface of the computer device is used to communicate with external terminals in a wired or wireless manner, and the wireless manner can be implemented through WIFI, a mobile cellular network, NFC (Near Field Communication), or other technologies. When the computer program is executed by the processor, it implements a report processing method based on a report system. The display unit of the computer device is used to form a visually visible picture, which can be a display screen, a projection device, or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen. The input device of the computer device can be a touch layer covering the display screen, or a button, a trackball, or a touchpad provided on the computer device housing, or an external keyboard, touchpad, or mouse, etc.

[0117] Those skilled in the art can understand that Figure 9 the structure shown in the figure is only a block diagram of some structures related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine some components, or have different component arrangements.

[0118] In one embodiment, a computer device is further provided, including a memory and a processor. A computer program is stored in the memory, and when the processor executes the computer program, the steps in the above method embodiments are implemented.

[0119] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by the processor, the steps in the above method embodiments are implemented.

[0120] In one embodiment, a computer program product is provided, including a computer program. When the computer program is executed by the processor, the steps in the above method embodiments are implemented.

[0121] Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be completed by instructing relevant hardware through a computer program. The computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above methods. Among them, any reference to a memory, storage, database, or other medium used in the various embodiments provided in the present application can include at least one of non-volatile and volatile memories. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, or optical memory, etc. Volatile memory can include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM), etc.

[0122] The technical features of the above embodiments can be combined arbitrarily. For the sake of brevity of description, not all possible combinations of the various technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, it should be considered to be within the scope described in this specification.

[0123] The above embodiments only represent several implementation manners of the present application. The description is relatively specific and detailed, but it should not be construed as a limitation on the scope of the invention patent. It should be noted that for those of ordinary skill in the art, without departing from the concept of the present application, several modifications and improvements can still be made, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application should be subject to the appended claims.

Claims

1. A report processing method based on a report system, characterized in that, the method includes: When it is necessary to automatically write data into the reports of the report system, determine at least one cell that needs to automatically write data; at least one of the at least one cell includes at least one target cell in a custom locked state that is pre-custom locked; Automatically write the data into the at least one cell, and after the automatic writing of the data is completed, for each target cell, based on the absolute position of the target cell in the report before the automatic writing of the data, determine the target cell; Overwrite the original cell information of the target cell to the target cell after being automatically written; the original cell information is the cell information of the target cell before the automatic writing of the data; the target cell after being overwritten remains in the custom locked state.

2. The method according to claim 1, characterized in that, the report includes multiple regions, and the method further includes: In response to a locking operation on the selected region in the report, set the cells in the selected region to the custom locked state.

3. The method according to claim 2, characterized in that, a locking control is provided in the report; the setting the state of the cells in the selected region to the custom locked state in response to a locking operation on the selected region in the report includes: In response to a trigger operation on the locking control, display a set of locking region options; the set of locking region options includes multiple locking region options for locking different regions respectively; Determine the target locking region option selected from the set of locking region options, and set the cells in the region indicated by the target locking region option to the custom locked state.

4. The method according to claim 1, characterized in that, the report also includes cells in an automatic locked state; the automatic locked state is automatically set according to the usage attributes of the cells; the method further includes: In response to an unlocking operation on the selected region in the report, set the cells in the selected region that are in the locked state to the unlocked state; wherein, the locked state is any one of the custom locked state and the automatic locked state.

5. The method according to claim 4, characterized in that, an unlocking control is provided in the report; the setting the cells in the selected region that are in the locked state to the unlocked state in response to an unlocking operation on the selected region in the report includes: In response to a trigger operation on the unlocking control, display a set of unlocking region options for locking different regions respectively; Determine the target unlocking region option selected from the set of unlocking region options, and set the cells in the region indicated by the target locking region option that are in the locked state to the unlocked state.

6. The method according to claim 1, characterized in that, the method further includes: Upon receiving a manual modification operation for any selected cell in the report, obtain the status of the selected cell; If the status is a custom locked state or an automatic locked state, confirm that modification of the selected cell is not supported; If the status is an unlocked state, confirm that modification of the selected cell is supported.

7. The method according to claim 1, wherein, the report is generated based on a distributed report template; the method further includes: determine a main report template; at least one cell in the main report template is in a custom locked state; in response to a template distribution operation for the main report template, create a distributed report template that inherits the locked state of the cells in the main report template; the locked state includes the custom locked state; in response to a report generation operation for the distributed report template, inherit the locked state of the cells in the distributed report template into the report.

8. The method according to claim 1, wherein, the determining of the target cell based on the absolute position of the target cell in the report before automatically writing data includes: if the absolute position of the target cell is variable, determine the position change value of the target cell; the position change value is the change value of the absolute position of the target cell in the report before and after automatically writing data; determine the new absolute position of the target cell after automatically writing data based on the absolute position of the target cell before automatically writing data and the position change value; determine the target cell after automatically writing data according to the new absolute position.

9. The method according to claim 4, wherein, the setting the cells in the selected area that are in a locked state to an unlocked state in response to an unlocking operation for the selected area in the report includes: in response to an unlocking operation for the selected area in the report, determine whether the operator of the unlocking operation has the unlocking permission for the selected area; if the operator has the unlocking permission, set the cells in the selected area that are in a locked state to an unlocked state.

10. A report processing device based on a report system, wherein, the device includes: a determination module, configured to determine at least one cell for which data needs to be automatically written in the case of automatically writing data to a report of the report system; at least one of the at least one cell is a target cell that is pre-customized and locked and is in a custom locked state; the determination module is further configured to, after the data is automatically written, for each target cell, determine the target cell based on the absolute position of the target cell in the report before automatically writing data; A recovery module for overwriting the original cell information of the target cell onto the target cell after automatic writing; the original cell information is the cell information of the target cell before automatic data writing, and the target cell after overwriting remains in the custom locked state.

11. A computer device, comprising a memory and a processor, the memory storing a computer program, wherein, when the processor executes the computer program, the steps of the method according to any one of claims 1 to 9 are implemented.

12. A computer-readable storage medium, having stored thereon a computer program, wherein, when the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 9 are implemented.

Images