In a LibreOffice spreadsheet, when I want to duplicate a cell's content, I use =<source coords>. For example if I want cell A2 to contain a duplicate of whatever is in A1, I fill in =A1 in A2.

Works fine for numbers, formulas, and text, except when a cell is empty. For some reason the duplicate cell then contains a number zero instead of empty. Apparently if a cell is empty, it enforces the content to be a number or something.



The second row are all copies of the first row. See that zero in C2, while C1 is empty?

How do I make an exact copy of a cell, regardless its type, so that a copy of an empty cell also remains empty?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.