Bug 160038 - VBA Compatibility:VBA functions in protected libraries don't work
Summary: VBA Compatibility:VBA functions in protected libraries don't work
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-03-05 03:59 UTC by Saburo
Modified: 2024-03-06 22:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
samplefile (11.31 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-03-05 03:59 UTC, Saburo 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Saburo 2024-03-05 03:59:30 UTC 
Description:
Works when library is unprotected, but not when protected
ex. Round function

Steps to Reproduce:
1.Open attached file
2.Tools > Macros >  Run Macro
3.attached file > Library1 > Module1 - Main run

Actual Results:
BASIC runtime error.

Expected Results:
Run Macro  like an unprotected library.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.2.0.3 (x86) / LibreOffice Community
Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: en-US
Calc: CL threaded
Comment 1 Saburo 2024-03-05 03:59:54 UTC 
Created attachment 192954 [details]
samplefile
Comment 2 raal 2024-03-06 22:59:50 UTC 
Reproducible with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 806362b915ee89a4f907905a8ac8c1527ea99223
CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded Jumbo

VBA not supported yet: https://ask.libreoffice.org/t/password-for-macros-that-allow-the-code-to-run-but-not-to-access-macros/47880/6