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.
1 answer
The following users marked this post as Works for me:
| User | Comment | Date |
|---|---|---|
| Wicket | (no comment) | Jun 22, 2023 at 00:21 |
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(†) 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.
† 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, Ctrl+Shift+Down and Yes.
0 comment threads
0 comment threads