Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
In an as yet unanswered Q from early this year a user of Stack Overflow asked: how to fill all non-empty cells of a column by 1 and the empty cells by 0. It's an xlsx file open with LibreOffice ...
#2: Post edited
by
Alexei
·
2020-11-01T06:58:30Z (over 3 years ago)
#1: Initial revision
by
pnuts
·
2020-10-15T00:34:44Z (over 3 years ago)
In a column, set populated cells to 1 and empty cells to 0
In an as yet unanswered [Q](https://stackoverflow.com/questions/59625747/libreoffice-calc-how-to-fill-all-non-empty-cells-of-a-column) from early this year a user of Stack Overflow asked: >how to fill all non-empty cells of a column by 1 and the empty cells by 0. It's an xlsx file open with LibreOffice Calc. Is this possible with a formula?