Difference in values between an excel file and the converted pdf (via aspose) file

IDBSSupport · February 22, 2022, 1:12pm

Displaying values of an Excel file in Aspose converted pdf with "Show Formula " enabled in the excel file-

In excel, where the a cell value is generated through a formula (e.g- SUM) and then copy-pasted that value to another cell.
Now, if that excel file (with Show Formula option enabled ) is converted, it tends to add few more digits at the end of the decimal numbers.

The customers expect to show the digits as shown in the original excel file but the copy-pasted data seems to add few more digits at the end of it.

The same issue is not observed on a manually entered value or any other value which was copy-pasted but was not generated through a formula.

PFA a screenshot of the original excel and the converted PDF for reference.
test-2.xlsx.pdf (19.2 KB)
xl.PNG (40.8 KB)

Amjad_Sahi · February 22, 2022, 1:35pm

@IDBSSupport,

Thanks for the screenshot and output PDF.

Could you also zip and attach your Excel file which you are converting to PDF via Aspose.Cells for Java API. We will check your issue soon.

IDBSSupport · February 23, 2022, 4:11am

test file.zip (11.7 KB)
PFA the original excel file.

Amjad_Sahi · February 23, 2022, 9:06am

@IDBSSupport,

Thanks for the template file.

We were able to reproduce the issue using your template file. A ticket with an id “CELLSJAVA-44364” is logged for your issue. We will look into the details of your issue and try to figure it out soon.

Once we have an update on it, we will let you know here.