How to force a cell to repaint

Posted by: john-shugart on 8 September 2017, 1:41 pm EST

  • Posted 8 September 2017, 1:41 pm EST

    I have a sheet and I am manually resetting some values, how can I force the cell to repaint after I set the new value before the EditModeOff event fires?


    Thanks in advance,


    John

  • Replied 8 September 2017, 1:41 pm EST

    John,


    If the Spread is in EditMode, then assigning values into the DaaModel of Spread will not display in the editor (even with a repaint). You would need to set the value into the Editor instead.

  • Replied 8 September 2017, 1:41 pm EST

    Can you tell me how to set the editor value? SheetView.Cells(1,2).????


     Thanks in advance,


     


    John

  • Replied 8 September 2017, 1:41 pm EST

    John,


    It sounded like you are still in editmode, so you would use code like the following on a GeneralCellType.


    CType(FpSpread1.EditingControl, FarPoint.Win.Spread.CellType.GeneralEditor).Value = ???

Need extra support?

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

Learn More

Forum Channels