This is a migrated thread and some comments may be shown as answers.

Why my Spreadsheet has no FormatProviders property

1 Answer 25 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
yi
Top achievements
Rank 1
yi asked on 17 Nov 2018, 04:41 AM

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:x="http://schemas.microsoft.com/winfx/2006/xaml"
             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>

 

 

1 Answer, 1 is accepted

Sort by
0
Accepted
Tanya
Telerik team
answered on 19 Nov 2018, 10:49 PM
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
Get quickly and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Spreadsheet
Asked by
yi
Top achievements
Rank 1
Answers by
Tanya
Telerik team
Share this question
or