[Libreoffice-bugs] [Bug 118241] FILEOPEN XLSX Basic code with CreateObject("Scripting.FileSystemObject") and “For Each ” loop does not work

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Jun 24 22:49:02 UTC 2018


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

--- Comment #3 from himajin100000 at gmail.com ---
Created attachment 143078
  --> https://bugs.documentfoundation.org/attachment.cgi?id=143078&action=edit
reproducible document with simpler code

DON' FORGET TO PUT SOME FILES in C:\lolog 
I had 12 files there

Expected Result(in Excel VBA):
True

Actual Result(in LibreOffice StarBasic):
False

Minor note:
It seems StarBasic Adds "Option VBASupport 1", when it opens .xlsm . This
option is required to get Actual Result. if you don't have this line, you will
encounter a "type mismatch error". Even in this case you will not get the
Expected Result.

-- 
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/20180624/c26de976/attachment-0001.html>


More information about the Libreoffice-bugs mailing list