The PDF conversion misses the values ?of the named areas

Aspose.Cells Product Family
1

Hi, please see the attached files.

I’ve tried to convert de xslx file to pdf with the simple code:

Dim wb As New Aspose.Cells.Workbook(excelFileStreamIn)
wb.Save(pdfFileStreamOut, Aspose.Cells.SaveFormat.Pdf)

But as you can see the resultant PDF document does not present the values of some named area (VarB1, VarN1, etc).
The excel document was generated by setting its custom properties using Aspose libraries.

It seems that the named area was not up to date with the custom properties and then the conversion method does not convert the values. If I open the excel file with Excel and I save it then the conversion will be ok.

Can you help me to fix this issue?

Thank you
2

Hi,

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

I am able to replicate this issue using the latest version:
Aspose.Cells
for .NET v7.2.2.1


We have logged this issue in our database. Once the issue is fixed or we have some other update relating to this issue, we will let you know asap.

This issue has been logged as CELLSNET-40774.

C#


string filePath = @“F:\Documento.xlsx”;


Workbook workbook = new Workbook(filePath);


workbook.CalculateFormula();

workbook.Save(filePath + “.out.pdf”);


Screenshot:

3

Hi,

We have fixed this issue. Please download and use the latest version: Aspose.Cells for .NET v7.2.2.2.

Please use the following code.

C#


Workbook workbook = new Workbook(@“D:\FileTemp\Documento.xlsx”);

workbook.CustomDocumentProperties.UpdateLinkedRange();

workbook.Save(@“D:\FileTemp\dest.pdf”);

4

Thank you very much!

It work well!


5

Hi,

Thanks for your feedback

It’s good to know your issue is resolved.

If you encounter any other problem or have some questions to be asked, please feel free to post, we will help you asap.

6

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.