Hidden columns becoming visible after width change

Hidden columns becoming visible after width change

Posted by: Bryan.Graves on 3 June 2019, 5:06 am EST

• 

  Bryan.Graves

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 June 2019, 5:06 am EST

  We are upgrading our spread to the newest version and are hammering out any problems from the upgrade. One problem we are experiencing is with the Column.Visible property.

  I have set the visible property for some columns to False. If I set the width for these columns, the visible property gets set back to True. Is there a property to set that will prevent this?

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 3 June 2019, 11:13 pm EST

  Hello,

  I can observe the issue at my end using the latest Service Pack. Hence, I’ve forwarded it to the developers for fix [ID:273080].
  
  I’ll update you once it is fixed.

  Thank you for reporting the issue.

  Thanks,
  
  Ruchir

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 10 June 2019, 12:13 am EST

  Hello Bryan,

  We’ve received information from the developers that it is by-design.
  
  >>I have set the visible property for some columns to False. If I set the width for these columns, the visible property gets set back to True.
  
  This is a breaking change in Spread V11 which is also in accordance with MS-Excel behavior.
  
  Also, the reason why it worked in Spread12 was because of a bug that had been fixed in the last service pack Spread12 SP1.

  ~Ruchir

• 

  Bryan.Graves

  • Post Options:
  • Link
    Copy

  Posted 10 June 2019, 5:39 am EST

  Is there a work around to prevent this?

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 10 June 2019, 3:30 pm EST

  Hi,

  Yes. In case, you just want to set the column Width without changing its Visibility, then you should set the Width to Axis model directly (SheetView.Models.ColumnAxis), something like:

  fpSpread1.Sheets[0].Models.ColumnAxis.SetSize(4,100);
  ```Warm regards,
  Ruchir