Page 1 of 1

[Solved] Find and replace applied only to filtered cells

PostPosted: Tue Dec 03, 2019 5:33 pm
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?

Re: Find and replace applied only to filtered cells

PostPosted: Tue Dec 03, 2019 7:04 pm
by Villeroy

Re: Find and replace applied only to filtered cells

PostPosted: Tue Dec 03, 2019 7:14 pm
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!).

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

PostPosted: Tue Dec 03, 2019 9:42 pm
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.

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

PostPosted: Tue Dec 03, 2019 9:46 pm
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.

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

PostPosted: Thu Dec 05, 2019 12:15 pm
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.