Apparatus and method capable of structuredly displaying electronic table function cue

Abstract

The invention provides a device which can structurally display the prompt of an electronic function table and a method, which can cause a user to conveniently examine the structure of a nested function when inputting or editing the electronic function table, thereby helping the user know the function with complex structure, and improving the editing efficiency. The device which can structurally display the prompt of the electronic function table comprises an input device, a display device and a host computer which are connected mutually. The invention is characterized in that the device also comprises an edit module used for various operations for processing the data, a storage module used for storing data information received by the edit module and providing function name information of a function analytic module for matching with the function, a data detection module used for detecting the data information operated by the edit module, a function analytic module used for analyzing the structure of the function, and a display module used for displaying the prompt of the function.

Description

technical field [0001] The invention relates to the field of computer software, in particular to a device and method capable of structurally displaying electronic table function prompts. Background technique [0002] Functions are widely used in spreadsheet software, and they are an important form of data representation in spreadsheets. A function in a spreadsheet is actually a procedure for defining an operation (or a set of operations) and returning the corresponding result. A function consists of a function name and parameters. The function name is used to identify a specific calculation rule, and the parameters are used to specify the data used by the calculation rule. Take the summation function SUM as an example. In the function SUM(1, 2, 3), "SUM" is the function name, and the calculation rule it represents is summation. "1", "2", and "3" are three The parameter indicates the data used for the summation. The meaning of the whole function is to sum the three numbers ...

AI Technical Summary

Problems solved by technology

There is a problem with the function prompt in the existing spreadsheet software: when inputting or editing a function, only the prompt of the function closest to the cursor can be displayed, and for nested functions, it cannot display the structure of the nested function

like figure 1 As shown, when editing the function SUM(MAX(1, 2, 3), MIN(1, 2, 3)), only the prompt of a single function near the cursor (that is, the prompt of the function MIN) can be displayed

When the nested function is very complex, a single function prompt cannot meet the needs of the user, because the user needs to know the structure of the entire function (the structural relationship between the parent function and the child function) when editing the function for easy viewing and modification

[0004] For example, when the user edits the functions: SUM(A1, MAX(AVERAGE(A1:C1), MIN(A1:C1)), COUNT(A1:C1), PRODUCT(MAX(B1:C1), A1)), due to The text is too long, it is difficult to understand its structure, which is very inconvenient for viewing and modifying functions

Images