sc/source/filter/xml/xmlexternaltabi.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: xmlexternaltabi.cxx,v $
  10  * $Revision: 1.1.2.5 $
  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 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_sc.hxx"
  33
  34
  35
  36 // INCLUDE ---------------------------------------------------------------
  37
  38 #include "xmlexternaltabi.hxx"
  39 #include "xmlimprt.hxx"
  40 #include "xmltabi.hxx"
  41 #include "xmlstyli.hxx"
  42
  43 #include "token.hxx"
  44 #include "document.hxx"
  45
  46 #include <xmloff/nmspmap.hxx>
  47 #include <xmloff/xmlnmspe.hxx>
  48 #include <xmloff/xmltoken.hxx>
  49 #include <xmloff/xmluconv.hxx>
  50 #include <com/sun/star/util/NumberFormat.hpp>
  51
  52 using namespace ::com::sun::star;
  53
  54 using ::rtl::OUString;
  55 using ::com::sun::star::uno::Reference;
  56 using ::com::sun::star::xml::sax::XAttributeList;
  57
  58 // ============================================================================
  59
  60 ScXMLExternalRefTabSourceContext::ScXMLExternalRefTabSourceContext(
  61     ScXMLImport& rImport, USHORT nPrefix, const OUString& rLName,
  62     const Reference<XAttributeList>& xAttrList, ScXMLExternalTabData& rRefInfo ) :
  63     SvXMLImportContext( rImport, nPrefix, rLName ),
  64     mrScImport(rImport),
  65     mrExternalRefInfo(rRefInfo)
  66 {
  67     using namespace ::xmloff::token;
  68
  69     sal_Int16 nAttrCount = xAttrList.is() ? xAttrList->getLength() : 0;
  70     for (sal_Int16 i = 0; i < nAttrCount; ++i)
  71     {
  72         const rtl::OUString& sAttrName = xAttrList->getNameByIndex(i);
  73         rtl::OUString aLocalName;
  74         sal_uInt16 nAttrPrefix = mrScImport.GetNamespaceMap().GetKeyByAttrName(sAttrName, &aLocalName);
  75         const rtl::OUString& sValue = xAttrList->getValueByIndex(i);
  76         if (nAttrPrefix == XML_NAMESPACE_XLINK)
  77         {
  78             if (IsXMLToken(aLocalName, XML_HREF))
  79                 maRelativeUrl = sValue;
  80         }
  81         else if (nAttrPrefix == XML_NAMESPACE_TABLE)
  82         {
  83             if (IsXMLToken(aLocalName, XML_TABLE_NAME))
  84                 maTableName = sValue;
  85             else if (IsXMLToken(aLocalName, XML_FILTER_NAME))
  86                 maFilterName = sValue;
  87             else if (IsXMLToken(aLocalName, XML_FILTER_OPTIONS))
  88                 maFilterOptions = sValue;
  89         }
  90     }
  91 }
  92
  93 ScXMLExternalRefTabSourceContext::~ScXMLExternalRefTabSourceContext()
  94 {
  95 }
  96
  97 SvXMLImportContext* ScXMLExternalRefTabSourceContext::CreateChildContext(
  98     USHORT nPrefix, const OUString& rLocalName, const Reference<XAttributeList>& /*xAttrList*/ )
  99 {
 100     return new SvXMLImportContext(GetImport(), nPrefix, rLocalName);
 101 }
 102
 103 void ScXMLExternalRefTabSourceContext::EndElement()
 104 {
 105     ScDocument* pDoc = mrScImport.GetDocument();
 106     if (!pDoc)
 107         return;
 108
 109     ScExternalRefManager* pRefMgr = pDoc->GetExternalRefManager();
 110     if (!maRelativeUrl.equals(mrExternalRefInfo.maFileUrl))
 111         pRefMgr->setRelativeFileName(mrExternalRefInfo.mnFileId, maRelativeUrl);
 112     pRefMgr->setFilterData(mrExternalRefInfo.mnFileId, maFilterName, maFilterOptions);
 113 }
 114
 115 // ============================================================================
 116
 117 ScXMLExternalRefRowsContext::ScXMLExternalRefRowsContext(
 118     ScXMLImport& rImport, USHORT nPrefix, const OUString& rLName,
 119     const Reference<XAttributeList>& /* xAttrList */, ScXMLExternalTabData& rRefInfo ) :
 120     SvXMLImportContext( rImport, nPrefix, rLName ),
 121     mrScImport(rImport),
 122     mrExternalRefInfo(rRefInfo)
 123 {
 124 }
 125
 126 ScXMLExternalRefRowsContext::~ScXMLExternalRefRowsContext()
 127 {
 128 }
 129
 130 SvXMLImportContext* ScXMLExternalRefRowsContext::CreateChildContext(
 131     USHORT nPrefix, const OUString& rLocalName, const Reference<XAttributeList>& xAttrList )
 132 {
 133     // #i101319# row elements inside group, rows or header-rows
 134     // are treated like row elements directly in the table element
 135
 136     const SvXMLTokenMap& rTokenMap = mrScImport.GetTableRowsElemTokenMap();
 137     sal_uInt16 nToken = rTokenMap.Get(nPrefix, rLocalName);
 138     switch (nToken)
 139     {
 140         case XML_TOK_TABLE_ROWS_ROW_GROUP:
 141         case XML_TOK_TABLE_ROWS_HEADER_ROWS:
 142         case XML_TOK_TABLE_ROWS_ROWS:
 143             return new ScXMLExternalRefRowsContext(
 144                 mrScImport, nPrefix, rLocalName, xAttrList, mrExternalRefInfo);
 145         case XML_TOK_TABLE_ROWS_ROW:
 146             return new ScXMLExternalRefRowContext(
 147                 mrScImport, nPrefix, rLocalName, xAttrList, mrExternalRefInfo);
 148         default:
 149             ;
 150     }
 151     return new SvXMLImportContext(GetImport(), nPrefix, rLocalName);
 152 }
 153
 154 void ScXMLExternalRefRowsContext::EndElement()
 155 {
 156 }
 157
 158 // ============================================================================
 159
 160 ScXMLExternalRefRowContext::ScXMLExternalRefRowContext(
 161     ScXMLImport& rImport, USHORT nPrefix, const OUString& rLName,
 162     const Reference<XAttributeList>& xAttrList, ScXMLExternalTabData& rRefInfo ) :
 163     SvXMLImportContext( rImport, nPrefix, rLName ),
 164     mrScImport(rImport),
 165     mrExternalRefInfo(rRefInfo),
 166     mnRepeatRowCount(1)
 167 {
 168     mrExternalRefInfo.mnCol = 0;
 169
 170     sal_Int16 nAttrCount(xAttrList.is() ? xAttrList->getLength() : 0);
 171     const SvXMLTokenMap& rAttrTokenMap = mrScImport.GetTableRowAttrTokenMap();
 172     for( sal_Int16 i=0; i < nAttrCount; ++i )
 173     {
 174         const rtl::OUString& sAttrName = xAttrList->getNameByIndex(i);
 175         rtl::OUString aLocalName;
 176         sal_uInt16 nAttrPrefix = mrScImport.GetNamespaceMap().GetKeyByAttrName(sAttrName, &aLocalName);
 177         const rtl::OUString& sValue = xAttrList->getValueByIndex(i);
 178
 179         switch (rAttrTokenMap.Get(nAttrPrefix, aLocalName))
 180         {
 181             case XML_TOK_TABLE_ROW_ATTR_REPEATED:
 182             {
 183                 mnRepeatRowCount = std::max(sValue.toInt32(), static_cast<sal_Int32>(1));
 184             }
 185             break;
 186         }
 187     }
 188 }
 189
 190 ScXMLExternalRefRowContext::~ScXMLExternalRefRowContext()
 191 {
 192 }
 193
 194 SvXMLImportContext* ScXMLExternalRefRowContext::CreateChildContext(
 195     USHORT nPrefix, const OUString& rLocalName, const Reference<XAttributeList>& xAttrList )
 196 {
 197     const SvXMLTokenMap& rTokenMap = mrScImport.GetTableRowElemTokenMap();
 198     sal_uInt16 nToken = rTokenMap.Get(nPrefix, rLocalName);
 199     if (nToken == XML_TOK_TABLE_ROW_CELL || nToken == XML_TOK_TABLE_ROW_COVERED_CELL)
 200         return new ScXMLExternalRefCellContext(mrScImport, nPrefix, rLocalName, xAttrList, mrExternalRefInfo);
 201
 202     return new SvXMLImportContext(GetImport(), nPrefix, rLocalName);
 203 }
 204
 205 void ScXMLExternalRefRowContext::EndElement()
 206 {
 207     ScExternalRefCache::TableTypeRef pTab = mrExternalRefInfo.mpCacheTable;
 208
 209     for (sal_Int32 i = 1; i < mnRepeatRowCount; ++i)
 210     {
 211         // Performance: duplicates of a non-existent row will still not exist.
 212         // Don't find that out for every cell.
 213         // External references often are a sparse matrix.
 214         if (i == 1 && !pTab->hasRow( mrExternalRefInfo.mnRow))
 215         {
 216             mrExternalRefInfo.mnRow += mnRepeatRowCount;
 217             return;
 218         }
 219
 220         for (sal_Int32 j = 0; j < mrExternalRefInfo.mnCol; ++j)
 221         {
 222             ScExternalRefCache::TokenRef pToken = pTab->getCell(
 223                 static_cast<SCCOL>(j), static_cast<SCROW>(mrExternalRefInfo.mnRow));
 224
 225             if (pToken.get())
 226             {
 227                 pTab->setCell(static_cast<SCCOL>(j),
 228                               static_cast<SCROW>(mrExternalRefInfo.mnRow+i), pToken);
 229             }
 230         }
 231     }
 232     mrExternalRefInfo.mnRow += mnRepeatRowCount;
 233 }
 234
 235 // ============================================================================
 236
 237 ScXMLExternalRefCellContext::ScXMLExternalRefCellContext(
 238     ScXMLImport& rImport, USHORT nPrefix, const OUString& rLName,
 239     const Reference<XAttributeList>& xAttrList, ScXMLExternalTabData& rRefInfo ) :
 240     SvXMLImportContext( rImport, nPrefix, rLName ),
 241     mrScImport(rImport),
 242     mrExternalRefInfo(rRefInfo),
 243     mfCellValue(0.0),
 244     mnRepeatCount(1),
 245     mnNumberFormat(-1),
 246     mnCellType(::com::sun::star::util::NumberFormat::UNDEFINED),
 247     mbIsNumeric(false),
 248     mbIsEmpty(true)
 249 {
 250     using namespace ::xmloff::token;
 251
 252     sal_Int16 nAttrCount = xAttrList.is() ? xAttrList->getLength() : 0;
 253     const SvXMLTokenMap& rTokenMap = rImport.GetTableRowCellAttrTokenMap();
 254     for (sal_Int16 i = 0; i < nAttrCount; ++i)
 255     {
 256         OUString aLocalName;
 257         sal_uInt16 nAttrPrefix = rImport.GetNamespaceMap().GetKeyByAttrName(
 258             xAttrList->getNameByIndex(i), &aLocalName);
 259
 260         const rtl::OUString& sValue = xAttrList->getValueByIndex(i);
 261         sal_uInt16 nToken = rTokenMap.Get(nAttrPrefix, aLocalName);
 262
 263         switch (nToken)
 264         {
 265             case XML_TOK_TABLE_ROW_CELL_ATTR_STYLE_NAME:
 266             {
 267                 XMLTableStylesContext* pStyles = static_cast<XMLTableStylesContext*>(mrScImport.GetAutoStyles());
 268                 const XMLTableStyleContext* pStyle = static_cast<const XMLTableStyleContext*>(
 269                     pStyles->FindStyleChildContext(XML_STYLE_FAMILY_TABLE_CELL, sValue, true));
 270                 if (pStyle)
 271                     mnNumberFormat = const_cast<XMLTableStyleContext*>(pStyle)->GetNumberFormat();
 272             }
 273             break;
 274             case XML_TOK_TABLE_ROW_CELL_ATTR_REPEATED:
 275             {
 276                 mnRepeatCount = ::std::max(sValue.toInt32(), static_cast<sal_Int32>(1));
 277             }
 278             break;
 279             case XML_TOK_TABLE_ROW_CELL_ATTR_VALUE_TYPE:
 280             {
 281                 mnCellType = mrScImport.GetCellType(sValue);
 282             }
 283             break;
 284             case XML_TOK_TABLE_ROW_CELL_ATTR_VALUE:
 285             {
 286                 if (sValue.getLength())
 287                 {
 288                     mrScImport.GetMM100UnitConverter().convertDouble(mfCellValue, sValue);
 289                     mbIsNumeric = true;
 290                     mbIsEmpty = false;
 291                 }
 292             }
 293             break;
 294             case XML_TOK_TABLE_ROW_CELL_ATTR_DATE_VALUE:
 295             {
 296                 if (sValue.getLength() && mrScImport.SetNullDateOnUnitConverter())
 297                 {
 298                     mrScImport.GetMM100UnitConverter().convertDateTime(mfCellValue, sValue);
 299                     mbIsNumeric = true;
 300                     mbIsEmpty = false;
 301                 }
 302             }
 303             break;
 304             case XML_TOK_TABLE_ROW_CELL_ATTR_TIME_VALUE:
 305             {
 306                 if (sValue.getLength())
 307                 {
 308                     mrScImport.GetMM100UnitConverter().convertTime(mfCellValue, sValue);
 309                     mbIsNumeric = true;
 310                     mbIsEmpty = false;
 311                 }
 312             }
 313             break;
 314             case XML_TOK_TABLE_ROW_CELL_ATTR_STRING_VALUE:
 315             {
 316                 if (sValue.getLength())
 317                 {
 318                     maCellString = sValue;
 319                     mbIsNumeric = false;
 320                     mbIsEmpty = false;
 321                 }
 322             }
 323             break;
 324             case XML_TOK_TABLE_ROW_CELL_ATTR_BOOLEAN_VALUE:
 325             {
 326                 if (sValue.getLength())
 327                 {
 328                     mfCellValue = IsXMLToken(sValue, XML_TRUE) ? 1.0 : 0.0;
 329                     mbIsNumeric = true;
 330                     mbIsEmpty = false;
 331                 }
 332             }
 333             break;
 334             default:
 335                 ;
 336         }
 337     }
 338 }
 339
 340 ScXMLExternalRefCellContext::~ScXMLExternalRefCellContext()
 341 {
 342 }
 343
 344 SvXMLImportContext* ScXMLExternalRefCellContext::CreateChildContext(
 345     USHORT nPrefix, const OUString& rLocalName, const Reference<XAttributeList>& xAttrList )
 346 {
 347     const SvXMLTokenMap& rTokenMap = mrScImport.GetTableRowCellElemTokenMap();
 348     sal_uInt16 nToken = rTokenMap.Get(nPrefix, rLocalName);
 349     if (nToken == XML_TOK_TABLE_ROW_CELL_P)
 350         return new ScXMLExternalRefCellTextContext(mrScImport, nPrefix, rLocalName, xAttrList, maCellString);
 351
 352     return new SvXMLImportContext(GetImport(), nPrefix, rLocalName);
 353 }
 354
 355 void ScXMLExternalRefCellContext::EndElement()
 356 {
 357     if (maCellString.getLength())
 358         mbIsEmpty = false;
 359
 360     for (sal_Int32 i = 0; i < mnRepeatCount; ++i, ++mrExternalRefInfo.mnCol)
 361     {
 362         if (mbIsEmpty)
 363             continue;
 364
 365         ScExternalRefCache::TokenRef aToken;
 366         if (mbIsNumeric)
 367             aToken.reset(new formula::FormulaDoubleToken(mfCellValue));
 368         else
 369             aToken.reset(new formula::FormulaStringToken(maCellString));
 370
 371         sal_uInt32 nNumFmt = mnNumberFormat >= 0 ? static_cast<sal_uInt32>(mnNumberFormat) : 0;
 372         mrExternalRefInfo.mpCacheTable->setCell(
 373             static_cast<SCCOL>(mrExternalRefInfo.mnCol),
 374             static_cast<SCROW>(mrExternalRefInfo.mnRow),
 375             aToken, nNumFmt);
 376     }
 377 }
 378
 379 // ============================================================================
 380
 381 ScXMLExternalRefCellTextContext::ScXMLExternalRefCellTextContext(
 382     ScXMLImport& rImport, USHORT nPrefix, const OUString& rLName,
 383     const Reference<XAttributeList>& /*xAttrList*/, OUString& rCellString ) :
 384     SvXMLImportContext( rImport, nPrefix, rLName ),
 385     mrScImport(rImport),
 386     mrCellString(rCellString)
 387 {
 388 }
 389
 390 ScXMLExternalRefCellTextContext::~ScXMLExternalRefCellTextContext()
 391 {
 392 }
 393
 394 SvXMLImportContext* ScXMLExternalRefCellTextContext::CreateChildContext(
 395     USHORT nPrefix, const OUString& rLocalName, const Reference<XAttributeList>& /*xAttrList*/ )
 396 {
 397     return new SvXMLImportContext(GetImport(), nPrefix, rLocalName);
 398 }
 399
 400 void ScXMLExternalRefCellTextContext::Characters(const OUString& rChar)
 401 {
 402     mrCellString = rChar;
 403 }
 404
 405 void ScXMLExternalRefCellTextContext::EndElement()
 406 {
 407 }