<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - 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." href="https://bugs.documentfoundation.org/show_bug.cgi?id=132519#c10">Comment # 10</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - 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." href="https://bugs.documentfoundation.org/show_bug.cgi?id=132519">bug 132519</a> from <a class="email" href="mailto:tnetter@gmail.com" title="ThomasU <tnetter@gmail.com>"> ThomasU</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=160313" name="attach_160313" title="Excel 2010 file with data added in Sheet2. Formulas then added in Sheet1 using LO 7.0.0.0dev">attachment 160313</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=160313&action=edit" title="Excel 2010 file with data added in Sheet2. Formulas then added in Sheet1 using LO 7.0.0.0dev">[details]</a> 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</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>