We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

SpreadsheetML: Hidden attribute on Column doesn't work for cells with Formula + Data


Please see attached SpreadsheetML input file. It contains following Worksheet:

<Worksheet ss:Name="Sheet1">
   <Column ss:Width="100" />
   <Column ss:Hidden="1" />
   <Column ss:Width="100"  />
    <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));

Can you please take a look?


FormulaWithinHiddenColumn.zip (1021 Bytes)


Thanks for using Aspose APIs.

We were able to observe this issue and logged it in our database for investigation and for a fix. Once, the issue is resolved or we have some other news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45639 - SpreadsheetM - Hidden attribute on column does not work - Column B should be hidden


Please download and try the following fix and let us know your feedback.

could you please let me know when do you plan to release this fix?


The upcoming official release will be 17.9.

17 means year 2017
9 means month September

It will be released somewhere 15-Sept to 25-Sept. It will also be available via NuGet.

The issues you have found earlier (filed as CELLSNET-45639) have been fixed in Aspose.Cells for .NET 17.9.