<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Choosing Formula Syntax 'Excel A1' is not reflected in INDIRECT function for sheet references" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131653#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Choosing Formula Syntax 'Excel A1' is not reflected in INDIRECT function for sheet references" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131653">bug 131653</a> from <a class="email" href="mailto:richard.crozier@yahoo.co.uk" title="Richard <richard.crozier@yahoo.co.uk>"> Richard</a> <pre>No, indeed I haven't, in my defence, this is a pretty obscure setting! With this setting, it works, I note that this setting has an option 'Calc A1 | Excel A1' which worked for me and made all versions work in the example I attached earlier. It would be nice if this was the defualt, if there's no major technical reason not to. It would also be nice there was such an option in the other option (Tools -> Options -> LibreOffice Calc -> Formula -> Formula Options -> Formula Syntax) and that this option was the default setting. My final change to this report will be to switch it back to an enhancement request, for this.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>