A method and device for dynamically refreshing a report

Abstract

The present application belongs to the technical field of report data processing, and provides a method and device for dynamically refreshing a report, including: parsing the formula input into the current cell and generating a syntax tree; starting from the current cell, expanding the data of the current cell to the data of the target cell after the offset according to the offset parsed; recording a reference chain each time the expansion is performed until the expansion is completed; wherein the reference chain is used to record the path of each expansion process from the current cell to the target cell; when the data of a cell in the report changes, finding the reference chain of the data of this cell, and searching and refreshing all the data involved according to the reference chain in sequence. The technical problem of how to automatically refresh the data in the report without manual input is solved.

Description

Technical Field

[0001] The present application belongs to the technical field of report data processing, and relates to a method and device for dynamically refreshing reports. Background Art

[0002] Existing Excel tables can only display data statically. Reports are tables or charts that display data dynamically. Report tools can be divided into SQL canvas mode and Cell mode.

[0003] The characteristic of SQL canvas mode is that the report is divided into several areas horizontally, and report components are freely placed in these areas. The positions of these components can be arbitrary, and the components can overlap each other. The advantage of this method is that it can realize visual data binding and the position of components is flexible. The disadvantage is that it is difficult to align components when inserting columns, and it is easy to stagger lines when drawing table lines.

[0004] The Cell method treats the report as an area consisting of a series of continuous cells. In this way, the position of report components can only be changed by changing the row height and column width, and components cannot overlap. Its advantage is that the cell merging function makes it relatively easy to draw multi-row column headers, but dynamic data binding in cells often requires manual formula writing, which increases the complexity of the operation.

[0005] In the application of cross-listing, the above two forms of reports are difficult to obtain data due to the deep binding based on coordinate offset and data behavior, and there is a mutual dependency between the data. Once a certain data needs to be changed, the data of the entire report will be wrong or the relevant data needs to be manually modified, which increases the workload. The existing technology relies on special syntax in the implementation of hierarchical coordinates of reports and is tightly bound to data acquisition behavior. Not only are the operations after the offset calculation limited, but the inconsistency of special syntax between different products also increases the user's learning cost. Summary of the invention

[0006] The present application provides a report dynamic refresh method and device to solve the technical problem of how to automatically refresh the data in the report without manual input.

[0007] The present application provides a method for dynamically refreshing a report, comprising: parsing a formula input into a current cell to generate a syntax tree; taking the current cell as a starting point, and sequentially expanding the data of the current cell to the data of a target cell after the offset according to the offset obtained by the parsing; recording a reference chain each time the expansion is performed until the expansion is completed; wherein the reference chain is used to record the path of each expansion process from the current cell to the target cell; when the data of a cell in the report changes, finding the reference chain of the data of this cell, and sequentially searching and refreshing all the data involved according to the reference chain.

[0008] Optionally, the method further comprises: when entering report data, matching the entered data with a predefined report template, wherein a one-to-one mapping relationship between fields and formulas is defined in the report template.

[0009] Optionally, the method for entering report data includes: S21: generating a tree data structure in the report based on the cascade relationship between the entered data; S22: based on the tree data structure, taking the current cell as the starting point, calling the offset function to perform offset calculation according to the offset information of the data of the current cell to obtain an offset result; S23: judging whether the offset calculation is completed. When the offset calculation is not completed, the previous offset result is used as the starting point to perform a new round of offset calculation of S22 until the offset calculation is completed; S24: when the offset calculation is completed, executing the RV function to obtain the data of the last cell of the offset calculation.

[0010] Optionally, the method further includes: when it is necessary to directly obtain data of a certain cell without expansion, directly inputting a corresponding calculation expression or value in the current cell.

[0011] Optionally, when the top-level formula of a cell in the report is modified, the top-level formula of the cell is obtained for editing and modification.

[0012] Optionally, according to the top-level formula, any one or more combination of aggregation or summation, dynamic reference, conditional calculation, and complex calculation is completed.

[0013] Optionally, a data or a set of data is obtained according to the reference chain.

[0014] The present application also provides a method and device for dynamically refreshing a report, comprising: a parsing unit, for parsing a formula input into a current cell and generating a syntax tree; an expansion unit, for taking the current cell as a starting point and, in sequence according to the parsed offset, expanding the data of the current cell to the data of a target cell after the offset; recording a reference chain each time the expansion is performed until the expansion is completed; wherein the reference chain is used to record the path of each expansion process from the current cell to the target cell; and a refresh unit, for finding the reference chain of the data of a cell in the report when the data of the cell changes, and searching and refreshing all the data involved in sequence according to the reference chain.

[0015] The present application provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, a report dynamic refresh method as described in any one of the above method embodiments is implemented.

[0016] The present application provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, a report dynamic refresh method in any one of the above method embodiments is implemented.

[0017] The beneficial effects of the present application are as follows: the present application proposes a method and device for dynamically refreshing a report, which uses a fixed tree structure to represent the data structure of the report, and adopts a reference chain to record the path in the expansion process of the data, so as to realize the dynamic refresh of the report data. When re-modifying the data of a certain cell, the reference chain can be obtained based on the parsing of the input formula of the cell. The reference chain records all the data involved in the calculation involved in the data, and the automatic search based on the reference chain can realize the automatic modification of only all relevant data. The problem in the prior art that when a certain data in a table is changed, a comprehensive update of all data on the current page will be triggered, which not only processes a large amount of data and is difficult to detect errors, but also requires the user to manually update the data in the current table when modifying the data, and also manually associate and modify other related data items, which is not only inefficient but also increases the risk of errors. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] Figure 1 A schematic diagram of the steps of a report dynamic refresh method provided in this application;

[0019] Figure 2 A flow chart of calculation of update data provided for this application;

[0020] Figure 3 A schematic diagram of the steps of a method for entering data into a report provided in this application;

[0021] Figure 4A flow chart of the hierarchical coordinate calculation process provided for this application;

[0022] Figure 5 A schematic diagram of a sales form provided for this application;

[0023] Figure 6 A schematic diagram of a sales form template provided for this application. DETAILED DESCRIPTION

[0024] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

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

[0026] This application provides a method for dynamically refreshing reports, such as Figure 1 As shown, it includes S1 to S3.

[0027] S1: Parse the formula entered in the current cell and generate a syntax tree.

[0028] Specifically, a report is a table or chart that dynamically displays data. It is widely used in scenarios such as account books and work data summary tables. These reports automatically match appropriate report templates based on different types of data. Each cell in the template uses a preset formula with a fixed format to implement data entry, modification, and calculation functions. When a user needs to modify or supplement data in a generated report, the system will parse the formula entered in the current cell to reveal all the associations (i.e., reference chains) between the data and other cell data in the report, and build a corresponding syntax tree based on these associations.

[0029] For example, the current report template is used to record the daily sales of a store, and can automatically compare the sales in the same time period of the previous day to display key data such as customer orders and total transaction amount. Hierarchical coordinates can be used to automatically shift the date data forward by one day for calculation. First, the formula entered by the user is parsed into a syntax tree, which not only contains all the calculation steps, but also clearly indicates the reference relationship and logical order between the data. Since the data in the report needs to be dynamically calculated based on different dates (new sales data is generated every day and compared with the data of the previous day), this syntax tree becomes the key to perform these complex calculations. During the calculation process, the current sales record node is used as the starting point, and the date offset function is used to accurately find the sales data of the same time node of the previous day. The sales data from the same starting time point to the current time point of the previous day are summarized to obtain the required summary result. This summary result is compared with the sales situation of the corresponding date of the current sales record, so as to help users quickly understand sales trends and changes.

[0030] S2: Starting from the current cell, the data of the current cell is expanded to the data of the target cell after the offset according to the parsed offset. Each time the expansion is performed, a reference chain is recorded until the expansion is completed. The reference chain is used to record the path of each expansion process from the current cell to the target cell.

[0031] In one embodiment, based on the formula parsed from the table, it is determined whether it is necessary to perform an offset calculation on the user data of the current cell. If an offset calculation is required, the offset of the data in the expression is obtained, the offset function is called and executed in sequence, and the offset is recorded through the reference chain. It should be noted that the offset includes absolute offset and relative offset. For example: if the data of the initial cell is only offset to one cell and the offset ends, it means that the offset is an absolute offset, and it only needs to be directly extended to the target cell according to the offset; if the data of the initial cell has been offset once, it is necessary to perform a second offset based on the cell where the first offset ends, then the offset of the second offset relative to the data of the cell where the first offset ends is a relative offset. Each offset needs to be recorded through the reference chain until the extension ends, and the extension from the initial cell to the target cell is completed.

[0032] S3: When the data of a cell in the report changes, find out the reference chain of the data in this cell, and search and refresh all the data involved in sequence according to the reference chain.

[0033] In one embodiment, when the data of a cell in a report changes, it is only necessary to find the reference chain corresponding to the data of the cell, and based on the data extension path recorded in the reference chain, backtrack from the current cell as the starting point, and recalculate the data of the cells involved, so as to ensure that when a certain data is modified, all data under the reference chain can be dynamically refreshed without manually entering the data of each cell, thereby improving the refresh efficiency and accuracy of the data. In addition, based on the sequential backtracking of the reference chain, the report data is updated, which reduces the data error rate.

[0034] Figure 2 A flow chart of updating data calculation provided by this application, such as Figure 2 As shown, change the data of a cell, obtain the reference chain of the cell, obtain the formula referenced by the current data according to the reference chain, and determine whether the formula is a top-level formula. If the judgment result is yes, execute the corresponding function of the cell to obtain the data. If the judgment result is no, continue to search for the reference chain with the cell where the current data is located, search for the next reference chain, and obtain the new data after the calculation of the previous step.

[0035] Furthermore, when the report data is entered, the entered data is matched with a predefined report template, in which a one-to-one mapping relationship between fields and formulas is defined.

[0036] Specifically, when entering data into a report, it is necessary to match the corresponding report template based on the data. In the report template, each table is mapped one-to-one through fields and formulas. Cells with different calculation functions realize calculations of different functions of the data in each cell according to their fields and the formulas called.

[0037] For example, there is a sales report whose sales records will accumulate over time. When new data is entered, these data will be automatically integrated into the corresponding formula according to the preset mapping relationship between the report and the formula. Every time a sales record is added, the hierarchical coordinate calculation formula for the current date will be re-called to update the sales data in the current cell. Since the daily sales record is only related to the current calculation result, the calculation results of other dates will not be recalculated, thereby ensuring the efficiency and accuracy of report processing. In addition, when the number of a sales record exceeds the quantity threshold at one time, the corresponding discount formula will be automatically called, and only the sales in the current cell will be recalculated. This local update method not only ensures the accurate application of the discount logic, but also avoids unnecessary global data recalculation, further improving the response speed of the report and user experience.

[0038] Figure 3 A schematic diagram of the steps of a method for entering data into a report provided in this application, such as Figure 3As shown, it includes S21 to S24.

[0039] S21: Generate a tree data structure in the report based on the cascading relationship between the input data.

[0040] S22: Based on the tree data structure, taking the current cell as the starting point, and according to the offset information of the data of the current cell, calling the offset function to perform offset calculation, and obtaining the offset result.

[0041] S23: Determine whether the offset calculation is completed. If the offset calculation is not completed, take the previous offset result as the starting point and perform a new round of offset calculation in S22 until the offset calculation is completed.

[0042] S24: When the offset calculation is completed, the RV function is executed to obtain the data of the last cell of the offset calculation.

[0043] Furthermore, after analyzing the entered data, all data nodes are integrated, the parent-child cascade relationship between each data is analyzed, and a forest is constructed. This application takes the data structure of the report as a tree data structure as an example. For example, data B is directly calculated based on data A, then data A can find data B based on its parent-child relationship. Specifically, taking the cell where data A is located as the starting point, the entry formula of the data A cell is obtained and parsed, and the offset of data B relative to data A is parsed. The offset information is calculated through the reference chain. The offset information includes the offset of the target cell relative to the current cell and the position information of the target cell. The offset function is called and executed to obtain the offset result, and the offset result is the calculation result obtained each time the offset calculation is performed.

[0044] Figure 4 A flow chart of the hierarchical coordinate calculation process provided by this application, such as Figure 4 As shown, taking the calculation formula RV(D2,RA(A2,1),RR(B2,-1)) as an example, the formula needs to solve the value of cell D2. Cell D2 is horizontally expanded one cell at a time relative to cell A2, and a calculation result is obtained based on the expansion of cell A2 to the right by one cell; the cell where cell A2 is located after expanding one cell to the right is taken as the current cell, and it is determined whether it is necessary to further perform offset calculation based on the current cell. This embodiment needs to expand vertically based on the current cell to expand one cell to the left of the cell where cell B2 is located. Each expansion records the offset path of the data through the reference chain until the offset calculation is completed. When the offset calculation is completed, the RV function is executed to obtain the data of the last cell of the offset calculation. It should be noted that the full name of the RV function is REPORT.VALUE, and its function is to obtain data in a specified area.

[0045] Specifically, enter the formula "RV(D2,RA(A2,1),RR(B2,-1))" in cell E2, and the calculation process is as follows.

[0046] 1. Parse the formula and form a syntax tree.

[0047] 2. Execute RA(A2,1), which is an absolute offset, that is, offset to the context of the first data expanded from cell A2. The record reference chain is {A_2:[E2]}, and the execution result is obtained.

[0048] 3. Execute RR(B2,-1). In the obtained execution result, find the B2 cell corresponding to the data in the current E2 cell, then shift the position upward by a length to obtain the new context. The record reference chain is {A_2:[E2],B_2:[E2]}.

[0049] 4. Execute the RV function to obtain the data extended from cell D2 in the current offset context and record the reference chain as {A_2:[E2],B_2:[E2],D_2:[E2]}.

[0050] 5. After the calculation is completed, the data in cell D2 changes, and according to the reference chain, it is found that cell E2 needs to be updated.

[0051] 6. Continue to search the reference chain. If cell E2 changes, there is no need to update other cells. Just update cell E2 directly.

[0052] Figure 5 A sales form diagram provided for this application, such as Figure 5 As shown, in a sales form, the part that needs to be calculated is the column where RV(D2,RA(A2,1),RR(B2,-1)) is located, where column B is the product name (Product), column C is the salesperson (Salesperson), column D is the sales (Sales), and column A is the region (Region). Two cells are extended from column A, namely (East) and (North). Figure 6 A schematic diagram of a sales form template provided for this application, such as Figure 6 As shown, the columns of cells are marked with letters A, B, C, D, E, F..., and the rows are marked with Arabic numerals 123456... Different fields are marked under each column of the first row, for example: Region, Product, Salesperson, Sales, RV(D2, RA(A2,1), RR(B2,-1)). It should be noted that these fields correspond to the database respectively, and all the data under the field in the database can be searched through the field.

[0053] In this example, the same hierarchical coordinate function can be executed in different areas to obtain some data. Specifically, when executing the formula in cell E7, RA(A2,1) is executed first, that is, the first data extended from cell A2 in the template is found. This is an absolute offset, and A2 (East) is obtained. Then RR(B2,-1) is executed, which is a relative offset, that is, the cell corresponding to cell E7 that is extended from cell B2 in the template is (B2,2) (Strawberry), and then it is offset forward by a length, that is, B2 (Banana). Because the cell D7 corresponding to E7 is the first data of B7 (Strawberry), E7 only needs to obtain the first data of the data extended from multiple D2 (template cells) corresponding to B2 (Banana), that is, 180.

[0054] Specifically, when it is necessary to directly obtain the data of a certain cell without expanding it, directly enter the corresponding calculation expression or value in the current cell.

[0055] In one embodiment, according to the type and format of the report, if the acquired data does not need to be expanded, a calculation expression is directly entered in the current cell to read the corresponding data. For example, the value of the previous row, next row, previous column, next column, etc., which is offset from the current position, or a specific value is directly entered.

[0056] For example, to get the value of the previous A1 cell, if the cell does not expand, there is no "previous A1 cell", so it does not expand. Since there is only one A1 cell, you can enter =A1[A1:-1] in cell B1.

[0057] Furthermore, when the top-level formula of a cell in the report is modified, the top-level formula of the cell is obtained for editing and modification.

[0058] In one embodiment, when the current cell needs to obtain all the expanded values, its top-level formula is =RV(Cell). For example, if all the expanded values ​​of cell A1 need to be obtained, the top-level formula entered in cell B1 is =RV(A1).

[0059] If cell B1 needs to be modified to obtain the value that meets the conditions in the expanded cell, you can enter the top-level formula =FILTER(Cell,Condition) in cell B1 to obtain it. For example, to obtain the value that is not 3 in the expanded cell A1, enter =FILTER(A1,A1<>3) in cell B1.

[0060] Specifically, according to the top-level formula, any one or more combination of aggregation or summation, dynamic reference, conditional calculation, and complex calculation can be completed.

[0061] In one embodiment, the summary is completed according to the top-level formula. In the summary table, when the data range contains merged cells, the summation needs special processing. For example, C2:C21 is a merged cell, but E3:E22 contains corresponding data (used to adjust the summation range). If the number of data to be processed is large, a more complex reference method can be used, such as the INDIRECT function.

[0062] Dynamically reference data based on input Using the INDIRECT function, you can dynamically reference other cells or areas based on the text value in a cell. Assuming that column C is the product name and column D is the sales volume, you can use the SUMIFS function to calculate the total sales volume of all products. Summing with units is a complex calculation. If the data contains units (such as amount) and the units are uniform, you can use the SUMPRODUCT function and the SUBSTITUTE function to achieve the sum.

[0063] Based on the report described in this application, users are allowed to call different calculation methods through a single top-level formula to cope with complex and changing report requirements.

[0064] Specifically, a piece of data or a group of data may be obtained according to a reference chain.

[0065] It should be noted that when obtaining the reference chain referenced by the current cell, if the reference chain involves only one data, the data is directly obtained; if the reference chain involves multiple data, these data are the same group of data, and all the data in the group can be obtained based on the reference chain.

[0066] The present application also provides a method and device for dynamically refreshing a report, including: a parsing unit, which is used to parse the formula input into the current cell and generate a syntax tree. An expansion unit, which is used to expand the data of the current cell to the data of the target cell after the offset, starting from the current cell and in turn according to the parsed offset. A reference chain is recorded each time the expansion is performed until the expansion is completed. The reference chain is used to record the path of each expansion process from the current cell to the target cell. A refresh unit, when the data of a cell in the report changes, finds out the reference chain of the data of this cell, and searches and refreshes all the data involved in turn according to the reference chain.

[0067] The present application provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, a report dynamic refresh method as described in any one of the above method embodiments is implemented.

[0068] The present application provides a terminal device, which includes a processor and a memory, wherein the memory is used to store a computer program, the computer program includes program instructions, and the processor is used to execute the program instructions stored in the computer storage medium. The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, etc. It is the computing core and control core of the terminal, which is suitable for implementing one or more instructions, and is specifically suitable for loading and executing one or more instructions to implement the corresponding method flow or corresponding function; the processor described in the embodiment of the present application can be used for the operation of a report dynamic refresh method.

[0069] The present application provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, a report dynamic refresh method in any one of the above method embodiments is implemented.

[0070] In one embodiment, the present application also provides a storage medium, specifically a computer-readable storage medium (Memory), which is a memory device in a terminal device for storing programs and data. It is understandable that the computer-readable storage medium here can include both the built-in storage medium in the terminal device and the extended storage medium supported by the terminal device. The computer-readable storage medium provides a storage space, which stores the operating device of the terminal. In addition, one or more instructions suitable for being loaded and executed by the processor are also stored in the storage space, and these instructions can be one or more computer programs (including program codes). It should be noted that the computer-readable storage medium here can be a high-speed RAM memory or a non-volatile memory, such as at least one disk memory. The processor can load and execute one or more instructions stored in the computer-readable storage medium to implement a dynamic refresh method for a report in the above embodiment.

[0071] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, devices, or computer program products. Therefore, the present application may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present application may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program codes.

[0072] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices, and computer program products according to the embodiments of the present application. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of the processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0073] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0074] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0075] Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present application rather than to limit it. Although the present application has been described in detail with reference to the above embodiments, ordinary technicians in the relevant field should understand that the specific implementation methods of the present application can still be modified or replaced by equivalents, and any modifications or equivalent replacements that do not depart from the spirit and scope of the present application should be included in the scope of protection of the claims of the present application.

Claims

1. A report dynamic refresh method, characterized in that: include: Parse the formula entered in the current cell and generate a syntax tree; Taking the current cell as the starting point, the data of the current cell is expanded to the data of the target cell offset by the offset according to the parsed offset; Each time the expansion is performed, a reference chain is recorded until the expansion is completed; wherein the reference chain is used to record the path of each expansion process from the current cell to the target cell; When the data of a cell in the report changes, the reference chain of the data of this cell is found, and all the data involved are searched and refreshed in sequence according to the reference chain; When entering report data, the entered data is matched with a predefined report template, in which a one-to-one mapping relationship between fields and formulas is defined; The method for entering report data includes: S21: generating a tree data structure in the report according to the cascade relationship between the entered data; S22: according to the tree data structure, taking the current cell as the starting point, calling the offset function to perform offset calculation according to the offset information of the data of the current cell to obtain the offset result; S23: judging whether the offset calculation is completed, when the offset calculation is not completed, taking the previous offset result as the starting point, and performing a new round of offset calculation of S22 until the offset calculation is completed; S24: when the offset calculation is completed, executing the RV function to obtain the data of the last cell of the offset calculation.

2. A report dynamic refresh method as claimed in claim 1, characterized in that: When you need to directly obtain the data of a cell without expanding it, directly enter the corresponding calculation expression or value in the current cell.

3. A report dynamic refresh method as claimed in claim 1, characterized in that: Also includes: When the top-level formula of a cell in the report is modified, the top-level formula of the cell is obtained for editing and modification.

4. A report dynamic refresh method as claimed in claim 3, characterized in that: According to the top-level formula, any one or more combination calculations of aggregation or summation, dynamic reference, conditional calculation, and complex calculation are completed.

5. A report dynamic refresh method as claimed in claim 1, characterized in that: A piece of data or a group of data is obtained according to the reference chain.

6. A report dynamic refresh method and device, characterized in that: include: The parsing unit is used to parse the formula entered in the current cell and generate a syntax tree; An expansion unit, used to take the current cell as a starting point and, in sequence according to the parsed offset, expand the data of the current cell to the data of the target cell offset by the offset; Each time the expansion is performed, a reference chain is recorded until the expansion is completed; wherein the reference chain is used to record the path of each expansion process from the current cell to the target cell; A refresh unit, when the data of a cell in a report changes, finds out the reference chain of the data of this cell, and searches and refreshes all the data involved in sequence according to the reference chain; When entering report data, the entered data is matched with a predefined report template, in which a one-to-one mapping relationship between fields and formulas is defined; the method for entering report data includes: S21: generating a tree data structure in the report according to the cascade relationship between the entered data; S22: according to the tree data structure, taking the current cell as the starting point, calling the offset function to perform offset calculation according to the offset information of the data of the current cell to obtain the offset result; S23: judging whether the offset calculation is completed, when the offset calculation is not completed, taking the previous offset result as the starting point, and performing a new round of S22 offset calculation until the offset calculation is completed; S24: when the offset calculation is completed, executing the RV function to obtain the data of the last cell of the offset calculation.

7. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, a report dynamic refresh method as described in any one of claims 1 to 5 is implemented.

8. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, a report dynamic refresh method as described in any one of claims 1 to 5 is implemented.

Images