[Libreoffice-bugs] [Bug 141543] New: VBA Range.Formula and Range.FormulaR1C1 properties use localized formula expressions

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 141543
           Summary: VBA Range.Formula and Range.FormulaR1C1 properties use
                    localized formula expressions
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: erack at redhat.com

The VBA compatibility Range.Formula and Range.FormulaR1C1 properties wrongly
use localized formula expressions as if they were Range.FormulaLocal and
Range.FormulaR1C1Local.

Instead, they should use English formula expressions and separators, and
additionally Range.FormulaLocal and Range.FormulaR1C1Local be implemented.

For an example see discussion in bug 128334 comment
https://bugs.documentfoundation.org/show_bug.cgi?id=128334#c9 and following,
and attachment there
https://bugs.documentfoundation.org/attachment.cgi?id=170966

Additional pointers to MS documentation in https://stackoverflow.com/a/35724386

-- 
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/20210407/ee32489e/attachment-0001.htm>