[Libreoffice-bugs] [Bug 52600] New: Excel Visual Basic code compatibility issue in LibreOffice Calc: Inserted Calc formula with Excel Visual Basic Code
bugzilla-daemon at freedesktop.org
bugzilla-daemon at freedesktop.org
Fri Jul 27 21:41:34 CEST 2012
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: libreoffice-bugs at lists.freedesktop.org
ReportedBy: Tor24_1975314 at t-online.de
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.
More information about the Libreoffice-bugs
mailing list