[Solved] Find and replace applied only to filtered cells

Discuss the spreadsheet application

[Solved] Find and replace applied only to filtered cells

Postby ptbento » Tue Dec 03, 2019 5:33 pm

It seems that when one applies find and replace to a filtered range it finds and replaces in all cells, not only on visible ones. How could one have Calc to find and replace only in visible cells?
Last edited by Hagar Delest on Tue Dec 03, 2019 7:24 pm, edited 2 times in total.
Reason: tagged solved
OpenOffice 3.4.1 on Windowx XP
ptbento
 
Posts: 37
Joined: Fri Jan 18, 2013 9:33 pm

Re: Find and replace applied only to filtered cells

Postby Villeroy » Tue Dec 03, 2019 7:04 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27373
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Find and replace applied only to filtered cells

Postby ptbento » Tue Dec 03, 2019 7:14 pm

Thank you. LO does not work in my Windows XP so I will stick to the old expedient of going back to Excel for the task above (but will keep using the wonderful regular expressions features in OO filter!).
OpenOffice 3.4.1 on Windowx XP
ptbento
 
Posts: 37
Joined: Fri Jan 18, 2013 9:33 pm

Re: [Solved] Find and replace applied only to filtered cells

Postby Villeroy » Tue Dec 03, 2019 9:42 pm

LO 5.4.7 of 2018 is the last version for Windows XP. That was a good version. Much better than anything AOO has to offer.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27373
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Find and replace applied only to filtered cells

Postby RoryOF » Tue Dec 03, 2019 9:46 pm

This is nearly, but not quite, Off Topic. A clean room replacement for Windows is called ReactOS. It comes in 32 and 64 bit versions and can be tried from a live DVD. I haven't tried it.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29870
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Solved] Find and replace applied only to filtered cells

Postby ptbento » Thu Dec 05, 2019 12:15 pm

Thank you very much Villeroy amd RoryOF for your comments. I will definitely try to install LO 5.4.7 and take a look at ReactOS.
OpenOffice 3.4.1 on Windowx XP
ptbento
 
Posts: 37
Joined: Fri Jan 18, 2013 9:33 pm


Return to Calc

Who is online

Users browsing this forum: Majestic-12 [Bot] and 12 guests