https://bugs.documentfoundation.org/show_bug.cgi?id=149933
--- Comment #3 from Heiko Tietze <[email protected]> --- 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 the assignee for the bug.
