[Solved] Find and replace applied only to filtered cells

Discuss the spreadsheet application
Post Reply
ptbento
Posts: 45
Joined: Fri Jan 18, 2013 9:33 pm

[Solved] Find and replace applied only to filtered cells

Post by ptbento »

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
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Find and replace applied only to filtered cells

Post by Villeroy »

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
ptbento
Posts: 45
Joined: Fri Jan 18, 2013 9:33 pm

Re: Find and replace applied only to filtered cells

Post by ptbento »

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
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Post by Villeroy »

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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Post by RoryOF »

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.15 on Xubuntu 22.04.4 LTS
ptbento
Posts: 45
Joined: Fri Jan 18, 2013 9:33 pm

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

Post by ptbento »

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
Post Reply