[Libreoffice-bugs] [Bug 118276] New: FILEOPEN XLSX Basic code with Validity and Sheets does not work in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118276
           Summary: FILEOPEN XLSX Basic code with Validity and Sheets 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 142969
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142969&action=edit
Example file from Excel with a Validity value set as macro condition

If we try to run the macro in the attached file, the Sheets will not hide if we
set the L9 cell to OK using validity setting and the Object Catalog will not
work correctly.

Steps to reproduce:
1. Create a new spreadsheet with Microsoft Excel 2016/2013
2. Set a validity for a cell (“L9”) and choose the List type. Set two value (OK
and NOT OK)
3. Create 8 Sheets.
4. Add this macro code to the Sheet1:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Me.Range("L9").Address Then
    If Target.Value = "OK" Then
        Sheets("Munka8").Visible = True
        Sheets("Munka7").Visible = True
        Sheets("Munka6").Visible = True
        Sheets("Munka5").Visible = True
    Else
        Sheets("Munka8").Visible = False
        Sheets("Munka7").Visible = False
        Sheets("Munka6").Visible = False
        Sheets("Munka5").Visible = False
    End If
End If
End Sub

5. Set the value of the “L9” cell to “OK” and NOT OK. (It will work)
6. Save the file as *.XLSM.
7. Open the file with LibreOffice Calc and set the value of the “L9” cell to
“OK” and “NOT OK”. (It will not work)
8. Save as the file in LibreOffice Calc.
9. Open in Microsoft Excel.

Actual results: The macro does not work. If we open the file in LibreOffice
Calc and open the Object Catalog, we can see the Document Objects. But If we
double click on the “Sheet1” (we use a macro here) LibreOffice adds a new
Sheet1 module to the Modules and we cannot open our macro code from the Object
Catalog. If we save the file and reopen with Microsoft Excel the Object Catalog
will be completely wrong.

Expected results:
The macro should work and the Object Catalog should work correctly if we want
to open a Document Object.


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/19e6196f/attachment-0001.html>