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

Free Support Forum - aspose.com

Moving conditionally formatted cells removes formatting

Aspose.Cells Product Family
#1

Moving a conditional formatted range somewhere that overlaps its original position seems to cause it to lose formatting.

input.zip (7.8 KB)

        Workbook workbook = new Workbook("input.xlsx");

        Range range = workbook.Worksheets.GetRangeByName("range");
        range.MoveTo(range.FirstRow-1, range.FirstColumn);

        workbook.Save("output.xlsx");
#2

@valuepro

Thanks for using Aspose APIs.

We were able to observe this issue as per your sample code, sample Excel file and description. 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 news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45543 - Moving conditionally formatted cells removes formatting
#3

@valuepro

Thanks for using Aspose APIs.

This is to inform you that we have fixed your issue CELLSNET-45543 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

#4

@valuepro,

Please try our latest version/fix: Aspose.Cells for .NET v17.7.5:


Your issue should be fixed in it.

Let us know your feedback.

Thank you.

#5

The issues you have found earlier (filed as CELLSNET-45543) have been fixed in latest version of Aspose.Cells for .NET (Download | NuGet).