Ask Your Question

Libre calc - insert line or paragraph break in text cell

asked 2019-02-01 06:22:56 +0100

goldofthesun gravatar image

updated 2019-02-01 06:35:01 +0100

I'd like to insert a line or paragraph break inside a cell that has text using regular expression (which I'm new to).

eg. From: Reference Lidia

To: Reference Lidia

I've tried the following (with regular expression box ticked), none have worked:

*Find: Reference

Replace: Reference \n* and Replace: Reference \n\n

What am I missing?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-01 18:54:41 +0100

Grantler gravatar image

updated 2019-02-01 18:56:05 +0100

It's not possible by Find&Replace, see some topics like that:

LO documentation writes:

Using '\n' in the 'Replace with' box will replace with the literal characters '\n', not a hard line break.

Macro? - Or use a formula containing char(10) for linefeed, see above first link...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-01 06:22:56 +0100

Seen: 139 times

Last updated: Feb 01 '19