/* ====================================================================
|
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 HH.WMS.Utils.NPOI.SS.Formula.Eval;
|
using HH.WMS.Utils.NPOI.SS.UserModel;
|
using HH.WMS.Utils.NPOI.SS.Formula;
|
using HH.WMS.Utils.NPOI.SS.Formula.PTG;
|
/**
|
*
|
*
|
* @author Josh Micich
|
*/
|
public class SheetRefEvaluator
|
{
|
|
private WorkbookEvaluator _bookEvaluator;
|
private EvaluationTracker _tracker;
|
private IEvaluationSheet _sheet;
|
private int _sheetIndex;
|
|
public SheetRefEvaluator(WorkbookEvaluator bookEvaluator, EvaluationTracker tracker, int sheetIndex)
|
{
|
if (sheetIndex < 0)
|
{
|
throw new ArgumentException("Invalid sheetIndex: " + sheetIndex + ".");
|
}
|
_bookEvaluator = bookEvaluator;
|
_tracker = tracker;
|
_sheetIndex = sheetIndex;
|
}
|
|
public String SheetName
|
{
|
get
|
{
|
return _bookEvaluator.GetSheetName(_sheetIndex);
|
}
|
}
|
|
public ValueEval GetEvalForCell(int rowIndex, int columnIndex)
|
{
|
return _bookEvaluator.EvaluateReference(this.Sheet, _sheetIndex, rowIndex, columnIndex, _tracker);
|
}
|
|
private IEvaluationSheet Sheet
|
{
|
get
|
{
|
if (_sheet == null)
|
{
|
_sheet = _bookEvaluator.GetSheet(_sheetIndex);
|
}
|
return _sheet;
|
}
|
}
|
|
/**
|
* @return whether cell at rowIndex and columnIndex is a subtotal
|
* @see org.apache.poi.ss.formula.functions.Subtotal
|
*/
|
public bool IsSubTotal(int rowIndex, int columnIndex)
|
{
|
bool subtotal = false;
|
IEvaluationCell cell = Sheet.GetCell(rowIndex, columnIndex);
|
if (cell != null && cell.CellType == CellType.FORMULA)
|
{
|
IEvaluationWorkbook wb = _bookEvaluator.Workbook;
|
foreach (Ptg ptg in wb.GetFormulaTokens(cell))
|
{
|
if (ptg is FuncVarPtg)
|
{
|
FuncVarPtg f = (FuncVarPtg)ptg;
|
if ("SUBTOTAL".Equals(f.Name))
|
{
|
subtotal = true;
|
break;
|
}
|
}
|
}
|
}
|
return subtotal;
|
}
|
}
|
}
|
