CN112799564A - Method, device, electronic equipment and medium for inserting control in table - Google Patents
Method, device, electronic equipment and medium for inserting control in table Download PDFInfo
- Publication number
- CN112799564A CN112799564A CN202010674476.9A CN202010674476A CN112799564A CN 112799564 A CN112799564 A CN 112799564A CN 202010674476 A CN202010674476 A CN 202010674476A CN 112799564 A CN112799564 A CN 112799564A
- Authority
- CN
- China
- Prior art keywords
- control
- user
- cell
- row
- label
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 44
- 230000001960 triggered effect Effects 0.000 claims abstract description 9
- 230000004044 response Effects 0.000 claims description 40
- 238000004590 computer program Methods 0.000 claims description 13
- 238000001514 detection method Methods 0.000 claims description 8
- 238000003780 insertion Methods 0.000 claims description 4
- 230000037431 insertion Effects 0.000 claims description 4
- 238000004891 communication Methods 0.000 description 15
- 238000010586 diagram Methods 0.000 description 9
- 230000008569 process Effects 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000010926 purge Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 239000003086 colorant Substances 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000835 fiber Substances 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
- 238000012545 processing Methods 0.000 description 1
- 238000011160 research Methods 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
- 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
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K7/00—Methods or arrangements for sensing record carriers, e.g. for reading patterns
- G06K7/10—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation
- G06K7/14—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation using light without selection of wavelength, e.g. sensing reflected white light
- G06K7/1404—Methods for optical code recognition
- G06K7/1408—Methods for optical code recognition the method being specifically adapted for the type of code
- G06K7/1417—2D bar codes
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Human Computer Interaction (AREA)
- Artificial Intelligence (AREA)
- General Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- Electromagnetism (AREA)
- Toxicology (AREA)
- Computer Vision & Pattern Recognition (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the invention provides a method, a device, electronic equipment and a medium for inserting a control into a table, relates to the technical field of computers, and can improve the efficiency of inserting the control into the table. The technical scheme of the embodiment of the invention comprises the following steps: in a display range of a designated tab in a table, an attribute setting operation triggered by a user is detected. The designated labels are any row labels or any column labels selected by a user in the table, and the attribute setting operation is used for setting controls in each cell in the row or column identified by the designated labels. And then responding to the attribute setting operation, and displaying the preset control identification. And then responding to the selection operation of the user on the displayed control identification, and inserting the control corresponding to the control identification selected by the user into each cell of the row or the column identified by the specified label.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method and an apparatus for inserting a control into a table, an electronic device, and a medium.
Background
The drawing of tables is a common means for organizing and organizing data, and people widely adopt the tables with shapes and colors in activities such as communication, scientific research, data analysis and the like. Generally, a row or a column of the table includes the same cell attribute. For example, all cells in a column of cells are filled by the age of the user.
For example, the control may be a check box, and when counting work tasks, a check box is usually manually inserted into a column of cells of the table in turn, so that a user can mark completed work tasks by means of checking hooks in the check boxes. However, when the control is added to a column or a row of cells, the control needs to be manually added to each cell in sequence, and the efficiency is low.
Disclosure of Invention
The embodiment of the invention aims to provide a method, a device, electronic equipment and a medium for inserting a control into a table, so as to improve the efficiency of inserting the control into the table. The specific technical scheme is as follows:
in a first aspect, an embodiment of the present invention provides a method for inserting a control in a table, where the method includes:
detecting attribute setting operation triggered by a user in a display range of a designated label in a table, wherein the designated label is any row label or any column label selected by the user in the table, and the attribute setting operation is used for setting controls in each cell in the row or column identified by the designated label;
responding to the attribute setting operation, and displaying a preset control identification;
and responding to the selection operation of the user on the displayed control identification, and inserting the control corresponding to the control identification selected by the user into each cell of the row or the column identified by the specified label.
Optionally, the inserting a control corresponding to the control identifier selected by the user in each cell of the row or the column identified by the specified label in response to the selection operation of the user on the displayed control identifier includes:
determining control description information corresponding to the control identification selected by the user according to the corresponding relation between the preset control identification and the control description information;
and inserting a control corresponding to the control identification in each cell of the row or the column identified by the specified label based on the control description information.
Optionally, the displaying a preset control identifier in response to the attribute setting operation includes:
in response to the property setting operation, displaying a control identification list, wherein the control identification list comprises identifications of at least one of the following controls: check box control, date control, code scanning entry control, drop-down list control and cell picture control.
Optionally, the control identification list further includes a clear option; after the user inserts the control corresponding to the control identification selected by the user into each cell of the row or the column identified by the specified label in response to the selection operation of the user on the displayed control identification, the method further comprises the following steps:
and in response to the triggering operation of the user on the clearing option included in the control identification list corresponding to the specified label, clearing the control in each cell of the row or the column identified by the specified label.
Optionally, the control corresponding to the control identifier selected by the user is a date control; after the user inserts the control corresponding to the control identification selected by the user into each cell of the row or the column identified by the specified label in response to the selection operation of the user on the displayed control identification, the method further comprises the following steps:
responding to the triggering operation of a user on a date control included in the cell, and displaying a date selection interface;
and identifying the date selected by the user in the date selection interface, and displaying the date selected by the user in the cell targeted by the trigger operation.
Optionally, the control corresponding to the control identifier selected by the user is a code scanning entry control; after the user inserts the control corresponding to the control identification selected by the user into each cell of the row or the column identified by the specified label in response to the selection operation of the user on the displayed control identification, the method further comprises the following steps:
responding to the triggering operation of a user on a code scanning entry control included in the cell, and displaying a specified two-dimensional code;
scanning the specified two-dimensional code through scanning equipment, and receiving data corresponding to the specified two-dimensional code acquired by the scanning equipment;
and displaying data corresponding to the specified two-dimensional code in the cell targeted by the trigger operation.
In a second aspect, an embodiment of the present invention provides an apparatus for inserting a control in a table, where the apparatus includes:
the system comprises a detection module, a display module and a control module, wherein the detection module is used for detecting attribute setting operation triggered by a user in a display range of a designated label in a table, the designated label is any row label or any column label selected by the user in the table, and the attribute setting operation is used for setting controls in each cell in the row or column identified by the designated label;
the display module is used for responding to the attribute setting operation detected by the detection module and displaying a preset control identification;
and the inserting module is used for responding to the selection operation of the user on the control identification displayed by the display module and inserting the control corresponding to the control identification selected by the user into each cell of the row or the column identified by the specified label.
Optionally, the insertion module is specifically configured to:
determining control description information corresponding to the control identification selected by the user according to the corresponding relation between the preset control identification and the control description information;
and inserting a control corresponding to the control identification in each cell of the row or the column identified by the specified label based on the control description information.
Optionally, the display module is specifically configured to:
in response to the property setting operation, displaying a control identification list, wherein the control identification list comprises identifications of at least one of the following controls: check box control, date control, code scanning entry control, drop-down list control and cell picture control.
Optionally, the control identification list further includes a clear option; the device further comprises: a clearing module;
and the clearing module is used for responding to the triggering operation of the clearing option included in the control identification list corresponding to the specified label by the user after the control corresponding to the control identification selected by the user is inserted into each cell of the row or the column identified by the specified label in response to the selection operation of the user on the displayed control identification, and clearing the control in each cell of the row or the column identified by the specified label.
Optionally, the control corresponding to the control identifier selected by the user is a date control; the display module is further configured to:
after the control corresponding to the control identification selected by the user is inserted into each cell of the row or the column identified by the specified label in response to the selection operation of the user on the displayed control identification, displaying a date selection interface in response to the triggering operation of the user on a date control included in the cell;
and identifying the date selected by the user in the date selection interface, and displaying the date selected by the user in the cell targeted by the trigger operation.
Optionally, the control corresponding to the control identifier selected by the user is a code scanning entry control; the device further comprises: a receiving module;
the display module is further configured to, after the control corresponding to the control identifier selected by the user is inserted into each cell in the row or column identified by the specified label in response to the selection operation of the user on the displayed control identifier, display the specified two-dimensional code in response to the trigger operation of the user on the code scanning entry control included in the cell;
the receiving module is used for scanning the specified two-dimensional code through scanning equipment and receiving data corresponding to the specified two-dimensional code acquired by the scanning equipment;
the display module is further configured to display data corresponding to the specified two-dimensional code in the cell targeted by the trigger operation.
In a third aspect, an embodiment of the present invention 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;
and the processor is used for realizing the steps of any method for inserting the control into the table when executing the program stored in the memory.
In a fourth aspect, the embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored in the computer-readable storage medium, and when executed by a processor, the computer program implements the steps of any one of the above methods for inserting a control in a table.
In a fifth aspect, embodiments of the present invention further provide a computer program product containing instructions, which when run on a computer, cause the computer to perform any one of the above methods for inserting a control in a table.
The technical scheme of the embodiment of the invention can at least bring the following beneficial effects: the embodiment of the invention can display the preset control identification after detecting the attribute setting operation triggered by the user in the display range of the designated label in the table, and insert the control corresponding to the control identification selected by the user in each cell of the row or column identified by the designated label. The control can be inserted into the cells in one row or column through one-time operation, and the control does not need to be manually added into each cell in one row or column in sequence, so that the efficiency of inserting the control into the table is improved.
Of course, not all of the advantages described above need to be achieved at the same time in the practice of any one product or method of the invention.
Drawings
In order to more clearly illustrate the embodiments of the present invention 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 invention, 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 flowchart of a method for inserting a control into a table according to an embodiment of the present invention;
FIG. 2 is an exemplary diagram of a table interface provided by an embodiment of the present invention;
FIG. 3 is an exemplary diagram of a table interface provided by an embodiment of the invention;
FIG. 4 is an exemplary diagram of a table interface provided by an embodiment of the present invention;
FIG. 5 is an exemplary diagram of a table interface provided by an embodiment of the present invention;
FIG. 6 is an exemplary diagram of a table interface provided by an embodiment of the present invention;
FIG. 7 is an exemplary diagram of a form interface provided by an embodiment of the present invention;
FIG. 8 is an exemplary diagram of a table interface provided by an embodiment of the present invention;
fig. 9 is a schematic structural diagram of an apparatus for inserting a control in a table according to an embodiment of the present invention;
fig. 10 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, 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 invention.
In order to improve efficiency of inserting a control into a table, an embodiment of the present invention provides a method for inserting a control into a table, which is applied to an electronic device, where the electronic device may be a mobile phone, a tablet computer, a computer, or a like. As shown in fig. 1, the method includes the following steps.
The designated labels are any row labels or any column labels selected by a user in the table, and the attribute setting operation is used for setting controls in each cell in the row or column identified by the designated labels. It will be appreciated that the user may select any row label or any column label in the table, with the user-selected label being the designated label.
As shown in fig. 2, the row numbers in fig. 2 include: 1. 2, 3, 4, 5, 6, 7, 8; the list number includes: A. b, C, D, E, F are provided. It will be appreciated that the row and column designations are non-editable areas in the table, the cells in the row identified by the row designation are editable areas in the table, and the cells in the column identified by the column designation are editable areas in the table.
In fig. 2, the display ranges of the designated symbols are: the range of cells of the index is specified. Taking column index a as an example, the display range of column index a is the range of a cell, i.e., the range within the bold frame in fig. 2.
And 102, responding to the attribute setting operation, and displaying a preset control identification.
In one embodiment, a preset control name may be displayed at a designated position of a designated tab.
For example, as shown in fig. 2, the designated reference number for the property setting operation is B, and in the lower right of B, the displaying of the control name includes: "checkbox", "date", "scan entry", "drop down list", "cell picture".
And 103, in response to the selection operation of the user on the displayed control identification, inserting the control corresponding to the control identification selected by the user into each cell of the row or the column identified by the specified label.
For example, as shown in fig. 2, the designation symbol B indicates that the user can click on a square box corresponding to the "check box", and after the click, the square box displays "√" inside, and each displayed control identifier is hidden; meanwhile, as shown in fig. 3, in each cell of the column identified by B, a check box is inserted. Wherein the initial state of the inserted check box is a box which does not include any symbol inside.
The technical scheme of the embodiment of the invention can at least bring the following beneficial effects: the embodiment of the invention can display the preset control identification after detecting the attribute setting operation triggered by the user in the display range of the designated label in the table, and insert the control corresponding to the control identification selected by the user in each cell of the row or column identified by the designated label. The control can be inserted into the cells in one row or column through one-time operation, and the control does not need to be manually added into each cell in one row or column in sequence, so that the efficiency of inserting the control into the table is improved.
Optionally, in the embodiment of the present invention, the display range of the row label may be referred to as a row header, and the display range of the column label may be referred to as a column header. As shown in fig. 2, the attribute setting operation may be: and clicking operation of the black triangle at the head of the row or the head of the column by the user. The line head, which is not shown in fig. 2, includes a black triangle, and in practical applications, the line head may also include a black triangle.
In the embodiment of the present invention, the manner of inserting the control in step 103 may include the following two steps.
Step one, determining control description information corresponding to a control identification selected by a user according to a corresponding relation between a preset control identification and the control description information.
In the embodiment of the present invention, the control description information is description information for generating one control. For example, the control description information is a function name of the control code.
And secondly, inserting a control corresponding to the control identification in each cell of the row or the column identified by the designated label based on the control description information.
In the embodiment of the invention, each cell has a row label and a column label, and if the designated label is a column label B and the control selected by the user is marked as a check box, the check box code is called and the check box is inserted in each cell with the column label B based on the function name of the check box code.
The technical scheme of the embodiment of the invention can also bring the following beneficial effects: the traditional way of inserting controls into cells is: firstly, selecting a cell, then searching a needed control from an insertion option above a table software display window, and then inserting the needed control into the selected cell. Compared with the traditional mode, by applying the technical scheme of the embodiment of the invention, a user can directly insert the required control in the row or the column by attribute setting operation in the row head or the column head. Therefore, the method for inserting the check boxes in the cells is simplified, and the operation is easy.
In this embodiment of the present invention, as shown in fig. 2, the manner for displaying the preset control identifier in step 102 includes: and responding to the attribute setting operation, and displaying a control identification list. Wherein the control identification list comprises the following identifications of at least one control: check box control, date control, code scanning entry control, drop-down list control and cell picture control.
It should be noted that the control identification list may further include identifications of other controls, and the control that can be inserted in the table is not specifically limited in the embodiment of the present invention.
Optionally, as shown in fig. 2, the control identification list may further include a purge option. Based on this, after the step 103, the control in each cell of the row or column identified by the specified label may also be cleared in response to a triggering operation of the user on a clearing option included in the list of control identifications corresponding to the specified label.
For example, as shown in fig. 3, assuming that the designated tab is column tab B, the control in each cell in the column of column tab B may be cleared in response to a user triggering operation on a clear option included in the list of control identifications corresponding to column tab B. After the clearing, the cells in column B do not include controls.
For example, in the embodiment of the present invention, the control selected by the user to identify the corresponding control may be a check box control. Based on this, after the check box is inserted at the above step 103, "√" is displayed in the check box of the B5 cell when a user toggle operation to the check box in the B5 cell is detected, as shown in fig. 3. Alternatively, when the user's toggle operation on the check box in the B5 cell is detected again, the "√" shape displayed in the check box of the B5 cell is cleared.
In the embodiment of the present invention, the control corresponding to the control identifier selected by the user may be a date control. Based on this, after the date control is inserted in step 103, the data in the cell may be updated, which includes the following two steps.
In the embodiment of the invention, as shown in fig. 4, a date control is inserted into the cell in the C column, when the user is detected to select the C3 cell, an icon of the date control is displayed on the right side of the C3 cell, and a date selection interface is displayed in response to the user clicking the icon of the date control.
Optionally, the date selection interface may be an interface in a box at the lower right of the cell C3 in fig. 4, may also be an interface as shown in fig. 5, or may also be an interface in another style, which is not specifically limited in this embodiment of the present invention.
And 2, identifying the date selected by the user in the date selection interface, and displaying the date selected by the user in the cell targeted by the trigger operation.
As shown in fig. 4, a click operation of a user on one of the dates is detected, the date targeted by the click operation is identified, and the date selected by the user is displayed in the cell C3 targeted by the trigger operation. For example, if it is detected that the user has clicked "12", then "3/12/2020/C3" is displayed.
Referring to fig. 4, as shown in fig. 5, when it is detected that the user clicks "ok", the date set in the dotted line box is identified, and "3/26/2020/s" is displayed in C3.
In the embodiment of the present invention, the control corresponding to the control identifier selected by the user may be a code scanning entry control. Based on this, after the code scanning entry control is inserted in step 103, the data in the cell can be updated, which includes the following three steps.
And (1) responding to the triggering operation of a user on a code scanning entry control included in the cell, and displaying the specified two-dimensional code.
As shown in fig. 6, a code scanning entry control is inserted into the cell in column B in fig. 6, when it is detected that the user selects the cell in column B5, an icon of the code scanning entry control is displayed on the right side of the cell in column B5, and a specified two-dimensional code is displayed in response to a click operation of the user on the icon of the code scanning entry control.
Optionally, the two-dimensional code is designated as a preset two-dimensional code.
And (2) scanning the specified two-dimensional code through scanning equipment, and receiving data corresponding to the specified two-dimensional code acquired by the scanning equipment.
In the embodiment of the invention, the scanning device can be a mobile phone, the mobile phone calls a small program to scan a page, the specified two-dimensional code displayed by the electronic device is scanned, then the mobile phone obtains data corresponding to the specified two-dimensional code, and the electronic device receives the data corresponding to the specified two-dimensional code sent by the mobile phone.
And (3) displaying data corresponding to the specified two-dimensional code in the cell targeted by the trigger operation.
In the embodiment of the present invention, the data corresponding to the specified two-dimensional code may be data such as text, picture, audio, video, or a combination of multiple data.
For example, referring to fig. 5, assuming that the cell targeted by the trigger operation is B5, data corresponding to the specified two-dimensional code is displayed in B5.
In the embodiment of the present invention, the control corresponding to the control identifier selected by the user may be a drop-down list control. Based on this, the manner of inserting the control in step 103 may include: displaying a blank list option, receiving a list option input by a user, and inserting a drop-down list control comprising the list option input by the user in each cell of the row or the column identified by the designated label.
As shown in FIG. 7, assume that a drop down list control is inserted in the cell in column B. When the user is detected to select the cell B3, list options are displayed, wherein the list options comprise: 0-9 years old, 10-19 years old, 20-29 years old. Then, the list option selected by the user is recognized to be 0-9 years old, and the list is displayed in a B3 cell for 0-9 years old.
In the embodiment of the present invention, the control corresponding to the control identifier selected by the user may be a cell picture control. Based on this, after the above step 103, a picture may also be inserted in the cell.
For example, as shown in fig. 8, a cell picture control is inserted into a cell in column a, and when the user is detected to select cell a2, an icon of a cell picture is displayed on the right side of cell a2, for example, a five-pointed star is displayed. And after detecting that the user clicks the five-pointed star, displaying a cell picture selection interface. And identifying the picture selected by the user in the picture selection interface, and displaying the picture selected by the user in the A2 cell.
In the embodiment of the present invention, a column operation may be performed on a column of cells, a row operation may be performed on a row of cells, and operations such as marking and deleting repeated items may be performed on a row or a column of cells.
Based on the same inventive concept, corresponding to the above method embodiment, an embodiment of the present invention provides an apparatus for inserting a control in a table, as shown in fig. 9, where the apparatus includes: a detection module 901, a display module 902 and an insertion module 903.
A detecting module 901, configured to detect, in a display range of a specified label in a table, a property setting operation triggered by a user, where the specified label is any row label or any column label selected by the user in the table, and the property setting operation is used to set a control in each cell in a row or a column identified by the specified label;
a display module 902, configured to display a preset control identifier in response to the attribute setting operation detected by the detection module 901;
and an inserting module 903, configured to insert, in response to a user's selection operation on the control identifier displayed by the display module 902, a control corresponding to the control identifier selected by the user in each cell of the row or column identified by the designated label.
Optionally, the inserting module 903 is specifically configured to:
determining control description information corresponding to the control identification selected by the user according to the corresponding relation between the preset control identification and the control description information;
and inserting the control to identify the corresponding control in each cell of the row or the column identified by the designated label based on the control description information.
Optionally, the display module 902 is specifically configured to:
in response to the property setting operation, displaying a control identification list, wherein the control identification list comprises identifications of at least one of the following controls: check box control, date control, code scanning entry control, drop-down list control and cell picture control.
Optionally, the control identification list further includes a clear option; the device also includes: a purge module 904;
and a clearing module 904, configured to, after inserting a control corresponding to the control identifier selected by the user into each cell in the row or column identified by the specified label in response to the selection operation of the user on the displayed control identifier, clear the control in each cell in the row or column identified by the specified label in response to a trigger operation of the user on a clearing option included in the control identifier list corresponding to the specified label.
Optionally, the control corresponding to the control identifier selected by the user is a date control; the display module 902 is further configured to:
after a control corresponding to the control identification selected by the user is inserted into each cell of the row or the column identified by the specified label in response to the selection operation of the user on the displayed control identification, a date selection interface is displayed in response to the triggering operation of the user on a date control included in the cell;
and identifying the date selected by the user in the date selection interface, and displaying the date selected by the user in the cell targeted by the trigger operation.
Optionally, the control corresponding to the control identifier selected by the user is a code scanning entry control; the device also includes: a receiving module 905;
the display module 902 is further configured to, in response to a selection operation of a user on a displayed control identifier, insert a control corresponding to the control identifier selected by the user in each cell of a row or a column identified by the designated label, and in response to a trigger operation of the user on a code scanning entry control included in the cell, display the designated two-dimensional code;
the receiving module 905 is configured to scan the specified two-dimensional code through the scanning device, and receive data corresponding to the specified two-dimensional code acquired by the scanning device;
the display module 902 is further configured to display data corresponding to the specified two-dimensional code in the cell targeted by the trigger operation.
The embodiment of the present invention further provides an electronic device, as shown in fig. 10, which includes a processor 1001, a communication interface 1002, a memory 1003 and a communication bus 1004, wherein the processor 1001, the communication interface 1002 and the memory 1003 complete mutual communication through the communication bus 1004,
a memory 1003 for storing a computer program;
the processor 1001 is configured to implement the method steps in the above-described method embodiments when executing the program stored in the memory 1003.
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 of the present invention, 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 methods for inserting a control in a table.
In yet another embodiment, a computer program product containing instructions is provided, which when run on a computer causes the computer to perform any of the above-described embodiments of the method for inserting a control in a form.
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 invention 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, as for the apparatus embodiment, since it is substantially similar to the method embodiment, the description is relatively simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The above description is only for the preferred embodiment of the present invention, and is not intended to limit the scope of the present invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention shall fall within the protection scope of the present invention.
Claims (14)
1. A method of inserting a control in a form, the method comprising:
detecting attribute setting operation triggered by a user in a display range of a designated label in a table, wherein the designated label is any row label or any column label selected by the user in the table, and the attribute setting operation is used for setting controls in each cell in the row or column identified by the designated label;
responding to the attribute setting operation, and displaying a preset control identification;
and responding to the selection operation of the user on the displayed control identification, and inserting the control corresponding to the control identification selected by the user into each cell of the row or the column identified by the specified label.
2. The method according to claim 1, wherein the inserting, in response to a user selection operation on a displayed control identification, a control corresponding to the control identification selected by the user in each cell of the row or column identified by the specified label comprises:
determining control description information corresponding to the control identification selected by the user according to the corresponding relation between the preset control identification and the control description information;
and inserting a control corresponding to the control identification in each cell of the row or the column identified by the specified label based on the control description information.
3. The method of claim 1, wherein displaying a preset control identification in response to the property setting operation comprises:
in response to the property setting operation, displaying a control identification list, wherein the control identification list comprises identifications of at least one of the following controls: check box control, date control, code scanning entry control, drop-down list control and cell picture control.
4. The method of claim 3, wherein the list of control identifications further includes a clear option; after the user inserts the control corresponding to the control identification selected by the user into each cell of the row or the column identified by the specified label in response to the selection operation of the user on the displayed control identification, the method further comprises the following steps:
and in response to the triggering operation of the user on the clearing option included in the control identification list corresponding to the specified label, clearing the control in each cell of the row or the column identified by the specified label.
5. The method of any of claims 1-4, wherein the user-selected control identifies the corresponding control as a date control; after the user inserts the control corresponding to the control identification selected by the user into each cell of the row or the column identified by the specified label in response to the selection operation of the user on the displayed control identification, the method further comprises the following steps:
responding to the triggering operation of a user on a date control included in the cell, and displaying a date selection interface;
and identifying the date selected by the user in the date selection interface, and displaying the date selected by the user in the cell targeted by the trigger operation.
6. The method of any of claims 1-4, wherein the user-selected control identifies the corresponding control as a code-scan entry control; after the user inserts the control corresponding to the control identification selected by the user into each cell of the row or the column identified by the specified label in response to the selection operation of the user on the displayed control identification, the method further comprises the following steps:
responding to the triggering operation of a user on a code scanning entry control included in the cell, and displaying a specified two-dimensional code;
scanning the specified two-dimensional code through scanning equipment, and receiving data corresponding to the specified two-dimensional code acquired by the scanning equipment;
and displaying data corresponding to the specified two-dimensional code in the cell targeted by the trigger operation.
7. An apparatus for inserting controls in a form, the apparatus comprising:
the system comprises a detection module, a display module and a control module, wherein the detection module is used for detecting attribute setting operation triggered by a user in a display range of a designated label in a table, the designated label is any row label or any column label selected by the user in the table, and the attribute setting operation is used for setting controls in each cell in the row or column identified by the designated label;
the display module is used for responding to the attribute setting operation detected by the detection module and displaying a preset control identification;
and the inserting module is used for responding to the selection operation of the user on the control identification displayed by the display module and inserting the control corresponding to the control identification selected by the user into each cell of the row or the column identified by the specified label.
8. The device according to claim 7, characterized in that the insertion module is specifically configured to:
determining control description information corresponding to the control identification selected by the user according to the corresponding relation between the preset control identification and the control description information;
and inserting a control corresponding to the control identification in each cell of the row or the column identified by the specified label based on the control description information.
9. The apparatus of claim 7, wherein the display module is specifically configured to:
in response to the property setting operation, displaying a control identification list, wherein the control identification list comprises identifications of at least one of the following controls: check box control, date control, code scanning entry control, drop-down list control and cell picture control.
10. The apparatus of claim 9, wherein the list of control identifications further comprises a clear option; the device further comprises: a clearing module;
and the clearing module is used for responding to the triggering operation of the clearing option included in the control identification list corresponding to the specified label by the user after the control corresponding to the control identification selected by the user is inserted into each cell of the row or the column identified by the specified label in response to the selection operation of the user on the displayed control identification, and clearing the control in each cell of the row or the column identified by the specified label.
11. The apparatus of any of claims 7-10, wherein the user-selected control identifies the corresponding control as a date control; the display module is further configured to:
after the control corresponding to the control identification selected by the user is inserted into each cell of the row or the column identified by the specified label in response to the selection operation of the user on the displayed control identification, displaying a date selection interface in response to the triggering operation of the user on a date control included in the cell;
and identifying the date selected by the user in the date selection interface, and displaying the date selected by the user in the cell targeted by the trigger operation.
12. The apparatus of any of claims 7-10, wherein the user-selected control identifies the corresponding control as a code-scan entry control; the device further comprises: a receiving module;
the display module is further configured to, after the control corresponding to the control identifier selected by the user is inserted into each cell in the row or column identified by the specified label in response to the selection operation of the user on the displayed control identifier, display the specified two-dimensional code in response to the trigger operation of the user on the code scanning entry control included in the cell;
the receiving module is used for scanning the specified two-dimensional code through scanning equipment and receiving data corresponding to the specified two-dimensional code acquired by the scanning equipment;
the display module is further configured to display data corresponding to the specified two-dimensional code in the cell targeted by the trigger operation.
13. An electronic device comprising a processor and a memory, wherein,
a memory for storing a computer program;
a processor for implementing the method steps of any of claims 1-6 when executing a program stored on a memory.
14. 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 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010674476.9A CN112799564A (en) | 2020-07-14 | 2020-07-14 | Method, device, electronic equipment and medium for inserting control in table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010674476.9A CN112799564A (en) | 2020-07-14 | 2020-07-14 | Method, device, electronic equipment and medium for inserting control in table |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112799564A true CN112799564A (en) | 2021-05-14 |
Family
ID=75806522
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010674476.9A Pending CN112799564A (en) | 2020-07-14 | 2020-07-14 | Method, device, electronic equipment and medium for inserting control in table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112799564A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115577676A (en) * | 2022-12-07 | 2023-01-06 | 苏州万店掌网络科技有限公司 | Page table control method, device, equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5721847A (en) * | 1994-10-21 | 1998-02-24 | Microsoft Corporation | Method and system for linking controls with cells of a spreadsheet |
| CN105474163A (en) * | 2013-06-14 | 2016-04-06 | 微软技术许可有限责任公司 | Natural quick function gestures |
| US20160334954A1 (en) * | 2006-12-28 | 2016-11-17 | Apple Inc. | Smart tables |
| CN106445900A (en) * | 2016-09-20 | 2017-02-22 | 东软集团股份有限公司 | Table style processing method and device |
| CN107392560A (en) * | 2016-05-16 | 2017-11-24 | 杨国成 | A kind of Excel list datas issue acquisition method and system based on internet |
-
2020
- 2020-07-14 CN CN202010674476.9A patent/CN112799564A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5721847A (en) * | 1994-10-21 | 1998-02-24 | Microsoft Corporation | Method and system for linking controls with cells of a spreadsheet |
| US20160334954A1 (en) * | 2006-12-28 | 2016-11-17 | Apple Inc. | Smart tables |
| CN105474163A (en) * | 2013-06-14 | 2016-04-06 | 微软技术许可有限责任公司 | Natural quick function gestures |
| CN107392560A (en) * | 2016-05-16 | 2017-11-24 | 杨国成 | A kind of Excel list datas issue acquisition method and system based on internet |
| CN106445900A (en) * | 2016-09-20 | 2017-02-22 | 东软集团股份有限公司 | Table style processing method and device |
Non-Patent Citations (6)
| Title |
|---|
| 伍艳均: "如何在送货单上增加二维码，实现手机扫码入仓", 《HTTPS://JINGYAN.BAIDU.COM/ARTICLE/3EA514899B4B0152E61BBAA9.HTML》 * |
| 伍艳均: "如何在送货单上增加二维码，实现手机扫码入仓", 《HTTPS://JINGYAN.BAIDU.COM/ARTICLE/3EA514899B4B0152E61BBAA9.HTML》, 10 May 2020 (2020-05-10), pages 1 - 3 * |
| 刘鑫道: "excel数据有效性设置性别", pages 1 - 4, Retrieved from the Internet <URL:https://jingyan.baidu.com/article/cbf0e500de786d6fab289307.html> * |
| 品客爱坎蒂: "excel中怎样筛选表格", 《HTTPS://JINGYAN.BAIDU.COM/ARTICLE/CBF0E5009B91282EAA28932F.HTML》 * |
| 品客爱坎蒂: "excel中怎样筛选表格", 《HTTPS://JINGYAN.BAIDU.COM/ARTICLE/CBF0E5009B91282EAA28932F.HTML》, 10 January 2016 (2016-01-10), pages 1 - 3 * |
| 已注销: "如何设置Excel表格的数据有效性？", pages 36 - 37, Retrieved from the Internet <URL:https://jingyan.baidu.com/article/1709ad802fc1784634c4f01b.html> * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115577676A (en) * | 2022-12-07 | 2023-01-06 | 苏州万店掌网络科技有限公司 | Page table control method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106484266B (en) | Text processing method and device | |
| CN106991179B (en) | Data deleting method and device and mobile terminal | |
| CN104243273A (en) | Method and device for displaying information on instant messaging client and information display system | |
| CN109359582B (en) | Information searching method, information searching device and mobile terminal | |
| CN111444750B (en) | PDF document identification method and device and electronic equipment | |
| CN111414727A (en) | Method and device for editing header and footer of PDF (Portable document Format) document and electronic equipment | |
| CN111368226A (en) | Screening method and device, electronic equipment and computer readable storage medium | |
| CN110825303A (en) | Interaction method, device, terminal and computer readable medium | |
| CN112799564A (en) | Method, device, electronic equipment and medium for inserting control in table | |
| CN112329409B (en) | Cell color conversion method and device and electronic equipment | |
| CN112912844A (en) | File collection method, file collection device and terminal equipment | |
| CN112269869A (en) | Method and device for querying keywords | |
| CN108834202B (en) | Information display method and equipment | |
| CN110795922B (en) | Form information display method and device for PDF document and electronic equipment | |
| CN112328837A (en) | Data display method, device, equipment and storage medium | |
| CN112783395B (en) | Method, device, electronic equipment and medium for displaying form field | |
| CN112306336A (en) | Document content display method and device | |
| CN111832270A (en) | Method and device for displaying row number and column label of table and electronic equipment | |
| CN112100122B (en) | Method and device for storing picture | |
| CN112232046A (en) | Method and device for displaying repeated items of table | |
| CN109992346A (en) | Methods of exhibiting, device and the equipment of virtual objects | |
| CN112783400B (en) | Document content selection method and device, electronic equipment and storage medium | |
| CN112100319A (en) | Method and device for searching marked text in document and electronic equipment | |
| CN112784550B (en) | Information input method and device | |
| CN113536750A (en) | Table marking method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210514 |
|
| RJ01 | Rejection of invention patent application after publication |