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

Question

When I write a macro to excel to set FitToPagesTall = 1 and leave FitToPagesWide as "Automatic", it sets FitToPagesWide to 0. However, these errors are when using C # (using VSTO).

sheet.PageSetup.FitToPagesWide = 0;

Any ideas? I tried installing to NULL to no avail.

Answer 1

Found.

You must set the value to false. sheet.PageSetup.FitToPagesWide = false;