I open an Excel file with Aspose Cells, then I save it in PDF format. The code is simple:
Dim AWB As Aspose.Cells.Workbook = New Aspose.Cells.Workbook() AWB.Open(strFileName) AWB.Save(strFileNamePDF, Aspose.Cells.FileFormatType.Pdf)
In the output files somme cells are empty (like cell U11 in attached file). I know that the cell content is very complex: {=XIRR(IF(FUNDNAME_LVL0_SI=$M11,OFFSET(INDIRECT(CONCATENATE(U$9,CONCATENATE(ADDRESS(ROW(HEADER_SI),MATCH(CONCATENATE(U$8,H11),HEADER_SI,0))))),1,0,NBLINES_SI),IF(FUNDNAME_LVL0_SI="DEFAULT_CASHFLOW",OFFSET(INDIRECT(CONCATENATE(U$9,CONCATENATE(ADDRESS(ROW(HEADER_SI),MATCH(CONCATENATE(U$8,H11),HEADER_SI,0))))),1,0,NBLINES_SI),0)),IF(FUNDNAME_LVL0_SI=$M11,OPERATION_DATE_SI,IF(FUNDNAME_LVL0_SI="DEFAULT_CASHFLOW",OPERATION_DATE_SI,$A$3)),IF($T11>=1,0.1,-0.1))}
Do you know if there is a turnaround, or if this issue is planed to be fixed in next releases ?
Please download and try our latest fix/version: Aspose.Cells for .NET v7.5.0.4 I have tested your scenario with it and it works fine. The cell formulas are evaluated fine and values are calculated fine to be rendered into PDF file.
Sample code:
//…
Dim AWB As Aspose.Cells.Workbook = New Aspose.Cells.Workbook(strFileName)
Well, I have tested and it works fine. It looks like you might be using some older version in your project. Please make sure to use Aspose.Cells for .NET v7.5.0.x, I shared the link (for the fix) in my previous post, please try it and let us know your result. For confirmation, you may print the version number that is being used in your project, see the document for your reference:
e.g
Console.WriteLine("Assembly Version Info: " & CellsHelper.GetVersion())
Thanks for your posting and using Aspose.Cells for .NET.
Please use the workbook.CalculateFormula() method and your pdf will have correct values. We have generated the output pdf with the following code and found no issue. We have attached the output pdf file for your reference.