CN112241235B - Electronic form annotation method, electronic form display method and corresponding device - Google Patents
Electronic form annotation method, electronic form display method and corresponding device Download PDFInfo
- Publication number
- CN112241235B CN112241235B CN201910584948.9A CN201910584948A CN112241235B CN 112241235 B CN112241235 B CN 112241235B CN 201910584948 A CN201910584948 A CN 201910584948A CN 112241235 B CN112241235 B CN 112241235B
- Authority
- CN
- China
- Prior art keywords
- annotation
- cells
- shared
- mark
- continuous
- 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 43
- 230000009471 action Effects 0.000 claims description 20
- 239000000725 suspension Substances 0.000 claims description 8
- 230000004913 activation Effects 0.000 claims description 5
- 238000001514 detection method Methods 0.000 claims description 3
- 238000007667 floating Methods 0.000 claims description 3
- 239000003550 marker Substances 0.000 claims 3
- 230000003213 activating effect Effects 0.000 claims 1
- 238000010586 diagram Methods 0.000 description 7
- 238000004891 communication Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 5
- 230000004048 modification Effects 0.000 description 5
- 238000012986 modification Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 3
- 238000003780 insertion Methods 0.000 description 3
- 230000037431 insertion Effects 0.000 description 3
- 238000012552 review Methods 0.000 description 3
- 239000003086 colorant Substances 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 239000011159 matrix material Substances 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000007723 transport mechanism Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- 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
-
- 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
- G06F3/04842—Selection of displayed objects or displayed text elements
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Human Computer Interaction (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Document Processing Apparatus (AREA)
Abstract
The embodiment of the invention discloses an electronic form annotation method, a display method and a corresponding device, wherein the method comprises the following steps: selecting a plurality of continuous cells in the electronic form according to the input operation; when an instruction for annotating the selected continuous cells is received, adding the annotations to the continuous cells, and adding shared annotation identifications to the continuous cells. By inserting annotations into a plurality of continuous cells in the spreadsheet, a user can quickly find out the contents of a focused and emphasized row or column through the corner mark highlighted by the head of the row or the head of the column.
Description
Technical Field
The embodiment of the invention relates to a document control technology, in particular to an electronic form annotating method, a display method and a corresponding device.
Background
Currently, when using electronic form review check modification, the blank area of the form can be additionally filled with content for marking, but this way not only increases the content of the document cell, but also is not easy to be noticed. Existing electronic forms can insert annotations into a single cell area, but the method only aims at a single cell, lacks an annotation expression mode of multiple areas, and is relatively limited in function.
Disclosure of Invention
The embodiment of the invention provides an electronic form annotating method, a display method and a corresponding device, which are used for realizing the functions of marking and annotating multiple cells of an electronic form.
To achieve the object of the embodiment of the present invention, an embodiment of the present invention provides a method for annotating electronic forms, including:
selecting a plurality of continuous cells in the electronic form according to the input operation;
when an instruction for annotating the selected continuous cells is received, adding the annotations to the continuous cells, and adding shared annotation identifications to the continuous cells.
Preferably, the annotation method further includes: and setting a shared zone bit, and setting the annotation action range of a plurality of continuous cells sharing the annotation identification, wherein the shared zone bit is a zone bit for distinguishing whether the shared annotation identification is the shared annotation identification.
Preferably, the continuous plurality of unit cells are unit cells in a whole row or a whole column or rectangular unit cells, and the rectangular unit cells are rectangular areas formed by the plurality of unit cells.
Preferably, the adding of the shared annotation identification to the plurality of continuous cells comprises:
when the whole row of cells is annotated, highlighting the shared corner marks on the header of the corresponding row after the annotation is finished;
when the whole row of cells is annotated, highlighting the table head of the corresponding row after annotation is finished to display the shared corner mark;
and when the rectangular cells are annotated, highlighting the sharing corner marks on the corner cells of the rectangular area.
Preferably, the method further comprises:
and receiving the editing operation of the annotation content by the user, and performing corresponding operation on the annotation content.
Preferably, the editing operation comprises one or more of:
adding annotation content operation, deleting annotation content operation, changing font information operation and changing shared corner mark color operation.
Preferably, before receiving the editing operation of the annotation content by the user, the method further includes:
matching whether the author name of the current opened document is the same as the author name of the annotation;
when the author name of the currently opened document is different from the author name of the annotation, the annotation content is subjected to an editing operation using a shared subscript color different from the author name of the annotation and/or different font information.
In a second aspect, an embodiment of the present invention further provides a method for displaying a spreadsheet annotation, where the method includes:
detecting the position of a mouse cursor;
when the mouse cursor is detected to be at the position of a shared annotation mark for indicating that a plurality of continuous cell annotations exist, drawing corresponding continuous outer frames around the plurality of cells for annotation range marking; and displaying the annotation content.
Preferably, the drawing of the outer frames around the corresponding continuous plurality of cells for annotation range marking includes:
when the mouse cursor is detected to be in the cell to highlight the sharing corner mark, reading the sharing flag bit to obtain the annotation action range of a plurality of continuous cells set by a user, wherein the sharing flag bit is a flag bit for distinguishing whether the sharing flag bit is the sharing corner mark or not; and marking the annotation range on the outline drawing line of the annotation action range of the continuous cells set by the user.
Preferably, the displaying the annotation content comprises:
and popping up a suspension dialog box, and displaying the annotated text content in the suspension dialog box.
Preferably, the displaying the annotation content further comprises:
displaying one or more of the following annotation parameters within the floating dialog: author, head portrait, time of annotation.
In a third aspect, an embodiment of the present invention further provides an electronic form annotation apparatus, including:
the obtaining module is used for selecting a plurality of continuous cells in the electronic form according to input operation;
and the annotation module is arranged for increasing the annotations of the plurality of continuous cells and adding shared annotation marks to the plurality of continuous cells when receiving an instruction for annotating the plurality of selected continuous cells.
Preferably, the annotation module is further configured to set a shared flag, and set an annotation action range of a plurality of continuous cells sharing the annotation identifier, where the shared flag is a flag for distinguishing whether the shared annotation identifier is shared.
Preferably, the adding, by the annotation module, a shared annotation identifier to the plurality of continuous cells includes:
when the whole row of cells is annotated, highlighting the shared corner marks on the header of the corresponding row after the annotation is finished;
when the whole row of cells are annotated, highlighting the table head of the corresponding row after the annotation is finished to display the shared corner mark;
and when the rectangular cells are annotated, highlighting the sharing corner marks on the vertex angle cells of the rectangular region.
Preferably, the annotating device further comprises an editing module:
and setting to receive the editing operation of the annotation content by the user and carrying out corresponding operation on the annotation content.
Preferably, the editing module is further configured to:
matching whether the author name of the current opened document is the same as the author name of the annotation;
when the author name of the currently opened document is different from the author name of the annotation, the annotation content is subjected to an editing operation using a shared subscript color different from the author name of the annotation and/or different font information.
In a fourth aspect, an embodiment of the present invention further provides a display device for electronic form annotation, including:
the detection module is used for detecting the position of a mouse cursor;
the activation module is used for drawing corresponding continuous outer frames around the plurality of cells for annotation range marking when the mouse cursor is detected to be at the position of the shared annotation mark for indicating that the plurality of continuous cell annotations exist; and displaying the annotation content.
Preferably, the step of drawing the outer frames around the corresponding continuous multiple unit cells by the activation module to perform annotation range marking includes:
when the mouse cursor is detected to be in the cell to highlight the sharing corner mark, reading the sharing flag bit to obtain the annotation action range of a plurality of continuous cells set by a user, wherein the sharing flag bit is a flag bit for distinguishing whether the sharing flag bit is the sharing corner mark or not; and marking the annotation range on the outline drawing line of the annotation action range of the continuous cells set by the user.
The beneficial effects of the embodiment of the invention can include:
according to the embodiment of the invention, the continuous multiple cells are inserted with the annotations in the electronic form, a user can quickly find the contents of the concerned heavy point row or column or rectangular area through the highlighted shared corner mark of the head of the row or column, mark the annotation range through lines or other display modes, and pop up the annotation suspension dialog box to check the specific annotation contents, so that purposeful review, check and modification can be carried out on the rows or columns or rectangular area of the annotation, the annotation contents can be edited or replied, and the communication efficiency of work is greatly improved.
Additional features and advantages of embodiments of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by the practice of the invention. The objectives and other advantages of the embodiments of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
The accompanying drawings are included to provide a further understanding of the embodiments of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the examples of the application do not constitute a limitation of the embodiments of the invention.
FIG. 1 is a flow chart of a method of spreadsheet annotation according to an embodiment of the present invention;
FIG. 2 is a flow chart of a method of displaying spreadsheet annotations in accordance with an embodiment of the present invention;
FIG. 3 is a schematic structural diagram of an electronic form annotation device according to an embodiment of the invention;
FIG. 4 is a schematic structural diagram of an electronic form annotation device according to an embodiment of the invention;
FIG. 5 is a schematic structural diagram of a display method of a spreadsheet annotation according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of an exemplary embodiment of a spreadsheet annotation;
FIG. 7 is a schematic diagram of a spreadsheet annotation according to an embodiment of the present invention;
FIG. 8 is a schematic diagram of a spreadsheet annotation according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention will be described in detail below with reference to the accompanying drawings. It should be noted that the embodiments and features of the embodiments in the present application may be arbitrarily combined with each other without conflict.
The steps illustrated in the flow charts of the figures may be performed in a computer system such as a set of computer-executable instructions. Also, while a logical order is shown in the flow diagrams, in some cases, the steps shown or described may be performed in an order different than here.
Example one
An embodiment of the present invention provides a spreadsheet annotation method, as shown in fig. 1, the method includes S101-S102:
s101, selecting a plurality of continuous cells in the electronic form according to input operation;
s102, when an instruction for annotating the selected continuous cells is received, adding the annotations to the continuous cells, and adding shared annotation marks to the continuous cells.
Aiming at the problem that the existing spreadsheet (excel) can only annotate a single cell, the embodiment of the invention can annotate a plurality of continuous cells, the plurality of continuous cells can be whole-row cells or whole-column cells or rectangular cells, and the rectangular cells are rectangular areas formed by the plurality of cells.
In an exemplary embodiment of the present invention, a plurality of cells in a spreadsheet selected by a user are obtained first; when it is determined that the user annotates the plurality of continuous cells, annotating the plurality of continuous cells, and adding shared annotation marks to the plurality of continuous cells, wherein the added shared annotation marks can be highlighting shared corner marks. The shared annotation tag is used to indicate that there are multiple cell annotations in succession.
In an exemplary embodiment of the present invention, the rectangular cell may be a cell matrix with a size of N × M, or may be a cell row with a size of 1 × M, or may be a cell column with a size of N × 1, where N, M is an integer greater than 1; the selection of a complete row or column may be applied to the case of a complete row of cells or a complete column of cells, and the selection of a partial cell in a row or a partial cell in a column may be applied to the case of a row of cells or a column of cells.
In exemplary embodiments of the present invention, the shared corner mark may use the same marking as the single cell annotation corner mark, or may use a different marking, such as a different color, a different shape, a different location, etc., than the single cell annotation corner mark. When the shared corner mark is the same as the single-cell annotation corner mark, a flag bit and the like can be used for recording and distinguishing whether the shared corner mark is used for a plurality of continuous cells or the annotation corner mark is used for the single cell.
In an exemplary embodiment of the present invention, the annotating method further includes: and setting a shared zone bit, and setting the annotation action range of a plurality of continuous cells sharing the annotation identification, wherein the shared zone bit is a zone bit for distinguishing whether the shared annotation identification is the shared annotation identification.
In the exemplary embodiment of the present invention, the correspondence between the annotation identification and the annotation scope needs to be shared.
Example two
This embodiment provides a scheme for highlighting annotations on the basis of the first embodiment.
In an exemplary embodiment of the present invention, the adding the shared annotation identification to the consecutive cells in S102 includes:
when the whole row of cells is annotated, highlighting the shared corner marks on the header of the corresponding row after the annotation is finished;
when the whole row of cells is annotated, highlighting the table head of the corresponding row after annotation is finished to display the shared corner mark;
and when the rectangular cells are annotated, highlighting the sharing corner marks on the corner cells of the rectangular area.
In an exemplary embodiment of the present invention, when performing an insertion annotation on an entire row or an entire column, the shared corner mark may be highlighted on the header of the corresponding row or the header of the corresponding column after the insertion annotation is completed, and for a rectangular cell, the shared corner mark may be highlighted on each cell in the rectangular area, and in consideration of that visual interference may be caused by displaying a plurality of corner marks for one annotation, a manner of highlighting the shared corner mark on a top corner cell in the rectangular area is adopted.
In an exemplary embodiment of the present invention, the shared corner mark may be highlighted in one or more corner cells of the rectangular region, for example, two corner cells of the rectangular region highlight the shared corner mark, two cells are located on a diagonal of the rectangular region, or four corner cells highlight the shared corner mark, and a range defined by four corners is an annotation range.
In an exemplary embodiment of the present invention, when the rectangular cell is a 1 × M cell row or an N × 1 cell column, the annotation range can be determined using cells at both ends.
In an exemplary embodiment of the present invention, the shared corner mark may be displayed in the header or upper right corner of the cell.
EXAMPLE III
This example gives a specific implementation of annotation editing based on any of the examples described above.
The exemplary embodiment of the present invention may further include: and receiving the editing operation of the annotation content by the user, and performing corresponding operation on the annotation content.
In an exemplary embodiment of the invention, the editing operation comprises one or more of:
adding annotation content operation, deleting annotation content operation, changing font information operation and changing shared corner mark color operation.
Before the receiving of the editing operation of the annotation content by the user in the exemplary embodiment of the present invention, the method further includes:
matching whether the author name of the current opened document is the same as the author name of the annotation;
when the author name of the currently opened document is different from the author name of the annotation, the annotation content is subjected to an editing operation using a shared subscript color different from the author name of the annotation and/or different font information.
In the exemplary embodiment of the present invention, more menus can be provided for the annotations to perform "editing", and in this embodiment, whether the annotations are the same author or not can be further distinguished, and according to the distinction of functions and displays performed by different authors, the author name of the currently opened document is compared with the author name of the latest modification of the current annotations, if the author names are the same, the author is the same author, the annotation is edited by the same author, and if the author names are different, the author names are different authors, and the annotation is responded by a person who reads the annotation.
In the exemplary embodiment of the invention, the annotation supports more button response operations at the upper right corner, and when the author is different, a new annotation list item appears for the response operation, and the new annotation list item comprises the author, the head portrait, the time and the text content. Different avatars and author names may be used with different font colors as a distinction.
In exemplary embodiments of the invention, one or more of the following may be implemented:
adding annotation content, deleting annotation content, changing font information, and changing color of shared corner mark. The font information may include: chinese character, western character, character pattern, character size, character color, etc.
Example four
An embodiment of the present invention provides a display method of a spreadsheet annotation, as shown in fig. 2, the method includes:
s201, detecting the position of a mouse cursor;
s202, when the mouse cursor is detected to be at a position of a shared annotation mark for indicating that a plurality of continuous cell annotations exist, drawing corresponding continuous outer frames around the plurality of cells for annotation range marking; and displaying the annotation content.
In an exemplary embodiment of the present invention, the drawing the corresponding continuous outer frames around the plurality of cells for annotation range marking includes:
when the fact that the shared corner mark is highlighted on the head of the row of the mouse cursor is detected, the annotation content can be directly displayed in the annotation frame, the continuous outer frames around the plurality of cells can be drawn for annotation range marking, and then the annotation content is displayed in the annotation frame;
when the fact that the mouse cursor is positioned at the head of the column and highlights the sharing corner mark is detected, the annotation content can be directly displayed in the annotation frame, the continuous outer frames around the plurality of cells can be drawn for annotation range marking, and then the annotation content is displayed in the annotation frame;
when the mouse cursor is detected to be in the cell to highlight the sharing corner mark, reading the sharing flag bit to obtain the annotation action range of a plurality of continuous cells set by a user, wherein the sharing flag bit is a flag bit for distinguishing whether the sharing flag bit is the sharing corner mark or not; and marking the annotation range on the outline drawing line of the annotation action range of the continuous cells set by the user.
In the exemplary embodiment of the present invention, when the mouse cursor is at the cell highlighting corner mark, it is necessary to distinguish whether the shared corner mark is a continuous shared corner mark for annotating a plurality of cells or an annotating corner mark for each cell, and the shared corner mark may use the same mark as the single cell annotating corner mark or may use a mark different from the single cell annotating corner mark, such as different colors, different shapes, different positions, and the like. When the shared corner mark is the same as the annotation corner mark of the single cell, a flag bit can be set for a plurality of continuous cells to indicate that the plurality of cells are one area. And when the annotation is displayed or activated, drawing the peripheral outer frame for marking the annotation range.
In an exemplary embodiment of the present invention, displaying the annotation content includes:
and popping up a suspension dialog box, and displaying the annotated text content in the suspension dialog box.
In an exemplary embodiment of the present invention, the displaying the annotation content further includes:
displaying one or more of the following annotation parameters within the floating dialog: author, head portrait, time of annotation.
In an exemplary embodiment of the present invention, when the user selects the row or column or the rectangular area (the PC-side mouse is suspended on any cell of the header of the row or column containing the corner mark or the rectangular area), an annotation bubble or a suspension dialog box is automatically popped up to display the annotated content, and the annotated content is displayed in a list form, each item includes: author, avatar, time, and text content.
EXAMPLE five
An embodiment of the present invention provides an electronic form annotating device, as shown in fig. 3, including:
an obtaining module 100 configured to select a plurality of continuous cells in the spreadsheet according to an input operation;
the annotating module 200 is configured to, when receiving an instruction for annotating the selected continuous cells, add annotations to the continuous cells, and add shared annotation marks to the continuous cells.
In an exemplary embodiment of the present invention, the annotation module is further configured to set a shared flag, and set an annotation action range of a plurality of continuous cells sharing the annotation identifier, where the shared flag is a flag for distinguishing whether the shared annotation identifier is a shared annotation identifier.
In an exemplary embodiment of the present invention, the adding, by the annotation module, a shared annotation identifier to the plurality of continuous cells includes:
when the whole row of cells is annotated, highlighting the shared corner marks on the header of the corresponding row after the annotation is finished;
when the whole row of cells is annotated, highlighting the table head of the corresponding row after annotation is finished to display the shared corner mark;
and when the rectangular cells are annotated, highlighting the sharing corner marks on the vertex angle cells of the rectangular region.
As shown in fig. 4, the annotating device in the exemplary embodiment of the invention further includes an editing module 300:
and setting to receive the editing operation of the annotation content by the user and carrying out corresponding operation on the annotation content.
In an exemplary embodiment of the invention, the editing module is further configured to:
matching whether the author name of the current opened document is the same as the author name of the annotation;
when the author name of the currently opened document is different from the author name of the annotation, the annotation content is subjected to an editing operation using a shared subscript color different from the author name of the annotation and/or different font information.
EXAMPLE six
An embodiment of the present invention provides a display device for electronic form annotation, as shown in fig. 5, including:
a detection module 10 configured to detect a position of a mouse cursor;
the activation module 20 is configured to draw corresponding continuous outer frames around the plurality of cells for annotation range marking when detecting that the mouse cursor is at a position of the shared annotation mark for indicating that the plurality of continuous cell annotations exist; and displaying the annotation content.
In an exemplary embodiment of the present invention, the step of drawing, by the activation module, an outer frame around the corresponding continuous multiple cells to perform annotation range marking includes:
when the mouse cursor is detected to be in the cell to highlight the sharing corner mark, reading the sharing flag bit to obtain the annotation action range of a plurality of continuous cells set by a user, wherein the sharing flag bit is a flag bit for distinguishing whether the sharing flag bit is the sharing corner mark or not; and marking the annotation range on the outline drawing line of the annotation action range of the continuous cells set by the user.
EXAMPLE seven
The exemplary embodiment of the present invention illustrates the process of annotation by taking the inserted row (column) annotation as an example:
(1) when an entire row or column of the spreadsheet is selected, the pop-up menu is incremented by an "insert row (column) annotation" as shown in FIG. 6.
(2) The top right corner of the row column head inserted with the annotation highlights the corner mark and pops up the annotation bubble, as shown in fig. 7, the bubble displays the current author, head portrait and time, and an input box is provided below to display the cursor for the user to input the annotation content. As shown in fig. 8, the upper right corner provides more buttons for "edit" (same as "edit" and different from "answer" according to the comparison of the author name of the currently open document and the author name of the last modification of the current annotation), "delete", and "change the color of the corner mark".
(3) And after the insertion of the column-row head annotation is finished, storing the annotated data, adding an annotation attribute Key Value pair (Key is comments and Value of the corresponding data block is allocated as data) to the column-row head, and storing the document by taking the Key Value pair as an attribute of the column and row to participate in storage. And reading whether the line contains the annotation attribute value to draw the corner mark when the line head of the table draws, and reading the annotation data block to display the content when bubbles are popped. The annotation data block is represented in a list form, and each item of the list contains an author, an avatar head, a time and a text content text.
(4) When the whole row or column containing the annotation is selected (the PC-side mouse is suspended above the head of the row or column containing the corner mark), an annotation bubble is popped up, and operations of 'editing', 'responding', 'deleting', 'changing the color of the corner mark' are carried out after more buttons are clicked.
After the electronic form rows or columns are inserted with annotations, a user can quickly find focused row and column contents through the highlighted corner marks at the top right corner of the row and column head, after specific contents are checked through popping out annotation bubbles, purposeful review, check and modification can be carried out on the focused row and column, the annotation contents can be edited or replied, after the operation is finished, the electronic form document is only sent to the opposite side, an additional communication way is omitted, and the communication efficiency of work is greatly improved.
It will be understood by those of ordinary skill in the art that all or some of the steps of the methods, systems, functional modules/units in the devices disclosed above may be implemented as software, firmware, hardware, or suitable combinations thereof. In a hardware implementation, the division between functional modules/units mentioned in the above description does not necessarily correspond to the division of physical components; for example, one physical component may have multiple functions, or one function or step may be performed by several physical components in cooperation. Some or all of the components may be implemented as software executed by a processor, such as a digital signal processor or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on computer readable media, which may include computer storage media (or non-transitory media) and communication media (or transitory media). The term computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data, as is well known to those of ordinary skill in the art. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, Digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by a computer. In addition, communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media as known to those skilled in the art.
Claims (14)
1. A method of spreadsheet annotation, the method comprising:
selecting a plurality of continuous cells in the electronic form according to the input operation;
when an instruction for annotating the selected continuous cells is received, adding annotations to the continuous cells, and adding shared annotation marks to the continuous cells;
the selected consecutive plurality of cells comprises: a plurality of spaced rows of successive cells, each of said rows of successive cells forming an area; or, a plurality of spaced column-sequential cells, each of said column-sequential cells forming an area; the increasing the annotations to the consecutive plurality of cells comprises: adding the same comment to the multiple spaced row continuous cells, or adding the same comment to the multiple spaced column continuous cells;
further comprising: setting a shared zone bit, and setting the annotation action range of a plurality of continuous cells sharing the annotation identification, wherein the shared zone bit is a zone bit for distinguishing whether the shared annotation identification is the shared annotation identification;
sharing the annotation identification includes: using the same mark as the single cell annotation mark, or using a mark different from the single cell annotation mark;
under the condition that the shared annotation mark is the same as the annotation mark of the single cell, recording and distinguishing whether the shared annotation mark is used for a plurality of continuous cells or the annotation mark is used for the single cell by using a mark bit or other methods;
adding shared annotation identifications to the continuous cells, wherein the steps comprise:
under the condition of annotating the cells in the whole row, highlighting the shared annotation mark on the header of the corresponding row after the annotation is finished; or,
under the condition of annotating the whole column of cells, highlighting the shared annotation identification on the header of the corresponding column after the annotation is finished;
and under the condition of annotating the rectangular cells, highlighting the shared annotation identification on the cells at the top corners of the rectangular area.
2. The annotation method according to claim 1, wherein the continuous plurality of unit cells are whole-row unit cells or whole-column unit cells or rectangular unit cells, and the rectangular unit cells are rectangular areas formed by the plurality of unit cells.
3. The annotation method according to claim 1 or 2, further comprising:
and receiving the editing operation of the annotation content by the user, and performing corresponding operation on the annotation content.
4. The annotation method of claim 3, wherein the editing operation comprises one or more of:
adding annotation content operation, deleting annotation content operation, changing font information operation and changing shared corner mark color operation.
5. The annotation method of claim 3, wherein the receiving of the editing operation of the annotation content by the user further comprises:
matching whether the author name of the current opened document is the same as the author name of the annotation;
when the author name of the currently opened document is different from the author name of the annotation, the annotation content is subjected to an editing operation using a shared subscript color different from the author name of the annotation and/or different font information.
6. A method of displaying spreadsheet annotations, the method comprising:
detecting the position of a mouse cursor;
when the mouse cursor is detected to be at the position of a shared annotation mark for indicating that a plurality of continuous cell annotations exist, drawing corresponding continuous outer frames around the plurality of cells for annotation range marking; displaying the annotation content;
the consecutive plurality of cells includes: row-sequential cells, or, column-sequential cells;
the drawing of the outer frames around the corresponding continuous plurality of unit grids for annotation range marking comprises the following steps: marking the annotation range of the outer frames around the row continuous cells at intervals, or marking the annotation range of the outer frames around the column continuous cells at intervals;
further comprising: setting a shared zone bit, and setting the annotation action range of a plurality of continuous cells sharing the annotation identification, wherein the shared zone bit is a zone bit for distinguishing whether the shared annotation identification is the shared annotation identification;
sharing the annotation identification includes: using the same mark as the single cell annotation mark, or using a mark different from the single cell annotation mark;
under the condition that the shared annotation mark is the same as the annotation mark of the single cell, recording and distinguishing whether the shared annotation mark is used for a plurality of continuous cells or the annotation mark is used for the single cell by using a mark bit or other methods;
wherein adding a shared annotation mark to the plurality of continuous cells comprises:
under the condition of annotating the cells in the whole row, highlighting the shared annotation mark on the header of the corresponding row after the annotation is finished;
under the condition of annotating the whole column of cells, highlighting the shared annotation identification on the header of the corresponding column after the annotation is finished;
and under the condition of annotating the rectangular cells, highlighting the shared annotation identification on the cells at the top corners of the rectangular area.
7. The display method according to claim 6, wherein the drawing of the corresponding continuous outer frames around the plurality of cells for annotation range marking comprises:
when the mouse cursor is detected to be in the cell to highlight the sharing corner mark, reading the sharing flag bit to obtain the annotation action range of a plurality of continuous cells set by a user, wherein the sharing flag bit is a flag bit for distinguishing whether the sharing flag bit is the sharing corner mark or not; and marking the annotation range on the outline drawing line of the annotation action range of the continuous cells set by the user.
8. The display method according to claim 6, wherein displaying the annotation content comprises:
and popping up a suspension dialog box, and displaying the annotated text content in the suspension dialog box.
9. The display method according to claim 8, wherein the displaying the annotation content further comprises:
displaying one or more of the following annotation parameters within the floating dialog: author, head portrait, time of annotation.
10. An electronic form annotating device, comprising:
the obtaining module is used for selecting a plurality of continuous cells in the electronic form according to input operation;
the annotation module is arranged for increasing annotations of the plurality of continuous cells and adding shared annotation marks to the plurality of continuous cells when receiving an instruction for annotating the plurality of continuous cells;
the selected consecutive plurality of cells comprises: a plurality of spaced rows of successive cells, each of said rows of successive cells forming an area; or, a plurality of spaced column-sequential cells, each of said column-sequential cells forming an area; the increasing the annotations to the consecutive plurality of cells comprises: adding the same comment to the multiple spaced row continuous cells, or adding the same comment to the multiple spaced column continuous cells;
the annotation module is also set to set a shared marker bit and set an annotation action range of a plurality of continuous cells sharing the annotation mark, and the shared marker bit is a marker bit for distinguishing whether the shared annotation mark is a shared annotation mark or not;
the adding, by the annotation module, a shared annotation identifier to the plurality of continuous cells includes:
when the cells in the whole row are annotated, highlighting the shared annotation mark on the header of the corresponding row after the annotation is finished;
when the whole row of cells is annotated, highlighting the shared annotation mark on the header of the corresponding row after the annotation is finished;
and when the rectangular cells are annotated, highlighting the shared annotation mark on the cells at the top corners of the rectangular area.
11. The annotation device of claim 10, further comprising an editing module:
and setting to receive the editing operation of the annotation content by the user and carrying out corresponding operation on the annotation content.
12. The annotation device of claim 11, wherein the editing module is further configured to:
matching whether the author name of the current opened document is the same as the author name of the annotation;
when the author name of the currently opened document is different from the author name of the annotation, the annotation content is subjected to an editing operation using a shared subscript color different from the author name of the annotation and/or different font information.
13. A display device for spreadsheet annotations, comprising:
the detection module is used for detecting the position of a mouse cursor;
the activation module is used for drawing corresponding continuous outer frames around the plurality of cells for annotation range marking when the mouse cursor is detected to be at the position of the shared annotation mark for indicating that the plurality of continuous cell annotations exist; displaying the annotation content;
the successive plurality of cells includes: row-sequential cells, or, column-sequential cells;
the drawing of the outer frames around the corresponding continuous plurality of unit grids for annotation range marking comprises the following steps: marking the annotation range of the outer frames around the row continuous cells at intervals, or marking the annotation range of the outer frames around the column continuous cells at intervals;
further comprising: setting a shared zone bit, and setting the annotation action range of a plurality of continuous cells sharing the annotation identification, wherein the shared zone bit is a zone bit for distinguishing whether the shared annotation identification is the shared annotation identification;
sharing the annotation identification includes: using the same mark as the single cell annotation mark, or using a mark different from the single cell annotation mark;
when the shared annotation mark is the same as the single cell annotation mark, recording and distinguishing whether the shared annotation mark is directed to a plurality of continuous cells or the annotation mark is directed to the single cell by using a mark bit or other modes;
wherein adding a shared annotation mark to the plurality of continuous cells comprises:
when the cells in the whole row are annotated, highlighting the shared annotation mark on the header of the corresponding row after the annotation is finished;
when the whole row of cells is annotated, highlighting the shared annotation mark on the header of the corresponding row after the annotation is finished;
and when the rectangular cells are annotated, highlighting the shared annotation mark on the cells at the top corners of the rectangular area.
14. The display device according to claim 13, wherein the activating module draws the corresponding continuous outer frames around the plurality of cells for annotation range marking comprises:
when the mouse cursor is detected to be in the cell to highlight the sharing corner mark, reading the sharing flag bit to obtain the annotation action range of a plurality of continuous cells set by a user, wherein the sharing flag bit is a flag bit for distinguishing whether the sharing flag bit is the sharing corner mark or not; and marking the annotation range on the outline drawing line of the annotation action range of the continuous cells set by the user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910584948.9A CN112241235B (en) | 2019-07-01 | 2019-07-01 | Electronic form annotation method, electronic form display method and corresponding device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910584948.9A CN112241235B (en) | 2019-07-01 | 2019-07-01 | Electronic form annotation method, electronic form display method and corresponding device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112241235A CN112241235A (en) | 2021-01-19 |
| CN112241235B true CN112241235B (en) | 2022-08-09 |
Family
ID=74175410
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910584948.9A Active CN112241235B (en) | 2019-07-01 | 2019-07-01 | Electronic form annotation method, electronic form display method and corresponding device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112241235B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102648466A (en) * | 2009-12-03 | 2012-08-22 | 国际商业机器公司 | A method for retrieving a data item annotation in a view |
| CN104169853A (en) * | 2012-03-13 | 2014-11-26 | 微软公司 | Web page application controls |
| CN106030492A (en) * | 2013-12-17 | 2016-10-12 | 微软技术许可有限责任公司 | Touch/gesture-enabled interaction with electronic spreadsheets |
| CN107229750A (en) * | 2017-06-27 | 2017-10-03 | 网易（杭州）网络有限公司 | table data processing method, device, storage medium and processor |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10698905B2 (en) * | 2017-09-14 | 2020-06-30 | SparkCognition, Inc. | Natural language querying of data in a structured context |
-
2019
- 2019-07-01 CN CN201910584948.9A patent/CN112241235B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102648466A (en) * | 2009-12-03 | 2012-08-22 | 国际商业机器公司 | A method for retrieving a data item annotation in a view |
| CN104169853A (en) * | 2012-03-13 | 2014-11-26 | 微软公司 | Web page application controls |
| CN106030492A (en) * | 2013-12-17 | 2016-10-12 | 微软技术许可有限责任公司 | Touch/gesture-enabled interaction with electronic spreadsheets |
| CN107229750A (en) * | 2017-06-27 | 2017-10-03 | 网易（杭州）网络有限公司 | table data processing method, device, storage medium and processor |
Non-Patent Citations (3)
| Title |
|---|
| "Excel如何一键给多个单元格添加相同批注？";梦在深巷;《https://www.kafan.cn/edu/26885541.html》;20190630;正文1-3页 * |
| "Microsoft Office 2019版本";系统城;《https://so.m.sm.cn/s?q=microsoft+Word+2019%E7%89%88%E6%9C%AC%E6%97%B6%E9%97%B4&uc_param_str=dnntnwvepffrgibijbprsvdsmeloodaaca&snum=6&by=submit&from=ucframe&change_engine=1&uc_sm=1#_m_i_p》;20180925;正文1-2页 * |
| 系统城."Microsoft Office 2019版本".《https://so.m.sm.cn/s?q=microsoft+Word+2019%E7%89%88%E6%9C%AC%E6%97%B6%E9%97%B4&uc_param_str=dnntnwvepffrgibijbprsvdsmeloodaaca&snum=6&by=submit&from=ucframe&change_engine=1&uc_sm=1#_m_i_p》.2018, * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112241235A (en) | 2021-01-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106776514B (en) | Annotating method and device | |
| CN111259644B (en) | Rich text processing method, editor, equipment and storage medium | |
| CN102339275B (en) | Comment processing method and device for electronic book | |
| KR20150087405A (en) | Providing note based annotation of content in e-reader | |
| US8930814B2 (en) | Digital comic editor, method and non-transitory computer-readable medium | |
| US20170220858A1 (en) | Optical recognition of tables | |
| JP2005209187A (en) | Graphical representation, storage and dissemination of displayed thinking | |
| CN111104557A (en) | Heterogeneous document processing system and method based on standard document markup language specification | |
| CN104966311A (en) | Vector graph storage method used for handwriting signing system | |
| CN102157003A (en) | Automatic configuration method for annotation label of map under digital environment | |
| CN116451659A (en) | Annotation processing method and device for electronic file, electronic equipment and storage medium | |
| JP4008280B2 (en) | Display method, display device, display program, and recording medium on which display program is recorded | |
| CN112199929A (en) | Form processing method and device, storage medium and electronic equipment | |
| CN113986158B (en) | Printing method, printing designer and computer readable storage medium | |
| JP2015095066A (en) | Information processing apparatus and information processing program | |
| CN112241235B (en) | Electronic form annotation method, electronic form display method and corresponding device | |
| CN102487362B (en) | The display packing of IM message and device | |
| CN113688150A (en) | Keyword searching method and device, electronic equipment and storage medium | |
| CN106201467B (en) | Screenshot labeling interface display method and device | |
| JP2017091328A (en) | Information processing apparatus and information processing program | |
| CN112256259A (en) | Method, device and equipment for processing thinking guide graph and storage medium | |
| JP6668868B2 (en) | Information processing apparatus and information processing program | |
| WO2023024959A1 (en) | Image labeling method and system, and device and storage medium | |
| CN113378526A (en) | PDF paragraph processing method, device, storage medium and equipment | |
| US20160364134A1 (en) | Information processing method and electronic device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |