Conditional formatting is lost on Deleting Row

Aspose.Cells Product Family
1

Hi Team,

We are facing an issue of losing conditional formatting when we delete row which was part of the conditional formatting range.

We are facing this issue with our latest Aspose.cells dll 7.5.3.0. This was not an issue with Aspose.cells 7.3.1.2 version.

Can you pls loon into this and revert.

Attached the excel and code sample files.

SampleFile.txt ---> c# code

SampleFile.xls ---> Excel template having defined conditional formatting

SampleFile_New.xls ---> Generated file using aspose code. Here in this file pls check the conditional formatting. You'll find the cell has the REF#

Thanks,

Hetal

2

Hi Hetal,

Thank you for providing your sample spreadsheet and code snippet for our review.

We are able to observe the problem on loosing conditional formatting rules when rows are deleted from the range on which condition formatting rules have been defined. Please note, we used the latest version of Aspose.Cells for .NET 7.7.1.1 for our testing. A ticket (CELLSNET-42318) has been logged in our bug tracking system to probe further into this matter. Please spare us little time to properly analyze the problem cause, and to provide a fix at earliest (if applicable). In the meanwhile, we will keep you posted with updates in this regard.

Please accept our apologies for your inconvenience.

3

Hi,

Thanks for using Aspose.Cells.

We have fixed this issue.

Please download and try the latest version: Aspose.Cells for .NET (Latest Version) and let us know your feedback.

4

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

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