[Libreoffice-bugs] [Bug 138646] The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name
https://bugs.documentfoundation.org/show_bug.cgi?id=138646 Andreas Heinisch changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |andreas.heini...@yahoo.de |desktop.org | Status|NEW |ASSIGNED -- 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 138646] The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name
https://bugs.documentfoundation.org/show_bug.cgi?id=138646 himajin100...@gmail.com changed: What|Removed |Added CC||er...@redhat.com --- Comment #6 from himajin100...@gmail.com --- https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/rangeutl.cxx?r=1da69081=MakeRangeFromName#279 https://opengrok.libreoffice.org/xref/core/sc/inc/rangenam.hxx?r=b49dada8#129 we can see from the GetSymbol's definition that the default value for the optional second parameter is formula::FormulaGrammar::GRAM_DEFAULT. This may be the culprit. -- 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 138646] The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name
https://bugs.documentfoundation.org/show_bug.cgi?id=138646 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- 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 138646] The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name
https://bugs.documentfoundation.org/show_bug.cgi?id=138646 --- Comment #5 from himajin100...@gmail.com --- https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/rangeutl.cxx?r=1da69081#295 https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/rangeutl.cxx?r=1da69081#309 -- 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 138646] The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name
https://bugs.documentfoundation.org/show_bug.cgi?id=138646 --- Comment #4 from himajin100...@gmail.com --- https://opengrok.libreoffice.org/xref/core/sc/source/ui/unoobj/cellsuno.cxx?r=1c027848#4758 -- 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 138646] The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name
https://bugs.documentfoundation.org/show_bug.cgi?id=138646 himajin100...@gmail.com changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #3 from himajin100...@gmail.com --- Confirmed. RuntimeException is thrown when I use either of "Excel A1" or "Excel R1C1" I put some SAL_INFO macros to see what's happening. Though I haven't looked the source closer, https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/address.cxx?r=1250aecd=ConvertSingleRef#1149 SAL_INFO("sc.core", OUString(p)); showed $Sheet1.$A$1 for "Calc A1", SAL_INFO("sc.core", OUString(p)); showed Sheet1!$A$1 for both "Excel A1" and "Excel R1C1". This can be problematic here, I guess. https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/address.cxx?r=1250aecd=ConvertSingleRef#1185 -- 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 138646] The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name
https://bugs.documentfoundation.org/show_bug.cgi?id=138646 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- 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 138646] The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name
https://bugs.documentfoundation.org/show_bug.cgi?id=138646 --- Comment #2 from Igor --- Created attachment 167840 --> https://bugs.documentfoundation.org/attachment.cgi?id=167840=edit Explains the error in detail -- 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 138646] The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name
https://bugs.documentfoundation.org/show_bug.cgi?id=138646 Igor changed: What|Removed |Added Keywords||needsDevAdvice -- 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 138646] The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name
https://bugs.documentfoundation.org/show_bug.cgi?id=138646 --- Comment #1 from Igor --- Created attachment 167807 --> https://bugs.documentfoundation.org/attachment.cgi?id=167807=edit Explains the error in detail Everything is clear -- 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