Calc find/replace with carriage return bug?

Discuss setup / installation issues - Add a spell checker, Language pack?

Calc find/replace with carriage return bug?

Postby smithsj » Wed Feb 27, 2019 11:44 pm

Hi all,

I'm trying to find something (a pipe buffered by two spaces), and replace it with a simple carriage return. What I'm doing is opening Find & Replace, entering the escaped pipe (backslah, then pipe) into the "Search for" box, entering a space, a backslash, an 'n', and then a space into the "Replace with" box, and then going into More Options and checking "Regular expressions." When I do this, it correctly identifies what I want to find, but it replaces them all with a backslash and then an n! What's weird about it is when I replace the n with a t, it replaces everything with a tab, as it should. Just not when I try to replace it with a carriage return. What is going on here?? Is it a bug (I had an older version of OpenOffice, but I just updated it and it's still happening), or am I missing something?

It's driving me nuts!

Thanks,
Stephen
OpenOffice 4.1.6 on MacOS 10.12.6
smithsj
 
Posts: 3
Joined: Wed Feb 27, 2019 11:38 pm

Re: Calc find/replace with carriage return bug?

Postby floris v » Thu Feb 28, 2019 12:27 am

AOO 4.1.6 op Linux Mint
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 4203
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Calc find/replace with carriage return bug?

Postby smithsj » Thu Feb 28, 2019 12:36 am

I'll try that, but everybody else seems to be able to get the \n thing to work...why can't I?
OpenOffice 4.1.6 on MacOS 10.12.6
smithsj
 
Posts: 3
Joined: Wed Feb 27, 2019 11:38 pm

Re: Calc find/replace with carriage return bug?

Postby RoryOF » Thu Feb 28, 2019 12:37 am

On the Find and Replace Window drop More Options and select Regular Expressions
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31209
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc find/replace with carriage return bug?

Postby floris v » Thu Feb 28, 2019 12:38 am

It may not work in Calc, on purpose.
AOO 4.1.6 op Linux Mint
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 4203
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Calc find/replace with carriage return bug?

Postby smithsj » Thu Feb 28, 2019 12:40 am

RoryOF – as I said in my original post, I did that.
Floris V – I do believe I've gotten this to work in the past. And other people seem to have gotten it to work. Could somebody check on their version and see if it does?
OpenOffice 4.1.6 on MacOS 10.12.6
smithsj
 
Posts: 3
Joined: Wed Feb 27, 2019 11:38 pm


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: No registered users and 7 guests