Bug 88213 - Carriage returns in cells broken with xlsx
Summary: Carriage returns in cells broken with xlsx
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.5.2 release
Hardware: Other Windows (All)
: low normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-08 21:24 UTC by randy
Modified: 2015-04-30 14:57 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Carriage return disappears upon re-open in Calc and in MS Office (mac 2011) (4.83 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-01-08 21:24 UTC, randy
Details
xlsx doc (4.83 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-01-08 21:40 UTC, randy
Details
xlsx doc (4.83 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-01-08 21:41 UTC, randy
Details
Demonstration of the issue in different cases (55.59 KB, application/zip)
2015-01-08 22:24 UTC, Wolfgang Jäger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description randy 2015-01-08 21:24:07 UTC
Created attachment 111974 [details]
Carriage return disappears upon re-open in Calc and in MS Office (mac 2011)

Did some discussing isolating this, which seems to be a legitimate issue that happens under specific circumstances. See this thread and the "answer" for further information. I'm incluing my test file here.

http://ask.libreoffice.org/en/question/44693/calc-text-carriage-return-disappears-upon-re-open/

The problem seems to be that if formatting is not the same on either side of the carriage return, it breaks in this file format. But see answer in thread for more information.
Comment 1 randy 2015-01-08 21:40:08 UTC
Created attachment 111975 [details]
xlsx doc
Comment 2 randy 2015-01-08 21:41:29 UTC
Created attachment 111976 [details]
xlsx doc
Comment 3 Wolfgang Jäger 2015-01-08 22:24:04 UTC
Created attachment 111979 [details]
Demonstration of the issue in different cases
Comment 4 Wolfgang Jäger 2015-01-08 22:35:00 UTC
(I was in contact with the original author of the bug report. See his link ionto the ask.libreoffice forum.)
The attachment https://www.libreoffice.org/bugzilla/attachment.cgi?id=111979 shall demonstrate that the issue is depending on the surrounding of the hard line break. 
During my investigation the error did not occur if at least one character in front of and one character behind the hard line break were uniformly formatted and thus were completely inside of a single text field. 

The same sheet saved in XLS and then reloaded did not show the error.
Comment 5 Wolfgang Jäger 2015-01-08 23:13:19 UTC
Additional tests showed: Ordinary spaces in contact with the line break are abolished together with the break independent of their character format if the next character in frontof the first space and behind the second space are differently formatted. The U+FEFF zero width space on the other hand is treated as letters and can prevent abolishing a line break between two specimen of it in same format. Having two U+FEFF differently formatted and a line break between: The line break will vanish, the two zero spaces will persist.
Comment 6 raal 2015-01-09 13:33:08 UTC
I can confirm with LO 4.3.5, win7
Comment 7 raal 2015-01-09 19:00:23 UTC
I can not confirm with Version: 4.4.0.1.0+
Build ID: 6db4dfae163753dfa1724120c5e235274559bcf0
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2014-12-31_02:11:39

I can not confirm with Version: 4.5.0.0.alpha0+
Build ID: 5d061167ee9b88628a1936041ee90c62e4dc1e18
TinderBox: Win-x86@42, Branch:master, Time: 2015-01-09_14:05:40

It's fixed in developer version,so closing as worksforme.