Hi,
We have been testing our application (that uses Aspose.Cells to generate an xlsx file). We have discovered that when the ListObject is re-sized in code using ListObject.Resize() Conditional formatting that was used in the ListObject’s column/s are not re-sizing to the size of the ListObject. I have had a look at how conditional formatting behave when a table in excel is re-sized, and found that changing the size of a table within excel automatically updates the range of the conditional formatting
Example:
Original Column range: =$A$2:$A$514
Conditional range: =$A$2:$A$514
New Column range: =$A$2:$A$7
Conditional range: =$A$2:$A$514
I have attached a mini project to demonstrate this issue.
I have also attached input excel file “testFile8.xlsx” containing some dummy data.
Please run the attached project and select the attached file when the open file dialog appears.
Thank you.