How to force the formulas to update

Posted by: john-shugart on 8 September 2017, 2:26 pm EST

  • Posted 8 September 2017, 2:26 pm EST

    I have a spread app that has formulas that referance cells that are spinner buttons. How can I force the formulas to update when the spinner increments and update the display?


    thanks in advance,


    John

  • Replied 8 September 2017, 2:26 pm EST

    John,


    Spread works the same as Excel.  Formulas work with values that are in the cell, not with values that are in the cell editor.  While you are editing a cell (e.g. typing in cell, pressing spin button on cell), you are changing the the value in the cell editor (which is positioned over the cell during edit mode).  When you leave edit mode (e.g. press key or click on another cell), the cell editor value is written to the cell.  At that time, the formulas will update.


    There is no way to force the formula to update with the new edited value prior to leaving edit mode.


     

  • Replied 8 September 2017, 2:26 pm EST

    Bobbyyo,


    Thanks for the response and the explanation.


     

Need extra support?

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

Learn More

Forum Channels