Bug 134361 - activeworkbook.followhyperlink in macro throws error
Summary: activeworkbook.followhyperlink in macro throws error
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
6.4.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2020-06-28 13:28 UTC by johnks
Modified: 2020-11-09 06:49 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
error screenshot (23.32 KB, image/png)
2020-06-28 13:29 UTC, johnks
Details
macro errors files (833.91 KB, application/zip)
2020-07-10 17:57 UTC, johnks
Details

Note You need to log in before you can comment on or make changes to this bug.
Description johnks 2020-06-28 13:28:45 UTC
Description:
i have excel macro enabled workbooks that have activeworkbook.followhyperlink vba command and my libreoffice calc throws 

BASIC syntax error: 
Unexpected symbol:address

https://docs.microsoft.com/en-us/office/vba/api/Excel.Workbook.FollowHyperlink

this link describes microsoft method of using this vba but LO does not work well with this.


Steps to Reproduce:
open a file containing vba with a button

 
Rem Attribute VBA_ModuleType=VBAFormModule
Option VBASupport 1
Private Sub CommandButton1_Click()
ActiveWorkbook.FollowHyperlink _
Address:="https://www.microsoft.com/en-in/download/details.aspx?id=7"
End Sub



Actual Results:
BASIC syntax error.
Unexpected symbol: Address.

Expected Results:
link in the button should work. currently the only way to work on the file containing this vba is to remove the line and then run


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
Comment 1 johnks 2020-06-28 13:29:09 UTC
Created attachment 162476 [details]
error screenshot
Comment 2 Xisco FaulĂ­ 2020-07-10 16:55:15 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 3 johnks 2020-07-10 17:57:23 UTC
Created attachment 162893 [details]
macro errors files

this zip contains some macro enabled files which have the current buggy activeworkbook hyperlink error and some more errors
Comment 4 Buovjaga 2020-11-09 06:48:46 UTC
Confirmed with the files. They give a warning about exceeding the max. number of columns, but I guess it does not affect this.

Arch Linux 64-bit
Version: 7.1.0.0.alpha1+
Build ID: c9b320c32aceab7e22d381b688e7b44030e01c2d
CPU threads: 8; OS: Linux 5.9; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 8 November 2020