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); } }
public static CellValue GetOrderCellValue(CellsKind cell, List <OrderItem> orderItems, Worksheet invoice) { var range = CellsHelper.GetActualCellRange(CellsHelper.FindLeftCell(cell), orderItems.Any() ? orderItems.Count : 0); return(invoice.Cells[range].Value); }