chart2/source/controller/dialogs/tp_DataSource.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: tp_DataSource.cxx,v $
  10  * $Revision: 1.5.44.2 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_chart2.hxx"
  33
  34 #include "tp_DataSource.hxx"
  35 #include "tp_DataSource.hrc"
  36 #include "Strings.hrc"
  37 #include "ResId.hxx"
  38 #include "chartview/ChartSfxItemIds.hxx"
  39 #include "macros.hxx"
  40 #include "ChartTypeTemplateProvider.hxx"
  41 #include "RangeSelectionHelper.hxx"
  42 #include "DataSeriesHelper.hxx"
  43 #include "tp_DataSourceControls.hxx"
  44 #include "ControllerLockGuard.hxx"
  45 #include "DataSourceHelper.hxx"
  46 #include <com/sun/star/sheet/XRangeSelection.hpp>
  47 #include <com/sun/star/table/XCellRange.hpp>
  48 #include <com/sun/star/chart2/XChartType.hpp>
  49 #include <com/sun/star/chart2/XChartTypeTemplate.hpp>
  50 #include <com/sun/star/util/XModifiable.hpp>
  51 #include <com/sun/star/chart2/data/XDataSink.hpp>
  52
  53 // for RET_OK
  54 #include <vcl/msgbox.hxx>
  55 #include <rtl/ustrbuf.hxx>
  56
  57 #include <functional>
  58 #include <algorithm>
  59 #include <map>
  60
  61 using namespace ::com::sun::star;
  62 using namespace ::com::sun::star::chart2;
  63
  64 using ::com::sun::star::uno::Reference;
  65 using ::com::sun::star::uno::Sequence;
  66 using ::rtl::OUString;
  67 using ::rtl::OUStringBuffer;
  68
  69 // --------------------------------------------------------------------------------
  70
  71 namespace
  72 {
  73
  74 const OUString lcl_aLabelRole( RTL_CONSTASCII_USTRINGPARAM( "label" ));
  75
  76 String lcl_GetRoleLBEntry(
  77     const OUString & rRole, const OUString & rRange )
  78 {
  79     String aEntry( rRole );
  80     aEntry += '\t';
  81     aEntry += String(
  82         ::chart::DialogModel::ConvertRoleFromInternalToUI( rRole ));
  83     aEntry += '\t';
  84     aEntry += String( rRange );
  85
  86     return aEntry;
  87 }
  88
  89 void lcl_UpdateCurrentRange(
  90     SvTabListBox & rOutListBox,
  91     const OUString & rRole, const OUString & rRange )
  92 {
  93     SvLBoxEntry * pEntry = rOutListBox.FirstSelected();
  94     if( pEntry )
  95         rOutListBox.SetEntryText( lcl_GetRoleLBEntry( rRole, rRange ), pEntry );
  96 }
  97
  98 bool lcl_UpdateCurrentSeriesName(
  99     SvTreeListBox & rOutListBox )
 100 {
 101     bool bResult = false;
 102     ::chart::SeriesEntry * pEntry = dynamic_cast< ::chart::SeriesEntry * >( rOutListBox.FirstSelected());
 103     if( pEntry &&
 104         pEntry->m_xDataSeries.is() &&
 105         pEntry->m_xChartType.is())
 106     {
 107         String aLabel( ::chart::DataSeriesHelper::getDataSeriesLabel(
 108                            pEntry->m_xDataSeries,
 109                            pEntry->m_xChartType->getRoleOfSequenceForSeriesLabel()));
 110         if( aLabel.Len())
 111         {
 112             rOutListBox.SetEntryText( pEntry, aLabel );
 113             bResult = true;
 114         }
 115     }
 116     return bResult;
 117 }
 118
 119 OUString lcl_GetSelectedRole( const SvTabListBox & rRoleListBox, bool bUITranslated = false )
 120 {
 121     OUString aResult;
 122     SvLBoxEntry * pEntry = rRoleListBox.FirstSelected();
 123     if( pEntry )
 124         aResult = OUString( rRoleListBox.GetEntryText( pEntry,
 125                                                        bUITranslated ? 1 : 0 ));
 126     return aResult;
 127 }
 128
 129 OUString lcl_GetSelectedRolesRange( const SvTabListBox & rRoleListBox )
 130 {
 131     OUString aResult;
 132     SvLBoxEntry * pEntry = rRoleListBox.FirstSelected();
 133     if( pEntry )
 134         aResult = OUString( rRoleListBox.GetEntryText( pEntry, 2 ));
 135     return aResult;
 136 }
 137
 138 OUString lcl_GetSequenceNameForLabel( ::chart::SeriesEntry * pEntry )
 139 {
 140     OUString aResult( RTL_CONSTASCII_USTRINGPARAM("values-y"));
 141     if( pEntry &&
 142         pEntry->m_xChartType.is())
 143     {
 144         aResult = pEntry->m_xChartType->getRoleOfSequenceForSeriesLabel();
 145     }
 146     return aResult;
 147 }
 148
 149 static long lcl_pRoleListBoxTabs[] =
 150     {   3,        // Number of Tabs
 151         0, 0, 75
 152     };
 153
 154 void lcl_ShowChooserButton(
 155     ::chart::RangeSelectionButton & rChooserButton,
 156     Edit & rEditField,
 157     BOOL bShow )
 158 {
 159     if( rChooserButton.IsVisible() != bShow )
 160     {
 161         rChooserButton.Show( bShow );
 162         sal_Int32 nWidhtDiff = 12 + 4;
 163         if( bShow )
 164             nWidhtDiff = -nWidhtDiff;
 165         Size aSize = rChooserButton.PixelToLogic( rEditField.GetSizePixel(), MAP_APPFONT );
 166         aSize.setWidth( aSize.getWidth() + nWidhtDiff );
 167         rEditField.SetSizePixel( rChooserButton.LogicToPixel( aSize, MAP_APPFONT ));
 168     }
 169 }
 170
 171 void lcl_enableRangeChoosing( bool bEnable, Dialog * pDialog )
 172 {
 173     if( pDialog )
 174     {
 175         pDialog->Show( bEnable ? FALSE : TRUE );
 176         pDialog->SetModalInputMode( bEnable ? FALSE : TRUE );
 177     }
 178 }
 179
 180 void lcl_addLSequenceToDataSource(
 181     const Reference< chart2::data::XLabeledDataSequence > & xLSequence,
 182     const Reference< chart2::data::XDataSource > & xSource )
 183 {
 184     Reference< data::XDataSink > xSink( xSource, uno::UNO_QUERY );
 185     if( xSink.is())
 186     {
 187         Sequence< Reference< chart2::data::XLabeledDataSequence > > aData( xSource->getDataSequences());
 188         aData.realloc( aData.getLength() + 1 );
 189         aData[ aData.getLength() - 1 ] = xLSequence;
 190         xSink->setData( aData );
 191     }
 192 }
 193
 194 Reference< chart2::data::XLabeledDataSequence > lcl_findLSequenceWithOnlyLabel(
 195     const Reference< chart2::data::XDataSource > & xDataSource )
 196 {
 197     Reference< chart2::data::XLabeledDataSequence > xResult;
 198     Sequence< Reference< chart2::data::XLabeledDataSequence > > aSequences( xDataSource->getDataSequences());
 199
 200     for( sal_Int32 i=0; i<aSequences.getLength(); ++i )
 201     {
 202         // no values are set but a label exists
 203         if( ! aSequences[i]->getValues().is() &&
 204             aSequences[i]->getLabel().is())
 205         {
 206             xResult.set( aSequences[i] );
 207             break;
 208         }
 209     }
 210
 211     return xResult;
 212 }
 213
 214 void lcl_shiftControlY( Control & rControl, long nYOffset )
 215 {
 216     Point aPos( rControl.GetPosPixel());
 217     aPos.setY( aPos.getY() + nYOffset );
 218     rControl.SetPosPixel( aPos );
 219 }
 220
 221 void lcl_increaseHeightOfControl( Control & rControl, long nYOffset )
 222 {
 223     Size aSize( rControl.GetSizePixel());
 224     aSize.setHeight( aSize.getHeight () + nYOffset );
 225     rControl.SetSizePixel( aSize );
 226 }
 227
 228 } //  anonymous namespace
 229
 230 // --------------------------------------------------------------------------------
 231
 232 namespace chart
 233 {
 234
 235 DataSourceTabPage::DataSourceTabPage(
 236     Window * pParent,
 237     DialogModel & rDialogModel,
 238     ChartTypeTemplateProvider* pTemplateProvider,
 239     Dialog * pParentDialog,
 240     bool bHideDescription /* = false */ ) :
 241         ::svt::OWizardPage( pParent, SchResId( TP_DATA_SOURCE )),
 242
 243     m_aFT_CAPTION     ( this, SchResId( FT_CAPTION_FOR_WIZARD )),
 244     m_aFT_SERIES      ( this, SchResId( FT_SERIES      )),
 245     m_apLB_SERIES( new SeriesListBox( this, SchResId( LB_SERIES ))),
 246     m_aBTN_ADD        ( this, SchResId( BTN_ADD        )),
 247     m_aBTN_REMOVE     ( this, SchResId( BTN_REMOVE     )),
 248     m_aBTN_UP         ( this, SchResId( BTN_UP         )),
 249     m_aBTN_DOWN       ( this, SchResId( BTN_DOWN       )),
 250     m_aFT_ROLE        ( this, SchResId( FT_ROLE        )),
 251     m_aLB_ROLE        ( this, SchResId( LB_ROLE        )),
 252     m_aFT_RANGE       ( this, SchResId( FT_RANGE       )),
 253     m_aEDT_RANGE      ( this, SchResId( EDT_RANGE      )),
 254     m_aIMB_RANGE_MAIN ( this, SchResId( IMB_RANGE_MAIN )),
 255     m_aFT_CATEGORIES  ( this, SchResId( FT_CATEGORIES  )),
 256     m_aFT_DATALABELS  ( this, SchResId( FT_DATALABELS  )),
 257     m_aEDT_CATEGORIES ( this, SchResId( EDT_CATEGORIES )),
 258     m_aIMB_RANGE_CAT  ( this, SchResId( IMB_RANGE_CAT  )),
 259
 260     m_pTemplateProvider( pTemplateProvider ),
 261     m_rDialogModel( rDialogModel ),
 262
 263     m_pCurrentRangeChoosingField( 0 ),
 264     m_bIsDirty( false ),
 265     m_pParentDialog( pParentDialog ),
 266     m_pTabPageNotifiable( dynamic_cast< TabPageNotifiable * >( pParentDialog ))
 267 {
 268     FreeResource();
 269
 270     if( bHideDescription )
 271     {
 272         // note: the offset should be a negative value for shifting upwards, the
 273         // 4 is for the offset difference between a wizard page and a tab-page
 274         long nYOffset = - ( m_aFT_SERIES.GetPosPixel().getY() - m_aFT_CAPTION.GetPosPixel().getY() + 4 );
 275         long nUpShift = - 2;
 276         long nYResize = - (nYOffset - nUpShift);
 277         m_aFT_CAPTION.Hide();
 278
 279         // shift list boxes and enlarge them by the space saved by hiding the caption
 280         lcl_shiftControlY( m_aFT_SERIES, nYOffset );
 281         lcl_shiftControlY( *(m_apLB_SERIES.get()), nYOffset );
 282         lcl_increaseHeightOfControl( *(m_apLB_SERIES.get()), nYResize );
 283
 284         lcl_shiftControlY( m_aFT_ROLE, nYOffset );
 285         lcl_shiftControlY( m_aLB_ROLE, nYOffset );
 286         lcl_increaseHeightOfControl( m_aLB_ROLE, nYResize );
 287
 288         lcl_shiftControlY( m_aBTN_ADD, nUpShift );
 289         lcl_shiftControlY( m_aBTN_REMOVE, nUpShift );
 290         lcl_shiftControlY( m_aBTN_UP, nUpShift );
 291         lcl_shiftControlY( m_aBTN_DOWN, nUpShift );
 292         lcl_shiftControlY( m_aFT_RANGE, nUpShift );
 293         lcl_shiftControlY( m_aEDT_RANGE, nUpShift );
 294         lcl_shiftControlY( m_aIMB_RANGE_MAIN, nUpShift );
 295         lcl_shiftControlY( m_aFT_CATEGORIES, nUpShift );
 296         lcl_shiftControlY( m_aFT_DATALABELS, nUpShift );
 297         lcl_shiftControlY( m_aEDT_CATEGORIES, nUpShift );
 298         lcl_shiftControlY( m_aIMB_RANGE_CAT, nUpShift );
 299     }
 300     else
 301     {
 302         // make font of caption bold
 303         Font aFont( m_aFT_CAPTION.GetControlFont() );
 304         aFont.SetWeight( WEIGHT_BOLD );
 305         m_aFT_CAPTION.SetControlFont( aFont );
 306
 307         // no mnemonic
 308         m_aFT_CAPTION.SetStyle( m_aFT_CAPTION.GetStyle() | WB_NOLABEL );
 309     }
 310
 311     m_aFixedTextRange = OUString( m_aFT_RANGE.GetText() );
 312     this->SetText( String( SchResId( STR_OBJECT_DATASERIES_PLURAL ) ) );
 313
 314     // set handlers
 315     m_apLB_SERIES->SetSelectHdl( LINK( this, DataSourceTabPage, SeriesSelectionChangedHdl ));
 316
 317     m_aLB_ROLE.SetWindowBits( WB_HSCROLL | WB_CLIPCHILDREN );
 318     m_aLB_ROLE.SetSelectionMode( SINGLE_SELECTION );
 319     m_aLB_ROLE.SetSelectHdl( LINK( this, DataSourceTabPage, RoleSelectionChangedHdl ));
 320
 321     m_aEDT_RANGE.SetKeyInputHdl( LINK( this, DataSourceTabPage, MainRangeButtonClickedHdl ));
 322     m_aEDT_CATEGORIES.SetKeyInputHdl( LINK( this, DataSourceTabPage, CategoriesRangeButtonClickedHdl ));
 323
 324     m_aIMB_RANGE_MAIN.SetClickHdl( LINK( this, DataSourceTabPage, MainRangeButtonClickedHdl ));
 325     m_aIMB_RANGE_CAT.SetClickHdl( LINK( this, DataSourceTabPage, CategoriesRangeButtonClickedHdl ));
 326
 327     m_aBTN_ADD.SetClickHdl( LINK( this, DataSourceTabPage, AddButtonClickedHdl ));
 328     m_aBTN_REMOVE.SetClickHdl( LINK( this, DataSourceTabPage, RemoveButtonClickedHdl ));
 329
 330     m_aBTN_UP.SetClickHdl( LINK( this, DataSourceTabPage, UpButtonClickedHdl ));
 331     m_aBTN_DOWN.SetClickHdl( LINK( this, DataSourceTabPage, DownButtonClickedHdl ));
 332
 333     m_aEDT_RANGE.SetModifyHdl( LINK( this, DataSourceTabPage, RangeModifiedHdl ));
 334     m_aEDT_CATEGORIES.SetModifyHdl( LINK( this, DataSourceTabPage, RangeModifiedHdl ));
 335     m_aEDT_RANGE.SetUpdateDataHdl( LINK( this, DataSourceTabPage, RangeUpdateDataHdl ));
 336     m_aEDT_CATEGORIES.SetUpdateDataHdl( LINK( this, DataSourceTabPage, RangeUpdateDataHdl ));
 337
 338     // #i75179# enable setting the background to a different color
 339     m_aEDT_RANGE.SetStyle( m_aEDT_RANGE.GetStyle() | WB_FORCECTRLBACKGROUND );
 340     m_aEDT_CATEGORIES.SetStyle( m_aEDT_CATEGORIES.GetStyle() | WB_FORCECTRLBACKGROUND );
 341
 342     // set symbol font for arrows
 343     // note: StarSymbol is substituted to OpenSymbol for OOo
 344     Font aSymbolFont( m_aBTN_UP.GetFont());
 345     aSymbolFont.SetName( String( RTL_CONSTASCII_USTRINGPARAM( "StarSymbol" )));
 346     m_aBTN_UP.SetControlFont( aSymbolFont );
 347     m_aBTN_DOWN.SetControlFont( aSymbolFont );
 348
 349     // set button text
 350     sal_Unicode cBlackUpPointingTriangle( 0x25b2 );
 351     sal_Unicode cBlackDownPointingTriangle( 0x25bc );
 352     m_aBTN_UP.SetText( String( cBlackUpPointingTriangle ));
 353     m_aBTN_DOWN.SetText( String( cBlackDownPointingTriangle ));
 354
 355     // init controls
 356     m_aLB_ROLE.SetTabs( lcl_pRoleListBoxTabs, MAP_APPFONT );
 357     m_aLB_ROLE.Show();
 358
 359     updateControlsFromDialogModel();
 360
 361     // select first series
 362     if( m_apLB_SERIES->First())
 363         m_apLB_SERIES->Select( m_apLB_SERIES->First());
 364     m_apLB_SERIES->GrabFocus();
 365 }
 366
 367 DataSourceTabPage::~DataSourceTabPage()
 368 {}
 369
 370 void DataSourceTabPage::ActivatePage()
 371 {
 372     OWizardPage::ActivatePage();
 373     updateControlsFromDialogModel();
 374 }
 375
 376 void DataSourceTabPage::initializePage()
 377 {
 378 }
 379
 380 void DataSourceTabPage::DeactivatePage()
 381 {
 382     commitPage();
 383     svt::OWizardPage::DeactivatePage();
 384 }
 385
 386 void DataSourceTabPage::commitPage()
 387 {
 388     commitPage(eFinish);
 389 }
 390
 391 sal_Bool DataSourceTabPage::commitPage( CommitPageReason /*eReason*/ )
 392 {
 393     //ranges may have been edited in the meanwhile (dirty is true in that case here)
 394     if( isValid() )
 395     {
 396         updateModelFromControl( 0 /*update all*/ );
 397         return sal_True;//return false if this page should not be left
 398     }
 399     else
 400         return sal_False;
 401 }
 402
 403 bool DataSourceTabPage::isRangeFieldContentValid( Edit & rEdit )
 404 {
 405     OUString aRange( rEdit.GetText());
 406     bool bIsValid = ( aRange.getLength() == 0 ) ||
 407         m_rDialogModel.getRangeSelectionHelper()->verifyCellRange( aRange );
 408
 409     if( bIsValid )
 410     {
 411         rEdit.SetControlForeground();
 412         rEdit.SetControlBackground();
 413     }
 414     else
 415     {
 416         rEdit.SetControlBackground( RANGE_SELECTION_INVALID_RANGE_BACKGROUND_COLOR );
 417         rEdit.SetControlForeground( RANGE_SELECTION_INVALID_RANGE_FOREGROUND_COLOR );
 418     }
 419
 420     return bIsValid;
 421 }
 422
 423 bool DataSourceTabPage::isValid()
 424 {
 425     bool bRoleRangeValid = true;
 426     bool bCategoriesRangeValid = true;
 427     bool bHasSelectedEntry = (m_apLB_SERIES->FirstSelected() != 0);
 428
 429     if( bHasSelectedEntry )
 430         bRoleRangeValid = isRangeFieldContentValid( m_aEDT_RANGE );
 431     if( m_aEDT_CATEGORIES.IsEnabled() )
 432         bCategoriesRangeValid = isRangeFieldContentValid( m_aEDT_CATEGORIES );
 433     bool bValid = ( bRoleRangeValid && bCategoriesRangeValid );
 434
 435     if( m_pTabPageNotifiable )
 436     {
 437         if( bValid )
 438             m_pTabPageNotifiable->setValidPage( this );
 439         else
 440             m_pTabPageNotifiable->setInvalidPage( this );
 441     }
 442
 443     return bValid;
 444 }
 445
 446 void DataSourceTabPage::setDirty()
 447 {
 448     m_bIsDirty = true;
 449 }
 450
 451 void DataSourceTabPage::updateControlsFromDialogModel()
 452 {
 453     // series
 454     fillSeriesListBox();
 455     SeriesSelectionChangedHdl( 0 );
 456
 457     // categories
 458     m_aEDT_CATEGORIES.SetText( String( m_rDialogModel.getCategoriesRange() ));
 459
 460     updateControlState();
 461 }
 462
 463 void DataSourceTabPage::fillSeriesListBox()
 464 {
 465     m_apLB_SERIES->SetUpdateMode( FALSE );
 466
 467     Reference< XDataSeries > xSelected;
 468     SeriesEntry * pEntry = dynamic_cast< SeriesEntry * >( m_apLB_SERIES->FirstSelected());
 469     if( pEntry )
 470         xSelected.set( pEntry->m_xDataSeries );
 471
 472     bool bHasSelectedEntry = (pEntry != 0);
 473     SvLBoxEntry * pSelectedEntry = 0;
 474     m_apLB_SERIES->Clear();
 475
 476     ::std::vector< DialogModel::tSeriesWithChartTypeByName > aSeries(
 477         m_rDialogModel.getAllDataSeriesWithLabel() );
 478
 479     sal_Int32 nUnnamedSeriesIndex = 1;
 480     for( ::std::vector< DialogModel::tSeriesWithChartTypeByName >::const_iterator aIt = aSeries.begin();
 481          aIt != aSeries.end(); ++aIt )
 482     {
 483         String aLabel( (*aIt).first );
 484         if( !aLabel.Len())
 485         {
 486             if( nUnnamedSeriesIndex > 1 )
 487             {
 488                 OUString aResString( String( ::chart::SchResId( STR_DATA_UNNAMED_SERIES_WITH_INDEX )));
 489
 490                 // replace index of unnamed series
 491                 const OUString aReplacementStr( RTL_CONSTASCII_USTRINGPARAM( "%NUMBER" ));
 492                 sal_Int32 nIndex = aResString.indexOf( aReplacementStr );
 493                 if( nIndex != -1 )
 494                     aLabel = String( aResString.replaceAt(
 495                                          nIndex, aReplacementStr.getLength(),
 496                                          String::CreateFromInt32( nUnnamedSeriesIndex )));
 497             }
 498             if( aLabel.Len() == 0 )
 499                 aLabel = String( ::chart::SchResId( STR_DATA_UNNAMED_SERIES ));
 500
 501             ++nUnnamedSeriesIndex;
 502         }
 503         pEntry = dynamic_cast< SeriesEntry * >(
 504             m_apLB_SERIES->InsertEntry( aLabel ));
 505         if( pEntry )
 506         {
 507             pEntry->m_xDataSeries.set( (*aIt).second.first );
 508             pEntry->m_xChartType.set(  (*aIt).second.second );
 509             if( bHasSelectedEntry && ((*aIt).second.first == xSelected))
 510                 pSelectedEntry = pEntry;
 511         }
 512     }
 513
 514     if( bHasSelectedEntry && pSelectedEntry )
 515         m_apLB_SERIES->Select( pSelectedEntry );
 516
 517     m_apLB_SERIES->SetUpdateMode( TRUE );
 518 }
 519
 520 void DataSourceTabPage::fillRoleListBox()
 521 {
 522     SeriesEntry * pSeriesEntry = dynamic_cast< SeriesEntry * >( m_apLB_SERIES->FirstSelected());
 523     bool bHasSelectedEntry = (pSeriesEntry != 0);
 524
 525     SvLBoxEntry * pRoleEntry =  m_aLB_ROLE.FirstSelected();
 526     ULONG nRoleIndex = SAL_MAX_UINT32;
 527     if( pRoleEntry )
 528         nRoleIndex = m_aLB_ROLE.GetModel()->GetAbsPos( pRoleEntry );
 529
 530     if( bHasSelectedEntry )
 531     {
 532         DialogModel::tRolesWithRanges aRoles(
 533             m_rDialogModel.getRolesWithRanges(
 534                 pSeriesEntry->m_xDataSeries,
 535                 lcl_GetSequenceNameForLabel( pSeriesEntry ),
 536                 pSeriesEntry->m_xChartType ));
 537
 538         // fill role list
 539         m_aLB_ROLE.SetUpdateMode( FALSE );
 540         m_aLB_ROLE.Clear();
 541         m_aLB_ROLE.RemoveSelection();
 542
 543         for( DialogModel::tRolesWithRanges::const_iterator aIt( aRoles.begin());
 544              aIt != aRoles.end(); ++ aIt )
 545         {
 546             m_aLB_ROLE.InsertEntry( lcl_GetRoleLBEntry( aIt->first, aIt->second ));
 547         }
 548
 549         // series may contain no roles, check listbox size before selecting entries
 550         if( m_aLB_ROLE.GetEntryCount() > 0 )
 551         {
 552             if( nRoleIndex >= m_aLB_ROLE.GetEntryCount())
 553                 nRoleIndex = 0;
 554             m_aLB_ROLE.Select( m_aLB_ROLE.GetEntry( nRoleIndex ));
 555         }
 556
 557         m_aLB_ROLE.SetUpdateMode( TRUE );
 558     }
 559 }
 560
 561 void DataSourceTabPage::updateControlState()
 562 {
 563     SvLBoxEntry * pSeriesEntry = m_apLB_SERIES->FirstSelected();
 564     bool bHasSelectedSeries = (pSeriesEntry != 0);
 565     bool bHasValidRole = false;
 566     bool bHasRangeChooser = m_rDialogModel.getRangeSelectionHelper()->hasRangeSelection();
 567
 568     if( bHasSelectedSeries )
 569     {
 570         SvLBoxEntry * pRoleEntry =  m_aLB_ROLE.FirstSelected();
 571         bHasValidRole = (pRoleEntry != 0);
 572     }
 573
 574     m_aBTN_ADD.Enable( true );
 575     m_aBTN_REMOVE.Enable( bHasSelectedSeries );
 576
 577     m_aBTN_UP.Enable( bHasSelectedSeries && (pSeriesEntry != m_apLB_SERIES->First()));
 578     m_aBTN_DOWN.Enable( bHasSelectedSeries && (pSeriesEntry != m_apLB_SERIES->Last()));
 579
 580     bool bHasCategories = m_rDialogModel.isCategoryDiagram();
 581
 582     m_aFT_DATALABELS.Show(!bHasCategories);
 583     m_aFT_CATEGORIES.Show( bHasCategories);
 584     BOOL bShowIB = bHasRangeChooser;
 585     lcl_ShowChooserButton( m_aIMB_RANGE_CAT, m_aEDT_CATEGORIES, bShowIB );
 586
 587     m_aFT_SERIES.Enable();
 588     m_apLB_SERIES->Enable();
 589
 590     m_aFT_ROLE.Enable( bHasSelectedSeries );
 591     m_aLB_ROLE.Enable( bHasSelectedSeries );
 592
 593     m_aFT_RANGE.Enable( bHasValidRole );
 594     m_aEDT_RANGE.Enable( bHasValidRole );
 595     lcl_ShowChooserButton( m_aIMB_RANGE_MAIN, m_aEDT_RANGE, bShowIB );
 596     isValid();
 597 }
 598
 599 IMPL_LINK( DataSourceTabPage, SeriesSelectionChangedHdl, void *, EMPTYARG )
 600 {
 601     m_rDialogModel.startControllerLockTimer();
 602     if( m_apLB_SERIES->FirstSelected())
 603     {
 604         fillRoleListBox();
 605         RoleSelectionChangedHdl( 0 );
 606     }
 607     updateControlState();
 608
 609     return 0;
 610 }
 611
 612 IMPL_LINK( DataSourceTabPage, RoleSelectionChangedHdl, void *, EMPTYARG )
 613 {
 614     m_rDialogModel.startControllerLockTimer();
 615     SvLBoxEntry * pEntry = m_aLB_ROLE.FirstSelected();
 616     if( pEntry )
 617     {
 618         OUString aRange( m_aEDT_RANGE.GetText());
 619         OUString aSelectedRoleUI = lcl_GetSelectedRole( m_aLB_ROLE, true );
 620         OUString aSelectedRange = lcl_GetSelectedRolesRange( m_aLB_ROLE );
 621
 622         // replace role in fixed text label
 623         const OUString aReplacementStr( RTL_CONSTASCII_USTRINGPARAM( "%VALUETYPE" ));
 624         sal_Int32 nIndex = m_aFixedTextRange.indexOf( aReplacementStr );
 625         if( nIndex != -1 )
 626         {
 627             m_aFT_RANGE.SetText(
 628                 String( m_aFixedTextRange.replaceAt(
 629                             nIndex, aReplacementStr.getLength(), aSelectedRoleUI )));
 630         }
 631
 632         m_aEDT_RANGE.SetText( String( aSelectedRange ));
 633         isValid();
 634     }
 635
 636     return 0;
 637 }
 638
 639 IMPL_LINK( DataSourceTabPage, MainRangeButtonClickedHdl, void *, EMPTYARG )
 640 {
 641     OSL_ASSERT( m_pCurrentRangeChoosingField == 0 );
 642     m_pCurrentRangeChoosingField = & m_aEDT_RANGE;
 643     if( m_aEDT_RANGE.GetText().Len() > 0 &&
 644         ! updateModelFromControl( m_pCurrentRangeChoosingField ))
 645         return 0;
 646
 647     SeriesEntry * pEntry = dynamic_cast< SeriesEntry * >( m_apLB_SERIES->FirstSelected());
 648     bool bHasSelectedEntry = (pEntry != 0);
 649
 650     OUString aSelectedRolesRange = lcl_GetSelectedRolesRange( m_aLB_ROLE );
 651
 652     if( bHasSelectedEntry && (m_aLB_ROLE.FirstSelected() != 0))
 653     {
 654         String aStr( SchResId( STR_DATA_SELECT_RANGE_FOR_SERIES ));
 655         OUString aUIStr( aStr );
 656
 657         // replace role
 658         OUString aReplacement( RTL_CONSTASCII_USTRINGPARAM( "%VALUETYPE" ));
 659         sal_Int32 nIndex = aUIStr.indexOf( aReplacement );
 660         if( nIndex != -1 )
 661         {
 662             aUIStr = aUIStr.replaceAt( nIndex, aReplacement.getLength(),
 663                                        lcl_GetSelectedRole( m_aLB_ROLE, true ));
 664         }
 665         // replace series name
 666         aReplacement = C2U( "%SERIESNAME" );
 667         nIndex = aUIStr.indexOf( aReplacement );
 668         if( nIndex != -1 )
 669         {
 670             aUIStr = aUIStr.replaceAt( nIndex, aReplacement.getLength(),
 671                                        OUString( m_apLB_SERIES->GetEntryText( pEntry )));
 672         }
 673
 674         lcl_enableRangeChoosing( true, m_pParentDialog );
 675         m_rDialogModel.getRangeSelectionHelper()->chooseRange( aSelectedRolesRange, aUIStr, *this );
 676     }
 677     else
 678         m_pCurrentRangeChoosingField = 0;
 679
 680     return 0;
 681 }
 682
 683 IMPL_LINK( DataSourceTabPage, CategoriesRangeButtonClickedHdl, void *, EMPTYARG )
 684 {
 685     OSL_ASSERT( m_pCurrentRangeChoosingField == 0 );
 686     m_pCurrentRangeChoosingField = & m_aEDT_CATEGORIES;
 687     if( m_aEDT_CATEGORIES.GetText().Len() > 0 &&
 688         ! updateModelFromControl( m_pCurrentRangeChoosingField ))
 689         return 0;
 690
 691     String aStr( SchResId( m_aFT_CATEGORIES.IsVisible() ? STR_DATA_SELECT_RANGE_FOR_CATEGORIES : STR_DATA_SELECT_RANGE_FOR_DATALABELS ));
 692     lcl_enableRangeChoosing( true, m_pParentDialog );
 693     m_rDialogModel.getRangeSelectionHelper()->chooseRange(
 694         m_rDialogModel.getCategoriesRange(), OUString( aStr ), *this );
 695     return 0;
 696 }
 697
 698 IMPL_LINK( DataSourceTabPage, AddButtonClickedHdl, void *, EMPTYARG )
 699 {
 700     m_rDialogModel.startControllerLockTimer();
 701     SeriesEntry * pEntry = dynamic_cast< SeriesEntry * >( m_apLB_SERIES->FirstSelected());
 702     Reference< XDataSeries > xSeriesToInsertAfter;
 703     Reference< XChartType > xChartTypeForNewSeries;
 704     if( m_pTemplateProvider )
 705             m_rDialogModel.setTemplate( m_pTemplateProvider->getCurrentTemplate());
 706
 707     if( pEntry )
 708     {
 709         xSeriesToInsertAfter.set( pEntry->m_xDataSeries );
 710         xChartTypeForNewSeries.set( pEntry->m_xChartType );
 711     }
 712     else
 713     {
 714         ::std::vector< Reference< XDataSeriesContainer > > aCntVec(
 715             m_rDialogModel.getAllDataSeriesContainers());
 716         if( ! aCntVec.empty())
 717             xChartTypeForNewSeries.set( aCntVec.front(), uno::UNO_QUERY );
 718     }
 719     OSL_ENSURE( xChartTypeForNewSeries.is(), "Cannot insert new series" );
 720
 721     m_rDialogModel.insertSeriesAfter( xSeriesToInsertAfter, xChartTypeForNewSeries );
 722     setDirty();
 723
 724     fillSeriesListBox();
 725     // note the box was cleared and refilled, so pEntry is invalid now
 726     SvLBoxEntry * pSelEntry = m_apLB_SERIES->FirstSelected();
 727     if( pSelEntry )
 728     {
 729         SvLBoxEntry * pNextEntry = m_apLB_SERIES->Next( pSelEntry );
 730         if( pNextEntry )
 731             m_apLB_SERIES->Select( pNextEntry );
 732     }
 733     SeriesSelectionChangedHdl( 0 );
 734
 735     return 0;
 736 }
 737
 738 IMPL_LINK( DataSourceTabPage, RemoveButtonClickedHdl, void *, EMPTYARG )
 739 {
 740     m_rDialogModel.startControllerLockTimer();
 741     SeriesEntry * pEntry = dynamic_cast< SeriesEntry * >( m_apLB_SERIES->FirstSelected());
 742     if( pEntry )
 743     {
 744         Reference< XDataSeries > xNewSelSeries;
 745         SeriesEntry * pNewSelEntry = dynamic_cast< SeriesEntry * >(
 746             m_apLB_SERIES->Next( pEntry ));
 747         if( pNewSelEntry )
 748             xNewSelSeries.set( pNewSelEntry->m_xDataSeries );
 749         else
 750         {
 751             pNewSelEntry = dynamic_cast< SeriesEntry * >( m_apLB_SERIES->Prev( pEntry ));
 752             if( pNewSelEntry )
 753                 xNewSelSeries.set( pNewSelEntry->m_xDataSeries );
 754         }
 755
 756         m_rDialogModel.deleteSeries( pEntry->m_xDataSeries, pEntry->m_xChartType );
 757         setDirty();
 758
 759         m_apLB_SERIES->RemoveSelection();
 760         fillSeriesListBox();
 761
 762         // select previous or next series
 763         //@improve: see methods GetModel()->GetAbsPos()/GetEntry() for absoulte list positions
 764         if( xNewSelSeries.is())
 765         {
 766             pEntry = dynamic_cast< SeriesEntry * >( m_apLB_SERIES->First());
 767             while( pEntry )
 768             {
 769                 if( pEntry->m_xDataSeries == xNewSelSeries )
 770                 {
 771                     m_apLB_SERIES->Select( pEntry );
 772                     break;
 773                 }
 774                 pEntry = dynamic_cast< SeriesEntry * >( m_apLB_SERIES->Next( pEntry ));
 775             }
 776         }
 777         SeriesSelectionChangedHdl( 0 );
 778     }
 779
 780     return 0;
 781 }
 782
 783 IMPL_LINK( DataSourceTabPage, UpButtonClickedHdl, void *, EMPTYARG )
 784 {
 785     m_rDialogModel.startControllerLockTimer();
 786     SeriesEntry * pEntry = dynamic_cast< SeriesEntry * >( m_apLB_SERIES->FirstSelected());
 787     bool bHasSelectedEntry = (pEntry != 0);
 788
 789     if( bHasSelectedEntry )
 790     {
 791         m_rDialogModel.moveSeries( pEntry->m_xDataSeries, DialogModel::MOVE_UP );
 792         setDirty();
 793         fillSeriesListBox();
 794         SeriesSelectionChangedHdl(0);
 795     }
 796
 797     return 0;
 798 }
 799
 800 IMPL_LINK( DataSourceTabPage, DownButtonClickedHdl, void *, EMPTYARG )
 801 {
 802     m_rDialogModel.startControllerLockTimer();
 803     SeriesEntry * pEntry = dynamic_cast< SeriesEntry * >( m_apLB_SERIES->FirstSelected());
 804     bool bHasSelectedEntry = (pEntry != 0);
 805
 806     if( bHasSelectedEntry )
 807     {
 808         m_rDialogModel.moveSeries( pEntry->m_xDataSeries, DialogModel::MOVE_DOWN );
 809         setDirty();
 810         fillSeriesListBox();
 811         SeriesSelectionChangedHdl(0);
 812     }
 813
 814     return 0;
 815 }
 816
 817 IMPL_LINK( DataSourceTabPage, RangeModifiedHdl, Edit*, pEdit )
 818 {
 819     if( isRangeFieldContentValid( *pEdit ))
 820         setDirty();
 821
 822     // enable/disable OK button
 823     isValid();
 824
 825     return 0;
 826 }
 827
 828 IMPL_LINK( DataSourceTabPage, RangeUpdateDataHdl, Edit*, pEdit )
 829 {
 830     // note: isValid sets the color of the edit field
 831     if( isRangeFieldContentValid( *pEdit ))
 832     {
 833         setDirty();
 834         updateModelFromControl( pEdit );
 835         if( pEdit== &m_aEDT_RANGE )
 836         {
 837             if( ! lcl_UpdateCurrentSeriesName( *m_apLB_SERIES ))
 838                 fillSeriesListBox();
 839         }
 840     }
 841     // enable/disable OK button
 842     isValid();
 843
 844     return 0;
 845 }
 846
 847 void DataSourceTabPage::listeningFinished(
 848     const ::rtl::OUString & rNewRange )
 849 {
 850     // rNewRange becomes invalid after removing the listener
 851     OUString aRange( rNewRange );
 852
 853     m_rDialogModel.startControllerLockTimer();
 854
 855     // stop listening
 856     m_rDialogModel.getRangeSelectionHelper()->stopRangeListening();
 857
 858     // change edit field
 859     ToTop();
 860     GrabFocus();
 861     if( m_pCurrentRangeChoosingField )
 862     {
 863         m_pCurrentRangeChoosingField->SetText( String( aRange ));
 864         m_pCurrentRangeChoosingField->GrabFocus();
 865     }
 866
 867     if( m_pCurrentRangeChoosingField == & m_aEDT_RANGE )
 868     {
 869         m_aEDT_RANGE.SetText( String( aRange ));
 870         setDirty();
 871     }
 872     else if( m_pCurrentRangeChoosingField == & m_aEDT_CATEGORIES )
 873     {
 874         m_aEDT_CATEGORIES.SetText( String( aRange ));
 875         setDirty();
 876     }
 877
 878     updateModelFromControl( m_pCurrentRangeChoosingField );
 879     if( ! lcl_UpdateCurrentSeriesName( *m_apLB_SERIES ))
 880         fillSeriesListBox();
 881
 882     m_pCurrentRangeChoosingField = 0;
 883
 884     updateControlState();
 885     lcl_enableRangeChoosing( false, m_pParentDialog );
 886 }
 887
 888 void DataSourceTabPage::disposingRangeSelection()
 889 {
 890     m_rDialogModel.getRangeSelectionHelper()->stopRangeListening( false );
 891 }
 892
 893 bool DataSourceTabPage::updateModelFromControl( Edit * pField )
 894 {
 895     if( !m_bIsDirty )
 896         return true;
 897
 898     ControllerLockGuard aLockedControllers( m_rDialogModel.getChartModel() );
 899
 900     // @todo: validity check of field content
 901     bool bResult = true;
 902     bool bAll = (pField == 0);
 903     Reference< data::XDataProvider > xDataProvider( m_rDialogModel.getDataProvider());
 904
 905     if( bAll || (pField == & m_aEDT_CATEGORIES) )
 906     {
 907         Reference< data::XLabeledDataSequence > xLabeledSeq( m_rDialogModel.getCategories() );
 908         if( xDataProvider.is())
 909         {
 910             OUString aRange( m_aEDT_CATEGORIES.GetText());
 911             if( aRange.getLength())
 912             {
 913                 // create or change categories
 914                 if( !xLabeledSeq.is())
 915                 {
 916                     xLabeledSeq.set( DataSourceHelper::createLabeledDataSequence( Reference< uno::XComponentContext >(0)));
 917                     m_rDialogModel.setCategories( xLabeledSeq );
 918                 }
 919                 try
 920                 {
 921                     xLabeledSeq->setValues( xDataProvider->createDataSequenceByRangeRepresentation( aRange ));
 922                 }
 923                 catch( const uno::Exception & ex )
 924                 {
 925                     // should work as validation should have happened before
 926                     ASSERT_EXCEPTION( ex );
 927                 }
 928             }
 929             else if( xLabeledSeq.is())
 930             {
 931                 // clear existing categories
 932                 xLabeledSeq.set(0);
 933                 m_rDialogModel.setCategories( xLabeledSeq );
 934             }
 935         }
 936     }
 937
 938     SeriesEntry * pSeriesEntry = dynamic_cast< SeriesEntry * >( m_apLB_SERIES->FirstSelected());
 939     bool bHasSelectedEntry = (pSeriesEntry != 0);
 940
 941     if( bHasSelectedEntry )
 942     {
 943         if( bAll || (pField == & m_aEDT_RANGE) )
 944         {
 945             try
 946             {
 947                 OUString aSelectedRole = lcl_GetSelectedRole( m_aLB_ROLE );
 948                 OUString aRange( m_aEDT_RANGE.GetText());
 949                 OUString aSequenceRole( aSelectedRole );
 950                 bool bIsLabel = aSequenceRole.equals( lcl_aLabelRole );
 951                 OUString aSequenceNameForLabel( lcl_GetSequenceNameForLabel( pSeriesEntry ));
 952
 953                 if( bIsLabel )
 954                     aSequenceRole = aSequenceNameForLabel;
 955
 956                 Reference< data::XDataSource > xSource( pSeriesEntry->m_xDataSeries, uno::UNO_QUERY_THROW );
 957                 Reference< data::XLabeledDataSequence > xLabeledSeq(
 958                     DataSeriesHelper::getDataSequenceByRole( xSource, aSequenceRole ));
 959
 960                 if( xDataProvider.is())
 961                 {
 962                     if( bIsLabel )
 963                     {
 964                         if( ! xLabeledSeq.is())
 965                         {
 966                             // check if there is already an "orphan" label sequence
 967                             xLabeledSeq.set( lcl_findLSequenceWithOnlyLabel( xSource ));
 968                             if( ! xLabeledSeq.is())
 969                             {
 970                                 // no corresponding labeled data sequence for label found
 971                                 xLabeledSeq.set( DataSourceHelper::createLabeledDataSequence( Reference< uno::XComponentContext >(0)));
 972                                 lcl_addLSequenceToDataSource( xLabeledSeq, xSource );
 973                             }
 974                         }
 975                         if( xLabeledSeq.is())
 976                         {
 977                             if( aRange.getLength())
 978                             {
 979                                 Reference< data::XDataSequence > xNewSeq;
 980                                 try
 981                                 {
 982                                     xNewSeq.set( xDataProvider->createDataSequenceByRangeRepresentation( aRange ));
 983                                 }
 984                                 catch( const uno::Exception & ex )
 985                                 {
 986                                     // should work as validation should have happened before
 987                                     ASSERT_EXCEPTION( ex );
 988                                 }
 989                                 if( xNewSeq.is())
 990                                 {
 991                                     // update range name by the full string provided
 992                                     // by the data provider. E.g. "a1" might become
 993                                     // "$Sheet1.$A$1"
 994                                     aRange = xNewSeq->getSourceRangeRepresentation();
 995                                     Reference< beans::XPropertySet > xProp( xNewSeq, uno::UNO_QUERY_THROW );
 996                                     xProp->setPropertyValue( C2U("Role"), uno::makeAny( lcl_aLabelRole ));
 997                                     xLabeledSeq->setLabel( xNewSeq );
 998                                 }
 999                             }
1000                             else
1001                             {
1002                                 xLabeledSeq->setLabel( Reference< data::XDataSequence >());
1003                             }
1004                         }
1005                     }
1006                     else
1007                     {
1008                         if( aRange.getLength())
1009                         {
1010                             Reference< data::XDataSequence > xNewSeq;
1011                             try
1012                             {
1013                                 xNewSeq.set( xDataProvider->createDataSequenceByRangeRepresentation( aRange ));
1014                             }
1015                             catch( const uno::Exception & ex )
1016                             {
1017                                 // should work as validation should have happened before
1018                                 ASSERT_EXCEPTION( ex );
1019                             }
1020                             if( xNewSeq.is())
1021                             {
1022                                 // update range name by the full string provided
1023                                 // by the data provider. E.g. "a1:e1" might become
1024                                 // "$Sheet1.$A$1:$E$1"
1025                                 aRange = xNewSeq->getSourceRangeRepresentation();
1026
1027                                 Reference< beans::XPropertySet > xProp( xNewSeq, uno::UNO_QUERY_THROW );
1028                                 xProp->setPropertyValue( C2U("Role"), uno::makeAny( aSelectedRole ));
1029                                 if( !xLabeledSeq.is())
1030                                 {
1031                                     if( aSelectedRole.equals( aSequenceNameForLabel ))
1032                                         xLabeledSeq.set( lcl_findLSequenceWithOnlyLabel( xSource ));
1033                                     if( ! xLabeledSeq.is())
1034                                     {
1035                                         xLabeledSeq.set( DataSourceHelper::createLabeledDataSequence( Reference< uno::XComponentContext >(0)));
1036                                         lcl_addLSequenceToDataSource( xLabeledSeq, xSource );
1037                                     }
1038                                 }
1039                                 xLabeledSeq->setValues( xNewSeq );
1040                             }
1041                         }
1042                         else if( xLabeledSeq.is())
1043                         {
1044                             // values cannot be deleted. This would also delete the Role (for labels)
1045 //                             xLabeledSeq->setValues( Reference< data::XDataSequence >());
1046                         }
1047                     }
1048                 }
1049
1050                 lcl_UpdateCurrentRange( m_aLB_ROLE, aSelectedRole, aRange );
1051             }
1052             catch( uno::Exception & ex )
1053             {
1054                 bResult = false;
1055                 ASSERT_EXCEPTION( ex );
1056             }
1057         }
1058     }
1059
1060     // update View
1061     // @todo remove this when automatic view updates from calc, writer and own data sequences are available
1062     if( bResult )
1063     {
1064         try
1065         {
1066             Reference< util::XModifiable > xModifiable( m_rDialogModel.getChartModel(), uno::UNO_QUERY );
1067             if( xModifiable.is() )
1068                 xModifiable->setModified( sal_True );
1069         }
1070         catch( uno::Exception & ex )
1071         {
1072             ASSERT_EXCEPTION( ex );
1073         }
1074     }
1075
1076     return bResult;
1077 }
1078
1079 } //  namespace chart