Bug 48634 - FILEOPEN: Import Excel VBA basic runtime error
Summary: FILEOPEN: Import Excel VBA basic runtime error
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL: https://www.dropbox.com/s/gbgzfte6j4j...
Whiteboard: BSA target:6.4.0
Keywords:
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2012-04-13 00:07 UTC by brajalle
Modified: 2019-10-31 16:32 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
xls spreadsheet (2.42 MB, application/vnd.ms-excel)
2014-05-20 16:58 UTC, Elias K Gardner
Details

Note You need to log in before you can comment on or make changes to this bug.
Description brajalle 2012-04-13 00:07:47 UTC
Problem description: Opening Excel spreadsheet with VBA macros results in message - BASIC runtime error '423' find control.  Macro attempts to call a DeleteControl but apparently fails.  Works in Excel fine.

Steps to reproduce:
1. Open Excel file in LibreOffice
2. Allow Macros
3. Error message pops up on both open of file and close.

Current behavior:  Error message pops up

Expected behavior:  Proper macro call and no error message

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.15 Safari/536.5
Comment 1 Sören 2012-08-14 14:47:40 UTC
Could you please attach a file, in which the problem occurs?
Comment 2 Joel Madero 2013-05-28 15:37:47 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2013-07-08 21:20:58 UTC Comment hidden (obsolete)
Comment 4 Elias K Gardner 2014-05-20 16:58:22 UTC
Created attachment 99432 [details]
xls spreadsheet

This file causes the BASIC runtime error. '423' FindControl
Comment 5 Elias K Gardner 2014-05-20 17:00:31 UTC
I just attached a document that causes this error in LibreOffice Version: 4.2.3.3
Build ID: 420m0(Build:3) on Ubuntu 14.04 x64.

Not sure if its appropriate to reopen this old bug but it appears to be the exact same error.

I'm happy to help in any way I can.

What does the error even mean?
Comment 6 Joel Madero 2014-11-05 23:59:58 UTC
Never confirmed by QA team - moving to UNCONFIRMED to get confirmation. Thanks
Comment 7 Buovjaga 2014-11-16 11:09:30 UTC
(In reply to Elias K Gardner from comment #4)
> Created attachment 99432 [details]
> xls spreadsheet
> 
> This file causes the BASIC runtime error. '423' FindControl

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

Win 7 64-bit Version: 4.4.0.0.alpha2+
Build ID: b021b5983c62e266b82d9f0c5c6d8d8900553827
TinderBox: Win-x86@39, Branch:master, Time: 2014-11-12_01:10:08
Comment 8 brajalle 2014-11-17 10:52:30 UTC
Added original file dropbox URL - https://www.dropbox.com/s/gbgzfte6j4jo1mb/Financials%20Projections%20Template.xls?dl=0
Comment 9 Buovjaga 2014-11-17 12:11:42 UTC
(In reply to brajalle from comment #8)
> Added original file dropbox URL -
> https://www.dropbox.com/s/gbgzfte6j4jo1mb/
> Financials%20Projections%20Template.xls?dl=0

Same message:

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

Win 7 64-bit Version: 4.4.0.0.alpha2+
Build ID: b021b5983c62e266b82d9f0c5c6d8d8900553827
TinderBox: Win-x86@39, Branch:master, Time: 2014-11-12_01:10:08
Comment 10 QA Administrators 2016-09-20 10:26:00 UTC Comment hidden (obsolete)
Comment 11 Nico 2016-12-28 11:31:55 UTC Comment hidden (obsolete, off-topic)
Comment 12 Buovjaga 2016-12-28 13:16:18 UTC Comment hidden (off-topic)
Comment 13 QA Administrators 2017-12-29 03:28:48 UTC Comment hidden (obsolete)
Comment 14 Thomas Lendo 2018-10-08 00:22:56 UTC
Still reproducible.

Version: 6.2.0.0.alpha0+
Build ID: 6dacf9ec5455bdad82e78470a1a7cb6d2271bec7
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: de-DE (de_DE.UTF-8); Calc: threaded
from yesterday
Comment 15 QA Administrators 2019-10-09 02:29:48 UTC Comment hidden (obsolete)
Comment 16 Commit Notification 2019-10-31 16:32:03 UTC
Caolán McNamara committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/20bca05a8e5a07c21451e4c62064d1a5680611d9

crashtesting: null deref on import of fdo48634-1.xls

It will be available in 6.4.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.