1 files changed, 162 insertions, 0 deletions
diff --git a/odk/examples/DevelopersGuide/FirstSteps/FirstLoadComponent.java b/odk/examples/DevelopersGuide/FirstSteps/FirstLoadComponent.java
new file mode 100644
index 000000000..70e531df3
--- /dev/null
+++ b/odk/examples/DevelopersGuide/FirstSteps/FirstLoadComponent.java
@@ -0,0 +1,162 @@
+/* -*- Mode: Java; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
+/*************************************************************************
+ *
+ *  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.beans.PropertyValue;
+import com.sun.star.beans.XPropertySet;
+import com.sun.star.uno.XComponentContext;
+import com.sun.star.comp.helper.Bootstrap;
+import com.sun.star.container.XEnumeration;
+import com.sun.star.container.XEnumerationAccess;
+import com.sun.star.frame.XComponentLoader;
+import com.sun.star.frame.XController;
+import com.sun.star.frame.XModel;
+import com.sun.star.lang.XComponent;
+import com.sun.star.lang.XMultiComponentFactory;
+import com.sun.star.sheet.XCellAddressable;
+import com.sun.star.sheet.XCellRangesQuery;
+import com.sun.star.sheet.XSheetCellRanges;
+import com.sun.star.sheet.XSpreadsheet;
+import com.sun.star.sheet.XSpreadsheetDocument;
+import com.sun.star.sheet.XSpreadsheetView;
+import com.sun.star.sheet.XSpreadsheets;
+import com.sun.star.table.XCell;
+import com.sun.star.uno.UnoRuntime;
+
+public class FirstLoadComponent {
+
+    /**
+     * @param args the command line arguments
+     */
+    public static void main(String[] args) {
+        try {
+            // get the remote office component context
+            XComponentContext xRemoteContext = Bootstrap.bootstrap();
+            if (xRemoteContext == null) {
+                System.err.println("ERROR: Could not bootstrap default Office.");
+            }
+
+            XMultiComponentFactory xRemoteServiceManager = xRemoteContext.getServiceManager();
+
+            Object desktop = xRemoteServiceManager.createInstanceWithContext(
+                "com.sun.star.frame.Desktop", xRemoteContext);
+            XComponentLoader xComponentLoader = UnoRuntime.queryInterface(XComponentLoader.class, desktop);
+
+            PropertyValue[] loadProps = new PropertyValue[0];
+            XComponent xSpreadsheetComponent = xComponentLoader.loadComponentFromURL("private:factory/scalc", "_blank", 0, loadProps);
+
+            XSpreadsheetDocument xSpreadsheetDocument = UnoRuntime.queryInterface(XSpreadsheetDocument.class,
+                                      xSpreadsheetComponent);
+
+            XSpreadsheets xSpreadsheets = xSpreadsheetDocument.getSheets();
+            xSpreadsheets.insertNewByName("MySheet", (short)0);
+            com.sun.star.uno.Type elemType = xSpreadsheets.getElementType();
+
+            System.out.println(elemType.getTypeName());
+            Object sheet = xSpreadsheets.getByName("MySheet");
+            XSpreadsheet xSpreadsheet = UnoRuntime.queryInterface(
+                XSpreadsheet.class, sheet);
+
+            XCell xCell = xSpreadsheet.getCellByPosition(0, 0);
+            xCell.setValue(21);
+            xCell = xSpreadsheet.getCellByPosition(0, 1);
+            xCell.setValue(21);
+            xCell = xSpreadsheet.getCellByPosition(0, 2);
+            xCell.setFormula("=sum(A1:A2)");
+
+            XPropertySet xCellProps = UnoRuntime.queryInterface(
+                XPropertySet.class, xCell);
+            xCellProps.setPropertyValue("CellStyle", "Result");
+
+            XModel xSpreadsheetModel = UnoRuntime.queryInterface(
+                XModel.class, xSpreadsheetComponent);
+            XController xSpreadsheetController = xSpreadsheetModel.getCurrentController();
+            XSpreadsheetView xSpreadsheetView = UnoRuntime.queryInterface(XSpreadsheetView.class,
+                                      xSpreadsheetController);
+            xSpreadsheetView.setActiveSheet(xSpreadsheet);
+
+            // *********************************************************
+            // example for use of enum types
+            xCellProps.setPropertyValue("VertJustify",
+                                        com.sun.star.table.CellVertJustify.TOP);
+
+
+            // *********************************************************
+            // example for a sequence of PropertyValue structs
+            // create an array with one PropertyValue struct, it contains
+            // references only
+            loadProps = new PropertyValue[1];
+
+            // instantiate PropertyValue struct and set its member fields
+            PropertyValue asTemplate = new PropertyValue();
+            asTemplate.Name = "AsTemplate";
+            asTemplate.Value = Boolean.TRUE;
+
+            // assign PropertyValue struct to array of references for PropertyValue
+            // structs
+            loadProps[0] = asTemplate;
+
+            // load calc file as template
+            //xSpreadsheetComponent = xComponentLoader.loadComponentFromURL(
+            //    "file:///c:/temp/DataAnalysys.ods", "_blank", 0, loadProps);
+
+            // *********************************************************
+            // example for use of XEnumerationAccess
+            XCellRangesQuery xCellQuery = UnoRuntime.queryInterface(XCellRangesQuery.class, sheet);
+            XSheetCellRanges xFormulaCells = xCellQuery.queryContentCells(
+                (short)com.sun.star.sheet.CellFlags.FORMULA);
+            XEnumerationAccess xFormulas = xFormulaCells.getCells();
+            XEnumeration xFormulaEnum = xFormulas.createEnumeration();
+
+            while (xFormulaEnum.hasMoreElements()) {
+                Object formulaCell = xFormulaEnum.nextElement();
+                xCell = UnoRuntime.queryInterface(XCell.class, formulaCell);
+                XCellAddressable xCellAddress = UnoRuntime.queryInterface(XCellAddressable.class, xCell);
+                System.out.println("Formula cell in column " +
+                                   xCellAddress.getCellAddress().Column
+                                   + ", row " + xCellAddress.getCellAddress().Row
+                                   + " contains " + xCell.getFormula());
+            }
+
+        }
+        catch (java.lang.Exception e){
+            e.printStackTrace();
+        }
+        finally {
+            System.exit( 0 );
+        }
+    }
+
+}
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */