Downstream bug may be found at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/892476 1) lsb_release -rd Description: Ubuntu 11.10 Release: 11.10 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.4.4-0ubuntu1~ppa1 Candidate: 1:3.4.4-0ubuntu1~ppa1 Version table: *** 1:3.4.4-0ubuntu1~ppa1 0 500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ oneiric/main i386 Packages 100 /var/lib/dpkg/status 1:3.4.3-3ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages 3) What is expected to happen in LibreOffice Calc is when one of the cells contains a line break -> Edit -> Find and Replace... -> in the "Search for" drop down \n -> in the "Replace with" drop down \n -> Regular expression button checked is the line break is replaced with a paragraph break as noted in http://help.libreoffice.org/Common/List_of_Regular_Expressions 4) What happens instead is the line break is replaced with the characters \n
*** Bug 43086 has been marked as a duplicate of this bug. ***
I think this is a duplicate of bug44398, i.e. isn't this a more general problem than just \n? (behaviour confirmed with version 3.5.3release, details entered in comment with bug 44398) *** This bug has been marked as a duplicate of bug 44398 ***
Winfried Donkers, I do not agree with this being a duplicate of bug 44398, nor do I agree with bug 44398 being accepted as a valid report for that matter based on the title. Many, purposefully or ignorantly, make wide-scoped "fix everything about a feature set" reports, as 44398's title is, and your subsequent comment https://bugs.freedesktop.org/show_bug.cgi?id=44398#c2 . This makes a report less likely to be resolved quickly. However, this (43107) report is targeted, specific, and detailed. Please do not toggle this report further unless you are submitting a patch. Thank you.
In 3.5.7 rc1 or 3.6.2.2 use "\n\n" in the replace field. That works for me. Can you pls check that? (I remeber in the late OOo times there was a change in this, but can't find the details now). I intend to close this one soon
(In reply to comment #4) > In 3.5.7 rc1 or 3.6.2.2 use "\n\n" in the replace field. > That works for me. > Can you pls check that? In Calc 3.6.2.2 (Build ID: da8c1e6) on Windows 7 64-bit, if I - use "\n\n" (excluding quotes) in the replace field - Click Replace all Calc inserts those literal characters into the cell(s), not newline characters. Based on that I don't think this bug is fixed.
Using Version 3.6.3.2 on Mac OSX, \n is inserted as literal text (i.e., not as a newline) as well.
Version 3.6.5.2 (Build ID: 5b93205) on Linux. Same problem - neither \n nor \n\n work.
*** Bug 64144 has been marked as a duplicate of this bug. ***
Confirmed in 4.2.6.3 on Fedora (Build ID: 4.2.6.3-8.fc20).
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.