Xceed DataGrid for WPF

error: Unable to move to the required generator node by using the current index

Wed, 15 May 2013 15:52:49 GMT

Our QA has reported this error and can't reproduce it. I thought that this is something only Xceed can address.

Details for the error:
Type : Xceed.Wpf.DataGrid.DataGridInternalException, Xceed.Wpf.DataGrid.v4.4, Version=4.4.13057.10310, Culture=neutral, PublicKeyToken=ba83ff368b7563c6
Message : Unable to move to the required generator node by using the current index.
Source : Xceed.Wpf.DataGrid.v4.4
TimeStamp : 05/11/2013 1:26:10 PM

Stack Trace :    at Xceed.Wpf.DataGrid.CustomItemContainerGenerator.StartGenerator(GeneratorPosition startPos, GeneratorDirection direction)
   at Xceed.Wpf.DataGrid.CustomItemContainerGenerator.CustomItemContainerGeneratorDisposableDisposer..ctor(CustomItemContainerGenerator generator, GeneratorPosition startGenPos, GeneratorDirection direction)
   at Xceed.Wpf.DataGrid.CustomItemContainerGenerator.System.Windows.Controls.Primitives.IItemContainerGenerator.StartAt(GeneratorPosition position, GeneratorDirection direction, Boolean allowStartAtRealizedItem)
   at Xceed.Wpf.DataGrid.Views.TableflowViewItemsHost.GenerateContainers(ICustomItemContainerGenerator generator, Int32 pageStartIndex, Int32 pageEndIndex, Boolean measureInvalidated, UIElement& focusedElement)
   at Xceed.Wpf.DataGrid.Views.TableflowViewItemsHost.GeneratePage(Boolean measureInvalidated, Double viewportHeight)
   at Xceed.Wpf.DataGrid.Views.TableflowViewItemsHost.ScrollToVerticalOffset(Double offset, Boolean animate, Nullable`1 scrollingDirection)
   at Xceed.Wpf.DataGrid.Views.TableflowViewItemsHost.System.Windows.Controls.Primitives.IScrollInfo.SetVerticalOffset(Double offset)
   at System.Windows.Controls.ScrollViewer.ExecuteNextCommand()
   at System.Windows.Controls.ScrollViewer.OnLayoutUpdated(Object sender, EventArgs e)
   at System.Windows.ContextLayoutManager.fireLayoutUpdateEvent()
   at System.Windows.ContextLayoutManager.UpdateLayout()
   at System.Windows.ContextLayoutManager.UpdateLayoutCallback(Object arg)
   at System.Windows.Media.MediaContext.InvokeOnRenderCallback.DoWork()
   at System.Windows.Media.MediaContext.FireInvokeOnRenderCallbacks()
   at System.Windows.Media.MediaContext.RenderMessageHandlerCore(Object resizedCompositionTarget)
   at System.Windows.Media.MediaContext.RenderMessageHandler(Object resizedCompositionTarget)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)

Grouping doesn't update when a value in grouped-by column updates in a DataGrid bound to an binding list if property is one level down

mukesh — Wed, 15 May 2013 18:20:48 GMT

updated item is not getting grouped properly if updated property(ies) is one level down.

i.e. ConcreteTrade.IsLiveStatus

Please suggest if i m missing something.

Is there any way to reduce deployment size of Xceed DataGrid for WPF?

Mikhail — Tue, 14 May 2013 21:13:35 GMT

Hi,

I installed xceed datargid and liked its features. But our product requre as little deployment size as it is possible.

Do we have any ways to reduce deployment size of Xceed datagrid for WPF?

Currently it is about 3.3Mb grid + 0.16 Mb Controls = 3.56 that is too much, unfurtunately.

Thank you in advance!

Adding Merged Columns runtime

rahul — Tue, 14 May 2013 12:44:13 GMT

What is the best way of defining the header in an xml file and creating columns at runtime, instead of declaring it in the xaml?

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

COL1 COL2 COL3 | GRP_COL1 GRP_COL2 GRP_COL3 | GRP_COL1 GRP_COL2 GRP_COL3 |

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

void CreateGroupColumns()

{

for (int i = 0; i < 4; i++)

{

Xceed.Wpf.DataGrid.MergedColumn col = new Xceed.Wpf.DataGrid.MergedColumn();

col.Title = "Group"+(i+1);

Xceed.Wpf.DataGrid.ColumnBase col1 = new MyColumn("QTY");

col.ChildColumns.Add(col1);

Xceed.Wpf.DataGrid.ColumnBase col2 = new MyColumn("PERC");

col.ChildColumns.Add(col2);

Xceed.Wpf.DataGrid.ColumnBase col3 = new MyColumn("VAL");

col.ChildColumns.Add(col3);

GroupGrid.Columns.Add(col);

}

Embedded datagrid Columns (Columns Within Columns)

Beryl — Thu, 20 Jan 2011 11:32:38 GMT

Is it possible to have embedded datagrid columns, I mean columns within columns and also support data vritualization and multiple levels of grouping & filtering possiblity?

http://www.designerwpf.com/2008/01/25/embedded-listview-columns-columns-within-columns/

multiple column headers in XCeed DataGrid for WPF v4.2

Rajesh — Fri, 02 Dec 2011 12:40:55 GMT

Is there any way to create multiple column headers in XCeed DataGrid for WPF v4.x ?

Header A		Header B
Hedaer1	Hedaer2	Hedaer1	Hedaer2

Regards

Rajesh Sajjanar

FilterRow - Case and Acent Sensitivity

Daniel — Thu, 06 Dec 2012 11:13:06 GMT

Hi!

Can I change the behavior of filterrow to make it case sensitive and accent insensitive?
There is a workaround to do this?

Thank you!
Daniel

WPF DataGrid is not displaying data when refreshing.

hamendra — Fri, 10 May 2013 09:08:22 GMT

WPF DataGrid is not displaying data( Zero Row) after refreshing for 12000 records. It loads data on first time correctly but when do some other action and again refresh the data Grid does not display any data in UI.

Where as it work fine for Less number of record (6).

Appreciate your help on same

Regards

Hamendra

Group row

rahul — Fri, 26 Apr 2013 16:37:21 GMT

Hi,

is there a way that i can have auto sum for the data columns in the group row. e.g

Column1 Column2

Group1 1200 180

subGroup1 300 80

row1 100 30

row2 200 50

subgroup2 900 100

row3 500 60

row4 400 40

And also the user should be able to change at the group/subgroup level and accordingly(pro-rata) the rows will change its data. Really appreciate the help and if possible some code to achieve this.

Xceed components with my Application Integration achieve ClickOnce publish?

gang — Tue, 07 May 2013 03:21:52 GMT

Dear Team,

I am new hand for Xceed Datagrid application,i want to know whether Xceed Datagrid supports ClickOnce publish?

Thanks

Zhixiang Wei

2013.5.7

ILMerge

Michael — Mon, 22 Apr 2013 06:57:11 GMT

I've used ILMerge to merge the three assemblies Xceed.Wpf.DataGrid.v4.5.dll, Xceed.Wpf.Controls.v4.5.dll and Xceed.Wpf.DataGrid.ThemePack.1.v4.5.dll into a single assembly. When compiling my application I get an error MC3074 due to a missing tag "Office2007BlueTheme" in namespace "http://schemas.xceed.com/wpf/xaml/datagrid".

Does anyone know how to resolve this?

Thanks,

Michael

Xceed DataGrid WPF Change Dafault OrderBy Column

Pir Qaiser — Wed, 01 May 2013 18:58:28 GMT

How can I make xceed data grid for wpf to sort/orderby the data source on a different column than the default key column? The data source is a datagrid collectionview.

Any help is appreciated.

Thanks

Qaiser

ShouldAbort property in AsyncQueryInfo

Venkatesh — Sat, 16 Mar 2013 09:08:04 GMT

Hi,

ShouldAbort property in AsyncQueryInfo is a readonly property.

When will this gets true?
Is there a way that I can force to set to true on error cases?

Thanks

Master with different detail grids

Steve0212 — Fri, 01 Mar 2013 19:50:34 GMT

Is is possible to have one grid with multiple sections f different information. Consider this example where I am writing a search function. I search for "Bob". I would want the resultant grid to combine not just all the Bobs in the company, but also all the files Bob created.

I would want the grid to look something like this:

Users <-- Master Row

User Name Display Name Email Address <-- Detail Row

Files <-- Master Row

File Name Folder Location File Size <-- Detail Row

Is this possible?

Capturing Scrolling Events

Thomas — Wed, 27 Mar 2013 13:55:46 GMT

I am looking for the event to capture when the grid is scrolled. How do I capture that event?

Cancel auto-select first row

Vyacheslav — Tue, 02 Apr 2013 02:56:32 GMT

Good day,

I am using DataGridControl. When I refreshing ItemsSource it default auto-select first row, but I dont't want this behavior. So how can I remove it?

Also I try selected row after refreshing. I used event ItemsSourceChangeCompleted but it doesn't work.

private void LoadData()

{

this.PeopleList = new List<People>();

this.PeopleList.Add(new People { Name="David", Age="22"});

this.PeopleList.Add(new People { Name="Anna", Age="20"});

this.NotifyPropertyChanged("PeopleList");

}

private void dataGrid_ItemsSourceChangeCompleted(object sender, EventArgs e)

{

var item = this.PeopleList.FirstOrDefault(q => q.Name == "Anna");

if (item != null)

this.dataGrid.SelectedItem = item;

else

this.dataGrid.SelectedItem = null;

}

In first loading event ItemsSourceChangeCompleted doesn't work. After refreshing it work.

Exception : at Xceed.Wpf.DataGrid.Automation.DataGridContextAutomationPeer.GetChildrenCore()

Liat — Mon, 08 Apr 2013 13:45:11 GMT

Hi,

I have a DataGrid in Collapsed mode, when I maximize the app window I get the following error and It happens on leptops only:

Thanks,

Technical information:

System.NullReferenceException: Object reference not set to an instance of an object.

at Xceed.Wpf.DataGrid.Automation.DataGridContextAutomationPeer.GetChildrenCore()

at Xceed.Wpf.DataGrid.Automation.DataGridControlAutomationPeer.GetChildrenCore()

at System.Windows.Automation.Peers.AutomationPeer.EnsureChildren()

at System.Windows.Automation.Peers.AutomationPeer.UpdateChildrenInternal(Int32 invalidateLimit)

at System.Windows.Automation.Peers.AutomationPeer.UpdateChildren()

at System.Windows.Automation.Peers.AutomationPeer.UpdateSubtree()

at System.Windows.Automation.Peers.AutomationPeer.UpdatePeer(Object arg)

at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)

at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)

Making 'non-enum' FilterCells have striped background like 'enum' FilterCells in a FilterRow

Neo — Mon, 19 Oct 2009 14:52:04 GMT

I've attached an example project demonstrating this. In my FilterRow, the columns based on enum properties of my datasource are disabled and appear with a striped background. I have set the IsEnabled flag to false on my other non-enum column FilterCell, but it doesn't show as disabled with a striped background like the enum column FilterCell does.

Is there any way of forcing this?

FilterCell doesn't work in this scenario

YiChen — Tue, 16 Apr 2013 07:38:01 GMT

Hi,

I have a dataGrid which is bond to a collection instances of Class A. Inside class A, there is a property called CompanyProp with type of Company Class. Company class is quite simple which only have a property called Name of string type.

I use FieldName="CompanyProp.Name" in Column settings and everything works fine, except the filtering. There is no responds no matter what I keyin in FilterCell of this column. I try to change to DisplayMemberBindingInfo to set Path, it also only work with display.

So how can I make FilterCell work with this kind of column without changing my Class A. ( I know if I create another string property to wrap around the CompanyProp and it will work. But I want to avoid to change my Model).

Thanks. Looking forward your reply.

Regards,

David

Deleting a row from the xceedgrid after sorting.

rupak — Mon, 15 Apr 2013 10:32:14 GMT

Hi ,

i want to delete a selected row after the user sorts the grid (say sort on the first column) . I am taking the selected index property to delete the item from the item source which is a data table. But the problem is since the items are sorted now ( only on the grid not in the underlying datatable) i am deleted the wrong item ( example : if the 5 th row is selected on the UI, it is not really the 5 th row of the data table; because the UI is sorted ).

How can i get the item source with the sorting expression applied on it; so that i can directly delete the selected item.

Dynamic row and column to xceed grid.

rupak — Wed, 10 Apr 2013 10:09:54 GMT

Hi ,

i have a requirement with below 3 features :

1. Grid is created with dynamic column list from the database . Number of columns are 60.

2. The user can add row /columns to the grid at any position ( like the excel insert row/column feature).

3. User should be able edit the data and the changes should be saved to database.

Really appreciate if someone share some sample code to arrive at point 1 and 2 .

Need to display text value from first row of group in StatCell of StatRow.

Durga prasad — Tue, 23 Apr 2013 07:33:19 GMT

Hi,

I want to display text value from first row of group in StatCell of StatRow.

Requirement is have calculated numeric values using Stat Functions and displayed in the StatCell of StatRow but i need to show the Measurements of that result in another cell that is text value.

Please suggest me.

Exception when pasting new items

Michael — Mon, 22 Apr 2013 14:26:43 GMT

There is an exception that randomly occurs when items are pasted into the Xceed DataGrid:

Index was out of range. Must be non-negative and less than the size of the collection.
   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at System.Collections.ObjectModel.Collection`1.System.Collections.IList.get_Item(Int32 index)
   at Xceed.Wpf.DataGrid.DataGridCollectionView.ForceRefresh(Boolean sendResetNotification, Boolean initialLoad, Boolean setCurrentToFirstOnInitialLoad)
   at Xceed.Wpf.DataGrid.DataGridCollectionView.ExecuteSourceItemOperation(DeferredOperation deferredOperation, Boolean& refreshForced)
   at Xceed.Wpf.DataGrid.DeferredOperationManager.Process(Boolean processAll)
   at Xceed.Wpf.DataGrid.DeferredOperationManager.Dispatched_Process(Object e)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)
   at System.Windows.Threading.DispatcherOperation.InvokeImpl()
   at System.Windows.Threading.DispatcherOperation.InvokeInSecurityContext(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Threading.DispatcherOperation.Invoke()
   at System.Windows.Threading.Dispatcher.ProcessQueue()
   at System.Windows.Threading.Dispatcher.WndProcHook(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)
   at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)
   at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
   at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
   at System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame)
   at System.Windows.Threading.Dispatcher.Run()
   at System.Windows.Application.RunDispatcher(Object ignore)
   at System.Windows.Application.RunInternal(Window window)
   at System.Windows.Application.Run(Window window)

From our perspective, we are binding to the ApplicationCommands.Paste command on the DataGridControl class. When items are pasted on the grid, our handler for this command is fired and we update our record collection, then switch to the dispatcher thread and do the following to update the grid with the new items

var binding = dataGridControl.GetBindingExpression(ItemsControl.ItemsSourceProperty);
if (binding != null)
{
binding.UpdateTarget();
}

Normally this all works fine, though it does get called a few times per paste. However randomly, when pasting a large number of items we get the exception seen above. It is not obvious from this exception whether it is coming from within the paste handler of the DataGridControl or handling the update of the ItemsSourceProperty.

Please could you shed some light on this exception and whether we are doing something wrong, which causes it.

Thanks.

Banded columns feature for xceed grid

rupak — Thu, 18 Apr 2013 12:17:19 GMT

Hello,

i am on version 4.2 ; the feature i am looking for looks like below . I need a common header for state,city,zip columns. I know this is available with xceed 4.5 . Any way to achieve the same thing in xceed 4.2 ?

Address

Name State City ZIp Phone

Rupak A B 8 123

Virtualization and StatFunctions

Daniel — Mon, 29 Apr 2013 12:54:11 GMT

Hi guys,

There is a way to implement StatFunctions using DataGridVirtualizingQueryableCollectionViewSource?
Any workaround through code is welcome!

Thanks a lot!

Problem in binding Combox as CellEditor / setting SelectedValueProperty through C# code

Supriya — Tue, 01 Dec 2009 15:41:28 GMT

Hi..I am using Xceed DataGrid For WPF 3.5 professional edition.

I am binding a combobox as cell editor through C# code and not throgh XAML. The selected value of the combobox is not retained in the cell after the edit. I want to set the SelectedValueProperty so that it will retain the selected value, but dont know what should i set it to?

System.Windows.FrameworkElementFactory comboBox = new System.Windows.FrameworkElementFactory(typeof(Xceed.Wpf.Controls.NavigableComboBox));

comboBox.SetValue(Xceed.Wpf.Controls.NavigableComboBox.ItemsSourceProperty, columnInfo.DomainValues.DefaultView);

comboBox.SetValue(Xceed.Wpf.Controls.NavigableComboBox.DisplayMemberPathProperty, "DomainValue");

comboBox.SetValue(Xceed.Wpf.Controls.NavigableComboBox.SelectedValuePathProperty, "DomainID");

//comboBox.SetValue(Xceed.Wpf.Controls.NavigableComboBox.SelectedValueProperty, "Xceed.Wpf.DataGrid.CellEditorBinding"); ???

dataGrid.Columns[columnInfo.Code].CellEditor = new CellEditor();

dataGrid.Columns[columnInfo.Code].CellEditor.EditTemplate = new System.Windows.DataTemplate();

dataGrid.Columns[columnInfo.Code].CellEditor.EditTemplate.VisualTree = comboBox;

I have gone throgh lot of documentation and posts, but did not find 'what to set' in SelectedValueProperty, through C#. Please help.

Binding by ID

Filippo — Tue, 23 Apr 2013 08:12:55 GMT

Hi all,

I have the following situation. I am using a DataGrid to display a list of Boxes. Each Box has a ProductID property. I also have a list of Products, each of which has an ID and a Name.

I want to 1) display a product Name instead of the ProductID, and 2) allow the user to select a Product from a ComboBox in the CellEditor, and change Box.ProductID accordingly.

So far, I've been able to do #1 by using DisplayMemberBindingInfo with a Converter that turns ProductIDs into product names.

However, I'm stumped on #2. I've tried putting this in the cell editor template:

but it won't work, I think because at this point the source of the Binding of SelectedValue is not a Box, but rather a product name. So I've changed it to:

                                <ComboBox IsEditable="True" IsTextSearchEnabled="True" DisplayMemberPath="Name"
                                          ItemsSource="{Binding Client.Products, Source={x:Static local:App.Instance}}"
                                          SelectedValue="{xcdg:CellEditorBinding}"
                                          SelectedValuePath="Name"/>

This results in the ConvertBack method of my Converter getting called with the selected product name, which won't work either (as I can't map back from product names to product IDs).

I realised that using DisplayMemberBindingInfo with a Converter is probably not the right way to do this, as it means that in the CellEditor I'm stuck with a product name. But I can't figure out how to do it otherwise. Help?

DataGrid crashing the application

shai — Mon, 08 Apr 2013 07:41:36 GMT

I'm defining the WPF DataGrid in the xaml. After running the application (even without touching the DataGrid) the whole application is crashing and I get this message:

Xceed.Wpf.DataGrid.Automation.DataGridContextAutomationPeer.GetChildrenCore()

em Xceed.Wpf.DataGrid.Automation.DataGridControlAutomationPeer.GetChildrenCore()

em System.Windows.Automation.Peers.AutomationPeer.EnsureChildren()

em System.Windows.Automation.Peers.AutomationPeer.UpdateChildren()

em System.Windows.Automation.Peers.AutomationPeer.UpdateSubtree()

em System.Windows.Automation.Peers.AutomationPeer.UpdatePeer(Object arg)

em System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Boolean isSingleParameter)

em System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Boolean isSingleParameter, Delegate catchHandler)

Are you familiar with this exception?

How can I prevent it?

Ultra-Simple Grid breaks VS2010 designview

Sascha — Tue, 04 May 2010 19:49:19 GMT

Hi,

make a new WPF C# Project (no matter if .NET 3.5 or .NET4), put in xceed.wpf.datagrid (3.7.10175.16000) as reference and merge the following code into the mainwindow.xaml:

    <xcdg:DataGridControl>
        <xcdg:DataGridControl.Columns>
            <xcdg:Column FieldName="MessageNumber" IsMainColumn="True" MinWidth="0" Title="Nr" Width="50" />
        </xcdg:DataGridControl.Columns>
        <xcdg:DataGridControl.View>
            <Views:TableView>
                <Views:TableView.FixedHeaders>
                    <DataTemplate>
                        <xcdg:HierarchicalGroupByControl Views:TableView.CanScrollHorizontally="False" />
                    </DataTemplate>
                </Views:TableView.FixedHeaders>
            </Views:TableView>
        </xcdg:DataGridControl.View>
    </xcdg:DataGridControl>

You'll see that VS2010 designer will cease work with an System.Reflection.TargetInvocationException
The party-pooper is the HierarchicalGroupByControl.
I don't know why, but this code worked definately with older versions of xceed.datagrid.
You don't use your own grid in projects, I suppose?

Please post an solution - thanks.

Sascha

memory leak with DataGridControl

Michael — Wed, 03 Apr 2013 15:19:10 GMT

Dear sirs,

using your DataGridControl for WPF (V. 4.2.11322.13590) I end up with a memory leak.

My profiler shows the root path down to the static GroupConfiguration.DefaultGroupConfiguration. That seems to prevent DataGridControl from being CGed. I dont know how to get rid of it.

Thanks for any help.

FilterRow filter event

YiChen — Wed, 03 Apr 2013 08:30:49 GMT

Hi,

We are using FilterRow in DataGridControl to do the customized filtering. But we cannot find any event that fired after user type in within filter cell and view is filtered.

How can we get equivalent event or is there any workaround to be informed after filtered by typing in FilterCell of FilterRow?

Regards,

David

Metro Light and Dark Themes for WPF Data Grid

Callon — Wed, 03 Apr 2013 17:04:05 GMT

I noticed that the Xceed Data Grid for Silverlight got Metro Light and Dark themes. When can we expect to see this in the WPF Data Grid?

How to put a customized checkbox into the filterCell

YiChen — Wed, 03 Apr 2013 03:15:00 GMT

Hi,

I have a FilterRow for datagrid. And I want to put a customized checkbox into filterCell within the fitlerRow. I found this http://xceed.com/CS/forums/thread/26837.aspx . But it is not generic way. If I have multiple bool columns , then I need to define multiple filterCell. Is there any generic ways to do that?

Second question is if I use the way provided by that thread, I found the checkbox will only have two status (even I use WPF default checkBox), checked and unchecked. But the filter row's default checkbox have three status, checked , unchecked and no selection. How to make it have the same behavior as the default checkbox?

Regards,

David

Bind DataGridCollectionViewSource to a Datatable in any page

Kieran — Wed, 06 Mar 2013 13:26:59 GMT

Hi,

In the getting started documentation you bind the DatagridCollectionViewSource to the Orders Datatable using the xaml:

Source="{Binding Source={x:Static Application.Current},

Path=Orders}"/>

I have the gird in a separate page and i was wondering what i replace Application.Current with to get the current page that the c# file is for?

To clarify i have the DataTable defined in the page and i just want to bind that that, instead of having to define it in the App.xaml.cs.

Thanks,

Kieran

Any columnchooser fix for DataGridControl v3.8?

Jeff — Thu, 21 Mar 2013 19:52:38 GMT

We are using v3.8 of the WPF DataGridControl. Whenever we have custom theme in a TableView, the ColumnChooser will fail to display. From browsing the DataGrid forum, it seems this is a known issue that's fixed in v4.3:

http://xceed.com/pages/TopMenu/Downloads/Updates.aspx?ProductId=9aa44cb9-cf78-db11-9ed7-0015c5e239e6

We are wondering if there's a patch of this issue for v3.8? If not, is there any workaround you can suggest to us?

Thanks.

Issue Binding DynamicObject properties to StatCells

Nathan — Fri, 27 Jul 2012 16:10:19 GMT

I have a data source that I convert into a list of view objects that have dynamic properties. My view objects inherit DynamicObject, allowing me to create the needed columns at runtime. I allow the DataGridCollectionViewSource to generate it's own ItemProperties. I then manually generate the column definitions on the actual data grid. All the bindings work great until I started adding stats rows.

I added a SumFunction to the DataGridCollectionViewSource, and a StatCell to the datagrid footer. When I run it, I get the following error:

System.Windows.Data Error: 17 : Cannot get 'SumOfCustomerTotal' value (type 'Object') from '(0)' (type 'DataGridCollectionViewGroupRoot'). BindingExpression:Path=(0).SumOfCustomerTotal; DataItem='StatCell' (Name=''); target element is 'StatCell' (Name=''); target property is 'Content' (type 'Object') InvalidSourcePropertyNameException:'Xceed.Wpf.DataGrid.Stats.InvalidSourcePropertyNameException: 'Total' is not a valid field name.
   at Xceed.Wpf.DataGrid.DataGridCollectionViewGroup.GetSourceProperties(StatFunction statFunction, DataGridCollectionView view)
   at Xceed.Wpf.DataGrid.DataGridCollectionViewGroup.InitializeAccumulationTypes(StatFunction statFunction, DataGridCollectionView view)
   at Xceed.Wpf.DataGrid.DataGridCollectionViewGroup.CalculateStatFunctionValue(StatFunction statFunction, DataGridCollectionView view)
   at Xceed.Wpf.DataGrid.DataGridCollectionViewGroup.GetStatFunctionResult(StatFunction statFunction, DataGridCollectionView view)
   at Xceed.Wpf.DataGrid.DataGridCollectionViewGroup.GetStatFunctionValue(String propertyName)
   at Xceed.Wpf.DataGrid.DataGridCollectionView.StatFunctionPropertyDescriptor.GetValue(Object component)
   at MS.Internal.Data.ValueTable.GetValue(Object item, PropertyDescriptor pd, Boolean indexerIsNext)
   at MS.Internal.Data.PropertyPathWorker.GetValue(Object item, Int32 level)
   at MS.Internal.Data.PropertyPathWorker.RawValue(Int32 k)'
System.Windows.Data Error: 17 : Cannot get 'SumOfCustomerTotal' value (type 'Object') from '(0)' (type 'DataGridCollectionViewGroupRoot'). BindingExpression:Path=(0).SumOfCustomerTotal; DataItem='StatCell' (Name=''); target element is 'StatCell' (Name=''); target property is 'Content' (type 'Object') InvalidSourcePropertyNameException:'Xceed.Wpf.DataGrid.Stats.InvalidSourcePropertyNameException: 'Total' is not a valid field name.
   at Xceed.Wpf.DataGrid.DataGridCollectionViewGroup.GetSourceProperties(StatFunction statFunction, DataGridCollectionView view)
   at Xceed.Wpf.DataGrid.DataGridCollectionViewGroup.InitializeAccumulationTypes(StatFunction statFunction, DataGridCollectionView view)
   at Xceed.Wpf.DataGrid.DataGridCollectionViewGroup.CalculateStatFunctionValue(StatFunction statFunction, DataGridCollectionView view)
   at Xceed.Wpf.DataGrid.DataGridCollectionViewGroup.GetStatFunctionResult(StatFunction statFunction, DataGridCollectionView view)
   at Xceed.Wpf.DataGrid.DataGridCollectionViewGroup.GetStatFunctionValue(String propertyName)
   at Xceed.Wpf.DataGrid.DataGridCollectionView.StatFunctionPropertyDescriptor.GetValue(Object component)
   at MS.Internal.Data.ValueTable.GetValue(Object item, PropertyDescriptor pd, Boolean indexerIsNext)
   at MS.Internal.Data.PropertyPathWorker.GetValue(Object item, Int32 level)
   at MS.Internal.Data.PropertyPathWorker.RawValue(Int32 k)'

"Total" is a valid dynamic field, that is correctly populated on the grid, but the StatCell appears to have issues binding to it. I tried defining that column in my view object in code, and it worked. Problem is, I can't do that because most of my columns are determined at runtime by the data coming in. Any ideas how to solve this?

How to set DefaultCellEditors in Style

YiChen — Wed, 27 Mar 2013 02:20:07 GMT

Hi,

I want to have a default bool editor template in xceedgrid for edit mode. I know it can be done by set in view by using DefaultCellEditors. But I want to set DefaultCellEditors in style of DataGridControl but unfortunately I found that DefaultCellEditors is a readonly dependency property, which cannot set in setter of style.

So how can I achieve that in style?

Looking forward your reply.

Xceed Grid: Exporting few columns to excel

Suman — Tue, 26 Mar 2013 06:05:16 GMT

Hi All,

Is it possible to export only few columns to excel from Xceed grid. i.e., We have 10 columns in grid and we need export 8 columns out of it?

FYI, we are using following version of Xceed grid

• Xceed.Wpf.Controls.v4.2.dll
• Xceed.Wpf.DataGrid.v4.2

Appreciate if I can get the sample code

Anyone with sample?

Thanks,

Suman

Hide Group Level Indicator Panel

Ricardo — Thu, 16 Aug 2007 14:25:33 GMT

Hi all,
I´m kinda new to XAML, maybe i´m doing something wrong.
I don´t want to use the Header in which is written Drag a Column header here...

So i´m doing the folowing:

<xcdg:DataGridControl x:Name="dtgDados">
<xcdg:DataGridControl.Resources>
<Style TargetType="{x:Type xcdg:GroupLevelIndicatorPane}">
<Setter Property="Visibility" Value="Collapsed" />
<Setter Property="ShowIndicators" Value="False" />
</Style>
<Style TargetType="{x:Type xcdg:TableView}">
<Setter Property="Theme" Value="Aero.NormalColor" />
<Setter Property="ShowRowSelectorPane" Value="False" />
</Style>
</xcdg:DataGridControl.Resources>

</xcdg:DataGridControl>

The styles for the TableView are working ok, but the GroupLevelIndicatorPanel is still appearing. How do I make it disappear?

I´m doing the databind in C# codebehind.
For that i´m using the ItemsSource property of the DataGrid.

Thanks for now.

How can I retrieve filtered data after filtering

YiChen — Sun, 17 Mar 2013 14:02:27 GMT

Hi,

I am using Xceed DataGridControl. I cannot find a correct event to get filtered data. I know there are AutoFilterValuesChanged and Filter events in DataGridCollectionViewSource. But it seems it is fired before actually filtering.

So how can I get data after it is filtered?

Looking forwards your reply.

Regards,

David

[Bug] If the DataGridControl is under another Tab, unable to select the newly added row by clicking the CurrentItem

Sam — Tue, 19 Mar 2013 15:14:40 GMT

Problem Description:

1. Under a <TabControl>, the DataGridControl is in one of the hidden <TabItem>.

2. It is bind to a DataGridCollectionViewSource then a ObservableCollection. Initially there is no item. Item is added while the Grid is still hidden.

3. Select the Tab where the Grid is in.

4. The DataGridControl.CurrentItem is set to the oldest item. However, the SelectedItem is null. Clicking or press space on that row does NOT select the item. Clicking other row will do. And after clicking any other row, that 1st item is also selectable.

Expected Result:
On step 4 - the CurrentItem (the 1st item) should be selectable by clicking, without clicking any other row first.

Here are the Repro XAML and CS:

Steps - 1. Click the Add button for a few time. 2. Switch to the 2nd Tab. 3. Found that the first item is not selectable by clicking

<Window x:Class="XceedWpfBug.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:sys="clr-namespace:System;assembly=mscorlib"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid"

Title="MainWindow" Height="350" Width="525">

<Window.Resources>

<xcdg:DataGridCollectionViewSource x:Key="List" Source="{Binding List}">

</xcdg:DataGridCollectionViewSource>

</Window.Resources>

<Grid>

</Grid>

</TabItem>

<xcdg:DataGridControl ItemsSource="{Binding Source={StaticResource List}}" NavigationBehavior="RowOnly"

Name="Grid">

<xcdg:DataGridControl.ItemContainerStyle>

<Style.Triggers>

</DataTrigger>

</Style.Triggers>

</Style>

</xcdg:DataGridControl.ItemContainerStyle>

</xcdg:DataGridControl>

</TabItem>

</TabControl>

</Window>

using System;

using System.Collections.Generic;

using System.Collections.ObjectModel;

using System.Diagnostics;

using System.Linq;

using System.Text;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Data;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Imaging;

using System.Windows.Navigation;

using System.Windows.Shapes;

using Xceed.Wpf.DataGrid;

namespace XceedWpfBug

{

/// <summary>

/// Interaction logic for MainWindow.xaml

/// </summary>

public partial class MainWindow : Window

{

private Context Context;

public MainWindow()

{

InitializeComponent();

DataContext =

Context = new Context

{

List = new ObservableCollection<DataLine>()

};

}

private void DataGridControl_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)

{

Trace.Assert(Grid.SelectedItems.Count > 0, "Grid.SelectedItems.Count > 0");

}

private void Button_Click(object sender, RoutedEventArgs e)

{

Context.List.Add(new DataLine {A = DateTime.Now.Ticks});

}

internal class Context

{

public ObservableCollection<DataLine> List { get; set; }

}

internal class DataLine

{

public long A { get; set; }

}

DataGridControl Visibility seted property generates exception after migrated to 3.1 version.

ecaterina — Wed, 11 Feb 2009 18:53:03 GMT

Hello,

Several days ago we migrated our solution to 3.1 version of xceed datagridcontrol.

Everithing goes fine, except one case : My DataGridControl on page has this property setted:

Visibility="{Binding Path=IsSelectedSplit, Converter={StaticResource BB}}" and on build everything goes fine, but when I acces that window I get the following exception :

Inner Exception : Object reference not set to an instance of an object.

Stack Trace:

   at Xceed.Wpf.DataGrid.Automation.DataGridContextAutomationPeer.GetChildrenCore()
   at Xceed.Wpf.DataGrid.Automation.DataGridControlAutomationPeer.GetChildrenCore()
   at System.Windows.Automation.Peers.AutomationPeer.EnsureChildren()
   at System.Windows.Automation.Peers.AutomationPeer.UpdateChildren()
   at System.Windows.Automation.Peers.AutomationPeer.UpdateSubtree()
   at System.Windows.Automation.Peers.AutomationPeer.UpdateSubtree()
   at System.Windows.Automation.Peers.AutomationPeer.UpdateSubtree()
   at System.Windows.ContextLayoutManager.fireAutomationEvents()
   at System.Windows.ContextLayoutManager.UpdateLayout()
   at System.Windows.UIElement.UpdateLayout()
   at System.Windows.Interop.HwndSource.SetLayoutSize()
   at System.Windows.Interop.HwndSource.set_RootVisualInternal(Visual value)
   at System.Windows.Interop.HwndSource.set_RootVisual(Visual value)
   at System.Windows.Window.SetRootVisual()
   at System.Windows.Window.SetupInitialState(Double requestedTop, Double requestedLeft, Double requestedWidth, Double requestedHeight)
   at System.Windows.Window.CreateSourceWindowImpl()
   at System.Windows.Window.SafeCreateWindow()
   at System.Windows.Window.ShowHelper(Object booleanBox)
   at System.Windows.Window.Show()
   at System.Windows.Window.ShowDialog()
   at MaxCell.Infrastructure.UI.Views.UnhandledExceptionDialog.ShowDialog(String exceptionDescription, String stackTrace) in D:\Captiva\MaxCell\src\MaxCell.Infrastructure.UI\Views\UnhandledExceptionDialog.xaml.cs:line 43
   at MaxCell.Infrastructure.Shell.Views.ExceptionManager.ProcessException(Exception exception, IShowExceptionDialog dialog) in D:\Captiva\MaxCell\src\MaxCell.Infrastructure.Shell\Views\ExceptionManager.cs:line 15
   at MaxCell.Infrastructure.Shell.Views.App.App_DispatcherUnhandledException(Object sender, DispatcherUnhandledExceptionEventArgs e) in D:\Captiva\MaxCell\src\MaxCell.Infrastructure.Shell\Views\App.cs:line 60
   at System.Windows.Threading.Dispatcher.CatchException(Exception e)
   at System.Windows.Threading.Dispatcher.CatchExceptionStatic(Object source, Exception e)
   at System.Windows.Threading.ExceptionWrapper.CatchException(Object source, Exception e, Delegate catchHandler)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Boolean isSingleParameter, Delegate catchHandler)
   at System.Windows.Threading.Dispatcher.WrappedInvoke(Delegate callback, Object args, Boolean isSingleParameter, Delegate catchHandler)
   at System.Windows.Threading.DispatcherOperation.InvokeImpl()
   at System.Windows.Threading.DispatcherOperation.InvokeInSecurityContext(Object state)
   at System.Threading.ExecutionContext.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Threading.DispatcherOperation.Invoke()
   at System.Windows.Threading.Dispatcher.ProcessQueue()
   at System.Windows.Threading.Dispatcher.WndProcHook(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Boolean isSingleParameter)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Boolean isSingleParameter, Delegate catchHandler)

If I set

Visibility="Visible" everything goes fine.

If anybody can help please.

Thank you .

Adding rows with DataGridVirtualizingCollectionView

Loic — Fri, 15 Mar 2013 10:42:54 GMT

Hi,

I use a WPF datagrid with collection virtualization enabled (DataGridVirtualizingCollectionView).

When I want to displaying my chunk of rows with QueryItemsEventArgs.AsyncQueryInfo.EndQuery, the grid will show for 1 or 2 seconds empty rows (with default value, image,etc.). Did I miss something or it's the normal behavior of the grid ?

Second point. I want to add a new item in my grid. Right now, I invoke the Refresh method of my DataGridVirtualizingCollectionView which cause a new blink. Is there another method to add a single row (and by extension, to remove one row) ?

Thanks.

Loic

HasValidationError is True after removing invalid row

Mario — Thu, 14 Mar 2013 15:52:31 GMT

I modified the Validation sample so the grid property IsDeleteCommandEnabled is true. I also added a ListChanged event handler on the MainPage so I can inspect the HasValidationError property. When I delete the invalid row while running the sample app the HasValidationError property remains True.

Is this the expected behavior?

I am using version 4.3.12355.10260

Exporting to excel with color in datarow

Suman — Tue, 12 Mar 2013 13:50:28 GMT

Hi All,

In our project, we are using following version of Xceed grid
• Xceed.Wpf.Controls.v4.2.dll
• Xceed.Wpf.DataGrid.v4.2

We have requirement for export the grid to excel. But we need to export with the colour of data row (E.g., if the data row is colour RED, then the excel should have RED colour)
Appreciate if I can get the sample code

Thanks,
Suman

Getting Cell value of selected Row.

Rocky — Sat, 09 Mar 2013 19:21:09 GMT

Hi there,

I have displayed data in Xceed Data Grid via DataTable.

DataTable dt = getProfile();

gridView2.ItemsSource = new DataGridCollectionView(dt.DefaultView);

I dont want user to make edit the data in the xceed datagrid itself but rather make edit in another window or popup. There is a Column named ID that is unique to each row in the datagrid and the database also so I need the cell value of selected row in another button click event or double click event of grid will also do.

I want to do something like this.

int id = gridView2.SelectedRow.Cells["ID"].Value;

Thanks

Xceed DataGrid_SelectionChanged event firing twice

Steven — Mon, 11 Mar 2013 16:24:54 GMT

I have a datagrid that fires the event twice. The goal is to get it to update the ItemsSource of two other grids inside a tab control. However, that event fires twice and the visible tab's grid doesn't update. Has anyone seen this before?

Highlight TextBox content on Tab

Jacob — Thu, 07 Mar 2013 20:12:09 GMT

Hi,

Does anybody know a way to automatically highlight the contents of a newly selected row, this seems like pretty common functionality but i'm not seeing it on the TextBox editor.

Thanks in advance,

--Jake

Is there a way to allow grid sort only when clicking on the headers (and not when the data is changed) ?

Elad — Thu, 07 Mar 2013 10:49:19 GMT

I have a DataGrid with AllowSort=True in which one of the columns is a checkbox.

When the user click on the checkbox column header - the grid is being sorted properly, but when I click on the checkbox of one the data rows and change its value - the row is being moved to a different place because the sort is being applied.

Is there a way to apply the sort only when user is clicking on the column header?

Thanks,

Elad.

Custom Group Header

Rick — Thu, 08 May 2008 19:01:09 GMT

Ok, so I have a list of Person objects in my datagridcontrol.

I want to group by PersonTypeID(because sorting by an integer is MUCH faster than sorting by a string) but I want to display the associated PersonTypeName inside the group header.

Is there any way to accomplish this?

Thanks so much for the help

Selected Row Template

Duane — Fri, 17 Aug 2007 14:42:00 GMT

Component: Xceed Data Grid For WPF v 1.2
IDE: Visual Studio 2008 Team Edition Beta 2
OS: Windows XP SP2

I've just started using the datagrid and I notice that when I select a row, the column I clicked on remains white while the rest of the row turns blue. I'd like the entire row to turn blue, because I've left ReadOnly set to true for the entire datagrid. I'm in the midst of trying a work around with a Column.CellContentTemplateSelector but if there is an easier way I'd like to know.

Some suggestions for future versions?

DataGrid.SelectedRowHighlightColor -> Overridden by Column.SelectedCellHighlightColor
Column.SelectedCellContentTemplate

Crash on Sorting By Non-existant Column Name

Anthony — Fri, 07 Aug 2009 13:08:22 GMT

Hello, If I set the datasource of the datagrid with one dataset, click on a datagrid header to sort it by a field called "Test", then after I'm done viewing this data I set the datasource of the datagrid to another dataset which does *not* contain a field called "Test", my application crashes; obviously it's still trying to apply the sort to "Test" but that field no longer exists in the new dataset so it crashes. What can I do do prevent this from happening? Also, is there a way to programmatically set the sort column(s)?

Thanks,

Anthony

Restore default settings

Krijn — Fri, 31 Jul 2009 09:37:06 GMT

How can I restore the DataGridControl default settings; grouping, sorting, column properties, .. as defined in xaml ?

My idea was to save the settings on each load, just before loading the user settings :

Private Sub MyDataGridLoaded(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs)

myDataGrid.SaveUserSettings(defaultSettingsRepository, Xceed.Wpf.DataGrid.Settings.UserSettings.All)
LoadUserSettings()

End Sub

        Private Sub RestoreDefaultSettings()
            myDataGrid.LoadUserSettings(defaultSettingsRepository, Xceed.Wpf.DataGrid.Settings.UserSettings.All)
        End Sub

But the Grid (with grouped DataGridCollectionViewSource and ObjectDataProvider) does not have all settings available (grouping,sorting) on load (because ObjectDataProvider doesn't have data yet).

How can I clear the loaded userSettings from the Grid ?

converting a databound grid item's value using DataGridBindingInfo?

Zebulon — Tue, 10 Feb 2009 01:27:07 GMT

I am binding my grid to a BindingList<T> in the C# codebehind. One of the properties in my type requires using a DataGridBindingInfo object in order to specify the path of the value I want to display.

Such as:

DataGridBindingInfo MilestoneSummaryBindingInfo = new DataGridBindingInfo();
MilestoneSummaryBindingInfo.Path = new PropertyPath("MilestoneSummary.Name");
dataGridControlTimelineValues.Columns["MilestoneSummary"].DisplayMemberBindingInfo = MilestoneSummaryBindingInfo;

However, I would actually like to display a conditional value in it's place (like if the MilestoneSummary.Name = "blah", then display a string of "No" instead of the actual value of .Name, for example)...

Can someone point me to a C# example of doing this?

Thanks!

virtualization - argument out of range exception

adam — Fri, 25 Sep 2009 13:29:00 GMT

Hi,

I have problem when i try to group by one of columns in grid with turned on virtualization. XAML looks like follows:

Property EdmQueryableSrc returns simple set of entites:

        public IQueryable EdmQueryableSrc
        {
            get
            {
                entities = new XceedTest.XCEEDTESTEntities();
                return entities.Persons;
            }
        }

Everything works fine until i drag and drop any of column header to grouping section when i get this Exception :

Type: System.ArgumentOutOfRangeException

Message: {"Specified argument was out of the range of valid values. Parameter name: index"}

Stack Trace:

at Xceed.Wpf.DataGrid.DataGridVirtualizingCollectionViewGroupBase.GetItemAtGlobalIndex(Int32 index)
   at Xceed.Wpf.DataGrid.DataGridVirtualizingCollectionViewBase.GetItemAt(Int32 index)
   at Xceed.Wpf.DataGrid.DataGridVirtualizingCollectionViewBase.SetCurrentItem(Int32 newCurrentPosition, Boolean isCancelable)
   at Xceed.Wpf.DataGrid.DataGridVirtualizingCollectionViewBase.AdjustCurrencyAfterReset(Int32 oldCurrentPosition)
   at Xceed.Wpf.DataGrid.DataGridVirtualizingCollectionViewBase.ForceRefresh(Boolean sendResetNotification, Boolean initialLoad, Boolean setCurrentToFirstOnInitialLoad)
   at Xceed.Wpf.DataGrid.DataGridVirtualizingCollectionViewBase.ExecuteSourceItemOperation(DeferredOperation deferredOperation)
   at Xceed.Wpf.DataGrid.DataGridCollectionViewBase.ExecuteOrQueueSourceItemOperation(DeferredOperation deferredOperation)
   at Xceed.Wpf.DataGrid.DataGridCollectionViewBase.OnGroupDescriptionsChanged(Object sender, NotifyCollectionChangedEventArgs e)
   at System.Collections.Specialized.NotifyCollectionChangedEventHandler.Invoke(Object sender, NotifyCollectionChangedEventArgs e)
   at System.Collections.ObjectModel.ObservableCollection`1.OnCollectionChanged(NotifyCollectionChangedEventArgs e)
   at System.Collections.ObjectModel.ObservableCollection`1.InsertItem(Int32 index, T item)
   at Xceed.Wpf.DataGrid.GroupDescriptionCollection.InsertItem(Int32 index, GroupDescription item)
   at System.Collections.ObjectModel.Collection`1.Insert(Int32 index, T item)
   at System.Windows.Controls.ItemCollection.SynchronizeGroupDescriptions(NotifyCollectionChangedEventArgs e, ObservableCollection`1 origin, ObservableCollection`1 clone)
   at System.Windows.Controls.ItemCollection.GroupDescriptionsChanged(Object sender, NotifyCollectionChangedEventArgs e)
   at System.Collections.Specialized.NotifyCollectionChangedEventHandler.Invoke(Object sender, NotifyCollectionChangedEventArgs e)
   at System.Collections.ObjectModel.ObservableCollection`1.OnCollectionChanged(NotifyCollectionChangedEventArgs e)
   at System.Collections.ObjectModel.ObservableCollection`1.InsertItem(Int32 index, T item)
   at System.Collections.ObjectModel.Collection`1.Insert(Int32 index, T item)
   at Xceed.Wpf.DataGrid.GroupingHelper.AddNewGroupFromColumn(ColumnBase column, ObservableCollection`1 targetGroupDescriptions, Int32 position)
   at Xceed.Wpf.DataGrid.GroupingHelper.AddNewGroupFromColumnManagerCell(ColumnManagerCell cell, GroupLevelDescription draggedOverDescription, DropMarkAlignment alignment, DataGridControl parentDataGridControl)
   at Xceed.Wpf.DataGrid.GroupingHelper.AppendNewGroupFromColumnManagerCell(ColumnManagerCell cell, DataGridControl parentDataGridControl)
   at Xceed.Wpf.DataGrid.GroupByControl.Xceed.Utils.Wpf.DragDrop.IDropTarget.Drop(UIElement draggedElement)
   at Xceed.Utils.Wpf.DragDrop.DragSourceManager.ProcessCurrentDropTargetDrop(Boolean wasDragging, Boolean drop)
   at Xceed.Utils.Wpf.DragDrop.DragSourceManager.EndDrag(Boolean drop)
   at Xceed.Utils.Wpf.DragDrop.DragSourceManager.ProcessMouseLeftButtonUp(MouseButtonEventArgs e)
   at Xceed.Wpf.DataGrid.Views.ColumnReorderingDragSourceManager.ProcessMouseLeftButtonUp(MouseButtonEventArgs e)
   at Xceed.Wpf.DataGrid.ColumnManagerCell.OnMouseLeftButtonUp(MouseButtonEventArgs e)
   at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e)
   at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
   at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
   at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
   at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
   at System.Windows.Input.InputManager.ProcessStagingArea()
   at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
   at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
   at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
   at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Boolean isSingleParameter)
   at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Boolean isSingleParameter, Delegate catchHandler)
   at System.Windows.Threading.Dispatcher.InvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Boolean isSingleParameter)
   at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
   at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
   at System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame)
   at System.Windows.Application.RunDispatcher(Object ignore)
   at System.Windows.Application.RunInternal(Window window)
   at System.Windows.Application.Run(Window window)
   at System.Windows.Application.Run()
   at XceedTestAutoVirtualize.App.Main() in C:\Users\adamw\Documents\Visual Studio 10\Projects\gridTest\XceedTestAutoVirtualize\obj\x86\Debug\App.g.cs:line 0
   at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
   at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
   at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

Sometimes ( very rare) i dont get that exception, but grid remains empty. In database is stored 100k records, generater by your virtaulization's example. Do you have any ideas how to solve this problem? Thanks in advance.

Issue Styling RowSelector

Rob — Tue, 08 Apr 2008 13:54:02 GMT

I have followed the example to style the RowSelector. I am able to get the ItemIndex to show up as its content no problem.

The issue is that the RowSelectorPane itself only allows enough space for 2 digits to be displayed (0-99) before it truncates the remaining digits. This is ok, if you have less than 100 rows of data in a grid, but when you have more you no longer can determine the idnex via the RowSelectorPane. Can someone provide an example on how to update either in XAML or progromatically the width of the RowSelectorPane to match the content width?

I have made a number of attempts to get this to updated and have not been able to find a solution.

Any help would be appreciated.

Binding data to row selector pane

rajendernag — Fri, 23 Mar 2007 09:36:28 GMT

Hi,

I want to bind some data to RowSelector pane also. Is it possible.

Updating a child combobox when a parent combox's value changes and in edit mode

Daniel — Mon, 18 Feb 2013 19:56:33 GMT

Hi,

I've got a grid with 2 combo boxes in, and one of them depends on the other one. I've got this relationship working fine outside of the grid via dependency properties, but when I put the row (which is a dependency object) into the grid, we are in edit mode, and it doesn't seem to commit any values back to row.

Hence, when I select the parent value, the childs ItemsSource is not updated because I don't get the event saying the parent has changed until I exit edit mode.

Is there a way to make edit mode update immediately?

Alternatively whats the best way to capture the change so I can update the childs ItemsSource collection?

Thanks,

Dan

User control as a details for a row

Eyal — Tue, 03 Nov 2009 10:54:27 GMT

Hey,

I'm in the process of evaluate the Xceed WPF data grid, and now i'm focusing on showing a user control / grid (not data grid) as a details of a row.

As i saw, I can use DetailConfigurations only for an inner table, but what if i want to use other controls as a details for a row?

Regards,

Eyal

Customizing DataGridControl - wrapping detail grid in expander

Namnet — Thu, 14 Feb 2013 21:03:33 GMT

Hello

I''ve created a custom control which inherits from the DataGridControl.

I'm trying to add functionality so that each detailgrid in (master/detail scenarios) will be wrapped by an expander with some statistical data (such as number of items in the detailgrid).

How can I do this?

"The local property 'Columns' can only be applied to types that are derived from 'DataGridControl'".

bsundsbo — Sun, 27 Jan 2013 20:26:09 GMT

I have derived from DataGridControl for custom behavior, but I am experiencing some issues with the error in the warning. The application compiles and runs just fine, but I keep getting these messages in the designer and in Error List. It is not just for Columns, but also for SelectionMode, View and a few other properties.

I realize this is not necessarily a problem with the Xceed control, but hopefully you can help me out with a solution. It delays the designer, it is annoying to look at, and whenever I type something in an affected file, the Error List keeps updating.

<Controls:XceedListView SelectionMode="Single">

<!-- Squigglies on next line and on SelectionMode -->
            <Controls:XceedListView.View>
                <xcdg:TableView>
                    <xcdg:TableView.FixedHeaders>
                        <DataTemplate>
                            <xcdg:ColumnManagerRow />
                        </DataTemplate>
                    </xcdg:TableView.FixedHeaders>
                </xcdg:TableView>
            </Controls:XceedListView.View>
       <!-- Squigglies on next line -->
            <xcdg:DataGridControl.Columns>
                <!-- Time column -->
            </xcdg:DataGridControl.Columns>
        </Controls:XceedListView>

Readonly Grouping

Oliver — Mon, 11 Feb 2013 13:41:33 GMT

Hello together,

under which circumstances could a grouping be readonly? Is there an property or parameter or something else?

We use the Datagrid control and after we load the usersettings a saved grouping can't be deleted.

I hope someone has a idea.

Thx

Oliver

Filter Pop up and Enum

Jib — Mon, 03 Dec 2012 14:36:49 GMT

Hi, I have an object with a property that is an enum. I use a converter to display the enum in the xceed table which works fine. I would like to keep the same display in the filter pop up when I click on the arrow in the column header. At the moment the filtering works fine but there is no text next to the checkboxes.

Description and not Id

Jonathan — Wed, 23 Jan 2013 14:26:17 GMT

How do I bind to an id field but display the description for that id?

CardView ColumnChooser is very slow

Stephan — Sun, 10 Feb 2013 11:48:26 GMT

Hello

I am using the CardView with about 10-15 columns on each card,

when I want to remove/add columns from the card, it takes a lot of time... sometimes even 40-50 seconds and it freezes up the display.

Is there anything that I can do to improve things? this is very important to me.

Thank you very much

Calling EditEnd or other functions from a checkbox inside a DataCell

Sebastian — Fri, 01 Feb 2013 01:15:34 GMT

Hey everyone,

I have an application with an Xceed DataGrid for WPF and in my grid I have a column with checkboxes. The problem I am having is that when the user clicks on the check box nothing happens, but when they click on the cell that the check box is in then the cell's EditBeginning event get's fired but crashes because the content is set to null. I tried everything possible from creating a datatemplate with the checkbox in it and setting it:

</DataTemplate>

I also tried to set the grid's UpdateSourceTrigger to no avail as well as different forms of binding found all over this forum.

Below is the final attempt that I have that didn't work. Any help is greatly appreciated.

</DataTemplate>

Hide ColumnManagerRow in code behind

Sebastian — Thu, 31 Jan 2013 01:55:10 GMT

Hey everyone,

I have a Xceed Datagrid which loads in data and works wonders. However, today I was approached by my supervisor and he wanted to know if the column headers can be hidden on demand. If it is possible is there a way I can modify it from the C# code?

Thanks in advance.

Master Detail Issue

Versova — Thu, 24 Jan 2013 20:55:14 GMT

Hi,

I have created a master detail grid as per the example in documentation. But when I click '+' on the master row, the master row does not exapnd to display the detaails table.

I have set AllowDetailToggle to true and I am use datagridcolllectionviewsource. I have set the detailsconfiguration on datagridcolllectionviewsource and the grid as per the example.

What could I be doing wromng?

Thanks,

DataGridControl is not completely exported to excel sheet

Amit — Mon, 28 Jan 2013 08:36:55 GMT

I have a datagrid control which has dynamic columns (1 column per finance year) based on the business requirements.

The grid resides in bottom half of the screen. It has a vertical scrollbar which allows user to view top to bottom grid.

When I try to export it to excel sheet, only the visible rows (visible on UI) get exported to excel. Rest data is ignored.

I am simply using _excelExporterObj.Export(_filepathString) method. Please let me know the solution on this.

Thanks & Regards,

-Amit

Stat Functions

Sandeep — Sat, 29 Nov 2008 11:53:06 GMT

Hi,

I have created a Context Menu on Stat Row. It contains Name of functions to apply as menu items. (Average/Sum/Max/Min etc).

Now I need a way to access StatCell so that i can apply it on the specified column only..

// Code to add Menu Items

Xceed.Wpf.DataGrid.StatRow sr = (sender as Xceed.Wpf.DataGrid.StatRow);

ContextMenu cm = new ContextMenu();

DropDownMenuItem ddmi = new DropDownMenuItem();

ddmi.Header = "Average";

ddmi.Click += new RoutedEventHandler(StatRow_ddmi_Click);

cm.Items.Add(ddmi);

// Code which will run on menu item click

void StatRow_ddmi_Click(object sender, RoutedEventArgs e)

{

if (dgGrid.CurrentColumn == null) return;

MenuItem menuItem = sender as MenuItem;

ContextMenu cm = menuItem.Parent as ContextMenu;

StatRow sr = (cm.PlacementTarget as StatRow);

//StatCell sc = ******* HOW TO ACCESS CURRENT COLUMN'S STAT CELL HERE **********

}

Some evaluation questions

Andrew — Thu, 24 Jan 2013 13:44:51 GMT

1) I want to display numeric data in a column, *but* in the first cell of the column I want to display a "unit of measure" (e.g. "cm", "mm", "in", etc.). The numeric cells must be read only, but the user should be able to click the "unit of measure" cell. This will display a dropdown list allowing the user to change that column's unit of measure. When a selection is made I need to update the values in the underlying data source, resulting in the new values appearing in the grid. Can you think of a way that this grid functionality could be achieved?

2) I want to be able to right-click a cell, which results in some kind of "pop-up" form (e.g. a Panel, or similar) appearing over the cell that was clicked. Is this possible? I would prefer not to use a vanilla dialog, which appear in the centre of the screen. (This may be more of a WPF question than Xceed - I'm still new to WPF, and don't know how to show one visual element over another).

3) Being WPF, is it possible to embed different visual elements within a cell? I would like the ability to display a numeric value with an image alongside it (this is an indicator that will change based on some complex business rules). Again, is this possible?

Thanks in advance

Andy

Default Filter with multiple criteria

Jib — Wed, 23 Jan 2013 10:58:09 GMT

Hello, I need to do a default filter for one of my xceed datagrid's column. I'd like to do it in the xaml code.

This code doesn't compile because of the criteria.

<xcdg:DataGridCollectionViewSource x:Key="superData"
                                           Source="{Binding RelativeSource={RelativeSource AncestorType={x:Type UserControl}}, Path=DataContext.MySource}"
                                           AutoFilterMode="And"
                                           AutoCreateItemProperties="True"
                                           DefaultCalculateDistinctValues="True">
            <xcdg:DataGridCollectionViewSource.ItemProperties>
                <xcdg:DataGridItemProperty Name="HeroName">
                    <xcdg:DataGridItemProperty.FilterCriterion>
                        <xcdg:AndFilterCriterion FirstFilterCriterion="Hulk"
                                                 SecondFilterCriterion="Captain America"/>
                    </xcdg:DataGridItemProperty.FilterCriterion>
                </xcdg:DataGridItemProperty>
            </xcdg:DataGridCollectionViewSource.ItemProperties>
        </xcdg:DataGridCollectionViewSource>

I didn't find a post explaining how to use AndFilterCriterion in xaml in the forums. How is it used?

Thanks.

Edit : To clarify my request, I'm looking for a default filter configuration exactly like if some one already ticked one or two checkboxes in the column's filter pop up not some sort of pre-filtering to display in the column and that cannot be undone.

I tried

<xcdg:StartsWithFilterCriterion Value="Hulk"/>

And it's not what I'm looking for because afterwards the user can't filter by Captain America since there is no more Captain America in the column.

I'm just looking for a default check box tick in the filter pop up.

Refresh Distinct Values for AutoFilter

Kieran — Mon, 21 Jan 2013 13:41:35 GMT

Hi,

When a user searches via the Filter Row the distinct values don't update in the AutoFilter Drop down.
Is there a way to refresh the distinct values?

Thanks,

Kieran

AutoFilter Click Refresh Time

Kieran — Mon, 21 Jan 2013 09:57:20 GMT

Hi,

Is there a way to impose a delay on the autofilter refresh time.

I'm dealing with a large dataset and i don't want the grid to repopulate on every click. This is because if the users wants to click a few items they have to wait a few seconds with each click.

Thanks in advance,

Kieran

single click checkbox edit

Kelly — Tue, 15 Jan 2013 00:03:11 GMT

Hi,

I have a grid with a checkbox column and at the moment it's taking 3 clicks in order to tick the checkbox. I was wondering is there anyway to reduce the number of clicks required? I have tried setting the edit triggers to ActivationGesture, SingleClick, RowIsCurrent, ClickOnCurrentCell, SingleClick, BeginEditCommand and the UpdateSourceTrigger to CellContentChanged but neither of these has worked

thanks,

kelly

AutoFilter popup width

David — Thu, 20 Dec 2012 16:37:09 GMT

I've enabled autofilter popups on my grid, which works well. However on one of the columns the text is too wide for the popup. How do I resize the popup to fit the text or enable a horizontal scroll bar?

Dave

Copy Specific Datagrid Columns to Clipboard

Justin — Wed, 16 Jan 2013 20:30:41 GMT

I'm trying to figure out a way to copy the contents (programmatically) of a few columns in my datagrid to the clipboard (not all columns). I was able to get this done with a standard datagridview but I can't seem to get it right with your datagrid.

The code I have to at least select everything then dump into the clipboard:

        ApplicationCommands.SelectAll.Execute(Nothing, dataGrid)
        ApplicationCommands.Copy.Execute(Nothing, dataGrid)
        dataGrid.SelectedItems.Clear()

But I can't figure out how to to omit columns or how to only select a range of columns.

I would great appreciate any help!

Justin

Dynamically creating StatRows and suppressing #DIV/0# values in code-behind.

Prasad — Mon, 17 Oct 2011 21:24:05 GMT

Due to our requirement I need to do dynamically create the StatRows as in the following thread.

http://xceed.com/CS/forums/post/29517.aspx

The code behind implementation works fine for all the StatRows (using the GenerateStatRowTemplate() helper function attached below)

As we have a lot of cells showing #DIV/0# and #VALUE# I implemented a stat cell converter as advised in the following thread.

http://xceed.com/CS/forums/post/30590.aspx.

At run time I am getting an error "Cannot create unknown type 'DataTemplate'." . What's wrong in the following code. ? Please help.

Code

private DataTemplate GenerateStatRowTemplate(EnumStatFunctions statFunc)
        {
            ParserContext pc = new ParserContext();
            pc.XmlnsDictionary.Add("", "http://schemas.microsoft.com/winfx/2006/xaml/presentation");
            pc.XmlnsDictionary.Add("x", "http://schemas.microsoft.com/winfx/2006/xaml");
            pc.XmlnsDictionary.Add("xcdg", "http://schemas.xceed.com/wpf/xaml/datagrid");

            DataTemplate footerTemplate = null;
            XElement statRow;
            XElement statCell;
            XElement dataTemplate = new XElement("DataTemplate");

            XNamespace xcdg = "http://schemas.xceed.com/wpf/xaml/datagrid";

            XElement dataTemplate2;
            XElement contentTemplate;
            XElement textBlock;

            List<StatFunction> statFuncList = null;

            if (StatisitcsFunctions.TryGetValue(statFunc, out statFuncList))
            {
                if (statFuncList != null)
                {
                    statRow = new XElement(xcdg + "StatRow");

                    foreach(StatFunction func in statFuncList)
                    {
                        statCell = new XElement(xcdg + "StatCell",
                                   new XAttribute("FieldName", func.SourcePropertyName),
                                   new XAttribute("ResultPropertyName", func.ResultPropertyName));

                        /*
                        <xcdg:StatCell.ContentTemplate>
                            <DataTemplate>
                                <TextBlock Text="{Binding ., Converter={StaticResource ResourceKey=StatCellConvert}}"/>
                            </DataTemplate>
                        </xcdg:StatCell.ContentTemplate>
                        */

                       contentTemplate = new XElement(xcdg + "StatCell.ContentTemplate"); //<xcdg:StatCell.ContentTemplate>
                       dataTemplate2 = new XElement("DataTemplate"); //<DataTemplate>

                       textBlock = new XElement("TextBlock",
                                   new XAttribute("Text", "{Binding Converter={StaticResource ResourceKey=StatCellConvert}}")); // <TextBlock Text="{Binding ., Converter={StaticResource ResourceKey=StatCellConvert}}"/>


                       dataTemplate2.Add(textBlock);
                       contentTemplate.Add(dataTemplate2);

                       statCell.Add(contentTemplate);
                       statRow.Add(statCell);
                    }
                    dataTemplate.Add(statRow);
                }
            }

            MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(dataTemplate.ToString()));
            footerTemplate = XamlReader.Load(ms, pc) as DataTemplate;
            return footerTemplate;
        }
    }

Thanks

Prasad

CancelEdit() on DataGrid raises System.InvalidOperationException: An attempt was made to call the CancelEdit method on a DataGridContext that is not current.

Daniel — Fri, 21 Dec 2012 11:24:55 GMT

Today I do some test nad I have found, that calling of method CancelEdit() of DataGridControl raises System.InvalidOperationException: An attempt was made to call the CancelEdit method on a DataGridContext that is not current.
at Xceed.Wpf.DataGrid.DataGridControl.CancelEditHelper(DataGridContext dataGridContext)
at Xceed.Wpf.DataGrid.DataGridControl.CancelEdit()

This happens when there is edited any value in child row, and focus reamins on that row (row remains in editing state).

What can be reason for that behaviour? I how can I avoind that exception, and correctly cancel editing?

Programmatically changing individual DataCell colours based on data in other DataRows

Neo — Tue, 25 Aug 2009 15:31:50 GMT

I have spent several days trying to find a way to change the colour of individual cells based on their value and/or the values of other data elsewhere in the grid. However, although there seems to be a lot of questions on the forums by users, the answers aren't really conclusive. I have read and contributed to several topics:

There is also a related article here which seemed to have some clues with some comments from our very own Jenny: http://ajhorus.wordpress.com/2007/11/22/xceed-datagrid-custom-cell-styling/

However, I am still having difficulties. There does not seem to be any clear information or documentation or examples on how to achieve this. I have put together a small sample application (attached) that demonstrates four methods - one is reminiscent of the above wordpress.com article, the other three are invoked by buttons on the form. Although the method from the wordpress.com article works, this is not ideal because it uses some DataRow event in a spurious manner and is not suitable if I wish to programmatically go through the DataRows and DataCells later on to modify the colours again.

Could I please have assistance on this as I have been racking my brain for days over this?

Many thanks,

Jason

EmptyDataItem when selecting multiple rows

Rania — Fri, 28 Dec 2012 09:51:17 GMT

Hello,

I have a problem when selecting a big number of rows in DataGridControl (select one row, scroll vertically very quickly and press Shift + second row). Some of the selected items are EmptyDataItem and I cannot treat them.

Any ideas??

I will send a sample project reproducing the issue to support@xceed.com.

100,000 records upload in xceed WPF DataGrid

Suman — Mon, 31 Dec 2012 11:41:04 GMT

Hi All,

I am new to Xceed family WPF controls

Our existing project is using Xceed WPF DataGridControl

Background: Currently the control is able to load 25,000 record (Records load either from Database or Excel application) in DataGridControl without any perfomance issue.

Requirement: Now the requirement is to load records more 100,000 in WPF DataGridControl control. But the loading is causing performance issue and slowness in response on the main application [ ur application (WPF) is loaded on Web page]

Can someone suggest/advice on the increase of performance while loading the data

Thanks in Advance

Suman

Excel "drag and fill", and row drag-and-drop possible?

Andrew — Tue, 18 Dec 2012 12:41:01 GMT

I'm about to evaluate Exceed and one of the main features that our customer is asking for is the Excel "drag and fill", i.e. you select a cell, press Ctrl-C, then drag a rectangle around one or more other cells (usually in the same column) and press Ctrl-P, resulting in the selected cell's value being copied into all the others. Is this possible?

Also, how easy is it to implement row drag-and-drop to re-order rows within a datagrid?

Thanks in advance

Andy

How do I bypass the "unsorted" column sort state

Michael — Mon, 10 Dec 2012 22:32:25 GMT

I understand that content of one or more columns can be sorted, but how do I bypass the "unsorted" column sort state all together? I essentially would like to only allow users the option of being able to see column content sorted either in an ascending or descending manner but never unsorted.

Sorting on Record-Bound Data

Barrett — Tue, 11 Dec 2012 19:37:08 GMT

Hi there.

I don't know exactly how you refer to this, but we have been using FieldName=" " and FieldName="." to bind to the entire record for some fields.
Our requirement is that we display a list of names as buttons. The user must be able to sort the column based on the names.

How do we sort a column by a field on the Item and yet have the CellContent be bound to the entire Item ?

We have been attempting to use the following XAML:

<xcdg:Column FieldName="." Title="Name" AllowSort="True" x:Name="NameColumn">
<xcdg:Column.CellContentTemplate>
<DataTemplate>
<Button x:Name="solButton" Content="{Binding Name}" FontWeight="Bold"
Command="{Binding DataContext.OpenCommand, RelativeSource={RelativeSource AncestorType=Views:SearchResultsView}}"
CommandParameter="{Binding Guid}"/>
</DataTemplate>
</xcdg:Column.CellContentTemplate>
</xcdg:Column>

Clicking on the column header results in the terribly helpful exception that the two array elements do not implement IComparable.
(Name is a string.)

Implementing IComparable on the classes in Items does not seem to help.
Adding a custom SortComparer to the ViewModel and:

<xcdg:DataGridCollectionViewSource x:Key="dataGridSource">
<xcdg:DataGridCollectionViewSource.ItemProperties>
<xcdg:DataGridItemProperty Name="." ValuePath="Name" SortComparer="{Binding SortComparer}"/>
</xcdg:DataGridCollectionViewSource.ItemProperties>
</xcdg:DataGridCollectionViewSource>

does nothing. (And the comparer is not even called.)

Any assistance would be greatly valued.

Thanks in advance.

FilterRow in details view

dominik — Thu, 06 Dec 2012 14:19:29 GMT

Is there any way to display FilterRow in details view?

StatRow: Suspend Updates during Lengthy Operation?

Jordan — Wed, 15 Feb 2012 14:36:45 GMT

Hello. I make a batch of updates to my datagrid periodically. I have a StatRow that I use for column sums. After every update in my batch of updates to my datagrid, the StatRow recalculates itself. This looks weird.

Is it possible to suspend updates to the StatRow during a batch of updates to a datagrid? And then resume updates once the batch is complete. (I realize that in the interim, the StatRow would display an erroneous result)

How to keep grid state

Artem — Thu, 22 Nov 2012 09:41:15 GMT

Grid is updated on a timer. How to save and restore the entire state of the grid:

groups, column position, column sorting, status groups (expanded/ collapsed), the selected/focused row, etc.?

How do I make the upgrade grid does not flash?

To sum up: how to correctly update the source grid?

CustomItemContainerGenerator.GenerateNextLocalContainer: Node is not the current one.

Dude — Fri, 02 Nov 2012 21:20:07 GMT

Hi folks,

So i have a rather complicated setup at hand where the grid has both grouping and master/details going on at the same time. The problem arises when the grid is first group then we drill into one of the master/details drill down and when we collapse that drilldown we get that exception:

Xceed.Wpf.DataGrid.DataGridInternalException occurred

Message=CustomItemContainerGenerator.GenerateNextLocalContainer: Node is not the current one.

Source=Xceed.Wpf.DataGrid.v4.4

StackTrace:

at Xceed.Wpf.DataGrid.CustomItemContainerGenerator.GenerateNextLocalContainer(Boolean& isNewlyRealized)

at Xceed.Wpf.DataGrid.CustomItemContainerGenerator.System.Windows.Controls.Primitives.IItemContainerGenerator.GenerateNext(Boolean& isNewlyRealized)

at Xceed.Wpf.DataGrid.Views.TableViewItemsHost.GenerateContainer(ICustomItemContainerGenerator generator, Int32 index, Boolean measureInvalidated)

at Xceed.Wpf.DataGrid.Views.TableViewItemsHost.GenerateContainers(ICustomItemContainerGenerator generator, Double pageHeight, HashSet`1 layoutedContainersToRecycle, Boolean measureInvalidated, PageIndexes& pageIndexes, Double& containersHeight)

at Xceed.Wpf.DataGrid.Views.TableViewItemsHost.GeneratePage(Double availableHeight, Boolean measureInvalidated, PageIndexes& generatedPage, Double& containersHeight)

at Xceed.Wpf.DataGrid.Views.TableViewItemsHost.GeneratePageAndUpdateIScrollInfoValues(Size availableSize, Boolean measureInvalidated, Double& viewportHeight)

at Xceed.Wpf.DataGrid.Views.TableViewItemsHost.MeasureOverride(Size availableSize)

at System.Windows.FrameworkElement.MeasureCore(Size availableSize)