[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.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from ThomasU <tnetter at gmail.com> ---
Created attachment 160313
  --> https://bugs.documentfoundation.org/attachment.cgi?id=160313&action=edit
Excel 2010 file with data added in Sheet2. Formulas then added in Sheet1 using
LO 7.0.0.0dev

Hi Eike,

Apologies for the late reply. Here's a spreadsheet where I entered data in
Sheet 2 using Excel 2010. I then used LibreOffice 7.0.0.0 dev in Linux to add
formulas in Sheet 1.
I did not touch the settings in Tools / Options / Formula / Details

Many thanks for your incredible work on LibreOffice.

-Thomas

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200504/47c8a4a7/attachment.htm>