Bug 49913 - : Crash when removing sheet from VB6
Summary: : Crash when removing sheet from VB6
Status: RESOLVED DUPLICATE of bug 45987
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Keywords: regression
Depends on:
Reported: 2012-05-14 07:08 UTC by jmgigandet
Modified: 2012-06-24 19:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description jmgigandet 2012-05-14 07:08:06 UTC
Problem description: 
I'm using VB6 to create spreadsheets. All was well with OO, and then LibreOffice V3.4.
Since upgrading to V3.52 (tested V3.53 too), I'm getting a crash when using Document.getSheets.RemoveByName("NameOfSheet3")

Steps to reproduce:
1. .... Open VB. Create new project. 

2. .... In main module add :
Dim ServiceManager As Object
Dim Desktop     As Object
Dim Document    As Object
Dim Feuille     As Object
    ' Create OpenOffice service
    Set ServiceManager = CreateObject("com.sun.star.ServiceManager")
    Set Desktop = ServiceManager.createInstance("com.sun.star.frame.Desktop")
    ' Create new Doc
    Set Document = Desktop.loadComponentFromURL("private:factory/scalc", "_blank", 0, args())
    ' Create new instance
    Set Feuille = Document.createInstance("com.sun.star.sheet.Spreadsheet")
    ' Suppression des feuilles supplémentaires
    Document.getSheets.RemoveByName ("Feuille3") or ("Sheet3") or whatever is the name of the third shield.

3. .... Run

Current behavior:
Crash when trying to remove sheet with error : 
"com.sun.star.uno.RuntimeException: [msci_uno bridge error] UNO type of C++ exception unknown: "std.out_of_range", RTTI-name=".?AVout_of_range@std@@"!"

Expected behavior:
Remove the sheet with no crash, as with previous LibreOffice and OpenOffice versions did.

Platform (if different from the browser): 
Browser: Mozilla/5.0 (Windows NT 5.1; rv:13.0) Gecko/20100101 Firefox/13.0
Comment 1 Misha 2012-05-31 01:09:16 UTC
Also appears when accessing via OLE using LibreOffice

com.sun.star.uno.RuntimeException: [msci_uno bridge error] UNO type of C++ exception unknown: "std.out_of_range", RTTI-name=".?AVout_of_range@std@@"!
Comment 2 Markus Mohrhard 2012-06-24 19:19:51 UTC

*** This bug has been marked as a duplicate of bug 45987 ***