xref: /aoo41x/main/sc/source/ui/inc/viewfunc.hxx (revision 52f1c2ee)

/**************************************************************
 *
 * 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_VIEWFUNC_HXX
#define SC_VIEWFUNC_HXX

#include "tabview.hxx"

#include "tabbgcolor.hxx"

#ifndef _SVSTDARR_SHORTS
#define _SVSTDARR_SHORTS
#include <svl/svstdarr.hxx>

#endif

#ifndef _SVSTDARR_STRINGS

#define _SVSTDARR_STRINGS
#include <svl/svstdarr.hxx>

#endif
#include <com/sun/star/embed/XEmbeddedObject.hpp>
#include <com/sun/star/embed/Aspects.hpp>

class ScPatternAttr;
class ScAutoFormatData;
class SvxSearchItem;
class SfxItemSet;
class SvxBorderLine;
class SvxBoxItem;
class SvxBoxInfoItem;
class SfxStyleSheetBase;
class SfxStyleSheet;
class SfxPoolItem;
class EditTextObject;
struct ScSolveParam;
struct ScTabOpParam;
class ScPostIt;
class ScConditionalFormat;
class ScValidationData;
class ScConversionParam;
class SdrModel;
class Graphic;
class Exchange;
class ScRangeList;
class SvxHyperlinkItem;
class ScTransferObj;
class ScTableProtection;

namespace com { namespace sun { namespace star { namespace datatransfer { class XTransferable; } } } }

//==================================================================

class ScViewFunc : public ScTabView
{
private:
	ScAddress	aFormatSource;		// fuer automatisches Erweitern von Formatierung
	ScRange		aFormatArea;
	sal_Bool		bFormatValid;

public:
					ScViewFunc( Window* pParent, ScDocShell& rDocSh, ScTabViewShell* pViewShell );
//UNUSED2008-05     ScViewFunc( Window* pParent, const ScViewFunc& rViewFunc, ScTabViewShell* pViewShell );
					~ScViewFunc();

	const ScPatternAttr*    GetSelectionPattern	();
	void					GetSelectionFrame	( SvxBoxItem&		rLineOuter,
												  SvxBoxInfoItem&	rLineInner );

	sal_uInt8			GetSelectionScriptType();

	sal_Bool			GetAutoSumArea(ScRangeList& rRangeList);
	void			EnterAutoSum(const ScRangeList& rRangeList, sal_Bool bSubTotal);
    bool            AutoSum( const ScRange& rRange, bool bSubTotal, bool bSetCursor, bool bContinue );
    String          GetAutoSumFormula( const ScRangeList& rRangeList, bool bSubTotal );

	void			EnterData( SCCOL nCol, SCROW nRow, SCTAB nTab, const String& rString,
                               sal_Bool bRecord = sal_True, const EditTextObject* pData = NULL );
	void			EnterValue( SCCOL nCol, SCROW nRow, SCTAB nTab, const double& rValue );
	void			EnterData( SCCOL nCol, SCROW nRow, SCTAB nTab, const EditTextObject* pData,
								sal_Bool bRecord = sal_True, sal_Bool bTestSimple = sal_False );

	void			EnterMatrix( const String& rString );
	void			EnterBlock( const String& rString, const EditTextObject* pData );

	void			EnterDataAtCursor( const String& rString );			//! nicht benutzt ?

	SC_DLLPUBLIC void			CutToClip( ScDocument* pClipDoc = NULL, sal_Bool bIncludeObjects = sal_False );
	SC_DLLPUBLIC sal_Bool			CopyToClip( ScDocument* pClipDoc = NULL, sal_Bool bCut = sal_False, sal_Bool bApi = sal_False,
								sal_Bool bIncludeObjects = sal_False, sal_Bool bStopEdit = sal_True );
    ScTransferObj*              CopyToTransferable();
	SC_DLLPUBLIC sal_Bool			PasteFromClip( sal_uInt16 nFlags, ScDocument* pClipDoc,
									sal_uInt16 nFunction = PASTE_NOFUNC, sal_Bool bSkipEmpty = sal_False,
									sal_Bool bTranspose = sal_False, sal_Bool bAsLink = sal_False,
									InsCellCmd eMoveMode = INS_NONE,
									sal_uInt16 nUndoExtraFlags = IDF_NONE,
									sal_Bool bAllowDialogs = sal_False );

	void			FillTab( sal_uInt16 nFlags, sal_uInt16 nFunction, sal_Bool bSkipEmpty, sal_Bool bAsLink );

	SC_DLLPUBLIC void			PasteFromSystem();
	SC_DLLPUBLIC sal_Bool			PasteFromSystem( sal_uLong nFormatId, sal_Bool bApi = sal_False );
    void                        PasteFromTransferable( const ::com::sun::star::uno::Reference<
                                                       ::com::sun::star::datatransfer::XTransferable >& rxTransferable );

	void			PasteDraw();
	void			PasteDraw( const Point& rLogicPos, SdrModel* pModel,
                                sal_Bool bGroup = sal_False, sal_Bool bSameDocClipboard = sal_False );

    sal_Bool PasteOnDrawObjectLinked(
        const ::com::sun::star::uno::Reference< ::com::sun::star::datatransfer::XTransferable >& rxTransferable,
        SdrObject& rHitObj);

	sal_Bool			PasteDataFormat( sal_uLong nFormatId,
										const ::com::sun::star::uno::Reference<
											::com::sun::star::datatransfer::XTransferable >& rxTransferable,
										SCCOL nPosX, SCROW nPosY, Point* pLogicPos = NULL,
										sal_Bool bLink = sal_False, sal_Bool bAllowDialogs = sal_False );

	sal_Bool			PasteFile( const Point&, const String&, sal_Bool bLink=sal_False );
    sal_Bool            PasteObject( const Point&, const com::sun::star::uno::Reference < com::sun::star::embed::XEmbeddedObject >&, const Size* = NULL, const Graphic* = NULL, const ::rtl::OUString& = ::rtl::OUString(), sal_Int64 nAspect = ::com::sun::star::embed::Aspects::MSOLE_CONTENT );
	sal_Bool			PasteBitmapEx( const Point&, const BitmapEx& );
	sal_Bool			PasteMetaFile( const Point&, const GDIMetaFile& );
	sal_Bool			PasteGraphic( const Point& rPos, const Graphic& rGraphic,
									const String& rFile, const String& rFilter );
	sal_Bool			PasteBookmark( sal_uLong nFormatId,
								const ::com::sun::star::uno::Reference<
									::com::sun::star::datatransfer::XTransferable >& rxTransferable,
								SCCOL nPosX, SCROW nPosY );
	sal_Bool			PasteDDE( const ::com::sun::star::uno::Reference<
								::com::sun::star::datatransfer::XTransferable >& rxTransferable );

	void			InsertBookmark( const String& rDescription, const String& rURL,
									SCCOL nPosX, SCROW nPosY, const String* pTarget = NULL,
									sal_Bool bTryReplace = sal_False );
	sal_Bool			HasBookmarkAtCursor( SvxHyperlinkItem* pContent );

	long			DropRequestHdl( Exchange* pExchange );
	sal_Bool			MoveBlockTo( const ScRange& rSource, const ScAddress& rDestPos,
									sal_Bool bCut, sal_Bool bRecord, sal_Bool bPaint, sal_Bool bApi );

	sal_Bool			LinkBlock( const ScRange& rSource, const ScAddress& rDestPos, sal_Bool bApi );

	void			CreateNames( sal_uInt16 nFlags );
	sal_uInt16			GetCreateNameFlags();
	void			InsertNameList();
	sal_Bool			InsertName( const String& rName, const String& rSymbol,
								const String& rType );

	void			ApplyAttributes( const SfxItemSet* pDialogSet, const SfxItemSet* pOldSet,
										sal_Bool bRecord = sal_True );
	void			ApplyAttr( const SfxPoolItem& rAttrItem );
	void			ApplySelectionPattern( const ScPatternAttr& rAttr,
											sal_Bool bRecord = sal_True,
											sal_Bool bCursorOnly = sal_False );
	void			ApplyPatternLines( const ScPatternAttr& rAttr,
										const SvxBoxItem* pNewOuter,
										const SvxBoxInfoItem* pNewInner, sal_Bool bRecord = sal_True );

	void			ApplyUserItemSet( const SfxItemSet& rItemSet );

	const SfxStyleSheet*	GetStyleSheetFromMarked();
	void					SetStyleSheetToMarked( SfxStyleSheet* pStyleSheet,
														sal_Bool bRecord = sal_True );
    void                    RemoveStyleSheetInUse( const SfxStyleSheetBase* pStyleSheet );
    void                    UpdateStyleSheetInUse( const SfxStyleSheetBase* pStyleSheet );

	void			SetNumberFormat( short nFormatType, sal_uLong nAdd = 0 );
	void			SetNumFmtByStr( const String& rCode );
	void			ChangeNumFmtDecimals( sal_Bool bIncrement );

	void			SetConditionalFormat( const ScConditionalFormat& rNew );
	void			SetValidation( const ScValidationData& rNew );

	void			ChangeIndent( sal_Bool bIncrement );

	void			ProtectSheet( SCTAB nTab, const ScTableProtection& rProtect );

	void			Protect( SCTAB nTab, const String& rPassword );
	sal_Bool			Unprotect( SCTAB nTab, const String& rPassword );

	void			DeleteCells( DelCellCmd eCmd, sal_Bool bRecord = sal_True );
	sal_Bool			InsertCells( InsCellCmd eCmd, sal_Bool bRecord = sal_True, sal_Bool bPartOfPaste = sal_False );
	void			DeleteMulti( sal_Bool bRows, sal_Bool bRecord = sal_True );

	void			DeleteContents( sal_uInt16 nFlags, sal_Bool bRecord = sal_True );

	void			SetWidthOrHeight( sal_Bool bWidth, SCCOLROW nRangeCnt, SCCOLROW* pRanges,
										ScSizeMode eMode, sal_uInt16 nSizeTwips,
										sal_Bool bRecord = sal_True, sal_Bool bPaint = sal_True,
										ScMarkData* pMarkData = NULL );
	void			SetMarkedWidthOrHeight( sal_Bool bWidth, ScSizeMode eMode, sal_uInt16 nSizeTwips,
										sal_Bool bRecord = sal_True, sal_Bool bPaint = sal_True );
	void			ShowMarkedColumns( sal_Bool bShow, sal_Bool bRecord = sal_True );
	void			ShowMarkedRows( sal_Bool bShow, sal_Bool bRecord = sal_True );

	sal_Bool			AdjustBlockHeight( sal_Bool bPaint = sal_True, ScMarkData* pMarkData = NULL );
	sal_Bool			AdjustRowHeight( SCROW nStartRow, SCROW nEndRow, sal_Bool bPaint = sal_True );

	void			ModifyCellSize( ScDirection eDir, sal_Bool bOptimal );

	SC_DLLPUBLIC void			InsertPageBreak( sal_Bool bColumn, sal_Bool bRecord = sal_True,
										const ScAddress* pPos = NULL,
										sal_Bool bSetModified = sal_True );
	SC_DLLPUBLIC void			DeletePageBreak( sal_Bool bColumn, sal_Bool bRecord = sal_True,
										const ScAddress* pPos = NULL,
										sal_Bool bSetModified = sal_True );

	void			RemoveManualBreaks();

	void			SetPrintZoom(sal_uInt16 nScale, sal_uInt16 nPages);
	void			AdjustPrintZoom();

	sal_Bool			TestMergeCells();
	sal_Bool			TestRemoveMerge();

	sal_Bool			MergeCells( sal_Bool bApi, sal_Bool& rDoContents, sal_Bool bRecord = sal_True );
	sal_Bool			RemoveMerge( sal_Bool bRecord = sal_True );

	void			FillSimple( FillDir eDir, sal_Bool bRecord = sal_True );
	void			FillSeries( FillDir	eDir, FillCmd eCmd, FillDateCmd	eDateCmd,
								double fStart, double fStep, double fMax, sal_Bool bRecord = sal_True );
	void			FillAuto( FillDir eDir, SCCOL nStartCol, SCROW nStartRow,
								SCCOL nEndCol, SCROW nEndRow, sal_uLong nCount, sal_Bool bRecord = sal_True );
	void			FillCrossDblClick();

	void			TransliterateText( sal_Int32 nType );

	ScAutoFormatData* CreateAutoFormatData();
	void			AutoFormat( sal_uInt16 nFormatNo, sal_Bool bRecord = sal_True );

//	void			SearchAndReplace( const SvxSearchItem* pSearchItem,
	sal_Bool			SearchAndReplace( const SvxSearchItem* pSearchItem,
										sal_Bool bAddUndo, sal_Bool bIsApi );

	void			Solve( const ScSolveParam& rParam );
	void			TabOp( const ScTabOpParam& rParam,  sal_Bool bRecord = sal_True );

	sal_Bool			InsertTable( const String& rName, SCTAB nTabNr, sal_Bool bRecord = sal_True );
	sal_Bool			InsertTables(SvStrings *pNames, SCTAB nTab, SCTAB nCount, sal_Bool bRecord = sal_True);


	sal_Bool			AppendTable( const String& rName, sal_Bool bRecord = sal_True );

	sal_Bool			DeleteTable( SCTAB nTabNr, sal_Bool bRecord = sal_True );
	sal_Bool			DeleteTables(const SvShorts &TheTabs, sal_Bool bRecord = sal_True );

	sal_Bool			RenameTable( const String& rName, SCTAB nTabNr );
	void			MoveTable( sal_uInt16 nDestDocNo, SCTAB nDestTab, sal_Bool bCopy );
	void			ImportTables( ScDocShell* pSrcShell,
									SCTAB nCount, const SCTAB* pSrcTabs,
									sal_Bool bLink,SCTAB nTab);

    bool            SetTabBgColor( const Color& rColor, SCTAB nTabNr );
    bool            SetTabBgColor( ScUndoTabColorInfo::List& rUndoSetTabBgColorInfoList );

	void			InsertTableLink( const String& rFile,
										const String& rFilter, const String& rOptions,
										const String& rTabName );
	void			InsertAreaLink( const String& rFile,
										const String& rFilter, const String& rOptions,
										const String& rSource, sal_uLong nRefresh );

	void			ShowTable( const String& rName );
	void			HideTable( SCTAB nTabNr );

	void			MakeScenario( const String& rName, const String& rComment,
									const Color& rColor, sal_uInt16 nFlags );
	void			ExtendScenario();
	void			UseScenario( const String& rName );

	void			InsertSpecialChar( const String& rStr, const Font& rFont );

	void			InsertDummyObject();
	void			InsertOleObject();

	void			InsertDraw();

	void			SetSelectionFrameLines( const SvxBorderLine* pLine,
											sal_Bool bColorOnly );

    void            SetNoteText( const ScAddress& rPos, const String& rNoteText );
    void            ReplaceNote( const ScAddress& rPos, const String& rNoteText, const String* pAuthor, const String* pDate );
    void            DoRefConversion( sal_Bool bRecord = sal_True );

//UNUSED2008-05  void            DoSpellingChecker( sal_Bool bRecord = sal_True );
    void            DoHangulHanjaConversion( sal_Bool bRecord = sal_True );
	void			DoThesaurus( sal_Bool bRecord = sal_True );
//UNUSED2008-05  DECL_LINK( SpellError, void * );

    /** Generic implementation of sheet conversion functions. */
    void            DoSheetConversion( const ScConversionParam& rParam, sal_Bool bRecord = sal_True );

    void            SetPrintRanges( sal_Bool bEntireSheet,
                                    const String* pPrint,
									const String* pRepCol, const String* pRepRow,
									sal_Bool bAddPrint );

	void			DetectiveAddPred();
	void			DetectiveDelPred();
	void			DetectiveAddSucc();
	void			DetectiveDelSucc();
	void			DetectiveAddError();
	void			DetectiveMarkInvalid();
	void			DetectiveDelAll();
	void			DetectiveRefresh();

	void			ShowNote( bool bShow = true );
	inline void		HideNote() { ShowNote( false ); }
	void			EditNote();

	void			ForgetFormatArea()		{ bFormatValid = sal_False; }
	sal_Bool			SelectionEditable( sal_Bool* pOnlyNotBecauseOfMatrix = NULL );

												// interne Hilfsfunktionen
protected:
	void			UpdateLineAttrs( SvxBorderLine&		  rLine,
									 const SvxBorderLine* pDestLine,
									 const SvxBorderLine* pSrcLine,
									 sal_Bool 				  bColor );

//UNUSED2008-05  void            PaintWidthHeight( sal_Bool bColumns, SCCOLROW nStart, SCCOLROW nEnd );


private:
	void			PasteRTF( SCCOL nCol, SCROW nStartRow,
								const ::com::sun::star::uno::Reference<
										::com::sun::star::datatransfer::XTransferable >& rxTransferable );
    bool            PasteMultiRangesFromClip( sal_uInt16 nFlags, ScDocument* pClipDoc, sal_uInt16 nFunction,
                                              bool bSkipEmpty, bool bTranspos, bool bAsLink, bool bAllowDialogs,
                                              InsCellCmd eMoveMode, sal_uInt16 nCondFlags, sal_uInt16 nUndoFlags );
    void            PostPasteFromClip(const ScRange& rPasteRange, const ScMarkData& rMark);

	sal_uInt16			GetOptimalColWidth( SCCOL nCol, SCTAB nTab, sal_Bool bFormula );

	void			StartFormatArea();
	sal_Bool			TestFormatArea( SCCOL nCol, SCROW nRow, SCTAB nTab, sal_Bool bAttrChanged );
	void			DoAutoAttributes( SCCOL nCol, SCROW nRow, SCTAB nTab,
										sal_Bool bAttrChanged, sal_Bool bAddUndo );
};



#endif