public CellFormula(Dictionary <string, string> attributes, string formula)
{
foreach (var attribute in attributes)
{
var key = attribute.Key;
var value = attribute.Value;
if (key == "t")
{
FormulaType = ParseCellFormulaType(value);
}
if (key == "ref")
{
RangeOfCells = value;
}
if (key == "ca")
{
CalculateCell = value == "1";
}
if (key == "aca")
{
AlwaysCalculateArray = value == "1";
}
}
Formula = formula;
}
public CellFormula(bool calculateCell, bool alwaysCalculateArray, string rangeOfCells, string formula,
CellFormulaType formulaType)
{
CalculateCell = calculateCell;
AlwaysCalculateArray = alwaysCalculateArray;
RangeOfCells = rangeOfCells;
Formula = formula;
FormulaType = formulaType;
}