Ask Your Question

I want to link a cell on sheet 2 (in calc) and populate it with a value from sheet 1 [closed]

asked 2017-04-28 13:40:47 +0100

peter ridgley gravatar image

updated 2017-04-28 14:58:47 +0100

Have used the example =Sheet1!C45 ? given (with and without the query) and get err 509 or #NAME?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by peter ridgley
close date 2017-04-30 08:22:27.927695


Hello peter, you could try "Sheet1.C45"

librebel gravatar imagelibrebel ( 2017-04-28 15:17:45 +0100 )edit

Where did you get the example from? It's Excel style.

Lupp gravatar imageLupp ( 2017-04-28 15:25:34 +0100 )edit

Lupp, I got that from the Libre Wiki Librebel, thta just enters text into the cell in sheet 2

peter ridgley gravatar imagepeter ridgley ( 2017-04-28 20:48:03 +0100 )edit

sorry, try "=Sheet1.C45" ( with the "=" in front)

librebel gravatar imagelibrebel ( 2017-04-28 21:19:40 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-04-29 00:16:05 +0100

m.a.riosv gravatar image

Maybe the issue is in relation with the formula configuration, =Sheet1!C45 is an excel syntax.

Menu/Tools/Options/LibreOffice Calc/Formula syntax

edit flag offensive delete link more

answered 2017-04-29 17:16:12 +0100

librebel gravatar image

hello peter,

1) place the cursor into your cell on Sheet 2
2) type "=Sheet1.C45" (without the quotes) and press Enter
edit flag offensive delete link more


Librebel, you are a genius, it WORKS. As always, I was looking for a too complicated a formula ! So easy for me to do so Thank you so much........ Pete

peter ridgley gravatar imagepeter ridgley ( 2017-04-29 17:37:45 +0100 )edit

you're welcome:)

librebel gravatar imagelibrebel ( 2017-04-29 17:48:27 +0100 )edit

Question Tools

1 follower


Asked: 2017-04-28 13:40:47 +0100

Seen: 57 times

Last updated: Apr 29 '17