I'm using Qt to write a program that creates a XML files that can be opened in Excel. So far I have been progressing rather well but now I have this problem that I need to put newline characters to some of the cells containing some text. Excel XML sheets use as the newline character.
So the problem is that with this:
@QString contents = "Foo&#10;Bar";
QDomText cellContents = doc->createTextNode(contents);
I get this:
While this is what I need:
@<Cell><Data ss:Type="String">Foo Bar</Data></Cell>@
I tried this:
But either that doesn't help here or then there's something wrong on how I'm doing this. Anyone cares to help?