INTEGRATION: CWS sdksample (1.4.40); FILE MERGED

2004/08/05 15:15:47 jsc 1.4.40.2: #i29308# use System.err for error output
2004/06/07 15:54:54 jsc 1.4.40.1: #i29308# use new bootstrap feature

1 files changed, 148 insertions, 155 deletions

diff --git a/odk/examples/java/Spreadsheet/EuroAdaption.java b/odk/examples/java/Spreadsheet/EuroAdaption.java
index 50abb6d883a1..d0b8124427da 100644
--- a/odk/examples/java/Spreadsheet/EuroAdaption.java
+++ b/odk/examples/java/Spreadsheet/EuroAdaption.java
@@ -2,9 +2,9 @@
  *
  *  $RCSfile: EuroAdaption.java,v $
  *
- *  $Revision: 1.4 $
+ *  $Revision: 1.5 $
  *
- *  last change: $Author: hr $ $Date: 2004-02-02 20:12:08 $
+ *  last change: $Author: rt $ $Date: 2005-01-31 17:15:41 $
  *
  *  The Contents of this file are made available subject to the terms of
  *  the BSD license.
@@ -39,90 +39,73 @@
  *************************************************************************/
 
 //***************************************************************************
-// comment: Step 1: connect to the office an get the MSF
+// comment: Step 1: get the Desktop object from the office
 //          Step 2: open an empty Calc document
 //          Step 3: enter a example text, set the numberformat to DM
 //          Step 4: change the numberformat to EUR (Euro)
 //          Step 5: use the DM/EUR factor on each cell with a content
 //***************************************************************************
 
-import com.sun.star.container.XIndexAccess;
-import com.sun.star.container.XEnumerationAccess;
-import com.sun.star.container.XEnumeration;
-
-import com.sun.star.uno.UnoRuntime;
-import com.sun.star.uno.AnyConverter;
-
-// access the implementations via names
 import com.sun.star.beans.PropertyValue;
 import com.sun.star.beans.XPropertySet;
 
-// access the implementations via names
-import com.sun.star.comp.servicemanager.ServiceManager;
+import com.sun.star.container.XEnumeration;
+import com.sun.star.container.XIndexAccess;
+import com.sun.star.container.XEnumerationAccess;
 
-import com.sun.star.connection.XConnector;
-import com.sun.star.connection.XConnection;
+import com.sun.star.document.XActionLockable;
 
-import com.sun.star.bridge.XUnoUrlResolver;
-import com.sun.star.uno.UnoRuntime;
-import com.sun.star.uno.XInterface;
-import com.sun.star.uno.XNamingService;
-import com.sun.star.uno.XComponentContext;
+import com.sun.star.frame.XDesktop;
+import com.sun.star.frame.XComponentLoader;
+
+import com.sun.star.lang.Locale;
+import com.sun.star.lang.XComponent;
+import com.sun.star.lang.XMultiComponentFactory;
 
 import com.sun.star.table.XCell;
 import com.sun.star.table.XCellRange;
+
 import com.sun.star.sheet.XSpreadsheet;
+import com.sun.star.sheet.XSpreadsheets;
 import com.sun.star.sheet.XSheetCellRanges;
+import com.sun.star.sheet.XCellRangesQuery;
 import com.sun.star.sheet.XCellFormatRangesSupplier;
 import com.sun.star.sheet.XCellRangesQuery;
+import com.sun.star.sheet.XSpreadsheetDocument;
+
+import com.sun.star.uno.UnoRuntime;
+import com.sun.star.uno.AnyConverter;
+import com.sun.star.uno.XInterface;
+import com.sun.star.uno.XComponentContext;
 
+import com.sun.star.util.NumberFormat;
 import com.sun.star.util.XNumberFormats;
 import com.sun.star.util.XNumberFormatsSupplier;
-import com.sun.star.lang.Locale;
-import com.sun.star.util.NumberFormat;
 
-import com.sun.star.lang.XMultiServiceFactory;
-import com.sun.star.lang.XMultiComponentFactory;
 
 public class EuroAdaption {
 
     public static void main(String args[]) {
-        String sConnectionString = "uno:socket,host=localhost,port=2083;urp;StarOffice.NamingService";
-
-        // It is possible to use a different connection string, passed as argument
-        if ( args.length == 1 ) {
-            sConnectionString = args[0];
-        }
-
-        XMultiServiceFactory xMSF = null;
-        try {
-            xMSF = connect( sConnectionString );
-        }
-        catch( Exception e) {
-            e.printStackTrace(System.out);
-            System.exit( 0 );
-        }
-
-        if( xMSF != null )  System.out.println("Connected to "+ sConnectionString );
-
         // You need the desktop to create a document
+        // The getDesktop method does the UNO bootstrapping, gets the
+        // remote servie manager and the desktop object.
         com.sun.star.frame.XDesktop xDesktop = null;
-        xDesktop = getDesktop( xMSF );
+        xDesktop = getDesktop();
 
         // create a sheet document
-        com.sun.star.sheet.XSpreadsheetDocument xSheetdocument = null;
-        xSheetdocument = ( com.sun.star.sheet.XSpreadsheetDocument ) createSheetdocument( xDesktop );
+        XSpreadsheetDocument xSheetdocument = null;
+        xSheetdocument = ( XSpreadsheetDocument ) createSheetdocument( xDesktop );
         System.out.println( "Create a new Spreadsheet" );
 
-
         // get the collection of all sheets from the document
-        com.sun.star.sheet.XSpreadsheets xSheets = null;
-        xSheets = (com.sun.star.sheet.XSpreadsheets) xSheetdocument.getSheets();
+        XSpreadsheets xSheets = null;
+        xSheets = (XSpreadsheets) xSheetdocument.getSheets();
 
-        // the Action Interface provides methods to hide actions, like inserting data, on a sheet, that increase the performance
-        com.sun.star.document.XActionLockable xActionInterface = null;
-        xActionInterface = (com.sun.star.document.XActionLockable) UnoRuntime.queryInterface(
-            com.sun.star.document.XActionLockable.class, xSheetdocument );
+        // the Action Interface provides methods to hide actions,
+        // like inserting data, on a sheet, that increase the performance
+        XActionLockable xActionInterface = null;
+        xActionInterface = (XActionLockable) UnoRuntime.queryInterface(
+            XActionLockable.class, xSheetdocument );
 
         // lock all actions
         xActionInterface.addActionLock();
@@ -130,15 +113,15 @@ public class EuroAdaption {
         com.sun.star.sheet.XSpreadsheet xSheet = null;
         try {
             // get via the index access the first sheet
-            com.sun.star.container.XIndexAccess xElements = (com.sun.star.container.XIndexAccess)
-                UnoRuntime.queryInterface( com.sun.star.container.XIndexAccess.class, xSheets );
+            XIndexAccess xElements = (XIndexAccess) UnoRuntime.queryInterface(
+                XIndexAccess.class, xSheets );
 
             // specify the first sheet from the spreadsheet
-            xSheet = (com.sun.star.sheet.XSpreadsheet) UnoRuntime.queryInterface(
-                com.sun.star.sheet.XSpreadsheet.class, xElements.getByIndex( 0 ));
+            xSheet = (XSpreadsheet) UnoRuntime.queryInterface(
+                XSpreadsheet.class, xElements.getByIndex( 0 ));
         }
         catch( Exception e) {
-            e.printStackTrace(System.out);
+            e.printStackTrace(System.err);
         }
 
         // get the interface to apply and create new numberformats
@@ -164,7 +147,9 @@ public class EuroAdaption {
     }
 
 
-    public static void Convert(  XSpreadsheet xSheet, XNumberFormats xNumberFormats, String sOldSymbol, String sNewSymbol, float fFactor ) {
+    public static void Convert( XSpreadsheet xSheet, XNumberFormats xNumberFormats,
+                                String sOldSymbol, String sNewSymbol,
+                                float fFactor ) {
         try {
             Locale xLanguage = new Locale();
             xLanguage.Country = "de";    // Germany -> DM
@@ -175,64 +160,89 @@ public class EuroAdaption {
             // create a number format key with the sNewSymbol
             int iSimpleKey = NumberFormat( xNumberFormats, sSimple, xLanguage );
 
-            // you have to use the FormatSupplier interface to get the CellFormat enumeration
-            XCellFormatRangesSupplier xCellFormatSupplier = (XCellFormatRangesSupplier)
-                UnoRuntime.queryInterface(XCellFormatRangesSupplier.class, xSheet );
+            // you have to use the FormatSupplier interface to get the
+            // CellFormat enumeration
+            XCellFormatRangesSupplier xCellFormatSupplier =
+                (XCellFormatRangesSupplier)UnoRuntime.queryInterface(
+                    XCellFormatRangesSupplier.class, xSheet );
 
             // getCellFormatRanges() has the interfaces for the enumeration
-            XEnumerationAccess xEnumerationAccess = (XEnumerationAccess)
-                UnoRuntime.queryInterface( XEnumerationAccess.class,
-                                           xCellFormatSupplier.getCellFormatRanges() );
+            XEnumerationAccess xEnumerationAccess =
+                (XEnumerationAccess)UnoRuntime.queryInterface(
+                    XEnumerationAccess.class,
+                    xCellFormatSupplier.getCellFormatRanges() );
+
             XEnumeration xRanges = xEnumerationAccess.createEnumeration();
 
+            // create an AnyConverter for later use
+            AnyConverter aAnyConv = new AnyConverter();
+
             while( xRanges.hasMoreElements() ) {
                 // the enumeration returns a cellrange
                 XCellRange xCellRange = (XCellRange) UnoRuntime.queryInterface(
                     XCellRange.class, xRanges.nextElement());
 
                 // the PropertySet the get and set the properties from the cellrange
-                XPropertySet xCellProp = ( XPropertySet ) UnoRuntime.queryInterface(
+                XPropertySet xCellProp = (XPropertySet)UnoRuntime.queryInterface(
                     XPropertySet.class, xCellRange );
 
-                // getPropertyValue returns an Object, you have to cast it to type that you need
+                // getPropertyValue returns an Object, you have to cast it to
+                // type that you need
                 Object oNumberObject = xCellProp.getPropertyValue( "NumberFormat" );
-                int iNumberFormat = ((Integer) oNumberObject).intValue();
+                int iNumberFormat = aAnyConv.toInt(oNumberObject);
 
                 // get the properties from the cellrange numberformat
-                XPropertySet xFormat = (XPropertySet) xNumberFormats.getByKey( iNumberFormat );
+                XPropertySet xFormat = (XPropertySet)
+                    xNumberFormats.getByKey(iNumberFormat );
 
-                short fType = ((Short) xFormat.getPropertyValue("Type")).shortValue();
-                String sCurrencySymbol = ((String) xFormat.getPropertyValue("CurrencySymbol")).toString();
+                short fType = aAnyConv.toShort(xFormat.getPropertyValue("Type"));
+                String sCurrencySymbol = aAnyConv.toString(
+                    xFormat.getPropertyValue("CurrencySymbol"));
 
-                // change the numberformat only on cellranges with a currency numberformat
+                // change the numberformat only on cellranges with a
+                // currency numberformat
                 if( ( (fType & com.sun.star.util.NumberFormat.CURRENCY) > 0) &&
                     ( sCurrencySymbol.compareTo( sOldSymbol ) == 0 ) ) {
-                    AnyConverter aAnyConv = new AnyConverter();
                     boolean bThousandSep = aAnyConv.toBoolean(
                         xFormat.getPropertyValue("ThousandsSeparator"));
-                    boolean bNegativeRed = aAnyConv.toBoolean(xFormat.getPropertyValue("NegativeRed"));
-                    short fDecimals = aAnyConv.toShort(xFormat.getPropertyValue("Decimals"));
-                    short fLeadingZeros = aAnyConv.toShort(xFormat.getPropertyValue("LeadingZeros"));
+                    boolean bNegativeRed = aAnyConv.toBoolean(
+                        xFormat.getPropertyValue("NegativeRed"));
+                    short fDecimals = aAnyConv.toShort(
+                        xFormat.getPropertyValue("Decimals"));
+                    short fLeadingZeros = aAnyConv.toShort(
+                        xFormat.getPropertyValue("LeadingZeros"));
                     Locale oLocale = (Locale) aAnyConv.toObject(
-                       new com.sun.star.uno.Type(Locale.class),xFormat.getPropertyValue("Locale"));
+                       new com.sun.star.uno.Type(Locale.class),
+                       xFormat.getPropertyValue("Locale"));
 
                     // create a new numberformat string
-                    String sNew = xNumberFormats.generateFormat( iSimpleKey, oLocale, bThousandSep, bNegativeRed, fDecimals, fLeadingZeros );
+                    String sNew = xNumberFormats.generateFormat( iSimpleKey,
+                                         oLocale, bThousandSep, bNegativeRed,
+                                         fDecimals, fLeadingZeros );
+
                     // get the NumberKey from the numberformat
-                    int iNewNumberFormat = NumberFormat( xNumberFormats, sNew, oLocale );
+                    int iNewNumberFormat = NumberFormat( xNumberFormats,
+                                                         sNew, oLocale );
 
                     // set the new numberformat to the cellrange DM->EUR
-                    xCellProp.setPropertyValue( "NumberFormat", new Integer( iNewNumberFormat ) );
+                    xCellProp.setPropertyValue( "NumberFormat",
+                                                new Integer( iNewNumberFormat ) );
 
-                    // interate over all cells from the cellrange with an content and use the DM/EUR factor
-                    XCellRangesQuery xCellRangesQuery = (XCellRangesQuery) UnoRuntime.queryInterface(
-                        com.sun.star.sheet.XCellRangesQuery.class, xCellRange );
-                    XSheetCellRanges xSheetCellRanges = xCellRangesQuery.queryContentCells(
-                        (short) com.sun.star.sheet.CellFlags.VALUE );
+                    // interate over all cells from the cellrange with an
+                    // content and use the DM/EUR factor
+                    XCellRangesQuery xCellRangesQuery = (XCellRangesQuery)
+                        UnoRuntime.queryInterface(
+                        XCellRangesQuery.class, xCellRange );
+
+                    XSheetCellRanges xSheetCellRanges =
+                        xCellRangesQuery.queryContentCells(
+                            (short) com.sun.star.sheet.CellFlags.VALUE );
 
                     if( xSheetCellRanges.getCount() > 0 ) {
-                        XEnumerationAccess xCellEnumerationAccess = xSheetCellRanges.getCells();
-                        XEnumeration xCellEnumeration = xCellEnumerationAccess.createEnumeration();
+                        XEnumerationAccess xCellEnumerationAccess =
+                            xSheetCellRanges.getCells();
+                        XEnumeration xCellEnumeration =
+                            xCellEnumerationAccess.createEnumeration();
 
                         while( xCellEnumeration.hasMoreElements() ) {
                             XCell xCell = (XCell) UnoRuntime.queryInterface(
@@ -244,12 +254,13 @@ public class EuroAdaption {
             }
         }
         catch( Exception e) {
-            e.printStackTrace(System.out);
+            e.printStackTrace(System.err);
         }
     }
 
 
-    public static int NumberFormat( XNumberFormats xNumberFormat, String sFormat, com.sun.star.lang.Locale xLanguage ) {
+    public static int NumberFormat( XNumberFormats xNumberFormat, String sFormat,
+                                    com.sun.star.lang.Locale xLanguage ) {
         int nRetKey = 0;
 
         try {
@@ -264,14 +275,15 @@ public class EuroAdaption {
             }
         }
         catch( Exception e) {
-            e.printStackTrace(System.out);
+            e.printStackTrace(System.err);
         }
 
         return( nRetKey );
     }
 
 
-    public static void createExampleData( XSpreadsheet xSheet, XNumberFormats xNumberFormat ) {
+    public static void createExampleData( XSpreadsheet xSheet,
+                                          XNumberFormats xNumberFormat ) {
 
         // enter in a cellrange numbers and change the numberformat to DM
         XCell xCell = null;
@@ -286,114 +298,95 @@ public class EuroAdaption {
             String sSimple = "0 [$DM]";
 
             // get the numberformat key
-            int iNumberFormatKey = NumberFormat( xNumberFormat, sSimple, xLanguage );
+            int iNumberFormatKey = NumberFormat(xNumberFormat, sSimple, xLanguage);
 
             for( int iCounter=1; iCounter < 10; iCounter++ ) {
                 // get one cell and insert a number
                 xCell = xSheet.getCellByPosition( 2, 1 + iCounter );
                 xCell.setValue( (double) iCounter * 2 );
-                xCellRange = xSheet.getCellRangeByPosition( 2, 1 + iCounter, 2, 1 + iCounter );
+                xCellRange = xSheet.getCellRangeByPosition( 2, 1 + iCounter,
+                                                            2, 1 + iCounter );
 
                 // get the ProperySet from the cell, to change the numberformat
-                XPropertySet xCellProp = ( XPropertySet ) UnoRuntime.queryInterface(
+                XPropertySet xCellProp = (XPropertySet)UnoRuntime.queryInterface(
                     XPropertySet.class, xCellRange );
-                xCellProp.setPropertyValue( "NumberFormat", new Integer(iNumberFormatKey) );
+                xCellProp.setPropertyValue( "NumberFormat",
+                                            new Integer(iNumberFormatKey) );
             }
         }
         catch( Exception e) {
-            e.printStackTrace(System.out);
+            e.printStackTrace(System.err);
         }
     }
 
+    public static XDesktop getDesktop() {
+        XDesktop xDesktop = null;
+        XMultiComponentFactory xMCF = null;
 
-    public static XMultiServiceFactory connect( String connectStr )
-    throws com.sun.star.uno.Exception,
-    com.sun.star.uno.RuntimeException, Exception {
-        // Get component context
-        XComponentContext xcomponentcontext =
-        com.sun.star.comp.helper.Bootstrap.createInitialComponentContext(
-        null );
-
-        // initial serviceManager
-        XMultiComponentFactory xLocalServiceManager =
-        xcomponentcontext.getServiceManager();
-
-        // create a connector, so that it can contact the office
-        Object  xUrlResolver  = xLocalServiceManager.createInstanceWithContext(
-        "com.sun.star.bridge.UnoUrlResolver", xcomponentcontext );
-        XUnoUrlResolver urlResolver = (XUnoUrlResolver)UnoRuntime.queryInterface( XUnoUrlResolver.class, xUrlResolver );
-
-        Object rInitialObject = urlResolver.resolve( connectStr );
-
-        XNamingService rName = (XNamingService)UnoRuntime.queryInterface(XNamingService.class, rInitialObject );
-
-        XMultiServiceFactory xMSF = null;
-        if( rName != null ) {
-            System.err.println( "got the remote naming service !" );
-            Object rXsmgr = rName.getRegisteredObject("StarOffice.ServiceManager" );
-
-            xMSF = (XMultiServiceFactory)
-            UnoRuntime.queryInterface( XMultiServiceFactory.class, rXsmgr );
-        }
-
-        return ( xMSF );
-    }
+        try {
+            XComponentContext xContext = null;
 
+            // get the remote office component context
+            xContext = com.sun.star.comp.helper.Bootstrap.bootstrap();
 
-    public static com.sun.star.frame.XDesktop getDesktop( XMultiServiceFactory xMSF ) {
-        XInterface xInterface = null;
-        com.sun.star.frame.XDesktop xDesktop = null;
+            // get the remote office service manager
+            xMCF = xContext.getServiceManager();
+            if( xMCF != null ) {
+                System.out.println("Connected to a running office ...");
 
-        if( xMSF != null ) {
-            try {
-                xInterface = (XInterface) xMSF.createInstance("com.sun.star.frame.Desktop");
-                xDesktop = (com.sun.star.frame.XDesktop) UnoRuntime.queryInterface(com.sun.star.frame.XDesktop.class, xInterface);
-            }
-            catch( Exception e) {
-                e.printStackTrace(System.out);
+                Object oDesktop = xMCF.createInstanceWithContext(
+                    "com.sun.star.frame.Desktop", xContext);
+                xDesktop = (XDesktop) UnoRuntime.queryInterface(
+                    XDesktop.class, oDesktop);
             }
+            else
+                System.out.println( "Can't create a desktop. No connection, no remote servicemanager available!" );
+        }
+        catch( Exception e) {
+            e.printStackTrace(System.err);
+            System.exit(1);
         }
-        else
-            System.out.println( "Can't create a desktop. null pointer !" );
+
 
         return xDesktop;
     }
 
 
-    public static com.sun.star.sheet.XSpreadsheetDocument createSheetdocument( com.sun.star.frame.XDesktop xDesktop ) {
-        com.sun.star.sheet.XSpreadsheetDocument aSheetDocument = null;
+    public static XSpreadsheetDocument createSheetdocument( XDesktop xDesktop ) {
+        XSpreadsheetDocument aSheetDocument = null;
 
         try {
-            com.sun.star.lang.XComponent xComponent = null;
+            XComponent xComponent = null;
             xComponent = CreateNewDocument( xDesktop, "scalc" );
 
-            aSheetDocument = (com.sun.star.sheet.XSpreadsheetDocument) UnoRuntime.queryInterface(com.sun.star.sheet.XSpreadsheetDocument.class, xComponent);
+            aSheetDocument = (XSpreadsheetDocument) UnoRuntime.queryInterface(
+                XSpreadsheetDocument.class, xComponent);
         }
         catch( Exception e) {
-            e.printStackTrace(System.out);
+            e.printStackTrace(System.err);
         }
 
         return aSheetDocument;
     }
 
-    protected static com.sun.star.lang.XComponent CreateNewDocument( com.sun.star.frame.XDesktop xDesktop, String sDocumentType ) {
+    protected static XComponent CreateNewDocument( XDesktop xDesktop,
+                                                   String sDocumentType ) {
         String sURL = "private:factory/" + sDocumentType;
 
-        com.sun.star.lang.XComponent xComponent = null;
+        XComponent xComponent = null;
+        XComponentLoader xComponentLoader = null;
         PropertyValue xValues[] = new PropertyValue[1];
-
-        com.sun.star.frame.XComponentLoader xComponentLoader = null;
-        XInterface xInterface = null;
-
-        PropertyValue[] xEmptyArgs = new PropertyValue[0];
-
-        xComponentLoader = (com.sun.star.frame.XComponentLoader) UnoRuntime.queryInterface(com.sun.star.frame.XComponentLoader.class, xDesktop );
+        PropertyValue xEmptyArgs[] = new PropertyValue[0];
 
         try {
-            xComponent  = xComponentLoader.loadComponentFromURL( sURL, "_blank", 0, xEmptyArgs);
+            xComponentLoader = (XComponentLoader) UnoRuntime.queryInterface(
+                XComponentLoader.class, xDesktop );
+
+            xComponent  = xComponentLoader.loadComponentFromURL(
+                sURL, "_blank", 0, xEmptyArgs);
         }
         catch( Exception e) {
-            e.printStackTrace(System.out);
+            e.printStackTrace(System.err);
         }
 
         return xComponent ;