To reproduce: please refer to the attached sample project. Workaround: this.radGridView1.TableElement.ScrollToRow(this.radGridView1.RowCount-1);
Attached project for reproducing. Workaround: var column = radGridView1.Columns[2] as GridViewDecimalColumn; var format = column.FormatString; column.FormatString = ""; column.ExcelExportType = DisplayFormatType.Currency; //export the grid column.FormatString = format;
Please refer to the attached sample project and follow the steps illustrated in the attached gif file.
To reproduce:
- Add a grid to a PageView and add the pageView to a dock window at run time.
- The grid should not be visible.
- Set your DPI setting to 150%
Workaround:
class MyViewDefinition : TableViewDefinition
{
public override IRowView CreateViewUIElement(GridViewInfo viewInfo)
{
return new MyTableElement();
}
}
class MyTableElement : GridTableElement
{
public override void DpiScaleChanged(SizeF scaleFactor)
{
if (this.ViewTemplate != null)
{
base.DpiScaleChanged(scaleFactor);
}
}
protected override Type ThemeEffectiveType
{
get { return typeof(GridTableElement); }
}
}
//use the above definition like this:
radGridView1.ViewDefinition = new MyViewDefinition();
To reproduce:
public Form1()
{
InitializeComponent();
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("ParentId", typeof(int));
for (int i = 0; i < 3; i++)
{
dt.Rows.Add(i, "Parent" + i, -1);
}
Random rand = new Random();
for (int i = 3; i < 15; i++)
{
dt.Rows.Add(i,"Child"+i,rand.Next(0,3));
}
this.radGridView1.Relations.AddSelfReference(this.radGridView1.MasterTemplate, "Id", "ParentId");
this.radGridView1.DataSource = dt;
this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.radGridView1.EnableGrouping = true;
this.radGridView1.EnableCustomGrouping = true;
this.radGridView1.CustomGrouping+=radGridView1_CustomGrouping;
}
private void radGridView1_CustomGrouping(object sender, GridViewCustomGroupingEventArgs e)
{
}
To reproduce: 1. Bind RadGridView to the Northwind.Customers table. 2. Activate the editor for some of the cells from the CustomerID column. 3. Enter "ALFKI" which already exists. The DataError event is supposed to be fired in this case. If you set the GridViewDataErrorEventArgs.ThrowException argument to true the exception is supposed to be thrown. However, nothing happens. Please refer to the attached sample project.
How to reproduce check the attached project:
Workaround: Create a custom spread export renderer
public class MySpreadExportRenderer : SpreadExportRenderer
{
public override void AddWorksheet(string sheetName)
{
string name = "";
Workbook wb = (Workbook)typeof(SpreadExportRenderer).GetField("workbook", BindingFlags.Instance | BindingFlags.NonPublic).GetValue(this);
if (sheetName == null || sheetName == string.Empty)
{
name = "Sheet_" + (wb.Worksheets.Count + 1);
}
else
{
name = sheetName;
}
if (wb.Worksheets.Where(w => w.Name == name).ToList().Count == 0)
{
base.AddWorksheet(sheetName);
}
else
{
typeof(SpreadExportRenderer).GetField("worksheet", BindingFlags.Instance | BindingFlags.NonPublic).SetValue(this, wb.Worksheets.Add());
}
}
}
Please refer to the attached sample project and follow the steps in the gif file.
1. Open two MDI child forms.
2. Activate the first form and right click on the grid in order to show the context menu and add a shortcut to the menu item. Press Ctrl+N in order to add some new rows to the first grid.
3. Activate the second form and right click on the grid in order to show the context menu and add a shortcut to the menu item. Press Ctrl+N in order to add some new rows to the second grid. However, you will notice that the first several shortcuts combinations are executed for the first grid and then for the active second grid.
Workaround: clear the shortcut when the form is deactivated:
this.Deactivate += GridForm_Deactivate;
private void GridForm_Deactivate(object sender, EventArgs e)
{
item.Shortcuts.Clear();
}
private void GridForm_Activated(object sender, EventArgs e)
{
this.ActiveControl = this.radGridView1;
}
RadMenuItem item = new RadMenuItem();
private void radGridView1_ContextMenuOpening(object sender, Telerik.WinControls.UI.ContextMenuOpeningEventArgs e)
{
item.Text = "insert row";
item.Shortcuts.Add(new RadShortcut(Keys.Control, Keys.N));
item.Click += item_Click;
e.ContextMenu.Items.Add(item);
}
To reproduce: please refer to the attached gif file.
Workaround:
public RadForm1()
{
InitializeComponent();
this.radGridView1.CellClick+=radGridView1_CellClick;
}
private void radGridView1_CellClick(object sender, Telerik.WinControls.UI.GridViewCellEventArgs e)
{
if (e.Column is Telerik.WinControls.UI.GridViewRowHeaderColumn)
{
this.radGridView1.CloseEditor();
}
}
Workaround:
Friend Class MyRadGridView
Inherits RadGridView
Public Overrides Property ThemeClassName As String
Get
Return GetType(RadGridView).FullName
End Get
Set(value As String)
MyBase.ThemeClassName = value
End Set
End Property
Protected Overrides Function CreateGridViewElement() As RadGridViewElement
Return New MyRadGridViewElement()
End Function
End Class
Friend Class MyRadGridViewElement
Inherits RadGridViewElement
Protected Overrides ReadOnly Property ThemeEffectiveType() As Type
Get
Return GetType(RadGridViewElement)
End Get
End Property
Protected Overrides Function CreateGroupPanelElement() As GroupPanelElement
Return New MyGroupPanelElement()
End Function
End Class
Friend Class MyGroupPanelElement
Inherits GroupPanelElement
Protected Overrides ReadOnly Property ThemeEffectiveType() As Type
Get
Return GetType(GroupPanelElement)
End Get
End Property
Protected Overrides Function ArrangeOverride(finalSize As SizeF) As SizeF
Dim clientRect As RectangleF = Me.GetClientRectangle(finalSize)
Dim sizeGripRect As New RectangleF(clientRect.X, clientRect.Bottom - Me.SizeGrip.DesiredSize.Height, clientRect.Width, Me.SizeGrip.DesiredSize.Height)
Me.SizeGrip.Arrange(sizeGripRect)
clientRect.Height -= Me.SizeGrip.DesiredSize.Height
Dim groupHeaderRect As New RectangleF(clientRect.X, clientRect.Y, Me.Header.DesiredSize.Width, clientRect.Height)
Me.Header.Arrange(groupHeaderRect)
clientRect.Width -= Me.Header.DesiredSize.Width
Dim scrollViewRect As New RectangleF(clientRect.X + Me.Header.DesiredSize.Width, clientRect.Y, clientRect.Width, clientRect.Height)
If scrollViewRect.Width > 20 Then
Me.ScrollView.Arrange(scrollViewRect)
End If
Return finalSize
End Function
End Class
Steps to reproduce:
1. Add RadGridView and populate with data
2. Show the context menu many times. Sometimes the popup is not shown correctly.
If you click again, the popup is visible correctly.
Workaround:
Set the AnimationEnabled property to false or the AnimationType property to None. Here is the code snippet how can be achieve it:
//Set the AnimationEnabled to false
void radGridView1_ContextMenuOpening(object sender, Telerik.WinControls.UI.ContextMenuOpeningEventArgs e)
{
RadDropDownMenu contextMenu = e.ContextMenu as RadDropDownMenu;
contextMenu.AnimationEnabled = false;
}
//Set the AnimationType to None
void radGridView1_ContextMenuOpening(object sender, Telerik.WinControls.UI.ContextMenuOpeningEventArgs e)
{
RadDropDownMenu contextMenu = e.ContextMenu as RadDropDownMenu;
contextMenu.AnimationType = PopupAnimationTypes.None;
}
How to reproduce: check the attached video
Workaround: disable pinning of the last row when it is in a group
public partial class Form1 : Form
{
DataTable dt;
public Form1()
{
InitializeComponent();
this.radGridView1.DataSource = this.GetData();
this.radGridView1.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;
this.radGridView1.ContextMenuOpening += RadGridView1_ContextMenuOpening;
}
private void RadGridView1_ContextMenuOpening(object sender, Telerik.WinControls.UI.ContextMenuOpeningEventArgs e)
{
GridRowHeaderCellElement header = e.ContextMenuProvider as GridRowHeaderCellElement;
if (header != null && header.RowInfo.Group != null)
{
var notPinned = header.RowInfo.Group.GroupRow.ChildRows.Where(r => r.IsPinned == false).ToList();
if (notPinned.Count <= 1)
{
e.ContextMenu.Items.RemoveAt(0);
e.ContextMenu.Items.RemoveAt(0);
}
}
}
private DataTable GetData()
{
dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Date", typeof(DateTime));
dt.Columns.Add("Bool", typeof(bool));
for (int i = 0; i < 2; i++)
{
for (int j = 0; j < 2; j++)
{
dt.Rows.Add(i, "Name " + i + " " + j, DateTime.Now.AddDays(i), i % 2 == 0);
}
}
return dt;
}
}
How to reproduce:
public partial class Form1 : Form
{
DataTable dt;
public Form1()
{
InitializeComponent();
this.radGridView1.DataSource = this.GetData();
this.radGridView1.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;
}
private void radButton1_Click(object sender, EventArgs e)
{
dt.Clear();
for (int i = 0; i < 100; i++)
{
dt.Rows.Add(i, "New Name " + i, DateTime.Now.AddDays(i), i % 2 == 0);
}
}
private DataTable GetData()
{
dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Date", typeof(DateTime));
dt.Columns.Add("Bool", typeof(bool));
for (int i = 0; i < 500; i++)
{
dt.Rows.Add(i, "Name " + i, DateTime.Now.AddDays(i), i % 2 == 0);
}
return dt;
}
}
Workaround:
public partial class Form1 : Form
{
DataTable dt;
public Form1()
{
InitializeComponent();
this.radGridView1.DataSource = this.GetData();
this.radGridView1.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;
this.radGridView1.RowsChanged += RadGridView1_RowsChanged;
}
private void RadGridView1_RowsChanged(object sender, Telerik.WinControls.UI.GridViewCollectionChangedEventArgs e)
{
if (e.Action == Telerik.WinControls.Data.NotifyCollectionChangedAction.Reset)
{
this.radGridView1.MasterView.PinnedRows.GetType().GetMethod("Clear", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic)
.Invoke(this.radGridView1.MasterView.PinnedRows, new object[] { });
}
}
private void radButton1_Click(object sender, EventArgs e)
{
dt.Clear();
for (int i = 0; i < 100; i++)
{
dt.Rows.Add(i, "New Name " + i, DateTime.Now.AddDays(i), i % 2 == 0);
}
}
private DataTable GetData()
{
dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Date", typeof(DateTime));
dt.Columns.Add("Bool", typeof(bool));
for (int i = 0; i < 500; i++)
{
dt.Rows.Add(i, "Name " + i, DateTime.Now.AddDays(i), i % 2 == 0);
}
return dt;
}
}
Workaround:
AddHandler Me.RadGridView1.CreateCompositeFilterDialog, AddressOf CreateCompositeFilterDialog
Private Sub CreateCompositeFilterDialog(sender As Object, e As GridViewCreateCompositeFilterDialogEventArgs)
Dim dialog As New CompositeDataFilterForm()
AddHandler dialog.DataFilter.EditorRequired, AddressOf EditorRequired
e.Dialog = dialog
End Sub
Private Sub EditorRequired(sender As Object, e As TreeNodeEditorRequiredEventArgs)
Dim filterNode As DataFilterCriteriaNode = TryCast(e.Node, DataFilterCriteriaNode)
If filterNode IsNot Nothing AndAlso filterNode.PropertyName = "BASE_NULL_DATE" AndAlso TypeOf sender Is DataFilterValueEditorElement Then
e.Editor = New TreeViewDateTimeEditor()
End If
End Sub
To reproduce: please refer to the attached sample project and follow the described steps in the .doc file located in the zip.
Workaround:
protected override void OnActivated(EventArgs e)
{
base.OnActivated(e);
this.ActiveControl = this.gvDetails;
}
private void gvDetails_LostFocus(object sender, EventArgs e)
{
((ComponentBehavior)gvDetails.Behavior).GetType().GetProperties(BindingFlags.NonPublic | BindingFlags.Instance);
PropertyInfo barProperty = ((ComponentBehavior)gvDetails.Behavior).GetType().GetProperty("ScreenPresenter",
BindingFlags.NonPublic | BindingFlags.Instance);
Form screenTip = barProperty.GetValue(((ComponentBehavior)gvDetails.Behavior), null) as Form;
screenTip.Hide();
}
To reproduce: please open the attached sample project and follow the steps illustrated in the attached gif file.
Workaround:
1. You still can scroll while dragging a row by using the mouse wheel.
2. Use the grid in unbound mode and set the AllowRowReorder property to true instead of using a custom RadDragDropService.
3. Use a custom drag and drop service:
public class CustomDragDropService : RadGridViewDragDropService
{
public CustomDragDropService(RadGridViewElement gridViewElement) : base(gridViewElement)
{
}
public override string Name
{
get
{
return typeof(RadGridViewDragDropService).Name;
}
}
protected override void HandleMouseMove(System.Drawing.Point mousePosition)
{
base.HandleMouseMove(mousePosition);
System.Drawing.Point location = this.GridViewElement.ElementTree.Control.PointToClient(Control.MousePosition);
GridTableElement tableElement = this.GetTableElementAtPoint(location);
ISupportDrag supportDrag = this.Context as ISupportDrag;
object dataContext = supportDrag.GetDataContext();
if (this.AllowAutoScrollRowsWhileDragging && dataContext == null)
{
ScrollRows(tableElement, location);
}
}
private void ScrollRows(GridTableElement tableElement, System.Drawing.Point location)
{
ScrollableRowsContainerElement scrollableRows = tableElement.ViewElement.ScrollableRows;
RadScrollBarElement vScrollbar = GetVeritcalScrollbar(tableElement);
System.Drawing.Rectangle containerBounds = scrollableRows.ControlBoundingRectangle;
if (containerBounds.Contains(location) ||
location.X < containerBounds.X ||
location.X > containerBounds.Right)
{
return;
}
int delta = 0;
if (location.Y > containerBounds.Bottom)
{
delta = location.Y - containerBounds.Bottom;
}
else if (location.Y < containerBounds.Y)
{
delta = location.Y - containerBounds.Y;
}
if (delta != 0 && vScrollbar.Visibility == ElementVisibility.Visible)
{
vScrollbar.Value = ClampValue(vScrollbar.Value + delta,
vScrollbar.Minimum,
vScrollbar.Maximum - vScrollbar.LargeChange + 1);
}
}
private int ClampValue(int value, int minimum, int maximum)
{
if (value < minimum)
{
return minimum;
}
if (maximum > 0 && value > maximum)
{
return maximum;
}
return value;
}
private RadScrollBarElement GetVeritcalScrollbar(GridTableElement tableElement)
{
if (GridViewElement.UseScrollbarsInHierarchy)
{
return tableElement.VScrollBar;
}
return GridViewElement.TableElement.VScrollBar;
}
}
public RadForm1()
{
InitializeComponent();
CustomDragDropService customService = new CustomDragDropService(radGridView1.GridViewElement);
radGridView1.GridViewElement.RegisterService(customService);
}
To reproduce: please refer to the attached sample project. Note that the CellValidating event is fired twice even without showing a RadMessageBox. With an MS Button the problem is not reproducible.
Workaround: use the RadGridView.ValueChanging event to perform validation while the user is typing in the active editor:
private void radGridView1_ValueChanging(object sender, Telerik.WinControls.UI.ValueChangingEventArgs e)
{
if (((string)e.NewValue) != "x")
{
RadMessageBox.Show("Only 'x' allowed!");
e.Cancel = true;
}
}
To reproduce: please refer to the attached sample project and gif file.
Workaround: use the CellFormatting event and apply the light orange BackColor for the selected cells belonging to the current pinned column:
private void radGridView1_CellFormatting(object sender, Telerik.WinControls.UI.CellFormattingEventArgs e)
{
if (e.Row.IsSelected && e.Column.IsCurrent)
{
e.CellElement.BackColor = Color.FromArgb(255, 231, 174);
}
else
{
e.CellElement.ResetValue(LightVisualElement.BackColorProperty, ValueResetFlags.Local);
}
}