LibreOffice Module sc (master) 1
Public Member Functions | Static Public Member Functions | Private Member Functions | Static Private Member Functions | List of all members
ScDBFunc Class Reference

#include <dbfunc.hxx>

Inheritance diagram for ScDBFunc:
[legend]
Collaboration diagram for ScDBFunc:
[legend]

Public Member Functions

 ScDBFunc (vcl::Window *pParent, ScDocShell &rDocSh, ScTabViewShell *pViewShell)
 
virtual ~ScDBFunc ()
 
void UISort (const ScSortParam &rSortParam)
 
void Sort (const ScSortParam &rSortParam, bool bRecord=true, bool bPaint=true)
 
SC_DLLPUBLIC void Query (const ScQueryParam &rQueryParam, const ScRange *pAdvSource, bool bRecord)
 
void DoSubTotals (const ScSubTotalParam &rParam, bool bRecord=true, const ScSortParam *pForceNewSort=nullptr)
 
void ToggleAutoFilter ()
 
void HideAutoFilter ()
 
void RepeatDB (bool bRecord=true)
 
bool ImportData (const ScImportParam &rParam)
 
void GotoDBArea (const OUString &rDBName)
 
ScDBDataGetDBData (bool bMarkArea=true, ScGetDBMode eMode=SC_DB_MAKE, ScGetDBSelection eSel=ScGetDBSelection::Keep)
 
ScDBDataGetAnonymousDBData ()
 
void Consolidate (const ScConsolidateParam &rParam)
 
bool MakePivotTable (const ScDPSaveData &rData, const ScRange &rDest, bool bNewTable, const ScDPObject &rSource)
 
void DeletePivotTable ()
 
void RecalcPivotTable ()
 
bool HasSelectionForDateGroup (ScDPNumGroupInfo &rOldInfo, sal_Int32 &rParts)
 
bool HasSelectionForNumGroup (ScDPNumGroupInfo &rOldInfo)
 
void GroupDataPilot ()
 
void DateGroupDataPilot (const ScDPNumGroupInfo &rInfo, sal_Int32 nParts)
 
void NumGroupDataPilot (const ScDPNumGroupInfo &rInfo)
 
void UngroupDataPilot ()
 
void DataPilotInput (const ScAddress &rPos, const OUString &rString)
 
void DataPilotSort (ScDPObject *pDPObject, tools::Long nDimIndex, bool bAscending, const sal_uInt16 *pUserListId=nullptr)
 
bool DataPilotMove (const ScRange &rSource, const ScAddress &rDest)
 
bool HasSelectionForDrillDown (css::sheet::DataPilotFieldOrientation &rOrientation)
 
void SetDataPilotDetails (bool bShow, const OUString *pNewDimensionName=nullptr)
 
void ShowDataPilotSourceData (ScDPObject &rDPObj, const css::uno::Sequence< css::sheet::DataPilotFieldFilter > &rFilters)
 
void MakeOutline (bool bColumns, bool bRecord=true)
 
void RemoveOutline (bool bColumns, bool bRecord=true)
 
void RemoveAllOutlines (bool bRecord=true)
 
void TestRemoveOutline (bool &rCol, bool &rRow)
 
void AutoOutline ()
 
void SelectLevel (bool bColumns, sal_uInt16 nLevel, bool bRecord=true)
 
void SetOutlineState (bool bColumn, sal_uInt16 nLevel, sal_uInt16 nEntry, bool bHidden)
 
void ShowOutline (bool bColumns, sal_uInt16 nLevel, sal_uInt16 nEntry, bool bRecord=true, bool bPaint=true)
 
void HideOutline (bool bColumns, sal_uInt16 nLevel, sal_uInt16 nEntry, bool bRecord=true, bool bPaint=true)
 
void ShowMarkedOutlines (bool bRecord=true)
 
void HideMarkedOutlines (bool bRecord=true)
 
bool OutlinePossible (bool bHide)
 
void UpdateCharts (bool bAllCharts)
 
void OnLOKShowHideColRow (bool bColumns, SCCOLROW nStartRow)
 
- Public Member Functions inherited from ScViewFunc
 ScViewFunc (vcl::Window *pParent, ScDocShell &rDocSh, ScTabViewShell *pViewShell)
 
 ~ScViewFunc ()
 
SC_DLLPUBLIC const ScPatternAttrGetSelectionPattern ()
 
void GetSelectionFrame (std::shared_ptr< SvxBoxItem > &rLineOuter, std::shared_ptr< SvxBoxInfoItem > &rLineInner)
 
SvtScriptType GetSelectionScriptType ()
 
bool GetAutoSumArea (ScRangeList &rRangeList)
 
void EnterAutoSum (const ScRangeList &rRangeList, bool bSubTotal, const ScAddress &rAddr, const OpCode eCode)
 
bool AutoSum (const ScRange &rRange, bool bSubTotal, bool bSetCursor, bool bContinue, const OpCode eCode)
 
OUString GetAutoSumFormula (const ScRangeList &rRangeList, bool bSubTotal, const ScAddress &rAddr, const OpCode eCode)
 
void EnterData (SCCOL nCol, SCROW nRow, SCTAB nTab, const OUString &rString, const EditTextObject *pData=nullptr, bool bMatrixExpand=false)
 
void EnterData (SCCOL nCol, SCROW nRow, SCTAB nTab, const EditTextObject &rData, bool bTestSimple=false)
 
void EnterValue (SCCOL nCol, SCROW nRow, SCTAB nTab, const double &rValue)
 
void EnterMatrix (const OUString &rString, ::formula::FormulaGrammar::Grammar eGram)
 
void EnterBlock (const OUString &rString, const EditTextObject *pData)
 
void EnterDataAtCursor (const OUString &rString)
 
SC_DLLPUBLIC void CutToClip ()
 
SC_DLLPUBLIC bool CopyToClip (ScDocument *pClipDoc, bool bCut, bool bApi=false, bool bIncludeObjects=false, bool bStopEdit=true)
 
SC_DLLPUBLIC bool CopyToClip (ScDocument *pClipDoc, const ScRangeList &rRange, bool bCut, bool bApi=false, bool bIncludeObjects=false, bool bStopEdit=true)
 
bool CopyToClipSingleRange (ScDocument *pClipDoc, const ScRangeList &rRanges, bool bCut, bool bIncludeObjects)
 
bool CopyToClipMultiRange (const ScDocument *pClipDoc, const ScRangeList &rRanges, bool bCut, bool bApi, bool bIncludeObjects)
 
rtl::Reference< ScTransferObjCopyToTransferable ()
 
SC_DLLPUBLIC bool PasteFromClip (InsertDeleteFlags nFlags, ScDocument *pClipDoc, ScPasteFunc nFunction=ScPasteFunc::NONE, bool bSkipEmptyCells=false, bool bTranspose=false, bool bAsLink=false, InsCellCmd eMoveMode=INS_NONE, InsertDeleteFlags nUndoExtraFlags=InsertDeleteFlags::NONE, bool bAllowDialogs=false)
 
void FillTab (InsertDeleteFlags nFlags, ScPasteFunc nFunction, bool bSkipEmpty, bool bAsLink)
 
SC_DLLPUBLIC void PasteFromSystem ()
 
SC_DLLPUBLIC bool PasteFromSystem (SotClipboardFormatId nFormatId, bool bApi=false)
 
void PasteFromTransferable (const css::uno::Reference< css::datatransfer::XTransferable > &rxTransferable)
 
void PasteDraw ()
 
void PasteDraw (const Point &rLogicPos, SdrModel *pModel, bool bGroup, std::u16string_view rSrcShellID, std::u16string_view rDestShellID)
 
bool PasteOnDrawObjectLinked (const css::uno::Reference< css::datatransfer::XTransferable > &rxTransferable, SdrObject &rHitObj)
 
bool PasteDataFormat (SotClipboardFormatId nFormatId, const css::uno::Reference< css::datatransfer::XTransferable > &rxTransferable, SCCOL nPosX, SCROW nPosY, const Point *pLogicPos, bool bLink=false, bool bAllowDialogs=false)
 
bool PasteFile (const Point &, const OUString &, bool bLink)
 
bool PasteObject (const Point &, const css::uno::Reference< css::embed::XEmbeddedObject > &, const Size *, const Graphic *=nullptr, const OUString &=OUString(), sal_Int64 nAspect=css::embed::Aspects::MSOLE_CONTENT)
 
bool PasteBitmapEx (const Point &, const BitmapEx &)
 
bool PasteMetaFile (const Point &, const GDIMetaFile &)
 
bool PasteGraphic (const Point &rPos, const Graphic &rGraphic, const OUString &rFile)
 
bool PasteBookmark (SotClipboardFormatId nFormatId, const css::uno::Reference< css::datatransfer::XTransferable > &rxTransferable, SCCOL nPosX, SCROW nPosY)
 
bool PasteLink (const css::uno::Reference< css::datatransfer::XTransferable > &rxTransferable)
 
void InsertBookmark (const OUString &rDescription, const OUString &rURL, SCCOL nPosX, SCROW nPosY, const OUString *pTarget=nullptr, bool bTryReplace=false)
 
bool HasBookmarkAtCursor (SvxHyperlinkItem *pContent)
 
bool MoveBlockTo (const ScRange &rSource, const ScAddress &rDestPos, bool bCut)
 
bool LinkBlock (const ScRange &rSource, const ScAddress &rDestPos)
 
void CreateNames (CreateNameFlags nFlags)
 
CreateNameFlags GetCreateNameFlags ()
 
void InsertNameList ()
 
bool InsertName (const OUString &rName, const OUString &rSymbol, const OUString &rType)
 
void ApplyAttributes (const SfxItemSet *pDialogSet, const SfxItemSet *pOldSet, bool bAdjustBlockHeight=true)
 
void ApplyAttr (const SfxPoolItem &rAttrItem, bool bAdjustBlockHeight=true)
 
void ApplySelectionPattern (const ScPatternAttr &rAttr, bool bCursorOnly=false)
 
void ApplyPatternLines (const ScPatternAttr &rAttr, const SvxBoxItem &rNewOuter, const SvxBoxInfoItem *pNewInner)
 
void ApplyUserItemSet (const SfxItemSet &rItemSet)
 
const SfxStyleSheetGetStyleSheetFromMarked ()
 
void SetStyleSheetToMarked (const SfxStyleSheet *pStyleSheet)
 
void RemoveStyleSheetInUse (const SfxStyleSheetBase *pStyleSheet)
 
void UpdateStyleSheetInUse (const SfxStyleSheetBase *pStyleSheet)
 
void SetNumberFormat (SvNumFormatType nFormatType, sal_uLong nAdd=0)
 
void SetNumFmtByStr (const OUString &rCode)
 
void ChangeNumFmtDecimals (bool bIncrement)
 
void SetValidation (const ScValidationData &rNew)
 
void ChangeIndent (bool bIncrement)
 
void ProtectSheet (SCTAB nTab, const ScTableProtection &rProtect)
 
void ProtectDoc (const OUString &rPassword)
 
bool Unprotect (SCTAB nTab, const OUString &rPassword)
 
void DeleteCells (DelCellCmd eCmd)
 
bool InsertCells (InsCellCmd eCmd, bool bRecord=true, bool bPartOfPaste=false)
 
void DeleteMulti (bool bRows)
 
void DeleteContents (InsertDeleteFlags nFlags)
 
void SetWidthOrHeight (bool bWidth, const std::vector< sc::ColRowSpan > &rRanges, ScSizeMode eMode, sal_uInt16 nSizeTwips, bool bRecord=true, const ScMarkData *pMarkData=nullptr)
 
void SetMarkedWidthOrHeight (bool bWidth, ScSizeMode eMode, sal_uInt16 nSizeTwips)
 
bool AdjustBlockHeight (bool bPaint=true, ScMarkData *pMarkData=nullptr)
 
bool AdjustRowHeight (SCROW nStartRow, SCROW nEndRow, bool bApi)
 
void ModifyCellSize (ScDirection eDir, bool bOptimal)
 
SC_DLLPUBLIC void InsertPageBreak (bool bColumn, bool bRecord=true, const ScAddress *pPos=nullptr, bool bSetModified=true)
 
SC_DLLPUBLIC void DeletePageBreak (bool bColumn, bool bRecord=true, const ScAddress *pPos=nullptr, bool bSetModified=true)
 
void RemoveManualBreaks ()
 
void SetPrintZoom (sal_uInt16 nScale)
 
void AdjustPrintZoom ()
 
bool TestMergeCells ()
 
bool TestRemoveMerge ()
 
bool MergeCells (bool bApi, bool &rDoContents, bool bCenter)
 
bool RemoveMerge ()
 
SC_DLLPUBLIC void FillSimple (FillDir eDir)
 
void FillSeries (FillDir eDir, FillCmd eCmd, FillDateCmd eDateCmd, double fStart, double fStep, double fMax)
 
SC_DLLPUBLIC void FillAuto (FillDir eDir, SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, sal_uLong nCount)
 
void FillCrossDblClick ()
 Downward fill of selected cell(s) by double-clicking cross-hair cursor. More...
 
void ConvertFormulaToValue ()
 
void TransliterateText (TransliterationFlags nType)
 
ScAutoFormatDataCreateAutoFormatData ()
 
void AutoFormat (sal_uInt16 nFormatNo)
 
bool SearchAndReplace (const SvxSearchItem *pSearchItem, bool bAddUndo, bool bIsApi)
 
void Solve (const ScSolveParam &rParam)
 
void TabOp (const ScTabOpParam &rParam, bool bRecord=true)
 
bool InsertTable (const OUString &rName, SCTAB nTabNr, bool bRecord=true)
 
void InsertTables (std::vector< OUString > &aNames, SCTAB nTab, SCTAB nCount, bool bRecord=true)
 
bool AppendTable (const OUString &rName, bool bRecord=true)
 
void DeleteTable (SCTAB nTabNr, bool bRecord=true)
 
bool DeleteTables (const std::vector< SCTAB > &TheTabs, bool bRecord=true)
 
void DeleteTables (SCTAB nTab, SCTAB nSheets)
 
bool RenameTable (const OUString &rName, SCTAB nTabNr)
 
void MoveTable (sal_uInt16 nDestDocNo, SCTAB nDestTab, bool bCopy, const OUString *pNewTabName=nullptr)
 
void ImportTables (ScDocShell *pSrcShell, SCTAB nCount, const SCTAB *pSrcTabs, bool bLink, SCTAB nTab)
 
bool SetTabBgColor (const Color &rColor, SCTAB nTabNr)
 
bool SetTabBgColor (ScUndoTabColorInfo::List &rUndoSetTabBgColorInfoList)
 
void InsertTableLink (const OUString &rFile, const OUString &rFilter, const OUString &rOptions, std::u16string_view rTabName)
 
void InsertAreaLink (const OUString &rFile, const OUString &rFilter, const OUString &rOptions, const OUString &rSource)
 
void ShowTable (const std::vector< OUString > &rNames)
 
void HideTable (const ScMarkData &rMark, SCTAB nTabToSelect=-1)
 
void MakeScenario (const OUString &rName, const OUString &rComment, const Color &rColor, ScScenarioFlags nFlags)
 
void ExtendScenario ()
 
void UseScenario (const OUString &rName)
 
void InsertSpecialChar (const OUString &rStr, const vcl::Font &rFont)
 
void SetSelectionFrameLines (const ::editeng::SvxBorderLine *pLine, bool bColorOnly)
 
void SetNoteText (const ScAddress &rPos, const OUString &rNoteText)
 
void ReplaceNote (const ScAddress &rPos, const OUString &rNoteText, const OUString *pAuthor, const OUString *pDate)
 
void DoRefConversion ()
 
void DoHangulHanjaConversion ()
 
void DoThesaurus ()
 
void DoSheetConversion (const ScConversionParam &rParam)
 Generic implementation of sheet conversion functions. More...
 
void SetPrintRanges (bool bEntireSheet, const OUString *pPrint, const OUString *pRepCol, const OUString *pRepRow, bool bAddPrint)
 
void DetectiveAddPred ()
 
void DetectiveDelPred ()
 
void DetectiveAddSucc ()
 
void DetectiveDelSucc ()
 
void DetectiveAddError ()
 
void DetectiveMarkInvalid ()
 
void DetectiveDelAll ()
 
void DetectiveRefresh ()
 
void DetectiveMarkPred ()
 
void DetectiveMarkSucc ()
 
void InsertCurrentTime (SvNumFormatType nCellFmt, const OUString &rUndoStr)
 Insert date or time into current cell. More...
 
void ShowNote (bool bShow)
 
void EditNote ()
 
bool SelectionEditable (bool *pOnlyNotBecauseOfMatrix=nullptr)
 
SC_DLLPUBLIC void DataFormPutData (SCROW nCurrentRow, SCROW nStartRow, SCCOL nStartCol, SCROW nEndRow, SCCOL nEndCol, std::vector< std::unique_ptr< ScDataFormFragment > > &rEdits, sal_uInt16 aColLength)
 
void UpdateSelectionArea (const ScMarkData &rSel, ScPatternAttr *pAttr=nullptr)
 
void OnLOKInsertDeleteColumn (SCCOL nStartCol, tools::Long nOffset)
 
void OnLOKInsertDeleteRow (SCROW nStartRow, tools::Long nOffset)
 
void OnLOKSetWidthOrHeight (SCCOLROW nStart, bool bWidth)
 
- Public Member Functions inherited from ScTabView
 ScTabView (const ScTabView &)=delete
 make noncopyable More...
 
const ScTabViewoperator= (const ScTabView &)=delete
 
 ScTabView (vcl::Window *pParent, ScDocShell &rDocSh, ScTabViewShell *pViewShell)
 
 ~ScTabView ()
 
void MakeDrawLayer ()
 
void HideListBox ()
 
bool HasHintWindow () const
 
void RemoveHintWindow ()
 
void TestHintWindow ()
 
 DECL_LINK (TabBarResize, ::TabBar *, void)
 
void SetTabBarWidth (tools::Long nNewWidth)
 Sets an absolute tab bar width (in pixels). More...
 
SC_DLLPUBLIC void SetRelTabBarWidth (double fRelTabBarWidth)
 Sets a relative tab bar width. More...
 
void SetPendingRelTabBarWidth (double fRelTabBarWidth)
 Sets a relative tab bar width. More...
 
tools::Long GetTabBarWidth () const
 Returns the current tab bar width in pixels. More...
 
double GetPendingRelTabBarWidth () const
 Returns the pending tab bar width relative to the frame window width (0.0 ... 1.0). More...
 
void DoResize (const Point &rOffset, const Size &rSize, bool bInner=false)
 
void RepeatResize (bool bUpdateFix=true)
 
void UpdateFixPos ()
 
Point GetGridOffset () const
 
bool IsDrawSelMode () const
 
void SetDrawSelMode (bool bNew)
 
void SetDrawFuncPtr (FuPoor *pFuncPtr)
 
void SetDrawFuncOldPtr (FuPoor *pFuncPtr)
 
FuPoorGetDrawFuncPtr ()
 
FuPoorGetDrawFuncOldPtr ()
 
void DrawDeselectAll ()
 
void DrawMarkListHasChanged ()
 
void UpdateAnchorHandles ()
 
ScPageBreakDataGetPageBreakData ()
 
const std::vector< ScHighlightEntry > & GetHighlightRanges () const
 
void UpdatePageBreakData (bool bForcePaint=false)
 
ScViewDataGetViewData ()
 
const ScViewDataGetViewData () const
 
ScViewFunctionSetGetFunctionSet ()
 
ScViewSelectionEngineGetSelEngine ()
 
bool SelMouseButtonDown (const MouseEvent &rMEvt)
 
ScDrawViewGetScDrawView ()
 
bool IsMinimized () const
 
void TabChanged (bool bSameTabButMoved=false)
 Called after moving, copying, inserting or deleting a sheet. More...
 
void SetZoom (const Fraction &rNewX, const Fraction &rNewY, bool bAll)
 
SC_DLLPUBLIC void RefreshZoom ()
 
void SetPagebreakMode (bool bSet)
 
void UpdateLayerLocks ()
 
void UpdateDrawTextOutliner ()
 
void DigitLanguageChanged ()
 
void InitRefMode (SCCOL nCurX, SCROW nCurY, SCTAB nCurZ, ScRefType eType)
 
void DoneRefMode (bool bContinue=false)
 
void UpdateRef (SCCOL nCurX, SCROW nCurY, SCTAB nCurZ)
 
void StopRefMode ()
 
void StopMarking ()
 
void FakeButtonUp (ScSplitPos eWhich)
 
ScGridWindowGetActiveWin ()
 
vcl::WindowGetWindowByPos (ScSplitPos ePos) const
 
ScSplitPos FindWindow (const vcl::Window *pWindow) const
 
void SetActivePointer (PointerStyle nPointer)
 
void ActiveGrabFocus ()
 
void ClickCursor (SCCOL nPosX, SCROW nPosY, bool bControl)
 
SC_DLLPUBLIC void SetCursor (SCCOL nPosX, SCROW nPosY, bool bNew=false)
 
SC_DLLPUBLIC void CellContentChanged ()
 
void SelectionChanged (bool bFromPaste=false)
 
void CursorPosChanged ()
 
void UpdateInputContext ()
 
void CheckSelectionTransfer ()
 
void InvertHorizontal (ScVSplitPos eWhich, tools::Long nDragPos)
 
void InvertVertical (ScHSplitPos eWhich, tools::Long nDragPos)
 
Point GetInsertPos () const
 
Point GetChartInsertPos (const Size &rSize, const ScRange &rCellRange)
 
Point GetChartDialogPos (const Size &rDialogSize, const tools::Rectangle &rLogicChart)
 
void UpdateAutoFillMark (bool bFromPaste=false)
 
void ShowCursor ()
 
void HideAllCursors ()
 
void ShowAllCursors ()
 
void AlignToCursor (SCCOL nCurX, SCROW nCurY, ScFollowMode eMode, const ScSplitPos *pWhich=nullptr)
 
SvxZoomType GetZoomType () const
 
void SetZoomType (SvxZoomType eNew, bool bAll)
 
sal_uInt16 CalcZoom (SvxZoomType eType, sal_uInt16 nOldZoom)
 
bool HasPageFieldDataAtCursor () const
 
void StartDataSelect ()
 
SC_DLLPUBLIC void MoveCursorAbs (SCCOL nCurX, SCROW nCurY, ScFollowMode eMode, bool bShift, bool bControl, bool bKeepOld=false, bool bKeepSel=false)
 
void MoveCursorRel (SCCOL nMovX, SCROW nMovY, ScFollowMode eMode, bool bShift, bool bKeepSel=false)
 
void MoveCursorPage (SCCOL nMovX, SCROW nMovY, ScFollowMode eMode, bool bShift, bool bKeepSel=false)
 
void MoveCursorArea (SCCOL nMovX, SCROW nMovY, ScFollowMode eMode, bool bShift, bool bKeepSel=false, bool bInteractiveByUser=false)
 
void MoveCursorEnd (SCCOL nMovX, SCROW nMovY, ScFollowMode eMode, bool bShift, bool bKeepSel=false)
 
void MoveCursorScreen (SCCOL nMovX, SCROW nMovY, ScFollowMode eMode, bool bShift)
 
void MoveCursorEnter (bool bShift)
 
bool MoveCursorKeyInput (const KeyEvent &rKeyEvent)
 
void FindNextUnprot (bool bShift, bool bInSelection)
 
void GetPageMoveEndPosition (SCCOL nMovX, SCROW nMovY, SCCOL &rPageX, SCROW &rPageY)
 
SC_DLLPUBLIC void SetTabNo (SCTAB nTab, bool bNew=false, bool bExtendSelection=false, bool bSameTabButMoved=false)
 
void SelectNextTab (short nDir, bool bExtendSelection)
 
void SelectTabPage (const sal_uInt16 nTab)
 
void ActivateView (bool bActivate, bool bFirst)
 
void ActivatePart (ScSplitPos eWhich)
 
bool IsInActivatePart () const
 
void SetTimer (ScGridWindow *pWin, const MouseEvent &rMEvt)
 
void ResetTimer ()
 
void ScrollX (tools::Long nDeltaX, ScHSplitPos eWhich, bool bUpdBars=true)
 
void ScrollY (tools::Long nDeltaY, ScVSplitPos eWhich, bool bUpdBars=true)
 
SC_DLLPUBLIC void ScrollLines (tools::Long nDeltaX, tools::Long nDeltaY)
 
bool ScrollCommand (const CommandEvent &rCEvt, ScSplitPos ePos)
 
bool GestureZoomCommand (const CommandEvent &rCEvt)
 
void ScrollToObject (const SdrObject *pDrawObj)
 
void MakeVisible (const tools::Rectangle &rHMMRect)
 
void PaintArea (SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, ScUpdateMode eMode=ScUpdateMode::All)
 
void PaintGrid ()
 
void PaintTopArea (SCCOL nStartCol, SCCOL nEndCol)
 
void PaintTop ()
 
void PaintLeftArea (SCROW nStartRow, SCROW nEndRow)
 
void PaintLeft ()
 
bool PaintExtras ()
 
void RecalcPPT ()
 
void CreateAnchorHandles (SdrHdlList &rHdl, const ScAddress &rAddress)
 
void UpdateCopySourceOverlay ()
 
void UpdateSelectionOverlay ()
 
void UpdateShrinkOverlay ()
 
void UpdateAllOverlays ()
 
void UpdateFormulas (SCCOL nStartCol=-1, SCROW nStartRow=-1, SCCOL nEndCol=-1, SCROW nEndRow=-1)
 
void InterpretVisible ()
 
void CheckNeedsRepaint ()
 
bool NeedsRepaint ()
 
void PaintRangeFinder (tools::Long nNumber)
 
void AddHighlightRange (const ScRange &rRange, const Color &rColor)
 
void ClearHighlightRanges ()
 
void DoChartSelection (const css::uno::Sequence< css::chart2::data::HighlightedRange > &rHilightRanges)
 
void DoDPFieldPopup (std::u16string_view rPivotTableName, sal_Int32 nDimensionIndex, Point aPoint, Size aSize)
 
tools::Long GetGridWidth (ScHSplitPos eWhich)
 
tools::Long GetGridHeight (ScVSplitPos eWhich)
 
void UpdateScrollBars (HeaderType eHeaderType=BOTH_HEADERS)
 
void SetNewVisArea ()
 
void SetTabProtectionSymbol (SCTAB nTab, const bool bProtect)
 
void InvalidateAttribs ()
 
void OnLibreOfficeKitTabChanged ()
 
void AddWindowToForeignEditView (SfxViewShell *pViewShell, ScSplitPos eWhich)
 
void RemoveWindowFromForeignEditView (SfxViewShell *pViewShell, ScSplitPos eWhich)
 
void MakeEditView (ScEditEngineDefaulter *pEngine, SCCOL nCol, SCROW nRow)
 
void KillEditView (bool bNoPaint)
 
void UpdateEditView ()
 
void SelectAll (bool bContinue=false)
 
void SelectAllTables ()
 
void DeselectAllTables ()
 
void MarkCursor (SCCOL nCurX, SCROW nCurY, SCTAB nCurZ, bool bCols=false, bool bRows=false, bool bCellSelection=false)
 
void InitBlockMode (SCCOL nCurX, SCROW nCurY, SCTAB nCurZ, bool bTestNeg=false, bool bCols=false, bool bRows=false, bool bForceNeg=false)
 
void InitOwnBlockMode (const ScRange &rMarkRange)
 
void DoneBlockMode (bool bContinue=false)
 
bool IsBlockMode () const
 
void ExpandBlock (SCCOL nMovX, SCROW nMovY, ScFollowMode eMode)
 
void ExpandBlockPage (SCCOL nMovX, SCROW nMovY)
 
void ExpandBlockArea (SCCOL nMovX, SCROW nMovY)
 
void MarkColumns ()
 
void MarkRows ()
 
void MarkColumns (SCCOL nCol, sal_Int16 nModifier)
 Called to select the specified full column. More...
 
void MarkRows (SCROW nRow, sal_Int16 nModifier)
 Called to select the specified full row. More...
 
void MarkDataArea (bool bIncludeCursor=true)
 
void MarkMatrixFormula ()
 
void Unmark ()
 
void MarkRange (const ScRange &rRange, bool bSetCursor=true, bool bContinue=false)
 
bool IsMarking (SCCOL nCol, SCROW nRow, SCTAB nTab) const
 
void PaintMarks (SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow)
 
void PaintBlock (bool bReset)
 divide PaintBlock into two methods: RepaintBlock and RemoveBlock or similar More...
 
void SetMarkData (const ScMarkData &rNew)
 
void MarkDataChanged ()
 
void LockModifiers (sal_uInt16 nModifiers)
 
sal_uInt16 GetLockedModifiers () const
 
void ViewOptionsHasChanged (bool bHScrollChanged, bool bGraphicsChanged)
 
Point GetMousePosPixel ()
 
void FreezeSplitters (bool bFreeze, SplitMethod eSplitMethod=SC_SPLIT_METHOD_CURSOR, SCCOLROW nFreezeIndex=-1)
 
void RemoveSplit ()
 
void SplitAtCursor ()
 
void SplitAtPixel (const Point &rPixel)
 
void InvalidateSplit ()
 
void ErrorMessage (TranslateId pGlobStrId)
 
void EnableRefInput (bool bFlag)
 
vcl::WindowGetFrameWin () const
 
bool HasPaintBrush () const
 
ScDocumentGetBrushDocument () const
 
SfxItemSetGetDrawBrushSet () const
 
bool IsPaintBrushLocked () const
 
void SetBrushDocument (ScDocumentUniquePtr pNew, bool bLock)
 
void SetDrawBrushSet (std::unique_ptr< SfxItemSet > pNew, bool bLock)
 
void ResetBrushDocument ()
 
void EnableAutoSpell (bool bEnable)
 
void ResetAutoSpell ()
 
void ResetAutoSpellForContentChange ()
 
void SetAutoSpellData (SCCOL nPosX, SCROW nPosY, const std::vector< editeng::MisspellRanges > *pRanges)
 
void getRowColumnHeaders (const tools::Rectangle &rRectangle, tools::JsonWriter &rJsonWriter)
 
OString getSheetGeometryData (bool bColumns, bool bRows, bool bSizes, bool bHidden, bool bFiltered, bool bGroups)
 
void extendTiledAreaIfNeeded ()
 
SCROW GetLOKStartHeaderRow () const
 
SCROW GetLOKEndHeaderRow () const
 
SCCOL GetLOKStartHeaderCol () const
 
SCCOL GetLOKEndHeaderCol () const
 

Static Public Member Functions

static sal_uInt16 DoUpdateCharts (const ScAddress &rPos, ScDocument &rDoc, bool bAllCharts)
 
- Static Public Member Functions inherited from ScTabView
static SC_DLLPUBLIC double GetRelTabBarWidth ()
 Returns the current tab bar width relative to the frame window width (0.0 ... 1.0). More...
 
static void UpdateInputLine ()
 
static void OnLOKNoteStateChanged (const ScPostIt *pNote)
 

Private Member Functions

void GetSelectedMemberList (ScDPUniqueStringSet &rEntries, tools::Long &rDimension)
 
 DECL_STATIC_LINK (ScDBFunc, InstallLOKNotifierHdl, void *, vcl::ILibreOfficeKitNotifier *)
 

Static Private Member Functions

static void ModifiedAutoFilter (ScDocShell *pDocSh)
 
static void ApplyAutoFilter (ScDocShell *pDocSh, ScViewData *pViewData, ScDBData *pDBData, SCCOL nCol, SCROW nRow, SCTAB nTab, ScQueryParam aParam)
 

Additional Inherited Members

- Public Types inherited from ScTabView
enum  SplitMethod {
  SC_SPLIT_METHOD_COL ,
  SC_SPLIT_METHOD_ROW ,
  SC_SPLIT_METHOD_CURSOR
}
 
- Protected Member Functions inherited from ScTabView
void UpdateHeaderWidth (const ScVSplitPos *pWhich=nullptr, const SCROW *pPosY=nullptr)
 
void HideTip ()
 
void ShowRefTip ()
 
void ZoomChanged ()
 
void UpdateShow ()
 
bool UpdateVisibleRange ()
 
void GetBorderSize (SvBorder &rBorder, const Size &rSize)
 
void ResetDrawDragMode ()
 
bool IsDrawTextEdit () const
 
void DrawEnableAnim (bool bSet)
 
void MakeDrawView (TriState nForceDesignMode)
 
void HideNoteMarker ()
 
void UpdateIMap (SdrObject *pObj)
 
- Static Protected Member Functions inherited from ScViewFunc
static void UpdateLineAttrs (::editeng::SvxBorderLine &rLine, const ::editeng::SvxBorderLine *pDestLine, const ::editeng::SvxBorderLine *pSrcLine, bool bColor)
 

Detailed Description

Definition at line 34 of file dbfunc.hxx.

Constructor & Destructor Documentation

◆ ScDBFunc()

ScDBFunc::ScDBFunc ( vcl::Window pParent,
ScDocShell rDocSh,
ScTabViewShell pViewShell 
)

Definition at line 43 of file dbfunc.cxx.

◆ ~ScDBFunc()

ScDBFunc::~ScDBFunc ( )
virtual

Definition at line 48 of file dbfunc.cxx.

Member Function Documentation

◆ ApplyAutoFilter()

void ScDBFunc::ApplyAutoFilter ( ScDocShell pDocSh,
ScViewData pViewData,
ScDBData pDBData,
SCCOL  nCol,
SCROW  nRow,
SCTAB  nTab,
ScQueryParam  aParam 
)
staticprivate

◆ AutoOutline()

void ScDBFunc::AutoOutline ( )

◆ Consolidate()

void ScDBFunc::Consolidate ( const ScConsolidateParam rParam)

◆ DataPilotInput()

void ScDBFunc::DataPilotInput ( const ScAddress rPos,
const OUString &  rString 
)

◆ DataPilotMove()

bool ScDBFunc::DataPilotMove ( const ScRange rSource,
const ScAddress rDest 
)

◆ DataPilotSort()

void ScDBFunc::DataPilotSort ( ScDPObject pDPObject,
tools::Long  nDimIndex,
bool  bAscending,
const sal_uInt16 *  pUserListId = nullptr 
)

◆ DateGroupDataPilot()

void ScDBFunc::DateGroupDataPilot ( const ScDPNumGroupInfo rInfo,
sal_Int32  nParts 
)

◆ DECL_STATIC_LINK()

ScDBFunc::DECL_STATIC_LINK ( ScDBFunc  ,
InstallLOKNotifierHdl  ,
void *  ,
vcl::ILibreOfficeKitNotifier  
)
private

References Query.

◆ DeletePivotTable()

void ScDBFunc::DeletePivotTable ( )

◆ DoSubTotals()

void ScDBFunc::DoSubTotals ( const ScSubTotalParam rParam,
bool  bRecord = true,
const ScSortParam pForceNewSort = nullptr 
)

Definition at line 431 of file dbfunc3.cxx.

References SfxUndoManager::AddUndoAction(), ALL, ScSubTotalParam::bDoSort, ScSubTotalParam::bRemoveOnly, ScSubTotalParam::bReplace, ScDocument::CompileDBFormula(), ScDocument::CopyToDocument(), Application::CreateMessageDialog(), ScTabView::DoneBlockMode(), ScDocument::DoSubTotals(), ScDBCollection::empty(), ScRangeName::empty(), ScTabView::ErrorMessage(), FORMULA, ScOutlineTable::GetColArray(), ScDocument::GetDBAtArea(), ScDocument::GetDBCollection(), ScOutlineArray::GetDepth(), ScViewData::GetDocShell(), ScDocShell::GetDocument(), ScViewData::GetMarkData(), ScEditableTester::GetMessageId(), ScDocument::GetOutlineTable(), ScOutlineArray::GetRange(), ScDocument::GetRangeName(), ScOutlineTable::GetRowArray(), ScDBData::GetSortParam(), ScDocument::GetTableCount(), ScViewData::GetTabNo(), ScDocShell::GetUndoManager(), ScTabView::GetViewData(), Grid, ScDocument::HasAttrib(), i, ScTabView::InitOwnBlockMode(), ScEditableTester::IsEditable(), ScDocument::IsUndoEnabled(), Left, ScTabView::MarkDataChanged(), ScDocument::MaxCol(), ScDocument::MaxRow(), Merged, ScSubTotalParam::nCol1, ScSubTotalParam::nCol2, NONE, ScSubTotalParam::nRow1, ScSubTotalParam::nRow2, Overlapped, ScDocShell::PostPaint(), pOut, ScOutlineArray::Remove(), ScDocument::RemoveSubTotals(), RET_YES, SCDOCMODE_UNDO, ScResId(), ScTabView::SelectionChanged(), ScDBData::SetArea(), ScDocument::SetDirty(), ScDocShellModificator::SetDocumentModified(), ScMarkData::SetMarkArea(), ScDBData::SetSubTotalParam(), Size, Sort(), ScDocument::TestRemoveSubTotals(), and Top.

Referenced by ScCellShell::ExecuteSubtotals(), ScUndoSubTotals::Redo(), RepeatDB(), and UISort().

◆ DoUpdateCharts()

sal_uInt16 ScDBFunc::DoUpdateCharts ( const ScAddress rPos,
ScDocument rDoc,
bool  bAllCharts 
)
static

◆ GetAnonymousDBData()

ScDBData * ScDBFunc::GetAnonymousDBData ( )

◆ GetDBData()

ScDBData * ScDBFunc::GetDBData ( bool  bMarkArea = true,
ScGetDBMode  eMode = SC_DB_MAKE,
ScGetDBSelection  eSel = ScGetDBSelection::Keep 
)

◆ GetSelectedMemberList()

void ScDBFunc::GetSelectedMemberList ( ScDPUniqueStringSet rEntries,
tools::Long rDimension 
)
private

◆ GotoDBArea()

void ScDBFunc::GotoDBArea ( const OUString &  rDBName)

◆ GroupDataPilot()

void ScDBFunc::GroupDataPilot ( )

◆ HasSelectionForDateGroup()

bool ScDBFunc::HasSelectionForDateGroup ( ScDPNumGroupInfo rOldInfo,
sal_Int32 &  rParts 
)

◆ HasSelectionForDrillDown()

bool ScDBFunc::HasSelectionForDrillDown ( css::sheet::DataPilotFieldOrientation &  rOrientation)

◆ HasSelectionForNumGroup()

bool ScDBFunc::HasSelectionForNumGroup ( ScDPNumGroupInfo rOldInfo)

◆ HideAutoFilter()

void ScDBFunc::HideAutoFilter ( )

◆ HideMarkedOutlines()

void ScDBFunc::HideMarkedOutlines ( bool  bRecord = true)

◆ HideOutline()

void ScDBFunc::HideOutline ( bool  bColumns,
sal_uInt16  nLevel,
sal_uInt16  nEntry,
bool  bRecord = true,
bool  bPaint = true 
)

◆ ImportData()

bool ScDBFunc::ImportData ( const ScImportParam rParam)

◆ MakeOutline()

void ScDBFunc::MakeOutline ( bool  bColumns,
bool  bRecord = true 
)

◆ MakePivotTable()

bool ScDBFunc::MakePivotTable ( const ScDPSaveData rData,
const ScRange rDest,
bool  bNewTable,
const ScDPObject rSource 
)

◆ ModifiedAutoFilter()

void ScDBFunc::ModifiedAutoFilter ( ScDocShell pDocSh)
staticprivate

◆ NumGroupDataPilot()

void ScDBFunc::NumGroupDataPilot ( const ScDPNumGroupInfo rInfo)

◆ OnLOKShowHideColRow()

void ScDBFunc::OnLOKShowHideColRow ( bool  bColumns,
SCCOLROW  nStartRow 
)

◆ OutlinePossible()

bool ScDBFunc::OutlinePossible ( bool  bHide)

◆ Query()

void ScDBFunc::Query ( const ScQueryParam rQueryParam,
const ScRange pAdvSource,
bool  bRecord 
)

◆ RecalcPivotTable()

void ScDBFunc::RecalcPivotTable ( )

◆ RemoveAllOutlines()

void ScDBFunc::RemoveAllOutlines ( bool  bRecord = true)

◆ RemoveOutline()

void ScDBFunc::RemoveOutline ( bool  bColumns,
bool  bRecord = true 
)

◆ RepeatDB()

void ScDBFunc::RepeatDB ( bool  bRecord = true)

◆ SelectLevel()

void ScDBFunc::SelectLevel ( bool  bColumns,
sal_uInt16  nLevel,
bool  bRecord = true 
)

◆ SetDataPilotDetails()

void ScDBFunc::SetDataPilotDetails ( bool  bShow,
const OUString *  pNewDimensionName = nullptr 
)

◆ SetOutlineState()

void ScDBFunc::SetOutlineState ( bool  bColumn,
sal_uInt16  nLevel,
sal_uInt16  nEntry,
bool  bHidden 
)

Definition at line 253 of file dbfunc3.cxx.

References HideOutline(), SelectLevel(), and ShowOutline().

Referenced by ScModelObj::setOutlineState().

◆ ShowDataPilotSourceData()

void ScDBFunc::ShowDataPilotSourceData ( ScDPObject rDPObj,
const css::uno::Sequence< css::sheet::DataPilotFieldFilter > &  rFilters 
)

◆ ShowMarkedOutlines()

void ScDBFunc::ShowMarkedOutlines ( bool  bRecord = true)

◆ ShowOutline()

void ScDBFunc::ShowOutline ( bool  bColumns,
sal_uInt16  nLevel,
sal_uInt16  nEntry,
bool  bRecord = true,
bool  bPaint = true 
)

◆ Sort()

void ScDBFunc::Sort ( const ScSortParam rSortParam,
bool  bRecord = true,
bool  bPaint = true 
)

◆ TestRemoveOutline()

void ScDBFunc::TestRemoveOutline ( bool &  rCol,
bool &  rRow 
)

◆ ToggleAutoFilter()

void ScDBFunc::ToggleAutoFilter ( )

◆ UISort()

void ScDBFunc::UISort ( const ScSortParam rSortParam)

◆ UngroupDataPilot()

void ScDBFunc::UngroupDataPilot ( )

◆ UpdateCharts()

void ScDBFunc::UpdateCharts ( bool  bAllCharts)

The documentation for this class was generated from the following files: