This project has moved and is read-only. For the latest updates, please go here.

Show*** properties in SheetView

Apr 21, 2011 at 4:19 AM


It would be great to include API properties or methods to set Show*** properties in SheetView, ie ShowGridLines, ShowRuler, ShowRowColHeaders etc...

Currently, I tweak the source code in XLWorkbook_Save.cs to enable such properties. For example:

            var sheetView = worksheetPart.Worksheet.SheetViews.FirstOrDefault();
            if (worksheetPart.Worksheet.SheetViews.Count() == 0)
                sheetView = new SheetView() { ShowGridLines = false,  WorkbookViewId = (UInt32Value)0U };

Thank you.

Apr 21, 2011 at 4:54 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Apr 21, 2011 at 4:59 AM

Thanks for the suggestion, I'll include it. You won't see it for a couple of weeks though (I'm in the middle of implementing charts).

Apr 21, 2011 at 7:20 AM

Great. Thanks for your support.