Copy/Paste From One Sheet to Another

[Kitfox]

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.

[ve3oat]

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?

[LeroyG]

See https://ask.libreoffice.org/en/answers/266344/. Not valid now, original poster may have deleted the question with all answers and comments. Sorry.

EDIT: See that your formulas don’t have an absolute sheet address, like =SUM($Sheet1.A1:A2). Remove the $ before the sheet name, like
=SUM(Sheet1.A1:A2).