[Libreoffice-bugs] [Bug 131653] Choosing Formula Syntax 'Excel A1' is not reflected in INDIRECT function for sheet references

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Richard <richard.crozier at yahoo.co.uk> ---
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.

-- 
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/20200329/e694a836/attachment.htm>