public void CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e) { if (!AllowChangeOrder()) { return; } string reference = e.Cell.GetReferenceA1(); var oldCustomerId = order.CustomerId; string shiftedRange = CellsHelper.GetActualCellRange(reference, actualOrderItems.Any() ? -actualOrderItems.Count : 0); if (OrderPropertiesHelper.Setters.ContainsKey(shiftedRange)) { OrderPropertiesHelper.Setters[shiftedRange].Invoke(order, e.Cell.Value, source); if (CellsHelper.HasDependentCells(shiftedRange)) { if (order.CustomerId != oldCustomerId) { UpdateCustomerStores(); } CellsHelper.UpdateDependentCells(Invoice, order, source); UpdateTotalValues(); } } if (IsOrderItemsRegionModified(e.Cell)) { UpdateOrderItem(e.Cell); } }
void spreadsheetControl_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e) { if ((e.ColumnIndex == 4) && ((e.RowIndex >= 3) && (e.RowIndex <= 8))) { spreadsheetControl.BeginUpdate(); generator.Generate(); spreadsheetControl.EndUpdate(); } }
private void spreadsheetControl1_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e) { IWorkbook workbook2 = spreadsheetControl1.Document; Worksheet sheet2_0 = workbook2.Worksheets[0]; if (sheet2_0.Cells[2, 0].Value.ToString() == null || sheet2_0.Cells[2, 0].Value.ToString() == "") { CoFAS_DevExpressManager.ShowInformationMessage("엑셀 시트를 불러와주시기 바랍니다."); return; } int click_col = 0; int click_row = 0; click_col = spreadsheetControl1.ActiveWorksheet[spreadsheetControl1.ActiveCell.GetReferenceA1()].RightColumnIndex; click_row = spreadsheetControl1.ActiveWorksheet[spreadsheetControl1.ActiveCell.GetReferenceA1()].TopRowIndex; if (click_col == 2 && click_row < 178) { lock (this) { showMsg method = delegate { string str = sheet2_0.Cells[click_row, click_col].Value.ToString(); sheet2_0.Cells[click_row, click_col].SetValue(str); // sheet2_0. bool check; check = str.Contains(sheet2_0.Cells[click_row, 0].Value.ToString()); if (check) { sheet2_0.Cells[click_row, click_col + 1].SetValue("Y"); sheet2_0.Cells[click_row, click_col + 1].Font.Color = Color.White; sheet2_0.Cells[click_row, click_col + 1].Fill.BackgroundColor = Color.Green; } else { sheet2_0.Cells[click_row, click_col + 1].SetValue("N"); sheet2_0.Cells[click_row, click_col + 1].Font.Color = Color.White; sheet2_0.Cells[click_row, click_col + 1].Fill.BackgroundColor = Color.Red; } //sheet2_0.SelectedCell = sheet2_0.Cells[click_row + 1, click_col]; }; this.BeginInvoke(method); } } else { CoFAS_DevExpressManager.ShowInformationMessage("해당하는 Barcode에 마우스를 클릭해주시기 바랍니다."); return; } }
private void spreadsheetControl1_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e) { Worksheet sheet = spreadsheetControl1.Document.Worksheets[0]; if (e.SheetName == sheet.Name && e.RowIndex == 3 && e.ColumnIndex == 2) { sheet.Columns[2].AutoFit(); sheet.Columns[4].AutoFit(); } }
private void spreadsheetControl_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e) { ExcelEventArg arg = new ExcelEventArg() { }; Range range = GetSelectedRange(); Cell active = getActiveCell(); object value = getValueAt(active.Row, active.Column, getActiveSheetName()); if (value is float || value is double || value is int) { bool availableDigitNumber = validateNumberDigit(value); if (!availableDigitNumber) { var sheet = this.spreadsheetControl.Document.Worksheets[getActiveSheetName()]; sheet.Cells[active.Row - 1, active.Column - 1].Value = e.OldValue; Kernel.Util.MessageDisplayer.DisplayError("Number Digit", "Number of digit is over !"); return; } } //Range previousRange = rangePreviousValue; //IsSameRange = previousRange == range; if (range == null || (rangePreviousValue != null && rangePreviousValue.Name.Equals(range.Name))) { return; } if (range.CellCount > 1) { arg.Range = range; } else { arg.Range = rangePreviousValue; } if (arg.Range == null) { arg.Range = range; } if (arg.Sheet == null) { arg.Sheet = arg.Range.Sheet; } if (ThrowEvent && Edited != null) { Edited(arg); rangePreviousValue = range; } }
private void spreadsheetControl1_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e) { for (int i = 1; i <= parentnode.Nodes.Count; i++) { Register up = new Register(); up.Patient_id = worksheet.GetCellValue(0, i).ToString(); up.Patient_Name = worksheet.GetCellValue(1, i).ToString();; up.Patient_Sex = worksheet.GetCellValue(2, i).ToString(); up.Number = worksheet.GetCellValue(3, i).ToString(); up.Id_Number = worksheet.GetCellValue(4, i).ToString(); up.Date_Of_Birth = worksheet.GetCellValue(5, i).ToString(); Updatedata(up); } MessageBox.Show("修改成功"); }
private void Spreadsheet_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e) { if (e.Worksheet.Index == 0 && e.RowIndex == 7) { return; } else if (e.Worksheet.Index == 1 && e.RowIndex == 8) { return; } else if (e.Worksheet.Index == 2 && e.OldValue.ToString() != "——" && e.ColumnIndex > 1 && e.ColumnIndex < 6 && e.RowIndex > 7 && e.RowIndex < 31) { return; } e.Cell.Value = e.OldValue; }
private void spreadsheetcontrol_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e) { }