CN108287713A - Adding method and device, terminal, storage medium, the electronic device of document function - Google Patents
Adding method and device, terminal, storage medium, the electronic device of document function Download PDFInfo
- Publication number
- CN108287713A CN108287713A CN201711427632.6A CN201711427632A CN108287713A CN 108287713 A CN108287713 A CN 108287713A CN 201711427632 A CN201711427632 A CN 201711427632A CN 108287713 A CN108287713 A CN 108287713A
- Authority
- CN
- China
- Prior art keywords
- multiselect
- combobox
- mentioned
- control
- document
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- 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
Abstract
The invention discloses a kind of adding method of document function and device, terminal, storage medium, electronic devices.Wherein, this method includes：Receive the first signal, wherein the first signal is that the first specified control for acting on document generates, and specified control is for triggering the control for supporting multiselect drop down box function；Add the executable file for supporting multiselect drop down box function.The present invention solves the less efficient technical problem that the relevant technologies use multiselect drop down box function in a document.
Description
Technical field
The present invention relates to development of software technology fields, adding method and device in particular to a kind of document function,
Terminal, storage medium, electronic device.
Background technology
Document in the related technology does not support multiselect drop-down list box (abbreviation multiselect combobox), especially Excel texts
Shelves, if to realize that the function of multiselect combobox can only realize that this not only needs to make by way of programming (such as VBA programmings)
It is familiar with VBA language with personnel, is familiar with Excel programmings, that is, user is needed to have certain programming grounding in basic skills, thus increases using branch
Hold the threshold that uses of the document of multiselect combobox, and while being needed every time using multiselect combobox be required for by reprogram come
It realizes, workload is also larger, and service efficiency is relatively low.
For above-mentioned problem, currently no effective solution has been proposed.
Invention content
An embodiment of the present invention provides a kind of adding method of document function and device, terminal, storage medium, electronics dresses
It sets, at least to solve the less efficient technical problem that the relevant technologies use multiselect drop down box function in a document.
One side according to the ... of the embodiment of the present invention provides a kind of adding method of document function, including：Receive first
Signal, wherein the first signal is that the first specified control for acting on document generates, and it is to be supported for triggering to specify control
The control of multiselect drop down box function；Add the executable file for supporting multiselect drop down box function.
Optionally, after the executable file that multiselect drop down box function is supported in addition, method further includes：Receive the second letter
Number, wherein second signal is that the designated position of the second current page for acting on document generates；For the specific bit of current page
Set operation executable file.
Optionally, during running executable file for the designated position of current page, method further includes：In specific bit
It sets place and shows multiselect combobox；Wherein, one or more option values are loaded in multiselect combobox.
Optionally, before specified location shows multiselect combobox, method further includes：Determine that current page whether there is
First control；Wherein, there is no the first control, the first control is added for current page.
Optionally, before specified location shows multiselect combobox, method further includes：It determines in designated position column
First cell in the first cell be expert at of content and designated position in content whether there is identical word
Symbol string；Wherein, determining there are in the case of identical character string multiselect combobox is shown in specified location.
Optionally, after showing multiselect combobox in specified location, method further includes：Monitor the acceptance of the bid of multiselect combobox
Whether one or more option values of note change；In the case where changing, updated according to changed option value
The display content of specified location.
Optionally, method further includes：Monitor content in the first cell of the designated position column and/or
Whether the content in the first cell that the designated position is expert at is changed；In the case where variation has occurred,
Update at least one of：Content in the first cell of the designated position column, the designated position are expert at
First cell in content, the dispaly state of the multiselect combobox, one loaded in the multiselect combobox or
Multiple option values.
One side according to the ... of the embodiment of the present invention provides a kind of terminal, for providing human-computer interaction interface, man-machine friendship
Mutual interface includes specified control, wherein specified control is for triggering the control for supporting multiselect drop down box function.
One side according to the ... of the embodiment of the present invention provides a kind of adding set of document function, including：Receive mould
Block, for receiving the first signal, wherein wherein, the first signal is that the first specified control for acting on document generates, and is referred to
It is for triggering the control for supporting multiselect drop down box function to determine control；Processing module, for adding for supporting multiselect combobox
The executable file of function.
One side according to the ... of the embodiment of the present invention provides a kind of storage medium, computer is stored in storage medium
Program, wherein computer program is arranged to execute the method in any of the above-described when operation.
One side according to the ... of the embodiment of the present invention provides a kind of electronic device, including memory and processor, storage
Computer program is stored in device, processor is arranged to run computer program to execute the method in any of the above-described.
In embodiments of the present invention, the finger that the document supports addition multiselect combobox is used to indicate using setting in a document
Determine the mode of control, when in use by specifying control to operate this, come trigger support multiselect drop down box function, by
Under the triggering of first signal, executable file of the automatic addition for supporting multiselect drop down box function so that document is provided with branch
The function of multiselect combobox is held, i.e., can realize the work(for supporting multiselect combobox by being operated to above-mentioned specified control
Can, because needing the when of using to reprogram without user, thus reduce workload, also improves using effect
Rate, and then solve the less efficient technical problem that the relevant technologies use multiselect drop down box function in a document.
Description of the drawings
Attached drawing described herein is used to provide further understanding of the present invention, and is constituted part of this application, this hair
Bright illustrative embodiments and their description are not constituted improper limitations of the present invention for explaining the present invention.In the accompanying drawings：
Fig. 1 is the flow diagram of the adding method of document function according to the ... of the embodiment of the present invention；
Fig. 2 is the structure diagram of the adding set for the document function of being provided according to the preferred embodiment of the present invention；
Fig. 3 is a schematic diagram of the human-computer interaction interface provided according to embodiments of the present invention；
Fig. 4 is the unit in Sheet pages of display window in the Excel provided according to the preferred embodiment of the present invention
The schematic diagram of multiselect combobox is shown in lattice；
Fig. 5 is that the value chosen in multiselect combobox in the B3 cells provided according to a preferred embodiment of the invention is switched to
2,3 be schematic diagram；
Fig. 6 is the schematic diagram of the method for the function of the addition multiselect combobox provided according to the preferred embodiment of the present invention；
Fig. 7 is the schematic diagram of the method using multiselect drop down box function provided according to the preferred embodiment of the present invention；
Fig. 8 is the process schematic of the button addition and Sheet pages of template of addition that are provided according to the preferred embodiment of the present invention；
Fig. 9 is the schematic diagram of the process of the button of the use addition provided according to the preferred embodiment of the present invention.
Specific implementation mode
In order to enable those skilled in the art to better understand the solution of the present invention, below in conjunction in the embodiment of the present invention
Attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is only
The embodiment of a part of the invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill people
The every other embodiment that member is obtained without making creative work should all belong to the model that the present invention protects
It encloses.
It should be noted that term " first " in description and claims of this specification and above-mentioned attached drawing, "
Two " etc. be for distinguishing similar object, without being used to describe specific sequence or precedence.It should be appreciated that using in this way
Data can be interchanged in the appropriate case, so as to the embodiment of the present invention described herein can in addition to illustrating herein or
Sequence other than those of description is implemented.In addition, term " comprising " and " having " and their any deformation, it is intended that cover
It includes to be not necessarily limited to for example, containing the process of series of steps or unit, method, system, product or equipment to cover non-exclusive
Those of clearly list step or unit, but may include not listing clearly or for these processes, method, product
Or the other steps or unit that equipment is intrinsic.
According to embodiments of the present invention, a kind of embodiment of the method for the adding method of document function is provided, needs to illustrate
It is that step shown in the flowchart of the accompanying drawings can execute in the computer system of such as a group of computer-executable instructions,
Also, although logical order is shown in flow charts, and it in some cases, can be to be executed different from sequence herein
Shown or described step.
Fig. 1 is the flow diagram of the adding method of document function according to the ... of the embodiment of the present invention, as shown in Figure 1, the party
Method includes the following steps：
Step S102 receives the first signal, wherein the first signal is that the first specified control for acting on document generates
, specified control is for triggering the control for supporting multiselect drop down box function；
Step S104 adds the executable file for supporting multiselect drop down box function.
Through the above steps, the specified control that the document supports addition multiselect combobox is used to indicate using setting in a document
The mode of part supports multiselect drop down box function, by first when in use by specifying control to operate this to trigger
Under the triggering of signal, executable file of the automatic addition for supporting multiselect drop down box function so that it is more that document is provided with support
The function of combobox is selected, i.e., can realize the function of supporting multiselect combobox by being operated to above-mentioned specified control, because
It is needing the when of using to reprogram without user, thus is reducing workload, also improving service efficiency, in turn
Solves the less efficient technical problem that the relevant technologies use multiselect drop down box function in a document.
It should be noted that above-mentioned steps S104 can be shown as：Under the triggering of above-mentioned first signal, automatically described
Above-mentioned executable file is edited in the Code Edit frame of document and is preserved.In this way, automatic addition is realized for branch
The executable file of multiselect drop down box function is held, so that above-mentioned document is provided with the function of supporting multiselect combobox.
It should be noted that above-mentioned executable file is referred to as script, code, program etc., but it is not limited to this.
Optionally, after above-mentioned steps S104, the above method further includes：Receive second signal, wherein second signal is
What the second designated position for acting on the current page of document generated；Above-mentioned executable text is run for the designated position of current page
Part.
It should be noted that it is above-mentioned first operation and it is above-mentioned second operation can be that touch operation is such as clicked, double-click or
Pressing operation etc. can also be suspension procedure, and but it is not limited to this.Above-mentioned document can be Word document, can also be Excel
Document, however it is not limited to this.Optionally, above-mentioned Word document can also include table, and but it is not limited to this, and above-mentioned designated position can
Can also be the list of the current page in Excel document to be the position where the cell in table that Word document includes
Position where first lattice, but it is not limited to this.
It should be noted that above-mentioned specified control is properly termed as supporting multiselect control, it is referred to as addition and supports multiselect
Combobox control, but it is not limited to this, and control may be button, and button etc. is not limited to this.
It should be noted that during operationally stating executable file, the above method can also include：In specific bit
It sets place and shows multiselect combobox；Wherein, one or more option values are loaded in multiselect combobox.
It should be noted that before specified location shows multiselect combobox, the above method further includes：It determines specified
Whether the content in the first cell that the content in the first cell of position column is expert at designated position deposits
In identical character string；Wherein, determining there are in the case of identical character string multiselect drop-down is shown in specified location
Frame.
It should be noted that above-mentioned character string can be number, letter, Chinese character, use for convenience, it can
Selection of land, above-mentioned character string may include：Character string for the rule for selecting one or more option values in specified location.
It should be noted that the character string of the above-mentioned rule for selecting one or more option values in specified location can
With referred to as multiselect label, such as multiselect 1, multiselect 2, multiselect 3 etc., but it is not limited to this, is illustrated by taking multiselect 1 as an example, above-mentioned
Rule can serve to indicate that selects an option value at cell from one or more option values.
It should be noted that determining there is no in the case of identical character string, multiselect is not shown in specified location
Combobox.
Optionally, the one or more option values loaded in above-mentioned multiselect combobox can be expert at by designated position
Content some or all of in the first cell of one cell or designated position column.With above-mentioned one or more choosings
For some or all of the first unit lattice that entry value is expert at by above-mentioned designated position content, be expert in designated position
One or more option values of one cell can have set form, and said one or multiple option values can be numbers, alphabetical,
Chinese character or a combination thereof, but it is not limited to this, such as if the one or more option values loaded in multiselect combobox are 1,
2,3, then it can be in the first unit lattice that the designated position is expert at【1|2|3】Performance, can also be with【' 1 ', ' 2 ',
‘3’】Performance, but it is not limited to this.
It should be noted that first cell or specific bit that above-mentioned character string and/or above-mentioned designated position are expert at
It can be according to need some or all of to set in the first cell of column content (such as above-mentioned one or more option values)
It is configured, after the setup, carries out corresponding update in specified location, for example change in above-mentioned character string, lead
It causes in the first cell that the content in the first cell of specified location column is expert at designated position
Identical character string is not present in content, then no longer show multiselect combobox in the specified location, or above-mentioned to above-mentioned
Content some or all of in the first cell of first cell or designated position column that designated position is expert at
(such as above-mentioned one or more option values) is reset, for example the numerical value of one or more option values is changed,
It either increases the number of option value or reduces the number of option value, then the multiselect drop-down shown in specified location
The one or more option values loaded in frame have also carried out corresponding update, such as correspondingly, its numerical value is updated, or
Increase the quantity of the option value in multiselect combobox, or reduces the quantity of the option value of multiselect combobox.
In the first cell of the first cell or designated position column be expert at above-mentioned designated position
Part or all of content (such as above-mentioned one or more option values) can be for being configured as needed, the one of the present invention
In a embodiment；
It should be noted that the above method can also include：Monitor first unit in the designated position column
Whether the content in the first cell that content and/or the designated position in lattice are expert at is changed；Occurring
In the case of variation, at least one of is updated：Content in the first cell of the designated position column, it is described
Content in the first cell that designated position is expert at, the dispaly state of the multiselect combobox, the multiselect combobox
One or more option values of middle load.
It should be noted that after specified location shows multiselect combobox, display is based on history in multiselect combobox
The said one or multiple option values of record value label can also show one or more options of the operation label based on user
Value, and then show one or more option values of the label in the specified location.Thus, the above method can also include：Prison
Whether the one or more option values marked in control multiselect combobox change；In the case where changing, according to generation
The display content of the option value update specified location of variation.
It should be noted that specified location show multiselect combobox also need in this prior page there are the first control,
Thus, in one embodiment of the invention, before specified location shows multiselect combobox, the above method further includes：Really
Determine current page and whether there is the first control；There is no the first control, the first control is added for designated position.
It should be noted that determining that as long as the execution action with the presence or absence of the first control at current page is happened at above-mentioned finger
It positions before the place of setting shows multiselect combobox, for example determining that current page is acted with the presence or absence of the execution of the first control can be with
It is happened at after above-mentioned steps S102 (by being determined in current page with the presence or absence of first to specifying control to carry out operation triggering execution
The action of control), it can also be happened at after receiving second signal and (be determined by carrying out operation triggering execution to designated position
Whether there is the action of the first control at current page), it is not limited to this.It should be noted that above-mentioned first control can be
List box Listbox controls, but it is not limited to this.In addition, Sheet pages in an Excel only needs to add a Listbox
Control, but be different Sheet and need to add in Listbox controls, such as current Excel that there are 3 Sheet tables respectively
(Sheet1, Sheet2, Sheet3), Sheet1 has been added to Sheet1, and in Sheet2 and is not added with, then from Sheet1
After being switched to Sheet2, if Sheet2 needs to show multiselect combobox, need to add above-mentioned first control in the Sheet2
Part is again turned on but it should be recognized that after being added to above-mentioned first control in Sheet2 in the Excel
It has existed above-mentioned first control when Sheet2, thus no longer needs to add above-mentioned first control.
Designated position by under the triggering of second signal, being current page runs above-mentioned executable file, i.e., to this
Specified control realizes this by the executable file of calling and operation support multiselect drop down box function after being operated and specifies
Multiselect combobox is shown at position, and can also be used in the case where user does not know about any programming language, i.e., not
It needs user that there is certain programming grounding in basic skills, reduces and use threshold using support multiselect combobox.
Multiselect combobox is used in order to facilitate user, or current page can in document to realize for guide user's operation document
It supports multiselect combobox, needs that page template is arranged for the document, thus, in one embodiment of the invention, in above-mentioned steps
After S102, the above method can also include：In the case of there is page template in a document, calls and run and can hold for page template
Style of writing part；In the case of page template is not present in a document, it is document addition page template and is that the page template added is called and transported
Row executable file by taking Excel as an example, can add masterplate page, this masterplate page can after having executed S102 steps in Excel
To guide user to carry out writing relevant data in new Sheet, user can operate in masterplate page can also be
It is operated in new Sheet.
It whether there is page template in a document it is alternatively possible to determine in the following manner, but it is not limited to this：Determine text
With the presence or absence of the page with specified title in shelves, in case of presence, determine that there are page templates, in case of absence,
It determines and page template is not present.
It should be noted that above-mentioned specified title can be " multiselect template " either " template " or
" MultiTemplate " or " Template ", but it is not limited to this.
In one embodiment of the invention, above-mentioned specified control can be corresponding with specified function, wherein above-mentioned specified letter
Number is the function for realizing addition multiselect function.
It should be noted that above-mentioned specified function can be fixed function, such as AddMultiSelect functions, but simultaneously
It is without being limited thereto.
It should be noted that before above-mentioned steps S102, needs that above-mentioned specified control is first installed, be with above-mentioned document
It is illustrated for Excel file, it can be the custom tool menu by using Excel itself to install above-mentioned specified control
Custom button in function, which is tied in above-mentioned specified function, that is, completes above-mentioned specified control
Installation.
Optionally, then call addition template function AddTemplate (), i.e., be mounted with above-mentioned specified control or
Can the function of template directly be added by calling to add template, in addition template during above-mentioned specified control is installed
Later, above-mentioned executable file is called for the template after addition.
It should be noted that if having installed primary above-mentioned specified control in the vehicle equipment where above-mentioned document
Part can all be directly displayed when being again turned on above-mentioned document or again a newly-built above-mentioned document on the vehicle equipment and opening
Above-mentioned specified control, and no longer reinstalled.
It should be noted that the executive agent of above-mentioned steps can be terminal, server, or can open or handle text
The electronic equipment of shelves, but it is not limited to this.
According to embodiments of the present invention, a kind of adding set of document function is additionally provided, Fig. 2 is according to of the invention preferred real
The structure diagram that the adding set of the document function of example offer is provided, as shown in Fig. 2, the device includes：
Receiving module 22, for receiving the first signal, wherein wherein, the first signal acts on document for first
What specified control generated, specified control is for triggering the control for supporting multiselect drop down box function；
Processing module 24 is connect with above-mentioned receiving module 22, for adding for supporting holding for multiselect drop down box function
Style of writing part.
By above-mentioned apparatus, the specified control that the document supports addition multiselect combobox is used to indicate using setting in a document
The mode of part, and then the operation that control is specified to this can be being received by above-mentioned receiving module 32 when in use, to trigger branch
Multiselect drop down box function is held, above-mentioned processing module 24 is under the triggering of the first signal, and automatic addition is for supporting multiselect combobox
The executable file of function so that document is provided with the function of supporting multiselect combobox, i.e., by being carried out to above-mentioned specified control
Operation can realize the function of supporting multiselect combobox, because needing the when of using to reprogram without user,
Thus reduce workload, also improve service efficiency, and then solves the relevant technologies and use multiselect combobox work(in a document
The less efficient technical problem of energy.
It should be noted that above-mentioned processing module 24 is additionally operable to：Under the triggering of above-mentioned first signal, automatically in the text
Above-mentioned executable file is edited in the Code Edit frame of shelves and is preserved.In this way, automatic addition is realized for supporting
The executable file of multiselect drop down box function, so that aforementioned stable is provided with the function of supporting multiselect combobox.
Optionally, above-mentioned receiving module 22 is additionally operable to receive second signal, wherein second signal acts on for second
What the designated position of the current page of document generated；Above-mentioned processing module 24, it is executable for the designated position operation for current page
File.
It should be noted that it is above-mentioned first operation and it is above-mentioned second operation can be that touch operation is such as clicked, double-click or
Pressing operation etc. can also be suspension procedure, and but it is not limited to this.Above-mentioned document can be Word document, can also be Excel
Document, however it is not limited to this.Optionally, above-mentioned Word document can also include table, and but it is not limited to this, and above-mentioned designated position can
Can also be the list of the current page in Excel document to be the position where the cell in table that Word document includes
Position where first lattice, but it is not limited to this.
It should be noted that above-mentioned specified control is properly termed as supporting multiselect control, it is referred to as addition and supports multiselect
Combobox control, but it is not limited to this, and control may be button, and button etc. is not limited to this.
In one embodiment of the invention, above-mentioned apparatus further includes：Display module is connect with above-mentioned processing module 24,
During operationally stating executable file, multiselect combobox is shown in specified location；Wherein, in multiselect combobox
It is loaded with one or more option values.
It should be noted that above-mentioned apparatus further includes：First determining module is connect with above-mentioned display module, for determining
Content in the first cell that content in the first cell of designated position column is expert at designated position
With the presence or absence of identical character string；Wherein, determining there are in the case of identical character string, above-mentioned display module is additionally operable to
Specified location shows multiselect combobox.
It should be noted that above-mentioned character string can be number, letter, Chinese character, use for convenience, it can
Selection of land, above-mentioned character string may include：Character string for the rule for selecting one or more option values in specified location.
It should be noted that the character string of the above-mentioned rule for selecting one or more option values in specified location can
With referred to as multiselect label, such as multiselect 1, multiselect 2, multiselect 3 etc., but it is not limited to this, is illustrated by taking multiselect 1 as an example, above-mentioned
Rule can serve to indicate that selects an option value at cell from one or more option values.
It should be noted that above-mentioned display unit is additionally operable to referring to there is no in the case of identical character string determining
The positioning place of setting does not show multiselect combobox.In one embodiment of the invention, above-mentioned apparatus can also include：Monitoring module,
It is connect with above-mentioned display module, for monitoring content and/or institute in the first cell of the designated position column
State whether the content in the first cell that designated position is expert at is changed；Update module, with above-mentioned monitoring module
Connection, in the case where variation has occurred, according to first unit of the designated position column changed
Content in the first cell that content in lattice and/or the designated position changed are expert at, update are following
At least one：Content in the first cell of the designated position column, be expert at first of the designated position
Content in cell, the dispaly state of the multiselect combobox, the one or more options loaded in the multiselect combobox
Value.
It should be noted that above-mentioned dispaly state may include display or not show, but it is not limited to this.
It should be noted that above-mentioned monitoring module is connect with above-mentioned display module, only an optional embodiment,
It does not limit.
It should be noted that above-mentioned monitoring module is additionally operable to the one or more option values marked in monitoring multiselect combobox
Whether change；Update module is additionally operable to update specified location according to changed option value in varying situations
Display content.
In one embodiment of the invention, above-mentioned apparatus further includes：Second determining module connects with above-mentioned display module
It connects, whether there is the first control at current page for determining；Add module is connect with above-mentioned determining module, for there is no
In the case of first control, the first control is added for current page.
It should be noted that above-mentioned display module is additionally operable to the case where above-mentioned determining module determines that there are the first controls
Under, show multiselect combobox in specified location.It should be noted that above-mentioned determining module can also be with above-mentioned receiving module 32
Connection, but it is not limited to this.
It should be noted that above-mentioned first control can be list box Listbox controls, but it is not limited to this.
By above-mentioned apparatus, under the triggering of second signal, called for current page for supporting multiselect drop down box function
Executable file, i.e., to this specify control to operate after by calling support multiselect drop down box function executable file
The function that the current page supports multiselect combobox is realized, and in the case where user does not know about any programming language
It can use, that is, not needing user has certain programming grounding in basic skills, reduces and uses threshold using support multiselect combobox.
In one embodiment of the invention, above-mentioned apparatus can also include：Processing module 24, for existing in a document
In the case of page template, executable file is called for page template；And/or there is no in the case of page template, be literary in a document
Shelves addition page template simultaneously calls executable file for the page template of addition.
It should be noted that above-mentioned apparatus further includes：Third determining module is connect with above-mentioned receiving module 22, for true
Determine with the presence or absence of the page with specified title in document, in case of presence, determine there are page template, there is no the case where
Under, it determines and page template is not present.
It should be noted that above-mentioned specified control can be corresponding with specified function, wherein above-mentioned specified function is for reality
Now add the function of multiselect function.
It should be noted that above-mentioned specified function can be fixed function, such as AddMultiSelect functions, but simultaneously
It is without being limited thereto.
It should be noted that the adding set of above-mentioned document function can be located at terminal, server, or can open or
In the electronic equipment for handling document, but it is not limited to this.
According to embodiments of the present invention, a kind of terminal is additionally provided, for providing human-computer interaction interface, in human-computer interaction interface
Including specifying control, wherein specified control is the control for triggering multiselect drop down box function.
Include for triggering multiselect drop down box function in the human-computer interaction interface of above-mentioned terminal by above-mentioned terminal
Control can support multiselect drop down box function, and then realize when in use by specifying control to operate this to trigger
Multiselect drop down box function is supported in automatic addition, is needing the when of using to reprogram without user, thus is reduced
Workload, also improves service efficiency, and then solves the efficiency that the relevant technologies use multiselect drop down box function in a document
Relatively low technical problem.
It should be noted that after the first signal for acting on that the specified control generates first, added automatically
Executable file for supporting multiselect drop down box function.
It should be noted that above-mentioned human-computer interaction interface can also include：The first row of first window, first window includes
The first row of the one or more option values shown in first designated label and multiselect combobox, first window includes second specified
Label；Or the first row of first window includes the one or more options shown in first designated label and multiselect combobox
Value, the first row of first window includes second designated label.
It should be noted that above-mentioned the first row and above-mentioned first row can also be hidden and be shown in human-computer interaction interface.
It should be noted that under first designated label and second designated label unanimous circumstances, in human-computer interaction interface
Show multiselect combobox, wherein the display location of multiselect combobox mark is specified as the position and second where first designated label
Location determination where signing.
It should be noted that above-mentioned first designated label and above-mentioned second designated label can be with the characters in above-described embodiment
String, but it is not limited to this.
Fig. 3 is a schematic diagram of the human-computer interaction interface provided according to embodiments of the present invention, as shown in figure 3, using circle
The button " supporting multiselect " gone out, as above-mentioned designated button, above-mentioned first designated label can consider the multiselect 1 in A row, multiselect
2 etc., above-mentioned second designated label can be the multiselect 1 in 1 row, multiselect 2, multiselect 3 etc..
In order to be better understood by the embodiment of the present invention, the present invention is further explained below in conjunction with preferred embodiment.
The method that the preferred embodiment of the present invention provides, illustrates, this method includes by taking Excel as an example：Use the VBA of Excel itself
Programming mode writes the executable file of the combobox (multiselect combobox) of a configurable support multiselect, specific implementation
The step of include：
1), using the functions of custom tool menu of Excel itself, by some macro script directly as a button (phase
When in above-mentioned designated button) it is placed in Excel function bars, after such once mounting, an excel file is arbitrarily opened, can
There is this addition to support the entrance of multiselect combobox, which is above-mentioned designated button, the button gone out with circle as shown in Figure 3
" supporting multiselect " button.
2)、ActiveWorkbook.VBProject.VBComponents("ThisWorkbook")
.CodeModule.InsertLines function：
In order to allow each Excel file can automatic adaptation whether support, used this function of InsertLines, from
It moves and gives Excel additions script (being equivalent to the above-mentioned executable file for supporting multiselect drop down box function).
Multiselect combobox is supported to need to write code, but be intended to any one newly-built Excel file to have this work(
Can, it needs to add automatically and supports above-mentioned script.So when user's point supports the button of multiselect (to be equivalent to the first above-mentioned behaviour
Make) after, it is more some supports will to be edited in the Code Edit frame of the ThisWorkBook of the WorkBook of current active automatically
It selects the code (being equivalent to for supporting the executable file of multiselect drop down box function or above-mentioned script) of drop-down and preserves, in this way
Current WorkBook just has the ability for supporting multiselect combobox, i.e., the button of above-mentioned support multiselect can be by foot after being clicked
This write-in simultaneously preserves, and for that can be called when Excel supports above-mentioned function.
3), Workbook_SheetSelectionChange functions
SheetSelectionChange functions can all be applied when switching the cell currently selected every time.
3.1)、ActiveSheet.OLEObjects.Add ClassType:=" Forms.ListBox.1 "
When using SheetSelectionChange functions every time, need to judge whether current Sheet there are ListBox controls
Part is then skipped without adding one automatically if having.
3.2) InsertLines functions above, are equally used, to current ActiviteSheet addition ListBox controls
The function that part should be supported.
3.3), in the case of 3.1) with 3.2) all having existed, directly in response to the display of multiselect combobox.
4), the display of combobox
The flag data (being equivalent to above-mentioned character string) of the corresponding first trip of a cell and first is chosen, is judged current
Whether cell shows the value of combobox and combobox.
Fig. 4 is the unit in Sheet pages of display window in the Excel provided according to the preferred embodiment of the present invention
The schematic diagram of multiselect combobox is shown in lattice, as shown in figure 4, B3 cells are selected, is then compared whether identical containing B1 in A3
Multiselect label multiselect 1, have and show multiselect combobox.
The data that the subsequent data separated using " | " of multiselect 1 in corresponding A3 are shown as combobox.
5), ListBox1_Change () function
Switch combobox selection value when, respond ListBox1_Change () function.It is assigned to selected cell
Value.
Fig. 5 is that the value chosen in multiselect combobox in the B3 cells provided according to a preferred embodiment of the invention is switched to
2,3 be schematic diagram, and the value that combobox is chosen is become 2,3 by such as Fig. 5 from 1,2, the value of cell can also automatically become 2+3.
Following technique effect may be implemented by above preferred embodiment：Any one new Excel document needs to support
Multiselect drop-down list box can be supported with a key；First, improving service efficiency, no longer need to rewrite code；Second is that reducing
The threshold of user, without understanding any VBA programmings.
Specifically, Fig. 6 is showing for the method for the function of the addition multiselect combobox provided according to the preferred embodiment of the present invention
It is intended to, as shown in fig. 6, this method includes：Step S601, user click【Multiselect combobox is supported in addition】It (is equivalent to above-mentioned
Designated button) (being equivalent to above-mentioned steps S102), step S602, judging current file, whether added multiselect template is (suitable
In above-mentioned page template), in the case where the judgment result is yes, shows already existing multiselect template, be no in judging result
In the case of, add multiselect template；Step S603 judges that the whether existing support multiselect scripts of ThisWorkBook (are equivalent to above-mentioned
Executable file for supporting multiselect drop down box function or above-mentioned script), in the case where the judgment result is yes, in execution
Multiselect script is stated, in the case where judging result is no, adds above-mentioned multiselect script.
Fig. 7 is the schematic diagram of the method using multiselect drop down box function provided according to the preferred embodiment of the present invention, such as Fig. 7
Shown, this method includes：Step S701, any one cell for clicking any one Sheet (are equivalent to above-mentioned reception second
Signal), step S702 judges whether there is ListBox1 controls, wherein step S703 is executed in a case of yes, in no feelings
Under condition, ListBox1 controls are added, execute step S703；Step S703, judges whether ActiviteSheet has multiselect foot
This, executes step S704 in a case of yes, executes step S705 in a case of no；Step S704 executes multiselect combobox
The display script (being equivalent to display multiselect combobox) of list；Step S706 chooses drop-down list box and (is equivalent to multiselect drop-down
Frame) value；Step S707 executes the script of the assignment in ActiviteSheet；Step S705 is added to ActiviteSheet
Script.
Fig. 8 is the process schematic of the button addition and Sheet pages of template of addition that are provided according to the preferred embodiment of the present invention,
As shown in Figure 8 comprising：Button (being equivalent to above-mentioned specified control) is tied to by step S801 in custom button
AddMultiSelect () function (is equivalent to above-mentioned specified function), will thus realize the installation of button；Step S802,
AddTemplate () function, sheet pages of the template of one specified format of addition is called (to be equivalent to above-mentioned multiselect template or template
Page)；Step S803 calls AddSheetCode () function, is that Sheet page of the template of above-mentioned addition adds script, and then can be with
Realize that Sheet pages of the template has the function of clicking cell triggering multiselect.
Fig. 9 is the schematic diagram of the process of the button of the use addition provided according to the preferred embodiment of the present invention, such as Fig. 9 institutes
Show, after the button of the addition is clicked, executes following steps：Step S901, finding Sheet pages of template (can add multiple
The class template)；Step S902 clicks any Sheet pages any one cell (being equivalent to above-mentioned designated position), then can touch
Send out multiselect function；Step S903 judges that current Sheet pages (is equivalent to above-mentioned for supporting multiselect to pull down either with or without multiselect script
The executable file of frame function or above-mentioned script), in the case where judging result is no multiselect script, in current Sheet
The script of multiselect is supported in page addition；Where it has, executing step S904；Step S904 judges whether to need to pop up multiselect
Combobox does not show multiselect combobox, in the case where the judgment result is yes, executes step in the case where judging result is no
Rapid S905；Step S905, the first cell content be expert at according to cell (are equivalent to and are expert in the designated position
Content in first cell), dynamic load goes out the options (being equivalent to option value) of multiselect combobox；Step S906, root
According to the history value of current cell, it is shown as corresponding value in combobox to choose state；Step S907, switches combobox
Value, dynamically writes values into cell.
It should be noted that before step S905, the above method further includes：ListBox1 controls are judged whether there is,
In, in a case of no, add ListBox1 controls.
According to embodiments of the present invention, a kind of storage medium is additionally provided, computer program is stored in storage medium,
In, computer program is arranged to the step of executing the method in above-mentioned embodiment illustrated in fig. 1 when operation.
According to embodiments of the present invention, a kind of electronic device, including memory and processor are additionally provided, is stored in memory
There are computer program, processor to be arranged to run computer program to execute the step of the method in above-mentioned embodiment illustrated in fig. 1
Suddenly.
The embodiments of the present invention are for illustration only, can not represent the quality of embodiment.
In the above embodiment of the present invention, all emphasizes particularly on different fields to the description of each embodiment, do not have in some embodiment
The part of detailed description may refer to the associated description of other embodiment.
In several embodiments provided herein, it should be understood that disclosed technology contents can pass through others
Mode is realized.Wherein, the apparatus embodiments described above are merely exemplary, for example, unit division, can be one kind
Division of logic function, formula that in actual implementation, there may be another division manner, such as multiple units or component can combine or can
To be integrated into another system, or some features can be ignored or not executed.Another point, shown or discussed is mutual
Coupling, direct-coupling or communication connection can be by some interfaces, the INDIRECT COUPLING or communication connection of unit or module,
Can be electrical or other forms.
The unit illustrated as separating component may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, you can be located at a place, or may be distributed over multiple
On unit.Some or all of unit therein can be selected according to the actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can also
It is that each unit physically exists alone, it can also be during two or more units be integrated in one unit.Above-mentioned integrated list
The form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.
If the integrated unit is realized in the form of SFU software functional unit and sells or use as independent product
When, it can be stored in a computer read/write memory medium.Based on this understanding, technical scheme of the present invention is substantially
The all or part of the part that contributes to existing technology or the technical solution can be in the form of software products in other words
It embodies, which is stored in a storage medium, including some instructions are used so that a computer
Equipment (can be personal computer, server or network equipment etc.) execute each embodiment the method for the present invention whole or
Part steps.And storage medium above-mentioned includes：USB flash disk, read-only memory (ROM, Read-Only Memory), arbitrary access are deposited
Reservoir (RAM, Random Access Memory), mobile hard disk, magnetic disc or CD etc. are various can to store program code
Medium.
The above is only a preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also answered
It is considered as protection scope of the present invention.
Claims (11)
1. a kind of adding method of document function, which is characterized in that including：
Receive the first signal, wherein first signal is that the first specified control for acting on document generates, the finger
It is for triggering the control for supporting multiselect drop down box function to determine control；
Add the executable file for supporting multiselect drop down box function.
2. according to the method described in claim 1, it is characterized in that, supporting the executable file of multiselect drop down box function in addition
Later, the method further includes：
Receive second signal, wherein the second signal is the designated position of the second current page for acting on the document
It generates；
The executable file is run for the designated position of the current page.
3. according to the method described in claim 2, it is characterized in that, can be held described in the designated position operation for the current page
It composes a piece of writing during part, the method further includes：Multiselect combobox is shown in the specified location；Wherein, under the multiselect
It draws in frame and is loaded with one or more option values.
4. according to the method described in claim 3, it is characterized in that, the specified location show multiselect combobox it
Before, the method further includes：
Determine that the current page whether there is the first control；In case of absence, it is that the current page adds described first
Control.
5. according to the method described in claim 3, it is characterized in that, the specified location show multiselect combobox before,
The method further includes：
Determine the content in the first cell of the designated position column is expert at the designated position first
Content in a cell whether there is identical character string；Wherein, determining there are in the case of the identical character string,
The multiselect combobox is shown in the specified location.
6. according to the method described in claim 3, it is characterized in that, the specified location show multiselect combobox after,
The method further includes：
Monitor whether the one or more of option values marked in the multiselect combobox change；
In the case where changing, the display content of the specified location is updated according to changed option value.
7. according to the method described in claim 3, it is characterized in that, the method further includes：
It monitors content in the first cell of the designated position column and/or the designated position is expert at the
Whether the content in one cell is changed；
In the case where variation has occurred, at least one of is updated：In the first cell of the designated position column
Content, the content in the first cell that the designated position is expert at, the dispaly state of the multiselect combobox is described
The one or more option values loaded in multiselect combobox.
8. a kind of terminal, for providing human-computer interaction interface, which is characterized in that the human-computer interaction interface includes specified control
Part, wherein the specified control is for triggering the control for supporting multiselect drop down box function.
9. a kind of adding set of document function, which is characterized in that including：
Receiving module, for receiving the first signal, wherein first signal is the first specified control for acting on document
It generates, the specified control is for triggering the control for supporting multiselect drop down box function；
Processing module, for adding the executable file for supporting multiselect drop down box function.
10. a kind of storage medium, which is characterized in that be stored with computer program in the storage medium, wherein the computer
Program is arranged to execute the method described in any one of claim 1 to 7 when operation.
11. a kind of electronic device, including memory and processor, which is characterized in that be stored with computer journey in the memory
Sequence, the processor are arranged to run the computer program to execute the side described in any one of claim 1 to 7
Method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711427632.6A CN108287713A (en) | 2017-12-22 | 2017-12-22 | Adding method and device, terminal, storage medium, the electronic device of document function |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711427632.6A CN108287713A (en) | 2017-12-22 | 2017-12-22 | Adding method and device, terminal, storage medium, the electronic device of document function |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108287713A true CN108287713A (en) | 2018-07-17 |
Family
ID=62832269
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711427632.6A Pending CN108287713A (en) | 2017-12-22 | 2017-12-22 | Adding method and device, terminal, storage medium, the electronic device of document function |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108287713A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112905090A (en) * | 2021-02-08 | 2021-06-04 | 北京字跳网络技术有限公司 | Spreadsheet processing method, device, terminal and storage medium |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6208340B1 (en) * | 1998-05-26 | 2001-03-27 | International Business Machines Corporation | Graphical user interface including a drop-down widget that permits a plurality of choices to be selected in response to a single selection of the drop-down widget |
| CN101187864A (en) * | 2007-11-21 | 2008-05-28 | 浪潮集团山东通用软件有限公司 | Method for exhibiting abstraction and integration for interface |
| CN102270137A (en) * | 2011-08-10 | 2011-12-07 | 清华大学 | Method for acquiring ADL (architecture description language) and modeling tool |
| CN102902516A (en) * | 2011-07-30 | 2013-01-30 | 佳都新太科技股份有限公司 | Control inversion based pop-up frame design for call center |
| CN104391693A (en) * | 2014-11-12 | 2015-03-04 | 国云科技股份有限公司 | Method for achieving multiple-choice of drop-down list box |
| CN105095348A (en) * | 2015-06-09 | 2015-11-25 | 北京织星科技有限公司 | Method for dynamically configuring website through XML (Extensive Markup Language) |
| CN105549831A (en) * | 2015-12-11 | 2016-05-04 | 浪潮电子信息产业股份有限公司 | Method for achieving checking of unit frame pull-down option |
| CN105701183A (en) * | 2016-01-07 | 2016-06-22 | 无锡天脉聚源传媒科技有限公司 | User personalized template implementation method and apparatus |
| CN105701072A (en) * | 2015-06-09 | 2016-06-22 | 深圳Tcl数字技术有限公司 | Method and device for filtering test contents of multiple projects based on excel form |
| CN106484393A (en) * | 2016-09-13 | 2017-03-08 | 厦门兆慧网络科技有限公司 | A kind of visualization view method for designing |
| CN106648568A (en) * | 2015-10-30 | 2017-05-10 | 北京国双科技有限公司 | Method and device for adding check box into table |
| CN107329745A (en) * | 2017-06-16 | 2017-11-07 | 贵州广思信息网络有限公司 | A kind of method of enhancing WORD document operability |
-
2017
- 2017-12-22 CN CN201711427632.6A patent/CN108287713A/en active Pending
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6208340B1 (en) * | 1998-05-26 | 2001-03-27 | International Business Machines Corporation | Graphical user interface including a drop-down widget that permits a plurality of choices to be selected in response to a single selection of the drop-down widget |
| CN101187864A (en) * | 2007-11-21 | 2008-05-28 | 浪潮集团山东通用软件有限公司 | Method for exhibiting abstraction and integration for interface |
| CN102902516A (en) * | 2011-07-30 | 2013-01-30 | 佳都新太科技股份有限公司 | Control inversion based pop-up frame design for call center |
| CN102270137A (en) * | 2011-08-10 | 2011-12-07 | 清华大学 | Method for acquiring ADL (architecture description language) and modeling tool |
| CN104391693A (en) * | 2014-11-12 | 2015-03-04 | 国云科技股份有限公司 | Method for achieving multiple-choice of drop-down list box |
| CN105095348A (en) * | 2015-06-09 | 2015-11-25 | 北京织星科技有限公司 | Method for dynamically configuring website through XML (Extensive Markup Language) |
| CN105701072A (en) * | 2015-06-09 | 2016-06-22 | 深圳Tcl数字技术有限公司 | Method and device for filtering test contents of multiple projects based on excel form |
| CN106648568A (en) * | 2015-10-30 | 2017-05-10 | 北京国双科技有限公司 | Method and device for adding check box into table |
| CN105549831A (en) * | 2015-12-11 | 2016-05-04 | 浪潮电子信息产业股份有限公司 | Method for achieving checking of unit frame pull-down option |
| CN105701183A (en) * | 2016-01-07 | 2016-06-22 | 无锡天脉聚源传媒科技有限公司 | User personalized template implementation method and apparatus |
| CN106484393A (en) * | 2016-09-13 | 2017-03-08 | 厦门兆慧网络科技有限公司 | A kind of visualization view method for designing |
| CN107329745A (en) * | 2017-06-16 | 2017-11-07 | 贵州广思信息网络有限公司 | A kind of method of enhancing WORD document operability |
Non-Patent Citations (2)
| Title |
|---|
| 我是来讨说法的: "excel下拉框如何设置多个多选？", 《HTTP://CLUB.EXCELHOME.NET/THREAD-1263598-1-1.HTML》 * |
| 杨小丽编著: "《Excel应用大全 全新升级版》", 31 January 2016 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112905090A (en) * | 2021-02-08 | 2021-06-04 | 北京字跳网络技术有限公司 | Spreadsheet processing method, device, terminal and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106484224B (en) | A kind of operating method and terminal | |
| JP7013466B2 (en) | Application data processing methods, equipment, and computer programs | |
| CN106339226B (en) | A kind of methods of exhibiting and page presentation device of Webpage | |
| CN104579934B (en) | A kind of information processing method and client | |
| CN105549820B (en) | A kind of method and terminal showing graphic user interface | |
| CN107608652A (en) | A kind of method and apparatus of Voice command graphical interfaces | |
| CN105094551A (en) | Information processing method and electronic equipment | |
| CN108595445A (en) | Interpretation method, device and terminal | |
| CN103379212B (en) | Method for rapidly replying message and mobile terminal | |
| CN109388506B (en) | Data processing method and electronic equipment | |
| CN104898922A (en) | Icon arranging method and terminal | |
| CN105335224A (en) | Application switching method and apparatus | |
| CN107608585A (en) | The operating method and equipment and mobile terminal of a kind of application program | |
| CN106325687A (en) | Method for calling program and terminal | |
| CN113282424B (en) | Information reference method and device and electronic equipment | |
| CN107765966A (en) | Event triggering method, device, intelligent terminal and storage medium based on picture | |
| CN105094736A (en) | Display control method and device and electronic device | |
| CN110187952A (en) | Store method, apparatus, terminal and the storage medium of content | |
| CN110286991A (en) | A kind of information processing method and device | |
| CN105446625A (en) | Picture pasting method and apparatus based on browser | |
| CN106886364A (en) | A kind of text handling method and terminal based on speech recognition | |
| CN108287713A (en) | Adding method and device, terminal, storage medium, the electronic device of document function | |
| CN106445283A (en) | Emoticon acquisition method and terminal | |
| CN110347327B (en) | Item editing method and touch terminal | |
| CN106716980A (en) | Method for displaying view and terminal 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 | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20180717 |