/*************************************************************************
*
* 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
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************/
// MARKER(update_precomp.py): autogen include statement, do not remove
#include "precompiled_sc.hxx"
#include <com/sun/star/table/CellAddress.hpp>
#include <com/sun/star/table/CellRangeAddress.hpp>
#include <svl/itemprop.hxx>
#include "docsh.hxx"
#include "unonames.hxx"
#include "unoguard.hxx"
#include "miscuno.hxx"
#include "convuno.hxx"
#include "addruno.hxx"
using namespace com::sun::star;
//------------------------------------------------------------------------
ScAddressConversionObj::ScAddressConversionObj(ScDocShell* pDocSh, sal_Bool bForRange) :
pDocShell( pDocSh ),
nRefSheet( 0 ),
bIsRange( bForRange )
{
pDocShell->GetDocument()->AddUnoObject(*this);
}
ScAddressConversionObj::~ScAddressConversionObj()
{
if (pDocShell)
pDocShell->GetDocument()->RemoveUnoObject(*this);
}
void ScAddressConversionObj::Notify( SfxBroadcaster&, const SfxHint& rHint )
{
if ( rHint.ISA( SfxSimpleHint ) &&
((const SfxSimpleHint&)rHint).GetId() == SFX_HINT_DYING )
{
pDocShell = NULL; // invalid
}
}
sal_Bool ScAddressConversionObj::ParseUIString( const String& rUIString )
{
if (!pDocShell)
return sal_False;
ScDocument* pDoc = pDocShell->GetDocument();
sal_Bool bSuccess = sal_False;
if ( bIsRange )
{
USHORT nResult = aRange.ParseAny( rUIString, pDoc );
if ( nResult & SCA_VALID )
{
if ( ( nResult & SCA_TAB_3D ) == 0 )
aRange.aStart.SetTab( static_cast<SCTAB>(nRefSheet) );
if ( ( nResult & SCA_TAB2_3D ) == 0 )
aRange.aEnd.SetTab( aRange.aStart.Tab() );
// different sheets are not supported in CellRangeAddress
if ( aRange.aStart.Tab() == aRange.aEnd.Tab() )
bSuccess = sal_True;
}
}
else
{
USHORT nResult = aRange.aStart.Parse( rUIString, pDoc );
if ( nResult & SCA_VALID )
{
if ( ( nResult & SCA_TAB_3D ) == 0 )
aRange.aStart.SetTab( static_cast<SCTAB>(nRefSheet) );
bSuccess = sal_True;
}
}
return bSuccess;
}
// XPropertySet
uno::Reference<beans::XPropertySetInfo> SAL_CALL ScAddressConversionObj::getPropertySetInfo()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
if ( bIsRange )
{
static SfxItemPropertyMapEntry aPropertyMap[] =
{
{MAP_CHAR_LEN(SC_UNONAME_ADDRESS), 0, &getCppuType((table::CellRangeAddress*)0), 0, 0 },
{MAP_CHAR_LEN(SC_UNONAME_PERSREPR), 0, &getCppuType((rtl::OUString*)0), 0, 0 },
{MAP_CHAR_LEN(SC_UNONAME_REFSHEET), 0, &getCppuType((sal_Int32*)0), 0, 0 },
{MAP_CHAR_LEN(SC_UNONAME_UIREPR), 0, &getCppuType((rtl::OUString*)0), 0, 0 },
{0,0,0,0,0,0}
};
static uno::Reference<beans::XPropertySetInfo> aRef(new SfxItemPropertySetInfo( aPropertyMap ));
return aRef;
}
else
{
static SfxItemPropertyMapEntry aPropertyMap[] =
{
{MAP_CHAR_LEN(SC_UNONAME_ADDRESS), 0, &getCppuType((table::CellAddress*)0), 0, 0 },
{MAP_CHAR_LEN(SC_UNONAME_PERSREPR), 0, &getCppuType((rtl::OUString*)0), 0, 0 },
{MAP_CHAR_LEN(SC_UNONAME_REFSHEET), 0, &getCppuType((sal_Int32*)0), 0, 0 },
{MAP_CHAR_LEN(SC_UNONAME_UIREPR), 0, &getCppuType((rtl::OUString*)0), 0, 0 },
{0,0,0,0,0,0}
};
static uno::Reference<beans::XPropertySetInfo> aRef(new SfxItemPropertySetInfo( aPropertyMap ));
return aRef;
}
}
void SAL_CALL ScAddressConversionObj::setPropertyValue( const rtl::OUString& aPropertyName, const uno::Any& aValue )
throw(beans::UnknownPropertyException, beans::PropertyVetoException,
lang::IllegalArgumentException, lang::WrappedTargetException,
uno::RuntimeException)
{
if ( !pDocShell )
throw uno::RuntimeException();
sal_Bool bSuccess = sal_False;
String aNameStr(aPropertyName);
if ( aNameStr.EqualsAscii( SC_UNONAME_ADDRESS ) )
{
// read the cell/range address from API struct
if ( bIsRange )
{
table::CellRangeAddress aRangeAddress;
if ( aValue >>= aRangeAddress )
{
ScUnoConversion::FillScRange( aRange, aRangeAddress );
bSuccess = sal_True;
}
}
else
{
table::CellAddress aCellAddress;
if ( aValue >>= aCellAddress )
{
ScUnoConversion::FillScAddress( aRange.aStart, aCellAddress );
bSuccess = sal_True;
}
}
}
else if ( aNameStr.EqualsAscii( SC_UNONAME_REFSHEET ) )
{
// set the reference sheet
sal_Int32 nIntVal = 0;
if ( aValue >>= nIntVal )
{
nRefSheet = nIntVal;
bSuccess = sal_True;
}
}
else if ( aNameStr.EqualsAscii( SC_UNONAME_UIREPR ) )
{
// parse the UI representation string
rtl::OUString sRepresentation;
if (aValue >>= sRepresentation)
{
String aUIString = sRepresentation;
bSuccess = ParseUIString( aUIString );
}
}
else if ( aNameStr.EqualsAscii( SC_UNONAME_PERSREPR ) )
{
// parse the file format string
rtl::OUString sRepresentation;
if (aValue >>= sRepresentation)
{
String aUIString(sRepresentation);
// cell or range: strip a single "." at the start
if ( aUIString.GetChar(0) == (sal_Unicode) '.' )
aUIString.Erase( 0, 1 );
if ( bIsRange )
{
// range: also strip a "." after the last colon
sal_Int32 nColon = rtl::OUString(aUIString).lastIndexOf( (sal_Unicode) ':' );
if ( nColon >= 0 && nColon < aUIString.Len() - 1 &&
aUIString.GetChar((xub_StrLen)nColon+1) == (sal_Unicode) '.' )
aUIString.Erase( (xub_StrLen)nColon+1, 1 );
}
// parse the rest like a UI string
bSuccess = ParseUIString( aUIString );
}
}
else
throw beans::UnknownPropertyException();
if ( !bSuccess )
throw lang::IllegalArgumentException();
}
uno::Any SAL_CALL ScAddressConversionObj::getPropertyValue( const rtl::OUString& aPropertyName )
throw(beans::UnknownPropertyException, lang::WrappedTargetException,
uno::RuntimeException)
{
if ( !pDocShell )
throw uno::RuntimeException();
ScDocument* pDoc = pDocShell->GetDocument();
uno::Any aRet;
String aNameStr(aPropertyName);
if ( aNameStr.EqualsAscii( SC_UNONAME_ADDRESS ) )
{
if ( bIsRange )
{
table::CellRangeAddress aRangeAddress;
ScUnoConversion::FillApiRange( aRangeAddress, aRange );
aRet <<= aRangeAddress;
}
else
{
table::CellAddress aCellAddress;
ScUnoConversion::FillApiAddress( aCellAddress, aRange.aStart );
aRet <<= aCellAddress;
}
}
else if ( aNameStr.EqualsAscii( SC_UNONAME_REFSHEET ) )
{
aRet <<= nRefSheet;
}
else if ( aNameStr.EqualsAscii( SC_UNONAME_UIREPR ) )
{
// generate UI representation string - include sheet only if different from ref sheet
String aFormatStr;
USHORT nFlags = SCA_VALID;
if ( aRange.aStart.Tab() != nRefSheet )
nFlags |= SCA_TAB_3D;
if ( bIsRange )
aRange.Format( aFormatStr, nFlags, pDoc );
else
aRange.aStart.Format( aFormatStr, nFlags, pDoc );
aRet <<= rtl::OUString( aFormatStr );
}
else if ( aNameStr.EqualsAscii( SC_UNONAME_PERSREPR ) )
{
// generate file format string - always include sheet
String aFormatStr;
aRange.aStart.Format( aFormatStr, SCA_VALID | SCA_TAB_3D, pDoc );
if ( bIsRange )
{
// manually concatenate range so both parts always have the sheet name
aFormatStr.Append( (sal_Unicode) ':' );
String aSecond;
aRange.aEnd.Format( aSecond, SCA_VALID | SCA_TAB_3D, pDoc );
aFormatStr.Append( aSecond );
}
aRet <<= rtl::OUString( aFormatStr );
}
else
throw beans::UnknownPropertyException();
return aRet;
}
SC_IMPL_DUMMY_PROPERTY_LISTENER( ScAddressConversionObj )
// lang::XServiceInfo
rtl::OUString SAL_CALL ScAddressConversionObj::getImplementationName() throw(uno::RuntimeException)
{
return rtl::OUString::createFromAscii( "ScAddressConversionObj" );
}
sal_Bool SAL_CALL ScAddressConversionObj::supportsService( const rtl::OUString& rServiceName )
throw(uno::RuntimeException)
{
String aServiceStr( rServiceName );
return aServiceStr.EqualsAscii( bIsRange ? SC_SERVICENAME_RANGEADDRESS
: SC_SERVICENAME_CELLADDRESS );
}
uno::Sequence<rtl::OUString> SAL_CALL ScAddressConversionObj::getSupportedServiceNames()
throw(uno::RuntimeException)
{
uno::Sequence<rtl::OUString> aRet(1);
rtl::OUString* pArray = aRet.getArray();
pArray[0] = rtl::OUString::createFromAscii( bIsRange ? SC_SERVICENAME_RANGEADDRESS
: SC_SERVICENAME_CELLADDRESS );
return aRet;
}