/************************************************************************* * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * * This file is part of OpenOffice.org. * * OpenOffice.org is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License version 3 * only, as published by the Free Software Foundation. * * OpenOffice.org is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Lesser General Public License version 3 for more details * (a copy is included in the LICENSE file that accompanied this code). * * You should have received a copy of the GNU Lesser General Public License * version 3 along with OpenOffice.org. If not, see * * for a copy of the LGPLv3 License. * ************************************************************************/ // MARKER(update_precomp.py): autogen include statement, do not remove #include "precompiled_sc.hxx" // INCLUDE --------------------------------------------------------------- #include "scitems.hxx" #include #include #include #include #include #include #include #include #include #include #include #include #include "viewdata.hxx" #include "docoptio.hxx" #include "scmod.hxx" #include "global.hxx" #include "document.hxx" #include "attrib.hxx" #include "tabview.hxx" #include "tabvwsh.hxx" #include "docsh.hxx" #include "sc.hrc" #include "patattr.hxx" #include "editutil.hxx" #include "scextopt.hxx" #include "miscuno.hxx" #include "unonames.hxx" #include "inputopt.hxx" #include "viewutil.hxx" #include #include "ViewSettingsSequenceDefines.hxx" #include #include #include using namespace com::sun::star; // STATIC DATA ----------------------------------------------------------- #define SC_GROWY_SMALL_EXTRA 100 #define SC_GROWY_BIG_EXTRA 200 #define TAG_TABBARWIDTH "tw:" static BOOL bMoveArea = FALSE; //! Member? USHORT nEditAdjust = SVX_ADJUST_LEFT; //! Member !!! //================================================================== ScViewDataTable::ScViewDataTable() : eZoomType( SVX_ZOOM_PERCENT ), aZoomX( 1,1 ), aZoomY( 1,1 ), aPageZoomX( 3,5 ), // Page-Default: 60% aPageZoomY( 3,5 ), nHSplitPos( 0 ), nVSplitPos( 0 ), eHSplitMode( SC_SPLIT_NONE ), eVSplitMode( SC_SPLIT_NONE ), eWhichActive( SC_SPLIT_BOTTOMLEFT ), nFixPosX( 0 ), nFixPosY( 0 ), nCurX( 0 ), nCurY( 0 ), bOldCurValid( FALSE ) { nPosX[0]=nPosX[1]=0; nPosY[0]=nPosY[1]=0; nTPosX[0]=nTPosX[1]=0; nTPosY[0]=nTPosY[1]=0; nMPosX[0]=nMPosX[1]=0; nMPosY[0]=nMPosY[1]=0; nPixPosX[0]=nPixPosX[1]=0; nPixPosY[0]=nPixPosY[1]=0; } ScViewDataTable::~ScViewDataTable() { } void ScViewDataTable::WriteUserDataSequence(uno::Sequence & rSettings, const ScViewData& /*rViewData*/, SCTAB /*nTab*/) { rSettings.realloc(SC_TABLE_VIEWSETTINGS_COUNT); beans::PropertyValue* pSettings = rSettings.getArray(); if (pSettings) { pSettings[SC_CURSOR_X].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_CURSORPOSITIONX)); pSettings[SC_CURSOR_X].Value <<= sal_Int32(nCurX); pSettings[SC_CURSOR_Y].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_CURSORPOSITIONY)); pSettings[SC_CURSOR_Y].Value <<= sal_Int32(nCurY); pSettings[SC_HORIZONTAL_SPLIT_MODE].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_HORIZONTALSPLITMODE)); pSettings[SC_HORIZONTAL_SPLIT_MODE].Value <<= sal_Int16(eHSplitMode); pSettings[SC_VERTICAL_SPLIT_MODE].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_VERTICALSPLITMODE)); pSettings[SC_VERTICAL_SPLIT_MODE].Value <<= sal_Int16(eVSplitMode); pSettings[SC_HORIZONTAL_SPLIT_POSITION].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_HORIZONTALSPLITPOSITION)); if (eHSplitMode == SC_SPLIT_FIX) pSettings[SC_HORIZONTAL_SPLIT_POSITION].Value <<= sal_Int32(nFixPosX); else pSettings[SC_HORIZONTAL_SPLIT_POSITION].Value <<= sal_Int32(nHSplitPos); pSettings[SC_VERTICAL_SPLIT_POSITION].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_VERTICALSPLITPOSITION)); if (eVSplitMode == SC_SPLIT_FIX) pSettings[SC_VERTICAL_SPLIT_POSITION].Value <<= sal_Int32(nFixPosY); else pSettings[SC_VERTICAL_SPLIT_POSITION].Value <<= sal_Int32(nVSplitPos); pSettings[SC_ACTIVE_SPLIT_RANGE].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_ACTIVESPLITRANGE)); pSettings[SC_ACTIVE_SPLIT_RANGE].Value <<= sal_Int16(eWhichActive); pSettings[SC_POSITION_LEFT].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_POSITIONLEFT)); pSettings[SC_POSITION_LEFT].Value <<= sal_Int32(nPosX[SC_SPLIT_LEFT]); pSettings[SC_POSITION_RIGHT].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_POSITIONRIGHT)); pSettings[SC_POSITION_RIGHT].Value <<= sal_Int32(nPosX[SC_SPLIT_RIGHT]); pSettings[SC_POSITION_TOP].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_POSITIONTOP)); pSettings[SC_POSITION_TOP].Value <<= sal_Int32(nPosY[SC_SPLIT_TOP]); pSettings[SC_POSITION_BOTTOM].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_POSITIONBOTTOM)); pSettings[SC_POSITION_BOTTOM].Value <<= sal_Int32(nPosY[SC_SPLIT_BOTTOM]); sal_Int32 nZoomValue ((aZoomY.GetNumerator() * 100) / aZoomY.GetDenominator()); sal_Int32 nPageZoomValue ((aPageZoomY.GetNumerator() * 100) / aPageZoomY.GetDenominator()); pSettings[SC_TABLE_ZOOM_TYPE].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_ZOOMTYPE)); pSettings[SC_TABLE_ZOOM_TYPE].Value <<= sal_Int16(eZoomType); pSettings[SC_TABLE_ZOOM_VALUE].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_ZOOMVALUE)); pSettings[SC_TABLE_ZOOM_VALUE].Value <<= nZoomValue; pSettings[SC_TABLE_PAGE_VIEW_ZOOM_VALUE].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_PAGEVIEWZOOMVALUE)); pSettings[SC_TABLE_PAGE_VIEW_ZOOM_VALUE].Value <<= nPageZoomValue; } } void ScViewDataTable::ReadUserDataSequence(const uno::Sequence & aSettings, ScViewData& rViewData, SCTAB nTab, bool& rHasZoom ) { rHasZoom = false; sal_Int32 nCount(aSettings.getLength()); sal_Int32 nTemp32(0); sal_Int16 nTemp16(0); sal_Int32 nTempPosV(0); sal_Int32 nTempPosH(0); sal_Int32 nTempPosVTw(0); sal_Int32 nTempPosHTw(0); bool bHasVSplitInTwips = false; bool bHasHSplitInTwips = false; for (sal_Int32 i = 0; i < nCount; i++) { rtl::OUString sName(aSettings[i].Name); if (sName.compareToAscii(SC_CURSORPOSITIONX) == 0) { aSettings[i].Value >>= nTemp32; nCurX = SanitizeCol( static_cast(nTemp32)); } else if (sName.compareToAscii(SC_CURSORPOSITIONY) == 0) { aSettings[i].Value >>= nTemp32; nCurY = SanitizeRow( static_cast(nTemp32)); } else if (sName.compareToAscii(SC_HORIZONTALSPLITMODE) == 0) { aSettings[i].Value >>= nTemp16; eHSplitMode = static_cast(nTemp16); } else if (sName.compareToAscii(SC_VERTICALSPLITMODE) == 0) { aSettings[i].Value >>= nTemp16; eVSplitMode = static_cast(nTemp16); } else if (sName.compareToAscii(SC_HORIZONTALSPLITPOSITION) == 0) { aSettings[i].Value >>= nTempPosH; bHasHSplitInTwips = false; } else if (sName.compareToAscii(SC_VERTICALSPLITPOSITION) == 0) { aSettings[i].Value >>= nTempPosV; bHasVSplitInTwips = false; } else if (sName.compareToAscii(SC_HORIZONTALSPLITPOSITION_TWIPS) == 0) { aSettings[i].Value >>= nTempPosHTw; bHasHSplitInTwips = true; } else if (sName.compareToAscii(SC_VERTICALSPLITPOSITION_TWIPS) == 0) { aSettings[i].Value >>= nTempPosVTw; bHasVSplitInTwips = true; } else if (sName.compareToAscii(SC_ACTIVESPLITRANGE) == 0) { aSettings[i].Value >>= nTemp16; eWhichActive = static_cast(nTemp16); } else if (sName.compareToAscii(SC_POSITIONLEFT) == 0) { aSettings[i].Value >>= nTemp32; nPosX[SC_SPLIT_LEFT] = SanitizeCol( static_cast(nTemp32)); } else if (sName.compareToAscii(SC_POSITIONRIGHT) == 0) { aSettings[i].Value >>= nTemp32; nPosX[SC_SPLIT_RIGHT] = SanitizeCol( static_cast(nTemp32)); } else if (sName.compareToAscii(SC_POSITIONTOP) == 0) { aSettings[i].Value >>= nTemp32; nPosY[SC_SPLIT_TOP] = SanitizeRow( static_cast(nTemp32)); } else if (sName.compareToAscii(SC_POSITIONBOTTOM) == 0) { aSettings[i].Value >>= nTemp32; nPosY[SC_SPLIT_BOTTOM] = SanitizeRow( static_cast(nTemp32)); } else if (sName.compareToAscii(SC_ZOOMTYPE) == 0) { aSettings[i].Value >>= nTemp16; eZoomType = SvxZoomType(nTemp16); rHasZoom = true; // set if there is any zoom information } else if (sName.compareToAscii(SC_ZOOMVALUE) == 0) { aSettings[i].Value >>= nTemp32; Fraction aZoom(nTemp32, 100); aZoomX = aZoomY = aZoom; rHasZoom = true; } else if (sName.compareToAscii(SC_PAGEVIEWZOOMVALUE) == 0) { aSettings[i].Value >>= nTemp32; Fraction aZoom(nTemp32, 100); aPageZoomX = aPageZoomY = aZoom; rHasZoom = true; } else if (sName.compareToAscii(SC_TABLESELECTED) == 0) { bool bSelected = false; aSettings[i].Value >>= bSelected; rViewData.GetMarkData().SelectTable( nTab, bSelected ); } else if (sName.compareToAscii(SC_UNONAME_TABCOLOR) == 0) { // There are documents out there that have their tab color defined as a view setting. sal_Int32 nColor = COL_AUTO; aSettings[i].Value >>= nColor; if (static_cast(nColor) != COL_AUTO) { ScDocument* pDoc = rViewData.GetDocument(); pDoc->SetTabBgColor(nTab, Color(static_cast(nColor))); } } } if (eHSplitMode == SC_SPLIT_FIX) nFixPosX = SanitizeCol( static_cast( bHasHSplitInTwips ? nTempPosHTw : nTempPosH )); else nHSplitPos = bHasHSplitInTwips ? static_cast< long >( nTempPosHTw * rViewData.GetPPTX() ) : nTempPosH; if (eVSplitMode == SC_SPLIT_FIX) nFixPosY = SanitizeRow( static_cast( bHasVSplitInTwips ? nTempPosVTw : nTempPosV )); else nVSplitPos = bHasVSplitInTwips ? static_cast< long >( nTempPosVTw * rViewData.GetPPTY() ) : nTempPosV; } //================================================================== ScViewData::ScViewData( ScDocShell* pDocSh, ScTabViewShell* pViewSh ) : pDocShell ( pDocSh ), pDoc ( NULL ), pView ( pViewSh ), pViewShell ( pViewSh ), pOptions ( new ScViewOptions ), pSpellingView ( NULL ), aLogicMode ( MAP_100TH_MM ), eDefZoomType( SVX_ZOOM_PERCENT ), aDefZoomX ( 1,1 ), aDefZoomY ( 1,1 ), aDefPageZoomX( 3,5 ), aDefPageZoomY( 3,5 ), eRefType ( SC_REFTYPE_NONE ), nTabNo ( 0 ), nRefTabNo ( 0 ), eEditActivePart( SC_SPLIT_BOTTOMLEFT ), bActive ( TRUE ), //! wie initialisieren? bIsRefMode ( FALSE ), bDelMarkValid( FALSE ), nFillMode ( SC_FILL_NONE ), bPagebreak ( FALSE ), bSelCtrlMouseClick( FALSE ) { SetGridMode ( TRUE ); SetSyntaxMode ( FALSE ); SetHeaderMode ( TRUE ); SetTabMode ( TRUE ); SetVScrollMode ( TRUE ); SetHScrollMode ( TRUE ); SetOutlineMode ( TRUE ); aScrSize = Size( (long) ( STD_COL_WIDTH * PIXEL_PER_TWIPS * OLE_STD_CELLS_X ), (long) ( ScGlobal::nStdRowHeight * PIXEL_PER_TWIPS * OLE_STD_CELLS_Y ) ); pTabData[0] = new ScViewDataTable; for ( SCTAB i = 1; i <= MAXTAB; i++ ) pTabData[i] = NULL; pThisTab = pTabData[nTabNo]; for (USHORT j=0; j<4; j++) { pEditView[j] = NULL; bEditActive[j] = FALSE; } nEditEndCol = nEditStartCol = nEditCol = 0; nEditEndRow = nEditRow = 0; nTabStartCol = SC_TABSTART_NONE; if (pDocShell) { pDoc = pDocShell->GetDocument(); *pOptions = pDoc->GetViewOptions(); } // keine ausgeblendete Tabelle anzeigen: if (pDoc && !pDoc->IsVisible(nTabNo)) { while ( !pDoc->IsVisible(nTabNo) && pDoc->HasTable(nTabNo+1) ) ++nTabNo; pTabData[nTabNo] = new ScViewDataTable; pThisTab = pTabData[nTabNo]; } CalcPPT(); } ScViewData::ScViewData( const ScViewData& rViewData ) : pDocShell ( rViewData.pDocShell ), pDoc ( rViewData.pDoc ), pView ( rViewData.pView ), pViewShell ( rViewData.pViewShell ), pOptions ( new ScViewOptions( *(rViewData.pOptions) ) ), pSpellingView ( rViewData.pSpellingView ), aLogicMode ( rViewData.aLogicMode ), eDefZoomType( rViewData.eDefZoomType ), aDefZoomX ( rViewData.aDefZoomX ), aDefZoomY ( rViewData.aDefZoomY ), aDefPageZoomX( rViewData.aDefPageZoomX ), aDefPageZoomY( rViewData.aDefPageZoomY ), eRefType ( SC_REFTYPE_NONE ), nTabNo ( rViewData.nTabNo ), nRefTabNo ( rViewData.nTabNo ), // kein RefMode eEditActivePart( rViewData.eEditActivePart ), bActive ( TRUE ), //! wie initialisieren? bIsRefMode ( FALSE ), bDelMarkValid( FALSE ), nFillMode ( SC_FILL_NONE ), bPagebreak ( rViewData.bPagebreak ), bSelCtrlMouseClick( rViewData.bSelCtrlMouseClick ) { SetGridMode ( rViewData.IsGridMode() ); SetSyntaxMode ( rViewData.IsSyntaxMode() ); SetHeaderMode ( rViewData.IsHeaderMode() ); SetTabMode ( rViewData.IsTabMode() ); SetVScrollMode ( rViewData.IsVScrollMode() ); SetHScrollMode ( rViewData.IsHScrollMode() ); SetOutlineMode ( rViewData.IsOutlineMode() ); aScrSize = rViewData.aScrSize; for ( SCTAB i = 0; i <= MAXTAB; i++ ) if (rViewData.pTabData[i]) pTabData[i] = new ScViewDataTable( *rViewData.pTabData[i] ); else pTabData[i] = NULL; pThisTab = pTabData[nTabNo]; for (USHORT j=0; j<4; j++) { pEditView[j] = NULL; bEditActive[j] = FALSE; } nEditEndCol = nEditStartCol = nEditCol = 0; nEditEndRow = nEditRow = 0; nTabStartCol = SC_TABSTART_NONE; CalcPPT(); } void ScViewData::InitData( ScDocument* pDocument ) { pDoc = pDocument; *pOptions = pDoc->GetViewOptions(); } //UNUSED2008-05 void ScViewData::InitFrom( const ScViewData* pRef ) //UNUSED2008-05 { //UNUSED2008-05 if (pRef==NULL) //UNUSED2008-05 { //UNUSED2008-05 DBG_ERROR("ScViewData::InitFrom mit NULL"); //UNUSED2008-05 return; //UNUSED2008-05 } //UNUSED2008-05 //UNUSED2008-05 aScrSize = pRef->aScrSize; //UNUSED2008-05 nTabNo = pRef->nTabNo; //UNUSED2008-05 eDefZoomType = pRef->eDefZoomType; //UNUSED2008-05 aDefZoomX = pRef->aDefZoomX; //UNUSED2008-05 aDefZoomY = pRef->aDefZoomY; //UNUSED2008-05 aDefPageZoomX = pRef->aDefPageZoomX; //UNUSED2008-05 aDefPageZoomY = pRef->aDefPageZoomY; //UNUSED2008-05 bPagebreak = pRef->bPagebreak; //UNUSED2008-05 aLogicMode = pRef->aLogicMode; //UNUSED2008-05 //UNUSED2008-05 SetGridMode ( pRef->IsGridMode() ); //UNUSED2008-05 SetSyntaxMode ( pRef->IsSyntaxMode() ); //UNUSED2008-05 SetHeaderMode ( pRef->IsHeaderMode() ); //UNUSED2008-05 SetTabMode ( pRef->IsTabMode() ); //UNUSED2008-05 SetVScrollMode ( pRef->IsVScrollMode() ); //UNUSED2008-05 SetHScrollMode ( pRef->IsHScrollMode() ); //UNUSED2008-05 SetOutlineMode ( pRef->IsOutlineMode() ); //UNUSED2008-05 //UNUSED2008-05 for (SCTAB i=0; i<=MAXTAB; i++) //UNUSED2008-05 { //UNUSED2008-05 delete pTabData[i]; //UNUSED2008-05 if (pRef->pTabData[i]) //UNUSED2008-05 pTabData[i] = new ScViewDataTable( *pRef->pTabData[i] ); //UNUSED2008-05 else //UNUSED2008-05 pTabData[i] = NULL; //UNUSED2008-05 } //UNUSED2008-05 pThisTab = pTabData[nTabNo]; //UNUSED2008-05 CalcPPT(); //UNUSED2008-05 } //UNUSED2008-05 //UNUSED2008-05 void ScViewData::SetDocShell( ScDocShell* pShell ) //UNUSED2008-05 { //UNUSED2008-05 pDocShell = pShell; //UNUSED2008-05 pDoc = pDocShell->GetDocument(); //UNUSED2008-05 *pOptions = pDoc->GetViewOptions(); //UNUSED2008-05 CalcPPT(); //UNUSED2008-05 } ScDocument* ScViewData::GetDocument() const { if (pDoc) return pDoc; else if (pDocShell) return pDocShell->GetDocument(); DBG_ERROR("kein Document an ViewData"); return NULL; } ScViewData::~ScViewData() { for (SCTAB i=0; i<=MAXTAB; i++) if (pTabData[i]) delete pTabData[i]; KillEditView(); delete pOptions; } void ScViewData::UpdateThis() { do { pThisTab = pTabData[nTabNo]; if (!pThisTab) { if (nTabNo>0) --nTabNo; else pThisTab = pTabData[0] = new ScViewDataTable; // hier keine Assertion, weil sonst Paints kommen, bevor alles initialisiert ist! } } while (!pThisTab); } void ScViewData::InsertTab( SCTAB nTab ) { delete pTabData[MAXTAB]; for (SCTAB i=MAXTAB; i>nTab; i--) pTabData[i] = pTabData[i-1]; pTabData[nTab] = NULL; // force creating new CreateTabData( nTab ); UpdateThis(); aMarkData.InsertTab( nTab ); } void ScViewData::DeleteTab( SCTAB nTab ) { delete pTabData[nTab]; for (SCTAB i=nTab; iGetTableCount() - 1; // am Doc muss vorher kopiert worden sein if (nDestTab > MAXTAB) { DBG_ERROR("Zuviele Tabellen"); return; } delete pTabData[MAXTAB]; for (SCTAB i=MAXTAB; i>nDestTab; i--) pTabData[i] = pTabData[i-1]; if ( pTabData[nSrcTab] ) pTabData[nDestTab] = new ScViewDataTable( *pTabData[nSrcTab] ); else pTabData[nDestTab] = NULL; UpdateThis(); aMarkData.InsertTab( nDestTab ); } void ScViewData::MoveTab( SCTAB nSrcTab, SCTAB nDestTab ) { if (nDestTab==SC_TAB_APPEND) nDestTab = pDoc->GetTableCount() - 1; SCTAB i; ScViewDataTable* pTab = pTabData[nSrcTab]; SCTAB nInsTab = nDestTab; if ( nSrcTab < nDestTab ) { --nInsTab; for (i=nSrcTab; inDestTab; i--) pTabData[i] = pTabData[i-1]; pTabData[nDestTab] = pTab; UpdateThis(); aMarkData.DeleteTab( nSrcTab ); aMarkData.InsertTab( nInsTab ); // ggf. angepasst } //UNUSED2008-05 void ScViewData::UpdateOle( ScSplitPos /* eWhich */ ) //UNUSED2008-05 { //UNUSED2008-05 GetDocShell()->UpdateOle(this); //UNUSED2008-05 } void ScViewData::SetViewShell( ScTabViewShell* pViewSh ) { if (pViewSh) { pViewShell = pViewSh; pView = pViewSh; } else { pViewShell = NULL; pView = NULL; } } void ScViewData::CreateTabData( std::vector< SCTAB >& rvTabs ) { std::vector< SCTAB >::iterator it_end = rvTabs.end(); for ( std::vector< SCTAB >::iterator it = rvTabs.begin(); it != it_end; ++it ) if ( !pTabData[*it] ) CreateTabData( *it ); } void ScViewData::SetZoomType( SvxZoomType eNew, std::vector< SCTAB >& tabs ) { BOOL bAll = ( tabs.size() == 0 ); if ( !bAll ) // create associated table data CreateTabData( tabs ); if ( bAll ) { for ( SCTAB i = 0; i <= MAXTAB; ++i ) { if ( pTabData[i] ) pTabData[i]->eZoomType = eNew; } eDefZoomType = eNew; } else { std::vector< SCTAB >::iterator it_end = tabs.end(); std::vector< SCTAB >::iterator it = tabs.begin(); for ( ; it != it_end; ++it ) { SCTAB i = *it; if ( pTabData[i] ) pTabData[i]->eZoomType = eNew; } } } void ScViewData::SetZoomType( SvxZoomType eNew, BOOL bAll ) { std::vector< SCTAB > vTabs; // Empty for all tabs if ( !bAll ) // get selected tabs { SCTAB nTabCount = pDoc->GetTableCount(); for (SCTAB i=0; i& tabs ) { BOOL bAll = ( tabs.size() == 0 ); if ( !bAll ) // create associated table data CreateTabData( tabs ); Fraction aFrac20( 1,5 ); Fraction aFrac400( 4,1 ); Fraction aValidX = rNewX; if (aValidXaFrac400) aValidX = aFrac400; Fraction aValidY = rNewY; if (aValidYaFrac400) aValidY = aFrac400; if ( bAll ) { for ( SCTAB i = 0; i <= MAXTAB; ++i ) { if ( pTabData[i] ) { if ( bPagebreak ) { pTabData[i]->aPageZoomX = aValidX; pTabData[i]->aPageZoomY = aValidY; } else { pTabData[i]->aZoomX = aValidX; pTabData[i]->aZoomY = aValidY; } } } if ( bPagebreak ) { aDefPageZoomX = aValidX; aDefPageZoomY = aValidY; } else { aDefZoomX = aValidX; aDefZoomY = aValidY; } } else { std::vector< SCTAB >::iterator it_end = tabs.end(); std::vector< SCTAB >::iterator it = tabs.begin(); for ( ; it != it_end; ++it ) { SCTAB i = *it; if ( pTabData[i] ) { if ( bPagebreak ) { pTabData[i]->aPageZoomX = aValidX; pTabData[i]->aPageZoomY = aValidY; } else { pTabData[i]->aZoomX = aValidX; pTabData[i]->aZoomY = aValidY; } } } } RefreshZoom(); } void ScViewData::SetZoom( const Fraction& rNewX, const Fraction& rNewY, BOOL bAll ) { std::vector< SCTAB > vTabs; if ( !bAll ) // get selected tabs { SCTAB nTabCount = pDoc->GetTableCount(); for (SCTAB i=0; iAppend(aSimple); } } BOOL ScViewData::SimpleColMarked() { SCCOL nStartCol; SCROW nStartRow; SCTAB nStartTab; SCCOL nEndCol; SCROW nEndRow; SCTAB nEndTab; if (GetSimpleArea(nStartCol,nStartRow,nStartTab,nEndCol,nEndRow,nEndTab) == SC_MARK_SIMPLE) if (nStartRow==0 && nEndRow==MAXROW) return TRUE; return FALSE; } BOOL ScViewData::SimpleRowMarked() { SCCOL nStartCol; SCROW nStartRow; SCTAB nStartTab; SCCOL nEndCol; SCROW nEndRow; SCTAB nEndTab; if (GetSimpleArea(nStartCol,nStartRow,nStartTab,nEndCol,nEndRow,nEndTab) == SC_MARK_SIMPLE) if (nStartCol==0 && nEndCol==MAXCOL) return TRUE; return FALSE; } BOOL ScViewData::IsMultiMarked() { // Test for "real" multi selection, calling MarkToSimple on a local copy, // and taking filtered in simple area marks into account. ScRange aDummy; ScMarkType eType = GetSimpleArea(aDummy); return (eType & SC_MARK_SIMPLE) != SC_MARK_SIMPLE; } void ScViewData::SetFillMode( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow ) { nFillMode = SC_FILL_FILL; nFillStartX = nStartCol; nFillStartY = nStartRow; nFillEndX = nEndCol; nFillEndY = nEndRow; } void ScViewData::SetDragMode( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, BYTE nMode ) { nFillMode = nMode; nFillStartX = nStartCol; nFillStartY = nStartRow; nFillEndX = nEndCol; nFillEndY = nEndRow; } void ScViewData::ResetFillMode() { nFillMode = SC_FILL_NONE; } void ScViewData::GetFillData( SCCOL& rStartCol, SCROW& rStartRow, SCCOL& rEndCol, SCROW& rEndRow ) { rStartCol = nFillStartX; rStartRow = nFillStartY; rEndCol = nFillEndX; rEndRow = nFillEndY; } SCCOL ScViewData::GetOldCurX() const { if (pThisTab->bOldCurValid) return pThisTab->nOldCurX; else return pThisTab->nCurX; } SCROW ScViewData::GetOldCurY() const { if (pThisTab->bOldCurValid) return pThisTab->nOldCurY; else return pThisTab->nCurY; } void ScViewData::SetOldCursor( SCCOL nNewX, SCROW nNewY ) { pThisTab->nOldCurX = nNewX; pThisTab->nOldCurY = nNewY; pThisTab->bOldCurValid = TRUE; } void ScViewData::ResetOldCursor() { pThisTab->bOldCurValid = FALSE; } Rectangle ScViewData::GetEditArea( ScSplitPos eWhich, SCCOL nPosX, SCROW nPosY, Window* pWin, const ScPatternAttr* pPattern, BOOL bForceToTop ) { return ScEditUtil( pDoc, nPosX, nPosY, nTabNo, GetScrPos(nPosX,nPosY,eWhich,TRUE), pWin, nPPTX, nPPTY, GetZoomX(), GetZoomY() ). GetEditArea( pPattern, bForceToTop ); } void ScViewData::SetEditEngine( ScSplitPos eWhich, ScEditEngineDefaulter* pNewEngine, Window* pWin, SCCOL nNewX, SCROW nNewY ) { BOOL bLayoutRTL = pDoc->IsLayoutRTL( nTabNo ); ScHSplitPos eHWhich = WhichH(eWhich); BOOL bWasThere = FALSE; if (pEditView[eWhich]) { // Wenn die View schon da ist, nichts aufrufen, was die Cursorposition aendert if (bEditActive[eWhich]) bWasThere = TRUE; else pEditView[eWhich]->SetEditEngine(pNewEngine); if (pEditView[eWhich]->GetWindow() != pWin) { pEditView[eWhich]->SetWindow(pWin); DBG_ERROR("EditView Window geaendert"); } } else { pEditView[eWhich] = new EditView( pNewEngine, pWin ); } // bei IdleFormat wird manchmal ein Cursor gemalt, wenn die View schon weg ist (23576) ULONG nEC = pNewEngine->GetControlWord(); pNewEngine->SetControlWord(nEC & ~EE_CNTRL_DOIDLEFORMAT); ULONG nVC = pEditView[eWhich]->GetControlWord(); pEditView[eWhich]->SetControlWord(nVC & ~EV_CNTRL_AUTOSCROLL); bEditActive[eWhich] = TRUE; const ScPatternAttr* pPattern = pDoc->GetPattern( nNewX, nNewY, nTabNo ); SvxCellHorJustify eJust = (SvxCellHorJustify)((const SvxHorJustifyItem&) pPattern->GetItem( ATTR_HOR_JUSTIFY )).GetValue(); BOOL bBreak = ( eJust == SVX_HOR_JUSTIFY_BLOCK ) || ((SfxBoolItem&)pPattern->GetItem(ATTR_LINEBREAK)).GetValue(); BOOL bAsianVertical = pNewEngine->IsVertical(); // set by InputHandler Rectangle aPixRect = ScEditUtil( pDoc, nNewX,nNewY,nTabNo, GetScrPos(nNewX,nNewY,eWhich), pWin, nPPTX,nPPTY,GetZoomX(),GetZoomY() ). GetEditArea( pPattern, TRUE ); // when right-aligned, leave space for the cursor // in vertical mode, editing is always right-aligned if ( nEditAdjust == SVX_ADJUST_RIGHT || bAsianVertical ) aPixRect.Right() += 1; Rectangle aOutputArea = pWin->PixelToLogic( aPixRect, GetLogicMode() ); pEditView[eWhich]->SetOutputArea( aOutputArea ); if ( bActive && eWhich == GetActivePart() ) { // keep the part that has the active edit view available after // switching sheets or reference input on a different part eEditActivePart = eWhich; // modify members nEditCol etc. only if also extending for needed area nEditCol = nNewX; nEditRow = nNewY; const ScMergeAttr* pMergeAttr = (ScMergeAttr*)&pPattern->GetItem(ATTR_MERGE); nEditEndCol = nEditCol; if (pMergeAttr->GetColMerge() > 1) nEditEndCol += pMergeAttr->GetColMerge() - 1; nEditEndRow = nEditRow; if (pMergeAttr->GetRowMerge() > 1) nEditEndRow += pMergeAttr->GetRowMerge() - 1; nEditStartCol = nEditCol; // For growing use only the alignment value from the attribute, numbers // (existing or started) with default aligment extend to the right. BOOL bGrowCentered = ( eJust == SVX_HOR_JUSTIFY_CENTER ); BOOL bGrowToLeft = ( eJust == SVX_HOR_JUSTIFY_RIGHT ); // visual left BOOL bGrowBackwards = bGrowToLeft; // logical left if ( bLayoutRTL ) bGrowBackwards = !bGrowBackwards; // invert on RTL sheet if ( bAsianVertical ) bGrowCentered = bGrowToLeft = bGrowBackwards = FALSE; // keep old behavior for asian mode long nSizeXPix; if (bBreak && !bAsianVertical) nSizeXPix = aPixRect.GetWidth(); // Papersize -> kein H-Scrolling else { DBG_ASSERT(pView,"keine View fuer EditView"); if ( bGrowCentered ) { // growing into both directions until one edge is reached //! should be limited to whole cells in both directions long nLeft = aPixRect.Left(); long nRight = pView->GetGridWidth(eHWhich) - aPixRect.Right(); nSizeXPix = aPixRect.GetWidth() + 2 * Min( nLeft, nRight ); } else if ( bGrowToLeft ) nSizeXPix = aPixRect.Right(); // space that's available in the window when growing to the left else nSizeXPix = pView->GetGridWidth(eHWhich) - aPixRect.Left(); if ( nSizeXPix <= 0 ) nSizeXPix = aPixRect.GetWidth(); // editing outside to the right of the window -> keep cell width } DBG_ASSERT(pView,"keine View fuer EditView"); long nSizeYPix = pView->GetGridHeight(WhichV(eWhich)) - aPixRect.Top(); if ( nSizeYPix <= 0 ) nSizeYPix = aPixRect.GetHeight(); // editing outside below the window -> keep cell height Size aPaperSize = pView->GetActiveWin()->PixelToLogic( Size( nSizeXPix, nSizeYPix ), GetLogicMode() ); if ( bBreak && !bAsianVertical && SC_MOD()->GetInputOptions().GetTextWysiwyg() ) { // #95593# if text is formatted for printer, use the exact same paper width // (and same line breaks) as for output. Fraction aFract(1,1); Rectangle aUtilRect = ScEditUtil( pDoc,nNewX,nNewY,nTabNo, Point(0,0), pWin, HMM_PER_TWIPS, HMM_PER_TWIPS, aFract, aFract ).GetEditArea( pPattern, FALSE ); aPaperSize.Width() = aUtilRect.GetWidth(); } pNewEngine->SetPaperSize( aPaperSize ); // sichtbarer Ausschnitt Size aPaper = pNewEngine->GetPaperSize(); Rectangle aVis = pEditView[eWhich]->GetVisArea(); long nDiff = aVis.Right() - aVis.Left(); if ( nEditAdjust == SVX_ADJUST_RIGHT ) { aVis.Right() = aPaper.Width() - 1; bMoveArea = !bLayoutRTL; } else if ( nEditAdjust == SVX_ADJUST_CENTER ) { aVis.Right() = ( aPaper.Width() - 1 + nDiff ) / 2; bMoveArea = TRUE; // always } else { aVis.Right() = nDiff; bMoveArea = bLayoutRTL; } aVis.Left() = aVis.Right() - nDiff; // --> OD 2005-12-22 #i49561# // Important note: // The set offset of the visible area of the EditView for centered and // right alignment in horizontal layout is consider by instances of // class in its methods // and . This is needed for the correct visibility // of paragraphs in edit mode at the accessibility API. // <-- pEditView[eWhich]->SetVisArea(aVis); // // UpdateMode has been disabled in ScInputHandler::StartTable // must be enabled before EditGrowY (GetTextHeight) pNewEngine->SetUpdateMode( TRUE ); pNewEngine->SetStatusEventHdl( LINK( this, ScViewData, EditEngineHdl ) ); EditGrowY( TRUE ); // adjust to existing text content EditGrowX(); Point aDocPos = pEditView[eWhich]->GetWindowPosTopLeft(0); if (aDocPos.Y() < aOutputArea.Top()) pEditView[eWhich]->Scroll( 0, aOutputArea.Top() - aDocPos.Y() ); //! Status (Event) zuruecksetzen } // hier muss bEditActive schon gesetzt sein // (wegen Map-Mode bei Paint) if (!bWasThere) pNewEngine->InsertView(pEditView[eWhich]); // Hintergrundfarbe der Zelle Color aBackCol = ((const SvxBrushItem&)pPattern->GetItem(ATTR_BACKGROUND)).GetColor(); ScModule* pScMod = SC_MOD(); // #105733# SvtAccessibilityOptions::GetIsForBorders is no longer used (always assumed TRUE) if ( aBackCol.GetTransparency() > 0 || Application::GetSettings().GetStyleSettings().GetHighContrastMode() ) { aBackCol.SetColor( pScMod->GetColorConfig().GetColorValue(svtools::DOCCOLOR).nColor ); } pEditView[eWhich]->SetBackgroundColor( aBackCol ); pEditView[eWhich]->Invalidate(); // noetig ?? // noetig, wenn Position geaendert } IMPL_LINK_INLINE_START( ScViewData, EmptyEditHdl, EditStatus *, EMPTYARG ) { return 0; } IMPL_LINK_INLINE_END( ScViewData, EmptyEditHdl, EditStatus *, EMPTYARG ) IMPL_LINK( ScViewData, EditEngineHdl, EditStatus *, pStatus ) { ULONG nStatus = pStatus->GetStatusWord(); if (nStatus & (EE_STAT_HSCROLL | EE_STAT_TEXTHEIGHTCHANGED | EE_STAT_TEXTWIDTHCHANGED | EE_STAT_CURSOROUT)) { EditGrowY(); EditGrowX(); if (nStatus & EE_STAT_CURSOROUT) { ScSplitPos eWhich = GetActivePart(); if (pEditView[eWhich]) pEditView[eWhich]->ShowCursor(FALSE); } } return 0; } void ScViewData::EditGrowX() { ScDocument* pLocalDoc = GetDocument(); ScSplitPos eWhich = GetActivePart(); ScHSplitPos eHWhich = WhichH(eWhich); EditView* pCurView = pEditView[eWhich]; if ( !pCurView || !bEditActive[eWhich]) return; BOOL bLayoutRTL = pLocalDoc->IsLayoutRTL( nTabNo ); ScEditEngineDefaulter* pEngine = (ScEditEngineDefaulter*) pCurView->GetEditEngine(); Window* pWin = pCurView->GetWindow(); SCCOL nLeft = GetPosX(eHWhich); SCCOL nRight = nLeft + VisibleCellsX(eHWhich); Size aSize = pEngine->GetPaperSize(); Rectangle aArea = pCurView->GetOutputArea(); long nOldRight = aArea.Right(); // Margin ist schon bei der urspruenglichen Breite beruecksichtigt long nTextWidth = pEngine->CalcTextWidth(); BOOL bChanged = FALSE; BOOL bAsianVertical = pEngine->IsVertical(); // get bGrow... variables the same way as in SetEditEngine const ScPatternAttr* pPattern = pLocalDoc->GetPattern( nEditCol, nEditRow, nTabNo ); SvxCellHorJustify eJust = (SvxCellHorJustify)((const SvxHorJustifyItem&) pPattern->GetItem( ATTR_HOR_JUSTIFY )).GetValue(); BOOL bGrowCentered = ( eJust == SVX_HOR_JUSTIFY_CENTER ); BOOL bGrowToLeft = ( eJust == SVX_HOR_JUSTIFY_RIGHT ); // visual left BOOL bGrowBackwards = bGrowToLeft; // logical left if ( bLayoutRTL ) bGrowBackwards = !bGrowBackwards; // invert on RTL sheet if ( bAsianVertical ) bGrowCentered = bGrowToLeft = bGrowBackwards = FALSE; // keep old behavior for asian mode BOOL bUnevenGrow = FALSE; if ( bGrowCentered ) { while (aArea.GetWidth() + 0 < nTextWidth && ( nEditStartCol > nLeft || nEditEndCol < nRight ) ) { long nLogicLeft = 0; if ( nEditStartCol > nLeft ) { --nEditStartCol; long nLeftPix = ToPixel( pLocalDoc->GetColWidth( nEditStartCol, nTabNo ), nPPTX ); nLogicLeft = pWin->PixelToLogic(Size(nLeftPix,0)).Width(); } long nLogicRight = 0; if ( nEditEndCol < nRight ) { ++nEditEndCol; long nRightPix = ToPixel( pLocalDoc->GetColWidth( nEditEndCol, nTabNo ), nPPTX ); nLogicRight = pWin->PixelToLogic(Size(nRightPix,0)).Width(); } aArea.Left() -= bLayoutRTL ? nLogicRight : nLogicLeft; aArea.Right() += bLayoutRTL ? nLogicLeft : nLogicRight; if ( aArea.Right() > aArea.Left() + aSize.Width() - 1 ) { long nCenter = ( aArea.Left() + aArea.Right() ) / 2; long nHalf = aSize.Width() / 2; aArea.Left() = nCenter - nHalf + 1; aArea.Right() = nCenter + aSize.Width() - nHalf - 1; } bChanged = TRUE; if ( nLogicLeft != nLogicRight ) bUnevenGrow = TRUE; } } else if ( bGrowBackwards ) { while (aArea.GetWidth() + 0 < nTextWidth && nEditStartCol > nLeft) { --nEditStartCol; long nPix = ToPixel( pLocalDoc->GetColWidth( nEditStartCol, nTabNo ), nPPTX ); long nLogicWidth = pWin->PixelToLogic(Size(nPix,0)).Width(); if ( !bLayoutRTL ) aArea.Left() -= nLogicWidth; else aArea.Right() += nLogicWidth; if ( aArea.Right() > aArea.Left() + aSize.Width() - 1 ) { if ( !bLayoutRTL ) aArea.Left() = aArea.Right() - aSize.Width() + 1; else aArea.Right() = aArea.Left() + aSize.Width() - 1; } bChanged = TRUE; } } else { while (aArea.GetWidth() + 0 < nTextWidth && nEditEndCol < nRight) { ++nEditEndCol; long nPix = ToPixel( pLocalDoc->GetColWidth( nEditEndCol, nTabNo ), nPPTX ); long nLogicWidth = pWin->PixelToLogic(Size(nPix,0)).Width(); if ( bLayoutRTL ) aArea.Left() -= nLogicWidth; else aArea.Right() += nLogicWidth; if ( aArea.Right() > aArea.Left() + aSize.Width() - 1 ) { if ( bLayoutRTL ) aArea.Left() = aArea.Right() - aSize.Width() + 1; else aArea.Right() = aArea.Left() + aSize.Width() - 1; } bChanged = TRUE; } } if (bChanged) { if ( bMoveArea || bGrowCentered || bGrowBackwards || bLayoutRTL ) { Rectangle aVis = pCurView->GetVisArea(); if ( bGrowCentered ) { // switch to center-aligned (undo?) and reset VisArea to center pEngine->SetDefaultItem( SvxAdjustItem( SVX_ADJUST_CENTER, EE_PARA_JUST ) ); long nCenter = aSize.Width() / 2; long nVisSize = aArea.GetWidth(); aVis.Left() = nCenter - nVisSize / 2; aVis.Right() = aVis.Left() + nVisSize - 1; } else if ( bGrowToLeft ) { // switch to right-aligned (undo?) and reset VisArea to the right pEngine->SetDefaultItem( SvxAdjustItem( SVX_ADJUST_RIGHT, EE_PARA_JUST ) ); aVis.Right() = aSize.Width() - 1; aVis.Left() = aSize.Width() - aArea.GetWidth(); // with the new, increased area } else { // switch to left-aligned (undo?) and reset VisArea to the left pEngine->SetDefaultItem( SvxAdjustItem( SVX_ADJUST_LEFT, EE_PARA_JUST ) ); long nMove = aVis.Left(); aVis.Left() = 0; aVis.Right() -= nMove; } pCurView->SetVisArea( aVis ); bMoveArea = FALSE; } pCurView->SetOutputArea(aArea); // In vertical mode, the whole text is moved to the next cell (right-aligned), // so everything must be repainted. Otherwise, paint only the new area. // If growing in centered alignment, if the cells left and right have different sizes, // the whole text will move, and may not even obscure all of the original display. if ( bUnevenGrow ) { aArea.Left() = pWin->PixelToLogic( Point(0,0) ).X(); aArea.Right() = pWin->PixelToLogic( aScrSize ).Width(); } else if ( !bAsianVertical && !bGrowToLeft && !bGrowCentered ) aArea.Left() = nOldRight; pWin->Invalidate(aArea); } } void ScViewData::EditGrowY( BOOL bInitial ) { ScSplitPos eWhich = GetActivePart(); ScVSplitPos eVWhich = WhichV(eWhich); EditView* pCurView = pEditView[eWhich]; if ( !pCurView || !bEditActive[eWhich]) return; ULONG nControl = pEditView[eWhich]->GetControlWord(); if ( nControl & EV_CNTRL_AUTOSCROLL ) { // if end of screen had already been reached and scrolling enabled, // don't further try to grow the edit area pCurView->SetOutputArea( pCurView->GetOutputArea() ); // re-align to pixels return; } EditEngine* pEngine = pCurView->GetEditEngine(); Window* pWin = pCurView->GetWindow(); SCROW nBottom = GetPosY(eVWhich) + VisibleCellsY(eVWhich); Size aSize = pEngine->GetPaperSize(); Rectangle aArea = pCurView->GetOutputArea(); long nOldBottom = aArea.Bottom(); long nTextHeight = pEngine->GetTextHeight(); // #106635# When editing a formula in a cell with optimal height, allow a larger portion // to be clipped before extending to following rows, to avoid obscuring cells for // reference input (next row is likely to be useful in formulas). long nAllowedExtra = SC_GROWY_SMALL_EXTRA; if ( nEditEndRow == nEditRow && !( pDoc->GetRowFlags( nEditRow, nTabNo ) & CR_MANUALSIZE ) && pEngine->GetParagraphCount() <= 1 ) { // If the (only) paragraph starts with a '=', it's a formula. // If this is the initial call and the text is empty, allow the larger value, too, // because this occurs in the normal progress of editing a formula. // Subsequent calls with empty text might involve changed attributes (including // font height), so they are treated like normal text. String aText = pEngine->GetText( (USHORT) 0 ); if ( ( aText.Len() == 0 && bInitial ) || aText.GetChar(0) == (sal_Unicode)'=' ) nAllowedExtra = SC_GROWY_BIG_EXTRA; } BOOL bChanged = FALSE; BOOL bMaxReached = FALSE; while (aArea.GetHeight() + nAllowedExtra < nTextHeight && nEditEndRow < nBottom && !bMaxReached) { ++nEditEndRow; ScDocument* pLocalDoc = GetDocument(); long nPix = ToPixel( pLocalDoc->GetRowHeight( nEditEndRow, nTabNo ), nPPTY ); aArea.Bottom() += pWin->PixelToLogic(Size(0,nPix)).Height(); if ( aArea.Bottom() > aArea.Top() + aSize.Height() - 1 ) { aArea.Bottom() = aArea.Top() + aSize.Height() - 1; bMaxReached = TRUE; // don't occupy more cells beyond paper size } bChanged = TRUE; nAllowedExtra = SC_GROWY_SMALL_EXTRA; // larger value is only for first row } if (bChanged) { pCurView->SetOutputArea(aArea); if (nEditEndRow >= nBottom || bMaxReached) { if ((nControl & EV_CNTRL_AUTOSCROLL) == 0) pCurView->SetControlWord( nControl | EV_CNTRL_AUTOSCROLL ); } aArea.Top() = nOldBottom; pWin->Invalidate(aArea); } } void ScViewData::ResetEditView() { EditEngine* pEngine = NULL; for (USHORT i=0; i<4; i++) if (pEditView[i]) { if (bEditActive[i]) { pEngine = pEditView[i]->GetEditEngine(); pEngine->RemoveView(pEditView[i]); pEditView[i]->SetOutputArea( Rectangle() ); } bEditActive[i] = FALSE; } if (pEngine) pEngine->SetStatusEventHdl( LINK( this, ScViewData, EmptyEditHdl ) ); } void ScViewData::KillEditView() { for (USHORT i=0; i<4; i++) if (pEditView[i]) { if (bEditActive[i]) pEditView[i]->GetEditEngine()->RemoveView(pEditView[i]); delete pEditView[i]; pEditView[i] = NULL; } } void ScViewData::GetEditView( ScSplitPos eWhich, EditView*& rViewPtr, SCCOL& rCol, SCROW& rRow ) { rViewPtr = pEditView[eWhich]; rCol = nEditCol; rRow = nEditRow; } void ScViewData::CreateTabData( SCTAB nNewTab ) { if (!pTabData[nNewTab]) { pTabData[nNewTab] = new ScViewDataTable; pTabData[nNewTab]->eZoomType = eDefZoomType; pTabData[nNewTab]->aZoomX = aDefZoomX; pTabData[nNewTab]->aZoomY = aDefZoomY; pTabData[nNewTab]->aPageZoomX = aDefPageZoomX; pTabData[nNewTab]->aPageZoomY = aDefPageZoomY; } } void ScViewData::CreateSelectedTabData() { SCTAB nTabCount = pDoc->GetTableCount(); for (SCTAB i=0; ieWhichActive = eNewActive; } Point ScViewData::GetScrPos( SCCOL nWhereX, SCROW nWhereY, ScHSplitPos eWhich ) const { DBG_ASSERT( eWhich==SC_SPLIT_LEFT || eWhich==SC_SPLIT_RIGHT, "Falsche Position" ); ScSplitPos ePos = ( eWhich == SC_SPLIT_LEFT ) ? SC_SPLIT_BOTTOMLEFT : SC_SPLIT_BOTTOMRIGHT; return GetScrPos( nWhereX, nWhereY, ePos ); } Point ScViewData::GetScrPos( SCCOL nWhereX, SCROW nWhereY, ScVSplitPos eWhich ) const { DBG_ASSERT( eWhich==SC_SPLIT_TOP || eWhich==SC_SPLIT_BOTTOM, "Falsche Position" ); ScSplitPos ePos = ( eWhich == SC_SPLIT_TOP ) ? SC_SPLIT_TOPLEFT : SC_SPLIT_BOTTOMLEFT; return GetScrPos( nWhereX, nWhereY, ePos ); } Point ScViewData::GetScrPos( SCCOL nWhereX, SCROW nWhereY, ScSplitPos eWhich, BOOL bAllowNeg ) const { ScHSplitPos eWhichX = SC_SPLIT_LEFT; ScVSplitPos eWhichY = SC_SPLIT_BOTTOM; switch( eWhich ) { case SC_SPLIT_TOPLEFT: eWhichX = SC_SPLIT_LEFT; eWhichY = SC_SPLIT_TOP; break; case SC_SPLIT_TOPRIGHT: eWhichX = SC_SPLIT_RIGHT; eWhichY = SC_SPLIT_TOP; break; case SC_SPLIT_BOTTOMLEFT: eWhichX = SC_SPLIT_LEFT; eWhichY = SC_SPLIT_BOTTOM; break; case SC_SPLIT_BOTTOMRIGHT: eWhichX = SC_SPLIT_RIGHT; eWhichY = SC_SPLIT_BOTTOM; break; } if (pView) { ((ScViewData*)this)->aScrSize.Width() = pView->GetGridWidth(eWhichX); ((ScViewData*)this)->aScrSize.Height() = pView->GetGridHeight(eWhichY); } USHORT nTSize; SCCOL nPosX = GetPosX(eWhichX); SCCOL nX; long nScrPosX=0; if (nWhereX >= nPosX) for (nX=nPosX; nX MAXCOL ) nScrPosX = 65535; else { nTSize = pDoc->GetColWidth( nX, nTabNo ); if (nTSize) { long nSizeXPix = ToPixel( nTSize, nPPTX ); nScrPosX += nSizeXPix; } } } else if (bAllowNeg) for (nX=nPosX; nX>nWhereX;) { --nX; nTSize = pDoc->GetColWidth( nX, nTabNo ); if (nTSize) { long nSizeXPix = ToPixel( nTSize, nPPTX ); nScrPosX -= nSizeXPix; } } SCROW nPosY = GetPosY(eWhichY); SCROW nY; long nScrPosY=0; if (nWhereY >= nPosY) for (nY=nPosY; nY MAXROW ) nScrPosY = 65535; else { nTSize = pDoc->GetRowHeight( nY, nTabNo ); if (nTSize) { long nSizeYPix = ToPixel( nTSize, nPPTY ); nScrPosY += nSizeYPix; } else if ( nY < MAXROW ) { // skip multiple hidden rows (forward only for now) SCROW nNext = pDoc->FirstVisibleRow(nY + 1, MAXROW, nTabNo); if ( nNext > MAXROW ) nY = MAXROW; else nY = nNext - 1; // +=nDir advances to next visible row } } } else if (bAllowNeg) for (nY=nPosY; nY>nWhereY;) { --nY; nTSize = pDoc->GetRowHeight( nY, nTabNo ); if (nTSize) { long nSizeYPix = ToPixel( nTSize, nPPTY ); nScrPosY -= nSizeYPix; } } if ( pDoc->IsLayoutRTL( nTabNo ) ) { // mirror horizontal position nScrPosX = aScrSize.Width() - 1 - nScrPosX; } if (nScrPosX > 32767) nScrPosX=32767; if (nScrPosY > 32767) nScrPosY=32767; return Point( nScrPosX, nScrPosY ); } // // Anzahl Zellen auf einem Bildschirm // SCCOL ScViewData::CellsAtX( SCsCOL nPosX, SCsCOL nDir, ScHSplitPos eWhichX, USHORT nScrSizeX ) const { DBG_ASSERT( nDir==1 || nDir==-1, "falscher CellsAt Aufruf" ); if (pView) ((ScViewData*)this)->aScrSize.Width() = pView->GetGridWidth(eWhichX); SCsCOL nX; USHORT nScrPosX = 0; if (nScrSizeX == SC_SIZE_NONE) nScrSizeX = (USHORT) aScrSize.Width(); if (nDir==1) nX = nPosX; // vorwaerts else nX = nPosX-1; // rueckwaerts BOOL bOut = FALSE; for ( ; nScrPosX<=nScrSizeX && !bOut; nX = sal::static_int_cast(nX + nDir) ) { SCsCOL nColNo = nX; if ( nColNo < 0 || nColNo > MAXCOL ) bOut = TRUE; else { USHORT nTSize = pDoc->GetColWidth( nColNo, nTabNo ); if (nTSize) { long nSizeXPix = ToPixel( nTSize, nPPTX ); nScrPosX = sal::static_int_cast( nScrPosX + (USHORT) nSizeXPix ); } } } if (nDir==1) nX = sal::static_int_cast( nX - nPosX ); else nX = (nPosX-1)-nX; if (nX>0) --nX; return nX; } SCROW ScViewData::CellsAtY( SCsROW nPosY, SCsROW nDir, ScVSplitPos eWhichY, USHORT nScrSizeY ) const { DBG_ASSERT( nDir==1 || nDir==-1, "falscher CellsAt Aufruf" ); if (pView) ((ScViewData*)this)->aScrSize.Height() = pView->GetGridHeight(eWhichY); if (nScrSizeY == SC_SIZE_NONE) nScrSizeY = (USHORT) aScrSize.Height(); SCROW nY; if (nDir==1) { // forward nY = nPosY; long nScrPosY = 0; AddPixelsWhile( nScrPosY, nScrSizeY, nY, MAXROW, nPPTY, pDoc, nTabNo); // Original loop ended on last evaluated +1 or if that was MAXROW even // on MAXROW+2. nY += (nY == MAXROW ? 2 : 1); nY -= nPosY; } else { // backward nY = nPosY-1; long nScrPosY = 0; AddPixelsWhileBackward( nScrPosY, nScrSizeY, nY, 0, nPPTY, pDoc, nTabNo); // Original loop ended on last evaluated -1 or if that was 0 even on // -2. nY -= (nY == 0 ? 2 : 1); nY = (nPosY-1)-nY; } if (nY>0) --nY; return nY; } SCCOL ScViewData::VisibleCellsX( ScHSplitPos eWhichX ) const { return CellsAtX( GetPosX( eWhichX ), 1, eWhichX, SC_SIZE_NONE ); } SCROW ScViewData::VisibleCellsY( ScVSplitPos eWhichY ) const { return CellsAtY( GetPosY( eWhichY ), 1, eWhichY, SC_SIZE_NONE ); } SCCOL ScViewData::PrevCellsX( ScHSplitPos eWhichX ) const { return CellsAtX( GetPosX( eWhichX ), -1, eWhichX, SC_SIZE_NONE ); } SCROW ScViewData::PrevCellsY( ScVSplitPos eWhichY ) const { return CellsAtY( GetPosY( eWhichY ), -1, eWhichY, SC_SIZE_NONE ); } //UNUSED2008-05 SCCOL ScViewData::LastCellsX( ScHSplitPos eWhichX ) const //UNUSED2008-05 { //UNUSED2008-05 return CellsAtX( MAXCOL+1, -1, eWhichX, SC_SIZE_NONE ); //UNUSED2008-05 } //UNUSED2008-05 //UNUSED2008-05 SCROW ScViewData::LastCellsY( ScVSplitPos eWhichY ) const //UNUSED2008-05 { //UNUSED2008-05 return CellsAtY( MAXROW+1, -1, eWhichY, SC_SIZE_NONE ); //UNUSED2008-05 } BOOL ScViewData::GetMergeSizePixel( SCCOL nX, SCROW nY, long& rSizeXPix, long& rSizeYPix ) { const ScMergeAttr* pMerge = (const ScMergeAttr*) pDoc->GetAttr( nX,nY,nTabNo, ATTR_MERGE ); if ( pMerge->GetColMerge() > 1 || pMerge->GetRowMerge() > 1 ) { long nOutWidth = 0; long nOutHeight = 0; SCCOL nCountX = pMerge->GetColMerge(); for (SCCOL i=0; iGetColWidth(nX+i,nTabNo), nPPTX ); SCROW nCountY = pMerge->GetRowMerge(); for (SCROW nRow = nY; nRow <= nY+nCountY-1; ++nRow) { SCROW nLastRow = nRow; if (pDoc->RowHidden(nRow, nTabNo, NULL, &nLastRow)) { nRow = nLastRow; continue; } USHORT nHeight = pDoc->GetRowHeight(nRow, nTabNo); nOutHeight += ToPixel(nHeight, nPPTY); } rSizeXPix = nOutWidth; rSizeYPix = nOutHeight; return TRUE; } else { rSizeXPix = ToPixel( pDoc->GetColWidth( nX, nTabNo ), nPPTX ); rSizeYPix = ToPixel( pDoc->GetRowHeight( nY, nTabNo ), nPPTY ); return FALSE; } } BOOL ScViewData::GetPosFromPixel( long nClickX, long nClickY, ScSplitPos eWhich, SCsCOL& rPosX, SCsROW& rPosY, BOOL bTestMerge, BOOL bRepair, BOOL bNextIfLarge ) { // special handling of 0 is now in ScViewFunctionSet::SetCursorAtPoint ScHSplitPos eHWhich = WhichH(eWhich); ScVSplitPos eVWhich = WhichV(eWhich); if ( pDoc->IsLayoutRTL( nTabNo ) ) { // mirror horizontal position if (pView) aScrSize.Width() = pView->GetGridWidth(eHWhich); nClickX = aScrSize.Width() - 1 - nClickX; } SCsCOL nStartPosX = GetPosX(eHWhich); SCsROW nStartPosY = GetPosY(eVWhich); rPosX = nStartPosX; rPosY = nStartPosY; long nScrX = 0; long nScrY = 0; if (nClickX > 0) { while ( rPosX<=MAXCOL && nClickX >= nScrX ) { nScrX += ToPixel( pDoc->GetColWidth( rPosX, nTabNo ), nPPTX ); ++rPosX; } --rPosX; } else { while ( rPosX>0 && nClickX < nScrX ) { --rPosX; nScrX -= ToPixel( pDoc->GetColWidth( rPosX, nTabNo ), nPPTX ); } } if (nClickY > 0) AddPixelsWhile( nScrY, nClickY, rPosY, MAXROW, nPPTY, pDoc, nTabNo ); else { /* TODO: could need some "SubPixelsWhileBackward" method */ while ( rPosY>0 && nClickY < nScrY ) { --rPosY; nScrY -= ToPixel( pDoc->GetRowHeight( rPosY, nTabNo ), nPPTY ); } } if (bNextIfLarge) // zu grosse Zellen ? { if ( rPosX == nStartPosX && nClickX > 0 ) { if (pView) aScrSize.Width() = pView->GetGridWidth(eHWhich); if ( nClickX > aScrSize.Width() ) ++rPosX; } if ( rPosY == nStartPosY && nClickY > 0 ) { if (pView) aScrSize.Height() = pView->GetGridHeight(eVWhich); if ( nClickY > aScrSize.Height() ) ++rPosY; } } if (rPosX<0) rPosX=0; if (rPosX>MAXCOL) rPosX=MAXCOL; if (rPosY<0) rPosY=0; if (rPosY>MAXROW) rPosY=MAXROW; if (bTestMerge) { //! public Methode um Position anzupassen BOOL bHOver = FALSE; while (pDoc->IsHorOverlapped( rPosX, rPosY, nTabNo )) { --rPosX; bHOver=TRUE; } BOOL bVOver = FALSE; while (pDoc->IsVerOverlapped( rPosX, rPosY, nTabNo )) { --rPosY; bVOver=TRUE; } if ( bRepair && ( bHOver || bVOver ) ) { const ScMergeAttr* pMerge = (const ScMergeAttr*) pDoc->GetAttr( rPosX, rPosY, nTabNo, ATTR_MERGE ); if ( ( bHOver && pMerge->GetColMerge() <= 1 ) || ( bVOver && pMerge->GetRowMerge() <= 1 ) ) { DBG_ERROR("Merge-Fehler gefunden"); pDoc->RemoveFlagsTab( 0,0, MAXCOL,MAXROW, nTabNo, SC_MF_HOR | SC_MF_VER ); SCCOL nEndCol = MAXCOL; SCROW nEndRow = MAXROW; pDoc->ExtendMerge( 0,0, nEndCol,nEndRow, nTabNo, TRUE, FALSE ); if (pDocShell) pDocShell->PostPaint( ScRange(0,0,nTabNo,MAXCOL,MAXROW,nTabNo), PAINT_GRID ); } } } return FALSE; } void ScViewData::GetMouseQuadrant( const Point& rClickPos, ScSplitPos eWhich, SCsCOL nPosX, SCsROW nPosY, BOOL& rLeft, BOOL& rTop ) { BOOL bLayoutRTL = pDoc->IsLayoutRTL( nTabNo ); long nLayoutSign = bLayoutRTL ? -1 : 1; Point aCellStart = GetScrPos( nPosX, nPosY, eWhich, TRUE ); long nSizeX; long nSizeY; GetMergeSizePixel( nPosX, nPosY, nSizeX, nSizeY ); rLeft = ( rClickPos.X() - aCellStart.X() ) * nLayoutSign <= nSizeX / 2; rTop = rClickPos.Y() - aCellStart.Y() <= nSizeY / 2; } void ScViewData::SetPosX( ScHSplitPos eWhich, SCCOL nNewPosX ) { if (nNewPosX != 0) { SCCOL nOldPosX = pThisTab->nPosX[eWhich]; long nTPosX = pThisTab->nTPosX[eWhich]; long nPixPosX = pThisTab->nPixPosX[eWhich]; SCCOL i; if ( nNewPosX > nOldPosX ) for ( i=nOldPosX; iGetColWidth( i,nTabNo ); nTPosX -= nThis; nPixPosX -= ToPixel(sal::static_int_cast(nThis), nPPTX); } else for ( i=nNewPosX; iGetColWidth( i,nTabNo ); nTPosX += nThis; nPixPosX += ToPixel(sal::static_int_cast(nThis), nPPTX); } pThisTab->nPosX[eWhich] = nNewPosX; pThisTab->nTPosX[eWhich] = nTPosX; pThisTab->nMPosX[eWhich] = (long) (nTPosX * HMM_PER_TWIPS); pThisTab->nPixPosX[eWhich] = nPixPosX; } else pThisTab->nPixPosX[eWhich] = pThisTab->nTPosX[eWhich] = pThisTab->nMPosX[eWhich] = pThisTab->nPosX[eWhich] = 0; } void ScViewData::SetPosY( ScVSplitPos eWhich, SCROW nNewPosY ) { if (nNewPosY != 0) { SCROW nOldPosY = pThisTab->nPosY[eWhich]; long nTPosY = pThisTab->nTPosY[eWhich]; long nPixPosY = pThisTab->nPixPosY[eWhich]; SCROW i, nHeightEndRow; if ( nNewPosY > nOldPosY ) for ( i=nOldPosY; iGetRowHeight( i, nTabNo, NULL, &nHeightEndRow ); SCROW nRows = std::min( nNewPosY, nHeightEndRow + 1) - i; i = nHeightEndRow; nTPosY -= nThis * nRows; nPixPosY -= ToPixel(sal::static_int_cast(nThis), nPPTY) * nRows; } else for ( i=nNewPosY; iGetRowHeight( i, nTabNo, NULL, &nHeightEndRow ); SCROW nRows = std::min( nOldPosY, nHeightEndRow + 1) - i; i = nHeightEndRow; nTPosY += nThis * nRows; nPixPosY += ToPixel(sal::static_int_cast(nThis), nPPTY) * nRows; } pThisTab->nPosY[eWhich] = nNewPosY; pThisTab->nTPosY[eWhich] = nTPosY; pThisTab->nMPosY[eWhich] = (long) (nTPosY * HMM_PER_TWIPS); pThisTab->nPixPosY[eWhich] = nPixPosY; } else pThisTab->nPixPosY[eWhich] = pThisTab->nTPosY[eWhich] = pThisTab->nMPosY[eWhich] = pThisTab->nPosY[eWhich] = 0; } void ScViewData::RecalcPixPos() // nach Zoom-Aenderungen { for (USHORT eWhich=0; eWhich<2; eWhich++) { long nPixPosX = 0; SCCOL nPosX = pThisTab->nPosX[eWhich]; for (SCCOL i=0; iGetColWidth(i,nTabNo), nPPTX); pThisTab->nPixPosX[eWhich] = nPixPosX; long nPixPosY = 0; SCROW nPosY = pThisTab->nPosY[eWhich]; for (SCROW j=0; jGetRowHeight(j,nTabNo), nPPTY); pThisTab->nPixPosY[eWhich] = nPixPosY; } } const MapMode& ScViewData::GetLogicMode( ScSplitPos eWhich ) { aLogicMode.SetOrigin( Point( pThisTab->nMPosX[WhichH(eWhich)], pThisTab->nMPosY[WhichV(eWhich)] ) ); return aLogicMode; } const MapMode& ScViewData::GetLogicMode() { aLogicMode.SetOrigin( Point() ); return aLogicMode; } void ScViewData::SetScreen( SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2 ) { SCCOL nCol; SCROW nRow; USHORT nTSize; long nSizePix; long nScrPosX = 0; long nScrPosY = 0; SetActivePart( SC_SPLIT_BOTTOMLEFT ); SetPosX( SC_SPLIT_LEFT, nCol1 ); SetPosY( SC_SPLIT_BOTTOM, nRow1 ); for (nCol=nCol1; nCol<=nCol2; nCol++) { nTSize = pDoc->GetColWidth( nCol, nTabNo ); if (nTSize) { nSizePix = ToPixel( nTSize, nPPTX ); nScrPosX += (USHORT) nSizePix; } } for (nRow=nRow1; nRow<=nRow2; nRow++) { nTSize = pDoc->GetRowHeight( nRow, nTabNo ); if (nTSize) { nSizePix = ToPixel( nTSize, nPPTY ); nScrPosY += (USHORT) nSizePix; } } aScrSize = Size( nScrPosX, nScrPosY ); } void ScViewData::SetScreenPos( const Point& rVisAreaStart ) { long nSize; long nTwips; long nAdd; BOOL bEnd; nSize = 0; nTwips = (long) (rVisAreaStart.X() / HMM_PER_TWIPS); if ( pDoc->IsLayoutRTL( nTabNo ) ) nTwips = -nTwips; SCCOL nX1 = 0; bEnd = FALSE; while (!bEnd) { nAdd = (long) pDoc->GetColWidth(nX1,nTabNo); if (nSize+nAdd <= nTwips+1 && nX1GetRowHeight(nY1,nTabNo); if (nSize+nAdd <= nTwips+1 && nY1GetViewFrame()->GetBindings(); } SfxDispatcher& ScViewData::GetDispatcher() { DBG_ASSERT( pViewShell, "GetDispatcher() without ViewShell" ); return *pViewShell->GetViewFrame()->GetDispatcher(); } Window* ScViewData::GetDialogParent() { DBG_ASSERT( pViewShell, "GetDialogParent() ohne ViewShell" ); return pViewShell->GetDialogParent(); } Window* ScViewData::GetActiveWin() { DBG_ASSERT( pView, "GetActiveWin() ohne View" ); return pView->GetActiveWin(); } ScDrawView* ScViewData::GetScDrawView() { DBG_ASSERT( pView, "GetScDrawView() ohne View" ); return pView->GetScDrawView(); } BOOL ScViewData::IsMinimized() { DBG_ASSERT( pView, "IsMinimized() ohne View" ); return pView->IsMinimized(); } void ScViewData::UpdateScreenZoom( const Fraction& rNewX, const Fraction& rNewY ) { Fraction aOldX = GetZoomX(); Fraction aOldY = GetZoomY(); SetZoom( rNewX, rNewY, FALSE ); Fraction aWidth = GetZoomX(); aWidth *= Fraction( aScrSize.Width(),1 ); aWidth /= aOldX; Fraction aHeight = GetZoomY(); aHeight *= Fraction( aScrSize.Height(),1 ); aHeight /= aOldY; aScrSize.Width() = (long) aWidth; aScrSize.Height() = (long) aHeight; } void ScViewData::CalcPPT() { nPPTX = ScGlobal::nScreenPPTX * (double) GetZoomX(); if (pDocShell) nPPTX = nPPTX / pDocShell->GetOutputFactor(); // Faktor ist Drucker zu Bildschirm nPPTY = ScGlobal::nScreenPPTY * (double) GetZoomY(); // #83616# if detective objects are present, // try to adjust horizontal scale so the most common column width has minimal rounding errors, // to avoid differences between cell and drawing layer output if ( pDoc && pDoc->HasDetectiveObjects(nTabNo) ) { SCCOL nEndCol = 0; SCROW nDummy = 0; pDoc->GetTableArea( nTabNo, nEndCol, nDummy ); if (nEndCol<20) nEndCol = 20; // same end position as when determining draw scale USHORT nTwips = pDoc->GetCommonWidth( nEndCol, nTabNo ); if ( nTwips ) { double fOriginal = nTwips * nPPTX; if ( fOriginal < static_cast(nEndCol) ) { // if one column is smaller than the column count, // rounding errors are likely to add up to a whole column. double fRounded = ::rtl::math::approxFloor( fOriginal + 0.5 ); if ( fRounded > 0.0 ) { double fScale = fRounded / fOriginal + 1E-6; if ( fScale >= 0.9 && fScale <= 1.1 ) nPPTX *= fScale; } } } } } //------------------------------------------------------------------ #define SC_OLD_TABSEP '/' #define SC_NEW_TABSEP '+' void ScViewData::WriteUserData(String& rData) { // nZoom (bis 364v) oder nZoom/nPageZoom/bPageMode (ab 364w) // nTab // Tab-ControlBreite // pro Tabelle: // CursorX/CursorY/HSplitMode/VSplitMode/HSplitPos/VSplitPos/SplitActive/ // PosX[links]/PosX[rechts]/PosY[oben]/PosY[unten] // wenn Zeilen groesser 8192, "+" statt "/" USHORT nZoom = (USHORT)((pThisTab->aZoomY.GetNumerator() * 100) / pThisTab->aZoomY.GetDenominator()); rData = String::CreateFromInt32( nZoom ); rData += '/'; nZoom = (USHORT)((pThisTab->aPageZoomY.GetNumerator() * 100) / pThisTab->aPageZoomY.GetDenominator()); rData += String::CreateFromInt32( nZoom ); rData += '/'; if (bPagebreak) rData += '1'; else rData += '0'; rData += ';'; rData += String::CreateFromInt32( nTabNo ); rData += ';'; rData.AppendAscii(RTL_CONSTASCII_STRINGPARAM( TAG_TABBARWIDTH )); rData += String::CreateFromInt32( pView->GetTabBarWidth() ); SCTAB nTabCount = pDoc->GetTableCount(); for (SCTAB i=0; inCurY > MAXROW_30 || pTabData[i]->nPosY[0] > MAXROW_30 || pTabData[i]->nPosY[1] > MAXROW_30 || ( pTabData[i]->eVSplitMode == SC_SPLIT_FIX && pTabData[i]->nFixPosY > MAXROW_30 ) ) { cTabSep = SC_NEW_TABSEP; // um eine 3.1-Version nicht umzubringen } rData += String::CreateFromInt32( pTabData[i]->nCurX ); rData += cTabSep; rData += String::CreateFromInt32( pTabData[i]->nCurY ); rData += cTabSep; rData += String::CreateFromInt32( pTabData[i]->eHSplitMode ); rData += cTabSep; rData += String::CreateFromInt32( pTabData[i]->eVSplitMode ); rData += cTabSep; if ( pTabData[i]->eHSplitMode == SC_SPLIT_FIX ) rData += String::CreateFromInt32( pTabData[i]->nFixPosX ); else rData += String::CreateFromInt32( pTabData[i]->nHSplitPos ); rData += cTabSep; if ( pTabData[i]->eVSplitMode == SC_SPLIT_FIX ) rData += String::CreateFromInt32( pTabData[i]->nFixPosY ); else rData += String::CreateFromInt32( pTabData[i]->nVSplitPos ); rData += cTabSep; rData += String::CreateFromInt32( pTabData[i]->eWhichActive ); rData += cTabSep; rData += String::CreateFromInt32( pTabData[i]->nPosX[0] ); rData += cTabSep; rData += String::CreateFromInt32( pTabData[i]->nPosX[1] ); rData += cTabSep; rData += String::CreateFromInt32( pTabData[i]->nPosY[0] ); rData += cTabSep; rData += String::CreateFromInt32( pTabData[i]->nPosY[1] ); } } } void ScViewData::ReadUserData(const String& rData) { if (!rData.Len()) // Leerer String kommt bei "neu Laden" return; // dann auch ohne Assertion beenden xub_StrLen nCount = rData.GetTokenCount(';'); if ( nCount <= 2 ) { // #45208# beim Reload in der Seitenansicht sind evtl. die Preview-UserData // stehengelassen worden. Den Zoom von der Preview will man hier nicht... DBG_ERROR("ReadUserData: das sind nicht meine Daten"); return; } String aTabOpt; xub_StrLen nTagLen = String::CreateFromAscii(RTL_CONSTASCII_STRINGPARAM(TAG_TABBARWIDTH)).Len(); //------------------- // nicht pro Tabelle: //------------------- SCTAB nTabStart = 2; Fraction aZoomX, aZoomY, aPageZoomX, aPageZoomY; //! evaluate (all sheets?) String aZoomStr = rData.GetToken(0); // Zoom/PageZoom/Modus USHORT nNormZoom = sal::static_int_cast(aZoomStr.GetToken(0,'/').ToInt32()); if ( nNormZoom >= MINZOOM && nNormZoom <= MAXZOOM ) aZoomX = aZoomY = Fraction( nNormZoom, 100 ); // "normaler" Zoom (immer) USHORT nPageZoom = sal::static_int_cast(aZoomStr.GetToken(1,'/').ToInt32()); if ( nPageZoom >= MINZOOM && nPageZoom <= MAXZOOM ) aPageZoomX = aPageZoomY = Fraction( nPageZoom, 100 ); // Pagebreak-Zoom, wenn gesetzt sal_Unicode cMode = aZoomStr.GetToken(2,'/').GetChar(0); // 0 oder "0"/"1" SetPagebreakMode( cMode == '1' ); // SetPagebreakMode muss immer gerufen werden wegen CalcPPT / RecalcPixPos() // // Tabelle kann ungueltig geworden sein (z.B. letzte Version): // SCTAB nNewTab = static_cast(rData.GetToken(1).ToInt32()); if (pDoc->HasTable( nNewTab )) SetTabNo(nNewTab); // // wenn vorhanden, TabBar-Breite holen: // aTabOpt = rData.GetToken(2); if ( nTagLen && aTabOpt.Copy(0,nTagLen).EqualsAscii(TAG_TABBARWIDTH) ) { pView->SetTabBarWidth( aTabOpt.Copy(nTagLen).ToInt32() ); nTabStart = 3; } //------------- // pro Tabelle: //------------- SCTAB nPos = 0; while ( nCount > nPos+nTabStart ) { aTabOpt = rData.GetToken(static_cast(nPos+nTabStart)); if (!pTabData[nPos]) pTabData[nPos] = new ScViewDataTable; sal_Unicode cTabSep = 0; if (aTabOpt.GetTokenCount(SC_OLD_TABSEP) >= 11) cTabSep = SC_OLD_TABSEP; #ifndef SC_LIMIT_ROWS else if (aTabOpt.GetTokenCount(SC_NEW_TABSEP) >= 11) cTabSep = SC_NEW_TABSEP; // '+' ist nur erlaubt, wenn wir mit Zeilen > 8192 umgehen koennen #endif if (cTabSep) { pTabData[nPos]->nCurX = SanitizeCol( static_cast(aTabOpt.GetToken(0,cTabSep).ToInt32())); pTabData[nPos]->nCurY = SanitizeRow( aTabOpt.GetToken(1,cTabSep).ToInt32()); pTabData[nPos]->eHSplitMode = (ScSplitMode) aTabOpt.GetToken(2,cTabSep).ToInt32(); pTabData[nPos]->eVSplitMode = (ScSplitMode) aTabOpt.GetToken(3,cTabSep).ToInt32(); if ( pTabData[nPos]->eHSplitMode == SC_SPLIT_FIX ) { pTabData[nPos]->nFixPosX = SanitizeCol( static_cast(aTabOpt.GetToken(4,cTabSep).ToInt32())); UpdateFixX(nPos); } else pTabData[nPos]->nHSplitPos = aTabOpt.GetToken(4,cTabSep).ToInt32(); if ( pTabData[nPos]->eVSplitMode == SC_SPLIT_FIX ) { pTabData[nPos]->nFixPosY = SanitizeRow( aTabOpt.GetToken(5,cTabSep).ToInt32()); UpdateFixY(nPos); } else pTabData[nPos]->nVSplitPos = aTabOpt.GetToken(5,cTabSep).ToInt32(); pTabData[nPos]->eWhichActive = (ScSplitPos) aTabOpt.GetToken(6,cTabSep).ToInt32(); pTabData[nPos]->nPosX[0] = SanitizeCol( static_cast(aTabOpt.GetToken(7,cTabSep).ToInt32())); pTabData[nPos]->nPosX[1] = SanitizeCol( static_cast(aTabOpt.GetToken(8,cTabSep).ToInt32())); pTabData[nPos]->nPosY[0] = SanitizeRow( aTabOpt.GetToken(9,cTabSep).ToInt32()); pTabData[nPos]->nPosY[1] = SanitizeRow( aTabOpt.GetToken(10,cTabSep).ToInt32()); // Test, ob der aktive Teil laut SplitMode ueberhaupt existiert // (Bug #44516#) ScSplitPos eTest = pTabData[nPos]->eWhichActive; if ( ( WhichH( eTest ) == SC_SPLIT_RIGHT && pTabData[nPos]->eHSplitMode == SC_SPLIT_NONE ) || ( WhichV( eTest ) == SC_SPLIT_TOP && pTabData[nPos]->eVSplitMode == SC_SPLIT_NONE ) ) { // dann wieder auf Default (unten links) pTabData[nPos]->eWhichActive = SC_SPLIT_BOTTOMLEFT; DBG_ERROR("SplitPos musste korrigiert werden"); } } ++nPos; } RecalcPixPos(); } void ScViewData::WriteExtOptions( ScExtDocOptions& rDocOpt ) const { // *** Fill extended document data for export filters *** // document settings ScExtDocSettings& rDocSett = rDocOpt.GetDocSettings(); // displayed sheet rDocSett.mnDisplTab = GetTabNo(); // width of the tabbar, relative to frame window width rDocSett.mfTabBarWidth = pView->GetPendingRelTabBarWidth(); if( rDocSett.mfTabBarWidth < 0.0 ) rDocSett.mfTabBarWidth = pView->GetRelTabBarWidth(); // sheet settings for( SCTAB nTab = 0, nTabCount = pDoc->GetTableCount(); nTab < nTabCount; ++nTab ) { if( const ScViewDataTable* pViewTab = pTabData[ nTab ] ) { ScExtTabSettings& rTabSett = rDocOpt.GetOrCreateTabSettings( nTab ); // split mode ScSplitMode eHSplit = pViewTab->eHSplitMode; ScSplitMode eVSplit = pViewTab->eVSplitMode; bool bHSplit = eHSplit != SC_SPLIT_NONE; bool bVSplit = eVSplit != SC_SPLIT_NONE; bool bRealSplit = (eHSplit == SC_SPLIT_NORMAL) || (eVSplit == SC_SPLIT_NORMAL); bool bFrozen = (eHSplit == SC_SPLIT_FIX) || (eVSplit == SC_SPLIT_FIX); DBG_ASSERT( !bRealSplit || !bFrozen, "ScViewData::WriteExtOptions - split and freeze in same sheet" ); rTabSett.mbFrozenPanes = !bRealSplit && bFrozen; // split and freeze position rTabSett.maSplitPos = Point( 0, 0 ); rTabSett.maFreezePos.Set( 0, 0, nTab ); if( bRealSplit ) { Point& rSplitPos = rTabSett.maSplitPos; rSplitPos = Point( bHSplit ? pViewTab->nHSplitPos : 0, bVSplit ? pViewTab->nVSplitPos : 0 ); rSplitPos = Application::GetDefaultDevice()->PixelToLogic( rSplitPos, MapMode( MAP_TWIP ) ); if( pDocShell ) rSplitPos.X() = (long)((double)rSplitPos.X() / pDocShell->GetOutputFactor()); } else if( bFrozen ) { if( bHSplit ) rTabSett.maFreezePos.SetCol( pViewTab->nFixPosX ); if( bVSplit ) rTabSett.maFreezePos.SetRow( pViewTab->nFixPosY ); } // first visible cell in top-left and additional panes rTabSett.maFirstVis.Set( pViewTab->nPosX[ SC_SPLIT_LEFT ], pViewTab->nPosY[ bVSplit ? SC_SPLIT_TOP : SC_SPLIT_BOTTOM ], nTab ); rTabSett.maSecondVis.Set( pViewTab->nPosX[ SC_SPLIT_RIGHT ], pViewTab->nPosY[ SC_SPLIT_BOTTOM ], nTab ); // active pane switch( pViewTab->eWhichActive ) { // no horizontal split -> always use left panes // no vertical split -> always use top panes case SC_SPLIT_TOPLEFT: rTabSett.meActivePane = SCEXT_PANE_TOPLEFT; break; case SC_SPLIT_TOPRIGHT: rTabSett.meActivePane = bHSplit ? SCEXT_PANE_TOPRIGHT : SCEXT_PANE_TOPLEFT; break; case SC_SPLIT_BOTTOMLEFT: rTabSett.meActivePane = bVSplit ? SCEXT_PANE_BOTTOMLEFT : SCEXT_PANE_TOPLEFT; break; case SC_SPLIT_BOTTOMRIGHT: rTabSett.meActivePane = bHSplit ? (bVSplit ? SCEXT_PANE_BOTTOMRIGHT : SCEXT_PANE_TOPRIGHT) : (bVSplit ? SCEXT_PANE_BOTTOMLEFT : SCEXT_PANE_TOPLEFT); break; } // cursor position rTabSett.maCursor.Set( pViewTab->nCurX, pViewTab->nCurY, nTab ); // sheet selection and selected ranges const ScMarkData& rMarkData = GetMarkData(); rTabSett.mbSelected = rMarkData.GetTableSelect( nTab ); rMarkData.FillRangeListWithMarks( &rTabSett.maSelection, TRUE ); // grid color rTabSett.maGridColor.SetColor( COL_AUTO ); if( pOptions ) { const Color& rGridColor = pOptions->GetGridColor(); if( rGridColor.GetColor() != SC_STD_GRIDCOLOR ) rTabSett.maGridColor = rGridColor; } // view mode and zoom rTabSett.mbPageMode = bPagebreak; rTabSett.mnNormalZoom = static_cast< long >( pViewTab->aZoomY * Fraction( 100.0 ) ); rTabSett.mnPageZoom = static_cast< long >( pViewTab->aPageZoomY * Fraction( 100.0 ) ); } } } void ScViewData::ReadExtOptions( const ScExtDocOptions& rDocOpt ) { // *** Get extended document data from import filters *** if( !rDocOpt.IsChanged() ) return; // document settings const ScExtDocSettings& rDocSett = rDocOpt.GetDocSettings(); // displayed sheet SetTabNo( rDocSett.mnDisplTab ); /* Width of the tabbar, relative to frame window width. We do not have the correct width of the frame window here -> store in ScTabView, which sets the size in the next resize. */ pView->SetPendingRelTabBarWidth( rDocSett.mfTabBarWidth ); // sheet settings for( SCTAB nTab = 0, nTabCount = pDoc->GetTableCount(); nTab < nTabCount; ++nTab ) { if( const ScExtTabSettings* pTabSett = rDocOpt.GetTabSettings( nTab ) ) { if( !pTabData[ nTab ] ) pTabData[ nTab ] = new ScViewDataTable; const ScExtTabSettings& rTabSett = *pTabSett; ScViewDataTable& rViewTab = *pTabData[ nTab ]; // split mode initialization bool bFrozen = rTabSett.mbFrozenPanes; bool bHSplit = bFrozen ? (rTabSett.maFreezePos.Col() > 0) : (rTabSett.maSplitPos.X() > 0); bool bVSplit = bFrozen ? (rTabSett.maFreezePos.Row() > 0) : (rTabSett.maSplitPos.Y() > 0); // first visible cell of top-left pane and additional panes rViewTab.nPosX[ SC_SPLIT_LEFT ] = rTabSett.maFirstVis.Col(); rViewTab.nPosY[ bVSplit ? SC_SPLIT_TOP : SC_SPLIT_BOTTOM ] = rTabSett.maFirstVis.Row(); if( bHSplit ) rViewTab.nPosX[ SC_SPLIT_RIGHT ] = rTabSett.maSecondVis.Col(); if( bVSplit ) rViewTab.nPosY[ SC_SPLIT_BOTTOM ] = rTabSett.maSecondVis.Row(); // split mode, split and freeze position rViewTab.eHSplitMode = rViewTab.eVSplitMode = SC_SPLIT_NONE; rViewTab.nHSplitPos = rViewTab.nVSplitPos = 0; rViewTab.nFixPosX = 0; rViewTab.nFixPosY = 0; if( bFrozen ) { if( bHSplit ) { rViewTab.eHSplitMode = SC_SPLIT_FIX; rViewTab.nFixPosX = rTabSett.maFreezePos.Col(); UpdateFixX( nTab ); } if( bVSplit ) { rViewTab.eVSplitMode = SC_SPLIT_FIX; rViewTab.nFixPosY = rTabSett.maFreezePos.Row(); UpdateFixY( nTab ); } } else { Point aPixel = Application::GetDefaultDevice()->LogicToPixel( rTabSett.maSplitPos, MapMode( MAP_TWIP ) ); //! Zoom? // #109648# - the test for use of printer metrics for text formatting here // effectively results in the nFactor = 1.0 regardless of the Option setting. if( pDocShell && SC_MOD()->GetInputOptions().GetTextWysiwyg()) { double nFactor = pDocShell->GetOutputFactor(); aPixel.X() = (long)( aPixel.X() * nFactor + 0.5 ); } if( bHSplit ) { rViewTab.eHSplitMode = SC_SPLIT_NORMAL; rViewTab.nHSplitPos = aPixel.X(); } if( bVSplit ) { rViewTab.eVSplitMode = SC_SPLIT_NORMAL; rViewTab.nVSplitPos = aPixel.Y(); } } // active pane ScSplitPos ePos = SC_SPLIT_BOTTOMLEFT; switch( rTabSett.meActivePane ) { // no horizontal split -> always use left panes // no vertical split -> always use *bottom* panes case SCEXT_PANE_TOPLEFT: ePos = bVSplit ? SC_SPLIT_TOPLEFT : SC_SPLIT_BOTTOMLEFT; break; case SCEXT_PANE_TOPRIGHT: ePos = bHSplit ? (bVSplit ? SC_SPLIT_TOPRIGHT : SC_SPLIT_BOTTOMRIGHT) : (bVSplit ? SC_SPLIT_TOPLEFT : SC_SPLIT_BOTTOMLEFT); break; case SCEXT_PANE_BOTTOMLEFT: ePos = SC_SPLIT_BOTTOMLEFT; break; case SCEXT_PANE_BOTTOMRIGHT: ePos = bHSplit ? SC_SPLIT_BOTTOMRIGHT : SC_SPLIT_BOTTOMLEFT; break; } rViewTab.eWhichActive = ePos; // cursor position const ScAddress& rCursor = rTabSett.maCursor; if( rCursor.IsValid() ) { rViewTab.nCurX = rCursor.Col(); rViewTab.nCurY = rCursor.Row(); } // sheet selection and selected ranges ScMarkData& rMarkData = GetMarkData(); rMarkData.SelectTable( nTab, rTabSett.mbSelected ); // zoom for each sheet if( rTabSett.mnNormalZoom ) rViewTab.aZoomX = rViewTab.aZoomY = Fraction( rTabSett.mnNormalZoom, 100L ); if( rTabSett.mnPageZoom ) rViewTab.aPageZoomX = rViewTab.aPageZoomY = Fraction( rTabSett.mnPageZoom, 100L ); // get some settings from displayed Excel sheet, set at Calc document if( nTab == GetTabNo() ) { // selection only for displayed sheet, do not select single cell // Disabled, does not work correctly. Anyway, our own XML filters do not import a selection at all. // const ScRangeList& rSel = rTabSett.maSelection; // if( (rSel.Count() >= 2) || ((rSel.Count() == 1) && (*rSel.GetObject( 0 ) != ScRange( rCursor ))) ) // rMarkData.MarkFromRangeList( rTabSett.maSelection, FALSE ); // grid color -- #i47435# set automatic grid color explicitly if( pOptions ) { Color aGridColor( rTabSett.maGridColor ); if( aGridColor.GetColor() == COL_AUTO ) aGridColor.SetColor( SC_STD_GRIDCOLOR ); pOptions->SetGridColor( aGridColor, EMPTY_STRING ); } // view mode and default zoom (for new sheets) from current sheet if( rTabSett.mnNormalZoom ) aDefZoomX = aDefZoomY = Fraction( rTabSett.mnNormalZoom, 100L ); if( rTabSett.mnPageZoom ) aDefPageZoomX = aDefPageZoomY = Fraction( rTabSett.mnPageZoom, 100L ); /* #i46820# set pagebreak mode via SetPagebreakMode(), this will update map modes that are needed to draw text correctly. */ SetPagebreakMode( rTabSett.mbPageMode ); } } } // RecalcPixPos oder so - auch nMPos - auch bei ReadUserData ??!?! } void ScViewData::WriteUserDataSequence(uno::Sequence & rSettings) { rSettings.realloc(SC_VIEWSETTINGS_COUNT); // + 1, because we have to put the view id in the sequence beans::PropertyValue* pSettings = rSettings.getArray(); if (pSettings) { sal_uInt16 nViewID(pViewShell->GetViewFrame()->GetCurViewId()); pSettings[SC_VIEW_ID].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_VIEWID)); rtl::OUStringBuffer sBuffer(rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_VIEW))); SvXMLUnitConverter::convertNumber(sBuffer, static_cast(nViewID)); pSettings[SC_VIEW_ID].Value <<= sBuffer.makeStringAndClear(); SCTAB nTabCount (pDoc->GetTableCount()); uno::Reference xServiceFactory = comphelper::getProcessServiceFactory(); DBG_ASSERT( xServiceFactory.is(), "got no service manager" ); if( xServiceFactory.is() ) { rtl::OUString sName(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.document.NamedPropertyValues")); uno::Reference xNameContainer = uno::Reference(xServiceFactory->createInstance(sName), uno::UNO_QUERY); if (xNameContainer.is()) { for (SCTAB nTab=0; nTab aTableViewSettings; pTabData[nTab]->WriteUserDataSequence(aTableViewSettings, *this, nTab); String sTabName; GetDocument()->GetName( nTab, sTabName ); rtl::OUString sOUName(sTabName); uno::Any aAny; aAny <<= aTableViewSettings; try { xNameContainer->insertByName(sTabName, aAny); } //#101739#; two tables with the same name are possible catch ( container::ElementExistException& ) { DBG_ERRORFILE("seems there are two tables with the same name"); } catch ( uno::RuntimeException& ) { DBG_ERRORFILE("something went wrong"); } } } pSettings[SC_TABLE_VIEWSETTINGS].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_TABLES)); pSettings[SC_TABLE_VIEWSETTINGS].Value <<= xNameContainer; } } String sName; GetDocument()->GetName( nTabNo, sName ); rtl::OUString sOUName(sName); pSettings[SC_ACTIVE_TABLE].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_ACTIVETABLE)); pSettings[SC_ACTIVE_TABLE].Value <<= sOUName; pSettings[SC_HORIZONTAL_SCROLL_BAR_WIDTH].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_HORIZONTALSCROLLBARWIDTH)); pSettings[SC_HORIZONTAL_SCROLL_BAR_WIDTH].Value <<= sal_Int32(pView->GetTabBarWidth()); sal_Int32 nZoomValue ((pThisTab->aZoomY.GetNumerator() * 100) / pThisTab->aZoomY.GetDenominator()); sal_Int32 nPageZoomValue ((pThisTab->aPageZoomY.GetNumerator() * 100) / pThisTab->aPageZoomY.GetDenominator()); pSettings[SC_ZOOM_TYPE].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_ZOOMTYPE)); pSettings[SC_ZOOM_TYPE].Value <<= sal_Int16(pThisTab->eZoomType); pSettings[SC_ZOOM_VALUE].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_ZOOMVALUE)); pSettings[SC_ZOOM_VALUE].Value <<= nZoomValue; pSettings[SC_PAGE_VIEW_ZOOM_VALUE].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_PAGEVIEWZOOMVALUE)); pSettings[SC_PAGE_VIEW_ZOOM_VALUE].Value <<= nPageZoomValue; pSettings[SC_PAGE_BREAK_PREVIEW].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_SHOWPAGEBREAKPREVIEW)); ScUnoHelpFunctions::SetBoolInAny( pSettings[SC_PAGE_BREAK_PREVIEW].Value, bPagebreak); if (pOptions) { pSettings[SC_SHOWZERO].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_SHOWZERO)); ScUnoHelpFunctions::SetBoolInAny( pSettings[SC_SHOWZERO].Value, pOptions->GetOption( VOPT_NULLVALS ) ); pSettings[SC_SHOWNOTES].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_SHOWNOTES)); ScUnoHelpFunctions::SetBoolInAny( pSettings[SC_SHOWNOTES].Value, pOptions->GetOption( VOPT_NOTES ) ); pSettings[SC_SHOWGRID].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_SHOWGRID)); ScUnoHelpFunctions::SetBoolInAny( pSettings[SC_SHOWGRID].Value, pOptions->GetOption( VOPT_GRID ) ); pSettings[SC_GRIDCOLOR].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_GRIDCOLOR)); String aColorName; Color aColor = pOptions->GetGridColor(&aColorName); pSettings[SC_GRIDCOLOR].Value <<= static_cast(aColor.GetColor()); pSettings[SC_SHOWPAGEBR].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_SHOWPAGEBR)); ScUnoHelpFunctions::SetBoolInAny( pSettings[SC_SHOWPAGEBR].Value, pOptions->GetOption( VOPT_PAGEBREAKS ) ); pSettings[SC_COLROWHDR].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_COLROWHDR)); ScUnoHelpFunctions::SetBoolInAny( pSettings[SC_COLROWHDR].Value, pOptions->GetOption( VOPT_HEADER ) ); pSettings[SC_SHEETTABS].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_SHEETTABS)); ScUnoHelpFunctions::SetBoolInAny( pSettings[SC_SHEETTABS].Value, pOptions->GetOption( VOPT_TABCONTROLS ) ); pSettings[SC_OUTLSYMB].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_OUTLSYMB)); ScUnoHelpFunctions::SetBoolInAny( pSettings[SC_OUTLSYMB].Value, pOptions->GetOption( VOPT_OUTLINER ) ); const ScGridOptions& aGridOpt = pOptions->GetGridOptions(); pSettings[SC_SNAPTORASTER].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_SNAPTORASTER)); ScUnoHelpFunctions::SetBoolInAny( pSettings[SC_SNAPTORASTER].Value, aGridOpt.GetUseGridSnap() ); pSettings[SC_RASTERVIS].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_RASTERVIS)); ScUnoHelpFunctions::SetBoolInAny( pSettings[SC_RASTERVIS].Value, aGridOpt.GetGridVisible() ); pSettings[SC_RASTERRESX].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_RASTERRESX)); pSettings[SC_RASTERRESX].Value <<= static_cast ( aGridOpt.GetFldDrawX() ); pSettings[SC_RASTERRESY].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_RASTERRESY)); pSettings[SC_RASTERRESY].Value <<= static_cast ( aGridOpt.GetFldDrawY() ); pSettings[SC_RASTERSUBX].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_RASTERSUBX)); pSettings[SC_RASTERSUBX].Value <<= static_cast ( aGridOpt.GetFldDivisionX() ); pSettings[SC_RASTERSUBY].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_RASTERSUBY)); pSettings[SC_RASTERSUBY].Value <<= static_cast ( aGridOpt.GetFldDivisionY() ); pSettings[SC_RASTERSYNC].Name = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_RASTERSYNC)); ScUnoHelpFunctions::SetBoolInAny( pSettings[SC_RASTERSYNC].Value, aGridOpt.GetSynchronize() ); } } } void ScViewData::ReadUserDataSequence(const uno::Sequence & rSettings) { Fraction aZoomX, aZoomY, aPageZoomX, aPageZoomY; //! evaluate (all sheets?) std::vector aHasZoomVect( GetDocument()->GetTableCount(), false ); sal_Int32 nCount(rSettings.getLength()); sal_Int32 nTemp32(0); sal_Int16 nTemp16(0); sal_Bool bPageMode(sal_False); for (sal_Int32 i = 0; i < nCount; i++) { // SC_VIEWID has to parse and use by mba rtl::OUString sName(rSettings[i].Name); if (sName.compareToAscii(SC_TABLES) == 0) { uno::Reference xNameContainer; if ((rSettings[i].Value >>= xNameContainer) && xNameContainer->hasElements()) { uno::Sequence< rtl::OUString > aNames(xNameContainer->getElementNames()); for (sal_Int32 nTabPos = 0; nTabPos < aNames.getLength(); nTabPos++) { String sTabName(aNames[nTabPos]); SCTAB nTab(0); if (GetDocument()->GetTable(sTabName, nTab)) { uno::Any aAny = xNameContainer->getByName(aNames[nTabPos]); uno::Sequence aTabSettings; if (aAny >>= aTabSettings) { pTabData[nTab] = new ScViewDataTable; bool bHasZoom = false; pTabData[nTab]->ReadUserDataSequence(aTabSettings, *this, nTab, bHasZoom); aHasZoomVect[nTab] = bHasZoom; } } } } } else if (sName.compareToAscii(SC_ACTIVETABLE) == 0) { rtl::OUString sValue; if(rSettings[i].Value >>= sValue) { String sTabName(sValue); SCTAB nTab(0); if (GetDocument()->GetTable(sTabName, nTab)) nTabNo = nTab; } } else if (sName.compareToAscii(SC_HORIZONTALSCROLLBARWIDTH) == 0) { if (rSettings[i].Value >>= nTemp32) pView->SetTabBarWidth(nTemp32); } else if (sName.compareToAscii(SC_RELHORIZONTALTABBARWIDTH) == 0) { double fWidth = 0.0; if (rSettings[i].Value >>= fWidth) pView->SetPendingRelTabBarWidth( fWidth ); } else if (sName.compareToAscii(SC_ZOOMTYPE) == 0) { if (rSettings[i].Value >>= nTemp16) eDefZoomType = SvxZoomType(nTemp16); } else if (sName.compareToAscii(SC_ZOOMVALUE) == 0) { if (rSettings[i].Value >>= nTemp32) { Fraction aZoom(nTemp32, 100); aDefZoomX = aDefZoomY = aZoom; } } else if (sName.compareToAscii(SC_PAGEVIEWZOOMVALUE) == 0) { if (rSettings[i].Value >>= nTemp32) { Fraction aZoom(nTemp32, 100); aDefPageZoomX = aDefPageZoomY = aZoom; } } else if (sName.compareToAscii(SC_SHOWPAGEBREAKPREVIEW) == 0) bPageMode = ScUnoHelpFunctions::GetBoolFromAny( rSettings[i].Value ); else if ( sName.compareToAscii( SC_UNO_SHOWZERO ) == 0 ) pOptions->SetOption(VOPT_NULLVALS, ScUnoHelpFunctions::GetBoolFromAny( rSettings[i].Value ) ); else if ( sName.compareToAscii( SC_UNO_SHOWNOTES ) == 0 ) pOptions->SetOption(VOPT_NOTES, ScUnoHelpFunctions::GetBoolFromAny( rSettings[i].Value ) ); else if ( sName.compareToAscii( SC_UNO_SHOWGRID ) == 0 ) pOptions->SetOption(VOPT_GRID, ScUnoHelpFunctions::GetBoolFromAny( rSettings[i].Value ) ); else if ( sName.compareToAscii( SC_UNO_GRIDCOLOR ) == 0 ) { sal_Int64 nColor = 0; if (rSettings[i].Value >>= nColor) { String aColorName; Color aColor(static_cast(nColor)); // #i47435# set automatic grid color explicitly if( aColor.GetColor() == COL_AUTO ) aColor.SetColor( SC_STD_GRIDCOLOR ); pOptions->SetGridColor(aColor, aColorName); } } else if ( sName.compareToAscii( SC_UNO_SHOWPAGEBR ) == 0 ) pOptions->SetOption(VOPT_PAGEBREAKS, ScUnoHelpFunctions::GetBoolFromAny( rSettings[i].Value ) ); else if ( sName.compareToAscii( SC_UNO_COLROWHDR ) == 0 ) pOptions->SetOption(VOPT_HEADER, ScUnoHelpFunctions::GetBoolFromAny( rSettings[i].Value ) ); else if ( sName.compareToAscii( SC_UNO_SHEETTABS ) == 0 ) pOptions->SetOption(VOPT_TABCONTROLS, ScUnoHelpFunctions::GetBoolFromAny( rSettings[i].Value ) ); else if ( sName.compareToAscii( SC_UNO_OUTLSYMB ) == 0 ) pOptions->SetOption(VOPT_OUTLINER, ScUnoHelpFunctions::GetBoolFromAny( rSettings[i].Value ) ); else if ( sName.compareToAscii( SC_UNO_SHOWOBJ ) == 0 ) { // #i80528# placeholders not supported anymore if ( rSettings[i].Value >>= nTemp16 ) pOptions->SetObjMode( VOBJ_TYPE_OLE, (nTemp16 == 1) ? VOBJ_MODE_HIDE : VOBJ_MODE_SHOW ); } else if ( sName.compareToAscii( SC_UNO_SHOWCHARTS ) == 0 ) { // #i80528# placeholders not supported anymore if ( rSettings[i].Value >>= nTemp16 ) pOptions->SetObjMode( VOBJ_TYPE_CHART, (nTemp16 == 1) ? VOBJ_MODE_HIDE : VOBJ_MODE_SHOW ); } else if ( sName.compareToAscii( SC_UNO_SHOWDRAW ) == 0 ) { // #i80528# placeholders not supported anymore if ( rSettings[i].Value >>= nTemp16 ) pOptions->SetObjMode( VOBJ_TYPE_DRAW, (nTemp16 == 1) ? VOBJ_MODE_HIDE : VOBJ_MODE_SHOW ); } else { ScGridOptions aGridOpt(pOptions->GetGridOptions()); if ( sName.compareToAscii( SC_UNO_SNAPTORASTER ) == 0 ) aGridOpt.SetUseGridSnap( ScUnoHelpFunctions::GetBoolFromAny( rSettings[i].Value ) ); else if ( sName.compareToAscii( SC_UNO_RASTERVIS ) == 0 ) aGridOpt.SetGridVisible( ScUnoHelpFunctions::GetBoolFromAny( rSettings[i].Value ) ); else if ( sName.compareToAscii( SC_UNO_RASTERRESX ) == 0 ) aGridOpt.SetFldDrawX( static_cast ( ScUnoHelpFunctions::GetInt32FromAny( rSettings[i].Value ) ) ); else if ( sName.compareToAscii( SC_UNO_RASTERRESY ) == 0 ) aGridOpt.SetFldDrawY( static_cast ( ScUnoHelpFunctions::GetInt32FromAny( rSettings[i].Value ) ) ); else if ( sName.compareToAscii( SC_UNO_RASTERSUBX ) == 0 ) aGridOpt.SetFldDivisionX( static_cast ( ScUnoHelpFunctions::GetInt32FromAny( rSettings[i].Value ) ) ); else if ( sName.compareToAscii( SC_UNO_RASTERSUBY ) == 0 ) aGridOpt.SetFldDivisionY( static_cast ( ScUnoHelpFunctions::GetInt32FromAny( rSettings[i].Value ) ) ); else if ( sName.compareToAscii( SC_UNO_RASTERSYNC ) == 0 ) aGridOpt.SetSynchronize( ScUnoHelpFunctions::GetBoolFromAny( rSettings[i].Value ) ); pOptions->SetGridOptions(aGridOpt); } } // copy default zoom to sheets where a different one wasn't specified for (SCTAB nZoomTab=0; nZoomTab<=MAXTAB; ++nZoomTab) if (pTabData[nZoomTab] && ( nZoomTab >= static_cast(aHasZoomVect.size()) || !aHasZoomVect[nZoomTab] )) { pTabData[nZoomTab]->eZoomType = eDefZoomType; pTabData[nZoomTab]->aZoomX = aDefZoomX; pTabData[nZoomTab]->aZoomY = aDefZoomY; pTabData[nZoomTab]->aPageZoomX = aDefPageZoomX; pTabData[nZoomTab]->aPageZoomY = aDefPageZoomY; } if (nCount) SetPagebreakMode( bPageMode ); // #i47426# write view options to document, needed e.g. for Excel export pDoc->SetViewOptions( *pOptions ); } void ScViewData::SetOptions( const ScViewOptions& rOpt ) { // if visibility of horiz. ScrollBar is changed, TabBar may have to be resized... BOOL bHScrollChanged = ( rOpt.GetOption(VOPT_HSCROLL) != pOptions->GetOption(VOPT_HSCROLL) ); // if graphics are turned on or off, animation has to be started or stopped // graphics are controlled by VOBJ_TYPE_OLE BOOL bGraphicsChanged = ( pOptions->GetObjMode(VOBJ_TYPE_OLE) != rOpt.GetObjMode(VOBJ_TYPE_OLE) ); *pOptions = rOpt; DBG_ASSERT( pView, "No View" ); if( pView ) { pView->ViewOptionsHasChanged( bHScrollChanged, bGraphicsChanged ); } } Point ScViewData::GetMousePosPixel() { DBG_ASSERT( pView, "GetMousePosPixel() ohne View" ); return pView->GetMousePosPixel(); } void ScViewData::UpdateInputHandler( BOOL bForce, BOOL bStopEditing ) { if (pViewShell) pViewShell->UpdateInputHandler( bForce, bStopEditing ); } BOOL ScViewData::IsOle() { return pDocShell && pDocShell->IsOle(); } BOOL ScViewData::UpdateFixX( SCTAB nTab ) // TRUE = Wert geaendert { if (!ValidTab(nTab)) // Default nTab=nTabNo; // akuelle Tabelle if (!pView || pTabData[nTab]->eHSplitMode != SC_SPLIT_FIX) return FALSE; ScDocument* pLocalDoc = GetDocument(); if (!pLocalDoc->HasTable(nTab)) // #114007# if called from reload, the sheet may not exist return FALSE; SCCOL nFix = pTabData[nTab]->nFixPosX; long nNewPos = 0; for (SCCOL nX=pTabData[nTab]->nPosX[SC_SPLIT_LEFT]; nXGetColWidth( nX, nTab ); if (nTSize) { long nPix = ToPixel( nTSize, nPPTX ); nNewPos += nPix; } } nNewPos += pView->GetGridOffset().X(); if (nNewPos != pTabData[nTab]->nHSplitPos) { pTabData[nTab]->nHSplitPos = nNewPos; if (nTab == nTabNo) RecalcPixPos(); //! sollte nicht noetig sein !!! return TRUE; } return FALSE; } BOOL ScViewData::UpdateFixY( SCTAB nTab ) // TRUE = Wert geaendert { if (!ValidTab(nTab)) // Default nTab=nTabNo; // akuelle Tabelle if (!pView || pTabData[nTab]->eVSplitMode != SC_SPLIT_FIX) return FALSE; ScDocument* pLocalDoc = GetDocument(); if (!pLocalDoc->HasTable(nTab)) // #114007# if called from reload, the sheet may not exist return FALSE; SCROW nFix = pTabData[nTab]->nFixPosY; long nNewPos = 0; for (SCROW nY=pTabData[nTab]->nPosY[SC_SPLIT_TOP]; nYGetRowHeight( nY, nTab ); if (nTSize) { long nPix = ToPixel( nTSize, nPPTY ); nNewPos += nPix; } } nNewPos += pView->GetGridOffset().Y(); if (nNewPos != pTabData[nTab]->nVSplitPos) { pTabData[nTab]->nVSplitPos = nNewPos; if (nTab == nTabNo) RecalcPixPos(); //! sollte nicht noetig sein !!! return TRUE; } return FALSE; } void ScViewData::UpdateOutlinerFlags( Outliner& rOutl ) const { ScDocument* pLocalDoc = GetDocument(); BOOL bOnlineSpell = pLocalDoc->GetDocOptions().IsAutoSpell(); ULONG nCntrl = rOutl.GetControlWord(); nCntrl |= EE_CNTRL_URLSFXEXECUTE; nCntrl |= EE_CNTRL_MARKFIELDS; nCntrl |= EE_CNTRL_AUTOCORRECT; if( bOnlineSpell ) nCntrl |= EE_CNTRL_ONLINESPELLING; else nCntrl &= ~EE_CNTRL_ONLINESPELLING; rOutl.SetControlWord(nCntrl); rOutl.SetCalcFieldValueHdl( LINK( SC_MOD(), ScModule, CalcFieldValueHdl ) ); // #97417# don't call GetSpellChecker if online spelling isn't enabled. // The language for AutoCorrect etc. is taken from the pool defaults // (set in ScDocument::UpdateDrawLanguages) if ( bOnlineSpell ) { com::sun::star::uno::Reference xXSpellChecker1( LinguMgr::GetSpellChecker() ); rOutl.SetSpeller( xXSpellChecker1 ); } rOutl.SetDefaultHorizontalTextDirection( (EEHorizontalTextDirection)pLocalDoc->GetEditTextDirection( nTabNo ) ); } ScAddress ScViewData::GetCurPos() const { return ScAddress( GetCurX(), GetCurY(), GetTabNo() ); } // static void ScViewData::AddPixelsWhile( long & rScrY, long nEndPixels, SCROW & rPosY, SCROW nEndRow, double nPPTY, const ScDocument * pDoc, SCTAB nTabNo ) { SCROW nRow = rPosY; while (rScrY <= nEndPixels && nRow <= nEndRow) { SCROW nHeightEndRow; USHORT nHeight = pDoc->GetRowHeight( nRow, nTabNo, NULL, &nHeightEndRow); if (nHeightEndRow > nEndRow) nHeightEndRow = nEndRow; if (!nHeight) nRow = nHeightEndRow + 1; else { SCROW nRows = nHeightEndRow - nRow + 1; sal_Int64 nPixel = ToPixel( nHeight, nPPTY); sal_Int64 nAdd = nPixel * nRows; if (nAdd + rScrY > nEndPixels) { sal_Int64 nDiff = rScrY + nAdd - nEndPixels; nRows -= static_cast(nDiff / nPixel); nAdd = nPixel * nRows; // We're looking for a value that satisfies loop condition. if (nAdd + rScrY <= nEndPixels) { ++nRows; nAdd += nPixel; } } rScrY += static_cast(nAdd); nRow += nRows; } } if (nRow > rPosY) --nRow; rPosY = nRow; } // static void ScViewData::AddPixelsWhileBackward( long & rScrY, long nEndPixels, SCROW & rPosY, SCROW nStartRow, double nPPTY, const ScDocument * pDoc, SCTAB nTabNo ) { SCROW nRow = rPosY; while (rScrY <= nEndPixels && nRow >= nStartRow) { SCROW nHeightStartRow; USHORT nHeight = pDoc->GetRowHeight( nRow, nTabNo, &nHeightStartRow, NULL); if (nHeightStartRow < nStartRow) nHeightStartRow = nStartRow; if (!nHeight) nRow = nHeightStartRow - 1; else { SCROW nRows = nRow - nHeightStartRow + 1; sal_Int64 nPixel = ToPixel( nHeight, nPPTY); sal_Int64 nAdd = nPixel * nRows; if (nAdd + rScrY > nEndPixels) { sal_Int64 nDiff = nAdd + rScrY - nEndPixels; nRows -= static_cast(nDiff / nPixel); nAdd = nPixel * nRows; // We're looking for a value that satisfies loop condition. if (nAdd + rScrY <= nEndPixels) { ++nRows; nAdd += nPixel; } } rScrY += static_cast(nAdd); nRow -= nRows; } } if (nRow < rPosY) ++nRow; rPosY = nRow; }