gpsuser/c-xll-tools

problem when using gui to insert function into cell or range (rather type function directly into cell/range)

Opened this issue · 0 comments

What steps will reproduce the problem?

1. select a cell or range of cells
2. open the function gui
3. try insert a function into the current cell/range 

What is the expected output? What do you see instead?
Expected output is to see the result of the function call in the selected 
cell/range

Instead, Excel may crash. This seems to be a function gui bug.

Solution

Type the function into the required cell/range directly, followed by 
ctrl-shift-enter. For example: =functionName(Range, parameters)

Tip: When typing the function name into the cell/range, use the tab button to 
auto-complete the function name.

Original issue reported on code.google.com by grantpsh...@gmail.com on 24 Apr 2013 at 12:44