1*b3f79822SAndrew Rist /**************************************************************
2cdf0e10cSrcweir  *
3*b3f79822SAndrew Rist  * Licensed to the Apache Software Foundation (ASF) under one
4*b3f79822SAndrew Rist  * or more contributor license agreements.  See the NOTICE file
5*b3f79822SAndrew Rist  * distributed with this work for additional information
6*b3f79822SAndrew Rist  * regarding copyright ownership.  The ASF licenses this file
7*b3f79822SAndrew Rist  * to you under the Apache License, Version 2.0 (the
8*b3f79822SAndrew Rist  * "License"); you may not use this file except in compliance
9*b3f79822SAndrew Rist  * with the License.  You may obtain a copy of the License at
10*b3f79822SAndrew Rist  *
11*b3f79822SAndrew Rist  *   http://www.apache.org/licenses/LICENSE-2.0
12*b3f79822SAndrew Rist  *
13*b3f79822SAndrew Rist  * Unless required by applicable law or agreed to in writing,
14*b3f79822SAndrew Rist  * software distributed under the License is distributed on an
15*b3f79822SAndrew Rist  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b3f79822SAndrew Rist  * KIND, either express or implied.  See the License for the
17*b3f79822SAndrew Rist  * specific language governing permissions and limitations
18*b3f79822SAndrew Rist  * under the License.
19*b3f79822SAndrew Rist  *
20*b3f79822SAndrew Rist  *************************************************************/
21*b3f79822SAndrew Rist 
22*b3f79822SAndrew Rist 
23cdf0e10cSrcweir 
24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
25cdf0e10cSrcweir #include "precompiled_sc.hxx"
26cdf0e10cSrcweir 
27cdf0e10cSrcweir 
28cdf0e10cSrcweir 
29cdf0e10cSrcweir //___________________________________________________________________
30cdf0e10cSrcweir #include "XMLDetectiveContext.hxx"
31cdf0e10cSrcweir #include <xmloff/nmspmap.hxx>
32cdf0e10cSrcweir #include <xmloff/xmltoken.hxx>
33cdf0e10cSrcweir #include <xmloff/xmluconv.hxx>
34cdf0e10cSrcweir #include "convuno.hxx"
35cdf0e10cSrcweir #include "xmlimprt.hxx"
36cdf0e10cSrcweir #include "XMLConverter.hxx"
37cdf0e10cSrcweir #include "rangeutl.hxx"
38cdf0e10cSrcweir 
39cdf0e10cSrcweir #include <algorithm>
40cdf0e10cSrcweir 
41cdf0e10cSrcweir using ::rtl::OUString;
42cdf0e10cSrcweir using namespace ::com::sun::star;
43cdf0e10cSrcweir using namespace xmloff::token;
44cdf0e10cSrcweir 
45cdf0e10cSrcweir 
46cdf0e10cSrcweir //___________________________________________________________________
47cdf0e10cSrcweir 
ScMyImpDetectiveObj()48cdf0e10cSrcweir ScMyImpDetectiveObj::ScMyImpDetectiveObj() :
49cdf0e10cSrcweir 	aSourceRange(),
50cdf0e10cSrcweir 	eObjType( SC_DETOBJ_NONE ),
51cdf0e10cSrcweir 	bHasError( sal_False )
52cdf0e10cSrcweir {
53cdf0e10cSrcweir }
54cdf0e10cSrcweir 
55cdf0e10cSrcweir //___________________________________________________________________
56cdf0e10cSrcweir 
operator <(const ScMyImpDetectiveOp & rDetOp) const57cdf0e10cSrcweir sal_Bool ScMyImpDetectiveOp::operator<(const ScMyImpDetectiveOp& rDetOp) const
58cdf0e10cSrcweir {
59cdf0e10cSrcweir 	return (nIndex < rDetOp.nIndex);
60cdf0e10cSrcweir }
61cdf0e10cSrcweir 
Sort()62cdf0e10cSrcweir void ScMyImpDetectiveOpArray::Sort()
63cdf0e10cSrcweir {
64cdf0e10cSrcweir 	aDetectiveOpList.sort();
65cdf0e10cSrcweir }
66cdf0e10cSrcweir 
GetFirstOp(ScMyImpDetectiveOp & rDetOp)67cdf0e10cSrcweir sal_Bool ScMyImpDetectiveOpArray::GetFirstOp( ScMyImpDetectiveOp& rDetOp )
68cdf0e10cSrcweir {
69cdf0e10cSrcweir 	if( aDetectiveOpList.empty() )
70cdf0e10cSrcweir 		return sal_False;
71cdf0e10cSrcweir 	ScMyImpDetectiveOpList::iterator aItr = aDetectiveOpList.begin();
72cdf0e10cSrcweir 	rDetOp = *aItr;
73cdf0e10cSrcweir 	aDetectiveOpList.erase( aItr );
74cdf0e10cSrcweir 	return sal_True;
75cdf0e10cSrcweir }
76cdf0e10cSrcweir 
77cdf0e10cSrcweir 
78cdf0e10cSrcweir //___________________________________________________________________
79cdf0e10cSrcweir 
ScXMLDetectiveContext(ScXMLImport & rImport,sal_uInt16 nPrfx,const OUString & rLName,ScMyImpDetectiveObjVec * pNewDetectiveObjVec)80cdf0e10cSrcweir ScXMLDetectiveContext::ScXMLDetectiveContext(
81cdf0e10cSrcweir 		ScXMLImport& rImport,
82cdf0e10cSrcweir 		sal_uInt16 nPrfx,
83cdf0e10cSrcweir 		const OUString& rLName,
84cdf0e10cSrcweir 		ScMyImpDetectiveObjVec* pNewDetectiveObjVec ) :
85cdf0e10cSrcweir 	SvXMLImportContext( rImport, nPrfx, rLName ),
86cdf0e10cSrcweir 	pDetectiveObjVec( pNewDetectiveObjVec )
87cdf0e10cSrcweir {
88cdf0e10cSrcweir }
89cdf0e10cSrcweir 
~ScXMLDetectiveContext()90cdf0e10cSrcweir ScXMLDetectiveContext::~ScXMLDetectiveContext()
91cdf0e10cSrcweir {
92cdf0e10cSrcweir }
93cdf0e10cSrcweir 
CreateChildContext(sal_uInt16 nPrefix,const OUString & rLName,const uno::Reference<xml::sax::XAttributeList> & xAttrList)94cdf0e10cSrcweir SvXMLImportContext *ScXMLDetectiveContext::CreateChildContext(
95cdf0e10cSrcweir 		sal_uInt16 nPrefix,
96cdf0e10cSrcweir 		const OUString& rLName,
97cdf0e10cSrcweir 		const uno::Reference< xml::sax::XAttributeList>& xAttrList )
98cdf0e10cSrcweir {
99cdf0e10cSrcweir 	SvXMLImportContext*		pContext	= NULL;
100cdf0e10cSrcweir 	const SvXMLTokenMap&	rTokenMap	= GetScImport().GetDetectiveElemTokenMap();
101cdf0e10cSrcweir 
102cdf0e10cSrcweir 	switch( rTokenMap.Get( nPrefix, rLName ) )
103cdf0e10cSrcweir 	{
104cdf0e10cSrcweir 		case XML_TOK_DETECTIVE_ELEM_HIGHLIGHTED:
105cdf0e10cSrcweir 			pContext = new ScXMLDetectiveHighlightedContext( GetScImport(), nPrefix, rLName, xAttrList, pDetectiveObjVec );
106cdf0e10cSrcweir 		break;
107cdf0e10cSrcweir 		case XML_TOK_DETECTIVE_ELEM_OPERATION:
108cdf0e10cSrcweir 			pContext = new ScXMLDetectiveOperationContext( GetScImport(), nPrefix, rLName, xAttrList );
109cdf0e10cSrcweir 		break;
110cdf0e10cSrcweir 	}
111cdf0e10cSrcweir 	if( !pContext )
112cdf0e10cSrcweir 		pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
113cdf0e10cSrcweir 
114cdf0e10cSrcweir 	return pContext;
115cdf0e10cSrcweir }
116cdf0e10cSrcweir 
EndElement()117cdf0e10cSrcweir void ScXMLDetectiveContext::EndElement()
118cdf0e10cSrcweir {
119cdf0e10cSrcweir }
120cdf0e10cSrcweir 
121cdf0e10cSrcweir 
122cdf0e10cSrcweir //___________________________________________________________________
123cdf0e10cSrcweir 
ScXMLDetectiveHighlightedContext(ScXMLImport & rImport,sal_uInt16 nPrfx,const OUString & rLName,const uno::Reference<xml::sax::XAttributeList> & xAttrList,ScMyImpDetectiveObjVec * pNewDetectiveObjVec)124cdf0e10cSrcweir ScXMLDetectiveHighlightedContext::ScXMLDetectiveHighlightedContext(
125cdf0e10cSrcweir 		ScXMLImport& rImport,
126cdf0e10cSrcweir 		sal_uInt16 nPrfx,
127cdf0e10cSrcweir 		const OUString& rLName,
128cdf0e10cSrcweir 		const uno::Reference< xml::sax::XAttributeList >& xAttrList,
129cdf0e10cSrcweir 		ScMyImpDetectiveObjVec* pNewDetectiveObjVec ):
130cdf0e10cSrcweir 	SvXMLImportContext( rImport, nPrfx, rLName ),
131cdf0e10cSrcweir 	pDetectiveObjVec( pNewDetectiveObjVec ),
132cdf0e10cSrcweir 	aDetectiveObj(),
133cdf0e10cSrcweir 	bValid( sal_False )
134cdf0e10cSrcweir {
135cdf0e10cSrcweir 	if( !xAttrList.is() ) return;
136cdf0e10cSrcweir 
137cdf0e10cSrcweir 	sal_Int16				nAttrCount		= xAttrList->getLength();
138cdf0e10cSrcweir 	const SvXMLTokenMap&	rAttrTokenMap	= GetScImport().GetDetectiveHighlightedAttrTokenMap();
139cdf0e10cSrcweir 
140cdf0e10cSrcweir 	for( sal_Int16 nIndex = 0; nIndex < nAttrCount; ++nIndex )
141cdf0e10cSrcweir 	{
142cdf0e10cSrcweir 		const rtl::OUString& sAttrName	(xAttrList->getNameByIndex( nIndex ));
143cdf0e10cSrcweir 		const rtl::OUString& sValue		(xAttrList->getValueByIndex( nIndex ));
144cdf0e10cSrcweir 		OUString aLocalName;
145cdf0e10cSrcweir 		sal_uInt16 nPrefix		= GetScImport().GetNamespaceMap().GetKeyByAttrName( sAttrName, &aLocalName );
146cdf0e10cSrcweir 
147cdf0e10cSrcweir 		switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
148cdf0e10cSrcweir 		{
149cdf0e10cSrcweir 			case XML_TOK_DETECTIVE_HIGHLIGHTED_ATTR_CELL_RANGE:
150cdf0e10cSrcweir 			{
151cdf0e10cSrcweir 				sal_Int32 nOffset(0);
152cdf0e10cSrcweir 				GetScImport().LockSolarMutex();
153cdf0e10cSrcweir 				bValid = ScRangeStringConverter::GetRangeFromString( aDetectiveObj.aSourceRange, sValue, GetScImport().GetDocument(), ::formula::FormulaGrammar::CONV_OOO, nOffset );
154cdf0e10cSrcweir 				GetScImport().UnlockSolarMutex();
155cdf0e10cSrcweir 			}
156cdf0e10cSrcweir 			break;
157cdf0e10cSrcweir 			case XML_TOK_DETECTIVE_HIGHLIGHTED_ATTR_DIRECTION:
158cdf0e10cSrcweir 				aDetectiveObj.eObjType = ScXMLConverter::GetDetObjTypeFromString( sValue );
159cdf0e10cSrcweir 			break;
160cdf0e10cSrcweir 			case XML_TOK_DETECTIVE_HIGHLIGHTED_ATTR_CONTAINS_ERROR:
161cdf0e10cSrcweir 				aDetectiveObj.bHasError = IsXMLToken(sValue, XML_TRUE);
162cdf0e10cSrcweir 			break;
163cdf0e10cSrcweir 			case XML_TOK_DETECTIVE_HIGHLIGHTED_ATTR_MARKED_INVALID:
164cdf0e10cSrcweir 				{
165cdf0e10cSrcweir 					if (IsXMLToken(sValue, XML_TRUE))
166cdf0e10cSrcweir 						aDetectiveObj.eObjType = SC_DETOBJ_CIRCLE;
167cdf0e10cSrcweir 				}
168cdf0e10cSrcweir 			break;
169cdf0e10cSrcweir 		}
170cdf0e10cSrcweir 	}
171cdf0e10cSrcweir }
172cdf0e10cSrcweir 
~ScXMLDetectiveHighlightedContext()173cdf0e10cSrcweir ScXMLDetectiveHighlightedContext::~ScXMLDetectiveHighlightedContext()
174cdf0e10cSrcweir {
175cdf0e10cSrcweir }
176cdf0e10cSrcweir 
CreateChildContext(sal_uInt16 nPrefix,const OUString & rLName,const uno::Reference<xml::sax::XAttributeList> &)177cdf0e10cSrcweir SvXMLImportContext *ScXMLDetectiveHighlightedContext::CreateChildContext(
178cdf0e10cSrcweir 		sal_uInt16 nPrefix,
179cdf0e10cSrcweir 		const OUString& rLName,
180cdf0e10cSrcweir         const uno::Reference< xml::sax::XAttributeList>& /* xAttrList */ )
181cdf0e10cSrcweir {
182cdf0e10cSrcweir 	return new SvXMLImportContext( GetImport(), nPrefix, rLName );
183cdf0e10cSrcweir }
184cdf0e10cSrcweir 
EndElement()185cdf0e10cSrcweir void ScXMLDetectiveHighlightedContext::EndElement()
186cdf0e10cSrcweir {
187cdf0e10cSrcweir 	switch( aDetectiveObj.eObjType )
188cdf0e10cSrcweir 	{
189cdf0e10cSrcweir 		case SC_DETOBJ_ARROW:
190cdf0e10cSrcweir 		case SC_DETOBJ_TOOTHERTAB:
191cdf0e10cSrcweir 		break;
192cdf0e10cSrcweir 		case SC_DETOBJ_FROMOTHERTAB:
193cdf0e10cSrcweir 		case SC_DETOBJ_CIRCLE:
194cdf0e10cSrcweir 			bValid = sal_True;
195cdf0e10cSrcweir 		break;
196cdf0e10cSrcweir 		default:
197cdf0e10cSrcweir 			bValid = sal_False;
198cdf0e10cSrcweir 	}
199cdf0e10cSrcweir 	if( bValid )
200cdf0e10cSrcweir 		pDetectiveObjVec->push_back( aDetectiveObj );
201cdf0e10cSrcweir }
202cdf0e10cSrcweir 
203cdf0e10cSrcweir 
204cdf0e10cSrcweir //___________________________________________________________________
205cdf0e10cSrcweir 
ScXMLDetectiveOperationContext(ScXMLImport & rImport,sal_uInt16 nPrfx,const OUString & rLName,const uno::Reference<xml::sax::XAttributeList> & xAttrList)206cdf0e10cSrcweir ScXMLDetectiveOperationContext::ScXMLDetectiveOperationContext(
207cdf0e10cSrcweir 		ScXMLImport& rImport,
208cdf0e10cSrcweir 		sal_uInt16 nPrfx,
209cdf0e10cSrcweir 		const OUString& rLName,
210cdf0e10cSrcweir 		const uno::Reference< xml::sax::XAttributeList >& xAttrList ) :
211cdf0e10cSrcweir 	SvXMLImportContext( rImport, nPrfx, rLName ),
212cdf0e10cSrcweir 	aDetectiveOp(),
213cdf0e10cSrcweir 	bHasType( sal_False )
214cdf0e10cSrcweir {
215cdf0e10cSrcweir 	if( !xAttrList.is() ) return;
216cdf0e10cSrcweir 
217cdf0e10cSrcweir 	sal_Int16				nAttrCount		= xAttrList->getLength();
218cdf0e10cSrcweir 	const SvXMLTokenMap&	rAttrTokenMap	= GetScImport().GetDetectiveOperationAttrTokenMap();
219cdf0e10cSrcweir 
220cdf0e10cSrcweir 	for( sal_Int16 nIndex = 0; nIndex < nAttrCount; ++nIndex )
221cdf0e10cSrcweir 	{
222cdf0e10cSrcweir 		const rtl::OUString& sAttrName	(xAttrList->getNameByIndex( nIndex ));
223cdf0e10cSrcweir 		const rtl::OUString& sValue		(xAttrList->getValueByIndex( nIndex ));
224cdf0e10cSrcweir 		OUString aLocalName;
225cdf0e10cSrcweir 		sal_uInt16 nPrefix		= GetScImport().GetNamespaceMap().GetKeyByAttrName( sAttrName, &aLocalName );
226cdf0e10cSrcweir 
227cdf0e10cSrcweir 		switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
228cdf0e10cSrcweir 		{
229cdf0e10cSrcweir 			case XML_TOK_DETECTIVE_OPERATION_ATTR_NAME:
230cdf0e10cSrcweir 				bHasType = ScXMLConverter::GetDetOpTypeFromString( aDetectiveOp.eOpType, sValue );
231cdf0e10cSrcweir 			break;
232cdf0e10cSrcweir 			case XML_TOK_DETECTIVE_OPERATION_ATTR_INDEX:
233cdf0e10cSrcweir 			{
234cdf0e10cSrcweir 				sal_Int32 nValue;
235cdf0e10cSrcweir 				if( SvXMLUnitConverter::convertNumber( nValue, sValue, 0 ) )
236cdf0e10cSrcweir 					aDetectiveOp.nIndex = nValue;
237cdf0e10cSrcweir 			}
238cdf0e10cSrcweir 			break;
239cdf0e10cSrcweir 		}
240cdf0e10cSrcweir 	}
241cdf0e10cSrcweir 	ScUnoConversion::FillScAddress( aDetectiveOp.aPosition, rImport.GetTables().GetRealCellPos() );
242cdf0e10cSrcweir }
243cdf0e10cSrcweir 
~ScXMLDetectiveOperationContext()244cdf0e10cSrcweir ScXMLDetectiveOperationContext::~ScXMLDetectiveOperationContext()
245cdf0e10cSrcweir {
246cdf0e10cSrcweir }
247cdf0e10cSrcweir 
CreateChildContext(sal_uInt16 nPrefix,const OUString & rLName,const uno::Reference<xml::sax::XAttributeList> &)248cdf0e10cSrcweir SvXMLImportContext *ScXMLDetectiveOperationContext::CreateChildContext(
249cdf0e10cSrcweir 		sal_uInt16 nPrefix,
250cdf0e10cSrcweir 		const OUString& rLName,
251cdf0e10cSrcweir         const uno::Reference< xml::sax::XAttributeList>& /* xAttrList */ )
252cdf0e10cSrcweir {
253cdf0e10cSrcweir 	return new SvXMLImportContext( GetImport(), nPrefix, rLName );
254cdf0e10cSrcweir }
255cdf0e10cSrcweir 
EndElement()256cdf0e10cSrcweir void ScXMLDetectiveOperationContext::EndElement()
257cdf0e10cSrcweir {
258cdf0e10cSrcweir 	if( bHasType && (aDetectiveOp.nIndex >= 0) )
259cdf0e10cSrcweir 		GetScImport().GetDetectiveOpArray()->AddDetectiveOp( aDetectiveOp );
260cdf0e10cSrcweir }
261cdf0e10cSrcweir 
262