showGridLines & showRowColHeaders in page not working #1079
Description
Source coder:
ws.pageSetup.horizontalCentered = true
ws.pageSetup.verticalCentered = true
ws.pageSetup.showGridLines = true
ws.pageSetup.showRowColHeaders = true
File output:
- horizontal : uncheck
- vertical : uncheck
sheet1.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">
<dimension ref="C3:C3" />
<sheetFormatPr defaultRowHeight="15" outlineLevelRow="0" outlineLevelCol="0" x14ac:dyDescent="55" />
<sheetData>
<row r="3" spans="3:3" x14ac:dyDescent="0.25">
<c r="C3" t="s">
<v>0</v>
</c>
</row>
</sheetData>
<printOptions horizontalCentered="1" verticalCentered="1" />
<pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3" />
<pageSetup orientation="portrait" horizontalDpi="4294967295" verticalDpi="4294967295" scale="100" fitToWidth="1" fitToHeight="1" />
</worksheet>