Basic Task: Move (cut/paste) the contents from cell A to cell B while maintaining some sort sort of default formatting in cell A. This is typically just a font-face/size combination; nothing more. Let’s assume I’m using Noto Sans 12.
What happens: The formatting in cell A resets to Liberation Sans 10. Presumably this would affect other “default” formatting traits I’d like to keep.
The workarounds: I can copy the contents from cell A to cell B, then go back and press the delete key on cell A. That does not reset the font formatting. I can also just perform a series of moves, and then re-format the entire document to Noto Sans 12. Neither of these is ideal.
What I’d like to be able to do: Change the default (fallback?) font of Calc either system-wide, or at least on a per-document level so that cut/paste is not such a chore. For the record, I’ve already tried using a template with the desired formatting on the entire sheet, but ran into the same issue.
It seems like this should be possible, but I’m hoping this community can help me out.