FormulaTextBox and multiple cell editing

Posted by: tuncbahcecioglu on 8 September 2017, 3:22 pm EST

  • Posted 8 September 2017, 3:22 pm EST


    Is is possible to use the FormulaTextBox to edit multiple cells of an fpSpread?
    Whenever I select the FormulaTextBox multiple selection in the fpSpread disappears.

  • Replied 8 September 2017, 3:22 pm EST


    You should be able to use ctrl + click to select cells for the formula. For selections that do not involve the formulas, do you have SelectionPolicy set? Or are you trying to put the same formula in multiple cells at one time?

  • Replied 8 September 2017, 3:22 pm EST

    Hi Gina,

    Thanks for the quick response.
    I am trying to put the same value, or formula to multiple cells at one time. Is this possible?

  • Marked as Answer

    Replied 8 September 2017, 3:23 pm EST


    No, FormulaTextBox does not support applying formulas to multiple selections.
    Excel does not support that either (in Excel, you can make multiple selections, set a formula in the formula bar, and the formula will only apply to the last selected cell, not to all the selected cells), so I think it's intended behavior.

Need extra support?

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

Learn More

Forum Channels