Skip to main content Skip to footer

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