oox/source/xls/pivottablefragment.cxx

   1 /*************************************************************************
   2  *
   3  *  OpenOffice.org - a multi-platform office productivity suite
   4  *
   5  *  $RCSfile: pivottablefragment.cxx,v $
   6  *
   7  *  $Revision: 1.2 $
   8  *
   9  *  last change: $Author: rt $ $Date: 2008-01-17 08:06:09 $
  10  *
  11  *  The Contents of this file are made available subject to
  12  *  the terms of GNU Lesser General Public License Version 2.1.
  13  *
  14  *
  15  *    GNU Lesser General Public License Version 2.1
  16  *    =============================================
  17  *    Copyright 2005 by Sun Microsystems, Inc.
  18  *    901 San Antonio Road, Palo Alto, CA 94303, USA
  19  *
  20  *    This library is free software; you can redistribute it and/or
  21  *    modify it under the terms of the GNU Lesser General Public
  22  *    License version 2.1, as published by the Free Software Foundation.
  23  *
  24  *    This library is distributed in the hope that it will be useful,
  25  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
  26  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
  27  *    Lesser General Public License for more details.
  28  *
  29  *    You should have received a copy of the GNU Lesser General Public
  30  *    License along with this library; if not, write to the Free Software
  31  *    Foundation, Inc., 59 Temple Place, Suite 330, Boston,
  32  *    MA  02111-1307  USA
  33  *
  34  ************************************************************************/
  35
  36 #include "oox/xls/pivottablefragment.hxx"
  37 #include "oox/helper/attributelist.hxx"
  38 #include "oox/helper/propertyset.hxx"
  39 #include "oox/xls/addressconverter.hxx"
  40
  41 #define DEBUG_OOX_PIVOTTABLE 1
  42
  43 #include <vector>
  44 #include <stdexcept>
  45 #if DEBUG_OOX_PIVOTTABLE
  46 #include <stdio.h>
  47 #endif
  48
  49 using ::rtl::OUString;
  50 using ::com::sun::star::uno::Any;
  51 using ::com::sun::star::uno::Reference;
  52 using ::com::sun::star::uno::Sequence;
  53 using ::com::sun::star::uno::Exception;
  54 using ::com::sun::star::uno::RuntimeException;
  55 using ::com::sun::star::uno::UNO_QUERY;
  56 using ::com::sun::star::uno::UNO_QUERY_THROW;
  57 using ::com::sun::star::table::CellRangeAddress;
  58 using ::com::sun::star::xml::sax::SAXException;
  59
  60 namespace oox {
  61 namespace xls {
  62
  63 OoxPivotTableFragment::OoxPivotTableFragment(
  64         const WorksheetHelper& rHelper, const OUString& rFragmentPath ) :
  65     OoxWorksheetFragmentBase( rHelper, rFragmentPath ),
  66     mbValidRange( false )
  67 {
  68 }
  69
  70 bool OoxPivotTableFragment::onCanCreateContext( sal_Int32 nElement ) const
  71 {
  72     switch( getCurrentContext() )
  73     {
  74         case XML_ROOT_CONTEXT:                      return (nElement == XLS_TOKEN( pivotTableDefinition ));
  75         case XLS_TOKEN( pivotTableDefinition ):     return (nElement == XLS_TOKEN( location )) ||
  76                                                            (nElement == XLS_TOKEN( pivotFields )) ||
  77                                                            (nElement == XLS_TOKEN( rowFields )) ||
  78                                                            (nElement == XLS_TOKEN( rowItems )) ||
  79                                                            (nElement == XLS_TOKEN( colFields )) ||
  80                                                            (nElement == XLS_TOKEN( colItems )) ||
  81                                                            (nElement == XLS_TOKEN( pageFields )) ||
  82                                                            (nElement == XLS_TOKEN( dataFields )) ||
  83                                                            (nElement == XLS_TOKEN( pivotTableStyleInfo ));
  84         case XLS_TOKEN( pivotFields ):              return (nElement == XLS_TOKEN( pivotField ));
  85         case XLS_TOKEN( pivotField ):               return (nElement == XLS_TOKEN( items ));
  86         case XLS_TOKEN( items ):                    return (nElement == XLS_TOKEN( item ));
  87         case XLS_TOKEN( rowFields ):                return (nElement == XLS_TOKEN( field ));
  88         case XLS_TOKEN( colFields ):                return (nElement == XLS_TOKEN( field ));
  89         case XLS_TOKEN( pageFields ):               return (nElement == XLS_TOKEN( pageField ));
  90         case XLS_TOKEN( dataFields ):               return (nElement == XLS_TOKEN( dataField ));
  91         case XLS_TOKEN( colItems ):                 return (nElement == XLS_TOKEN( i ));
  92         case XLS_TOKEN( rowItems ):                 return (nElement == XLS_TOKEN( i ));
  93     }
  94     return false;
  95 }
  96
  97 void OoxPivotTableFragment::onStartElement( const AttributeList& rAttribs )
  98 {
  99     switch ( getCurrentContext() )
 100     {
 101         case XLS_TOKEN( pivotTableDefinition ):
 102             importPivotTableDefinition( rAttribs );
 103         break;
 104         case XLS_TOKEN( location ):
 105             importLocation( rAttribs );
 106         break;
 107         case XLS_TOKEN( pivotFields ):
 108             importPivotFields( rAttribs );
 109         break;
 110         case XLS_TOKEN( pivotField ):
 111             importPivotField( rAttribs );
 112         break;
 113     }
 114 }
 115
 116 void OoxPivotTableFragment::finalizeImport()
 117 {
 118     if( mbValidRange )
 119         getPivotTables().setPivotTable( maName, maData );
 120 }
 121
 122 void OoxPivotTableFragment::importLocation( const AttributeList& rAttribs )
 123 {
 124     CellRangeAddress aRange;
 125     OUString aRangeName = rAttribs.getString( XML_ref );
 126     mbValidRange = getAddressConverter().convertToCellRange(
 127         aRange, aRangeName, getSheetIndex(), true );
 128
 129     if ( mbValidRange )
 130         maData.maRange = aRange;
 131 }
 132
 133 void OoxPivotTableFragment::importPivotTableDefinition( const AttributeList& rAttribs )
 134 {
 135     if ( !rAttribs.hasAttribute( XML_cacheId ) )
 136         return;
 137
 138     maName = rAttribs.getString( XML_name );
 139     maData.mnCacheId = rAttribs.getInteger( XML_cacheId, 0 );
 140
 141     // name="PivotTable3"
 142     // cacheId="0"
 143     // applyNumberFormats="0"
 144     // applyBorderFormats="0"
 145     // applyFontFormats="0"
 146     // applyPatternFormats="0"
 147     // applyAlignmentFormats="0"
 148     // applyWidthHeightFormats="1"
 149     // dataCaption="Values"
 150     // updatedVersion="3"
 151     // minRefreshableVersion="3"
 152     // showCalcMbrs="0"
 153     // useAutoFormatting="1"
 154     // itemPrintTitles="1"
 155     // createdVersion="3"
 156     // indent="0"
 157     // outline="1"
 158     // outlineData="1"
 159     // multipleFieldFilters="0"
 160 }
 161
 162 void OoxPivotTableFragment::importPivotFields( const AttributeList& rAttribs )
 163 {
 164     maData.maFields.reserve( rAttribs.getUnsignedInteger( XML_count, 1 ) );
 165 }
 166
 167 void OoxPivotTableFragment::importPivotField( const AttributeList& rAttribs )
 168 {
 169     maData.maFields.push_back( PivotTableField() );
 170     PivotTableField& rField = maData.maFields.back();
 171     rField.mbDataField = rAttribs.getBool( XML_dataField, false );
 172
 173     // Possible values are: axisCol, axisRow, axisPage, axisValues
 174     switch ( rAttribs.getToken( XML_axis ) )
 175     {
 176         case XML_axisCol:
 177             rField.meAxis = PivotTableField::COLUMN;
 178         break;
 179         case XML_axisRow:
 180             rField.meAxis = PivotTableField::ROW;
 181         break;
 182         case XML_axisPage:
 183             rField.meAxis = PivotTableField::PAGE;
 184         break;
 185         case XML_axisValues:
 186             rField.meAxis = PivotTableField::VALUES;
 187         break;
 188         default:
 189         break;
 190     }
 191 }
 192
 193 } // namespace xls
 194 } // namespace oox