sc/source/ui/vba/vbaborders.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: vbaborders.cxx,v $
  10  * $Revision: 1.6 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30 #include "vbaborders.hxx"
  31
  32 #include <cppuhelper/implbase3.hxx>
  33 #include <ooo/vba/excel/XlBordersIndex.hpp>
  34 #include <ooo/vba/excel/XlBorderWeight.hpp>
  35 #include <ooo/vba/excel/XlLineStyle.hpp>
  36 #include <ooo/vba/excel/XlColorIndex.hpp>
  37 #include <com/sun/star/beans/XPropertySet.hpp>
  38 #include <com/sun/star/table/TableBorder.hpp>
  39 #include <com/sun/star/table/XColumnRowRange.hpp>
  40
  41 #include "vbapalette.hxx"
  42
  43 using namespace ::com::sun::star;
  44 using namespace ::ooo::vba;
  45 using namespace ::ooo::vba::excel;
  46
  47
  48 typedef ::cppu::WeakImplHelper1<container::XIndexAccess > RangeBorders_Base;
  49 typedef InheritedHelperInterfaceImpl1<excel::XBorder > ScVbaBorder_Base;
  50
  51 // #TODO sort these indexes to match the order in which Excel iterates over the
  52 // borders, the enumeration will match the order in this list
  53 static const sal_Int16 supportedIndexTable[] = {  XlBordersIndex::xlEdgeLeft, XlBordersIndex::xlEdgeTop, XlBordersIndex::xlEdgeBottom, XlBordersIndex::xlEdgeRight, XlBordersIndex::xlDiagonalDown, XlBordersIndex::xlDiagonalUp, XlBordersIndex::xlInsideVertical, XlBordersIndex::xlInsideHorizontal };
  54
  55 const static rtl::OUString sTableBorder( RTL_CONSTASCII_USTRINGPARAM("TableBorder") );
  56
  57 //  Equiv widths in in 1/100 mm
  58 const static sal_Int32 OOLineThin = 35;
  59 const static sal_Int32 OOLineMedium = 88;
  60 const static sal_Int32 OOLineThick = 141;
  61 const static sal_Int32 OOLineHairline = 2;
  62
  63 class ScVbaBorder : public ScVbaBorder_Base
  64 {
  65 private:
  66     uno::Reference< beans::XPropertySet > m_xProps;
  67     sal_Int32 m_LineType;
  68     ScVbaPalette m_Palette;
  69     bool setBorderLine( table::BorderLine& rBorderLine )
  70     {
  71         table::TableBorder aTableBorder;
  72         m_xProps->getPropertyValue( sTableBorder ) >>= aTableBorder;
  73
  74         switch ( m_LineType )
  75         {
  76             case XlBordersIndex::xlEdgeLeft:
  77                 aTableBorder.IsLeftLineValid = sal_True;
  78                 aTableBorder.LeftLine= rBorderLine;
  79                 break;
  80             case XlBordersIndex::xlEdgeTop:
  81                 aTableBorder.IsTopLineValid = sal_True;
  82                 aTableBorder.TopLine = rBorderLine;
  83                 break;
  84
  85             case XlBordersIndex::xlEdgeBottom:
  86                 aTableBorder.IsBottomLineValid = sal_True;
  87                 aTableBorder.BottomLine = rBorderLine;
  88                 break;
  89             case XlBordersIndex::xlEdgeRight:
  90                 aTableBorder.IsRightLineValid = sal_True;
  91                 aTableBorder.RightLine = rBorderLine;
  92                 break;
  93             case XlBordersIndex::xlInsideVertical:
  94                 aTableBorder.IsVerticalLineValid = sal_True;
  95                 aTableBorder.VerticalLine = rBorderLine;
  96                 break;
  97             case XlBordersIndex::xlInsideHorizontal:
  98                 aTableBorder.IsHorizontalLineValid = sal_True;
  99                 aTableBorder.HorizontalLine = rBorderLine;
 100                 break;
 101             case XlBordersIndex::xlDiagonalDown:
 102             case XlBordersIndex::xlDiagonalUp:
 103                 // #TODO have to ignore at the momement, would be
 104                 // nice to investigate what we can do here
 105                 break;
 106             default:
 107                     return false;
 108         }
 109         m_xProps->setPropertyValue( sTableBorder, uno::makeAny(aTableBorder) );
 110         return true;
 111     }
 112
 113     bool getBorderLine( table::BorderLine& rBorderLine )
 114     {
 115         table::TableBorder aTableBorder;
 116         m_xProps->getPropertyValue( sTableBorder ) >>= aTableBorder;
 117         switch ( m_LineType )
 118         {
 119             case XlBordersIndex::xlEdgeLeft:
 120                 if ( aTableBorder.IsLeftLineValid )
 121                     rBorderLine = aTableBorder.LeftLine;
 122                 break;
 123             case XlBordersIndex::xlEdgeTop:
 124                 if ( aTableBorder.IsTopLineValid )
 125                     rBorderLine = aTableBorder.TopLine;
 126                 break;
 127
 128             case XlBordersIndex::xlEdgeBottom:
 129                 if ( aTableBorder.IsBottomLineValid )
 130                     rBorderLine = aTableBorder.BottomLine;
 131                 break;
 132             case XlBordersIndex::xlEdgeRight:
 133                 if ( aTableBorder.IsRightLineValid )
 134                     rBorderLine = aTableBorder.RightLine;
 135                 break;
 136             case XlBordersIndex::xlInsideVertical:
 137                 if ( aTableBorder.IsVerticalLineValid )
 138                     rBorderLine = aTableBorder.VerticalLine;
 139                 break;
 140             case XlBordersIndex::xlInsideHorizontal:
 141                 if ( aTableBorder.IsHorizontalLineValid )
 142                     rBorderLine = aTableBorder.HorizontalLine;
 143                 break;
 144
 145             case XlBordersIndex::xlDiagonalDown:
 146             case XlBordersIndex::xlDiagonalUp:
 147                 // #TODO have to ignore at the momement, would be
 148                 // nice to investigate what we can do here
 149                 break;
 150             default:
 151                     return false;
 152         }
 153         return true;
 154     }
 155     ScVbaBorder(); // no impl
 156 protected:
 157     virtual rtl::OUString& getServiceImplName()
 158     {
 159         static rtl::OUString sImplName( RTL_CONSTASCII_USTRINGPARAM("ScVbaBorder") );
 160     return sImplName;
 161     }
 162     virtual css::uno::Sequence<rtl::OUString> getServiceNames()
 163     {
 164         static uno::Sequence< rtl::OUString > aServiceNames;
 165         if ( aServiceNames.getLength() == 0 )
 166         {
 167             aServiceNames.realloc( 1 );
 168             aServiceNames[ 0 ] = rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("ooo.vba.excel.Border" ) );
 169         }
 170         return aServiceNames;
 171     }
 172 public:
 173     ScVbaBorder( const uno::Reference< beans::XPropertySet > & xProps, const uno::Reference< uno::XComponentContext >& xContext, sal_Int32 lineType, ScVbaPalette& rPalette) : ScVbaBorder_Base( uno::Reference< XHelperInterface >( xProps, uno::UNO_QUERY ), xContext ), m_xProps( xProps ), m_LineType( lineType ), m_Palette( rPalette ) {}
 174
 175     // XBorder
 176     uno::Any SAL_CALL getColor() throw (uno::RuntimeException)
 177     {
 178         table::BorderLine aBorderLine;
 179         if ( getBorderLine( aBorderLine ) )
 180             return uno::makeAny( OORGBToXLRGB( aBorderLine.Color ) );
 181         throw uno::RuntimeException( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM( "No Implementation available" ) ), uno::Reference< uno::XInterface >() );
 182     }
 183     void SAL_CALL setColor( const uno::Any& _color ) throw (uno::RuntimeException)
 184     {
 185         sal_Int32 nColor = 0;
 186         _color >>= nColor;
 187         table::BorderLine aBorderLine;
 188         if ( getBorderLine( aBorderLine ) )
 189         {
 190             aBorderLine.Color = XLRGBToOORGB( nColor );
 191             setBorderLine( aBorderLine );
 192         }
 193         else
 194             throw uno::RuntimeException( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM( "No Implementation available" ) ), uno::Reference< uno::XInterface >() );
 195     }
 196
 197     uno::Any SAL_CALL getColorIndex() throw (uno::RuntimeException)
 198     {
 199         sal_Int32 nColor = 0;
 200         XLRGBToOORGB( getColor() ) >>= nColor;
 201         uno::Reference< container::XIndexAccess > xIndex = m_Palette.getPalette();
 202         sal_Int32 nElems = xIndex->getCount();
 203         sal_Int32 nIndex = -1;
 204         for ( sal_Int32 count=0; count<nElems; ++count )
 205         {
 206             sal_Int32 nPaletteColor = 0;
 207             xIndex->getByIndex( count ) >>= nPaletteColor;
 208             if ( nPaletteColor == nColor )
 209             {
 210                 nIndex = count + 1;
 211                 break;
 212             }
 213         }
 214         return uno::makeAny(nIndex);
 215     }
 216
 217     void SAL_CALL setColorIndex( const uno::Any& _colorindex ) throw (uno::RuntimeException)
 218     {
 219         sal_Int32 nColor = 0;
 220         _colorindex >>= nColor;
 221         if ( !nColor || nColor == XlColorIndex::xlColorIndexAutomatic )
 222             nColor = 1;
 223         setColor( OORGBToXLRGB( m_Palette.getPalette()->getByIndex( --nColor )  ) );
 224     }
 225     uno::Any SAL_CALL getWeight() throw (uno::RuntimeException)
 226     {
 227         table::BorderLine aBorderLine;
 228         if ( getBorderLine( aBorderLine ) )
 229         {
 230             switch ( aBorderLine.OuterLineWidth )
 231             {
 232                 case 0: // Thin = default OO thickness
 233                 case OOLineThin:
 234                     return uno::makeAny( XlBorderWeight::xlThin );
 235                 case OOLineMedium:
 236                     return uno::makeAny( XlBorderWeight::xlMedium );
 237                 case OOLineThick:
 238                     return uno::makeAny( XlBorderWeight::xlThick );
 239                 case OOLineHairline:
 240                     return uno::makeAny( XlBorderWeight::xlHairline );
 241                 default:
 242                     break;
 243             }
 244         }
 245         throw uno::RuntimeException( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM( "Method failed" ) ), uno::Reference< uno::XInterface >() );
 246     }
 247     void SAL_CALL setWeight( const uno::Any& _weight ) throw (uno::RuntimeException)
 248     {
 249         sal_Int32 nWeight = 0;
 250         _weight >>= nWeight;
 251         table::BorderLine aBorderLine;
 252         if ( getBorderLine( aBorderLine ) )
 253         {
 254             switch ( nWeight )
 255             {
 256                 case XlBorderWeight::xlThin:
 257                     aBorderLine.OuterLineWidth = OOLineThin;
 258                     break;
 259                 case XlBorderWeight::xlMedium:
 260                     aBorderLine.OuterLineWidth = OOLineMedium;
 261                     break;
 262                 case XlBorderWeight::xlThick:
 263                     aBorderLine.OuterLineWidth = OOLineThick;
 264                     break;
 265                 case XlBorderWeight::xlHairline:
 266                     aBorderLine.OuterLineWidth = OOLineHairline;
 267                     break;
 268                 default:
 269                     throw uno::RuntimeException( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM( "Bad param" ) ), uno::Reference< uno::XInterface >() );
 270             }
 271             setBorderLine( aBorderLine );
 272         }
 273         else
 274                     throw uno::RuntimeException( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM( "Method failed" ) ), uno::Reference< uno::XInterface >() );
 275     }
 276
 277     uno::Any SAL_CALL getLineStyle() throw (uno::RuntimeException)
 278     {
 279         // always return xlContinuous;
 280         return uno::makeAny( XlLineStyle::xlContinuous );
 281     }
 282     void SAL_CALL setLineStyle( const uno::Any& _linestyle ) throw (uno::RuntimeException)
 283     {
 284         // Urk no choice but to silently ignore we don't support this attribute
 285         // #TODO would be nice to support the excel line styles
 286         sal_Int32 nLineStyle = 0;
 287         _linestyle >>= nLineStyle;
 288         table::BorderLine aBorderLine;
 289         if ( getBorderLine( aBorderLine ) )
 290         {
 291             switch ( nLineStyle )
 292             {
 293                 case XlLineStyle::xlContinuous:
 294                 case XlLineStyle::xlDash:
 295                 case XlLineStyle::xlDashDot:
 296                 case XlLineStyle::xlDashDotDot:
 297                 case XlLineStyle::xlDot:
 298                 case XlLineStyle::xlDouble:
 299                 case XlLineStyle::xlLineStyleNone:
 300                 case XlLineStyle::xlSlantDashDot:
 301                     break;
 302                 default:
 303                     throw uno::RuntimeException( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM( "Bad param" ) ), uno::Reference< uno::XInterface >() );
 304             }
 305             setBorderLine( aBorderLine );
 306         }
 307         else
 308             throw uno::RuntimeException( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM( "Method failed" ) ), uno::Reference< uno::XInterface >() );
 309     }
 310 };
 311
 312 class RangeBorders : public RangeBorders_Base
 313 {
 314 private:
 315     uno::Reference< table::XCellRange > m_xRange;
 316     uno::Reference< uno::XComponentContext > m_xContext;
 317     ScVbaPalette m_Palette;
 318     sal_Int32 getTableIndex( sal_Int32 nConst )
 319     {
 320         // hokay return position of the index in the table
 321         sal_Int32 nIndexes = getCount();
 322         sal_Int32 realIndex = 0;
 323         const sal_Int16* pTableEntry = supportedIndexTable;
 324         for ( ; realIndex < nIndexes; ++realIndex, ++pTableEntry )
 325         {
 326             if ( *pTableEntry == nConst )
 327                 return realIndex;
 328         }
 329         return getCount(); // error condition
 330     }
 331 public:
 332     RangeBorders(  const uno::Reference< table::XCellRange >& xRange,  const uno::Reference< uno::XComponentContext > & xContext, ScVbaPalette& rPalette ) : m_xRange( xRange ), m_xContext( xContext ), m_Palette( rPalette )
 333     {
 334     }
 335     // XIndexAccess
 336     virtual ::sal_Int32 SAL_CALL getCount(  ) throw (uno::RuntimeException)
 337     {
 338         return sizeof( supportedIndexTable ) / sizeof( supportedIndexTable[0] );
 339     }
 340     virtual uno::Any SAL_CALL getByIndex( ::sal_Int32 Index ) throw (lang::IndexOutOfBoundsException, lang::WrappedTargetException, uno::RuntimeException)
 341     {
 342
 343         sal_Int32 nIndex = getTableIndex( Index );
 344         if ( nIndex >= 0 && nIndex < getCount() )
 345         {
 346             uno::Reference< beans::XPropertySet > xProps( m_xRange, uno::UNO_QUERY_THROW );
 347             return uno::makeAny( uno::Reference< excel::XBorder >( new ScVbaBorder( xProps, m_xContext, supportedIndexTable[ nIndex ], m_Palette )) );
 348         }
 349         throw lang::IndexOutOfBoundsException();
 350     }
 351     virtual uno::Type SAL_CALL getElementType(  ) throw (uno::RuntimeException)
 352     {
 353         return  excel::XBorder::static_type(0);
 354     }
 355     virtual ::sal_Bool SAL_CALL hasElements(  ) throw (uno::RuntimeException)
 356     {
 357         return sal_True;
 358     }
 359 };
 360
 361 uno::Reference< container::XIndexAccess >
 362 rangeToBorderIndexAccess( const uno::Reference< table::XCellRange >& xRange,  const uno::Reference< uno::XComponentContext > & xContext, ScVbaPalette& rPalette )
 363 {
 364     return new RangeBorders( xRange, xContext, rPalette );
 365 }
 366
 367 class RangeBorderEnumWrapper : public EnumerationHelper_BASE
 368 {
 369     uno::Reference<container::XIndexAccess > m_xIndexAccess;
 370     sal_Int32 nIndex;
 371 public:
 372     RangeBorderEnumWrapper( const uno::Reference< container::XIndexAccess >& xIndexAccess ) : m_xIndexAccess( xIndexAccess ), nIndex( 0 ) {}
 373     virtual ::sal_Bool SAL_CALL hasMoreElements(  ) throw (uno::RuntimeException)
 374     {
 375         return ( nIndex < m_xIndexAccess->getCount() );
 376     }
 377
 378     virtual uno::Any SAL_CALL nextElement(  ) throw (container::NoSuchElementException, lang::WrappedTargetException, uno::RuntimeException)
 379     {
 380         if ( nIndex < m_xIndexAccess->getCount() )
 381             return m_xIndexAccess->getByIndex( nIndex++ );
 382         throw container::NoSuchElementException();
 383     }
 384 };
 385
 386 ScVbaBorders::ScVbaBorders( const uno::Reference< XHelperInterface >& xParent, const uno::Reference< uno::XComponentContext > & xContext, const uno::Reference< table::XCellRange >& xRange, ScVbaPalette& rPalette  ):  ScVbaBorders_BASE( xParent, xContext, rangeToBorderIndexAccess( xRange ,xContext, rPalette ) ), bRangeIsSingleCell( false )
 387 {
 388     uno::Reference< table::XColumnRowRange > xColumnRowRange(xRange, uno::UNO_QUERY_THROW );
 389     if ( xColumnRowRange->getRows()->getCount() == 1 && xColumnRowRange->getColumns()->getCount() == 1 )
 390         bRangeIsSingleCell = true;
 391     m_xProps.set( xRange, uno::UNO_QUERY_THROW );
 392 }
 393
 394 uno::Reference< container::XEnumeration >
 395 ScVbaBorders::createEnumeration() throw (uno::RuntimeException)
 396 {
 397     return new RangeBorderEnumWrapper( m_xIndexAccess );
 398 }
 399
 400 uno::Any
 401 ScVbaBorders::createCollectionObject( const css::uno::Any& aSource )
 402 {
 403     return aSource; // its already a Border object
 404 }
 405
 406 uno::Type
 407 ScVbaBorders::getElementType() throw (uno::RuntimeException)
 408 {
 409     return excel::XBorders::static_type(0);
 410 }
 411
 412 uno::Any
 413 ScVbaBorders::getItemByIntIndex( const sal_Int32 nIndex )  throw (uno::RuntimeException)
 414 {
 415     return createCollectionObject( m_xIndexAccess->getByIndex( nIndex ) );
 416 }
 417
 418
 419 uno::Any SAL_CALL ScVbaBorders::getColor() throw (uno::RuntimeException)
 420 {
 421     sal_Int32 count = getCount();
 422     uno::Any color;
 423     for( sal_Int32 i = 0; i < count ; i++ )
 424     {
 425         if( XlBordersIndex::xlDiagonalDown != supportedIndexTable[i] && XlBordersIndex::xlDiagonalUp != supportedIndexTable[i] )
 426         {
 427             uno::Reference< XBorder > xBorder( getItemByIntIndex( supportedIndexTable[i] ), uno::UNO_QUERY_THROW );
 428             if( color.hasValue() )
 429             {
 430                 if( color != xBorder->getColor() )
 431                     return uno::makeAny( uno::Reference< uno::XInterface >() );
 432             }
 433             else
 434                 color = xBorder->getColor();
 435         }
 436     }
 437     return  color;
 438 }
 439 void SAL_CALL ScVbaBorders::setColor( const uno::Any& _color ) throw (uno::RuntimeException)
 440 {
 441     sal_Int32 count = getCount();
 442     for( sal_Int32 i = 0; i < count ; i++ )
 443     {
 444         uno::Reference< XBorder > xBorder( getItemByIntIndex( supportedIndexTable[i] ), uno::UNO_QUERY_THROW );
 445         xBorder->setColor( _color );
 446     }
 447 }
 448 uno::Any SAL_CALL ScVbaBorders::getColorIndex() throw (uno::RuntimeException)
 449 {
 450     sal_Int32 count = getCount();
 451     uno::Any nColorIndex;
 452     for( sal_Int32 i = 0; i < count ; i++ )
 453     {
 454         if( XlBordersIndex::xlDiagonalDown != supportedIndexTable[i] && XlBordersIndex::xlDiagonalUp != supportedIndexTable[i] )
 455         {
 456             uno::Reference< XBorder > xBorder( getItemByIntIndex( supportedIndexTable[i] ), uno::UNO_QUERY_THROW );
 457             if( nColorIndex.hasValue() )
 458             {
 459                 if( nColorIndex != xBorder->getColorIndex() )
 460                     return uno::makeAny( uno::Reference< uno::XInterface >() );
 461             }
 462             else
 463                 nColorIndex = xBorder->getColorIndex();
 464         }
 465     }
 466     return  nColorIndex;
 467 }
 468 void SAL_CALL ScVbaBorders::setColorIndex( const uno::Any& _colorindex ) throw (uno::RuntimeException)
 469 {
 470     sal_Int32 count = getCount();
 471     for( sal_Int32 i = 0; i < count ; i++ )
 472     {
 473         uno::Reference< XBorder > xBorder( getItemByIntIndex( supportedIndexTable[i] ), uno::UNO_QUERY_THROW );
 474         xBorder->setColorIndex( _colorindex );
 475     }
 476 }
 477
 478 bool
 479 lcl_areAllLineWidthsSame( const table::TableBorder& maTableBorder, bool bIsCell )
 480 {
 481
 482     bool bRes = false;
 483     if (bIsCell)
 484     {
 485         bRes = ((maTableBorder.TopLine.OuterLineWidth == maTableBorder.BottomLine.OuterLineWidth) &&
 486 (maTableBorder.TopLine.OuterLineWidth == maTableBorder.LeftLine.OuterLineWidth) &&
 487 (maTableBorder.TopLine.OuterLineWidth == maTableBorder.RightLine.OuterLineWidth));
 488     }
 489     else
 490     {
 491         bRes = ((maTableBorder.TopLine.OuterLineWidth == maTableBorder.BottomLine.OuterLineWidth) &&
 492 (maTableBorder.TopLine.OuterLineWidth == maTableBorder.LeftLine.OuterLineWidth) &&
 493 (maTableBorder.TopLine.OuterLineWidth == maTableBorder.HorizontalLine.OuterLineWidth) &&
 494 (maTableBorder.TopLine.OuterLineWidth == maTableBorder.VerticalLine.OuterLineWidth) &&
 495 (maTableBorder.TopLine.OuterLineWidth == maTableBorder.RightLine.OuterLineWidth));
 496     }
 497     return bRes;
 498 }
 499
 500 uno::Any SAL_CALL ScVbaBorders::getLineStyle() throw (uno::RuntimeException)
 501 {
 502     table::TableBorder maTableBorder;
 503     m_xProps->getPropertyValue( sTableBorder ) >>= maTableBorder;
 504
 505     sal_Int32 aLinestyle =  XlLineStyle::xlLineStyleNone;
 506
 507     if ( lcl_areAllLineWidthsSame( maTableBorder, bRangeIsSingleCell ))
 508     {
 509         if (maTableBorder.TopLine.LineDistance != 0)
 510         {
 511             aLinestyle = XlLineStyle::xlDouble;
 512         }
 513         else if ( maTableBorder.TopLine.OuterLineWidth != 0 )
 514         {
 515             aLinestyle = XlLineStyle::xlContinuous;
 516         }
 517     }
 518     return uno::makeAny( aLinestyle );
 519 }
 520 void SAL_CALL ScVbaBorders::setLineStyle( const uno::Any& _linestyle ) throw (uno::RuntimeException)
 521 {
 522     sal_Int32 count = getCount();
 523     for( sal_Int32 i = 0; i < count ; i++ )
 524     {
 525         uno::Reference< XBorder > xBorder( getItemByIntIndex( supportedIndexTable[i] ), uno::UNO_QUERY_THROW );
 526         xBorder->setLineStyle( _linestyle );
 527     }
 528 }
 529 uno::Any SAL_CALL ScVbaBorders::getWeight() throw (uno::RuntimeException)
 530 {
 531     sal_Int32 count = getCount();
 532     uno::Any weight;
 533     for( sal_Int32 i = 0; i < count ; i++ )
 534     {
 535         if( XlBordersIndex::xlDiagonalDown != supportedIndexTable[i] && XlBordersIndex::xlDiagonalUp != supportedIndexTable[i] )
 536         {
 537             uno::Reference< XBorder > xBorder( getItemByIntIndex( supportedIndexTable[i] ), uno::UNO_QUERY_THROW );
 538             if( weight.hasValue() )
 539             {
 540                 if( weight != xBorder->getWeight() )
 541                     return uno::makeAny( uno::Reference< uno::XInterface >() );
 542             }
 543             else
 544                 weight = xBorder->getWeight();
 545         }
 546     }
 547     return  weight;
 548 }
 549 void SAL_CALL ScVbaBorders::setWeight( const uno::Any& _weight ) throw (uno::RuntimeException)
 550 {
 551     sal_Int32 count = getCount();
 552     for( sal_Int32 i = 0; i < count ; i++ )
 553     {
 554         uno::Reference< XBorder > xBorder( getItemByIntIndex( supportedIndexTable[i] ), uno::UNO_QUERY_THROW );
 555         xBorder->setWeight( _weight );
 556     }
 557 }
 558
 559
 560 rtl::OUString&
 561 ScVbaBorders::getServiceImplName()
 562 {
 563     static rtl::OUString sImplName( RTL_CONSTASCII_USTRINGPARAM("ScVbaBorders") );
 564     return sImplName;
 565 }
 566
 567 uno::Sequence< rtl::OUString >
 568 ScVbaBorders::getServiceNames()
 569 {
 570     static uno::Sequence< rtl::OUString > aServiceNames;
 571     if ( aServiceNames.getLength() == 0 )
 572     {
 573         aServiceNames.realloc( 1 );
 574         aServiceNames[ 0 ] = rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("ooo.vba.excel.Borders" ) );
 575     }
 576     return aServiceNames;
 577 }