CN108132922B - Automatic filling method and device based on form - Google Patents
Automatic filling method and device based on formDownload PDFInfo
- Publication number
- CN108132922B CN108132922BCN201611091609.XACN201611091609ACN108132922BCN 108132922 BCN108132922 BCN 108132922BCN 201611091609 ACN201611091609 ACN 201611091609ACN 108132922 BCN108132922 BCN 108132922B
- Authority
- CN
- China
- Prior art keywords
- filling
- area
- processing mode
- anchor point
- dragging
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
Translated fromChinese
Description
Translated fromChinese技术领域technical field
本发明涉及办公软件处理技术领域，尤其涉及一种基于表格的自动填充方法及装置。The invention relates to the technical field of office software processing, in particular to a form-based automatic filling method and device.
背景技术Background technique
表格作为办公软件中最重要的数据处理工具，能对大批量数据进行快速的处理和分析，给用户带来了极大的便利性。As the most important data processing tool in office software, tables can quickly process and analyze large quantities of data, bringing great convenience to users.
在表格中需要计算数据结果时，可以对每个单元格输入公式进行计算，但这样效率非常低下，在很多情况下通过表格的自动填充功能可以帮助用户快速输入公式。比如要计算一个班级里每个学生的各科总分时，只需要把一个学生的总分计算好，利用表格的自动填充功能就能把剩下的学生一次性计算出来，避免了重复的操作。When the data result needs to be calculated in the table, you can enter a formula for each cell to perform the calculation, but this is very inefficient. In many cases, the automatic filling function of the table can help users enter the formula quickly. For example, when you want to calculate the total score of each student in a class, you only need to calculate the total score of one student, and use the automatic filling function of the table to calculate the remaining students at one time, avoiding repeated operations. .
目前的自动填充分为顺序填充和重复填充。在重复填充时需选定一个初始区域，然后从初始区域拖拽至其他区域，完成对其他区域的填充，填充时根据选定的初始区域重复填充。The current automatic filling is divided into sequential filling and repeated filling. When filling repeatedly, you need to select an initial area, and then drag and drop from the initial area to other areas to complete the filling of other areas. When filling, repeat filling according to the selected initial area.
然而，目前的自动填充分为顺序填充和重复填充，在实际填充时由于填充区域较大，有时无法一次性完成填充，可能需要多次调整，在放手之后再往上或者往下拖一点，从而导致了体验性低的技术问题。However, the current automatic filling is divided into sequential filling and repeated filling. In the actual filling, due to the large filling area, sometimes the filling cannot be completed at one time. It may need to be adjusted several times. After letting go, drag it up or down a little, so as to Caused a technical problem with low experience.
发明内容SUMMARY OF THE INVENTION
本发明实施例提供的一种基于表格的自动填充方法及装置，解决了目前在执行重复填充操作时，可能由于填充区域较大无法一次性完成填充，需要进行多次调整，而导致的体验性低的技术问题。The table-based automatic filling method and device provided by the embodiments of the present invention solve the problem of experiential problems caused by the fact that the filling area is too large and the filling cannot be completed at one time, and multiple adjustments are required when performing repeated filling operations. Low technical issues.
本发明实施例提供的一种基于表格的自动填充方法，包括：A form-based automatic filling method provided by an embodiment of the present invention includes:
在表格中选定需要重复填充的原始区域，并记录；Select the original area that needs to be filled repeatedly in the table, and record it;
通过表格触发自动填充处理模式；Trigger the autofill processing mode through the form;
在所述自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录；Capture and record the dragging track of anchor points in real time under the automatic filling processing mode;
当退出所述自动填充处理模式时，以最后一次记录的所述锚点的所述拖曳轨迹所覆盖的表格区域为最终填充区域，并对所述最终填充区域进行对应填充处理。When exiting the automatic filling processing mode, the table area covered by the dragging track of the anchor point recorded last time is used as the final filling area, and corresponding filling processing is performed on the final filling area.
可选地，通过表格触发自动填充处理模式具体包括：Optionally, triggering the automatic filling processing mode through the form specifically includes:
通过在所述表格中的选中区域的快捷菜单触发所述自动填充处理模式。The autofill processing mode is triggered by a shortcut menu in a selected area in the form.
可选地，在所述自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录具体包括：Optionally, capturing the dragging trajectory of the anchor point in real time in the automatic filling processing mode, and recording specifically includes:
在所述自动填充处理模式下记录首次拖曳锚点的起始拖曳位置；recording the initial dragging position of the first dragging anchor point in the automatic filling processing mode;
在所述自动填充处理模式下实时捕捉锚点拖曳后停止状态下的拖曳停止位置，并记录所述拖曳停止位置。In the automatic filling processing mode, the dragging stop position in the stopped state after the anchor point is dragged is captured in real time, and the dragging stop position is recorded.
可选地，在所述自动填充处理模式下实时捕捉锚点拖曳后停止状态下的拖曳停止位置，并记录所述拖曳停止位置之后还包括：Optionally, in the automatic filling processing mode, capturing the drag stop position in the state where the anchor point is stopped after dragging in real time, and recording the drag stop position further includes:
当在所述自动填充处理模式下检测到锚点再次拖曳，则记录所述锚点再次拖曳后停止状态下的再次拖曳停止位置，并替换掉前一次拖曳停止位置。When it is detected that the anchor point is dragged again in the automatic filling processing mode, the re-drag stop position in the stopped state after the anchor point is dragged again is recorded, and the previous drag stop position is replaced.
可选地，当退出所述自动填充处理模式时，以最后一次记录的所述锚点的所述拖曳轨迹所覆盖的表格区域为最终填充区域，并对所述最终填充区域进行对应填充处理具体包括：Optionally, when exiting the automatic filling processing mode, the table area covered by the drag track of the anchor point recorded last time is the final filling area, and the corresponding filling processing is performed on the final filling area. include:
当退出所述自动填充处理模式时，以最后一次记录的所述拖曳停止位置和记录的所述起始拖曳位置覆盖的表格区域为所述最终填充区域；When exiting the automatic filling processing mode, the table area covered by the last recorded dragging stop position and the recorded starting dragging position is the final filling area;
对所述最终填充区域进行重复填充处理；performing repeated filling processing on the final filling area;
其中，对所述最终填充区域进行填充处理时，是以记录中的原始区域为填充对象的。Wherein, when performing the filling process on the final filling area, the original area in the record is used as the filling object.
本发明实施例提供的一种基于表格的自动填充装置，包括：A form-based automatic filling device provided by an embodiment of the present invention includes:
确定单元，用于在表格中选定需要重复填充的原始区域，并记录；Determine the unit, which is used to select the original area that needs to be filled repeatedly in the table, and record it;
触发单元，用于通过表格触发自动填充处理模式；Trigger unit for triggering the autofill processing mode through the form;
锚点轨迹记录单元，用于在所述自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录；An anchor point track recording unit, used for capturing and recording the anchor point dragging track in real time under the automatic filling processing mode;
填充处理单元，用于当退出所述自动填充处理模式时，以最后一次记录的所述锚点的所述拖曳轨迹所覆盖的表格区域为最终填充区域，并对所述最终填充区域进行对应填充处理。A filling processing unit, configured to use the table area covered by the dragging track of the anchor point recorded last time as the final filling area when exiting the automatic filling processing mode, and perform corresponding filling on the final filling area deal with.
可选地，触发单元，具体用于通过在所述表格中的选中区域的快捷菜单触发所述自动填充处理模式。Optionally, the triggering unit is specifically configured to trigger the automatic filling processing mode through the shortcut menu of the selected area in the form.
可选地，锚点轨迹记录单元具体包括：Optionally, the anchor point track recording unit specifically includes:
起始拖曳位置记录子单元，用于在所述自动填充处理模式下记录首次拖曳锚点的起始拖曳位置；a starting dragging position recording subunit, used for recording the starting dragging position of the first dragging anchor point in the automatic filling processing mode;
拖曳停止位置记录子单元，用于在所述自动填充处理模式下实时捕捉锚点拖曳后停止状态下的拖曳停止位置，并记录所述拖曳停止位置。The dragging stop position recording subunit is used to capture the dragging stop position in the state of stopping after the anchor point is dragged in real time in the automatic filling processing mode, and record the dragging stop position.
可选地，锚点轨迹记录单元还包括：Optionally, the anchor point track recording unit further includes:
最后拖曳停止位置确定子单元，具体用于当在所述自动填充处理模式下检测到锚点再次拖曳，则记录所述锚点再次拖曳后停止状态下的再次拖曳停止位置，并替换掉前一次拖曳停止位置。The final drag stop position determination subunit is specifically used to record the drag stop position of the anchor point in the stopped state after dragging the anchor point again when it is detected that the anchor point is dragged again in the automatic filling processing mode, and replace the previous dragging stop position Drag stop position.
可选地，填充处理单元具体包括：Optionally, the filling processing unit specifically includes:
最终填充区域确定子单元，用于当退出所述自动填充处理模式时，以最后一次记录的所述拖曳停止位置和记录的所述起始拖曳位置覆盖的表格区域为所述最终填充区域；The final filling area determination subunit is used for, when exiting the automatic filling processing mode, the table area covered by the last recorded dragging stop position and the recorded starting dragging position is the final filling area;
填充处理子单元，用于对所述最终填充区域进行重复填充处理；a filling processing subunit, used to perform repeated filling processing on the final filling area;
其中，对所述最终填充区域进行填充处理时，是以记录中的原始区域为填充对象的。Wherein, when performing the filling process on the final filling area, the original area in the record is used as the filling object.
从以上技术方案可以看出，本发明实施例具有以下优点：As can be seen from the above technical solutions, the embodiments of the present invention have the following advantages:
本发明实施例提供的一种基于表格的自动填充方法及装置，其中，基于表格的自动填充方法包括：在表格中选定需要重复填充的原始区域，并记录；通过表格触发自动填充处理模式；在自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录；当退出自动填充处理模式时，以最后一次记录的锚点的拖曳轨迹所覆盖的表格区域为最终填充区域，并对最终填充区域进行对应填充处理。本实施例中，通过首先确定通过表格触发自动填充处理模式，然后在自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录，最后当退出自动填充处理模式时，以最后一次记录的锚点的拖曳轨迹所覆盖的表格区域为最终填充区域，并对最终填充区域进行对应填充处理，解决了目前在执行重复填充操作时，可能由于填充区域较大无法一次性完成填充，需要进行多次调整，而导致的体验性低的技术问题。A form-based automatic filling method and device provided by an embodiment of the present invention, wherein the form-based automatic filling method includes: selecting an original area that needs to be repeatedly filled in the form, and recording; triggering an automatic filling processing mode through the form; Capture and record the dragging track of anchor points in real time in the automatic filling processing mode; when exiting the automatic filling processing mode, the table area covered by the dragging track of the anchor point recorded last time is the final filling area, and the final filling area is processed. Corresponding to filling processing. In this embodiment, by first determining that the automatic filling processing mode is triggered by the table, then capturing and recording the dragging track of the anchor point in real time in the automatic filling processing mode, and finally when exiting the automatic filling processing mode, the last recorded anchor point The table area covered by the dragging track is the final filling area, and the corresponding filling processing is performed on the final filling area, which solves the problem that when performing repeated filling operations, the filling may not be completed at one time due to the large filling area, and multiple adjustments are required. The resulting technical problems with low experience.
附图说明Description of drawings
为了更清楚地说明本发明实施例或现有技术中的技术方案，下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍，显而易见地，下面描述中的附图仅仅是本发明的一些实施例，对于本领域普通技术人员来讲，在不付出创造性劳动性的前提下，还可以根据这些附图获得其它的附图。In order to explain the embodiments of the present invention or the technical solutions in the prior art more clearly, the following briefly introduces the accompanying drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments of the present invention. For those of ordinary skill in the art, other drawings can also be obtained based on these drawings without any creative effort.
图1为本发明实施例提供的一种基于表格的自动填充方法的一个实施例的流程示意图；1 is a schematic flowchart of an embodiment of a table-based automatic filling method provided by an embodiment of the present invention;
图2为本发明实施例提供的一种基于表格的自动填充方法的另一个实施例的流程示意图；2 is a schematic flowchart of another embodiment of a table-based automatic filling method provided by an embodiment of the present invention;
图3为本发明实施例提供的一种基于表格的自动填充装置的一个实施例的结构示意图；3 is a schematic structural diagram of an embodiment of a table-based automatic filling device provided by an embodiment of the present invention;
图4为本发明实施例提供的一种基于表格的自动填充装置的另一个实施例的结构示意图；4 is a schematic structural diagram of another embodiment of a table-based automatic filling device provided by an embodiment of the present invention;
图5(a)至(c)为图2的应用例示意图。5( a ) to ( c ) are schematic diagrams of the application example of FIG. 2 .
具体实施方式Detailed ways
本发明实施例提供的一种基于表格的自动填充方法及装置，解决了目前在执行重复填充操作时，可能由于填充区域较大无法一次性完成填充，需要进行多次调整，而导致的体验性低的技术问题。The table-based automatic filling method and device provided by the embodiments of the present invention solve the problem of experiential problems caused by the fact that the filling area is too large and the filling cannot be completed at one time, and multiple adjustments are required when performing repeated filling operations. Low technical issues.
为使得本发明的发明目的、特征、优点能够更加的明显和易懂，下面将结合本发明实施例中的附图，对本发明实施例中的技术方案进行清楚、完整地描述，显然，下面所描述的实施例仅仅是本发明一部分实施例，而非全部的实施例。基于本发明中的实施例，本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其它实施例，都属于本发明保护的范围。In order to make the purpose, features and advantages of the present invention more obvious and understandable, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the following The described embodiments are only some, but not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.
请参阅图1，本发明实施例提供的一种基于表格的自动填充方法的一个实施例包括：Referring to FIG. 1, an embodiment of a table-based automatic filling method provided by an embodiment of the present invention includes:
101、在表格中选定需要重复填充的原始区域，并记录；101. Select the original area that needs to be filled repeatedly in the table, and record;
本实施例中，当需要非一次填充，而是需要进行多次调整，需要在表格中选定需要重复填充的原始区域，并记录。In this embodiment, when multiple adjustments are required instead of one-time filling, the original area that needs to be filled repeatedly needs to be selected in the table and recorded.
102、通过表格触发自动填充处理模式；102. Trigger the automatic filling processing mode through the form;
当在表格中选定需要重复填充的原始区域，并记录之后，需要通过表格触发自动填充处理模式。When the original area that needs to be repeatedly filled is selected in the table and recorded, the automatic filling processing mode needs to be triggered through the table.
103、在自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录；103. Capture and record the dragging track of the anchor point in real time in the automatic filling processing mode;
当通过表格触发自动填充处理模式之后，需要在自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录。After triggering the auto-fill processing mode through the table, you need to capture and record the dragging track of the anchor point in real-time in the auto-fill processing mode.
104、当退出自动填充处理模式时，以最后一次记录的锚点的拖曳轨迹所覆盖的表格区域为最终填充区域，并对最终填充区域进行对应填充处理。104. When exiting the automatic filling processing mode, take the table area covered by the dragging track of the anchor point recorded last time as the final filling area, and perform corresponding filling processing on the final filling area.
当在自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录之后，需要当退出自动填充处理模式时，以最后一次记录的锚点的拖曳轨迹所覆盖的表格区域为最终填充区域，并对最终填充区域进行对应填充处理。When capturing and recording the anchor point dragging track in real time in the automatic filling processing mode, it is necessary to take the table area covered by the dragging track of the anchor point recorded last time as the final filling area when exiting the automatic filling processing mode. Fill the area with corresponding filling processing.
本实施例中，通过首先在表格中选定需要重复填充的原始区域，并记录，然后在自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录，最后当退出自动填充处理模式时，以最后一次记录的锚点的拖曳轨迹所覆盖的表格区域为最终填充区域，并对最终填充区域进行对应填充处理，解决了目前在执行重复填充操作时，可能由于填充区域较大无法一次性完成填充，需要进行多次调整，而导致的体验性低的技术问题。In this embodiment, by first selecting the original area that needs to be filled repeatedly in the table, and recording, and then capturing the dragging track of the anchor point in real time in the automatic filling processing mode, and recording, and finally when exiting the automatic filling processing mode, the last The table area covered by the dragging track of the anchor point recorded once is the final filling area, and the corresponding filling processing is performed on the final filling area, which solves the problem that when performing repeated filling operations, the filling may not be completed at one time due to the large filling area. Need to make multiple adjustments, resulting in low experience technical problems.
上面是对基于表格的自动填充方法的过程进行详细的描述，下面将对具体过程进行详细的描述，请参阅图2，本发明实施例提供的一种基于表格的自动填充方法的另一个实施例包括：The above is a detailed description of the process of the table-based automatic filling method. The specific process will be described in detail below. Please refer to FIG. 2, another embodiment of a table-based automatic filling method provided by an embodiment of the present invention. include:
201、在表格中选定需要重复填充的原始区域，并记录；201. Select the original area that needs to be filled repeatedly in the table, and record;
本实施例中，当需要非一次填充，而是需要进行多次调整，需要在表格中选定需要重复填充的原始区域，并记录。In this embodiment, when multiple adjustments are required instead of one-time filling, the original area that needs to be filled repeatedly needs to be selected in the table and recorded.
202、通过在表格中的选中区域的快捷菜单触发自动填充处理模式；202. Trigger the automatic filling processing mode through the shortcut menu of the selected area in the table;
当在表格中选定需要重复填充的原始区域，并记录之后，需要通过在表格中的选中区域的快捷菜单触发自动填充处理模式。When the original area that needs to be filled repeatedly is selected in the table and recorded, it is necessary to trigger the automatic filling processing mode through the shortcut menu of the selected area in the table.
203、在自动填充处理模式下记录首次拖曳锚点的起始拖曳位置，并记录起始拖曳位置；203. Record the starting dragging position of the anchor point for the first time in the automatic filling processing mode, and record the starting dragging position;
当通过在表格中的选中区域的快捷菜单触发自动填充处理模式之后，需要在自动填充处理模式下记录首次拖曳锚点的起始拖曳位置，并记录起始拖曳位置。After triggering the automatic filling processing mode through the shortcut menu of the selected area in the table, it is necessary to record the starting dragging position of the anchor point for the first time in the automatic filling processing mode, and record the starting dragging position.
204、在自动填充处理模式下实时捕捉锚点拖曳后停止状态下的拖曳停止位置，并记录拖曳停止位置；204. In the automatic filling processing mode, capture the dragging stop position in the stopped state after the anchor point is dragged in real time, and record the dragging stop position;
当在自动填充处理模式下记录首次拖曳锚点的起始拖曳位置，并记录起始拖曳位置之后，需要在自动填充处理模式下实时捕捉锚点拖曳后停止状态下的拖曳停止位置，并记录拖曳停止位置。When recording the starting dragging position of the anchor point for the first time in the automatic filling processing mode, and recording the starting dragging position, it is necessary to capture the dragging stop position of the anchor point in the state of stopping after dragging in real time in the automatic filling processing mode, and record the dragging stop position. stop position.
205、当在自动填充处理模式下检测到锚点再次拖曳，则记录锚点再次拖曳后停止状态下的再次拖曳停止位置，并替换掉前一次拖曳停止位置；205. When it is detected that the anchor point is dragged again in the automatic filling processing mode, record the dragging stop position of the anchor point in the stopped state after dragging again, and replace the previous dragging stop position;
当在自动填充处理模式下实时捕捉锚点拖曳后停止状态下的拖曳停止位置，并记录拖曳停止位置之后，当在自动填充处理模式下检测到锚点再次拖曳，则记录锚点再次拖曳后停止状态下的再次拖曳停止位置，并替换掉前一次拖曳停止位置。When capturing the drag stop position of the anchor point in real-time in the auto-fill processing mode and recording the drag stop position, when the anchor point is detected to be dragged again in the auto-fill processing mode, the anchor point will be recorded and stopped after dragging again. The dragging stop position in the state is replaced by the previous dragging stop position.
206、当退出自动填充处理模式时，以最后一次记录的拖曳停止位置和记录的起始拖曳位置覆盖的表格区域为最终填充区域；206. When exiting the automatic filling processing mode, the table area covered by the dragging stop position of the last record and the starting dragging position of the record is the final filling area;
当在自动填充处理模式下检测到锚点再次拖曳，则记录锚点再次拖曳后停止状态下的再次拖曳停止位置，并替换掉前一次拖曳停止位置之后，当退出自动填充处理模式时，以最后一次记录的拖曳停止位置和记录的起始拖曳位置覆盖的表格区域为最终填充区域。When it is detected that the anchor point is dragged again in the auto-fill processing mode, the re-drag stop position in the stopped state after the anchor point is dragged again will be recorded, and the previous drag stop position will be replaced. The table area covered by the dragging stop position of one record and the starting dragging position of the record is the final filling area.
207、对最终填充区域进行重复填充处理。207. Perform repeated filling processing on the final filling area.
当退出自动填充处理模式时，以最后一次记录的拖曳停止位置和记录的起始拖曳位置覆盖的表格区域为最终填充区域之后，需要对最终填充区域进行重复填充处理。When exiting the automatic filling processing mode, after the table area covered by the dragging stop position of the last record and the starting dragging position of the record is the final filling area, the final filling area needs to be repeatedly filled.
其中，对最终填充区域进行填充处理时，是以记录中的原始区域为填充对象的。Among them, when the final filling area is filled, the original area in the record is used as the filling object.
为了便于理解下面以一具体应用场景进行详细的描述，如图5(a)至(c)所示，应用例包括：In order to facilitate understanding, a specific application scenario is described in detail below, as shown in Figure 5(a) to (c), application examples include:
1、如图5(a)，通过选中区域的快捷菜单进入填充状态。1. As shown in Figure 5(a), enter the filling state through the shortcut menu of the selected area.
2、如图5(b)，通过拖拽锚点进行第一次自动填充。2. As shown in Figure 5(b), the first automatic filling is performed by dragging the anchor point.
3、如图5(c)，在第一次填充完毕，松手之后，继续拖拽锚点进行第二次填充。3. As shown in Figure 5(c), after the first filling is completed, after letting go, continue to drag the anchor point for the second filling.
在图5(b)中，第一次进行填充时自动记录了填充位置是到P，并且初始参照区域是黄色区域。在第二次填充时可以根据第一次填充的位置P，以及初始的参照区域来决定后续的填充内容。这样在多次调整之后，退出填充状态后的结果就等同于用户一次性拖拽到最后放手位置的结果。In Fig. 5(b), when filling is performed for the first time, it is automatically recorded that the filling position is to P, and the initial reference area is the yellow area. In the second filling, the subsequent filling content can be determined according to the position P of the first filling and the initial reference area. In this way, after multiple adjustments, the result after exiting the filled state is equivalent to the result of the user dragging to the last release position at one time.
本实施例中，通过首先在表格中选定需要重复填充的原始区域，并记录，然后在自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录，最后当退出自动填充处理模式时，以最后一次记录的锚点的拖曳轨迹所覆盖的表格区域为最终填充区域，并对最终填充区域进行对应填充处理，解决了目前在执行重复填充操作时，可能由于填充区域较大无法一次性完成填充，需要进行多次调整，而导致的体验性低的技术问题。In this embodiment, by first selecting the original area that needs to be filled repeatedly in the table, and recording, and then capturing the dragging track of the anchor point in real time in the automatic filling processing mode, and recording, and finally when exiting the automatic filling processing mode, the last The table area covered by the dragging track of the anchor point recorded once is the final filling area, and the corresponding filling processing is performed on the final filling area, which solves the problem that when performing repeated filling operations, the filling may not be completed at one time due to the large filling area. Need to make multiple adjustments, resulting in low experience technical problems.
进一步，通过记录上一次填充的位置及初始的参照区域，达到允许操作者进行多次填充的效果。Further, by recording the position of the last filling and the initial reference area, the effect of allowing the operator to fill in multiple times is achieved.
请参阅图3，本发明实施例中提供的一种基于表格的自动填充装置的一个实施例包括：Referring to FIG. 3, an embodiment of a table-based automatic filling device provided in an embodiment of the present invention includes:
确定单元301，用于在表格中选定需要重复填充的原始区域，并记录；Determining
触发单元300，用于通过表格触发自动填充处理模式；a triggering
锚点轨迹记录单元302，用于在自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录；Anchor point
填充处理单元303，用于当退出自动填充处理模式时，以最后一次记录的锚点的拖曳轨迹所覆盖的表格区域为最终填充区域，并对最终填充区域进行对应填充处理。The filling
本实施例中，通过首先确定单元301确定通过表格触发自动填充处理模式，然后锚点轨迹记录单元302在自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录，最后填充处理单元303当退出自动填充处理模式时，以最后一次记录的锚点的拖曳轨迹所覆盖的表格区域为最终填充区域，并对最终填充区域进行对应填充处理，解决了目前在执行重复填充操作时，可能由于填充区域较大无法一次性完成填充，需要进行多次调整，而导致的体验性低的技术问题。In this embodiment, the determining
上面是对基于表格的自动填充装置的各单元进行详细的描述，下面将对子单元进行详细的描述，请参阅图4，本发明实施例中提供的一种基于表格的自动填充装置的另一个实施例包括：The above is a detailed description of each unit of the table-based automatic filling device, and the sub-units will be described in detail below. Please refer to FIG. 4 , another example of a table-based automatic filling device provided in an embodiment of the present invention. Examples include:
确定单元401，用于在表格中选定需要重复填充的原始区域，并记录。The determining unit 401 is used to select the original area that needs to be filled repeatedly in the table, and record it.
触发单元400，用于通过表格触发自动填充处理模式，触发单元402，具体用于通过在表格中的选中区域的快捷菜单触发自动填充处理模式。The triggering
锚点轨迹记录单元402，用于在自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录；Anchor point track recording unit 402, for capturing and recording the anchor point dragging track in real time under the automatic filling processing mode;
锚点轨迹记录单元402具体包括：The anchor point track recording unit 402 specifically includes:
起始拖曳位置记录子单元4021，用于在自动填充处理模式下记录首次拖曳锚点的起始拖曳位置，并记录起始拖曳位置；The starting dragging
拖曳停止位置记录子单元4022，用于在自动填充处理模式下实时捕捉锚点拖曳后停止状态下的拖曳停止位置，并记录拖曳停止位置；The dragging stop
最后拖曳停止位置确定子单元4023，具体用于当在自动填充处理模式下检测到锚点再次拖曳，则记录锚点再次拖曳后停止状态下的再次拖曳停止位置，并替换掉前一次拖曳停止位置。The final drag stop
填充处理单元403，用于当退出自动填充处理模式时，以最后一次记录的锚点的拖曳轨迹所覆盖的表格区域为最终填充区域，并对最终填充区域进行对应填充处理。The filling
填充处理单元403具体包括：The filling
最终填充区域确定子单元4031，用于当退出自动填充处理模式时，以最后一次记录的拖曳停止位置和记录的起始拖曳位置覆盖的表格区域为最终填充区域；The final filling
填充处理子单元4032，用于对最终填充区域进行重复填充处理；The filling
其中，对最终填充区域进行填充处理时，是以记录中的原始区域为填充对象的。Among them, when the final filling area is filled, the original area in the record is used as the filling object.
本实施例中，通过首先确定单元401确定通过表格触发自动填充处理模式，然后锚点轨迹记录单元402在自动填充处理模式下实时捕捉锚点拖曳轨迹，并记录，最后填充处理单元403当退出自动填充处理模式时，以最后一次记录的锚点的拖曳轨迹所覆盖的表格区域为最终填充区域，并对最终填充区域进行对应填充处理，解决了目前在执行重复填充操作时，可能由于填充区域较大无法一次性完成填充，需要进行多次调整，而导致的体验性低的技术问题。In this embodiment, the determining unit 401 first determines that the automatic filling processing mode is triggered through the table, and then the anchor point track recording unit 402 captures the dragging track of the anchor point in real time in the automatic filling processing mode, and records it, and finally the filling
进一步，通过记录上一次填充的位置及初始的参照区域，达到允许操作者进行多次填充的效果。Further, by recording the position of the last filling and the initial reference area, the effect of allowing the operator to fill in multiple times is achieved.
所属领域的技术人员可以清楚地了解到，为描述的方便和简洁，上述描述的系统，装置和单元的具体工作过程，可以参考前述方法实施例中的对应过程，在此不再赘述。Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working process of the system, device and unit described above may refer to the corresponding process in the foregoing method embodiments, which will not be repeated here.
在本申请所提供的几个实施例中，应该理解到，所揭露的系统，装置和方法，可以通过其它的方式实现。例如，以上所描述的装置实施例仅仅是示意性的，例如，所述单元的划分，仅仅为一种逻辑功能划分，实际实现时可以有另外的划分方式，例如多个单元或组件可以结合或者可以集成到另一个系统，或一些特征可以忽略，或不执行。另一点，所显示或讨论的相互之间的耦合或直接耦合或通信连接可以是通过一些接口，装置或单元的间接耦合或通信连接，可以是电性，机械或其它的形式。In the several embodiments provided in this application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the apparatus embodiments described above are only illustrative. For example, the division of the units is only a logical function division. In actual implementation, there may be other division methods. For example, multiple units or components may be combined or Can be integrated into another system, or some features can be ignored, or not implemented. On the other hand, the shown or discussed mutual coupling or direct coupling or communication connection may be through some interfaces, indirect coupling or communication connection of devices or units, and may be in electrical, mechanical or other forms.
所述作为分离部件说明的单元可以是或者也可以不是物理上分开的，作为单元显示的部件可以是或者也可以不是物理单元，即可以位于一个地方，或者也可以分布到多个网络单元上。可以根据实际的需要选择其中的部分或者全部单元来实现本实施例方案的目的。The units described as separate components may or may not be physically separated, and components displayed as units may or may not be physical units, that is, may be located in one place, or may be distributed to multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution in this embodiment.
另外，在本发明各个实施例中的各功能单元可以集成在一个处理单元中，也可以是各个单元单独物理存在，也可以两个或两个以上单元集成在一个单元中。上述集成的单元既可以采用硬件的形式实现，也可以采用软件功能单元的形式实现。In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically alone, or two or more units may be integrated into one unit. The above-mentioned integrated units may be implemented in the form of hardware, or may be implemented in the form of software functional units.
所述集成的单元如果以软件功能单元的形式实现并作为独立的产品销售或使用时，可以存储在一个计算机可读取存储介质中。基于这样的理解，本发明的技术方案本质上或者说对现有技术做出贡献的部分或者该技术方案的全部或部分可以以软件产品的形式体现出来，该计算机软件产品存储在一个存储介质中，包括若干指令用以使得一台计算机设备(可以是个人计算机，服务器，或者网络设备等)执行本发明各个实施例所述方法的全部或部分步骤。而前述的存储介质包括：U盘、移动硬盘、只读存储器(ROM，Read-OnlyMemory)、随机存取存储器(RAM，Random Access Memory)、磁碟或者光盘等各种可以存储程序代码的介质。The integrated unit, if implemented in the form of a software functional unit and sold or used as an independent product, may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium , including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage medium includes: U disk, removable hard disk, Read-Only Memory (ROM, Read-Only Memory), Random Access Memory (RAM, Random Access Memory), magnetic disk or optical disk and other media that can store program codes.
以上所述，以上实施例仅用以说明本发明的技术方案，而非对其限制；尽管参照前述实施例对本发明进行了详细的说明，本领域的普通技术人员应当理解：其依然可以对前述各实施例所记载的技术方案进行修改，或者对其中部分技术特征进行等同替换；而这些修改或者替换，并不使相应技术方案的本质脱离本发明各实施例技术方案的精神和范围。As mentioned above, the above embodiments are only used to illustrate the technical solutions of the present invention, but not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand: The technical solutions described in the embodiments are modified, or some technical features thereof are equivalently replaced; and these modifications or replacements do not make the essence of the corresponding technical solutions depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (10)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611091609.XACN108132922B (en) | 2016-12-01 | 2016-12-01 | Automatic filling method and device based on form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611091609.XACN108132922B (en) | 2016-12-01 | 2016-12-01 | Automatic filling method and device based on form |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108132922A CN108132922A (en) | 2018-06-08 |
| CN108132922Btrue CN108132922B (en) | 2020-12-25 |
Family
ID=62388141
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611091609.XAActiveCN108132922B (en) | 2016-12-01 | 2016-12-01 | Automatic filling method and device based on form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108132922B (en) |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7426496B2 (en)* | 2004-03-03 | 2008-09-16 | Microsoft Corporation | Assisted form filling |
| US7660779B2 (en)* | 2004-05-12 | 2010-02-09 | Microsoft Corporation | Intelligent autofill |
| US7386785B2 (en)* | 2004-08-30 | 2008-06-10 | Sap Ag | Automatic electronic timesheet filler |
| US20110145739A1 (en)* | 2009-12-16 | 2011-06-16 | Peter Glen Berger | Device, Method, and Graphical User Interface for Location-Based Data Collection |
| US10229101B2 (en)* | 2013-06-14 | 2019-03-12 | Microsoft Technology Licensing, Llc | Smart fill |
- 2016
- 2016-12-01CNCN201611091609.XApatent/CN108132922B/enactiveActive
Also Published As
| Publication number | Publication date |
|---|---|
| CN108132922A (en) | 2018-06-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6363736B2 (en) | Intelligent terminal control method | |
| US10384125B2 (en) | Information processing program and information processing method | |
| JP2021500645A5 (en) | ||
| US9880914B2 (en) | Device, method and program for performing system testing | |
| RU2016111349A (en) | AUTOMATED RECORDING OF PRODUCTION PROCESS DATA FOR ANALYSIS AND REPORTING ERRORS IN THE DRILLING APPLICATION | |
| CN106210836A (en) | Interactive learning method and device in video playing process and terminal equipment | |
| US9310886B2 (en) | Transient message display control | |
| US11604689B1 (en) | Resolving technology issues | |
| US20150253877A1 (en) | Off-screen input capture for mobile device | |
| CN111176569A (en) | Flow quota method, device, system and equipment and readable storage medium | |
| CN110502414B (en) | Terminal equipment performance testing method, device, terminal equipment and storage medium | |
| CN105391964A (en) | Video data processing method and apparatus | |
| CN108650538B (en) | A method and system for simultaneously recording near-field audio and far-field video | |
| TWI579828B (en) | Voice recognition device and method | |
| CN106503080A (en) | Information dissemination method and device | |
| US20160191845A1 (en) | Electronic device and method for recording and displaying script | |
| CN108132922B (en) | Automatic filling method and device based on form | |
| CN104866807B (en) | A kind of Face detection method and system | |
| JP2018536212A5 (en) | ||
| CN105898169A (en) | Video processing method and device | |
| CN111510787A (en) | Multimedia editing method, device, terminal and storage medium | |
| CN109597721A (en) | A kind of audio data collecting method, apparatus, equipment and storage medium | |
| CN107844590B (en) | Small file migration method, apparatus, device, and computer-readable storage medium | |
| CN104572408B (en) | Progress bar display processing method and device | |
| CN106033352A (en) | Vertex editing method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |