Adding spanned cells breaking change

Adding spanned cells breaking change

Posted by: CKantor on 26 June 2019, 12:14 pm EST

• 

  CKantor

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 June 2019, 12:14 pm EST

  I am trying to upgrade Spread for Winforms in my application from version 10 to 12. In the breaking changes under SheetView, it says:

  Adding spanned cells Spread WinForms 12 no longer allows adding spanned cells that have the same anchor cell as the existing span.

  Whenever I try to set ColumnSpan for an anchor cell that has already been set as having a Columnspan, I get a System.ArgumentOutOfRangeException: “Specified argument was out of the range of valid value”. Can you suggest how to set the column span to something different? Can I clear the ColumnSpan before setting it for a cell?

  Thanks.

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 26 June 2019, 8:09 pm EST

  Hi,

  The breaking change only refers to the use of AddSpanCell. Using ColumnSpan should work correctly.

  I could not observe this exception with the below code:

  fpSpread1.ActiveSheet.Cells[2, 2].ColumnSpan = 3;
  fpSpread1.ActiveSheet.Cells[2, 2].ColumnSpan = 6;
  

  Please post a small sample which exhibits the behavior you’re observing.
  
  Also, mention the exact Spread version so we can check it with that.

  Thanks,
  
  Jitender

• 

  CKantor

  • Post Options:
  • Link
    Copy

  Posted 27 June 2019, 4:20 am EST

  I noticed that I was running version 12.45.20181 and the latest version (released on 6/21) is 12.45.20191. After installing the latest version the problem went away.