Change event not getting fired

Posted by: vkempanna on 8 September 2017, 1:09 pm EST

  • Posted 8 September 2017, 1:09 pm EST

    Hi,


    I want  to check if any cell value is changed in the spread before saving the changes.


    I am subscribing for the change event ,but it is not getting fired.Is this the right event?


    I have atatched the application for your reference


    2008/04/WindowsApplication2-2.zip
  • Replied 8 September 2017, 1:09 pm EST

    Vinutha -

    Events like Change and EditChange only fire when the user is typing in the cell.  I would suggest using the Changed event for the data model which will fire whenever a change is made, whether directly by the user of via code.
  • Replied 8 September 2017, 1:09 pm EST

    Bob,


    I am populating the spread manually,how can i subcribe to the data model changed event.

  • Replied 8 September 2017, 1:09 pm EST

    Dim model as FarPoint.Win.Spread.Model.DefaultSheetDataModel
    model = FpSpread1.ActiveSheet.Models.Data


    Private Sub
    FpSpread1_DataModelChanged(ByVal sender As Object, ByVal e As
    FarPoint.Win.Spread.Model.SheetDataModelEventArgs)
    Handles
    model.Changed
        
    End Sub
Need extra support?

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

Learn More

Forum Channels