Difference between revisions of "Talk:Documentation/DevGuide/Spreadsheets/Example: Adding a New Spreadsheet"

From Apache OpenOffice Wiki
Jump to: navigation, search
(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…')
 
Line 8: Line 8:
 
   
 
   
  
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.
+
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.
 
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.

Revision as of 22:14, 15 November 2009

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 getByName returns com.sun.star.uno.Any as data type.

I found the way on getting the right Interface reading the 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

--Javacioc 22:13, 15 November 2009 (UTC)

Personal tools