Copy / Paste not following structure


If I highlight cell A1 , C1 and F1 and want to copy the formulas or whatever to A2, C2 and F2 I usually just highlight the 3 cells then I go to B1 and COPY but for some reason it doesn’t put them in the right place. it puts them in A2,B2 and C2.

Any Idea why that would be?



I should include Version, Ubuntu-gnome

Calc is programmed to do this way. Thus, you can group (via copy and paste) data from ranges that share the same rows or the same columns.

If the content of B1, D1 and E1 are no formulas, you can select from A1 to F1, copy, choose menu Edit - Paste Special - Paste Special… (the same that Ctrl+Shift+V), check Formulas and Add, and press Enter.

Paste Special - Add - Formulas

Done with LibreOffice (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 (Correct answer mark) to the left of the answer that solves your question.