Breaking Change V11: Column's visibility set to false but shows when the width is set in WinForms
Background:
After the Spread .NET’s version 11 release, to be in accordance with MS-Excel behavior, if the visibility of a column is set to false but the width is also set, then visibility will then change to true making the columns visible.
There is a workaround to prevent this by simply setting the width of the columns directly to the axis model.
Steps to Complete:
Set the Width to the Axis model directly
Getting Started:
Set the Width to the Axis model directly:
To set the column Width without changing its Visibility to true, then you need to set the width to the Axis model directly
fpSpread1.Sheets[0].Models.ColumnAxis.SetSize(x,x);
Tags:
Mackenzie Albitz