[Libreoffice-bugs] [Bug 106193] Erroneus Formula calculation containing INDIRECT(ADDRESS()), ending in error value
https://bugs.documentfoundation.org/show_bug.cgi?id=106193 Johnny_M changed: What|Removed |Added Resolution|FIXED |NOTABUG -- 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 106193] Erroneus Formula calculation containing INDIRECT(ADDRESS()), ending in error value
https://bugs.documentfoundation.org/show_bug.cgi?id=106193 --- Comment #6 from m.a.riosv --- There was a great effort from devs to achieve compatibility ways for INDIRECT(). The better compatibility it's avoiding INDIRECT() whenever it's possible, besides it is a volatile function, used massively can slow down the spreadsheet. -- 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 106193] Erroneus Formula calculation containing INDIRECT(ADDRESS()), ending in error value
https://bugs.documentfoundation.org/show_bug.cgi?id=106193 Jesús Alonso changed: What|Removed |Added Resolution|NOTABUG |FIXED --- Comment #5 from Jesús Alonso --- thanks a lot!! it was driving me crazy I really appreciate your help, I didn't know there were so many options with such an impact on results -- 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 106193] Erroneus Formula calculation containing INDIRECT(ADDRESS()), ending in error value
https://bugs.documentfoundation.org/show_bug.cgi?id=106193 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #4 from m.a.riosv --- The issue is with the option in: Menu/Tools/Options/LibreOffice calc/Formula - Detailed Calculation Settings - Custom - Details - Reference syntax for string reference. It is with your file 'Excel A1', so C2 having 'Calc A1' reference gives an error, change it to 'Calc A1 | Excel A1" and all formulas work fine. -- 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 106193] Erroneus Formula calculation containing INDIRECT(ADDRESS()), ending in error value
https://bugs.documentfoundation.org/show_bug.cgi?id=106193 --- Comment #3 from Jesús Alonso --- Created attachment 131471 --> https://bugs.documentfoundation.org/attachment.cgi?id=131471&action=edit Check cell C2 in sheet Hoja2 Please check C2 in sheet Hoja2 -- 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 106193] Erroneus Formula calculation containing INDIRECT(ADDRESS()), ending in error value
https://bugs.documentfoundation.org/show_bug.cgi?id=106193 --- Comment #2 from Jesús Alonso --- The file in which I noticed the problem is an Microsoft Excel file with extension XLSX. I have tried to create a simple example file created from scratch with LibreOffice Calc and it seems to work just fine. Right now I do not have accessto Microsoft Office to try to create a simple example with it, so I will try to create a simplified version of the file I observed this behaviour with. -- 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 106193] Erroneus Formula calculation containing INDIRECT(ADDRESS()), ending in error value
https://bugs.documentfoundation.org/show_bug.cgi?id=106193 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #1 from m.a.riosv --- Created attachment 131470 --> https://bugs.documentfoundation.org/attachment.cgi?id=131470&action=edit Test Address+Indirect There are two places where to set up formula syntax: - Menu/Tools/Options/LibreOffice calc/Formula - Formula Option - Formula syntax. - Menu/Tools/Options/LibreOffice calc/Formula - Detailed Calculation Settings - Custom - Details - Reference syntax for string reference. With both as 'Calc A1' results look ok. Attached a sample file that looks ok for me. -- 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