Talk:Documentation/DevGuide/Spreadsheets/Example: Adding a New Spreadsheet
From Apache OpenOffice Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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)
