/// <summary> /// 切换cell事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void fpSpread1_Change(object sender, FarPoint.Win.Spread.ChangeEventArgs e) { if (e.Column == 5) { if (this.fpSpread1_Sheet1.GetText(e.Row, e.Column).ToUpper() == "TRUE") { this.fpSpread1_Sheet1.SetValue(e.Row, 6, false, false); this.fpSpread1_Sheet1.SetValue(e.Row, 7, false, false); } } else if (e.Column == 6) { if (this.fpSpread1_Sheet1.GetText(e.Row, e.Column).ToUpper() == "TRUE") { this.fpSpread1_Sheet1.SetValue(e.Row, 5, false, false); this.fpSpread1_Sheet1.SetValue(e.Row, 7, false, false); } } else if (e.Column == 7) { if (this.fpSpread1_Sheet1.GetText(e.Row, e.Column).ToUpper() == "TRUE") { this.fpSpread1_Sheet1.SetValue(e.Row, 5, false, false); this.fpSpread1_Sheet1.SetValue(e.Row, 6, false, false); } } }
private void neuSpread1_Change(object sender, FarPoint.Win.Spread.ChangeEventArgs e) { int rowIdx = 0; int colIdx = 0; rowIdx = neuSpread1_Sheet1.ActiveRowIndex; colIdx = neuSpread1_Sheet1.ActiveColumnIndex; if (colIdx != 10) { #region //if (System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 4].Value) + // System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 5].Value) + // System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 6].Value) - // System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 7].Value) - // System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 8].Value) > 0) //{ #endregion neuSpread1_Sheet1.Cells[rowIdx, 10].Value = System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 4].Value) + System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 5].Value) + System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 6].Value) - System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 7].Value) - System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 8].Value); #region //} //else //{ // MessageBox.Show("输入有误将会使期末实有病人数为负!"); // neuSpread1.SetActiveCell(e.Row,e.Column); // neuSpread1.EditMode = true; //} #endregion } else { if (System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 10].Value) != System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 4].Value) + System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 5].Value) + System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 6].Value) - System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 7].Value) - System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 8].Value)) { #region //if (MessageBox.Show("期末实有病人数有误差,是否修改原有病人数!", "错误", MessageBoxButtons.YesNo, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1) == DialogResult.Yes) //{ #endregion ///为保证等式的成立设为原与人数是不确定的,发现存在误差修改原有人数 neuSpread1_Sheet1.Cells[rowIdx, 4].Value = System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 10].Value) - System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 5].Value) - System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 6].Value) + System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 7].Value) + System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 8].Value); #region //} //else //{ // neuSpread1.SetActiveCell(rowIdx, 10); // neuSpread1.EditMode = true; //} #endregion } } }
private void GrdView_Change(object sender, FarPoint.Win.Spread.ChangeEventArgs e) { GrdView.ActiveSheet.SetText(e.Row, liColFlag, "1"); GrdView.ActiveSheet.Cells[e.Row, liColCode, e.Row, liColFlag].ForeColor = Color.Red; GrdView.ActiveSheet.Cells[e.Row, liColCode, e.Row, liColFlag].Font = new Font("Microsoft Sans Serif", 8, FontStyle.Bold); }