Data processing method and device, equipment, storage medium and computer program product

Abstract

The application relates to a data processing method, device, equipment, storage medium and computer program product. The method comprises the following steps: displaying a first data report; in response to an index setting operation on a target item in the first data report, displaying candidate indexes; the target item is at least one of a target row or a target column in the first data report; in response to an index selection operation, displaying an index state for indicating that a target index has been set at a corresponding position of the target item; the target index is an index specified by the index selection operation among the candidate indexes; and in response to a first storage operation, the target index and cell data in the target item are stored in association, so that when data is processed through a second data report, the cell data in the target item stored in association is found and displayed based on the target index. The method can improve the data processing efficiency and accuracy.

Description

Technical Field

[0001] This application relates to the field of computer technology, and in particular to a data processing method, apparatus, device, storage medium, and computer program product. Background Technology

[0002] Traditional data collection and storage methods typically involve collecting and storing data using Excel spreadsheets. After collecting the data, users simply save it in the spreadsheet and store the spreadsheet file.

[0003] This data storage method requires manually opening the spreadsheet file to query and copy data when the collected data is needed later. This process is cumbersome and prone to errors, resulting in poor data processing efficiency and accuracy. Summary of the Invention

[0004] Therefore, it is necessary to provide a data processing method, apparatus, device, storage medium, and computer program product that can improve the efficiency and accuracy of data processing in response to the above-mentioned technical problems.

[0005] Firstly, this application provides a data processing method. The method includes:

[0006] Display the first data report;

[0007] In response to an indicator setting operation for a target item in the first data report, candidate indicators are displayed; the target item is at least one of a target row or a target column in the first data report.

[0008] In response to the indicator selection operation, an indicator status indicating that the target indicator has been set is displayed at the corresponding position of the target entry; the target indicator is the indicator specified by the indicator selection operation from the candidate indicators.

[0009] In response to the first storage operation, the target indicator and the cell data in the target entry are stored together so that when processing data in the second data report, the cell data in the target entry stored together can be found and displayed based on the target indicator.

[0010] Secondly, this application also provides a data processing apparatus. The apparatus includes:

[0011] The report display module is used to display the first data report;

[0012] The candidate indicator display module is used to display candidate indicators in response to an indicator setting operation for a target item in the first data report; the target item is at least one of a target row or a target column in the first data report.

[0013] The indicator status display module is used to display an indicator status indicating that the target indicator has been set at the corresponding position of the target entry in response to the indicator selection operation; the target indicator is the indicator specified by the indicator selection operation among the candidate indicators.

[0014] The data storage module is configured to, in response to a first storage operation, associate and store the target indicator and the cell data in the target entry, so that when processing data through a second data report, the cell data in the associated target entry can be found and displayed based on the target indicator.

[0015] Thirdly, this application also provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the steps of the above-described method.

[0016] Fourthly, this application also provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the above-described method.

[0017] Fifthly, this application also provides a computer program product, including a computer program that, when executed by a processor, implements the steps of the above-described method.

[0018] The aforementioned data processing method, apparatus, computer equipment, storage medium, and computer program product, after displaying a first data report, in response to an indicator setting operation for a target item in the first data report, display candidate indicators. The target item is at least one of a target row or target column in the first data report. In response to an indicator selection operation, at the corresponding position of the target item, an indicator status indicating that the target indicator has been set is displayed. The target indicator is the indicator specified by the indicator selection operation among the candidate indicators. By flexibly setting indicators for the target items in the first data report, the target items can be associated with specified target indicators, so that subsequently, in response to a first storage operation, the target indicators and target values ​​can be linked. Cell data in the target entry are stored in association. When the target indicator and the cell data in the target entry are stored in association, during subsequent data processing through the second data report, when the indicator data of the target indicator is needed, the cell data of the target entry (i.e., the indicator data of the target indicator) can be directly found and displayed in the second data report based on the target indicator. This avoids manually opening the first data report to query and copy the indicator data of the target indicator (i.e., the cell data in the target entry), improving the efficiency of obtaining the indicator data of the target indicator and ensuring the accuracy of the indicator data of the target indicator. In turn, it can improve the efficiency and accuracy of data processing in subsequent data processing.

[0019] Sixthly, this application provides a data processing method. The method includes:

[0020] Display a second data report for data processing;

[0021] In response to the indicator setting operation in the first cell of the second data report, candidate indicators are displayed;

[0022] In response to the indicator selection operation, an indicator status indicating that the target indicator has been set is displayed at a preset position in the first cell; the target indicator is the indicator specified by the indicator selection operation among the candidate indicators.

[0023] In response to the data retrieval operation, the cell data found based on the target indicator is displayed in the second cell of the second data report; the second cell and the first cell belong to the same row or column; the cell data is associated with the target indicator by setting the target indicator for the target entry in the first data report.

[0024] Seventhly, this application also provides a data processing apparatus. The apparatus includes:

[0025] The report display module is used to display a second data report for data processing.

[0026] The candidate indicator display module is used to display candidate indicators in response to the indicator setting operation of the first cell in the second data report;

[0027] The indicator status display module is used to respond to the indicator selection operation by displaying an indicator status indicating that the target indicator has been set at a preset position in the first cell; the target indicator is the indicator specified by the indicator selection operation among the candidate indicators.

[0028] The data retrieval module is used to respond to the data retrieval operation and display the cell data found based on the target indicator in the second cell of the second data report; the second cell and the first cell belong to the same row or column; the cell data is associated with the target indicator by setting the target indicator for the target entry in the first data report.

[0029] Eighthly, this application also provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the steps of the above-described method.

[0030] Ninthly, this application also provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the above-described method.

[0031] In a tenth aspect, this application also provides a computer program product, including a computer program that, when executed by a processor, implements the steps of the above-described method.

[0032] The aforementioned data processing method, apparatus, computer equipment, storage medium, and computer program product, by pre-associating and storing target indicators with cell data based on target entries in a first data report, can, when data processing is required, display a second data report for data processing. In response to an indicator setting operation on the first cell of the second data report, candidate indicators are displayed; in response to an indicator selection operation, an indicator status indicating that the target indicator has been set is displayed at a preset position in the first cell. The target indicator is the indicator specified by the indicator selection operation among the candidate indicators. By flexibly setting indicators for the row or column to which the first cell belongs in the second data report, the row or column to which the first cell belongs can be associated with the specified target indicator. Therefore, in response to a data retrieval operation, the cell data found based on the target indicator (i.e., the indicator data of the target indicator) can be displayed in the second cell of the second data report. Since the second cell and the first cell belong to the same row or column, this avoids manually opening the first data report to query and copy the indicator data of the target indicator (i.e., cell data in the target entry), improving the efficiency of obtaining the target indicator data and ensuring the accuracy of the target indicator data. This, in turn, improves the efficiency and accuracy of subsequent data processing. Attached Figure Description

[0033] Figure 1 This is an application environment diagram of a data processing method in one embodiment;

[0034] Figure 2 This is a flowchart illustrating a data processing method in one embodiment;

[0035] Figure 3 This is a schematic diagram of a first data report in one embodiment;

[0036] Figure 4 This is a schematic diagram of the first data report in another embodiment;

[0037] Figure 5 This is a schematic diagram of the first data report in another embodiment;

[0038] Figure 6 This is a schematic diagram of the first data report in another embodiment;

[0039] Figure 7 This is a schematic diagram of the first data report in another embodiment;

[0040] Figure 8 This is a schematic diagram of cell attributes in one embodiment;

[0041] Figure 9 This is a schematic diagram of an indicator warehouse in one embodiment;

[0042] Figure 10 This is a schematic diagram of the first data report in another embodiment;

[0043] Figure 11 This is a schematic diagram of associated stored procedures in one embodiment;

[0044] Figure 12 This is a schematic diagram of an associated stored procedure in another embodiment;

[0045] Figure 13 This is a schematic diagram illustrating the storage of data report versions in one embodiment;

[0046] Figure 14 This is a schematic diagram illustrating the addition of a blank entry in one embodiment;

[0047] Figure 15 A schematic diagram of the first data report in another embodiment;

[0048] Figure 16 This is a flowchart illustrating the data processing method in another embodiment;

[0049] Figure 17 This is a schematic diagram of a second data report in one embodiment;

[0050] Figure 18 This is a schematic diagram of a second data report in another embodiment;

[0051] Figure 19 This is a flowchart illustrating the data processing method in another embodiment;

[0052] Figure 20 This is a flowchart illustrating a data processing method in one embodiment;

[0053] Figure 21 This is a flowchart illustrating the indicator selection steps in one embodiment;

[0054] Figure 22 This is a structural block diagram of a data processing device in one embodiment;

[0055] Figure 23 This is a structural block diagram of the data processing apparatus in another embodiment;

[0056] Figure 24 This is an internal structural diagram of a computer device in one embodiment. Detailed Implementation

[0057] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application.

[0058] The data processing method provided in this application embodiment can be applied to, for example... Figure 1 In the application environment shown, terminal 102 communicates with server 104 via a network. A data storage system can store the data that server 104 needs to process. The data storage system can be integrated on server 104 or placed in the cloud or on other servers. The above data processing method can be executed independently by terminal 102, or it can be executed interactively by terminal 102 and server 104. Taking terminal 102 executing independently as an example, in one embodiment, terminal 102 displays a first data report; in response to an indicator setting operation for a target entry in the first data report, it displays candidate indicators; the target entry is at least one of a target row or target column in the first data report; in response to an indicator selection operation, at the corresponding position of the target entry, it displays an indicator status indicating that the target indicator has been set; the target indicator is the indicator specified by the indicator selection operation among the candidate indicators; in response to a first storage operation, it associates and stores the target indicator and the cell data in the target entry so that when processing data through a second data report, it can find and display the associated cell data in the target entry based on the target indicator.

[0059] In another embodiment, terminal 102 displays a second data report for data processing; in response to an indicator setting operation on the first cell of the second data report, candidate indicators are displayed; in response to an indicator selection operation, an indicator status indicating that a target indicator has been set is displayed at a preset position in the first cell; the target indicator is the indicator specified by the indicator selection operation among the candidate indicators; in response to a data retrieval operation, cell data found based on the target indicator is displayed in the second cell of the second data report; the second cell and the first cell belong to the same row or column; the cell data is associated with the target indicator by setting the target indicator for the target entry in the first data report.

[0060] The terminals can be, but are not limited to, various desktop computers, laptops, smartphones, tablets, IoT devices, portable wearable devices, and network devices. IoT devices can include smart speakers, smart TVs, smart air conditioners, smart in-vehicle devices, etc. Portable wearable devices can include smartwatches, smart bracelets, head-mounted devices, etc. Network devices can include routers, switches, firewalls, load balancers, network storage devices, network adapters, etc.

[0061] Server 104 can be a standalone physical server, a server cluster or distributed system composed of multiple physical servers, or a cloud server providing basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms. Terminals and servers can be connected directly or indirectly via wired or wireless communication; this application does not impose any restrictions on this.

[0062] In one embodiment, such as Figure 2 As shown, a data processing method is provided, which can be applied to... Figure 1 Taking terminal 102 as an example, the explanation includes the following steps:

[0063] S202, display the first data report.

[0064] Among them, the first data report can be a collection report, which is used to collect raw data from data providers. For example, in the field of project management, the first data report can be a project report, through which data such as the progress and resource usage of sub-projects provided by various project participants can be collected; in the field of production and supply chain management, the first data report can be a production report, through which data such as the production progress, inventory level, and supplier delivery status of various products can be collected; in the field of investment management, the first data report is a financial statement, through which investors can collect financial data such as the income, profit, and interest rate of the investee for each financial cycle.

[0065] It is understandable that the first data report can be a report at any stage of the data collection process. Specifically, it can be a report before data collection or a report after data collection is completed. A report before data collection refers to a report before the formal start of data collection work. Specifically, it can be a report with a preset template configured. The preset template defines the data filling area, data collection framework, fields and formats in the corresponding work report to help users accurately and consistently collect the required data in the subsequent collection process. A report after data collection is completed refers to a report in which data entry has been completed according to the preset template.

[0066] For example Figure 3The first data report shown is the report before data collection. It is configured with a preset template, which defines the data filling area in this first data report as (B3-J10). B3 represents the cell in the 3rd row of column B, and J10 represents the cell in the 10th row of column J. This means that in the first data report, the data will be filled in the area from cell B3 to cell J10. In addition, the preset template also defines the fields and formats for receipt collection, such as the collection year fields being "2018", "2019", "2020", "2021", "2022", "2023", and "2024", and the collection indicator fields being "Operating Revenue", "Net Profit", "Basic Earnings Per Share", "Total Earnings Per Share", "Return on Equity", "Return on Total Assets", and "Gross Profit Margin". The unit fields corresponding to these revenue indicator fields are "CNY", "CNY", "CNY", "CNY", "%", "%", and "%" respectively. For example... Figure 4 The first data report shown is the report after the data collection is completed. All the data that needs to be filled in has been entered into the report.

[0067] In one embodiment, a data processing application can run on the terminal. Users can create blank reports through the data processing application and configure a preset template for the created blank reports. The report configured with the preset template is the first data report.

[0068] In one embodiment, a data processing application may be running on the terminal. The user can load and display an existing first data report through the data processing application. The first data report may be a report on which data collection has been completed.

[0069] The data processing application can be a standalone application or a sub-application embedded in other management platforms. In this embodiment, the data processing application may include an online spreadsheet function, which refers to a spreadsheet tool that can be accessed and operated via a network. When the data processing application includes an online spreadsheet function, users can share spreadsheets with others through links or permission settings.

[0070] S204, in response to an indicator setting operation for a target entry in the first data report, display candidate indicators; the target entry is at least one of a target row or a target column in the first data report.

[0071] Here, the target row is the specific row in the first data table that the user wants to operate on, and the target column is the specific column in the first data table that the user wants to operate on. It can be understood that the target row can be a row within the data population area of ​​the first data table, and the target column can be a specific column within the data population area of ​​the first data table. For example, the target row could be... Figure 3 or Figure 4 The target column can be any row from row 3 to row 10 in the first data table shown. Figure 3 or Figure 4 Any column from column B to column J in the first data table shown.

[0072] The indicator setting operation is used to trigger the setting of indicators for specific items, specifically the triggering operation of the indicator setting function button.

[0073] Candidate metrics are pre-set metrics stored in the metric library. Specifically, they can include row metrics and column metrics. Row metrics are metrics that can be associated with a row in a data report; column metrics are metrics that can be associated with a specific column in a data report. Row metrics and column metrics can be set according to specific business scenarios.

[0074] like Figure 4 The indicator repository shown is a financial data collection scenario. The row indicators in this repository are time indicators, such as "2018", "2019", "2020", "2021", "2022", "2023" and "2024", while the column indicators are specific financial indicators, such as "operating revenue", "net profit", "basic earnings per share", "total earnings per share", "return on equity", "return on total assets", "gross profit margin", "debt-to-equity ratio", "current ratio" and "quick ratio".

[0075] Understandably, the pre-set indicators stored in the indicator library, when pre-set, in addition to setting the indicator name for each indicator, also set the indicator identifier, indicator type and other attributes for each indicator. The indicator identifier is used to uniquely identify an indicator, and the indicator type can be a row indicator type or a column indicator type; other attributes can be the unit or other descriptive information of the indicator.

[0076] Specifically, the terminal can display the first data report in the table display area of ​​the data processing application's working interface, and display the indicator setting function button in the work bar area of ​​the working interface. When the user wants to set an indicator for the target item in the first data report, he / she can first select the target item in the first data report, and then click the indicator setting function button. The terminal responds to the click operation of the indicator setting function button and displays candidate indicators.

[0077] In one embodiment, when a user wants to set an indicator for a target item in the first data report, they can first select a cell in the target item in the first data report, and then click the indicator setting function button. The terminal responds to the click operation of the indicator setting function button and displays candidate indicators.

[0078] In one embodiment, the terminal displays candidate indicators in response to a click operation on the indicator setting function button, including: in response to a click operation on the indicator setting function button, determining the target indicator type that matches the target entry, retrieving the indicator of the target indicator type from the indicator repository, and displaying the retrieved indicator of the target indicator type as a candidate indicator.

[0079] For example, if the target item is a target row, the row indicator is retrieved from the indicator repository and displayed as a candidate indicator; if the target item is a target column, the column indicator is retrieved from the indicator repository and displayed as a candidate indicator.

[0080] S206, in response to the indicator selection operation, displays the indicator status indicating that the target indicator has been set at the corresponding position of the target entry; the target indicator is the indicator specified by the indicator selection operation among the candidate indicators.

[0081] Specifically, the indicator selection operation can be a click operation on the target indicator. The corresponding position of the target item can be a preset position of the target row or target column. For example, the preset position of the target column can be the first cell corresponding to the target column in the data filling area, and the preset position of the target row can be the first cell corresponding to the target row in the data filling area.

[0082] The status of an indicator can be specifically represented by preset identifiers, which can be icon identifiers, color identifiers, text identifiers, etc. (See reference...) Figure 5 In the first data report shown, a black triangle icon is displayed in the upper right corner of the first cell (i.e., cell D3) in column D, corresponding to the data fill area. This black triangle icon indicates that the target indicator for column D has been set. Similarly, a black triangle icon is displayed in the upper right corner of the first cell (i.e., cell B4) in row 4, indicating that the target indicator for row 4 has been set.

[0083] S208, in response to the first storage operation, the target indicator and the cell data in the target entry are stored together so that when the data is processed through the second data report, the cell data in the target entry stored together can be found and displayed based on the target indicator.

[0084] The first storage operation is the data entry operation for the collected data, which can specifically be the triggering of the data entry function button. The cell data in the target entry can specifically be the indicator values ​​of different collected metrics. It can be understood that after the target metric is set, that is, after the relationship between the target entry and the target metric is established, the cell data in the target entry is the indicator value of the target metric.

[0085] The second data report can be any other data report besides the first data report, used for data processing. For example, the second data report can be a blank report.

[0086] Linking and storing cell data in target metrics and target entries means mapping and storing the cell data (i.e., metric values) collected in the target entries to the target metrics associated with the target entries. In other words, when a cell is associated only with the target row metric, its cell data is stored only with that target row metric; when a cell is associated only with the target column metric, its cell data is stored only with that target column metric; and when a cell's target row and target column are associated with both the target row metric and the target column metric, its cell data is stored with both the target row metric and the target column metric.

[0087] It should be noted that the association between cell data and target indicators can be direct or indirect. Direct association means establishing a direct correspondence between the target indicator and cell data in the database. Indirect association means establishing a correspondence between the target indicator and cell data through an intermediate element. There can be one or more intermediate elements. For example, an association can be established between the target indicator and an intermediate element, and an association can also be established between the intermediate element and the cell data. This is achieved through these two associations. The intermediate element can be at least one of the following: indicator identifier or cell coordinates.

[0088] In one embodiment, when the first data report is a report prior to data collection, after the terminal displays the indicator status indicating that the target indicator has been set in the first data report, it can also trigger a shared version submission operation. In response to the shared version submission operation, the terminal shares the currently configured first data report with the target object so that the target object can enter data in the first data report. After receiving the data entry completion notification, the terminal displays the first data report after the data entry is completed. For the first data report after the data entry is completed, in response to the first storage operation, the target indicator and the cell data in the target entry are associated and stored.

[0089] like Figure 5 In the first data report shown, corresponding target metrics have been configured for the target items. Users can click the "Submit Shared Version" button, and the data collector's terminal will respond to the click operation of the "Submit Shared Version" button by sharing the first data report to the data provider. Figure 6 This diagram illustrates the first data report displayed on the data provider's terminal. Figure 6In the first data report displayed, the data provider enters the corresponding indicator data according to the indicator information provided in the first data report, and clicks the "Submit" button after completing the entry. The data provider's terminal responds to the click of the "Submit" button by sending an entry completion notification to the receipt collector's terminal. Upon receiving the entry completion notification, the receipt collector's terminal displays... Figure 7 The first data report shown is completed after data entry. After verifying the entered data and confirming its accuracy, the user can click the "Submit Review Result" button. This "Submit Review Result" button is the data entry function button. The terminal of the receipt collector responds to the click of the "Submit Review Result" button by associating and storing the cell data in the target indicator and the target item. For example, column D is associated with the column indicator "2018", row 4 is associated with the row indicator "Operating Revenue", and cell D4 contains the data "3216.94". Cell D4 stores the indicator value for that year (2018) and that indicator (Operating Revenue), so a mapping relationship "(2018, Operating Revenue) - 3216.94" can be established. Furthermore, assuming the indicator identifier for the column indicator "2018" is "L0001" and the indicator identifier for the row indicator is "H0001", a mapping relationship "(L0001, H0001) - The established mapping relationship, "3216.94", represents the operating revenue in 2018 as 3216.94. After establishing the mapping relationship, it can be stored in the database for subsequent querying, updating, and analysis.

[0090] In one embodiment, when the first data report is a report indicating that data collection has been completed, after the terminal displays the indicator status in the first data report to indicate that the target indicator has been set, the user can directly trigger the first storage operation. In response to the first storage operation, the terminal associates and stores the target indicator and the cell data in the target entry.

[0091] like Figure 7 In the first data report shown, corresponding target indicators have been configured for the target items. After the entered data is reviewed and confirmed to be correct, the user can click the "Submit Review Result" button. This "Submit Review Result" button is the database entry function button. The terminal of the receipt collector responds to the click operation of the "Submit Review Result" button and associates and stores the target indicators and cell data in the target items in the database.

[0092] In one embodiment, when a user needs to use the data of a certain indicator while processing data through the second data report, they can directly initiate a data retrieval operation for the target indicator in the second data report. In response to the data retrieval operation, the terminal can directly search for cell data in the target entry stored in the database based on the target indicator and display the found cell data for subsequent data processing.

[0093] In one embodiment, when the terminal processes data through the second data report, the process of finding and displaying cell data in the associated stored target entry based on the target indicator may specifically include steps S902 to S908, and the specific implementation methods described in steps S902 to S908 can be found here.

[0094] The above data processing method, after displaying the first data report, displays candidate indicators in response to the indicator setting operation for the target item in the first data report. The target item is at least one of the target rows or target columns in the first data report. In response to the indicator selection operation, an indicator status indicating that the target indicator has been set is displayed at the corresponding position of the target item. The target indicator is the indicator specified by the indicator selection operation among the candidate indicators. By flexibly setting indicators for the target items in the first data report, the target items can be associated with the specified target indicators. Subsequently, in response to the first storage operation, the target indicator and the cell data in the target item can be associated and stored. With the target indicator and the cell data in the target item associated and stored, when the indicator data of the target indicator is needed during the subsequent data processing through the second data report, the cell data in the associated target item (i.e., the indicator data of the target indicator) can be directly searched and displayed in the second data report based on the target indicator. This avoids manually opening the first data report to query and copy the indicator data of the target indicator (i.e., the cell data in the target item), improving the efficiency of obtaining the indicator data of the target indicator and ensuring the accuracy of the indicator data of the target indicator. This, in turn, can improve the efficiency and accuracy of data processing in subsequent data processing.

[0095] In one embodiment, the process of displaying candidate indicators in response to an indicator setting operation for a target item in a first data report includes the following steps: when the target item or the header cell of the target item in the first data report is selected, candidate indicators are displayed in response to the triggered indicator setting operation; header information is displayed in the header cell; the process of displaying an indicator status indicating that the target indicator has been set at the corresponding position of the target item in response to an indicator selection operation includes the following steps: in response to the indicator selection operation, an indicator status indicating that the target indicator has been set is displayed at a preset position in the header cell.

[0096] In this context, the header cell refers to the cell in the first data report used to display header information. Header information refers to the labels or titles used to describe data rows or columns. Specifically, the header cell can be the cell in the first row or first column of the data fill area of ​​the first data report, such as... Figure 3 or Figure 4 The first data report shown has cells B3-J3 as header cells, cells B3-B10 as header cells, cell C3 displaying the header information "Unit", cell D3 displaying the header information "2018", and cell B10 displaying the header information "Gross Profit Margin".

[0097] The default position of the header cell can be any position among the top left, bottom left, top right, bottom right, center, cell border, etc.

[0098] Specifically, the terminal can display the first data report in the table display area of ​​the data processing application's working interface, and display the indicator setting function button in the work bar area of ​​the working interface. When the user wants to set an indicator for a target item in the first data report, they can select the header cell of the target item and then click the indicator setting function button. In response to the click operation of the indicator setting function button, the terminal displays candidate indicators. For the displayed candidate indicators, the user can select the target indicator. In response to the selection operation of the target indicator, the terminal displays the indicator status indicating that the target indicator has been set in the preset position of the header cell.

[0099] refer to Figure 5 In the first data report shown, a black triangle icon is displayed in the upper right corner of the header cell (i.e., cell D3) in column D, corresponding to the data fill area. This black triangle icon indicates that the target indicator for column D has been set. Similarly, a black triangle icon is displayed in the upper right corner of the header cell (i.e., cell B4) in row 4, corresponding to the data fill area. This black triangle icon indicates that the target indicator for row 4 has been set.

[0100] In the above embodiments, when the target entry or the header cell of the target entry in the first data report is selected, the terminal displays candidate indicators in response to the triggered indicator setting operation; the header cell displays header information; in response to the indicator selection operation, the indicator status indicating that the target indicator has been set is displayed at a preset position in the header cell. Flexible indicator setting of the target entry in the first data report can associate the target entry with the specified target indicator, so that in response to the first storage operation, the target indicator and the cell data in the target entry can be associated and stored, improving the convenience of operation.

[0101] In one embodiment, the cell attributes of the header cell include an indicator attribute field; the process by which the terminal displays an indicator status indicating that the target indicator has been set at a preset position in the header cell in response to an indicator selection operation includes the following steps: in response to an indicator selection operation, obtaining the indicator identifier of the target indicator; storing the indicator identifier in the indicator attribute field of the header cell, and then displaying an indicator status indicating that the target indicator has been set at a preset position in the header cell.

[0102] Cell attributes describe the specific characteristics of a cell. In the data report of this application, each cell's cell attributes may include row coordinates, column coordinates, cell style, font style, cell value, cell value formatting rules, and other attribute fields. For header cells, indicator attribute fields can be pre-added to their cell attributes. Alternatively, indicator attribute fields can be added to the cell attributes of each cell in the data report of this application, such as... Figure 4 As shown, the indicator attribute field can be used to record the indicator identifier of the indicator associated with the cell.

[0103] Specifically, for the displayed candidate indicators, the user can select the target indicator. In response to the selection of the target indicator, the terminal retrieves the indicator identifier of the target indicator from the indicator repository based on the selected target indicator and stores the indicator identifier in the indicator attribute field of the selected header cell. After the indicator identifier is stored, the first report can be re-rendered to display the indicator status indicating that the target indicator has been set in the preset position of the header cell.

[0104] like Figure 9 As shown, the selected target indicator is "net profit", and the indicator identifier for "net profit" is "H0005". After storing the indicator identifier for "net profit" in the indicator attribute field of the selected header cell, a black triangle icon is displayed in the upper right corner of the selected header cell.

[0105] In the above embodiments, the terminal obtains the indicator identifier of the target indicator in response to the indicator selection operation; after storing the indicator identifier in the indicator attribute field of the header cell, the indicator status indicating that the target indicator has been set is displayed in a preset position in the header cell. The target entries in the first data report can be flexibly set with indicators, and the target entries can be associated with the specified target indicators. In this way, the target indicators and the cell data in the target entries can be associated and stored in response to the first storage operation, which improves the convenience of operation.

[0106] In one embodiment, the process of displaying candidate indicators in response to a triggered indicator setting operation includes the following steps: in response to the triggered indicator setting operation, displaying candidate indicator types; the candidate indicator types include row indicator types and column indicator types; in response to an indicator type selection operation, displaying candidate indicators belonging to the target indicator type; the target indicator type is the indicator type among the candidate indicator types that matches the target entry as specified by the indicator type selection operation.

[0107] It is understandable that indicators belonging to the row indicator type can also be called row indicators, and indicators belonging to the column indicator type can also be called column indicators, such as... Figure 4 The indicator repository shown is a financial data collection scenario. The row indicators in this repository are time indicators, such as "2018", "2019", "2020", "2021", "2022", "2023" and "2024", while the column indicators are specific financial indicators, such as "operating revenue", "net profit", "basic earnings per share", "total earnings per share", "return on equity", "return on total assets", "gross profit margin", "debt-to-equity ratio", "current ratio" and "quick ratio".

[0108] Specifically, the terminal can display the first data report in the table display area of ​​the data processing application's working interface, and display the indicator setting function button in the work bar area of ​​the working interface. When the user wants to set indicators for the target item in the first data report, they can select the header cell of the target item and then click the indicator setting function button. In response to the click operation of the indicator setting function button, the terminal displays candidate indicator types, including row indicator types and column indicator types. When the user selects a row indicator type, the terminal displays the candidate row indicators in response to the selection operation of the row indicator type. When the user selects a column indicator type, the terminal displays the candidate column indicators in response to the selection operation of the column indicator type.

[0109] like Figure 10As shown, after selecting cell D3, the user can click the "Select Indicator" button. In response to the click of the "Select Indicator" button, the terminal displays candidate indicator types, including time indicators and financial indicators. Time indicators are row indicators, and financial indicators are column indicators. In response to the selection of "Time Indicator Type", the terminal displays candidate time indicators, such as "2018", "2019", "2020", "2021", "2022", and "2023".

[0110] In the above embodiments, the terminal displays candidate indicator types in response to the triggered indicator setting operation; the candidate indicator types include row indicator types and column indicator types; in response to the indicator type selection operation, candidate indicators belonging to the target indicator type are displayed, thereby enabling flexible indicator settings for target items in the first data report according to requirements, improving the efficiency of indicator setting.

[0111] In one embodiment, the process of a terminal associating and storing target metrics and cell data in a target entry in response to a first storage operation includes the following steps: storing a first association relationship between the target metrics and the target entry in response to the first storage operation; determining data cells in the target entry; and storing a second association relationship between the cell position of the data cell and the cell data of the data cell.

[0112] In this context, the data cells in the target entry refer to the specific cells in the data report that are associated with the target entry (such as a specific row or column). These cells contain actual data values. It can be understood that each data cell corresponds to a cell value, which is the cell data of that data cell.

[0113] In one embodiment, in response to a first storage operation, the terminal determines the cells belonging to the target entry within the data filling area of ​​the first data report. Within these cells, it identifies the header cells whose table attribute values ​​contain indicator identifiers. Other cells outside the header cells are then identified as data cells for the target entry. The terminal obtains the cell coordinates and corresponding cell data for each data cell and establishes a second association between the cell coordinates and the cell data. For example... Figure 11 As shown, the first association is "H0001-row n", and the second association is "column m, row n-12300".

[0114] In the above embodiments, the terminal, in response to the first storage operation, stores the first association relationship between the target indicator and the target entry; determines the data cell in the target entry; and stores the second association relationship between the cell position of the data cell and the cell data of the data cell. This enables flexible association storage of the target indicator and the cell data in the target entry. With the target indicator and the cell data in the target entry stored in association, when the indicator data of the target indicator is needed during subsequent data processing through the second data report, the cell data (i.e., the indicator data of the target indicator) in the associated target entry can be directly searched and displayed in the second data report based on the target indicator. This avoids manually opening the first data report to query and copy the indicator data (i.e., the cell data in the target entry), improving the efficiency of obtaining the indicator data of the target indicator and ensuring the accuracy of the indicator data of the target indicator. This, in turn, can improve the efficiency and accuracy of data processing in subsequent data processing.

[0115] In one embodiment, the target entry includes a target row and a target column, the target metric includes a target row metric and a target column metric, and the data cell is the cell at the intersection of the target row and the target column; the process of the terminal storing the first association between the target metric and the target entry includes the following steps: storing the row metric association between the target row metric and the target row; storing the column metric association between the target column metric and the target column.

[0116] Specifically, when the target entries in the first data report include target rows and target columns, for the target row, the row indicator relationships between its associated target row indicators are determined and stored; for the target column, the column indicator relationships between its associated target column indicators are determined and stored. The terminal can determine the cell corresponding to the intersection of the target row and target column as a data cell, and obtain the cell coordinates and corresponding cell data of each data cell, establishing a second relationship between the cell coordinates and the cell data of the data cells. For example... Figure 12 As shown, the row indicator relationship is "H0001-nth row", the column indicator relationship is "L0001-mth column", and the second relationship is "mth column nth row-12300".

[0117] In the above embodiments, the terminal, when the target entry includes target rows and target columns, the target indicator includes target row indicators and target column indicators, and the data cell is the cell at the intersection of the target row and target column, can achieve the associated storage of target indicators and cell data in target entries by storing the row indicator association relationship between target row indicators and target rows, and storing the column indicator association relationship between target column indicators and target columns. With the target indicator and cell data in target entries stored in association, when the indicator data of the target indicator is needed during subsequent data processing through the second data report, the cell data (i.e., the indicator data of the target indicator) in the associated target entry can be directly searched and displayed in the second data report based on the target indicator. This avoids manually opening the first data report to query and copy the indicator data (i.e., the cell data in the target entry), improving the efficiency of obtaining the indicator data of the target indicator and ensuring the accuracy of the indicator data of the target indicator. This can improve the efficiency and accuracy of data processing in subsequent data processing.

[0118] In one embodiment, the data processing method further includes the following steps: in response to a data modification operation on a data cell, obtaining the modified cell data of the data cell; in response to a first storage operation, updating the cell data in the stored second association relationship to the modified cell data.

[0119] Specifically, after a user triggers the first storage operation to associate and store the target indicator and the cell data in the target entry into the database, if the indicator value is found to be incorrect, the user can modify the cell data in the corresponding data cell. The terminal responds to the data modification operation by obtaining the modified cell data. After the data modification is completed, the user can trigger the first storage operation again. The terminal responds to the first storage operation by updating the cell data in the stored second association relationship with the modified cell data.

[0120] In the above embodiments, the terminal obtains the modified cell data of the data cell in response to the data modification operation of the data cell; in response to the first storage operation, it updates the cell data in the stored second association relationship with the modified cell data, thereby realizing flexible modification of the association relationship between the target indicator and the target entry, improving the flexibility of modifying the cell data of the stored target indicator, and ensuring the accuracy of the cell data of the stored target indicator.

[0121] In one embodiment, the first data report is a shared version data report, and the above data processing method further includes the following steps: in response to a second storage operation, storing the shared version data report in the form of a personal version to obtain a personal version data report; in response to a shared version submission operation, sharing the shared version data report to a target object so that the target object can enter data in the shared version data report.

[0122] The first data report is a shared version data report, which means that the first data report is a version that can be accessed and edited by multiple users. In this shared version, the content of the data report can be viewed, modified or supplemented by different users, while maintaining a certain degree of synchronization and collaboration.

[0123] Personal version data reports are copies created based on shared version data. Each user can create their own independent copy of the shared version data report and perform personalized data operations and processing on it. For example, a user can populate data in a specific area of ​​their personal version, and these modifications will not affect other users' shared version data reports. It's important to understand that, unlike the shared version, the data in the personal version is private to the user and can only be viewed and modified by that specific user.

[0124] The second storage operation can be a personal version save operation, specifically clicking the personal version save button. The shared version submit operation can be clicking the shared version submit button, which is used to submit the edited or modified shared version data report to the target object or other collaborating members so that they can enter the data.

[0125] Specifically, the terminal can display the first data report in the table display area of ​​the data processing application's working interface, and display a personal version save button and a shared version submit button in the work bar area of ​​the working interface. When a user wants to obtain the personal version data report, they can click the personal version save button. The terminal responds to the click operation of the personal version save button and saves the first data report as the user's personal version data report. If the shared version data report is the report before data collection, when the user has completed the configuration of the shared version data report and wants the target object to enter data, they can click the shared version submit button. The terminal responds to the click operation of the shared version submit button and shares the configured shared version data report to the target object, so that the target object can see the configured shared version data report and enter data.

[0126] like Figure 5The system displays a "Save Personal Version" button. When a user wants to obtain a personal version data report, they can click the "Save Personal Version" button. The terminal responds to the click operation of the "Save Personal Version" button and saves the first data report as the user's personal version data report. Figure 5 The system also displays a "Submit Shared Version" button. When a user has completed the configuration of the shared version data report and wants the target object to enter data, they can click the "Submit Shared Version" button. The terminal responds to the click operation of the "Submit Shared Version" button by sharing the configured shared version data report to the target object, so that the target object can see the configured shared version data report and enter data.

[0127] It should be noted that the reference Figure 13 Unlike other online forms that only have one main version, the online form designed in this invention has multiple versions and branches. The form is divided into personal versions and shared versions. The personal version can be operated and saved on the basis of the shared version without affecting the shared version or other people's personal versions. It can freely perform sheet operations, formula calculations, table import and export, etc., which can improve the efficiency of filling and reduce the probability of accidental submission.

[0128] In the above embodiments, the terminal, in response to the second storage operation, stores the shared version data report in the form of a personal version to obtain a personal version data report; in response to the shared version submission operation, it shares the shared version data report to the target object so that the target object can enter data in the shared version data report, thereby achieving rapid data collection and improving the efficiency of data collection.

[0129] In one embodiment, the above data processing method further includes the following steps: after receiving the data entry completion notification, displaying the data entry shared version report; the data entry shared version report is obtained by data entry into the shared version report; the process of the terminal responding to the first storage operation and associating and storing the cell data in the target indicator and the target entry further includes the following steps: in response to the first storage operation, associating and storing the cell data in the target entry in the data entry shared version report.

[0130] Specifically, the target user enters data into the shared version data report and submits the report after data entry is completed. Upon receiving the data entry completion notification, the terminal displays the shared version data report so that the user can review it. After the user confirms that the data entry is correct, the user can trigger the first storage operation. The terminal responds to the first storage operation by storing the cell data of the target entry in the shared version data report.

[0131] like Figure 5 In the first data report shown, corresponding target metrics have been configured for the target items. Users can click the "Submit Shared Version" button, and the data collector's terminal will respond to the click operation of the "Submit Shared Version" button by sharing the first data report to the data provider. Figure 6 This diagram illustrates the first data report displayed on the data provider's terminal. Figure 6 In the first data report displayed, the data provider enters the corresponding indicator data according to the indicator information provided in the first data report, and clicks the "Submit" button after completing the entry. The data provider's terminal responds to the click of the "Submit" button by sending an entry completion notification to the receipt collector's terminal. Upon receiving the entry completion notification, the receipt collector's terminal displays... Figure 7 The first data report shown is completed after the data entry is completed. After the entered data is reviewed and confirmed to be correct, the user can click the "Submit Review Result" button. This "Submit Review Result" button is the data entry function button. The terminal of the receipt collector responds to the click operation of the "Submit Review Result" button and associates and stores the cell data in the target indicator and the target item.

[0132] In the above embodiments, after receiving the input completion notification, the terminal displays the input-after-shared version data report. The input-after-shared version data report is obtained by inputting data into the shared version data report. In response to the first storage operation, the cell data in the target entry of the input-after-shared version data report is stored in association. With the target indicator and the cell data in the target entry stored in association, when the indicator data of the target indicator is needed during the subsequent data processing through the second data report, the cell data in the target entry (i.e., the indicator data of the target indicator) can be directly searched and displayed in the second data report based on the target indicator. This avoids manually opening the first data report to query and copy the indicator data of the target indicator (i.e., the cell data in the target entry), improving the efficiency of obtaining the indicator data of the target indicator and ensuring the accuracy of the indicator data of the target indicator. This can improve the efficiency and accuracy of data processing in subsequent data processing.

[0133] In one embodiment, the data processing method further includes the following steps: in response to a first storage operation, storing a shared version data report after data entry; when entering a new data collection cycle, in response to a report open operation, displaying the shared version data report after data entry as a shared version data report for the new data collection cycle, and displaying newly added blank entries in the displayed shared version data report for the new data collection cycle; displaying an indicator status indicating that a new indicator has been set at the corresponding position of the blank entries; the new indicator is an indicator that conforms to the new data collection cycle; in response to a shared version submit operation, sharing the shared version data report for the new data collection cycle to the target object, so that the target object can enter data in the shared version data report for the new data collection cycle.

[0134] A data collection cycle refers to the time frame within which a system or organization collects, organizes, analyzes, and stores data under specific conditions or within a specific time period. A data collection cycle can be any of the following: annual, quarterly, monthly, or daily. A new data collection cycle refers to the next cycle that begins after the end of one data collection cycle. In the business process, each new cycle signifies the restart of data collection.

[0135] The newly added blank entries refer to the expansion of the data-filled area of ​​the shared version data report in order to reserve unfilled rows or columns for new data collection cycles.

[0136] Specifically, in response to the first storage operation, the terminal associates and stores the target metric and the cell data in the target entry. Simultaneously, it stores the shared version data report after data entry. Upon entering a new data collection cycle, the terminal opens the shared version data report through the data processing application, displaying it as the shared version data report for the new data collection cycle. Based on the metric associations of each entry in the shared version data report, it determines the new metric and, based on the metric type of the new metric, determines the type of new blank entry required. Then, based on the type of the new blank entry, it expands the data filling area of ​​the shared version data report. This process allows for the creation of new blank entries and the identification of target cells within those entries to display new metrics. Simultaneously, the newly added blank entries are displayed in the shared version of the data report for the new data collection period. The target cells also display the new metrics, with a preset position indicating that the new metrics have been set. When a user wants the target object to enter data, they can click the "Shared Version Submit" button. The terminal responds to this click by sharing the shared version of the data report for the new data collection period to the target object, enabling them to enter data within the report.

[0137] For example, the new data collection cycle is set for 2025, such as... Figure 14 As shown, the time indicator "2025" has already been created in the indicator repository. When 2025 arrives, the terminal opens the shared version data report after data entry through the data processing application. By analyzing this shared version data report, the new indicator "2025" is determined. This new indicator belongs to the column indicator type, so the type of the required new blank entry is determined to be column. The adjacent time indicator for the new indicator "2025" is determined to be "2024". The target entry associated with the time indicator "2024" is determined to be column J. Therefore, the required new blank entry is determined to be column K. The indicator status based on the time indicator "2024" is displayed in cell J3. Therefore, cell K3, which is used to display the new indicator "2025", is determined to be cell K3. Figure 15 As shown, cell K3 displays the newly added indicator "2025", and a default position in cell K3 indicates that the new indicator has been set. Furthermore, in the data fill area, areas other than the newly added entry can be set to non-editable, such as... Figure 15 As shown, the cell data in cells D4 to J11 is gray, indicating that the cell data in cells D4 to J11 cannot be edited.

[0138] In the above embodiments, in response to the first storage operation, the shared version data report after data entry is stored; when a new data collection cycle begins, in response to the report opening operation, the shared version data report after data entry is displayed as the shared version data report for the new data collection cycle, and newly added blank entries are displayed in the displayed shared version data report for the new data collection cycle; at the corresponding position of the blank entries, an indicator status indicating that the newly added indicator has been set is displayed; the newly added indicator is an indicator that conforms to the new data collection cycle; in response to the shared version submission operation, the shared version data report for the new data collection cycle is shared to the target object, so that the target object can enter data in the shared version data report for the new data collection cycle, thereby quickly creating a shared version data report for the new data collection cycle, thereby achieving rapid data collection and improving the efficiency of data collection.

[0139] In one embodiment, the data processing method further includes the following steps: in response to a report open operation for a personal version data report, displaying a personal version data report; in response to a shared version submission operation, sharing the personal version data report as a shared version data report to a target object, so that the target object can enter data in the shared version data report.

[0140] Specifically, the terminal responds to the report opening operation for the personal version data report through the data processing application, loads the user's personal version data report from storage, and displays it. This data report is a copy created based on the shared version data report, in which the user can make personalized edits. After completing the editing of the personal version data report, when the user wants to share its content with other target objects for data entry, they can click the shared version submission button. The terminal responds to the click operation of the shared version submission button, converts the personal version data report into a shared version data report, and shares it with the target object. After receiving the shared version data report, the target object can enter data in the report.

[0141] In the above embodiments, the terminal displays the personal version data report in response to the report opening operation for the personal version data report; in response to the shared version submission operation, the personal version data report is shared as a shared version data report to the target object, so that the target object can enter data in the shared version data report, thereby improving the flexibility of creating the shared version data report, enabling the version data report to be shared quickly, thereby achieving rapid data collection and improving the efficiency of data collection.

[0142] In one embodiment, such as Figure 16 As shown, another data processing method is provided, which can be applied to... Figure 1 Taking terminal 102 as an example, the explanation includes the following steps:

[0143] S1602 displays a second data report for data processing.

[0144] The second data report can be any other data report besides the first data report, used for data processing. For example, the second data report can be a blank report.

[0145] In one embodiment, a data processing application may be running on the terminal, and the user can create a blank report through the data processing application, which is the second data report.

[0146] In one embodiment, a data processing application may be running on the terminal, allowing the user to load and display an existing second data report.

[0147] The data processing application can be a standalone application or a sub-application embedded in other management platforms. In this embodiment, the data processing application may include an online spreadsheet function, which refers to a spreadsheet tool that can be accessed and operated via a network. When the data processing application includes an online spreadsheet function, users can share spreadsheets with others through links or permission settings.

[0148] S1604, in response to the indicator setting operation in the first cell of the second data report, displays candidate indicators.

[0149] It is understandable that when the second data report is a blank report, the first cell can be any cell in the second data report; when the second data report contains a data-filled area, the first cell can be a cell in the data-filled area.

[0150] The indicator setting operation is used to trigger the setting of indicators for specific items, specifically the triggering operation of the indicator setting function button.

[0151] Candidate metrics are pre-set metrics stored in the metric library. Specifically, they can include row metrics and column metrics. Row metrics are metrics that can be associated with a row in a data report; column metrics are metrics that can be associated with a specific column in a data report. Row metrics and column metrics can be set according to specific business scenarios.

[0152] like Figure 4 The indicator repository shown is a financial data collection scenario. The row indicators in this repository are time indicators, such as "2018", "2019", "2020", "2021", "2022", "2023" and "2024", while the column indicators are specific financial indicators, such as "operating revenue", "net profit", "basic earnings per share", "total earnings per share", "return on equity", "return on total assets", "gross profit margin", "debt-to-equity ratio", "current ratio" and "quick ratio".

[0153] Understandably, the pre-set indicators stored in the indicator library, when pre-set, in addition to setting the indicator name for each indicator, also set the indicator identifier, indicator type and other attributes for each indicator. The indicator identifier is used to uniquely identify an indicator, and the indicator type can be a row indicator type or a column indicator type; other attributes can be the unit or other descriptive information of the indicator.

[0154] Specifically, the terminal can display a second data report in the table display area of ​​the data processing application's working interface, and display an indicator setting function button in the work bar area of ​​the working interface. When the user wants to set an indicator for the first cell of the second data report, he / she can first select the first cell in the second data report, and then click the indicator setting function button. The terminal responds to the click operation of the indicator setting function button and displays candidate indicators.

[0155] In one embodiment, the terminal displays candidate indicators in response to a click operation on the indicator setting function button, including: displaying candidate indicator types in response to a click operation on the indicator setting function button; the candidate indicator types include row indicator types and column indicator types; and displaying candidate indicators belonging to the target indicator type in response to an indicator type selection operation; the target indicator type is the indicator type specified by the indicator type selection operation among the candidate indicator types.

[0156] S1606, in response to the indicator selection operation, displays the indicator status in the preset position of the first cell to indicate that the target indicator has been set; the target indicator is the indicator specified by the indicator selection operation from the candidate indicators.

[0157] Specifically, the indicator selection operation can be a click operation on the target indicator. The preset position of the first cell can be any position among the top left, bottom left, top right, bottom right, center, cell border, etc.

[0158] The status of an indicator can be represented by preset identifiers, which can be icon identifiers, color identifiers, text identifiers, etc.

[0159] In one embodiment, when the first cell is blank, the terminal, in response to the indicator selection operation, displays an indicator status indicating that the target indicator has been set at a preset position in the first cell, and also displays the selected target indicator in the first cell. (See reference) Figure 17 In the second data report shown, a black triangle icon is displayed in the upper right corner of the first cell (i.e., cell B4); at the same time, the target indicator name "current ratio" is displayed in cell B4.

[0160] S1608, in response to the data retrieval operation, displays the cell data found based on the target indicator in the second cell of the second data report; the second cell and the first cell belong to the same row or column; the cell data is associated with the target indicator by setting the target indicator for the target entry in the first data report.

[0161] Specifically, the data retrieval operation can be the clicking of the indicator data retrieval function button.

[0162] Specifically, while displaying candidate indicators, the terminal also displays an indicator data retrieval function button. When a user wants to retrieve the indicator data of a target indicator, they can click the indicator data retrieval function button. In response to the click operation of the indicator data retrieval function button, the terminal searches for the cell data corresponding to the target indicator in the database, and determines the second cell in the target entry to display the cell data based on the target indicator associated with it in the second data report. The found cell data is then displayed in the second cell of the second data report.

[0163] refer to Figure 17 When a user wants to retrieve the target metric data, they can click the "Retrieve Metric" button. The terminal responds to this click by searching the database for the cell data corresponding to the target metric. Figure 18 As shown, the second cell of the second data report displays the cell data found based on the target indicator.

[0164] The aforementioned data processing method, by pre-associating and storing the target indicator with cell data from the target entry in the first data report, allows for subsequent data processing when a second data report is displayed. In response to an indicator setting operation on the first cell in the second data report, candidate indicators are displayed. In response to an indicator selection operation, an indicator status indicating that the target indicator has been set is displayed at a preset position in the first cell. The target indicator is the one specified by the indicator selection operation from among the candidate indicators. By flexibly setting the indicator for the row or column of the first cell in the second data report, the row or column can be associated with the specified target indicator. Therefore, in response to a data retrieval operation, the cell data found based on the target indicator (i.e., the indicator data of the target indicator) can be displayed in the second cell of the second data report. Since the second cell and the first cell belong to the same row or column, this avoids manually opening the first data report to query and copy the target indicator data (i.e., cell data from the target entry), improving the efficiency of target indicator data acquisition and ensuring the accuracy of the target indicator data. This, in turn, improves data processing efficiency and accuracy in subsequent data processing.

[0165] In one embodiment, the process of a terminal displaying cell data found based on a target indicator in a second cell of a second data report includes the following steps: in response to a data retrieval operation, searching for cell data associated with the target indicator in a database; determining a second cell in the second data report for displaying data based on the target indicator; and displaying the cell data in the second cell.

[0166] In one embodiment, when the target indicator and cell data are stored in the database in a direct association manner, the terminal can directly find the cell data based on the target indicator; when the target indicator and cell data are stored in the database in an indirect association manner, the terminal needs to first find the intermediate element based on the target indicator, and then find the cell data based on the intermediate element.

[0167] In one embodiment, when the target metric includes a target row metric and a target column metric, the target row associated with the target row metric in the second data report and the target column associated with the target column metric in the second data report can be determined, and the cell corresponding to the intersection of the target row and the target column can be determined as the second cell, and the found cell data can be displayed in the second cell.

[0168] In the above embodiments, the terminal, in response to a data retrieval operation, searches for cell data associated with the target indicator in the database; based on the target indicator, it determines the second cell in the second data report for displaying the data; and displays the cell data in the second cell. This avoids manually opening the first data report to query and copy the indicator data of the target indicator (i.e., the cell data in the target entry), improving the efficiency of obtaining the indicator data of the target indicator and ensuring the accuracy of the indicator data of the target indicator. This, in turn, can improve the efficiency and accuracy of data processing in subsequent data processing.

[0169] In one embodiment, the target indicator and cell data are stored in the database in an indirect association storage manner, and the intermediate element used for indirect association storage is the target entry of the first data report. The process of the terminal searching for the cell data associated with the target indicator in the database includes the following steps: based on the first association relationship between the target indicator and the target entry stored in the database, searching for the target entry associated with the target indicator; based on the second association relationship between the cell position of the data cell and the cell data of the data cell in the first data report stored in the database, searching for the cell data corresponding to the target entry.

[0170] Specifically, the database stores the first association between the target indicator and the target item in the first data report, as well as the second association between the cell position of the data cell of the target item in the first data report and the cell data of the data cell. The terminal can first find the target item in the first data report corresponding to the target indicator based on the first association, then find the cell position corresponding to the target item, and find the cell data corresponding to the cell position based on the second association. The cell data found is the cell data corresponding to the target item.

[0171] In the above embodiments, the terminal finds the target entries associated with the target indicators based on the first association relationship between the target indicators and target entries stored in the database; and finds the cell data corresponding to the target entries based on the second association relationship between the cell position and cell data of the data cells in the first data report stored in the database. This avoids manually opening the first data report to query and copy the indicator data of the target indicators (i.e., the cell data in the target entries), improves the efficiency of obtaining the indicator data of the target indicators, and ensures the accuracy of the indicator data of the target indicators. In turn, it can improve the efficiency and accuracy of data processing in subsequent data processing.

[0172] In one embodiment, the process by which a terminal determines the second cell in a second data report for displaying data based on a target indicator includes the following steps: determining the entry containing the first cell that matches the indicator type of the target indicator; and determining the cell in the entry that is adjacent to the first cell as the second cell for displaying data.

[0173] Specifically, when there is only one target indicator, if the target indicator is a row indicator, the terminal determines that the row containing the first cell in the second data report is an entry matching the row indicator type, and determines the cell adjacent to the first cell in the row containing the first cell as the second cell for displaying the data; if the target indicator is a column indicator, the terminal determines that the column containing the first cell in the second data report is an entry matching the column indicator type, and determines the cell adjacent to the first cell in the column containing the first cell as the second cell for displaying the data.

[0174] In the above embodiments, the terminal determines the entry containing the first cell that matches the indicator type of the target indicator; and determines the cell adjacent to the first cell in the entry as the second cell for displaying data. Thus, in response to the data retrieval operation, the cell data found based on the target indicator can be displayed in the second cell of the second data report. This avoids manually opening the first data report to query and copy the indicator data of the target indicator (i.e., the cell data in the target entry), improving the efficiency of obtaining the indicator data of the target indicator and ensuring the accuracy of the indicator data of the target indicator. In turn, it can improve the efficiency and accuracy of data processing in subsequent data processing.

[0175] This application also provides an application scenario in which the above-described data processing method is applied. Specifically, this application scenario could be a financial statement collection scenario, and the above-described data processing method can be used in… Figure 19 The system shown is implemented, see reference. Figure 19The system includes a management interface and an investee company interface. The management interface is the management page of an investment management system, while the investee company interface is a separate system for external investee companies. When it is necessary to collect financial data from investee companies, a collection template can be set up on the management interface to collect data.

[0176] 1. The administrator first sets up the collection template.

[0177] For example, we need to collect a company's annual financial indicators.

[0178] 2. Manually label the corresponding indicators for rows and columns.

[0179] The process for labeling indicators is as follows (refer to the previous section). Figure 20 Specifically, it includes the following sub-steps:

[0180] 2.1 The overall table data structure consists of individual cells, each with fixed attributes. It is necessary to extend the indicator attributes into the original cell attributes to store indicator identifiers.

[0181] 2.2 When annotating metrics, users need to select preset metrics from the metric repository. The relevant interface is already described in the above product process. After selecting a metric, the front end will set the corresponding identifier of the metric into the cell attribute and detect changes in the cell. When the cell has the metric identifier, the rendering method will be called to render the small black triangle into the cell to prompt the user.

[0182] 2.3 Detect user input, save the user input content and send it to the backend for storage.

[0183] In this system, the front end is built using the React technology framework and adopts the open-source spreadsheet library luckysheet. This library already has good support for general spreadsheet editing capabilities, but it does not have related capabilities such as labeling metrics. It needs to be further developed to support metric-related capabilities.

[0184] The backend uses the Java framework, and the messaging system uses Pulsar. For storage, a combination of MySQL and MongoDB is used to achieve high performance. MongoDB, as an online table-based database, allows for partial cell submission of changes instead of the previous method of submitting complete table data to the backend for saving each new record. This saves network bandwidth and fully leverages MongoDB's partial update capabilities to improve update performance. Furthermore, asynchronous backups of historical data changes are achieved through monitoring and subscribing to oplog ChangeStreams. This approach does not affect the main data storage and retrieval process, improving database read / write efficiency.

[0185] 2.4 Update the corresponding indicator warehouse value according to the indicator identifier.

[0186] 2.5 Save the corresponding version.

[0187] 2.6 Automatically add columns for new cycles. When a new cycle begins, a time indicator (such as 2025) needs to be added to the indicator repository. At this time, the system will search the table data to see if the latest cycle indicator is included. If not, the corresponding column number will be found based on the 2024 indicator identifier, and the indicator will be automatically added to the subsequent blank column.

[0188] 3. Display indicator status.

[0189] For example, after marking, a small black triangle will appear in the upper right corner of the corresponding cell, indicating that the row and column of that cell have been marked as indicator data.

[0190] 4. Data collection.

[0191] For example, after clicking submit, the investee company will receive a prompt to fill in the information, and then submit it for review.

[0192] 5. Data import.

[0193] After receiving and verifying the information, the management system will store the data in the database and archive the version for future reference.

[0194] 6. New cycle collection form generation.

[0195] When a new cycle begins, the system analyzes the rows and columns to identify the areas that need to be added, automatically adds a new cycle, and sets uneditable permissions for historical cycle data.

[0196] This application also provides an application scenario in which the above-described data processing method is applied. Specifically, this application scenario can be a financial data processing scenario. The data processing method includes the following three steps: indicator selection, data retrieval, and data display. The indicator selection process can be referenced... Figure 21 The flowchart shown is identical to the above-described process of labeling indicators and will not be repeated here. Data retrieval can directly retrieve the corresponding indicator data from the database based on the selected target indicator. Then, based on the row or column associated with the selected target indicator, the cell used to display the data is determined, and the retrieved indicator data is displayed in that cell.

[0197] It should be understood that although the steps in the flowcharts of the embodiments described above are shown sequentially according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the embodiments described above may include multiple steps or multiple stages. These steps or stages are not necessarily completed at the same time, but can be executed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the steps or stages of other steps.

[0198] Based on the same inventive concept, this application also provides a data processing apparatus for implementing the data processing method described above. The solution provided by this apparatus is similar to the implementation scheme described in the above method; therefore, the specific limitations in one or more data processing apparatus embodiments provided below can be found in the limitations of the data processing method described above, and will not be repeated here.

[0199] In one embodiment, such as Figure 22 As shown, a data processing device is provided, including: a report display module 2202, a candidate indicator display module 2204, an indicator status display module 2206, and a data storage module 2208, wherein:

[0200] The report display module 2202 is used to display the first data report;

[0201] The candidate indicator display module 2204 is used to display candidate indicators in response to an indicator setting operation for a target item in the first data report; the target item is at least one of a target row or a target column in the first data report.

[0202] The indicator status display module 2206 is used to respond to the indicator selection operation and display the indicator status at the corresponding position of the target entry to indicate that the target indicator has been set; the target indicator is the indicator specified by the indicator selection operation among the candidate indicators.

[0203] The data storage module 2208 is used to, in response to the first storage operation, associate and store the target indicator and the cell data in the target entry, so that when processing data through the second data report, the cell data in the associated target entry can be found and displayed based on the target indicator.

[0204] In the above embodiments, after displaying the first data report, in response to the indicator setting operation for the target item in the first data report, candidate indicators are displayed. The target item is at least one of the target rows or target columns in the first data report. In response to the indicator selection operation, an indicator status indicating that the target indicator has been set is displayed at the corresponding position of the target item. The target indicator is the indicator specified by the indicator selection operation among the candidate indicators. By flexibly setting indicators for the target items in the first data report, the target items can be associated with the specified target indicators. Subsequently, in response to the first storage operation, the target indicator and the cell data in the target item can be associated and stored. With the target indicator and the cell data in the target item associated and stored, when the indicator data of the target indicator is needed during the subsequent data processing through the second data report, the cell data in the associated target item (i.e., the indicator data of the target indicator) can be directly searched and displayed in the second data report based on the target indicator. This avoids manually opening the first data report to query and copy the indicator data of the target indicator (i.e., the cell data in the target item), improving the efficiency of obtaining the indicator data of the target indicator and ensuring the accuracy of the indicator data of the target indicator. This can improve the efficiency and accuracy of data processing in subsequent data processing.

[0205] In one embodiment, the candidate indicator display module 2204 is further configured to: display candidate indicators in response to a triggered indicator setting operation when the target entry or the header cell of the target entry in the first data report is selected; the header cell displays header information; the indicator status display module 2206 is further configured to: display an indicator status indicating that the target indicator has been set at a preset position in the header cell in response to an indicator selection operation.

[0206] In one embodiment, the cell attributes of the header cell include an indicator attribute field; the indicator status display module 2206 is further configured to: in response to an indicator selection operation, obtain the indicator identifier of the target indicator; after storing the indicator identifier in the indicator attribute field of the header cell, display the indicator status indicating that the target indicator has been set at a preset position in the header cell.

[0207] In one embodiment, the candidate indicator display module 2204 is further configured to: display candidate indicator types in response to a triggered indicator setting operation; the candidate indicator types include row indicator types and column indicator types; and display candidate indicators belonging to a target indicator type in response to an indicator type selection operation; the target indicator type is an indicator type among the candidate indicator types that is specified by the indicator type selection operation and matches the target entry.

[0208] In one embodiment, the data storage module 2208 is further configured to: in response to a first storage operation, store a first association between a target indicator and a target entry; determine a data cell in a target entry; and store a second association between the cell position of the data cell and the cell data of the data cell.

[0209] In one embodiment, the target entry includes a target row and a target column, the target metric includes a target row metric and a target column metric, and the data cell is the cell at the intersection of the target row and the target column; the data storage module 2208 is further configured to: store the row metric relationship between the target row metric and the target row; and store the column metric relationship between the target column metric and the target column.

[0210] In one embodiment, the data storage module 2208 is further configured to: in response to a data modification operation on a data cell, obtain the modified cell data of the data cell; and in response to a first storage operation, update the cell data in the stored second association relationship with the modified cell data.

[0211] In one embodiment, the first data report is a shared version data report, and the device further includes a report storage module and a report sharing module, wherein: the report storage module is used to store the shared version data report in the form of a personal version in response to a second storage operation, to obtain a personal version data report; the report sharing module is used to share the shared version data report to a target object in response to a shared version submission operation, so that the target object can enter data in the shared version data report.

[0212] In one embodiment, the report display module 2202 is further configured to: display the shared version data report after data entry is received; the shared version data report after data entry is obtained by data entry into the shared version data report; the data storage module 2208 is further configured to: in response to the first storage operation, associate and store the cell data in the target entry of the shared version data report after data entry.

[0213] In one embodiment, the data storage module 2208 is further configured to: in response to the first storage operation, store the shared version data report after data entry; the report display module 2202 is further configured to: when entering a new data collection cycle, in response to the report opening operation, display the shared version data report after data entry as the shared version data report for the new data collection cycle, and display newly added blank entries in the displayed shared version data report for the new data collection cycle; the indicator status display module 2206 is further configured to display an indicator status indicating that a new indicator has been set at the corresponding position of the blank entry; the new indicator is an indicator that conforms to the new data collection cycle; the report sharing module is further configured to, in response to the shared version submission operation, share the shared version data report for the new data collection cycle to the target object, so that the target object can enter data in the shared version data report for the new data collection cycle.

[0214] In one embodiment, the report display module 2202 is further configured to: display the personal version data report in response to a report open operation for the personal version data report; the report sharing module is further configured to: share the personal version data report as a shared version data report to the target object in response to a shared version submission operation, so that the target object can enter data in the shared version data report.

[0215] In one embodiment, such as Figure 23 As shown, a data processing device is also provided, including: a report display module 2302, a candidate indicator display module 2304, an indicator status display module 2306, and a data retrieval module 2308, wherein:

[0216] Report display module 2302 is used to display a second data report for data processing;

[0217] The candidate indicator display module 2304 is used to display candidate indicators in response to the indicator setting operation of the first cell in the second data report;

[0218] The indicator status display module 2306 is used to respond to the indicator selection operation and display the indicator status indicating that the target indicator has been set at a preset position in the first cell; the target indicator is the indicator specified by the indicator selection operation among the candidate indicators.

[0219] The data retrieval module 2308 is used to respond to the data retrieval operation and display the cell data found based on the target indicator in the second cell of the second data report; the second cell and the first cell belong to the same row or column; the cell data is associated with the target indicator by setting the target indicator for the target item in the first data report.

[0220] In the above embodiments, by pre-associating and storing the target indicator with the cell data in the target entry of the first data report, when data processing is required, a second data report for data processing is displayed. In response to the indicator setting operation of the first cell in the second data report, candidate indicators are displayed. In response to the indicator selection operation, an indicator status indicating that the target indicator has been set is displayed at a preset position in the first cell. The target indicator is the indicator specified by the indicator selection operation among the candidate indicators. By flexibly setting the indicator for the row or column to which the first cell belongs in the second data report, the row or column to which the first cell belongs can be associated with the specified target indicator. Thus, in response to the data retrieval operation, the cell data found based on the target indicator (i.e., the indicator data of the target indicator) can be displayed in the second cell of the second data report. The second cell and the first cell belong to the same row or column, avoiding the need to manually open the first data report to query and copy the indicator data of the target indicator (i.e., the cell data in the target entry), improving the efficiency of obtaining the indicator data of the target indicator, and ensuring the accuracy of the indicator data of the target indicator. This can improve the efficiency and accuracy of data processing in subsequent data processing.

[0221] In one embodiment, the data retrieval module 2308 is further configured to, in response to the data retrieval operation, search for cell data associated with the target indicator in the database; determine a second cell in the second data report for displaying data based on the target indicator; and display the cell data in the second cell.

[0222] In one embodiment, the data retrieval module 2308 is further configured to: search for target entries associated with target indicators based on a first association relationship between target indicators and target entries stored in the database; and search for cell data corresponding to target entries based on a second association relationship between cell positions and cell data in a first data report stored in the database.

[0223] In one embodiment, the data retrieval module 2308 is further configured to determine the entry containing the first cell that matches the indicator type of the target indicator; and to determine the cell in the entry that is adjacent to the first cell as the second cell for displaying data.

[0224] Each module in the aforementioned data processing device can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in or independent of the processor in a computer device, or stored in the memory of a computer device as software, so that the processor can call and execute the operations corresponding to each module.

[0225] In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as follows: Figure 24 As shown, the computer device includes a processor, memory, input / output interfaces, a communication interface, a display unit, and an input device. The processor, memory, and input / output interfaces are connected via a system bus, and the communication interface, display unit, and input device are also connected to the system bus via the input / output interfaces. The processor provides computational and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The input / output interfaces are used for exchanging information between the processor and external devices. The communication interface is used for wired or wireless communication with external terminals; wireless communication can be achieved through Wi-Fi, mobile cellular networks, NFC (Near Field Communication), or other technologies. When the computer program is executed by the processor, it implements a data processing method. The display unit of the computer device is used to form a visually visible image. It can be a display screen, a projection device, or a virtual reality imaging device. The display screen can be an LCD screen or an e-ink screen. The input device of the computer device can be a touch layer covering the display screen, or buttons, trackballs, or touchpads set on the casing of the computer device, or external keyboards, touchpads, or mice, etc.

[0226] Those skilled in the art will understand that Figure 24 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0227] In one embodiment, a computer device is also provided, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the steps in the above method embodiments.

[0228] In one embodiment, a computer-readable storage medium is provided having a computer program stored thereon that, when executed by a processor, implements the steps in the above method embodiments.

[0229] In one embodiment, a computer program product is provided, including a computer program that, when executed by a processor, implements the steps in the above method embodiments.

[0230] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, data stored, data displayed, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of related data must comply with the relevant laws, regulations and standards of the relevant countries and regions.

[0231] Those skilled in the art will understand that all or part of the processes in the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium. When executed, the computer program can include the processes of the embodiments described above. Any references to memory, databases, or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM). The databases involved in the embodiments provided in this application may include at least one type of relational database and non-relational database. Non-relational databases may include, but are not limited to, blockchain-based distributed databases. The processors involved in the embodiments provided in this application may be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, quantum computing-based data processing logic devices, etc., and are not limited to these.

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

[0233] The embodiments described above are merely illustrative of several implementation methods of this application, and while the descriptions are specific and detailed, they should not be construed as limiting the scope of this patent application. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of this application, and these all fall within the protection scope of this application. Therefore, the protection scope of this application should be determined by the appended claims.

Claims

1. A data processing method, characterized in that, The method includes: Display the first data report; In response to an indicator setting operation for a target item in the first data report, candidate indicators are displayed; the target item is at least one of a target row or a target column in the first data report. In response to the indicator selection operation, an indicator status indicating that the target indicator has been set is displayed at the corresponding position of the target entry; the target indicator is the indicator specified by the indicator selection operation from the candidate indicators. In response to the first storage operation, the target indicator and the cell data in the target entry are stored together so that when the data is processed through the second data report, the cell data in the target entry stored together can be found and displayed based on the target indicator.

2. The method according to claim 1, characterized in that, The step of displaying candidate indicators in response to an indicator setting operation for a target item in the first data report includes: When the target entry or the header cell of the target entry in the first data report is selected, candidate indicators are displayed in response to the triggered indicator setting operation; the header cell displays header information. In response to the indicator selection operation, the indicator status indicating that the target indicator has been set is displayed at the corresponding position of the target entry, including: In response to the indicator selection operation, the indicator status indicating that the target indicator has been set is displayed at a preset position in the header cell.

3. The method according to claim 2, characterized in that, The header cell's cell attributes include indicator attribute fields; in response to an indicator selection operation, displaying an indicator status indicating that the target indicator has been set at a preset position in the header cell includes: In response to the indicator selection operation, obtain the indicator identifier of the target indicator; After storing the indicator identifier in the indicator attribute field of the header cell, the indicator status indicating that the target indicator has been set is displayed at a preset position in the header cell.

4. The method according to claim 2, characterized in that, The response to the triggered metric setting operation displays candidate metrics, including: In response to a triggered indicator setting operation, candidate indicator types are displayed; the candidate indicator types include row indicator types and column indicator types. In response to the indicator type selection operation, candidate indicators belonging to the target indicator type are displayed; the target indicator type is the indicator type among the candidate indicator types that matches the target entry as specified by the indicator type selection operation.

5. The method according to claim 1, characterized in that, The step of responding to the first storage operation by associating and storing the target metric and the cell data in the target entry includes: In response to the first storage operation, a first association relationship between the target metric and the target entry is stored; Identify the data cells in the target entry; A second association relationship is established between the cell position of the data cell and the cell data of the data cell.

6. The method according to claim 5, characterized in that, The target entry includes a target row and a target column, the target metric includes a target row metric and a target column metric, and the data cell is the cell at the intersection of the target row and the target column; The storage of the first association between the target metric and the target entry includes: Store the target row metrics and the row metric relationships between the target rows; Store the target column index and the column index association relationship between the target columns.

7. The method according to claim 5, characterized in that, The method further includes; In response to a data modification operation on the data cell, the modified cell data of the data cell is obtained; In response to the first storage operation, the cell data in the stored second association relationship is updated to the modified cell data.

8. The method according to claim 1, characterized in that, The first data report is a shared version data report, and the method further includes: In response to the second storage operation, the shared version data report is stored in the form of a personal version to obtain a personal version data report; In response to the shared version submission operation, the shared version data report is shared to the target object so that the target object can enter data in the shared version data report.

9. The method according to claim 8, characterized in that, The method further includes: Upon receiving the data entry completion notification, the shared version data report after data entry is displayed; the shared version data report after data entry is obtained by entering data into the shared version data report. The step of responding to the first storage operation by associating and storing the target metric and the cell data in the target entry includes: In response to the first storage operation, the cell data in the target entry of the entered shared version data report is stored in association.

10. The method according to claim 9, characterized in that, The method further includes: In response to the first storage operation, the entered shared version data report is stored; When a new data collection cycle begins, in response to the report opening operation, the shared version data report after data entry is displayed as the shared version data report for the new data collection cycle, and the newly added blank entries are displayed in the shared version data report for the new data collection cycle. In the corresponding position of the blank entry, the indicator status indicating that the newly added indicator has been set is displayed; the newly added indicator is an indicator that conforms to the new data collection cycle. In response to the shared version submission operation, the shared version data report of the new data collection period is shared to the target object so that the target object can enter data in the shared version data report of the new data collection period.

11. The method according to claim 8, characterized in that, The method further includes: In response to a report open operation for the personal version data report, the personal version data report is displayed; In response to the shared version submission operation, the personal version data report is shared as a shared version data report to the target object, so that the target object can enter data in the shared version data report.

12. A data processing method, characterized in that, The method includes: Display a second data report for data processing; In response to the indicator setting operation in the first cell of the second data report, candidate indicators are displayed; In response to the indicator selection operation, an indicator status indicating that the target indicator has been set is displayed at a preset position in the first cell; the target indicator is the indicator specified by the indicator selection operation among the candidate indicators. In response to the data retrieval operation, the cell data found based on the target indicator is displayed in the second cell of the second data report; the second cell and the first cell belong to the same row or column; the cell data is associated with the target indicator by setting the target indicator for the target entry in the first data report.

13. The method according to claim 12, characterized in that, The second cell of the second data report displays cell data found based on the target indicator, including: In response to the data retrieval operation, the cell data associated with the target indicator is searched in the database; Based on the target indicator, determine the second cell in the second data report used to display the data; Display the cell data in the second cell.

14. The method according to claim 13, characterized in that, The step of searching the database for the cell data associated with the target indicator includes: Based on the first association relationship between the target indicator and the target entry stored in the database, the target entry associated with the target indicator is found; Based on the second association relationship between the cell position of the data cell in the first data report stored in the database and the cell data of the data cell, the cell data corresponding to the target entry is found.

15. The method according to claim 13, characterized in that, The step of determining the second cell in the second data report for displaying data based on the target indicator includes: Identify the entry in the first cell that matches the indicator type of the target indicator; The cell adjacent to the first cell in the entry is designated as the second cell for displaying data.

16. A data processing apparatus, characterized in that, The device includes: The report display module is used to display the first data report; The candidate indicator display module is used to display candidate indicators in response to an indicator setting operation for a target item in the first data report; the target item is at least one of a target row or a target column in the first data report. The indicator status display module is used to display an indicator status indicating that the target indicator has been set at the corresponding position of the target entry in response to the indicator selection operation; the target indicator is the indicator specified by the indicator selection operation among the candidate indicators. The data storage module is configured to, in response to a first storage operation, associate and store the target indicator and the cell data in the target entry, so that when processing data through a second data report, the cell data in the associated target entry can be found and displayed based on the target indicator.

17. A data processing apparatus, characterized in that, The device includes: The report display module is used to display a second data report for data processing. The candidate indicator display module is used to display candidate indicators in response to the indicator setting operation of the first cell in the second data report; The indicator status display module is used to respond to the indicator selection operation by displaying an indicator status indicating that the target indicator has been set at a preset position in the first cell; the target indicator is the indicator specified by the indicator selection operation among the candidate indicators. The data retrieval module is used to respond to the data retrieval operation and display the cell data found based on the target indicator in the second cell of the second data report; the second cell and the first cell belong to the same row or column; the cell data is associated with the target indicator by setting the target indicator for the target entry in the first data report.

18. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 15.

19. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 15.

20. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 15.

Images