Synthoid/ExportSheetData

(XML) cannot have a cell value with < or >

Closed this issue · 1 comments

phtsang commented

Great work! This is the most promising thing for XML outputs!

I have some values inside my cells as < and/or >
But the XML output is &lt; and &gt;

If this is fixed then I have a working nested XML for my purposes. By using =CONCATENATE(<child1>,child1,</child1>,<child2>,child2,</child2>) ?

Thanks!

Synthoid commented

By default, illegal XML characters are formatted to use safe encoding. You can disable this by using the Don't format illegal characters option. That should do what you want.