CN112949266B

CN112949266B - Electronic form processing method, electronic form processing device, electronic equipment and storage medium

Info

Publication number: CN112949266B
Application number: CN201911268264.4A
Authority: CN
Inventors: 霍秋桦; 陈波
Original assignee: Beijing Kingsoft Office Software Inc; Zhuhai Kingsoft Office Software Co Ltd
Current assignee: Beijing Kingsoft Office Software Inc; Zhuhai Kingsoft Office Software Co Ltd
Filing date: 2019-12-11
Publication date: 2024-06-25
Anticipated expiration: 2039-12-11

Abstract

The embodiment of the invention provides a processing method, a processing device, electronic equipment and a storage medium for an electronic form, wherein the method comprises the following steps: acquiring a to-be-processed electronic form, receiving a selection instruction of a user for a drop-down list in a drop-down list template to obtain a target drop-down list, receiving a selection instruction of a user for cells in the to-be-processed electronic form to obtain target setting cells, and setting contents in the target drop-down list into the target setting cells. The embodiment of the invention can reduce the operation difficulty of the user and improve the problem of poor user experience.

Description

Electronic form processing method, electronic form processing device, electronic equipment and storage medium

Technical Field

The present invention relates to the field of computer technologies, and in particular, to a method and apparatus for processing an electronic form, an electronic device, and a storage medium.

Background

A drop-down list refers to a list in which hidden contents in the list can be displayed in a drop-down manner. When clicking on the drop-down list, the terminal displays each content included in the drop-down list, and the user can select one or more items of content from the displayed each content.

In the prior art, when a drop-down list is set for a certain cell in a table, a user terminal receives an instruction for setting the drop-down list for the certain cell, obtains the cell needing to set the drop-down list according to the instruction, then uses the content input by the user in a content input box as the content to be added into the drop-down list, generates the drop-down list in the cell needing to set the drop-down list, and displays the content input by the user in the drop-down list.

However, each time a user adds new content to the drop-down list, the user needs to input the new content in the dialog box and then click the ok button, so that the new content is added to the drop-down list, that is, the user needs to send an ok instruction once every time the content is added to the drop-down list, thus increasing the operation difficulty of the user and resulting in poor user experience.

Disclosure of Invention

The embodiment of the invention aims to provide a processing method, a processing device, electronic equipment and a storage medium of an electronic form, which are used for solving the problems that a user needs to send a plurality of instructions when a drop-down list is set, the operation difficulty of the user is increased and the user experience is poor. The specific technical scheme is as follows:

in a first aspect, an embodiment of the present invention provides a method for processing a spreadsheet, where the method includes:

Acquiring an electronic form to be processed;

Receiving a selection instruction of a user for a drop-down list in a drop-down list template to obtain a target drop-down list, wherein different drop-down list contents are displayed in different drop-down lists;

Receiving a selection instruction of a user for cells in the electronic form to be processed, and obtaining target setting cells;

and setting the content in the target drop-down list into the target setting cell.

Optionally, the step of receiving a selection instruction of the user for the drop-down list in the drop-down list template to obtain the target drop-down list includes:

The drop-down list template is displayed to a user, wherein the drop-down list template comprises: a plurality of pull-down lists and contents corresponding to the pull-down lists;

Receiving a selection instruction of a user for the plurality of drop-down lists;

and determining a target drop-down list according to the selection instruction.

Optionally, after the obtaining the electronic form to be processed, the method further includes:

generating a first drop-down list by utilizing the content of the cells with the same content in the electronic form to be processed;

The first drop-down list is added to the drop-down list template.

Optionally, the step of generating the first drop-down list by using the content of the cells with the same content in the electronic form to be processed includes:

Generating a first drop-down list by utilizing a target column or a target row in the electronic form to be processed; the target columns or the target rows have cells with the same content.

Optionally, the step of generating the first drop-down list by using the target column or the target row in the electronic form to be processed includes:

Acquiring the content of the cells with the same content in the target column or the target row;

Extracting the content with occurrence times exceeding a preset time threshold for the acquired content;

the extracted content is composed as the first drop-down list.

Optionally, before the obtaining the electronic form to be processed, the method further includes:

And obtaining a drop-down list in the drop-down list template by utilizing the drop-down list in the pre-generated electronic table.

Optionally, the step of obtaining the drop-down list in the drop-down list template by using the drop-down list in the pre-generated electronic table includes:

Acquiring the content in the pre-generated pull-down list;

Extracting content with occurrence times exceeding a preset time threshold from the content in the pre-generated pull-down list;

Combining the extracted content into a second drop-down list;

the second drop-down list is added to the drop-down list template.

and obtaining the drop-down list in the drop-down list template by utilizing the user-defined content input by the user.

Optionally, the step of obtaining the drop-down list in the drop-down list template by using the custom content input by the user includes:

Acquiring the user-defined content input by a user;

the custom content is composed into a third drop-down list;

The third drop-down list is added to the drop-down list template.

Acquiring a history drop-down list in the electronic form to be processed, wherein the history drop-down list is a drop-down list pre-stored in the electronic form to be processed;

the history drop-down list is added to the drop-down list template.

In a second aspect, an embodiment of the present invention provides a processing apparatus for a spreadsheet, where the apparatus includes:

The first acquisition module is used for acquiring the electronic form to be processed;

the first receiving module is used for receiving a selection instruction of a user for a drop-down list in a drop-down list template to obtain a target drop-down list, wherein different drop-down list contents are displayed in different drop-down lists;

the second receiving module is used for receiving a selection instruction of a user for cells in the electronic form to be processed to obtain target setting cells;

And the setting module is used for setting the content in the target drop-down list into the target setting unit cell.

Optionally, the first receiving module specifically includes:

The display sub-module is used for displaying the pull-down list template to a user, and the pull-down list template comprises: a plurality of pull-down lists and contents corresponding to the pull-down lists;

The receiving sub-module is used for receiving a selection instruction of a user for the plurality of drop-down lists;

and the determining submodule is used for determining a target drop-down list according to the selection instruction.

Optionally, the apparatus further includes:

the generation module is used for generating a first drop-down list by utilizing the content of the cells with the same content in the electronic form to be processed;

And the first adding module is used for adding the first drop-down list into the drop-down list template.

Optionally, the generating module is specifically configured to:

Optionally, the generating module includes:

the first acquisition submodule is used for acquiring the contents of the cells with the same contents in the target column or the target row;

The first extraction submodule is used for extracting the content with the occurrence number exceeding a preset number threshold for the acquired content;

and the first composition submodule is used for composing the extracted content into the first drop-down list.

Optionally, the apparatus further includes:

and the second acquisition module is used for obtaining the drop-down list in the drop-down list template by utilizing the drop-down list in the pre-generated electronic table.

Optionally, the second obtaining module specifically includes:

a second obtaining sub-module, configured to obtain the pre-generated pull-down list and contents in the pre-generated pull-down list;

The second extraction submodule is used for extracting the content with the occurrence frequency exceeding a preset frequency threshold value from the content in the pre-generated pull-down list;

a second composition sub-module for composing the extracted content into a second drop-down list;

and the first adding submodule is used for adding the second drop-down list into the drop-down list template.

Optionally, the apparatus further includes:

And the third acquisition module is used for acquiring the drop-down list in the drop-down list template by utilizing the user-defined content input by the user.

Optionally, the third obtaining module specifically includes:

the third acquisition sub-module is used for acquiring the user-defined content input by the user;

A third composition sub-module, configured to compose the custom content into a third drop-down list;

And the second adding submodule is used for adding the third drop-down list into the drop-down list template.

Optionally, the apparatus further includes:

a fourth acquisition module: the method comprises the steps of obtaining a history drop-down list in the electronic form to be processed, wherein the history drop-down list is a drop-down list pre-stored in the electronic form to be processed;

And the second adding module is used for adding the history drop-down list into the drop-down list template.

In a third aspect, an embodiment of the present invention provides an electronic device, including a processor, a communication interface, a memory, and a communication bus, where the processor, the communication interface, and the memory complete communication with each other through the communication bus;

A memory for storing a computer program;

and a processor, configured to implement the method steps described in the first aspect when executing the program stored in the memory.

In a fourth aspect, embodiments of the present invention provide a computer-readable storage medium having stored therein a computer program which, when executed by a processor, implements the method steps of the first aspect described above.

The embodiment of the invention has the beneficial effects that:

According to the electronic form processing method, the electronic device and the storage medium, the electronic form to be processed can be obtained first, the electronic form to be processed is provided with the pull-down list template, the pull-down list template is provided with the pull-down list with different contents, then a selection instruction of a user is received to determine the target pull-down list and the target setting cell, and the target pull-down list is set in the target setting cell. Because the content of the drop-down list in the drop-down list template is determined, the user does not need to send a determining instruction for a plurality of times, so that the operation difficulty of the user is reduced, and the problem of poor user experience is solved. Of course, it is not necessary for any one product or method of practicing the invention to achieve all of the advantages set forth above at the same time.

Drawings

In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.

FIG. 1 is a flowchart of a first method for processing a spreadsheet according to an embodiment of the present invention;

FIG. 2 is a schematic flow chart of step S102 in the embodiment of the invention;

FIG. 3 is a diagram of a drop down list template in an embodiment of the invention;

FIG. 4 is a flowchart of a second method for processing a spreadsheet according to an embodiment of the present invention;

FIG. 5 is a schematic diagram of a to-be-processed electronic form according to an embodiment of the present invention;

FIG. 6 is a schematic diagram of a drop-down list generated by applying the processing method of the second electronic form provided in the embodiment of the present invention;

FIG. 7 is a flowchart of a third method for processing a spreadsheet according to an embodiment of the present invention;

FIG. 8 is a flowchart of a fourth method for processing a spreadsheet according to an embodiment of the present invention;

FIG. 9 is a schematic flow chart of step S401 in the embodiment of the present invention;

FIG. 10 is a flowchart of a fifth method for processing a spreadsheet according to an embodiment of the present invention;

FIG. 11 is a schematic flow chart of step S501 in the embodiment of the present invention;

FIG. 12 is a flowchart of a sixth method for processing a spreadsheet according to an embodiment of the present invention;

FIG. 13 is a schematic diagram of another electronic form to be processed in an embodiment of the invention;

FIG. 14 is a schematic diagram of a drop-down list generated by applying a sixth spreadsheet processing method according to an embodiment of the present invention;

FIG. 15 is a schematic diagram of a first electronic form processing apparatus according to an embodiment of the present invention;

Fig. 16 is a schematic structural diagram of a first receiving module according to an embodiment of the present invention;

FIG. 17 is a schematic diagram of a second electronic form processing apparatus according to an embodiment of the present invention;

FIG. 18 is a schematic diagram of a generating module according to an embodiment of the present invention;

FIG. 19 is a schematic diagram of a third electronic form processing apparatus according to an embodiment of the present invention;

FIG. 20 is a schematic diagram of a second acquiring module according to an embodiment of the present invention;

FIG. 21 is a schematic diagram of a fourth electronic form processing apparatus according to an embodiment of the present invention;

FIG. 22 is a schematic structural diagram of a third acquiring module according to an embodiment of the present invention;

FIG. 23 is a schematic diagram of a fifth electronic form processing apparatus according to an embodiment of the present invention;

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

Detailed Description

The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.

As shown in fig. 1, an embodiment of the present invention provides a method for processing a spreadsheet, where the process may include the following steps:

S101, acquiring a to-be-processed electronic form.

The method for processing the electronic form can be applied to electronic equipment, the electronic equipment can run document editing software, and the document editing software can be used for editing the electronic form. The electronic device may refer to a computer, a mobile phone, a tablet computer or the like.

When a user needs to insert a drop-down list into a spreadsheet, the spreadsheet to be processed may be typed, which may refer to a table that the user needs to perform an insert drop-down list operation.

S102, receiving a selection instruction of a user for a drop-down list in a drop-down list template to obtain a target drop-down list.

In the embodiment of the invention, a plurality of drop-down lists can be arranged in the drop-down list template, and a plurality of different drop-down lists can be displayed with different drop-down list contents. The drop-down list template can be stored in a menu of 'insert drop-down list', and when a user clicks on a 'insert drop-down list' option, the drop-down list template is displayed to the user so as to receive a selection instruction of the user for the drop-down list in the drop-down list template, and a target drop-down list can be obtained by utilizing the selection instruction, wherein the target drop-down list can be the drop-down list which is required to be set by the user for the cells in the electronic form to be processed.

S103, receiving a selection instruction of a user for cells in the electronic form to be processed, and obtaining target setting cells.

In the embodiment of the present invention, the target setting cell may refer to a cell selected by a user and needing to set a pull-down list, the user may send a selection instruction for any one cell in the electronic table to be processed, that is, any one cell in the electronic table to be processed may set the pull-down list, the user may also send a selection instruction for a plurality of cells in the electronic table to be processed at the same time, so that the plurality of selected cells may be set to the same pull-down list, for example, if the a11 cell and the B2 cell are simultaneously selected by the user, the a11 cell and the B2 cell may be set to the same pull-down list.

S104, setting the content in the target drop-down list into the target setting cell.

In the embodiment of the invention, after receiving a selection instruction of a user for a drop-down list in a drop-down list template and a selection instruction for a cell in a to-be-processed electronic form, the drop-down list content in a target drop-down list can be copied, the copied content is pasted into a target setting cell, and after the step is completed, when the user clicks the target setting cell, the target setting cell can display the target drop-down list to the user.

As an alternative implementation manner of the embodiment of the present invention, as shown in fig. 2, the step S102 specifically includes:

s1021, displaying the pull-down list template to the user.

In the embodiment of the invention, the drop-down list template can be stored in a menu of an 'insert drop-down list', when a user clicks an 'insert drop-down list' option, the electronic device can display the drop-down list template to the user, as shown in fig. 3, the drop-down list template can comprise a plurality of drop-down lists, for example, a drop-down list formed by drop-down list contents such as 'yes', 'no', and the like, a drop-down list formed by drop-down list contents such as 'not started', 'in progress', and 'completed', and a drop-down list formed by drop-down list contents such as 'a', 'B', and 'C', and the like.

S1022, receiving a selection instruction of a user for a plurality of drop-down lists.

After the drop-down list template is displayed to the user, the user can click on a plurality of drop-down lists in the drop-down list template, and the electronic equipment receives a selection instruction through clicking on the drop-down list by the user.

S1023, determining a target pull-down list according to the selection instruction.

In the embodiment of the invention, the electronic equipment can determine the drop-down list selected by the user as the target drop-down list by receiving the selection instruction of the user, and the content in the target drop-down list is the same as the drop-down list content required to be set by the user.

According to the method for processing the electronic forms, the electronic forms to be processed can be obtained first, the electronic forms to be processed are provided with the pull-down list templates, pull-down lists with different contents are arranged in the pull-down list templates, then a selection instruction of a user is received to determine the target pull-down list and the target setting unit cell, and the target pull-down list is set in the target setting unit cell. Because the content of the drop-down list in the drop-down list template is determined, the user does not need to send a determining instruction for a plurality of times, so that the operation difficulty of the user is reduced, and the problem of poor user experience is solved.

As shown in fig. 4, the embodiment of the present invention further provides a method for processing a spreadsheet, where the method may include:

S201, acquiring a to-be-processed electronic form.

This step is the same as step S101 in the embodiment shown in fig. 1, and will not be described here again.

S202, generating a first drop-down list by utilizing the content of the cells with the same content in the electronic form to be processed.

In the embodiment of the invention, cells with the same content can exist in the electronic table to be processed, and the cells can exist in one column, one row or any cell in the electronic table to be processed. The contents of the cells having the same contents are extracted, and the contents are used as the first drop-down list contents to generate a first drop-down list.

S203, adding the first drop-down list to the drop-down list template.

The first drop-down list is added to a drop-down list template, and when the user clicks the 'insert drop-down list' option, the electronic device can present the drop-down list template to the user, wherein the drop-down list template comprises the first drop-down list. That is, the user can select the contents of the cells having the same contents in the table to be processed as the drop-down list contents.

S204, receiving a selection instruction of a user for a drop-down list in the drop-down list template to obtain a target drop-down list.

This step is the same as step S102 in the embodiment shown in fig. 1, and will not be described here again.

S205, receiving a selection instruction of a user for cells in the electronic form to be processed, and obtaining target setting cells.

This step is the same as step S103 in the embodiment shown in fig. 1, and will not be described here again.

S206, setting the content in the target drop-down list into the target setting cell.

This step is the same as step S104 in the embodiment shown in fig. 1, and will not be described here again.

As an optional implementation manner of the embodiment of the present invention, the step S202 specifically includes:

A first drop-down list is generated using the target column or target row in the spreadsheet to be processed.

In the embodiment of the invention, the target row or the target column has the cells with the same content, and the content in the cells can be extracted as the first drop-down list content, and the first drop-down list is generated and displayed in the drop-down list template. As shown in fig. 5, the electronic table includes A, B, C columns, where column C is a column with cells having the same content, in column C, C1, C2, and C3 are cells having the same content, the content of the cells is a collaboration function, C5, C6, C7, and C8 are cells having the same content, the content of the cells is an operation, and C10 and C11 are cells having the same content, and the content of the cells is an optimization improvement. As shown in fig. 6, one item each of "collaboration function", "operation", "optimization improvement" is extracted as a pull-down list content generation pull-down list, and displayed in a pull-down list template.

As an alternative implementation manner of the embodiment of the present invention, after the embodiment shown in fig. 4, as shown in fig. 7, a method for processing an electronic table according to the embodiment of the present invention further includes:

S301, acquiring the content of the cells with the same content in the target column or the target row.

In the embodiment of the invention, the target column or the target row can be provided with the cells with the same content, or the target row can be provided with the cells with different content, when the user clicks the 'insert drop-down list option', the electronic equipment can receive the clicking instruction of the user, and the electronic equipment acquires the content of the cells with the same content from the target row or the target column corresponding to the clicking instruction.

S302, extracting the content with the occurrence number exceeding a preset number threshold for the acquired content.

In the embodiment of the present invention, the content of the cells whose number of identical cells exceeds the preset threshold value in the obtained content may be extracted, for example, if the content of a column of cells is "a", "B", "C", and "B" is a cell that does not have identical content, it is known that "B" is first excluded, and if the preset threshold value is 2, "B" and "C" are extracted as the drop-down list content. It should be noted that, the preset frequency threshold may be set by the user according to the actual service requirement, and the embodiment of the present invention is not specifically limited.

S303, the extracted content is composed into a first pull-down list.

In the embodiment of the invention, the extracted content exceeding the preset times threshold value can be sequentially formed into a new drop-down list, and the new drop-down list is the first drop-down list which can be displayed in the drop-down list template.

According to the processing method of the electronic form, which is provided by the embodiment of the invention, the content with the cells with the same content in the electronic form to be processed can be utilized to generate the drop-down list and be added to the drop-down list template, and when a user wants to set the content with the cells with the same content as the drop-down list on the target cell, the user does not need to click the cells with the same content again and can directly obtain the content from the drop-down list template, so that the operation of the user is simpler and more convenient, and the user experience is improved.

As shown in fig. 8, the embodiment of the present invention further provides a method for processing a spreadsheet, where the method may include:

S401, utilizing a pull-down list in a pre-generated electronic form to obtain the pull-down list in a pull-down list template.

In the embodiment of the invention, a pre-generated electronic table can be stored in the electronic equipment, some cells in the electronic table are provided with a drop-down list, when a user clicks an 'insert drop-down list option', the electronic equipment can receive a click command sent by the user, search a set drop-down list in the pre-generated electronic table corresponding to the click command, acquire the set drop-down list and add the set drop-down list to a drop-down list template in the electronic table to be processed. The existing drop-down list in the pre-generated electronic form has a large relevance to the content of the cells in the electronic form to be processed, and the cells in the electronic form to be processed may need to set the existing drop-down list in the pre-generated electronic form, so that the drop-down list in the pre-generated electronic form can be acquired.

S402, acquiring a to-be-processed electronic form.

S403, receiving a selection instruction of a user for a drop-down list in the drop-down list template to obtain a target drop-down list.

S404, receiving a selection instruction of a user for cells in the electronic form to be processed, and obtaining target setting cells.

S405, the contents in the target drop-down list are set into the target setting cell.

As an alternative implementation manner of the embodiment of the present invention, as shown in fig. 9, the step S401 specifically includes:

s4011, a pre-generated pull-down list and contents in the pre-generated pull-down list are acquired.

In the embodiment of the invention, when a user clicks the 'insert drop-down list option', the electronic equipment can receive a click instruction of the user, and the electronic equipment searches a pre-generated drop-down list in the electronic form to be processed and acquires the pre-generated drop-down list corresponding to the click instruction.

S4012 extracts, from the contents in the pull-down list generated in advance, contents whose number of occurrences exceeds a preset number of times threshold.

Among the contents in the pre-generated pull-down list, the same contents can exist for multiple times, the electronic device can identify the cells with the same contents and extract the contents with the occurrence times exceeding the preset times threshold value in the contents of the cells, and it is noted that the preset times threshold value can be set by a user according to actual service requirements.

S4013, the extracted content is composed as a second drop-down list.

In the embodiment of the invention, after the electronic device extracts the content with the occurrence number exceeding the preset number threshold, the content can be sequentially arranged to form a new drop-down list, and the new drop-down list can be used as a second drop-down list.

S4014, add the second drop-down list to the drop-down list template.

And adding the second drop-down list into the drop-down list template, wherein the second drop-down list is displayed in the drop-down list template, and after the addition of the second drop-down list is completed, if the user needs to set the second drop-down list onto other cells, the second drop-down list can be directly obtained from the drop-down list template.

According to the method for processing the electronic forms, the drop-down list in the drop-down list template can be obtained by utilizing the drop-down list in the pre-generated electronic forms, so that even when the history drop-down list does not exist in the electronic forms to be processed, the drop-down list can be obtained from the pre-generated electronic forms without manually inputting the content of the drop-down list, and the operation efficiency is higher.

As shown in fig. 10, the embodiment of the present invention further provides a method for processing a spreadsheet, where the method may include:

S501, obtaining a drop-down list in a drop-down list template by utilizing user-input custom content.

In the embodiment of the invention, a pull-down list template can be displayed to a user, and referring to fig. 3, the user can input custom content by clicking a 'custom pull-down list' option in the pull-down list template, and the pull-down list in the pull-down list template is obtained by utilizing the custom content input by the user. When a user needs to set a drop-down list for a cell in the electronic form to be processed, and the required drop-down list is not found in the drop-down list template, custom content can be input to obtain a new drop-down list.

S502, acquiring a to-be-processed electronic form.

S503, receiving a selection instruction of a user for a drop-down list in the drop-down list template to obtain a target drop-down list.

S504, receiving a selection instruction of a user for cells in the electronic form to be processed, and obtaining target setting cells.

S505, the contents in the target drop-down list are set into the target setting cell.

As an alternative implementation manner of the embodiment of the present invention, as shown in fig. 11, the step S501 specifically includes:

S5011, acquiring user-defined content input by a user.

In the embodiment of the invention, a drop-down list template can be displayed to a user, and referring to fig. 3, a user-defined drop-down list option exists in the drop-down list template, the user can input user-defined content by clicking the user-defined drop-down list option, and the electronic equipment receives a selection instruction of the user aiming at the user-defined drop-down list option and acquires the user-defined content input by the user.

S5012, the custom content is composed as a third drop down list.

In the embodiment of the invention, the electronic device can form the acquired self-defined content into the third drop-down list.

S5013, the third drop down list is added to the drop down list template.

And adding the third drop-down list into the drop-down list template, wherein the third drop-down list is displayed in the drop-down list template, and after the addition of the third drop-down list is completed, if the user needs to set the third drop-down list onto other cells, the third drop-down list can be directly obtained from the drop-down list template.

According to the method for processing the electronic form, which is provided by the embodiment of the invention, the user-defined content input by the user can be utilized to obtain the drop-down list in the drop-down list template. In this way, the user can predict which contents are to be used as the drop-down list according to the contents in the to-be-processed table, input the predicted contents to obtain the corresponding drop-down list, and obtain the direct use from the drop-down list template when the drop-down list is set for the target cell later, thereby improving the working efficiency.

As shown in fig. 12, the embodiment of the present invention further provides a method for processing a spreadsheet, where the method may include:

S601, acquiring a to-be-processed electronic form.

S602, acquiring a history drop-down list in the electronic form to be processed.

In the embodiment of the present invention, as shown in fig. 13, a to-be-processed electronic form may have a history drop-down list, where the history drop-down list is a drop-down list pre-saved in the to-be-processed electronic form, and the history drop-down list in fig. 13 is composed of three items of "web", "mobile end" and "two ends" drop-down list contents. When the user clicks the "insert drop-down list option", the electronic device may receive a click command from the user, and the electronic device searches and obtains a history drop-down list in the electronic form to be processed corresponding to the click command.

S603, adding the history pull-down list into a pull-down list template.

After the history drop-down list is obtained, as shown in fig. 14, the "web", "mobile end" and "both ends" are extracted and displayed as one drop-down list in the drop-down list template, and when one drop-down list is newly added in the drop-down list template, the newly added drop-down list is displayed before the existing drop-down list in the drop-down list template, the history drop-down list is added in the drop-down list template, the history drop-down list is displayed in the drop-down list template, and after the addition of the history drop-down list is completed, the user can obtain the history drop-down list from the drop-down list template and set the history drop-down list on other target cells. If a history drop-down list exists in the electronic table to be processed, the content of the drop-down list in the history drop-down list has a large relevance with the content in the cells of the electronic table to be processed, and the user is likely to need to set the history drop-down list in other cells in the electronic table to be processed, so that the electronic device can acquire the history drop-down list in the electronic table to be processed and add the history drop-down list to the drop-down list template, and then the user can conveniently set the history drop-down list in other cells in the electronic table to be processed.

S604, receiving a selection instruction of a user for a drop-down list in the drop-down list template to obtain a target drop-down list.

S605, receiving a selection instruction of a user for cells in the electronic form to be processed, and obtaining target setting cells.

S606, setting the content in the target drop-down list into a target setting cell.

According to the method for processing the electronic table, the historical drop-down list in the drop-down list template can be obtained by using the historical drop-down list in the electronic table to be processed, and then a user can obtain the historical drop-down list from the drop-down list template and set the historical drop-down list on other target cells without manually inputting the content in the historical list again, so that the operation experience is improved.

Corresponding to the method embodiment, the embodiment of the invention also provides a processing device of the electronic table, corresponding to the flow shown in fig. 1, as shown in fig. 15, the device comprises:

A first obtaining module 701, configured to obtain a to-be-processed electronic form.

The first receiving module 702 is configured to receive a selection instruction of a user for a drop-down list in a drop-down list template, so as to obtain a target drop-down list, where different drop-down list contents are displayed in different drop-down lists.

The second receiving module 703 is configured to receive a selection instruction of a user for a cell in the electronic form to be processed, so as to obtain a target setting cell.

A setting module 704, configured to set the content in the target drop-down list into the target setting cell.

As an alternative implementation manner of the embodiment of the present invention, as shown in fig. 16, the first receiving module specifically includes:

The display submodule 7021 is configured to display a drop-down list template to a user, where the drop-down list template includes: and the plurality of drop-down lists and the content corresponding to each drop-down list.

A receiving submodule 7022 is configured to receive a selection instruction of a user for a plurality of drop-down lists.

A determining submodule 7023 is configured to determine a target drop-down list according to the selection instruction.

As an alternative implementation manner of the embodiment of the present invention, based on the device structure of fig. 15, as shown in fig. 17, a processing device for an electronic table of the embodiment of the present invention may further include:

A generating module 801, configured to generate a first drop-down list by using contents of cells having the same contents in the electronic form to be processed.

A first adding module 802 is configured to add the first drop-down list to the drop-down list template.

As an optional implementation manner of the embodiment of the present invention, the generating module 801 is specifically configured to:

As an alternative implementation manner of the embodiment of the present invention, as shown in fig. 18, the generating module 801 specifically includes:

the first obtaining submodule 8011 is configured to obtain contents of cells with the same contents in the target column or the target row.

The first extraction submodule 8012 is configured to extract, for the acquired content, content whose occurrence number exceeds a preset number threshold.

A first composition sub-module 8013 for composing the extracted content into a first drop-down list.

As an alternative implementation manner of the embodiment of the present invention, based on the device structure of fig. 15, as shown in fig. 19, a processing device for an electronic table of the embodiment of the present invention may further include:

A second obtaining module 901, configured to obtain a drop-down list in a drop-down list template by using a drop-down list in a pre-generated electronic form.

As an alternative implementation manner of the embodiment of the present invention, as shown in fig. 20, the second obtaining module 901 specifically includes:

a second obtaining sub-module 9011, configured to obtain a pre-generated pull-down list and contents in the pre-generated pull-down list;

A second extraction sub-module 9012, configured to extract, from the contents in the pull-down list generated in advance, contents whose occurrence number exceeds a preset number threshold;

A second composition sub-module 9013 for composing the extracted content into a second pull-down list;

a first add submodule 9014 for adding the second drop-down list to the drop-down list template.

As an alternative implementation manner of the embodiment of the present invention, based on the device structure of fig. 15, as shown in fig. 21, a processing device for an electronic table of the embodiment of the present invention may further include:

And a third obtaining module 1001, configured to obtain a drop-down list in the drop-down list template by using the user-defined content input by the user.

As an alternative implementation manner of the embodiment of the present invention, as shown in fig. 22, the third obtaining module 1001 specifically includes:

a third obtaining submodule 10011, configured to obtain user-defined content input by a user;

A third composition sub-module 10012, configured to compose the custom content into a third drop-down list;

A second add submodule 10013 for adding the third drop-down list to the drop-down list template.

As an alternative implementation manner of the embodiment of the present invention, based on the device structure of fig. 15, as shown in fig. 23, a processing device for an electronic table of the embodiment of the present invention may further include:

A fourth obtaining module 1101, configured to obtain a history drop-down list in the electronic form to be processed, where the history drop-down list is a drop-down list pre-stored in the electronic form to be processed;

a second adding module 1102 is configured to add the history drop-down list to the drop-down list template.

The electronic form processing device provided by the embodiment of the invention can firstly acquire the electronic form to be processed, wherein the electronic form to be processed is provided with the pull-down list template, the pull-down list template is provided with pull-down lists with different contents, then a selection instruction of a user is received to determine the target pull-down list and the target setting unit cell, and the target pull-down list is set in the target setting unit cell. Because the content of the drop-down list in the drop-down list template is determined, the user does not need to send a determining instruction for a plurality of times, so that the operation difficulty of the user is reduced, and the problem of poor user experience is solved.

The embodiment of the invention also provides an electronic device, as shown in fig. 24, which comprises a processor 1201, a communication interface 1202, a memory 1203 and a communication bus 1204, wherein the processor 1201, the communication interface 1202 and the memory 1203 are used for completing the communication between each other through the communication bus 1204, and the memory 1203 is used for storing a computer program;

the processor 1201, when executing the program stored in the memory 1203, performs the following steps:

Acquiring an electronic form to be processed; receiving a selection instruction of a user for a drop-down list in a drop-down list template to obtain a target drop-down list, wherein different drop-down list contents are displayed in different drop-down lists; receiving a selection instruction of a user for cells in the electronic form to be processed, and obtaining target setting cells; the contents in the target drop-down list are set into the target setting cell.

The communication bus mentioned above for the electronic device may be a peripheral component interconnect standard (PERIPHERAL COMPONENT INTERCONNECT, PCI) bus or an extended industry standard architecture (Extended Industry Standard Architecture, EISA) bus, etc. The communication bus may be classified as an address bus, a data bus, a control bus, or the like. For ease of illustration, the figures are shown with only one bold line, but not with only one bus or one type of bus.

The communication interface is used for communication between the electronic device and other devices.

The Memory may include random access Memory (Random Access Memory, RAM) or may include Non-Volatile Memory (NVM), such as at least one disk Memory. Optionally, the memory may also be at least one memory device located remotely from the aforementioned processor.

The processor may be a general-purpose processor, including a central processing unit (Central Processing Unit, CPU), a network processor (Network Processor, NP), etc.; but may also be a digital signal processor (DIGITAL SIGNAL Processing, DSP), application SPECIFIC INTEGRATED Circuit (ASIC), field-Programmable gate array (Field-Programmable GATE ARRAY, FPGA) or other Programmable logic device, discrete gate or transistor logic device, discrete hardware components.

According to the electronic equipment provided by the embodiment of the invention, the electronic form to be processed can be acquired first, the electronic form to be processed is provided with the pull-down list template, the pull-down list template is provided with the pull-down lists with different contents, then the target pull-down list and the target setting unit cell are determined by receiving the selection instruction of the user, and the target pull-down list is set in the target setting unit cell. Because the content of the drop-down list in the drop-down list template is determined, the user does not need to send a determining instruction for a plurality of times, so that the operation difficulty of the user is reduced, and the problem of poor user experience is solved.

In yet another embodiment of the present invention, a computer readable storage medium is provided, in which a computer program is stored, which when executed by a processor, implements the steps of a processing method of any one of the electronic devices described above.

The computer readable storage medium provided by the embodiment of the invention can firstly acquire the electronic form to be processed, wherein the electronic form to be processed is provided with the pull-down list template, the pull-down list template is provided with pull-down lists with different contents, then a selection instruction of a user is received to determine the target pull-down list and the target setting unit cell, and the target pull-down list is set in the target setting unit cell. Because the content of the drop-down list in the drop-down list template is determined, the user does not need to send a determining instruction for a plurality of times, so that the operation difficulty of the user is reduced, and the problem of poor user experience is solved.

For the apparatus, electronic device and storage medium embodiments, the description is relatively simple as it is substantially similar to the method embodiments, and reference should be made to the description of the method embodiments for relevant points. It should be noted that, the device and the storage medium according to the embodiments of the present invention are the device and the storage medium applying the above-mentioned method for processing an electronic form, respectively, so all embodiments of the above-mentioned method for processing an electronic form are applicable to the device and the storage medium, and the same or similar beneficial effects can be achieved.

It is noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.

In this specification, each embodiment is described in a related manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for the apparatus, electronic device and storage medium embodiments, since they are substantially similar to the method embodiments, the description is relatively simple, and references to the parts of the description of the method embodiments are only needed.

The foregoing description is only of the preferred embodiments of the present invention and is not intended to limit the scope of the present invention. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention are included in the protection scope of the present invention.

Claims

1. A method of processing a spreadsheet, the method comprising:

Acquiring an electronic form to be processed;

Displaying a pull-down list template, wherein the pull-down list template comprises pull-down lists and contents corresponding to the pull-down lists, and different pull-down list contents are displayed in different pull-down lists;

receiving a selection instruction of a user for the drop-down list, and obtaining a target drop-down list according to the selection instruction;

Setting the content in the target drop-down list into the target setting cell;

The method further comprises the steps of:

Acquiring the content of cells with the same content in a target column or a target row in the electronic form to be processed;

combining the extracted content into a first drop-down list;

adding the first drop-down list to the drop-down list template;

or the method further comprises:

acquiring a pre-generated pull-down list and contents in the pre-generated pull-down list;

Combining the extracted content into a second drop-down list;

the second drop-down list is added to the drop-down list template.

2. The method of claim 1, wherein after the obtaining the electronic form to be processed, the method further comprises:

The first drop-down list is added to the drop-down list template.

3. The method of claim 2, wherein the step of generating the first drop-down list using contents of cells having the same contents in the electronic form to be processed comprises:

4. A method according to claim 3, wherein the step of generating a first drop-down list using a target column or a target row in the electronic form to be processed comprises:

the extracted content is composed as the first drop-down list.

5. The method of claim 1, wherein prior to the obtaining the pending spreadsheet, the method further comprises:

6. The method of claim 5, wherein the step of obtaining the drop down list in the drop down list template using the user-entered custom content comprises:

Acquiring the user-defined content input by a user;

the custom content is composed into a third drop-down list;

The third drop-down list is added to the drop-down list template.

7. The method of claim 1, wherein after the obtaining the electronic form to be processed, the method further comprises:

the history drop-down list is added to the drop-down list template.

8. An apparatus for processing a spreadsheet, the apparatus comprising:

The first receiving module is used for displaying a pull-down list template, wherein the pull-down list template comprises pull-down lists and contents corresponding to the pull-down lists, and different pull-down list contents are displayed in different pull-down lists; receiving a selection instruction of a user for the drop-down list, and obtaining a target drop-down list according to the selection instruction;

a setting module, configured to set the content in the target drop-down list into the target setting cell;

The apparatus further comprises:

A third adding module, configured to obtain contents of cells with the same contents in a target column or a target row in the electronic form to be processed; extracting the content with occurrence times exceeding a preset time threshold for the acquired content; combining the extracted content into a first drop-down list; adding the first drop-down list to the drop-down list template;

Or the device further comprises:

The second acquisition module is used for acquiring a pre-generated pull-down list and contents in the pre-generated pull-down list; extracting content with occurrence times exceeding a preset time threshold from the content in the pre-generated pull-down list; combining the extracted content into a second drop-down list; the second drop-down list is added to the drop-down list template.

9. The apparatus of claim 8, wherein the apparatus further comprises:

10. The apparatus according to claim 9, wherein the generating module is specifically configured to:

11. The apparatus of claim 10, wherein the generating module comprises:

12. The apparatus of claim 8, wherein the apparatus further comprises:

13. The apparatus of claim 12, wherein the third acquisition module comprises:

14. The apparatus of claim 8, wherein the apparatus further comprises:

A fourth obtaining module, configured to obtain a history drop-down list in the electronic form to be processed, where the history drop-down list is a drop-down list stored in advance in the electronic form to be processed;

15. An electronic device, comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory are in communication with each other through the communication bus;

The memory is used for storing a computer program;

the processor being adapted to implement the method of any of claims 1-7 when executing a computer program stored on a memory.

16. A computer readable storage medium, characterized in that the computer readable storage medium has stored therein a computer program which, when executed by a processor, implements the method of any of claims 1-7.