Hi,
Please see attached SpreadsheetML input file. It contains following Worksheet:
<Worksheet ss:Name="Sheet1">
<Table>
<Column ss:Width="100" />
<Column ss:Hidden="1" />
<Column ss:Width="100" />
<Row>
<Cell><Data ss:Type="String">Y</Data></Cell>
<Cell ss:Formula="=RC[1]"><Data ss:Type="Number">0</Data></Cell>
<Cell><Data ss:Type="Number">1</Data></Cell>
It’s a 3 column 1 row table. Column B is Hidden, but Cell B1 contains both Data (0) and a formula (=C1). This causes the column to be visible. If we remove Data node from the cell it will stay hidden.
The code I’m using to replicate the issue:
var workbook = new Workbook(@"D:\FormulaWithinHiddenColumn.xml", new LoadOptions(LoadFormat.SpreadsheetML));
workbook.Save(@"D:\output.xlsx");
Can you please take a look?
Thanks,
Maciek
FormulaWithinHiddenColumn.zip (1021 Bytes)