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

Free Support Forum - aspose.com

Cell.GetDisplayStyle() is not reflecting the applied table filter


We’ve encountered an issue with Cell.GetDisplayStyle() when the cells are hidden after applying a filter.

Attached a small console application describing the issue - the input TestFile.xlsx has on the A2:C5 range a table filter applied and the first row is hidden. After applying the filter Excel also updates the alternate-row style correspondingly, e.g. by making the first visible row (11) to appear with darker background.

But when inspecting this with Aspose, it seems the filter is not affecting the styles on the cells, as per the console app’s output the darker colour is applied on the hidden A2 row, and not on the first A3 visible one:
<<Test started…
Hidden A2 Cell has foreground colour: 'Color [A=255, R=220, G=230, B=242]'
A3 Cell has foreground colour: 'Color [Empty]'
A4 Cell has foreground colour: 'Color [A=255, R=220, G=230, B=242]'
A5 Cell has foreground colour: 'Color [Empty]'
Test finished, press any key…>>

We are using Aspose.Cells version

Any feedback will be highly appreciated.

Thank you,
Mihai Andrei
Sr Software Engineer
IBM Romania

Hi Mihai,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after running your project with your given source file. After the filter is applied, cell A3 color should be darker but it is shown as empty.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42661.


Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.0.2.2 and let us know your feedback.

The issues you have found earlier (filed as CELLSNET-42661) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.