Apache OpenOffice Wiki - User contributions [en]

Talk:Documentation/DevGuide/Spreadsheets/Example: Adding a New Spreadsheet

2009-11-15T22:40:13Z

Javacioc:

In the insertSpreadsheet() method of the example, the assignement

xSheet = xSheets.getByName(aName);

cannot be casted to com.sun.star.sheet.XSpreadsheet as per Exception reported as follow:

java.lang.ClassCastException: com.sun.star.uno.Any cannot be cast to com.sun.star.sheet.XSpreadsheet

As per the API, the method [http://api.openoffice.org/docs/common/ref/com/sun/star/container/XNameAccess.html#getByName getByName] returns com.sun.star.uno.Any as data type.

I think it should:

xSheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, xSheets.getByName(aName));

I'm using Netbeans 6.7.1 with OpenOffice.org API Plugin v.2.0.6, the SDK is 3.1.1

--[[User:Javacioc|Javacioc]] 22:13, 15 November 2009 (UTC)

User:Javacioc

2009-11-15T22:33:40Z

Javacioc: Created page with 'My profile on [http://it.linkedin.com/in/javacioc Linkedin]'

My profile on [http://it.linkedin.com/in/javacioc Linkedin]

Talk:Documentation/DevGuide/Spreadsheets/Example: Adding a New Spreadsheet

2009-11-15T22:14:50Z

Javacioc:

In the insertSpreadsheet() method of the example, the assignement

xSheet = xSheets.getByName(aName);

cannot be casted to com.sun.star.sheet.XSpreadsheet as per Exception reported as follow:

java.lang.ClassCastException: com.sun.star.uno.Any cannot be cast to com.sun.star.sheet.XSpreadsheet

As per the API, the method [http://api.openoffice.org/docs/common/ref/com/sun/star/container/XNameAccess.html#getByName getByName] returns com.sun.star.uno.Any as data type.

I found the way on getting the right Interface reading the [http://www.javaworld.com/javaworld/jw-05-2008/jw-05-spreadsheets.html?page=2http://www.javaworld.com/javaworld/jw-05-2008/jw-05-spreadsheets.html?page=2 JavaWorld article] and it works well.

Here the snippet:

xSheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, xSheets.getByName(aName));

I'm using Netbeans 6.7.1 with OpenOffice.org API Plugin v.2.0.6, the SDK is 3.1.1

--[[User:Javacioc|Javacioc]] 22:13, 15 November 2009 (UTC)

Talk:Documentation/DevGuide/Spreadsheets/Example: Adding a New Spreadsheet

2009-11-15T22:13:27Z

Javacioc: Created page with 'In the insertSpreadsheet() method of the example, the assignement xSheet = xSheets.getByName(aName); cannot be casted to com.sun.star.sheet.XSpreadsheet as per Exception rep…'

In the insertSpreadsheet() method of the example, the assignement

xSheet = xSheets.getByName(aName);

cannot be casted to com.sun.star.sheet.XSpreadsheet as per Exception reported as follow:

java.lang.ClassCastException: com.sun.star.uno.Any cannot be cast to com.sun.star.sheet.XSpreadsheet

As per the API of the method [http://api.openoffice.org/docs/common/ref/com/sun/star/container/XNameAccess.html#getByName getByName] the method returns com.sun.star.uno.Any as data type.

I found the way on getting the right Interface reading the [http://www.javaworld.com/javaworld/jw-05-2008/jw-05-spreadsheets.html?page=2http://www.javaworld.com/javaworld/jw-05-2008/jw-05-spreadsheets.html?page=2 JavaWorld article] and it works well.

Here the snippet:

xSheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, xSheets.getByName(aName));

I'm using Netbeans 6.7.1 with OpenOffice.org API Plugin v.2.0.6, the SDK is 3.1.1

--[[User:Javacioc|Javacioc]] 22:13, 15 November 2009 (UTC)