Aspose.Cells NumberValue issue in Export to PDF

Aspose.Cells Product Family
1

Hello,

We’re using Aspose.Cells v18.12.0 for .NET and we’ve noticed a couple of issues that appear when we export excel files to PDF, after we purchased the Aspose.Cells product. We decided to share the most easily-reproducible issue here, because the others depend on confidential data. But we could create topics for the rest in the future, if we manage to reproduce them with dummy data.

Namely, the current issue is that the NUMBERVALUE excel formula does not work as expected when exporting files to PDF.

Code used for exporting:

Workbook workbook = new Workbook(“NumberValueBug.xlsx”);
SaveOptions saveOptions = new PdfSaveOptions
{
OnePagePerSheet = true,
CalculateFormula = true
};
workbook.Save(“NumberValueBug.pdf”, saveOptions);

The test files (source excel and exported pdf) are attached to this topic (in a zip file).

NumberValueFormulaIssue.zip (19.2 KB)

Is there any workaround for this?

Thank you in advance,
Best Regards

2

@rystadenergy,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46548 - NumberValue issue while converting XLSX to PDF

3

Hi ahsaniqbalsidiqui

Thanks for looking into it!

Best Regards

4

@rystadenergy

You are welcome.

5

@rystadenergy,

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

6

@rystadenergy,

Please try our latest version/fix: Aspose.Cells for .NET v19.1.4:

Aspose.Cells19.1.4 For .Net2_AuthenticodeSigned.Zip (4.7 MB)
Aspose.Cells19.1.4 For .Net4.0.Zip (4.8 MB)

Let us know your feedback.

7

Hi ahsaniqbalsidiqui,

We just tested it, and the fix works!

Should we expect the fix to be a part of the next release?
If so, when would that be approximately?

Thank you for the quick responses and support!

Have a great day,

Rystad Energy

8

@rystadenergy,

Good to know that your issue is sorted out by the latest fix/version. And, yes, our next official release (e.g Aspose.Cells for .NET v19.2) of the product will include this fix. We are scheduled to release it in the third/fourth week of February 2019. The date is not finalized as usually a release is published when ready. You will also be notified when the next release comes out.

Keep in touch.

9

The issues you have found earlier (filed as CELLSNET-46548) have been fixed in Aspose.Cells for .NET v19.2. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi