Have used the example =Sheet1!C45 ? given (with and without the query) and get err 509 or #NAME?
Hello peter, you could try “Sheet1.C45”
Where did you get the example from? It’s Excel style.
Lupp, I got that from the Libre Wiki
Librebel, thta just enters text into the cell in sheet 2
sorry, try “=Sheet1.C45” ( with the “=” in front)
Maybe the issue is in relation with the formula configuration, =Sheet1!C45 is an excel syntax.
Menu/Tools/Options/LibreOffice Calc/Formula syntax
hello peter,
1) place the cursor into your cell on Sheet 2
2) type "=Sheet1.C45" (without the quotes) and press Enter
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
you’re welcome:)