diff options
Diffstat (limited to 'odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java')
-rw-r--r-- | odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java | 27 |
1 files changed, 9 insertions, 18 deletions
diff --git a/odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java b/odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java index dd89ce017ead..8b4e8afaef10 100644 --- a/odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java +++ b/odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java @@ -72,42 +72,35 @@ public class ViewSample extends SpreadsheetDocHelper public void doSampleFunction() throws Exception { com.sun.star.sheet.XSpreadsheetDocument xDoc = getDocument(); - com.sun.star.frame.XModel xModel = (com.sun.star.frame.XModel) - UnoRuntime.queryInterface( com.sun.star.frame.XModel.class, xDoc); + com.sun.star.frame.XModel xModel = UnoRuntime.queryInterface( com.sun.star.frame.XModel.class, xDoc); com.sun.star.frame.XController xController = xModel.getCurrentController(); // --- Spreadsheet view --- // freeze the first column and first two rows - com.sun.star.sheet.XViewFreezable xFreeze = (com.sun.star.sheet.XViewFreezable) - UnoRuntime.queryInterface( com.sun.star.sheet.XViewFreezable.class, xController ); + com.sun.star.sheet.XViewFreezable xFreeze = UnoRuntime.queryInterface( com.sun.star.sheet.XViewFreezable.class, xController ); if ( null != xFreeze ) System.out.println( "got xFreeze" ); xFreeze.freezeAtPosition( 1, 2 ); // --- View pane --- // get the cell range shown in the second pane and assign a cell background to them - com.sun.star.container.XIndexAccess xIndex = (com.sun.star.container.XIndexAccess) - UnoRuntime.queryInterface( com.sun.star.container.XIndexAccess.class, xController ); + com.sun.star.container.XIndexAccess xIndex = UnoRuntime.queryInterface( com.sun.star.container.XIndexAccess.class, xController ); Object aPane = xIndex.getByIndex(1); - com.sun.star.sheet.XCellRangeReferrer xRefer = (com.sun.star.sheet.XCellRangeReferrer) - UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangeReferrer.class, aPane ); + com.sun.star.sheet.XCellRangeReferrer xRefer = UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangeReferrer.class, aPane ); com.sun.star.table.XCellRange xRange = xRefer.getReferredCells(); - com.sun.star.beans.XPropertySet xRangeProp = (com.sun.star.beans.XPropertySet) - UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, xRange ); + com.sun.star.beans.XPropertySet xRangeProp = UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, xRange ); xRangeProp.setPropertyValue( "IsCellBackgroundTransparent", new Boolean( false ) ); xRangeProp.setPropertyValue( "CellBackColor", new Integer( 0xFFFFCC ) ); // --- View settings --- // change the view to display green grid lines - com.sun.star.beans.XPropertySet xProp = (com.sun.star.beans.XPropertySet) - UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, xController ); + com.sun.star.beans.XPropertySet xProp = UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, xController ); xProp.setPropertyValue( "ShowGrid", new Boolean(true) ); xProp.setPropertyValue( "GridColor", new Integer(0x00CC00) ); // --- Range selection --- // let the user select a range and use it as the view's selection - com.sun.star.sheet.XRangeSelection xRngSel = (com.sun.star.sheet.XRangeSelection) - UnoRuntime.queryInterface( com.sun.star.sheet.XRangeSelection.class, xController ); + com.sun.star.sheet.XRangeSelection xRngSel = UnoRuntime.queryInterface( com.sun.star.sheet.XRangeSelection.class, xController ); ExampleRangeListener aListener = new ExampleRangeListener(); xRngSel.addRangeSelectionListener( aListener ); com.sun.star.beans.PropertyValue[] aArguments = new com.sun.star.beans.PropertyValue[2]; @@ -125,10 +118,8 @@ public class ViewSample extends SpreadsheetDocHelper xRngSel.removeRangeSelectionListener( aListener ); if ( aListener.aResult != null && aListener.aResult.length() != 0 ) { - com.sun.star.view.XSelectionSupplier xSel = (com.sun.star.view.XSelectionSupplier) - UnoRuntime.queryInterface( com.sun.star.view.XSelectionSupplier.class, xController ); - com.sun.star.sheet.XSpreadsheetView xView = (com.sun.star.sheet.XSpreadsheetView) - UnoRuntime.queryInterface( com.sun.star.sheet.XSpreadsheetView.class, xController ); + com.sun.star.view.XSelectionSupplier xSel = UnoRuntime.queryInterface( com.sun.star.view.XSelectionSupplier.class, xController ); + com.sun.star.sheet.XSpreadsheetView xView = UnoRuntime.queryInterface( com.sun.star.sheet.XSpreadsheetView.class, xController ); com.sun.star.sheet.XSpreadsheet xSheet = xView.getActiveSheet(); com.sun.star.table.XCellRange xResultRange = xSheet.getCellRangeByName( aListener.aResult ); xSel.select( xResultRange ); |