Bug 134492 - Opening an .xla file containing custom formula throws basic runtime error
Summary: Opening an .xla file containing custom formula throws basic runtime error
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
(earliest affected)
3.5.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
Reported: 2020-07-04 05:01 UTC by johnks
Modified: 2020-11-09 15:10 UTC (History)
3 users (show)

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

basic runtime error (198.50 KB, application/vnd.ms-excel)
2020-07-04 05:02 UTC, johnks

Note You need to log in before you can comment on or make changes to this bug.
Description johnks 2020-07-04 05:01:58 UTC
BASIC runtime error.

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:
open file in macro enabled mode
write a number in a cell and write "=word(cell)" in the next cell and calc shows the number in figures.
running macro throws runtime error

Actual Results:
basic runtime error is thrown on macro run but other than that the file works

Expected Results:
file works as expected but there is a runtime error that happens everytime

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-07-04 05:02:21 UTC
Created attachment 162627 [details]
basic runtime error
Comment 2 Xisco Faulí 2020-07-10 16:58:06 UTC
Hello Johnks,
Which is the password for the macros ?
Comment 3 johnks 2020-07-10 17:57:11 UTC
(In reply to Xisco Faulí from comment #2)
> Hello Johnks,
> Which is the password for the macros ?

no idea. got the file from a friend. this should work without a password in Libreoffice calc
Comment 4 Buovjaga 2020-11-09 06:44:21 UTC
I repro the error. Another person tried to open the file in Excel 2013, but it refused to open. The person was able to insert it as an add-in, though.

There is an older report (closed due to insufficient data), which sounds kind of similar: bug 117320

Leaving this as unconfirmed, because I have no evidence that LibreOffice should support these files.

Also tested with 4.4.7 and 3.5.0.

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
Comment 5 Buovjaga 2020-11-09 15:10:47 UTC
Discussed in the dev chat. Adding support for the missing VBA is OK, but XLA as a format will not be supported, because these Excel addons may be implemented with many different programming languages.