A method and apparatus for setting expressions in electronic forms.

Abstract

This invention discloses a method and apparatus for setting expressions in electronic forms, belonging to the field of data statistics technology. The method includes: dragging and dropping components and metadata information in a form design interface to construct an electronic form; displaying a calculation formula setting interface in response to a first operation by the user in the form design interface; responding to a second operation by the user to set the data source; and generating a target calculation formula in response to a third operation by the user to set each formula element in the calculation formula editing box. The target calculation formula type includes at least one of the following: audit formula, calculation formula, summary formula, and filtering formula. Through the expression setting scheme in electronic forms disclosed in this invention, matching logic can be introduced into the expression syntax, allowing several rows or columns to share a single expression. This avoids repetitive expression writing and improves work efficiency during the process of summarizing micro-data into macro-data.

Description

Technical Field

[0001] This invention relates to the field of data statistics technology, and in particular to a method and apparatus for setting expressions in electronic forms. Background Technology

[0002] Reports, as carriers of statistical data, are used in various statistical transactions. The descriptive information of the report's data area is determined by the main and secondary columns, while the period information in the table header describes the data period. Data collection tables, summary tables, and thematic tables are three common types of reports in statistical operations. Data collection tables primarily store micro-level data, while summary and thematic tables primarily store macro-level data formed by summarizing micro-level data. Data collection tables can be stored in databases in two ways: as reports and as datasets. However, how to quickly and accurately generate summary or thematic reports from the micro-level data in data collection tables remains a challenge in current statistical operations.

[0003] Therefore, there is an urgent need for those skilled in the art to provide a quick solution for summarizing micro-data from collection tables into macro-data to improve work efficiency. Summary of the Invention

[0004] The purpose of this invention is to provide a method and apparatus for setting expressions in electronic forms, which can solve the problem of the cumbersome process of converting micro data into macro data in the prior art.

[0005] To solve the above-mentioned technical problems, the present invention provides the following technical solution:

[0006] This invention provides a method for setting expressions in electronic forms, wherein the method includes:

[0007] Drag and drop components and metadata information from the form design interface to construct an electronic form; wherein the electronic form includes at least one of the following: a collection form, a summary form, and a topic form;

[0008] In response to the user's first operation in the table design interface, the calculation formula setting interface is displayed;

[0009] A second action is performed in response to the user setting the data source;

[0010] In response to a user's third setting operation on each formula element in the formula editing box, a target calculation formula is generated, wherein the formula elements include: cell coordinate information, operator symbols, and form styles; the target calculation formula type includes at least one of: audit formula, calculation formula, summary formula, and filter formula.

[0011] Optionally, the step of displaying the calculation formula setting interface in response to a user's first operation in the form design interface includes:

[0012] In response to the user's first touch operation on the first control in the table design interface, the calculation formula tab is displayed;

[0013] The system receives a second touch operation from the user on the second control in the calculation formula tab and displays the calculation formula settings interface.

[0014] Optionally, the step of responding to the second operation of setting the data source by the user includes:

[0015] Receives user selection of preset data types in the calculation formula settings interface;

[0016] Use the data of the user-selected data type as the data source.

[0017] Optionally, the step of generating the target calculation formula in response to a user's third setting operation on each formula element in the calculation formula edit box includes:

[0018] Receives a third touch operation from the user to select the target cell on the source table page;

[0019] In response to the third touch operation, the target cell information is added to the calculation formula editing box;

[0020] Receive the user's fourth touch operation on the target operator;

[0021] In response to the fourth touch operation, the target operator is added to the calculation formula editing box;

[0022] In response to the user's selection of the target electronic form under the report tab, the middle area of ​​the calculation formula editing box switches to the source table tab and displays the form style of the selected target electronic form;

[0023] In response to the user's selection of a target cell in the source table, the coordinate information and table number information corresponding to the target cell are written into the calculation formula edit box;

[0024] After receiving the instruction that the calculation formula has been written, the target calculation formula is generated.

[0025] Optionally, after the step of writing the coordinate information and table number information corresponding to the target cell into the calculation formula edit box, the method further includes:

[0026] After selecting the target cell in the target spreadsheet, click on the wildcard configuration in the current interface and enter the row range in the row range field;

[0027] and / or

[0028] After selecting the target cell in the target spreadsheet, click on the wildcard configuration in the current interface and enter the column range in the column range field.

[0029] This application embodiment also provides a device for setting expressions in electronic forms, wherein the device includes:

[0030] The module is used to drag and drop components and metadata information in the form design interface to build electronic forms; wherein, the electronic forms include at least one of the following: a collection form, a summary form, and a topic form;

[0031] The display module is used to display the calculation formula setting interface in response to the user's first operation in the table design interface;

[0032] The response module is used to respond to a second operation where the user sets the data source;

[0033] The generation module is used to generate a target calculation formula in response to the user's third setting operation on each formula element in the calculation formula edit box. The formula elements include: cell coordinate information, operator symbols, and form styles. The target calculation formula type includes at least one of: audit formula, calculation formula, summary formula, and filter formula.

[0034] Optionally, the display module includes:

[0035] The first submodule is used to display the calculation formula tab in response to the user's first touch operation on the first control in the table design interface;

[0036] The second submodule is used to receive the user's second touch operation on the second control in the calculation formula tab and display the calculation formula settings interface.

[0037] Optionally, the response module includes:

[0038] The third submodule is used to receive the user's selection of the preset data type in the calculation formula setting interface;

[0039] The fourth submodule is used to use data of the data type selected by the user as the data source.

[0040] Optionally, the generation module includes:

[0041] The fifth submodule is used to receive the third touch operation of the user clicking on the target cell of the source table page;

[0042] The sixth submodule is used to add the target cell information to the calculation formula editing box in response to the third touch operation;

[0043] The seventh submodule is used to receive the user's fourth touch operation on the target operator;

[0044] The eighth submodule is used to add the target operator to the calculation formula editing box in response to the fourth touch operation;

[0045] The ninth submodule is used to respond to the user's selection of the target electronic form under the report tab, switch to the source table tab in the middle area of ​​the calculation formula editing box, and display the form style of the selected target electronic form;

[0046] The tenth submodule is used to respond to the user's selection operation of the target cell in the source table and write the coordinate information and table number information corresponding to the target cell into the calculation formula edit box;

[0047] The eleventh submodule is used to generate the target calculation formula after receiving the instruction that the calculation formula has been written.

[0048] Optionally, the generation module further includes:

[0049] The twelfth sub-module is used to select the target cell in the target electronic form after the tenth sub-module writes the coordinate information and table number information corresponding to the target cell into the calculation formula editing box, click the wildcard configuration in the current interface, and enter the row range in the row interval;

[0050] and / or

[0051] The thirteenth submodule is used to select the target cell in the target spreadsheet, click the wildcard configuration on the current interface, and enter the column range in the column range field.

[0052] This invention provides an electronic device, which includes a processor, a memory, and a program or instructions stored in the memory and executable on the processor. When the program or instructions are executed by the processor, they implement the steps of setting the expression in any of the above-described electronic forms.

[0053] This invention provides a readable storage medium storing a program or instructions, which, when executed by a processor, implement the steps of setting the expression in any of the above-described electronic forms.

[0054] The electronic form expression setting scheme provided in this embodiment of the invention involves dragging and dropping components and metadata information in the form design interface to construct an electronic form; responding to the user's first operation in the form design interface, displaying the calculation formula setting interface; responding to the user's second operation of setting the data source; and responding to the user's third operation of setting each formula element in the calculation formula edit box, generating the target calculation formula. Through the electronic form expression setting method disclosed in this embodiment of the invention, matching logic can be introduced into the expression syntax, allowing several rows or columns to share a single expression. Therefore, in the process of summarizing micro-data into macro-data, repetitive expression writing can be avoided, thereby improving work efficiency. Attached Figure Description

[0055] Figure 1 This is a flowchart illustrating the steps of setting an expression in an electronic form according to an embodiment of this application;

[0056] Figure 2 This is a schematic diagram illustrating the form design interface of an embodiment of this application;

[0057] Figure 3 This is a schematic diagram of the first expression design surface representing an embodiment of this application;

[0058] Figure 4 This is a schematic diagram of the second expression design interface representing an embodiment of this application;

[0059] Figure 5 This is a schematic diagram of the third expression design interface representing an embodiment of this application;

[0060] Figure 6 This is a schematic diagram of the fourth expression design interface representing an embodiment of this application;

[0061] Figure 7 This is a structural block diagram illustrating an expression setting device in an electronic form according to an embodiment of this application. Detailed Implementation

[0062] To make the technical problems, technical solutions and advantages of the present invention clearer, a detailed description will be given below in conjunction with the accompanying drawings and specific embodiments.

[0063] The following description, in conjunction with the accompanying drawings, details the expression setting scheme for the electronic form provided in this application through specific embodiments and application scenarios.

[0064] As attached Figure 1 As shown, the method for setting expressions in an electronic form according to an embodiment of this application includes the following steps:

[0065] Step 101: Drag and drop components and metadata information from the form design interface to build the electronic form.

[0066] The electronic forms include at least one of the following: a data collection form, a summary form, or a topic form.

[0067] Data collection tables, summary tables, and thematic tables are three common types of electronic reports, or electronic forms, used in statistical work. Data collection tables primarily store micro-level data, while summary and thematic tables store macro-level data derived from the aggregation of micro-level data. For each type of table, each cell will have unique coordinate information, which will be used as input in expressions and as the basis for matching asterisks (*).

[0068] Data collection tables are stored in databases in two ways: reports and datasets. However, quickly and accurately generating summary or thematic reports from the micro-level data in collection tables remains a challenge in current statistical operations. To achieve a fast and convenient process from micro to macro, reduce unnecessary and cumbersome intermediate processing, and improve work efficiency, our company has developed a bracket expression syntax compatible with both statistical reports and datasets. This expression syntax includes four types of formulas: audit formulas, calculation formulas, summary formulas, and filtering formulas. Audit formulas are mainly used in collection tables to ensure the rationality of the data entered; calculation formulas are mainly used in summary tables, thematic tables, and other comprehensive reports to extract data; summary formulas are also mainly used in summary tables and thematic tables to summarize and calculate the extracted data; filtering formulas are mainly applied to tables, main columns, and guest columns to set filtering conditions for calculations or summaries. This expression syntax also includes a set of custom display rules for the previous period, the same period last year, and the period before that, allowing for quick retrieval of data for the corresponding period. To avoid repetitive expression writing and improve work efficiency, an asterisk (*) matching logic is introduced into the expression syntax, allowing several rows or columns to share a single expression.

[0069] The design interface is as follows: Figure 2 As shown, Figure 2 As shown, the form design interface includes information indicating the basic attributes of an electronic form, such as table headers, footers, and two-dimensional fixed-length tables. In addition, the interface includes settings for main columns, side columns, summary formulas, calculation formulas, and cell units. The left side of the interface also includes setting options for indicators, grouping, and attributes. When an indicator option is selected, metadata information at various levels is displayed in the left side of the interface. By moving the components and metadata information displayed in the left side to the right side, the main columns, side columns, and calculation formulas of the electronic form can be designed.

[0070] It should be noted that, Figure 2This is just one specific example; the actual layout of the form design interface is not limited to this. The specific components and metadata information displayed in the form design interface will be adaptively adjusted according to the type of electronic form to be drawn and the field.

[0071] Step 102: In response to the user's first operation in the table design interface, display the calculation formula setting interface.

[0072] In one alternative embodiment, the method of displaying the calculation formula setting interface in response to a user's first operation in the table design interface may include the following sub-steps:

[0073] First, in response to the user's first touch operation on the first control in the table design interface, the calculation formula tab is displayed;

[0074] The first control is used to trigger the design process of the calculation formula. The first control can be set to the text form of the "Calculation Formula" control, or it can be just an icon used to indicate the calculation formula, such as a triangle, a circle, or a pentagram.

[0075] Secondly, it receives the user's second touch operation on the second control in the calculation formula tab and displays the calculation formula settings interface.

[0076] The formula tab can include controls for indicating whether to add, delete, or modify a formula. The second control is specifically for indicating whether to add a new formula.

[0077] The second touch operation may include, but is not limited to, single-click, double-click or long-press operations. In this embodiment, the specific operation indicated by the second touch operation is not limited.

[0078] Figure 3 This is a schematic diagram of the interface design for the first expression, which can also be called the calculation formula setting interface. Figure 3 This example uses the calculation formula to be designed as a summary formula. The summary formula settings interface supports users selecting either report or dataset formats as the data source. It should be noted that if you need to set the calculation formula, you can... Figure 2 Select the "Calculate Formula" button in the interface shown to trigger the display of the calculation formula settings interface.

[0079] Step 103: A second action in response to the user setting the data source.

[0080] In one optional embodiment, the second operation in response to the user setting the data source is as follows: First, the user selects a preset data type in the calculation formula setting interface; second, the data under the user-selected data type is used as the data source.

[0081] like Figure 3 As shown in the diagram, the first expression design interface includes two data type options: "Report" and "Dataset." Users can select the corresponding option to determine whether to choose data from a report or a data table as the data source. Figure 3 As shown in the example, when the user selects to choose data from a report as the data source, multiple levels of reports are provided for the user to choose from in the left area of ​​the first expression design interface diagram. The user can select a specific report from the left area, and the name of the selected report is displayed in the table in the right area.

[0082] like Figure 3 As shown, the first expression design interface also includes options related to expression editing, such as range settings, wildcard form, operators, and functions. After selecting the data source for generating the electronic form, users can flexibly select and set these options to complete the editing of the calculation formula.

[0083] Figure 3 The interface for designing the expression when the user selects "Report" as the data type is shown. In actual implementation, the user can also select "Dataset" as the data type, and the corresponding second expression design interface is as follows. Figure 4 As shown in the diagram, the left-hand area of ​​the second expression design interface provides multiple levels of datasets for users to select. Users can select specific datasets from the left-hand area, and the names of the selected datasets are displayed in a table in the right-hand area.

[0084] like Figure 4 As shown, the second expression design interface also includes options related to editing operators and functions. After selecting the data source for generating the electronic form, users can flexibly select and set these options to complete the editing of the calculation formula.

[0085] Step 104: In response to the user's third setting operation on each formula element in the calculation formula edit box, generate the target calculation formula.

[0086] The formula elements include: cell coordinate information, operators, and form styles; the target calculation formula type includes at least one of the following: audit formula, calculation formula, summary formula, and filter formula.

[0087] like Figure 5 As shown in the third expression design interface, in an optional embodiment, the method for generating the target calculation formula in response to the user's third setting operation on each formula element in the calculation formula edit box includes the following sub-steps:

[0088] Sub-step 1: Receive the user's third touch operation on the target cell of the source table page;

[0089] The source tab is the expression design interface, and the target cell is the cell in the table on the right side of the expression design interface.

[0090] Sub-step two: In response to the third touch operation, add the target cell information to the calculation formula edit box;

[0091] Sub-step 3: Receive the user's fourth touch operation on the target operator;

[0092] The target operator can be "=", and the fourth touch operation can be a click operation.

[0093] Sub-step four: In response to the fourth touch operation, add the target operator to the calculation formula edit box;

[0094] Sub-step 5: In response to the user's selection of the target electronic form under the report tab, switch to the source table tab in the middle area of ​​the calculation formula editing box and display the form style of the selected target electronic form;

[0095] Sub-step six: In response to the user's selection of the target cell in the source table, write the coordinate information and table number information corresponding to the target cell into the calculation formula edit box;

[0096] Sub-step seven: After receiving the instruction that the calculation formula has been written, generate the target calculation formula.

[0097] The instruction to complete the calculation formula can be generated by clicking the "OK" control in the third expression design interface.

[0098] in, Figure 5 The operational formulas in this context are the calculation formulas.

[0099] like Figure 6 As shown in the fourth expression design interface, if you need to configure row or column wildcards, select a cell in the current table, click on the wildcard configuration on the page, and enter the row or column range in the row or column range field. Continue until the expression is complete, then click "OK" to finish writing the expression, i.e., the calculation formula.

[0100] In an optional embodiment, after writing the coordinate information and table number information corresponding to the target cell into the calculation formula edit box, the method further includes:

[0101] After selecting the target cell in the target spreadsheet, click on the wildcard configuration in the current interface and enter the row range in the row range field;

[0102] and / or

[0103] After selecting the target cell in the target spreadsheet, click on the wildcard configuration in the current interface and enter the column range in the column range field.

[0104] The method for setting expressions in electronic forms provided in this application involves dragging and dropping components and metadata information in the form design interface to construct an electronic form; responding to a first operation by the user in the form design interface, displaying a calculation formula setting interface; responding to a second operation by the user to set the data source; and responding to a third operation by the user to set each formula element in the calculation formula edit box, generating a target calculation formula. By introducing matching logic into the expression syntax of the electronic form disclosed in this invention, several rows or columns can share a single expression. Therefore, in the process of summarizing micro-data into macro-data, repetitive expression writing can be avoided, thereby improving work efficiency.

[0105] Figure 7 The structural block diagram shows a device for setting expressions in an electronic form according to an embodiment of this application.

[0106] The device for setting expressions in electronic forms provided in this application includes the following functional modules:

[0107] The construction module 701 is used to drag and drop components and metadata information in the form design interface to construct an electronic form; wherein, the electronic form includes at least one of the following: a collection form, a summary form, and a topic form;

[0108] Display module 702 is used to display the calculation formula setting interface in response to the user's first operation in the table design interface;

[0109] Response module 703 is used to respond to a second operation where the user sets the data source;

[0110] The generation module 704 is used to generate a target calculation formula in response to the user's third setting operation on each formula element in the calculation formula edit box. The formula elements include: cell coordinate information, operator symbols, and form styles. The target calculation formula type includes at least one of: audit formula, calculation formula, summary formula, and filter formula.

[0111] Optionally, the display module includes:

[0112] The first submodule is used to display the calculation formula tab in response to the user's first touch operation on the first control in the table design interface;

[0113] The second submodule is used to receive the user's second touch operation on the second control in the calculation formula tab and display the calculation formula settings interface.

[0114] Optionally, the response module includes:

[0115] The third submodule is used to receive the user's selection of the preset data type in the calculation formula setting interface;

[0116] The fourth submodule is used to use data of the data type selected by the user as the data source.

[0117] Optionally, the generation module includes:

[0118] The fifth submodule is used to receive the third touch operation of the user clicking on the target cell of the source table page;

[0119] The sixth submodule is used to add the target cell information to the calculation formula editing box in response to the third touch operation;

[0120] The seventh submodule is used to receive the user's fourth touch operation on the target operator;

[0121] The eighth submodule is used to add the target operator to the calculation formula editing box in response to the fourth touch operation;

[0122] The ninth submodule is used to respond to the user's selection of the target electronic form under the report tab, switch to the source table tab in the middle area of ​​the calculation formula editing box, and display the form style of the selected target electronic form;

[0123] The tenth submodule is used to respond to the user's selection operation of the target cell in the source table and write the coordinate information and table number information corresponding to the target cell into the calculation formula edit box;

[0124] The eleventh submodule is used to generate the target calculation formula after receiving the instruction that the calculation formula has been written.

[0125] Optionally, the generation module further includes:

[0126] The twelfth sub-module is used to select the target cell in the target electronic form after the tenth sub-module writes the coordinate information and table number information corresponding to the target cell into the calculation formula editing box, click the wildcard configuration in the current interface, and enter the row range in the row interval;

[0127] and / or

[0128] The thirteenth submodule is used to select the target cell in the target spreadsheet, click the wildcard configuration on the current interface, and enter the column range in the column range field.

[0129] The electronic form expression setting device provided in this application embodiment constructs an electronic form by dragging and dropping components and metadata information in the form design interface; in response to a user's first operation in the form design interface, it displays a calculation formula setting interface; in response to a user's second operation of setting the data source; and in response to a user's third operation of setting each formula element in the calculation formula edit box, it generates the target calculation formula. Through the electronic form expression setting method disclosed in this embodiment, matching logic can be introduced into the expression syntax, allowing several rows or columns to share a single expression. Therefore, in the process of summarizing micro-data into macro-data, repetitive expression writing can be avoided, thereby improving work efficiency.

[0130] In the embodiments of this application Figure 7 The device for setting expressions in the electronic form shown can be a device, or it can be a component, integrated circuit, or chip in a server. (This is from an embodiment of the present application.) Figure 7 The device for setting expressions in the electronic form shown can be a device with an operating system. This operating system can be Android, iOS, or other possible operating systems; this application does not specifically limit the specific operating system used.

[0131] The embodiments provided in this application Figure 7 The device for setting expressions in the electronic form shown can achieve... Figure 1 The various processes implemented in the method implementation examples will not be described again here to avoid repetition.

[0132] Optionally, embodiments of this application also provide an electronic device, including a processor, a memory, and a program or instructions stored in the memory and executable on the processor. When the program or instructions are executed by the processor, they implement the various processes of the above-described embodiment of the method for setting expressions in electronic forms and achieve the same technical effect. To avoid repetition, they will not be described again here.

[0133] It should be noted that the electronic device in this application embodiment includes the server described above.

[0134] This application also provides a readable storage medium storing a program or instructions. When the program or instructions are executed by a processor, they implement the various processes of the above-described method for setting expressions in electronic forms and achieve the same technical effect. To avoid repetition, these will not be described again here.

[0135] The processor is the processor in the electronic device described in the above embodiments. The readable storage medium includes computer-readable storage media, such as computer read-only memory (ROM), random access memory (RAM), magnetic disk, or optical disk.

[0136] This application embodiment also provides a chip, which includes a processor and a communication interface. The communication interface and the processor are coupled. The processor is used to run programs or instructions to implement the various processes of the above-described embodiment of the method for setting expressions in electronic forms, and can achieve the same technical effect. To avoid repetition, it will not be described again here.

[0137] It should be understood that the chip mentioned in the embodiments of this application may also be referred to as a system-on-a-chip, system chip, chip system, or system-on-a-chip, etc.

[0138] It should be noted that, in this document, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Unless otherwise specified, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes that element.

[0139] The above description represents the preferred embodiments of the present invention. It should be noted that those skilled in the art can make various improvements and modifications without departing from the principles of the present invention, and these improvements and modifications should also be considered within the scope of protection of the present invention.

Claims

1. A method of setting an expression in an electronic form, characterized by, The method comprises: Dragging components and metadata information in a table design interface to build an electronic form; wherein the electronic form comprises at least one of a collection table, a summary table, and a special topic table; In response to a first operation of a user in the table design interface, a calculation formula setting interface is displayed; In response to a second operation of the user setting a data source; In response to a third setting operation of the user on each formula element in the calculation formula editing box, a target calculation formula is generated, wherein the formula element comprises cell coordinate information, an operator symbol, and a form style; and the target calculation formula type comprises at least one of an audit formula, an operation formula, a summary formula, and a filtering formula; The main column, the object column, and the calculation formula of the electronic form are designed by moving the components and the metadata information displayed in the left region to the right region; The step of generating the target calculation formula in response to the third setting operation of the user on each formula element in the calculation formula editing box comprises: A bracket expression syntax compatible with statistical reports and data sets is adopted, wherein the bracket expression syntax independently defines a set of display rules for quickly obtaining data of a corresponding period, and a star matching logic is introduced in the expression syntax to realize that several rows or several columns share one expression; and the display rules comprise at least one of a previous period, a same period last year, and a previous previous period; In response to a selection operation of the user on a target cell in a source table, coordinate information and table number information corresponding to the target cell are written into the calculation formula editing box; After the step of writing the coordinate information and the table number information corresponding to the target cell into the calculation formula editing box, the method further comprises: After selecting a target cell in a target electronic form, a wildcard configuration in the current interface is clicked, and a row range is input in a row interval, and / or After selecting a target cell in a target electronic form, a wildcard configuration in the current interface is clicked, and a column range is input in a column interval.

2. The method of claim 1, wherein, The step of displaying the calculation formula setting interface in response to the first operation of the user in the table design interface comprises: In response to a first touch operation of the user on a first control in the table design interface, a calculation formula tab is displayed; A second touch operation of the user on a second control in the calculation formula tab is received, and the calculation formula setting interface is displayed.

3. The method of claim 1, wherein, The step of responding to the second operation of the user setting the data source comprises: A selection operation of the user on a preset data type in the calculation formula setting interface is received; Data under the data type selected by the user is taken as the data source.

4. The method of claim 1, wherein, The step of generating the target calculation formula in response to the third setting operation of the user on each formula element in the calculation formula editing box comprises: A third touch operation of the user on a target cell under a source table tab is received; In response to the third touch operation, the target cell information is added to the calculation formula editing box; A fourth touch operation of the user on a target operator symbol is received; In response to the fourth touch operation, the target operator symbol is added to the calculation formula editing box; In response to a selection operation of a target electronic form under a report tab by a user, a source table tab is switched to the middle region of the calculation formula editing box, and a form style of the selected target electronic form is displayed; In response to a selection operation of a target cell in the source table by the user, the coordinate information and the table number information corresponding to the target cell are written into the calculation formula editing box; After receiving a calculation formula writing completion instruction, a target calculation formula is generated.

5. An apparatus for setting an expression in an electronic form, characterized by comprising: The device comprises: A construction module configured to drag components and metadata information in a table style design interface to construct an electronic form, wherein the electronic form comprises at least one of a collection table, a summary table, and a special topic table; A display module configured to display a calculation formula setting interface in response to a first operation of a user in the table style design interface; A response module configured to respond to a second operation of the user to set a data source; A generation module configured to generate a target calculation formula in response to a third setting operation of the user on each formula element in a calculation formula editing box, wherein the formula element comprises cell coordinate information, an operator symbol, and a form style, and the target calculation formula type comprises at least one of an audit formula, an operation formula, a summary formula, and a filtering formula; The generation module is configured to adopt a bracket expression syntax compatible with statistical reports and data sets, the bracket expression syntax autonomously defines a set of display rules to quickly obtain data of a corresponding period, and a hash symbol matching logic is introduced in the expression syntax to realize that several rows or several columns share one expression, and the display rules comprise at least one of a previous period, a same period last year, and a previous previous period; The main column, the dependent column, and the calculation formula of the electronic form are designed by moving the components and the metadata information displayed in the left region to the right region; The generation module comprises: A tenth sub-module configured to write coordinate information and table number information corresponding to a target cell in a source table into a calculation formula editing box in response to a selection operation of the target cell by the user, A twelfth sub-module configured to select a target cell in a target electronic form, click a wildcard configuration in a current interface, and input a row range in a row interval and / or a column range in a column interval after the tenth sub-module writes the coordinate information and the table number information corresponding to the target cell into the calculation formula editing box, A thirteenth sub-module configured to select a target cell in a target electronic form, click a wildcard configuration in a current interface, and input a column range in a column interval.

6. The apparatus of claim 5, wherein, The display module comprises: A first sub-module configured to display a calculation formula tab in response to a first touch operation of a first control in the table style design interface by the user; A second sub-module configured to receive a second touch operation of a second control in the calculation formula tab by the user to display a calculation formula setting interface.

7. The apparatus of claim 5, wherein, The response module comprises: A third sub-module configured to receive a selection operation of a preset data type in the calculation formula setting interface by the user; A fourth sub-module configured to take data of the data type selected by the user as a data source.

8. The apparatus of claim 5, wherein, The generation module comprises: The fifth sub-module is configured to receive a third touch operation of a user on a target cell under the source table tab; The sixth sub-module is configured to add the target cell information to the calculation formula editing box in response to the third touch operation; The seventh sub-module is configured to receive a fourth touch operation of a user on a target operator symbol; The eighth sub-module is configured to add the target operator symbol to the calculation formula editing box in response to the fourth touch operation; The ninth sub-module is configured to switch to the source table tab in the middle area of the calculation formula editing box and display the sheet style of the selected target electronic sheet in response to a selection operation of a user on the target electronic sheet under the report tab; The tenth sub-module is configured to write the coordinate information and the table number information corresponding to the target cell into the calculation formula editing box in response to a selection operation of a user on the target cell in the source table; The eleventh sub-module is configured to generate a target calculation formula after receiving a calculation formula completion instruction.

Images