Shahar Or, thank you for reporting this and helping make Ubuntu better. In order to have \n treated as a new line, one must click the "More Options" button -> check "Regular expressions". Thank you for reporting this and feel free to report any future bugs you may find.
** Changed in: libreoffice (Ubuntu) Status: New => Invalid -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/892476 Title: "\n" in replace field of Calc's search and replace is treated as text Status in LibreOffice Productivity Suite: Unknown Status in “libreoffice” package in Ubuntu: Invalid Bug description: In Calc's search and replace feature, entering "\n" in the replace field is treated as regular text. It would be useful to use "\n" for new line in Calc. ProblemType: Bug DistroRelease: Ubuntu 11.10 Package: libreoffice-calc 1:3.4.3-3ubuntu2 ProcVersionSignature: Ubuntu 3.0.0-12.20-generic 3.0.4 Uname: Linux 3.0.0-12-generic x86_64 ApportVersion: 1.23-0ubuntu4 Architecture: amd64 Date: Sat Nov 19 13:02:28 2011 EcryptfsInUse: Yes InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007) SourcePackage: libreoffice UpgradeStatus: Upgraded to oneiric on 2011-10-16 (34 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/892476/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp