/// <summary> /// Mets les ranges selectionnés dans le presse-papier. /// </summary> /// <param name="range"></param> public static void SetRange(Ui.Office.Range range) { if (range == null) { return; } ClearClipboard(); System.Windows.Clipboard.SetData(RANGE_CLIPBOARD_FORMAT, range); }
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; } }
public TableActionData(int oid, Ui.Office.Range range) : this() { this.oids.Add(oid); this.range = range; }