LCOV - code coverage report
Current view: top level - sc/source/ui/vba - vbapagebreaks.cxx (source / functions) Hit Total Coverage
Test: commit e02a6cb2c3e2b23b203b422e4e0680877f232636 Lines: 0 144 0.0 %
Date: 2014-04-14 Functions: 0 34 0.0 %
Legend: Lines: hit not hit

          Line data    Source code
       1             : /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
       2             : /*
       3             :  * This file is part of the LibreOffice project.
       4             :  *
       5             :  * This Source Code Form is subject to the terms of the Mozilla Public
       6             :  * License, v. 2.0. If a copy of the MPL was not distributed with this
       7             :  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
       8             :  *
       9             :  * This file incorporates work covered by the following license notice:
      10             :  *
      11             :  *   Licensed to the Apache Software Foundation (ASF) under one or more
      12             :  *   contributor license agreements. See the NOTICE file distributed
      13             :  *   with this work for additional information regarding copyright
      14             :  *   ownership. The ASF licenses this file to you under the Apache
      15             :  *   License, Version 2.0 (the "License"); you may not use this file
      16             :  *   except in compliance with the License. You may obtain a copy of
      17             :  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
      18             :  */
      19             : #include "vbapagebreaks.hxx"
      20             : #include "vbapagebreak.hxx"
      21             : #include <ooo/vba/excel/XWorksheet.hpp>
      22             : using namespace ::com::sun::star;
      23             : using namespace ::ooo::vba;
      24             : 
      25             : typedef ::cppu::WeakImplHelper1<container::XIndexAccess > RangePageBreaks_Base;
      26           0 : class RangePageBreaks : public RangePageBreaks_Base
      27             : {
      28             : private:
      29             :     uno::Reference< XHelperInterface > mxParent;
      30             :     uno::Reference< uno::XComponentContext > mxContext;
      31             :     uno::Reference< sheet::XSheetPageBreak > mxSheetPageBreak;
      32             :     sal_Bool m_bColumn;
      33             : 
      34             : public:
      35           0 :     RangePageBreaks( const uno::Reference< XHelperInterface >& xParent,
      36             :                      const uno::Reference< uno::XComponentContext >& xContext,
      37             :                      uno::Reference< sheet::XSheetPageBreak >& xSheetPageBreak,
      38           0 :                      sal_Bool bColumn ) : mxParent( xParent ), mxContext( xContext ), mxSheetPageBreak( xSheetPageBreak ), m_bColumn( bColumn )
      39             :     {
      40           0 :     }
      41             : 
      42           0 :     sal_Int32 getAPIStartofRange( const uno::Reference< excel::XRange >& xRange ) throw (css::uno::RuntimeException)
      43             :     {
      44           0 :         if( m_bColumn )
      45           0 :             return xRange->getColumn() - 1;
      46           0 :         return xRange->getRow() - 1;
      47             :     }
      48             : 
      49           0 :     sal_Int32 getAPIEndIndexofRange( const uno::Reference< excel::XRange >& xRange, sal_Int32 nUsedStart ) throw (uno::RuntimeException)
      50             :     {
      51           0 :         if( m_bColumn )
      52           0 :             return nUsedStart + xRange->Columns( uno::Any() )->getCount() - 1;
      53           0 :         return nUsedStart + xRange->Rows( uno::Any() )->getCount();
      54             :     }
      55             : 
      56           0 :     uno::Sequence<sheet::TablePageBreakData> getAllPageBreaks() throw (uno::RuntimeException)
      57             :     {
      58           0 :         if( m_bColumn )
      59           0 :             return mxSheetPageBreak->getColumnPageBreaks();
      60           0 :         return mxSheetPageBreak->getRowPageBreaks();
      61             :     }
      62             : 
      63           0 :     uno::Reference<container::XIndexAccess> getRowColContainer() throw (uno::RuntimeException)
      64             :     {
      65           0 :         uno::Reference< table::XColumnRowRange > xColumnRowRange( mxSheetPageBreak, uno::UNO_QUERY_THROW );
      66           0 :         uno::Reference<container::XIndexAccess> xIndexAccess;
      67           0 :         if( m_bColumn )
      68           0 :             xIndexAccess.set( xColumnRowRange->getColumns(), uno::UNO_QUERY_THROW );
      69             :         else
      70           0 :             xIndexAccess.set( xColumnRowRange->getRows(), uno::UNO_QUERY_THROW );
      71           0 :         return xIndexAccess;
      72             :     }
      73             : 
      74             :     sheet::TablePageBreakData getTablePageBreakData( sal_Int32 nAPIItemIndex ) throw ( script::BasicErrorException, uno::RuntimeException);
      75             :     uno::Any Add( const css::uno::Any& Before ) throw ( css::script::BasicErrorException, css::uno::RuntimeException);
      76             : 
      77             :     // XIndexAccess
      78             :     virtual sal_Int32 SAL_CALL getCount(  ) throw (uno::RuntimeException, std::exception) SAL_OVERRIDE;
      79             :     virtual uno::Any SAL_CALL getByIndex( sal_Int32 Index ) throw (lang::IndexOutOfBoundsException, lang::WrappedTargetException, uno::RuntimeException, std::exception) SAL_OVERRIDE;
      80           0 :     virtual uno::Type SAL_CALL getElementType(  ) throw (uno::RuntimeException, std::exception) SAL_OVERRIDE
      81             :     {
      82           0 :         if( m_bColumn )
      83           0 :              return cppu::UnoType<excel::XVPageBreak>::get();
      84           0 :         return  cppu::UnoType<excel::XHPageBreak>::get();
      85             :     }
      86           0 :     virtual sal_Bool SAL_CALL hasElements(  ) throw (uno::RuntimeException, std::exception) SAL_OVERRIDE
      87             :     {
      88           0 :         return sal_True;
      89             :     }
      90             : };
      91             : 
      92             : /** @TODO Unlike MS Excel this method only considers the pagebreaks that intersect the used range
      93             : *  To become completely compatible the print area has to be considered. As far as I found out this printarea
      94             : *  also considers the position and sizes of shapes and manually inserted page breaks
      95             : *  Note: In MS  there is a limit of 1026 horizontal page breaks per sheet.
      96             : */
      97           0 : sal_Int32 SAL_CALL RangePageBreaks::getCount(  ) throw (uno::RuntimeException, std::exception)
      98             : {
      99           0 :     sal_Int32 nCount = 0;
     100           0 :     uno::Reference< excel::XWorksheet > xWorksheet( mxParent, uno::UNO_QUERY_THROW );
     101           0 :     uno::Reference< excel::XRange > xRange = xWorksheet->getUsedRange();
     102           0 :     sal_Int32 nUsedStart = getAPIStartofRange( xRange );
     103           0 :     sal_Int32 nUsedEnd = getAPIEndIndexofRange( xRange, nUsedStart );
     104           0 :     uno::Sequence<sheet::TablePageBreakData> aTablePageBreakData = getAllPageBreaks();
     105             : 
     106           0 :     sal_Int32 nLength = aTablePageBreakData.getLength();
     107           0 :     for( sal_Int32 i=0; i<nLength; i++ )
     108             :     {
     109           0 :         sal_Int32 nPos = aTablePageBreakData[i].Position;
     110           0 :         if( nPos > nUsedEnd + 1)
     111           0 :             return nCount;
     112           0 :         nCount++;
     113             :     }
     114             : 
     115           0 :     return nCount;
     116             : }
     117             : 
     118           0 : uno::Any SAL_CALL RangePageBreaks::getByIndex( sal_Int32 Index ) throw (lang::IndexOutOfBoundsException, lang::WrappedTargetException, uno::RuntimeException, std::exception)
     119             : {
     120           0 :     if( (Index < getCount()) && ( Index >= 0 ))
     121             :     {
     122           0 :         sheet::TablePageBreakData aTablePageBreakData = getTablePageBreakData( Index );
     123           0 :         uno::Reference< container::XIndexAccess > xIndexAccess = getRowColContainer();
     124           0 :         sal_Int32 nPos = aTablePageBreakData.Position;
     125           0 :         if( (nPos < xIndexAccess->getCount()) && (nPos > -1) )
     126             :         {
     127           0 :             uno::Reference< beans::XPropertySet > xRowColPropertySet( xIndexAccess->getByIndex(nPos), uno::UNO_QUERY_THROW );
     128           0 :             if( m_bColumn )
     129           0 :                 return uno::makeAny( uno::Reference< excel::XVPageBreak >( new ScVbaVPageBreak( mxParent, mxContext, xRowColPropertySet, aTablePageBreakData) ));
     130           0 :             return uno::makeAny( uno::Reference< excel::XHPageBreak >( new ScVbaHPageBreak( mxParent, mxContext, xRowColPropertySet, aTablePageBreakData) ));
     131           0 :         }
     132             :     }
     133           0 :     throw lang::IndexOutOfBoundsException();
     134             : }
     135             : 
     136           0 : sheet::TablePageBreakData RangePageBreaks::getTablePageBreakData( sal_Int32 nAPIItemIndex ) throw ( script::BasicErrorException, uno::RuntimeException)
     137             : {
     138           0 :     sal_Int32 index = -1;
     139           0 :     sheet::TablePageBreakData aTablePageBreakData;
     140           0 :     uno::Reference< excel::XWorksheet > xWorksheet( mxParent, uno::UNO_QUERY_THROW );
     141           0 :     uno::Reference< excel::XRange > xRange = xWorksheet->getUsedRange();
     142           0 :     sal_Int32 nUsedStart = getAPIStartofRange( xRange );
     143           0 :     sal_Int32 nUsedEnd = getAPIEndIndexofRange( xRange, nUsedStart );
     144           0 :     uno::Sequence<sheet::TablePageBreakData> aTablePageBreakDataList = getAllPageBreaks();
     145             : 
     146           0 :     sal_Int32 nLength = aTablePageBreakDataList.getLength();
     147           0 :     for( sal_Int32 i=0; i<nLength; i++ )
     148             :     {
     149           0 :         aTablePageBreakData = aTablePageBreakDataList[i];
     150           0 :         sal_Int32 nPos = aTablePageBreakData.Position;
     151           0 :         if( nPos > nUsedEnd + 1 )
     152           0 :             DebugHelper::exception(SbERR_METHOD_FAILED, OUString());
     153           0 :         index++;
     154           0 :         if( index == nAPIItemIndex )
     155           0 :             return aTablePageBreakData;
     156             :     }
     157             : 
     158           0 :     return aTablePageBreakData;
     159             : }
     160             : 
     161           0 : uno::Any RangePageBreaks::Add( const css::uno::Any& Before ) throw ( css::script::BasicErrorException, css::uno::RuntimeException)
     162             : {
     163           0 :     uno::Reference< excel::XRange > xRange;
     164           0 :     Before >>= xRange;
     165           0 :     if( !xRange.is() )
     166             :     {
     167           0 :         DebugHelper::exception(SbERR_BAD_ARGUMENT, OUString());
     168             :     }
     169             : 
     170           0 :     sal_Int32 nAPIRowColIndex = getAPIStartofRange( xRange );
     171           0 :     uno::Reference< container::XIndexAccess > xIndexAccess = getRowColContainer();
     172           0 :     uno::Reference< beans::XPropertySet > xRowColPropertySet( xIndexAccess->getByIndex(nAPIRowColIndex), uno::UNO_QUERY_THROW );
     173           0 :     xRowColPropertySet->setPropertyValue("IsStartOfNewPage", uno::makeAny(sal_True));
     174           0 :     sheet::TablePageBreakData aTablePageBreakData;
     175           0 :     aTablePageBreakData.ManualBreak = sal_True;
     176           0 :     aTablePageBreakData.Position = nAPIRowColIndex;
     177           0 :     if( m_bColumn )
     178           0 :         return uno::makeAny( uno::Reference< excel::XVPageBreak >( new ScVbaVPageBreak( mxParent, mxContext, xRowColPropertySet, aTablePageBreakData) ));
     179           0 :     return uno::makeAny( uno::Reference< excel::XHPageBreak >( new ScVbaHPageBreak( mxParent, mxContext, xRowColPropertySet, aTablePageBreakData) ));
     180             : }
     181             : 
     182             : 
     183           0 : class RangePageBreaksEnumWrapper : public EnumerationHelper_BASE
     184             : {
     185             :     uno::Reference<container::XIndexAccess > m_xIndexAccess;
     186             :     sal_Int32 nIndex;
     187             : public:
     188           0 :     RangePageBreaksEnumWrapper( const uno::Reference< container::XIndexAccess >& xIndexAccess ) : m_xIndexAccess( xIndexAccess ), nIndex( 0 ) {}
     189           0 :     virtual sal_Bool SAL_CALL hasMoreElements(  ) throw (uno::RuntimeException, std::exception) SAL_OVERRIDE
     190             :     {
     191           0 :         return ( nIndex < m_xIndexAccess->getCount() );
     192             :     }
     193             : 
     194           0 :     virtual uno::Any SAL_CALL nextElement(  ) throw (container::NoSuchElementException, lang::WrappedTargetException, uno::RuntimeException, std::exception) SAL_OVERRIDE
     195             :     {
     196           0 :         if ( nIndex < m_xIndexAccess->getCount() )
     197           0 :             return m_xIndexAccess->getByIndex( nIndex++ );
     198           0 :         throw container::NoSuchElementException();
     199             :     }
     200             : };
     201             : 
     202           0 : ScVbaHPageBreaks::ScVbaHPageBreaks( const uno::Reference< XHelperInterface >& xParent,
     203             :                                     const uno::Reference< uno::XComponentContext >& xContext,
     204             :                                     uno::Reference< sheet::XSheetPageBreak >& xSheetPageBreak) throw (uno::RuntimeException):
     205           0 :                           ScVbaHPageBreaks_BASE( xParent,xContext, new RangePageBreaks( xParent, xContext, xSheetPageBreak, false )),
     206           0 :                           mxSheetPageBreak( xSheetPageBreak )
     207             : {
     208           0 : }
     209             : 
     210           0 : uno::Any SAL_CALL ScVbaHPageBreaks::Add( const uno::Any& Before) throw ( script::BasicErrorException, uno::RuntimeException, std::exception)
     211             : {
     212           0 :     RangePageBreaks* pPageBreaks = dynamic_cast< RangePageBreaks* >( m_xIndexAccess.get() );
     213           0 :     if( pPageBreaks )
     214             :     {
     215           0 :         return pPageBreaks->Add( Before );
     216             :     }
     217           0 :     return uno::Any();
     218             : }
     219             : 
     220             : uno::Reference< container::XEnumeration >
     221           0 : ScVbaHPageBreaks::createEnumeration() throw (uno::RuntimeException)
     222             : {
     223           0 :     return new RangePageBreaksEnumWrapper( m_xIndexAccess );
     224             : }
     225             : 
     226             : uno::Any
     227           0 : ScVbaHPageBreaks::createCollectionObject( const css::uno::Any& aSource )
     228             : {
     229           0 :     return aSource; // its already a pagebreak object
     230             : }
     231             : 
     232             : uno::Type
     233           0 : ScVbaHPageBreaks::getElementType() throw (uno::RuntimeException)
     234             : {
     235           0 :     return cppu::UnoType<excel::XHPageBreak>::get();
     236             : }
     237             : 
     238             : OUString
     239           0 : ScVbaHPageBreaks::getServiceImplName()
     240             : {
     241           0 :     return OUString("ScVbaHPageBreaks");
     242             : }
     243             : 
     244             : uno::Sequence< OUString >
     245           0 : ScVbaHPageBreaks::getServiceNames()
     246             : {
     247           0 :     static uno::Sequence< OUString > aServiceNames;
     248           0 :     if ( aServiceNames.getLength() == 0 )
     249             :     {
     250           0 :         aServiceNames.realloc( 1 );
     251           0 :         aServiceNames[ 0 ] = "ooo.vba.excel.HPageBreaks";
     252             :     }
     253           0 :     return aServiceNames;
     254             : }
     255             : 
     256             : //VPageBreak
     257           0 : ScVbaVPageBreaks::ScVbaVPageBreaks( const uno::Reference< XHelperInterface >& xParent,
     258             :                                     const uno::Reference< uno::XComponentContext >& xContext,
     259             :                                     uno::Reference< sheet::XSheetPageBreak >& xSheetPageBreak ) throw ( uno::RuntimeException )
     260           0 : :   ScVbaVPageBreaks_BASE( xParent, xContext, new RangePageBreaks( xParent, xContext, xSheetPageBreak, sal_True ) ),
     261           0 :     mxSheetPageBreak( xSheetPageBreak )
     262             : {
     263           0 : }
     264             : 
     265           0 : ScVbaVPageBreaks::~ScVbaVPageBreaks()
     266             : {
     267           0 : }
     268             : 
     269             : uno::Any SAL_CALL
     270           0 : ScVbaVPageBreaks::Add( const uno::Any& Before ) throw ( script::BasicErrorException, uno::RuntimeException, std::exception )
     271             : {
     272           0 :     RangePageBreaks* pPageBreaks = dynamic_cast< RangePageBreaks* >( m_xIndexAccess.get() );
     273           0 :     if( pPageBreaks )
     274             :     {
     275           0 :         return pPageBreaks->Add( Before );
     276             :     }
     277           0 :     return uno::Any();
     278             : }
     279             : 
     280             : uno::Reference< container::XEnumeration >
     281           0 : ScVbaVPageBreaks::createEnumeration() throw ( uno::RuntimeException )
     282             : {
     283           0 :     return new RangePageBreaksEnumWrapper( m_xIndexAccess );
     284             : }
     285             : 
     286             : uno::Any
     287           0 : ScVbaVPageBreaks::createCollectionObject( const css::uno::Any& aSource )
     288             : {
     289           0 :     return aSource; // its already a pagebreak object
     290             : }
     291             : 
     292             : uno::Type
     293           0 : ScVbaVPageBreaks::getElementType() throw ( uno::RuntimeException )
     294             : {
     295           0 :     return cppu::UnoType<excel::XVPageBreak>::get();
     296             : }
     297             : 
     298             : OUString
     299           0 : ScVbaVPageBreaks::getServiceImplName()
     300             : {
     301           0 :     return OUString("ScVbaVPageBreaks");
     302             : }
     303             : 
     304             : uno::Sequence< OUString >
     305           0 : ScVbaVPageBreaks::getServiceNames()
     306             : {
     307           0 :     static uno::Sequence< OUString > aServiceNames;
     308           0 :     if ( aServiceNames.getLength() == 0 )
     309             :     {
     310           0 :         aServiceNames.realloc( 1 );
     311           0 :         aServiceNames[ 0 ] = "ooo.vba.excel.VPageBreaks";
     312             :     }
     313           0 :     return aServiceNames;
     314             : }
     315             : 
     316             : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */

Generated by: LCOV version 1.10