Formula Suggestion

Posted by: departh on 8 September 2017, 2:49 pm EST

  • Posted 8 September 2017, 2:49 pm EST

    Hello Experts,

    I would like to know whether there is any features like formula autofilling, like MS Excel when we start writing formula over any cell, it will populate list of suggestion with attributes, is there any way we can set for fpSpread?

    Thanks and Regards

    Partha 

  • Replied 8 September 2017, 2:49 pm EST

    Hello,

    You can make use of the FormulaTextBox which is similar to the Formula bar in Excel. Once you have attached it to the Spread, any formula you type into it, is entered in the active cell. It also provides you suggestion for the formulas and the variables required by it. Moreover, if you wish to use a cell range in the sheet as values to a formula, you can select them using the mouse, in the similar way as you do in Excel. You can refer to the following link to know how exactly this FormulaTextBox works:

                                                                                      http://www.clubfarpoint.com/FarPointSupportSite/Modules/Docs/SpreadWin5Help/spwin-formulabar.html

    Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur.



Need extra support?

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

Learn More

Forum Channels