Description: In this page: https://help.libreoffice.org/Common/List_of_Regular_Expressions see at the cell containing \n and it states: Represents a line break that was inserted with the Shift+Enter key combination. To change a line break into a paragraph break, enter \n in the Find and Replace boxes, and then perform a search and replace. \n in the Find text box stands for a line break that was inserted with the Shift+Enter key combination. \n in the Replace text box stands for a paragraph break that can be entered with the Enter or Return key. In LibreOffice Calc, doing this DOESN'T add a paregraph break, but inserts the \n instead (as visually inserted). Actual Results: Doesn't replace line feeds with paragraphs Expected Results: Must to do as in help page Reproducible: Always User Profile Reset: No Additional Info:
- open new calc document - enter text in cell A1: Hello (ctrl)+(enter) (line break) World - open search & replace dialog - seach for \n (with enabled regular expressions) - replace with X - result: HelloXWorld IMHO calc has no paragraph breaks at all, so exchanging linefeeds with paragraphs is not possible.
Changing this to Documentation...
If the documentation is updated, this bug doesn't appear anymore :-)