Telerik Forums
UI for WPF Forum
1 answer
151 views

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

Nikolay Demirev
Telerik team
 answered on 28 Sep 2016
4 answers
360 views

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.

Dmitry
Top achievements
Rank 1
 answered on 28 Sep 2016
7 answers
1.0K+ views
Hi,

I have a RadGridView with CanUserSelect="True". I define my columns manually using nested GridViewDataColumn. Each column is bound to some property of some object. The properties only have a 'get' method. When i run my app, I cannot select the content of the cells (for copy operation). I noticed that if i change the properties of the underlying objects and add an empty setter, I get to edit.

How can I do the same things without having to change my properties? I want to be able to have readonly data that I CAN select. Is there a way to tell the columns or the whole  grid that they should be selectable? (I thought btw that 'CanUserSelect' should take care of that?)

brgds
Frederic
NA
Top achievements
Rank 1
 answered on 28 Sep 2016
10 answers
186 views

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.

Dario Concilio
Top achievements
Rank 2
 answered on 27 Sep 2016
3 answers
120 views

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?

 

D
Top achievements
Rank 1
 answered on 27 Sep 2016
3 answers
567 views

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.

Stefan
Telerik team
 answered on 27 Sep 2016
6 answers
255 views
Hello. I display labels on BarSeries. Please see the picture in 'BarChartLabels.PNG' file. But as you can see there, sometimes the numerical values of labels are too long and look ugly. How to round fractional part of labels of BarSeries to thousandths for example?
Dmitry
Top achievements
Rank 1
 answered on 27 Sep 2016
2 answers
90 views

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. 

 

Dharmavaram
Top achievements
Rank 1
 answered on 27 Sep 2016
1 answer
1.2K+ views

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>

Martin Ivanov
Telerik team
 answered on 27 Sep 2016
1 answer
122 views

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?

Martin
Telerik team
 answered on 27 Sep 2016
Narrow your results
Selected tags
Tags
GridView
General Discussions
Chart
RichTextBox
Docking
ScheduleView
ChartView
TreeView
Diagram
Map
ComboBox
TreeListView
Window
RibbonView and RibbonWindow
PropertyGrid
DragAndDrop
TabControl
TileView
Carousel
DataForm
PDFViewer
MaskedInput (Numeric, DateTime, Text, Currency)
AutoCompleteBox
DatePicker
Buttons
ListBox
GanttView
PivotGrid
Spreadsheet
Gauges
NumericUpDown
PanelBar
DateTimePicker
DataFilter
Menu
ContextMenu
TimeLine
Calendar
Installer and Visual Studio Extensions
ImageEditor
BusyIndicator
Expander
Slider
TileList
PersistenceFramework
DataPager
Styling
TimeBar
OutlookBar
TransitionControl
FileDialogs
Book
ToolBar
ColorPicker
TimePicker
MultiColumnComboBox
SyntaxEditor
VirtualGrid
Wizard
ExpressionEditor
NavigationView (Hamburger Menu)
WatermarkTextBox
DesktopAlert
BarCode
SpellChecker
DataServiceDataSource
EntityFrameworkDataSource
RadialMenu
ChartView3D
Data Virtualization
BreadCrumb
LayoutControl
ProgressBar
Sparkline
TabbedWindow
ToolTip
CloudUpload
ColorEditor
TreeMap and PivotMap
EntityFrameworkCoreDataSource (.Net Core)
HeatMap
Chat (Conversational UI)
VirtualizingWrapPanel
Calculator
NotifyIcon
TaskBoard
TimeSpanPicker
BulletGraph
Licensing
WebCam
CardView
DataBar
FilePathPicker
PasswordBox
SplashScreen
Callout
Rating
Accessibility
CollectionNavigator
Localization
AutoSuggestBox
Security
VirtualKeyboard
HighlightTextBlock
TouchManager
StepProgressBar
Badge
OfficeNavigationBar
ExpressionParser
CircularProgressBar
SvgImage
PipsPager
SlideView
AI Coding Assistant
+? more
Top users last month
Bohdan
Top achievements
Rank 3
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Elliot
Top achievements
Rank 1
Iron
Iron
Iron
Sunil
Top achievements
Rank 1
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Bohdan
Top achievements
Rank 3
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Elliot
Top achievements
Rank 1
Iron
Iron
Iron
Sunil
Top achievements
Rank 1
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?