CN113536750A - Table marking method and device, electronic equipment and storage medium - Google Patents
Table marking method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN113536750A CN113536750A CN202110631104.2A CN202110631104A CN113536750A CN 113536750 A CN113536750 A CN 113536750A CN 202110631104 A CN202110631104 A CN 202110631104A CN 113536750 A CN113536750 A CN 113536750A
- Authority
- CN
- China
- Prior art keywords
- unit
- item
- unit item
- identifier
- items
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 45
- 238000004891 communication Methods 0.000 claims description 19
- 238000004590 computer program Methods 0.000 claims description 13
- 238000011084 recovery Methods 0.000 claims description 7
- 230000001960 triggered effect Effects 0.000 claims description 5
- 238000002372 labelling Methods 0.000 claims description 3
- 238000012545 processing Methods 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 23
- 230000008569 process Effects 0.000 description 6
- 230000009471 action Effects 0.000 description 4
- 238000005516 engineering process Methods 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
- 239000000835 fiber Substances 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
Images
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- User Interface Of Digital Computer (AREA)
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 unit item to be skipped from a table as a target unit item, wherein the unit item comprises a unit row and/or a unit column; determining first identifications of other unit items; marking the identification of the other unit item as the first identification. Therefore, by applying the scheme provided by the embodiment of the application, the number of the unit items used for displaying the specific content in the table can be counted conveniently.
Description
Technical Field
The present application relates to the field of file processing technologies, and in particular, to a form marking method and apparatus, an electronic device, and a storage medium.
Background
With the rapid development of file processing technology, the application of forms is more and more extensive. Usually, the cell entries in the table are labeled, the cell entries may be cell rows or cell columns, and based on the labeled information, the number of the cell entries in the table may be counted.
Taking fig. 1 as an example, fig. 1 is a schematic diagram of an enterprise employee table, in fig. 1, "XX" represents an employee name, a column on the left side of the table is provided with a numeric row mark, a column mark with a letter is provided on the upper end row, when the number of unit items is counted based on information of the unit item marks, if a title or a header appears, the prior art marks only count and see all rows and columns, and the number of the unit items used for displaying specific contents in the table cannot be counted.
Disclosure of Invention
An object of the embodiments of the present application is to provide a table marking method, apparatus, electronic device, and storage medium, so as to solve the technical problem that, if a title or a header appears, the marking in the prior art can only count and see all rows and columns, and cannot count the number of unit items for displaying specific content in a 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 unit item to be skipped from a table as a target unit item, wherein the unit item comprises a unit row and/or a unit column;
determining a first identifier of other unit items, wherein the other unit items are: the unit items except the target unit item in the unit items of the table;
marking the identification of the other unit item as the first identification.
In an 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 an embodiment of the present invention, the determining the first identifier of each other unit entry according to the arrangement order of the other unit entries 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 as follows: each unit item in the reverse direction of the direction represented by the type of the target unit item; determining the first identifier of each second unit item according to the arrangement sequence of each second unit item in the table and the first identifier of each first unit item, wherein the second unit items are as follows: and each unit item is positioned in the positive direction of the direction represented by the type of the target unit item.
In an embodiment of the present invention, the determining the first identifier of each other unit entry according to the arrangement order of the other unit entries 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 as follows: 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 items are as follows: and each unit item is positioned in the positive direction of the direction represented by the type of the target unit item.
In an embodiment of the present invention, the method further includes:
determining a relabeled unit item in the marked table as a reference unit item;
under the condition that the reference unit item is located before the target unit item, according to the arrangement sequence of the reference unit item and each third unit item in the table, determining second identifications of the reference unit item and each third unit item, and marking the identifications of the reference unit item and each third unit item as the second identifications, wherein the third unit item is: a unit item between the reference unit item and the target unit item;
determining third identifications of the reference unit item and the fourth unit items according to the arrangement sequence of the reference unit item and the fourth unit items in the table under the condition that the reference unit item is positioned behind the target unit item, and marking the identifications of the reference unit item and the fourth unit items as the third identifications, wherein the fourth unit items are as follows: a unit item following the reference unit item.
In an embodiment of the present invention, the method further includes: and under the condition of receiving an identifier recovery operation triggered by a user in a user interface, determining a preset identifier of each unit item in the table, and updating the identifier of each unit item into the preset identifier.
In an 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 an embodiment of the present invention, the determining the cell entry to be skipped from the table includes: traversing the unit items in a preset range in the table, and searching the unit items meeting a preset skipping marking condition as target unit items, wherein the skipping marking condition comprises at least one of the following conditions: blank rows, blank columns, cell rows for displaying a title, and cell columns for displaying a title.
In a second aspect, an embodiment of the present invention provides a form marking apparatus, where the apparatus includes:
the first unit item determining module is used for determining a unit item to be skipped and marked in a table as a target unit item, wherein the unit item comprises a unit row and/or a unit column;
a first identifier determining module, configured to determine a first identifier of another unit item, where the another unit item is: the unit items except the target unit item in the unit items of the table;
and the identification marking module is used for marking the identifications of the other unit items as the first identifications.
In an embodiment of the present invention, the first identifier determining module is specifically configured to determine the first identifier of each other unit item according to an arrangement order of the other unit items in the table.
In an embodiment of the present invention, the first identifier determining module is specifically configured to determine the first identifier of each first unit item according to an arrangement order of each first unit item in the table, 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 the first identifier of each second unit item according to the arrangement sequence of each second unit item in the table and the first identifier of each first unit item, wherein the second unit items are as follows: and each unit item is positioned in the positive direction of the direction represented by the type of the target unit item.
In an embodiment of the present invention, the first identifier determining module is specifically configured to determine the first identifier of each first unit item according to an arrangement order of each first unit item in the table, 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 items are as follows: and each unit item is positioned in the positive direction of the direction represented by the type of the target unit item.
In an embodiment of the present invention, the apparatus further includes:
a second cell item determining module, configured to determine a relabeled cell item in the marked table as a reference cell item;
a second identifier determining module, configured to determine, according to an arrangement order of the reference unit item and each third unit item in the table, a second identifier of the reference unit item and each third unit item, 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, according to an arrangement order of the reference unit item and the fourth unit items in the table, third identifiers of the reference unit item and the fourth unit items when the reference unit item is located behind the target unit item, and mark the identifiers of the reference unit item and the fourth unit items as the third identifiers, where the fourth unit item is: a unit item following the reference unit item.
In an embodiment of the present invention, the apparatus further includes: and the identifier updating module is used for determining the preset identifier of each unit item in the table and updating the identifier of each unit item into the preset identifier under the condition of receiving the identifier recovery operation triggered by the user in the user interface.
In an 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 an embodiment of the present invention, the first unit item determining module is specifically configured to traverse unit items in a preset range in a table, and search for a unit item meeting a preset skip flag condition as a target unit item, where the skip flag condition includes at least one of the following conditions: blank rows, blank columns, cell rows for displaying a title, and cell columns for displaying a 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 and the communication interface complete communication between the memory and the processor through the communication bus;
a memory for storing a computer program; a processor for implementing the method steps of any of the first aspect when executing a program stored in the memory.
In a fourth aspect, the present application provides a computer-readable storage medium, in which a computer program is stored, and the computer program, when executed by a processor, implements the method steps of any one of the first aspect.
When the scheme provided by the embodiment of the application is applied to table marking, firstly, the unit item to be skipped to be marked in the table is determined as a target unit item, wherein the unit item comprises a unit row and/or a unit column, and then the unit items except the target unit item are marked according to a preset sequence. When the table is marked, the marking of the unit rows and/or the unit columns which are not expected to be marked can be skipped, and all the unit rows and/or the unit columns are not marked, so that the number of the unit items used for displaying specific contents in the table can be conveniently counted based on the marked information.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art that other embodiments can be obtained by using the drawings without creative efforts.
FIG. 1 is a schematic diagram of a prior art form mark;
fig. 2 is a schematic flowchart of a first table marking method according to an embodiment of the present application;
FIG. 3 is a schematic diagram of a menu item provided by an embodiment of the present application;
FIG. 4a is a schematic diagram of a first table provided in an embodiment of the present application;
FIG. 4b is a schematic diagram of a second table provided in the embodiments of the present application;
FIG. 5a is a schematic diagram of a third table provided in the embodiments of the present application;
FIG. 5b is a schematic diagram of a fourth table provided in the embodiments of the present application;
fig. 6 is a schematic flowchart of a second table marking method according to an embodiment of the present application;
FIG. 7 is a schematic diagram of another menu item provided in an embodiment of the present application;
FIG. 8a is a schematic diagram of a fifth table provided in the embodiments of the present application;
FIG. 8b is a schematic diagram of a sixth table provided in the embodiments of the present application;
FIG. 8c is a schematic diagram of a seventh table provided in the embodiments of the present application;
FIG. 8d is a schematic diagram of an eighth table provided in the embodiments of the present application;
FIG. 9a is a schematic diagram of a ninth table provided in the embodiments of the present application;
FIG. 9b is a schematic diagram of a tenth table provided in the embodiments of the present application;
fig. 10 is a schematic structural diagram of a first table marking apparatus according to an embodiment of the present application;
fig. 11 is a schematic structural diagram of a second table marking apparatus according to an embodiment of the present application;
fig. 12 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
In order to count the number of specific unit items in a table, embodiments of the present application provide a table marking method, an apparatus, an electronic device, and a storage medium, which are described in detail below.
First, an application scenario of the embodiment of the present invention is explained.
The embodiment of the invention is applied to an application scene of counting unit items for displaying specific contents in a table.
Since the unit items are usually marked in the prior art in the order from top to bottom according to all the unit items, in the application scenario, the counted number of unit items cannot count the actual number of unit items showing actual specific contents in a certain table, and the counted result always includes the number of rows or columns of the title or the header.
Taking fig. 1 as an example, assume that the unit items for displaying specific contents in fig. 1 are: the unit items labeled "3", "4" and "5" are counted as 5 in the related art labeling method, but actually the actual number of unit items for displaying specific contents is 3, so the accuracy of the counted number is low.
Referring to fig. 2, fig. 2 is a schematic flowchart of a first table marking method provided in the 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, Microsoft Office and the like. The table marking method includes the following steps 201 to 203.
Wherein the cell item includes a cell row and/or a cell column.
The target unit item refers to a unit item to be skipped, that is, the target unit item is a unit item that does not need to be marked. The target cell item may comprise a target cell row and/or a target cell column, the target cell row: the unit row of the mark to be skipped, the target unit column is: the marked cell columns are to be skipped.
In some cases, there are rows and/or columns of cells in the table that are to be skip marked. For example: for blank rows and columns in the table, marks can be skipped; the marking can be skipped for the cell rows and cell columns in the table for displaying the title; the marking can be skipped for cell rows and cell columns in the table that do not show specific content. The above-mentioned cell row and/or cell column to be skip-marked may be taken as a target cell item.
The number of the target unit items may be 1 or more. When the number of the target unit items is multiple, in an embodiment of the present invention, 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 non-continuous rows of cells and/or at least two non-continuous columns of cells.
Specifically, when the target unit item is a unit row and/or a unit column for displaying a title, consecutive unit rows and/or unit columns may need to be occupied, and therefore, 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 from which a mark is selected by a user. In one embodiment, the user may move the cursor to the position of the unit item in the table on the user interface by moving the mouse, and trigger a click operation for indicating that the unit item is the unit item to be skipped. When the client detects the clicking operation of the user, the unit item clicked by the user is determined as a target unit item.
Specifically, a user may select and click a cell item to be skipped and marked in the table, a preset menu item is popped up, the menu item includes an option button representing that the selected cell item needs to be skipped and marked, and after the click operation of the option button by the user is detected, the cell item selected by the user may be determined as a target cell item to be skipped and marked.
Taking fig. 3 as an example, fig. 3 is a schematic diagram of a menu item provided in the embodiment of the present application. As shown in fig. 3, the menu items include option buttons such as "copy", "cut", "paste", and the like, where the option button "skip the current line number" indicates that the currently selected cell line needs to be skipped, and when the option button "skip the current line number" in the menu item is reselected after the cell line selected by the user is detected, it may be considered that the user needs the electronic device to skip the mark for the selected cell line, so the selected cell line may be used as the target cell item.
In another embodiment, the user may also input the position of the cell item in the table on the user interface as the cell item to be skipped. The client 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: first identifications of other unit items are determined.
The other unit items are as follows: the unit items except the target unit item in each unit item of the table. The target unit item is a unit item to be skip-marked, and the other unit items are unit items to be marked.
The first identifier refers to a value of an identifier parameter item of another unit item, that is, a value of an identifier of another unit item. The first mark may be in the form of a number "1, 2,3 … …", so that the number of rows of cells other than the target cell row may be directly determined according to the mark, and in addition, may be in the form of a letter "A, B, C … …".
In order to improve the efficiency and accuracy of the identification determination, in an 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 cell items in the table includes an order from top to bottom and an order from left to right.
Taking fig. 4a as an example, the dark color area in the table shown in fig. 4a is used to display the logo, and the cell row located in the third row among the cell rows except the dark color area: a target unit item; the unit rows positioned in the first row, the second row, the fourth row and the fifth row are as follows: other unit items; wherein, the arrangement sequence of other unit items in the table is: the cell line comprises a first line of cell lines, a second line of cell lines, a fourth line of cell lines and a fifth line of cell lines.
The cell column in the third column of the cell columns in the table shown in fig. 4a, excluding the dark color region, is: a target unit item; the unit columns in the first column, the second column, the fourth column and the fifth column are as follows: other unit items; wherein, the arrangement sequence of other unit columns in the table is as follows: the cell array comprises a first column of cell columns, a second column of cell columns, a fourth column of cell columns and a fifth column of cell columns.
Specifically, when the first identifier of each other unit item is determined, the first identifiers of the other unit items may be sequentially determined according to an order of the other unit items arranged from top to bottom or from left to right in the table.
For example: taking fig. 4a as an example, when the arrangement order of other cell items in the table is: when the cell rows in the first row, the cell rows in the second row, the cell rows in the fourth row, and the cell rows in the fifth row are arranged in the above order, the cell rows in the first row are identified as "1", the cell rows in the second row are identified as "2", the cell rows in the fourth row are identified as "3", and the cell rows in the fifth row are identified as "4";
when the arrangement sequence of other unit items in the table is: when the first column unit column, the second column unit column, the fourth column unit column, and the fifth column unit column are arranged in the above order, the first column unit column may be identified as "1", the second column unit column may be identified as "2", the fourth column unit column may be identified as "3", and the fifth column unit column may be 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 determined first, 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.
When determining the identifier of the unit item located in the first row/first column, the identifier input by the user may be used as the identifier of the unit item located in the first row/first column, for example: assuming that the identification input by the user is "3", the "3" can be taken as the identification of the unit item located in the first row/first column. It is also possible to use a preset identifier as the identifier of the unit item located in the first row/first column, where the preset identifier may be set by a worker according to experience, for example: the preset flag may be "1" or "a".
After the identification of the unit item positioned in the first row/first column is determined, the identification of each other unit item is sequentially determined according to the arrangement sequence of each other unit item in the table.
Along with fig. 4a, the identifier of the unit item in the first row is "1", and "2, 3, 4" are respectively used as the identifiers of the other unit items according to the arrangement order of the other unit items in the table, wherein the identifier of the unit row in the second row is: "2", the identification of the cell rows of the fourth row is: the cell row of the "3" fifth row is identified as: "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 also be used as the first identifier of each unit item; and determining the first identifier of each unit item behind the target unit item based on the preset identifier of the target unit item.
And under the default condition, all the unit rows have corresponding preset identifications, and all the unit columns have corresponding preset identifications.
The target unit item is a unit item to be skipped from which a mark is to be skipped, and the preset identification of each unit item after the target unit item needs to be changed, while the preset identification of each unit item before the target unit item does not need to be changed.
Based on this, the preset identifier of each unit item before the target unit item can be directly determined as the first identifier of each unit item.
When determining the identifiers of the unit items located after the target unit item, the preset identifier of the target unit item may be used as the identifiers of the adjacent unit items located after the target unit item, and then the identifiers of the unit items located after the target unit item are determined.
For example: assuming that the third row of cells is a target cell item and the preset identifier of the target cell item is "3", the cell items following the target cell item include: a fourth row of cells, a fifth row of cells, a sixth row of cells, … …, wherein the fourth row of cells is: the adjacent cell item located after the target cell item, so "3" can be determined as the identification of the fourth row of cell lines, and further, the identification of the fifth row of cell lines can be determined as: "4", identification of the sixth row of cell rows: "5", … …. Therefore, the first identification of each other unit item can be quickly determined according to the arrangement sequence of each other unit item in the table, and the identification determination efficiency is improved.
Step 203: the identifications of the other unit items are marked as first identifications.
The identification of the unit item refers to the identification parameter item of the unit item.
Marking the identification of the other unit item as the first identification means: and marking the value of the identification parameter item of other unit items in the user interface as a first identification.
Specifically, the following two cases may be included in the labeling:
in the first case, the identifier of each unit item in the table has an initial value, and in this case, when the identifiers of other unit items are marked, the initial values of the identifiers of other unit items in the user interface are updated to the first identifier.
For example: assuming that the initial value of the identifier of the unit item 1 in the table 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 unit item 2 is the target unit item, the first identifiers of the other unit items after re-determination are respectively: and updating the initial values of the identifiers of other unit items in the user interface according to the first identifier to realize the identifier marking process of other unit items, wherein 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, and the first identifier of the unit item 5 is 4.
In the second case, the value of the identifier of each unit item in the table does not have the initial value, and in this case, when the identifiers of other unit items are marked, the value of the identifiers of other unit items in the user interface is directly determined as the first identifier.
For example: assuming 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, where the unit item 2 is a target unit item, and the first identifiers of the other unit items after re-determination are: 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, the value of the identifier of each other unit item in the table in the user interface is marked as the first identifier, and the identifier marking process of 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 the other cell columns are marked, the marking may be performed in the uppermost cell in the other cell columns.
Taking fig. 4b as an example, in fig. 4b, the cell row in the third row is the target cell row, and the other cell rows are: the cell rows other than the target cell row, as can be seen from fig. 4b, the first row of cell rows is labeled: "1", the second row of cell rows is labeled: "2", the fourth row of cell rows is labeled: "3", the fifth row of cells is labeled: "4".
Based on the marked first identification, the number of unit items in the table can be counted conveniently. As in fig. 4b, the number of unit items in the table for displaying specific contents may be directly determined to be 10.
The target unit item may be a unit row/unit column for displaying a title, and the target unit item is a unit item to be skipped from marking, that is, when the scheme provided by this embodiment is used for marking, the unit row/unit column for displaying the title is not marked, so that the number of unit items for displaying specific content can be counted conveniently.
As can be seen from the above, when the scheme provided by this embodiment is applied to table marking, marking may be performed by skipping the cell rows and/or cell columns that are not desired to be marked, and not marking all the cell rows and/or cell columns, and based on the marked information, the number of the cell items used for displaying specific content in the table can be counted conveniently.
In an embodiment of the present invention, the determining the first identifier in step 202 may be implemented in the following two ways.
In a first mode, the first identifier of each first unit item is determined according to the arrangement sequence of each first unit item in the table, and the first identifier of each second unit item is determined according to the arrangement sequence of each second unit item in the table and according to the first identifier.
The second mode is as follows: 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 identifier of each second unit item according to the arrangement sequence of each second unit item in the table.
The first unit item is: the unit items in the reverse direction of the direction represented by the type of the target unit item. The second unit term is: the unit items are in the positive direction of the direction represented by the type of the target unit item.
The types of the target unit item comprise a unit row and a unit 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: the vertical direction from the target cell item, further, the cell item identification of the table is usually sequentially increased from top to bottom. Thus, the forward direction of the direction characterized by the type of the target unit item is: starting from the target unit item, a vertically downward direction, the second unit item being: each cell row in a vertically downward direction from the target cell item; the reverse of the direction characterized by the type of the target unit item is: starting from the target unit item in the vertical upward direction, the first unit item is: each cell row in a vertically upward direction 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, the direction of the vertical down arrow is the vertical down direction from the target unit item, so the direction of the vertical down arrow is the positive direction of the direction represented by the type of the target unit item, and the second unit item is: each cell row in a vertically downward direction from the target cell item;
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 represented by the type of the target unit item, and the first unit item is: each cell row in a vertically upward direction 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: the horizontal direction from the target cell entry, further, since the cell entry identification of the table is usually sequentially increased from left to right. Thus, the forward direction of the direction characterized by the type of the target unit item is: starting from the target unit item in the horizontal right direction, the second unit item is: cell columns in the horizontal right direction from the target cell item; the reverse of the direction characterized by the type of the target unit item is: starting from the target unit item in the horizontal left direction, the first unit item is: cell columns in the horizontal left direction are started from the target cell item.
Taking fig. 5b as an example, the cell item marked as empty in fig. 5b is the target cell item, the direction of the horizontal right arrow is the horizontal right direction from the target cell item, so the direction of the horizontal right arrow is the positive direction of the direction represented by the type of the target cell item, and the second cell item is: cell columns in the horizontal right direction from the target cell item;
the direction of the horizontal left arrow is the horizontal left direction from the target unit item, so the direction of the horizontal left arrow is the reverse of the direction represented by the type of the target unit item, and the first unit item is: cell columns in the horizontal left direction are started from the target cell item.
The specific procedures for determining the first identifier are different between the first and second manners, and are described below.
When the first identifier is determined by the first method, 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 first row/column in the second unit item may be determined according to the first identifier of the unit item located in the last row/column in each first unit item, and then 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 unit item includes: the first row of unit rows, the second row of unit rows and the third row of unit rows, and the second unit item comprises: when determining the first identifier of the first cell item, the fifth, sixth, and seventh cell lines may determine that the identifier of the first cell line is "1", the identifier of the second cell line is "2", and the identifier of the third cell line is "3", according to the arrangement order of the first cell items in the table;
in determining the first identity of the second unit item, due to the third row unit action: the cell entry in the first cell entry located in the last row, and identified as "3", the cell row in the fifth row: in the second unit item, the unit item located in the first row may determine, according to the identifier of the third row unit item, that the identifier of the fifth row unit item is "4", and further may determine that the identifier of the sixth row unit item is "5" and the identifier of the seventh row unit item is "6".
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 related, so that the application scene of overall statistics on the number of data in the table can be met, and the actual requirements of users are better met.
When the first identifier is determined by adopting the second mode, determining the first identifier of each first unit item according to the arrangement sequence of each first unit item in the table; and determining the first identifier of each second unit item according to the arrangement sequence of each second unit item in the table.
For example: following the above example, when determining the first identifier of the first cell entry, according to the arrangement order of the first cell entries in the table, it may be determined that the identifier of the first row of cell rows is "1", the identifier of the second row of cell rows is "2", and the identifier of the third row of cell rows is "3"; when determining the first identifier of the second cell item, the identifier of the fifth cell row may be determined to be "1", the identifier of the sixth cell row may be determined to be "2", and the identifier of the seventh cell row may be determined to be "3", according to the arrangement order of the second cell items in the table.
In this case, it can be understood that the table includes a plurality of sub-tables, and since the target unit entry is not identified and the first identifications of the first unit entry and the second unit entry are separately determined, statistics on the number of unit entries in each sub-table can be conveniently performed.
Referring to fig. 6, fig. 6 is a flowchart illustrating a second form marking method according to an embodiment of the present application, and after the step 203, the following steps 204 and 206 may also be included.
Step 204: and determining the relabeled unit item in the marked table as a reference unit item.
In some cases, the marked identifiers in the table cannot meet the needs of the user, or the identifiers are wrong, and the user can select the unit items needing to be marked again in the marked table.
In one embodiment, the user may move the cursor to the location of the cell item in the table on the user interface by moving the mouse, and trigger a click operation to indicate that the cell item is a relabeled 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 a reference unit item.
Specifically, the user may select and click the unit item re-marked in the table, pop up a preset menu item, where the menu item includes an option button 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 may be determined to be a reference unit item re-marked.
Taking fig. 7 as an example, fig. 7 is a schematic diagram of another menu item provided in the embodiment of the present application. As shown in fig. 7, the menu items include option buttons such as "copy", "cut", "paste", and the like, where the option button "mark from the current row" indicates that the currently selected cell row needs to be re-marked, and when the cell row selected by the user and the option button "mark from the current row" in the above menu items are detected, it may be considered that the user needs the electronic device to re-mark the selected cell row, so the current row 5 may be used as a reference cell item.
In another embodiment, the user may enter the location of the cell item in the table on the user interface as a relabeled cell item.
In this case, when determining the reference cell item, a cell item corresponding to the position may be determined in the table based on the position of the cell item in the table input by the user, and the determined cell item may be used as the reference cell item.
Step 205: and under the condition that the reference unit item is positioned in front of the target unit item, determining second identifications of the reference unit item and the third unit items according to the arrangement sequence of the reference unit item and the third unit items in the table, and marking the identifications of the reference unit item and the third unit items as the second identifications.
The third unit item is: unit items between the reference unit item and the target unit item.
Taking fig. 8a as an example, the unit item marked as empty in fig. 8a is a target unit item, and the unit item marked as 3 is a reference unit item, 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 a third unit item.
When determining the reference unit item and the identifiers of the third unit items, the second identifier of the reference unit item may be determined first, the identifier of each third unit item may be determined based on the determined identifier of the reference unit item and the arrangement order of the reference unit item and the third unit items in the table, and the determined identifier of the reference unit item and the identifier of the third unit item may be used as the second identifier. .
When 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 identifier input by the user is "3", the "3" can be used as the identifier of the reference unit item. The preset identifier may also be an identifier of a reference unit item, and the preset identifier may be set by a worker according to experience, for example: the preset flag may be "1" or "a".
After the identifier of the reference unit item is determined, the number of unit item intervals between each third unit item and the reference unit item can be determined according to the arrangement sequence of the reference unit item and each third unit item in the table, and the identifier of each third unit item can be determined based on the identifier of the reference unit item and the number of unit item intervals corresponding to each third unit item.
Referring to fig. 8a, the reference cell item is the third row of cell rows, the target cell item is the seventh row of cell rows, and each third cell item sequentially is: the fourth row unit row, the fifth row unit row and the sixth row unit row, assuming that the re-determined reference unit item is identified as "1", and the unit row interval number of the interval between the fourth row unit row and the third row unit row is 1, the identification of the fourth row unit row can be calculated as: 1+1 ═ 2, i.e., "2", and in this way, the identification of the fifth row of elements can be calculated as: "3", the sixth row of cells is identified as "4".
And after determining the second identifications of the reference unit item and each third unit item, marking the identifications of the reference unit item and each third unit item as the second identifications.
Specifically, the identifier of the unit item located before the reference unit item may determine whether to be reserved based on actual needs of the user, and in a case where the user triggers a clearing operation in the user interface to indicate that the identifier of the unit item before the reference unit item is cleared, the identifier of each unit item before the reference unit item may be cleared.
And the identification of the unit item after the target unit item can keep the marked identification unchanged; the identities of the unit items subsequent to the target unit item may also be calculated based on the identities of the unit items adjacent to and before the target unit item, and the calculated identities relabeled to the identities of the unit items subsequent to the target unit item.
For example: assuming that the identifier of the unit item adjacent to the target unit item is 4, the identifiers of the unit items after the target unit item can be calculated as follows: 5. 6,7,8,9 … ….
Taking fig. 8b as an example, fig. 8b is: the table diagram obtained by marking the reference unit item and the identifiers of the third unit items in fig. 8a as third identifiers can be seen from fig. 8b that the identifiers of the unit items before the reference unit item are cleared.
Comparing fig. 8b and fig. 8a, the identifier of the reference unit item is marked as "1", the identifiers of the third unit items are respectively marked as "2", "3" and "4" in sequence, the identifiers of the unit items before the reference unit item are all empty, and the unit items after the target unit item are marked as "5" and "6".
Of course, if the user does not trigger the clearing operation, the identifier of the unit item before the reference unit item may be kept unchanged.
Step 206: and under the condition that the reference unit item is positioned behind the target unit item, determining the identifications of the reference unit item and the fourth unit items according to the arrangement sequence of the reference unit item and the fourth unit items in the table, and marking the identifications of the reference unit item and the fourth unit items as third identifications.
The fourth unit item is: the unit item following the unit item is referred to.
Taking fig. 8c as an example, the unit item marked as empty in the rectangular box in fig. 8c is a target unit item, and the unit item marked as 4 is a reference unit item, and it can be seen that the reference unit item is located behind the target unit item, and each unit item behind the reference unit item is a fourth unit item.
When determining the reference unit item and the identifiers of the fourth unit items, the identifier of the reference unit item may be determined first, the identifier of each fourth unit item may be determined based on the determined identifier of the reference unit item and the arrangement order of the reference unit item and the fourth unit items in the table, and the identifier of the reference unit item and the identifier of the fourth unit item may be used as the third identifier.
The specific manner of determining the identity of the reference unit item can be seen in the manner of determining the identity of the reference unit item in step 204.
After the identifier of the reference unit item is determined, the unit item interval number of the interval between each fourth unit item and the reference unit item can be determined according to the arrangement sequence of the reference unit item and each fourth unit item in the table, and the identifier of each fourth unit item can be determined based on the identifier of the reference unit item and the unit item interval number corresponding to each fourth unit item.
Along with fig. 8c, the reference cell item is the fifth row of cell rows, the target cell item is the third row of cell rows, and each fourth cell item is in turn: the sixth row of cell rows, the seventh row of cell rows, and the eighth row of cell rows, assuming that the re-determined reference cell item is identified as "1" and the number of cell row intervals between the sixth row of cell rows and the fifth row of cell rows is 1, the identification of the sixth row of cell rows can be calculated as: 1+1 ═ 2, i.e., "2", and in this way, the identity of the seventh row of elements can be calculated as: "3", the eighth row of cell rows is identified as "4".
And after determining the third identifiers of the reference unit item and each fourth unit item, marking the identifiers of the reference unit item and each fourth unit item as the third identifiers.
Specifically, the identifier of the unit item located between the target unit item and the reference unit item may determine whether to reserve based on actual needs of the user, and in a case where the user triggers an emptying operation in the user interface for indicating the identifier of the unit item between the target unit item and the reference unit item, the identifier of the unit item between the target unit item and the reference unit item may be cleared.
Of course, if the user does not trigger the clearing operation, the identifier 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 table diagram obtained by marking the identifiers of the reference unit item and the fourth unit items in fig. 8c as the third identifiers can be seen from fig. 8d that the identifiers of the unit items between the reference unit item and the target unit item are cleared.
Comparing fig. 8d and 8c, the identification of the reference unit item is marked as "1", the identifications of the fourth unit items are respectively marked as "2", "3", "4", "5" in order, and the identifications of the unit items between the reference unit item and the target unit item are null.
In this way, when the cell item in the table needs to be re-marked, the reference cell item that needs to be re-marked is determined, so that the second cell item after the reference cell item or the first identifier of the first cell item between the reference cell item and the target cell item is re-determined, so as to adapt to the need of re-marking the cell item in the table.
In an embodiment of the present invention, in a case where an identifier recovery operation triggered by a user in a user interface is received, a preset identifier of each unit item in a table may also be determined, and the identifier of each unit item is updated to the preset identifier.
In a common situation, the identifiers of the unit items in the table all have preset identifiers. When a user needs to restore the identifier of each unit item in the table, the user may trigger the identifier restoring operation, where the identifier restoring operation is used to instruct to restore the identifier of each unit item in the table.
Specifically, an identifier recovery button may be set in the user interface, and it is determined that the user needs to recover the identifier of each cell item of the table by detecting a click operation of the user that triggers the identifier recovery button. In this case, the preset identification of each unit item may be determined, and the identification of each unit item may be updated to the preset identification.
Taking fig. 9a and 9b as an example, the unit row in the fifth row in fig. 9a is the target unit row, and the labels of the unit rows except the unit row in the fifth row are, in order from top to bottom: "1, 2,3,4,5,6,7,8, 9", the identification of each unit item shown in fig. 9b is: after the identification of each unit item is recovered on the basis of fig. 9a, the identification of each unit row is, from top to bottom: "1,2,3,4,5,6,7,8,9,10".
Therefore, the marks of all the unit items in the marked table can be recovered, and the requirement for recovering the marks of the unit items is met.
In an embodiment of the present application, when determining the target cell item, the cell items in a preset range in the table may be traversed, and the cell item satisfying a preset skip flag condition is searched as the target cell item.
Wherein the skip flag condition includes at least one of the following conditions: blank rows, blank columns, cell rows for displaying a title, and cell columns for displaying a title.
Characters do not exist in all cells in the blank rows and the blank columns;
the unit row for displaying the title and the unit column for displaying the title have a cell for displaying the title content.
Specifically, the marking may be skipped, that is, not performed, for a blank row, a blank column, a unit row for displaying a title, a unit column for displaying a title, and the like. Therefore, the cell item meeting the above condition can be searched in the table, and the searched cell item is taken as the target cell item to be skipped and marked.
In an embodiment of the present application, the skip flag condition may be a preset condition, or may be a user-defined skip flag condition.
Specifically, the electronic device may provide a condition input box, and obtain a condition input by the user in the condition input box as a skip flag condition. A plurality of candidate conditions can also be provided, one or more conditions selected by a user from the plurality of candidate conditions are obtained, and the conditions are combined to obtain the skip mark condition.
Referring to fig. 10, fig. 10 is a schematic structural diagram of a first form marking device provided in the embodiment of the present application, where the device includes the following modules 1001 and 1003:
a first unit item determining module 1001, configured to determine a unit item to be skipped from 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 first identifiers of other unit items, where the other unit items are: the unit items except the target unit item in the unit items of the table;
an identifier tagging module 1003, configured to tag the identifier of the other unit item as the first identifier.
In an embodiment of the present invention, the first identifier determining module is specifically configured to determine the first identifier of each other unit item according to an arrangement order of the other unit items in the table.
In an embodiment of the present invention, the first identifier determining module is specifically configured to determine the first identifier of each first unit item according to an arrangement order of each first unit item in the table, 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 the first identifier of each second unit item according to the arrangement sequence of each second unit item in the table and the first identifier of each first unit item, wherein the second unit items are as follows: and each unit item is positioned in the positive direction of the direction represented by the type of the target unit item.
In an embodiment of the present invention, the first identifier determining module is specifically configured to determine the first identifier of each first unit item according to an arrangement order of each first unit item in the table, 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 items are as follows: and each unit item is positioned in the positive 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 table marking device provided in the embodiment of the present application, and the device further includes the following modules 1004 and 1006.
A second unit item determining module 1004, configured to determine a relabeled unit item in the marked table as a reference unit item;
a second identifier determining module 1005, configured to, when the reference unit item is located before the target unit item, determine second identifiers of the reference unit item and the third unit items according to an arrangement order of the reference unit item and the third unit items in the table, and mark the identifiers of the reference unit item and the third unit items as the second identifiers, 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 third identifiers of the reference unit item and the fourth unit items according to an arrangement order of the reference unit item and the fourth unit items in the table when the reference unit item is located behind the target unit item, and mark the identifiers of the reference unit item and the fourth unit items as the third identifiers, where the fourth unit item is: a unit item following the reference unit item.
In an embodiment of the present invention, the apparatus further includes:
and the identifier updating module is used for determining the preset identifier of each unit item in the table and updating the identifier of each unit item into the preset identifier under the condition of receiving the identifier recovery operation triggered by the user in the user interface.
In an 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 an embodiment of the present invention, the first unit item determining module is specifically configured to traverse unit items in a preset range in a table, and search for a unit item meeting a preset skip flag condition as a target unit item, where the skip flag condition includes at least one of the following conditions: blank rows, blank columns, cell rows for displaying a title, and cell columns for displaying a title.
An 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 complete 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 steps when executing the program stored in the memory 1203.
The communication bus mentioned in the electronic device may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The communication bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown, but this does not mean that there is only one bus or one type of bus.
The communication interface is used for communication between the electronic equipment and other equipment.
The Memory may include a Random Access Memory (RAM) or a 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 processor.
The Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; but also Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components.
In yet another embodiment provided by the present application, a computer-readable storage medium is further provided, in which a computer program is stored, and the computer program, when executed by a processor, implements the steps of any of the above table marking methods.
In yet another embodiment provided by the present application, there is also provided a computer program product containing instructions which, when run on a computer, cause the computer to perform any of the above-described table marking methods.
In the above embodiments, the implementation may be wholly or partially realized 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, cause the processes or functions described in accordance with the embodiments of the application to occur, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored in a computer readable storage medium or transmitted from one computer readable storage medium to another, for example, from one website site, computer, server, or data center to another website site, computer, server, or data center via wired (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device, such as a server, a data center, etc., that incorporates one or more of the 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)), among others.
It is noted that, herein, relational terms such as first and second, and the like may be 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. Also, 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 an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
All the embodiments in the present specification are described in a related manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, apparatus embodiments, electronic device embodiments, computer-readable storage medium embodiments, and computer program product embodiments are substantially similar to method embodiments and therefore are described with relative ease, as appropriate, with reference to the partial description of the method embodiments.
The above description is only for the preferred embodiment of the present application and is not intended to limit the scope of the present application. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application are included in the protection scope of the present application.
Claims (11)
1. A method of table labeling, the method comprising:
determining a target unit item to be skipped from a table, wherein the unit item comprises a unit row and/or a unit column;
determining a first identifier of other unit items, wherein the other unit items are: the unit items except the target unit item in the unit items of the table;
marking the identification of the other unit item as the first identification.
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 identifier of each other unit item according to the arrangement order of the other unit items 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 as follows: each unit item in the reverse direction of the direction represented by the type of the target unit item;
determining the first identifier of each second unit item according to the arrangement sequence of each second unit item in the table and the first identifier of each first unit item, wherein the second unit items are as follows: and each unit item is positioned in the positive direction of the direction represented by the type of the target unit item.
4. The method of claim 2, wherein determining the first identifier of each other unit item according to the arrangement order of the other unit items 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 as follows: 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 items are as follows: and each unit item is positioned in the positive 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:
determining a relabeled unit item in the marked table as a reference unit item;
under the condition that the reference unit item is located before the target unit item, according to the arrangement sequence of the reference unit item and each third unit item in the table, determining second identifications of the reference unit item and each third unit item, and marking the identifications of the reference unit item and each third unit item as the second identifications, wherein the third unit item is: a unit item between the reference unit item and the target unit item;
determining third identifications of the reference unit item and the fourth unit items according to the arrangement sequence of the reference unit item and the fourth unit items in the table under the condition that the reference unit item is positioned behind the target unit item, and marking the identifications of the reference unit item and the fourth unit items as the third identifications, wherein the fourth unit items are as follows: a unit item following the reference unit item.
6. The method according to any one of claims 1-4, further comprising:
and under the condition of receiving an identifier recovery operation triggered by a user in a user interface, determining a preset identifier of each unit item in the table, and updating the identifier of each unit item into the preset identifier.
7. 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.
8. The method according to any of claims 1-4, wherein the determining the cell entry in the table to skip the mark comprises:
traversing the unit items in a preset range in the table, and searching the unit items meeting a preset skipping marking condition as target unit items, wherein the skipping marking condition comprises at least one of the following conditions: blank rows, blank columns, cell rows for displaying a title, and cell columns for displaying a title.
9. A form marking apparatus, comprising:
the first unit item determining module is used for determining a unit item to be skipped and marked in a table as a target unit item, wherein the unit item comprises a unit row and/or a unit column;
a first identifier determining module, configured to determine a first identifier of another unit item, where the another unit item is: the unit items except the target unit item in the unit items of the table;
and the identification marking module is used for marking the identifications of the other unit items as the first identifications.
10. An electronic device is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor and the communication interface are used for realizing mutual communication by the memory through the communication bus;
a memory for storing a computer program;
a processor for implementing the method steps of any one of claims 1 to 8 when executing a program stored in the memory.
11. A computer-readable storage medium, characterized in that a computer program is stored in the computer-readable storage medium, which computer program, when being executed by a processor, carries out the method steps of any one of claims 1 to 8.
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 true CN113536750A (en) | 2021-10-22 |
| CN113536750B 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 (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040088650A1 (en) * | 2002-10-30 | 2004-05-06 | Actuate Corporation | Methods and apparatus for generating a spreadsheet report template |
| US20160098384A1 (en) * | 2014-10-05 | 2016-04-07 | Splunk Inc. | Statistics Time Chart Interface Row Mode Drill Down |
| US20180225270A1 (en) * | 2017-02-06 | 2018-08-09 | International Business Machines Corporation | Processing user action in data integration tools |
| US20180293217A1 (en) * | 2017-04-05 | 2018-10-11 | Microsoft Technology Licensing, Llc | Smarter copy/paste |
| CN110427599A (en) * | 2019-06-06 | 2019-11-08 | 北京辰森世纪科技股份有限公司 | The statistical method and device of report subtotal, storage medium, electronic device |
-
2021
- 2021-06-07 CN CN202110631104.2A patent/CN113536750B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040088650A1 (en) * | 2002-10-30 | 2004-05-06 | Actuate Corporation | Methods and apparatus for generating a spreadsheet report template |
| US20160098384A1 (en) * | 2014-10-05 | 2016-04-07 | Splunk Inc. | Statistics Time Chart Interface Row Mode Drill Down |
| US20180225270A1 (en) * | 2017-02-06 | 2018-08-09 | International Business Machines Corporation | Processing user action in data integration tools |
| US20180293217A1 (en) * | 2017-04-05 | 2018-10-11 | Microsoft Technology Licensing, Llc | Smarter copy/paste |
| 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函数填充序列", 《农村电气化》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113536750B (en) | 2023-12-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3407221A1 (en) | Methods and devices for searching and displaying information on a terminal | |
| CN107765938B (en) | Picture interaction method and device | |
| JP2013084074A5 (en) | ||
| CN112394861A (en) | Page jump method and device, storage medium and electronic device | |
| CN110162353A (en) | Multi-page switching method and equipment, storage medium, terminal | |
| CN106095816B (en) | Information delivery method and device | |
| CN113194024A (en) | Information display method and device and electronic equipment | |
| US20120246243A1 (en) | Electronic mail system, user terminal apparatus, information providing apparatus, and computer readable medium | |
| CN104539801B (en) | Method and terminal for presenting contact information | |
| CN109635829B (en) | Picture classification method, mobile terminal and computer storage medium | |
| CN103389981A (en) | Network label automatic identification method and system thereof | |
| CN113536750A (en) | Table marking method and device, electronic equipment and storage medium | |
| CN112329409B (en) | Cell color conversion method and device and electronic equipment | |
| CN112100463A (en) | Information processing method and device, electronic equipment and readable storage medium | |
| CN111126029A (en) | Electronic document generation method and device, computer equipment and storage medium | |
| CN108170838B (en) | Topic evolution visualization display method, application server and computer readable storage medium | |
| CN104866545A (en) | Method for searching keywords on information display page | |
| CN112799564A (en) | Method, device, electronic equipment and medium for inserting control in table | |
| CN104850608A (en) | Method for searching keywords on information exhibiting page | |
| JP2011197983A (en) | Information display device and information display program | |
| US20120254200A1 (en) | User behavior based cognitive engine for data objects | |
| CN104427070A (en) | Method and device for displaying contact information and switching presentation mode | |
| CN110908570B (en) | Image processing method, device, terminal and storage medium | |
| CN110795922B (en) | Form information display method and device for PDF document and electronic equipment | |
| JP5813703B2 (en) | Image display method and system |
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 |