Why my Spreadsheet has no FormatProviders property

[yi]

Hi,

      I'm using RadSpreadsheet recently to deal with Excel and CSV files. But I found my RadSpreadsheet control has no FormatProviders property and I could not register XlsxFormatProvider and CsvFormatProvider. Seems I've added all the references required and reset the Theme file. Is there anything I ignored? My Telerik Controls Version is Ver. 2017 Q1, is that low version a suspicious cause for the problems?

    Here's my XAML snippet:

<UserControl x:Class="ProgLogMgnt.Views.ExcelView"

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

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

             xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"

             xmlns:models="clr-namespace:ProgLogMgnt.Models"

             xmlns:controls="clr-namespace:Mango.Controls;assembly=Mango.Wpf"

             xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation"

             xmlns:converters="clr-namespace:Mango.Converters;assembly=Mango.Wpf"

             xmlns:mango="clr-namespace:Mango;assembly=Mango.Wpf"

             xmlns:xlsx="clr-namespace:Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx;assembly=Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml"

             xmlns:d="http://schemas.microsoft.com/expression/blend/2008"

             xmlns:local="clr-namespace:ProgLogMgnt.Views"

             mc:Ignorable="d"

             d:DesignHeight="450" d:DesignWidth="800">

    <Grid>

        <telerik:RadSpreadsheet x:Name="Excelsheet">

             !--No FormatProviders property intelliSensed here and could not continue--!

            <telerik:RadSpreadsheet.FormatProviders> </telerik:RadSpreadsheet.FormatProviders>

        </telerik:RadSpreadsheet>

    </Grid>

</UserControl>

Here is my Theme file:

<ResourceDictionary.MergedDictionaries>
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/System.Windows.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.Data.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.Input.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.Navigation.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.DataVisualization.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.Chart.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.Diagrams.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.Diagrams.Extensions.xaml/>
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.Docking.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.Expressions.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.GanttView.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.GridView.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.ImageEditor.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.RibbonView.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.RichTextBoxUI.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.ScheduleView.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Controls.Spreadsheet.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Documents.xaml" />
    <ResourceDictionary Source="/Telerik.Windows.Themes.Office2013;component/Themes/Telerik.Windows.Documents.Proofing.xaml" />
    <ResourceDictionary Source="Themes/FrameworkTheme.xaml" />
</ResourceDictionary.MergedDictionaries>

 

 

[Tanya]

Hi Yi,

The FormatProviders dependency property has been introduced in R1 2018 and this since you are using an earlier version of RadSpreadsheet, it is unavailable there. I would advise you to upgrade the controls to the latest version so you can benefit from the latest features and bug fixes introduced in it. However, if this is not possible, you can register the format providers you would like to use through the WorkbookFormatProvidersManager static class. 

Hope this is helpful.

Regards,
Tanya
Progress Telerik