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)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
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:

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

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
i have excel macro enabled workbooks that have activeworkbook.followhyperlink vba command and my libreoffice calc throws 

BASIC syntax error: 
Unexpected symbol:address


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 _
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:
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
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