[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