sc/source/filter/xml/xmlsubti.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  *
   9  * This file incorporates work covered by the following license notice:
  10  *
  11  *   Licensed to the Apache Software Foundation (ASF) under one or more
  12  *   contributor license agreements. See the NOTICE file distributed
  13  *   with this work for additional information regarding copyright
  14  *   ownership. The ASF licenses this file to you under the Apache
  15  *   License, Version 2.0 (the "License"); you may not use this file
  16  *   except in compliance with the License. You may obtain a copy of
  17  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  18  */
  19
  20 #include "xmlsubti.hxx"
  21 #include "global.hxx"
  22 #include "xmlstyli.hxx"
  23 #include "xmlimprt.hxx"
  24 #include "document.hxx"
  25 #include "markdata.hxx"
  26 #include "XMLConverter.hxx"
  27 #include "docuno.hxx"
  28 #include "cellsuno.hxx"
  29 #include "XMLStylesImportHelper.hxx"
  30 #include "sheetdata.hxx"
  31 #include "tabprotection.hxx"
  32 #include "tokenarray.hxx"
  33 #include "convuno.hxx"
  34 #include "documentimport.hxx"
  35
  36 #include <svx/svdpage.hxx>
  37
  38 #include <sax/tools/converter.hxx>
  39 #include <xmloff/xmltkmap.hxx>
  40 #include <xmloff/nmspmap.hxx>
  41 #include <xmloff/xmlerror.hxx>
  42 #include <com/sun/star/sheet/XSpreadsheetDocument.hpp>
  43 #include <com/sun/star/sheet/XSheetCellRange.hpp>
  44 #include <com/sun/star/sheet/XCellRangeAddressable.hpp>
  45 #include <com/sun/star/sheet/CellInsertMode.hpp>
  46 #include <com/sun/star/sheet/XCellRangeMovement.hpp>
  47 #include <com/sun/star/drawing/XDrawPageSupplier.hpp>
  48 #include <com/sun/star/container/XNamed.hpp>
  49 #include <com/sun/star/util/XProtectable.hpp>
  50 #include <com/sun/star/sheet/XArrayFormulaRange.hpp>
  51
  52 #include <boost/scoped_ptr.hpp>
  53
  54 using namespace com::sun::star;
  55
  56
  57 ScXMLTabProtectionData::ScXMLTabProtectionData() :
  58     meHash1(PASSHASH_SHA1),
  59     meHash2(PASSHASH_UNSPECIFIED),
  60     mbProtected(false),
  61     mbSelectProtectedCells(true),
  62     mbSelectUnprotectedCells(true)
  63 {
  64 }
  65
  66 ScMyTables::ScMyTables(ScXMLImport& rTempImport)
  67     : rImport(rTempImport),
  68     aFixupOLEs(rTempImport),
  69     maCurrentCellPos(ScAddress::INITIALIZE_INVALID),
  70     nCurrentColCount(0),
  71     nCurrentDrawPage( -1 ),
  72     nCurrentXShapes( -1 )
  73 {
  74 }
  75
  76 ScMyTables::~ScMyTables()
  77 {
  78 }
  79
  80 namespace {
  81
  82 uno::Reference<sheet::XSpreadsheet> getCurrentSheet(const uno::Reference<frame::XModel>& xModel, SCTAB nSheet)
  83 {
  84     uno::Reference<sheet::XSpreadsheet> xSheet;
  85     uno::Reference<sheet::XSpreadsheetDocument> xSpreadDoc(xModel, uno::UNO_QUERY);
  86     if (!xSpreadDoc.is())
  87         return xSheet;
  88
  89     uno::Reference <sheet::XSpreadsheets> xSheets(xSpreadDoc->getSheets());
  90     if (!xSheets.is())
  91         return xSheet;
  92
  93     uno::Reference <container::XIndexAccess> xIndex(xSheets, uno::UNO_QUERY);
  94     if (!xIndex.is())
  95         return xSheet;
  96
  97     xSheet.set(xIndex->getByIndex(nSheet), uno::UNO_QUERY);
  98     return xSheet;
  99 }
 100
 101 }
 102
 103 void ScMyTables::NewSheet(const OUString& sTableName, const OUString& sStyleName,
 104                           const ScXMLTabProtectionData& rProtectData)
 105 {
 106     if (rImport.GetModel().is())
 107     {
 108         nCurrentColCount = 0;
 109         sCurrentSheetName = sTableName;
 110         //reset cols and rows for new sheet, but increment tab
 111         maCurrentCellPos.SetCol(-1);
 112         maCurrentCellPos.SetRow(-1);
 113         maCurrentCellPos.SetTab(maCurrentCellPos.Tab() + 1);
 114
 115         maProtectionData = rProtectData;
 116         ScDocument *pDoc = ScXMLConverter::GetScDocument(rImport.GetModel());
 117
 118         // The document contains one sheet when created. So for the first
 119         // sheet, we only need to set its name.
 120         if (maCurrentCellPos.Tab() > 0)
 121             pDoc->AppendTabOnLoad(sTableName);
 122         else
 123             pDoc->SetTabNameOnLoad(maCurrentCellPos.Tab(), sTableName);
 124
 125         rImport.SetTableStyle(sStyleName);
 126         xCurrentSheet = getCurrentSheet(rImport.GetModel(), maCurrentCellPos.Tab());
 127         if (xCurrentSheet.is())
 128         {
 129             // We need to set the current cell range here regardless of
 130             // presence of style name.
 131             xCurrentCellRange.set(xCurrentSheet, uno::UNO_QUERY);
 132             SetTableStyle(sStyleName);
 133         }
 134     }
 135 }
 136
 137 void ScMyTables::SetTableStyle(const OUString& sStyleName)
 138 {
 139     //these uno calls are a bit difficult to remove, XMLTableStyleContext::FillPropertySet uses
 140     //SvXMLImportPropertyMapper::FillPropertySet
 141     if ( !sStyleName.isEmpty() )
 142     {
 143         // #i57869# All table style properties for all sheets are now applied here,
 144         // before importing the contents.
 145         // This is needed for the background color.
 146         // Sheet visibility has special handling in ScDocFunc::SetTableVisible to
 147         // allow hiding the first sheet.
 148         // RTL layout is only remembered, not actually applied, so the shapes can
 149         // be loaded before mirroring.
 150
 151         if ( xCurrentSheet.is() )
 152         {
 153             xCurrentCellRange.set(xCurrentSheet, uno::UNO_QUERY);
 154             uno::Reference <beans::XPropertySet> xProperties(xCurrentSheet, uno::UNO_QUERY);
 155             if ( xProperties.is() )
 156             {
 157                 XMLTableStylesContext *pStyles = (XMLTableStylesContext *)rImport.GetAutoStyles();
 158                 if ( pStyles )
 159                 {
 160                     XMLTableStyleContext* pStyle = (XMLTableStyleContext *)pStyles->FindStyleChildContext(
 161                             XML_STYLE_FAMILY_TABLE_TABLE, sStyleName, true);
 162                     if ( pStyle )
 163                     {
 164                         pStyle->FillPropertySet(xProperties);
 165
 166                         ScSheetSaveData* pSheetData = ScModelObj::getImplementation(rImport.GetModel())->GetSheetSaveData();
 167                         pSheetData->AddTableStyle( sStyleName, ScAddress( 0, 0, maCurrentCellPos.Tab() ) );
 168                     }
 169                 }
 170             }
 171         }
 172     }
 173 }
 174
 175 void ScMyTables::AddRow()
 176 {
 177     maCurrentCellPos.SetRow(maCurrentCellPos.Row() + 1);
 178     maCurrentCellPos.SetCol(-1); //reset columns for new row
 179 }
 180
 181 void ScMyTables::SetRowStyle(const OUString& rCellStyleName)
 182 {
 183     rImport.GetStylesImportHelper()->SetRowStyle(rCellStyleName);
 184 }
 185
 186 void ScMyTables::AddColumn(bool bIsCovered)
 187 {
 188     maCurrentCellPos.SetCol( maCurrentCellPos.Col() + 1 );
 189     //here only need to set column style if this is the first row and
 190     //the cell is not covered.
 191     if(maCurrentCellPos.Row() == 0 && !bIsCovered)
 192         rImport.GetStylesImportHelper()->InsertCol(maCurrentCellPos.Col(), maCurrentCellPos.Tab(), rImport.GetDocument());
 193 }
 194
 195 void ScMyTables::DeleteTable()
 196 {
 197     ScXMLImport::MutexGuard aGuard(rImport);
 198
 199     rImport.GetStylesImportHelper()->SetStylesToRanges();
 200     rImport.SetStylesToRangesFinished();
 201
 202     maMatrixRangeList.RemoveAll();
 203
 204     if (rImport.GetDocument() && maProtectionData.mbProtected)
 205     {
 206         uno::Sequence<sal_Int8> aHash;
 207         ::sax::Converter::decodeBase64(aHash, maProtectionData.maPassword);
 208
 209         boost::scoped_ptr<ScTableProtection> pProtect(new ScTableProtection);
 210         pProtect->setProtected(maProtectionData.mbProtected);
 211         pProtect->setPasswordHash(aHash, maProtectionData.meHash1, maProtectionData.meHash2);
 212         pProtect->setOption(ScTableProtection::SELECT_LOCKED_CELLS,   maProtectionData.mbSelectProtectedCells);
 213         pProtect->setOption(ScTableProtection::SELECT_UNLOCKED_CELLS, maProtectionData.mbSelectUnprotectedCells);
 214         rImport.GetDocument()->SetTabProtection(maCurrentCellPos.Tab(), pProtect.get());
 215     }
 216 }
 217
 218 void ScMyTables::AddColStyle(const sal_Int32 nRepeat, const OUString& rCellStyleName)
 219 {
 220     rImport.GetStylesImportHelper()->AddColumnStyle(rCellStyleName, nCurrentColCount, nRepeat);
 221     nCurrentColCount += nRepeat;
 222     SAL_WARN_IF(nCurrentColCount > MAXCOLCOUNT, "sc", "more columns than fit into SCCOL");
 223     nCurrentColCount = std::min<sal_Int32>( nCurrentColCount, MAXCOLCOUNT );
 224 }
 225
 226 uno::Reference< drawing::XDrawPage > ScMyTables::GetCurrentXDrawPage()
 227 {
 228     if( (maCurrentCellPos.Tab() != nCurrentDrawPage) || !xDrawPage.is() )
 229     {
 230         uno::Reference<drawing::XDrawPageSupplier> xDrawPageSupplier( xCurrentSheet, uno::UNO_QUERY );
 231         if( xDrawPageSupplier.is() )
 232             xDrawPage.set(xDrawPageSupplier->getDrawPage());
 233         nCurrentDrawPage = sal::static_int_cast<sal_Int16>(maCurrentCellPos.Tab());
 234     }
 235     return xDrawPage;
 236 }
 237
 238 uno::Reference< drawing::XShapes > ScMyTables::GetCurrentXShapes()
 239 {
 240     if( (maCurrentCellPos.Tab() != nCurrentXShapes) || !xShapes.is() )
 241     {
 242         xShapes.set(GetCurrentXDrawPage(), uno::UNO_QUERY);
 243         rImport.GetShapeImport()->startPage(xShapes);
 244         rImport.GetShapeImport()->pushGroupForSorting ( xShapes );
 245         nCurrentXShapes = sal::static_int_cast<sal_Int16>(maCurrentCellPos.Tab());
 246         return xShapes;
 247     }
 248     else
 249         return xShapes;
 250 }
 251
 252 bool ScMyTables::HasDrawPage()
 253 {
 254     return !((maCurrentCellPos.Tab() != nCurrentDrawPage) || !xDrawPage.is());
 255 }
 256
 257 bool ScMyTables::HasXShapes()
 258 {
 259     return !((maCurrentCellPos.Tab() != nCurrentXShapes) || !xShapes.is());
 260 }
 261
 262 void ScMyTables::AddOLE(uno::Reference <drawing::XShape>& rShape,
 263       const OUString &rRangeList)
 264 {
 265       aFixupOLEs.AddOLE(rShape, rRangeList);
 266 }
 267
 268 void ScMyTables::AddMatrixRange(
 269         const SCCOL nStartColumn, const SCROW nStartRow, const SCCOL nEndColumn, const SCROW nEndRow,
 270         const OUString& rFormula, const OUString& rFormulaNmsp, const formula::FormulaGrammar::Grammar eGrammar)
 271 {
 272     OSL_ENSURE(nEndRow >= nStartRow, "wrong row order");
 273     OSL_ENSURE(nEndColumn >= nStartColumn, "wrong column order");
 274     ScRange aScRange(
 275         nStartColumn, nStartRow, maCurrentCellPos.Tab(),
 276         nEndColumn, nEndRow, maCurrentCellPos.Tab()
 277     );
 278
 279     maMatrixRangeList.Append(aScRange);
 280
 281     ScDocumentImport& rDoc = rImport.GetDoc();
 282     boost::scoped_ptr<ScTokenArray> pCode(new ScTokenArray);
 283     pCode->AddStringXML( rFormula );
 284     if( (eGrammar == formula::FormulaGrammar::GRAM_EXTERNAL) && !rFormulaNmsp.isEmpty() )
 285         pCode->AddStringXML( rFormulaNmsp );
 286     rDoc.setMatrixCells(aScRange, *pCode, eGrammar);
 287     rDoc.getDoc().IncXMLImportedFormulaCount( rFormula.getLength() );
 288 }
 289
 290 bool ScMyTables::IsPartOfMatrix(const ScAddress& rScAddress) const
 291 {
 292     if (!maMatrixRangeList.empty())
 293         return maMatrixRangeList.In(rScAddress);
 294     return false;
 295 }
 296
 297 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */