/**************************************************************
*
* 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_sc.hxx"
#include <tools/debug.hxx>
#include <svl/smplhint.hxx>
#include <svl/zforlist.hxx>
#include <rtl/uuid.h>
#include <com/sun/star/awt/XBitmap.hpp>
#include <com/sun/star/util/SortField.hpp>
#include <com/sun/star/table/TableSortField.hpp>
#include <com/sun/star/beans/PropertyAttribute.hpp>
#include <com/sun/star/table/TableOrientation.hpp>
#include <com/sun/star/table/CellRangeAddress.hpp>
#include <com/sun/star/sheet/DataImportMode.hpp>
#include <com/sun/star/sheet/FilterOperator2.hpp>
#include <com/sun/star/sheet/TableFilterField2.hpp>
#include "datauno.hxx"
#include "dapiuno.hxx"
#include "cellsuno.hxx"
#include "miscuno.hxx"
#include "targuno.hxx"
#include "rangeutl.hxx"
#include "dbcolect.hxx"
#include "docsh.hxx"
#include "dbdocfun.hxx"
#include "unoguard.hxx"
#include "unonames.hxx"
#include "globstr.hrc"
#ifndef SC_CONVUNO_HXX
#include "convuno.hxx"
#include "hints.hxx"
#endif
#include "attrib.hxx"
#include "dpshttab.hxx"
#include <comphelper/extract.hxx>
#include <svx/dataaccessdescriptor.hxx>
using namespace com::sun::star;
SV_IMPL_PTRARR( XDBRefreshListenerArr_Impl, XDBRefreshListenerPtr );
//------------------------------------------------------------------------
// alles ohne Which-ID, Map nur fuer PropertySetInfo
const SfxItemPropertyMapEntry* lcl_GetSubTotalPropertyMap()
{
// some old property names are for 5.2 compatibility
static SfxItemPropertyMapEntry aSubTotalPropertyMap_Impl[] =
{
{MAP_CHAR_LEN(SC_UNONAME_BINDFMT), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_CASE), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_ENABSORT), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_ENUSLIST), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_FORMATS), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_INSBRK), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_ISCASE), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_MAXFLD), 0, &getCppuType((sal_Int32*)0), beans::PropertyAttribute::READONLY, 0},
{MAP_CHAR_LEN(SC_UNONAME_SORTASC), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_ULIST), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_UINDEX), 0, &getCppuType((sal_Int32*)0), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_USINDEX), 0, &getCppuType((sal_Int32*)0), 0, 0},
{0,0,0,0,0,0}
};
return aSubTotalPropertyMap_Impl;
}
const SfxItemPropertyMapEntry* lcl_GetFilterPropertyMap()
{
static SfxItemPropertyMapEntry aFilterPropertyMap_Impl[] =
{
{MAP_CHAR_LEN(SC_UNONAME_CONTHDR), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_COPYOUT), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_ISCASE), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_MAXFLD), 0, &getCppuType((sal_Int32*)0), beans::PropertyAttribute::READONLY, 0},
{MAP_CHAR_LEN(SC_UNONAME_ORIENT), 0, &getCppuType((table::TableOrientation*)0), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_OUTPOS), 0, &getCppuType((table::CellAddress*)0), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_SAVEOUT), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_SKIPDUP), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_USEREGEX), 0, &getBooleanCppuType(), 0, 0},
{0,0,0,0,0,0}
};
return aFilterPropertyMap_Impl;
}
const SfxItemPropertyMapEntry* lcl_GetDBRangePropertyMap()
{
static SfxItemPropertyMapEntry aDBRangePropertyMap_Impl[] =
{
{MAP_CHAR_LEN(SC_UNONAME_AUTOFLT), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_FLTCRT), 0, &getCppuType((table::CellRangeAddress*)0), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_FROMSELECT),0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_ISUSER), 0, &getBooleanCppuType(), beans::PropertyAttribute::READONLY, 0 },
{MAP_CHAR_LEN(SC_UNONAME_KEEPFORM), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNO_LINKDISPBIT), 0, &getCppuType((uno::Reference<awt::XBitmap>*)0), beans::PropertyAttribute::READONLY, 0 },
{MAP_CHAR_LEN(SC_UNO_LINKDISPNAME), 0, &getCppuType((rtl::OUString*)0), beans::PropertyAttribute::READONLY, 0 },
{MAP_CHAR_LEN(SC_UNONAME_MOVCELLS), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_REFPERIOD), 0, &getCppuType((sal_Int32*)0), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_STRIPDAT), 0, &getBooleanCppuType(), 0, 0},
{MAP_CHAR_LEN(SC_UNONAME_TOKENINDEX),0, &getCppuType((sal_Int32*)0), beans::PropertyAttribute::READONLY, 0 },
{MAP_CHAR_LEN(SC_UNONAME_USEFLTCRT),0, &getBooleanCppuType(), 0, 0},
{0,0,0,0,0,0}
};
return aDBRangePropertyMap_Impl;
}
//------------------------------------------------------------------------
#define SCDATABASERANGEOBJ_SERVICE "com.sun.star.sheet.DatabaseRange"
SC_SIMPLE_SERVICE_INFO( ScConsolidationDescriptor, "ScConsolidationDescriptor", "com.sun.star.sheet.ConsolidationDescriptor" )
SC_SIMPLE_SERVICE_INFO( ScDatabaseRangesObj, "ScDatabaseRangesObj", "com.sun.star.sheet.DatabaseRanges" )
SC_SIMPLE_SERVICE_INFO( ScFilterDescriptorBase, "ScFilterDescriptorBase", "com.sun.star.sheet.SheetFilterDescriptor" )
SC_SIMPLE_SERVICE_INFO( ScSubTotalDescriptorBase, "ScSubTotalDescriptorBase", "com.sun.star.sheet.SubTotalDescriptor" )
SC_SIMPLE_SERVICE_INFO( ScSubTotalFieldObj, "ScSubTotalFieldObj", "com.sun.star.sheet.SubTotalField" )
//------------------------------------------------------------------------
// static
ScSubTotalFunc ScDataUnoConversion::GeneralToSubTotal( sheet::GeneralFunction eSummary )
{
ScSubTotalFunc eSubTotal;
switch (eSummary)
{
case sheet::GeneralFunction_NONE: eSubTotal = SUBTOTAL_FUNC_NONE; break;
case sheet::GeneralFunction_SUM: eSubTotal = SUBTOTAL_FUNC_SUM; break;
case sheet::GeneralFunction_COUNT: eSubTotal = SUBTOTAL_FUNC_CNT2; break;
case sheet::GeneralFunction_AVERAGE: eSubTotal = SUBTOTAL_FUNC_AVE; break;
case sheet::GeneralFunction_MAX: eSubTotal = SUBTOTAL_FUNC_MAX; break;
case sheet::GeneralFunction_MIN: eSubTotal = SUBTOTAL_FUNC_MIN; break;
case sheet::GeneralFunction_PRODUCT: eSubTotal = SUBTOTAL_FUNC_PROD; break;
case sheet::GeneralFunction_COUNTNUMS: eSubTotal = SUBTOTAL_FUNC_CNT; break;
case sheet::GeneralFunction_STDEV: eSubTotal = SUBTOTAL_FUNC_STD; break;
case sheet::GeneralFunction_STDEVP: eSubTotal = SUBTOTAL_FUNC_STDP; break;
case sheet::GeneralFunction_VAR: eSubTotal = SUBTOTAL_FUNC_VAR; break;
case sheet::GeneralFunction_VARP: eSubTotal = SUBTOTAL_FUNC_VARP; break;
case sheet::GeneralFunction_AUTO:
default:
DBG_ERROR("GeneralToSubTotal: falscher enum");
eSubTotal = SUBTOTAL_FUNC_NONE;
}
return eSubTotal;
}
// static
sheet::GeneralFunction ScDataUnoConversion::SubTotalToGeneral( ScSubTotalFunc eSubTotal )
{
sheet::GeneralFunction eGeneral;
switch (eSubTotal)
{
case SUBTOTAL_FUNC_NONE: eGeneral = sheet::GeneralFunction_NONE; break;
case SUBTOTAL_FUNC_AVE: eGeneral = sheet::GeneralFunction_AVERAGE; break;
case SUBTOTAL_FUNC_CNT: eGeneral = sheet::GeneralFunction_COUNTNUMS; break;
case SUBTOTAL_FUNC_CNT2: eGeneral = sheet::GeneralFunction_COUNT; break;
case SUBTOTAL_FUNC_MAX: eGeneral = sheet::GeneralFunction_MAX; break;
case SUBTOTAL_FUNC_MIN: eGeneral = sheet::GeneralFunction_MIN; break;
case SUBTOTAL_FUNC_PROD: eGeneral = sheet::GeneralFunction_PRODUCT; break;
case SUBTOTAL_FUNC_STD: eGeneral = sheet::GeneralFunction_STDEV; break;
case SUBTOTAL_FUNC_STDP: eGeneral = sheet::GeneralFunction_STDEVP; break;
case SUBTOTAL_FUNC_SUM: eGeneral = sheet::GeneralFunction_SUM; break;
case SUBTOTAL_FUNC_VAR: eGeneral = sheet::GeneralFunction_VAR; break;
case SUBTOTAL_FUNC_VARP: eGeneral = sheet::GeneralFunction_VARP; break;
default:
DBG_ERROR("SubTotalToGeneral: falscher enum");
eGeneral = sheet::GeneralFunction_NONE;
break;
}
return eGeneral;
}
//------------------------------------------------------------------------
// ScImportDescriptor: alles static
long ScImportDescriptor::GetPropertyCount()
{
return 4;
}
void ScImportDescriptor::FillProperties( uno::Sequence<beans::PropertyValue>& rSeq, const ScImportParam& rParam )
{
DBG_ASSERT( rSeq.getLength() == GetPropertyCount(), "falscher Count" );
beans::PropertyValue* pArray = rSeq.getArray();
sheet::DataImportMode eMode = sheet::DataImportMode_NONE;
if ( rParam.bImport )
{
if ( rParam.bSql )
eMode = sheet::DataImportMode_SQL;
else if ( rParam.nType == ScDbQuery )
eMode = sheet::DataImportMode_QUERY;
else
eMode = sheet::DataImportMode_TABLE; // Type ist immer ScDbQuery oder ScDbTable
}
::svx::ODataAccessDescriptor aDescriptor;
aDescriptor.setDataSource(rParam.aDBName);
if (aDescriptor.has( svx::daDataSource ))
{
pArray[0].Name = rtl::OUString::createFromAscii( SC_UNONAME_DBNAME );
pArray[0].Value <<= rtl::OUString( rParam.aDBName );
}
else if (aDescriptor.has( svx::daConnectionResource ))
{
pArray[0].Name = rtl::OUString::createFromAscii( SC_UNONAME_CONRES );
pArray[0].Value <<= rtl::OUString( rParam.aDBName );
}
pArray[1].Name = rtl::OUString::createFromAscii( SC_UNONAME_SRCTYPE );
pArray[1].Value <<= eMode;
pArray[2].Name = rtl::OUString::createFromAscii( SC_UNONAME_SRCOBJ );
pArray[2].Value <<= rtl::OUString( rParam.aStatement );
pArray[3].Name = rtl::OUString::createFromAscii( SC_UNONAME_ISNATIVE );
ScUnoHelpFunctions::SetBoolInAny( pArray[3].Value, rParam.bNative );
}
void ScImportDescriptor::FillImportParam( ScImportParam& rParam, const uno::Sequence<beans::PropertyValue>& rSeq )
{
rtl::OUString aStrVal;
const beans::PropertyValue* pPropArray = rSeq.getConstArray();
long nPropCount = rSeq.getLength();
for (long i = 0; i < nPropCount; i++)
{
const beans::PropertyValue& rProp = pPropArray[i];
String aPropName(rProp.Name);
if (aPropName.EqualsAscii( SC_UNONAME_ISNATIVE ))
rParam.bNative = ScUnoHelpFunctions::GetBoolFromAny( rProp.Value );
else if (aPropName.EqualsAscii( SC_UNONAME_DBNAME ))
{
if ( rProp.Value >>= aStrVal )
rParam.aDBName = String( aStrVal );
}
else if (aPropName.EqualsAscii( SC_UNONAME_CONRES ))
{
if ( rProp.Value >>= aStrVal )
rParam.aDBName = String( aStrVal );
}
else if (aPropName.EqualsAscii( SC_UNONAME_SRCOBJ ))
{
if ( rProp.Value >>= aStrVal )
rParam.aStatement = String( aStrVal );
}
else if (aPropName.EqualsAscii( SC_UNONAME_SRCTYPE ))
{
//! test for correct enum type?
sheet::DataImportMode eMode = (sheet::DataImportMode)
ScUnoHelpFunctions::GetEnumFromAny( rProp.Value );
switch (eMode)
{
case sheet::DataImportMode_NONE:
rParam.bImport = sal_False;
break;
case sheet::DataImportMode_SQL:
rParam.bImport = sal_True;
rParam.bSql = sal_True;
break;
case sheet::DataImportMode_TABLE:
rParam.bImport = sal_True;
rParam.bSql = sal_False;
rParam.nType = ScDbTable;
break;
case sheet::DataImportMode_QUERY:
rParam.bImport = sal_True;
rParam.bSql = sal_False;
rParam.nType = ScDbQuery;
break;
default:
DBG_ERROR("falscher Mode");
rParam.bImport = sal_False;
}
}
}
}
//------------------------------------------------------------------------
// ScSortDescriptor: alles static
//! SortAscending muss aus der SheetSortDescriptor service-Beschreibung raus
long ScSortDescriptor::GetPropertyCount()
{
return 9; // TableSortDescriptor and SheetSortDescriptor
}
void ScSortDescriptor::FillProperties( uno::Sequence<beans::PropertyValue>& rSeq, const ScSortParam& rParam )
{
DBG_ASSERT( rSeq.getLength() == GetPropertyCount(), "falscher Count" );
beans::PropertyValue* pArray = rSeq.getArray();
// Uno-Werte zusammensuchen
table::CellAddress aOutPos;
aOutPos.Sheet = rParam.nDestTab;
aOutPos.Column = rParam.nDestCol;
aOutPos.Row = rParam.nDestRow;
sal_uInt16 nSortCount = 0;
while ( nSortCount < MAXSORT && rParam.bDoSort[nSortCount] )
++nSortCount;
uno::Sequence<table::TableSortField> aFields(nSortCount);
if (nSortCount)
{
table::TableSortField* pFieldArray = aFields.getArray();
for (sal_uInt16 i=0; i<nSortCount; i++)
{
pFieldArray[i].Field = rParam.nField[i];
pFieldArray[i].IsAscending = rParam.bAscending[i];
pFieldArray[i].FieldType = table::TableSortFieldType_AUTOMATIC; // immer Automatic
pFieldArray[i].IsCaseSensitive = rParam.bCaseSens;
pFieldArray[i].CollatorLocale = rParam.aCollatorLocale;
pFieldArray[i].CollatorAlgorithm = rtl::OUString( rParam.aCollatorAlgorithm );
}
}
// Sequence fuellen
pArray[0].Name = rtl::OUString::createFromAscii( SC_UNONAME_ISSORTCOLUMNS );
pArray[0].Value = ::cppu::bool2any(!rParam.bByRow);
pArray[1].Name = rtl::OUString::createFromAscii( SC_UNONAME_CONTHDR );
ScUnoHelpFunctions::SetBoolInAny( pArray[1].Value, rParam.bHasHeader );
pArray[2].Name = rtl::OUString::createFromAscii( SC_UNONAME_MAXFLD );
pArray[2].Value <<= (sal_Int32) MAXSORT;
pArray[3].Name = rtl::OUString::createFromAscii( SC_UNONAME_SORTFLD );
pArray[3].Value <<= aFields;
pArray[4].Name = rtl::OUString::createFromAscii( SC_UNONAME_BINDFMT );
ScUnoHelpFunctions::SetBoolInAny( pArray[4].Value, rParam.bIncludePattern );
pArray[5].Name = rtl::OUString::createFromAscii( SC_UNONAME_COPYOUT );
ScUnoHelpFunctions::SetBoolInAny( pArray[5].Value, !rParam.bInplace );
pArray[6].Name = rtl::OUString::createFromAscii( SC_UNONAME_OUTPOS );
pArray[6].Value <<= aOutPos;
pArray[7].Name = rtl::OUString::createFromAscii( SC_UNONAME_ISULIST );
ScUnoHelpFunctions::SetBoolInAny( pArray[7].Value, rParam.bUserDef );
pArray[8].Name = rtl::OUString::createFromAscii( SC_UNONAME_UINDEX );
pArray[8].Value <<= (sal_Int32) rParam.nUserIndex;
}
void ScSortDescriptor::FillSortParam( ScSortParam& rParam, const uno::Sequence<beans::PropertyValue>& rSeq )
{
sal_Bool bOldSortDescriptor(sal_False);
sal_Bool bNewSortDescriptor(sal_False);
const beans::PropertyValue* pPropArray = rSeq.getConstArray();
long nPropCount = rSeq.getLength();
for (long nProp = 0; nProp < nPropCount; nProp++)
{
const beans::PropertyValue& rProp = pPropArray[nProp];
String aPropName(rProp.Name);
if (aPropName.EqualsAscii( SC_UNONAME_ORIENT ))
{
bOldSortDescriptor = sal_True;
//! test for correct enum type?
table::TableOrientation eOrient = (table::TableOrientation)
ScUnoHelpFunctions::GetEnumFromAny( rProp.Value );
rParam.bByRow = ( eOrient != table::TableOrientation_COLUMNS );
}
else if (aPropName.EqualsAscii( SC_UNONAME_ISSORTCOLUMNS ))
{
bNewSortDescriptor = sal_True;
rParam.bByRow = !::cppu::any2bool(rProp.Value);
}
else if (aPropName.EqualsAscii( SC_UNONAME_CONTHDR ))
rParam.bHasHeader = ScUnoHelpFunctions::GetBoolFromAny( rProp.Value );
else if (aPropName.EqualsAscii( SC_UNONAME_MAXFLD ))
{
sal_Int32 nVal;
if ( (rProp.Value >>= nVal) && nVal > MAXSORT )
{
//! specify exceptions
//! throw lang::IllegalArgumentException();
}
}
else if (aPropName.EqualsAscii( SC_UNONAME_SORTFLD ))
{
uno::Sequence<util::SortField> aSeq;
uno::Sequence<table::TableSortField> aNewSeq;
if ( rProp.Value >>= aSeq )
{
bOldSortDescriptor = sal_True;
sal_Int32 nCount = aSeq.getLength();
sal_Int32 i;
if ( nCount > MAXSORT )
{
DBG_ERROR("Zu viele Sortierfelder");
nCount = MAXSORT;
}
const util::SortField* pFieldArray = aSeq.getConstArray();
for (i=0; i<nCount; i++)
{
rParam.nField[i] = (SCCOLROW)pFieldArray[i].Field;
rParam.bAscending[i] = pFieldArray[i].SortAscending;
// FieldType wird ignoriert
rParam.bDoSort[i] = sal_True;
}
for (i=nCount; i<MAXSORT; i++)
rParam.bDoSort[i] = sal_False;
}
else if ( rProp.Value >>= aNewSeq )
{
bNewSortDescriptor = sal_True;
sal_Int32 nCount = aNewSeq.getLength();
sal_Int32 i;
if ( nCount > MAXSORT )
{
DBG_ERROR("Zu viele Sortierfelder");
nCount = MAXSORT;
}
const table::TableSortField* pFieldArray = aNewSeq.getConstArray();
for (i=0; i<nCount; i++)
{
rParam.nField[i] = (SCCOLROW)pFieldArray[i].Field;
rParam.bAscending[i] = pFieldArray[i].IsAscending;
// only one is possible, sometime we should make it possible to have different for every entry
rParam.bCaseSens = pFieldArray[i].IsCaseSensitive;
rParam.aCollatorLocale = pFieldArray[i].CollatorLocale;
rParam.aCollatorAlgorithm = pFieldArray[i].CollatorAlgorithm;
// FieldType wird ignoriert
rParam.bDoSort[i] = sal_True;
}
for (i=nCount; i<MAXSORT; i++)
rParam.bDoSort[i] = sal_False;
}
}
else if (aPropName.EqualsAscii( SC_UNONAME_ISCASE ))
{
bOldSortDescriptor = sal_True;
rParam.bCaseSens = ScUnoHelpFunctions::GetBoolFromAny( rProp.Value );
}
else if (aPropName.EqualsAscii( SC_UNONAME_BINDFMT ))
rParam.bIncludePattern = ScUnoHelpFunctions::GetBoolFromAny( rProp.Value );
else if (aPropName.EqualsAscii( SC_UNONAME_COPYOUT ))
rParam.bInplace = !ScUnoHelpFunctions::GetBoolFromAny( rProp.Value );
else if (aPropName.EqualsAscii( SC_UNONAME_OUTPOS ))
{
table::CellAddress aAddress;
if ( rProp.Value >>= aAddress )
{
rParam.nDestTab = aAddress.Sheet;
rParam.nDestCol = (SCCOL)aAddress.Column;
rParam.nDestRow = (SCROW)aAddress.Row;
}
}
else if (aPropName.EqualsAscii( SC_UNONAME_ISULIST ))
rParam.bUserDef = ScUnoHelpFunctions::GetBoolFromAny( rProp.Value );
else if (aPropName.EqualsAscii( SC_UNONAME_UINDEX ))
{
sal_Int32 nVal = 0;
if ( rProp.Value >>= nVal )
rParam.nUserIndex = (sal_uInt16)nVal;
}
else if (aPropName.EqualsAscii( SC_UNONAME_COLLLOC ))
{
bOldSortDescriptor = sal_True;
rProp.Value >>= rParam.aCollatorLocale;
}
else if (aPropName.EqualsAscii( SC_UNONAME_COLLALG ))
{
bOldSortDescriptor = sal_True;
rtl::OUString sStr;
if ( rProp.Value >>= sStr )
rParam.aCollatorAlgorithm = sStr;
}
}
}
//------------------------------------------------------------------------
ScSubTotalFieldObj::ScSubTotalFieldObj( ScSubTotalDescriptorBase* pDesc, sal_uInt16 nP ) :
xRef( pDesc ), // Objekt festhalten
rParent( *pDesc ),
nPos( nP )
{
DBG_ASSERT(pDesc, "ScSubTotalFieldObj: Parent ist 0");
}
ScSubTotalFieldObj::~ScSubTotalFieldObj()
{
}
// XSubTotalField
sal_Int32 SAL_CALL ScSubTotalFieldObj::getGroupColumn() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScSubTotalParam aParam;
rParent.GetData(aParam);
return aParam.nField[nPos];
}
void SAL_CALL ScSubTotalFieldObj::setGroupColumn( sal_Int32 nGroupColumn ) throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScSubTotalParam aParam;
rParent.GetData(aParam);
aParam.nField[nPos] = (SCCOL)nGroupColumn;
rParent.PutData(aParam);
}
uno::Sequence<sheet::SubTotalColumn> SAL_CALL ScSubTotalFieldObj::getSubTotalColumns()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScSubTotalParam aParam;
rParent.GetData(aParam);
SCCOL nCount = aParam.nSubTotals[nPos];
uno::Sequence<sheet::SubTotalColumn> aSeq(nCount);
sheet::SubTotalColumn* pAry = aSeq.getArray();
for (SCCOL i=0; i<nCount; i++)
{
pAry[i].Column = aParam.pSubTotals[nPos][i];
pAry[i].Function = ScDataUnoConversion::SubTotalToGeneral(
aParam.pFunctions[nPos][i] );
}
return aSeq;
}
void SAL_CALL ScSubTotalFieldObj::setSubTotalColumns(
const uno::Sequence<sheet::SubTotalColumn>& aSubTotalColumns )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScSubTotalParam aParam;
rParent.GetData(aParam);
sal_uInt32 nColCount = aSubTotalColumns.getLength();
if ( nColCount <= sal::static_int_cast<sal_uInt32>(SCCOL_MAX) )
{
SCCOL nCount = static_cast<SCCOL>(nColCount);
aParam.nSubTotals[nPos] = nCount;
if (nCount != 0)
{
aParam.pSubTotals[nPos] = new SCCOL[nCount];
aParam.pFunctions[nPos] = new ScSubTotalFunc[nCount];
const sheet::SubTotalColumn* pAry = aSubTotalColumns.getConstArray();
for (SCCOL i=0; i<nCount; i++)
{
aParam.pSubTotals[nPos][i] = static_cast<SCCOL>(pAry[i].Column);
aParam.pFunctions[nPos][i] =
ScDataUnoConversion::GeneralToSubTotal( pAry[i].Function );
}
}
else
{
aParam.pSubTotals[nPos] = NULL;
aParam.pFunctions[nPos] = NULL;
}
}
//! sonst Exception oder so? (zuviele Spalten)
rParent.PutData(aParam);
}
//------------------------------------------------------------------------
ScSubTotalDescriptorBase::ScSubTotalDescriptorBase() :
aPropSet( lcl_GetSubTotalPropertyMap() )
{
}
ScSubTotalDescriptorBase::~ScSubTotalDescriptorBase()
{
}
// GetData/PutData hier nur wegen NewInstance-Krempel implementiert...
void ScSubTotalDescriptorBase::GetData( ScSubTotalParam& /* rParam */ ) const
{
DBG_ERROR("ScSubTotalDescriptorBase::GetData soll nicht gerufen werden");
}
void ScSubTotalDescriptorBase::PutData( const ScSubTotalParam& /* rParam */ )
{
DBG_ERROR("ScSubTotalDescriptorBase::PutData soll nicht gerufen werden");
}
// XSubTotalDesctiptor
ScSubTotalFieldObj* ScSubTotalDescriptorBase::GetObjectByIndex_Impl(sal_uInt16 nIndex)
{
if ( nIndex < getCount() )
return new ScSubTotalFieldObj( this, nIndex );
return NULL;
}
void SAL_CALL ScSubTotalDescriptorBase::clear() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScSubTotalParam aParam;
GetData(aParam);
for (sal_uInt16 i=0; i<MAXSUBTOTAL; i++)
aParam.bGroupActive[i] = sal_False;
//! Notify oder so fuer die Field-Objekte???
PutData(aParam);
}
void SAL_CALL ScSubTotalDescriptorBase::addNew(
const uno::Sequence<sheet::SubTotalColumn>& aSubTotalColumns,
sal_Int32 nGroupColumn ) throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScSubTotalParam aParam;
GetData(aParam);
sal_uInt16 nPos = 0;
while ( nPos < MAXSUBTOTAL && aParam.bGroupActive[nPos] )
++nPos;
sal_uInt32 nColCount = aSubTotalColumns.getLength();
if ( nPos < MAXSUBTOTAL && nColCount <= sal::static_int_cast<sal_uInt32>(SCCOL_MAX) )
{
aParam.bGroupActive[nPos] = sal_True;
aParam.nField[nPos] = static_cast<SCCOL>(nGroupColumn);
delete aParam.pSubTotals[nPos];
delete aParam.pFunctions[nPos];
SCCOL nCount = static_cast<SCCOL>(nColCount);
aParam.nSubTotals[nPos] = nCount;
if (nCount != 0)
{
aParam.pSubTotals[nPos] = new SCCOL[nCount];
aParam.pFunctions[nPos] = new ScSubTotalFunc[nCount];
const sheet::SubTotalColumn* pAry = aSubTotalColumns.getConstArray();
for (SCCOL i=0; i<nCount; i++)
{
aParam.pSubTotals[nPos][i] = static_cast<SCCOL>(pAry[i].Column);
aParam.pFunctions[nPos][i] =
ScDataUnoConversion::GeneralToSubTotal( pAry[i].Function );
}
}
else
{
aParam.pSubTotals[nPos] = NULL;
aParam.pFunctions[nPos] = NULL;
}
}
else // too many fields / columns
throw uno::RuntimeException(); // no other exceptions specified
PutData(aParam);
}
// Flags/Einstellungen als Properties
// XEnumerationAccess
uno::Reference<container::XEnumeration> SAL_CALL ScSubTotalDescriptorBase::createEnumeration()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return new ScIndexEnumeration(this, rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.sheet.SubTotalFieldsEnumeration")));
}
// XIndexAccess
sal_Int32 SAL_CALL ScSubTotalDescriptorBase::getCount() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScSubTotalParam aParam;
GetData(aParam);
sal_uInt16 nCount = 0;
while ( nCount < MAXSUBTOTAL && aParam.bGroupActive[nCount] )
++nCount;
return nCount;
}
uno::Any SAL_CALL ScSubTotalDescriptorBase::getByIndex( sal_Int32 nIndex )
throw(lang::IndexOutOfBoundsException,
lang::WrappedTargetException, uno::RuntimeException)
{
ScUnoGuard aGuard;
uno::Reference<sheet::XSubTotalField> xField(GetObjectByIndex_Impl((sal_uInt16)nIndex));
if (xField.is())
return uno::makeAny(xField);
else
throw lang::IndexOutOfBoundsException();
// return uno::Any();
}
uno::Type SAL_CALL ScSubTotalDescriptorBase::getElementType() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return getCppuType((uno::Reference<sheet::XSubTotalField>*)0);
}
sal_Bool SAL_CALL ScSubTotalDescriptorBase::hasElements() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return ( getCount() != 0 );
}
// XPropertySet
uno::Reference<beans::XPropertySetInfo> SAL_CALL ScSubTotalDescriptorBase::getPropertySetInfo()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
static uno::Reference<beans::XPropertySetInfo> aRef(
new SfxItemPropertySetInfo( aPropSet.getPropertyMap() ));
return aRef;
}
void SAL_CALL ScSubTotalDescriptorBase::setPropertyValue(
const rtl::OUString& aPropertyName, const uno::Any& aValue )
throw(beans::UnknownPropertyException, beans::PropertyVetoException,
lang::IllegalArgumentException, lang::WrappedTargetException,
uno::RuntimeException)
{
ScUnoGuard aGuard;
ScSubTotalParam aParam;
GetData(aParam);
String aString(aPropertyName);
// some old property names are for 5.2 compatibility
if (aString.EqualsAscii( SC_UNONAME_CASE ) || aString.EqualsAscii( SC_UNONAME_ISCASE ))
aParam.bCaseSens = ScUnoHelpFunctions::GetBoolFromAny( aValue );
else if (aString.EqualsAscii( SC_UNONAME_FORMATS ) || aString.EqualsAscii( SC_UNONAME_BINDFMT ))
aParam.bIncludePattern = ScUnoHelpFunctions::GetBoolFromAny( aValue );
else if (aString.EqualsAscii( SC_UNONAME_ENABSORT ))
aParam.bDoSort = ScUnoHelpFunctions::GetBoolFromAny( aValue );
else if (aString.EqualsAscii( SC_UNONAME_SORTASC ))
aParam.bAscending = ScUnoHelpFunctions::GetBoolFromAny( aValue );
else if (aString.EqualsAscii( SC_UNONAME_INSBRK ))
aParam.bPagebreak = ScUnoHelpFunctions::GetBoolFromAny( aValue );
else if (aString.EqualsAscii( SC_UNONAME_ULIST ) || aString.EqualsAscii( SC_UNONAME_ENUSLIST ))
aParam.bUserDef = ScUnoHelpFunctions::GetBoolFromAny( aValue );
else if (aString.EqualsAscii( SC_UNONAME_UINDEX ) || aString.EqualsAscii( SC_UNONAME_USINDEX ))
{
sal_Int32 nVal = 0;
if ( aValue >>= nVal )
aParam.nUserIndex = (sal_uInt16)nVal;
}
else if (aString.EqualsAscii( SC_UNONAME_MAXFLD ))
{
sal_Int32 nVal = 0;
if ( (aValue >>= nVal) && nVal > sal::static_int_cast<sal_Int32>(MAXSUBTOTAL) )
{
throw lang::IllegalArgumentException();
}
}
PutData(aParam);
}
uno::Any SAL_CALL ScSubTotalDescriptorBase::getPropertyValue( const rtl::OUString& aPropertyName )
throw(beans::UnknownPropertyException, lang::WrappedTargetException,
uno::RuntimeException)
{
ScUnoGuard aGuard;
ScSubTotalParam aParam;
GetData(aParam);
String aString(aPropertyName);
uno::Any aRet;
// some old property names are for 5.2 compatibility
if (aString.EqualsAscii( SC_UNONAME_CASE ) || aString.EqualsAscii( SC_UNONAME_ISCASE ))
ScUnoHelpFunctions::SetBoolInAny( aRet, aParam.bCaseSens );
else if (aString.EqualsAscii( SC_UNONAME_FORMATS ) || aString.EqualsAscii( SC_UNONAME_BINDFMT ))
ScUnoHelpFunctions::SetBoolInAny( aRet, aParam.bIncludePattern );
else if (aString.EqualsAscii( SC_UNONAME_ENABSORT ))
ScUnoHelpFunctions::SetBoolInAny( aRet, aParam.bDoSort );
else if (aString.EqualsAscii( SC_UNONAME_SORTASC ))
ScUnoHelpFunctions::SetBoolInAny( aRet, aParam.bAscending );
else if (aString.EqualsAscii( SC_UNONAME_INSBRK ))
ScUnoHelpFunctions::SetBoolInAny( aRet, aParam.bPagebreak );
else if (aString.EqualsAscii( SC_UNONAME_ULIST ) || aString.EqualsAscii( SC_UNONAME_ENUSLIST ))
ScUnoHelpFunctions::SetBoolInAny( aRet, aParam.bUserDef );
else if (aString.EqualsAscii( SC_UNONAME_UINDEX ) || aString.EqualsAscii( SC_UNONAME_USINDEX ))
aRet <<= (sal_Int32) aParam.nUserIndex;
else if (aString.EqualsAscii( SC_UNONAME_MAXFLD ))
aRet <<= (sal_Int32) MAXSUBTOTAL;
return aRet;
}
SC_IMPL_DUMMY_PROPERTY_LISTENER( ScSubTotalDescriptorBase )
// XUnoTunnel
sal_Int64 SAL_CALL ScSubTotalDescriptorBase::getSomething(
const uno::Sequence<sal_Int8 >& rId ) throw(uno::RuntimeException)
{
if ( rId.getLength() == 16 &&
0 == rtl_compareMemory( getUnoTunnelId().getConstArray(),
rId.getConstArray(), 16 ) )
{
return sal::static_int_cast<sal_Int64>(reinterpret_cast<sal_IntPtr>(this));
}
return 0;
}
// static
const uno::Sequence<sal_Int8>& ScSubTotalDescriptorBase::getUnoTunnelId()
{
static uno::Sequence<sal_Int8> * pSeq = 0;
if( !pSeq )
{
osl::Guard< osl::Mutex > aGuard( osl::Mutex::getGlobalMutex() );
if( !pSeq )
{
static uno::Sequence< sal_Int8 > aSeq( 16 );
rtl_createUuid( (sal_uInt8*)aSeq.getArray(), 0, sal_True );
pSeq = &aSeq;
}
}
return *pSeq;
}
// static
ScSubTotalDescriptorBase* ScSubTotalDescriptorBase::getImplementation(
const uno::Reference<sheet::XSubTotalDescriptor> xObj )
{
ScSubTotalDescriptorBase* pRet = NULL;
uno::Reference<lang::XUnoTunnel> xUT( xObj, uno::UNO_QUERY );
if (xUT.is())
pRet = reinterpret_cast<ScSubTotalDescriptorBase*>(sal::static_int_cast<sal_IntPtr>(xUT->getSomething(getUnoTunnelId())));
return pRet;
}
//------------------------------------------------------------------------
ScSubTotalDescriptor::ScSubTotalDescriptor()
{
}
ScSubTotalDescriptor::~ScSubTotalDescriptor()
{
}
void ScSubTotalDescriptor::GetData( ScSubTotalParam& rParam ) const
{
rParam = aStoredParam; // Abfrage fuer Interface
}
void ScSubTotalDescriptor::PutData( const ScSubTotalParam& rParam )
{
aStoredParam = rParam; // vom Interface gesetzt
}
void ScSubTotalDescriptor::SetParam( const ScSubTotalParam& rNew )
{
aStoredParam = rNew; // von aussen gesetzt
}
//------------------------------------------------------------------------
ScRangeSubTotalDescriptor::ScRangeSubTotalDescriptor(ScDatabaseRangeObj* pPar) :
pParent(pPar)
{
if (pParent)
pParent->acquire();
}
ScRangeSubTotalDescriptor::~ScRangeSubTotalDescriptor()
{
if (pParent)
pParent->release();
}
void ScRangeSubTotalDescriptor::GetData( ScSubTotalParam& rParam ) const
{
if (pParent)
pParent->GetSubTotalParam( rParam );
}
void ScRangeSubTotalDescriptor::PutData( const ScSubTotalParam& rParam )
{
if (pParent)
pParent->SetSubTotalParam( rParam );
}
//------------------------------------------------------------------------
ScConsolidationDescriptor::ScConsolidationDescriptor()
{
}
ScConsolidationDescriptor::~ScConsolidationDescriptor()
{
}
void ScConsolidationDescriptor::SetParam( const ScConsolidateParam& rNew )
{
aParam = rNew;
}
// XConsolidationDescriptor
sheet::GeneralFunction SAL_CALL ScConsolidationDescriptor::getFunction() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return ScDataUnoConversion::SubTotalToGeneral(aParam.eFunction);
}
void SAL_CALL ScConsolidationDescriptor::setFunction( sheet::GeneralFunction nFunction )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
aParam.eFunction = ScDataUnoConversion::GeneralToSubTotal(nFunction);
}
uno::Sequence<table::CellRangeAddress> SAL_CALL ScConsolidationDescriptor::getSources()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
sal_uInt16 nCount = aParam.nDataAreaCount;
if (!aParam.ppDataAreas)
nCount = 0;
table::CellRangeAddress aRange;
uno::Sequence<table::CellRangeAddress> aSeq(nCount);
table::CellRangeAddress* pAry = aSeq.getArray();
for (sal_uInt16 i=0; i<nCount; i++)
{
ScArea* pArea = aParam.ppDataAreas[i];
if (pArea)
{
aRange.Sheet = pArea->nTab;
aRange.StartColumn = pArea->nColStart;
aRange.StartRow = pArea->nRowStart;
aRange.EndColumn = pArea->nColEnd;
aRange.EndRow = pArea->nRowEnd;
}
pAry[i] = aRange;
}
return aSeq;
}
void SAL_CALL ScConsolidationDescriptor::setSources(
const uno::Sequence<table::CellRangeAddress>& aSources )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
sal_uInt16 nCount = (sal_uInt16)aSources.getLength();
if (nCount)
{
const table::CellRangeAddress* pAry = aSources.getConstArray();
ScArea** pNew = new ScArea*[nCount];
sal_uInt16 i;
for (i=0; i<nCount; i++)
pNew[i] = new ScArea( pAry[i].Sheet,
static_cast<SCCOL>(pAry[i].StartColumn), pAry[i].StartRow,
static_cast<SCCOL>(pAry[i].EndColumn), pAry[i].EndRow );
aParam.SetAreas( pNew, nCount ); // kopiert alles
for (i=0; i<nCount; i++)
delete pNew[i];
delete[] pNew;
}
else
aParam.ClearDataAreas();
}
table::CellAddress SAL_CALL ScConsolidationDescriptor::getStartOutputPosition()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
table::CellAddress aPos;
aPos.Column = aParam.nCol;
aPos.Row = aParam.nRow;
aPos.Sheet = aParam.nTab;
return aPos;
}
void SAL_CALL ScConsolidationDescriptor::setStartOutputPosition(
const table::CellAddress& aStartOutputPosition )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
aParam.nCol = (SCCOL)aStartOutputPosition.Column;
aParam.nRow = (SCROW)aStartOutputPosition.Row;
aParam.nTab = aStartOutputPosition.Sheet;
}
sal_Bool SAL_CALL ScConsolidationDescriptor::getUseColumnHeaders() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return aParam.bByCol;
}
void SAL_CALL ScConsolidationDescriptor::setUseColumnHeaders( sal_Bool bUseColumnHeaders )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
aParam.bByCol = bUseColumnHeaders;
}
sal_Bool SAL_CALL ScConsolidationDescriptor::getUseRowHeaders() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return aParam.bByRow;
}
void SAL_CALL ScConsolidationDescriptor::setUseRowHeaders( sal_Bool bUseRowHeaders )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
aParam.bByRow = bUseRowHeaders;
}
sal_Bool SAL_CALL ScConsolidationDescriptor::getInsertLinks() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return aParam.bReferenceData;
}
void SAL_CALL ScConsolidationDescriptor::setInsertLinks( sal_Bool bInsertLinks )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
aParam.bReferenceData = bInsertLinks;
}
//------------------------------------------------------------------------
ScFilterDescriptorBase::ScFilterDescriptorBase(ScDocShell* pDocShell) :
aPropSet( lcl_GetFilterPropertyMap() ),
pDocSh(pDocShell)
{
if (pDocSh)
pDocSh->GetDocument()->AddUnoObject(*this);
}
ScFilterDescriptorBase::~ScFilterDescriptorBase()
{
if (pDocSh)
pDocSh->GetDocument()->RemoveUnoObject(*this);
}
void ScFilterDescriptorBase::Notify( SfxBroadcaster&, const SfxHint& rHint )
{
if ( rHint.ISA( SfxSimpleHint ) )
{
sal_uLong nId = ((const SfxSimpleHint&)rHint).GetId();
if ( nId == SFX_HINT_DYING )
{
pDocSh = NULL; // invalid
}
}
}
// XSheetFilterDescriptor and XSheetFilterDescriptor2
uno::Sequence<sheet::TableFilterField> SAL_CALL ScFilterDescriptorBase::getFilterFields()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScQueryParam aParam;
GetData(aParam);
SCSIZE nEntries = aParam.GetEntryCount(); // allozierte Eintraege im Param
SCSIZE nCount = 0; // aktive
while ( nCount < nEntries &&
aParam.GetEntry(nCount).bDoQuery )
++nCount;
sheet::TableFilterField aField;
uno::Sequence<sheet::TableFilterField> aSeq(static_cast<sal_Int32>(nCount));
sheet::TableFilterField* pAry = aSeq.getArray();
for (SCSIZE i=0; i<nCount; i++)
{
const ScQueryEntry& rEntry = aParam.GetEntry(i);
rtl::OUString aStringValue;
if (rEntry.pStr)
aStringValue = *rEntry.pStr;
aField.Connection = (rEntry.eConnect == SC_AND) ? sheet::FilterConnection_AND :
sheet::FilterConnection_OR;
aField.Field = rEntry.nField;
aField.IsNumeric = !rEntry.bQueryByString;
aField.StringValue = aStringValue;
aField.NumericValue = rEntry.nVal;
switch (rEntry.eOp) // ScQueryOp
{
case SC_EQUAL:
{
aField.Operator = sheet::FilterOperator_EQUAL;
if (!rEntry.bQueryByString && *rEntry.pStr == EMPTY_STRING)
{
if (rEntry.nVal == SC_EMPTYFIELDS)
{
aField.Operator = sheet::FilterOperator_EMPTY;
aField.NumericValue = 0;
}
else if (rEntry.nVal == SC_NONEMPTYFIELDS)
{
aField.Operator = sheet::FilterOperator_NOT_EMPTY;
aField.NumericValue = 0;
}
}
}
break;
case SC_LESS: aField.Operator = sheet::FilterOperator_LESS; break;
case SC_GREATER: aField.Operator = sheet::FilterOperator_GREATER; break;
case SC_LESS_EQUAL: aField.Operator = sheet::FilterOperator_LESS_EQUAL; break;
case SC_GREATER_EQUAL: aField.Operator = sheet::FilterOperator_GREATER_EQUAL; break;
case SC_NOT_EQUAL: aField.Operator = sheet::FilterOperator_NOT_EQUAL; break;
case SC_TOPVAL: aField.Operator = sheet::FilterOperator_TOP_VALUES; break;
case SC_BOTVAL: aField.Operator = sheet::FilterOperator_BOTTOM_VALUES; break;
case SC_TOPPERC: aField.Operator = sheet::FilterOperator_TOP_PERCENT; break;
case SC_BOTPERC: aField.Operator = sheet::FilterOperator_BOTTOM_PERCENT; break;
default:
DBG_ERROR("Falscher Filter-enum");
aField.Operator = sheet::FilterOperator_EMPTY;
}
pAry[i] = aField;
}
return aSeq;
}
uno::Sequence<sheet::TableFilterField2> SAL_CALL ScFilterDescriptorBase::getFilterFields2()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScQueryParam aParam;
GetData(aParam);
SCSIZE nEntries = aParam.GetEntryCount(); // allozierte Eintraege im Param
SCSIZE nCount = 0; // aktive
while ( nCount < nEntries &&
aParam.GetEntry(nCount).bDoQuery )
++nCount;
sheet::TableFilterField2 aField;
uno::Sequence<sheet::TableFilterField2> aSeq(static_cast<sal_Int32>(nCount));
sheet::TableFilterField2* pAry = aSeq.getArray();
for (SCSIZE i=0; i<nCount; i++)
{
const ScQueryEntry& rEntry = aParam.GetEntry(i);
rtl::OUString aStringValue;
if (rEntry.pStr)
aStringValue = *rEntry.pStr;
aField.Connection = (rEntry.eConnect == SC_AND) ? sheet::FilterConnection_AND : sheet::FilterConnection_OR;
aField.Field = rEntry.nField;
aField.IsNumeric = !rEntry.bQueryByString;
aField.StringValue = aStringValue;
aField.NumericValue = rEntry.nVal;
switch (rEntry.eOp) // ScQueryOp
{
case SC_EQUAL:
{
aField.Operator = sheet::FilterOperator2::EQUAL;
if (!rEntry.bQueryByString && *rEntry.pStr == EMPTY_STRING)
{
if (rEntry.nVal == SC_EMPTYFIELDS)
{
aField.Operator = sheet::FilterOperator2::EMPTY;
aField.NumericValue = 0;
}
else if (rEntry.nVal == SC_NONEMPTYFIELDS)
{
aField.Operator = sheet::FilterOperator2::NOT_EMPTY;
aField.NumericValue = 0;
}
}
}
break;
case SC_LESS: aField.Operator = sheet::FilterOperator2::LESS; break;
case SC_GREATER: aField.Operator = sheet::FilterOperator2::GREATER; break;
case SC_LESS_EQUAL: aField.Operator = sheet::FilterOperator2::LESS_EQUAL; break;
case SC_GREATER_EQUAL: aField.Operator = sheet::FilterOperator2::GREATER_EQUAL; break;
case SC_NOT_EQUAL: aField.Operator = sheet::FilterOperator2::NOT_EQUAL; break;
case SC_TOPVAL: aField.Operator = sheet::FilterOperator2::TOP_VALUES; break;
case SC_BOTVAL: aField.Operator = sheet::FilterOperator2::BOTTOM_VALUES; break;
case SC_TOPPERC: aField.Operator = sheet::FilterOperator2::TOP_PERCENT; break;
case SC_BOTPERC: aField.Operator = sheet::FilterOperator2::BOTTOM_PERCENT; break;
case SC_CONTAINS: aField.Operator = sheet::FilterOperator2::CONTAINS; break;
case SC_DOES_NOT_CONTAIN: aField.Operator = sheet::FilterOperator2::DOES_NOT_CONTAIN; break;
case SC_BEGINS_WITH: aField.Operator = sheet::FilterOperator2::BEGINS_WITH; break;
case SC_DOES_NOT_BEGIN_WITH: aField.Operator = sheet::FilterOperator2::DOES_NOT_BEGIN_WITH; break;
case SC_ENDS_WITH: aField.Operator = sheet::FilterOperator2::ENDS_WITH; break;
case SC_DOES_NOT_END_WITH: aField.Operator = sheet::FilterOperator2::DOES_NOT_END_WITH; break;
default:
DBG_ERROR("Falscher Filter-enum");
aField.Operator = sheet::FilterOperator2::EMPTY;
}
pAry[i] = aField;
}
return aSeq;
}
void SAL_CALL ScFilterDescriptorBase::setFilterFields(
const uno::Sequence<sheet::TableFilterField>& aFilterFields )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScQueryParam aParam;
GetData(aParam);
SCSIZE nCount = static_cast<SCSIZE>(aFilterFields.getLength());
DBG_ASSERT( nCount <= MAXQUERY, "setFilterFields: zu viele" );
aParam.Resize( nCount );
const sheet::TableFilterField* pAry = aFilterFields.getConstArray();
SCSIZE i;
for (i=0; i<nCount; i++)
{
ScQueryEntry& rEntry = aParam.GetEntry(i);
if (!rEntry.pStr)
rEntry.pStr = new String; // sollte nicht sein (soll immer initialisiert sein)
rEntry.bDoQuery = sal_True;
rEntry.eConnect = (pAry[i].Connection == sheet::FilterConnection_AND) ? SC_AND : SC_OR;
rEntry.nField = pAry[i].Field;
rEntry.bQueryByString = !pAry[i].IsNumeric;
*rEntry.pStr = String( pAry[i].StringValue );
rEntry.nVal = pAry[i].NumericValue;
if (!rEntry.bQueryByString && pDocSh)
{
pDocSh->GetDocument()->GetFormatTable()->GetInputLineString(rEntry.nVal, 0, *rEntry.pStr);
}
switch (pAry[i].Operator) // FilterOperator
{
case sheet::FilterOperator_EQUAL: rEntry.eOp = SC_EQUAL; break;
case sheet::FilterOperator_LESS: rEntry.eOp = SC_LESS; break;
case sheet::FilterOperator_GREATER: rEntry.eOp = SC_GREATER; break;
case sheet::FilterOperator_LESS_EQUAL: rEntry.eOp = SC_LESS_EQUAL; break;
case sheet::FilterOperator_GREATER_EQUAL: rEntry.eOp = SC_GREATER_EQUAL; break;
case sheet::FilterOperator_NOT_EQUAL: rEntry.eOp = SC_NOT_EQUAL; break;
case sheet::FilterOperator_TOP_VALUES: rEntry.eOp = SC_TOPVAL; break;
case sheet::FilterOperator_BOTTOM_VALUES: rEntry.eOp = SC_BOTVAL; break;
case sheet::FilterOperator_TOP_PERCENT: rEntry.eOp = SC_TOPPERC; break;
case sheet::FilterOperator_BOTTOM_PERCENT: rEntry.eOp = SC_BOTPERC; break;
case sheet::FilterOperator_EMPTY:
{
rEntry.eOp = SC_EQUAL;
rEntry.nVal = SC_EMPTYFIELDS;
rEntry.bQueryByString = sal_False;
*rEntry.pStr = EMPTY_STRING;
}
break;
case sheet::FilterOperator_NOT_EMPTY:
{
rEntry.eOp = SC_EQUAL;
rEntry.nVal = SC_NONEMPTYFIELDS;
rEntry.bQueryByString = sal_False;
*rEntry.pStr = EMPTY_STRING;
}
break;
default:
DBG_ERROR("Falscher Query-enum");
rEntry.eOp = SC_EQUAL;
}
}
SCSIZE nParamCount = aParam.GetEntryCount(); // Param wird nicht unter 8 resized
for (i=nCount; i<nParamCount; i++)
aParam.GetEntry(i).bDoQuery = sal_False; // ueberzaehlige Felder zuruecksetzen
PutData(aParam);
}
void SAL_CALL ScFilterDescriptorBase::setFilterFields2(
const uno::Sequence<sheet::TableFilterField2>& aFilterFields )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScQueryParam aParam;
GetData(aParam);
SCSIZE nCount = static_cast<SCSIZE>(aFilterFields.getLength());
DBG_ASSERT( nCount <= MAXQUERY, "setFilterFields: zu viele" );
aParam.Resize( nCount );
const sheet::TableFilterField2* pAry = aFilterFields.getConstArray();
SCSIZE i;
for (i=0; i<nCount; i++)
{
ScQueryEntry& rEntry = aParam.GetEntry(i);
if (!rEntry.pStr)
rEntry.pStr = new String; // sollte nicht sein (soll immer initialisiert sein)
rEntry.bDoQuery = sal_True;
rEntry.eConnect = (pAry[i].Connection == sheet::FilterConnection_AND) ? SC_AND : SC_OR;
rEntry.nField = pAry[i].Field;
rEntry.bQueryByString = !pAry[i].IsNumeric;
*rEntry.pStr = String( pAry[i].StringValue );
rEntry.nVal = pAry[i].NumericValue;
if (!rEntry.bQueryByString && pDocSh)
{
pDocSh->GetDocument()->GetFormatTable()->GetInputLineString(rEntry.nVal, 0, *rEntry.pStr);
}
switch (pAry[i].Operator) // FilterOperator
{
case sheet::FilterOperator2::EQUAL: rEntry.eOp = SC_EQUAL; break;
case sheet::FilterOperator2::LESS: rEntry.eOp = SC_LESS; break;
case sheet::FilterOperator2::GREATER: rEntry.eOp = SC_GREATER; break;
case sheet::FilterOperator2::LESS_EQUAL: rEntry.eOp = SC_LESS_EQUAL; break;
case sheet::FilterOperator2::GREATER_EQUAL: rEntry.eOp = SC_GREATER_EQUAL; break;
case sheet::FilterOperator2::NOT_EQUAL: rEntry.eOp = SC_NOT_EQUAL; break;
case sheet::FilterOperator2::TOP_VALUES: rEntry.eOp = SC_TOPVAL; break;
case sheet::FilterOperator2::BOTTOM_VALUES: rEntry.eOp = SC_BOTVAL; break;
case sheet::FilterOperator2::TOP_PERCENT: rEntry.eOp = SC_TOPPERC; break;
case sheet::FilterOperator2::BOTTOM_PERCENT: rEntry.eOp = SC_BOTPERC; break;
case sheet::FilterOperator2::CONTAINS: rEntry.eOp = SC_CONTAINS; break;
case sheet::FilterOperator2::DOES_NOT_CONTAIN: rEntry.eOp = SC_DOES_NOT_CONTAIN; break;
case sheet::FilterOperator2::BEGINS_WITH: rEntry.eOp = SC_BEGINS_WITH; break;
case sheet::FilterOperator2::DOES_NOT_BEGIN_WITH: rEntry.eOp = SC_DOES_NOT_BEGIN_WITH;break;
case sheet::FilterOperator2::ENDS_WITH: rEntry.eOp = SC_ENDS_WITH; break;
case sheet::FilterOperator2::DOES_NOT_END_WITH: rEntry.eOp = SC_DOES_NOT_END_WITH; break;
case sheet::FilterOperator2::EMPTY:
{
rEntry.eOp = SC_EQUAL;
rEntry.nVal = SC_EMPTYFIELDS;
rEntry.bQueryByString = sal_False;
*rEntry.pStr = EMPTY_STRING;
}
break;
case sheet::FilterOperator2::NOT_EMPTY:
{
rEntry.eOp = SC_EQUAL;
rEntry.nVal = SC_NONEMPTYFIELDS;
rEntry.bQueryByString = sal_False;
*rEntry.pStr = EMPTY_STRING;
}
break;
default:
DBG_ERROR("Falscher Query-enum");
rEntry.eOp = SC_EQUAL;
}
}
SCSIZE nParamCount = aParam.GetEntryCount(); // Param wird nicht unter 8 resized
for (i=nCount; i<nParamCount; i++)
aParam.GetEntry(i).bDoQuery = sal_False; // ueberzaehlige Felder zuruecksetzen
PutData(aParam);
}
// Rest sind Properties
// XPropertySet
uno::Reference<beans::XPropertySetInfo> SAL_CALL ScFilterDescriptorBase::getPropertySetInfo()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
static uno::Reference<beans::XPropertySetInfo> aRef(
new SfxItemPropertySetInfo( aPropSet.getPropertyMap() ));
return aRef;
}
void SAL_CALL ScFilterDescriptorBase::setPropertyValue(
const rtl::OUString& aPropertyName, const uno::Any& aValue )
throw(beans::UnknownPropertyException, beans::PropertyVetoException,
lang::IllegalArgumentException, lang::WrappedTargetException,
uno::RuntimeException)
{
ScUnoGuard aGuard;
ScQueryParam aParam;
GetData(aParam);
String aString(aPropertyName);
if (aString.EqualsAscii( SC_UNONAME_CONTHDR ))
aParam.bHasHeader = ScUnoHelpFunctions::GetBoolFromAny( aValue );
else if (aString.EqualsAscii( SC_UNONAME_COPYOUT ))
aParam.bInplace = !(ScUnoHelpFunctions::GetBoolFromAny( aValue ));
else if (aString.EqualsAscii( SC_UNONAME_ISCASE ))
aParam.bCaseSens = ScUnoHelpFunctions::GetBoolFromAny( aValue );
else if (aString.EqualsAscii( SC_UNONAME_MAXFLD ))
{
sal_Int32 nVal = 0;
if ( (aValue >>= nVal) && nVal > sal::static_int_cast<sal_Int32>(MAXQUERY) )
{
throw lang::IllegalArgumentException();
}
}
else if (aString.EqualsAscii( SC_UNONAME_ORIENT ))
{
//! test for correct enum type?
table::TableOrientation eOrient = (table::TableOrientation)
ScUnoHelpFunctions::GetEnumFromAny( aValue );
aParam.bByRow = ( eOrient != table::TableOrientation_COLUMNS );
}
else if (aString.EqualsAscii( SC_UNONAME_OUTPOS ))
{
table::CellAddress aAddress;
if ( aValue >>= aAddress )
{
aParam.nDestTab = aAddress.Sheet;
aParam.nDestCol = (SCCOL)aAddress.Column;
aParam.nDestRow = (SCROW)aAddress.Row;
}
}
else if (aString.EqualsAscii( SC_UNONAME_SAVEOUT ))
aParam.bDestPers = ScUnoHelpFunctions::GetBoolFromAny( aValue );
else if (aString.EqualsAscii( SC_UNONAME_SKIPDUP ))
aParam.bDuplicate = !(ScUnoHelpFunctions::GetBoolFromAny( aValue ));
else if (aString.EqualsAscii( SC_UNONAME_USEREGEX ))
aParam.bRegExp = ScUnoHelpFunctions::GetBoolFromAny( aValue );
PutData(aParam);
}
uno::Any SAL_CALL ScFilterDescriptorBase::getPropertyValue( const rtl::OUString& aPropertyName )
throw(beans::UnknownPropertyException, lang::WrappedTargetException,
uno::RuntimeException)
{
ScUnoGuard aGuard;
ScQueryParam aParam;
GetData(aParam);
String aString(aPropertyName);
uno::Any aRet;
if (aString.EqualsAscii( SC_UNONAME_CONTHDR ))
ScUnoHelpFunctions::SetBoolInAny( aRet, aParam.bHasHeader );
else if (aString.EqualsAscii( SC_UNONAME_COPYOUT ))
ScUnoHelpFunctions::SetBoolInAny( aRet, !(aParam.bInplace) );
else if (aString.EqualsAscii( SC_UNONAME_ISCASE ))
ScUnoHelpFunctions::SetBoolInAny( aRet, aParam.bCaseSens );
else if (aString.EqualsAscii( SC_UNONAME_MAXFLD ))
aRet <<= (sal_Int32) MAXQUERY;
else if (aString.EqualsAscii( SC_UNONAME_ORIENT ))
{
table::TableOrientation eOrient = aParam.bByRow ? table::TableOrientation_ROWS :
table::TableOrientation_COLUMNS;
aRet <<= eOrient;
}
else if (aString.EqualsAscii( SC_UNONAME_OUTPOS ))
{
table::CellAddress aOutPos;
aOutPos.Sheet = aParam.nDestTab;
aOutPos.Column = aParam.nDestCol;
aOutPos.Row = aParam.nDestRow;
aRet <<= aOutPos;
}
else if (aString.EqualsAscii( SC_UNONAME_SAVEOUT ))
ScUnoHelpFunctions::SetBoolInAny( aRet, aParam.bDestPers );
else if (aString.EqualsAscii( SC_UNONAME_SKIPDUP ))
ScUnoHelpFunctions::SetBoolInAny( aRet, !(aParam.bDuplicate) );
else if (aString.EqualsAscii( SC_UNONAME_USEREGEX ))
ScUnoHelpFunctions::SetBoolInAny( aRet, aParam.bRegExp );
return aRet;
}
SC_IMPL_DUMMY_PROPERTY_LISTENER( ScFilterDescriptorBase )
//------------------------------------------------------------------------
ScFilterDescriptor::ScFilterDescriptor(ScDocShell* pDocShell)
:
ScFilterDescriptorBase(pDocShell)
{
}
ScFilterDescriptor::~ScFilterDescriptor()
{
}
void ScFilterDescriptor::GetData( ScQueryParam& rParam ) const
{
rParam = aStoredParam; // Abfrage fuer Interface
}
void ScFilterDescriptor::PutData( const ScQueryParam& rParam )
{
aStoredParam = rParam; // vom Interface gesetzt
}
void ScFilterDescriptor::SetParam( const ScQueryParam& rNew )
{
aStoredParam = rNew; // von aussen gesetzt
}
//------------------------------------------------------------------------
ScRangeFilterDescriptor::ScRangeFilterDescriptor(ScDocShell* pDocShell, ScDatabaseRangeObj* pPar) :
ScFilterDescriptorBase(pDocShell),
pParent(pPar)
{
if (pParent)
pParent->acquire();
}
ScRangeFilterDescriptor::~ScRangeFilterDescriptor()
{
if (pParent)
pParent->release();
}
void ScRangeFilterDescriptor::GetData( ScQueryParam& rParam ) const
{
if (pParent)
pParent->GetQueryParam( rParam );
}
void ScRangeFilterDescriptor::PutData( const ScQueryParam& rParam )
{
if (pParent)
pParent->SetQueryParam( rParam );
}
//------------------------------------------------------------------------
ScDataPilotFilterDescriptor::ScDataPilotFilterDescriptor(ScDocShell* pDocShell, ScDataPilotDescriptorBase* pPar) :
ScFilterDescriptorBase(pDocShell),
pParent(pPar)
{
if (pParent)
pParent->acquire();
}
ScDataPilotFilterDescriptor::~ScDataPilotFilterDescriptor()
{
if (pParent)
pParent->release();
}
void ScDataPilotFilterDescriptor::GetData( ScQueryParam& rParam ) const
{
if (pParent)
{
ScDPObject* pDPObj = pParent->GetDPObject();
if (pDPObj && pDPObj->IsSheetData())
rParam = pDPObj->GetSheetDesc()->aQueryParam;
}
}
void ScDataPilotFilterDescriptor::PutData( const ScQueryParam& rParam )
{
if (pParent)
{
ScDPObject* pDPObj = pParent->GetDPObject();
if (pDPObj)
{
ScSheetSourceDesc aSheetDesc;
if (pDPObj->IsSheetData())
aSheetDesc = *pDPObj->GetSheetDesc();
aSheetDesc.aQueryParam = rParam;
pDPObj->SetSheetDesc(aSheetDesc);
pParent->SetDPObject(pDPObj);
}
}
}
//------------------------------------------------------------------------
ScDatabaseRangeObj::ScDatabaseRangeObj(ScDocShell* pDocSh, const String& rNm) :
pDocShell( pDocSh ),
aName( rNm ),
aPropSet( lcl_GetDBRangePropertyMap() )
{
pDocShell->GetDocument()->AddUnoObject(*this);
}
ScDatabaseRangeObj::~ScDatabaseRangeObj()
{
if (pDocShell)
pDocShell->GetDocument()->RemoveUnoObject(*this);
}
void ScDatabaseRangeObj::Notify( SfxBroadcaster&, const SfxHint& rHint )
{
if ( rHint.ISA( SfxSimpleHint ) && ((const SfxSimpleHint&)rHint).GetId() == SFX_HINT_DYING )
pDocShell = NULL; // ungueltig geworden
else if ( rHint.ISA (ScDBRangeRefreshedHint) )
{
ScDBData* pDBData = GetDBData_Impl();
const ScDBRangeRefreshedHint& rRef = (const ScDBRangeRefreshedHint&)rHint;
ScImportParam aParam;
pDBData->GetImportParam(aParam);
if (aParam == rRef.GetImportParam())
Refreshed_Impl();
}
}
// Hilfsfuntionen
ScDBData* ScDatabaseRangeObj::GetDBData_Impl() const
{
ScDBData* pRet = NULL;
if (pDocShell)
{
ScDBCollection* pNames = pDocShell->GetDocument()->GetDBCollection();
if (pNames)
{
sal_uInt16 nPos = 0;
if (pNames->SearchName( aName, nPos ))
pRet = (*pNames)[nPos];
}
}
return pRet;
}
// XNamed
rtl::OUString SAL_CALL ScDatabaseRangeObj::getName() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return aName;
}
void SAL_CALL ScDatabaseRangeObj::setName( const rtl::OUString& aNewName )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
if (pDocShell)
{
ScDBDocFunc aFunc(*pDocShell);
String aNewStr(aNewName);
sal_Bool bOk = aFunc.RenameDBRange( aName, aNewStr, sal_True );
if (bOk)
aName = aNewStr;
}
}
// XDatabaseRange
table::CellRangeAddress SAL_CALL ScDatabaseRangeObj::getDataArea() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
table::CellRangeAddress aAddress;
ScDBData* pData = GetDBData_Impl();
if (pData)
{
ScRange aRange;
pData->GetArea(aRange);
aAddress.Sheet = aRange.aStart.Tab();
aAddress.StartColumn = aRange.aStart.Col();
aAddress.StartRow = aRange.aStart.Row();
aAddress.EndColumn = aRange.aEnd.Col();
aAddress.EndRow = aRange.aEnd.Row();
}
return aAddress;
}
void SAL_CALL ScDatabaseRangeObj::setDataArea( const table::CellRangeAddress& aDataArea )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScDBData* pData = GetDBData_Impl();
if ( pDocShell && pData )
{
ScDBData aNewData( *pData );
//! MoveTo ???
aNewData.SetArea( aDataArea.Sheet, (SCCOL)aDataArea.StartColumn, (SCROW)aDataArea.StartRow,
(SCCOL)aDataArea.EndColumn, (SCROW)aDataArea.EndRow );
ScDBDocFunc aFunc(*pDocShell);
aFunc.ModifyDBData(aNewData, sal_True);
}
}
uno::Sequence<beans::PropertyValue> SAL_CALL ScDatabaseRangeObj::getSortDescriptor()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScSortParam aParam;
const ScDBData* pData = GetDBData_Impl();
if (pData)
{
pData->GetSortParam(aParam);
// im SortDescriptor sind die Fields innerhalb des Bereichs gezaehlt
ScRange aDBRange;
pData->GetArea(aDBRange);
SCCOLROW nFieldStart = aParam.bByRow ? static_cast<SCCOLROW>(aDBRange.aStart.Col()) : static_cast<SCCOLROW>(aDBRange.aStart.Row());
for (sal_uInt16 i=0; i<MAXSORT; i++)
if ( aParam.bDoSort[i] && aParam.nField[i] >= nFieldStart )
aParam.nField[i] -= nFieldStart;
}
uno::Sequence<beans::PropertyValue> aSeq( ScSortDescriptor::GetPropertyCount() );
ScSortDescriptor::FillProperties( aSeq, aParam );
return aSeq;
}
void ScDatabaseRangeObj::GetQueryParam(ScQueryParam& rQueryParam) const
{
const ScDBData* pData = GetDBData_Impl();
if (pData)
{
pData->GetQueryParam(rQueryParam);
// im FilterDescriptor sind die Fields innerhalb des Bereichs gezaehlt
ScRange aDBRange;
pData->GetArea(aDBRange);
SCCOLROW nFieldStart = rQueryParam.bByRow ? static_cast<SCCOLROW>(aDBRange.aStart.Col()) : static_cast<SCCOLROW>(aDBRange.aStart.Row());
SCSIZE nCount = rQueryParam.GetEntryCount();
for (SCSIZE i=0; i<nCount; i++)
{
ScQueryEntry& rEntry = rQueryParam.GetEntry(i);
if (rEntry.bDoQuery && rEntry.nField >= nFieldStart)
rEntry.nField -= nFieldStart;
}
}
}
void ScDatabaseRangeObj::SetQueryParam(const ScQueryParam& rQueryParam)
{
const ScDBData* pData = GetDBData_Impl();
if (pData)
{
// im FilterDescriptor sind die Fields innerhalb des Bereichs gezaehlt
ScQueryParam aParam(rQueryParam);
ScRange aDBRange;
pData->GetArea(aDBRange);
SCCOLROW nFieldStart = aParam.bByRow ? static_cast<SCCOLROW>(aDBRange.aStart.Col()) : static_cast<SCCOLROW>(aDBRange.aStart.Row());
SCSIZE nCount = aParam.GetEntryCount();
for (SCSIZE i=0; i<nCount; i++)
{
ScQueryEntry& rEntry = aParam.GetEntry(i);
if (rEntry.bDoQuery)
rEntry.nField += nFieldStart;
}
ScDBData aNewData( *pData );
aNewData.SetQueryParam(aParam);
aNewData.SetHeader(aParam.bHasHeader); // not in ScDBData::SetQueryParam
ScDBDocFunc aFunc(*pDocShell);
aFunc.ModifyDBData(aNewData, sal_True);
}
}
uno::Reference<sheet::XSheetFilterDescriptor> SAL_CALL ScDatabaseRangeObj::getFilterDescriptor()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return new ScRangeFilterDescriptor(pDocShell, this);
}
void ScDatabaseRangeObj::GetSubTotalParam(ScSubTotalParam& rSubTotalParam) const
{
const ScDBData* pData = GetDBData_Impl();
if (pData)
{
pData->GetSubTotalParam(rSubTotalParam);
// im FilterDescriptor sind die Fields innerhalb des Bereichs gezaehlt
ScRange aDBRange;
pData->GetArea(aDBRange);
SCCOL nFieldStart = aDBRange.aStart.Col();
for (sal_uInt16 i=0; i<MAXSUBTOTAL; i++)
{
if ( rSubTotalParam.bGroupActive[i] )
{
if ( rSubTotalParam.nField[i] >= nFieldStart )
rSubTotalParam.nField[i] = sal::static_int_cast<SCCOL>( rSubTotalParam.nField[i] - nFieldStart );
for (SCCOL j=0; j<rSubTotalParam.nSubTotals[i]; j++)
if ( rSubTotalParam.pSubTotals[i][j] >= nFieldStart )
rSubTotalParam.pSubTotals[i][j] =
sal::static_int_cast<SCCOL>( rSubTotalParam.pSubTotals[i][j] - nFieldStart );
}
}
}
}
void ScDatabaseRangeObj::SetSubTotalParam(const ScSubTotalParam& rSubTotalParam)
{
const ScDBData* pData = GetDBData_Impl();
if (pData)
{
// im FilterDescriptor sind die Fields innerhalb des Bereichs gezaehlt
ScSubTotalParam aParam(rSubTotalParam);
ScRange aDBRange;
pData->GetArea(aDBRange);
SCCOL nFieldStart = aDBRange.aStart.Col();
for (sal_uInt16 i=0; i<MAXSUBTOTAL; i++)
{
if ( aParam.bGroupActive[i] )
{
aParam.nField[i] = sal::static_int_cast<SCCOL>( aParam.nField[i] + nFieldStart );
for (SCCOL j=0; j<aParam.nSubTotals[i]; j++)
aParam.pSubTotals[i][j] = sal::static_int_cast<SCCOL>( aParam.pSubTotals[i][j] + nFieldStart );
}
}
ScDBData aNewData( *pData );
aNewData.SetSubTotalParam(aParam);
ScDBDocFunc aFunc(*pDocShell);
aFunc.ModifyDBData(aNewData, sal_True);
}
}
uno::Reference<sheet::XSubTotalDescriptor> SAL_CALL ScDatabaseRangeObj::getSubTotalDescriptor()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return new ScRangeSubTotalDescriptor(this);
}
uno::Sequence<beans::PropertyValue> SAL_CALL ScDatabaseRangeObj::getImportDescriptor()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScImportParam aParam;
const ScDBData* pData = GetDBData_Impl();
if (pData)
pData->GetImportParam(aParam);
uno::Sequence<beans::PropertyValue> aSeq( ScImportDescriptor::GetPropertyCount() );
ScImportDescriptor::FillProperties( aSeq, aParam );
return aSeq;
}
// XRefreshable
void SAL_CALL ScDatabaseRangeObj::refresh() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScDBData* pData = GetDBData_Impl();
if ( pDocShell && pData )
{
ScDBDocFunc aFunc(*pDocShell);
// Import zu wiederholen?
sal_Bool bContinue = sal_True;
ScImportParam aImportParam;
pData->GetImportParam( aImportParam );
if (aImportParam.bImport && !pData->HasImportSelection())
{
SCTAB nTab;
SCCOL nDummyCol;
SCROW nDummyRow;
pData->GetArea( nTab, nDummyCol,nDummyRow,nDummyCol,nDummyRow );
bContinue = aFunc.DoImport( nTab, aImportParam, NULL, sal_True ); //! Api-Flag as parameter
}
// interne Operationen (sort, query, subtotal) nur, wenn kein Fehler
if (bContinue)
aFunc.RepeatDB( pData->GetName(), sal_True, sal_True );
}
}
void SAL_CALL ScDatabaseRangeObj::addRefreshListener(
const uno::Reference<util::XRefreshListener >& xListener )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
uno::Reference<util::XRefreshListener>* pObj =
new uno::Reference<util::XRefreshListener>( xListener );
aRefreshListeners.Insert( pObj, aRefreshListeners.Count() );
// hold one additional ref to keep this object alive as long as there are listeners
if ( aRefreshListeners.Count() == 1 )
acquire();
}
void SAL_CALL ScDatabaseRangeObj::removeRefreshListener(
const uno::Reference<util::XRefreshListener >& xListener )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
sal_uInt16 nCount = aRefreshListeners.Count();
for ( sal_uInt16 n=nCount; n--; )
{
uno::Reference<util::XRefreshListener>* pObj = aRefreshListeners[n];
if ( *pObj == xListener )
{
aRefreshListeners.DeleteAndDestroy( n );
if ( aRefreshListeners.Count() == 0 )
release(); // release ref for listeners
break;
}
}
}
void ScDatabaseRangeObj::Refreshed_Impl()
{
lang::EventObject aEvent;
aEvent.Source = (cppu::OWeakObject*)this;
for ( sal_uInt16 n=0; n<aRefreshListeners.Count(); n++ )
(*aRefreshListeners[n])->refreshed( aEvent );
}
// XCellRangeSource
uno::Reference<table::XCellRange> SAL_CALL ScDatabaseRangeObj::getReferredCells()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
ScRange aRange;
ScDBData* pData = GetDBData_Impl();
if ( pData )
{
//! static Funktion um ScCellObj/ScCellRangeObj zu erzeugen am ScCellRangeObj ???
pData->GetArea(aRange);
if ( aRange.aStart == aRange.aEnd )
return new ScCellObj( pDocShell, aRange.aStart );
else
return new ScCellRangeObj( pDocShell, aRange );
}
return NULL;
}
// XPropertySet
uno::Reference<beans::XPropertySetInfo> SAL_CALL ScDatabaseRangeObj::getPropertySetInfo()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
static uno::Reference<beans::XPropertySetInfo> aRef(
new SfxItemPropertySetInfo( aPropSet.getPropertyMap() ));
return aRef;
}
void SAL_CALL ScDatabaseRangeObj::setPropertyValue(
const rtl::OUString& aPropertyName, const uno::Any& aValue )
throw(beans::UnknownPropertyException, beans::PropertyVetoException,
lang::IllegalArgumentException, lang::WrappedTargetException,
uno::RuntimeException)
{
ScUnoGuard aGuard;
ScDBData* pData = GetDBData_Impl();
if ( pDocShell && pData )
{
ScDBData aNewData( *pData );
sal_Bool bDo = sal_True;
String aString(aPropertyName);
if ( aString.EqualsAscii( SC_UNONAME_KEEPFORM ) )
aNewData.SetKeepFmt( ScUnoHelpFunctions::GetBoolFromAny( aValue ) );
else if ( aString.EqualsAscii( SC_UNONAME_MOVCELLS ) )
aNewData.SetDoSize( ScUnoHelpFunctions::GetBoolFromAny( aValue ) );
else if ( aString.EqualsAscii( SC_UNONAME_STRIPDAT ) )
aNewData.SetStripData( ScUnoHelpFunctions::GetBoolFromAny( aValue ) );
else if (aString.EqualsAscii( SC_UNONAME_AUTOFLT ))
{
sal_Bool bAutoFilter(ScUnoHelpFunctions::GetBoolFromAny( aValue ));
aNewData.SetAutoFilter(bAutoFilter);
ScRange aRange;
aNewData.GetArea(aRange);
ScDocument* pDoc = pDocShell->GetDocument();
if (bAutoFilter && pDoc)
pDoc->ApplyFlagsTab( aRange.aStart.Col(), aRange.aStart.Row(),
aRange.aEnd.Col(), aRange.aStart.Row(),
aRange.aStart.Tab(), SC_MF_AUTO );
else if (!bAutoFilter && pDoc)
pDoc->RemoveFlagsTab(aRange.aStart.Col(), aRange.aStart.Row(),
aRange.aEnd.Col(), aRange.aStart.Row(),
aRange.aStart.Tab(), SC_MF_AUTO );
ScRange aPaintRange(aRange.aStart, aRange.aEnd);
aPaintRange.aEnd.SetRow(aPaintRange.aStart.Row());
pDocShell->PostPaint(aPaintRange, PAINT_GRID);
}
else if (aString.EqualsAscii( SC_UNONAME_USEFLTCRT ))
{
if (ScUnoHelpFunctions::GetBoolFromAny( aValue ))
{
ScRange aRange;
aNewData.GetAdvancedQuerySource(aRange);
aNewData.SetAdvancedQuerySource(&aRange);
}
else
aNewData.SetAdvancedQuerySource(NULL);
}
else if (aString.EqualsAscii( SC_UNONAME_FLTCRT ))
{
table::CellRangeAddress aRange;
if (aValue >>= aRange)
{
ScRange aCoreRange;
ScUnoConversion::FillScRange(aCoreRange, aRange);
aNewData.SetAdvancedQuerySource(&aCoreRange);
}
}
else if (aString.EqualsAscii( SC_UNONAME_FROMSELECT ))
{
aNewData.SetImportSelection(::cppu::any2bool(aValue));
}
else if (aString.EqualsAscii( SC_UNONAME_REFPERIOD ))
{
sal_Int32 nRefresh = 0;
if (aValue >>= nRefresh)
{
ScDocument* pDoc = pDocShell->GetDocument();
aNewData.SetRefreshDelay(nRefresh);
if (pDoc && pDoc->GetDBCollection())
{
aNewData.SetRefreshHandler( pDoc->GetDBCollection()->GetRefreshHandler() );
aNewData.SetRefreshControl( pDoc->GetRefreshTimerControlAddress() );
}
}
}
else if (aString.EqualsAscii( SC_UNONAME_CONRES ))
{
}
else
bDo = sal_False;
if (bDo)
{
ScDBDocFunc aFunc(*pDocShell);
aFunc.ModifyDBData(aNewData, sal_True);
}
}
}
uno::Any SAL_CALL ScDatabaseRangeObj::getPropertyValue( const rtl::OUString& aPropertyName )
throw(beans::UnknownPropertyException, lang::WrappedTargetException,
uno::RuntimeException)
{
ScUnoGuard aGuard;
uno::Any aRet;
ScDBData* pData = GetDBData_Impl();
if ( pData )
{
String aString(aPropertyName);
if ( aString.EqualsAscii( SC_UNONAME_KEEPFORM ) )
ScUnoHelpFunctions::SetBoolInAny( aRet, pData->IsKeepFmt() );
else if ( aString.EqualsAscii( SC_UNONAME_MOVCELLS ) )
ScUnoHelpFunctions::SetBoolInAny( aRet, pData->IsDoSize() );
else if ( aString.EqualsAscii( SC_UNONAME_STRIPDAT ) )
ScUnoHelpFunctions::SetBoolInAny( aRet, pData->IsStripData() );
else if ( aString.EqualsAscii( SC_UNONAME_ISUSER ) )
{
// all database ranges except "unnamed" are user defined
ScUnoHelpFunctions::SetBoolInAny( aRet,
( pData->GetName() != ScGlobal::GetRscString(STR_DB_NONAME) ) );
}
else if ( aString.EqualsAscii( SC_UNO_LINKDISPBIT ) )
{
// no target bitmaps for individual entries (would be all equal)
// ScLinkTargetTypeObj::SetLinkTargetBitmap( aRet, SC_LINKTARGETTYPE_DBAREA );
}
else if ( aString.EqualsAscii( SC_UNO_LINKDISPNAME ) )
aRet <<= rtl::OUString( aName );
else if (aString.EqualsAscii( SC_UNONAME_AUTOFLT ))
{
sal_Bool bAutoFilter(GetDBData_Impl()->HasAutoFilter());
ScUnoHelpFunctions::SetBoolInAny( aRet, bAutoFilter );
}
else if (aString.EqualsAscii( SC_UNONAME_USEFLTCRT ))
{
ScRange aRange;
sal_Bool bIsAdvancedSource(GetDBData_Impl()->GetAdvancedQuerySource(aRange));
ScUnoHelpFunctions::SetBoolInAny( aRet, bIsAdvancedSource );
}
else if (aString.EqualsAscii( SC_UNONAME_FLTCRT ))
{
table::CellRangeAddress aRange;
ScRange aCoreRange;
if (GetDBData_Impl()->GetAdvancedQuerySource(aCoreRange))
ScUnoConversion::FillApiRange(aRange, aCoreRange);
aRet <<= aRange;
}
else if (aString.EqualsAscii( SC_UNONAME_FROMSELECT ))
{
ScUnoHelpFunctions::SetBoolInAny( aRet, GetDBData_Impl()->HasImportSelection() );
}
else if (aString.EqualsAscii( SC_UNONAME_REFPERIOD ))
{
sal_Int32 nRefresh(GetDBData_Impl()->GetRefreshDelay());
aRet <<= nRefresh;
}
else if (aString.EqualsAscii( SC_UNONAME_CONRES ))
{
}
else if (aString.EqualsAscii( SC_UNONAME_TOKENINDEX ))
{
// get index for use in formula tokens (read-only)
aRet <<= static_cast<sal_Int32>(GetDBData_Impl()->GetIndex());
}
}
return aRet;
}
SC_IMPL_DUMMY_PROPERTY_LISTENER( ScDatabaseRangeObj )
// XServiceInfo
rtl::OUString SAL_CALL ScDatabaseRangeObj::getImplementationName() throw(uno::RuntimeException)
{
return rtl::OUString::createFromAscii( "ScDatabaseRangeObj" );
}
sal_Bool SAL_CALL ScDatabaseRangeObj::supportsService( const rtl::OUString& rServiceName )
throw(uno::RuntimeException)
{
String aServiceStr( rServiceName );
return aServiceStr.EqualsAscii( SCDATABASERANGEOBJ_SERVICE ) ||
aServiceStr.EqualsAscii( SCLINKTARGET_SERVICE );
}
uno::Sequence<rtl::OUString> SAL_CALL ScDatabaseRangeObj::getSupportedServiceNames()
throw(uno::RuntimeException)
{
uno::Sequence<rtl::OUString> aRet(2);
rtl::OUString* pArray = aRet.getArray();
pArray[0] = rtl::OUString::createFromAscii( SCDATABASERANGEOBJ_SERVICE );
pArray[1] = rtl::OUString::createFromAscii( SCLINKTARGET_SERVICE );
return aRet;
}
//------------------------------------------------------------------------
ScDatabaseRangesObj::ScDatabaseRangesObj(ScDocShell* pDocSh) :
pDocShell( pDocSh )
{
pDocShell->GetDocument()->AddUnoObject(*this);
}
ScDatabaseRangesObj::~ScDatabaseRangesObj()
{
if (pDocShell)
pDocShell->GetDocument()->RemoveUnoObject(*this);
}
void ScDatabaseRangesObj::Notify( SfxBroadcaster&, const SfxHint& rHint )
{
// Referenz-Update interessiert hier nicht
if ( rHint.ISA( SfxSimpleHint ) &&
((const SfxSimpleHint&)rHint).GetId() == SFX_HINT_DYING )
{
pDocShell = NULL; // ungueltig geworden
}
}
// XDatabaseRanges
ScDatabaseRangeObj* ScDatabaseRangesObj::GetObjectByIndex_Impl(sal_uInt16 nIndex)
{
if (pDocShell)
{
ScDBCollection* pNames = pDocShell->GetDocument()->GetDBCollection();
if (pNames && nIndex < pNames->GetCount())
return new ScDatabaseRangeObj( pDocShell, (*pNames)[nIndex]->GetName() );
}
return NULL;
}
ScDatabaseRangeObj* ScDatabaseRangesObj::GetObjectByName_Impl(const rtl::OUString& aName)
{
if ( pDocShell && hasByName(aName) )
{
String aString(aName);
return new ScDatabaseRangeObj( pDocShell, aString );
}
return NULL;
}
void SAL_CALL ScDatabaseRangesObj::addNewByName( const rtl::OUString& aName,
const table::CellRangeAddress& aRange )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
sal_Bool bDone = sal_False;
if (pDocShell)
{
ScDBDocFunc aFunc(*pDocShell);
String aString(aName);
ScRange aNameRange( (SCCOL)aRange.StartColumn, (SCROW)aRange.StartRow, aRange.Sheet,
(SCCOL)aRange.EndColumn, (SCROW)aRange.EndRow, aRange.Sheet );
bDone = aFunc.AddDBRange( aString, aNameRange, sal_True );
}
if (!bDone)
throw uno::RuntimeException(); // no other exceptions specified
}
void SAL_CALL ScDatabaseRangesObj::removeByName( const rtl::OUString& aName )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
sal_Bool bDone = sal_False;
if (pDocShell)
{
ScDBDocFunc aFunc(*pDocShell);
String aString(aName);
bDone = aFunc.DeleteDBRange( aString, sal_True );
}
if (!bDone)
throw uno::RuntimeException(); // no other exceptions specified
}
// XEnumerationAccess
uno::Reference<container::XEnumeration> SAL_CALL ScDatabaseRangesObj::createEnumeration()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return new ScIndexEnumeration(this, rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.sheet.DatabaseRangesEnumeration")));
}
// XIndexAccess
sal_Int32 SAL_CALL ScDatabaseRangesObj::getCount() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
//! "unbenannt" weglassen ?
if (pDocShell)
{
ScDBCollection* pNames = pDocShell->GetDocument()->GetDBCollection();
if (pNames)
return pNames->GetCount();
}
return 0;
}
uno::Any SAL_CALL ScDatabaseRangesObj::getByIndex( sal_Int32 nIndex )
throw(lang::IndexOutOfBoundsException,
lang::WrappedTargetException, uno::RuntimeException)
{
ScUnoGuard aGuard;
uno::Reference<sheet::XDatabaseRange> xRange(GetObjectByIndex_Impl((sal_uInt16)nIndex));
if (xRange.is())
return uno::makeAny(xRange);
else
throw lang::IndexOutOfBoundsException();
// return uno::Any();
}
uno::Type SAL_CALL ScDatabaseRangesObj::getElementType() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return getCppuType((uno::Reference<sheet::XDatabaseRange>*)0);
}
sal_Bool SAL_CALL ScDatabaseRangesObj::hasElements() throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
return ( getCount() != 0 );
}
// XNameAccess
uno::Any SAL_CALL ScDatabaseRangesObj::getByName( const rtl::OUString& aName )
throw(container::NoSuchElementException,
lang::WrappedTargetException, uno::RuntimeException)
{
ScUnoGuard aGuard;
uno::Reference<sheet::XDatabaseRange> xRange(GetObjectByName_Impl(aName));
if (xRange.is())
return uno::makeAny(xRange);
else
throw container::NoSuchElementException();
// return uno::Any();
}
uno::Sequence<rtl::OUString> SAL_CALL ScDatabaseRangesObj::getElementNames()
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
//! "unbenannt" weglassen ?
if (pDocShell)
{
ScDBCollection* pNames = pDocShell->GetDocument()->GetDBCollection();
if (pNames)
{
sal_uInt16 nCount = pNames->GetCount();
String aName;
uno::Sequence<rtl::OUString> aSeq(nCount);
rtl::OUString* pAry = aSeq.getArray();
for (sal_uInt16 i=0; i<nCount; i++)
pAry[i] = (*pNames)[i]->GetName();
return aSeq;
}
}
return uno::Sequence<rtl::OUString>(0);
}
sal_Bool SAL_CALL ScDatabaseRangesObj::hasByName( const rtl::OUString& aName )
throw(uno::RuntimeException)
{
ScUnoGuard aGuard;
//! "unbenannt" weglassen ?
if (pDocShell)
{
ScDBCollection* pNames = pDocShell->GetDocument()->GetDBCollection();
if (pNames)
{
String aString(aName);
sal_uInt16 nPos = 0;
if (pNames->SearchName( aString, nPos ))
return sal_True;
}
}
return sal_False;
}
//------------------------------------------------------------------------