https://bugs.freedesktop.org/show_bug.cgi?id=52600
Bug #: 52600
Summary: Excel Visual Basic code compatibility issue in
LibreOffice Calc: Inserted Calc formula with Excel
Visual Basic Code
Classification: Unclassified
Product: LibreOffice
Version: 3.5.5.3 release
Platform: x86 (IA32)
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 64802
--> https://bugs.freedesktop.org/attachment.cgi?id=64802
Excel test file with macro
Inserted formulas per Excel Visual Basic code are not converted with the right
formula separator symbol on Windows systems with other regional settings.
Example Windows "Regional and Language Options": "German (Germany)"
with Formula/List Separator ';' and Decimal Symbol ','
Example:
Create in Excel a macro with the following code, set up the Windows regional
and language options to "German (Germany)" and try to run this macro inside
LibreOffice Calc:
Sub Test_Insert_Formula()
' Preparing Test:
Range("A1").FormulaR1C1 = "3"
Range("C1").FormulaR1C1 = "4"
Range("B1").Select
' Testing Excel VBA Code in Libre Office:
Cells(1, 2).FormulaR1C1 = "=IF(RC[-1]>RC[1],""greater than"",""less
than"")"
End Sub
If the system formula delimiter symbol is set to ";" it should be inserted:
=IF(A1>C1;1;0)
instead of
=IF(A1>C1,1,0)
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
