Setting Excel FitToPagesWide to "Automatic" in C# (VTSO)

Question

When I record a macro in excel to set the FitToPagesTall = 1 and leave FitToPagesWide as "Automatic" it sets FitToPagesWide to 0. However this errors when in c# (using VSTO).

sheet.PageSetup.FitToPagesWide=0;

Any ideas? Tried setting to NULL to no avail.

Answer 1

Found it.

Have to set to false.

sheet.PageSetup.FitToPagesWide = false;