Table tools - export exact value without getting converted to formulae in excel

Table tools - export exact value without getting converted to formulae in excel

ShruthiPaiKShruthiPaiK Posts: 1Questions: 1Answers: 0

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"]
             })
This discussion has been closed.