public void setFormulaExcel()
{
if (EsValida() && EsFormula())
{
FormulaExcel = (CeldasCondicion.Count() > 0) ? $"IF({CeldasCondicion.ToString(Condicion, true)},{Celdas.ToString(Formula)},0)" : Celdas.ToString(Formula);
}
if (EsValida() && !EsFormula())
{
FormulaExcel = Formula.Split('=')[1];
}
}
public void setFormulaExcel()
{
FormulaExcel = CeldasFormula.ToString(Formula, true);
CondicionExcel = (CeldasCondicion.Count() > 0 && CeldasCondicion.Where(o => o.Fila == -1).Count() == 0) ? CeldasCondicion.ToString(Condicion, true) : "";
}
public bool EsValida() => Celdas.Where(o => o.Fila == -1).Count() == 0 && CeldasCondicion.Where(o => o.Fila == -1).Count() == 0;
public bool EsFormula() => Celdas.Count() > 0 || CeldasCondicion.Count() > 0;
