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.
Created attachment 111975 [details] xlsx doc
Created attachment 111976 [details] xlsx doc
Created attachment 111979 [details] Demonstration of the issue in different cases
(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.
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.
I can confirm with LO 4.3.5, win7
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.