Ask Your Question

Copying a sheet with relative reference formula also changes the "source" sheet into the formula. [closed]

asked 2015-01-23 20:18:44 +0200

ratrace gravatar image

updated 2020-08-11 14:24:06 +0200

Alex Kemp gravatar image


i'm using LibreOffice beta2 locale gr in win xp (sp3).


In the attached file when i'm trying to copy sheet 2 into the same spreadsheet and put it in the end of the document, the formula in the cell A1 of the new sheet is changing from,

=VLOOKUP(B1;Φύλλο1.A1:C4;2) to =VLOOKUP(B1;Φύλλο2.A1:C4;2)

Is this the right behavior? In a relative reference are sheets also changing or only the cells of the formula?

To copy the sheet i right click in the name of the sheet and choose move/copy...

  • "Φύλλο" in Greek means Sheet.


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-11 14:24:13.856236

1 Answer

Sort by » oldest newest most voted

answered 2015-01-23 20:43:23 +0200

erAck gravatar image

Also the sheet is a relative reference here, prefix it with a $ to make it an absolute reference when copying across sheets. =VLOOKUP(B1;$Φύλλο1.A1:C4;2)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-01-23 20:18:44 +0200

Seen: 145 times

Last updated: Jan 23 '15