summaryrefslogtreecommitdiff
path: root/odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java
diff options
context:
space:
mode:
Diffstat (limited to 'odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java')
-rw-r--r--odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java170
1 files changed, 0 insertions, 170 deletions
diff --git a/odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java b/odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java
deleted file mode 100644
index 36a3029b..00000000
--- a/odk/examples/DevelopersGuide/Spreadsheet/ViewSample.java
+++ /dev/null
@@ -1,170 +0,0 @@
-/*************************************************************************
- *
- * 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 )
- {
- }
- }
-
-// ________________________________________________________________
-
-}
generated by cgit v1.2.3 (git 2.39.1) at 2025-07-02 19:59:12 +0000