odk/examples/DevelopersGuide/Spreadsheet/ExampleDataPilotSource.java

   1 import com.sun.star.sheet.DataPilotFieldFilter;
   2
   3 /*************************************************************************
   4  *
   5  *  The Contents of this file are made available subject to the terms of
   6  *  the BSD license.
   7  *
   8  *  Copyright 2000, 2010 Oracle and/or its affiliates.
   9  *  All rights reserved.
  10  *
  11  *  Redistribution and use in source and binary forms, with or without
  12  *  modification, are permitted provided that the following conditions
  13  *  are met:
  14  *  1. Redistributions of source code must retain the above copyright
  15  *     notice, this list of conditions and the following disclaimer.
  16  *  2. Redistributions in binary form must reproduce the above copyright
  17  *     notice, this list of conditions and the following disclaimer in the
  18  *     documentation and/or other materials provided with the distribution.
  19  *  3. Neither the name of Sun Microsystems, Inc. nor the names of its
  20  *     contributors may be used to endorse or promote products derived
  21  *     from this software without specific prior written permission.
  22  *
  23  *  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
  24  *  "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
  25  *  LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
  26  *  FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
  27  *  COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
  28  *  INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
  29  *  BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
  30  *  OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
  31  *  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR
  32  *  TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE
  33  *  USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  34  *
  35  *************************************************************************/
  36
  37 //  Example DataPilot source component
  38
  39 //  helper class to hold the settings
  40
  41 class ExampleSettings
  42 {
  43     static public final int nDimensionCount = 6;
  44     static public final int nValueDimension = 4;
  45     static public final int nDataDimension = 5;
  46     static public final String [] aDimensionNames = {
  47         "ones", "tens", "hundreds", "thousands", "value", "" };
  48
  49     static public final String getMemberName( int nMember )
  50     {
  51         return String.valueOf( nMember );
  52     }
  53
  54     public int nMemberCount = 3;
  55     public java.util.List<Integer> aColDimensions = new java.util.ArrayList<Integer>();
  56     public java.util.List<Integer> aRowDimensions = new java.util.ArrayList<Integer>();
  57 }
  58
  59 //  XPropertySetInfo implementation for getPropertySetInfo
  60
  61 class ExamplePropertySetInfo implements com.sun.star.beans.XPropertySetInfo
  62 {
  63     private final com.sun.star.beans.Property[] aProperties;
  64
  65     public ExamplePropertySetInfo( com.sun.star.beans.Property[] aProps )
  66     {
  67         aProperties = aProps;
  68     }
  69
  70     public com.sun.star.beans.Property[] getProperties()
  71     {
  72         return aProperties;
  73     }
  74
  75     public com.sun.star.beans.Property getPropertyByName( String aName )
  76                     throws com.sun.star.beans.UnknownPropertyException
  77     {
  78         for ( int i=0; i<aProperties.length; i++ )
  79             if ( aProperties[i].Name.equals( aName ) )
  80                 return aProperties[i];
  81         throw new com.sun.star.beans.UnknownPropertyException();
  82     }
  83
  84     public boolean hasPropertyByName( String aName )
  85     {
  86         for ( int i=0; i<aProperties.length; i++ )
  87             if ( aProperties[i].Name.equals( aName ) )
  88                 return true;
  89         return false;
  90     }
  91 }
  92
  93 //  implementation of com.sun.star.sheet.DataPilotSourceMember
  94
  95 class ExampleMember implements com.sun.star.container.XNamed,
  96       com.sun.star.beans.XPropertySet
  97 {
  98     private final int nMember;
  99
 100     public ExampleMember( int nMbr )
 101     {
 102         nMember = nMbr;
 103     }
 104
 105     //  XNamed
 106
 107     public String getName()
 108     {
 109         return ExampleSettings.getMemberName( nMember );
 110     }
 111
 112     public void setName( String aName )
 113     {
 114         // ignored
 115     }
 116
 117     //  XPropertySet
 118
 119     public com.sun.star.beans.XPropertySetInfo getPropertySetInfo()
 120     {
 121         return new ExamplePropertySetInfo( new com.sun.star.beans.Property[] {
 122             new com.sun.star.beans.Property( "IsVisible",   -1,
 123                         new com.sun.star.uno.Type( Boolean.class ), (short) 0),
 124             new com.sun.star.beans.Property( "ShowDetails", -1,
 125                         new com.sun.star.uno.Type( Boolean.class ), (short) 0) });
 126     }
 127
 128     public void setPropertyValue( String aPropertyName, Object aValue )
 129         throws com.sun.star.beans.UnknownPropertyException
 130     {
 131         if ( aPropertyName.equals( "IsVisible" ) ||
 132              aPropertyName.equals( "ShowDetails" ) )
 133         {
 134             // ignored
 135         }
 136         else
 137             throw new com.sun.star.beans.UnknownPropertyException();
 138     }
 139
 140     public Object getPropertyValue( String aPropertyName )
 141         throws com.sun.star.beans.UnknownPropertyException
 142     {
 143         if ( aPropertyName.equals( "IsVisible" ) ||
 144              aPropertyName.equals( "ShowDetails" ) )
 145         {
 146             return Boolean.TRUE;     // always true
 147         }
 148         else
 149             throw new com.sun.star.beans.UnknownPropertyException();
 150     }
 151
 152     public void addPropertyChangeListener(
 153         String aPropertyName, com.sun.star.beans.XPropertyChangeListener xListener)
 154     {
 155     }
 156     public void removePropertyChangeListener(
 157         String aPropertyName, com.sun.star.beans.XPropertyChangeListener aListener)
 158     {
 159     }
 160     public void addVetoableChangeListener(
 161         String PropertyName, com.sun.star.beans.XVetoableChangeListener aListener)
 162     {
 163     }
 164     public void removeVetoableChangeListener(
 165         String PropertyName, com.sun.star.beans.XVetoableChangeListener aListener)
 166     {
 167     }
 168 }
 169
 170 //  implementation of com.sun.star.sheet.DataPilotSourceMembers
 171
 172 class ExampleMembers implements com.sun.star.container.XNameAccess
 173 {
 174     private final ExampleSettings aSettings;
 175     private ExampleMember[] aMembers;
 176
 177     public ExampleMembers( ExampleSettings aSet )
 178     {
 179         aSettings = aSet;
 180         aMembers = new ExampleMember[ aSettings.nMemberCount ];
 181     }
 182
 183     //  XNameAccess
 184
 185     public com.sun.star.uno.Type getElementType()
 186     {
 187         return new com.sun.star.uno.Type( com.sun.star.container.XNamed.class );
 188     }
 189
 190     public boolean hasElements()
 191     {
 192         return true;    // always has elements
 193     }
 194
 195     public Object getByName( String aName )
 196         throws com.sun.star.container.NoSuchElementException
 197     {
 198         int nCount = aSettings.nMemberCount;
 199         for ( int i=0; i<nCount; i++ )
 200             if ( aName.equals( ExampleSettings.getMemberName( i ) ) )
 201             {
 202                 if ( aMembers[i] == null )
 203                     aMembers[i] = new ExampleMember( i );
 204                 return aMembers[i];
 205             }
 206         throw new com.sun.star.container.NoSuchElementException();
 207     }
 208
 209     public String[] getElementNames()
 210     {
 211         int nCount = aSettings.nMemberCount;
 212         String [] aNames = new String[ nCount ];
 213         for ( int i=0; i<nCount; i++ )
 214             aNames[i] = ExampleSettings.getMemberName( i );
 215         return aNames;
 216     }
 217
 218     public boolean hasByName( String aName )
 219     {
 220         int nCount = aSettings.nMemberCount;
 221         for ( int i=0; i<nCount; i++ )
 222             if ( aName.equals( ExampleSettings.getMemberName( i ) ) )
 223                 return true;
 224         return false;
 225     }
 226 }
 227
 228 //  implementation of com.sun.star.sheet.DataPilotSourceLevel
 229
 230 class ExampleLevel implements
 231                     com.sun.star.container.XNamed,
 232                     com.sun.star.sheet.XMembersSupplier,
 233                     com.sun.star.sheet.XDataPilotMemberResults,
 234                     com.sun.star.beans.XPropertySet
 235 {
 236     private final ExampleSettings aSettings;
 237     private final int nDimension;
 238     private ExampleMembers aMembers;
 239
 240     public ExampleLevel( ExampleSettings aSet, int nDim )
 241     {
 242         aSettings = aSet;
 243         nDimension = nDim;
 244     }
 245
 246     // XNamed
 247
 248     public String getName()
 249     {
 250         return ExampleSettings.aDimensionNames[ nDimension ];
 251     }
 252
 253     public void setName( String aName )
 254     {
 255         // ignored
 256     }
 257
 258     // XMembersSupplier
 259
 260     public com.sun.star.container.XNameAccess getMembers()
 261     {
 262         if ( aMembers == null )
 263             aMembers = new ExampleMembers( aSettings );
 264         return aMembers;
 265     }
 266
 267     // XDataPilotMemberResults
 268
 269     public com.sun.star.sheet.MemberResult[] getResults()
 270     {
 271         int nDimensions = 0;
 272         int nPosition = aSettings.aColDimensions.indexOf( Integer.valueOf(nDimension));
 273         if ( nPosition >= 0 )
 274             nDimensions = aSettings.aColDimensions.size();
 275         else
 276         {
 277             nPosition = aSettings.aRowDimensions.indexOf( Integer.valueOf(nDimension));
 278             if ( nPosition >= 0 )
 279                 nDimensions = aSettings.aRowDimensions.size();
 280         }
 281
 282         if ( nPosition < 0 )
 283             return new com.sun.star.sheet.MemberResult[0];
 284
 285         int nMembers = aSettings.nMemberCount;
 286         int nRepeat = 1;
 287         int nFill = 1;
 288         for ( int i=0; i<nDimensions; i++ )
 289         {
 290             if ( i < nPosition )
 291                 nRepeat *= nMembers;
 292             else if ( i > nPosition )
 293                 nFill *= nMembers;
 294         }
 295         int nSize = nRepeat * nMembers * nFill;
 296
 297         com.sun.star.sheet.MemberResult[] aResults =
 298             new com.sun.star.sheet.MemberResult[nSize];
 299         int nResultPos = 0;
 300         for (int nOuter=0; nOuter<nRepeat; nOuter++)
 301         {
 302             for (int nMember=0; nMember<nMembers; nMember++)
 303             {
 304                 aResults[nResultPos] = new com.sun.star.sheet.MemberResult();
 305                 aResults[nResultPos].Name = ExampleSettings.getMemberName(nMember);
 306                 aResults[nResultPos].Caption = aResults[nResultPos].Name;
 307                 aResults[nResultPos].Flags =
 308                     com.sun.star.sheet.MemberResultFlags.HASMEMBER;
 309                 ++nResultPos;
 310
 311                 for (int nInner=1; nInner<nFill; nInner++)
 312                 {
 313                     aResults[nResultPos] = new com.sun.star.sheet.MemberResult();
 314                     aResults[nResultPos].Flags =
 315                         com.sun.star.sheet.MemberResultFlags.CONTINUE;
 316                     ++nResultPos;
 317                 }
 318             }
 319         }
 320         return aResults;
 321     }
 322
 323     //  XPropertySet
 324
 325     public com.sun.star.beans.XPropertySetInfo getPropertySetInfo()
 326     {
 327         return new ExamplePropertySetInfo( new com.sun.star.beans.Property[] {
 328             new com.sun.star.beans.Property( "SubTotals", -1,
 329                             new com.sun.star.uno.Type(
 330                                 com.sun.star.sheet.GeneralFunction[].class ),
 331                                              (short) 0 ),
 332             new com.sun.star.beans.Property( "ShowEmpty", -1,
 333                              new com.sun.star.uno.Type( Boolean.class ),
 334                                              (short) 0 ) } );
 335     }
 336
 337     public void setPropertyValue( String aPropertyName, Object aValue )
 338         throws com.sun.star.beans.UnknownPropertyException
 339     {
 340         if ( aPropertyName.equals( "SubTotals" ) ||
 341              aPropertyName.equals( "ShowEmpty" ) )
 342         {
 343             // ignored
 344         }
 345         else
 346             throw new com.sun.star.beans.UnknownPropertyException();
 347     }
 348
 349     public Object getPropertyValue( String aPropertyName )
 350         throws com.sun.star.beans.UnknownPropertyException
 351     {
 352         if ( aPropertyName.equals( "SubTotals" ) )
 353             return new com.sun.star.sheet.GeneralFunction[0];
 354         else if ( aPropertyName.equals( "ShowEmpty" ) )
 355             return Boolean.TRUE;
 356         else
 357             throw new com.sun.star.beans.UnknownPropertyException();
 358     }
 359
 360     public void addPropertyChangeListener(
 361         String aPropertyName, com.sun.star.beans.XPropertyChangeListener xListener)
 362     {
 363     }
 364     public void removePropertyChangeListener(
 365         String aPropertyName, com.sun.star.beans.XPropertyChangeListener aListener)
 366     {
 367     }
 368     public void addVetoableChangeListener(
 369         String PropertyName, com.sun.star.beans.XVetoableChangeListener aListener)
 370     {
 371     }
 372     public void removeVetoableChangeListener(
 373         String PropertyName, com.sun.star.beans.XVetoableChangeListener aListener)
 374     {
 375     }
 376 }
 377
 378 //  implementation of com.sun.star.sheet.DataPilotSourceLevels
 379
 380 class ExampleLevels implements com.sun.star.container.XNameAccess
 381 {
 382     private final ExampleSettings aSettings;
 383     private final int nDimension;
 384     private ExampleLevel aLevel;
 385
 386     public ExampleLevels( ExampleSettings aSet, int nDim )
 387     {
 388         aSettings = aSet;
 389         nDimension = nDim;
 390     }
 391
 392     // XNameAccess
 393
 394     public com.sun.star.uno.Type getElementType()
 395     {
 396         return new com.sun.star.uno.Type( com.sun.star.container.XNamed.class );
 397     }
 398
 399     public boolean hasElements()
 400     {
 401         return true;    // always has elements
 402     }
 403
 404     public Object getByName( String aName )
 405         throws com.sun.star.container.NoSuchElementException
 406     {
 407         //  there's only one level with the same name as the dimension / hierarchy
 408         if ( aName.equals( ExampleSettings.aDimensionNames[nDimension] ) )
 409         {
 410             if ( aLevel == null )
 411                 aLevel = new ExampleLevel( aSettings, nDimension );
 412             return aLevel;
 413         }
 414         throw new com.sun.star.container.NoSuchElementException();
 415     }
 416
 417     public String[] getElementNames()
 418     {
 419         String [] aNames = new String[ 1 ];
 420         aNames[0] = ExampleSettings.aDimensionNames[nDimension];
 421         return aNames;
 422     }
 423
 424     public boolean hasByName( String aName )
 425     {
 426         return aName.equals( ExampleSettings.aDimensionNames[nDimension] );
 427     }
 428 }
 429
 430 //  implementation of com.sun.star.sheet.DataPilotSourceHierarchy
 431
 432 class ExampleHierarchy implements com.sun.star.container.XNamed,
 433       com.sun.star.sheet.XLevelsSupplier
 434 {
 435     private final ExampleSettings aSettings;
 436     private final int nDimension;
 437     private ExampleLevels aLevels;
 438
 439     public ExampleHierarchy( ExampleSettings aSet, int nDim )
 440     {
 441         aSettings = aSet;
 442         nDimension = nDim;
 443     }
 444
 445     // XNamed
 446
 447     public String getName()
 448     {
 449         return ExampleSettings.aDimensionNames[ nDimension ];
 450     }
 451
 452     public void setName( String aName )
 453     {
 454         // ignored
 455     }
 456
 457     // XLevelsSupplier
 458
 459     public com.sun.star.container.XNameAccess getLevels()
 460     {
 461         if ( aLevels == null )
 462             aLevels = new ExampleLevels( aSettings, nDimension );
 463         return aLevels;
 464     }
 465 }
 466
 467 //  implementation of com.sun.star.sheet.DataPilotSourceHierarchies
 468
 469 class ExampleHierarchies implements com.sun.star.container.XNameAccess
 470 {
 471     private final ExampleSettings aSettings;
 472     private final int nDimension;
 473     private ExampleHierarchy aHierarchy;
 474
 475     public ExampleHierarchies( ExampleSettings aSet, int nDim )
 476     {
 477         aSettings = aSet;
 478         nDimension = nDim;
 479     }
 480
 481     //  XNameAccess
 482
 483     public com.sun.star.uno.Type getElementType()
 484     {
 485         return new com.sun.star.uno.Type( com.sun.star.container.XNamed.class );
 486     }
 487
 488     public boolean hasElements()
 489     {
 490         return true;    // always has elements
 491     }
 492
 493     public Object getByName( String aName )
 494         throws com.sun.star.container.NoSuchElementException
 495     {
 496         //  there's only one hierarchy with the same name as the dimension
 497         if ( aName.equals( ExampleSettings.aDimensionNames[nDimension] ) )
 498         {
 499             if ( aHierarchy == null )
 500                 aHierarchy = new ExampleHierarchy( aSettings, nDimension );
 501             return aHierarchy;
 502         }
 503         throw new com.sun.star.container.NoSuchElementException();
 504     }
 505
 506     public String[] getElementNames()
 507     {
 508         String [] aNames = new String[ 1 ];
 509         aNames[0] = ExampleSettings.aDimensionNames[nDimension];
 510         return aNames;
 511     }
 512
 513     public boolean hasByName( String aName )
 514     {
 515         return aName.equals( ExampleSettings.aDimensionNames[nDimension] );
 516     }
 517 }
 518
 519 //  implementation of com.sun.star.sheet.DataPilotSourceDimension
 520
 521 class ExampleDimension implements
 522                     com.sun.star.container.XNamed,
 523                     com.sun.star.sheet.XHierarchiesSupplier,
 524                     com.sun.star.util.XCloneable,
 525                     com.sun.star.beans.XPropertySet
 526 {
 527     private final ExampleSettings aSettings;
 528     private final int nDimension;
 529     private ExampleHierarchies aHierarchies;
 530     private com.sun.star.sheet.DataPilotFieldOrientation eOrientation;
 531
 532     public ExampleDimension( ExampleSettings aSet, int nDim )
 533     {
 534         aSettings = aSet;
 535         nDimension = nDim;
 536         eOrientation = ( nDim == ExampleSettings.nValueDimension ) ?
 537             com.sun.star.sheet.DataPilotFieldOrientation.DATA :
 538             com.sun.star.sheet.DataPilotFieldOrientation.HIDDEN;
 539     }
 540
 541     //  XNamed
 542
 543     public String getName()
 544     {
 545         return ExampleSettings.aDimensionNames[ nDimension ];
 546     }
 547
 548     public void setName( String aName )
 549     {
 550         // ignored
 551     }
 552
 553     //  XHierarchiesSupplier
 554
 555     public com.sun.star.container.XNameAccess getHierarchies()
 556     {
 557         if ( aHierarchies == null )
 558             aHierarchies = new ExampleHierarchies( aSettings, nDimension );
 559         return aHierarchies;
 560     }
 561
 562     //  XCloneable
 563
 564     public com.sun.star.util.XCloneable createClone()
 565     {
 566         return null;        // not supported
 567     }
 568
 569     //  XPropertySet
 570
 571     public com.sun.star.beans.XPropertySetInfo getPropertySetInfo()
 572     {
 573         return new ExamplePropertySetInfo( new com.sun.star.beans.Property[] {
 574             new com.sun.star.beans.Property( "Original", -1,
 575                 new com.sun.star.uno.Type( com.sun.star.container.XNamed.class),
 576                 com.sun.star.beans.PropertyAttribute.READONLY ),
 577             new com.sun.star.beans.Property( "IsDataLayoutDimension", -1,
 578                 new com.sun.star.uno.Type( Boolean.class),
 579                 com.sun.star.beans.PropertyAttribute.READONLY ),
 580             new com.sun.star.beans.Property( "Orientation", -1,
 581                 new com.sun.star.uno.Type(
 582                   com.sun.star.sheet.DataPilotFieldOrientation.class), (short) 0),
 583             new com.sun.star.beans.Property( "Position", -1,
 584                 new com.sun.star.uno.Type( Integer.class ), (short) 0),
 585             new com.sun.star.beans.Property( "Function", -1,
 586                 new com.sun.star.uno.Type(com.sun.star.sheet.GeneralFunction.class),
 587                                              (short) 0 ),
 588             new com.sun.star.beans.Property( "UsedHierarchy", -1,
 589                 new com.sun.star.uno.Type( Integer.class ), (short) 0 ),
 590             new com.sun.star.beans.Property( "Filter", -1,
 591                 new com.sun.star.uno.Type(
 592                     com.sun.star.sheet.TableFilterField[].class), (short) 0) });
 593     }
 594
 595     public void setPropertyValue( String aPropertyName, Object aValue )
 596                     throws com.sun.star.beans.UnknownPropertyException
 597     {
 598         if ( aPropertyName.equals( "Orientation" ) )
 599         {
 600             com.sun.star.sheet.DataPilotFieldOrientation eNewOrient =
 601                         (com.sun.star.sheet.DataPilotFieldOrientation) aValue;
 602             if ( nDimension != ExampleSettings.nValueDimension &&
 603                  nDimension != ExampleSettings.nDataDimension &&
 604                  eNewOrient != com.sun.star.sheet.DataPilotFieldOrientation.DATA )
 605             {
 606                 // remove from list for old orientation and add for new one
 607                 Integer aDimInt = Integer.valueOf(nDimension);
 608                 if ( eOrientation == com.sun.star.sheet.DataPilotFieldOrientation.COLUMN )
 609                     aSettings.aColDimensions.remove( aDimInt );
 610                 else if ( eOrientation == com.sun.star.sheet.DataPilotFieldOrientation.ROW )
 611                     aSettings.aRowDimensions.remove( aDimInt );
 612                 if ( eNewOrient == com.sun.star.sheet.DataPilotFieldOrientation.COLUMN )
 613                     aSettings.aColDimensions.add( aDimInt );
 614                 else if ( eNewOrient == com.sun.star.sheet.DataPilotFieldOrientation.ROW )
 615                     aSettings.aRowDimensions.add( aDimInt );
 616
 617                 // change orientation
 618                 eOrientation = eNewOrient;
 619             }
 620         }
 621         else if ( aPropertyName.equals( "Position" ) )
 622         {
 623             int nNewPos = ((Integer) aValue).intValue();
 624             Integer aDimInt = Integer.valueOf(nDimension);
 625             if ( eOrientation == com.sun.star.sheet.DataPilotFieldOrientation.COLUMN )
 626             {
 627                 aSettings.aColDimensions.remove( aDimInt );
 628                 aSettings.aColDimensions.add( nNewPos, aDimInt );
 629             }
 630             else if ( eOrientation == com.sun.star.sheet.DataPilotFieldOrientation.ROW )
 631             {
 632                 aSettings.aRowDimensions.remove( aDimInt );
 633                 aSettings.aRowDimensions.add( nNewPos, aDimInt );
 634             }
 635         }
 636         else if ( aPropertyName.equals( "Function" ) || aPropertyName.equals( "UsedHierarchy" ) ||
 637                   aPropertyName.equals( "Filter" ) )
 638         {
 639             // ignored
 640         }
 641         else
 642             throw new com.sun.star.beans.UnknownPropertyException();
 643     }
 644
 645     public Object getPropertyValue( String aPropertyName )
 646                     throws com.sun.star.beans.UnknownPropertyException
 647     {
 648         if ( aPropertyName.equals( "Original" ) )
 649             return null;
 650         else if ( aPropertyName.equals( "IsDataLayoutDimension" ) )
 651             return Boolean.valueOf( nDimension == ExampleSettings.nDataDimension );
 652         else if ( aPropertyName.equals( "Orientation" ) )
 653             return eOrientation;
 654         else if ( aPropertyName.equals( "Position" ) )
 655         {
 656             int nPosition;
 657             if ( eOrientation == com.sun.star.sheet.DataPilotFieldOrientation.COLUMN )
 658                 nPosition = aSettings.aColDimensions.indexOf( Integer.valueOf(nDimension) );
 659             else if ( eOrientation == com.sun.star.sheet.DataPilotFieldOrientation.ROW )
 660                 nPosition = aSettings.aRowDimensions.indexOf( Integer.valueOf(nDimension) );
 661             else
 662                 nPosition = nDimension;
 663             return Integer.valueOf( nPosition );
 664         }
 665         else if ( aPropertyName.equals( "Function" ) )
 666             return com.sun.star.sheet.GeneralFunction.SUM;
 667         else if ( aPropertyName.equals( "UsedHierarchy" ) )
 668             return Integer.valueOf(0);
 669         else if ( aPropertyName.equals( "Filter" ) )
 670             return new com.sun.star.sheet.TableFilterField[0];
 671         else
 672             throw new com.sun.star.beans.UnknownPropertyException();
 673     }
 674
 675     public void addPropertyChangeListener(
 676         String aPropertyName, com.sun.star.beans.XPropertyChangeListener xListener)
 677     {
 678     }
 679     public void removePropertyChangeListener(
 680         String aPropertyName, com.sun.star.beans.XPropertyChangeListener aListener)
 681     {
 682     }
 683     public void addVetoableChangeListener(
 684         String PropertyName, com.sun.star.beans.XVetoableChangeListener aListener)
 685     {
 686     }
 687     public void removeVetoableChangeListener(
 688         String PropertyName, com.sun.star.beans.XVetoableChangeListener aListener)
 689     {
 690     }
 691 }
 692
 693 //  implementation of com.sun.star.sheet.DataPilotSourceDimensions
 694
 695 class ExampleDimensions implements com.sun.star.container.XNameAccess
 696 {
 697     private final ExampleSettings aSettings;
 698     private ExampleDimension[] aDimensions;
 699
 700     public ExampleDimensions( ExampleSettings aSet )
 701     {
 702         aSettings = aSet;
 703     }
 704
 705     //  XNameAccess
 706
 707     public com.sun.star.uno.Type getElementType()
 708     {
 709         return new com.sun.star.uno.Type( com.sun.star.container.XNamed.class );
 710     }
 711
 712     public boolean hasElements()
 713     {
 714         return true;    // always has elements
 715     }
 716
 717     public Object getByName( String aName )
 718         throws com.sun.star.container.NoSuchElementException
 719     {
 720         for (int i=0; i<ExampleSettings.nDimensionCount; i++)
 721             if ( aName.equals( ExampleSettings.aDimensionNames[i] ) )
 722             {
 723                 if ( aDimensions == null )
 724                     aDimensions = new ExampleDimension[ ExampleSettings.nDimensionCount ];
 725                 if ( aDimensions[i] == null )
 726                     aDimensions[i] = new ExampleDimension( aSettings, i );
 727                 return aDimensions[i];
 728             }
 729         throw new com.sun.star.container.NoSuchElementException();
 730     }
 731
 732     public String[] getElementNames()
 733     {
 734         String [] aNames = new String[ ExampleSettings.nDimensionCount ];
 735         for (int i=0; i<ExampleSettings.nDimensionCount; i++)
 736             aNames[ i ] = ExampleSettings.aDimensionNames[i];
 737         return aNames;
 738     }
 739
 740     public boolean hasByName( String aName )
 741     {
 742         for (int i=0; i<ExampleSettings.nDimensionCount; i++)
 743             if ( aName.equals( ExampleSettings.aDimensionNames[i] ) )
 744                 return true;
 745         return false;
 746     }
 747 }
 748
 749 //  outer class for service implementation
 750
 751 public class ExampleDataPilotSource
 752 {
 753     //  implementation of com.sun.star.sheet.DataPilotSource
 754
 755     static public class _ExampleDataPilotSource implements
 756                         com.sun.star.sheet.XDimensionsSupplier,
 757                         com.sun.star.sheet.XDataPilotResults,
 758                         com.sun.star.util.XRefreshable,
 759                         com.sun.star.beans.XPropertySet,
 760                         com.sun.star.lang.XInitialization,
 761                         com.sun.star.lang.XServiceInfo
 762     {
 763         static private final String aServiceName = "com.sun.star.sheet.DataPilotSource";
 764         static private final String aImplName =  _ExampleDataPilotSource.class.getName();
 765
 766         private final ExampleSettings aSettings = new ExampleSettings();
 767         private ExampleDimensions aDimensions;
 768
 769         public _ExampleDataPilotSource( com.sun.star.lang.XMultiServiceFactory xFactory )
 770         {
 771         }
 772
 773         //  XInitialization
 774
 775         public void initialize( Object[] aArguments )
 776         {
 777             //  If the first argument (Source) is a number between 2 and 10,
 778             //  use it as member count, otherwise keep the default value.
 779             try
 780             {
 781         if ( aArguments.length >= 1 )
 782         {
 783             String aSource = com.sun.star.uno.AnyConverter.toString(aArguments[0]);
 784             if ( aSource != null && aSource.length() > 0)
 785             {
 786             int nValue = Integer.parseInt( aSource );
 787             if ( nValue >= 2 && nValue <= 10 )
 788                 aSettings.nMemberCount = nValue;
 789             }
 790         }
 791         }
 792         catch ( NumberFormatException e )
 793         {
 794         System.out.println( "Error: caught exception in " +
 795                     "ExampleDataPilotSource.initialize!\nException Message = "
 796                     + e.getMessage());
 797         e.printStackTrace();
 798         }
 799         catch ( com.sun.star.lang.IllegalArgumentException e )
 800         {
 801         System.out.println( "Error: caught exception in " +
 802                     "ExampleDataPilotSource.initialize!\nException Message = "
 803                     + e.getMessage());
 804         e.printStackTrace();
 805         }
 806         }
 807
 808         //  XDataPilotResults
 809
 810         public com.sun.star.sheet.DataResult[][] getResults()
 811         {
 812             int[] nDigits = new int[ExampleSettings.nDimensionCount];
 813             int nValue = 1;
 814             for (int i=0; i<ExampleSettings.nDimensionCount; i++)
 815             {
 816                 nDigits[i] = nValue;
 817                 nValue *= 10;
 818             }
 819
 820             int nMemberCount = aSettings.nMemberCount;
 821             int nRowDimCount = aSettings.aRowDimensions.size();
 822             int nColDimCount = aSettings.aColDimensions.size();
 823
 824             int nRows = 1;
 825             for (int i=0; i<nRowDimCount; i++)
 826                 nRows *= nMemberCount;
 827             int nColumns = 1;
 828             for (int i=0; i<nColDimCount; i++)
 829                 nColumns *= nMemberCount;
 830
 831             com.sun.star.sheet.DataResult[][] aResults = new com.sun.star.sheet.DataResult[nRows][];
 832             for (int nRow=0; nRow<nRows; nRow++)
 833             {
 834                 int nRowVal = nRow;
 835                 int nRowResult = 0;
 836                 for (int nRowDim=0; nRowDim<nRowDimCount; nRowDim++)
 837                 {
 838                     int nDim = aSettings.aRowDimensions.get(nRowDimCount-nRowDim-1).intValue();
 839                     nRowResult += ( nRowVal % nMemberCount ) * nDigits[nDim];
 840                     nRowVal /= nMemberCount;
 841                 }
 842
 843                 aResults[nRow] = new com.sun.star.sheet.DataResult[nColumns];
 844                 for (int nCol=0; nCol<nColumns; nCol++)
 845                 {
 846                     int nColVal = nCol;
 847                     int nResult = nRowResult;
 848                     for (int nColDim=0; nColDim<nColDimCount; nColDim++)
 849                     {
 850                         int nDim = aSettings.aColDimensions.get(nColDimCount-nColDim-1).intValue();
 851                         nResult += ( nColVal % nMemberCount ) * nDigits[nDim];
 852                         nColVal /= nMemberCount;
 853                     }
 854
 855                     aResults[nRow][nCol] = new com.sun.star.sheet.DataResult();
 856                     aResults[nRow][nCol].Flags = com.sun.star.sheet.DataResultFlags.HASDATA;
 857                     aResults[nRow][nCol].Value = nResult;
 858                 }
 859             }
 860             return aResults;
 861         }
 862
 863         public double[] getFilteredResults(DataPilotFieldFilter[] aFilters) {
 864             // FIXME
 865             return new double[0];
 866         }
 867
 868         //  XDimensionsSupplier
 869
 870         public com.sun.star.container.XNameAccess getDimensions()
 871         {
 872             if ( aDimensions == null )
 873                 aDimensions = new ExampleDimensions( aSettings );
 874             return aDimensions;
 875         }
 876
 877         //  XPropertySet
 878
 879         public com.sun.star.beans.XPropertySetInfo getPropertySetInfo()
 880         {
 881             return new ExamplePropertySetInfo( new com.sun.star.beans.Property[] {
 882                 new com.sun.star.beans.Property( "ColumnGrand", -1,
 883                        new com.sun.star.uno.Type( Boolean.class ), (short) 0),
 884                 new com.sun.star.beans.Property( "RowGrand", -1,
 885                        new com.sun.star.uno.Type( Boolean.class ), (short) 0) });
 886         }
 887
 888         public void setPropertyValue( String aPropertyName, Object aValue )
 889             throws com.sun.star.beans.UnknownPropertyException
 890         {
 891             if ( aPropertyName.equals( "ColumnGrand" ) ||
 892                  aPropertyName.equals( "RowGrand" ) )
 893             {
 894                 // ignored
 895             }
 896             else
 897                 throw new com.sun.star.beans.UnknownPropertyException();
 898         }
 899
 900         public Object getPropertyValue( String aPropertyName )
 901             throws com.sun.star.beans.UnknownPropertyException
 902         {
 903             if ( aPropertyName.equals( "ColumnGrand" ) ||
 904                  aPropertyName.equals( "RowGrand" ) )
 905             {
 906                 return Boolean.FALSE;        // always false
 907             }
 908             else
 909                 throw new com.sun.star.beans.UnknownPropertyException();
 910         }
 911
 912         public void addPropertyChangeListener(
 913             String aPropertyName,
 914             com.sun.star.beans.XPropertyChangeListener xListener )
 915         {
 916         }
 917         public void removePropertyChangeListener(
 918             String aPropertyName,
 919             com.sun.star.beans.XPropertyChangeListener aListener )
 920         {
 921         }
 922         public void addVetoableChangeListener(
 923             String PropertyName,
 924             com.sun.star.beans.XVetoableChangeListener aListener )
 925         {
 926         }
 927         public void removeVetoableChangeListener(
 928             String PropertyName,
 929             com.sun.star.beans.XVetoableChangeListener aListener )
 930         {
 931         }
 932
 933         //  XRefreshable
 934
 935         public void refresh()
 936         {
 937         }
 938         public void addRefreshListener( com.sun.star.util.XRefreshListener l )
 939         {
 940         }
 941         public void removeRefreshListener( com.sun.star.util.XRefreshListener l )
 942         {
 943         }
 944
 945         //  XServiceInfo
 946
 947         public String getImplementationName()
 948         {
 949             return aImplName;
 950         }
 951
 952         public String[] getSupportedServiceNames()
 953         {
 954             String [] aSupportedServices = new String[ 1 ];
 955             aSupportedServices[ 0 ] = aServiceName;
 956             return aSupportedServices;
 957         }
 958
 959         public boolean supportsService( String aService )
 960         {
 961             return aService.equals( aServiceName );
 962         }
 963     }
 964
 965     public static com.sun.star.lang.XSingleServiceFactory __getServiceFactory(
 966         String implName,
 967         com.sun.star.lang.XMultiServiceFactory multiFactory,
 968         com.sun.star.registry.XRegistryKey regKey)
 969     {
 970         com.sun.star.lang.XSingleServiceFactory xSingleServiceFactory = null;
 971
 972         if ( implName.equals(_ExampleDataPilotSource.aImplName) )
 973             xSingleServiceFactory =
 974                 com.sun.star.comp.loader.FactoryHelper.getServiceFactory(
 975                     _ExampleDataPilotSource.class,
 976                     _ExampleDataPilotSource.aServiceName, multiFactory, regKey);
 977
 978         return xSingleServiceFactory;
 979     }
 980 }
 981