Free Support Forum - aspose.cloud

Convert Excel to PDF : Sometimes the result of evaluation of formula is not stable


#1

Hi all,

I have converted Excel to Pdf as following sample :
http://www.aspose.com/docs/display/cellscloud/Convert+Excel+Workbook+with+Additional+Settings

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
";

//sign URI
string signedURI = Sign(strURI);
POST(signedURI, xml);

//build URI

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.