1*efeef26fSAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 3*efeef26fSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*efeef26fSAndrew Rist * or more contributor license agreements. See the NOTICE file 5*efeef26fSAndrew Rist * distributed with this work for additional information 6*efeef26fSAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*efeef26fSAndrew Rist * to you under the Apache License, Version 2.0 (the 8*efeef26fSAndrew Rist * "License"); you may not use this file except in compliance 9*efeef26fSAndrew Rist * with the License. You may obtain a copy of the License at 10cdf0e10cSrcweir * 11*efeef26fSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12cdf0e10cSrcweir * 13*efeef26fSAndrew Rist * Unless required by applicable law or agreed to in writing, 14*efeef26fSAndrew Rist * software distributed under the License is distributed on an 15*efeef26fSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*efeef26fSAndrew Rist * KIND, either express or implied. See the License for the 17*efeef26fSAndrew Rist * specific language governing permissions and limitations 18*efeef26fSAndrew Rist * under the License. 19cdf0e10cSrcweir * 20*efeef26fSAndrew Rist *************************************************************/ 21*efeef26fSAndrew Rist 22*efeef26fSAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove 25cdf0e10cSrcweir #include "precompiled_sw.hxx" 26cdf0e10cSrcweir 27cdf0e10cSrcweir #include <com/sun/star/chart/ChartDataRowSource.hpp> 28cdf0e10cSrcweir #include <com/sun/star/chart2/data/XDataProvider.hpp> 29cdf0e10cSrcweir #include <com/sun/star/chart2/data/XDataReceiver.hpp> 30cdf0e10cSrcweir #include <com/sun/star/beans/PropertyState.hpp> 31cdf0e10cSrcweir 32cdf0e10cSrcweir #include <sot/storage.hxx> 33cdf0e10cSrcweir #include <sot/clsids.hxx> 34cdf0e10cSrcweir 35cdf0e10cSrcweir #include "edtwin.hxx" 36cdf0e10cSrcweir #include "errhdl.hxx" 37cdf0e10cSrcweir #include "wrtsh.hxx" 38cdf0e10cSrcweir #include "cmdid.h" 39cdf0e10cSrcweir #include "frmatr.hxx" 40cdf0e10cSrcweir #include "view.hxx" 41cdf0e10cSrcweir #include "basesh.hxx" 42cdf0e10cSrcweir #include "swundo.hxx" 43cdf0e10cSrcweir #include "tablemgr.hxx" 44cdf0e10cSrcweir #include "frmfmt.hxx" 45cdf0e10cSrcweir #include "instable.hxx" 46cdf0e10cSrcweir #include "swerror.h" 47cdf0e10cSrcweir #include "table.hrc" 48cdf0e10cSrcweir #include "swabstdlg.hxx" 49cdf0e10cSrcweir #include "swcli.hxx" 50cdf0e10cSrcweir #include "docsh.hxx" 51cdf0e10cSrcweir #include "unotbl.hxx" 52cdf0e10cSrcweir #include "unochart.hxx" 53cdf0e10cSrcweir 54cdf0e10cSrcweir using namespace ::com::sun::star; 55cdf0e10cSrcweir 56cdf0e10cSrcweir /*------------------------------------------------------------------------ 57cdf0e10cSrcweir Beschreibung: Zeilenhoehe einstellen (Dialog) 58cdf0e10cSrcweir ------------------------------------------------------------------------*/ 59cdf0e10cSrcweir 60cdf0e10cSrcweir 61cdf0e10cSrcweir void SwTableFUNC::ColWidthDlg( Window *pParent ) 62cdf0e10cSrcweir { 63cdf0e10cSrcweir InitTabCols(); 64cdf0e10cSrcweir SwAbstractDialogFactory* pFact = SwAbstractDialogFactory::Create(); 65cdf0e10cSrcweir DBG_ASSERT(pFact, "SwAbstractDialogFactory fail!"); 66cdf0e10cSrcweir 67cdf0e10cSrcweir VclAbstractDialog* pDlg = pFact->CreateSwTableWidthDlg( pParent, *this ,DLG_COL_WIDTH ); 68cdf0e10cSrcweir DBG_ASSERT(pDlg, "Dialogdiet fail!"); 69cdf0e10cSrcweir pDlg->Execute(); 70cdf0e10cSrcweir delete pDlg; 71cdf0e10cSrcweir } 72cdf0e10cSrcweir 73cdf0e10cSrcweir /*-------------------------------------------------------------------- 74cdf0e10cSrcweir Beschreibung: Breite ermitteln 75cdf0e10cSrcweir --------------------------------------------------------------------*/ 76cdf0e10cSrcweir 77cdf0e10cSrcweir 78cdf0e10cSrcweir SwTwips SwTableFUNC::GetColWidth(sal_uInt16 nNum) const 79cdf0e10cSrcweir { 80cdf0e10cSrcweir SwTwips nWidth = 0; 81cdf0e10cSrcweir 82cdf0e10cSrcweir if( aCols.Count() > 0 ) 83cdf0e10cSrcweir { 84cdf0e10cSrcweir if(aCols.Count() == GetColCount()) 85cdf0e10cSrcweir { 86cdf0e10cSrcweir nWidth = (SwTwips)((nNum == aCols.Count()) ? 87cdf0e10cSrcweir aCols.GetRight() - aCols[nNum-1] : 88cdf0e10cSrcweir nNum == 0 ? aCols[nNum] - aCols.GetLeft() : 89cdf0e10cSrcweir aCols[nNum] - aCols[nNum-1]); 90cdf0e10cSrcweir } 91cdf0e10cSrcweir else 92cdf0e10cSrcweir { 93cdf0e10cSrcweir SwTwips nRValid = nNum < GetColCount() ? 94cdf0e10cSrcweir aCols[(sal_uInt16)GetRightSeparator((int)nNum)]: 95cdf0e10cSrcweir aCols.GetRight(); 96cdf0e10cSrcweir SwTwips nLValid = nNum ? 97cdf0e10cSrcweir aCols[(sal_uInt16)GetRightSeparator((int)nNum - 1)]: 98cdf0e10cSrcweir aCols.GetLeft(); 99cdf0e10cSrcweir nWidth = nRValid - nLValid; 100cdf0e10cSrcweir } 101cdf0e10cSrcweir } 102cdf0e10cSrcweir else 103cdf0e10cSrcweir nWidth = aCols.GetRight(); 104cdf0e10cSrcweir 105cdf0e10cSrcweir return nWidth; 106cdf0e10cSrcweir } 107cdf0e10cSrcweir 108cdf0e10cSrcweir 109cdf0e10cSrcweir 110cdf0e10cSrcweir SwTwips SwTableFUNC::GetMaxColWidth( sal_uInt16 nNum ) const 111cdf0e10cSrcweir { 112cdf0e10cSrcweir ASSERT(nNum <= aCols.Count(), "Index out of Area"); 113cdf0e10cSrcweir 114cdf0e10cSrcweir if ( GetColCount() > 0 ) 115cdf0e10cSrcweir { 116cdf0e10cSrcweir // Die max. Breite ergibt sich aus der eigenen Breite und 117cdf0e10cSrcweir // der Breite der Nachbarzellen um je MINLAY verringert 118cdf0e10cSrcweir SwTwips nMax = nNum == 0 ? 119cdf0e10cSrcweir GetColWidth(1) - MINLAY : 120cdf0e10cSrcweir nNum == GetColCount() ? 121cdf0e10cSrcweir GetColWidth( nNum-1 ) - MINLAY : 122cdf0e10cSrcweir GetColWidth(nNum - 1) + GetColWidth( nNum + 1 ) - 2 * MINLAY; 123cdf0e10cSrcweir 124cdf0e10cSrcweir return nMax + GetColWidth(nNum) ; 125cdf0e10cSrcweir } 126cdf0e10cSrcweir else 127cdf0e10cSrcweir return GetColWidth(nNum); 128cdf0e10cSrcweir } 129cdf0e10cSrcweir 130cdf0e10cSrcweir 131cdf0e10cSrcweir 132cdf0e10cSrcweir void SwTableFUNC::SetColWidth(sal_uInt16 nNum, SwTwips nNewWidth ) 133cdf0e10cSrcweir { 134cdf0e10cSrcweir // aktuelle Breite setzen 135cdf0e10cSrcweir // alle folgenden Verschieben 136cdf0e10cSrcweir sal_Bool bCurrentOnly = sal_False; 137cdf0e10cSrcweir SwTwips nWidth = 0; 138cdf0e10cSrcweir 139cdf0e10cSrcweir if ( aCols.Count() > 0 ) 140cdf0e10cSrcweir { 141cdf0e10cSrcweir if(aCols.Count() != GetColCount()) 142cdf0e10cSrcweir bCurrentOnly = sal_True; 143cdf0e10cSrcweir nWidth = GetColWidth(nNum); 144cdf0e10cSrcweir 145cdf0e10cSrcweir int nDiff = (int)(nNewWidth - nWidth); 146cdf0e10cSrcweir if( !nNum ) 147cdf0e10cSrcweir aCols[ static_cast< sal_uInt16 >(GetRightSeparator(0)) ] += nDiff; 148cdf0e10cSrcweir else if( nNum < GetColCount() ) 149cdf0e10cSrcweir { 150cdf0e10cSrcweir if(nDiff < GetColWidth(nNum + 1) - MINLAY) 151cdf0e10cSrcweir aCols[ static_cast< sal_uInt16 >(GetRightSeparator(nNum)) ] += nDiff; 152cdf0e10cSrcweir else 153cdf0e10cSrcweir { 154cdf0e10cSrcweir int nDiffLeft = nDiff - (int)GetColWidth(nNum + 1) + (int)MINLAY; 155cdf0e10cSrcweir aCols[ static_cast< sal_uInt16 >(GetRightSeparator(nNum)) ] += (nDiff - nDiffLeft); 156cdf0e10cSrcweir aCols[ static_cast< sal_uInt16 >(GetRightSeparator(nNum - 1)) ] -= nDiffLeft; 157cdf0e10cSrcweir } 158cdf0e10cSrcweir } 159cdf0e10cSrcweir else 160cdf0e10cSrcweir aCols[ static_cast< sal_uInt16 >(GetRightSeparator(nNum-1)) ] -= nDiff; 161cdf0e10cSrcweir } 162cdf0e10cSrcweir else 163cdf0e10cSrcweir aCols.SetRight( Min( nNewWidth, aCols.GetRightMax()) ); 164cdf0e10cSrcweir 165cdf0e10cSrcweir pSh->StartAllAction(); 166cdf0e10cSrcweir pSh->SetTabCols( aCols, bCurrentOnly ); 167cdf0e10cSrcweir pSh->EndAllAction(); 168cdf0e10cSrcweir } 169cdf0e10cSrcweir 170cdf0e10cSrcweir 171cdf0e10cSrcweir 172cdf0e10cSrcweir void SwTableFUNC::InitTabCols() 173cdf0e10cSrcweir { 174cdf0e10cSrcweir ASSERT(pSh, keine Shell); 175cdf0e10cSrcweir 176cdf0e10cSrcweir if( pFmt && pSh) 177cdf0e10cSrcweir pSh->GetTabCols( aCols ); 178cdf0e10cSrcweir } 179cdf0e10cSrcweir 180cdf0e10cSrcweir 181cdf0e10cSrcweir 182cdf0e10cSrcweir SwTableFUNC::SwTableFUNC(SwWrtShell *pShell, sal_Bool bCopyFmt) 183cdf0e10cSrcweir : pFmt(pShell->GetTableFmt()), 184cdf0e10cSrcweir pSh(pShell), 185cdf0e10cSrcweir bCopy(bCopyFmt) 186cdf0e10cSrcweir { 187cdf0e10cSrcweir // gfs. das Format fuer die Bearbeitung kopieren 188cdf0e10cSrcweir if( pFmt && bCopy ) 189cdf0e10cSrcweir pFmt = new SwFrmFmt( *pFmt ); 190cdf0e10cSrcweir } 191cdf0e10cSrcweir 192cdf0e10cSrcweir 193cdf0e10cSrcweir 194cdf0e10cSrcweir SwTableFUNC::~SwTableFUNC() 195cdf0e10cSrcweir { 196cdf0e10cSrcweir if(bCopy) 197cdf0e10cSrcweir delete pFmt; 198cdf0e10cSrcweir } 199cdf0e10cSrcweir 200cdf0e10cSrcweir void SwTableFUNC::UpdateChart() 201cdf0e10cSrcweir { 202cdf0e10cSrcweir //Update der Felder in der Tabelle vom User ausgeloesst, alle 203cdf0e10cSrcweir //Charts zu der Tabelle werden auf den neuesten Stand gebracht. 204cdf0e10cSrcweir SwFrmFmt *pFmt2 = pSh->GetTableFmt(); 205cdf0e10cSrcweir if ( pFmt2 && pSh->HasOLEObj( pFmt2->GetName() ) ) 206cdf0e10cSrcweir { 207cdf0e10cSrcweir pSh->StartAllAction(); 208cdf0e10cSrcweir pSh->UpdateCharts( pFmt2->GetName() ); 209cdf0e10cSrcweir pSh->EndAllAction(); 210cdf0e10cSrcweir } 211cdf0e10cSrcweir } 212cdf0e10cSrcweir 213cdf0e10cSrcweir uno::Reference< frame::XModel > SwTableFUNC::InsertChart( 214cdf0e10cSrcweir uno::Reference< chart2::data::XDataProvider > &rxDataProvider, 215cdf0e10cSrcweir sal_Bool bFillWithData, 216cdf0e10cSrcweir const rtl::OUString &rCellRange, 217cdf0e10cSrcweir SwFlyFrmFmt** ppFlyFrmFmt ) 218cdf0e10cSrcweir { 219cdf0e10cSrcweir uno::Reference< frame::XModel > xChartModel; 220cdf0e10cSrcweir pSh->StartUndo( UNDO_UI_INSERT_CHART ); 221cdf0e10cSrcweir pSh->StartAllAction(); 222cdf0e10cSrcweir 223cdf0e10cSrcweir String aName; 224cdf0e10cSrcweir if (pSh->IsCrsrInTbl()) 225cdf0e10cSrcweir { 226cdf0e10cSrcweir aName = pSh->GetTableFmt()->GetName(); 227cdf0e10cSrcweir // insert node before table 228cdf0e10cSrcweir pSh->MoveTable( fnTableCurr, fnTableStart ); 229cdf0e10cSrcweir pSh->Up( sal_False, 1, sal_False ); 230cdf0e10cSrcweir if ( pSh->IsCrsrInTbl() ) 231cdf0e10cSrcweir { 232cdf0e10cSrcweir if ( aName != pSh->GetTableFmt()->GetName() ) 233cdf0e10cSrcweir pSh->Down( sal_False, 1, sal_False ); // two adjacent tables 234cdf0e10cSrcweir } 235cdf0e10cSrcweir pSh->SplitNode(); 236cdf0e10cSrcweir } 237cdf0e10cSrcweir 238cdf0e10cSrcweir // insert chart 239cdf0e10cSrcweir ::rtl::OUString aObjName; 240cdf0e10cSrcweir comphelper::EmbeddedObjectContainer aCnt; 241cdf0e10cSrcweir uno::Reference < embed::XEmbeddedObject > xObj = 242cdf0e10cSrcweir aCnt.CreateEmbeddedObject( SvGlobalName( SO3_SCH_CLASSID ).GetByteSequence(), aObjName ); 243cdf0e10cSrcweir 244cdf0e10cSrcweir ::svt::EmbeddedObjectRef aEmbObjRef( xObj, ::com::sun::star::embed::Aspects::MSOLE_CONTENT ); 245cdf0e10cSrcweir if ( xObj.is() ) 246cdf0e10cSrcweir { 247cdf0e10cSrcweir 248cdf0e10cSrcweir SwFlyFrmFmt* pTmp = 0; 249cdf0e10cSrcweir pSh->InsertOleObject( aEmbObjRef, &pTmp ); 250cdf0e10cSrcweir if (ppFlyFrmFmt) 251cdf0e10cSrcweir *ppFlyFrmFmt = pTmp; 252cdf0e10cSrcweir 253cdf0e10cSrcweir uno::Reference< embed::XComponentSupplier > xCompSupp( xObj, uno::UNO_QUERY ); 254cdf0e10cSrcweir if( xCompSupp.is()) 255cdf0e10cSrcweir { 256cdf0e10cSrcweir xChartModel.set( xCompSupp->getComponent(), uno::UNO_QUERY ); 257cdf0e10cSrcweir if( xChartModel.is() ) 258cdf0e10cSrcweir xChartModel->lockControllers(); //#i79578# don't request a new replacement image for charts to often - block change notifications 259cdf0e10cSrcweir } 260cdf0e10cSrcweir 261cdf0e10cSrcweir // set the table name at the OLE-node 262cdf0e10cSrcweir if (aName.Len()) 263cdf0e10cSrcweir pSh->SetChartName( aName ); 264cdf0e10cSrcweir } 265cdf0e10cSrcweir pSh->EndAllAction(); 266cdf0e10cSrcweir 267cdf0e10cSrcweir if ( xObj.is() ) 268cdf0e10cSrcweir { 269cdf0e10cSrcweir // Let the chart be activated after the inserting 270cdf0e10cSrcweir SfxInPlaceClient* pClient = pSh->GetView().FindIPClient( xObj, &pSh->GetView().GetEditWin() ); 271cdf0e10cSrcweir if ( !pClient ) 272cdf0e10cSrcweir { 273cdf0e10cSrcweir pClient = new SwOleClient( &pSh->GetView(), &pSh->GetView().GetEditWin(), aEmbObjRef ); 274cdf0e10cSrcweir pSh->SetCheckForOLEInCaption( sal_True ); 275cdf0e10cSrcweir } 276cdf0e10cSrcweir pSh->CalcAndSetScale( aEmbObjRef ); 277cdf0e10cSrcweir //#50270# Error brauchen wir nicht handeln, das erledigt das 278cdf0e10cSrcweir //DoVerb in der SfxViewShell 279cdf0e10cSrcweir ErrCode nErr = pClient->DoVerb( SVVERB_SHOW ); 280cdf0e10cSrcweir (void) nErr; 281cdf0e10cSrcweir } 282cdf0e10cSrcweir 283cdf0e10cSrcweir uno::Reference< chart2::data::XDataReceiver > xDataReceiver( xChartModel, uno::UNO_QUERY ); 284cdf0e10cSrcweir if (bFillWithData && xDataReceiver.is() && rxDataProvider.is()) 285cdf0e10cSrcweir { 286cdf0e10cSrcweir xDataReceiver->attachDataProvider( rxDataProvider ); 287cdf0e10cSrcweir 288cdf0e10cSrcweir uno::Reference< util::XNumberFormatsSupplier > xNumberFormatsSupplier( pSh->GetView().GetDocShell()->GetModel(), uno::UNO_QUERY ); 289cdf0e10cSrcweir xDataReceiver->attachNumberFormatsSupplier( xNumberFormatsSupplier ); 290cdf0e10cSrcweir 291cdf0e10cSrcweir // default values for ranges that do not consist of a single row or column 292cdf0e10cSrcweir bool bHasCategories = true; 293cdf0e10cSrcweir bool bFirstCellAsLabel = true; 294cdf0e10cSrcweir chart::ChartDataRowSource eDataRowSource = chart::ChartDataRowSource_COLUMNS; 295cdf0e10cSrcweir 296cdf0e10cSrcweir SwRangeDescriptor aDesc; 297cdf0e10cSrcweir FillRangeDescriptor( aDesc, rCellRange ); 298cdf0e10cSrcweir bool bSingleRowCol = aDesc.nTop == aDesc.nBottom || aDesc.nLeft == aDesc.nRight; 299cdf0e10cSrcweir if (bSingleRowCol) 300cdf0e10cSrcweir { 301cdf0e10cSrcweir aDesc.Normalize(); 302cdf0e10cSrcweir sal_Int32 nRowLen = aDesc.nRight - aDesc.nLeft + 1; 303cdf0e10cSrcweir sal_Int32 nColLen = aDesc.nBottom - aDesc.nTop + 1; 304cdf0e10cSrcweir 305cdf0e10cSrcweir bHasCategories = false; 306cdf0e10cSrcweir if (nRowLen == 1 && nColLen == 1) 307cdf0e10cSrcweir bFirstCellAsLabel = false; 308cdf0e10cSrcweir else if (nRowLen > 1) 309cdf0e10cSrcweir eDataRowSource = chart::ChartDataRowSource_ROWS; 310cdf0e10cSrcweir else if (nColLen > 1) 311cdf0e10cSrcweir eDataRowSource = chart::ChartDataRowSource_COLUMNS; 312cdf0e10cSrcweir else { 313cdf0e10cSrcweir DBG_ERROR( "unexpected state" ); 314cdf0e10cSrcweir } 315cdf0e10cSrcweir } 316cdf0e10cSrcweir 317cdf0e10cSrcweir uno::Sequence< beans::PropertyValue > aArgs( 4 ); 318cdf0e10cSrcweir aArgs[0] = beans::PropertyValue( 319cdf0e10cSrcweir ::rtl::OUString::createFromAscii("CellRangeRepresentation"), -1, 320cdf0e10cSrcweir uno::makeAny( rCellRange ), beans::PropertyState_DIRECT_VALUE ); 321cdf0e10cSrcweir aArgs[1] = beans::PropertyValue( 322cdf0e10cSrcweir ::rtl::OUString::createFromAscii("HasCategories"), -1, 323cdf0e10cSrcweir uno::makeAny( bHasCategories ), beans::PropertyState_DIRECT_VALUE ); 324cdf0e10cSrcweir aArgs[2] = beans::PropertyValue( 325cdf0e10cSrcweir ::rtl::OUString::createFromAscii("FirstCellAsLabel"), -1, 326cdf0e10cSrcweir uno::makeAny( bFirstCellAsLabel ), beans::PropertyState_DIRECT_VALUE ); 327cdf0e10cSrcweir aArgs[3] = beans::PropertyValue( 328cdf0e10cSrcweir ::rtl::OUString::createFromAscii("DataRowSource"), -1, 329cdf0e10cSrcweir uno::makeAny( eDataRowSource ), beans::PropertyState_DIRECT_VALUE ); 330cdf0e10cSrcweir xDataReceiver->setArguments( aArgs ); 331cdf0e10cSrcweir } 332cdf0e10cSrcweir 333cdf0e10cSrcweir pSh->EndUndo( UNDO_UI_INSERT_CHART ); 334cdf0e10cSrcweir 335cdf0e10cSrcweir if( xChartModel.is() ) 336cdf0e10cSrcweir xChartModel->unlockControllers(); //#i79578# don't request a new replacement image for charts to often 337cdf0e10cSrcweir return xChartModel; 338cdf0e10cSrcweir } 339cdf0e10cSrcweir 340cdf0e10cSrcweir sal_uInt16 SwTableFUNC::GetCurColNum() const 341cdf0e10cSrcweir { 342cdf0e10cSrcweir sal_uInt16 nPos = pSh->GetCurTabColNum(); 343cdf0e10cSrcweir sal_uInt16 nCount = 0; 344cdf0e10cSrcweir for(sal_uInt16 i = 0; i < nPos; i++ ) 345cdf0e10cSrcweir if(aCols.IsHidden(i)) 346cdf0e10cSrcweir nCount ++; 347cdf0e10cSrcweir return nPos - nCount; 348cdf0e10cSrcweir } 349cdf0e10cSrcweir 350cdf0e10cSrcweir 351cdf0e10cSrcweir 352cdf0e10cSrcweir 353cdf0e10cSrcweir sal_uInt16 SwTableFUNC::GetColCount() const 354cdf0e10cSrcweir { 355cdf0e10cSrcweir sal_uInt16 nCount = 0; 356cdf0e10cSrcweir for(sal_uInt16 i = 0; i < aCols.Count(); i++ ) 357cdf0e10cSrcweir if(aCols.IsHidden(i)) 358cdf0e10cSrcweir nCount ++; 359cdf0e10cSrcweir return aCols.Count() - nCount; 360cdf0e10cSrcweir } 361cdf0e10cSrcweir 362cdf0e10cSrcweir 363cdf0e10cSrcweir 364cdf0e10cSrcweir int SwTableFUNC::GetRightSeparator(int nNum) const 365cdf0e10cSrcweir { 366cdf0e10cSrcweir DBG_ASSERT( nNum < (int)GetColCount() ,"Index out of range"); 367cdf0e10cSrcweir int i = 0; 368cdf0e10cSrcweir while( nNum >= 0 ) 369cdf0e10cSrcweir { 370cdf0e10cSrcweir if( !aCols.IsHidden( static_cast< sal_uInt16 >(i)) ) 371cdf0e10cSrcweir nNum--; 372cdf0e10cSrcweir i++; 373cdf0e10cSrcweir } 374cdf0e10cSrcweir return i - 1; 375cdf0e10cSrcweir } 376cdf0e10cSrcweir 377cdf0e10cSrcweir 378cdf0e10cSrcweir 379