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@lists.freedesktop.org
Reporter: kelem...@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@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs