| /************************************************************** | |
| * | |
| * Licensed to the Apache Software Foundation (ASF) under one | |
| * or more contributor license agreements. See the NOTICE file | |
| * distributed with this work for additional information | |
| * regarding copyright ownership. The ASF licenses this file | |
| * to you under the Apache License, Version 2.0 (the | |
| * "License"); you may not use this file except in compliance | |
| * with the License. You may obtain a copy of the License at | |
| * | |
| * http://www.apache.org/licenses/LICENSE-2.0 | |
| * | |
| * Unless required by applicable law or agreed to in writing, | |
| * software distributed under the License is distributed on an | |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY | |
| * KIND, either express or implied. See the License for the | |
| * specific language governing permissions and limitations | |
| * under the License. | |
| * | |
| *************************************************************/ | |
| import com.sun.star.uno.UnoRuntime; | |
| // __________ implementation ____________________________________ | |
| /** Create and modify a spreadsheet view. | |
| */ | |
| public class ViewSample extends SpreadsheetDocHelper | |
| { | |
| // ________________________________________________________________ | |
| public static void main( String args[] ) | |
| { | |
| try | |
| { | |
| ViewSample aSample = new ViewSample( args ); | |
| aSample.doSampleFunction(); | |
| } | |
| catch (Exception ex) | |
| { | |
| System.out.println( "Sample caught exception! " + ex ); | |
| System.exit( 1 ); | |
| } | |
| System.out.println( "\nSamples done." ); | |
| System.exit( 0 ); | |
| } | |
| // ________________________________________________________________ | |
| public ViewSample( String[] args ) | |
| { | |
| super( args ); | |
| } | |
| // ________________________________________________________________ | |
| /** This sample function performs all changes on the view. */ | |
| public void doSampleFunction() throws Exception | |
| { | |
| com.sun.star.sheet.XSpreadsheetDocument xDoc = getDocument(); | |
| 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 = | |
| 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 = | |
| UnoRuntime.queryInterface( com.sun.star.container.XIndexAccess.class, xController ); | |
| Object aPane = xIndex.getByIndex(1); | |
| 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 = | |
| 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 = | |
| 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 = | |
| 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]; | |
| aArguments[0] = new com.sun.star.beans.PropertyValue(); | |
| aArguments[0].Name = "Title"; | |
| aArguments[0].Value = "Please select a cell range (e.g. C4:E6)"; | |
| aArguments[1] = new com.sun.star.beans.PropertyValue(); | |
| aArguments[1].Name = "CloseOnMouseRelease"; | |
| aArguments[1].Value = new Boolean(true); | |
| xRngSel.startRangeSelection( aArguments ); | |
| synchronized (aListener) | |
| { | |
| aListener.wait(); // wait until the selection is done | |
| } | |
| xRngSel.removeRangeSelectionListener( aListener ); | |
| if ( aListener.aResult != null && aListener.aResult.length() != 0 ) | |
| { | |
| 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 ); | |
| } | |
| } | |
| // ________________________________________________________________ | |
| // listener to react on finished selection | |
| private class ExampleRangeListener implements com.sun.star.sheet.XRangeSelectionListener | |
| { | |
| public String aResult; | |
| public void done( com.sun.star.sheet.RangeSelectionEvent aEvent ) | |
| { | |
| aResult = aEvent.RangeDescriptor; | |
| synchronized (this) | |
| { | |
| notify(); | |
| } | |
| } | |
| public void aborted( com.sun.star.sheet.RangeSelectionEvent aEvent ) | |
| { | |
| synchronized (this) | |
| { | |
| notify(); | |
| } | |
| } | |
| public void disposing( com.sun.star.lang.EventObject aObj ) | |
| { | |
| } | |
| } | |
| // ________________________________________________________________ | |
| } |