Conditional formatting rule priority incorrect for type DataBar

Aspose.Cells Product Family
1

We have the following file: ConditionalFormatting.zip (6.9 KB)
And the following code:

var workbook = new Workbook("ConditionalFormatting.xlsx");

var rule1 = workbook.Worksheets["Sheet1"].ConditionalFormattings[0];
var priority1 = rule1[0].Priority;
// actual: 0
// expected: 4

var rule2 = workbook.Worksheets["Sheet1"].ConditionalFormattings[1];
var priority2 = rule2[0].Priority;
// actual: 0
// expected: 3

var rule3 = workbook.Worksheets["Sheet1"].ConditionalFormattings[2];
var priority3 = rule3[0].Priority;
// actual: 0
// expected: 2

var rule4 = workbook.Worksheets["Sheet1"].ConditionalFormattings[3];
var priority4 = rule4[0].Priority;
// actual: 0
// expected: 1

We found that all these rules with type “Data Bar” have their priority set to 0, instead of the actual priority. The priority is correct for other types of conditional format rules.

2

@infotron,
We have observed the 0 priority of all the conditional formattings by running the above sample code. This issue is logged in our database for investigation and fix as follows:

CELLSNET-47425 - Conditional formatting rule priority incorrect for type DataBar

3

@infotron,
This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-47425”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@infotron,
Please try our latest version/fix: Aspose.Cells for .NET v20.6.2:

Aspose.Cells20.6.2 For .Net4.0.Zip (5.4 MB)
Aspose.Cells20.6.2 For .Net2_AuthenticodeSigned.Zip (5.4 MB)

Your issue should be fixed in it.

Let us know your feedback.

5

Yes, this issue is fixed in Aspose.Cells v20.6.2. Thank you!

6

@infotron.

Good to know that your issue is fixed with the latest fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

7

The issues you have found earlier (filed as CELLSNET-47425) have been fixed in Aspose.Cells for .NET v20.7. This message was posted using Bugs notification tool by ahsaniqbalsidiqui