Model.Data.Changed Events are not triggered for all affected cells in SP11

Model.Data.Changed Events are not triggered for all affected cells in SP11

Posted by: tohcy on 23 November 2018, 3:24 am EST

• 

  tohcy

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 November 2018, 3:24 am EST

  Hi,

  Please refer to case 267418
  
  The issues have been sent for quite some days and I only receive a system notice that the e-mail has been received with above tracking number.

  The codes I wrote in the example :

  Dim m_model As FarPoint.Win.Spread.Model.DefaultSheetDataModel
  
  m_model = FpSpread1.Sheets(0).Models.Data
  
  m_model.UnionedChangeCellRange = False
  
  FpSpread1.Sheets(0).Models.Data = m_model
  
  AddHandler FpSpread1.Sheets(0).Models.Data.Changed, AddressOf auto_modelchange

  Then I create a function to show the cells being processed as following :
  
  Private Sub auto_modelchange(sender As Object, e As FarPoint.Win.Spread.Model.SheetDataModelEventArgs)

      TextBox1.Text = TextBox1.Text + Chr(13) + Chr(10) + "Row : " + e.Row.ToString.Trim + " Col : " + e.Column.ToString.Trim
  

  End Sub

  The outcome is, only the single affected cell is reflected in the text box
  
  I am aware SP12 is going to be published and may this is a bug, wonder if it is possible to include in as I suppose this is quite a critical one.

  I have attached the sample VB.net project and the XML which I designed using latest spread for window V11.45

  Thanks
  
  Regards
  
  Raymond

  engine_order.zipSP11 ERROR.zip

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 26 November 2018, 7:04 am EST

  Hi Raymond,

  In your attached sample, when the cell is changed using dropdown, the values you mentioned are not changed automatically. However, if you hover over these cells then the values are changed.

  To force Spread to update these cells, you can use ShowDependents method in your auto_modelchange handler.

  Please refer to the attached sample for the same.

  Also, you can post your issues either here on the forums, or on SupportOne website (www.supportone.componentone.com)

  Regards,
  
  Jitender
  
  SP11 ERROR.zip

• 

  tohcy

  • Post Options:
  • Link
    Copy

  Posted 27 November 2018, 1:03 am EST - Updated 30 September 2022, 2:05 pm EST

  Hi, Jitender,

  I think I may not explained well in my previous message above.
  
  In the case 267418 which I sent by e-mail, I attached the screen-shot. May be I shall explain in more details about the problem here.

  As I mentioned in above message.
  
  …" The outcome is, only the single affected cell is reflected in the text box" …
  
  The affected cells are NOT ONLY Cell F4, but also cell H5, I expect H5 being triggered too, as all previous version of SP works in this way.

  The event however, only being fired for F4.
  
  That’s why the text box only return “Row 3, Col 5”
  
  I shall expect, the text box shows also ‘Row 4, Col 7’ if the library works correctly.

  Please find attached image may be better explain my meaning.

  Thanks

  

  1145×460 24 KB

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 27 November 2018, 10:37 am EST

  Hello,

  You can modify your code as follows to fix this issue:

  
  Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
          Dim m_model As FarPoint.Win.Spread.Model.DefaultSheetDataModel
  
          On Error Resume Next
          RemoveHandler FpSpread1.Sheets(0).Models.Data.Changed, AddressOf auto_modelchange
          FpSpread1.Reset()
  
          If FpSpread1.Open("C:\engine_order\engine_order.xml") = True Then
              m_model = FpSpread1.Sheets(0).Models.Data
              m_model.UnionedChangeCellRange = True
              AddHandler FpSpread1.Sheets(0).Models.Data.Changed, AddressOf auto_modelchange
  
              TextBox1.Text = "XML loaded successfully !"
          End If
  
      End Sub
      Private Sub auto_modelchange(sender As Object, e As FarPoint.Win.Spread.Model.SheetDataModelEventArgs)
          On Error Resume Next
          TextBox1.Text = TextBox1.Text + Chr(13) + Chr(10) + "Row : " + e.Row.ToString.Trim + " Col : " + e.Column.ToString.Trim + " Type : " + e.Type.ToString
  
      End Sub
  
  
  

  Thanks,
  
  Deepak Sharma

• 

  tohcy

  • Post Options:
  • Link
    Copy

  Posted 28 November 2018, 5:58 am EST - Updated 30 September 2022, 2:05 pm EST

  Dear Deepak Sharma,

  At the first glance it appears to work, but if I slightly modify the xml to add in more formula inside, it fails !!! Let me explain this :

  I am now putting in formula at C2 as in attached png. Now I run again the proposed change you made and the outcome fail to trigger all 3 cells

  If you remember in year 2014, May 27, I raised the same issue for SP7 ( please check the issue no 43329, Bug no 68108 ), the solution provided to me is setting UnionedChangeCellRange = FALSE. The officer supported this was yourself as in my record, and it resolved all issues of this.

  After that SP9, SP10 works perfectly with this, until it comes to SP11, issue appears again.
  
  Kindly take a closer look into this. You can write a few more formula around this cells, and you shall find not all cells are triggered.

  Thanks
  
  Regards
  
  Raymond

  

  1136×578 30.6 KB

• 

  tohcy

  • Post Options:
  • Link
    Copy

  Posted 28 November 2018, 11:21 pm EST

  Hi,

  While waiting for your reply, I try to access to SupportOne portal to open up new support ticket after I login from Grapecity web site, this portal ask me to login again.

  Then I perform below and all actions fail :
  
  a) I use Grapecity Login account - Fails
  
  b) I use my e-mail to reset my password, using the reset link from the e-mail received, after putting new password and press Confirm button, it says ‘e-mail is invalid’
  
  c) Then I try to create a new account, and it says e-mail already existed.

  Anything wrong ?
  
  Regards
  
  Raymond

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 29 November 2018, 7:38 am EST

  Hello Raymond,

  We are looking into your issue and we will get back to you after investigating it more.

  Further, please try using the same account to login into S1 as used to login into our website.

  Else you may try clearing the browser cache and try to login again. Please see if it works.

  Thanks,
  
  Reeva

• 

  tohcy

  • Post Options:
  • Link
    Copy

  Posted 29 November 2018, 10:53 am EST

  Hi Reeva,

  It does not help unfortunately.
  
  I tested on Chrome as well Micosoft Edge after clearing the browser historical data.

  a) First, I login to Grapecity and it is successful

  b) Then I go to the support page and press the ‘Open New Ticket’ button. This directed me to SupportOne portal and after a little while staying on the blank page with progress bar, a login page appeared with e-mail and password for me to type in

  c) Type in my e-mail and password exactly the account I login to Grapecity web site.

  d) Error, user name or password invalid.

  Regards
  
  Raymond

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 6 December 2018, 7:57 am EST

  Hi Raymond,

  Please let me know if you are still facing the issue with logging into SupportOne portal?

  Thanks,
  
  Deepak Sharma