Free Support Forum - aspose.cloud

Convert Excel to PDF : The evaluation of formula is not same between cells


#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

With my excel template, I have received the result pdf with evaluating formula is not the same between cells. Can you explain about it ?
(Please see the screenshot image for more details)

Thanks,
Chien


#2

Hi Chien,

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

We were able to observe this issue and logged it in our database for a fix. Once, the issue is fixed or we have some other update for you, we will let you know asap.

This issue has been logged as

  • SAASCELLS-103 - Convert Excel to PDF : The evaluation of formula is not same between cells


#3

Hi,


Thanks for the template files.

I have evaluated your issue and it works fine. Please set CalculateFormula attribute to false in PdfSaveOptions options in xml string,
e.g
false

I used the following sample code and it works fine, I have attached the output PDF file for your reference here.
e.g
Sample code:

APPKey.AppSID = “787xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx”;
APPKey.AppKey = “394xxxxxxxxxxxxxxxxxxxxxxxxx”;

string xml = @"
false
false
None
false
90
70
Pdf
";

string strURI = “http://api.aspose.com/v1.1/cells/EvaluateFormula.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\outFileExcel119.pdf”))
{
response.GetResponseStream().CopyTo(stream);
}
}


Please see the above code and evaluate it to see if it fine and also check the output PDF file for your reference.

Let us know if you find any issue in the output PDF file.


Thank you.