LibreOffice Module sc (master) 1
|
#include <dbfunc.hxx>
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) |
ScDBData * | GetDBData (bool bMarkArea=true, ScGetDBMode eMode=SC_DB_MAKE, ScGetDBSelection eSel=ScGetDBSelection::Keep) |
ScDBData * | GetAnonymousDBData () |
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 ScPatternAttr * | GetSelectionPattern () |
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< ScTransferObj > | CopyToTransferable () |
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 SfxStyleSheet * | GetStyleSheetFromMarked () |
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) |
ScAutoFormatData * | CreateAutoFormatData () |
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 ScTabView & | operator= (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) |
FuPoor * | GetDrawFuncPtr () |
FuPoor * | GetDrawFuncOldPtr () |
void | DrawDeselectAll () |
void | DrawMarkListHasChanged () |
void | UpdateAnchorHandles () |
ScPageBreakData * | GetPageBreakData () |
const std::vector< ScHighlightEntry > & | GetHighlightRanges () const |
void | UpdatePageBreakData (bool bForcePaint=false) |
ScViewData & | GetViewData () |
const ScViewData & | GetViewData () const |
ScViewFunctionSet & | GetFunctionSet () |
ScViewSelectionEngine * | GetSelEngine () |
bool | SelMouseButtonDown (const MouseEvent &rMEvt) |
ScDrawView * | GetScDrawView () |
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) |
ScGridWindow * | GetActiveWin () |
vcl::Window * | GetWindowByPos (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::Window * | GetFrameWin () const |
bool | HasPaintBrush () const |
ScDocument * | GetBrushDocument () const |
SfxItemSet * | GetDrawBrushSet () 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) |
Definition at line 34 of file dbfunc.hxx.
ScDBFunc::ScDBFunc | ( | vcl::Window * | pParent, |
ScDocShell & | rDocSh, | ||
ScTabViewShell * | pViewShell | ||
) |
Definition at line 43 of file dbfunc.cxx.
|
virtual |
Definition at line 48 of file dbfunc.cxx.
|
staticprivate |
Definition at line 380 of file dbfunc.cxx.
References SfxUndoManager::AddUndoAction(), ScDocument::ApplyAttr(), ATTR_MERGE_FLAG(), Auto, ScDBData::GetArea(), ScDocument::GetAttr(), ScViewData::GetDocument(), ScDBData::GetName(), ScDocShell::GetUndoManager(), Grid, ModifiedAutoFilter(), ScQueryParamTable::nCol1, ScQueryParamTable::nCol2, ScDocShell::PostPaint(), and ScDBData::SetAutoFilter().
Referenced by ToggleAutoFilter().
void ScDBFunc::AutoOutline | ( | ) |
Definition at line 214 of file dbfunc3.cxx.
References ScOutlineDocFunc::AutoOutline(), ScViewData::GetDocShell(), ScViewData::GetDocument(), ScViewData::GetMarkData(), ScMarkData::GetMultiMarkArea(), ScViewData::GetTabNo(), ScTabView::GetViewData(), ScMarkData::IsMarked(), ScMarkData::IsMultiMarked(), ScMarkData::MarkToMulti(), ScDocument::MaxCol(), and ScDocument::MaxRow().
Referenced by ScTabViewShell::Execute().
void ScDBFunc::Consolidate | ( | const ScConsolidateParam & | rParam | ) |
Definition at line 606 of file dbfunc3.cxx.
References ScDocShell::DoConsolidate(), ScViewData::GetDocShell(), ScTabView::GetViewData(), ScConsolidateParam::nTab, and ScTabView::SetTabNo().
Referenced by ScCellShell::ExecuteEdit().
void ScDBFunc::DataPilotInput | ( | const ScAddress & | rPos, |
const OUString & | rString | ||
) |
ignore case?
Definition at line 1380 of file dbfunc3.cxx.
References aData, ScDPSaveGroupItem::AddElement(), ScDPSaveGroupDimension::AddGroupItem(), AUTO, ScDPObject::BuildAllDimensionMembers(), ScAddress::Col(), ScTabView::ErrorMessage(), ScDPObject::GetDimName(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScDocument::GetDPCollection(), ScDPSaveDimension::GetExistingMemberByName(), ScDPObject::GetHeaderDim(), ScDPObject::GetHeaderPositionData(), ScDPSaveMember::GetLayoutName(), ScDPSaveMember::GetName(), ScDPSaveDimension::GetName(), ScDPSaveGroupDimension::GetNamedGroup(), ScDPSaveGroupDimension::GetNamedGroupAcc(), ScDPDimensionSaveData::GetNamedGroupDimAcc(), ScDPObject::GetSaveData(), ScDocument::GetString(), ScDPSaveDimension::GetSubTotalFunc(), ScDPSaveDimension::GetSubTotalsCount(), ScTabView::GetViewData(), ScDPObject::IsDataDescriptionCell(), ScDPObject::IsDimNameInUse(), ScDPSaveDimension::IsMemberNameInUse(), lcl_replaceMemberNameInSubtotal(), ScDPCollection::ReloadGroupsInCache(), ScDPSaveMember::RemoveLayoutName(), ScDPSaveDimension::RemoveLayoutName(), ScDPSaveGroupItem::Rename(), ScDPSaveGroupDimension::Rename(), ScAddress::Row(), ScDPSaveMember::SetLayoutName(), ScDPSaveDimension::SetLayoutName(), ScDPSaveMember::SetName(), ScDPSaveDimension::SetName(), ScDPObject::SetSaveData(), ScDPSaveDimension::SetSubtotalName(), ScAddress::Tab(), and ScDBDocFunc::UpdatePivotTable().
Referenced by ScInputHandler::EnterHandler().
bApi for drag&drop?
Definition at line 1817 of file dbfunc3.cxx.
References aData, ScRange::aEnd, ScRange::aStart, ScAddress::Col(), ScDBDocFunc::DataPilotUpdate(), ScDPObject::GetDimName(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScDPObject::GetHeaderPositionData(), ScDPObject::GetMemberNames(), ScDPObject::GetSaveData(), ScTabView::GetViewData(), lcl_MoveToEnd(), ScAddress::Row(), ScDPSaveDimension::SetSortInfo(), ScAddress::Tab(), and ScTabView::Unmark().
Referenced by ScGridWindow::DropTransferObj(), and ScClipUtil::PasteFromClipboard().
void ScDBFunc::DataPilotSort | ( | ScDPObject * | pDPObject, |
tools::Long | nDimIndex, | ||
bool | bAscending, | ||
const sal_uInt16 * | pUserListId = nullptr |
||
) |
Definition at line 1691 of file dbfunc3.cxx.
References ScDPSaveDimension::AddMember(), ScDPObject::BuildAllDimensionMembers(), ScDBDocFunc::DataPilotUpdate(), ScGlobal::GetCollator(), ScDPSaveData::GetDimensionByName(), ScDPObject::GetDimName(), ScDPSaveDimension::GetExistingMemberByName(), ScDPSaveDimension::GetMembers(), ScDPObject::GetSaveData(), ScUserListData::GetSubCount(), ScUserListData::GetSubStr(), ScGlobal::GetUserList(), ScTabView::GetViewData(), i, n, ScDPSaveDimension::SetSortInfo(), and ScUserList::size().
void ScDBFunc::DateGroupDataPilot | ( | const ScDPNumGroupInfo & | rInfo, |
sal_Int32 | nParts | ||
) |
before (immediate) base
Definition at line 987 of file dbfunc3.cxx.
References aData, ScDPDimensionSaveData::AddGroupDimension(), ScDPDimensionSaveData::AddNumGroupDimension(), aEntries, ScDPDimensionSaveData::CreateDateGroupDimName(), ScDPObject::GetDimName(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScDPDimensionSaveData::GetNamedGroupDim(), ScDPSaveDimension::GetOrientation(), ScDPObject::GetSaveData(), GetSelectedMemberList(), ScTabView::GetViewData(), ScDPNumGroupInfo::mbDateValues, ScDPNumGroupInfo::mfStep, nBit, ScDBDocFunc::RefreshPivotTableGroups(), ScDPSaveGroupDimension::SetDateInfo(), ScDPSaveDimension::SetOrientation(), ScDPObject::SetSaveData(), and ScTabView::Unmark().
Referenced by ScCellShell::ExecuteEdit(), and UngroupDataPilot().
|
private |
References Query.
void ScDBFunc::DeletePivotTable | ( | ) |
Definition at line 706 of file dbfunc3.cxx.
References ScTabView::CursorPosChanged(), ScTabView::ErrorMessage(), ScViewData::GetDocShell(), ScDocShell::GetDocument(), ScDocument::GetDPAtCursor(), ScTabView::GetViewData(), and ScDBDocFunc::RemovePivotTable().
Referenced by ScPivotShell::Execute().
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().
|
static |
Definition at line 31 of file dbfunc4.cxx.
References aName, ScRangeList::Contains(), ScDocument::GetDrawLayer(), ScDocument::GetOldChartParameters(), SdrModel::GetPage(), SdrModel::GetPageCount(), ScDocument::IsChart(), SdrObjListIter::Next(), pObject, and ScDocument::UpdateChart().
Referenced by ScModule::ModifyOptions(), and UpdateCharts().
ScDBData * ScDBFunc::GetAnonymousDBData | ( | ) |
Definition at line 156 of file dbfunc.cxx.
References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), ScDocShell::GetAnonymousDBData(), ScDocument::GetDataArea(), ScViewData::GetDocShell(), ScDocShell::GetDocument(), ScViewData::GetMarkData(), ScViewData::GetSimpleArea(), ScTabView::GetViewData(), ScMarkData::IsMarked(), ScMarkData::IsMultiMarked(), ScAddress::Row(), SC_MARK_SIMPLE, SC_MARK_SIMPLE_FILTERED, ScAddress::SetCol(), ScAddress::SetRow(), and ScAddress::Tab().
Referenced by ScCellShell::ExecuteSubtotals().
ScDBData * ScDBFunc::GetDBData | ( | bool | bMarkArea = true , |
ScGetDBMode | eMode = SC_DB_MAKE , |
||
ScGetDBSelection | eSel = ScGetDBSelection::Keep |
||
) |
Definition at line 81 of file dbfunc.cxx.
References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), eMode, ScDocShell::GetDBData(), ScViewData::GetDocShell(), ScDocShell::GetDocument(), ScViewData::GetMarkData(), ScViewData::GetSimpleArea(), ScTabView::GetViewData(), ScMarkData::IsMarked(), ScMarkData::IsMultiMarked(), Keep, ScTabView::MarkRange(), pData, ScAddress::Row(), RowDown, SC_DB_OLD, SC_MARK_SIMPLE, SC_MARK_SIMPLE_FILTERED, ScAddress::SetCol(), ScAddress::SetRow(), ShrinkToUsedData, ScDocument::ShrinkToUsedDataArea(), and ScAddress::Tab().
Referenced by ScDispatch::addStatusListener(), ScTabViewShell::CreateRefDialogController(), ScCellShell::ExecuteDataPilotDialog(), ScCellShell::ExecuteDB(), ScCellShell::ExecuteSubtotals(), ScCellShell::GetDBState(), HideAutoFilter(), lcl_GetSortParam(), ScUndoImportData::Repeat(), RepeatDB(), ScDispatch::selectionChanged(), and ToggleAutoFilter().
|
private |
Definition at line 744 of file dbfunc3.cxx.
References aData, ScRange::aEnd, ScRange::aStart, ScAddress::Col(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScDPObject::GetHeaderPositionData(), ScViewData::GetMultiArea(), ScTabView::GetViewData(), ScAddress::Row(), and ScAddress::Tab().
Referenced by DateGroupDataPilot(), GroupDataPilot(), HasSelectionForDateGroup(), HasSelectionForDrillDown(), HasSelectionForNumGroup(), NumGroupDataPilot(), SetDataPilotDetails(), and UngroupDataPilot().
void ScDBFunc::GotoDBArea | ( | const OUString & | rDBName | ) |
Definition at line 54 of file dbfunc.cxx.
References ScTabView::DoneBlockMode(), ScDBCollection::NamedDBs::findByUpperName(), ScGlobal::getCharClass(), ScDocument::GetDBCollection(), ScViewData::GetDocument(), ScDBCollection::getNamedDBs(), ScTabView::GetViewData(), ScTabView::InitBlockMode(), ScTabView::MarkCursor(), ScTabView::MoveCursorAbs(), pData, SC_FOLLOW_JUMP, ScTabView::SelectionChanged(), and ScTabView::SetTabNo().
Referenced by ScCellShell::ExecuteDB().
void ScDBFunc::GroupDataPilot | ( | ) |
Also do this when removing groups? Handle this case dynamically with automatic groups?
before (immediate) base
Definition at line 1127 of file dbfunc3.cxx.
References aData, ScDPSaveGroupItem::AddElement(), ScDPSaveGroupItem::AddElementsFromGroup(), ScDPDimensionSaveData::AddGroupDimension(), ScDPSaveGroupDimension::AddGroupItem(), aEntries, aEntryName, ScDPDimensionSaveData::CreateGroupDimName(), ScDPSaveGroupDimension::CreateGroupName(), ScDPObject::GetDimName(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScDPSaveGroupDimension::GetGroupByIndex(), ScDPSaveGroupDimension::GetGroupCount(), ScDPDimensionSaveData::GetGroupDimAccForBase(), ScDPSaveGroupDimension::GetGroupDimName(), ScDPSaveGroupItem::GetGroupName(), ScDPSaveGroupDimension::GetNamedGroup(), ScDPDimensionSaveData::GetNamedGroupDim(), ScDPSaveDimension::GetOrientation(), ScDPObject::GetSaveData(), GetSelectedMemberList(), ScDPSaveGroupDimension::GetSourceDimName(), ScTabView::GetViewData(), ScDBDocFunc::RefreshPivotTableGroups(), ScDPSaveGroupItem::RemoveElementsFromGroups(), ScDPSaveGroupDimension::RemoveFromGroups(), ScResId(), ScDPSaveDimension::SetOrientation(), ScDPObject::SetSaveData(), and ScTabView::Unmark().
Referenced by ScCellShell::ExecuteEdit().
bool ScDBFunc::HasSelectionForDateGroup | ( | ScDPNumGroupInfo & | rOldInfo, |
sal_Int32 & | rParts | ||
) |
Definition at line 806 of file dbfunc3.cxx.
References ScRange::aEnd, aEntries, ScRange::aStart, ATTR_VALUE_FORMAT(), ScAddress::Col(), ScDPDimensionSaveData::CollectDateParts(), ScDocument::GetAttr(), ScViewData::GetCurX(), ScViewData::GetCurY(), ScDPSaveGroupDimension::GetDateInfo(), ScDPSaveNumGroupDimension::GetDateInfo(), ScDPSaveGroupDimension::GetDatePart(), ScDPSaveNumGroupDimension::GetDatePart(), ScDPObject::GetDimName(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScDPSaveData::GetExistingDimensionData(), ScDocument::GetFormatTable(), ScDPSaveNumGroupDimension::GetInfo(), ScDPDimensionSaveData::GetNamedGroupDim(), ScDPDimensionSaveData::GetNumGroupDim(), ScDPObject::GetSaveData(), GetSelectedMemberList(), ScDPSaveGroupDimension::GetSourceDimName(), ScViewData::GetTabNo(), SvNumberFormatter::GetType(), ScDocument::GetValue(), ScTabView::GetViewData(), ScDocument::HasValueData(), ScDPNumGroupInfo::mbAutoEnd, ScDPNumGroupInfo::mbAutoStart, ScDPNumGroupInfo::mbDateValues, ScDPNumGroupInfo::mfEnd, ScDPNumGroupInfo::mfStart, nIndex, nType, ScAddress::Row(), SC_MARK_SIMPLE, and ScAddress::Tab().
Referenced by ScCellShell::ExecuteEdit().
bool ScDBFunc::HasSelectionForDrillDown | ( | css::sheet::DataPilotFieldOrientation & | rOrientation | ) |
Definition at line 1907 of file dbfunc3.cxx.
References aEntries, ScDPObject::GetDimName(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScDPSaveData::GetExistingDimensionByName(), ScDPSaveData::GetInnermostDimension(), ScDPSaveDimension::GetOrientation(), ScDPObject::GetSaveData(), GetSelectedMemberList(), and ScTabView::GetViewData().
Referenced by ScCellShell::ExecuteEdit(), and ScGridWindow::MouseButtonUp().
bool ScDBFunc::HasSelectionForNumGroup | ( | ScDPNumGroupInfo & | rOldInfo | ) |
Definition at line 919 of file dbfunc3.cxx.
References ScRange::aEnd, aEntries, ScRange::aStart, ScAddress::Col(), ScViewData::GetCurX(), ScViewData::GetCurY(), ScDPObject::GetDimName(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScDPSaveData::GetExistingDimensionData(), ScDPSaveNumGroupDimension::GetInfo(), ScDPDimensionSaveData::GetNamedGroupDim(), ScDPDimensionSaveData::GetNumGroupDim(), ScDPObject::GetSaveData(), GetSelectedMemberList(), ScViewData::GetTabNo(), ScDocument::GetValue(), ScTabView::GetViewData(), ScDocument::HasValueData(), ScDPNumGroupInfo::mbAutoEnd, ScDPNumGroupInfo::mbAutoStart, ScDPNumGroupInfo::mfEnd, ScDPNumGroupInfo::mfStart, ScAddress::Row(), SC_MARK_SIMPLE, and ScAddress::Tab().
Referenced by ScCellShell::ExecuteEdit().
void ScDBFunc::HideAutoFilter | ( | ) |
Definition at line 414 of file dbfunc.cxx.
References SfxUndoManager::AddUndoAction(), ScDocument::ApplyAttr(), ATTR_MERGE_FLAG(), Auto, ScDBData::GetArea(), ScDocument::GetAttr(), ScViewData::GetBindings(), GetDBData(), ScViewData::GetDocShell(), ScDocShell::GetDocument(), ScDBData::GetName(), ScDocShell::GetUndoManager(), ScTabView::GetViewData(), Grid, SfxBindings::Invalidate(), ScDocShell::PostPaint(), ScDBData::SetAutoFilter(), and ScDocShellModificator::SetDocumentModified().
Referenced by ScCellShell::ExecuteDB().
void ScDBFunc::HideMarkedOutlines | ( | bool | bRecord = true | ) |
Definition at line 408 of file dbfunc3.cxx.
References ScTabView::ErrorMessage(), ScViewData::GetDocShell(), ScTabView::GetViewData(), ScOutlineDocFunc::HideMarkedOutlines(), ScTabViewShell::notifyAllViewsSheetGeomInvalidation(), SC_MARK_SIMPLE, and ScTabView::UpdateScrollBars().
Referenced by ScCellShell::ExecuteEdit(), ScUndoOutlineBlock::Redo(), and ScUndoOutlineBlock::Repeat().
void ScDBFunc::HideOutline | ( | bool | bColumns, |
sal_uInt16 | nLevel, | ||
sal_uInt16 | nEntry, | ||
bool | bRecord = true , |
||
bool | bPaint = true |
||
) |
Definition at line 287 of file dbfunc3.cxx.
References COLUMN_HEADER, ScViewData::GetDocShell(), ScViewData::GetTabNo(), ScTabView::GetViewData(), ScOutlineDocFunc::HideOutline(), ScTabViewShell::notifyAllViewsSheetGeomInvalidation(), ROW_HEADER, and ScTabView::UpdateScrollBars().
Referenced by ScOutlineWindow::DoFunction(), ScUndoDoOutline::Redo(), SetOutlineState(), and ScUndoDoOutline::Undo().
bool ScDBFunc::ImportData | ( | const ScImportParam & | rParam | ) |
Definition at line 451 of file dbfunc.cxx.
References ScDBDocFunc::DoImport(), ScTabView::ErrorMessage(), ScViewData::GetDocument(), ScEditableTester::GetMessageId(), ScTabView::GetViewData(), ScEditableTester::IsEditable(), ScImportParam::nCol1, ScImportParam::nCol2, ScImportParam::nRow1, and ScImportParam::nRow2.
Referenced by ScDocShell::Execute(), ScCellShell::ExecuteDB(), and ScUndoImportData::Repeat().
void ScDBFunc::MakeOutline | ( | bool | bColumns, |
bool | bRecord = true |
||
) |
Definition at line 89 of file dbfunc3.cxx.
References COLUMN_HEADER, ScTabView::ErrorMessage(), ScViewData::GetDocShell(), ScTabView::GetViewData(), ScOutlineDocFunc::MakeOutline(), ScTabViewShell::notifyAllViewsHeaderInvalidation(), ScTabViewShell::notifyAllViewsSheetGeomInvalidation(), ROW_HEADER, and SC_MARK_SIMPLE.
Referenced by ScCellShell::ExecuteEdit(), ScUndoMakeOutline::Redo(), and ScUndoMakeOutline::Repeat().
bool ScDBFunc::MakePivotTable | ( | const ScDPSaveData & | rData, |
const ScRange & | rDest, | ||
bool | bNewTable, | ||
const ScDPObject & | rSource | ||
) |
change the dialog to keep the dimension data
Definition at line 621 of file dbfunc3.cxx.
References SfxUndoManager::AddUndoAction(), aName, ScRange::aStart, aStr, ScAddress::Col(), ScTabView::CursorPosChanged(), ScDBDocFunc::DataPilotUpdate(), ScTabView::ErrorMessage(), ScViewData::GetDocShell(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScDPSaveData::GetExistingDimensionData(), ScDocument::GetName(), ScDPObject::GetSaveData(), ScDocument::GetTableCount(), ScViewData::GetTabNo(), ScDocShell::GetUndoManager(), ScTabView::GetViewData(), i, ScDocument::InsertTab(), ScViewData::InsertTab(), ScDPSaveData::IsEmpty(), ScDocument::IsUndoEnabled(), lcl_MakePivotTabName(), MAXTAB, ScDocShell::PostPaintExtras(), ScAddress::Row(), ScResId(), ScDPSaveData::SetDimensionData(), ScDPObject::SetOutRange(), ScDPObject::SetSaveData(), ScTabView::SetTabNo(), SfxGetpApp(), and ScAddress::Tab().
Referenced by ScCellShell::ExecuteDB().
|
staticprivate |
Definition at line 402 of file dbfunc.cxx.
References ScDocShell::GetViewBindings(), SfxBindings::Invalidate(), and ScDocShellModificator::SetDocumentModified().
Referenced by ApplyAutoFilter(), and ToggleAutoFilter().
void ScDBFunc::NumGroupDataPilot | ( | const ScDPNumGroupInfo & | rInfo | ) |
Definition at line 1085 of file dbfunc3.cxx.
References aData, ScDPDimensionSaveData::AddNumGroupDimension(), aEntries, ScDPObject::GetDimName(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScDPDimensionSaveData::GetNumGroupDimAcc(), ScDPObject::GetSaveData(), GetSelectedMemberList(), ScTabView::GetViewData(), ScDBDocFunc::RefreshPivotTableGroups(), ScDPSaveNumGroupDimension::SetGroupInfo(), ScDPObject::SetSaveData(), and ScTabView::Unmark().
Referenced by ScCellShell::ExecuteEdit().
void ScDBFunc::OnLOKShowHideColRow | ( | bool | bColumns, |
SCCOLROW | nStartRow | ||
) |
Definition at line 2278 of file dbfunc3.cxx.
References SfxViewShell::GetDocId(), SfxViewShell::GetFirst(), ScViewData::GetLOKHeightHelper(), ScViewData::GetLOKWidthHelper(), SfxViewShell::GetNext(), ScTabViewShell::getPart(), ScViewData::GetTabNo(), ScTabView::GetViewData(), ScViewData::GetViewShell(), comphelper::LibreOfficeKit::isActive(), ScTabView::MarkDataChanged(), and ScTabViewShell::ShowCursor().
Referenced by ScOutlineDocFunc::HideOutline(), ScDBDocFunc::Query(), ScOutlineDocFunc::SelectLevel(), ScOutlineDocFunc::ShowMarkedOutlines(), ScOutlineDocFunc::ShowOutline(), ScUndoOutlineBlock::Undo(), and ScUndoQuery::Undo().
bool ScDBFunc::OutlinePossible | ( | bool | bHide | ) |
Definition at line 307 of file dbfunc3.cxx.
References ScOutlineTable::GetColArray(), ScViewData::GetDocument(), ScOutlineEntry::GetEnd(), ScSubOutlineIterator::GetNext(), ScDocument::GetOutlineTable(), ScOutlineTable::GetRowArray(), ScOutlineEntry::GetStart(), ScViewData::GetTabNo(), ScTabView::GetViewData(), ScOutlineEntry::IsHidden(), and SC_MARK_SIMPLE.
Referenced by ScCellShell::GetState().
void ScDBFunc::Query | ( | const ScQueryParam & | rQueryParam, |
const ScRange * | pAdvSource, | ||
bool | bRecord | ||
) |
Definition at line 234 of file dbfunc.cxx.
References ScQueryParamBase::bInplace, ScDBData::GetArea(), ScViewData::GetBindings(), ScDocument::GetDBAtCursor(), ScViewData::GetDocShell(), ScDocShell::GetDocument(), ScViewData::GetTabNo(), ScTabView::GetViewData(), SfxBindings::Invalidate(), ScTabView::MarkRange(), ScQueryParam::nDestCol, ScQueryParam::nDestRow, ScQueryParam::nDestTab, ScTabViewShell::notifyAllViewsSheetGeomInvalidation(), ScDBDocFunc::Query(), ROW_HEADER, ScTabView::SelectionChanged(), TOP_LEFT, and ScTabView::UpdateScrollBars().
Referenced by ScCellShell::ExecuteDB(), lcl_SelectAll(), ScUndoQuery::Redo(), RepeatDB(), ToggleAutoFilter(), and ScGridWindow::UpdateAutoFilterFromMenu().
void ScDBFunc::RecalcPivotTable | ( | ) |
Definition at line 723 of file dbfunc3.cxx.
References ScTabView::CursorPosChanged(), ScTabView::ErrorMessage(), ScViewData::GetDocShell(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScTabView::GetViewData(), and ScDBDocFunc::RefreshPivotTables().
Referenced by ScPivotShell::Execute().
void ScDBFunc::RemoveAllOutlines | ( | bool | bRecord = true | ) |
Definition at line 194 of file dbfunc3.cxx.
References BOTH_HEADERS, ScViewData::GetDocShell(), ScViewData::GetTabNo(), ScTabView::GetViewData(), ScTabViewShell::notifyAllViewsSheetGeomInvalidation(), ScOutlineDocFunc::RemoveAllOutlines(), and ScTabView::UpdateScrollBars().
Referenced by ScTabViewShell::Execute(), and ScUndoRemoveAllOutlines::Redo().
void ScDBFunc::RemoveOutline | ( | bool | bColumns, |
bool | bRecord = true |
||
) |
Definition at line 110 of file dbfunc3.cxx.
References COLUMN_HEADER, ScTabView::ErrorMessage(), ScViewData::GetDocShell(), ScTabView::GetViewData(), ScTabViewShell::notifyAllViewsHeaderInvalidation(), ScTabViewShell::notifyAllViewsSheetGeomInvalidation(), ScOutlineDocFunc::RemoveOutline(), ROW_HEADER, and SC_MARK_SIMPLE.
Referenced by ScCellShell::ExecuteEdit(), ScUndoMakeOutline::Redo(), and ScUndoMakeOutline::Repeat().
void ScDBFunc::RepeatDB | ( | bool | bRecord = true | ) |
undo only needed data ?
Definition at line 2113 of file dbfunc3.cxx.
References SfxUndoManager::AddUndoAction(), ALL, ScQueryEntry::bDoQuery, ScSubTotalParam::bGroupActive, ScQueryParamBase::bInplace, ScSubTotalParam::bRemoveOnly, ScDocument::CopyToDocument(), ScDocument::CreateQueryParam(), DoSubTotals(), ScDBCollection::empty(), ScRangeName::empty(), ScTabView::ErrorMessage(), FORMULA, ScDBData::GetAdvancedQuerySource(), ScDBData::GetArea(), ScOutlineTable::GetColArray(), ScViewData::GetCurX(), ScViewData::GetCurY(), ScDocument::GetDBAtCursor(), ScDocument::GetDBCollection(), GetDBData(), ScViewData::GetDocShell(), ScViewData::GetDocument(), ScQueryParamBase::GetEntry(), ScDocument::GetOutlineTable(), ScDBData::GetQueryParam(), ScOutlineArray::GetRange(), ScDocument::GetRangeName(), ScOutlineTable::GetRowArray(), ScDBData::GetSortParam(), ScDBData::GetSubTotalParam(), ScDocument::GetTableCount(), ScViewData::GetTabNo(), ScDocShell::GetUndoManager(), ScTabView::GetViewData(), Grid, ScDBData::IsDoSize(), ScDocument::IsUndoEnabled(), Left, ScSortParam::maKeyState, ScDocument::MaxCol(), ScDocument::MaxRow(), ScQueryParam::nDestCol, ScQueryParam::nDestRow, ScQueryParam::nDestTab, NONE, ScDocShell::PostPaint(), Query(), SCDOCMODE_UNDO, ScTabView::SetTabNo(), Size, Sort(), Top, and TOP_LEFT.
Referenced by ScDocShell::Execute(), ScCellShell::ExecuteDB(), ScUndoRepeatDB::Redo(), and ScDBDocFunc::UpdateImport().
void ScDBFunc::SelectLevel | ( | bool | bColumns, |
sal_uInt16 | nLevel, | ||
bool | bRecord = true |
||
) |
Definition at line 233 of file dbfunc3.cxx.
References COLUMN_HEADER, ScViewData::GetDocShell(), ScViewData::GetTabNo(), ScTabView::GetViewData(), ScTabViewShell::notifyAllViewsSheetGeomInvalidation(), ROW_HEADER, ScOutlineDocFunc::SelectLevel(), and ScTabView::UpdateScrollBars().
Referenced by ScOutlineWindow::DoFunction(), ScUndoOutlineLevel::Redo(), and SetOutlineState().
void ScDBFunc::SetDataPilotDetails | ( | bool | bShow, |
const OUString * | pNewDimensionName = nullptr |
||
) |
Use all members from source level instead (including non-visible)?
Definition at line 1944 of file dbfunc3.cxx.
References aData, aEntries, ScDBDocFunc::DataPilotUpdate(), ScDPObject::GetDimName(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScDPSaveDimension::GetMemberByName(), ScDPObject::GetMemberResultNames(), ScDPSaveDimension::GetOrientation(), ScDPObject::GetSaveData(), GetSelectedMemberList(), ScTabView::GetViewData(), LONG_MAX, ScDPSaveDimension::SetOrientation(), ScDPSaveMember::SetShowDetails(), and ScTabView::Unmark().
Referenced by ScCellShell::ExecuteEdit().
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().
void ScDBFunc::ShowDataPilotSourceData | ( | ScDPObject & | rDPObj, |
const css::uno::Sequence< css::sheet::DataPilotFieldFilter > & | rFilters | ||
) |
Definition at line 2030 of file dbfunc3.cxx.
References ALL, any, Any, aStr, ATTR_VALUE_FORMAT(), ScDocument::CreateValidTabName(), SfxUndoManager::EnterListAction(), ScTabView::ErrorMessage(), ScViewData::GetDocShell(), ScViewData::GetDocument(), ScDocument::GetDocumentShell(), ScPatternAttr::GetItemSet(), ScDPObject::GetSource(), ScViewData::GetTabNo(), ScDocShell::GetUndoManager(), ScTabView::GetViewData(), ScViewFunc::InsertTable(), SfxObjectShell::IsReadOnly(), SfxUndoManager::LeaveListAction(), ScViewFunc::PasteFromClip(), SfxItemSet::Put(), SC_UNO_DP_NUMBERFO, SCDOCMODE_CLIP, and ScResId().
Referenced by ScCellShell::ExecuteEdit(), ScDataPilotTableObj::insertDrillDownSheet(), and ScGridWindow::MouseButtonUp().
void ScDBFunc::ShowMarkedOutlines | ( | bool | bRecord = true | ) |
Definition at line 385 of file dbfunc3.cxx.
References ScTabView::ErrorMessage(), ScViewData::GetDocShell(), ScTabView::GetViewData(), ScTabViewShell::notifyAllViewsSheetGeomInvalidation(), SC_MARK_SIMPLE, ScOutlineDocFunc::ShowMarkedOutlines(), and ScTabView::UpdateScrollBars().
Referenced by ScCellShell::ExecuteEdit(), ScUndoOutlineBlock::Redo(), and ScUndoOutlineBlock::Repeat().
void ScDBFunc::ShowOutline | ( | bool | bColumns, |
sal_uInt16 | nLevel, | ||
sal_uInt16 | nEntry, | ||
bool | bRecord = true , |
||
bool | bPaint = true |
||
) |
Definition at line 267 of file dbfunc3.cxx.
References COLUMN_HEADER, ScViewData::GetDocShell(), ScViewData::GetTabNo(), ScTabView::GetViewData(), ScTabViewShell::notifyAllViewsSheetGeomInvalidation(), ROW_HEADER, ScOutlineDocFunc::ShowOutline(), and ScTabView::UpdateScrollBars().
Referenced by ScOutlineWindow::DoFunction(), ScUndoDoOutline::Redo(), SetOutlineState(), and ScUndoDoOutline::Undo().
void ScDBFunc::Sort | ( | const ScSortParam & | rSortParam, |
bool | bRecord = true , |
||
bool | bPaint = true |
||
) |
Definition at line 213 of file dbfunc.cxx.
References ScSortParam::bInplace, ScViewData::GetDocShell(), ScViewData::GetTabNo(), ScTabView::GetViewData(), ScTabView::MarkRange(), ScSortParam::nCol1, ScSortParam::nCol2, ScSortParam::nDestCol, ScSortParam::nDestRow, ScSortParam::nDestTab, ScSortParam::nRow1, ScSortParam::nRow2, ScTabView::ResetAutoSpellForContentChange(), and ScDBDocFunc::Sort().
Referenced by DoSubTotals(), RepeatDB(), and UISort().
void ScDBFunc::TestRemoveOutline | ( | bool & | rCol, |
bool & | rRow | ||
) |
Definition at line 131 of file dbfunc3.cxx.
References ScOutlineTable::GetColArray(), ScViewData::GetDocument(), ScOutlineEntry::GetEnd(), ScSubOutlineIterator::GetNext(), ScDocument::GetOutlineTable(), ScOutlineTable::GetRowArray(), ScOutlineEntry::GetStart(), ScTabView::GetViewData(), ScDocument::MaxCol(), ScDocument::MaxRow(), and SC_MARK_SIMPLE.
Referenced by ScCellShell::ExecuteEdit(), and ScCellShell::GetState().
void ScDBFunc::ToggleAutoFilter | ( | ) |
undo, retrieve beforehand ??
instead retrieve from DB-range?
Undo ??
Definition at line 276 of file dbfunc.cxx.
References SfxUndoManager::AddUndoAction(), ScDocument::ApplyAttr(), ApplyAutoFilter(), ATTR_MERGE_FLAG(), Auto, ScQueryEntry::bDoQuery, ScQueryParamBase::bDuplicate, Application::CreateMessageDialog(), SfxUndoManager::EnterListAction(), ScDBData::GetArea(), ScDocument::GetAttr(), GetDBData(), ScViewData::GetDialogParent(), ScViewData::GetDocShell(), ScViewData::GetDocument(), ScQueryParamBase::GetEntry(), ScQueryParamBase::GetEntryCount(), ScDBData::GetName(), ScDBData::GetQueryParam(), ScViewData::GetTabNo(), ScDocShell::GetUndoManager(), ScTabView::GetViewData(), ScViewData::GetViewShell(), SfxViewShell::GetViewShellId(), ScDBData::HasHeader(), i, ScDocument::IsBlockEmpty(), SfxUndoManager::LeaveListAction(), LINK, ModifiedAutoFilter(), ScQueryParamTable::nCol1, ScQueryParamTable::nCol2, ScQueryParamTable::nRow1, ScQueryParamTable::nRow2, Query(), RET_YES, RowDown, SC_DB_AUTOFILTER, ScResId(), ScDBData::SetAutoFilter(), ScDBData::SetByRow(), and ScDBData::SetHeader().
Referenced by ScCellShell::ExecuteDB().
void ScDBFunc::UISort | ( | const ScSortParam & | rSortParam | ) |
Definition at line 186 of file dbfunc.cxx.
References ScSubTotalParam::bGroupActive, ScSubTotalParam::bRemoveOnly, DoSubTotals(), ScDocument::GetDBAtArea(), ScViewData::GetDocShell(), ScDocShell::GetDocument(), ScDBData::GetSubTotalParam(), ScViewData::GetTabNo(), ScTabView::GetViewData(), ScSortParam::nCol1, ScSortParam::nCol2, ScSortParam::nRow1, ScSortParam::nRow2, and Sort().
Referenced by ScCellShell::ExecuteDB(), and ScGridWindow::UpdateAutoFilterFromMenu().
void ScDBFunc::UngroupDataPilot | ( | ) |
Definition at line 1262 of file dbfunc3.cxx.
References aData, aEntries, DateGroupDataPilot(), ScDPSaveGroupDimension::GetDatePart(), ScDPSaveNumGroupDimension::GetDatePart(), ScDPObject::GetDimName(), ScViewData::GetDocument(), ScDocument::GetDPAtCursor(), ScDPObject::GetMemberResultNames(), ScDPDimensionSaveData::GetNamedGroupDimAcc(), ScDPDimensionSaveData::GetNumGroupDim(), ScDPObject::GetSaveData(), GetSelectedMemberList(), ScTabView::GetViewData(), ScDPSaveGroupDimension::HasOnlyHidden(), ScDPSaveGroupDimension::IsEmpty(), ScDBDocFunc::RefreshPivotTableGroups(), ScDPSaveGroupDimension::RemoveGroup(), ScDPDimensionSaveData::RemoveGroupDimension(), ScDPDimensionSaveData::RemoveNumGroupDimension(), ScDPObject::SetSaveData(), and ScTabView::Unmark().
Referenced by ScCellShell::ExecuteEdit().
void ScDBFunc::UpdateCharts | ( | bool | bAllCharts | ) |
Definition at line 24 of file dbfunc2.cxx.
References DoUpdateCharts(), ScTabView::ErrorMessage(), ScViewData::GetCurX(), ScViewData::GetCurY(), ScViewData::GetDocument(), ScDocument::GetDrawLayer(), ScViewData::GetTabNo(), and ScTabView::GetViewData().
Referenced by ScDocShell::DoHardRecalc(), ScDocShell::DoRecalc(), ScCellShell::ExecuteEdit(), and ScModule::ModifyOptions().