Questions on UI for WPF Forum

1 answer

381 views

Basic xslx import/export functionality through a DataSet

I have a project that is currently using the WPF control suite. What I would like to do is import data from an xlsx spreadsheet into a DataSet.

There's really two aspects to the solution. First is a discovery-type service where I can get worksheet names, row by column counts, and then column data types. Secondly, I would like to import the data from a worksheet into a DataSet. Ideally without displaying a spreadsheet control as the process would be automated.

Of secondary importance is the reverse. E.g., open/create a workbook, create a new or clear an existing worksheet, and (append) data to a given worksheet.

Rather than include another vendor's library, I would like to do this with the currently used Telerik suite. I don't see any significant discussion in the product descriptions or forums so I am raising the question here.

Spreadsheet

answered on 22 Apr 2013

22 answers

991 views

WindowsFormsHost in RadWindow

Hi, I have a problem while using RadWindow as the picture showing.
The two windows showed error!
The first window with a gray WinForm DataGridView in a WindowsFormsHost,
and the second window whit a red one.
AS the picture showing, the red window cannot display normally.
Is there any way to solve this problem?

Wish your help.
Thank you !

My xaml code:

    
            <Page x:Class="WpfBrowserApplication9.Page1" 
        
                xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" 
        
                xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
        
                Title="Page1" xmlns:my="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls.Navigation" 
        
                      xmlns:wfi="clr-namespace:System.Windows.Forms.Integration;assembly=WindowsFormsIntegration" 
        
                xmlns:wf="clr-namespace:System.Windows.Forms;assembly=System.Windows.Forms">  
        
                <Grid> 
        
                    <my:RadWindow Name="radWindow1" VerticalAlignment="Top" > 
        
                        <wfi:WindowsFormsHost Height="200" Width="300">  
        
                            <wf:DataGridView x:Name="xy"></wf:DataGridView> 
        
                        </wfi:WindowsFormsHost> 
        
                    </my:RadWindow> 
        
                    <my:RadWindow Name="radWindow2">  
        
                        <wfi:WindowsFormsHost Height="200" Width="300">  
        
                            <wf:DataGridView x:Name="xzy" BackgroundColor="Red"></wf:DataGridView> 
        
                        </wfi:WindowsFormsHost> 
        
                    </my:RadWindow> 
        
                    <telerik:RadButton Height="23" HorizontalAlignment="Right" Margin="0,0,48,2" Name="radButton1" VerticalAlignment="Bottom" Width="75" xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation" Click="radButton1_Click">Button</telerik:RadButton> 
        
                </Grid> 
        
            </Page>

and code behind:

    
            using System;  
        
            using System.Collections.Generic;  
        
            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;  
        
            namespace WpfBrowserApplication9  
        
            {  
        
                /// <summary>  
        
                /// Page1.xaml  
        
                /// </summary>  
        
                public partial class Page1 : Page  
        
                {  
        
                    public Page1()  
        
                    {  
        
                        InitializeComponent();  
        
                        radWindow1.Show();  
        
                    }  
        
                    private void radButton1_Click(object sender, RoutedEventArgs e)  
        
                    {  
        
                        radWindow2.Show();  
        
                    }  
        
                }  
        
            }

Window

answered on 22 Apr 2013

1 answer

382 views

RadPieChart LabelFormat

Hi,

How can i setup the Label Format in RadPieChart?

Thanks

ChartView

answered on 19 Apr 2013

3 answers

331 views

IconTemplate and icon on taskbar is not the same

Hi,

I'm using RadWindow in my project and for each of them I set the following in my xaml:

    <telerik:RadWindow.IconTemplate>
        <DataTemplate>
            <Image Source="Resources/About_32x32.png" Height="24" Width="24" Stretch="Fill" Margin="0 0 3 0" />
        </DataTemplate>
    </telerik:RadWindow.IconTemplate>

When my RadWindow is visible, the ico attache to my RadWindow is clearly the one I have in my IconTemplate. When I minimize my RadWindow on my taskbar, the icon on the taskwindow is the default one (a small window).

Thank's

Window

answered on 19 Apr 2013

4 answers

528 views

[Solved] Custom shape and MVVM

Hi'
I would like to use custom shapes together with MVVM. I have followed the online documentation regarding MVVM and RadDiagram:
http://www.telerik.com/help/wpf/raddiagrams-howto-mvvm.html
But I do not know how to create custom shapes when using MVVM - could you please provide an example?
Thanks,
Michael

Diagram

answered on 19 Apr 2013

1 answer

113 views

Problem with focus on filter 'contains'

I have a RadGridView in a Word AddIn, and my users want to use the "Contains" or "IsEqualTo" features of the filtering.

This AddIn just contains the RadGridView and a pager, so the height of the Addin is only as high as those two added together.

This all works just fine as long as the grid is expanded vertically enough so that the "Contains" or "IsEqualTo" textboxes are over the Addin, but if the grid height is decreased so that "Contains" or "IsEqualTo" is now over some other part of Word, if I try to type into "Contains", I'm really typing into the Word document.

Any assistance on getting the Filter dropdown to retain it's focus?

Thanks!

-Dave

GridView

answered on 19 Apr 2013

2 answers

152 views

[Solved] Custom attributes for element in RichTextBox

Hi

Are there support for custom attributes on individual elements in the RichTextBox, or some possibility to extend the RTB to support it?
What i would like to achieve is to programmatically add, say an ID (or other forms of metadata), to individual elements on the canvas such as an image, a table, footnote and so on, and then be able to track/read the attributes at a later point via exported xaml from the XamlFormatProvider.

Hope this makes sense.

Best regards,
Terje

RichTextBox

answered on 19 Apr 2013

1 answer

468 views

GridView columns not updating as DataTable columns update

I have a RadGridView which has its ItemsSource property bound to the the DefaultView of a DataTable that is created and updated by a ViewModel. The GridView has the AutoGenerateColumns property set to true.

When columns are added to this DataTable and the PropertyChanged event is fired, the new columns are not added to the GridView.

Also, when columns are removed from the DataTable and the PropertyChanged event is fired, the data from these columns is removed from the GridView, but not the columns themselves.

Does the AutoGenerateColumns property only generate columns when the control is initialized? Does this behavior of dynamically removing and adding columns as the underlying DataTable is changed not exist?

GridView

answered on 19 Apr 2013

1 answer

247 views

"Click" Event on TileList fires multiple times

Not sure if this is an issue or I'm just using it wrong....
I am trying to capture when a User "Clicks" a Tile in my Tile List and then perform an Action. The below works okay except that if one Tile is currently selected and you Click a new Tile the Event below will fire 3 times. Twice with the new Tile as an AddedItem thereby firing my Method twice.

How can I do this different so as to not have my method fire multiple times? Is there a different event I should look at? I was able to capture the Tile's MouseDoubleClick event but that isn't truly what I want to do.

This is a WPF 4.5 app using Telerik release(2013.1.403.45).

<telerik:RadTileList x:Name="AppLaunchPad"

GroupTemplate="{StaticResource GroupTemplate}"

ScrollViewer.HorizontalScrollBarVisibility="Visible"

cal:Message.Attach="[Event SelectionChanged] = [Action OpenDoorway($eventArgs)]">

public void OpenDoorway(SelectionChangedEventArgs e)

{

var s = e.Source as RadTileList;

var t = e.AddedItems.Count;

if (t > 0)

{

windowManager.Alert("Testing", "This came from the Launcher: " + s.SelectedItem.ToString());

}

TileList

answered on 19 Apr 2013

1 answer

141 views

"Unhandled exception" in telerik code when editing xaml/raddocking

I get the following exception when I paste from your WPF Controls Examples and reduce the contents of RadPanes (See xaml below).

Any suggestions for a way forward?



Anders, Denmark



Object reference not set to an instance of an object.

   at Telerik.Windows.Controls.InternalWindow.PopupWindowHost.PopupHostManagerBase.GetManager(DependencyObject obj) in c:\TB\135\WPF_Scrum\Release_WPF\Sources\Development\Controls\Navigation\Window\InternalWindow\PopupWindowHost.cs:line 308

   at Telerik.Windows.Controls.InternalWindow.SinglePopupWindowHost.GetHostManager() in c:\TB\135\WPF_Scrum\Release_WPF\Sources\Development\Controls\Navigation\Window\InternalWindow\SinglePopupWindowHost.cs:line 22

   at Telerik.Windows.Controls.InternalWindow.PopupWindowHost.Open(Boolean isModal) in c:\TB\135\WPF_Scrum\Release_WPF\Sources\Development\Controls\Navigation\Window\InternalWindow\PopupWindowHost.cs:line 77

   at Telerik.Windows.Controls.WindowBase.ShowWindow(Boolean isModal) in c:\TB\135\WPF_Scrum\Release_WPF\Sources\Development\Controls\Navigation\Window\WindowBase.cs:line 891

   at Telerik.Windows.Controls.Docking.ToolWindow.Open() in c:\TB\135\WPF_Scrum\Release_WPF\Sources\Development\Controls\Docking\Docking\Parts\ToolWindow.cs:line 121

   at Telerik.Windows.Controls.RadDocking.OpenInToolWindow(RadSplitContainer container) in c:\TB\135\WPF_Scrum\Release_WPF\Sources\Development\Controls\Docking\Docking\Docking\RadDocking.cs:line 797

   at Telerik.Windows.Controls.RadDocking.InitializeSplitContainer(RadSplitContainer container) in c:\TB\135\WPF_Scrum\Release_WPF\Sources\Development\Controls\Docking\Docking\Docking\RadDocking.cs:line 1325

   at Telerik.Windows.Controls.RadDocking.OnApplyTemplate() in c:\TB\135\WPF_Scrum\Release_WPF\Sources\Development\Controls\Docking\Docking\Docking\RadDocking.cs:line 180

   at System.Windows.FrameworkElement.ApplyTemplate()

   at Microsoft.Expression.Platform.WPF.WpfViewNodeManager.EnsureElementInDictionary(Object root, ViewNode knownAncestor)







<

telerik:RadDocking x:Name="radDocking1"

Grid.Row="1" Margin="0 0 0 10"

BorderThickness="0"

Padding="0" Background="{StaticResource LightGrayBrush}">

<telerik:RadDocking.DocumentHost>

<telerik:RadSplitContainer>

<telerik:RadPaneGroup>

<telerik:RadDocumentPane Title="Description">

</telerik:RadDocumentPane>

<telerik:RadPane Header="NotDragable" CanFloat="False">

</telerik:RadPane>

</telerik:RadPaneGroup>

</telerik:RadSplitContainer>

</telerik:RadDocking.DocumentHost>

<telerik:RadSplitContainer MaxWidth="600" telerik:DockingPanel.InitialSize="210,150"

Name="LeftContainer" InitialPosition="DockedLeft">

<telerik:RadPaneGroup x:Name="Group1">

<telerik:RadPane x:Name="Pane1" Header="Server Explorer">

</telerik:RadPane>

<telerik:RadPane x:Name="Pane2" Header="Toolbox">

</telerik:RadPane>

</telerik:RadPaneGroup>

</telerik:RadSplitContainer>

<telerik:RadSplitContainer MaxWidth="679" telerik:DockingPanel.InitialSize="210,150"

x:Name="RightContainer" InitialPosition="DockedRight">

<telerik:RadPaneGroup x:Name="Group2">

<telerik:RadPane x:Name="Pane3" Header="Solution Explorer">

</telerik:RadPane>

<telerik:RadPane x:Name="Pane4" Header="Properties">

</telerik:RadPane>

</telerik:RadPaneGroup>

</telerik:RadSplitContainer>

<telerik:RadSplitContainer InitialPosition="FloatingDockable"

telerik:RadDocking.FloatingLocation="450, 250"

telerik:RadDocking.FloatingSize="300, 220">

<telerik:RadPaneGroup>

<telerik:RadPane Header="Not Document Pane" CanDockInDocumentHost="False">

</telerik:RadPane>

</telerik:RadPaneGroup>

</telerik:RadSplitContainer>

<telerik:RadSplitContainer telerik:DockingPanel.InitialSize="200,180"

x:Name="BottomContainer" InitialPosition="DockedBottom">

<telerik:RadPaneGroup x:Name="Group3">

<telerik:RadPane x:Name="Pane5" Header="Output">

</telerik:RadPane>

<telerik:RadPane x:Name="Pane6" Header="Error List">

</telerik:RadPane>

</telerik:RadPaneGroup>

</telerik:RadSplitContainer>

</telerik:RadDocking>

Docking

answered on 19 Apr 2013