In Calc, when I copy a merged cell containing a date, and paste it in another document, how do I keep the date ‘number’ format but not the ‘merged’ part of the format (i.e. paste in single cell so I don’t have to un-merge it every time)?
Choose menu Edit - Paste Special - Paste Unformatted Text (the same that Ctrl+Shift+Alt+V).
It do you choose menu Edit - Paste Special - Paste Special… (the same that Ctrl+Shift+V or Insert), and OK,¹ you will get the serial number of that date. But if also checks Formats you will get the “‘merged’ part of the format”.
¹ Provided that by default Text, Numbers and Date & time are checked.
More LibreOffice Help on Paste Special.
Tested with LibreOffice 6.3.6.2 (x86); OS: Windows 6.1
Add Answer is reserved for solutions.
Press edit below your question if you want to add more information; also can comment an answer.
Check the mark (
) to the left of the answer that solves your question.