[Libreoffice-bugs] [Bug 134487] New: macros dont work as expected. calc crashes on running the macros in file

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 134487
           Summary: macros dont work as expected. calc crashes on running
                    the macros in file
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: testing1237a-c at yahoo.com

Description:
i am attaching a copy of a simple invoicing excel sheet with macros. on first
start up, the file shows 

BASIC syntax error.
Expected: ,.

then, there is a button on "home" sheet, "add business logo to invoices" that
macro fails because the sheet has hardcoded "ActivePrinter:="Microsoft Print to
PDF"" and it fails on that. removing that line, error that shows is 
"BASIC runtime error.
'423'
GetOpenFilename"

"fname = Application.GetOpenFilename(filefilter:="Images (*.jpg),*.jpg",
Title:="Select Logo")" the code that shows the problem

the sheet has further problems like 
"BASIC runtime error.
'423'
RemoveDuplicates"


Steps to Reproduce:
1. open the file and try to work with buttons/forms

Actual Results:
https://drive.google.com/open?id=1D6b8CQu1ph9WDpSkxQIqwsUGlxeuEz19
download link to file 

https://www.youtube.com/watch?v=0jhN-i4vgpQ

link to video by the creator of the file showing the file working in excel but
not in LO calc.

Expected Results:
the excel file should work as shown in the youtube video


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.2.2
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: kf5; 
Locale: en-IN (en_IN.UTF-8); UI-Language: en-US
Calc: 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/20200703/878d89ad/attachment.htm>