Ask Your Question
0

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

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

ratrace gravatar image

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

Alex Kemp gravatar image

Hello,

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

bug.ods

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.

Thanks

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
0

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

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

Stats

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

Seen: 139 times

Last updated: Jan 23 '15