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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs