HTML5 Export Excel saves Currency column (EUR) as text
HTML5 Export Excel saves Currency column (EUR) as text
juanjoMtz
Posts: 2Questions: 1Answers: 0
Link to test case: http://live.datatables.net/kibofude/10
Debugger code (debug.datatables.net): https://debug.datatables.net/iwajeb
Error messages shown: (In excel) The Number in This Cell is Formatted as Text
Description of problem: Columns 1 and 2 are formatted as text, so you cannot use them for calculations
The percentage one works fine, oddly enough
This question has an accepted answers - jump to answer
Answers
The format we are looking for for Euros in an Excel export is
€123- so the Euro following in your export renderer doesn't match.Changing the renderer slightly allows it to work: http://live.datatables.net/zojegute/1/edit .
Allan
Oh, it had to be something as simple like that
It might be a good idea to search for both (A lot of european languages append the sign, for example spanish, german, or french, just to name some), since it looks like a reasonably simple change.
Also, a reference in the docs would also come a long way (Maybe when the pattern matching for special number formats becomes exposed via an API?)
Thank you very much for the help
Agreed on all accounts! The export format detection really needs a bit of love and care!
Good to hear that did the job for you.
Regards,
Allan