Automatic filling method and device, electronic equipment and medium

Abstract

This application provides an autofill method, apparatus, electronic device, and medium. The method includes: in response to a selection operation on a target area in a table, determining a target area; the target area includes multiple table areas, each table area including a header and at least one cell, the content of which is used to fill the header content; based on the header, determining an autofill task for the target area; based on the autofill task and the content of a first table area in the target area, obtaining the content or content calculation formula of a second table area in the target area, and filling the obtained content or content calculation formula into the cells of the second table area. According to this application, an autofill task for the target area can be determined based on the header, and the associated second table area can be automatically filled based on the content already filled in the first table area. This method is simple to process, has a low operational threshold, significantly reduces the probability of errors, saves input time, and significantly improves filling efficiency.

Description

Technical Field

[0001] Embodiments of this disclosure relate to the field of computer technology, and more specifically, embodiments of this disclosure relate to automatic filling methods, apparatus, electronic devices, and media. Background Technology

[0002] This section is intended to provide background or context for the embodiments of this disclosure as set forth in the claims. The description herein is not intended to be a prior art simply because it is included in this section.

[0003] When filling out forms, we often need to fill in blank cells by manually entering information or manually entering formulas based on known data.

[0004] The above methods require knowledge of formulas and functions, are relatively cumbersome to operate, are prone to errors, and take a long time when the data volume is large, so they are inefficient and have a certain professional threshold. Summary of the Invention

[0005] In view of the above, embodiments of this disclosure provide the following automatic filling methods, apparatus, electronic devices and media to achieve automatic filling of specific content.

[0006] According to a first aspect of the present disclosure, an automatic fill method is provided, the method comprising:

[0007] In response to a selection operation on a target area in a table, the target area is determined; the target area includes multiple table areas, each table area including a table header and at least one cell, the content of which is used to fill the content of the table header.

[0008] Based on the table header, determine the automatic fill task for the target area;

[0009] Based on the autofill task and the content of the first table area in the target area, the content or content calculation formula of the second table area in the target area is obtained, and the obtained content or content calculation formula is filled into the cells of the second table area.

[0010] In some implementations, the automatic fill task of determining the target area based on the table header includes:

[0011] In response to the selection operation of the autofill task for the header, the autofill task table is searched to obtain the autofill task that matches the header in the target area; the autofill task table includes at least one autofill task item, and the autofill task item includes header information and an identifier of the autofill task corresponding to the header information.

[0012] In some implementations, the header information in the autofill task item includes data item information and item information to be filled;

[0013] The step of finding the autofill task table and obtaining the autofill task that matches the table header in the target area includes:

[0014] If a header exists that matches both the data item information and the field to be filled in the header information, the autofill task indicated by the identifier corresponding to the header information is determined to be the autofill task of the target area; the table area where the header that matches the data item information is located is determined to be the first table area; and the table area where the header that matches the field to be filled is determined to be the second table area.

[0015] In some implementations, after determining the target area, the method further includes:

[0016] Receive content filling instruction information, the instruction information including an identifier of the autofill task;

[0017] The autofill task indicated by the identifier is determined to be the autofill task of the target area, and the first table area and the second table area related to the autofill task are determined in the target area.

[0018] In some implementations, after determining the target area, the method further includes:

[0019] Receive parameters related to the automatic filling task for the target area;

[0020] The parameters include:

[0021] Parameters used to characterize the association relationship between at least two of the headers in the target region; and / or,

[0022] A parameter used to indicate whether the cell in the second table area is filled with content or a content calculation formula; and / or,

[0023] Parameters used to indicate the first table area and / or the second table area in the target area.

[0024] In some implementations, obtaining the content or content calculation formula of the second table area in the target area includes:

[0025] Based on the autofill task of the target area, the association database is searched to obtain the association relationship between the header of the first table area and the header of the second table area;

[0026] Based on the aforementioned relationship and the content already filled in the first table area, the content of the second table area or the content calculation formula is obtained.

[0027] In some implementations, when the table area is a column area, the column header of the column area is the table header of the table area;

[0028] Alternatively, if the table area is a row area, the row header of the row area is the table header of the table area.

[0029] According to a second aspect of the present disclosure, an automatic filling apparatus is provided, the apparatus comprising:

[0030] A target area selection unit is configured to determine the target area in response to a selection operation on a target area in a table; the target area includes multiple table areas, each table area including a header and at least one cell, the content of which is used to fill the content of the header;

[0031] A task identification unit is used to determine the automatic fill task of the target area based on the table header;

[0032] The content filling unit is used to obtain the content or content calculation formula of the second table area in the target area based on the automatic filling task and the content of the first table area in the target area, and to fill the obtained content or content calculation formula into the cell of the second table area.

[0033] According to a third aspect of the present disclosure, an electronic device is provided, the device including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the autofill method as described above.

[0034] According to a fourth aspect of the present disclosure, a computer-readable storage medium is provided, on which a program is stored, the program being executed by a processor of the operations performed by the autofill method as described above.

[0035] According to a fifth aspect of the present disclosure, a computer program product is provided, including a computer program that, when executed by a processor, implements the operations performed by the autofill method as described above.

[0036] The various embodiments of this disclosure automatically fill in other related content based on the already filled content according to the automatic fill task corresponding to the target area. This process is simple, has a low operating threshold, significantly reduces the probability of errors, saves input time, and significantly improves filling efficiency. Attached Figure Description

[0037] The above and other objects, features, and advantages of this disclosure will become readily apparent from the following detailed description of exemplary embodiments, taken in conjunction with the accompanying drawings. Several embodiments of this disclosure are illustrated in the drawings by way of example and not limitation, in which:

[0038] Figure 1 A flowchart illustrating an automatic fill method according to an embodiment of the present disclosure is shown.

[0039] Figures 2(a) and 2(b) illustrate schematic diagrams of autofill content according to an exemplary embodiment of this application.

[0040] Figures 3(a) and 3(b) illustrate schematic diagrams of autofill content according to an exemplary embodiment of this application.

[0041] Figures 4(a) and 4(b) illustrate schematic diagrams of autofill content according to an exemplary embodiment of this application.

[0042] Figures 5(a), 5(b) and 5(c) illustrate schematic diagrams of autofill content according to an exemplary embodiment of this application.

[0043] Figure 6 A structural block diagram of an automatic filling device according to an embodiment of this application is shown.

[0044] Figure 7 A schematic diagram of the structure of an electronic device according to an exemplary embodiment of this application is shown.

[0045] In the accompanying drawings, the same or corresponding reference numerals indicate the same or corresponding parts. Detailed Implementation

[0046] The principles and spirit of this disclosure will now be described with reference to several exemplary embodiments. It should be understood that these embodiments are given merely to enable those skilled in the art to better understand and implement this disclosure, and are not intended to limit the scope of this disclosure in any way. Rather, these embodiments are provided to make this disclosure more thorough and complete, and to fully convey the scope of this disclosure to those skilled in the art.

[0047] Those skilled in the art will recognize that embodiments of this disclosure can be implemented as a system, apparatus, device, method, or computer program product. Therefore, this disclosure can be specifically implemented in the following forms: entirely hardware, entirely software (including firmware, resident software, microcode, etc.), or a combination of hardware and software.

[0048] It is important to understand in this article that the number of any content blocks in the accompanying figures is for illustrative purposes only and not as a limitation, and that any naming is for distinction only and has no limiting meaning.

[0049] The principles and spirit of this disclosure will be explained in detail below with reference to several representative embodiments.

[0050] Figure 1 A flowchart illustrating an autofill method according to an embodiment of this application is shown. This method can be applied to various tabular documents. For example... Figure 1 As shown, the method includes steps 101 to 103.

[0051] Step 101: In response to a selection operation on a target area in a table, determine the target area; the target area includes multiple table areas, each table area including a header and at least one cell, the content of which is used to fill the content of the header.

[0052] In some possible implementations, when the table area is a column area, the column header of the column area is the table header of the table area. That is, one table area is one column area, and the column header is the table header of the corresponding table area. For example, the column header of the first table area is the table header of the first table area, and the column header of the second table area is the table header of the second table area.

[0053] In some other possible implementations, when the table area is a row area, the row header of the row area is the table header of the table area. That is, one table area is one row area, and the row header is the table header of the corresponding table area. For example, the row header of the first table area is the table header of the first table area, and the row header of the second table area is the table header of the second table area.

[0054] The selection of a target area in a table can be performed by the user using a mouse, touchscreen, keyboard input, voice input, or other methods.

[0055] In other possible implementations, the content of the aforementioned cells and the content of the table headers can be data or calculation formulas, etc.

[0056] Step 2: Based on the table header, determine the autofill task for the target area.

[0057] The autofill task is used to fill another portion of the table area (referred to as the second table area) in the target area based on a portion of the table area (referred to as the first table area in this document).

[0058] For example, after selecting a target area, users can further trigger a list of operations for that selected area. This could be done by right-clicking after selecting the target area to display the operation list, and then clicking "Autofill" in the list to issue an autofill instruction. Users can also directly trigger the "Autofill" control in the command bar at the top of the document to issue an autofill instruction. Users can also issue autofill instructions via voice commands, and so on. The system can respond to user autofill instructions and activate the autofill function.

[0059] In some possible implementations, an autofill task table can be searched to obtain autofill tasks that match the header in the target area. The autofill task table includes at least one autofill task item, and each autofill task item includes header information and an identifier for the autofill task corresponding to the header information. The identifier for the autofill task can be any information that can uniquely identify different autofill tasks, such as the name of the autofill task.

[0060] In some possible implementations, the header information in the autofill task includes data item information and field information to be filled. During the search, if a header that matches both the data item information and the field information to be filled exists simultaneously, the autofill task indicated by the identifier corresponding to the header information is determined as the autofill task for the target area; the table area containing the header that matches the data item information is determined as the first table area; and the table area containing the header that matches the field information to be filled is determined as the second table area.

[0061] An example is provided to illustrate this. For instance, a target area includes a table area with the header "ID Number", a table area with the header "Gender", and a table area with the header "Date of Birth". The created autofill task table includes the following autofill task items: the autofill task is identified as "Identity Information Supplement", the data item information is "ID Information", and the items to be filled are "Gender Information, Birthday Information, Age Information".

[0062] In one example, the autofill task table can be searched. If it is determined that the target area contains both a header "ID number" that matches the data item "ID information" and a header "gender" and "date of birth" that match the data item "gender information, birthday information, age information", then the autofill task indicated by the "identity information supplement" label in the autofill task item is determined to be the autofill task of the target area. The table area containing the header "ID number" that matches the data item "ID information" is determined to be the first table area, and the table areas containing the headers "gender" and "date of birth" that match the data item "gender information, birthday information, age information" are determined to be the second table area.

[0063] As can be seen from the above examples, there may be more than one first table area or second table area in an autofill task. The first table area and the second table area are not necessarily in a one-to-one relationship. In this example, the autofill task "Identity Information Fill" has one first table area and two second table areas. The contents of the two second table areas are filled based on the contents of the first table area.

[0064] As can be seen from the above examples, those skilled in the art can set rules as needed to determine whether the table header matches the data item information or the information to be filled.

[0065] In some cases, a perfect match between the table header and the data item information or the information to be filled in may not be necessary for a match to be determined. For example, in the example above, the header "ID number" and the data item information "ID information" string are not exactly the same. Those skilled in the art can set matching rules according to specific circumstances. For example, they can first extract the keywords (e.g., "ID card") of each item, and then determine whether they match based on the keywords. For example, they can set a fuzzy matching principle, or they can set a set of matching information, where items belonging to the same set can be judged as matches, and so on.

[0066] In some cases, it may not be necessary for the table header to include all data items or information to be filled in in order to determine a match. For example, in the example above, the table header "Gender" is directly related to the information segment "Gender Information" in the information segment "Gender Information, Birthday Information, Age Information" to be filled in, but not directly related to the information segments "Birthday Information" and "Age Information". However, it is still possible to determine that the table header "Gender" matches the information segment "Gender Information, Birthday Information, Age Information" to be filled in, and that the table header "Date of Birth" matches the information segment to be filled in, and so on.

[0067] In another example, suppose a target area includes a table area with the header "ID Number", a table area with the header "Gender", and a table area with the header "Date of Birth". Suppose the created autofill task table includes the following two autofill task items: First, the autofill task is identified as "Gender Information Fill", the data item information is "ID Number Information", and the information to be filled is "Gender Information"; Second, the autofill task is identified as "Birthday Information Fill", the data item information is "ID Number Information", and the information to be filled is "Birthday Information".

[0068] When searching the aforementioned autofill task table, it can be determined that there are two autofill tasks in the target area: "Gender Information Fill" and "Birthday Information Fill". For the former, the table area containing the header "ID Number" is determined as the first table area, and the table area containing the header "Gender" is determined as the second table area; for the latter, the table area containing the header "ID Number" is determined as the first table area, and the table area containing the header "Date of Birth" is determined as the second table area.

[0069] As can be seen from this example, there may be more than one autofill task for the identified target area. For example, in this example, there are two autofill tasks for the target area.

[0070] This example also demonstrates that different autofill tasks can involve the same table area. In this example, the first table area in both the "Gender Information Fill" and "Birthday Information Fill" autofill tasks is the table area containing the header "ID Number".

[0071] Those skilled in the art can construct an autofill task table based on the inherent logical relationship between the content and specific needs, set matching judgment rules, and store the autofill task table in a database.

[0072] In some implementations, after identifying the autofill task for the target area, a prompt message can be displayed to request the user to further confirm whether the identified autofill task is the desired one. Subsequently, confirmation information from the user can be received. If the confirmation message indicates that the identified autofill task is the desired one, subsequent steps can continue, i.e., autofilling is performed based on the identified autofill task. If the confirmation message indicates that the identified autofill task is not the desired one, the identified autofill task can be abandoned, and identification can be repeated, or the user can be asked to indicate the desired autofill task, and so on.

[0073] Step 103: Based on the content of the first table area in the target area and the automatic fill task, obtain the content or content calculation formula of the second table area in the target area, and fill the obtained content or content calculation formula into the cells of the second table area.

[0074] In some implementations, the association database can be searched based on the autofill task of the target area to obtain the association between the headers of the first table area and the headers of the second table area; and based on the association and the content already filled in the first table area, the content or content calculation formula of the second table area can be obtained.

[0075] The relationship database can store the identifier of the autofill task and the relationship between the headers of the first table area and the headers of the second table area in the autofill task. Those skilled in the art can construct the relationship database as needed.

[0076] This relationship can be a formula for calculating the content of the header of the second table area based on the header of the first table area. Those skilled in the art will understand that this content calculation formula can be an algorithm function, etc. The content already filled in the first table area can be substituted into the above content calculation formula, and the calculation result can be directly filled into the corresponding cell in the second table area. In this case, if the content of the cells in the first table area changes subsequently, the content of the corresponding cells in the second table area usually will not be updated accordingly. If it is necessary to update the content in the second table area, the second table area can be refreshed by executing the above autofill method again.

[0077] Alternatively, the above calculation formulas can be filled into the cells of the second table area. In this case, if the content of the cells in the first table area changes subsequently, the content of the corresponding cells in the second table area will be automatically updated accordingly.

[0078] When calculating the content of cells in the second table area based on the content of cells in the first table area, if some cells in the first table area are not yet filled, these cells can be skipped and the corresponding cells in the second table area are not calculated. Alternatively, a prompt message can be displayed, prompting the user to fill in or load content into blank cells in the first table area in real time. If the user fills in content into a blank cell, the corresponding cells in the second table area are calculated. If the user indicates that they will not fill in content for the time being, the blank cell is skipped and the corresponding cells in the second table area are not calculated, and so on.

[0079] In the above embodiments, based on the automatic fill task of the target area and the content already filled in some table areas, the content of other related table areas is automatically filled. The process is simple, the operation threshold is low, and it can significantly reduce the probability of errors and improve the filling efficiency.

[0080] In some implementations, after determining the target area, the method further includes: receiving content filling instruction information, the instruction information including an identifier of the autofill task; determining that the autofill task indicated by the identifier is an autofill task for the target area, and determining a first table area and a second table area related to the autofill task in the target area.

[0081] In some cases, if the autofill task for the target area cannot be directly identified from the table header, the user may be asked to instruct the autofill task for the target area, and the autofill task for the target area, as well as the first table area and the second table area in the target area, may be determined based on the received instruction information.

[0082] In some examples of this implementation, after determining the target area, the method further includes: receiving parameters related to the autofill task of the target area; the parameters include: parameters for characterizing the association between at least two headers in the target area; and / or, parameters for indicating whether the cells in the second table area are filled with content or a calculation formula for the content; and / or, parameters for indicating the first table area and / or the second table area in the target area.

[0083] Parameters can characterize the relationships between at least two headers in the target area. For example, users can pass formulas, algorithm codes, etc., that reflect the logical relationships between different headers as parameters to the table editor; they can also import charts, etc., that represent the mapping relationships between different headers into the table editor, and so on.

[0084] The parameter can be a Boolean parameter that indicates the type of fill. For example, if the Boolean parameter takes the first value, the result will be filled into the cells of the second table area; if the Boolean parameter takes the second value, the calculated formula will be filled into the cells of the second table area, and so on.

[0085] The parameters can also be used to indicate which / which table areas in the target area are the first table area and / or which / which table areas are the second table area.

[0086] The parameters associated with the autofill task can be mathematical formulas, algorithm code, charts, Boolean data, strings, logical expressions, and so on.

[0087] Figures 2(a) and (b) illustrate an automatic content filling method according to an exemplary embodiment of this application. Figure 2(a) is a schematic diagram of the selected target area, where each column is a table area and the column header is the table header.

[0088] The headers in this target area include "Name", "Gender", "ID Card Number", "Birthday", and "Age".

[0089] Based on these headers, the autofill task table can be located, and the autofill task identifier for the target area can be determined as "Identity Information Supplement". The first table area can be determined as the "ID Card" column, and the second table area can be determined as the "Gender", "Birthday" and "Age" columns.

[0090] Based on the "Identity Information Supplement" identifier of the autofill task, the system searches the relational database to obtain the data calculation formulas for calculating "Gender," "Birthday," and "Age" based on the "ID Card" information. These formulas are then filled into the corresponding cells in the "Gender," "Birthday," and "Age" columns, respectively. The autofill result is shown in Figure 2(b).

[0091] In this case, the corresponding data calculation formula is filled into the second table area. When the data in the first table area changes, the data in the second table area will be updated accordingly. For situations that require synchronous data updates, this can significantly reduce table maintenance costs and also help avoid errors caused by oversights.

[0092] Figures 3(a) and (b) illustrate an automatic data filling diagram according to an exemplary embodiment of this application. Figure 3(a) is a schematic diagram of the selected target area, with each column representing a table area and the column header being the table header.

[0093] The header of this target area includes "Employee ID", "Name", "Date of Joining", and "Length of Service".

[0094] Based on these headers, the autofill task table can be located, and the autofill task corresponding to the target area can be determined as "Supplementing Seniority Information". The first table area can be determined as the "Date of Employment" column, and the second table area can be determined as the "Seniority" column.

[0095] Users can provide confirmation information to further confirm that the "Seniority Information Supplement" task is the desired autofill task.

[0096] Based on the autofill task's identifier "Supplementing Seniority Information," the system searches the relational database to obtain the data calculation formula for calculating "Seniority" based on "Job Start Date" data. This formula is then filled into the corresponding cells in the "Seniority" column. The autofill result is shown in Figure 3(b).

[0097] Figures 4(a) and (b) illustrate an automatic data filling diagram according to an exemplary embodiment of this application. Figure 4(a) is a schematic diagram of the selected target area, with each column representing a table area and the column header being the table header.

[0098] The header of the target area includes "Name", "Score", and "Rank".

[0099] Based on these headers, the autofill task table can be located, and the autofill task corresponding to the target area can be determined as "Ranking Information Supplement". The first table area can be determined as the "Score" column, and the second table area can be determined as the "Ranking" column.

[0100] Users can provide confirmation information to further confirm that the "Ranking Information Supplement" task is the desired autofill task.

[0101] Based on the autofill task's identifier "Ranking Information Supplement," the system searches a relational database to obtain the data calculation formula for calculating the "Rank" data based on the "Score" data. The rank obtained using this formula is then filled into the corresponding cells in the "Rank" column. The autofill result is shown in Figure 4(b).

[0102] In this example, the data filled into the cells of the second table area is the ranking result, not the ranking calculation formula. When the data in the "Score" column changes, the "Ranking" column will not update automatically. In this case, you can run the autofill task "Ranking Information Supplement" again for the target area to update the "Ranking" column.

[0103] Figures 5(a), (b), and (c) illustrate a schematic diagram of automatically populated data according to an exemplary embodiment of this application. Figure 5(a) is a schematic diagram of the selected target area, with each column representing a table area and the column header serving as the table header.

[0104] The header of this target area includes "Employee ID", "Name", "Work Order Number", "Status", "Position", and "Level".

[0105] Based on these headers, the autofill task table is queried, but no autofill task for the target area is found. At this point, a dialog box can pop up, requesting the user to specify the autofill task for the target area.

[0106] The system can receive instructions from the user in response to the aforementioned request. These instructions include an identifier for the auto-fill task, such as the task name. In this example, the user also provides parameters related to the instructed task "Associated Data Fill," namely the "Basic Information Table" shown in Figure 5(b). The "Basic Information Table" shows the relationships between "Employee ID" and "Name," "Employee ID" and "Job Title," and "Employee ID" and "Level."

[0107] The instruction indicates that the autofill task is "related data fill". Combined with the "basic information table" related to the task and the header of the target area, the first table area can be determined as the "employee ID" column, and the second table area can be determined as the "name", "position", and "level" columns.

[0108] The system can query the relational database, extract the algorithm template corresponding to the task "Related Data Filling", and input the relational data given in the "Basic Information Table" to obtain the data calculation formulas for the "Name", "Position", and "Level" columns, and then fill them into the corresponding cells.

[0109] Taking the "Name" column as an example, the process of obtaining the data calculation formula is illustrated. This table component itself provides the VLOOKUP function for related data lookup. The VLOOKUP algorithm template can be extracted from the relational database, and the column headers of the target area in the "Business Table" and the information in the "Basic Information Table" are scanned. The resulting formula for the "Name" column is "=VLOOKUP(Business Table Employee ID Cell, Basic Information Table Range, Name Column Number, Exact Match)", which is then filled into the corresponding cell in the "Name" column. The autofill result of this example is shown in Figure 5(c).

[0110] Figure 6 A structural block diagram of an apparatus for automatically filling in data according to an embodiment of this application is shown. Figure 6 As shown, the device includes a target area selection unit 601, a task identification unit 602, and a data filling unit 603.

[0111] The target area selection unit 601 is used to determine the target area in response to a selection operation on a target area in a table; the target area includes multiple table areas, each table area including a table header and at least one cell, the content of which is used to fill the content of the table header.

[0112] The task identification unit 602 is used to determine the automatic fill task of the target area based on the table header.

[0113] The content filling unit 603 is used to obtain the content or content calculation formula of the second table area in the target area based on the automatic filling task and the content of the first table area in the target area, and to fill the obtained content or content calculation formula into the cells of the second table area.

[0114] For the device embodiments, since they basically correspond to the method embodiments, the relevant parts can be referred to in the description of the method embodiments. The device embodiments described above are merely illustrative. The modules described as separate components may or may not be physically separate, and the components shown as modules may or may not be physical modules, that is, they may be located in one place or distributed across multiple network modules. Some or all of the modules can be selected to achieve the purpose of the solution in this specification according to actual needs. Those skilled in the art can understand and implement this without creative effort.

[0115] This specification also provides an electronic device, see [link to documentation] Figure 7 , Figure 7 A schematic diagram of the structure of an electronic device according to an exemplary embodiment of this application is shown. Figure 7As shown, the terminal includes a processor 710, a memory 720, and a network interface 730. The memory 720 stores computer instructions that can run on the processor 710. The processor 710 is used to implement the autofill method provided in any embodiment of this application when executing the computer instructions. The network interface 730 is used to implement input / output functions. In more possible implementations, the electronic device may also include other hardware, which is not limited in this application.

[0116] This specification also provides a computer-readable storage medium, which can take many forms, such as RAM (Random Access Memory), volatile memory, non-volatile memory, flash memory, storage drive (e.g., hard disk drive), solid-state drive, any type of storage disk (e.g., optical disc, DVD, etc.), or similar storage media, or combinations thereof. Specifically, the computer-readable medium can also be paper or other suitable media capable of printing programs. A computer program is stored on the computer-readable storage medium, which, when executed by a processor, implements the autofill method provided in any embodiment of this application.

[0117] This specification also provides a computer program product, including a computer program that, when executed by a processor, implements the autofill method provided in any embodiment of this application.

[0118] Those skilled in the art will understand that one or more embodiments of this specification can be provided as a method, apparatus, electronic device, computer-readable storage medium, or computer program product. Therefore, one or more embodiments of this specification can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, one or more embodiments of this specification can take the form of a computer program product implemented on one or more computer-readable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-readable program code.

[0119] The various embodiments in this specification are described in a progressive manner. Similar or identical parts between embodiments can be referred to interchangeably. Each embodiment focuses on its differences from other embodiments. In particular, the embodiments corresponding to the terminal are basically similar to the method embodiments, so the description is relatively simple; relevant parts can be referred to the descriptions of the method embodiments.

[0120] The foregoing has described specific embodiments of this specification. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims may be performed in a different order than that shown in the embodiments and may still achieve the desired result. Furthermore, the processes depicted in the drawings do not necessarily require the specific or sequential order shown to achieve the desired result. In some embodiments, multitasking and parallel processing are possible or may be advantageous.

[0121] The embodiments of the subject matter and functional operation described in this specification can be implemented in the following ways: digital electronic circuits, tangibly embodied computer software or firmware, computer hardware including the structures disclosed in this specification and their structural equivalents, or combinations thereof. Embodiments of the subject matter described in this specification can be implemented as one or more computer programs, i.e., one or more modules of computer program instructions encoded on a tangible, non-transitory program carrier for execution by a data processing apparatus or for controlling the operation of a data processing apparatus. Alternatively or additionally, the program instructions may be encoded on artificially generated propagation signals, such as machine-generated electrical, optical, or electromagnetic signals, which are generated to encode information and transmit it to a suitable receiving device for execution by the data processing apparatus. The computer storage medium may be a machine-readable storage device, a machine-readable storage substrate, a random or serial access memory device, or combinations thereof.

[0122] The processing and logic flow described in this specification can be executed by one or more programmable computers that execute one or more computer programs to perform corresponding functions by operating on input data and generating output. The processing and logic flow can also be executed by dedicated logic circuitry—such as FPGAs (Field-Programmable Gate Arrays) or ASICs (Application-Specific Integrated Circuits), and the device can also be implemented as dedicated logic circuitry.

[0123] Suitable computers for executing computer programs include, for example, general-purpose and / or special-purpose microprocessors, or any other type of central processing unit. Typically, the central processing unit receives instructions and data from read-only memory and / or random access memory. The basic components of a computer include a central processing unit for implementing or executing instructions and one or more memory devices for storing instructions and data. Typically, a computer will also include one or more mass storage devices for storing data, such as disks, magneto-optical disks, or optical disks, or the computer will be operatively coupled to such mass storage devices to receive data from or transfer data to them, or both. However, a computer is not required to have such devices. Furthermore, a computer can be embedded in another device, such as a mobile phone, a personal digital assistant (PDA), a mobile audio or video player, a game console, a global positioning system (GPS) receiver, or a portable storage device such as a universal serial bus (USB) flash drive, to name a few.

[0124] Computer-readable media suitable for storing computer program instructions and data include all forms of non-volatile memory, media, and memory devices, such as semiconductor memory devices (e.g., EPROM, EEPROM, and flash memory devices), magnetic disks (e.g., internal hard disks or removable disks), magneto-optical disks, and CD-ROM and DVD-ROM disks. Processors and memory may be supplemented by or incorporated into dedicated logic circuitry.

[0125] While this specification contains numerous specific implementation details, these should not be construed as limiting the scope of any invention or the scope of the claims, but rather are primarily intended to describe features of specific embodiments of a particular invention. Certain features described in the various embodiments herein may also be implemented in combination in a single embodiment. Conversely, various features described in a single embodiment may also be implemented separately in various embodiments or in any suitable sub-combination. Furthermore, while features may function in certain combinations as described above and even initially claimed in this way, one or more features from a claimed combination may be removed from that combination in some cases, and a claimed combination may refer to a sub-combination or a variation thereof.

[0126] Similarly, although the operations are depicted in a specific order in the accompanying drawings, this should not be construed as requiring these operations to be performed in the specific order shown or sequentially, or requiring all illustrated operations to be performed to achieve the desired result. In some cases, multitasking and parallel processing may be advantageous. Furthermore, the separation of various system modules and components in the above embodiments should not be construed as requiring such separation in all embodiments, and it should be understood that the described program components and systems can generally be integrated together in a single software product or packaged into multiple software products.

[0127] Thus, specific embodiments of the subject matter have been described. Other embodiments are within the scope of the appended claims. In some cases, the actions recited in the claims may be performed in a different order and still achieve the desired result. Furthermore, the processes depicted in the drawings are not necessarily shown in a specific order or sequence to achieve the desired result. In some implementations, multitasking and parallel processing may be advantageous.

[0128] Other embodiments of this specification will readily occur to those skilled in the art upon consideration of the specification and practice of the invention claimed herein. This specification is intended to cover any variations, uses, or adaptations that follow the general principles of this specification and include common knowledge or customary techniques in the art not claimed herein. That is, this specification is not limited to the precise structures described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope.

[0129] The above description is merely an optional embodiment of this specification and is not intended to limit this specification. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of this specification shall be included within the scope of protection of this specification.

Claims

1. An automatic filling method, characterized in that, The method comprises: determining a target region in response to a selection operation on the target region in a table; the target region comprises a plurality of table regions, the table regions comprising a table header and at least one cell, the content of the cell being used to fill the content of the table header; determining an autofill task of the target region based on the table header, comprising: in response to a selection operation on the autofill task of the table header, searching an autofill task table to obtain an autofill task matching the table header in the target region; based on the autofill task and the content of the first table region in the target region, obtaining the content or a content calculation formula of the second table region in the target region, and filling the obtained content or content calculation formula in the cell of the second table region.

2. The method of claim 1, wherein, The autofill task table comprises at least one autofill task item, and the autofill task item comprises table header information and an identifier of an autofill task corresponding to the table header information.

3. The method of claim 2, wherein: The table header information in the autofill task item comprises data item information and to-be-filled item information; The searching of the autofill task table to obtain the autofill task matching the table header in the target region comprises: In the case where there are table headers matching both the data item information and the to-be-filled item information in the table header information, determining that the autofill task indicated by the identifier corresponding to the table header information is the autofill task of the target region, determining that the table region where the table header matching the data item information is located is the first table region, and determining that the table region where the table header matching the to-be-filled item information is located is the second table region.

4. The method of claim 1, wherein, After determining the target region, the method further comprises: receiving indication information of content filling, the indication information comprising an identifier of an autofill task; determining that the autofill task indicated by the identifier is the autofill task of the target region, and determining the first table region and the second table region related to the autofill task in the target region.

5. The method of claim 1, wherein, After determining the target region, the method further comprises: receiving a parameter related to the autofill task of the target region; The parameter comprises: a parameter for representing an association relationship between at least two table headers in the target region; and / or, a parameter for indicating whether to fill content or fill a content calculation formula in the cell of the second table region; and / or, a parameter for indicating the first table region and / or the second table region in the target region.

6. The method of claim 1, wherein, Obtaining the content or the content calculation formula of the second table region in the target region comprises: searching an association relationship library based on the autofill task of the target region to obtain an association relationship between the table header of the first table region and the table header of the second table region; based on the association relationship and the filled content in the first table region, obtaining the content or the content calculation formula of the second table region.

7. The method of claim 1, wherein: in a case where the table region is a column region, a column header of the column region is the table header of the table region; or in a case where the table region is a row region, a row header of the row region is the table header of the table region. The apparatus comprises:

8. An automatic filling device, characterized in that a target region selection unit configured to determine a target region in response to a selection operation on the target region, the target region comprising a plurality of table regions, each table region comprising a table header and at least one cell, content of the cell being used to fill content of the table header; a task identification unit configured to determine an autofill task of the target region based on the table header, comprising: in response to a selection operation on the autofill task of the table header, searching an autofill task table to obtain an autofill task matching the table header in the target region; a content filling unit configured to obtain content or a content calculation formula of a second table region in the target region based on the autofill task and content of a first table region in the target region, and fill the obtained content or the content calculation formula in the cell of the second table region. The device comprises a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor implements the autofill method of any one of claims 1 to 7 when executing the program.

9. An electronic device, comprising: The computer readable storage medium stores a program, and the program is executed by the processor to perform the operations of the autofill method of any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, ​

Images