| /************************************************************** |
| * |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| *************************************************************/ |
| |
| |
| |
| // MARKER(update_precomp.py): autogen include statement, do not remove |
| #include "precompiled_sc.hxx" |
| |
| |
| |
| // INCLUDE --------------------------------------------------------------- |
| #include "XMLExportDDELinks.hxx" |
| #include <xmloff/xmltoken.hxx> |
| #include <xmloff/xmlnmspe.hxx> |
| #include <xmloff/nmspmap.hxx> |
| #include <xmloff/xmluconv.hxx> |
| #include "xmlexprt.hxx" |
| #include "unonames.hxx" |
| #include "document.hxx" |
| #include "scmatrix.hxx" |
| #include <com/sun/star/sheet/XDDELink.hpp> |
| |
| class ScMatrix; |
| |
| using namespace com::sun::star; |
| using namespace xmloff::token; |
| |
| ScXMLExportDDELinks::ScXMLExportDDELinks(ScXMLExport& rTempExport) |
| : rExport(rTempExport) |
| { |
| } |
| |
| ScXMLExportDDELinks::~ScXMLExportDDELinks() |
| { |
| } |
| |
| sal_Bool ScXMLExportDDELinks::CellsEqual(const sal_Bool bPrevEmpty, const sal_Bool bPrevString, const String& sPrevValue, const double& fPrevValue, |
| const sal_Bool bEmpty, const sal_Bool bString, const String& sValue, const double& fValue) |
| { |
| if (bEmpty == bPrevEmpty) |
| if (bEmpty) |
| return sal_True; |
| else if (bString == bPrevString) |
| if (bString) |
| return (sPrevValue == sValue); |
| else |
| return (fPrevValue == fValue); |
| else |
| return sal_False; |
| else |
| return sal_False; |
| } |
| |
| void ScXMLExportDDELinks::WriteCell(const sal_Bool bEmpty, const sal_Bool bString, const String& sValue, const double& fValue, const sal_Int32 nRepeat) |
| { |
| rtl::OUStringBuffer sBuffer; |
| if (!bEmpty) |
| { |
| if (bString) |
| { |
| rExport.AddAttribute(XML_NAMESPACE_OFFICE, XML_VALUE_TYPE, XML_STRING); |
| rExport.AddAttribute(XML_NAMESPACE_OFFICE, XML_STRING_VALUE, rtl::OUString(sValue)); |
| } |
| else |
| { |
| rExport.AddAttribute(XML_NAMESPACE_OFFICE, XML_VALUE_TYPE, XML_FLOAT); |
| rExport.GetMM100UnitConverter().convertDouble(sBuffer, fValue); |
| rExport.AddAttribute(XML_NAMESPACE_OFFICE, XML_VALUE, sBuffer.makeStringAndClear()); |
| } |
| } |
| if (nRepeat > 1) |
| { |
| rExport.GetMM100UnitConverter().convertNumber(sBuffer, nRepeat); |
| rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_NUMBER_COLUMNS_REPEATED, sBuffer.makeStringAndClear()); |
| } |
| SvXMLElementExport(rExport, XML_NAMESPACE_TABLE, XML_TABLE_CELL, sal_True, sal_True); |
| } |
| |
| void ScXMLExportDDELinks::WriteTable(const sal_Int32 nPos) |
| { |
| const ScMatrix* pMatrix(NULL); |
| if (rExport.GetDocument()) |
| pMatrix = rExport.GetDocument()->GetDdeLinkResultMatrix( static_cast<sal_uInt16>(nPos) ); |
| if (pMatrix) |
| { |
| SCSIZE nuCol; |
| SCSIZE nuRow; |
| pMatrix->GetDimensions( nuCol, nuRow ); |
| sal_Int32 nRowCount = static_cast<sal_Int32>(nuRow); |
| sal_Int32 nColCount = static_cast<sal_Int32>(nuCol); |
| SvXMLElementExport aTableElem(rExport, XML_NAMESPACE_TABLE, XML_TABLE, sal_True, sal_True); |
| rtl::OUStringBuffer sBuffer; |
| if (nColCount > 1) |
| { |
| rExport.GetMM100UnitConverter().convertNumber(sBuffer, nColCount); |
| rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_NUMBER_COLUMNS_REPEATED, sBuffer.makeStringAndClear()); |
| } |
| { |
| SvXMLElementExport aElemCol(rExport, XML_NAMESPACE_TABLE, XML_TABLE_COLUMN, sal_True, sal_True); |
| } |
| sal_Bool bPrevString(sal_True); |
| sal_Bool bPrevEmpty(sal_True); |
| double fPrevValue; |
| String sPrevValue; |
| sal_Int32 nRepeatColsCount(1); |
| for(sal_Int32 nRow = 0; nRow < nRowCount; ++nRow) |
| { |
| SvXMLElementExport aElemRow(rExport, XML_NAMESPACE_TABLE, XML_TABLE_ROW, sal_True, sal_True); |
| for(sal_Int32 nColumn = 0; nColumn < nColCount; ++nColumn) |
| { |
| ScMatValType nType = SC_MATVAL_VALUE; |
| const ScMatrixValue* pMatVal = pMatrix->Get( static_cast<SCSIZE>(nColumn), static_cast<SCSIZE>(nRow), nType ); |
| sal_Bool bIsString = ScMatrix::IsNonValueType( nType); |
| |
| if (nColumn == 0) |
| { |
| bPrevEmpty = !pMatVal; |
| bPrevString = bIsString; |
| if( bIsString ) |
| sPrevValue = pMatVal->GetString(); |
| else |
| fPrevValue = pMatVal->fVal; |
| } |
| else |
| { |
| double fValue; |
| String sValue; |
| sal_Bool bEmpty(!pMatVal); |
| sal_Bool bString(bIsString); |
| if( bIsString ) |
| sValue = pMatVal->GetString(); |
| else |
| fValue = pMatVal->fVal; |
| |
| if (CellsEqual(bPrevEmpty, bPrevString, sPrevValue, fPrevValue, |
| bEmpty, bString, sValue, fValue)) |
| ++nRepeatColsCount; |
| else |
| { |
| WriteCell(bPrevEmpty, bPrevString, sPrevValue, fPrevValue, nRepeatColsCount); |
| nRepeatColsCount = 1; |
| bPrevEmpty = bEmpty; |
| fPrevValue = fValue; |
| sPrevValue = sValue; |
| } |
| } |
| } |
| WriteCell(bPrevEmpty, bPrevString, sPrevValue, fPrevValue, nRepeatColsCount); |
| nRepeatColsCount = 1; |
| } |
| } |
| } |
| |
| void ScXMLExportDDELinks::WriteDDELinks(uno::Reference<sheet::XSpreadsheetDocument>& xSpreadDoc) |
| { |
| uno::Reference <beans::XPropertySet> xPropertySet (xSpreadDoc, uno::UNO_QUERY); |
| if (xPropertySet.is()) |
| { |
| uno::Reference<container::XIndexAccess> xIndex(xPropertySet->getPropertyValue(rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_DDELINKS))), uno::UNO_QUERY); |
| if (xIndex.is()) |
| { |
| sal_Int32 nCount = xIndex->getCount(); |
| if (nCount) |
| { |
| SvXMLElementExport aElemDDEs(rExport, XML_NAMESPACE_TABLE, XML_DDE_LINKS, sal_True, sal_True); |
| for (sal_uInt16 nDDELink = 0; nDDELink < nCount; ++nDDELink) |
| { |
| uno::Reference<sheet::XDDELink> xDDELink(xIndex->getByIndex(nDDELink), uno::UNO_QUERY); |
| if (xDDELink.is()) |
| { |
| SvXMLElementExport aElemDDE(rExport, XML_NAMESPACE_TABLE, XML_DDE_LINK, sal_True, sal_True); |
| { |
| rExport.AddAttribute(XML_NAMESPACE_OFFICE, XML_DDE_APPLICATION, xDDELink->getApplication()); |
| rExport.AddAttribute(XML_NAMESPACE_OFFICE, XML_DDE_TOPIC, xDDELink->getTopic()); |
| rExport.AddAttribute(XML_NAMESPACE_OFFICE, XML_DDE_ITEM, xDDELink->getItem()); |
| rExport.AddAttribute(XML_NAMESPACE_OFFICE, XML_AUTOMATIC_UPDATE, XML_TRUE); |
| sal_uInt8 nMode; |
| if (rExport.GetDocument() && |
| rExport.GetDocument()->GetDdeLinkMode(nDDELink, nMode)) |
| { |
| switch (nMode) |
| { |
| case SC_DDE_ENGLISH : |
| rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_CONVERSION_MODE, XML_INTO_ENGLISH_NUMBER); |
| break; |
| case SC_DDE_TEXT : |
| rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_CONVERSION_MODE, XML_KEEP_TEXT); |
| break; |
| } |
| } |
| SvXMLElementExport(rExport, XML_NAMESPACE_OFFICE, XML_DDE_SOURCE, sal_True, sal_True); |
| } |
| WriteTable(nDDELink); |
| } |
| } |
| } |
| } |
| } |
| } |
