void Sheet_CellChanged(object sender, CellChangedEventArgs e) { if (e.PropertyName == "Value") { this.NotifyCellValueChanged(e.Row, e.Column); } }
void Worksheet_CellChanged(object sender, CellChangedEventArgs e) { if (((this._cachRange != null) && (e.PropertyName == "Value")) && (this._cachRange != null)) { CellRange range = new CellRange(e.Row, e.Column, e.RowCount, e.ColumnCount); if (range.Intersects(this._cachRange.Row, this._cachRange.Column, this._cachRange.RowCount, this._cachRange.ColumnCount)) { this.ClearCache(); this.OnDataChanged(); } } }
void Sheet_CellChanged(object sender, CellChangedEventArgs e) { if (e.PropertyName == "Value") { IFloatingObjectSheet sheet = sender as IFloatingObjectSheet; if (this._cachedChangedRanges.ContainsKey(sheet)) { List <ISheetCellRangeMonitorSupport> list = new List <ISheetCellRangeMonitorSupport>(); foreach (ISheetCellRangeMonitorSupport support in this._cachedChangedRanges[sheet]) { if (!list.Contains(support)) { list.Add(support); } } this.RaiseSheetCellRangeSupporterAffected("Value", list.ToArray()); } } }