[Libreoffice-bugs] [Bug 118277] New: FILEOPEN XLSX Basic project with VBA Project Password does not work in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118277
           Summary: FILEOPEN XLSX Basic project with VBA Project Password
                    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 142973
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142973&action=edit
Example file from Excel with password protected VBA macro

If we want to keep your program (Macro/VBA Project) in safety in Microsoft
Excel, we usually use the “VBAPROJECT Password” option to protect the VBA code.
If we open the *.XLSM file with LibreOffice Calc the protection of the Project
will disappear.

Steps to reproduce:
1. Create a new spreadsheet with Microsoft Excel 2016/2013/2010
2. Open the Visual Basic window and create a simple visual basic Module.
3. Write a simple code in the module.
4. Click Tools on the Menu and choose “VBAProject Properties...”
5. Then choose “Protection”, check the “Lock project for viewing” checkbox and
create a password to view project properties. Click OK.
6. Reload the *.XLSM file with Excel and check your VBA Project’s password
protection. (It will work)
7. Open the file with LibreOffice Calc and check your VBA Project’s password
protection.
8. Save as the file *.XLSM
9. Open it with Microsoft Excel

Actual results: There is no password protection on the VBA Project. We can edit
the modules.
If we export the file with LibreOffice Calc and open it with Microsoft Excel
the password protection will not be present.
Four new workbooks icon appeared in the Microsoft Excel Objects folder at the
VBA Project, after we reopen the exported *.XLSM file with Microsoft Excel.


Expected results:
The VBA Project password should not disappear after we open the *.XLSM file
with LibreOffice Calc. After we reopen the exported file with Microsoft Excel,
the Excel Object structure should be the same as in the original file.

Version: 6.0.0.0.beta1+
Build ID: 29228e83df009cf76ac819ed024527be1092f065
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86 at 42, Branch:libreoffice-6-0, Time: 2017-12-04_23:15:34
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/20180620/dd75f1f7/attachment.html>