New line characters are lost when exporting to XML spreadsheet


I had some longer text that contains new line characters and needed to be translated. After exporting to XML spreadsheet, the new line character was removed in the process and the whole formatting of the text was lost in the process.
Example of resource to translate:
Sample blurb to translate:
• Line 1
• Line 2
• Line 3
Applications used:
  • ResourceBlender Express v1.4.7. Also checked on latest source.
  • Office 2007
    It might be that the new line is not replaced with special character that Excel recognises. When you for example create XML Spreadsheet (2003) using Excel 2007 and look into the file in text editor, you can notice the use of where new lines were used.