[Libreoffice-bugs] [Bug 118153] New: FILEOPEN VBA Macro:“Workbooks.Open Filename” command does not work

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118153
           Summary: FILEOPEN VBA Macro:“Workbooks.Open Filename” command
                    does not work
           Product: LibreOffice
           Version: 6.2.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 142718
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142718&action=edit
Example file from Excel

The ‘Workbooks.Open Filename:="FILE PATH"’ command does not work in LibreOffice
if the file extension is *.xlsx in the FILE PATH. If the file extension is
*.xls the command works correctly.

Steps to reproduce:
1. Create a new *.xlsm file with Microsoft Excel 2010/2013/2016.
2. Create a new module in the VBA Project.
3. Use this command: ‘Workbooks.Open Filename:="FILE PATH"’ with *.xlsx and
*.xls files in the “FILE PATH”
4. Save the file and open with LibreOffice Calc
5. Try the macro in both cases. (FILE PATH with *.xlsx and *.xls)


Actual results:
We got an error message (Type: com.sun.star.uno.RuntimeException Message: Bad
Format) in case of *.xlsx extension, but not in case of *.xls extension.

Expected results:
We should not get an error message (Type: com.sun.star.uno.RuntimeException
Message: Bad Format) in case of *.xlsx extension.


Verzió: 6.0.4.2
Build az.: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf
CPU szálak: 4; OS: Windows 10.0; Felületmegjelenítés: GL; 
Területi beállítások: hu-HU (hu_HU); Calc: CL

Version: 6.2.0.0.alpha0+
Build ID: 1e9e01dff0a8d65bb10d5a886cca7899b43979da
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86 at 42, Branch:master, Time: 2018-05-27_05:50:28
Locale: hu-HU (hu_HU); Calc: group threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180614/5623707b/attachment-0001.html>