7.1 Carriage return in Replace

Used to be a \n in the search and replace dialog Replace field would insert a carriage return… now it just inserts \n litterally… Suggestions?

Tick the box labelled Regular expressions

Yeah, since I was using regex in my search it is ticked… no joy.

Ah. I just realised it refers to Calc. \n doesn’t work in Calc in Replace field, see wiki

Carriage returns in cells can cause problems, e.g. if using Find and Replace it won’t search beyond the carriage return