| /************************************************************** |
| * |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| *************************************************************/ |
| |
| |
| |
| #ifndef SC_COLUMN_HXX |
| #define SC_COLUMN_HXX |
| |
| #include "markarr.hxx" |
| #include "global.hxx" |
| #include "address.hxx" |
| #include "rangenam.hxx" |
| #include <tools/solar.h> |
| |
| #include <set> |
| |
| class Fraction; |
| class OutputDevice; |
| class Rectangle; |
| class SfxBroadcaster; |
| class SfxItemPoolCache; |
| class SfxItemSet; |
| class SvtListener; |
| class SfxPoolItem; |
| class SfxStyleSheetBase; |
| class SvxBorderLine; |
| class SvxBoxInfoItem; |
| class SvxBoxItem; |
| |
| class ScAttrIterator; |
| class ScAttrArray; |
| class ScBaseCell; |
| class ScDocument; |
| class ScFormulaCell; |
| class ScMarkData; |
| class ScPatternAttr; |
| class ScStyleSheet; |
| class SvtBroadcaster; |
| class TypedScStrCollection; |
| class ScProgress; |
| class ScPostIt; |
| struct ScFunctionData; |
| struct ScLineFlags; |
| struct ScMergePatternState; |
| class ScDPTableDataCache; |
| class ScFlatBoolRowSegments; |
| |
| #define COLUMN_DELTA 4 |
| |
| |
| struct ScNeededSizeOptions |
| { |
| const ScPatternAttr* pPattern; |
| sal_Bool bFormula; |
| sal_Bool bSkipMerged; |
| sal_Bool bGetFont; |
| sal_Bool bTotalSize; |
| |
| ScNeededSizeOptions() |
| { |
| pPattern = NULL; |
| bFormula = sal_False; |
| bSkipMerged = sal_True; |
| bGetFont = sal_True; |
| bTotalSize = sal_False; |
| } |
| }; |
| |
| struct ColEntry |
| { |
| SCROW nRow; |
| ScBaseCell* pCell; |
| }; |
| |
| |
| class ScColumn |
| { |
| private: |
| SCCOL nCol; |
| SCTAB nTab; |
| |
| SCSIZE nCount; |
| SCSIZE nLimit; |
| ColEntry* pItems; |
| |
| ScAttrArray* pAttrArray; |
| ScDocument* pDocument; |
| |
| friend class ScDocument; // fuer FillInfo |
| friend class ScDocumentIterator; |
| friend class ScValueIterator; |
| friend class ScHorizontalValueIterator; |
| friend class ScDBQueryDataIterator; |
| friend class ScColumnIterator; |
| friend class ScQueryCellIterator; |
| friend class ScMarkedDataIter; |
| friend class ScCellIterator; |
| friend class ScHorizontalCellIterator; |
| friend class ScHorizontalAttrIterator; |
| |
| public: |
| static sal_Bool bDoubleAlloc; // fuer Import: Groesse beim Allozieren verdoppeln |
| |
| public: |
| ScColumn(); |
| ~ScColumn(); |
| |
| void Init(SCCOL nNewCol, SCTAB nNewTab, ScDocument* pDoc); |
| |
| sal_Bool Search( SCROW nRow, SCSIZE& nIndex ) const; |
| ScBaseCell* GetCell( SCROW nRow ) const; |
| void Insert( SCROW nRow, ScBaseCell* pCell ); |
| void Insert( SCROW nRow, sal_uLong nFormatIndex, ScBaseCell* pCell ); |
| void Append( SCROW nRow, ScBaseCell* pCell ); |
| void Delete( SCROW nRow ); |
| void DeleteAtIndex( SCSIZE nIndex ); |
| void FreeAll(); |
| void Resize( SCSIZE nSize ); |
| void SwapRow( SCROW nRow1, SCROW nRow2 ); |
| void SwapCell( SCROW nRow, ScColumn& rCol); |
| |
| //UNUSED2009-05 sal_Bool HasLines( SCROW nRow1, SCROW nRow2, Rectangle& rSizes, |
| //UNUSED2009-05 sal_Bool bLeft, sal_Bool bRight ) const; |
| bool HasAttrib( SCROW nRow1, SCROW nRow2, sal_uInt16 nMask ) const; |
| sal_Bool HasAttribSelection( const ScMarkData& rMark, sal_uInt16 nMask ) const; |
| sal_Bool ExtendMerge( SCCOL nThisCol, SCROW nStartRow, SCROW nEndRow, |
| SCCOL& rPaintCol, SCROW& rPaintRow, |
| sal_Bool bRefresh, sal_Bool bAttrs ); |
| |
| sal_Bool IsEmptyVisData(sal_Bool bNotes) const; // ohne Broadcaster |
| sal_Bool IsEmptyData() const; |
| sal_Bool IsEmptyAttr() const; |
| sal_Bool IsEmpty() const; |
| |
| // nur Daten: |
| sal_Bool IsEmptyBlock(SCROW nStartRow, SCROW nEndRow, bool bIgnoreNotes = false) const; |
| SCSIZE GetEmptyLinesInBlock( SCROW nStartRow, SCROW nEndRow, ScDirection eDir ) const; |
| sal_Bool HasDataAt(SCROW nRow) const; |
| sal_Bool HasVisibleDataAt(SCROW nRow) const; |
| SCROW GetFirstDataPos() const; |
| SCROW GetLastDataPos() const; |
| SCROW GetLastVisDataPos(sal_Bool bNotes) const; // ohne Broadcaster |
| SCROW GetFirstVisDataPos(sal_Bool bNotes) const; |
| sal_Bool GetPrevDataPos(SCROW& rRow) const; |
| sal_Bool GetNextDataPos(SCROW& rRow) const; |
| void FindDataAreaPos(SCROW& rRow, long nMovY) const; // (ohne Broadcaster) |
| void FindUsed( SCROW nStartRow, SCROW nEndRow, sal_Bool* pUsed ) const; |
| |
| SCSIZE VisibleCount( SCROW nStartRow, SCROW nEndRow ) const; |
| |
| sal_uInt16 GetBlockMatrixEdges( SCROW nRow1, SCROW nRow2, sal_uInt16 nMask ) const; |
| sal_Bool HasSelectionMatrixFragment(const ScMarkData& rMark) const; |
| |
| sal_Bool GetFirstVisibleAttr( SCROW& rFirstRow ) const; |
| sal_Bool GetLastVisibleAttr( SCROW& rLastRow ) const; |
| /* |
| Get the last cell's row number , which have visual atribute or visual data in a column |
| */ |
| sal_Bool GetLastAttr( SCROW& rLastRow ) const; |
| sal_Bool HasVisibleAttrIn( SCROW nStartRow, SCROW nEndRow ) const; |
| sal_Bool IsVisibleAttrEqual( const ScColumn& rCol, SCROW nStartRow = 0, |
| SCROW nEndRow = MAXROW ) const; |
| sal_Bool IsAllAttrEqual( const ScColumn& rCol, SCROW nStartRow, SCROW nEndRow ) const; |
| |
| sal_Bool TestInsertCol( SCROW nStartRow, SCROW nEndRow) const; |
| sal_Bool TestInsertRow( SCSIZE nSize ) const; |
| void InsertRow( SCROW nStartRow, SCSIZE nSize ); |
| void DeleteRow( SCROW nStartRow, SCSIZE nSize ); |
| void DeleteRange( SCSIZE nStartIndex, SCSIZE nEndIndex, sal_uInt16 nDelFlag ); |
| void DeleteArea(SCROW nStartRow, SCROW nEndRow, sal_uInt16 nDelFlag ); |
| void CopyToClip(SCROW nRow1, SCROW nRow2, ScColumn& rColumn, sal_Bool bKeepScenarioFlags, sal_Bool bCloneNoteCaptions); |
| void CopyFromClip(SCROW nRow1, SCROW nRow2, long nDy, |
| sal_uInt16 nInsFlag, sal_Bool bAsLink, sal_Bool bSkipAttrForEmpty, ScColumn& rColumn); |
| void StartListeningInArea( SCROW nRow1, SCROW nRow2 ); |
| void BroadcastInArea( SCROW nRow1, SCROW nRow2 ); |
| |
| void RemoveEditAttribs( SCROW nStartRow, SCROW nEndRow ); |
| |
| // Markierung von diesem Dokument |
| void MixMarked( const ScMarkData& rMark, sal_uInt16 nFunction, |
| sal_Bool bSkipEmpty, ScColumn& rSrcCol ); |
| void MixData( SCROW nRow1, SCROW nRow2, sal_uInt16 nFunction, sal_Bool bSkipEmpty, |
| ScColumn& rSrcCol ); |
| |
| ScFormulaCell* CreateRefCell( ScDocument* pDestDoc, const ScAddress& rDestPos, |
| SCSIZE nIndex, sal_uInt16 nFlags ) const; |
| |
| ScAttrIterator* CreateAttrIterator( SCROW nStartRow, SCROW nEndRow ) const; |
| |
| SCCOL GetCol() const { return nCol; } |
| |
| // UpdateSelectionFunction: Mehrfachselektion |
| void UpdateSelectionFunction( const ScMarkData& rMark, |
| ScFunctionData& rData, |
| ScFlatBoolRowSegments& rHiddenRows, |
| sal_Bool bDoExclude, SCROW nExStartRow, SCROW nExEndRow ); |
| void UpdateAreaFunction( ScFunctionData& rData, |
| ScFlatBoolRowSegments& rHiddenRows, |
| SCROW nStartRow, SCROW nEndRow ); |
| |
| void CopyToColumn(SCROW nRow1, SCROW nRow2, sal_uInt16 nFlags, sal_Bool bMarked, |
| ScColumn& rColumn, const ScMarkData* pMarkData = NULL, |
| sal_Bool bAsLink = sal_False ); |
| void UndoToColumn(SCROW nRow1, SCROW nRow2, sal_uInt16 nFlags, sal_Bool bMarked, |
| ScColumn& rColumn, const ScMarkData* pMarkData = NULL ); |
| |
| void CopyScenarioFrom( const ScColumn& rSrcCol ); |
| void CopyScenarioTo( ScColumn& rDestCol ) const; |
| sal_Bool TestCopyScenarioTo( const ScColumn& rDestCol ) const; |
| void MarkScenarioIn( ScMarkData& rDestMark ) const; |
| |
| void CopyUpdated( const ScColumn& rPosCol, ScColumn& rDestCol ) const; |
| |
| void SwapCol(ScColumn& rCol); |
| void MoveTo(SCROW nStartRow, SCROW nEndRow, ScColumn& rCol); |
| |
| sal_Bool HasEditCells(SCROW nStartRow, SCROW nEndRow, SCROW& rFirst) const; |
| |
| // sal_True = Zahlformat gesetzt |
| sal_Bool SetString( SCROW nRow, SCTAB nTab, const String& rString, |
| formula::FormulaGrammar::AddressConvention conv = formula::FormulaGrammar::CONV_OOO, |
| SvNumberFormatter* pFormatter = NULL, |
| bool bDetectNumberFormat = true ); |
| void SetValue( SCROW nRow, const double& rVal); |
| void SetError( SCROW nRow, const sal_uInt16 nError); |
| |
| void GetString( SCROW nRow, String& rString ) const; |
| void GetInputString( SCROW nRow, String& rString ) const; |
| double GetValue( SCROW nRow ) const; |
| void GetFormula( SCROW nRow, String& rFormula, |
| sal_Bool bAsciiExport = sal_False ) const; |
| CellType GetCellType( SCROW nRow ) const; |
| SCSIZE GetCellCount() const { return nCount; } |
| sal_uLong GetWeightedCount() const; |
| sal_uLong GetCodeCount() const; // RPN-Code in Formeln |
| sal_uInt16 GetErrCode( SCROW nRow ) const; |
| |
| sal_Bool HasStringData( SCROW nRow ) const; |
| sal_Bool HasValueData( SCROW nRow ) const; |
| //UNUSED2009-05 sal_uInt16 GetErrorData( SCROW nRow) const; |
| sal_Bool HasStringCells( SCROW nStartRow, SCROW nEndRow ) const; |
| |
| /** Returns the pointer to a cell note object at the passed row. */ |
| ScPostIt* GetNote( SCROW nRow ); |
| /** Sets the passed cell note object at the passed row. Takes ownership! */ |
| void TakeNote( SCROW nRow, ScPostIt* pNote ); |
| /** Returns and forgets a cell note object at the passed row. */ |
| ScPostIt* ReleaseNote( SCROW nRow ); |
| /** Deletes the note at the passed row. */ |
| void DeleteNote( SCROW nRow ); |
| |
| void SetDirty(); |
| void SetDirty( const ScRange& ); |
| void SetDirtyVar(); |
| void SetDirtyAfterLoad(); |
| void SetTableOpDirty( const ScRange& ); |
| void CalcAll(); |
| void CalcAfterLoad(); |
| void CompileAll(); |
| void CompileXML( ScProgress& rProgress ); |
| |
| void ResetChanged( SCROW nStartRow, SCROW nEndRow ); |
| |
| void UpdateReference( UpdateRefMode eUpdateRefMode, SCCOL nCol1, SCROW nRow1, SCTAB nTab1, |
| SCCOL nCol2, SCROW nRow2, SCTAB nTab2, |
| SCsCOL nDx, SCsROW nDy, SCsTAB nDz, |
| ScDocument* pUndoDoc = NULL ); |
| void UpdateInsertTab( SCTAB nTable); |
| void UpdateInsertTabOnlyCells( SCTAB nTable); |
| void UpdateDeleteTab( SCTAB nTable, sal_Bool bIsMove, ScColumn* pRefUndo = NULL ); |
| void UpdateMoveTab(SCTAB nOldPos, SCTAB nNewPos, SCTAB nTabNo); |
| void UpdateCompile( sal_Bool bForceIfNameInUse = sal_False ); |
| void UpdateTranspose( const ScRange& rSource, const ScAddress& rDest, |
| ScDocument* pUndoDoc ); |
| void UpdateGrow( const ScRange& rArea, SCCOL nGrowX, SCROW nGrowY ); |
| |
| void SetTabNo(SCTAB nNewTab); |
| sal_Bool IsRangeNameInUse(SCROW nRow1, SCROW nRow2, sal_uInt16 nIndex) const; |
| void FindRangeNamesInUse(SCROW nRow1, SCROW nRow2, std::set<sal_uInt16>& rIndexes) const; |
| void ReplaceRangeNamesInUse( SCROW nRow1, SCROW nRow2, const ScRangeData::IndexMap& rMap ); |
| |
| const SfxPoolItem* GetAttr( SCROW nRow, sal_uInt16 nWhich ) const; |
| const ScPatternAttr* GetPattern( SCROW nRow ) const; |
| const ScPatternAttr* GetPatternRange( SCROW& rStartRow, SCROW& rEndRow, SCROW nRow ) const; |
| const ScPatternAttr* GetMostUsedPattern( SCROW nStartRow, SCROW nEndRow ) const; |
| |
| sal_uLong GetNumberFormat( SCROW nRow ) const; |
| |
| void MergeSelectionPattern( ScMergePatternState& rState, const ScMarkData& rMark, sal_Bool bDeep ) const; |
| void MergePatternArea( ScMergePatternState& rState, SCROW nRow1, SCROW nRow2, sal_Bool bDeep ) const; |
| void MergeBlockFrame( SvxBoxItem* pLineOuter, SvxBoxInfoItem* pLineInner, |
| ScLineFlags& rFlags, |
| SCROW nStartRow, SCROW nEndRow, sal_Bool bLeft, SCCOL nDistRight ) const; |
| void ApplyBlockFrame( const SvxBoxItem* pLineOuter, const SvxBoxInfoItem* pLineInner, |
| SCROW nStartRow, SCROW nEndRow, sal_Bool bLeft, SCCOL nDistRight ); |
| |
| void ApplyAttr( SCROW nRow, const SfxPoolItem& rAttr ); |
| void ApplyPattern( SCROW nRow, const ScPatternAttr& rPatAttr ); |
| void ApplyPatternArea( SCROW nStartRow, SCROW nEndRow, const ScPatternAttr& rPatAttr ); |
| void SetPattern( SCROW nRow, const ScPatternAttr& rPatAttr, sal_Bool bPutToPool = sal_False ); |
| void SetPatternArea( SCROW nStartRow, SCROW nEndRow, |
| const ScPatternAttr& rPatAttr, sal_Bool bPutToPool = sal_False ); |
| void ApplyPatternIfNumberformatIncompatible( const ScRange& rRange, |
| const ScPatternAttr& rPattern, short nNewType ); |
| |
| void ApplyStyle( SCROW nRow, const ScStyleSheet& rStyle ); |
| void ApplyStyleArea( SCROW nStartRow, SCROW nEndRow, const ScStyleSheet& rStyle ); |
| void ApplySelectionStyle(const ScStyleSheet& rStyle, const ScMarkData& rMark); |
| void ApplySelectionLineStyle( const ScMarkData& rMark, |
| const SvxBorderLine* pLine, sal_Bool bColorOnly ); |
| |
| const ScStyleSheet* GetStyle( SCROW nRow ) const; |
| const ScStyleSheet* GetSelectionStyle( const ScMarkData& rMark, sal_Bool& rFound ) const; |
| const ScStyleSheet* GetAreaStyle( sal_Bool& rFound, SCROW nRow1, SCROW nRow2 ) const; |
| |
| void FindStyleSheet( const SfxStyleSheetBase* pStyleSheet, ScFlatBoolRowSegments& rUsedRows, bool bReset ); |
| sal_Bool IsStyleSheetUsed( const ScStyleSheet& rStyle, sal_Bool bGatherAllStyles ) const; |
| |
| /// May return -1 if not found |
| SCsROW SearchStyle( SCsROW nRow, const ScStyleSheet* pSearchStyle, |
| sal_Bool bUp, sal_Bool bInSelection, const ScMarkData& rMark ); |
| sal_Bool SearchStyleRange( SCsROW& rRow, SCsROW& rEndRow, const ScStyleSheet* pSearchStyle, |
| sal_Bool bUp, sal_Bool bInSelection, const ScMarkData& rMark ); |
| |
| sal_Bool ApplyFlags( SCROW nStartRow, SCROW nEndRow, sal_Int16 nFlags ); |
| sal_Bool RemoveFlags( SCROW nStartRow, SCROW nEndRow, sal_Int16 nFlags ); |
| void ClearItems( SCROW nStartRow, SCROW nEndRow, const sal_uInt16* pWhich ); |
| |
| void RemoveProtected( SCROW nStartRow, SCROW nEndRow ); |
| |
| SCsROW ApplySelectionCache( SfxItemPoolCache* pCache, const ScMarkData& rMark ); |
| void DeleteSelection( sal_uInt16 nDelFlag, const ScMarkData& rMark ); |
| |
| void ClearSelectionItems( const sal_uInt16* pWhich, const ScMarkData& rMark ); |
| void ChangeSelectionIndent( sal_Bool bIncrement, const ScMarkData& rMark ); |
| |
| long GetNeededSize( SCROW nRow, OutputDevice* pDev, |
| double nPPTX, double nPPTY, |
| const Fraction& rZoomX, const Fraction& rZoomY, |
| sal_Bool bWidth, const ScNeededSizeOptions& rOptions ); |
| sal_uInt16 GetOptimalColWidth( OutputDevice* pDev, double nPPTX, double nPPTY, |
| const Fraction& rZoomX, const Fraction& rZoomY, |
| sal_Bool bFormula, sal_uInt16 nOldWidth, |
| const ScMarkData* pMarkData, |
| sal_Bool bSimpleTextImport ); |
| void GetOptimalHeight( SCROW nStartRow, SCROW nEndRow, sal_uInt16* pHeight, |
| OutputDevice* pDev, |
| double nPPTX, double nPPTY, |
| const Fraction& rZoomX, const Fraction& rZoomY, |
| sal_Bool bShrink, sal_uInt16 nMinHeight, SCROW nMinStart ); |
| template< typename TAddLebal, typename TAddData > |
| void FillDPCacheT( long nDim, SCROW nStartRow, SCROW nEndRow, const TAddLebal & , const TAddData & ); |
| void FillDPCache( ScDPTableDataCache * pCache, long nDim, SCROW nStartRow, SCROW nEndRow ); |
| private: |
| long GetSimpleTextNeededSize( SCSIZE nIndex, OutputDevice* pDev, |
| sal_Bool bWidth ); |
| public: |
| |
| /// Including current, may return -1 |
| SCsROW GetNextUnprotected( SCROW nRow, sal_Bool bUp ) const; |
| |
| void GetFilterEntries(SCROW nStartRow, SCROW nEndRow, TypedScStrCollection& rStrings, bool& rHasDates); |
| sal_Bool GetDataEntries(SCROW nRow, TypedScStrCollection& rStrings, sal_Bool bLimit); |
| |
| //UNUSED2008-05 SCROW NoteCount( SCROW nMaxRow = MAXROW ) const; |
| |
| void UpdateInsertTabAbs(SCTAB nNewPos); |
| sal_Bool TestTabRefAbs(SCTAB nTable); |
| sal_Bool GetNextSpellingCell(SCROW& nRow, sal_Bool bInSel, const ScMarkData& rData) const; |
| |
| void RemoveAutoSpellObj(); |
| |
| void StartListening( SvtListener& rLst, SCROW nRow ); |
| void EndListening( SvtListener& rLst, SCROW nRow ); |
| void MoveListeners( SvtBroadcaster& rSource, SCROW nDestRow ); |
| void StartAllListeners(); |
| void StartNeededListeners(); // only for cells where NeedsListening()==TRUE |
| void SetRelNameDirty(); |
| |
| void CompileDBFormula(); |
| void CompileDBFormula( sal_Bool bCreateFormulaString ); |
| void CompileNameFormula( sal_Bool bCreateFormulaString ); |
| void CompileColRowNameFormula(); |
| |
| sal_Int32 GetMaxStringLen( SCROW nRowStart, SCROW nRowEnd, CharSet eCharSet ) const; |
| xub_StrLen GetMaxNumberStringLen( sal_uInt16& nPrecision, |
| SCROW nRowStart, SCROW nRowEnd ) const; |
| |
| SCSIZE GetPatternCount( ); |
| SCSIZE GetPatternCount( SCROW nRw1, SCROW nRw2 ); |
| bool ReservedPatternCount( SCSIZE nReserved ); |
| private: |
| ScBaseCell* CloneCell(SCSIZE nIndex, sal_uInt16 nFlags, ScDocument& rDestDoc, const ScAddress& rDestPos); |
| //UNUSED2008-05 void CorrectSymbolCells( CharSet eStreamCharSet ); |
| }; |
| |
| |
| class ScColumnIterator // alle Daten eines Bereichs durchgehen |
| { |
| const ScColumn* pColumn; |
| SCSIZE nPos; |
| SCROW nTop; |
| SCROW nBottom; |
| public: |
| ScColumnIterator( const ScColumn* pCol, SCROW nStart=0, SCROW nEnd=MAXROW ); |
| ~ScColumnIterator(); |
| |
| sal_Bool Next( SCROW& rRow, ScBaseCell*& rpCell ); |
| SCSIZE GetIndex() const; |
| }; |
| |
| |
| class ScMarkedDataIter // Daten in selektierten Bereichen durchgehen |
| { |
| const ScColumn* pColumn; |
| SCSIZE nPos; |
| ScMarkArrayIter* pMarkIter; |
| SCROW nTop; |
| SCROW nBottom; |
| sal_Bool bNext; |
| sal_Bool bAll; |
| |
| public: |
| ScMarkedDataIter( const ScColumn* pCol, const ScMarkData* pMarkData, |
| sal_Bool bAllIfNone = sal_False ); |
| ~ScMarkedDataIter(); |
| |
| sal_Bool Next( SCSIZE& rIndex ); |
| }; |
| |
| |
| #endif |
| |
| |
