[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