Ask Your Question
0

Copy / Paste not following structure

asked 2016-12-02 03:24:46 +0200

Daniel O'Brien gravatar image

(CALC)

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?

Thanks

Dan

edit retag flag offensive close merge delete

Comments

I should include Version 5.2.2.2, Ubuntu-gnome

Daniel O'Brien gravatar imageDaniel O'Brien ( 2016-12-02 03:26:02 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-09-16 00:55:24 +0200

LeroyG gravatar image

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 6.3.6.2 (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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-12-02 03:24:46 +0200

Seen: 31 times

Last updated: Sep 16