odk/examples/DevelopersGuide/Spreadsheet/ExampleDataPilotSource.java

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