/************************************************************************* * * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: StatisticsItemConverter.cxx,v $ * * $Revision: 1.19 $ * * last change: $Author: rt $ $Date: 2008-02-18 15:56:43 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. * * * GNU Lesser General Public License Version 2.1 * ============================================= * Copyright 2005 by Sun Microsystems, Inc. * 901 San Antonio Road, Palo Alto, CA 94303, USA * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License version 2.1, as published by the Free Software Foundation. * * This library 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 for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * ************************************************************************/ // MARKER(update_precomp.py): autogen include statement, do not remove #include "precompiled_chart2.hxx" #include "StatisticsItemConverter.hxx" #include "SchWhichPairs.hxx" #include "macros.hxx" #include "ItemPropertyMap.hxx" #include "RegressionCurveHelper.hxx" #include "ErrorBar.hxx" #include "PropertyHelper.hxx" #include "ChartModelHelper.hxx" #include "ChartTypeHelper.hxx" #include "GraphicPropertyItemConverter.hxx" #ifndef _SVX_CHRTITEM_HXX #include #endif #ifndef _SFXINTITEM_HXX #include #endif #ifndef INCLUDED_RTL_MATH_HXX #include #endif #ifndef _COM_SUN_STAR_CHART2_DATAPOINTLABEL_HPP_ #include #endif #ifndef _COM_SUN_STAR_CHART2_XREGRESSIONCURVECONTAINER_HPP_ #include #endif #ifndef _COM_SUN_STAR_CHART2_ERRORBARSTYLE_HPP_ #include #endif #ifndef _COM_SUN_STAR_LANG_XSERVICENAME_HPP_ #include #endif #include #include #include using namespace ::com::sun::star; namespace { uno::Reference< beans::XPropertySet > lcl_GetYErrorBar( const uno::Reference< beans::XPropertySet > & xProp ) { uno::Reference< beans::XPropertySet > xResult; if( xProp.is()) try { ( xProp->getPropertyValue( C2U( "ErrorBarY" )) >>= xResult ); } catch( uno::Exception & ex ) { ASSERT_EXCEPTION( ex ); } return xResult; } ::chart::RegressionCurveHelper::tRegressionType lcl_convertRegressionType( SvxChartRegress eRegress ) { ::chart::RegressionCurveHelper::tRegressionType eType = ::chart::RegressionCurveHelper::REGRESSION_TYPE_NONE; switch( eRegress ) { case CHREGRESS_LINEAR: eType = ::chart::RegressionCurveHelper::REGRESSION_TYPE_LINEAR; break; case CHREGRESS_LOG: eType = ::chart::RegressionCurveHelper::REGRESSION_TYPE_LOG; break; case CHREGRESS_EXP: eType = ::chart::RegressionCurveHelper::REGRESSION_TYPE_EXP; break; case CHREGRESS_POWER: eType = ::chart::RegressionCurveHelper::REGRESSION_TYPE_POWER; break; case CHREGRESS_NONE: break; } return eType; } uno::Reference< beans::XPropertySet > lcl_GetDefaultErrorBar() { // todo: use a valid context return uno::Reference< beans::XPropertySet >( new ::chart::ErrorBar( uno::Reference< uno::XComponentContext >())); } void lcl_getErrorValues( const uno::Reference< beans::XPropertySet > & xErrorBarProp, double & rOutPosError, double & rOutNegError ) { if( ! xErrorBarProp.is()) return; try { xErrorBarProp->getPropertyValue( C2U( "PositiveError" )) >>= rOutPosError; xErrorBarProp->getPropertyValue( C2U( "NegativeError" )) >>= rOutNegError; } catch( uno::Exception & ex ) { ASSERT_EXCEPTION( ex ); } } void lcl_getErrorIndicatorValues( const uno::Reference< beans::XPropertySet > & xErrorBarProp, bool & rOutShowPosError, bool & rOutShowNegError ) { if( ! xErrorBarProp.is()) return; try { xErrorBarProp->getPropertyValue( C2U( "ShowPositiveError" )) >>= rOutShowPosError; xErrorBarProp->getPropertyValue( C2U( "ShowNegativeError" )) >>= rOutShowNegError; } catch( uno::Exception & ex ) { ASSERT_EXCEPTION( ex ); } } uno::Reference< beans::XPropertySet > lcl_getEquationProperties( const uno::Reference< beans::XPropertySet > & xSeriesPropSet, const SfxItemSet * pItemSet ) { bool bEquationExists = true; // ensure that a trendline is on if( pItemSet ) { SvxChartRegress eRegress = CHREGRESS_NONE; const SfxPoolItem *pPoolItem = NULL; if( pItemSet->GetItemState( SCHATTR_STAT_REGRESSTYPE, TRUE, &pPoolItem ) == SFX_ITEM_SET ) { eRegress = static_cast< const SvxChartRegressItem * >( pPoolItem )->GetValue(); bEquationExists = ( eRegress != CHREGRESS_NONE ); } } if( bEquationExists ) { uno::Reference< chart2::XRegressionCurveContainer > xRegCnt( xSeriesPropSet, uno::UNO_QUERY ); uno::Reference< chart2::XRegressionCurve > xCurve( ::chart::RegressionCurveHelper::getFirstCurveNotMeanValueLine( xRegCnt )); if( xCurve.is()) { return xCurve->getEquationProperties(); } } return uno::Reference< beans::XPropertySet >(); } } // anonymous namespace namespace chart { namespace wrapper { StatisticsItemConverter::StatisticsItemConverter( const uno::Reference< frame::XModel > & xModel, const uno::Reference< beans::XPropertySet > & rPropertySet, SfxItemPool& rItemPool ) : ItemConverter( rPropertySet, rItemPool ), m_xModel( xModel ) { OSL_ASSERT( static_cast< int >( RegressionCurveHelper::REGRESSION_TYPE_NONE ) == static_cast< int >( CHREGRESS_NONE )); OSL_ASSERT( static_cast< int >( RegressionCurveHelper::REGRESSION_TYPE_LINEAR ) == static_cast< int >( CHREGRESS_LINEAR )); OSL_ASSERT( static_cast< int >( RegressionCurveHelper::REGRESSION_TYPE_LOG ) == static_cast< int >( CHREGRESS_LOG )); OSL_ASSERT( static_cast< int >( RegressionCurveHelper::REGRESSION_TYPE_EXP ) == static_cast< int >( CHREGRESS_EXP )); OSL_ASSERT( static_cast< int >( RegressionCurveHelper::REGRESSION_TYPE_POWER ) == static_cast< int >( CHREGRESS_POWER )); } StatisticsItemConverter::~StatisticsItemConverter() {} const USHORT * StatisticsItemConverter::GetWhichPairs() const { // must span all used items! return nStatWhichPairs; } bool StatisticsItemConverter::GetItemProperty( tWhichIdType /* nWhichId */, tPropertyNameWithMemberId & /* rOutProperty */ ) const { return false; } bool StatisticsItemConverter::ApplySpecialItem( USHORT nWhichId, const SfxItemSet & rItemSet ) throw( uno::Exception ) { bool bChanged = false; uno::Any aValue; switch( nWhichId ) { case SCHATTR_STAT_AVERAGE: { uno::Reference< chart2::XRegressionCurveContainer > xRegCnt( GetPropertySet(), uno::UNO_QUERY ); bool bOldHasMeanValueLine = RegressionCurveHelper::hasMeanValueLine( xRegCnt ); bool bNewHasMeanValueLine = static_cast< const SfxBoolItem & >( rItemSet.Get( nWhichId )).GetValue(); if( bOldHasMeanValueLine != bNewHasMeanValueLine ) { if( ! bNewHasMeanValueLine ) RegressionCurveHelper::removeMeanValueLine( xRegCnt ); else RegressionCurveHelper::addMeanValueLine( xRegCnt, uno::Reference< uno::XComponentContext >(), GetPropertySet() ); bChanged = true; } } break; // Attention !!! This case must be passed before SCHATTR_STAT_PERCENT, // SCHATTR_STAT_BIGERROR, SCHATTR_STAT_CONSTPLUS, // SCHATTR_STAT_CONSTMINUS and SCHATTR_STAT_INDICATE case SCHATTR_STAT_KIND_ERROR: { uno::Reference< beans::XPropertySet > xOldErrorBarProp( lcl_GetYErrorBar( GetPropertySet() )); SvxChartKindError eErrorKind = static_cast< const SvxChartKindErrorItem & >( rItemSet.Get( nWhichId )).GetValue(); if( !xOldErrorBarProp.is() && eErrorKind == CHERROR_NONE) { //nothing to do } else { chart2::ErrorBarStyle eStyle; switch( eErrorKind ) { case CHERROR_NONE: eStyle = chart2::ErrorBarStyle_NONE; break; case CHERROR_VARIANT: eStyle = chart2::ErrorBarStyle_VARIANCE; break; case CHERROR_SIGMA: eStyle = chart2::ErrorBarStyle_STANDARD_DEVIATION; break; case CHERROR_PERCENT: eStyle = chart2::ErrorBarStyle_RELATIVE; break; case CHERROR_BIGERROR: eStyle = chart2::ErrorBarStyle_ERROR_MARGIN; break; case CHERROR_CONST: eStyle = chart2::ErrorBarStyle_ABSOLUTE; break; } if( !xOldErrorBarProp.is() ) { xOldErrorBarProp = lcl_GetDefaultErrorBar(); } xOldErrorBarProp->setPropertyValue( C2U( "ErrorBarStyle" ), uno::makeAny( eStyle )); GetPropertySet()->setPropertyValue( C2U( "ErrorBarY" ), uno::makeAny( xOldErrorBarProp )); bChanged = true; } } break; case SCHATTR_STAT_PERCENT: case SCHATTR_STAT_BIGERROR: { uno::Reference< beans::XPropertySet > xOldErrorBarProp( lcl_GetYErrorBar( GetPropertySet())); bool bOldHasErrorBar = xOldErrorBarProp.is(); double fValue = static_cast< const SvxDoubleItem & >( rItemSet.Get( nWhichId )).GetValue(); double fPos, fNeg; lcl_getErrorValues( xOldErrorBarProp, fPos, fNeg ); if( bOldHasErrorBar && ! ( ::rtl::math::approxEqual( fPos, fValue ) && ::rtl::math::approxEqual( fNeg, fValue ))) { xOldErrorBarProp->setPropertyValue( C2U( "PositiveError" ), uno::makeAny( fValue )); xOldErrorBarProp->setPropertyValue( C2U( "NegativeError" ), uno::makeAny( fValue )); GetPropertySet()->setPropertyValue( C2U( "ErrorBarY" ), uno::makeAny( xOldErrorBarProp )); bChanged = true; } } break; case SCHATTR_STAT_CONSTPLUS: { uno::Reference< beans::XPropertySet > xOldErrorBarProp( lcl_GetYErrorBar( GetPropertySet())); bool bOldHasErrorBar = xOldErrorBarProp.is(); double fValue = static_cast< const SvxDoubleItem & >( rItemSet.Get( nWhichId )).GetValue(); double fPos, fNeg; lcl_getErrorValues( xOldErrorBarProp, fPos, fNeg ); if( bOldHasErrorBar && ! ::rtl::math::approxEqual( fPos, fValue )) { xOldErrorBarProp->setPropertyValue( C2U( "PositiveError" ), uno::makeAny( fValue )); GetPropertySet()->setPropertyValue( C2U( "ErrorBarY" ), uno::makeAny( xOldErrorBarProp )); bChanged = true; } } break; case SCHATTR_STAT_CONSTMINUS: { uno::Reference< beans::XPropertySet > xOldErrorBarProp( lcl_GetYErrorBar( GetPropertySet())); bool bOldHasErrorBar = xOldErrorBarProp.is(); double fValue = static_cast< const SvxDoubleItem & >( rItemSet.Get( nWhichId )).GetValue(); double fPos, fNeg; lcl_getErrorValues( xOldErrorBarProp, fPos, fNeg ); if( bOldHasErrorBar && ! ::rtl::math::approxEqual( fNeg, fValue )) { xOldErrorBarProp->setPropertyValue( C2U( "NegativeError" ), uno::makeAny( fValue )); GetPropertySet()->setPropertyValue( C2U( "ErrorBarY" ), uno::makeAny( xOldErrorBarProp )); bChanged = true; } } break; case SCHATTR_STAT_REGRESSTYPE: { SvxChartRegress eRegress = static_cast< const SvxChartRegressItem & >( rItemSet.Get( nWhichId )).GetValue(); uno::Reference< chart2::XRegressionCurveContainer > xRegCnt( GetPropertySet(), uno::UNO_QUERY ); if( eRegress == CHREGRESS_NONE ) { bChanged = RegressionCurveHelper::removeAllExceptMeanValueLine( xRegCnt ); } else { SvxChartRegress eOldRegress( static_cast< SvxChartRegress >( static_cast< sal_Int32 >( RegressionCurveHelper::getFirstRegressTypeNotMeanValueLine( xRegCnt )))); if( eOldRegress != eRegress ) { RegressionCurveHelper::replaceOrAddCurveAndReduceToOne( lcl_convertRegressionType( eRegress ), xRegCnt, uno::Reference< uno::XComponentContext >()); bChanged = true; } } } break; case SCHATTR_REGRESSION_SHOW_EQUATION: { uno::Reference< beans::XPropertySet > xEqProp( lcl_getEquationProperties( GetPropertySet(), &rItemSet )); if( xEqProp.is()) { bool bShowEq = false; xEqProp->getPropertyValue( C2U("ShowEquation")) >>= bShowEq; bool bNewShowEq = static_cast< const SfxBoolItem & >( rItemSet.Get( nWhichId )).GetValue(); if( bShowEq != bNewShowEq ) { xEqProp->setPropertyValue( C2U("ShowEquation"), uno::makeAny( bNewShowEq )); bChanged = true; } } } break; case SCHATTR_REGRESSION_SHOW_COEFF: { uno::Reference< beans::XPropertySet > xEqProp( lcl_getEquationProperties( GetPropertySet(), &rItemSet )); if( xEqProp.is()) { bool bShowCoeff = false; xEqProp->getPropertyValue( C2U("ShowCorrelationCoefficient")) >>= bShowCoeff; bool bNewShowCoeff = static_cast< const SfxBoolItem & >( rItemSet.Get( nWhichId )).GetValue(); if( bShowCoeff != bNewShowCoeff ) { xEqProp->setPropertyValue( C2U("ShowCorrelationCoefficient"), uno::makeAny( bNewShowCoeff )); bChanged = true; } } } break; case SCHATTR_STAT_INDICATE: { uno::Reference< beans::XPropertySet > xOldErrorBarProp( lcl_GetYErrorBar( GetPropertySet())); bool bOldHasErrorBar = xOldErrorBarProp.is(); SvxChartIndicate eIndicate = static_cast< const SvxChartIndicateItem & >( rItemSet.Get( nWhichId )).GetValue(); bool bNewIndPos = (eIndicate == CHINDICATE_BOTH || eIndicate == CHINDICATE_UP ); bool bNewIndNeg = (eIndicate == CHINDICATE_BOTH || eIndicate == CHINDICATE_DOWN ); bool bShowPos, bShowNeg; lcl_getErrorIndicatorValues( xOldErrorBarProp, bShowPos, bShowNeg ); if( bOldHasErrorBar && ( bShowPos != bNewIndPos || bShowNeg != bNewIndNeg )) { xOldErrorBarProp->setPropertyValue( C2U( "ShowPositiveError" ), uno::makeAny( bNewIndPos )); xOldErrorBarProp->setPropertyValue( C2U( "ShowNegativeError" ), uno::makeAny( bNewIndNeg )); GetPropertySet()->setPropertyValue( C2U( "ErrorBarY" ), uno::makeAny( xOldErrorBarProp )); bChanged = true; } } break; } return bChanged; } void StatisticsItemConverter::FillSpecialItem( USHORT nWhichId, SfxItemSet & rOutItemSet ) const throw( uno::Exception ) { switch( nWhichId ) { case SCHATTR_STAT_AVERAGE: rOutItemSet.Put( SfxBoolItem( nWhichId, RegressionCurveHelper::hasMeanValueLine( uno::Reference< chart2::XRegressionCurveContainer >( GetPropertySet(), uno::UNO_QUERY )))); break; case SCHATTR_STAT_KIND_ERROR: { SvxChartKindError eErrorKind = CHERROR_NONE; uno::Reference< beans::XPropertySet > xErrorBarProp( lcl_GetYErrorBar( GetPropertySet())); if( xErrorBarProp.is() ) { chart2::ErrorBarStyle eStyle; if( xErrorBarProp->getPropertyValue( C2U( "ErrorBarStyle" )) >>= eStyle ) { switch( eStyle ) { case chart2::ErrorBarStyle_NONE: break; case chart2::ErrorBarStyle_VARIANCE: eErrorKind = CHERROR_VARIANT; break; case chart2::ErrorBarStyle_STANDARD_DEVIATION: eErrorKind = CHERROR_SIGMA; break; case chart2::ErrorBarStyle_ABSOLUTE: eErrorKind = CHERROR_CONST; break; case chart2::ErrorBarStyle_RELATIVE: eErrorKind = CHERROR_PERCENT; break; case chart2::ErrorBarStyle_ERROR_MARGIN: eErrorKind = CHERROR_BIGERROR; break; case chart2::ErrorBarStyle_STANDARD_ERROR: // not yet available in UI break; case chart2::ErrorBarStyle_FROM_DATA: // suppress warning case chart2::ErrorBarStyle_MAKE_FIXED_SIZE: break; } } } rOutItemSet.Put( SvxChartKindErrorItem( eErrorKind, SCHATTR_STAT_KIND_ERROR )); } break; case SCHATTR_STAT_PERCENT: { uno::Reference< beans::XPropertySet > xErrorBarProp( lcl_GetYErrorBar( GetPropertySet())); if( xErrorBarProp.is()) { double fPos, fNeg; lcl_getErrorValues( xErrorBarProp, fPos, fNeg ); rOutItemSet.Put( SvxDoubleItem( ( fPos + fNeg ) / 2.0, nWhichId )); } } break; case SCHATTR_STAT_BIGERROR: { uno::Reference< beans::XPropertySet > xErrorBarProp( lcl_GetYErrorBar( GetPropertySet())); if( xErrorBarProp.is()) { double fPos, fNeg; lcl_getErrorValues( xErrorBarProp, fPos, fNeg ); rOutItemSet.Put( SvxDoubleItem( ( fPos + fNeg ) / 2.0, nWhichId )); } } break; case SCHATTR_STAT_CONSTPLUS: { uno::Reference< beans::XPropertySet > xErrorBarProp( lcl_GetYErrorBar( GetPropertySet())); if( xErrorBarProp.is()) { double fPos, fNeg; lcl_getErrorValues( xErrorBarProp, fPos, fNeg ); rOutItemSet.Put( SvxDoubleItem( fPos, nWhichId )); } } break; case SCHATTR_STAT_CONSTMINUS: { uno::Reference< beans::XPropertySet > xErrorBarProp( lcl_GetYErrorBar( GetPropertySet())); if( xErrorBarProp.is()) { double fPos, fNeg; lcl_getErrorValues( xErrorBarProp, fPos, fNeg ); rOutItemSet.Put( SvxDoubleItem( fNeg, nWhichId )); } } break; case SCHATTR_STAT_REGRESSTYPE: { SvxChartRegress eRegress = static_cast< SvxChartRegress >( static_cast< sal_Int32 >( RegressionCurveHelper::getFirstRegressTypeNotMeanValueLine( uno::Reference< chart2::XRegressionCurveContainer >( GetPropertySet(), uno::UNO_QUERY ) ))); rOutItemSet.Put( SvxChartRegressItem( eRegress, SCHATTR_STAT_REGRESSTYPE )); } break; case SCHATTR_REGRESSION_SHOW_EQUATION: { uno::Reference< beans::XPropertySet > xEqProp( lcl_getEquationProperties( GetPropertySet(), 0 )); if( xEqProp.is()) { bool bShowEq = false; if( xEqProp->getPropertyValue( C2U("ShowEquation")) >>= bShowEq ) rOutItemSet.Put( SfxBoolItem( nWhichId, bShowEq )); } else rOutItemSet.InvalidateItem( nWhichId ); } break; case SCHATTR_REGRESSION_SHOW_COEFF: { uno::Reference< beans::XPropertySet > xEqProp( lcl_getEquationProperties( GetPropertySet(), 0 )); if( xEqProp.is()) { bool bShowCoeff = false; if( xEqProp->getPropertyValue( C2U("ShowCorrelationCoefficient")) >>= bShowCoeff ) rOutItemSet.Put( SfxBoolItem( nWhichId, bShowCoeff )); } else rOutItemSet.InvalidateItem( nWhichId ); } break; case SCHATTR_STAT_INDICATE: { uno::Reference< beans::XPropertySet > xErrorBarProp( lcl_GetYErrorBar( GetPropertySet())); SvxChartIndicate eIndicate = CHINDICATE_BOTH; if( xErrorBarProp.is()) { bool bShowPos, bShowNeg; lcl_getErrorIndicatorValues( xErrorBarProp, bShowPos, bShowNeg ); if( bShowPos ) { if( bShowNeg ) eIndicate = CHINDICATE_BOTH; else eIndicate = CHINDICATE_UP; } else { if( bShowNeg ) eIndicate = CHINDICATE_DOWN; else eIndicate = CHINDICATE_NONE; } } rOutItemSet.Put( SvxChartIndicateItem( eIndicate, SCHATTR_STAT_INDICATE )); } break; } } } // namespace wrapper } // namespace chart