Method and apparatus for displaying function parameter in spreadsheet, and electronic device
Embodiments of a method and an apparatus for providing a prompt of a function parameter in a spreadsheet and of an electronic device are provided. The method includes: obtaining a first function parameter of a function in the spreadsheet; determining whether the first function parameter is associated with a dynamic constraint rule, wherein the dynamic constraint rule is that there is a dynamic constraint that associates the first function parameter with another function parameters in a function to which the first function parameter belongs; if the first function parameter is associated with a dynamic constraint rule, calculating a value range of the first function parameter based on the dynamic constraint rule; and presenting a prompt for the first function parameter based on the value range. By applying the embodiments provided in the present application, a user can input correct content for a parameter quickly and accurately. An inappropriate input for a parameter and thus erroneous calculation of the related formula are avoided.
1. A method for providing a prompt of a function parameter in a spreadsheet to a user, which is applied to an electronic device, comprising:
obtaining a first function parameter of a function in the spreadsheet by detecting an operation of the first function parameter of the function inputted by a user accessing the spreadsheet;
determining whether the first function parameter is associated with a dynamic constraint rule, wherein the dynamic constraint rule indicates a dynamic constraint between the first function parameter and a second function parameter of the function, wherein the first function parameter is associated with a first list of values in the spreadsheet and the second function parameter is associated with a second list of values in the spreadsheet;
in response to determining that the first function parameter is associated with the dynamic constraint rule, calculating a value range of the first function parameter based on the dynamic constraint rule, wherein calculating the value range of the first function parameter comprises:
obtaining a value range of the second function parameter of the function based on the second list of values, wherein the value range of the second function parameter is associated with the first function parameter through the dynamic constraint; and
calculating the value range of the first function parameter based on the dynamic constraint, the value range of the second function parameter, and the first list of values, wherein the dynamic constraint is a relationship between the value ranges of the first and second function parameters such that the value ranges of the first function parameter changes based on the value ranges of the second function parameter, and the dynamic constraint is determined by retrieving a dynamic constraint parameter list for the spreadsheet;
presenting a prompt for the user, wherein the prompt displays the value range of the first function parameter for selection by the user.
2. The method of claim 1 , wherein determining whether the first function parameter is associated with the dynamic constraint rule comprises:
retrieving a dynamic constraint parameter list for the spreadsheet, wherein the dynamic constraint parameter list is a set of elements comprising a function parameter, another function parameter associated with the function parameter through a dynamic constraint, and the dynamic constraint; and
determining whether the first function parameter is associated with the dynamic constraint rule from the dynamic constraint parameter list.
3. The method of claim 1 , wherein presenting the prompt of the first function parameter based on the value range comprises:
displaying the value range of the first function parameter in a drop-down list or in a prompting bubble.
4. The method of claim 1 , wherein obtaining the first function parameter of the function in the spreadsheet comprises:
detecting an input for the first function parameter in the spreadsheet.
5. An apparatus for providing a prompt of a function parameter in a spreadsheet to a user, comprising:
a detection module, configured for obtaining a first function parameter of a function in the spreadsheet by detecting an operation of the first function parameter of the function inputting by a user accessing the spreadsheet;
a determination module, configured for determining whether the first function parameter is associated with a dynamic constraint rule, wherein the dynamic constraint rule indicates a dynamic constraint between the first function parameter and a second function parameter of the function, wherein the first function parameter is associated with a first list of values in the spreadsheet and the second function parameter is associated with a second list of values in the spreadsheet;
a processing module, configured for, in response to determining that the first function parameter is associated with the dynamic constraint rule, calculating a value range of the first function parameter based on the dynamic constraint rule;
wherein the processing module comprises:
a value obtaining sub-module, configured for obtaining a value range of the second function parameter of the function based on the second list of values, wherein the value range of the second function parameter is associated with the first function parameter through the dynamic constraint; and
a calculation sub-module, configured for calculating the value range of the first function parameter based on the dynamic constraint, the value range of the second function parameter, and the first list of values, wherein the dynamic constraint is a relationship between the value ranges of the first and second function parameters such that the value ranges of the first function parameter changes based on the value ranges of the second function parameter, and the dynamic constraint is determined by retrieving a dynamic constraint parameter list for the spreadsheet;
a prompt module, configured for presenting a prompt for the user, wherein the prompt displays the value range of the first function parameter for selection by the user.
6. The device of claim 5 , wherein the determination module comprises:
a retrieving sub-module, configured for retrieving a dynamic constraint parameter list for the spreadsheet, wherein the dynamic constraint parameter list is a set of elements comprising a function parameter, another function parameter associated with the function parameter through a dynamic constraint, and the dynamic constraint; and
a determination sub-module, configured for determining whether the first function parameter is associated with the dynamic constraint rule from the dynamic constraint parameter list.
7. The apparatus of claim 5 , wherein the prompt module comprises:
a display sub-module, configured for displaying the value range of the first function parameter in a drop-down list or in a prompting bubble.
8. The apparatus of claim 5 , wherein the detection module comprises:
a detection sub-module, configured for detecting an input for the first function parameter in the spreadsheet.
9. An electronic device, comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other via the communication bus;
the memory is configured for storing a computer program; and
the processor is configured for carrying out steps of the method of claim 1 by executing the computer program stored on the memory.
10. A non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, causes the processor to carry out steps of the method of claim 1 .