We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Decimal data rounds on export to csv/txt

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.