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)