[Libreoffice-bugs] [Bug 118273] New: FILESAVE XLSX Basic code with Userform does not work in Calc

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Jun 20 16:07:17 UTC 2018


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

            Bug ID: 118273
           Summary: FILESAVE XLSX Basic code with Userform does not work
                    in Calc
           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 142965
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142965&action=edit
Example file from Excel

If we create a simple Userform Object in a VBA project in Microsoft Excel and
save as (*.XLSM) in LibreOffice Calc the Userform object will completely
disapper, except the code of the Userform. The Userform Codes which originally
was under the Forms, moved to among the Document Objects. Even if we open a
*.XLSM file which contains a Userform, the Userform object will not appear
under the Forms, but the Class Modules.

Steps to reproduce:
1. Create a new spreadsheet with Microsoft Excel 2016/2013
2. Open the Visual Basic window and create a simple visual basic Userform
Object
3. Create some objects on the UserForm1 module (Textbox, Label, Button)
4. Double click on these objects (textbox, Label, Button), to create Private
sub events.
4. Save the file as *.XLSM.
5. Open the file with LibreOffice Calc
6. Save as the file *.XLSM and reload it

Actual results: After we import the *.XLSM file in LibreOffice Calc 6.0.0.1,
the Userform Object appeared under the Class Modules, instead of under the
Forms. Nevertheless, if we create a Button_Click() event on the Worksheet to
open the UserForm1
        Sub Gomb2_Click()
        UserForm1.Show
        End Sub
the UserForm1 module will appear correctly.
If we export the *.XLSM file with LibreOffice Calc 6.0.0.1.0+ and reload the
file, the Userform object will disapper, except the code of the UserForm. The
Userform Codes moved to be among the Document Objects. If we open the exported
file with Microsoft Excel the UserForm1 Object codes will not be even among the
Document Objects.
Expected results:
The UserForms module should work correctly (should not disappear) after we save
the file in LibreOffice Calc.


Version: 6.0.0.1.0+
Build ID: c678dc5309741097d9b0265f03dd279a8794d256
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86 at 42, Branch:libreoffice-6-0, Time: 2017-12-28_04:21:33
Locale: hu-HU (hu_HU); Calc: group

-- 
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/20180620/d79858ac/attachment.html>


More information about the Libreoffice-bugs mailing list