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

            Bug ID: 102076
           Summary: Excel XLSM import: VBA compatibility mode
                    insufficient: "EVALUATE" not supported
           Product: LibreOffice
           Version: 5.2.1.2 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Item related to the same file as bug 102075, namely attachment 127275 [details]
[Excel XLSM file (XLS with macros)]

LibreOffice's VBA support stumbles over MSO's VBA function

   If Evaluate("EXACT(Zeiten!" & colNo2 & "6,"""")") Then Exit Do

EVALUATE is supposed to yield the same result as entering the this for a cell
(with prefix "="), e.g. "=EXACT(Zeiten!A6)" as cell value.

Current result:
  Error box with:
    BASIC runtime error.
    '1'
    Type: com.sun.star.uno.RuntimeException
    Message:
    [OK]

Expected:
(1) A better error message
(2) Support of the EVALUATE.

-- 
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

Reply via email to