COUNTIFS formula not calculated correctly when converting to PDF

Aspose.Cells Product Family
1

Hi,

We have found that “COUNTIFS” formulas are not calculated correctly in XLSX files converted to PDF.
The formula column just has 0 instead of the actual result.

I have attached a small project to demonstrate the issue. I have also attached an input file “input file with countifs.xlsx”. The project’s code simply opens the input file, calculate formulas, then re-saves it as “generated file.xlsx”.

The input file has two formula columns; one with “COUNTIFS” and another with “COUNTIF”.
If you look at the generated file, you can see that the COUNTIFS column only shows 0s as shown in the attache screenshot.

2

Hi,


Thanks for the sample project with the template file.

After an initial test, I can notice the issue as you mentioned by converting your template file to PDF. The COUNTIFS formula is not calculated in the list although we call Workbook.CalculateFormula() method before rendering to PDF format. I have logged a ticket with an id “CELLSNET-41909” for your issue. We will look into your issue soon.

Once we have any update on it, we will let you know here.

Thank you.

3

Hi,

We’re getting some pressure in getting a fix for this bug. In comparison to the other issues with converting Excel files to PDF (conditional formatting in pivot tables) this issue is the biggest from our point of view. This is because the other options have good alternatives while this one does not. We are looking at using Array Formulas to work around this, but the complexity of understanding Array Formulas could confuse users.

4

Hi,


I checked the status of your issue (logged as “CELLSNET-41909”) into our database, it is resolved, so you might expect a fix soon. We might conduct some extensive testing before providing you the fix here.

Thank you.
5

Hi,

That sounds promising. I hope it truly is fixed and that no issues surfaces during your tests.

Thank you for the information.

6

Hi,

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

We have fixed the issue.

Please download and try this fix: Aspose.Cells for .NET (Latest Version) and let us know your feedback.

7

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

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