| Category: | Bug report |
Priority: | High |
Status: | New |
| Project: | Severity: | Critical |
Resolution: | Open |
|
| Component: | Reproducibility: | Always |
Assigned to: |
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
| Attachment | Size |
|---|---|
 Test report | 1.19 KB |
 This is the XLSX file produced by JR | 3.57 KB |
| This is the XLSX after Excel saved it | 8.14 KB |
v6.3
5 Comments:
What application/version are you using to open the XLSX file? (LibreOffice shows the text with line breaks fwiw.)
Regards,
Lucian
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
Note: this does not happen with XLS export.