I recently updated from version 5.2.7 to version 6.1.5 (as a result of going to a new Devuan release). One behavior in Calc changed that I’m finding extremely annoying.
Previously, if I had a formula I wanted to copy to a whole bunch of cells, I’d copy (CTRL-C) in the cell with the formula, select the range of cells I wanted to get the formula (with relative references updated), and paste (CTRL-V). It worked fine.
Now, I can only paste to one cell at a time. If I copy a formula from one cell, and then paste to a range, it treats it like a text import; the resulting cells get just numbers, not the formula. I have a similar problem when I try “Paste Special” and select formula.
Again, it works if I copy from one cell and paste to another; the formula copies over as selected. I just can no longer copy one formula to a range of cells, the way i was previously able to with LibreOffice 5.2
Is there a setting somewhere that can restore the previous behavior? This current behavior is driving me nuts.