[Libreoffice-bugs] [Bug 107902] New: Macro in XLSM gives error in Calc, but runs fine in Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 107902
           Summary: Macro in XLSM gives error in Calc, but runs fine in
                    Excel
           Product: LibreOffice
           Version: 5.4.0.0.alpha1+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx, regression
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
                CC: szymon.klos at collabora.com

Created attachment 133368
  --> https://bugs.documentfoundation.org/attachment.cgi?id=133368&action=edit
Sample XLSM that gives error in Calc when run

Open the attached Excel spreadsheet with a simple macro, and run the macro. 

Execution fails with error:
"BASIC runtime error.
'1'

Type: com.sun.star.lang.WrappedTargetRuntimeException
Message: non-RuntimeException occurred when accessing an interface type
attribute"

There's no error message if the first line of the macro is changed
- from: Range("A1").Select
- to:   Range("A1:A5").Select

In Excel the macro runs fine in both cases.

Occurs in 5.4 master build (68a1cb23ede1d4ae6195850190fca6953c30417f) / Windows
7, doesn't occur in 5.2.0.4. => regression

-- 
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/20170516/bab0b9eb/attachment.html>