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