[Libreoffice-ux-advise] [Bug 149933] Editing:- Feature Request "go to - special" feature needed

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=149933

--- Comment #3 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
Received this per direct email:

Hello,
​
​When I have a large spreadsheet with many blank cells dispersed though
numerous columns & rows (some contiguous with each other & others separate &
isolated). I want to select all the blank cells, so I can paste a formula to
fill in the blanks. So I can then use the spreadsheet to create a pivot table.
I have searched Libreoffice help (& google) & I can not find a way to select
all the blank cells (which are not contiguous) in a spreadsheet table. I think
a go to special feature (such as exists in MS Excel) would be a great solution.
​
​Kind Regards
​Noel

And my reply: Rather than implementing special functions for every scenario we
should take the generic approach. And in this case it is the Find & Replace
dialog that can be used to search for empty cells (leave Find empty but insert
something at Replace and use Find All) or to replace the empty cells with some
other value.

-- 
You are receiving this mail because:
You are on the CC list for the bug.