In my OpenOffice spreadsheet, there are cells containing "\n" text.
Each "\n" occurrence needs to be replaced with a new line or line break.
The Find-and-Replace dialog does offer regular expressions when searching. So I can find them using \n but when the replacement is set to \n it replaces the occurrence with the text "\n" instead of a new line.
How can one Find-and-Replace a text into a new line?