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:
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 22.214.171.124.
Any feedback will be highly appreciated.
Sr Software Engineer
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 v126.96.36.199 and let us know your feedback.