CN108268193B - Method and device for displaying prompt information corresponding to functions in spreadsheet - Google Patents
Method and device for displaying prompt information corresponding to functions in spreadsheet Download PDFInfo
- Publication number
- CN108268193B CN108268193B CN201710004203.1A CN201710004203A CN108268193B CN 108268193 B CN108268193 B CN 108268193B CN 201710004203 A CN201710004203 A CN 201710004203A CN 108268193 B CN108268193 B CN 108268193B
- Authority
- CN
- China
- Prior art keywords
- function
- prompt information
- function parameter
- determining
- information set
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
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
- 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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Abstract
The embodiment of the invention provides a method and a device for displaying prompt information corresponding to functions in an electronic form, wherein the method comprises the following steps: acquiring a function input in an electronic form; the function comprises at least two function parameters with nesting relation; acquiring a first function parameter in the function parameters as a current function parameter; determining a prompt information set corresponding to the current function parameter according to a preset function configuration file; displaying the prompt information set; determining prompt information selected by a user as a current function parameter according to the nesting relation; and returning to the step of determining the prompt information set corresponding to the current function parameter according to the preset function configuration file until the prompt information sets corresponding to all the function parameters are displayed. Prompt information can be dynamically displayed, the range of each selection of a user is narrowed, and user experience is improved.
Description
Technical Field
The invention relates to the technical field of electronic form parameter prompt, in particular to a method and a device for displaying prompt information corresponding to functions in an electronic form.
Background
The electronic form can input, output and display data, can help a user to make various complex form documents, performs complicated data calculation, can display the input data as a form with excellent visibility after various complex statistical operations, and can vividly change a large amount of boring and tasteless data into various beautiful colored business charts to display, thereby greatly enhancing the visibility of the data.
The existing electronic form can provide functions with different functions, and preset prompt information corresponding to function parameters, when a user inputs the functions in the electronic form, the electronic form can display the prompt information corresponding to the parameters of the functions, if the functions have a plurality of parameters, after the user inputs the functions and the parameters, the electronic form can display all the prompt information corresponding to all the parameters of the functions for the user to select. For example: assuming that the function for acquiring the weather of a certain area is weather, when the user inputs "═ weather (" when, all provinces and all cities under each province are displayed as prompt information for the user to select.
Therefore, in the prior art, when the number of the function parameters is large and the number of the prompt messages is large, a user needs to spend more time to select from a large number of prompt messages, and the user experience is not good.
Disclosure of Invention
The embodiment of the invention aims to provide a method and a device for displaying prompt information corresponding to functions in an electronic form, which are used for dynamically displaying the prompt information, reducing the range of each selection of a user and improving the user experience. The specific technical scheme is as follows:
a method for displaying prompt information corresponding to functions in a spreadsheet comprises the following steps:
acquiring a function input in an electronic form; the function comprises at least two function parameters with nesting relation;
acquiring a first function parameter in the function parameters as a current function parameter;
determining a prompt information set corresponding to the current function parameter according to a preset function configuration file;
displaying the prompt information set;
determining prompt information selected by a user as a current function parameter according to the nesting relation;
and returning to the step of determining the prompt information set corresponding to the current function parameter according to the preset function configuration file until the prompt information sets corresponding to all the function parameters are displayed.
The method as described above, wherein the preset function configuration file stores in advance a corresponding relationship between the function parameter and the prompt information;
the step of determining the prompt information set corresponding to the function parameter according to a preset function configuration file includes:
and determining the prompt information set corresponding to the function parameter according to the corresponding relation between the function parameter and the prompt information.
The method as described above, wherein the preset function configuration file stores in advance a corresponding relationship between the function parameter and the network request;
the step of determining the prompt information set corresponding to the function parameter according to a preset function configuration file includes:
determining a network request corresponding to the function parameter according to the corresponding relation between the function parameter and the network request;
and determining at least one prompt message acquired from a server side according to the network request as the prompt message set.
The method as described above, wherein the step of displaying the prompt information set includes:
and displaying the prompt information set in a list form.
A device for displaying prompt information corresponding to functions in a spreadsheet, comprising:
the acquisition module is used for acquiring functions input in the electronic forms; the function comprises at least two function parameters with nesting relation; acquiring a first function parameter in the function parameters as a current function parameter;
the first determining module is used for determining a prompt information set corresponding to the current function parameter according to a preset function configuration file;
the display module is used for displaying the prompt information set;
the second determining module is used for determining prompt information selected by a user as a current function parameter according to the nesting relation;
and the triggering module is used for triggering the first determining module until the prompt information sets corresponding to all the function parameters are displayed completely.
The device as described above, wherein the preset function configuration file stores in advance a corresponding relationship between the function parameter and the prompt information;
the first determining module is specifically configured to: and determining the prompt information set corresponding to the function parameter according to the corresponding relation between the function parameter and the prompt information.
The apparatus as described above, wherein the preset function configuration file stores in advance a corresponding relationship between the function parameter and the network request;
the first determining module is specifically configured to: determining a network request corresponding to the function parameter according to the corresponding relation between the function parameter and the network request; and determining at least one prompt message acquired from a server side according to the network request as the prompt message set.
The apparatus as described above, wherein the display module is specifically configured to: and displaying the prompt information set in a list form.
The method and the device for displaying the prompt information corresponding to the function in the electronic form, provided by the embodiment of the invention, comprise the following steps: acquiring a function input in an electronic form; the function comprises at least two function parameters with nesting relation; acquiring a first function parameter in the function parameters as a current function parameter; determining a prompt information set corresponding to the current function parameter according to a preset function configuration file; displaying the prompt information set; determining prompt information selected by a user as a current function parameter according to the nesting relation; and returning to the step of determining the prompt information set corresponding to the current function parameter according to the preset function configuration file until the prompt information sets corresponding to all the function parameters are displayed. Therefore, prompt information can be dynamically displayed according to selection of the user, the range of each selection of the user is narrowed, and user experience is improved. Of course, it is not necessary for any product or method of practicing the invention to achieve all of the above-described advantages at the same time.
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, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of a method for displaying prompt information corresponding to a function in an electronic form according to an embodiment of the present invention;
fig. 2 is a schematic structural diagram of a display device for displaying prompt information corresponding to a function in an electronic form 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.
Fig. 1 is a flowchart of a method for displaying prompt information corresponding to a function in an electronic form according to an embodiment of the present invention. As shown in fig. 1, the method provided by this embodiment may include:
For example, when weather of a certain region is obtained, the function parameters having the nesting relationship may be: provinces and cities corresponding to the provinces; the telephone number of a certain employee in a certain company is obtained, and the function parameters with the nesting relation can be: company, a certain department of the company, the names of employees in a certain department, etc.
And 102, acquiring a first function parameter in the function parameters as a current function parameter.
And 103, determining a prompt information set corresponding to the current function parameter according to a preset function configuration file.
In a feasible implementation manner, the preset function configuration file may store a corresponding relationship between the function parameter and the prompt information in advance; in this step, the prompt information set corresponding to the function parameter may be specifically determined according to the corresponding relationship between the function parameter and the prompt information. For example, the corresponding relation of provinces and cities is written in a preset function configuration file, when a user selects a certain province, all cities of the province are obtained by analyzing the configuration file and displayed to the user in a list form.
In another possible implementation, the relationship of the parameters to the parameters may be written as a network request. The preset function configuration file can store the corresponding relation between the function parameters and the network request in advance; in this step, according to the corresponding relationship between the function parameter and the network request, determining the network request corresponding to the function parameter; and determining at least one prompt message acquired from a server side according to the network request as the prompt message set.
And 104, displaying the prompt information set.
In practical applications, the prompt information set may be displayed in a list form, and the display form of the prompt information set in this embodiment is not particularly limited.
And 105, determining prompt information selected by a user as a current function parameter according to the nesting relation.
And 106, returning to the step of determining the prompt information set corresponding to the current function parameter according to the preset function configuration file until the prompt information sets corresponding to all the function parameters are displayed.
The above-described flow is described below by way of example.
Suppose that there is a function weather for acquiring the weather of a certain area, and the function includes at least two nested function parameters of province and city. Assuming that a user wants to use the function to obtain the weather of the Zhuhai city in Guangdong province, the user inputs the function as weather in the spreadsheet (when the function input in the spreadsheet is obtained, the first function parameter 'province' is obtained as the current function parameter, the corresponding prompt information is obtained and collected as all provinces according to the preset function configuration file, all provinces are displayed, after the user selects the Guangdong province, the 'Guangdong province' selected by the user is determined as the current function parameter according to the nesting relation, then the list of all cities in the Guangdong province is obtained according to the preset function configuration file and displayed for the user to select, and after the user selects the Guangdong province, the weather of the Zhuhai city in Guangdong province is displayed.
It is assumed that a telephone number of an employee in a certain department of a certain company is to be obtained, the function is a telephone number (name), at least two function parameters having a nested relationship included in the function are the department name and the employee name, and a preset function configuration file may store a corresponding relationship between the function parameters and the network request in advance. When a user inputs a function phonenumber in an electronic form (after acquiring a first function parameter 'department' as a current function parameter, determining a network situation corresponding to the 'department' according to a preset function configuration file, determining at least one prompt message acquired from a server terminal according to the network request, namely all departments as a prompt message set, displaying all the departments, determining the department selected by the user as the current function parameter, determining a network request corresponding to the department selected by the user, wherein the network request is to request a network by taking the department as the current function parameter, acquiring all employee names of the department from the server terminal, then displaying the employee names in a list form for the user to select, and displaying a telephone number corresponding to the employee names after the user selects the employee names.
It can be seen that, in the technical solution of this embodiment, the function input in the electronic form is obtained; the function comprises at least two function parameters with nesting relation; acquiring a first function parameter in the function parameters as a current function parameter; determining a prompt information set corresponding to the current function parameter according to a preset function configuration file; displaying the prompt information set; determining prompt information selected by a user as a current function parameter according to the nesting relation; and returning to the step of determining the prompt information set corresponding to the current function parameter according to the preset function configuration file until the prompt information sets corresponding to all the function parameters are displayed. The prompt information can be dynamically displayed according to the selection of the user, the range of each selection of the user is narrowed, and the user experience is improved.
Fig. 2 is a schematic structural diagram of a display device for displaying prompt information corresponding to a function in an electronic form according to an embodiment of the present invention. As shown in fig. 2, this embodiment may include an obtaining module 21, a first determining module 22, a displaying module 23, a second determining module 24, and a triggering module 25.
The acquiring module 21 is configured to acquire a function input in the spreadsheet; the function comprises at least two function parameters with nesting relation; acquiring a first function parameter in the function parameters as a current function parameter;
a first determining module 22, configured to determine, according to a preset function configuration file, a prompt information set corresponding to the current function parameter;
the display module 23 is configured to display the prompt information set;
the second determining module 24 is configured to determine, according to the nesting relationship, prompt information selected by a user as a current function parameter;
and the triggering module 25 is configured to trigger the first determining module 22 until the prompt information sets corresponding to all the function parameters are completely displayed.
In a possible implementation manner, the preset function configuration file may store a corresponding relationship between the function parameter and the prompt information in advance; the first determining module 22 is specifically configured to: and determining the prompt information set corresponding to the function parameter according to the corresponding relation between the function parameter and the prompt information.
In another possible implementation manner, the preset function configuration file may store a corresponding relationship between the function parameter and the network request in advance; the first determining module 22 is specifically configured to: determining a network request corresponding to the function parameter according to the corresponding relation between the function parameter and the network request; and determining at least one prompt message acquired from a server side according to the network request as the prompt message set.
The display module 23 is specifically configured to: and displaying the prompt information set in a list form.
The display device for the prompt information corresponding to the function in the electronic form provided by this embodiment may be used to implement the technical solutions of the above method embodiments, and the implementation principles and technical effects are similar, and are not described herein again.
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, for the system embodiment, since it is substantially similar to the method embodiment, the description is 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 (8)
1. A method for displaying prompt information corresponding to functions in an electronic form is characterized by comprising the following steps:
acquiring a function input in an electronic form; the function comprises at least two function parameters with nesting relation;
acquiring a first function parameter in the function parameters as a current function parameter;
determining a prompt information set corresponding to the current function parameter according to a preset function configuration file, wherein the prompt information set is a set of selectable items corresponding to the current function parameter;
displaying the prompt information set;
determining prompt information selected by a user as a current function parameter according to the nesting relation;
and returning to the step of determining the prompt information set corresponding to the current function parameter according to the preset function configuration file until the prompt information sets corresponding to all the function parameters are displayed.
2. The method according to claim 1, wherein the preset function configuration file stores in advance a corresponding relationship between the function parameter and the prompt message;
the step of determining the prompt information set corresponding to the function parameter according to a preset function configuration file includes:
and determining the prompt information set corresponding to the function parameter according to the corresponding relation between the function parameter and the prompt information.
3. The method according to claim 1, wherein the preset function configuration file stores in advance a corresponding relationship between the function parameter and the network request;
the step of determining the prompt information set corresponding to the function parameter according to a preset function configuration file includes:
determining a network request corresponding to the function parameter according to the corresponding relation between the function parameter and the network request;
and determining at least one prompt message acquired from a server side according to the network request as the prompt message set.
4. The method of claim 1, wherein the step of displaying the set of toasts comprises:
and displaying the prompt information set in a list form.
5. A device for displaying prompt information corresponding to functions in a spreadsheet, comprising:
the acquisition module is used for acquiring functions input in the electronic forms; the function comprises at least two function parameters with nesting relation; acquiring a first function parameter in the function parameters as a current function parameter;
a first determining module, configured to determine, according to a preset function configuration file, a prompt information set corresponding to the current function parameter, where the prompt information set is a set of selectable items corresponding to the current function parameter;
the display module is used for displaying the prompt information set;
the second determining module is used for determining prompt information selected by a user as a current function parameter according to the nesting relation;
and the triggering module is used for triggering the first determining module until the prompt information sets corresponding to all the function parameters are displayed completely.
6. The apparatus according to claim 5, wherein the preset function configuration file stores in advance a corresponding relationship between the function parameter and the prompt message;
the first determining module is specifically configured to: and determining the prompt information set corresponding to the function parameter according to the corresponding relation between the function parameter and the prompt information.
7. The apparatus according to claim 5, wherein the preset function configuration file stores in advance a corresponding relationship between the function parameter and the network request;
the first determining module is specifically configured to: determining a network request corresponding to the function parameter according to the corresponding relation between the function parameter and the network request; and determining at least one prompt message acquired from a server side according to the network request as the prompt message set.
8. The apparatus of claim 5, wherein the display module is specifically configured to: and displaying the prompt information set in a list form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710004203.1A CN108268193B (en) | 2017-01-04 | 2017-01-04 | Method and device for displaying prompt information corresponding to functions in spreadsheet |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710004203.1A CN108268193B (en) | 2017-01-04 | 2017-01-04 | Method and device for displaying prompt information corresponding to functions in spreadsheet |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108268193A CN108268193A (en) | 2018-07-10 |
| CN108268193B true CN108268193B (en) | 2021-03-02 |
Family
ID=62771663
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710004203.1A Active CN108268193B (en) | 2017-01-04 | 2017-01-04 | Method and device for displaying prompt information corresponding to functions in spreadsheet |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108268193B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101404041A (en) * | 2008-09-24 | 2009-04-08 | 上海纳杰电气成套有限公司 | System diagram generation system |
| CN103440391A (en) * | 2013-09-16 | 2013-12-11 | 卓捷创芯科技（深圳）有限公司 | Semiconductor process corner scanning and simulating method based on numerical value selection function |
| CN105045775A (en) * | 2015-08-12 | 2015-11-11 | 深圳联友科技有限公司 | Method and apparatus for generating Excel document in designated format |
| CN105550164A (en) * | 2015-12-09 | 2016-05-04 | 北京奇虎科技有限公司 | Chart generation method and device |
| CN105556507A (en) * | 2013-09-18 | 2016-05-04 | 伊麦格莱肯有限责任公司 | Method and system for statistical modeling of data using a quadratic likelihood functional |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101493830A (en) * | 2004-04-29 | 2009-07-29 | Nec软件有限公司 | Structured natural language query and knowledge system |
| US7451397B2 (en) * | 2004-12-15 | 2008-11-11 | Microsoft Corporation | System and method for automatically completing spreadsheet formulas |
| CN101425007B (en) * | 2007-10-29 | 2012-09-05 | 珠海金山软件有限公司 | Method capable of structuredly displaying electronic table function cue |
| US20110066933A1 (en) * | 2009-09-02 | 2011-03-17 | Ludwig Lester F | Value-driven visualization primitives for spreadsheets, tabular data, and advanced spreadsheet visualization |
| US9594735B2 (en) * | 2011-09-12 | 2017-03-14 | Microsoft Technology Licensing, Llc | Automatic highlighting of formula parameters for limited display devices |
| CN103336762B (en) * | 2013-07-12 | 2016-06-08 | 珠海金山办公软件有限公司 | A kind of method and terminal pointing out relative ranks value in electrical form |
| US9619581B2 (en) * | 2013-12-20 | 2017-04-11 | Microsoft Technology Licensing, Llc | Constructing queries for execution over multi-dimensional data structures |
| US11188308B2 (en) * | 2014-07-23 | 2021-11-30 | Apple Inc. | Interactive code editing |
-
2017
- 2017-01-04 CN CN201710004203.1A patent/CN108268193B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101404041A (en) * | 2008-09-24 | 2009-04-08 | 上海纳杰电气成套有限公司 | System diagram generation system |
| CN103440391A (en) * | 2013-09-16 | 2013-12-11 | 卓捷创芯科技（深圳）有限公司 | Semiconductor process corner scanning and simulating method based on numerical value selection function |
| CN105556507A (en) * | 2013-09-18 | 2016-05-04 | 伊麦格莱肯有限责任公司 | Method and system for statistical modeling of data using a quadratic likelihood functional |
| CN105045775A (en) * | 2015-08-12 | 2015-11-11 | 深圳联友科技有限公司 | Method and apparatus for generating Excel document in designated format |
| CN105550164A (en) * | 2015-12-09 | 2016-05-04 | 北京奇虎科技有限公司 | Chart generation method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108268193A (en) | 2018-07-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106100969A (en) | A kind of do not read the based reminding method of session, device and terminal unit | |
| CN105488039A (en) | Query method and device | |
| CN105893564A (en) | Search method and device based on search engine client | |
| CN109978198B (en) | Meal waiting duration real-time estimation system based on big data and AI technology | |
| CN111339213A (en) | Knowledge graph-based visual display method, electronic equipment and medium | |
| US10992611B2 (en) | Topic classified presentation for a message in a message cluster | |
| CN111460279A (en) | Information recommendation method and device, storage medium and computer equipment | |
| WO2017067211A1 (en) | Map poi display method and terminal | |
| CN104915345B (en) | A kind of method and terminal of recommendation service information | |
| CN103412885A (en) | Contact person photo setting method and device | |
| CN106991110B (en) | Webpage switching method and device | |
| CN106789147B (en) | Flow analysis method and device | |
| CN105376140A (en) | A voice message prompt method and device | |
| CN108959439B (en) | Data template generation method and system | |
| CN105681252A (en) | Client-side data based processing method and device | |
| CN105827780B (en) | A kind of incoming display method and device | |
| CN108268193B (en) | Method and device for displaying prompt information corresponding to functions in spreadsheet | |
| CN105516939A (en) | Message pushing method and device and mobile terminal | |
| CN109033043A (en) | A kind of management through figures method, apparatus and terminal | |
| CN103927181A (en) | Weather data displaying method and device | |
| WO2013023252A1 (en) | A computer system to visualise data from an ip rights database | |
| CN103580984A (en) | Method and system for information aggregation based on interest points | |
| CN107729457B (en) | Method, device and storage medium for intelligent information retrieval | |
| CN105279035B (en) | Calendared tasks querying method and device | |
| CN113312196A (en) | Address synchronization method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |