Hi there,
i'm using the IWorkbookFormatProvider to open an XLSX, modify some values and save it under another name. Works fine.
Is it also possible to open an XLTX (Excel Template) File with the IWorkbookFormatProvider? That would be the much nicer solution than opening a XLSX and save it under another name. If i just change the source of for the FormatProvider to an .xltx an error is thrown.
Thanx for your help.
Mike

Hello. I'd like to change Y-axis scale for RadCartesianChart with BarSeries. I do the following for it: 1) Define the property that is binding data source.
/// <summary>/// Step (selected by a user) for vertical axis./// </summary>private double _currentStep;/// <summary>/// Gets or sets the step (selected by a user) for vertical axis./// </summary>private double CurrentStep{ get { return this._currentStep; } set { this.SetProperty(ref this._currentStep, value); }}2) Use the property in binding in XAML (here I don't display all XAML but if you need I'll do it):
<telerik:RadCartesianChart.VerticalAxis> <telerik:LinearAxis x:Name="verticalAxis" Title="Percents [%]" Minimum="{Binding ChartMinimum}" Maximum="{Binding ChartMaximum}" MajorStep="{Binding CurrentStep}"/></telerik:RadCartesianChart.VerticalAxis>As you can see I also set Minimum and Maximum properties here.
3) I assign MajorStep, Minimum and Maximum properties by the values I've got from modal dialog:
private void raiseScalingMinMaxInputWindow(){ InputScalingValuesNotification inputScalingValuesNotification = new InputScalingValuesNotification(); inputScalingValuesNotification.Title = "Set the scale"; this.InputScalingValuesConfirmationRequest.Raise(inputScalingValuesNotification, returned => { if (returned != null && returned.Confirmed) { this.ChartMinimum = (double)returned.MinimalScalingValue; this.ChartMaximum = (double)returned.MaximalScalingValue; this.CurrentStep = (double)returned.MajorStepValue; } });}I've checked in debugger so values are assigned correctly. Eventually, LinearAxis.Minimum and LinearAxis.Maximum properties are set correctly but LinearAxis.MajorStep is not set. If you open Scale.PNG file attached you can see the example of it. There I set LinearAxis.Minimum == 1, LinearAxis.Maximum == 12 and LinearAxis.MajorStep == 1. But the value of LinearAxis.MajorStep there is equal to 2. Why does it have place? And the second, why do not all fit in the scale window? So I need that the MajorStep must match the specified value (for example 1 in our case) and all Y-axis scale fits to the window size and not to go outside the window.
May be I do something wrong? May be I should use LinearAxis.ActualRange property instead of LinearAxis.Minimum and LinearAxis.Maximum properties? Please tell me and help me. As always, I will be very grateful to you.
Hi,
I would simplify XAML code in my view, can I move ControPanelItems tag and its content into style?
I tryed but I don't understand if it's possible or not.
Hi,
So I have a radcartesianchart with 2 line series. But they are not showing all the data points I assign by data binding. What could the problem be and any possible solutions?
Hi,
Iam not able to see PropertyValueChanged event on RadPropertyGrid control.There is event called ItemChanged,Can I use it instead of PropertyValue changed??
Regards,
Nagasree.
I have a radgridview for which each row details is having another property grid in it.
Here is the similar example I found. http://docs.telerik.com/devtools/wpf/controls/radgridview/row-details/template#complex-rowdetails-template
In this example the only difference with my scenario is Both Club and Player classes are derived from the Same calss named "XYZXYZ".
So the common selected row property can be binded to a property of type "XYZXYZ". or normal "object" type.
And finally I am using this whole grid control as usercontrol in my main window, for this I will bind a SelectedItem property, which need to store the latest selected row datacontext, here the row may be from the outer grid or may be from the inner grids.
Maybe (hopefully) I'm just being stupid.
Consider the xaml below. If the Window is small a scrollbar will appear in the ScrollView. The mousewheel controls scrolling - unless the mouse is over the tab header.
Is there some way to allow scrolling to work / not be swallowed by the RadTabControl
Regards David
<Grid> <ScrollViewer> <telerik:RadTabControl> <telerik:RadTabItem Header="One"> <StackPanel> <Label>One</Label> <Label>Two</Label> <Label>Three</Label> <telerik:RadButton Height="200" Width="200">BIG</telerik:RadButton> </StackPanel> </telerik:RadTabItem> </telerik:RadTabControl> </ScrollViewer></Grid>
I haven't had this issue before. It began as soon as I updated to the latest version of Visual Studio 2015 and updated to the latest release of the WPF Controls.
Here is a style I have created for the GridView.
<Style x:Key="GridViewStyle" TargetType="{x:Type telerik:RadGridView}"> <Setter Property="AutoGenerateColumns" Value="False"/> <Setter Property="EnableLostFocusSelectedState" Value="False"/> <Setter Property="SelectionUnit" Value="FullRow"/> <Setter Property="SelectionMode" Value="Single"/> <Setter Property="GroupRenderMode" Value="Flat"/> <Setter Property="IsReadOnly" Value="True"/> <Setter Property="ScrollViewer.VerticalScrollBarVisibility" Value="Visible"/> <Setter Property="IsFilteringAllowed" Value="False"/> <Setter Property="CanUserDeleteRows" Value="False"/> <Setter Property="CanUserInsertRows" Value="False"/> <Setter Property="GridLinesVisibility" Value="Both"/> <Setter Property="RowIndicatorVisibility" Value="Collapsed"/> <Setter Property="RowHeight" Value="20"/></Style>Every single Setter throws the following error (with the exception of 'GroupRenderMode' and 'ScrollViewer.VerticalScrollBarVisibility'):
The property "[PropertyName]" is not a DependencyProperty. To be used in markup, non-attached properties must be exposed on the target type with an accessible instance property "[PropertyName]". For attached properties, the declaring type must provide static "Get[PropertyName]" and "Set[PropertyName]" methods.
Anyone having similar issues?