Difference between revisions of "Talk:Documentation/DevGuide/Spreadsheets/Example: Adding a New Spreadsheet"
From Apache OpenOffice Wiki
(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 | + | 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)