EDIT: this problem was due to a too old version of LibreOffice (< v7.1). It was solved by upgrading to the latest version.
Let’s imagine a workbook with two sheets: Sheet1 and Sheet2.
In cell A1 of Sheet1, I place the value 12.
I give the name result to cell A1 of Sheet1 with a limited scope to Sheet1.
-
In one cell of
Sheet1, I place the formula=INDIRECT("result").
The result is as expected:12.
Perfect! -
In one cell of
Sheet2, I place the formula=INDIRECT("Sheet1.A1").
The result is as expected:12.
Perfect! -
In one cell of
Sheet2, I place the formula=INDIRECT("result").
The result is:# REF !.
I guess this is normal because I am no longer in the scope of Sheet1. -
In one cell of
Sheet2, I place the formula=INDIRECT("Sheet1.result").
The result is:# REF !.
Damn, why doesn’t this work? How can I address the name of a cell in another sheet?
I couldn’t detail here everything I tried.
I followed tutorials for Excel (like this). Nothing works.
Does Calc have any shortcomings on this point compared to Excel?
Thanks in advance for your help
*Note: limiting the cell name range to the sheet is non-negotiable as I want to have the same name in different sheets.