Preventing conversion of & to `& amp;`
Preventing conversion of & to `& amp;`
Webtoolboy
Posts: 2Questions: 1Answers: 0
Hi,
When exporting to Excel '&' automatically gets converted to &
I have tried exportOptions such as setting stripHtml to false, orthogonal to display null and also a format replacing the & with something else entirely.
The final solution works but it seems to be executed before & gets converted to & which prevents the final output from containing any unconverted '&' characters.
Is there any way to disable the conversion to & ?
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
The Excel file format is XML based so there has to be some sort of encoding. Does it show as
&in Excel? Can you give me a link to a page showing the issue please?Allan
When setting up an example on live.datatables.net I went through the versions of the files used and realised this is a problem that has been fixed in the latest version of buttons.html5 (v 1.3.1). I was using version 1.2.1:
http://live.datatables.net/heduyufu/1/
But thank you for your answer that ultimately lead me to the solution to the problem!
Super - thanks for posting back. Good to hear that the latest version does the business for you!
Allan