Hi Telerik,

I would like to know if WPF SpreadSheet can create advanced excel sheets as for instance EPPLUS library does.

I am using epplus for creating advanced Excel spreadsheets using .NET, without the need of interop right now and also using Telerik components in my project.

I thought if your spreadsheet is better or doing same thing so I would switch into your spreadsheet component.

 

I read a post that was saying they do not do the same thing and both are needed:

https://www.telerik.com/forums/how-to-upload-an-excel-file-and-how-to-read-its-content-row-by-row

Is it so?

 

If your component does so, please come with a sample/example for showing how.

It is urgent so I would appreciate getting the answer as soon as possible.

Thank you.

Best Regards

Kourosh

Hello,

because Telerik has no editable (enter text not contained in list) combobox (and this is really sad) I'm forced to add the standard ComboBox to a gridview column:

 

            <telerik:GridViewDataColumn UniqueName="AccountName" Header="Gegenkonto" Width="250">
                <telerik:GridViewColumn.CellEditTemplate>
                    <DataTemplate>
                        <ComboBox ItemsSource="{Binding DataContext.AccountList, RelativeSource={RelativeSource FindAncestor, AncestorType={x:Type UserControl}}}"
                                  DisplayMemberPath="AccountName" Text="{Binding AccountName}" IsEditable="True"/>
                    </DataTemplate>
                </telerik:GridViewColumn.CellEditTemplate>
            </telerik:GridViewDataColumn>

The problem is now, that it doesn't move to the next cell when I press the Tab key while editing that column. It works perfectly an the other (telerik) columns.

 

Best Regards,

Raul

 

Hi,

I am using a RadGridView with property ShowColumnSortIndexes set as "True".

The index numbers were displaying properly when I did multi column sorting.

But now the sort index numbers are not displayed since we used a template for GridViewHeaderCell to customize the look of header cells.

Could someone please help me to get the sort index numbers back in GridViewHeaderCell template?

Thanks,

Vijay

 

I have problem with wpf designer from today. In the design view I can only see rad watermark text box and all window controls all others are not visible.

In the output of General and I have these exceptions:

Exception has been thrown by the target of an invocation.
There was an exception when loading the design time assembly '***path***\Design\Telerik.Windows.Controls.Navigation.Design.5.0.dll':

Exception has been thrown by the target of an invocation.
There was an exception when loading the design time assembly '***path***\Design\Telerik.Windows.Controls.Input.VisualStudio.Design.4.0.dll':
Exception has been thrown by the target of an invocation.
There was an exception when loading the design time assembly '***path***\Design\Telerik.Windows.Controls.Input.Design.5.0.dll':
Exception has been thrown by the target of an invocation.
There was an exception when loading the design time assembly '***path***\Design\Telerik.Windows.Controls.Data.VisualStudio.Design.4.0.dll':
Could not load file or assembly 'Telerik.Windows.Controls.Data, Version=2018.1.122.45, Culture=neutral, PublicKeyToken=KEY' or one of its dependencies. The system cannot find the file specified.
There was an exception when loading the design time assembly '***path***\Designer\ShadowCache\i1edbdwb.fee\tj5mcnrj.5ft\Design\Telerik.Windows.Controls.Data.Design.5.0.dll':
Exception has been thrown by the target of an invocation.

I have a grid in which each row has an error and hence shows up as pink/red.  That's as it should be, but the problem is that in this situation, it is impossible to tell which row(s) are selected.  Is there a way to change it so that even when all rows are in error the row selection is still visible?

Thanks!

Have a RadGridView set up with AutoGenerateColumns="True". The grid is populated by:

    SqlDataAdapter dataAdapter = new SqlDataAdapter();
                dataAdapter.SelectCommand = _sqlCommand;
                DataTable dataTable = new DataTable();
                dataAdapter.Fill(dataTable);
                MRSuserSource = dataTable;

All is well at this point the end-user can use the data filter of the grid to sort on whatever column and whatever data. Using AutoGenerateColumns because based on SQL database the number of columns will be more or less.

Looking to create specific filters.

Using some samples and documentation running into a problem on how to do the "column programmatically" as seen in this document "https://docs.telerik.com/devtools/wpf/controls/radgridview/filtering/programmatic#filtering-single-column".

The question becomes how is to define the filter when the columns are automatically created and getting the DataTable to be seen as "GridViewColumn". Maybe missing other details that are being overlooked.

Hi,

 

I was able to find and implement a solution for a simple hierarchy with the rad grid, but I'm stuck on the second level. I could find solutions for a third level, but we need to implement a n level hierarchy. Is this possible and if so how is it possible to implement this with the RadGridView?

 

Best regards

Tobias

Hello, i have no idea how to get the checked/unchecked event in mvvm. My goal is that i wan't do do some cell item calculation when rows are selected/deselected.

Here is my code:

 

There is also a CheckboxColumn. Would this be a better approach and how get the checked/unchecked event?

Following your "https://docs.telerik.com/devtools/wpf/controls/radgridview/getting-started/getting-started2#adding-radgridview-to-the-project" document but can't build the example. Trying to follow document to test programmatically filtering.
When I follow the examples I'm getting these messages in VS2017:
Severity Code Description Project File Line Suppression State
Error  gridView is not supported in a Windows Presentation Foundation (WPF) project. ProgrammaticFiltering F:\How-to and Research\C#\Telerik RadGridView\ProgrammaticFiltering\ProgrammaticFiltering\MainWindow.xaml 11
Error  The type 'local:gridView' was not found. Verify that you are not missing an assembly reference and that all referenced assemblies have been built. ProgrammaticFiltering F:\How-to and Research\C#\Telerik RadGridView\ProgrammaticFiltering\ProgrammaticFiltering\MainWindow.xaml 11
Error  The namespace prefix "local" is not defined. ProgrammaticFiltering F:\How-to and Research\C#\Telerik RadGridView\ProgrammaticFiltering\ProgrammaticFiltering\MainWindow.xaml 11
Error  The namespace prefix "local" is not defined. ProgrammaticFiltering F:\How-to and Research\C#\Telerik RadGridView\ProgrammaticFiltering\ProgrammaticFiltering\MainWindow.xaml 11

Hallo Telerik , 

i think there is an issue but i am not sure. 

1) i using the RadGridView + QueryableCollectionView as ItemSource 

2) I prepared the Collection i think correctly and Data is shown in the Grid also the paging prev and next works as "expected". 

   Debuging show me that the Property of SelectedUiDataItem ( see part of code below ) is called twice.

   First with Value = NULL and second with a Value != NULL which is the new Item set on the new Page. So i think a normal Condition.

Problem comes after Record is changed ! 

If i start changeing a Record in the Grid and Ending the Change with Return or selecting a different Record. 

On Return (i stay in same record in grid) the SelectedUiDataItem is called several times ( counted 22 ) 

1) Time called with value = null 

2-21) Times called for each Record in the Page 

22) Time called with value = null 

How can this been avoided what have i done wrong because in the SelectedItem Property i do not know which is the "real" current item ( = null) at the End and Updates are failing.

thanks br thomas cinatl

<telerik:RadGridView x:Name="LookupListGridCtrl" ItemsSource="{Binding Nodes, Mode=TwoWay}" SelectedItem="{Binding SelectedUiDataItem,Mode=TwoWay}"  Grid.Row="1" 
                             AutoGenerateColumns="false" NewRowPosition="Top" SelectionMode="Single" SelectionUnit="FullRow" 
                             CanUserDeleteRows="True" IsSynchronizedWithCurrentItem="True" CanUserResizeColumns="True" CanUserSearch="True"
                             RowIndicatorVisibility="Visible" Margin="0,0,0,1" ValidationType="Default" 
                             FilteringMode="FilterRow" 
		>

           <telerik:EventToCommandBehavior.EventBindings>
                <telerik:EventBinding Command="{Binding CommandProvider.DoDeleteRow}" EventName="Deleted" RaiseOnHandledEvents="True" PassEventArgsToCommand="True" />
                <telerik:EventBinding Command="{Binding CommandProvider.DoUpdateRow}" EventName="RowEditEnded" RaiseOnHandledEvents="True" PassEventArgsToCommand="True" />
                <telerik:EventBinding Command="{Binding CommandProvider.DoAddNew}" EventName="AddingNewDataItem" RaiseOnHandledEvents="True" PassEventArgsToCommand="True" />
                <telerik:EventBinding Command="{Binding CommandProvider.DoValidatingCell}" EventName="CellValidating" RaiseOnHandledEvents="True" PassEventArgsToCommand="True" />
                <telerik:EventBinding Command="{Binding CommandProvider.DoValidatingRow}" EventName="RowValidating" RaiseOnHandledEvents="True" PassEventArgsToCommand="True" />
                <telerik:EventBinding Command="{Binding CommandProvider.DoSelectionChanging}" EventName="SelectionChanging" RaiseOnHandledEvents="True" PassEventArgsToCommand="True" />
            </telerik:EventToCommandBehavior.EventBindings>

.....

</telerik:RadGridView>
 
        <telerik:RadDataPager PageSize="20"
                          Grid.Row="2" FontSize="12" Margin="0,-1,0,0" 
                          Source="{Binding Items, ElementName=LookupListGridCtrl}"
                          IsTotalItemCountFixed="True"
                          DisplayMode="FirstLastPreviousNextNumeric, Text" />