Table tools - export exact value without getting converted to formulae in excel
Table tools - export exact value without getting converted to formulae in excel
I am using version 1.10.7 of datatables.
I have a column called time which has values like "-259D:22:49" which indicates how many days, hours, minutes left to meet a deadline and most of the values are negative .
I have been using Table tools plugin to export the table to excel. This column always gets converted to some sorta formula.
My question is:
Is it possible using data tables tabletools to convert the values to text or something so it is retained as it is and not converted to any formulae
Well, here is the part of code used to achieve the export part of it:
$(tableId).dataTable({
"sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "../js/libs/DataTables/extras/TableTools/media/swf/copy_csv_xls.swf",
"aButtons": ["xls"]
})