Line Break in Cell breaks Excel Export in IE7/XP
Line Break in Cell breaks Excel Export in IE7/XP
sm9
Posts: 27Questions: 0Answers: 0
Hi there,
I've just noticed an issue when exporting exporting data to Excel using DataTables (1.7.3) and TableTools (2.0.0.dev).
I've noticed that if a cell has data with line breaks within (i.e. multiple paragraphs of text split with the paragraph here), it breaks cell data into the next cell at each line break. For info, my table has 12 columns and around 200 rows.
This happens in Windows XP with Internet Explorer 7, but doesn't happen on Safari 5 on Max OSX 10.6.
Any ideas on how I can get around this at all?
Thanks,
Stephen
I've just noticed an issue when exporting exporting data to Excel using DataTables (1.7.3) and TableTools (2.0.0.dev).
I've noticed that if a cell has data with line breaks within (i.e. multiple paragraphs of text split with the paragraph here), it breaks cell data into the next cell at each line break. For info, my table has 12 columns and around 200 rows.
This happens in Windows XP with Internet Explorer 7, but doesn't happen on Safari 5 on Max OSX 10.6.
Any ideas on how I can get around this at all?
Thanks,
Stephen
This discussion has been closed.