private void SetFormula_Circular() { string[] strArr = new string[FpSpread1.ActiveSheetView.RowCount]; string[] strArrsumAC = new string[FpSpread1.ActiveSheetView.RowCount]; for (int i = 0; i < FpSpread1.ActiveSheetView.RowCount; i++) { if (!string.IsNullOrEmpty(FpSpread1.ActiveSheetView.Cells[i, 7].Text)) strArr[i] = FpSpread1.ActiveSheetView.Cells[i, 7].Text; if (!string.IsNullOrEmpty(FpSpread1.ActiveSheetView.Cells[i, 8].Text)) strArrsumAC[i] = FpSpread1.ActiveSheetView.Cells[i, 8].Text.Replace("$",""); } decimal sumForecast_Cost = 0; for (int j = 0; j < strArr.Length; j++) { sumForecast_Cost = sumForecast_Cost + Convert.ToDecimal(strArr[j]); } txtProjectedCost.Text = Convert.ToString(sumForecast_Cost); decimal sumActualCost = 0; for (int j = 0; j < strArrsumAC.Length; j++) { sumActualCost = sumActualCost + Convert.ToDecimal(strArrsumAC[j]); } txtActualCost.Text = Convert.ToString(sumActualCost); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)