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

Mon, 04 May 2020 03:04:22 -0700 

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

--- Comment #10 from ThomasU <tnet...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to