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

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)

@acturisaspose

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

@acturisaspose

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?

@acturisaspose

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.