Change event not getting fired

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

  • Posted 8 September 2017, 1:09 pm EST


    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

  • 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


    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

    <font class="keyword">Private</font> <font class="keyword">Sub</font>
    FpSpread1_DataModelChanged(<font class="keyword">ByVal</font> sender <font class="keyword">As</font> <font class="keyword">Object</font>, <font class="keyword">ByVal</font> e <font class="keyword">As</font>
    <font class="keyword">End</font> <font class="keyword">Sub</font>
Need extra support?

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

Learn More

Forum Channels