Incorrect formula calculation in Excel to PDF conversion using Aspose.Cells Cloud API

Aspose.Cells Cloud Product Family
1

Hi all,

I have converted Excel to Pdf as following sample :
https://docs.aspose.cloud/display/cellscloud/Convert+Excel+Workbook+to+Different+File+Formats

Our customers had reported about that they use the same template (different time data) and converted into PDF (on 05-December). Then they had received the different convert pdf results and they didn’t know why. Can you explain about it ?

Thanks,
Chien

2

Hi,

Thanks for the template files and screen shots.

I have evaluated your issue and it works fine as per the original Excel file. I used the following sample code and the formulas evaluations in the output PDF is same as per the original Excel file, I have attached the output PDF file for your reference here.

e.g

Sample code:

APPKey.AppSID = “787xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx”;

APPKey.AppKey = “394xxxxxxxxxxxxxxxxxxxxxxxxxxx”;

string xml = @"

false

false

None

false

90

70

Pdf

";

string strURI = “http://api.aspose.com/v1.1/cells/CheckFile.xlsx/saveAs?newfilename=outexcelfile1.pdf”;

//sign URI

string signedURI = Sign(strURI);

POST(signedURI, xml);

//build URI

strURI = “https://api.aspose.com/v1.1/storage/file/outexcelfile1.pdf”;

signedURI = Sign(strURI);

using (HttpWebResponse response = GET(signedURI))

{

using (var stream = File.Create(@“e:\test2\outFileExcel121.pdf”))

{

response.GetResponseStream().CopyTo(stream);

}

}

Let us know if you find any issue in the output PDF comparing with original Excel file regarding formula calculations.

Thank you.