1 files changed, 170 insertions, 0 deletions
diff --git a/odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java b/odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java
new file mode 100644
index 000000000000..dd89ce017ead
--- /dev/null
+++ b/odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java
@@ -0,0 +1,170 @@
+/*************************************************************************
+ *
+ *  The Contents of this file are made available subject to the terms of
+ *  the BSD license.
+ *
+ *  Copyright 2000, 2010 Oracle and/or its affiliates.
+ *  All rights reserved.
+ *
+ *  Redistribution and use in source and binary forms, with or without
+ *  modification, are permitted provided that the following conditions
+ *  are met:
+ *  1. Redistributions of source code must retain the above copyright
+ *     notice, this list of conditions and the following disclaimer.
+ *  2. Redistributions in binary form must reproduce the above copyright
+ *     notice, this list of conditions and the following disclaimer in the
+ *     documentation and/or other materials provided with the distribution.
+ *  3. Neither the name of Sun Microsystems, Inc. nor the names of its
+ *     contributors may be used to endorse or promote products derived
+ *     from this software without specific prior written permission.
+ *
+ *  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
+ *  "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
+ *  LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
+ *  FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
+ *  COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
+ *  INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
+ *  BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
+ *  OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
+ *  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR
+ *  TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE
+ *  USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+ *
+ *************************************************************************/
+
+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 = (com.sun.star.frame.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 );
+        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 );
+        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.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 );
+        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 );
+        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 );
+        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 = (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.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 )
+        {
+        }
+    }
+
+// ________________________________________________________________
+
+}