/// <summary>
/// Adds another formula as a parameter in a formula
/// </summary>
/// <param name="formula">Another formula to add to this formula's parameter list</param>
public Formula Add(Formula formula)
{
Parameter p = new Parameter(formula);
Parameters.Add(p);
return this;
}
/// <summary>
/// Adds a range as a parameter in a formula
/// </summary>
/// <param name="range">Range to add as parameter</param>
public Formula Add(Range range)
{
Parameter p = new Parameter(range);
Parameters.Add(p);
return this;
}
/// <summary>
/// Adds a string as a parameter in a formula
/// </summary>
/// <param name="parameter">String to add as parameter</param>
public Formula Add(string parameter)
{
Parameter p = new Parameter(parameter);
Parameters.Add(p);
return this;
}
/// <summary>
/// Adds a cell as a parameter in a formula
/// </summary>
/// <param name="cell">Cell to add as parameter</param>
public Formula Add(Cell cell)
{
Parameter p = new Parameter(new Range(cell));
Parameters.Add(p);
return this;
}
/// <summary>
/// Adds a empty group to the formula
/// </summary>
/// <returns></returns>
public Formula EmptyGroup()
{
Parameter p = new Parameter("()");
Parameters.Add(p);
return this;
}
/// <summary>
/// Ends a group
/// </summary>
public Formula EndGroup()
{
Parameter p = new Parameter(')');
Parameters.Add(p);
return this;
}
/// <summary>
/// Starts a new group
/// </summary>
public Formula StartGroup()
{
Parameter p = new Parameter('(');
Parameters.Add(p);
return this;
}
/// <summary>
/// Adds a operator as a parameter in a formula
/// </summary>
/// <param name="op">Operator to add as parameter</param>
public Formula Operator(char op)
{
Parameter p = new Parameter(op);
Parameters.Add(p);
return this;
}