Conditional formatting evaluation incorrect

Aspose.Cells Product Family
1

Please run the following program against the attached spreadsheet:

private static void TestConditonalFormatting()
{
Workbook workbook = new Workbook(@“C:\temp\spreadsheets\test_conditional_formatting7.xlsx”);
Worksheet worksheet = workbook.Worksheets[0];

workbook.CalculateFormula();

Cell cell = worksheet.Cells[“A1”];
ConditionalFormattingResult formattingResult = cell.GetConditionalFormattingResult();

Console.WriteLine(“Is ConditionalFormattingIcon not null: {0}”, formattingResult.ConditionalFormattingIcon != null);

}

Basically, A1 has two conditional formattings. If the value is > 100 then the first rule says there is no formatting and the evaluation should stop right there if the condition is true.

The second condition is an iconset type condition formatting.

Because the value in A1 is 101, the ConditionalFormattingResult ConditionalFormattingIcon should be null because the evaluation doesn’t reach the second condition. If the value was <= 100 then yes, ConditionalFormattingResult.ConditionalFormattingIcon should not be null.

Can you please fix this?

Thanks

2

Hi Costa,

Thanks for your posting and using Aspose.Cells for .NET.

We were able to observe this issue. ConditionalFormattingResult ConditionalFormattingIcon should be null because the evaluation doesn’t reach the second condition.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-42135.

3

Hi,

Thanks for using Aspose.Cells for .NET.

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET v7.7.0.2 and let us know your feedback.

4

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

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