Export to Excel: specific data is missing
Export to Excel: specific data is missing
elstupid
Posts: 25Questions: 5Answers: 1
Link to test case: https://live.datatables.net/ramapozi/1/edit
Description of problem:
I came across this very specific problem with data, see example. It's part of a live table I have with items, which have a brand name and a serial number.
If I try to export this table to CSV or any other option, data is exactly exported as is. If it's exported to Excel however, the value for "18E03778" is converted to #NULL!
If I change it to "18F03778" it exports just fine. It seems this is data specific, where the export to Excel interprets data and sees some as text, others as numbers and this one possibly as hex or something?
Because this is textual data in the JSON it should render as just text in Excel.
Is there a workaround to force this to render as text (even though I feel this shouldn't happen)?
Answers
Ooo - that's a nasty one. Thanks for letting me know about it. It is due to this line of code which attempts to be smart about the export, but for your specific data it is not what is wanted.
I might need to rewrite how the export works so that line only runs on number type columns... Let me ponder it a bit
Allan
Glad to help
Might be a challenge to fix this, good luck