[#7161] - JR new lines not showing initially in XLSX export

Category:
Bug report
Priority:
High
Status:
New
Project: Severity:
Critical
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:
0

Hi,

When I make a report that exports to XSLX, then the newlines are being ignored in Excel. Example: http://cl.ly/fSNU

Strange thing is, when you make a minor change to the exported xlsx file and save it, when you open that file, new lines suddenly appear! So they are not actually lost.

This makes me believe JR is somehow not correctly formatting newlines for Excel.

I included a sample report that illustrates this problem.

Kind regards,
Maarten @ Yesplan

v6.3
mvcoile's picture
120
Joined: Apr 28 2014 - 2:15am
Last seen: 11 months 3 days ago

5 Comments:

#1

What application/version are you using to open the XLSX file? (LibreOffice shows the text with line breaks fwiw.)

Regards,
Lucian

#2

Yes, Numbers (Apple's version Excel) also shows it. However, Microsoft Excel (all versions) does not. Since these files are used by people with Excel, it's irrelevant to me that they work with other software.

I have a slight feeling this is because their own XML has CRLF or CR line-endings, while JR creates xml files with LF. By xml I off course mean the xml files inside the .xlsx file.

Kind regards,
Maarten @ Yesplan

#3
  • Assigned:nobody» lucianc
#4

Note: this does not happen with XLS export.

#5
  • Assigned:lucianc» shertage
Feedback
randomness