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 EsFormula() => Celdas.Count() > 0 || CeldasCondicion.Count() > 0;