sc/source/ui/vba/vbapagesetup.cxx

   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 "vbapagesetup.hxx"
  20 #include "cellsuno.hxx"
  21 #include "convuno.hxx"
  22 #include "rangelst.hxx"
  23 #include "excelvbahelper.hxx"
  24 #include <com/sun/star/sheet/XPrintAreas.hpp>
  25 #include <com/sun/star/sheet/XHeaderFooterContent.hpp>
  26 #include <com/sun/star/text/XText.hpp>
  27 #include <com/sun/star/style/XStyleFamiliesSupplier.hpp>
  28 #include <com/sun/star/container/XNameAccess.hpp>
  29 #include <ooo/vba/excel/XlPageOrientation.hpp>
  30 #include <ooo/vba/excel/XlOrder.hpp>
  31 #include <ooo/vba/excel/Constants.hpp>
  32 #include <i18nutil/paper.hxx>
  33 #include <sal/macros.h>
  34 #include <algorithm>
  35 #include <filter/msfilter/util.hxx>
  36
  37 using namespace ::com::sun::star;
  38 using namespace ::ooo::vba;
  39
  40 #define ZOOM_IN 10
  41 #define ZOOM_MAX 400
  42
  43 bool getScRangeListForAddress( const OUString& sName, ScDocShell* pDocSh, ScRange& refRange, ScRangeList& aCellRanges, formula::FormulaGrammar::AddressConvention aConv = formula::FormulaGrammar::CONV_XL_A1 ) throw ( uno::RuntimeException );
  44
  45 ScVbaPageSetup::ScVbaPageSetup(const uno::Reference< XHelperInterface >& xParent,
  46                 const uno::Reference< uno::XComponentContext >& xContext,
  47                 const uno::Reference< sheet::XSpreadsheet >& xSheet,
  48                 const uno::Reference< frame::XModel >& xModel) throw (uno::RuntimeException):
  49            ScVbaPageSetup_BASE( xParent, xContext ), mxSheet( xSheet ), mbIsLandscape( false )
  50 {
  51     // query for current page style
  52     mxModel.set( xModel, uno::UNO_QUERY_THROW );
  53     uno::Reference< beans::XPropertySet > xSheetProps( mxSheet, uno::UNO_QUERY_THROW );
  54     uno::Any aValue = xSheetProps->getPropertyValue("PageStyle");
  55     OUString aStyleName;
  56     aValue >>= aStyleName;
  57
  58     uno::Reference< style::XStyleFamiliesSupplier > xStyleFamiliesSup( mxModel, uno::UNO_QUERY_THROW );
  59     uno::Reference< container::XNameAccess > xStyleFamilies = xStyleFamiliesSup->getStyleFamilies();
  60     uno::Reference< container::XNameAccess > xPageStyle( xStyleFamilies->getByName("PageStyles"), uno::UNO_QUERY_THROW );
  61     mxPageProps.set( xPageStyle->getByName(aStyleName), uno::UNO_QUERY_THROW );
  62     mnOrientLandscape = excel::XlPageOrientation::xlLandscape;
  63     mnOrientPortrait = excel::XlPageOrientation::xlPortrait;
  64     mxPageProps->getPropertyValue("IsLandscape") >>= mbIsLandscape;
  65 }
  66
  67 OUString SAL_CALL ScVbaPageSetup::getPrintArea() throw (css::uno::RuntimeException)
  68 {
  69     OUString aPrintArea;
  70     uno::Reference< sheet::XPrintAreas > xPrintAreas( mxSheet, uno::UNO_QUERY_THROW );
  71     uno::Sequence< table::CellRangeAddress > aSeq = xPrintAreas->getPrintAreas();
  72     sal_Int32 nCount = aSeq.getLength();
  73     if( nCount )
  74     {
  75         ScAddress::Details aDetails( formula::FormulaGrammar::CONV_XL_A1, 0, 0 );
  76         sal_uInt16 nFlags = SCA_VALID;
  77         nFlags |= ( SCA_TAB_ABSOLUTE | SCA_COL_ABSOLUTE | SCA_ROW_ABSOLUTE | SCA_TAB2_ABSOLUTE | SCA_COL2_ABSOLUTE | SCA_ROW2_ABSOLUTE );
  78         ScRangeList aRangeList;
  79         for( sal_Int32 i=0; i<nCount; i++ )
  80         {
  81             ScRange aRange;
  82             ScUnoConversion::FillScRange( aRange, aSeq[i] );
  83             aRangeList.Append( aRange );
  84         }
  85         ScDocument* pDoc = excel::getDocShell( mxModel )->GetDocument();
  86         aRangeList.Format( aPrintArea, nFlags, pDoc, formula::FormulaGrammar::CONV_XL_A1, ','  );
  87     }
  88
  89     return aPrintArea;
  90 }
  91
  92 void SAL_CALL ScVbaPageSetup::setPrintArea( const OUString& rAreas ) throw (css::uno::RuntimeException)
  93 {
  94     uno::Reference< sheet::XPrintAreas > xPrintAreas( mxSheet, uno::UNO_QUERY_THROW );
  95     if( rAreas.isEmpty() ||
  96         rAreas.equalsIgnoreAsciiCase ( OUString("FALSE") ) )
  97     {
  98         // print the whole sheet
  99         uno::Sequence< table::CellRangeAddress > aSeq;
 100         xPrintAreas->setPrintAreas( aSeq );
 101     }
 102     else
 103     {
 104         ScRangeList aCellRanges;
 105         ScRange aRange;
 106         if( getScRangeListForAddress( rAreas, excel::getDocShell( mxModel ) , aRange, aCellRanges ) )
 107         {
 108             uno::Sequence< table::CellRangeAddress > aSeq( aCellRanges.size() );
 109             for ( size_t i = 0, nRanges = aCellRanges.size(); i < nRanges; ++i )
 110             {
 111                 ScRange* pRange = aCellRanges[ i ];
 112                 table::CellRangeAddress aRangeAddress;
 113                 ScUnoConversion::FillApiRange( aRangeAddress, *pRange );
 114                 aSeq[ i++ ] = aRangeAddress;
 115             }
 116             xPrintAreas->setPrintAreas( aSeq );
 117         }
 118     }
 119 }
 120
 121 double SAL_CALL ScVbaPageSetup::getHeaderMargin() throw (css::uno::RuntimeException)
 122 {
 123     return VbaPageSetupBase::getHeaderMargin();
 124 }
 125
 126 void SAL_CALL ScVbaPageSetup::setHeaderMargin( double margin ) throw (css::uno::RuntimeException)
 127 {
 128     VbaPageSetupBase::setHeaderMargin( margin );
 129 }
 130
 131 double SAL_CALL ScVbaPageSetup::getFooterMargin() throw (css::uno::RuntimeException)
 132 {
 133     return VbaPageSetupBase::getFooterMargin();
 134 }
 135
 136 void SAL_CALL ScVbaPageSetup::setFooterMargin( double margin ) throw (css::uno::RuntimeException)
 137 {
 138     VbaPageSetupBase::setFooterMargin( margin );
 139 }
 140
 141 uno::Any SAL_CALL ScVbaPageSetup::getFitToPagesTall() throw (css::uno::RuntimeException)
 142 {
 143     return mxPageProps->getPropertyValue("ScaleToPagesY");
 144 }
 145
 146 void SAL_CALL ScVbaPageSetup::setFitToPagesTall( const uno::Any& fitToPagesTall) throw (css::uno::RuntimeException)
 147 {
 148     sal_uInt16 scaleToPageY = 0;
 149     try
 150     {
 151         sal_Bool aValue;
 152         if( fitToPagesTall.getValueTypeClass() != uno::TypeClass_BOOLEAN || (fitToPagesTall >>= aValue))
 153         {
 154             fitToPagesTall >>= scaleToPageY;
 155         }
 156
 157         mxPageProps->setPropertyValue("ScaleToPagesY", uno::makeAny( scaleToPageY ));
 158     }
 159     catch( uno::Exception& )
 160     {
 161     }
 162 }
 163
 164 uno::Any SAL_CALL ScVbaPageSetup::getFitToPagesWide() throw (css::uno::RuntimeException)
 165 {
 166     return mxPageProps->getPropertyValue("ScaleToPagesX");
 167 }
 168
 169 void SAL_CALL ScVbaPageSetup::setFitToPagesWide( const uno::Any& fitToPagesWide) throw (css::uno::RuntimeException)
 170 {
 171     sal_uInt16 scaleToPageX = 0;
 172     try
 173     {
 174         sal_Bool aValue = false;
 175         if( fitToPagesWide.getValueTypeClass() != uno::TypeClass_BOOLEAN || (fitToPagesWide >>= aValue))
 176         {
 177             fitToPagesWide >>= scaleToPageX;
 178         }
 179
 180         mxPageProps->setPropertyValue("ScaleToPagesX", uno::makeAny( scaleToPageX ));
 181     }
 182     catch( uno::Exception& )
 183     {
 184     }
 185 }
 186
 187 uno::Any SAL_CALL ScVbaPageSetup::getZoom() throw (css::uno::RuntimeException)
 188 {
 189     return mxPageProps->getPropertyValue("PageScale");
 190 }
 191
 192 void SAL_CALL ScVbaPageSetup::setZoom( const uno::Any& zoom) throw (css::uno::RuntimeException)
 193 {
 194     sal_uInt16 pageScale = 0;
 195     try
 196     {
 197         if( zoom.getValueTypeClass() == uno::TypeClass_BOOLEAN )
 198         {
 199             sal_Bool aValue = false;
 200             zoom >>= aValue;
 201             if( aValue )
 202             {
 203                 DebugHelper::exception(SbERR_BAD_PARAMETER, OUString() );
 204             }
 205         }
 206         else
 207         {
 208             zoom >>= pageScale;
 209             if(( pageScale < ZOOM_IN )||( pageScale > ZOOM_MAX ))
 210             {
 211                 DebugHelper::exception(SbERR_BAD_PARAMETER, OUString() );
 212             }
 213         }
 214
 215         // these only exist in S08
 216         sal_uInt16 nScale = 0;
 217         mxPageProps->setPropertyValue("ScaleToPages", uno::makeAny( nScale ));
 218         mxPageProps->setPropertyValue("ScaleToPagesX", uno::makeAny( nScale ));
 219         mxPageProps->setPropertyValue("ScaleToPagesY", uno::makeAny( nScale ));
 220     }
 221     catch( beans::UnknownPropertyException& )
 222     {
 223         if( pageScale == 0 )
 224         {
 225             DebugHelper::exception(SbERR_BAD_PARAMETER, OUString() );
 226         }
 227     }
 228     catch( uno::Exception& )
 229     {
 230     }
 231
 232     mxPageProps->setPropertyValue("PageScale", uno::makeAny( pageScale ));
 233 }
 234
 235 OUString SAL_CALL ScVbaPageSetup::getLeftHeader() throw (css::uno::RuntimeException)
 236 {
 237     OUString leftHeader;
 238     try
 239     {
 240         uno::Reference<sheet::XHeaderFooterContent> xHeaderContent( mxPageProps->getPropertyValue("RightPageHeaderContent"), uno::UNO_QUERY_THROW);
 241         if( xHeaderContent.is() )
 242         {
 243             uno::Reference< text::XText > xText = xHeaderContent->getLeftText();
 244             leftHeader = xText->getString();
 245         }
 246     }
 247     catch( uno::Exception& )
 248     {
 249     }
 250
 251     return leftHeader;
 252 }
 253
 254 void SAL_CALL ScVbaPageSetup::setLeftHeader( const OUString& leftHeader) throw (css::uno::RuntimeException)
 255 {
 256     try
 257     {
 258         uno::Reference<sheet::XHeaderFooterContent> xHeaderContent( mxPageProps->getPropertyValue("RightPageHeaderContent"), uno::UNO_QUERY_THROW);
 259         if( xHeaderContent.is() )
 260         {
 261             uno::Reference< text::XText > xText = xHeaderContent->getLeftText();
 262             xText->setString( leftHeader );
 263             mxPageProps->setPropertyValue("RightPageHeaderContent", uno::makeAny(xHeaderContent) );
 264         }
 265     }
 266     catch( uno::Exception& )
 267     {
 268     }
 269 }
 270
 271 OUString SAL_CALL ScVbaPageSetup::getCenterHeader() throw (css::uno::RuntimeException)
 272 {
 273     OUString centerHeader;
 274     try
 275     {
 276         uno::Reference<sheet::XHeaderFooterContent> xHeaderContent( mxPageProps->getPropertyValue("RightPageHeaderContent"), uno::UNO_QUERY_THROW);
 277         if( xHeaderContent.is() )
 278         {
 279             uno::Reference< text::XText > xText = xHeaderContent->getCenterText();
 280             centerHeader = xText->getString();
 281         }
 282     }
 283     catch( uno::Exception& )
 284     {
 285     }
 286
 287     return centerHeader;
 288 }
 289
 290 void SAL_CALL ScVbaPageSetup::setCenterHeader( const OUString& centerHeader) throw (css::uno::RuntimeException)
 291 {
 292     try
 293     {
 294         uno::Reference<sheet::XHeaderFooterContent> xHeaderContent( mxPageProps->getPropertyValue("RightPageHeaderContent"), uno::UNO_QUERY_THROW);
 295         if( xHeaderContent.is() )
 296         {
 297             uno::Reference< text::XText > xText = xHeaderContent->getCenterText();
 298             xText->setString( centerHeader );
 299             mxPageProps->setPropertyValue("RightPageHeaderContent", uno::makeAny(xHeaderContent) );
 300         }
 301     }
 302     catch( uno::Exception& )
 303     {
 304     }
 305 }
 306
 307 OUString SAL_CALL ScVbaPageSetup::getRightHeader() throw (css::uno::RuntimeException)
 308 {
 309     OUString rightHeader;
 310     try
 311     {
 312         uno::Reference<sheet::XHeaderFooterContent> xHeaderContent( mxPageProps->getPropertyValue("RightPageHeaderContent"), uno::UNO_QUERY_THROW);
 313         if( xHeaderContent.is() )
 314         {
 315             uno::Reference< text::XText > xText = xHeaderContent->getRightText();
 316             rightHeader = xText->getString();
 317         }
 318     }
 319     catch( uno::Exception& )
 320     {
 321     }
 322
 323     return rightHeader;
 324 }
 325
 326 void SAL_CALL ScVbaPageSetup::setRightHeader( const OUString& rightHeader) throw (css::uno::RuntimeException)
 327 {
 328     try
 329     {
 330         uno::Reference<sheet::XHeaderFooterContent> xHeaderContent( mxPageProps->getPropertyValue("RightPageHeaderContent"), uno::UNO_QUERY_THROW);
 331         if( xHeaderContent.is() )
 332         {
 333             uno::Reference< text::XText > xText = xHeaderContent->getRightText();
 334             xText->setString( rightHeader );
 335             mxPageProps->setPropertyValue("RightPageHeaderContent", uno::makeAny(xHeaderContent) );
 336         }
 337     }
 338     catch( uno::Exception& )
 339     {
 340     }
 341 }
 342
 343 OUString SAL_CALL ScVbaPageSetup::getLeftFooter() throw (css::uno::RuntimeException)
 344 {
 345     OUString leftFooter;
 346     try
 347     {
 348         uno::Reference<sheet::XHeaderFooterContent> xFooterContent( mxPageProps->getPropertyValue("RightPageFooterContent"), uno::UNO_QUERY_THROW);
 349         if( xFooterContent.is() )
 350         {
 351             uno::Reference< text::XText > xText = xFooterContent->getLeftText();
 352             leftFooter = xText->getString();
 353         }
 354     }
 355     catch( uno::Exception& )
 356     {
 357     }
 358
 359     return leftFooter;
 360 }
 361
 362 void SAL_CALL ScVbaPageSetup::setLeftFooter( const OUString& leftFooter) throw (css::uno::RuntimeException)
 363 {
 364     try
 365     {
 366         uno::Reference<sheet::XHeaderFooterContent> xFooterContent( mxPageProps->getPropertyValue("RightPageFooterContent"), uno::UNO_QUERY_THROW);
 367         if( xFooterContent.is() )
 368         {
 369             uno::Reference< text::XText > xText = xFooterContent->getLeftText();
 370             xText->setString( leftFooter );
 371             mxPageProps->setPropertyValue("RightPageFooterContent", uno::makeAny(xFooterContent) );
 372         }
 373     }
 374     catch( uno::Exception& )
 375     {
 376     }
 377 }
 378
 379 OUString SAL_CALL ScVbaPageSetup::getCenterFooter() throw (css::uno::RuntimeException)
 380 {
 381     OUString centerFooter;
 382     try
 383     {
 384         uno::Reference<sheet::XHeaderFooterContent> xFooterContent( mxPageProps->getPropertyValue("RightPageFooterContent"), uno::UNO_QUERY_THROW);
 385         if( xFooterContent.is() )
 386         {
 387             uno::Reference< text::XText > xText = xFooterContent->getCenterText();
 388             centerFooter = xText->getString();
 389         }
 390     }
 391     catch( uno::Exception& )
 392     {
 393     }
 394
 395     return centerFooter;
 396 }
 397
 398 void SAL_CALL ScVbaPageSetup::setCenterFooter( const OUString& centerFooter) throw (css::uno::RuntimeException)
 399 {
 400     try
 401     {
 402         uno::Reference<sheet::XHeaderFooterContent> xFooterContent( mxPageProps->getPropertyValue("RightPageFooterContent"), uno::UNO_QUERY_THROW);
 403         if( xFooterContent.is() )
 404         {
 405             uno::Reference< text::XText > xText = xFooterContent->getCenterText();
 406             xText->setString( centerFooter );
 407             mxPageProps->setPropertyValue("RightPageFooterContent", uno::makeAny(xFooterContent) );
 408         }
 409     }
 410     catch( uno::Exception& )
 411     {
 412     }
 413
 414 }
 415
 416 OUString SAL_CALL ScVbaPageSetup::getRightFooter() throw (css::uno::RuntimeException)
 417 {
 418     OUString rightFooter;
 419     try
 420     {
 421         uno::Reference<sheet::XHeaderFooterContent> xFooterContent( mxPageProps->getPropertyValue("RightPageFooterContent"), uno::UNO_QUERY_THROW);
 422         if( xFooterContent.is() )
 423         {
 424             uno::Reference< text::XText > xText = xFooterContent->getRightText();
 425             rightFooter = xText->getString();
 426         }
 427     }
 428     catch( uno::Exception& )
 429     {
 430     }
 431
 432     return rightFooter;
 433 }
 434
 435 void SAL_CALL ScVbaPageSetup::setRightFooter( const OUString& rightFooter) throw (css::uno::RuntimeException)
 436 {
 437     try
 438     {
 439         uno::Reference<sheet::XHeaderFooterContent> xFooterContent( mxPageProps->getPropertyValue("RightPageFooterContent"), uno::UNO_QUERY_THROW);
 440         if( xFooterContent.is() )
 441         {
 442             uno::Reference< text::XText > xText = xFooterContent->getRightText();
 443             xText->setString( rightFooter );
 444             mxPageProps->setPropertyValue("RightPageFooterContent", uno::makeAny(xFooterContent) );
 445         }
 446     }
 447     catch( uno::Exception& )
 448     {
 449     }
 450 }
 451
 452 sal_Int32 SAL_CALL ScVbaPageSetup::getOrder() throw (css::uno::RuntimeException)
 453 {
 454     sal_Int32 order = excel::XlOrder::xlDownThenOver;
 455     try
 456     {
 457         uno::Any aValue = mxPageProps->getPropertyValue("PrintDownFirst");
 458         sal_Bool bPrintDownFirst = false;
 459         aValue >>= bPrintDownFirst;
 460         if( !bPrintDownFirst )
 461             order = excel::XlOrder::xlOverThenDown;
 462     }
 463     catch( uno::Exception& )
 464     {
 465     }
 466
 467     return order;
 468 }
 469
 470 void SAL_CALL ScVbaPageSetup::setOrder( sal_Int32 order) throw (css::uno::RuntimeException)
 471 {
 472     sal_Bool bOrder = sal_True;
 473     switch( order )
 474     {
 475         case excel::XlOrder::xlDownThenOver:
 476             break;
 477         case excel::XlOrder::xlOverThenDown:
 478             bOrder = false;
 479             break;
 480         default:
 481             DebugHelper::exception(SbERR_BAD_PARAMETER, OUString() );
 482     }
 483
 484     try
 485     {
 486         mxPageProps->setPropertyValue("PrintDownFirst", uno::makeAny( bOrder ));
 487     }
 488     catch( uno::Exception& )
 489     {
 490     }
 491 }
 492
 493 sal_Int32 SAL_CALL ScVbaPageSetup::getFirstPageNumber() throw (css::uno::RuntimeException)
 494 {
 495     sal_Int16 number = 0;
 496     try
 497     {
 498         uno::Any aValue = mxPageProps->getPropertyValue("FirstPageNumber");
 499         aValue >>= number;
 500     }
 501     catch( uno::Exception& )
 502     {
 503     }
 504
 505     if( number ==0 )
 506     {
 507         number = excel::Constants::xlAutomatic;
 508     }
 509
 510     return number;
 511 }
 512
 513 void SAL_CALL ScVbaPageSetup::setFirstPageNumber( sal_Int32 firstPageNumber) throw (css::uno::RuntimeException)
 514 {
 515     if( firstPageNumber == excel::Constants::xlAutomatic )
 516         firstPageNumber = 0;
 517
 518     try
 519     {
 520         uno::Any aValue;
 521         aValue <<= (sal_Int16)firstPageNumber;
 522         mxPageProps->setPropertyValue("FirstPageNumber", aValue );
 523     }
 524     catch( uno::Exception& )
 525     {
 526     }
 527 }
 528
 529 sal_Bool SAL_CALL ScVbaPageSetup::getCenterVertically() throw (css::uno::RuntimeException)
 530 {
 531     sal_Bool centerVertically = false;
 532     try
 533     {
 534         uno::Any aValue = mxPageProps->getPropertyValue("CenterVertically");
 535         aValue >>= centerVertically;
 536     }
 537     catch( uno::Exception& )
 538     {
 539     }
 540     return centerVertically;
 541 }
 542
 543 void SAL_CALL ScVbaPageSetup::setCenterVertically( sal_Bool centerVertically) throw (css::uno::RuntimeException)
 544 {
 545     try
 546     {
 547         mxPageProps->setPropertyValue("CenterVertically", uno::makeAny( centerVertically ));
 548     }
 549     catch( uno::Exception& )
 550     {
 551     }
 552 }
 553
 554 sal_Bool SAL_CALL ScVbaPageSetup::getCenterHorizontally() throw (css::uno::RuntimeException)
 555 {
 556     sal_Bool centerHorizontally = false;
 557     try
 558     {
 559         uno::Any aValue = mxPageProps->getPropertyValue("CenterHorizontally");
 560         aValue >>= centerHorizontally;
 561     }
 562     catch( uno::Exception& )
 563     {
 564     }
 565     return centerHorizontally;
 566 }
 567
 568 void SAL_CALL ScVbaPageSetup::setCenterHorizontally( sal_Bool centerHorizontally) throw (css::uno::RuntimeException)
 569 {
 570     try
 571     {
 572         mxPageProps->setPropertyValue("CenterHorizontally", uno::makeAny( centerHorizontally ));
 573     }
 574     catch( uno::Exception& )
 575     {
 576     }
 577 }
 578
 579 sal_Bool SAL_CALL ScVbaPageSetup::getPrintHeadings() throw (css::uno::RuntimeException)
 580 {
 581     sal_Bool printHeadings = false;
 582     try
 583     {
 584         uno::Any aValue = mxPageProps->getPropertyValue("PrintHeaders");
 585         aValue >>= printHeadings;
 586     }
 587     catch( uno::Exception& )
 588     {
 589     }
 590     return printHeadings;
 591 }
 592
 593 void SAL_CALL ScVbaPageSetup::setPrintHeadings( sal_Bool printHeadings) throw (css::uno::RuntimeException)
 594 {
 595     try
 596     {
 597         mxPageProps->setPropertyValue("PrintHeaders", uno::makeAny( printHeadings ));
 598     }
 599     catch( uno::Exception& )
 600     {
 601     }
 602 }
 603
 604 ::sal_Bool SAL_CALL ScVbaPageSetup::getPrintGridlines() throw (uno::RuntimeException)
 605 {
 606     return false;
 607 }
 608
 609 void SAL_CALL ScVbaPageSetup::setPrintGridlines( ::sal_Bool /*_printgridlines*/ ) throw (uno::RuntimeException)
 610 {
 611 }
 612
 613 OUString SAL_CALL ScVbaPageSetup::getPrintTitleRows() throw (uno::RuntimeException)
 614 {
 615     return OUString();
 616 }
 617 void SAL_CALL ScVbaPageSetup::setPrintTitleRows( const OUString& /*_printtitlerows*/ ) throw (css::uno::RuntimeException)
 618 {
 619 }
 620 OUString SAL_CALL ScVbaPageSetup::getPrintTitleColumns() throw (uno::RuntimeException)
 621 {
 622     return OUString();
 623 }
 624
 625 void SAL_CALL ScVbaPageSetup::setPrintTitleColumns( const OUString& /*_printtitlecolumns*/ ) throw (uno::RuntimeException)
 626 {
 627 }
 628
 629 sal_Int32 SAL_CALL ScVbaPageSetup::getPaperSize() throw (uno::RuntimeException)
 630 {
 631     awt::Size aSize; // current papersize
 632     mxPageProps->getPropertyValue( "Size" ) >>= aSize;
 633     if ( mbIsLandscape )
 634         ::std::swap( aSize.Width, aSize.Height );
 635
 636     sal_Int32 nPaperSizeIndex = msfilter::util::PaperSizeConv::getMSPaperSizeIndex( aSize );
 637     if ( nPaperSizeIndex == 0 )
 638         nPaperSizeIndex = excel::XlPaperSize::xlPaperUser;
 639     return nPaperSizeIndex;
 640 }
 641
 642 void SAL_CALL ScVbaPageSetup::setPaperSize( sal_Int32 papersize ) throw (uno::RuntimeException)
 643 {
 644     if ( papersize != excel::XlPaperSize::xlPaperUser )
 645     {
 646         awt::Size aPaperSize;
 647         const msfilter::util::ApiPaperSize& rConvertedSize = msfilter::util::PaperSizeConv::getApiSizeForMSPaperSizeIndex( papersize );
 648         aPaperSize.Height = rConvertedSize.mnHeight;
 649         aPaperSize.Width = rConvertedSize.mnWidth;
 650         if ( mbIsLandscape )
 651             ::std::swap( aPaperSize.Width, aPaperSize.Height );
 652         mxPageProps->setPropertyValue( "Size", uno::makeAny( aPaperSize ) );
 653     }
 654 }
 655
 656 OUString
 657 ScVbaPageSetup::getServiceImplName()
 658 {
 659     return OUString("ScVbaPageSetup");
 660 }
 661
 662 uno::Sequence< OUString >
 663 ScVbaPageSetup::getServiceNames()
 664 {
 665     static uno::Sequence< OUString > aServiceNames;
 666     if ( aServiceNames.getLength() == 0 )
 667     {
 668         aServiceNames.realloc( 1 );
 669         aServiceNames[ 0 ] = "ooo.vba.excel.PageSetup";
 670     }
 671     return aServiceNames;
 672 }
 673
 674 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */