CN115983214A

CN115983214A - Data editing method, apparatus, device, medium, and program product

Info

Publication number: CN115983214A
Application number: CN202211230923.7A
Authority: CN
Inventors: 黄晓岚; 蒋梅群; 陈晓建; 黄漳华
Original assignee: China Construction Bank Corp; CCB Finetech Co Ltd
Current assignee: China Construction Bank Corp; CCB Finetech Co Ltd
Priority date: 2022-09-30
Filing date: 2022-09-30
Publication date: 2023-04-18

Abstract

The embodiment of the invention relates to the technical field of data processing, and discloses a data editing method, a device, equipment, a medium and a program product, wherein the method comprises the following steps: responding to a data summarizing and editing starting instruction of a user in a current data form to be summarized, and displaying a preset user-defined data summarizing and editing interface; determining a target data summarizing object and a target data summarizing and editing strategy according to the input of the user in the preset custom data summarizing and editing interface; and responding to a data summarizing and editing operation triggering instruction of a user, and finishing the data summarizing and editing of the target data object based on the target data summarizing and editing strategy. According to the technical scheme, the problems that the summarizing and editing efficiency of multi-level report data in a filling and reporting system is low and the visualization is not high are solved, the data editing rules can be flexibly configured in the data editing process, and the summarizing efficiency of the data and the visualization degree in the data editing process are improved.

Description

Data editing method, device, equipment, medium and program product

Technical Field

Embodiments of the present invention relate to the field of data processing technologies, and in particular, to a data editing method, apparatus, device, medium, and program product.

Background

In a business organization with a multi-level organization architecture, business data is generally collected from bottom to top and edited. Generally, in a business system, indexes and calculation rules are defined, and a report is made, so that the report is distributed to the most basic level organization, and data is checked and summarized step by step upwards.

However, in the above process, the number of reports to be filled in is inconsistent under different service scenarios, and the number of indexes in each report is large, and the workload of defining the indexes is large and cumbersome. Moreover, when the report data items in different years change, the corresponding change of the index form relates to a large transformation amount, and the visualization degree of the data calculation process is low.

Disclosure of Invention

Embodiments of the present invention provide a data editing method, apparatus, device, medium, and program product, so as to implement flexible configuration of data editing rules during a data editing process, improve data summarization efficiency, and achieve high visualization degree during the data editing process.

In a first aspect, an embodiment of the present invention provides a data editing method, where the method includes:

responding to a data summarizing and editing starting instruction of a user in a current data form to be summarized, and displaying a preset user-defined data summarizing and editing interface;

determining a target data summarizing object and a target data summarizing and editing strategy according to the input of the user in the preset custom data summarizing and editing interface;

and responding to a data summarizing and editing operation triggering instruction of a user, and finishing the data summarizing and editing of the target data object based on the target data summarizing and editing strategy.

In a second aspect, an embodiment of the present invention provides a data editing apparatus, where the apparatus includes:

the data summarizing and editing function starting module is used for responding to a data summarizing and editing starting instruction of a user in a current dataform and displaying a preset user-defined data summarizing and editing interface;

the data summarizing and editing strategy determining module is used for determining a target data summarizing object and a target data summarizing and editing strategy according to the input of the user in the preset user-defined data summarizing and editing interface;

and the data summarizing and editing module is used for responding to a data summarizing and editing operation trigger instruction of a user and finishing data summarizing and editing of the target data object based on the target data summarizing and editing strategy.

In a third aspect, an embodiment of the present invention further provides a computer device, where the computer device includes:

one or more processors;

a memory for storing one or more programs;

when executed by the one or more processors, cause the one or more processors to implement a data editing method as provided by any embodiment of the invention.

In a fourth aspect, the embodiments of the present invention further provide a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the data editing method provided in any embodiment of the present invention.

In a fifth aspect, an embodiment of the present invention further provides a computer program product, on which a computer program is stored, and when the computer program is executed by a processor, the computer program implements the data editing method provided in any embodiment of the present invention.

The embodiment of the invention has the following advantages or beneficial effects:

in the embodiment of the invention, a preset user-defined data summarizing and editing interface is displayed by responding to a data summarizing and editing starting instruction of a user in a current data sheet to be summarized, and an interactive interface for editing data summarizing strategies is provided for the user; then, according to the input of a user in a preset custom data summarizing and editing interface, a target data summarizing object and a target data summarizing and editing strategy are determined; and finally, responding to a data summarizing and editing operation trigger instruction of a user, finishing data summarizing and editing of the target data object based on the target data summarizing and editing strategy, namely, efficiently summarizing the data according to the configuration of the user on the data summarizing object, namely the data summarizing strategy. The technical scheme of the embodiment of the invention solves the problems of low data summarization and editing efficiency and low visualization of the multi-level report in the filling and reporting system, can flexibly configure the data editing rules in the data editing process, and improves the data summarization efficiency and the visualization degree in the data editing process.

Drawings

Fig. 1 is a flowchart of a data editing method provided in an embodiment of the present invention;

fig. 2 is a schematic diagram of a preset custom data summarizing and editing interface according to an embodiment of the present invention;

fig. 3 is a flowchart of a data editing method according to an embodiment of the present invention;

fig. 4 is a flowchart of a data editing method provided in an embodiment of the present invention;

FIG. 5 is a schematic diagram of a configuration of a summary area in a fixed row summary according to an embodiment of the present invention;

FIG. 6 is a schematic diagram illustrating a source configuration of summarized data in a static row summary according to an embodiment of the present invention;

FIG. 7 is a diagram illustrating a summary result of a row in accordance with an embodiment of the present invention;

FIG. 8 is a schematic diagram of a non-fixed row summary configuration provided by an embodiment of the present invention;

fig. 9 is a schematic diagram of a non-fixed row summary result provided in the embodiment of the present invention;

FIG. 10 is a schematic illustration of a deployed configuration in a mechanical column according to an embodiment of the present invention;

FIG. 11 is a schematic diagram illustrating the result of a deployed configuration in mechanical columns according to an embodiment of the present invention;

fig. 12 is a flowchart of a data editing apparatus according to an embodiment of the present invention;

fig. 13 is a schematic structural diagram of a computer device according to an embodiment of the present invention.

Detailed Description

The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.

It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures. Meanwhile, in the description of the present invention, the terms "first", "second", and the like are used only for distinguishing the description, and are not construed as indicating or implying relative importance. According to the technical scheme, the data acquisition, storage, use, processing and the like meet relevant regulations of national laws and regulations.

Fig. 1 is a schematic flow chart of a data editing method according to an embodiment of the present invention, which is applicable to a service organization of a multi-level organization structure, where service data is summarized and edited from bottom to top. The method can be executed by a data editing apparatus, which can be implemented by software and/or hardware, integrated in a computer device with application development function, or configured in a dataform application to be used as a plug-in.

As shown in fig. 1, the data editing method includes the steps of:

and S110, responding to a data summarizing and editing starting instruction of a user in the current data form to be summarized, and displaying a preset custom data summarizing and editing interface.

At present, in a multi-level organization structure, when business data are aggregated, business personnel define indexes and rules which need to be filled in business index items and aggregated calculation through a business system, and due to the large number of the business data index items, the process of data aggregation is large in workload and long in time consumption.

In order to further improve the efficiency of data summarization and editing, in this embodiment, a data summarization and editing function is directly added to an editable data table, so that the data summarization operation is configured more efficiently and flexibly, and the data summarization and editing operation is completed.

The current data form to be summarized may be a data form which is preset with data items to be filled and is to be subjected to data filling and summarization. The current data form to be summarized may be a blank data form to be summarized, or a data form with completed partial data filling and summarization.

Each data item in the current data form to be summarized can be a result obtained after adjustment and screening in a predefined data index item library to be filled. There is no need to redefine the data items in each data form to be summarized.

Furthermore, a data summarization user-defined function control can be set on the display interface of the data form to be summarized so as to start entering a data summarization editing function. When a user clicks the data summarizing custom function control, the data editing device can obtain a data summarizing editing starting instruction, and therefore a preset custom data summarizing editing interface is displayed. The preset custom data summarization editing interface is provided with configurable items which need to be configured in a custom manner in the data summarization editing process, such as data source objects to be summarized, areas to be summarized, summarization modes, summarization directions, special formats or formula requirements and the like.

For example, the preset custom data summarization editing interface may be an interface as shown in fig. 2, and when a user clicks a "summarization definition" function control on a current to-be-summarized data form display interface, the preset custom data summarization editing interface may be triggered to enter.

And S120, determining a target data summarizing object and a target data summarizing and editing strategy according to the input of the user in the preset custom data summarizing and editing interface.

Specifically, the input of the user in the preset custom data summarizing and editing interface is the configuration result of each configurable item in the interface.

The target data summarizing object comprises a data area to be summarized and a data source object to be summarized. The area to be summarized represents an area of the current data form to be summarized, which needs to be filled with data. For example, in a data form to be summarized, each column corresponds to a data item to be filled in, and each row represents a data source object. When the summary of the data indicates that a plurality of subordinate business mechanisms summarize business data to a superior business mechanism, in the current data sheet to be summarized, each line corresponds to one subordinate business mechanism to indicate the source of the data, and each column corresponds to one data item to be filled.

When a user clicks a summary area display triggering instruction in the summary area configuration item, a current data form to be summarized can be displayed according to the summary area triggering instruction of the user and is used as a superior data form to be summarized; and then, determining the data area to be summarized in the upper data table to be summarized according to the selection of the user in the data area in the upper data table to be summarized. If it is determined that the data area to be summarized corresponds to determining which data items are to be read in which data of one or more subordinate business establishments.

In an optional mode, if a plurality of to-be-summarized upper level data tables exist, when a user triggers a summarizing area display instruction, names of the plurality of to-be-summarized upper level data tables can be displayed as selectable to-be-summarized upper level data tables, and the user can select one of the to-be-summarized upper level data tables as a target to-be-summarized data table and further select a target to-be-summarized data area from the target to-be-summarized data table.

Further, the data source object to be summarized corresponds to the configuration result of the configuration item "summarized access source" in fig. 2. When a user sends a summarized data source setting instruction, a currently filled subordinate data table to be summarized, which is associated with a higher-level data table to be summarized, can be displayed according to the summarized data source setting instruction of the user; and then, determining a target data source object to be summarized according to the selection operation of the user on the lower-level data table to be summarized. In an alternative embodiment, the selection may also be performed by performing domain selection in the data table of each data source object, determining a certain row/column or multiple rows and multiple columns to be spliced to the summary area, and selecting from the data.

And determining the target data summarizing and editing strategy, wherein the target data summarizing and editing strategy comprises configuration results of configurable items such as a data summarizing mode, a summarizing direction, a cell summarizing strategy and the like. The target data summarizing mode, the target data summarizing direction and the target cell summarizing strategy can be determined according to the setting operation of the user on the data summarizing mode, the summarizing direction and the cell summarizing strategy.

The data summarization mode is fixed cell summarization, non-fixed cell summarization or data item amplification summarization according to a data source. Fixed cell summarization refers to a data table of data source objects where one cell corresponds to one data item content. In the non-fixed cell aggregation manner, it is explained that one data item may correspond to a plurality of cells in the data table of the data source object, and the determination is specifically performed according to the data amount of the data item in the data table of the corresponding data source object. The data source data item amplification summarization is that in a data area to be summarized, one data item cannot be directly read, and the data item is obtained by calculation and amplification according to preset rules in each data source object. And generating corresponding amplification data by the data of different data source objects to be summarized, wherein the data items obtained by calculation and amplification usually do not need to calculate the summarized data.

The summarizing direction is a column direction or a row direction, and because the compiling directions of some data tables are different, each row may correspond to one data item, or each column may correspond to one data item, and the data summarizing direction is determined according to a specific summarizing area form.

The target cell summarizing strategy means that some cells exist, the data of the corresponding data items do not need to be summarized and calculated, and only the original values in the data of the data source objects to be summarized are directly reserved. In a normal case, if the target (special) cell aggregation mode is not set, the default aggregation mode is the aggregation SUM function. Specifically, the cells not subjected to the summary calculation may be determined according to the cell marking operation of the user.

In addition, as shown in fig. 2, the interface is further provided with a mechanism cell configuration item, the splicing position of the data source object is located, and only the mechanism cells in the summary row/column are selected, and when the selection is expanded according to the row, the mechanisms are spliced below the selected mechanism cell, and when the selection is expanded, the mechanisms are spliced on the right side of the selected mechanism cell. Another way of configuring the data source is also understood.

And S130, responding to a data summarizing and editing operation triggering instruction of a user, and finishing data summarizing and editing of the target data object based on the target data summarizing and editing strategy.

When the user presets a custom data summarization editing interface to complete the strategy configuration of data summarization, a 'confirm' button can be clicked to trigger the execution of data summarization editing operation, and corresponding data in the data source object to be summarized are filled in and summarized into the data area to be summarized corresponding to the current data form to be summarized.

Specifically, the virtual coordinates of each target data source object to be summarized in the current data form to be summarized may be determined according to the identifier of the target data source object. And then, filling the data of the data source object to be summarized of each target into the target cells of the row or column corresponding to the virtual coordinates, and finishing the summarizing work of the data. Usually, in an upper level data table to be summarized, each data source object to be summarized is correspondingly provided with a virtual coordinate (virtual row or virtual column coordinate) to ensure the accuracy of data when a row or column is inserted again.

According to the technical scheme of the embodiment, a preset user-defined data summarization editing interface is displayed by responding to a data summarization editing starting instruction of a user in a current data form to be summarized, and an interactive interface for editing a data summarization strategy is provided for the user; then, according to the input of a user in a preset custom data summarizing and editing interface, a target data summarizing object and a target data summarizing and editing strategy are determined; and finally, responding to a data summarizing and editing operation trigger instruction of a user, finishing data summarizing and editing of the target data object based on the target data summarizing and editing strategy, namely, efficiently summarizing the data according to the configuration of the user on the data summarizing object, namely the data summarizing strategy. The technical scheme of the embodiment of the invention solves the problems of low data summarization and editing efficiency and low visualization of the multi-level report in the filling and reporting system, can flexibly configure the data editing rules in the data editing process, and improves the data summarization efficiency and the visualization degree in the data editing process.

Fig. 3 is a flowchart of another data editing method provided in an embodiment of the present invention, where the present embodiment and the data editing method in the foregoing embodiments belong to the same inventive concept, and further describe a process of performing verification in a data summarization editing process. The method can be executed by a data editing device, which can be realized by software and/or hardware, and is integrated in a computer device with application development function.

As shown in fig. 3, the data editing method includes the steps of:

and S210, responding to a data summarizing and editing starting instruction of the user in the current data form to be summarized, and displaying a preset custom data summarizing and editing interface.

And S220, determining a target data summarizing object and a target data summarizing and editing strategy according to the input of the user in the preset custom data summarizing and editing interface.

And S230, responding to a data summarizing and editing operation triggering instruction of a user, and analyzing a first start-stop coordinate of a two-dimensional array corresponding to a to-be-summarized data area of the current to-be-summarized data form and a second start-stop coordinate of data of the target to-be-summarized data source object in the to-be-summarized data area.

S240, checking whether the first start-stop coordinate is matched with the second start-stop coordinate.

The data field coordinates in the step are checked to determine whether the data read from the data table of the data source object to be summarized is matched with the position to be filled in the data area to be summarized, so that the situation that rows or columns are disordered to cause summarization errors is avoided.

And S250, when the verification is passed, finishing the data summarization and editing of the target data object based on the target data summarization and editing strategy.

And when the verification is passed, the data read from the target data source object to be summarized is matched with the target data field to be summarized, so that further data reading and writing can be performed, and the data summarizing and editing process is completed.

In particular, during the data summarization and editing process, the target cell summarization policy in the target data summarization and editing policy is also analyzed to determine whether the data item content corresponding to the cell does not need to be summarized. When the data items which do not participate in data summarization calculation are set in the target cell summarization strategy through analysis, when the data of the target data source object to be summarized are filled into the cells corresponding to the data items, the data in the cells corresponding to the data items are not overlapped and summarized.

In addition, after data is summarized and edited, due to insertion of row or column contents, formula errors may occur in some cells, and therefore, the summary formula of the cells in the data area to be summarized needs to be updated according to changes in the index information of each cell in the data area to be summarized in the current data form to be summarized, so as to ensure accuracy of formula calculation results.

According to the technical scheme of the embodiment, a preset user-defined data summarization editing interface is displayed by responding to a data summarization editing starting instruction of a user in a current data form to be summarized, and an interactive interface for editing a data summarization strategy is provided for the user; then, according to the input of a user in a preset user-defined data summarizing and editing interface, a target data summarizing object and a target data summarizing and editing strategy are determined; finally, in response to a data summarizing and editing operation triggering instruction of a user, data summarizing and editing of the target data object are completed based on the target data summarizing and editing strategy, in the process of data summarizing and editing, verification between coordinates of data to be summarized in a data table of the data source object and coordinates of a target summarizing data area in the data area to be summarized is increased, and identification of special cells is achieved, accuracy of data filling and summarizing is further guaranteed, and therefore data summarizing objects, namely the data summarizing strategy, can be configured according to the user, and data summarizing is achieved efficiently. The technical scheme of the embodiment of the invention solves the problems of low data summarization and editing efficiency and low visualization of the multi-level report in the filling and reporting system, can flexibly configure the data editing rules in the data editing process, and improves the data summarization efficiency and the visualization degree in the data editing process.

Fig. 4 is a flowchart of another data editing method provided in an embodiment of the present invention, where the present embodiment and the data editing method in the foregoing embodiments belong to the same inventive concept, and further describe a data summarization process of different data summarization scenarios, where the data summarization scenario includes conventional data summarization, pre-summarization, and re-summarization. The method can be executed by a data editing device, which can be realized by software and/or hardware, and is integrated in a computer device with application development function.

As shown in fig. 4, the data editing method includes the steps of:

and S310, responding to a data summarizing and editing starting instruction of the current data form to be summarized by the user, and displaying a preset custom data summarizing and editing interface.

And S320, determining a target data summarizing object and a target data summarizing and editing strategy according to the input of the user in the preset custom data summarizing and editing interface.

And S330, responding to a data summarization editing operation trigger instruction of a user, and judging whether the current data summarization operation is a pre-summarization operation or a re-summarization operation.

The pre-summarization may be a test of summarizing and fusing the contents of the data tables of the defined data area to be summarized and the data source object to be summarized, so as to determine whether the definitions of the tables and the configuration of the data summarization policy are logically incorrect. A pre-summary function control can be arranged in an interactive interface between a user and the data table, so that the user can trigger the operation.

The re-summarizing operation means that in one data summarizing and editing, data information in a data table of a data source object to be summarized may not be completely filled, so that summarized data is incomplete or summarized incorrectly, and the data summarizing operation needs to be performed again after the data table of the data source object to be summarized is completely filled. During the waiting period, the user can repeatedly trigger the data summarization operation to inquire the data table filling condition of the data source object to be summarized, which can be understood as the refreshing process of the data.

And S340, when the current data summarization editing operation is a pre-summarization operation, filling a preset constant value in each cell of the to-be-summarized data area of the current to-be-summarized data form.

During the pre-summary operation, the real data to be filled and summarized are not read, and are usually replaced by a preset constant value, such as a value 1, so that it is convenient to observe whether the summary logic is correct in the pre-summary result.

It can be understood that in the scenario of pre-summarized data summarization, the pre-summarized end summarization process may start a formal data summarization operation.

And S350, when the current data summarization editing operation is a re-summarization operation, deleting the data of the row cells or the column cells filled in the previous data summarization editing operation before the current data summarization editing operation is executed.

Specifically, whether the current data summarization is the first data summarization or the re-summarization operation is performed again can be determined by determining whether corresponding data are filled in the data area to be summarized.

When the current data summarization operation is determined to be the re-summarization operation, the previous summarized data reserved in the data area to be summarized is deleted, so that the intersection or confusion of the two summarized data is avoided.

And S360, finishing the data summarization and editing of the target data object based on the target data summarization and editing strategy.

In this step, data summarization may be performed according to the data summarization editing process described in the foregoing embodiment.

Particularly, when the data summarization mode in the target data summarization editing strategy is data statistics summarization according to the data source object, that is, when some data item contents are expanded according to the data source object, the specific data summarization editing further includes the following steps: firstly, according to the amplification cell corresponding to the target statistical expansion data item in the current data sheet to be summarized, correspondingly increasing the amplification cell in the data sheet of each target data summarizing object. Then, respectively calculating data results corresponding to the corresponding target statistic expansion data items in the data of each target data summarizing object according to a summarizing statistic formula of the amplification unit; and finally, filling the data result into the corresponding amplification cell and reporting the data result into a data area to be summarized.

According to the technical scheme of the embodiment, a preset user-defined data summarization editing interface is displayed by responding to a data summarization editing starting instruction of a user in a current data form to be summarized, and an interactive interface for editing a data summarization strategy is provided for the user; then, according to the input of a user in a preset user-defined data summarizing and editing interface, a target data summarizing object and a target data summarizing and editing strategy are determined; and finally, responding to a data summarization editing operation trigger instruction of a user, finishing data summarization editing of the target data object based on the target data summarization editing strategy, and performing pre-summarization and repeated summarization judgment in the data summarization editing process so as to perform corresponding data processing and further ensure the accuracy of the data summarization operation. The technical scheme of the embodiment of the invention solves the problems of low data summarization and editing efficiency and low visualization of the multi-level report in the filling and reporting system, can flexibly configure the data editing rules in the data editing process, and improves the data summarization efficiency and the visualization degree in the data editing process.

Now, a specific data summarization example in a scenario in which a lower row summarizes data from an upper row in a banking system is described.

Example one: when performing the fixed row summarization of the data table, as shown in fig. 5, a to-be-summarized data area (summarized area in the corresponding figure) is first selected from the to-be-summarized data table in the upper row. Then, the summarized value source data is selected from the data table of the data source object to be summarized as shown in fig. 6. The aggregation mode is that all the fixed cells of the items are aggregated, and the aggregation direction is selected to be aggregated. It will be appreciated that the arrangement of the table according to this here must select the item rows, otherwise the items will not be joined and, since the item cells are not in data format, the names of the items will not be aggregated but presented directly as they are. The results are shown in FIG. 7.

Example two: when the data table is not fixed row summary, the configuration process of the data summary editing is as shown in fig. 8. First, a region of data to be summarized is selected from the upper table shown in the left diagram of fig. 8, and then summarized value source data is selected from the lower table shown in the right diagram of fig. 8. The summarizing mode is unfixed cell summarizing. One or more lines of value sources of the same label are randomly selected in the lower-level row report, and the value sources are synchronously summarized into the report to be summarized in the upper-level row when the lower-level row increases the rows (still with the same attribute). The summary direction is selected as row summary. The summary results can refer to the summary effect shown in fig. 9.

Example three: during the expansion according to the organization column, an expansion area can be selected from the table interface to be summarized shown in fig. 10, and the summarizing mode is selected as follows: and expanding according to mechanisms (data source objects), splicing all filling mechanisms according to the mechanism cells, simultaneously splicing all gathering areas, and generating corresponding mechanism data gathering directions according to different mechanisms to select row gathering. The final deployment result in the mechanical column can be seen in the schematic diagram shown in fig. 11.

Fig. 12 is a schematic structural diagram of a data editing apparatus according to an embodiment of the present invention, which is applicable to a service organization with a multi-level organization structure, and the service data is summarized and edited from bottom to top. The device can be realized by software and/or hardware, is integrated in a computer device with an application development function, or can be directly used as a plug-in for applications such as online document editing and the like.

As shown in fig. 12, the data editing apparatus includes: the data summarization edit function initiation module 410, the data summarization edit policy determination module 420, and the data summarization edit module 430.

The data summarizing and editing function starting module 410 is used for responding to a data summarizing and editing starting instruction of a user in a current data form and displaying a preset custom data summarizing and editing interface; the data summarizing and editing strategy determining module 420 is configured to determine a target data summarizing object and a target data summarizing and editing strategy according to the input of the user in the preset custom data summarizing and editing interface; and the data summarizing and editing module 430 is configured to respond to a data summarizing and editing operation trigger instruction of a user, and complete data summarizing and editing of the target data object based on the target data summarizing and editing strategy.

According to the technical scheme of the embodiment, a preset user-defined data summarization editing interface is displayed by responding to a data summarization editing starting instruction of a user in a current data form to be summarized, and an interactive interface for editing a data summarization strategy is provided for the user; then, according to the input of a user in a preset user-defined data summarizing and editing interface, a target data summarizing object and a target data summarizing and editing strategy are determined; and finally, responding to a data summarizing and editing operation triggering instruction of a user, finishing data summarizing and editing of the target data object based on the target data summarizing and editing strategy, namely efficiently summarizing the data according to the configuration of the user on the data summarizing object, namely the data summarizing strategy. The technical scheme of the embodiment of the invention solves the problems of low summarizing and editing efficiency and low visualization of multi-level report data in the filling and reporting system, can flexibly configure the data editing rule in the data editing process, and improves the summarizing efficiency and the visualization degree in the data editing process.

Optionally, the data summarization editing policy determining module 420 is specifically configured to:

according to a summarizing area triggering instruction of a user, displaying the current data form to be summarized as a superior data form to be summarized;

and determining a data area to be summarized in the superior data table to be summarized according to the selection of the user in the data area of the superior data table to be summarized.

displaying the currently filled lower-level data table to be summarized associated with the upper-level data table to be summarized according to a trigger instruction of a summarized data source of the user;

and determining a target data source object to be summarized according to the selection operation of the user on the subordinate data table to be summarized.

determining a target data summarizing mode, a target data summarizing direction and a target cell summarizing strategy according to the setting operation of the user on the data summarizing mode, the summarizing direction and the cell summarizing strategy;

the data summarization mode is fixed cell summarization, non-fixed cell summarization or mechanism data item amplification summarization, and the summarization direction is a column direction or a row direction.

and determining the cells which do not perform the summary calculation according to the cell marking operation of the user.

Optionally, the data summarization editing module 430 is specifically configured to:

determining a virtual coordinate of each target data source object to be summarized in the current data form to be summarized according to the identifier of each target data source object to be summarized in the target data summarizing object;

and filling the data of the target data source object to be summarized into the target cells of the row or the column corresponding to the virtual coordinate.

Optionally, the data summarization editing module 430 may be further configured to:

analyzing a first start-stop coordinate of a two-dimensional array corresponding to a to-be-summarized data area of the current to-be-summarized data form and a second start-stop coordinate of the data of the target to-be-summarized data source object in the to-be-summarized data area;

and checking whether the first start-stop coordinate and the second start-stop coordinate are matched.

analyzing a target cell summarizing strategy in the target data summarizing and editing strategy;

when the target cell summarizing strategy is analyzed to be provided with a data item which does not participate in data summarizing calculation, when the data of the target data source object to be summarized is filled into the cell corresponding to the data item, the data in the cell corresponding to the data item are not overlapped and summarized.

and updating the summarizing formula of the cells in the summarizing formula in the to-be-summarized data area according to the index information change of the cells in the to-be-summarized data area of the current to-be-summarized data form.

when the data summarization editing operation instruction is triggered, judging whether the current data summarization operation is a pre-summarization operation;

and when the current data summarization editing operation is a pre-summarization operation, filling preset constant values in each cell of the to-be-summarized data area of the current to-be-summarized data form.

when the data summarization editing operation instruction is triggered, judging whether the current data summarization operation is a re-summarization operation or not;

and when the current data summarization editing operation is a re-summarization operation, deleting the data of the row cells or the column cells filled in the previous data summarization editing operation before the current data summarization editing operation is executed.

correspondingly adding the amplification cells in the data table of each target data summarization object according to the amplification cells corresponding to the target statistic expansion data items in the current data table to be summarized;

calculating data results corresponding to the corresponding target statistic expansion data items in the data of the target data summarizing objects according to the summarizing statistic formula of the amplification units;

and filling the data results into corresponding amplification unit cells.

The data editing device provided by the embodiment of the invention can execute the data editing method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.

It should be noted that, the units and modules included in the apparatus are merely divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the embodiment of the invention.

Fig. 13 is a schematic structural diagram of a computer device according to an embodiment of the present invention. FIG. 13 illustrates a block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention. The computer device 12 shown in fig. 13 is only an example and should not bring any limitation to the function and the scope of use of the embodiments of the present invention. The computer device 12 may be any terminal device with computing capability, such as a terminal device of an intelligent controller, a server, a mobile phone, and the like.

As shown in FIG. 13, computer device 12 is in the form of a general purpose computing device. The components of computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that couples various system components including the system memory 28 and the processing unit 16.

Bus 18 represents one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor, or a local bus using any of a variety of bus architectures. By way of example, such architectures include, but are not limited to, industry Standard Architecture (ISA) bus, micro-channel architecture (MAC) bus, enhanced ISA bus, video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus.

Computer device 12 typically includes a variety of computer system readable media. Such media can be any available media that is accessible by computer device 12 and includes both volatile and nonvolatile media, removable and non-removable media.

The system memory 28 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM) 30 and/or cache memory 32. The computer device 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 13, commonly referred to as a "hard drive"). Although not shown in FIG. 13, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. System memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.

A program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in system memory 28, such program modules 42 including but not limited to an operating system, one or more application programs, other program modules, and program data, each of which or some combination of which may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of embodiments of the invention as described.

Computer device 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), with one or more devices that enable a user to interact with computer device 12, and/or with any devices (e.g., network card, modem, etc.) that enable computer device 12 to communicate with one or more other computing devices. Such communication may be through an input/output (I/O) interface 22. Also, computer device 12 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) through network adapter 20. As shown, network adapter 20 communicates with the other modules of computer device 12 via bus 18. It should be appreciated that although not shown in FIG. 13, other hardware and/or software modules may be used in conjunction with computer device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.

The processing unit 16 executes various functional applications and data processing by executing programs stored in the system memory 28, for example, implementing a data editing method provided by the present embodiment, the method including:

The present embodiment also provides a computer-readable storage medium on which a computer program is stored, the program, when executed by a processor, implementing a data editing method as provided in any embodiment of the present invention, including:

Computer storage media for embodiments of the invention may employ any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. The computer-readable storage medium may be, for example but not limited to: an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.

Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).

It will be understood by those skilled in the art that the modules or steps of the invention described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of computing devices, and optionally they may be implemented by program code executable by a computing device, such that it may be stored in a memory device and executed by a computing device, or it may be separately fabricated into various integrated circuit modules, or it may be fabricated by fabricating a plurality of modules or steps thereof into a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.

Embodiments of the present invention further provide a computer program product, including a computer program, where the computer program, when executed by a processor, implements the data editing method provided in any embodiment of the present application.

Computer program product in implementing the computer program code for carrying out operations of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).

It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in some detail by the above embodiments, the invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the invention, and the scope of the invention is determined by the scope of the appended claims.

Claims

1. A method of editing data, comprising:

2. The method of claim 1, wherein determining a target data summarization object according to the user input in the preset custom data summarization editing interface comprises:

3. The method of claim 2, wherein determining a target data summarization object according to the user input at the predefined custom data summarization edit interface further comprises:

4. The method according to claim 1, wherein the determining a target data summarization editing strategy according to the user input in the preset custom data summarization editing interface comprises:

determining a target data summarization mode, a target data summarization direction and a target cell summarization strategy according to the setting operation of the user on the data summarization mode, the summarization direction and the cell summarization strategy;

5. The method according to claim 4, wherein the determining a target cell rollup policy according to the setting operation of the user cell rollup policy comprises:

6. The method according to any one of claims 1-5, wherein the completing the data summary editing of the target data object based on the target data summary editing policy comprises:

and filling data of each target data source object to be summarized into target cells of rows or columns corresponding to the virtual coordinates.

7. The method according to claim 6, wherein before filling the data of each data source object to be summarized into the target cell of the row or column corresponding to the virtual coordinate, the method comprises:

8. The method according to claim 6, wherein when the data of each data source object to be summarized is filled into the target cell of the row or column corresponding to the virtual coordinate, the method comprises:

9. The method of claim 6, further comprising:

10. The method of claim 1, further comprising:

and when the current data summarization editing operation is a pre-summarization operation, filling a preset constant value in each cell of the to-be-summarized data area of the current to-be-summarized data form.

11. The method of claim 1, further comprising:

12. The method of claim 6, wherein when the data summarization in the target data summarization editing policy is data statistics summarization by data source object, the completing the data summarization editing of the target data object based on the target data summarization editing policy further comprises:

and filling the data results into corresponding amplification unit cells.

13. A data editing apparatus, characterized in that the apparatus comprises:

the data summarizing and editing function starting module is used for responding to a data summarizing and editing starting instruction of a user in a current data form and displaying a preset custom data summarizing and editing interface;

14. A computer device, characterized in that the computer device comprises:

one or more processors;

a memory for storing one or more programs;

the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the data editing method of any one of claims 1-12.

15. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out a data editing method as claimed in any one of claims 1 to 12.

16. A computer program product comprising a computer program which, when executed by a processor, implements a data editing method as claimed in any one of claims 1 to 12.