Created attachment 95016 [details]
A1 cell with two lines
<text:line-break/> are ignored in cells.
Steps to reproduce:
1. Generate a file with a line break or open the attached file
All line breaks are removed, leaving only one line of text. On save the new lines are gone from the file.
The cell should display one line above the other.
Operating System: Windows 7
Version: 220.127.116.11 release
The file opens and saves fine in OpenOffice 3.2.
In LibreOffice 18.104.22.168 the single line is hidden. I.e. If the file content was line1<line-break/>line2 then the cell content is line1line2\n but only the second empty line is displayed unless the row height is grown.
Created attachment 95063 [details]
Sample file with line break added.
Hi sylvain, thanks for reporting.
Your file open without line break in 4.1.6 4.2.1 4.2.2
But adding a line break, save, open in any of this version with line break.
find attached the new file.
sorry if I wasn't clear, the bug is ignoring the XML element <text:line-break/>. Not the UI feature of line break which in Calc insert a new <text:p>.
But this could be connected as in Writer inserting a line break in in the UI creates an actual <text:line-break/> element.
Sorry hit save before finishing my last sentence ;
But this could be connected as in Writer inserting a line break in a table cell from the UI creates an actual <text:line-break/> element. I've attached a sample.
Created attachment 95074 [details]
Cell with a line-break in Writer
I have not found if it might be available in ods files as part of cell text.
The XML syntax is the same for all document types, see 9.1.1 in OpenDocument-v1.2-os-part1 and also 6.1.1 Paragraph Elements Content/Basic Text Content/General : "The paragraph elements <text:p> and <text:h> and their *descendant elements* contain the text content of *any* document." IMHO this clearly says that <text:line-break/> (just as <text:s/> and <text:span>) should be supported everywhere by LibreOffice and not just in Writer. All the more since multi-line UI is already supported in Calc.
OSX behaves identical thus OS > All.
Not sure if this should or should not be working. Setting to Enhancement and NEW.
We need a dev to chime in on this if this enhancement request makes sense or not.
Line breaks are working with version Version: 22.214.171.124.alpha1+
Please @sylvain, is the issue solved?
Four month without info.
Please if you have the issue, reopen it again.
<table:table-cell office:value-type="string" calcext:value-type="string"><text:p>line1<text:line-break/>Line2</text:p></table:table-cell> still renders as a single line in LibreOffice 126.96.36.199.
(In reply to Stefan Rijnhart from comment #12)
> <table:table-cell office:value-type="string"
> table:table-cell> still renders as a single line in LibreOffice 188.8.131.52.
Could you please try in LibreOffice 184.108.40.206 ?
Bug is still present in 220.127.116.11
I entered two lines in a cell with Ctrl-Enter, then manually replaced ...</text:p><text:p>... with <text:line-break/>. The line break disappeared.
Note that using `setDataArray` API call will insert `<text:line-break>` instead of `<text:p>`, so those inserted new lines will be removed as soon as the document is saved and re-opened.