Convert Excel to PDF API of Aspose.Cells cloud evaluates incorrect formula

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

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.