* Create a blank sheet
* Double-click on a cell to inline-edit it
* Enter two-line content (e.g. "first line", <Ctrl>-<Enter>, "last line") and hit <Enter>
* Open find/replace (Ctrl-H)
* Expand "other options" and tick "regular expressions"
* In find, enter "\n" without quotation marks
* In replace, enter "\nmiddle line\n"
* Click "Replace all"
> does anyone have a test document
You can't reproduce?
Steps:
* Create a blank sheet
* Double-click on a cell to inline-edit it
* Enter two-line content (e.g. "first line", <Ctrl>-<Enter>, "last line") and hit <Enter>
* Open find/replace (Ctrl-H)
* Expand "other options" and tick "regular expressions"
* In find, enter "\n" without quotation marks
* In replace, enter "\nmiddle line\n"
* Click "Replace all"
Expected:
* Cell contains three lines: "first line", "middle line", "last line"
Actual:
* Cell contains one line: "first line\nmiddle line\nlast line" (literal string)