I have recently moved to LibreOffice from MS Excel. A feature/tool I use a lot is "Go to - Special - Blanks". Unfortunately this tool is not available on LibreOffice (or I just can't find it). Could you please add this in future versions. Many thanks. Kind regards.
Added UX-team for discussion
What exactly is your use case and how does this function solves it?
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.
Created attachment 185362 [details] Screenshot MSO However, having this "Go To Special" dialog provides some more nice solutions. Like detecting values/constants vs. formulas, checking references and differences, etc. It is kind of a shortcut to the F&R_Find-All functionality.
We discussed the topic in the design meeting. The Go-To-Special dialog is a nice shortcut to many typical search operations such as Blanks, Formulas, References etc. I would name it differently, maybe "Quick Search", and place the button to start this dialog at the quick find toolbar. Could be an interesting GSoC project.