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
An easy way (in LibreOffice Calc 5.4.3.2) is not to attempt directly to overwrite what is already present but to create the desired results with a formula in a different column, then replace the co...
Answer
#3: Post undeleted
by
Alexei
·
2021-05-26T18:08:58Z (over 3 years ago)
#2: Post deleted
by
pnuts
·
2021-05-24T06:39:32Z (over 3 years ago)
#1: Initial revision
by
pnuts
·
2020-10-15T00:36:21Z (about 4 years ago)
An easy way (in LibreOffice Calc 5.4.3.2) is not to attempt directly to overwrite what is already present but to create the desired results with a formula in a different column, then replace the contents of the original column with the values (not formulae) from the added column.
Assuming the data is in ColumnA, insert a new ColumnB and in B1 and copied down(<sup>†</sup>) to suit:
=IF(ISBLANK(A1),0,1)
then select ColumnB, Edit > Copy, select ColumnA, Edit > Paste Only > Paste Only Numbers. Now ColumnB may be deleted.
The sheet may be saved with an `xlsx` extension.
<sup>†</sup> Double-clicking the fill handle won't work here (because of the blank cells). Instead either drag down to suit or, if very many cells, go to the last cell to be populated and enter something there (say `x`) then return to B1, Copy, select B2, <kbd>Ctrl</kbd>+<kbd>Shift</kbd>+<kbd>Down</kbd> and <kbd>Yes</kbd>.