Bug 134471 - "Application.CommandBars("Ply").Enabled = True" VBA error
Summary: "Application.CommandBars("Ply").Enabled = True" VBA error
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
6.4.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2020-07-03 09:04 UTC by johnks
Modified: 2023-05-21 17:14 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
xlsm file containing problem vba (162.99 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2020-07-03 09:04 UTC, johnks
Details
$(ARG1) error on the bug (254.36 KB, image/png)
2023-05-21 17:14 UTC, johnks
Details

Note You need to log in before you can comment on or make changes to this bug.
Description johnks 2020-07-03 09:04:17 UTC
Description:
BASIC runtime error.
'1'

Type: com.sun.star.uno.DeploymentException
Message: component context fails to supply singleton com.sun.star.ui.theModuleUIConfigurationManagerSupplier of type com.sun.star.ui.XModuleUIConfigurationManagerSupplier

Steps to Reproduce:
vba containing the code 
Application.CommandBars("Ply").Enabled = True

throws the error and does not work. calc shifts user to libreoffice basic with this error and refuses to go to actual document. Further, does not allow user to easily close the file 


Actual Results:
https://stackoverflow.com/questions/24540929/commandbarsply-wont-reset-on-workbook-beforeclose-vba-excel

Expected Results:
vba should execute as it works in excel


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-07-03 09:04:57 UTC
Created attachment 162602 [details]
xlsm file containing problem vba
Comment 2 Julien Nabet 2020-07-03 10:55:32 UTC
On pc Debian x86-64 with master sources updated today + authorize macro, the first error popup message I got is:
"BASIC runtime error.
'423'
ExecuteExcel4Macro

(Line showed is line 13, first line from Workbook_Open method)

Then I can indeed see your message
Comment 3 Julien Nabet 2020-07-03 10:57:02 UTC
I noticed this on console:
warn:scripting:701294:701294:scripting/source/basprov/basprov.cxx:329: LibraryName VBAProject is part of the url VBAProject.ThisWorkbook.Workbook_Open

Don't know if it's related.
Comment 4 johnks 2020-07-03 12:33:03 UTC
yes. that error too. i was going to add a new bug report for that or can this bug report will suffice for both?
Comment 5 Julien Nabet 2020-07-03 12:42:57 UTC
For the moment, I don't think it needs a new bugtracker but I may be wrong.
Comment 6 QA Administrators 2022-07-09 03:35:08 UTC Comment hidden (obsolete)
Comment 7 johnks 2023-05-21 17:13:47 UTC
bug exists in 

Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Flatpak
Calc: threaded

check the new screenshot. some $(Arg1) alert also
Comment 8 johnks 2023-05-21 17:14:13 UTC
Created attachment 187419 [details]
$(ARG1) error on the bug