private void spreadsheetControl_CustomCellEdit(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCustomCellEditEventArgs e) { if (e.ColumnIndex == 0) { RepositoryItemTextEdit repository = new RepositoryItemTextEdit(); repository.AutoHeight = false; repository.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder; Style thisCellsStyle = e.Cell.Style; string thisCellsFormat = thisCellsStyle.NumberFormat; string thisCellsStyleName = thisCellsStyle.Name; thisCellsFormat = e.Cell.NumberFormat; bool thisCellIsLocked = e.Cell.Protection.Locked; IList <DevExpress.Spreadsheet.Comment> comments = spreadsheetControl.ActiveWorksheet.Comments.GetComments(spreadsheetControl.ActiveCell); string thisCellsNote = comments[0].Text; // hardcoding '0' only works because there is only one ActiveCell if (thisCellsFormat == "") { repository.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None; } else { repository.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; repository.Mask.EditMask = thisCellsFormat; } e.RepositoryItem = repository; } }
private void spreadsheetControl1_CustomCellEdit(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCustomCellEditEventArgs e) { // Specify a type of the custom editor assigned to cells of the "Quantity" table column. // To identify the custom editor, use a value of ValueObject associated with it. if (e.ValueObject.IsText && e.ValueObject.TextValue == "MySpinEdit") { // Create a repository item corresponding to a SpinEdit control and specify its settings. RepositoryItemSpinEdit repository = new RepositoryItemSpinEdit(); repository.AutoHeight = false; repository.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder; repository.MinValue = 1; repository.MaxValue = 1000; repository.IsFloatValue = false; // Assign the SpinEdit editor to a cell. e.RepositoryItem = repository; } }