Read more

How to find and replace empty cells in Libre Office Calc

Emanuel
December 04, 2017Software engineer at makandra GmbH

To find and replace (CTRL + H) empty cells in Libre Office Calc you can use a regular expressions (also called "Finds an empty paragraph" in context of a spreadsheet):

Illustration online protection

Rails professionals since 2007

Our laser focus on a single technology has made us a leader in this space. Need help?

  • We build a solid first version of your product
  • We train your development team
  • We rescue your project in trouble
Read more Show archive.org snapshot

Screenshot_2017-12-04_11-07-04.png

It is also possible to just enter a regular expression in the search (CTRL + F), but there is no option to only search in the current selection like in the screenshot above. Use find and replace instead if needed.

Posted by Emanuel to makandra dev (2017-12-04 11:05)