/* ====================================================================
|
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.
|
==================================================================== */
|
namespace HH.WMS.Utils.NPOI.SS.Formula
|
{
|
|
using System;
|
using System.Text;
|
using System.Collections;
|
|
[Serializable]
|
public class WorkbookNotFoundException : Exception
|
{
|
public WorkbookNotFoundException(String msg):base(msg)
|
{
|
|
}
|
}
|
/**
|
* Manages a collection of {@link WorkbookEvaluator}s, in order To support evaluation of formulas
|
* across spreadsheets.<p/>
|
*
|
* For POI internal use only
|
*
|
* @author Josh Micich
|
*/
|
public class CollaboratingWorkbooksEnvironment
|
{
|
|
public static CollaboratingWorkbooksEnvironment EMPTY = new CollaboratingWorkbooksEnvironment();
|
|
private Hashtable _evaluatorsByName;
|
private WorkbookEvaluator[] _evaluators;
|
|
private bool _unhooked;
|
private CollaboratingWorkbooksEnvironment()
|
{
|
_evaluatorsByName = new Hashtable();
|
_evaluators = new WorkbookEvaluator[0];
|
}
|
public static void Setup(String[] workbookNames, WorkbookEvaluator[] evaluators)
|
{
|
int nItems = workbookNames.Length;
|
if (evaluators.Length != nItems)
|
{
|
throw new ArgumentException("Number of workbook names is " + nItems
|
+ " but number of evaluators is " + evaluators.Length);
|
}
|
if (nItems < 1)
|
{
|
throw new ArgumentException("Must provide at least one collaborating worbook");
|
}
|
CollaboratingWorkbooksEnvironment env = new CollaboratingWorkbooksEnvironment(workbookNames, evaluators, nItems);
|
HookNewEnvironment(evaluators, env);
|
}
|
|
private CollaboratingWorkbooksEnvironment(String[] workbookNames, WorkbookEvaluator[] evaluators, int nItems)
|
{
|
Hashtable m = new Hashtable(nItems * 3 / 2);
|
Hashtable uniqueEvals = new Hashtable(nItems * 3 / 2);
|
for (int i = 0; i < nItems; i++)
|
{
|
String wbName = workbookNames[i];
|
WorkbookEvaluator wbEval = evaluators[i];
|
if (m.ContainsKey(wbName))
|
{
|
throw new ArgumentException("Duplicate workbook name '" + wbName + "'");
|
}
|
if (uniqueEvals.ContainsKey(wbEval))
|
{
|
String msg = "Attempted To register same workbook under names '"
|
+ uniqueEvals[(wbEval) + "' and '" + wbName + "'"];
|
throw new ArgumentException(msg);
|
}
|
uniqueEvals[wbEval]=wbName;
|
m[wbName] = wbEval;
|
}
|
UnhookOldEnvironments(evaluators);
|
//HookNewEnvironment(evaluators, this); - moved to Setup method above
|
_unhooked = false;
|
_evaluators = evaluators;
|
_evaluatorsByName = m;
|
}
|
|
private static void HookNewEnvironment(WorkbookEvaluator[] evaluators, CollaboratingWorkbooksEnvironment env)
|
{
|
|
// All evaluators will need To share the same cache.
|
// but the cache takes an optional evaluation listener.
|
int nItems = evaluators.Length;
|
IEvaluationListener evalListener = evaluators[0].GetEvaluationListener();
|
// make sure that all evaluators have the same listener
|
for (int i = 0; i < nItems; i++)
|
{
|
if (evalListener != evaluators[i].GetEvaluationListener())
|
{
|
// This would be very complex To support
|
throw new Exception("Workbook evaluators must all have the same evaluation listener");
|
}
|
}
|
EvaluationCache cache = new EvaluationCache(evalListener);
|
|
for (int i = 0; i < nItems; i++)
|
{
|
evaluators[i].AttachToEnvironment(env, cache, i);
|
}
|
|
}
|
private void UnhookOldEnvironments(WorkbookEvaluator[] evaluators)
|
{
|
ArrayList oldEnvs = new ArrayList();
|
for (int i = 0; i < evaluators.Length; i++)
|
{
|
oldEnvs.Add(evaluators[i].GetEnvironment());
|
}
|
CollaboratingWorkbooksEnvironment[] oldCWEs = new CollaboratingWorkbooksEnvironment[oldEnvs.Count];
|
oldCWEs = (CollaboratingWorkbooksEnvironment[])oldEnvs.ToArray(typeof(CollaboratingWorkbooksEnvironment));
|
for (int i = 0; i < oldCWEs.Length; i++)
|
{
|
oldCWEs[i].Unhook();
|
}
|
}
|
|
/**
|
*
|
*/
|
private void Unhook()
|
{
|
if (_evaluators.Length < 1)
|
{
|
return;
|
}
|
for (int i = 0; i < _evaluators.Length; i++)
|
{
|
_evaluators[i].DetachFromEnvironment();
|
}
|
_unhooked = true;
|
}
|
|
public WorkbookEvaluator GetWorkbookEvaluator(String workbookName)
|
{
|
if (_unhooked)
|
{
|
throw new InvalidOperationException("This environment Has been unhooked");
|
}
|
WorkbookEvaluator result;
|
if (_evaluatorsByName.ContainsKey(workbookName))
|
{
|
result = (WorkbookEvaluator)_evaluatorsByName[workbookName];
|
}
|
else
|
{
|
StringBuilder sb = new StringBuilder(256);
|
sb.Append("Could not resolve external workbook name '").Append(workbookName).Append("'.");
|
if (_evaluators.Length < 1)
|
{
|
sb.Append(" Workbook environment has not been set up.");
|
}
|
else
|
{
|
sb.Append(" The following workbook names are valid: (");
|
IEnumerator i = _evaluatorsByName.Keys.GetEnumerator();
|
int count = 0;
|
while (i.MoveNext())
|
{
|
if (count++ > 0)
|
{
|
sb.Append(", ");
|
}
|
sb.Append("'").Append(i.Current).Append("'");
|
}
|
sb.Append(")");
|
}
|
throw new WorkbookNotFoundException(sb.ToString());
|
}
|
return result;
|
}
|
}
|
}
|
