CN113536750B - Form marking method and device, electronic equipment and storage medium - Google Patents
Form marking method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN113536750B CN113536750B CN202110631104.2A CN202110631104A CN113536750B CN 113536750 B CN113536750 B CN 113536750B CN 202110631104 A CN202110631104 A CN 202110631104A CN 113536750 B CN113536750 B CN 113536750B
- Authority
- CN
- China
- Prior art keywords
- unit
- item
- unit item
- items
- target
- 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
- 238000000034 method Methods 0.000 title claims abstract description 44
- 238000004891 communication Methods 0.000 claims description 18
- 238000004590 computer program Methods 0.000 claims description 10
- 238000011084 recovery Methods 0.000 claims description 10
- 230000001960 triggered effect Effects 0.000 claims description 5
- 238000012545 processing Methods 0.000 abstract description 6
- 238000010586 diagram Methods 0.000 description 18
- 230000008569 process Effects 0.000 description 5
- 230000009471 action Effects 0.000 description 4
- 230000006399 behavior Effects 0.000 description 4
- 238000010926 purge Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000000802 evaporation-induced self-assembly Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/0482—Interaction with lists of selectable items, e.g. menus
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
Abstract
The embodiment of the application provides a form marking method, a form marking device, electronic equipment and a storage medium, which relate to the technical field of file processing and comprise the following steps: determining a cell item to be skipped marked in a table as a target cell item, wherein the cell item comprises a cell row and/or a cell column; determining a first identity of the other unit items; and marking the identification of the other unit items as the first identification. Therefore, by applying the scheme provided by the embodiment of the application, the number of the unit items for displaying the specific content in the table can be counted conveniently.
Description
Technical Field
The present disclosure relates to the field of document processing technologies, and in particular, to a method and apparatus for marking a table, an electronic device, and a storage medium.
Background
With the rapid development of file processing technology, the application of tables is becoming more and more widespread. The unit items in the table are usually marked, and the unit items can be unit rows or unit columns, and the number of the unit items in the table can be counted based on marked information.
Taking fig. 1 as an example, fig. 1 is a schematic diagram of an employee table, where "XX" in fig. 1 indicates employee names, a column on the left side of the table carries a numeric row label, and a column label on the upper end of the table carries letters, when counting the number of unit items based on information of unit item labels, if titles or headers appear, the labels in the prior art can only count all rows and columns, and cannot count the number of unit items for displaying specific contents in the table.
Disclosure of Invention
An embodiment of the present application is to provide a method, an apparatus, an electronic device, and a storage medium for marking a table, so as to solve a technical problem that if a title or a table header appears, a marking in the prior art can only count all rows and columns, and cannot count the number of unit items for displaying specific contents in the table conveniently. The specific technical scheme is as follows:
in a first aspect, an embodiment of the present invention provides a table marking method, where the method includes:
determining a cell item to be skipped marked in a table as a target cell item, wherein the cell item comprises a cell row and/or a cell column;
determining a first identification of other unit items, wherein the other unit items are: the unit items of the table except for the target unit item;
And marking the identification of the other unit items as the first identification.
In one embodiment of the present invention, the determining the first identifier of the other unit item includes: and determining the first identification of each other unit item according to the arrangement sequence of the other unit items in the table.
In one embodiment of the present invention, the determining the first identifier of each other unit item according to the arrangement order of the other unit items in the table includes: determining a first identifier of each first unit item according to the arrangement sequence of each first unit item in the table, wherein the first unit item is: each unit item in the reverse direction of the direction represented by the type of the target unit item; according to the arrangement sequence of the second unit items in the table, determining the first identification of each second unit item according to the first identification of each first unit item, wherein the second unit items are: each unit item in the forward direction of the direction represented by the type of the target unit item.
In one embodiment of the present invention, the determining the first identifier of each other unit item according to the arrangement order of the other unit items in the table includes: determining a first identifier of each first unit item according to the arrangement sequence of each first unit item in the table, wherein the first unit item is: each unit item in the reverse direction of the direction represented by the type of the target unit item; determining a first identifier of each second unit item according to the arrangement sequence of each second unit item in the table, wherein the second unit item is: each unit item in the forward direction of the direction represented by the type of the target unit item.
In one embodiment of the present invention, the method further includes:
determining a re-marked unit item in the marked table as a reference unit item;
determining a second identifier of the reference unit item and each third unit item according to the arrangement sequence of the reference unit item and each third unit item in the table under the condition that the reference unit item is positioned before the target unit item, and marking the identifiers of the reference unit item and each third unit item as the second identifier, wherein the third unit item is: a unit item between the reference unit item and the target unit item;
determining a third identifier of the reference unit item and each fourth unit item according to the arrangement sequence of the reference unit item and each fourth unit item in the table when the reference unit item is positioned behind the target unit item, and marking the identifiers of the reference unit item and each fourth unit item as the third identifier, wherein the fourth unit item is: the unit items subsequent to the reference unit item.
In one embodiment of the present invention, the method further includes: and under the condition that an identifier recovery operation triggered by a user in a user interface is received, determining preset identifiers of all unit items in the table, and updating the identifiers of all unit items to the preset identifiers.
In one embodiment of the present invention, the target unit item includes: at least two consecutive rows of cells and/or at least two consecutive columns of cells.
In one embodiment of the present invention, the determining the cell entry to be skipped in the table includes: traversing unit items in a preset range in a table, and searching for unit items meeting preset skip mark conditions as target unit items, wherein the skip mark conditions comprise at least one of the following conditions: blank row, blank column, cell row for displaying title, cell column for displaying title.
In a second aspect, an embodiment of the present invention provides a form marking apparatus, where the apparatus includes:
a first unit item determining module, configured to determine a unit item to be skipped marked in a table, as a target unit item, where the unit item includes a unit row and/or a unit column;
the first identification determining module is used for determining first identifications of other unit items, wherein the other unit items are: the unit items of the table except for the target unit item;
and the identification marking module is used for marking the identification of the other unit items as the first identification.
In one embodiment of the present invention, the first identifier determining module is specifically configured to determine, according to an arrangement order of other unit items in the table, a first identifier of each other unit item.
In one embodiment of the present invention, the first identifier determining module is specifically configured to determine, according to an arrangement order of each first unit item in the table, a first identifier of each first unit item, where the first unit item is: each unit item in the reverse direction of the direction represented by the type of the target unit item; according to the arrangement sequence of the second unit items in the table, determining the first identification of each second unit item according to the first identification of each first unit item, wherein the second unit items are: each unit item in the forward direction of the direction represented by the type of the target unit item.
In one embodiment of the present invention, the first identifier determining module is specifically configured to determine, according to an arrangement order of each first unit item in the table, a first identifier of each first unit item, where the first unit item is: each unit item in the reverse direction of the direction represented by the type of the target unit item; determining a first identifier of each second unit item according to the arrangement sequence of each second unit item in the table, wherein the second unit item is: each unit item in the forward direction of the direction represented by the type of the target unit item.
In one embodiment of the present invention, the apparatus further includes:
a second unit item determining module for determining a unit item re-marked in the marked table as a reference unit item;
a second identifier determining module, configured to determine, when the reference unit item is located before the target unit item, a second identifier of the reference unit item and each third unit item according to an arrangement order of the reference unit item and each third unit item in the table, and mark the identifiers of the reference unit item and each third unit item as the second identifier, where the third unit item is: a unit item between the reference unit item and the target unit item;
a third identifier determining module, configured to determine, when the reference unit item is located after the target unit item, third identifiers of the reference unit item and each fourth unit item according to an arrangement order of the reference unit item and each fourth unit item in the table, and mark the identifiers of the reference unit item and each fourth unit item as the third identifiers, where the fourth unit item is: the unit items subsequent to the reference unit item.
In one embodiment of the present invention, the apparatus further includes: the identification updating module is used for determining preset identifications of all unit items in the table and updating the identifications of all unit items into the preset identifications under the condition that an identification recovery operation triggered by a user in a user interface is received.
In one embodiment of the present invention, the target unit item includes: at least two consecutive rows of cells and/or at least two consecutive columns of cells.
In one embodiment of the present invention, the first unit item determining module is specifically configured to traverse unit items within a preset range in a table, find a unit item that meets a preset skip flag condition as a target unit item, where the skip flag condition includes at least one of the following conditions: blank row, blank column, cell row for displaying title, cell column for displaying title.
In a third aspect, an embodiment of the present application 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; a processor for implementing the method steps of any one of the first aspects when executing a program stored on a memory.
In a fourth aspect, embodiments of the present application provide a computer-readable storage medium having a computer program stored therein, which when executed by a processor, implements the method steps of any of the first aspects.
When the scheme provided by the embodiment of the application is applied to marking the table, firstly, determining the unit items to be skipped to be marked in the table as target unit items, wherein the unit items comprise unit rows and/or unit columns, and then marking the unit items except for the target unit items according to a preset sequence. In this way, when marking the table, the unit rows and/or unit columns which are not expected to be marked can be skipped, instead, all the unit rows and/or unit columns are not marked, and based on the marked information, the statistics of the number of unit items for displaying specific contents in the table can be conveniently performed.
Drawings
In order to more clearly illustrate the embodiments of the present application 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 below, it being obvious that the drawings in the following description are only some embodiments of the present application, and that other embodiments may be obtained according to these drawings without inventive effort to a person skilled in the art.
FIG. 1 is a schematic diagram of a prior art form marking;
fig. 2 is a flowchart of a first form marking method according to an embodiment of the present application;
FIG. 3 is a schematic view of a menu item according to an embodiment of the present application;
FIG. 4a is a schematic diagram of a first table according to an embodiment of the present disclosure;
FIG. 4b is a schematic diagram of a second form provided in an embodiment of the present application;
FIG. 5a is a schematic diagram of a third table according to an embodiment of the present disclosure;
FIG. 5b is a fourth table schematic diagram provided in an embodiment of the present application;
FIG. 6 is a flowchart of a second form marking method according to an embodiment of the present disclosure;
FIG. 7 is a schematic diagram of another menu item provided in an embodiment of the present application;
FIG. 8a is a fifth table diagram according to an embodiment of the present disclosure;
FIG. 8b is a sixth table schematically illustrating an embodiment of the present application;
FIG. 8c is a schematic diagram of a seventh table provided in an embodiment of the present application;
FIG. 8d is a schematic diagram of an eighth table provided in an embodiment of the present application;
FIG. 9a is a schematic diagram of a ninth table provided in an embodiment of the present application;
FIG. 9b is a schematic view of a tenth table provided in an embodiment of the present application;
fig. 10 is a schematic structural diagram of a first form marking device according to an embodiment of the present disclosure;
FIG. 11 is a schematic structural diagram of a second form marking device according to an embodiment of the present disclosure;
fig. 12 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
The following description of the embodiments of the present application will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are only some, but not all, of the embodiments of the present application. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the present disclosure, are within the scope of the present disclosure.
In order to count the number of specific unit items in a table, the embodiments of the present application provide a table marking method, a device, an electronic device and a storage medium, which are described in detail below.
First, an application scenario of the embodiment of the present invention will be described.
The embodiment of the invention is applied to the application scene for counting the unit items for displaying the specific content in the table.
Since in the prior art, the unit items are usually marked sequentially in the order of all the unit items from top to bottom, in the application scenario, the counted number of unit items cannot count the actual number of unit items displaying the actual specific content in a certain table, and the counted result always includes the number of rows or columns of the header or the table head.
Taking fig. 1 as an example, assume that the unit items for displaying specific contents in fig. 1 are: the number of unit items marked "3", "4", and "5" is counted as 5 according to the marking method of the related art, but the actual number of unit items for displaying specific contents is actually 3, so the counted number is less accurate.
Referring to fig. 2, fig. 2 is a flow chart of a first form marking method according to an embodiment of the present application. The method can be applied to electronic equipment such as an electronic computer, a mobile phone, a tablet personal computer and the like, and can also be applied to Office software such as WPS Office and Microsoft Office. The table marking method includes the following steps 201 to 203.
In step 201, a cell item to be skipped in the table is determined as a target cell item.
Wherein the cell items comprise cell rows and/or cell columns.
The target unit item refers to a unit item to be skipped for marking, that is, the target unit item is a unit item that does not need marking. The target unit items may include target unit rows and/or target unit columns, the target unit rows: the cell rows to be skipped for marking, the target cell columns are: the marked cell columns are to be skipped.
In some cases, there are rows and/or columns of cells in the table to be skipped marked. For example: for blank rows and blank columns in the table, the marks can be skipped; the marks can be skipped for the cell rows and cell columns in the table for displaying the title; the labels may be skipped for rows and columns of cells in the table where no specific content is displayed. The above-described cell row and/or cell column to be skipped-marked may be taken as the target cell item.
The number of the target unit items may be 1 or more. In one embodiment of the present invention, when the number of target unit items is plural, the target unit items may include: at least two consecutive rows of cells and/or at least two consecutive columns of cells. Of course, the target unit item may also be: at least two discrete rows of cells and/or at least two discrete columns of cells.
In particular, when the target unit item is a unit row and/or a unit column for displaying a title, it may be necessary to occupy consecutive unit rows and/or unit columns, and thus, when the target unit item includes at least two consecutive unit rows and/or at least two consecutive unit columns, a complete title may be displayed.
The target unit item may be a unit item to be skipped to be marked selected by a user. In one embodiment, the user may move the cursor over the position of the cell item in the table on the user interface by moving the mouse and trigger a click operation for indicating that the cell item is the cell item to be skipped. When the client detects the clicking operation of the user, determining the unit item clicked by the user as a target unit item.
Specifically, the user may select and click a unit item to be skipped and marked in the table, pop up a preset menu item, where the menu item includes an option button that characterizes that the selected unit item needs to be skipped and, after detecting the clicking operation of the option button by the user, may determine that the unit item selected by the user is a target unit item to be skipped and marked.
Taking fig. 3 as an example, fig. 3 is a schematic diagram of a menu item according to an embodiment of the present application. As shown in fig. 3, the menu items include option buttons such as "copy", "cut", "paste", etc., wherein the option button "skip the current line number" indicates that the currently selected line of units needs to be skipped, and when the user selects the option button "skip the current line number" in the menu item after detecting that the user selects the line of units, the user can consider that the user needs the electronic device to skip and mark the selected line of units, so that the selected line of units can be used as a target unit item.
In another embodiment, the user may also input, on the user interface, where the unit item in the table is located, as the unit item to be skipped. The client terminal determines a unit item corresponding to the position in the table based on the position input by the user, and takes the determined unit item as a target unit item.
Step 202: a first identification of other unit items is determined.
The other unit items are as follows: the cell entries of the table except for the target cell entry. The target unit item is a unit item to be skipped for marking, and the other unit items mentioned above refer to unit items to be marked.
The first identifier refers to the value of the identifier parameter item of the other unit item, that is, the value of the identifier of the other unit item. The first identifier may be in the form of a number "1, 2, 3, … …", so that the number of rows of the unit row other than the target unit row can be directly determined based on the flag, and may be in the form of a letter "A, B, C … …".
In order to improve the efficiency and accuracy of identification determination, in one embodiment of the present invention, the first identification of each other unit item may be determined according to the arrangement order of the other unit items in the table.
The arrangement order of the other unit items in the table includes an order from top to bottom and an order from left to right.
Taking fig. 4a as an example, a dark color area is used to display a logo in the table shown in fig. 4a, and a cell row in the third row is a cell row except for the dark color area: a target unit item; cell behavior in the first, second, fourth, and fifth rows: other unit items; the arrangement sequence of other unit items in the table is as follows: a first row of unit lines, a second row of unit lines, a fourth row of unit lines, and a fifth row of unit lines.
The cell columns in the third column among the cell columns except for the dark color region in the table shown in fig. 4a are: a target unit item; the cell columns in the first, second, fourth and fifth columns are: other unit items; the arrangement sequence of other unit columns in the table is as follows: a first column unit row, a second column unit row, a fourth column unit row, and a fifth column unit row.
Specifically, when determining the first identifier of each other unit item, the first identifier of each other unit item may be sequentially determined according to the order of the other unit items in the table from top to bottom or from left to right.
For example: taking fig. 4a as an example, when the arrangement order of other unit items in the table is: the first row unit row, the second row unit row, the fourth row unit row and the fifth row unit row can determine that the identification of the first row unit row is 1, the identification of the second row unit row is 2, the identification of the fourth row unit row is 3 and the identification of the fifth row unit row is 4 according to the arrangement sequence;
when the arrangement order of other unit items in the table is as follows: when the first, second, fourth, and fifth columns of unit columns are determined, according to the arrangement order, the first column of unit columns is identified as "1", the second column of unit columns is identified as "2", the fourth column of unit columns is identified as "3", and the fifth column of unit columns is identified as "4".
In one embodiment, when determining the first identifier of each other unit item, the identifier of the unit item located in the first row/first column in each other unit item may be first determined, and the identifier of each other unit item may be determined as the first identifier based on the determined identifier of the unit item in the first row/first column and the arrangement order of each other unit item in the table.
In determining the above-mentioned identification of the unit item located in the first row/first column, the identification input by the user may be the identification of the unit item located in the first row/first column, for example: assuming that the identification of the user input is "3", the "3" may be taken as the identification of the unit item located in the first row/first column. It is also possible to use a preset identity as an identity of the unit items located in the first row/first column, which may be set empirically by a staff member, for example: the preset identifier may be "1" or "a".
After the identification of the unit items located in the first row/first column is determined, the identification of each other unit item is sequentially determined according to the arrangement order of each other unit item in the table.
With reference to fig. 4a, the unit items in the first row are identified as "1", and "2,3,4" are respectively identified as each other unit item according to the arrangement order of each other unit item in the table, where the unit rows in the second row are identified as: the identification of the cell row of "2", fourth row, is: the identity of the cell row of the fifth row of "3" is: "4", the marked table is shown in FIG. 4 b.
In another embodiment, the preset identifier of each unit item before the target unit item may be used as the first identifier of each unit item; and determining a first identifier of each unit item after the target unit item based on the preset identifier of the target unit item.
Under default, all the unit rows have corresponding preset identifiers, and all the unit columns have corresponding preset identifiers.
The target unit item is a unit item to be skipped to be marked, and the preset identification for each unit item subsequent to the target unit item needs to be changed, whereas the preset identification for each unit item of each unit item preceding the target unit item does not need to be changed.
Based on this, the preset identification of each unit item before the target unit item can be directly determined as the first identification of each unit item.
When determining the identity of each unit item located after the target unit item, the preset identity of the target unit item may be used as the identity of the adjacent unit item located after the target unit item, so as to determine the identity of each unit item located after the target unit item.
For example: assuming that the third row of unit acts as a target unit item, and the preset identifier of the target unit item is "3", each unit item located after the target unit item includes: a fourth row unit row, a fifth row unit row, a sixth phone unit row, … …, wherein the fourth row unit row: adjacent unit items located after the target unit item, so "3" can be determined as the identification of the fourth row unit line, and further the identification of the fifth row unit line can be determined as: "4", identification of sixth row element row: "5", … …. Therefore, according to the arrangement sequence of the other unit items in the table, the first identification of the other unit items can be quickly determined, and the identification determination efficiency is improved.
Step 203: the identity of the other unit items is marked as a first identity.
The identification of the unit items refers to the identification parameter items of the unit items.
Marking the identity of the other unit items as a first identity means: and marking the values of the identification parameter items of other unit items in the user interface as a first identification.
Specifically, the marking may include the following two cases:
in the first case, the identifiers of the unit items in the table have initial values, and in this case, when the identifiers of the other unit items are marked, the initial values of the identifiers of the other unit items in the user interface are updated to the first identifiers.
For example: assuming that the initial value of the identifier of the unit item 1 is 1, the initial value of the identifier of the unit item 2 is 2, the initial value of the identifier of the unit item 3 is 3, the initial value of the identifier of the unit item 4 is 4, and the initial value of the identifier of the unit item 5 is 5;
assuming that the unit item 2 is the target unit item, the first identifiers of the other unit items after the redetermining are respectively: the first identifier of the unit item 1 is 1, the first identifier of the unit item 3 is 2, the first identifier of the unit item 4 is 3, the first identifier of the unit item 5 is 4, and the initial value of the identifiers of other unit items in the user interface is updated according to the first identifier, so that the process of marking the identifiers of the other unit items is realized.
In the second case, the value of the identifier of each element in the table does not have an initial value, in which case, when the identifiers of other element are marked, the value of the identifier of the other element in the user interface is directly determined as the first identifier.
For example: assume that the table includes a unit item 1, a unit item 2, a unit item 3, a unit item 4 and a unit item 5, wherein the unit item 2 is a target unit item, and the first identifiers of other unit items after re-determination are respectively: the first identifier of the unit item 1 is 1, the first identifier of the unit item 3 is 2, the first identifier of the unit item 4 is 3, the first identifier of the unit item 5 is 4, and the value of the identifier of each other unit item in the table in the user interface is marked as the first identifier, so that the identifier marking process of the other unit items is realized.
Specifically, when marking other cell rows, marking may be performed in the leftmost cell in the other cell rows; when marking other cell columns, the marking may be performed in the uppermost cell in the other cell columns.
Taking fig. 4b as an example, in the third row of fig. 4b, the cell behavior is the target cell row, and the other cell behaviors: the cell rows other than the target cell row, as can be seen from fig. 4b, the first row of cells is marked as: "1", second row unit row flag is: "2", fourth row of unit row marks are: "3", fifth row unit row is labeled: "4".
Based on the marked first identification, the number of the unit items in the table can be counted conveniently. As in fig. 4b, the number of cell items in the table for displaying the specific content may be directly determined to be 10.
The above-mentioned target unit items may be unit rows/unit columns for displaying the title, and the target unit items are unit items to be skipped for marking, that is, when marking is performed by adopting the scheme provided in this embodiment, the unit rows/unit columns for displaying the title are not marked, so that the number of unit items for displaying specific contents may be counted conveniently.
From the above, when the table marking is performed by applying the scheme provided by the embodiment, the unit rows and/or the unit columns which are not expected to be marked can be skipped for marking, instead, all the unit rows and/or the unit columns are not marked, and based on the marked information, the statistics on the number of the unit items for displaying the specific content in the table can be conveniently performed.
In one embodiment of the present invention, the determination of the first identifier in step 202 may also be implemented in the following two ways.
In a first mode, according to the arrangement sequence of the first unit items in the table, the first identification of each first unit item is determined, according to the arrangement sequence of the second unit items in the table, the first identification of each second unit item is determined according to the first identification.
The second way is: determining a first identifier of each first unit item according to the arrangement sequence of each first unit item in the table; and determining the first identification of each second unit item according to the arrangement sequence of each second unit item in the table.
The first unit item is: the type of the target unit item characterizes each unit item in the opposite direction of the direction. The second unit item is: the type of the target cell item characterizes each cell item in the forward direction of the direction.
The type of the target cell item includes a cell row and a cell column.
When the type of the target unit item is a unit row, the direction represented by the type of the target unit item may be: further, since the cell entry identity of the table is typically incremented sequentially from top to bottom, the vertical direction from the target cell entry. Thus, the forward direction of the direction characterized by the type of target unit item is: starting from the target unit item in a vertically downward direction, the second unit item is: starting from the target unit item, each unit row in the vertically downward direction; the reverse of the direction characterized by the type of target unit item is: starting from the target unit item in a vertically upward direction, the first unit item is: each cell row in the vertically upward direction is started from the target cell item.
Taking fig. 5a as an example, the unit item marked as empty in fig. 5a is the target unit item, and the direction of the vertical downward arrow is the vertical downward direction from the target unit item, so the direction of the vertical downward arrow is the forward direction of the direction characterized by the type of the target unit item, and the second unit item is: starting from the target unit item, each unit row in the vertically downward direction;
the direction of the vertical upward arrow is the vertical upward direction from the target unit item, so the direction of the vertical upward arrow is the reverse direction of the direction characterized by the type of the target unit item, and the first unit item is: each cell row in the vertically upward direction is started from the target cell item.
When the type of the target unit item is a unit column, the direction represented by the type of the target unit item may be: further, since the cell entry identifications of the table are typically incremented sequentially from left to right, the horizontal direction from the target cell entry. Thus, the forward direction of the direction characterized by the type of target unit item is: starting from the target unit item in the horizontal right direction, the second unit item is: starting from the target cell item, each cell row in the horizontal right direction; the reverse of the direction characterized by the type of target unit item is: starting from the target unit item in the horizontal left direction, the first unit item is: each cell column in the horizontal left direction is started from the target cell item.
Taking fig. 5b as an example, the unit item marked as empty in fig. 5b is the target unit item, and the direction of the horizontal right arrow is the horizontal right direction from the target unit item, so the direction of the horizontal right arrow is the forward direction of the direction characterized by the type of the target unit item, and the second unit item is: starting from the target cell item, each cell row in the horizontal right direction;
the direction of the horizontal left arrow is the direction to start from the target unit item to the horizontal left, so the direction of the horizontal left arrow is the reverse direction of the direction characterized by the type of the target unit item, and the first unit item is: each cell column in the horizontal left direction is started from the target cell item.
The specific procedure for determining the first identifier in the first mode and the second mode is different, and will be described below.
When the first identifier is determined in the first manner, first, the first identifier of each first unit item is determined according to the arrangement order of each first unit item in the table, and when the first identifier of each second unit item is determined according to the first identifier of each first unit item, the first identifier of the unit item located in the last row/column in each first unit item can be determined according to the first identifier of the unit item located in the first row/column in each second unit item, and further, the first identifier of each second unit item is determined according to the arrangement order of each second unit item in the table.
For example: assume that the first element includes: a first row of cells, a second row of cells, a third row of cells, the second cell item comprising: when determining the first identifier of the first unit item, the fifth row unit row, the sixth row unit row and the seventh row unit row, according to the arrangement sequence of the first unit items in the table, the identifier of the first row unit row is determined to be "1", the identifier of the second row unit row is determined to be "2", and the identifier of the third row unit row is determined to be "3";
in determining the first identity of the second unit item, due to the third row unit behavior: the cell item in the last row of the first cell item, and labeled "3", the fifth row of cell actions: the unit items in the first row in the second unit items can determine that the identifier of the fifth row of unit lines is '4', and further can determine that the identifier of the sixth row of unit lines is '5', and the identifier of the seventh row of unit lines is '6', according to the identifier of the third row of unit lines.
Therefore, the identification of the second unit item is determined according to the identification of the first unit item, namely the identifications of the first unit item and the second unit item are associated, so that the application scene of the integral statistics of the data in the table can be met, and the actual requirements of users are met.
When the first identifiers are determined by adopting the second mode, determining the first identifiers of the first unit items according to the arrangement sequence of the first unit items in the table; and determining the first identification of each second unit item according to the arrangement sequence of each second unit item in the table.
For example: along the above example, when determining the first identification of the first unit items, according to the arrangement order of the first unit items in the table, the identification of the first row unit row may be determined as "1", the identification of the second row unit row as "2", and the identification of the third row unit row as "3"; when determining the first identifier of the second unit item, according to the arrangement order of the second unit items in the table, the identifier of the fifth unit row may be determined to be "1", the identifier of the sixth unit row may be determined to be "2", and the identifier of the seventh unit row may be determined to be "3".
In this case, it may be understood that the table includes a plurality of sub-tables, and since the target unit item is not identified, and the first identifications of the first unit item and the second unit item are separately determined, the number of unit items in each sub-table can be conveniently counted.
Referring to fig. 6, fig. 6 is a schematic flow chart of a second form marking method according to an embodiment of the present application, after the step 203, the following steps 204 to 206 may be further included.
Step 204: the re-marked cell entry in the marked table is determined as a reference cell entry.
In some cases, the marked identifier in the table may not meet the user's needs, or the user may select the unit item to be re-marked in the marked table.
In one embodiment, the user may move a cursor over the user interface at the location of the cell item in the form by moving the mouse and triggering a click operation indicating that the cell item is a re-tagged cell item. When the client detects the clicking operation of the user, the unit item clicked by the user is determined to be used as the reference unit item.
Specifically, the user can select and click the unit items in the table for re-marking, pop up a preset menu item, wherein the menu item comprises an option button for representing that the selected unit item needs to be re-marked, and after the click operation of the option button by the user is detected, the unit item selected by the user can be determined to be the re-marked reference unit item.
Taking fig. 7 as an example, fig. 7 is a schematic diagram of another menu item provided in an embodiment of the present application. As shown in fig. 7, the menu items include option buttons such as "copy", "cut", "paste", etc., where the option button "identify from current line" indicates that the currently selected element line needs to be re-identified, and when the element line selected by the user is detected and the option button "identify from current line" in the menu items is selected again, the user may consider that the electronic device needs to re-identify the selected element line, so that the current 5 th line may be used as the reference element item.
In another embodiment, the user may enter the location of the cell item in the form on the user interface as a re-tagged cell item.
In this case, when the above-described reference cell item is determined, based on the position of the cell item in the table inputted by the user, the cell item corresponding to the above-described position may be determined in the table, and the determined cell item may be used as the reference cell item.
Step 205: in the case that the reference unit item is located before the target unit item, determining second identifications of the reference unit item and each third unit item according to the arrangement order of the reference unit item and each third unit item in the table, and marking the identifications of the reference unit item and each third unit item as the second identifications.
The third element is: the unit items between the reference unit item and the target unit item.
Taking fig. 8a as an example, the unit item marked with empty in fig. 8a is the target unit item, the unit item marked with 3 is the reference unit item, and it can be seen that the reference unit item is located before the target unit item, and each unit item between the reference unit item and the target unit item is the third unit item.
In determining the identity of the reference unit item and each third unit item, a second identity of the reference unit item may be first determined, the identity of each third unit item is determined based on the determined identity of the reference unit item and the arrangement order of the reference unit item and each third unit item in the table, and the determined identity of the reference unit item and the identity of the third unit item are used as the second identity. .
In determining the identity of the reference unit item, the identity input by the user may be used as the identity of the reference unit item, for example: assuming that the user input identification is "3", the "3" may be taken as the identification of the reference cell item. The preset identifier may also be an identifier of the reference unit item, where the preset identifier may be set empirically by a worker, for example: the preset identifier may be "1" or "a".
After the identification of the reference unit item is determined, according to the arrangement order of the reference unit item and each third unit item in the table, the unit item interval number of the interval between each third unit item and the reference unit item can be determined, and based on the identification of the reference unit item and the unit item interval number corresponding to each third unit item, the identification of each third unit item can be determined.
Referring to fig. 8a, the reference cell item is a third row of cells, the target cell item is a seventh row of cells, and each third cell item is in turn: the fourth row unit row, the fifth row unit row, and the sixth row unit row, assuming that the identification of the redetermined reference unit item is "1", the number of unit row intervals of intervals between the fourth row unit row and the third row unit row is 1, so the identification of the fourth row unit row can be calculated as: 1+1=2, i.e. "2", according to which the identity of the fifth row of cells can be calculated as: the identification of "3", sixth row of cells is "4".
After determining the second identifications of the reference unit item and each third unit item, the identifications of the reference unit item and each third unit item are marked as the second identifications.
In particular, the identity of the unit item preceding the reference unit item may be determined whether to remain based on the actual needs of the user, and in the case where the user triggers a purge operation in the user interface for indicating the identity of the unit item preceding the reference unit item, the identity of each unit item preceding the reference unit item may be purged.
Moreover, the identification of the unit items after the target unit item can keep the marked identification unchanged; the identity of each unit item subsequent to the target unit item may also be calculated based on the identities of the neighboring unit items preceding the target unit item, and the calculated identity re-tagged with the identity of each unit item subsequent to the target unit item.
For example: assuming that the identifiers of the adjacent unit items before the target unit item are 4, the identifiers of the unit items after the target unit item can be calculated according to the sequence: 5. 6, 7, 8, 9, … ….
Taking fig. 8b as an example, fig. 8b is: the reference unit item and the identifier of each third unit item in fig. 8a are marked as a third identifier, and it can be seen from fig. 8b that the identifier of the unit item preceding the reference unit item is emptied.
Comparing fig. 8b and fig. 8a, the identifiers of the reference unit items are marked as "1", the identifiers of the respective third unit items are respectively marked as "2", "3" and "4" in order, and the identifiers of the unit items preceding the reference unit item are all empty, and the unit items following the target unit item are marked as "5" and "6".
Of course, if the user does not trigger the above-mentioned purging operation, the identity of the unit item located before the reference unit item may be kept unchanged.
Step 206: in the case that the reference unit item is located after the target unit item, the identities of the reference unit item and each fourth unit item are determined according to the arrangement order of the reference unit item and each fourth unit item in the table, and the identities of the reference unit item and each fourth unit item are marked as a third identity.
The fourth element is: the unit items subsequent to the unit item are referred to.
Taking fig. 8c as an example, the unit item marked empty in the rectangular frame in fig. 8c is the target unit item, the unit item marked 4 is the reference unit item, and it can be seen that the reference unit item is located after the target unit item, and each unit item after the reference unit item is the fourth unit item.
In determining the identity of the reference unit item and each fourth unit item, the identity of the reference unit item may be first determined, the identity of each fourth unit item may be determined based on the determined identity of the reference unit item and the arrangement order of the reference unit item and each fourth unit item in the table, and the identity of the reference unit item and the identity of the fourth unit item may be used as the third identity.
The specific way of determining the identity of the reference unit item may be seen in the way of determining the identity of the reference unit item in step 204.
After the identification of the reference unit item is determined, according to the arrangement order of the reference unit item and each fourth unit item in the table, the number of unit item intervals between each fourth unit item and the reference unit item can be determined, and based on the identification of the reference unit item and the number of unit item intervals corresponding to each fourth unit item, the identification of each fourth unit item can be determined.
Along fig. 8c, the reference unit item is the fifth row unit line, the target unit item is the third row unit line, and the fourth unit items are in turn: a sixth row of unit lines, a seventh row of unit lines, and an eighth row of unit lines, assuming that the identification of the redetermined reference unit item is "1", the number of unit line intervals of intervals between the sixth row of unit lines and the fifth row of unit lines is 1, so that the identification of the sixth row of unit lines can be calculated as: 1+1=2, i.e. "2", according to which the identity of the seventh row of cells can be calculated as: the identification of "3", the eighth row of cells is "4".
After determining the third identifications of the reference unit item and each fourth unit item, the identifications of the reference unit item and each fourth unit item are marked as the third identifications.
In particular, the identity of the unit item located between the target unit item and the reference unit item may be determined whether to remain based on the actual needs of the user, and when the user triggers a purging operation in the user interface for indicating the identity of the unit item located between the target unit item and the reference unit item, the identity of the unit item located between the target unit item and the reference unit item may be purged.
Of course, if the user does not trigger the above-mentioned purging operation, the identity of the unit item located between the target unit item and the reference unit item may be kept unchanged.
Taking fig. 8d as an example, fig. 8d is: the reference unit item and the identifier of each fourth unit item in fig. 8c are marked as a third identifier, and it can be seen from fig. 8d that the identifier of the unit item between the reference unit item and the target unit item is emptied.
In contrast to fig. 8d and 8c, the identification of the reference unit item is marked "1", the identification of each fourth unit item is marked "2", "3", "4", "5", respectively, in order, and the identification of the unit item between the reference unit item and the target unit item is empty.
Thus, when the unit items in the table need to be re-marked, the reference unit items needing to be re-marked are determined, so that the first identification of the second unit item after the reference unit item or the first unit item between the reference unit item and the target unit item is re-determined, and the requirement of re-marking the unit items in the table is met.
In one embodiment of the invention, under the condition that the identifier recovery operation triggered by the user in the user interface is received, the preset identifier of each unit item in the table can be determined, and the identifier of each unit item is updated to be the preset identifier.
In a general case, the identifiers of the unit items in the table have preset identifiers. When the user needs to recover the identifier of each unit item in the table, the user can trigger the identifier recovery operation, where the identifier recovery operation is used to instruct to recover the identifier of each unit item in the table.
Specifically, an identifier recovery button may be set in the user interface, and by detecting a click operation of the user that triggers the identifier recovery button, it is determined that the user needs to recover the identifier of each element item of the table. In this case, the preset identity of each unit item may be determined, and the identity of each unit item may be updated to the preset identity.
Taking fig. 9a and 9b as an example, in fig. 9a, the fifth row unit line is a target unit line, and the identifiers of the unit lines except for the fifth row unit line are sequentially from top to bottom: "1,2,3,4,5,6,7,8,9", the identity of each element shown in FIG. 9b is: the identifiers of the unit items after the recovery on the basis of fig. 9a are as follows from top to bottom: "1,2,3,4,5,6,7,8,9,10".
Therefore, the identification of each unit item in the marked table can be recovered, and the requirement for recovering the identification of the unit item is met.
In one embodiment of the present application, when determining the target unit item, the unit item in the preset range in the table may be traversed, and the unit item that satisfies the preset skip flag condition may be searched for as the target unit item.
Wherein the skip mark condition includes at least one of the following conditions: blank row, blank column, cell row for displaying title, cell column for displaying title.
Characters do not exist in all cells in the blank rows and the blank columns;
the cell row for displaying the title, and the cell in the cell column for displaying the title exist for displaying the title content.
Specifically, the marks may be skipped, that is, not performed, for blank rows, blank columns, cell rows for displaying titles, cell columns for displaying titles, and the like. Therefore, the unit items meeting the conditions can be searched in the table, and the searched unit items are used as target unit items to be skipped.
In an embodiment of the present application, the skip mark condition may be a preset condition, or may be a skip mark condition customized by a user.
Specifically, the electronic apparatus may provide a condition input box, and obtain a condition input by the user in the condition input box as the skip flag condition. A plurality of candidate conditions may also be provided, one or more conditions selected by the user from the plurality of candidate conditions are obtained, and the skip mark conditions are combined.
Referring to fig. 10, fig. 10 is a schematic structural diagram of a first form marking device according to an embodiment of the present application, where the device includes the following modules 1001-1003:
a first unit item determining module 1001, configured to determine a unit item to be skipped marked in a table, as a target unit item, where the unit item includes a unit row and/or a unit column;
a first identifier determining module 1002, configured to determine a first identifier of another unit item, where the other unit item is: the unit items of the table except for the target unit item;
an identification marking module 1003, configured to mark the identification of the other unit item as the first identification.
In one embodiment of the present invention, the first identifier determining module is specifically configured to determine, according to an arrangement order of other unit items in the table, a first identifier of each other unit item.
In one embodiment of the present invention, the first identifier determining module is specifically configured to determine, according to an arrangement order of each first unit item in the table, a first identifier of each first unit item, where the first unit item is: each unit item in the reverse direction of the direction represented by the type of the target unit item; according to the arrangement sequence of the second unit items in the table, determining the first identification of each second unit item according to the first identification of each first unit item, wherein the second unit items are: each unit item in the forward direction of the direction represented by the type of the target unit item.
In one embodiment of the present invention, the first identifier determining module is specifically configured to determine, according to an arrangement order of each first unit item in the table, a first identifier of each first unit item, where the first unit item is: each unit item in the reverse direction of the direction represented by the type of the target unit item; determining a first identifier of each second unit item according to the arrangement sequence of each second unit item in the table, wherein the second unit item is: each unit item in the forward direction of the direction represented by the type of the target unit item.
Referring to fig. 11, fig. 11 is a schematic structural diagram of a second form marking device according to an embodiment of the present application, where the device further includes the following modules 1004-1006.
A second unit item determining module 1004, configured to determine a unit item that is re-marked in the marked table as a reference unit item;
a second identifier determining module 1005, configured to determine, in a case where the reference unit item is located before the target unit item, a second identifier of the reference unit item and each third unit item according to an arrangement order of the reference unit item and each third unit item in the table, and mark the identifiers of the reference unit item and each third unit item as the second identifier, where the third unit item is: a unit item between the reference unit item and the target unit item;
a third identifier determining module 1006, configured to determine, when the reference unit item is located after the target unit item, third identifiers of the reference unit item and each fourth unit item according to an arrangement order of the reference unit item and each fourth unit item in the table, and mark the identifiers of the reference unit item and each fourth unit item as the third identifiers, where the fourth unit item is: the unit items subsequent to the reference unit item.
In one embodiment of the present invention, the apparatus further includes:
the identification updating module is used for determining preset identifications of all unit items in the table and updating the identifications of all unit items into the preset identifications under the condition that an identification recovery operation triggered by a user in a user interface is received.
In one embodiment of the present invention, the target unit item includes: at least two consecutive rows of cells and/or at least two consecutive columns of cells.
In one embodiment of the present invention, the first unit item determining module is specifically configured to traverse unit items within a preset range in a table, find a unit item that meets a preset skip flag condition as a target unit item, where the skip flag condition includes at least one of the following conditions: blank row, blank column, cell row for displaying title, cell column for displaying title.
The embodiment of the present application further provides an electronic device, as shown in fig. 12, including a processor 1201, a communication interface 1202, a memory 1203, and a communication bus 1204, where the processor 1201, the communication interface 1202, and the memory 1203 perform communication with each other through the communication bus 1204,
a memory 1203 for storing a computer program;
The processor 1201 is configured to implement the table marking method when executing the program stored in the memory 1203.
The communication bus mentioned above for the electronic devices 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 also digital signal processors (Digital Signal Processing, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), field programmable gate arrays (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.
In yet another embodiment provided herein, a computer readable storage medium is also provided, in which a computer program is stored, which when executed by a processor, implements the steps of any of the table marking methods described above.
In yet another embodiment provided herein, there is also provided a computer program product containing instructions that, when run on a computer, cause the computer to perform any of the table marking methods of the above embodiments.
In the above embodiments, it may be implemented in whole or in part by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, produces a flow or function in accordance with embodiments of the present application, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable apparatus. The computer instructions may be stored in or transmitted from one computer-readable storage medium to another, for example, by wired (e.g., coaxial cable, optical fiber, digital Subscriber Line (DSL)), or wireless (e.g., infrared, wireless, microwave, etc.). The computer readable storage medium may be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that contains an integration of one or more available media. The usable medium may be a magnetic medium (e.g., floppy Disk, hard Disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., solid State Disk (SSD)), etc.
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 embodiments, the electronic device embodiments, the computer-readable storage medium embodiments, the computer program product embodiments, the description is relatively simple, as it is substantially similar to the method embodiments, and relevant places are referred to in the partial description of the method embodiments.
The foregoing description is only of the preferred embodiments of the present application and is not intended to limit the scope of the present application. Any modifications, equivalent substitutions, improvements, etc. that are within the spirit and principles of the present application are intended to be included within the scope of the present application.
Claims (10)
1. A method of marking a form, the method comprising:
determining a target cell item to be skipped marked in a table, wherein the cell item comprises a cell row and/or a cell column;
determining a first identification of other unit items, wherein the other unit items are: the unit items of the table except for the target unit item;
marking the identification of the other unit items as the first identification;
the method further comprises the steps of:
determining a re-marked unit item in the marked table as a reference unit item;
determining a second identifier of the reference unit item and each third unit item according to the arrangement sequence of the reference unit item and each third unit item in the table under the condition that the reference unit item is positioned before the target unit item, and marking the identifiers of the reference unit item and each third unit item as the second identifier, wherein the third unit item is: a unit item between the reference unit item and the target unit item;
Determining a third identifier of the reference unit item and each fourth unit item according to the arrangement sequence of the reference unit item and each fourth unit item in the table when the reference unit item is positioned behind the target unit item, and marking the identifiers of the reference unit item and each fourth unit item as the third identifier, wherein the fourth unit item is: the unit items subsequent to the reference unit item.
2. The method of claim 1, wherein determining the first identity of the other unit item comprises:
and determining the first identification of each other unit item according to the arrangement sequence of the other unit items in the table.
3. The method of claim 2, wherein determining the first identity of each other unit item according to the order in which the other unit items are arranged in the table comprises:
determining a first identifier of each first unit item according to the arrangement sequence of each first unit item in the table, wherein the first unit item is: each unit item in the reverse direction of the direction represented by the type of the target unit item;
according to the arrangement sequence of the second unit items in the table, determining the first identification of each second unit item according to the first identification of each first unit item, wherein the second unit items are: each unit item in the forward direction of the direction represented by the type of the target unit item.
4. The method of claim 2, wherein determining the first identity of each other unit item according to the order in which the other unit items are arranged in the table comprises:
determining a first identifier of each first unit item according to the arrangement sequence of each first unit item in the table, wherein the first unit item is: each unit item in the reverse direction of the direction represented by the type of the target unit item;
determining a first identifier of each second unit item according to the arrangement sequence of each second unit item in the table, wherein the second unit item is: each unit item in the forward direction of the direction represented by the type of the target unit item.
5. The method according to any one of claims 1-4, further comprising:
and under the condition that an identifier recovery operation triggered by a user in a user interface is received, determining preset identifiers of all unit items in the table, and updating the identifiers of all unit items to the preset identifiers.
6. The method of any one of claims 1-4, wherein the target unit item comprises: at least two consecutive rows of cells and/or at least two consecutive columns of cells.
7. The method according to any one of claims 1-4, wherein determining the cell entry to be skipped marked in the table comprises:
traversing unit items in a preset range in a table, and searching for unit items meeting preset skip mark conditions as target unit items, wherein the skip mark conditions comprise at least one of the following conditions: blank row, blank column, cell row for displaying title, cell column for displaying title.
8. A form marking apparatus, the apparatus comprising:
a first unit item determining module, configured to determine a unit item to be skipped marked in a table, as a target unit item, where the unit item includes a unit row and/or a unit column;
the first identification determining module is used for determining first identifications of other unit items, wherein the other unit items are: the unit items of the table except for the target unit item;
the identification marking module is used for marking the identification of the other unit items as the first identification;
the apparatus further comprises:
a second unit item determining module for determining a unit item re-marked in the marked table as a reference unit item;
A second identifier determining module, configured to determine, when the reference unit item is located before the target unit item, a second identifier of the reference unit item and each third unit item according to an arrangement order of the reference unit item and each third unit item in the table, and mark the identifiers of the reference unit item and each third unit item as the second identifier, where the third unit item is: a unit item between the reference unit item and the target unit item;
a third identifier determining module, configured to determine, when the reference unit item is located after the target unit item, third identifiers of the reference unit item and each fourth unit item according to an arrangement order of the reference unit item and each fourth unit item in the table, and mark the identifiers of the reference unit item and each fourth unit item as the third identifiers, where the fourth unit item is: the unit items subsequent to the reference unit item.
9. The electronic equipment is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory are communicated with each other through the communication bus;
A memory for storing a computer program;
a processor for implementing the method steps of any one of claims 1-7 when executing a program stored on a memory.
10. 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 steps of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110631104.2A CN113536750B (en) | 2021-06-07 | 2021-06-07 | Form marking method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110631104.2A CN113536750B (en) | 2021-06-07 | 2021-06-07 | Form marking method and device, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113536750A CN113536750A (en) | 2021-10-22 |
| CN113536750B true CN113536750B (en) | 2023-12-26 |
Family
ID=78124558
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110631104.2A Active CN113536750B (en) | 2021-06-07 | 2021-06-07 | Form marking method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113536750B (en) |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110427599A (en) * | 2019-06-06 | 2019-11-08 | 北京辰森世纪科技股份有限公司 | The statistical method and device of report subtotal, storage medium, electronic device |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7370271B2 (en) * | 2002-10-30 | 2008-05-06 | Actuate Corporation | Methods and apparatus for generating a spreadsheet report template |
| US10303344B2 (en) * | 2014-10-05 | 2019-05-28 | Splunk Inc. | Field value search drill down |
| US20180225270A1 (en) * | 2017-02-06 | 2018-08-09 | International Business Machines Corporation | Processing user action in data integration tools |
| US10372810B2 (en) * | 2017-04-05 | 2019-08-06 | Microsoft Technology Licensing, Llc | Smarter copy/paste |
-
2021
- 2021-06-07 CN CN202110631104.2A patent/CN113536750B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110427599A (en) * | 2019-06-06 | 2019-11-08 | 北京辰森世纪科技股份有限公司 | The statistical method and device of report subtotal, storage medium, electronic device |
Non-Patent Citations (1)
| Title |
|---|
| 妙用Excel的SUBTOTAL函数填充序列;任家印;《农村电气化》(第总第248期期);第59页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113536750A (en) | 2021-10-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3407221A1 (en) | Methods and devices for searching and displaying information on a terminal | |
| US7000195B2 (en) | Viewer system and method allocating a degree of importance to a network address based upon frequency of display | |
| JP2014116026A (en) | Hierarchical tag having community-based rating | |
| JP6826293B2 (en) | Information information system and its processing method and program | |
| CN109976599B (en) | Method, device and equipment for processing unread messages of application program | |
| US20130248597A1 (en) | Intellectual material object management method and system | |
| CN110674345A (en) | Video searching method and device and server | |
| CN113536750B (en) | Form marking method and device, electronic equipment and storage medium | |
| CN109359108B (en) | Report extraction method and device, storage medium and electronic equipment | |
| US20120246243A1 (en) | Electronic mail system, user terminal apparatus, information providing apparatus, and computer readable medium | |
| CN101593175A (en) | Communication information system and contact person's thereof correlating method | |
| CN112329409B (en) | Cell color conversion method and device and electronic equipment | |
| CN111835623B (en) | Unread message display method and device and electronic equipment | |
| CN109635829B (en) | Picture classification method, mobile terminal and computer storage medium | |
| JP2008299744A (en) | Business form input support system, program and recording medium | |
| CN110728113A (en) | Information screening method and device of electronic forms and terminal equipment | |
| JP2007323474A (en) | Ocr system, ocr format parameter preparation method, its program and program recording medium | |
| CN107766563B (en) | Method and device for updating data, storage medium and electronic equipment | |
| CN110795922B (en) | Form information display method and device for PDF document and electronic equipment | |
| CN105893402A (en) | Information displaying method used for terminal equipment, and terminal equipment | |
| JP2011197983A (en) | Information display device and information display program | |
| CN111460304B (en) | Information display method, electronic device and readable storage medium | |
| CN107783668A (en) | Electronic equipment and character input control method | |
| US10509543B2 (en) | Control method for ordering of a displayed list, and control apparatus and storage medium provided therewith | |
| CN112307716A (en) | Document content export method, export device, electronic equipment and storage medium |
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 |