/************************************************************** * * 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. * *************************************************************/ // MARKER(update_precomp.py): autogen include statement, do not remove #include "precompiled_scui.hxx" //------------------------------------------------------------------ #include #include "global.hxx" #include "document.hxx" #include "tabvwsh.hxx" #include "viewdata.hxx" #include "uiitems.hxx" #include "userlist.hxx" #include "rangeutl.hxx" #include "crdlg.hxx" #include "scresid.hxx" #include "sc.hrc" // -> Slot-IDs #include "optdlg.hrc" #include "globstr.hrc" #define _TPUSRLST_CXX #include "tpusrlst.hxx" #undef _TPUSRLST_CXX //CHINA001 #include "scui_def.hxx" //CHINA001 //CHINA001 #include "scresid.hxx" //add by CHINA001 //CHINA001 #include "miscdlgs.hrc" //add by CHINA001 //CHINA001 //CHINA001 #include "scabstdlg.hxx" //CHINA001 // STATIC DATA ----------------------------------------------------------- #define CR (sal_Unicode)13 #define LF (sal_Unicode)10 static sal_uInt16 pUserListsRanges[] = { SID_SCUSERLISTS, SID_SCUSERLISTS, 0 }; static const sal_Unicode cDelimiter = ','; //======================================================================== // Benutzerdefinierte Listen: ScTpUserLists::ScTpUserLists( Window* pParent, const SfxItemSet& rCoreAttrs ) : SfxTabPage ( pParent, ScResId( RID_SCPAGE_USERLISTS ), rCoreAttrs ), aFtLists ( this, ScResId( FT_LISTS ) ), aLbLists ( this, ScResId( LB_LISTS ) ), aFtEntries ( this, ScResId( FT_ENTRIES ) ), aEdEntries ( this, ScResId( ED_ENTRIES ) ), aFtCopyFrom ( this, ScResId( FT_COPYFROM ) ), aEdCopyFrom ( this, ScResId( ED_COPYFROM ) ), aBtnNew ( this, ScResId( BTN_NEW ) ), aBtnAdd ( this, ScResId( BTN_ADD ) ), aBtnRemove ( this, ScResId( BTN_REMOVE ) ), aBtnCopy ( this, ScResId( BTN_COPY ) ), aStrQueryRemove ( ScResId( STR_QUERYREMOVE ) ), aStrNew ( aBtnNew.GetText() ), aStrCancel ( ScResId( STR_DISMISS ) ), aStrAdd ( ScResId( SCSTR_ADD ) ), aStrModify ( ScResId( SCSTR_MODIFY ) ), aStrCopyList ( ScResId( STR_COPYLIST ) ), aStrCopyFrom ( ScResId( STR_COPYFROM ) ), aStrCopyErr ( ScResId( STR_COPYERR ) ), // nWhichUserLists ( GetWhich( SID_SCUSERLISTS ) ), pUserLists ( NULL ), pDoc ( NULL ), pViewData ( NULL ), pRangeUtil ( new ScRangeUtil ), bModifyMode ( sal_False ), bCancelMode ( sal_False ), bCopyDone ( sal_False ), nCancelPos ( 0 ) { SetExchangeSupport(); Init(); FreeResource(); } // ----------------------------------------------------------------------- __EXPORT ScTpUserLists::~ScTpUserLists() { delete pUserLists; delete pRangeUtil; } // ----------------------------------------------------------------------- void ScTpUserLists::Init() { SfxViewShell* pSh = SfxViewShell::Current(); ScTabViewShell* pViewSh = PTR_CAST(ScTabViewShell, pSh); aLbLists.SetSelectHdl ( LINK( this, ScTpUserLists, LbSelectHdl ) ); aBtnNew.SetClickHdl ( LINK( this, ScTpUserLists, BtnClickHdl ) ); aBtnNew.SetClickHdl ( LINK( this, ScTpUserLists, BtnClickHdl ) ); aBtnAdd.SetClickHdl ( LINK( this, ScTpUserLists, BtnClickHdl ) ); aBtnRemove.SetClickHdl ( LINK( this, ScTpUserLists, BtnClickHdl ) ); aEdEntries.SetModifyHdl ( LINK( this, ScTpUserLists, EdEntriesModHdl ) ); if ( pViewSh ) { SCTAB nStartTab = 0; SCTAB nEndTab = 0; SCCOL nStartCol = 0; SCROW nStartRow = 0; SCCOL nEndCol = 0; SCROW nEndRow = 0; pViewData = pViewSh->GetViewData(); pDoc = pViewData->GetDocument(); pViewData->GetSimpleArea( nStartCol, nStartRow, nStartTab, nEndCol, nEndRow, nEndTab ); PutInOrder( nStartCol, nEndCol ); PutInOrder( nStartRow, nEndRow ); PutInOrder( nStartTab, nEndTab ); ScRange( nStartCol, nStartRow, nStartTab, nEndCol, nEndRow, nEndTab ).Format( aStrSelectedArea, SCR_ABS_3D, pDoc ); aBtnCopy.SetClickHdl ( LINK( this, ScTpUserLists, BtnClickHdl ) ); aBtnCopy.Enable(); } else { aBtnCopy.Disable(); aFtCopyFrom.Disable(); aEdCopyFrom.Disable(); } // aLbLists.GrabFocus(); } // ----------------------------------------------------------------------- sal_uInt16* __EXPORT ScTpUserLists::GetRanges() { return pUserListsRanges; } // ----------------------------------------------------------------------- SfxTabPage* __EXPORT ScTpUserLists::Create( Window* pParent, const SfxItemSet& rAttrSet ) { return ( new ScTpUserLists( pParent, rAttrSet ) ); } // ----------------------------------------------------------------------- void __EXPORT ScTpUserLists::Reset( const SfxItemSet& rCoreAttrs ) { const ScUserListItem& rUserListItem = (const ScUserListItem&) rCoreAttrs.Get( nWhichUserLists ); const ScUserList* pCoreList = rUserListItem.GetUserList(); DBG_ASSERT( pCoreList, "UserList not found :-/" ); if ( pCoreList ) { if ( !pUserLists ) pUserLists = new ScUserList( *pCoreList ); else *pUserLists = *pCoreList; if ( UpdateUserListBox() > 0 ) { aLbLists.SelectEntryPos( 0 ); UpdateEntries( 0 ); } } else if ( !pUserLists ) pUserLists = new ScUserList; aEdCopyFrom.SetText( aStrSelectedArea ); if ( aLbLists.GetEntryCount() == 0 ) { aFtLists .Disable(); aLbLists .Disable(); aFtEntries .Disable(); aEdEntries .Disable(); aBtnRemove .Disable(); } aBtnNew.SetText( aStrNew ); aBtnAdd.SetText( aStrAdd ); aBtnAdd.Disable(); if ( !bCopyDone && pViewData ) { aFtCopyFrom .Enable(); aEdCopyFrom .Enable(); aBtnCopy .Enable(); } // aLbLists.GrabFocus(); } // ----------------------------------------------------------------------- sal_Bool __EXPORT ScTpUserLists::FillItemSet( SfxItemSet& rCoreAttrs ) { // Modifikationen noch nicht uebernommen? // -> Click auf Add-Button simulieren if ( bModifyMode || bCancelMode ) BtnClickHdl( &aBtnAdd ); const ScUserListItem& rUserListItem = (const ScUserListItem&) GetItemSet().Get( nWhichUserLists ); ScUserList* pCoreList = rUserListItem.GetUserList(); sal_Bool bDataModified = sal_False; if ( (pUserLists == NULL) && (pCoreList == NULL) ) { bDataModified = sal_False; } else if ( pUserLists != NULL ) { if ( pCoreList != NULL ) bDataModified = (*pUserLists != *pCoreList); else bDataModified = sal_True; } if ( bDataModified ) { ScUserListItem aULItem( nWhichUserLists ); if ( pUserLists ) aULItem.SetUserList( *pUserLists ); rCoreAttrs.Put( aULItem ); } return bDataModified; } // ----------------------------------------------------------------------- int __EXPORT ScTpUserLists::DeactivatePage( SfxItemSet* pSetP ) { if ( pSetP ) FillItemSet( *pSetP ); return LEAVE_PAGE; } // ----------------------------------------------------------------------- sal_uInt16 ScTpUserLists::UpdateUserListBox() { aLbLists.Clear(); if ( !pUserLists ) return 0; //---------------------------------------------------------- sal_uInt16 nCount = pUserLists->GetCount(); String aEntry; if ( nCount > 0 ) { for ( sal_uInt16 i=0; iGetString(); DBG_ASSERT( aEntry.Len() > 0, "Empty UserList-entry :-/" ); aLbLists.InsertEntry( aEntry ); } } return nCount; } // ----------------------------------------------------------------------- void ScTpUserLists::UpdateEntries( sal_uInt16 nList ) { if ( !pUserLists ) return; //---------------------------------------------------------- if ( nList < pUserLists->GetCount() ) { ScUserListData* pList = (*pUserLists)[nList]; sal_uInt16 nSubCount = pList->GetSubCount(); String aEntryListStr; for ( sal_uInt16 i=0; iGetSubStr( i ); } aEntryListStr.ConvertLineEnd(); aEdEntries.SetText( aEntryListStr ); } else { DBG_ERROR( "Invalid ListIndex :-/" ); } } // ----------------------------------------------------------------------- void ScTpUserLists::MakeListStr( String& rListStr ) { String aInputStr(rListStr); String aStr; xub_StrLen nLen = aStr.Len(); xub_StrLen c = 0; aInputStr.ConvertLineEnd( LINEEND_LF ); //aStr.EraseAllChars( ' ' ); xub_StrLen nToken=rListStr.GetTokenCount(LF); for(xub_StrLen i=0;iInsert( new ScUserListData( theEntriesStr ) ) ) { DBG_ERROR( "Entry could not be inserted :-/" ); } } // ----------------------------------------------------------------------- void ScTpUserLists::CopyListFromArea( const ScRefAddress& rStartPos, const ScRefAddress& rEndPos ) { if ( bCopyDone ) return; //---------------------------------------------------------- SCTAB nTab = rStartPos.Tab(); SCCOL nStartCol = rStartPos.Col(); SCROW nStartRow = rStartPos.Row(); SCCOL nEndCol = rEndPos.Col(); SCROW nEndRow = rEndPos.Row(); sal_uInt16 nCellDir = SCRET_COLS; sal_Bool bValueIgnored = sal_False; if ( (nStartCol != nEndCol) && (nStartRow != nEndRow) ) { nCellDir = ScColOrRowDlg( this, aStrCopyList, aStrCopyFrom ).Execute(); //CHINA001 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create(); //CHINA001 DBG_ASSERT(pFact, "ScAbstractFactory create fail!");//CHINA001 //CHINA001 //CHINA001 VclAbstractDialog* pDlg = pFact->CreateScColOrRowDlg( this, aStrCopyList, aStrCopyFrom,ResId(RID_SCDLG_COLORROW) ); //CHINA001 DBG_ASSERT(pDlg, "Dialog create fail!");//CHINA001 //CHINA001 nCellDir = pDlg->Execute(); //CHINA001 delete pDlg; //CHINA001 } else if ( nStartCol != nEndCol ) nCellDir = SCRET_ROWS; else nCellDir = SCRET_COLS; if ( nCellDir != RET_CANCEL ) { String aStrList; String aStrField; if ( nCellDir == SCRET_COLS ) { for ( SCCOL col=nStartCol; col<=nEndCol; col++ ) { for ( SCROW row=nStartRow; row<=nEndRow; row++ ) { if ( pDoc->HasStringData( col, row, nTab ) ) { pDoc->GetString( col, row, nTab, aStrField ); if ( aStrField.Len() > 0 ) { aStrList += aStrField; aStrList += '\n'; } } else bValueIgnored = sal_True; } if ( aStrList.Len() > 0 ) AddNewList( aStrList ); aStrList.Erase(); } } else { for ( SCROW row=nStartRow; row<=nEndRow; row++ ) { for ( SCCOL col=nStartCol; col<=nEndCol; col++ ) { if ( pDoc->HasStringData( col, row, nTab ) ) { pDoc->GetString( col, row, nTab, aStrField ); if ( aStrField.Len() > 0 ) { aStrList += aStrField; aStrList += '\n'; } } else bValueIgnored = sal_True; } if ( aStrList.Len() > 0 ) AddNewList( aStrList ); aStrList.Erase(); } } if ( bValueIgnored ) { InfoBox( this, aStrCopyErr ).Execute(); } } //---------------------------------------------------------- bCopyDone = sal_True; } // ----------------------------------------------------------------------- void ScTpUserLists::ModifyList( sal_uInt16 nSelList, const String& rEntriesStr ) { if ( !pUserLists ) return; //---------------------------------------------------------- String theEntriesStr( rEntriesStr ); MakeListStr( theEntriesStr ); (*pUserLists)[nSelList]->SetString( theEntriesStr ); } // ----------------------------------------------------------------------- void ScTpUserLists::RemoveList( sal_uInt16 nList ) { if ( pUserLists ) pUserLists->AtFree( nList ); } //----------------------------------------------------------------------- // Handler: //--------- IMPL_LINK( ScTpUserLists, LbSelectHdl, ListBox*, pLb ) { if ( pLb == &aLbLists ) { sal_uInt16 nSelPos = aLbLists.GetSelectEntryPos(); if ( nSelPos != LISTBOX_ENTRY_NOTFOUND ) { if ( !aFtEntries.IsEnabled() ) aFtEntries.Enable(); if ( !aEdEntries.IsEnabled() ) aEdEntries.Enable(); if ( !aBtnRemove.IsEnabled() ) aBtnRemove.Enable(); if ( aBtnAdd.IsEnabled() ) aBtnAdd.Disable(); UpdateEntries( nSelPos ); } } return 0; } // ----------------------------------------------------------------------- IMPL_LINK( ScTpUserLists, BtnClickHdl, PushButton*, pBtn ) { if ( pBtn == &aBtnNew ) { if ( !bCancelMode ) { nCancelPos = ( aLbLists.GetEntryCount() > 0 ) ? aLbLists.GetSelectEntryPos() : 0; aLbLists.SetNoSelection(); aFtLists.Disable(); aLbLists.Disable(); aFtEntries.Enable(); aEdEntries.Enable(); aEdEntries.SetText( EMPTY_STRING ); aEdEntries.GrabFocus(); aBtnAdd.Disable(); aBtnRemove.Disable(); //----------------------------- if ( aBtnCopy.IsEnabled() ) { aBtnCopy.Disable(); aFtCopyFrom.Disable(); aEdCopyFrom.Disable(); } aBtnNew.SetText( aStrCancel ); bCancelMode = sal_True; } else // if ( bCancelMode ) { if ( aLbLists.GetEntryCount() > 0 ) { aLbLists.SelectEntryPos( nCancelPos ); LbSelectHdl( &aLbLists ); aFtLists.Enable(); aLbLists.Enable(); } else { aFtEntries.Disable(); aEdEntries.Disable(); aEdEntries.SetText( EMPTY_STRING ); aBtnRemove.Disable(); } aBtnAdd.Disable(); //----------------------------- if ( pViewData && !bCopyDone ) { aBtnCopy.Enable(); aFtCopyFrom.Enable(); aEdCopyFrom.Enable(); } aBtnNew.SetText( aStrNew ); bCancelMode = sal_False; bModifyMode = sal_False; } } else if ( pBtn == &aBtnAdd ) { String theEntriesStr( aEdEntries.GetText() ); if ( !bModifyMode ) { if ( theEntriesStr.Len() > 0 ) { AddNewList( theEntriesStr ); UpdateUserListBox(); aLbLists.SelectEntryPos( aLbLists.GetEntryCount()-1 ); LbSelectHdl( &aLbLists ); aFtLists.Enable(); aLbLists.Enable(); } else { if ( aLbLists.GetEntryCount() > 0 ) { aLbLists.SelectEntryPos( nCancelPos ); LbSelectHdl( &aLbLists ); aLbLists.Enable(); aLbLists.Enable(); } } aBtnAdd.Disable(); aBtnRemove.Enable(); aBtnNew.SetText( aStrNew ); bCancelMode = sal_False; } else // if ( bModifyMode ) { sal_uInt16 nSelList = aLbLists.GetSelectEntryPos(); DBG_ASSERT( nSelList != LISTBOX_ENTRY_NOTFOUND, "Modify without List :-/" ); if ( theEntriesStr.Len() > 0 ) { ModifyList( nSelList, theEntriesStr ); UpdateUserListBox(); aLbLists.SelectEntryPos( nSelList ); } else { aLbLists.SelectEntryPos( 0 ); LbSelectHdl( &aLbLists ); } aBtnNew.SetText( aStrNew ); bCancelMode = sal_False; aBtnAdd.SetText( aStrAdd ); bModifyMode = sal_False; aBtnAdd.Disable(); aBtnRemove.Enable(); aFtLists.Enable(); aLbLists.Enable(); } if ( pViewData && !bCopyDone ) { aBtnCopy.Enable(); aFtCopyFrom.Enable(); aEdCopyFrom.Enable(); } } else if ( pBtn == &aBtnRemove ) { if ( aLbLists.GetEntryCount() > 0 ) { sal_uInt16 nRemovePos = aLbLists.GetSelectEntryPos(); String aMsg ( aStrQueryRemove.GetToken( 0, '#' ) ); aMsg += aLbLists.GetEntry( nRemovePos ); aMsg += aStrQueryRemove.GetToken( 1, '#' ); if ( RET_YES == QueryBox( this, WinBits( WB_YES_NO | WB_DEF_YES ), aMsg ).Execute() ) { RemoveList( nRemovePos ); UpdateUserListBox(); if ( aLbLists.GetEntryCount() > 0 ) { aLbLists.SelectEntryPos( ( nRemovePos >= aLbLists.GetEntryCount() ) ? aLbLists.GetEntryCount()-1 : nRemovePos ); LbSelectHdl( &aLbLists ); } else { aFtLists.Disable(); aLbLists.Disable(); aFtEntries.Disable(); aEdEntries.Disable(); aEdEntries.SetText( EMPTY_STRING ); aBtnRemove.Disable(); } } if ( pViewData && !bCopyDone && !aBtnCopy.IsEnabled() ) { aBtnCopy.Enable(); aFtCopyFrom.Enable(); aEdCopyFrom.Enable(); } } } else if ( pViewData && (pBtn == &aBtnCopy) ) { if ( bCopyDone ) return 0; //----------------------------------------------------------- ScRefAddress theStartPos; ScRefAddress theEndPos; String theAreaStr( aEdCopyFrom.GetText() ); sal_Bool bAreaOk = sal_False; if ( theAreaStr.Len() > 0 ) { bAreaOk = pRangeUtil->IsAbsArea( theAreaStr, pDoc, pViewData->GetTabNo(), &theAreaStr, &theStartPos, &theEndPos, pDoc->GetAddressConvention() ); if ( !bAreaOk ) { bAreaOk = pRangeUtil->IsAbsPos( theAreaStr, pDoc, pViewData->GetTabNo(), &theAreaStr, &theStartPos, pDoc->GetAddressConvention() ); theEndPos = theStartPos; } } if ( bAreaOk ) { CopyListFromArea( theStartPos, theEndPos ); UpdateUserListBox(); aLbLists.SelectEntryPos( aLbLists.GetEntryCount()-1 ); LbSelectHdl( &aLbLists ); aEdCopyFrom .SetText( theAreaStr ); aEdCopyFrom .Disable(); aBtnCopy .Disable(); aFtCopyFrom .Disable(); } else { ErrorBox( this, WinBits( WB_OK | WB_DEF_OK ), ScGlobal::GetRscString( STR_INVALID_TABREF ) ).Execute(); aEdCopyFrom.GrabFocus(); aEdCopyFrom.SetSelection( Selection( 0, SELECTION_MAX ) ); } } return 0; } // ----------------------------------------------------------------------- IMPL_LINK( ScTpUserLists, EdEntriesModHdl, MultiLineEdit*, pEd ) { if ( pEd != &aEdEntries ) return 0; //----------------------------------------------------------- if ( aBtnCopy.IsEnabled() ) { aBtnCopy .Disable(); aFtCopyFrom .Disable(); aEdCopyFrom .Disable(); } if ( aEdEntries.GetText().Len() > 0 ) { if ( !bCancelMode && !bModifyMode ) { aBtnNew.SetText( aStrCancel ); bCancelMode = sal_True; aBtnAdd.SetText( aStrModify ); bModifyMode = sal_True; aBtnAdd.Enable(); aBtnRemove.Disable(); aFtLists.Disable(); aLbLists.Disable(); } else // if ( bCancelMode || bModifyMode ) { if ( !aBtnAdd.IsEnabled() ) aBtnAdd.Enable(); } } else { if ( aBtnAdd.IsEnabled() ) aBtnAdd.Disable(); } return 0; }