The problem is that Calc seems to have two modes: sometimes the paste replaces whatever is in the cell I click on; other times, Calc inserts new cells to make room and the cells below are pushed down. The second mode (insert) often disrupts my sheets where they contain data in rows: shifting one column down destroys the row integrity.
The mode switch seems to happen randomly while I'm working with Calc: all of a sudden a paste starts shifting cells. I don't know what's causing it to switch but I'd very much like to avoid it or somehow switch back to replace mode.
I've tried Paste Special and ticked the "move cells down" option--that doesn't seem to trigger the mode switch. Same for Insert > Cells ...
Any other ideas? Some other setting that might affect this behavior?
Edit: PS: |