I noticed what I think must be a bug with LibreOffice Calc, here comes the fact:
1) I'm using Version 184.108.40.206
2) I went to Menu "Tools" > "Options", then "Libre Office Calc" > "Formula" and set "Formula syntax" to "Excel A1" so to make my formulas more compliant to Excel "default form" changing "." to "!" for worksheets reference separator (that means "Sheet1.A1" will become "Sheet1!A1").
3) I then put in A1 the formula: "=ADDRESS(1,1,,,"Sheet1")" and I expected something like "Sheet1!A1" as result BUT what I get is "Sheet1.$A$1" (the . is not converted to ! despite having set "Excel A1" on formula syntax) !!!
Katarina: noticing your last commits (eg: http://cgit.freedesktop.org/libreoffice/core/commit/?id=2bfeabde75d1e99879465fee6fe6a97357739ae2), thought you might be interested in this one.
I didn't test but your patches didn't seem specific to INDIRECT function. In this case you'd have been killed 2 birds with one stone here, no?
I updated LibreOffice version since this bug, I originally reported for release 220.127.116.11 is still present in 18.104.22.168 release.
I updated LibreOffice version for this bug, I originally reported for release 22.214.171.124, is still present in 126.96.36.199 release.
I updated LibreOffice version for this bug, I originally reported for release 188.8.131.52, is still present in 184.108.40.206 release.
Shall someone, please, remove my 2 previous comment? Thank you.
(In reply to danicotra from comment #4)
> I updated LibreOffice version for this bug, I originally reported for
> release 220.127.116.11, is still present in 18.104.22.168 release.
> Shall someone, please, remove my 2 previous comment? Thank you.
Version field corresponds to the earliest LO version where the bug is present.
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":
Resolves: tdf#93415 use proper sheet separator in ADDRESS A1 notation
It will be available in 5.3.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.