search

clarketm / TableExport

The simple, easy-to-implement library to export HTML tables to xlsx, xls, csv, and txt files.
https://tableexport.travismclarke.com/
Apache License 2.0
888 stars 290 forks source link

XLS export negative numbers not exported correctly #97

Open mkoczorowski opened 7 years ago

mkoczorowski commented 7 years ago

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

image

what can cause this ? can anyone help ?

saidbakr commented 7 years ago

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 commented 7 years ago

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

saidbakr commented 7 years ago

@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 commented 5 years ago

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