Copy/Paste From One Sheet to Another

asked 2018-03-18 21:11:15 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have a Budget spreadsheet that I have been using for years in Excel. There is a separate sheet for each month. With Excel I would create the first month and then copy the entire sheet and paste it to the other 11 sheets. I then could tweak each month as needed.

I created this years Budget spreadsheet the same way with Calc. Unfortunately I have discovered that each months formulas are pointing at January's fields instead of being relative to the individual months. Kind of messed me up since the balances are obviously wrong.

Is there a way to copy/paste the sheet without it including the reference to the original sheet in the new sheet?

Also, when I tried copying the individual fields I have found that if I press enter after the copy, it wipes out copy buffer and I have to select and copy the value again. This doesn't make sense.

edit retag flag offensive close merge delete

Comments

I could not reproduce your copy/paste problem. When I paste using Paste-Special (formulas + formats) the pasted contents contain no reference to the original sheet, maybe because cells in the original sheet contain no references to their sheet. Do your cells contains references to the sheet?

ve3oat gravatar imageve3oat ( 2018-03-21 01:43:27 +0100 )edit