FormulaTextBox Drop Down and Custom Names

Posted by: fmessina on 8 September 2017, 2:22 pm EST

  • Posted 8 September 2017, 2:22 pm EST

    Hi,

    I was wondering if there is a way to incorporate the Custom Names setup in a spreadsheet into the formulatextbox dropdown along with the functions?  

    Also, is there a way built in to have the formula drop down work from a particular cell like it does from the formulatextbox control?

     

    Thank you,

     

    Frank 

  • Replied 8 September 2017, 2:22 pm EST

    Hello Frank,


    While using FormulaTextBox along with the Spread we are able to get the Spread's CustomNames in the FormuaTexBox automatically. Please have a look at the attached sample and let us know your further observations on the same.


    I have a ttached a screenshot of the same as well, wherin the three CustomNames i have made( test, test1, test2) are visible in FormulaTextBox.


    And for the second question, we are able to get the formula textbox in Spread's Cell but the dropdown facility is not available. However, we have added it as an enhacement request for future release,and the request Id is #999166658.


    Thanks.


    2010/06/FormulaTextBoxSample.zip
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels