[Libreoffice-bugs] [Bug 131653] Choosing Formula Syntax 'Excel A1' is not reflected in INDIRECT function for sheet references
https://bugs.documentfoundation.org/show_bug.cgi?id=131653 --- Comment #5 from Richard --- 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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131653] Choosing Formula Syntax 'Excel A1' is not reflected in INDIRECT function for sheet references
https://bugs.documentfoundation.org/show_bug.cgi?id=131653 m.a.riosv changed: What|Removed |Added Ever confirmed|0 |1 CC||miguelangelrv@libreoffice.o ||rg Status|UNCONFIRMED |NEEDINFO --- Comment #4 from m.a.riosv --- Have you set up properly, Menu/Tools/Options/LibreOffice calc/Formula - Detailed calculation settings - Reference syntax for string references. -- 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
[Libreoffice-bugs] [Bug 131653] Choosing Formula Syntax 'Excel A1' is not reflected in INDIRECT function for sheet references
https://bugs.documentfoundation.org/show_bug.cgi?id=131653 --- Comment #3 from Richard --- Created attachment 159107 --> https://bugs.documentfoundation.org/attachment.cgi?id=159107=edit Calc document demonstrating the issue -- 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
[Libreoffice-bugs] [Bug 131653] Choosing Formula Syntax 'Excel A1' is not reflected in INDIRECT function for sheet references
https://bugs.documentfoundation.org/show_bug.cgi?id=131653 V Stuart Foote changed: What|Removed |Added Ever confirmed|1 |0 Status|REOPENED|UNCONFIRMED -- 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
[Libreoffice-bugs] [Bug 131653] Choosing Formula Syntax 'Excel A1' is not reflected in INDIRECT function for sheet references
https://bugs.documentfoundation.org/show_bug.cgi?id=131653 Richard changed: What|Removed |Added Severity|enhancement |normal -- 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
[Libreoffice-bugs] [Bug 131653] Choosing Formula Syntax 'Excel A1' is not reflected in INDIRECT function for sheet references
https://bugs.documentfoundation.org/show_bug.cgi?id=131653 Richard changed: What|Removed |Added Summary|Choosing Formula Syntax |Choosing Formula Syntax |'Excel a1' is not reflected |'Excel A1' is not reflected |in INDIRECT function|in INDIRECT function for ||sheet references -- 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
[Libreoffice-bugs] [Bug 131653] Choosing Formula Syntax 'Excel a1' is not reflected in INDIRECT function
https://bugs.documentfoundation.org/show_bug.cgi?id=131653 Richard changed: What|Removed |Added Summary|Support exclamation mark|Choosing Formula Syntax |for referenced to cells on |'Excel a1' is not reflected |another sheet for Excel |in INDIRECT function |compatibility. | -- 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