From 3381981e76873304b171f7df900561dac681d2af Mon Sep 17 00:00:00 2001 From: Rüdiger Timm Date: Thu, 17 Jan 2008 07:06:10 +0000 Subject: #i10000# Bring module to HEAD. --- oox/source/xls/pivottablefragment.cxx | 194 ++++++++++++++++++++++++++++++++++ 1 file changed, 194 insertions(+) create mode 100644 oox/source/xls/pivottablefragment.cxx (limited to 'oox/source/xls/pivottablefragment.cxx') diff --git a/oox/source/xls/pivottablefragment.cxx b/oox/source/xls/pivottablefragment.cxx new file mode 100644 index 000000000000..48f99cb4d41c --- /dev/null +++ b/oox/source/xls/pivottablefragment.cxx @@ -0,0 +1,194 @@ +/************************************************************************* + * + * OpenOffice.org - a multi-platform office productivity suite + * + * $RCSfile: pivottablefragment.cxx,v $ + * + * $Revision: 1.2 $ + * + * last change: $Author: rt $ $Date: 2008-01-17 08:06:09 $ + * + * 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 + * + ************************************************************************/ + +#include "oox/xls/pivottablefragment.hxx" +#include "oox/helper/attributelist.hxx" +#include "oox/helper/propertyset.hxx" +#include "oox/xls/addressconverter.hxx" + +#define DEBUG_OOX_PIVOTTABLE 1 + +#include +#include +#if DEBUG_OOX_PIVOTTABLE +#include +#endif + +using ::rtl::OUString; +using ::com::sun::star::uno::Any; +using ::com::sun::star::uno::Reference; +using ::com::sun::star::uno::Sequence; +using ::com::sun::star::uno::Exception; +using ::com::sun::star::uno::RuntimeException; +using ::com::sun::star::uno::UNO_QUERY; +using ::com::sun::star::uno::UNO_QUERY_THROW; +using ::com::sun::star::table::CellRangeAddress; +using ::com::sun::star::xml::sax::SAXException; + +namespace oox { +namespace xls { + +OoxPivotTableFragment::OoxPivotTableFragment( + const WorksheetHelper& rHelper, const OUString& rFragmentPath ) : + OoxWorksheetFragmentBase( rHelper, rFragmentPath ), + mbValidRange( false ) +{ +} + +bool OoxPivotTableFragment::onCanCreateContext( sal_Int32 nElement ) const +{ + switch( getCurrentContext() ) + { + case XML_ROOT_CONTEXT: return (nElement == XLS_TOKEN( pivotTableDefinition )); + case XLS_TOKEN( pivotTableDefinition ): return (nElement == XLS_TOKEN( location )) || + (nElement == XLS_TOKEN( pivotFields )) || + (nElement == XLS_TOKEN( rowFields )) || + (nElement == XLS_TOKEN( rowItems )) || + (nElement == XLS_TOKEN( colFields )) || + (nElement == XLS_TOKEN( colItems )) || + (nElement == XLS_TOKEN( pageFields )) || + (nElement == XLS_TOKEN( dataFields )) || + (nElement == XLS_TOKEN( pivotTableStyleInfo )); + case XLS_TOKEN( pivotFields ): return (nElement == XLS_TOKEN( pivotField )); + case XLS_TOKEN( pivotField ): return (nElement == XLS_TOKEN( items )); + case XLS_TOKEN( items ): return (nElement == XLS_TOKEN( item )); + case XLS_TOKEN( rowFields ): return (nElement == XLS_TOKEN( field )); + case XLS_TOKEN( colFields ): return (nElement == XLS_TOKEN( field )); + case XLS_TOKEN( pageFields ): return (nElement == XLS_TOKEN( pageField )); + case XLS_TOKEN( dataFields ): return (nElement == XLS_TOKEN( dataField )); + case XLS_TOKEN( colItems ): return (nElement == XLS_TOKEN( i )); + case XLS_TOKEN( rowItems ): return (nElement == XLS_TOKEN( i )); + } + return false; +} + +void OoxPivotTableFragment::onStartElement( const AttributeList& rAttribs ) +{ + switch ( getCurrentContext() ) + { + case XLS_TOKEN( pivotTableDefinition ): + importPivotTableDefinition( rAttribs ); + break; + case XLS_TOKEN( location ): + importLocation( rAttribs ); + break; + case XLS_TOKEN( pivotFields ): + importPivotFields( rAttribs ); + break; + case XLS_TOKEN( pivotField ): + importPivotField( rAttribs ); + break; + } +} + +void OoxPivotTableFragment::finalizeImport() +{ + if( mbValidRange ) + getPivotTables().setPivotTable( maName, maData ); +} + +void OoxPivotTableFragment::importLocation( const AttributeList& rAttribs ) +{ + CellRangeAddress aRange; + OUString aRangeName = rAttribs.getString( XML_ref ); + mbValidRange = getAddressConverter().convertToCellRange( + aRange, aRangeName, getSheetIndex(), true ); + + if ( mbValidRange ) + maData.maRange = aRange; +} + +void OoxPivotTableFragment::importPivotTableDefinition( const AttributeList& rAttribs ) +{ + if ( !rAttribs.hasAttribute( XML_cacheId ) ) + return; + + maName = rAttribs.getString( XML_name ); + maData.mnCacheId = rAttribs.getInteger( XML_cacheId, 0 ); + + // name="PivotTable3" + // cacheId="0" + // applyNumberFormats="0" + // applyBorderFormats="0" + // applyFontFormats="0" + // applyPatternFormats="0" + // applyAlignmentFormats="0" + // applyWidthHeightFormats="1" + // dataCaption="Values" + // updatedVersion="3" + // minRefreshableVersion="3" + // showCalcMbrs="0" + // useAutoFormatting="1" + // itemPrintTitles="1" + // createdVersion="3" + // indent="0" + // outline="1" + // outlineData="1" + // multipleFieldFilters="0" +} + +void OoxPivotTableFragment::importPivotFields( const AttributeList& rAttribs ) +{ + maData.maFields.reserve( rAttribs.getUnsignedInteger( XML_count, 1 ) ); +} + +void OoxPivotTableFragment::importPivotField( const AttributeList& rAttribs ) +{ + maData.maFields.push_back( PivotTableField() ); + PivotTableField& rField = maData.maFields.back(); + rField.mbDataField = rAttribs.getBool( XML_dataField, false ); + + // Possible values are: axisCol, axisRow, axisPage, axisValues + switch ( rAttribs.getToken( XML_axis ) ) + { + case XML_axisCol: + rField.meAxis = PivotTableField::COLUMN; + break; + case XML_axisRow: + rField.meAxis = PivotTableField::ROW; + break; + case XML_axisPage: + rField.meAxis = PivotTableField::PAGE; + break; + case XML_axisValues: + rField.meAxis = PivotTableField::VALUES; + break; + default: + break; + } +} + +} // namespace xls +} // namespace oox -- cgit