Talk:Documentation/DevGuide/Spreadsheets/Example: Adding a New Spreadsheet
From Apache OpenOffice Wiki
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 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
--Javacioc 22:13, 15 November 2009 (UTC)
yes, this is wrong in the code snippet but correct in the SDK sample. I have changed the code snippet!
--Jsc 14:54, 18 November 2009 (UTC)