As described in here when doing copy and past in
Office Calc, all the formatting is moved from the source cell to the target cell too. Including Frames and cell background color.
This mentioned thread is 10 years old, maybe there is now a workaround.
I'm looking for a way of either lock the format settings of a cell or to do an one click action to insert without destroying the layout of my spread sheet.
The in the thread suggested solution is to hit Ctrl+Shift+V which opens an additional context menu where you can select what to insert. I would like to have a permanent option.