Show*** properties in SheetView

Apr 21, 2011 at 3:19 AM

Hello,

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 };
                worksheetPart.Worksheet.SheetViews.Append(sheetView);
            }
 

Thank you.

Coordinator
Apr 21, 2011 at 3:54 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Coordinator
Apr 21, 2011 at 3: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 6:20 AM

Great. Thanks for your support.