Bug 75702 - FILEOPEN: line-break ignored
Summary: FILEOPEN: line-break ignored
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Windows (All)
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2014-03-03 10:44 UTC by sylvain
Modified: 2018-10-30 16:40 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

A1 cell with two lines (1.92 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-03-03 10:44 UTC, sylvain
Sample file with line break added. (9.31 KB, application/xml)
2014-03-03 23:12 UTC, m.a.riosv
Cell with a line-break in Writer (8.33 KB, application/vnd.oasis.opendocument.text)
2014-03-04 08:37 UTC, sylvain

Note You need to log in before you can comment on or make changes to this bug.
Description sylvain 2014-03-03 10:44:04 UTC
Created attachment 95016 [details]
A1 cell with two lines

Problem description: 
<text:line-break/> are ignored in cells.

Steps to reproduce:
1. Generate a file with a line break or open the attached file

Current behavior:
All line breaks are removed, leaving only one line of text. On save the new lines are gone from the file.

Expected behavior:
The cell should display one line above the other.

Operating System: Windows 7
Version: release
Comment 1 sylvain 2014-03-03 10:51:16 UTC
The file opens and saves fine in OpenOffice 3.2.
In LibreOffice 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.
Comment 2 m.a.riosv 2014-03-03 23:12:12 UTC
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.
Comment 3 sylvain 2014-03-04 08:33:03 UTC
  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.
Comment 4 sylvain 2014-03-04 08:36:02 UTC
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.
Comment 5 sylvain 2014-03-04 08:37:10 UTC
Created attachment 95074 [details]
Cell with a line-break in Writer
Comment 6 m.a.riosv 2014-03-04 22:32:41 UTC
I have not found if it might be available in ods files as part of cell text.
Comment 7 sylvain 2014-03-17 10:15:20 UTC
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.
Comment 8 retired 2015-01-04 12:01:51 UTC
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.
Comment 9 Priyanka Gaikwad 2015-05-29 05:14:32 UTC
Line breaks are working with version Version:
Comment 10 m.a.riosv 2015-08-23 22:37:16 UTC
Please @sylvain, is the issue solved?
Comment 11 m.a.riosv 2015-12-27 02:17:42 UTC
Four month without info.
Please if you have the issue, reopen it again.
Comment 12 Stefan Rijnhart 2017-12-29 14:10:43 UTC
<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
Comment 13 Xisco Faulí 2018-01-17 17:35:59 UTC
(In reply to Stefan Rijnhart from comment #12)
> <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

Could you please try in LibreOffice ?
Comment 14 Kenneth Hanson 2018-04-11 03:13:46 UTC
Bug is still present in

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.
Comment 15 Jorge Maroto 2018-10-30 16:40:28 UTC
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.