CN116341503A - Electronic form configuration method, device, equipment and storage medium - Google Patents

Abstract

The application discloses a configuration method, device, equipment and storage medium of an electronic form, which are used for solving the problem that the configuration difficulty of the electronic form is high because cells corresponding to all function options are difficult to determine in the process of configuring the electronic form at present. The method comprises the following steps: receiving input operation of target function options in the electronic form; the target function option is used for configuring the electronic form; the input operation includes pre-associating field data with a target function option; determining a target cell corresponding to the target function option in the electronic table in response to the input operation of the user; and displaying the target cell in a preset display mode. The technical scheme is convenient for a user to quickly and accurately acquire the cell acted by each function option in the electronic form, and reduces the understanding difficulty of each function option for configuring the electronic form, thereby being beneficial to reducing the difficulty of configuring the electronic form.

Description

Electronic form configuration method, device, equipment and storage medium

technical field

The present application relates to the field of computer technology, and in particular to a configuration method, device, equipment and storage medium of an electronic form.

Background technique

Electronic forms can help users create various complex table documents, perform cumbersome data calculations, and perform various complex statistical operations on the input data and display them as tables with excellent visibility, which greatly enhances the visibility of data sex.

However, currently, in the process of configuring the electronic form, it is difficult for the user to determine the cells that each configuration function acts on, which makes the configuration of the electronic form more difficult, and it is even more difficult to produce a form document that meets the user's expectations.

Contents of the invention

The purpose of the embodiment of the present application is to provide a configuration method, device, device, and storage medium for an electronic form to solve the problem that it is difficult to determine the cells corresponding to each function option in the process of configuring the electronic form, which leads to the configuration of the electronic form Difficult question.

In order to solve the above technical problems, the embodiment of the present application is implemented as follows:

On the one hand, an embodiment of the present application provides a method for configuring an electronic form, including:

receiving an input operation to a target function option in an electronic form; the target function option is used to configure the electronic form; the input operation includes pre-association of field data with the target function option;

In response to the input operation, determining a target cell corresponding to the target function option in the electronic form;

The target cell is displayed in a preset display manner.

On the other hand, an embodiment of the present application provides an electronic form configuration device, including:

The first receiving module is used to receive an input operation on the target function option in the electronic form; the target function option is used to configure the electronic form; the input operation includes pre-association of field data with the target function option;

A determining module, configured to determine a target cell corresponding to the target function option in the electronic form in response to the input operation;

A display module, configured to display the target cell in a preset display manner.

In yet another aspect, an embodiment of the present application provides an electronic form configuration device, including a processor; and a memory arranged to store computer-executable instructions, the computer-executable instructions configured to be executed by the processor, the The computer-executable instructions are executed by the processor to implement the above-mentioned electronic form configuration method.

In yet another aspect, an embodiment of the present application provides a storage medium for storing computer-executable instructions, and when the computer-executable instructions are executed by a processor, the above-mentioned method for configuring an electronic form is implemented.

By adopting the technical solution of the embodiment of the present application, by receiving the input operation of the target function option in the electronic form, the target function option is used to configure the electronic form, and the input operation may include pre-association of the field data with the target function option, so as to respond to the input Operation, determine the target cell corresponding to the target function option in the spreadsheet, and then display the target cell in a preset display mode. It can be seen that in the process of configuring the electronic form, this technical solution can display the cells corresponding to each function option based on the operation of the pre-associated function options and field data, so that the user can quickly and accurately know the effect of each function option in the electronic form. The cells reduce the difficulty of understanding the various function options used to configure the electronic form, thereby helping to reduce the difficulty of configuring the electronic form.

Description of drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments described in this application. Those skilled in the art can also obtain other drawings based on these drawings without any creative effort.

Fig. 1 is a schematic flowchart of a method for configuring an electronic form according to an embodiment of the present application;

FIG. 2 is a schematic interface diagram of a pivot table according to an embodiment of the present application;

Fig. 3 is a schematic interface diagram of a pivot table according to another embodiment of the present application;

FIG. 4 is a schematic interface diagram of a pivot table according to another embodiment of the present application;

Fig. 5 is a schematic interface diagram of a pivot table according to another embodiment of the present application;

FIG. 6 is a schematic structural diagram of an electronic form configuration device according to an embodiment of the present application;

Fig. 7 is a schematic structural diagram of an electronic form configuration device according to an embodiment of the present application.

Detailed ways

Embodiments of the present application provide a configuration method, device, device, and storage medium for electronic forms to solve the problem that it is difficult to determine the cells corresponding to each function option in the process of configuring electronic forms at present, which makes the configuration of electronic forms difficult. question.

In order to enable those skilled in the art to better understand the technical solutions in the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described The embodiments are only some of the embodiments of the present application, but not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the scope of protection of this application.

Fig. 1 is a schematic flowchart of a method for configuring an electronic form according to an embodiment of the present application. As shown in Fig. 1, the method may include:

S102. Receive an input operation on a target function option in the electronic form.

In this embodiment, the target function option is used to configure the electronic form, and the target function option may be a function option input by clicking, dragging, and the like. Optionally, the target function option may be a field placement area for configuring the spreadsheet, and the field placement area may include placement areas for row data, column data, value data, filter fields, and other field data. Target feature option can be a feature option to configure the spreadsheet for row sorting or column sorting, can be a feature option to configure the spreadsheet to show or hide category subtotals, can be a feature option to configure the spreadsheet to show or hide duplicates labels options, etc. It should be understood that in addition to the target function options, the electronic form also includes other function options, such as function options for configuring font color, font size, etc., which is not limited in this embodiment of the present application.

In this embodiment, the input operation includes pre-associating field data with target function options. Optionally, the pre-association of the field data with the target function option may be an operation of moving any field in the field data to any field placement area, or it may be an operation of triggering the target function option in a selection manner. Among them, there is a difference between pre-association and association. For example, for the trigger operation of the target function option in the selection mode, the pre-association can be the hovering operation of the user's mouse on the target function option, and the association can be the click operation of the target function option; The operation of moving a field to any field drop area, the pre-association can be the operation that the user drags any field to any field drop area and hovering over it, and the association can be after dragging any field to any field drop area Just let go of the operation.

S104. In response to the input operation, determine a target cell corresponding to the target function option in the electronic form.

S106, displaying the target cell in a preset display manner.

In one embodiment, the preset display mode includes at least one of the following: highlighting, thickening the outline, and coloring the outline. Optionally, the target cell can be displayed in one or more display methods of highlighting, thickening the outline, and coloring the outline. Through this enhanced display of the target cell, it is convenient for the user to intuitively see the Which cells of are the target cells. Wherein, the target cell can be displayed with any color highlight, outline coloring, etc., and the target cell can be displayed with any specification of outline bold.

In one embodiment, after the user hovers over the target function option, if the user leaves the target function option, the enhanced display of the target cell will not disappear immediately. In this way, not only is it beneficial for the user to clarify the cell to which each function option of the electronic form acts, but also it is not necessary for the user to constantly operate the device (such as a mouse) to hover over the target function option, which frees the user's hands. Optionally, the enhanced display of the target cell may disappear after a preset period of time, or disappear after the user clicks on another area of the spreadsheet.

By adopting the technical solution of the embodiment of the present application, by receiving the input operation of the target function option in the electronic form, the target function option is used to configure the electronic form, and the input operation may include pre-association of the field data with the target function option, so as to respond to the input Operation, determine the target cell corresponding to the target function option in the spreadsheet, and then display the target cell in a preset display mode. It can be seen that in the process of configuring the electronic form, this technical solution can display the cells corresponding to each function option based on the operation of the pre-associated function options and field data, so that the user can quickly and accurately know the effect of each function option in the electronic form. The cells reduce the difficulty of understanding the various function options used to configure the electronic form, thereby helping to reduce the difficulty of configuring the electronic form.

The electronic form configuration method provided by the embodiment of the present application is applicable to various electronic forms. The following will take the electronic form as a pivot table as an example to describe the electronic form configuration method provided by the embodiment of the present application in detail. Among them, the pivot table is essentially a two-dimensional table, which is different from the simple one-dimensional table data. The two-dimensional table involves a tree structure, and the threshold for understanding is relatively high. An easy-to-understand electronic form configuration method is more needed.

In one embodiment, the spreadsheet is a pivot table. The input operation of receiving the target function option in the electronic form (ie S102) can be performed as the following step A1:

Step A1, receiving an input operation on the target function option in the configuration column on the pivot table.

Wherein, the target function option in the configuration column may include a field placement area for configuring the pivot table, and the field placement area includes at least one of the following field data placement areas: row data, column data, value data, and filter fields.

Optionally, the target function options in the configuration bar may also include a function option of displaying or hiding duplicate item labels, a function option of displaying or hiding category subtotals, and the like.

For ease of understanding, the target function options in the configuration column will be described below through the interface diagrams of the pivot table shown in Figure 2 and Figure 3 . It should be noted that Fig. 2 and Fig. 3 are only an example of a pivot table for illustrating this embodiment, and other menu bars and other function options in the pivot table are not reflected.

As shown in Figure 2, in the pivot table 200, the right side is provided with a configuration bar 210, the field configuration of the configuration bar 210 includes a field name selection area and a pivot table area, and the pivot table area includes a filter field placement area (that is, in Figure 2 filter) 211 , row data placement area (ie row in FIG. 2 ) 212 , column data placement area (ie column in FIG. 2 ) 213 and value data placement area (ie value in FIG. 2 ) 214 . Users can pre-associate field data with target function options by dragging any field name to any field drop area and hovering over it. Since each field placement area corresponds to the cells of the pivot table, through the pre-association operation, the target cell corresponding to the field placement area in the pivot table can be determined, thereby displaying the target cell in a preset display mode.

As shown in FIG. 3 , in the pivot table 300 , a configuration bar 210 is set on the right side, and the display configuration of the configuration bar 210 includes a function option 311 for displaying or hiding category subtotals and a function option 312 for displaying or hiding duplicate item labels. Among them, the function option 311 of displaying or hiding category subtotals includes displaying or hiding category subtotals, displaying or hiding row totals, and displaying or hiding column totals. You can choose to display category subtotals, row totals, column totals, etc. by clearing the check boxes in front of each function option to choose to hide category subtotals, hide row totals, and hide column totals, etc. In the pivot table shown in Figure 3, if the user chooses to display the subtotal by category, the data in the row of "Total of Province X" and the data of the row of "Total of Province Y" will be displayed, as shown in Figure 3; if If the user chooses to hide the category subtotals, the data in the row of "Total of Province X" and the row of "Total of Province Y" will be hidden. This effect is not shown in Figure 3.

Among them, the function option 312 of displaying or hiding the duplicate item label includes displaying or hiding the row field and displaying or hiding the column field, and the user can choose to display the row field, To display column fields, etc., you can choose to hide row fields, hide column fields, etc. by clearing the check boxes in front of each function option. In the pivot table shown in Figure 3, if the user chooses to display the row field, the previous cell of the row where "city b" and "city c" are located will display "province X", "city e" and "city f". "Y province" will be displayed in the previous cell of the row where ", this effect is not shown in Figure 3; if the user chooses to hide the row field, the previous cell of the row where "b city" and "c city" is emptied, and the previous cell of the row where "city e" and "city f" are located is emptied, as shown in Figure 3.

It should be noted that the way the user chooses to display or hide includes but is not limited to the way of checking or clearing the check box. In actual applications, the user can choose to show or hide in a corresponding way according to the specific display page conditions. This embodiment of the present application does not limit it.

In one embodiment, by receiving an operation of associating field data with the field placement area, and in response to the operation, according to the cell corresponding to the field placement area in the pivot table, an association between the field data and the cell is established. Mapping relations.

Optionally, the operation of associating the field data with the field drop area may be performed as follows: drag any field to any field drop area and then let go. Since each field placement area corresponds to the cells of the pivot table, through this association operation, a mapping relationship between field data and the cells corresponding to the field placement area can be established.

Using the pivot table shown in Figure 2, if the operation of associating "sales price" with the value data placement area 214 is received, in response to this operation, the cell corresponding to the value data placement area 214 in the data pivot table can be , to establish a mapping relationship between the “sales price” and the cells corresponding to the value data placement area 214 .

In one embodiment, based on the mapping relationship between the field data and the cells, the cells in the pivot table can be filled with field data.

Following the pivot table shown in Figure 2, if the mapping relationship between the "sales price" and the cells corresponding to the value data placement area 214 has been established, then, based on the mapping relationship, each "sales price" can be used to fill the pivot data The cell corresponding to the value data placement area 214 in the table, so as to accurately fill the "sales price" in the original table into the pivot table.

In one embodiment, receiving the input operation of the target function option in the configuration column on the pivot table (that is, step A1) can be performed as the following step A11 or step A12:

Step A11, receiving an operation of moving any field in the field data to any field placement area.

Optionally, as shown in FIG. 2 , the user can select or search for any field in the field name selection area in the field configuration of the configuration bar 210 , so as to move any field to the field placement area desired by the user. Wherein, the method of moving the field to the field placement area may be: dragging the field and hovering in the field placement area. It should be understood that the pivot table is often used for data summarization and statistics. Therefore, the user generally configures the pivot table purposefully, that is, for each field, the user has a desired field placement area.

Step A12, receiving a trigger operation of selecting a target function option in the configuration column.

Wherein, the target function option may include a function option of displaying or hiding duplicate item labels, and/or a function option of displaying or hiding category subtotals. Optionally, the trigger operation of selecting the target function option may be an operation of hovering the user's mouse over the target function option. Using the pivot table shown in FIG. 3 , when the user hovers over the function option 312 for displaying or hiding duplicate item labels, and/or the function option 311 for displaying or hiding category subtotals, it is considered that the user has received the In the trigger operation of the target function option in the selection mode, at this time, it can be regarded as the check box before the corresponding function option is checked by the user.

In this embodiment, in response to the input operation, determining the target cell corresponding to the target function option in the spreadsheet (ie S104) can be performed as the following step B1 or step B2:

Step B1, in response to the operation of moving any field in the field data to any field placement area, according to the field placement area, determine the target cell corresponding to the field placement area in the spreadsheet.

Wherein, each field placement area corresponds to a cell in the spreadsheet.

Step B2, in response to the trigger operation of selecting the target function option in the configuration column, according to the selected cell and the triggered target function option, determine the target cell corresponding to the target function option in the spreadsheet.

Optionally, based on the pivot table shown in FIG. 3 , assuming that the trigger operation on the target function option in the selection mode is performed as: hovering the user's mouse over the target function option, then step B2 may be performed as: responding When the user hovers over the function option of displaying or hiding duplicate item labels in the configuration bar, according to the cell selected by the user and the function option of displaying or hiding duplicate item labels, determine whether to display or hide duplicate items in the spreadsheet The target cell corresponding to the function option of the label; or, in response to the operation of the user's mouse hovering on the function option of displaying or hiding the subtotal of the category in the configuration bar, according to the cell selected by the user and the value of the subtotal of the category to be displayed or hidden Option to determine the target cell in the spreadsheet that corresponds to the option to show or hide category subtotals. For the detailed process of step B2, reference may be made to the following steps E1-E3, which will not be repeated here.

In this embodiment, through different input operations performed on different target function options, corresponding methods for determining the target cell are respectively provided, which facilitates accurate determination of the target cell.

In one embodiment, the spreadsheet is a pivot table. The input operation of receiving the target function option in the electronic form (ie S102) can be performed as the following step C1:

Step C1, receiving an input operation on the menu bar associated with the target function option in the pivot table.

Wherein, at least one of the following target function options may be included in the menu bar: a function option of sorting, a function option of displaying or hiding category subtotals, and a function option of displaying or hiding duplicate item labels. Optionally, the menu bar associated with the target function option can be popped up by right-clicking the mouse, can be popped up by triggering a preset shortcut key, and can also be fixed at any position on the pivot table interface.

For ease of understanding, the target function options in the menu bar will be described below through the schematic interface diagram of the pivot table shown in FIG. 4 . In the pivot table shown in FIG. 4 , the menu bar can be popped up by right-clicking the mouse, or by triggering a preset shortcut key. It should be noted that FIG. 4 is only an example of a pivot table for illustrating this embodiment, and other menu bars and other functional options in the pivot table are not reflected.

As shown in (a) of FIG. 4 , in the pivot table 400, the user selects any cell and clicks the right mouse button, or triggers a preset shortcut key, and the menu bar 410 can be called out, and the menu bar 410 includes sorting A function option 411, a function option 412 for displaying or hiding category subtotals, and a function option 413 for displaying or hiding duplicate item labels.

In one embodiment, receiving an input operation on the menu bar associated with the target function option in the pivot table (that is, step C1 ) may be performed as: receiving a trigger operation of selecting the target function option in the menu bar.

Optionally, the triggering operation of selecting the target function option may be performed as an operation of hovering the user's mouse over the target function option.

In this embodiment, in response to the input operation, determining the target cell corresponding to the target function option in the spreadsheet (that is, S104) may be performed as follows: in response to selecting in the menu bar that triggers the pop-up on the selected cell The method triggers an operation on the target function option, and determines the target cell corresponding to the target function option in the spreadsheet according to the selected cell and the selected target function option.

Optionally, based on the pivot table shown in FIG. 4 , assuming that the trigger operation on the target function option in the selection mode is performed as: hovering the user's mouse over the target function option, then, in response to the selected cell Above, for triggering the trigger operation of the target function option in the selection mode in the pop-up menu bar, according to the selected cell and the selected target function option, determine the target cell corresponding to the target function option in the spreadsheet, which can be executed as follows Step D1 or Step D2 or Step D3:

Step D1, in response to the operation of hovering the user's mouse over the sorting function option in the menu bar that triggers the pop-up on the selected cell, determine the corresponding sorting function option in the spreadsheet according to the selected cell and the sorting function option the target cell.

Using the pivot table shown in (a) of Figure 4, when the selected cell "294" is received, the user hovers over the sort function option of the menu bar that triggers the pop-up, as shown in Figure 4 As shown in (b), the next-level menu bar 420 pops up, and the next-level menu bar 420 includes "N factory" in ascending order of value, "N factory" in descending order of value, "b city" in ascending order of value, "b city" " in descending order by value. In this embodiment, the target cell corresponding to the sorting function option in the spreadsheet can be determined by receiving the user's mouse hovering operation on each function option in the lower-level menu bar 420 and combining the selected cell.

Step D2, in response to the operation on the selected cell, hovering the user's mouse over the function option of triggering the display or hiding of the category subtotal in the pop-up menu bar, according to the selected cell and the display or hide of the category subtotal Option to determine the target cell in the spreadsheet that corresponds to the option to show or hide category subtotals.

Step D3, in response to the operation on the selected cell, hovering the user's mouse over the function option that triggers the display or hiding of the duplicate item label in the pop-up menu bar, according to the selected cell and the display or hide of the duplicate item label A feature that determines the target cell in the spreadsheet for the feature that shows or hides duplicate labels.

For the detailed process of step D1, step D2 or step D3, reference may be made to the following steps E1-E3, which will not be repeated here. In this embodiment, through different input operations performed on different target function options, corresponding methods for determining the target cell are respectively provided, which facilitates accurate determination of the target cell.

In one embodiment, the spreadsheet is a pivot table, and the pivot table is a mapping table constructed based on the row data of the first dimension and the column data of the second dimension. The pivot information of the cells in the pivot table includes: element information and level information on the first dimension, and element information and level information on the second dimension.

Optionally, the row data of the first dimension and the column data of the second dimension respectively correspond to a balanced multi-fork tree, and the two balanced multi-fork trees are mapped to each other to form a pivot table. For each balanced multi-fork tree, each node of the balanced multi-fork tree contains the level information and element information of the node. Therefore, each cell in the pivot table corresponds to element information and level information of two balanced multi-trees.

Using the pivot table shown in (a) of Figure 4, it can be seen that the pivot table is based on the row data of the first dimension "sales province-sales city" and the column data of the second dimension "manufacturer-M factory and N factory" Build gets. Suppose the level of city b is m, the level of province X is m-1, the level of factory N is n, and the level of manufacturer is n-1, then the pivot information of the selected cell "294" includes: The element information "b city" and the level information "m" on the dimension, and the element information "N factory" and the level information "n" on the second dimension. It should be noted that the specific levels 0, 1, 2, etc. can be set according to the needs of specific scenarios, which is not limited in the embodiment of the present application, so in this embodiment, the specific levels 0, 1, 2 are not used Wait for an example.

In one embodiment, in response to the input operation, determining the target cell corresponding to the target function option in the spreadsheet (ie S104) may be performed as the following steps E1-E3:

Step E1, determine the target element information corresponding to the target function option.

Using the pivot table shown in (b) of Figure 4, it can be seen that the pivot table is based on the row data of the first dimension "sales province-sales city" and the column data of the second dimension "manufacturer-M factory and N factory" Build gets. Suppose the level of city b is m, the level of province X is m-1, the level of factory N is n, and the level of manufacturers is n-1. If the target function option is "N factory" in the lower menu bar 420 in ascending order of value, then it can be determined that the target element information corresponding to the target function option is "N factory".

Step E2, determining the target level information of the selected cell in the dimension corresponding to the target element information.

Following the example in step E1, it can be determined that the target level information of the selected cell in the dimension corresponding to the target element information is "n".

Step E3, in the pivot table, determine the target cell corresponding to the target function option. Wherein, the target cell is on a dimension corresponding to the target element information, its corresponding element information matches the target element information, and its level information matches the target level information.

Following the example in step E2, the target cell is on the dimension corresponding to the target element information, and its corresponding element information matches the target element information, that is, the cell whose element information on the second dimension is "N Factory" , whose level information matches the target level information, that is, the cell whose level information on the second dimension is "n", as shown in Figure 5, exemplarily displays the target unit in a bold outline cells, including cell "154", cell "294", cell "275", cell "791", cell "448", and cell "662".

In summary, certain embodiments of the subject matter have been described. Other implementations are within the scope of the following claims. In some cases, the actions recited in the claims can be performed in a different order and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In certain implementations, multitasking and parallel processing may be advantageous.

The above is the electronic form configuration method provided by the embodiment of the present application. Based on the same idea, the embodiment of the present application also provides an electronic form configuration device.

Fig. 6 is a schematic structural diagram of an electronic form configuration device according to an embodiment of the present application. As shown in Fig. 6, the electronic form configuration device may include:

The first receiving module 610 is used to receive an input operation to the target function option in the electronic form; the target function option is used to configure the electronic form; the input operation includes pre-association of field data with the target function option;

A determining module 620, configured to determine the target cell corresponding to the target function option in the spreadsheet in response to the input operation;

The display module 630 is configured to display the target cell in a preset display manner.

In one embodiment, the spreadsheet is a pivot table; the first receiving module 610 includes:

The first receiving unit is used to receive an input operation on the target function option in the configuration bar on the pivot table;

Wherein, the target function option in the configuration column includes a field placement area for configuring the pivot table, and the field placement area includes at least one of the following field data placement areas: row data, column data, value data, and filter fields.

In one embodiment, the electronic form configuration device further includes:

The second receiving module is used to receive the operation of associating the field data with the field placement area;

The establishing module is used for, in response to the operation, establishing the mapping relationship between the field data and the cells according to the cells corresponding to the field placement area in the pivot table.

In one embodiment, the electronic form configuration device further includes:

The fill module is used to fill the cells in the pivot table with field data based on the mapping relationship.

In one embodiment, the spreadsheet is a pivot table; the first receiving module 610 includes:

The second receiving unit is used to receive an input operation on the menu bar associated with the target function option in the pivot table;

Wherein, the menu bar includes at least one of the following target function options: a sort function option, a function option of displaying or hiding category subtotals, and a function option of displaying or hiding duplicate item labels.

In one embodiment, the first receiving unit is specifically used for:

Receive the operation of moving any field in the field data to any field drop area;

Or, receive a trigger operation of selecting a target function option in the configuration bar.

In one embodiment, the second receiving unit is specifically used for:

Receive the trigger operation of selecting the target function option in the menu bar.

In one embodiment, the determining module 620 includes:

The first determination unit is used to determine the target cell corresponding to the field placement area in the electronic form according to the field placement area in response to the operation of moving any field in the field data to any field placement area;

or,

The second determining unit is configured to determine the target cell corresponding to the target function option in the spreadsheet according to the selected cell and the triggered target function option in response to a trigger operation on the target function option in a selection manner in the configuration bar.

In one embodiment, the determining module 620 includes:

The third determination unit is used to respond to the trigger operation of the target function option in the menu bar that triggers the pop-up on the selected cell, and determine the electronic form according to the selected cell and the selected target function option. The target cell corresponding to the target feature option.

In one embodiment, the spreadsheet is a pivot table, and the pivot table is a mapping table constructed based on the row data of the first dimension and the column data of the second dimension; the pivot information of the cells in the pivot table includes: Element information and level information on the first dimension, and element information and level information on the second dimension.

In one embodiment, the determining module 620 includes:

a target element information determination unit, configured to determine target element information corresponding to the target function option;

The target level information determination unit is used to determine the target level information of the selected cell in the dimension corresponding to the target element information;

The fourth determination unit is used to determine the target cell corresponding to the target function option in the pivot table; wherein, the target cell is on the dimension corresponding to the target element information, and its corresponding element information matches the target element information, Its hierarchy information matches the target hierarchy information.

In one embodiment, the preset display mode includes at least one of the following: highlighting, thickening the outline, and coloring the outline.

By adopting the technical solution of the embodiment of the present application, by receiving the input operation of the target function option in the electronic form, the target function option is used to configure the electronic form, and the input operation may include pre-association of the field data with the target function option, so as to respond to the input Operation, determine the target cell corresponding to the target function option in the spreadsheet, and then display the target cell in a preset display mode. It can be seen that in the process of configuring the electronic form, this technical solution can display the cells corresponding to each function option based on the operation of the pre-associated function options and field data, so that the user can quickly and accurately know the effect of each function option in the electronic form. The cells reduce the difficulty of understanding the various function options used to configure the electronic form, thereby helping to reduce the difficulty of configuring the electronic form.

Those skilled in the art should understand that the electronic form configuration device in FIG. 6 can be used to implement the electronic form configuration method described above, and the detailed description should be similar to the previous description of the method. In order to avoid tediousness, here No further description.

Based on the same thought, the embodiment of the present application also provides a device for configuring electronic forms, as shown in FIG. 7 . The electronic form configuration device may have relatively large differences due to different configurations or performances, and may include one or more processors 701 and memory 702, and one or more application programs or data may be stored in the memory 702. Wherein, the storage 702 may be a short-term storage or a persistent storage. The application program stored in the memory 702 may include one or more modules (not shown in the figure), and each module may include a series of computer-executable instructions for configuring the electronic form. Furthermore, the processor 701 may be configured to communicate with the memory 702, and execute a series of computer-executable instructions in the memory 702 on the electronic form configuration device. The electronic form configuration device may also include one or more power sources 703 , one or more wired or wireless network interfaces 704 , one or more input and output interfaces 705 , and one or more keyboards 706 .

Specifically in this embodiment, the electronic form configuration device includes a memory, and one or more application programs, wherein one or more application programs are stored in the memory, and one or more application programs may include one or more modules, and each module may include a series of computer-executable instructions in the electronic form configuration device, and is configured to be executed by one or more processors, and the one or more application programs include computer-executable instructions for performing the following instruction:

receiving an input operation on a target function option in the electronic form; the target function option is used to configure the electronic form; the input operation includes pre-association of field data with the target function option;

determining a target cell in the spreadsheet corresponding to the target function option in response to the input operation;

Display the target cell in the preset display mode.

By adopting the technical solution of the embodiment of the present application, by receiving the input operation of the target function option in the electronic form, the target function option is used to configure the electronic form, and the input operation may include pre-association of the field data with the target function option, so as to respond to the input Operation, determine the target cell corresponding to the target function option in the spreadsheet, and then display the target cell in a preset display mode. It can be seen that in the process of configuring the electronic form, this technical solution can display the cells corresponding to each function option based on the operation of the pre-associated function options and field data, so that the user can quickly and accurately know the effect of each function option in the electronic form. The cells reduce the difficulty of understanding the various function options used to configure the electronic form, thereby helping to reduce the difficulty of configuring the electronic form.

The embodiment of the present application also provides a storage medium, the storage medium stores one or more computer programs, and the one or more computer programs include computer-executable instructions. When the device executes, the electronic device can be made to execute the various processes of the above embodiments of the electronic form configuration method, and can achieve the same technical effect. To avoid repetition, details are not repeated here.

The systems, devices, modules, or units described in the above embodiments can be specifically implemented by computer chips or entities, or by products with certain functions. A typical implementing device is a computer. Specifically, the computer may be, for example, a personal computer, a laptop computer, a cellular phone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or Combinations of any of these devices.

For the convenience of description, when describing the above devices, functions are divided into various units and described separately. Of course, when implementing the present application, the functions of each unit can be implemented in one or more pieces of software and/or hardware.

Those skilled in the art should understand that the embodiments of the present application may be provided as methods, systems, or computer program products. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) having computer-usable program code embodied therein.

The present application is described with reference to flowcharts and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the present application. It should be understood that each procedure and/or block in the flowchart and/or block diagram, and a combination of procedures and/or blocks in the flowchart and/or block diagram can be realized by computer program instructions. These computer program instructions may be provided to a general purpose computer, special purpose computer, embedded processor, or processor of other programmable data processing equipment to produce a machine such that the instructions executed by the processor of the computer or other programmable data processing equipment produce a An apparatus for realizing the functions specified in one or more procedures of the flowchart and/or one or more blocks of the block diagram.

These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing apparatus to operate in a specific manner, such that the instructions stored in the computer-readable memory produce an article of manufacture comprising instruction means, the instructions The device realizes the function specified in one or more procedures of the flowchart and/or one or more blocks of the block diagram.

These computer program instructions can also be loaded onto a computer or other programmable data processing device, causing a series of operational steps to be performed on the computer or other programmable device to produce a computer-implemented process, thereby The instructions provide steps for implementing the functions specified in the flow chart or blocks of the flowchart and/or the block or blocks of the block diagrams.

In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.

Memory may include non-permanent storage in computer readable media, in the form of random access memory (RAM) and/or nonvolatile memory such as read only memory (ROM) or flash RAM. Memory is an example of computer readable media.

Computer-readable media, including both permanent and non-permanent, removable and non-removable media, can be implemented by any method or technology for storage of information. Information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read only memory (ROM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Flash memory or other memory technology, Compact Disc Read-Only Memory (CD-ROM), Digital Versatile Disc (DVD) or other optical storage, Magnetic tape cartridge, tape magnetic disk storage or other magnetic storage device or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, computer-readable media excludes transitory computer-readable media, such as modulated data signals and carrier waves.

It should also be noted that the term "comprises", "comprises" or any other variation thereof is intended to cover a non-exclusive inclusion such that a process, method, article, or apparatus comprising a set of elements includes not only those elements, but also includes Other elements not expressly listed, or elements inherent in the process, method, commodity, or apparatus are also included. Without further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of additional identical elements in the process, method, article or apparatus comprising said element.

This application may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The application may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including storage devices.

Each embodiment in this specification is described in a progressive manner, the same and similar parts of each embodiment can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the system embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and for relevant parts, refer to part of the description of the method embodiment.

The above descriptions are only examples of the present application, and are not intended to limit the present application. For those skilled in the art, various modifications and changes may occur in this application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included within the scope of the claims of the present application.

Claims (15)

1. A method for configuring an electronic form, comprising: receiving an input operation to a target function option in an electronic form; the target function option is used to configure the electronic form; the input operation includes pre-association of field data with the target function option; In response to the input operation, determining a target cell corresponding to the target function option in the electronic form; The target cell is displayed in a preset display manner. 2. The method according to claim 1, wherein the electronic form is a pivot table; the receiving input operation to the target function option in the electronic form comprises: receiving an input operation on the target function option in the configuration column on the pivot table; Wherein, the target function option in the configuration column includes a field placement area for configuring the pivot table, and the field placement area includes a placement area for at least one of the following field data: row data, column data, value data, filter field. 3. The method according to claim 2, wherein the method further comprises: receiving an operation of associating the field data with the field placement area; In response to the operation, a mapping relationship between the field data and the cells is established according to the cells in the pivot table corresponding to the field placement areas. 4. method according to claim 3, is characterized in that, described method also comprises: Based on the mapping relationship, the cells in the pivot table are filled with the field data. 5. The method according to claim 1, wherein the electronic form is a pivot table; the receiving input operation of the target function option in the electronic form comprises: receiving an input operation on the menu bar associated with the target function option in the pivot table; Wherein, the menu bar includes at least one of the following target function options: a sort function option, a function option of displaying or hiding category subtotals, and a function option of displaying or hiding duplicate item labels. 6. The method according to claim 2, wherein the receiving input operation of the target function option in the configuration bar on the pivot table comprises: receiving an operation of moving any field in the field data to any of the field placement areas; Or, receiving a trigger operation of selecting the target function option in the configuration bar. 7. The method according to claim 5, wherein the receiving the input operation of the menu bar associated with the target function option in the pivot table comprises: receiving a trigger operation of selecting the target function option in the menu bar. 8. The method according to claim 6, wherein, in response to the input operation, determining the target cell corresponding to the target function option in the spreadsheet comprises: In response to the operation of moving any field in the field data to any of the field placement areas, according to the field placement area, determine the target cell corresponding to the field placement area in the electronic form; or, In response to a trigger operation on the target function option in a selection manner in the configuration column, according to the selected cell and the triggered target function option, determine the target corresponding to the target function option in the spreadsheet Cell. 9. The method according to claim 7, wherein, in response to the input operation, determining the target cell corresponding to the target function option in the spreadsheet comprises: In response to a trigger operation on the selected cell and in the menu bar that triggers the pop-up, the target function option is selected, and the electronic form is determined according to the selected cell and the selected target function option The target cell corresponding to the target function option in . 10. The method according to claim 1, wherein the spreadsheet is a pivot table, and the pivot table is a mapping table constructed based on the row data of the first dimension and the column data of the second dimension; The pivot information of the cells in the pivot table includes: element information and level information on the first dimension, and element information and level information on the second dimension. 11. The method according to claim 10, wherein, in response to the input operation, determining the target cell corresponding to the target function option in the spreadsheet comprises: determining target element information corresponding to the target function option; Determine the target level information of the selected cell on the dimension corresponding to the target element information; In the pivot table, determine the target cell corresponding to the target function option; wherein, the target cell is on the dimension corresponding to the target element information, and its corresponding element information and the target element information match, its level information matches the target level information. 12. The method according to claim 1, wherein the preset display mode includes at least one of the following: highlighting, thickening the outline, and coloring the outline. 13. A configuration device for an electronic form, characterized in that, comprising: The first receiving module is used to receive an input operation on the target function option in the electronic form; the target function option is used to configure the electronic form; the input operation includes pre-association of field data with the target function option; A determining module, configured to determine a target cell corresponding to the target function option in the electronic form in response to the input operation; A display module, configured to display the target cell in a preset display manner. 14. A configuration device for an electronic form, characterized in that, comprising: processor; and A memory arranged to store computer-executable instructions configured to be executed by the processor, the computer-executable instructions being executed by the processor to implement the method described in any one of claims 1-12 How to configure the spreadsheet described above. 15. A storage medium, characterized in that the storage medium is used to store computer-executable instructions, and when the computer-executable instructions are executed by a processor, the electronic form according to any one of claims 1-12 is implemented. configuration method.

Images