[Libreoffice-bugs] [Bug 132519] CELL("ADDRESS"; ...) to other sheet from Workbook imported from Excel may let INDIRECT() fail with #REF! if string reference setting forces different syntax than current formula syntax (comment 9).

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=132519

--- Comment #11 from Eike Rathke <er...@redhat.com> ---
Late, but.. I do not see anything wrong with the attached document in itself.
It has

      <loext:extCalcPr stringRefSyntax="CalcA1"/>

and according to that the correct reference string for INDIRECT() is
"$Sheet2.A1".

If (both in LO 7.0.0 and 7.4.x) I load a .xlsx created by Excel and save it
again it gets

      <loext:extCalcPr stringRefSyntax="ExcelA1"/>

just as expected, and for that document can be seen under
Tools/Options/Calc/Formula/Details as well.

So however your document ended up with CalcA1 instead of ExcelA1 if you didn't
touch that option I don't know.

-- 
You are receiving this mail because:
You are the assignee for the bug.