XLS export negative numbers not exported correctly

[mkoczorowski]

When I export a table which have negative numbers in cell all of those numbers are incorrect in xls file.

an example comparing the same table exported to csv vs xls

what can cause this ? can anyone help ?

[saidbakr]

Indeed, it is not negative numbers only. It extends to any dash - character containing string, such as MySQL datetime format or text like ABM-1. Also unicode charcaters such as Arabic. However, in CSV and Text export format everything works fine.

[mkoczorowski]

hi, thanks for the explanation. Do you know is there any workaround ?

[saidbakr]

@mkoczorowski Unfortunately, I do not know else using CSV. However, CSV need proper import to MS Excell, but it works smoothly with Libre Office Calc

[SWAT10101]

@mkoczorowski
@saidbakr https://github.com/clarketm/TableExport/issues/124