oox/source/xls/tablebuffer.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: tablebuffer.cxx,v $
  10  * $Revision: 1.4 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 #include "oox/xls/tablebuffer.hxx"
  32 #include <com/sun/star/sheet/XDatabaseRanges.hpp>
  33 #include <com/sun/star/sheet/XDatabaseRange.hpp>
  34 #include "properties.hxx"
  35 #include "oox/helper/attributelist.hxx"
  36 #include "oox/helper/containerhelper.hxx"
  37 #include "oox/helper/propertyset.hxx"
  38 #include "oox/helper/recordinputstream.hxx"
  39 #include "oox/xls/addressconverter.hxx"
  40
  41 using ::rtl::OUString;
  42 using ::com::sun::star::uno::Reference;
  43 using ::com::sun::star::uno::Exception;
  44 using ::com::sun::star::uno::UNO_QUERY_THROW;
  45 using ::com::sun::star::container::XNameAccess;
  46 using ::com::sun::star::sheet::XDatabaseRanges;
  47 using ::com::sun::star::sheet::XDatabaseRange;
  48
  49 namespace oox {
  50 namespace xls {
  51
  52 // ============================================================================
  53
  54 TableModel::TableModel() :
  55     mnId( -1 ),
  56     mnType( XML_worksheet ),
  57     mnHeaderRows( 1 ),
  58     mnTotalsRows( 0 )
  59 {
  60 }
  61
  62 // ============================================================================
  63
  64 Table::Table( const WorkbookHelper& rHelper ) :
  65     WorkbookHelper( rHelper ),
  66     mnTokenIndex( -1 )
  67 {
  68 }
  69
  70 void Table::importTable( const AttributeList& rAttribs, sal_Int16 nSheet )
  71 {
  72     getAddressConverter().convertToCellRangeUnchecked( maModel.maRange, rAttribs.getString( XML_ref, OUString() ), nSheet );
  73     maModel.maProgName    = rAttribs.getXString( XML_name, OUString() );
  74     maModel.maDisplayName = rAttribs.getXString( XML_displayName, OUString() );
  75     maModel.mnId          = rAttribs.getInteger( XML_id, -1 );
  76     maModel.mnType        = rAttribs.getToken( XML_tableType, XML_worksheet );
  77     maModel.mnHeaderRows  = rAttribs.getInteger( XML_headerRowCount, 1 );
  78     maModel.mnTotalsRows  = rAttribs.getInteger( XML_totalsRowCount, 0 );
  79 }
  80
  81 void Table::importTable( RecordInputStream& rStrm, sal_Int16 nSheet )
  82 {
  83     BinRange aBinRange;
  84     sal_Int32 nType;
  85     rStrm >> aBinRange >> nType >> maModel.mnId >> maModel.mnHeaderRows >> maModel.mnTotalsRows;
  86     rStrm.skip( 32 );
  87     rStrm >> maModel.maProgName >> maModel.maDisplayName;
  88
  89     getAddressConverter().convertToCellRangeUnchecked( maModel.maRange, aBinRange, nSheet );
  90     static const sal_Int32 spnTypes[] = { XML_worksheet, XML_TOKEN_INVALID, XML_TOKEN_INVALID, XML_queryTable };
  91     maModel.mnType = STATIC_ARRAY_SELECT( spnTypes, nType, XML_TOKEN_INVALID );
  92 }
  93
  94 void Table::finalizeImport()
  95 {
  96     // validate cell range
  97     maDestRange = maModel.maRange;
  98     bool bValidRange = getAddressConverter().validateCellRange( maDestRange, true, true );
  99
 100     // create database range
 101     if( bValidRange && (maModel.mnId > 0) && (maModel.maDisplayName.getLength() > 0) ) try
 102     {
 103         // find an unused name
 104         Reference< XDatabaseRanges > xDatabaseRanges = getDatabaseRanges();
 105         Reference< XNameAccess > xNameAccess( xDatabaseRanges, UNO_QUERY_THROW );
 106         OUString aName = ContainerHelper::getUnusedName( xNameAccess, maModel.maDisplayName, '_' );
 107         xDatabaseRanges->addNewByName( aName, maModel.maRange );
 108         Reference< XDatabaseRange > xDatabaseRange( xDatabaseRanges->getByName( aName ), UNO_QUERY_THROW );
 109         PropertySet aPropSet( xDatabaseRange );
 110         if( !aPropSet.getProperty( mnTokenIndex, PROP_TokenIndex ) )
 111             mnTokenIndex = -1;
 112     }
 113     catch( Exception& )
 114     {
 115         OSL_ENSURE( false, "Table::finalizeImport - cannot create database range" );
 116     }
 117 }
 118
 119 // ============================================================================
 120
 121 TableBuffer::TableBuffer( const WorkbookHelper& rHelper ) :
 122     WorkbookHelper( rHelper )
 123 {
 124 }
 125
 126 TableRef TableBuffer::importTable( const AttributeList& rAttribs, sal_Int16 nSheet )
 127 {
 128     TableRef xTable( new Table( *this ) );
 129     xTable->importTable( rAttribs, nSheet );
 130     insertTable( xTable );
 131     return xTable;
 132 }
 133
 134 TableRef TableBuffer::importTable( RecordInputStream& rStrm, sal_Int16 nSheet )
 135 {
 136     TableRef xTable( new Table( *this ) );
 137     xTable->importTable( rStrm, nSheet );
 138     insertTable( xTable );
 139     return xTable;
 140 }
 141
 142 void TableBuffer::finalizeImport()
 143 {
 144     maIdTables.forEachMem( &Table::finalizeImport );
 145 }
 146
 147 TableRef TableBuffer::getTable( sal_Int32 nTableId ) const
 148 {
 149     return maIdTables.get( nTableId );
 150 }
 151
 152 TableRef TableBuffer::getTable( const OUString& rDispName ) const
 153 {
 154     return maNameTables.get( rDispName );
 155 }
 156
 157 // private --------------------------------------------------------------------
 158
 159 void TableBuffer::insertTable( TableRef xTable )
 160 {
 161     sal_Int32 nTableId = xTable->getTableId();
 162     const OUString& rDispName = xTable->getDisplayName();
 163     if( (nTableId > 0) && (rDispName.getLength() > 0) )
 164     {
 165         OSL_ENSURE( maIdTables.find( nTableId ) == maIdTables.end(), "TableBuffer::insertTable - multiple table identifier" );
 166         maIdTables[ nTableId ] = xTable;
 167         OSL_ENSURE( maNameTables.find( rDispName ) == maNameTables.end(), "TableBuffer::insertTable - multiple table name" );
 168         maNameTables[ rDispName ] = xTable;
 169     }
 170 }
 171
 172 // ============================================================================
 173
 174 } // namespace xls
 175 } // namespace oox
 176