Generating csv/txt output form an template file with smart markers rounds the decimal typed data. No rounding occurs when exporting in excel format, which is the desired behavior.
Is there a work around for this?
Sample csv output:
“StringColumn”,“DecimalColumn”
“123.0123456789”,“123.0123457"
”-345.0123456789","-345.0123457"
Values in the DecimalColumn & StringColumn are the same. Only difference is the data type of the underlying DataColumn.
Attached is the sample console app and test template.
Aspose.Cells v 8.6
Hi,
Thanks for your posting, providing us the sample project and using Aspose.Cells.
We have checked your TestTemplate_output.xlsx and TestTemplate_output.csv and did not find any rounding issues, values in both files look same. I have attached the screenshot showing both of them for your reference.