max lenght of field
max lenght of field
mahdishad
Posts: 5Questions: 4Answers: 0
hi . i have a field that has like this value 112.301.70132470.1 . when length of content greater than 15 character, in exported excel file
this value save 112.301 .
how can i solve this problem?
thx
This discussion has been closed.
Answers
I think your issue is more like excel / export to excel thinking this is a numeric value instead of a text value. It used to be (or still is) a common issue when exporting a somewhat numeric appearing text to excel. In pure excel, you used to put an apostrophe in front of the text so excel knew it was not a number. In HTML export, you use to put a span around the text. In writing to .xlsx worksheets, you put a span with class of "text" around the text to prevent conversion.
I think you can use the exporting data feature found here,
https://datatables.net/extensions/buttons/examples/html5/outputFormat-function.html
I think if you render your export with an apostrophe in front of the text value for that column or encapsulate the cell in a span it is should work.
thx. but i find best way for solve this problem. with put this string "" in left side of field content(ex: "112.301.70132470.1") value convert to string and problem has solved