1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 24 #ifndef SC_TABLE_HXX 25 #define SC_TABLE_HXX 26 27 #include <vector> 28 #include <memory> 29 #include <utility> 30 #include <tools/gen.hxx> 31 #include <tools/color.hxx> 32 #include <com/sun/star/uno/Sequence.hxx> 33 #include "column.hxx" 34 #include "sortparam.hxx" 35 #include "compressedarray.hxx" 36 37 #include <memory> 38 #include <set> 39 #include <boost/shared_ptr.hpp> 40 41 namespace utl { 42 class SearchParam; 43 class TextSearch; 44 } 45 46 namespace com { namespace sun { namespace star { 47 namespace sheet { 48 struct TablePageBreakData; 49 } 50 } } } 51 52 class SfxItemSet; 53 class SfxStyleSheetBase; 54 class SvxBoxInfoItem; 55 class SvxBoxItem; 56 class SvxSearchItem; 57 58 class ScAutoFormat; 59 class ScAutoFormatData; 60 class ScBaseCell; 61 class ScDocument; 62 class ScDrawLayer; 63 class ScFormulaCell; 64 class ScOutlineTable; 65 class ScPostIt; 66 class ScPrintSaverTab; 67 class ScProgress; 68 class ScProgress; 69 class ScRangeList; 70 class ScSheetEvents; 71 class ScSortInfoArray; 72 class ScStyleSheet; 73 class ScTableLink; 74 class ScTableProtection; 75 class ScUserListData; 76 struct RowInfo; 77 struct ScFunctionData; 78 struct ScLineFlags; 79 class CollatorWrapper; 80 class ScFlatUInt16RowSegments; 81 class ScFlatBoolRowSegments; 82 class ScFlatBoolColSegments; 83 84 85 struct ScShowRowsEntry 86 { 87 SCROW mnRow1; 88 SCROW mnRow2; 89 bool mbShow; 90 ScShowRowsEntryScShowRowsEntry91 ScShowRowsEntry( SCROW nR1, SCROW nR2, bool bS ) : 92 mnRow1(nR1), mnRow2(nR2), mbShow(bS) {} 93 }; 94 95 96 class ScTable 97 { 98 private: 99 typedef ::std::vector< ScRange > ScRangeVec; 100 typedef ::std::pair< SCCOL, SCROW > ScAddress2D; 101 typedef ::std::vector< ScAddress2D > ScAddress2DVec; 102 typedef ::std::auto_ptr< ScAddress2DVec > ScAddress2DVecPtr; 103 104 // Daten pro Tabelle ------------------ 105 ScColumn aCol[MAXCOLCOUNT]; 106 107 String aName; 108 String aCodeName; 109 String aComment; 110 sal_Bool bScenario; 111 sal_Bool bLayoutRTL; 112 sal_Bool bLoadingRTL; 113 114 String aLinkDoc; 115 String aLinkFlt; 116 String aLinkOpt; 117 String aLinkTab; 118 sal_uLong nLinkRefreshDelay; 119 sal_uInt8 nLinkMode; 120 121 // Seitenformatvorlage 122 String aPageStyle; 123 sal_Bool bPageSizeValid; 124 Size aPageSizeTwips; // Groesse der Druck-Seite 125 SCCOL nRepeatStartX; // Wiederholungszeilen/Spalten 126 SCCOL nRepeatEndX; // REPEAT_NONE, wenn nicht benutzt 127 SCROW nRepeatStartY; 128 SCROW nRepeatEndY; 129 130 ::std::auto_ptr<ScTableProtection> pTabProtection; 131 132 sal_uInt16* pColWidth; 133 ::boost::shared_ptr<ScFlatUInt16RowSegments> mpRowHeights; 134 135 sal_uInt8* pColFlags; 136 ScBitMaskCompressedArray< SCROW, sal_uInt8>* pRowFlags; 137 ::boost::shared_ptr<ScFlatBoolColSegments> mpHiddenCols; 138 ::boost::shared_ptr<ScFlatBoolRowSegments> mpHiddenRows; 139 ::boost::shared_ptr<ScFlatBoolColSegments> mpFilteredCols; 140 ::boost::shared_ptr<ScFlatBoolRowSegments> mpFilteredRows; 141 142 ::std::set<SCROW> maRowPageBreaks; 143 ::std::set<SCROW> maRowManualBreaks; 144 ::std::set<SCCOL> maColPageBreaks; 145 ::std::set<SCCOL> maColManualBreaks; 146 147 ScOutlineTable* pOutlineTable; 148 149 ScSheetEvents* pSheetEvents; 150 151 SCCOL nTableAreaX; 152 SCROW nTableAreaY; 153 sal_Bool bTableAreaValid; 154 155 // interne Verwaltung ------------------ 156 sal_Bool bVisible; 157 sal_Bool bStreamValid; 158 sal_Bool bPendingRowHeights; 159 sal_Bool bCalcNotification; 160 161 SCTAB nTab; 162 sal_uInt16 nRecalcLvl; // Rekursionslevel Size-Recalc 163 ScDocument* pDocument; 164 utl::SearchParam* pSearchParam; 165 utl::TextSearch* pSearchText; 166 167 mutable String aUpperName; // #i62977# filled only on demand, reset in SetName 168 169 ScAddress2DVecPtr mxUninitNotes; 170 171 // SortierParameter um den Stackbedarf von Quicksort zu Minimieren 172 ScSortParam aSortParam; 173 CollatorWrapper* pSortCollator; 174 sal_Bool bGlobalKeepQuery; 175 sal_Bool bSharedNameInserted; 176 177 ScRangeVec aPrintRanges; 178 sal_Bool bPrintEntireSheet; 179 180 ScRange* pRepeatColRange; 181 ScRange* pRepeatRowRange; 182 183 sal_uInt16 nLockCount; 184 185 ScRangeList* pScenarioRanges; 186 Color aScenarioColor; 187 Color aTabBgColor; 188 sal_uInt16 nScenarioFlags; 189 sal_Bool bActiveScenario; 190 bool mbPageBreaksValid; 191 192 friend class ScDocument; // fuer FillInfo 193 friend class ScDocumentIterator; 194 friend class ScValueIterator; 195 friend class ScHorizontalValueIterator; 196 friend class ScDBQueryDataIterator; 197 friend class ScCellIterator; 198 friend class ScQueryCellIterator; 199 friend class ScHorizontalCellIterator; 200 friend class ScHorizontalAttrIterator; 201 friend class ScDocAttrIterator; 202 friend class ScAttrRectIterator; 203 204 205 public: 206 ScTable( ScDocument* pDoc, SCTAB nNewTab, const String& rNewName, 207 sal_Bool bColInfo = sal_True, sal_Bool bRowInfo = sal_True ); 208 ~ScTable(); 209 GetOutlineTable()210 ScOutlineTable* GetOutlineTable() { return pOutlineTable; } 211 212 SCSIZE GetCellCount(SCCOL nCol) const; 213 sal_uLong GetCellCount() const; 214 sal_uLong GetWeightedCount() const; 215 sal_uLong GetCodeCount() const; // RPN-Code in Formeln 216 217 sal_Bool SetOutlineTable( const ScOutlineTable* pNewOutline ); 218 void StartOutlineTable(); 219 220 void DoAutoOutline( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow ); 221 222 sal_Bool TestRemoveSubTotals( const ScSubTotalParam& rParam ); 223 void RemoveSubTotals( ScSubTotalParam& rParam ); 224 sal_Bool DoSubTotals( ScSubTotalParam& rParam ); 225 GetSheetEvents() const226 const ScSheetEvents* GetSheetEvents() const { return pSheetEvents; } 227 void SetSheetEvents( const ScSheetEvents* pNew ); 228 IsVisible() const229 sal_Bool IsVisible() const { return bVisible; } 230 void SetVisible( sal_Bool bVis ); 231 IsStreamValid() const232 sal_Bool IsStreamValid() const { return bStreamValid; } 233 void SetStreamValid( sal_Bool bSet, sal_Bool bIgnoreLock = sal_False ); 234 IsPendingRowHeights() const235 sal_Bool IsPendingRowHeights() const { return bPendingRowHeights; } 236 void SetPendingRowHeights( sal_Bool bSet ); 237 GetCalcNotification() const238 sal_Bool GetCalcNotification() const { return bCalcNotification; } 239 void SetCalcNotification( sal_Bool bSet ); 240 IsLayoutRTL() const241 sal_Bool IsLayoutRTL() const { return bLayoutRTL; } IsLoadingRTL() const242 sal_Bool IsLoadingRTL() const { return bLoadingRTL; } 243 void SetLayoutRTL( sal_Bool bSet ); 244 void SetLoadingRTL( sal_Bool bSet ); 245 IsScenario() const246 sal_Bool IsScenario() const { return bScenario; } 247 void SetScenario( sal_Bool bFlag ); GetScenarioComment(String & rComment) const248 void GetScenarioComment( String& rComment) const { rComment = aComment; } SetScenarioComment(const String & rComment)249 void SetScenarioComment( const String& rComment ) { aComment = rComment; } GetScenarioColor() const250 const Color& GetScenarioColor() const { return aScenarioColor; } SetScenarioColor(const Color & rNew)251 void SetScenarioColor(const Color& rNew) { aScenarioColor = rNew; } 252 const Color& GetTabBgColor() const; 253 void SetTabBgColor(const Color& rColor); GetScenarioFlags() const254 sal_uInt16 GetScenarioFlags() const { return nScenarioFlags; } SetScenarioFlags(sal_uInt16 nNew)255 void SetScenarioFlags(sal_uInt16 nNew) { nScenarioFlags = nNew; } SetActiveScenario(sal_Bool bSet)256 void SetActiveScenario(sal_Bool bSet) { bActiveScenario = bSet; } IsActiveScenario() const257 sal_Bool IsActiveScenario() const { return bActiveScenario; } 258 GetLinkMode() const259 sal_uInt8 GetLinkMode() const { return nLinkMode; } IsLinked() const260 sal_Bool IsLinked() const { return nLinkMode != SC_LINK_NONE; } GetLinkDoc() const261 const String& GetLinkDoc() const { return aLinkDoc; } GetLinkFlt() const262 const String& GetLinkFlt() const { return aLinkFlt; } GetLinkOpt() const263 const String& GetLinkOpt() const { return aLinkOpt; } GetLinkTab() const264 const String& GetLinkTab() const { return aLinkTab; } GetLinkRefreshDelay() const265 sal_uLong GetLinkRefreshDelay() const { return nLinkRefreshDelay; } 266 267 void SetLink( sal_uInt8 nMode, const String& rDoc, const String& rFlt, 268 const String& rOpt, const String& rTab, sal_uLong nRefreshDelay ); 269 270 void GetName( String& rName ) const; 271 void SetName( const String& rNewName ); 272 GetCodeName(String & rName) const273 void GetCodeName( String& rName ) const { rName = aCodeName; } SetCodeName(const String & rNewName)274 void SetCodeName( const String& rNewName ) { aCodeName = rNewName; } 275 276 const String& GetUpperName() const; 277 GetPageStyle() const278 const String& GetPageStyle() const { return aPageStyle; } 279 void SetPageStyle( const String& rName ); 280 void PageStyleModified( const String& rNewName ); 281 282 sal_Bool IsProtected() const; 283 void SetProtection(const ScTableProtection* pProtect); 284 ScTableProtection* GetProtection(); 285 286 Size GetPageSize() const; 287 void SetPageSize( const Size& rSize ); 288 void SetRepeatArea( SCCOL nStartCol, SCCOL nEndCol, SCROW nStartRow, SCROW nEndRow ); 289 290 void RemoveAutoSpellObj(); 291 292 void LockTable(); 293 void UnlockTable(); 294 295 sal_Bool IsBlockEditable( SCCOL nCol1, SCROW nRow1, SCCOL nCol2, 296 SCROW nRow2, sal_Bool* pOnlyNotBecauseOfMatrix = NULL ) const; 297 sal_Bool IsSelectionEditable( const ScMarkData& rMark, 298 sal_Bool* pOnlyNotBecauseOfMatrix = NULL ) const; 299 300 sal_Bool HasBlockMatrixFragment( SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2 ) const; 301 sal_Bool HasSelectionMatrixFragment( const ScMarkData& rMark ) const; 302 303 sal_Bool IsBlockEmpty( SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, bool bIgnoreNotes = false ) const; 304 305 void PutCell( const ScAddress&, ScBaseCell* pCell ); 306 //UNUSED2009-05 void PutCell( const ScAddress&, sal_uLong nFormatIndex, ScBaseCell* pCell); 307 void PutCell( SCCOL nCol, SCROW nRow, ScBaseCell* pCell ); 308 void PutCell(SCCOL nCol, SCROW nRow, sal_uLong nFormatIndex, ScBaseCell* pCell); 309 // sal_True = Zahlformat gesetzt 310 sal_Bool SetString( SCCOL nCol, SCROW nRow, SCTAB nTab, const String& rString, 311 SvNumberFormatter* pFormatter = NULL, bool bDetectNumberFormat = true ); 312 void SetValue( SCCOL nCol, SCROW nRow, const double& rVal ); 313 void SetError( SCCOL nCol, SCROW nRow, sal_uInt16 nError); 314 SCSIZE GetPatternCount( SCCOL nCol ); 315 SCSIZE GetPatternCount( SCCOL nCol, SCROW nRw1, SCROW nRw2 ); 316 bool ReservedPatternCount( SCCOL nCol, SCSIZE nReserved ); 317 318 void GetString( SCCOL nCol, SCROW nRow, String& rString ); 319 void FillDPCache( ScDPTableDataCache * pCache, SCCOL nStartCol, SCCOL nEndCol, SCROW nStartRow, SCROW nEndRow ); 320 void GetInputString( SCCOL nCol, SCROW nRow, String& rString ); GetValue(const ScAddress & rPos) const321 double GetValue( const ScAddress& rPos ) const 322 { 323 return ValidColRow(rPos.Col(),rPos.Row()) ? 324 aCol[rPos.Col()].GetValue( rPos.Row() ) : 325 0.0; 326 } 327 double GetValue( SCCOL nCol, SCROW nRow ); 328 void GetFormula( SCCOL nCol, SCROW nRow, String& rFormula, 329 sal_Bool bAsciiExport = sal_False ); 330 GetCellType(const ScAddress & rPos) const331 CellType GetCellType( const ScAddress& rPos ) const 332 { 333 return ValidColRow(rPos.Col(),rPos.Row()) ? 334 aCol[rPos.Col()].GetCellType( rPos.Row() ) : 335 CELLTYPE_NONE; 336 } 337 CellType GetCellType( SCCOL nCol, SCROW nRow ) const; GetCell(const ScAddress & rPos) const338 ScBaseCell* GetCell( const ScAddress& rPos ) const 339 { 340 return ValidColRow(rPos.Col(),rPos.Row()) ? 341 aCol[rPos.Col()].GetCell( rPos.Row() ) : 342 NULL; 343 } 344 ScBaseCell* GetCell( SCCOL nCol, SCROW nRow ) const; 345 346 void GetFirstDataPos(SCCOL& rCol, SCROW& rRow) const; 347 void GetLastDataPos(SCCOL& rCol, SCROW& rRow) const; 348 349 /** Returns the pointer to a cell note object at the passed cell address. */ 350 ScPostIt* GetNote( SCCOL nCol, SCROW nRow ); 351 /** Sets the passed cell note object at the passed cell address. Takes ownership! */ 352 void TakeNote( SCCOL nCol, SCROW nRow, ScPostIt*& rpNote ); 353 /** Returns and forgets the cell note object at the passed cell address. */ 354 ScPostIt* ReleaseNote( SCCOL nCol, SCROW nRow ); 355 /** Deletes the note at the passed cell address. */ 356 void DeleteNote( SCCOL nCol, SCROW nRow ); 357 /** Creates the captions of all uninitialized cell notes. 358 @param bForced True = always create all captions, false = skip when Undo is disabled. */ 359 void InitializeNoteCaptions( bool bForced = false ); 360 361 sal_Bool TestInsertRow( SCCOL nStartCol, SCCOL nEndCol, SCSIZE nSize ); 362 void InsertRow( SCCOL nStartCol, SCCOL nEndCol, SCROW nStartRow, SCSIZE nSize ); 363 void DeleteRow( SCCOL nStartCol, SCCOL nEndCol, SCROW nStartRow, SCSIZE nSize, 364 sal_Bool* pUndoOutline = NULL ); 365 366 sal_Bool TestInsertCol( SCROW nStartRow, SCROW nEndRow, SCSIZE nSize ); 367 void InsertCol( SCCOL nStartCol, SCROW nStartRow, SCROW nEndRow, SCSIZE nSize ); 368 void DeleteCol( SCCOL nStartCol, SCROW nStartRow, SCROW nEndRow, SCSIZE nSize, 369 sal_Bool* pUndoOutline = NULL ); 370 371 void DeleteArea(SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, sal_uInt16 nDelFlag); 372 void CopyToClip(SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, ScTable* pTable, 373 sal_Bool bKeepScenarioFlags, sal_Bool bCloneNoteCaptions); 374 void CopyToClip(const ScRangeList& rRanges, ScTable* pTable, 375 bool bKeepScenarioFlags, bool bCloneNoteCaptions); 376 void CopyFromClip(SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, SCsCOL nDx, SCsROW nDy, 377 sal_uInt16 nInsFlag, sal_Bool bAsLink, sal_Bool bSkipAttrForEmpty, ScTable* pTable); 378 void StartListeningInArea( SCCOL nCol1, SCROW nRow1, 379 SCCOL nCol2, SCROW nRow2 ); 380 void BroadcastInArea( SCCOL nCol1, SCROW nRow1, 381 SCCOL nCol2, SCROW nRow2 ); 382 383 void CopyToTable(SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, 384 sal_uInt16 nFlags, sal_Bool bMarked, ScTable* pDestTab, 385 const ScMarkData* pMarkData = NULL, 386 sal_Bool bAsLink = sal_False, sal_Bool bColRowFlags = sal_True); 387 void UndoToTable(SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, 388 sal_uInt16 nFlags, sal_Bool bMarked, ScTable* pDestTab, 389 const ScMarkData* pMarkData = NULL); 390 391 void TransposeClip( SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, 392 ScTable* pTransClip, sal_uInt16 nFlags, sal_Bool bAsLink ); 393 394 // Markierung von diesem Dokument 395 void MixMarked( const ScMarkData& rMark, sal_uInt16 nFunction, 396 sal_Bool bSkipEmpty, ScTable* pSrcTab ); 397 void MixData( SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, 398 sal_uInt16 nFunction, sal_Bool bSkipEmpty, ScTable* pSrcTab ); 399 400 void CopyData( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, 401 SCCOL nDestCol, SCROW nDestRow, SCTAB nDestTab ); 402 403 void CopyScenarioFrom( const ScTable* pSrcTab ); 404 void CopyScenarioTo( ScTable* pDestTab ) const; 405 sal_Bool TestCopyScenarioTo( const ScTable* pDestTab ) const; 406 void MarkScenarioIn( ScMarkData& rMark, sal_uInt16 nNeededBits ) const; 407 sal_Bool HasScenarioRange( const ScRange& rRange ) const; 408 void InvalidateScenarioRanges(); 409 const ScRangeList* GetScenarioRanges() const; 410 411 void CopyUpdated( const ScTable* pPosTab, ScTable* pDestTab ) const; 412 413 void InvalidateTableArea(); 414 void InvalidatePageBreaks(); 415 416 sal_Bool GetCellArea( SCCOL& rEndCol, SCROW& rEndRow ) const; // sal_False = leer 417 sal_Bool GetTableArea( SCCOL& rEndCol, SCROW& rEndRow ) const; 418 sal_Bool GetPrintArea( SCCOL& rEndCol, SCROW& rEndRow, sal_Bool bNotes ) const; 419 sal_Bool GetPrintAreaHor( SCROW nStartRow, SCROW nEndRow, 420 SCCOL& rEndCol, sal_Bool bNotes ) const; 421 sal_Bool GetPrintAreaVer( SCCOL nStartCol, SCCOL nEndCol, 422 SCROW& rEndRow, sal_Bool bNotes ) const; 423 424 /* 425 Get the last cell's position, which has visual attribute or data and has max row number among all columns. 426 */ 427 void GetLastAttrCell( SCCOL& rEndCol, SCROW& rEndRow ) const; 428 sal_Bool GetDataStart( SCCOL& rStartCol, SCROW& rStartRow ) const; 429 430 void ExtendPrintArea( OutputDevice* pDev, 431 SCCOL nStartCol, SCROW nStartRow, SCCOL& rEndCol, SCROW nEndRow ); 432 433 void GetDataArea( SCCOL& rStartCol, SCROW& rStartRow, SCCOL& rEndCol, SCROW& rEndRow, 434 sal_Bool bIncludeOld, bool bOnlyDown ) const; 435 436 bool ShrinkToUsedDataArea( bool& o_bShrunk, SCCOL& rStartCol, SCROW& rStartRow, 437 SCCOL& rEndCol, SCROW& rEndRow, bool bColumnsOnly ) const; 438 439 SCSIZE GetEmptyLinesInBlock( SCCOL nStartCol, SCROW nStartRow, 440 SCCOL nEndCol, SCROW nEndRow, ScDirection eDir ); 441 442 void FindAreaPos( SCCOL& rCol, SCROW& rRow, SCsCOL nMovX, SCsROW nMovY ); 443 void GetNextPos( SCCOL& rCol, SCROW& rRow, SCsCOL nMovX, SCsROW nMovY, 444 sal_Bool bMarked, sal_Bool bUnprotected, const ScMarkData& rMark ); 445 446 void LimitChartArea( SCCOL& rStartCol, SCROW& rStartRow, SCCOL& rEndCol, SCROW& rEndRow ); 447 448 sal_Bool HasData( SCCOL nCol, SCROW nRow ); 449 sal_Bool HasStringData( SCCOL nCol, SCROW nRow ); 450 sal_Bool HasValueData( SCCOL nCol, SCROW nRow ); 451 //UNUSED2008-05 sal_uInt16 GetErrorData(SCCOL nCol, SCROW nRow) const; 452 sal_Bool HasStringCells( SCCOL nStartCol, SCROW nStartRow, 453 SCCOL nEndCol, SCROW nEndRow ) const; 454 GetErrCode(const ScAddress & rPos) const455 sal_uInt16 GetErrCode( const ScAddress& rPos ) const 456 { 457 return ValidColRow(rPos.Col(),rPos.Row()) ? 458 aCol[rPos.Col()].GetErrCode( rPos.Row() ) : 459 0; 460 } 461 //UNUSED2008-05 sal_uInt16 GetErrCode( SCCOL nCol, SCROW nRow ) const; 462 463 void ResetChanged( const ScRange& rRange ); 464 465 void SetDirty(); 466 void SetDirty( const ScRange& ); 467 void SetDirtyAfterLoad(); 468 void SetDirtyVar(); 469 void SetTableOpDirty( const ScRange& ); 470 void CalcAll(); 471 void CalcAfterLoad(); 472 void CompileAll(); 473 void CompileXML( ScProgress& rProgress ); 474 475 void UpdateReference( UpdateRefMode eUpdateRefMode, SCCOL nCol1, SCROW nRow1, SCTAB nTab1, 476 SCCOL nCol2, SCROW nRow2, SCTAB nTab2, 477 SCsCOL nDx, SCsROW nDy, SCsTAB nDz, 478 ScDocument* pUndoDoc = NULL, sal_Bool bIncludeDraw = sal_True, bool bUpdateNoteCaptionPos = true ); 479 480 void UpdateDrawRef( UpdateRefMode eUpdateRefMode, SCCOL nCol1, SCROW nRow1, SCTAB nTab1, 481 SCCOL nCol2, SCROW nRow2, SCTAB nTab2, 482 SCsCOL nDx, SCsROW nDy, SCsTAB nDz, bool bUpdateNoteCaptionPos = true ); 483 484 void UpdateTranspose( const ScRange& rSource, const ScAddress& rDest, 485 ScDocument* pUndoDoc ); 486 487 void UpdateGrow( const ScRange& rArea, SCCOL nGrowX, SCROW nGrowY ); 488 489 void UpdateInsertTab(SCTAB nTable); 490 //UNUSED2008-05 void UpdateInsertTabOnlyCells(SCTAB nTable); 491 void UpdateDeleteTab( SCTAB nTable, sal_Bool bIsMove, ScTable* pRefUndo = NULL ); 492 void UpdateMoveTab(SCTAB nOldPos, SCTAB nNewPos, SCTAB nTabNo, ScProgress& ); 493 void UpdateCompile( sal_Bool bForceIfNameInUse = sal_False ); 494 void SetTabNo(SCTAB nNewTab); 495 sal_Bool IsRangeNameInUse(SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, 496 sal_uInt16 nIndex) const; 497 void FindRangeNamesInUse(SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, 498 std::set<sal_uInt16>& rIndexes) const; 499 void ReplaceRangeNamesInUse(SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, 500 const ScRangeData::IndexMap& rMap ); 501 void Fill( SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, 502 sal_uLong nFillCount, FillDir eFillDir, FillCmd eFillCmd, FillDateCmd eFillDateCmd, 503 double nStepValue, double nMaxValue); 504 String GetAutoFillPreview( const ScRange& rSource, SCCOL nEndX, SCROW nEndY ); 505 506 void UpdateSelectionFunction( ScFunctionData& rData, 507 SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, 508 const ScMarkData& rMark ); 509 510 void AutoFormat( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, 511 sal_uInt16 nFormatNo ); 512 void GetAutoFormatData(SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, ScAutoFormatData& rData); 513 void ScReplaceTabsStr( String& rStr, const String& rSrch, const String& rRepl ); // aus sw 514 sal_Bool SearchAndReplace(const SvxSearchItem& rSearchItem, 515 SCCOL& rCol, SCROW& rRow, ScMarkData& rMark, 516 String& rUndoStr, ScDocument* pUndoDoc); 517 518 void FindMaxRotCol( RowInfo* pRowInfo, SCSIZE nArrCount, SCCOL nX1, SCCOL nX2 ); 519 520 void GetBorderLines( SCCOL nCol, SCROW nRow, 521 const SvxBorderLine** ppLeft, const SvxBorderLine** ppTop, 522 const SvxBorderLine** ppRight, const SvxBorderLine** ppBottom ) const; 523 524 //UNUSED2009-05 sal_Bool HasLines( const ScRange& rRange, Rectangle& rSizes ) const; 525 bool HasAttrib( SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, sal_uInt16 nMask ) const; 526 sal_Bool HasAttribSelection( const ScMarkData& rMark, sal_uInt16 nMask ) const; 527 sal_Bool ExtendMerge( SCCOL nStartCol, SCROW nStartRow, 528 SCCOL& rEndCol, SCROW& rEndRow, 529 sal_Bool bRefresh, sal_Bool bAttrs ); 530 const SfxPoolItem* GetAttr( SCCOL nCol, SCROW nRow, sal_uInt16 nWhich ) const; 531 const ScPatternAttr* GetPattern( SCCOL nCol, SCROW nRow ) const; 532 const ScPatternAttr* GetMostUsedPattern( SCCOL nCol, SCROW nStartRow, SCROW nEndRow ) const; 533 GetNumberFormat(const ScAddress & rPos) const534 sal_uLong GetNumberFormat( const ScAddress& rPos ) const 535 { 536 return ValidColRow(rPos.Col(),rPos.Row()) ? 537 aCol[rPos.Col()].GetNumberFormat( rPos.Row() ) : 538 0; 539 } 540 sal_uLong GetNumberFormat( SCCOL nCol, SCROW nRow ) const; 541 void MergeSelectionPattern( ScMergePatternState& rState, 542 const ScMarkData& rMark, sal_Bool bDeep ) const; 543 void MergePatternArea( ScMergePatternState& rState, SCCOL nCol1, SCROW nRow1, 544 SCCOL nCol2, SCROW nRow2, sal_Bool bDeep ) const; 545 void MergeBlockFrame( SvxBoxItem* pLineOuter, SvxBoxInfoItem* pLineInner, 546 ScLineFlags& rFlags, 547 SCCOL nStartCol, SCROW nStartRow, 548 SCCOL nEndCol, SCROW nEndRow ) const; 549 void ApplyBlockFrame( const SvxBoxItem* pLineOuter, 550 const SvxBoxInfoItem* pLineInner, 551 SCCOL nStartCol, SCROW nStartRow, 552 SCCOL nEndCol, SCROW nEndRow ); 553 554 void ApplyAttr( SCCOL nCol, SCROW nRow, const SfxPoolItem& rAttr ); 555 void ApplyPattern( SCCOL nCol, SCROW nRow, const ScPatternAttr& rAttr ); 556 void ApplyPatternArea( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, const ScPatternAttr& rAttr ); 557 void ApplyPooledPatternArea( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, const ScPatternAttr& rPooledAttr, const ScPatternAttr& rAttr ); 558 SetPattern(const ScAddress & rPos,const ScPatternAttr & rAttr,sal_Bool bPutToPool=sal_False)559 void SetPattern( const ScAddress& rPos, const ScPatternAttr& rAttr, sal_Bool bPutToPool = sal_False ) 560 { 561 if (ValidColRow(rPos.Col(),rPos.Row())) 562 aCol[rPos.Col()].SetPattern( rPos.Row(), rAttr, bPutToPool ); 563 } 564 void SetPattern( SCCOL nCol, SCROW nRow, const ScPatternAttr& rAttr, sal_Bool bPutToPool = sal_False ); 565 void ApplyPatternIfNumberformatIncompatible( const ScRange& rRange, 566 const ScPatternAttr& rPattern, short nNewType ); 567 568 void ApplyStyle( SCCOL nCol, SCROW nRow, const ScStyleSheet& rStyle ); 569 void ApplyStyleArea( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, const ScStyleSheet& rStyle ); 570 void ApplySelectionStyle(const ScStyleSheet& rStyle, const ScMarkData& rMark); 571 void ApplySelectionLineStyle( const ScMarkData& rMark, 572 const SvxBorderLine* pLine, sal_Bool bColorOnly ); 573 574 const ScStyleSheet* GetStyle( SCCOL nCol, SCROW nRow ) const; 575 const ScStyleSheet* GetSelectionStyle( const ScMarkData& rMark, sal_Bool& rFound ) const; 576 const ScStyleSheet* GetAreaStyle( sal_Bool& rFound, SCCOL nCol1, SCROW nRow1, 577 SCCOL nCol2, SCROW nRow2 ) const; 578 579 void StyleSheetChanged( const SfxStyleSheetBase* pStyleSheet, sal_Bool bRemoved, 580 OutputDevice* pDev, 581 double nPPTX, double nPPTY, 582 const Fraction& rZoomX, const Fraction& rZoomY ); 583 584 sal_Bool IsStyleSheetUsed( const ScStyleSheet& rStyle, sal_Bool bGatherAllStyles ) const; 585 586 sal_Bool ApplyFlags( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, sal_Int16 nFlags ); 587 sal_Bool RemoveFlags( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, sal_Int16 nFlags ); 588 589 void ApplySelectionCache( SfxItemPoolCache* pCache, const ScMarkData& rMark ); 590 void DeleteSelection( sal_uInt16 nDelFlag, const ScMarkData& rMark ); 591 592 void ClearSelectionItems( const sal_uInt16* pWhich, const ScMarkData& rMark ); 593 void ChangeSelectionIndent( sal_Bool bIncrement, const ScMarkData& rMark ); 594 GetRepeatColRange() const595 const ScRange* GetRepeatColRange() const { return pRepeatColRange; } GetRepeatRowRange() const596 const ScRange* GetRepeatRowRange() const { return pRepeatRowRange; } 597 void SetRepeatColRange( const ScRange* pNew ); 598 void SetRepeatRowRange( const ScRange* pNew ); 599 GetPrintRangeCount() const600 sal_uInt16 GetPrintRangeCount() const { return static_cast< sal_uInt16 >( aPrintRanges.size() ); } 601 const ScRange* GetPrintRange(sal_uInt16 nPos) const; 602 /** Returns true, if the sheet is always printed. */ IsPrintEntireSheet() const603 sal_Bool IsPrintEntireSheet() const { return bPrintEntireSheet; } 604 605 /** Removes all print ranges. */ 606 void ClearPrintRanges(); 607 /** Adds a new print ranges. */ 608 void AddPrintRange( const ScRange& rNew ); 609 //UNUSED2009-05 /** Removes all old print ranges and sets the passed print ranges. */ 610 //UNUSED2009-05 void SetPrintRange( const ScRange& rNew ); 611 /** Marks the specified sheet to be printed completely. Deletes old print ranges! */ 612 void SetPrintEntireSheet(); 613 614 void FillPrintSaver( ScPrintSaverTab& rSaveTab ) const; 615 void RestorePrintRanges( const ScPrintSaverTab& rSaveTab ); 616 617 sal_uInt16 GetOptimalColWidth( SCCOL nCol, OutputDevice* pDev, 618 double nPPTX, double nPPTY, 619 const Fraction& rZoomX, const Fraction& rZoomY, 620 sal_Bool bFormula, const ScMarkData* pMarkData, 621 sal_Bool bSimpleTextImport ); 622 sal_Bool SetOptimalHeight( SCROW nStartRow, SCROW nEndRow, sal_uInt16 nExtra, 623 OutputDevice* pDev, 624 double nPPTX, double nPPTY, 625 const Fraction& rZoomX, const Fraction& rZoomY, 626 sal_Bool bForce, 627 ScProgress* pOuterProgress = NULL, sal_uLong nProgressStart = 0 ); 628 long GetNeededSize( SCCOL nCol, SCROW nRow, 629 OutputDevice* pDev, 630 double nPPTX, double nPPTY, 631 const Fraction& rZoomX, const Fraction& rZoomY, 632 sal_Bool bWidth, sal_Bool bTotalSize ); 633 void SetColWidth( SCCOL nCol, sal_uInt16 nNewWidth ); 634 void SetColWidthOnly( SCCOL nCol, sal_uInt16 nNewWidth ); 635 void SetRowHeight( SCROW nRow, sal_uInt16 nNewHeight ); 636 sal_Bool SetRowHeightRange( SCROW nStartRow, SCROW nEndRow, sal_uInt16 nNewHeight, 637 double nPPTX, double nPPTY ); 638 639 /** 640 * Set specified row height to specified ranges. Don't check for drawing 641 * objects etc. Just set the row height. Nothing else. 642 * 643 * Note that setting a new row height via this function will not 644 * invalidate page breaks. 645 */ 646 void SetRowHeightOnly( SCROW nStartRow, SCROW nEndRow, sal_uInt16 nNewHeight ); 647 648 // nPPT fuer Test auf Veraenderung 649 void SetManualHeight( SCROW nStartRow, SCROW nEndRow, sal_Bool bManual ); 650 651 sal_uInt16 GetColWidth( SCCOL nCol ) const; 652 SC_DLLPUBLIC sal_uInt16 GetRowHeight( SCROW nRow, SCROW* pStartRow = NULL, SCROW* pEndRow = NULL, bool bHiddenAsZero = true ) const; 653 sal_uLong GetRowHeight( SCROW nStartRow, SCROW nEndRow ) const; 654 sal_uLong GetScaledRowHeight( SCROW nStartRow, SCROW nEndRow, double fScale ) const; 655 sal_uLong GetColOffset( SCCOL nCol ) const; 656 sal_uLong GetRowOffset( SCROW nRow ) const; 657 658 /** 659 * Get the last row such that the height of row 0 to the end row is as 660 * high as possible without exceeding the specified height value. 661 * 662 * @param nHeight maximum desired height 663 * 664 * @return SCROW last row of the range within specified height. 665 */ 666 SCROW GetRowForHeight(sal_uLong nHeight) const; 667 668 sal_uInt16 GetOriginalWidth( SCCOL nCol ) const; 669 sal_uInt16 GetOriginalHeight( SCROW nRow ) const; 670 671 sal_uInt16 GetCommonWidth( SCCOL nEndCol ); 672 673 SCROW GetHiddenRowCount( SCROW nRow ); 674 675 void ShowCol(SCCOL nCol, bool bShow); 676 void ShowRow(SCROW nRow, bool bShow); 677 void DBShowRow(SCROW nRow, bool bShow); 678 679 void ShowRows(SCROW nRow1, SCROW nRow2, bool bShow); 680 void DBShowRows(SCROW nRow1, SCROW nRow2, bool bShow, bool bSetFlags); // if bSetFlags=false, no SetRowHidden/SetRowFiltered 681 682 void SetColFlags( SCCOL nCol, sal_uInt8 nNewFlags ); 683 void SetRowFlags( SCROW nRow, sal_uInt8 nNewFlags ); 684 void SetRowFlags( SCROW nStartRow, SCROW nEndRow, sal_uInt8 nNewFlags ); 685 686 /// @return the index of the last row with any set flags (auto-pagebreak is ignored). 687 SCROW GetLastFlaggedRow() const; 688 689 /// @return the index of the last changed column (flags and column width, auto pagebreak is ignored). 690 SCCOL GetLastChangedCol() const; 691 /// @return the index of the last changed row (flags and row height, auto pagebreak is ignored). 692 SCROW GetLastChangedRow() const; 693 694 sal_Bool IsDataFiltered() const; 695 sal_uInt8 GetColFlags( SCCOL nCol ) const; 696 sal_uInt8 GetRowFlags( SCROW nRow ) const; 697 GetRowFlagsArray() const698 const ScBitMaskCompressedArray< SCROW, sal_uInt8> * GetRowFlagsArray() const 699 { return pRowFlags; } 700 701 sal_Bool UpdateOutlineCol( SCCOL nStartCol, SCCOL nEndCol, sal_Bool bShow ); 702 sal_Bool UpdateOutlineRow( SCROW nStartRow, SCROW nEndRow, sal_Bool bShow ); 703 704 void UpdatePageBreaks( const ScRange* pUserArea ); 705 void RemoveManualBreaks(); 706 sal_Bool HasManualBreaks() const; 707 void SetRowManualBreaks( const ::std::set<SCROW>& rBreaks ); 708 void SetColManualBreaks( const ::std::set<SCCOL>& rBreaks ); 709 710 void GetAllRowBreaks(::std::set<SCROW>& rBreaks, bool bPage, bool bManual) const; 711 void GetAllColBreaks(::std::set<SCCOL>& rBreaks, bool bPage, bool bManual) const; 712 bool HasRowPageBreak(SCROW nRow) const; 713 bool HasColPageBreak(SCCOL nCol) const; 714 bool HasRowManualBreak(SCROW nRow) const; 715 bool HasColManualBreak(SCCOL nCol) const; 716 717 /** 718 * Get the row position of the next manual break that occurs at or below 719 * specified row. When no more manual breaks are present at or below 720 * the specified row, -1 is returned. 721 * 722 * @param nRow row at which the search begins. 723 * 724 * @return SCROW next row position with manual page break, or -1 if no 725 * more manual breaks are present. 726 */ 727 SCROW GetNextManualBreak(SCROW nRow) const; 728 729 void RemoveRowPageBreaks(SCROW nStartRow, SCROW nEndRow); 730 void RemoveRowBreak(SCROW nRow, bool bPage, bool bManual); 731 void RemoveColBreak(SCCOL nCol, bool bPage, bool bManual); 732 void SetRowBreak(SCROW nRow, bool bPage, bool bManual); 733 void SetColBreak(SCCOL nCol, bool bPage, bool bManual); 734 ::com::sun::star::uno::Sequence< 735 ::com::sun::star::sheet::TablePageBreakData> GetRowBreakData() const; 736 737 bool RowHidden(SCROW nRow, SCROW* pFirstRow = NULL, SCROW* pLastRow = NULL) const; 738 bool RowHidden(SCROW nRow, SCROW& rLastRow) const; 739 bool HasHiddenRows(SCROW nStartRow, SCROW nEndRow) const; 740 bool ColHidden(SCCOL nCol, SCCOL& rLastCol) const; 741 bool ColHidden(SCCOL nCol, SCCOL* pFirstCol = NULL, SCCOL* pLastCol = NULL) const; 742 void SetRowHidden(SCROW nStartRow, SCROW nEndRow, bool bHidden); 743 void SetColHidden(SCCOL nStartCol, SCCOL nEndCol, bool bHidden); 744 void CopyColHidden(ScTable& rTable, SCCOL nStartCol, SCCOL nEndCol); 745 void CopyRowHidden(ScTable& rTable, SCROW nStartRow, SCROW nEndRow); 746 void CopyRowHeight(ScTable& rSrcTable, SCROW nStartRow, SCROW nEndRow, SCROW nSrcOffset); 747 SCROW FirstVisibleRow(SCROW nStartRow, SCROW nEndRow) const; 748 SCROW LastVisibleRow(SCROW nStartRow, SCROW nEndRow) const; 749 SCROW CountVisibleRows(SCROW nStartRow, SCROW nEndRow) const; 750 sal_uInt32 GetTotalRowHeight(SCROW nStartRow, SCROW nEndRow) const; 751 752 SCCOLROW LastHiddenColRow(SCCOLROW nPos, bool bCol) const; 753 754 bool RowFiltered(SCROW nRow, SCROW* pFirstRow = NULL, SCROW* pLastRow = NULL) const; 755 bool ColFiltered(SCCOL nCol, SCCOL* pFirstCol = NULL, SCCOL* pLastCol = NULL) const; 756 bool HasFilteredRows(SCROW nStartRow, SCROW nEndRow) const; 757 void CopyColFiltered(ScTable& rTable, SCCOL nStartCol, SCCOL nEndCol); 758 void CopyRowFiltered(ScTable& rTable, SCROW nStartRow, SCROW nEndRow); 759 void SetRowFiltered(SCROW nStartRow, SCROW nEndRow, bool bFiltered); 760 void SetColFiltered(SCCOL nStartCol, SCCOL nEndCol, bool bFiltered); 761 SCROW FirstNonFilteredRow(SCROW nStartRow, SCROW nEndRow) const; 762 SCROW LastNonFilteredRow(SCROW nStartRow, SCROW nEndRow) const; 763 SCROW CountNonFilteredRows(SCROW nStartRow, SCROW nEndRow) const; 764 765 void SyncColRowFlags(); 766 767 void StripHidden( SCCOL& rX1, SCROW& rY1, SCCOL& rX2, SCROW& rY2 ); 768 void ExtendHidden( SCCOL& rX1, SCROW& rY1, SCCOL& rX2, SCROW& rY2 ); 769 770 void Sort(const ScSortParam& rSortParam, sal_Bool bKeepQuery); 771 sal_Bool ValidQuery(SCROW nRow, const ScQueryParam& rQueryParam, 772 sal_Bool* pSpecial = NULL, ScBaseCell* pCell = NULL, 773 sal_Bool* pbTestEqualCondition = NULL ); 774 void TopTenQuery( ScQueryParam& ); 775 SCSIZE Query(ScQueryParam& rQueryParam, sal_Bool bKeepSub); 776 sal_Bool CreateQueryParam(SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, ScQueryParam& rQueryParam); 777 778 void GetFilterEntries(SCCOL nCol, SCROW nRow1, SCROW nRow2, TypedScStrCollection& rStrings, bool& rHasDates); 779 void GetFilteredFilterEntries( SCCOL nCol, SCROW nRow1, SCROW nRow2, const ScQueryParam& rParam, TypedScStrCollection& rStrings, bool& rHasDates ); 780 sal_Bool GetDataEntries(SCCOL nCol, SCROW nRow, TypedScStrCollection& rStrings, sal_Bool bLimit); 781 782 sal_Bool HasColHeader( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow ); 783 sal_Bool HasRowHeader( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow ); 784 785 void DoColResize( SCCOL nCol1, SCCOL nCol2, SCSIZE nAdd ); 786 787 788 sal_Int32 GetMaxStringLen( SCCOL nCol, 789 SCROW nRowStart, SCROW nRowEnd, CharSet eCharSet ) const; 790 xub_StrLen GetMaxNumberStringLen( sal_uInt16& nPrecision, 791 SCCOL nCol, 792 SCROW nRowStart, SCROW nRowEnd ) const; 793 794 void FindConditionalFormat( sal_uLong nKey, ScRangeList& rRanges ); 795 IncRecalcLevel()796 void IncRecalcLevel() { ++nRecalcLvl; } DecRecalcLevel(bool bUpdateNoteCaptionPos=true)797 void DecRecalcLevel( bool bUpdateNoteCaptionPos = true ) { if (!--nRecalcLvl) SetDrawPageSize(true, bUpdateNoteCaptionPos); } 798 799 sal_Bool IsSortCollatorGlobal() const; 800 void InitSortCollator( const ScSortParam& rPar ); 801 void DestroySortCollator(); 802 803 private: 804 void FillSeries( SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, 805 sal_uLong nFillCount, FillDir eFillDir, FillCmd eFillCmd, 806 FillDateCmd eFillDateCmd, 807 double nStepValue, double nMaxValue, sal_uInt16 nMinDigits, 808 sal_Bool bAttribs, ScProgress& rProgress ); 809 void FillAnalyse( SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, 810 FillCmd& rCmd, FillDateCmd& rDateCmd, 811 double& rInc, sal_uInt16& rMinDigits, 812 ScUserListData*& rListData, sal_uInt16& rListIndex); 813 void FillAuto( SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, 814 sal_uLong nFillCount, FillDir eFillDir, ScProgress& rProgress ); 815 816 sal_Bool ValidNextPos( SCCOL nCol, SCROW nRow, const ScMarkData& rMark, 817 sal_Bool bMarked, sal_Bool bUnprotected ); 818 819 void AutoFormatArea(SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, 820 const ScPatternAttr& rAttr, sal_uInt16 nFormatNo); 821 void GetAutoFormatAttr(SCCOL nCol, SCROW nRow, sal_uInt16 nIndex, ScAutoFormatData& rData); 822 void GetAutoFormatFrame(SCCOL nCol, SCROW nRow, sal_uInt16 nFlags, sal_uInt16 nIndex, ScAutoFormatData& rData); 823 sal_Bool SearchCell(const SvxSearchItem& rSearchItem, SCCOL nCol, SCROW nRow, 824 const ScMarkData& rMark, String& rUndoStr, ScDocument* pUndoDoc); 825 sal_Bool Search(const SvxSearchItem& rSearchItem, SCCOL& rCol, SCROW& rRow, 826 const ScMarkData& rMark, String& rUndoStr, ScDocument* pUndoDoc); 827 sal_Bool SearchAll(const SvxSearchItem& rSearchItem, ScMarkData& rMark, 828 String& rUndoStr, ScDocument* pUndoDoc); 829 sal_Bool Replace(const SvxSearchItem& rSearchItem, SCCOL& rCol, SCROW& rRow, 830 const ScMarkData& rMark, String& rUndoStr, ScDocument* pUndoDoc); 831 sal_Bool ReplaceAll(const SvxSearchItem& rSearchItem, ScMarkData& rMark, 832 String& rUndoStr, ScDocument* pUndoDoc); 833 834 sal_Bool SearchStyle(const SvxSearchItem& rSearchItem, SCCOL& rCol, SCROW& rRow, 835 ScMarkData& rMark); 836 sal_Bool ReplaceStyle(const SvxSearchItem& rSearchItem, SCCOL& rCol, SCROW& rRow, 837 ScMarkData& rMark, sal_Bool bIsUndo); 838 sal_Bool SearchAllStyle(const SvxSearchItem& rSearchItem, ScMarkData& rMark); 839 sal_Bool ReplaceAllStyle(const SvxSearchItem& rSearchItem, ScMarkData& rMark, 840 ScDocument* pUndoDoc); 841 842 // benutzen globalen SortParam: 843 sal_Bool IsSorted(SCCOLROW nStart, SCCOLROW nEnd); 844 void DecoladeRow( ScSortInfoArray*, SCROW nRow1, SCROW nRow2 ); 845 void SwapCol(SCCOL nCol1, SCCOL nCol2); 846 void SwapRow(SCROW nRow1, SCROW nRow2); 847 short CompareCell( sal_uInt16 nSort, 848 ScBaseCell* pCell1, SCCOL nCell1Col, SCROW nCell1Row, 849 ScBaseCell* pCell2, SCCOL nCell2Col, SCROW nCell2Row ); 850 short Compare(SCCOLROW nIndex1, SCCOLROW nIndex2); 851 short Compare( ScSortInfoArray*, SCCOLROW nIndex1, SCCOLROW nIndex2); 852 ScSortInfoArray* CreateSortInfoArray( SCCOLROW nInd1, SCCOLROW nInd2 ); 853 void QuickSort( ScSortInfoArray*, SCsCOLROW nLo, SCsCOLROW nHi); 854 void SortReorder( ScSortInfoArray*, ScProgress& ); 855 856 sal_Bool CreateExcelQuery(SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, ScQueryParam& rQueryParam); 857 sal_Bool CreateStarQuery(SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, ScQueryParam& rQueryParam); 858 void GetUpperCellString(SCCOL nCol, SCROW nRow, String& rStr); 859 860 sal_Bool RefVisible(ScFormulaCell* pCell); 861 862 sal_Bool IsEmptyLine(SCROW nRow, SCCOL nStartCol, SCCOL nEndCol); 863 864 void IncDate(double& rVal, sal_uInt16& nDayOfMonth, double nStep, FillDateCmd eCmd); 865 void FillFormula(sal_uLong& nFormulaCounter, sal_Bool bFirst, ScFormulaCell* pSrcCell, 866 SCCOL nDestCol, SCROW nDestRow, sal_Bool bLast ); 867 void UpdateInsertTabAbs(SCTAB nNewPos); 868 sal_Bool GetNextSpellingCell(SCCOL& rCol, SCROW& rRow, sal_Bool bInSel, 869 const ScMarkData& rMark) const; 870 sal_Bool GetNextMarkedCell( SCCOL& rCol, SCROW& rRow, const ScMarkData& rMark ); 871 void SetDrawPageSize( bool bResetStreamValid = true, bool bUpdateNoteCaptionPos = true ); 872 sal_Bool TestTabRefAbs(SCTAB nTable); 873 void CompileDBFormula(); 874 void CompileDBFormula( sal_Bool bCreateFormulaString ); 875 void CompileNameFormula( sal_Bool bCreateFormulaString ); 876 void CompileColRowNameFormula(); 877 878 void StartListening( const ScAddress& rAddress, SvtListener* pListener ); 879 void EndListening( const ScAddress& rAddress, SvtListener* pListener ); 880 void StartAllListeners(); 881 void StartNeededListeners(); // only for cells where NeedsListening()==TRUE 882 void SetRelNameDirty(); 883 884 void SetLoadingMedium(bool bLoading); 885 886 SCSIZE FillMaxRot( RowInfo* pRowInfo, SCSIZE nArrCount, SCCOL nX1, SCCOL nX2, 887 SCCOL nCol, SCROW nAttrRow1, SCROW nAttrRow2, SCSIZE nArrY, 888 const ScPatternAttr* pPattern, const SfxItemSet* pCondSet ); 889 890 // idle calculation of OutputDevice text width for cell 891 // also invalidates script type, broadcasts for "calc as shown" 892 void InvalidateTextWidth( const ScAddress* pAdrFrom, const ScAddress* pAdrTo, 893 sal_Bool bNumFormatChanged, sal_Bool bBroadcast ); 894 895 /** 896 * In case the cell text goes beyond the column width, move the max column 897 * position to the right. This is called from ExtendPrintArea. 898 */ 899 void MaybeAddExtraColumn(SCCOL& rCol, SCROW nRow, OutputDevice* pDev, double nPPTX, double nPPTY); 900 901 /** 902 * Use this to iterate through non-empty visible cells in a single column. 903 */ 904 class VisibleDataCellIterator 905 { 906 public: 907 static SCROW ROW_NOT_FOUND; 908 909 explicit VisibleDataCellIterator(ScFlatBoolRowSegments& rRowSegs, ScColumn& rColumn); 910 ~VisibleDataCellIterator(); 911 912 /** 913 * Set the start row position. In case there is not visible data cell 914 * at the specified row position, it will move to the position of the 915 * first visible data cell below that point. 916 * 917 * @return First visible data cell if found, or NULL otherwise. 918 */ 919 ScBaseCell* reset(SCROW nRow); 920 921 /** 922 * Find the next visible data cell position. 923 * 924 * @return Next visible data cell if found, or NULL otherwise. 925 */ 926 ScBaseCell* next(); 927 928 /** 929 * Get the current row position. 930 * 931 * @return Current row position, or ROW_NOT_FOUND if the iterator 932 * doesn't point to a valid data cell position. 933 */ 934 SCROW getRow() const; 935 936 private: 937 ScFlatBoolRowSegments& mrRowSegs; 938 ScColumn& mrColumn; 939 ScBaseCell* mpCell; 940 SCROW mnCurRow; 941 SCROW mnUBound; 942 }; 943 944 public : 945 ScColumn* GetColumnByIndex(sal_Int32 index); 946 }; 947 948 949 #endif 950 951 952