Questions on UI for WPF Forum

1 answer

197 views

Only display grid

Hi,
Is it possible to only display the grid of a spreadsheet?
I need spreadsheet functionality (e.g. formulas) but the user interface doesn't require the ribbon or the possibility to have several worksheets. In addition it will be read only (although it would be nice to have some of the cells editable, and I am hoping you will add this feature soon).

Thanks for your help.
RD

Spreadsheet

answered on 08 Nov 2013

1 answer

125 views

Drag & Drop Appointment Time behavior

Hi,

is it possible to change the time steps on drag & drop an appointment? Now the steps are minutes. Is it possible to change the
steps on moving an appointment to 15minutes (12:00 - 12:15 - 12:30 - 12:45 - ....)

Please i Need help!! see attached file

Thanks
Best Regards
Rene

ScheduleView

answered on 08 Nov 2013

5 answers

122 views

Cancelled Drop On RadScheduleView Still Removes Item From ListBox

Hi,

I am dragging items between a ListBox and a RadScheduleView.

On a successful drag and drop the item is removed from the ListBox and added to the RadScheduleView.

If I decide to cancel the Drop in my custom ScheduleViewDragDropBehavior overidden Drop method the RadScheduleView behaves correctly and does not add the item. However the ListBox still removes the item.

How can I stop the ListBox from removing the item when the Drop is cancelled by the RadScheduleView?

Thanks
Anthony

DragAndDrop

answered on 08 Nov 2013

1 answer

209 views

How to edit multiple cells

Hi

I need a hint how to implement the editing of multiple cells with one operation? Using MS-DataGrid I'm waiting in the PreviewKeyDown event for Key.Enter and then copy the entered value from the visual tree to all selected cells.

Is there an easier way to do this with the RadGridView?

UPDATE: Found the RowEditEnded by my self. The only left issue was to leave the edit mode of the next cell after hitting enter. Solved this in the PreviewKeyUp event.

GridView

answered on 08 Nov 2013

1 answer

675 views

RadGridView: Scrollbar resets when data is refreshed or ItemsSource is updated.

My WPF question/problem is similar to the already answered question in this thread for WinForms: http://www.telerik.com/community/forums/winforms/gridview/scroll-bar-position-after-refreshing-grid.aspx

The problem is I don't have a way to get the Grid or Scrollbar controls/elements in the code behind because we are using a strict MVVM approach so this solution does not fix the problem I am having in WPF.

If there are any other tips or tricks you all might have that would work for MVVM, it would be much appreciated. This is one of the last problems we are having with a couple of our windows with large sets of data in a RadGridView. While the user is viewing data
in the Grid, I want the Grid to continue updating AND preserve the scrollbars position within the Grid -- instead of the scrollbars position returning to the top of the Grid. Thanks in advance for any help or guidance!

J

GridView

answered on 07 Nov 2013

2 answers

271 views

[Solved] Remove Aggregates from Group Headers

My grid is displaying aggregate results in the group headers which I want to remove; I only wish to display the aggregates in the column footers. My WPF form uses the following;

<Window x:Class="MainWindow"

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

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

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

xmlns:local="clr-namespace:ProjectRigAnalysis"

Title="MainWindow"

Height="auto"

Width="auto"

WindowStartupLocation="CenterScreen">

<Window.Resources>

<local:NumberToFixedStringConverter x:Key="NumberToFixedString" />

<local:GridViewTemplateSelector x:Key="gridViewTemplateSelector">

<local:GridViewTemplateSelector.belowRequirement>

<DataTemplate>

<TextBlock Text="{Binding RequiredRigYrs, Converter={StaticResource NumberToFixedString}, ConverterParameter=0.00}"

Foreground="Red"

TextAlignment="Right" />

</DataTemplate>

</local:GridViewTemplateSelector.belowRequirement>

<local:GridViewTemplateSelector.meetsRequirement>

<DataTemplate>

<TextBlock Text="{Binding RequiredRigYrs, Converter={StaticResource NumberToFixedString}, ConverterParameter=0.00}"

Foreground="Green"

TextAlignment="Right" />

</DataTemplate>

</local:GridViewTemplateSelector.meetsRequirement>

</local:GridViewTemplateSelector>

<Style TargetType="telerik:GroupHeaderRow">

<Setter Property="ShowGroupHeaderColumnAggregates" Value="False" />

<Setter Property="ShowHeaderAggregates" Value="False" />

</Style>

</Window.Resources>

<Grid>

<Grid.ColumnDefinitions>

<ColumnDefinition Width="*" />

</Grid.ColumnDefinitions>

<telerik:RadGridView Name="rgvWell"

Grid.Row="0"

Grid.Column="0"

HorizontalAlignment="Stretch"

VerticalAlignment="Stretch"

Margin="5"

telerik:StyleManager.Theme="Office_Blue"

AutoGenerateColumns="False"

ShowColumnFooters="True"

ShowGroupFooters="True"

RowIndicatorVisibility="Collapsed"

ItemsSource="{Binding}">

<telerik:RadGridView.GroupDescriptors>

<telerik:GroupDescriptor Member="Period" SortDirection="Ascending" />

<telerik:GroupDescriptor Member="Project" SortDirection="Ascending" />

</telerik:RadGridView.GroupDescriptors>

<telerik:RadGridView.Columns>

<telerik:GridViewDataColumn Header="Project" UniqueName="Project" IsReadOnly="True" />

<telerik:GridViewDataColumn Header="Rig Type" UniqueName="RigType" IsReadOnly="True" />

<telerik:GridViewDataColumn Header="Period" UniqueName="Period" IsReadOnly="True" />

<telerik:GridViewDataColumn Header="Requirement" UniqueName="RequiredRigYrs" IsReadOnly="True" CellTemplateSelector="{StaticResource gridViewTemplateSelector}" >

<telerik:GridViewDataColumn.AggregateFunctions>

<telerik:SumFunction Caption="Requirement: " ResultFormatString="{} {0:0.00}" />

</telerik:GridViewDataColumn.AggregateFunctions>

</telerik:GridViewDataColumn>

<telerik:GridViewDataColumn Header="Capability" UniqueName="AvailableRigYrs" IsReadOnly="False" DataFormatString="{} {0:0.00}">

<telerik:GridViewDataColumn.AggregateFunctions>

<telerik:SumFunction Caption="Capability: " ResultFormatString="{} {0:0.00}" />

</telerik:GridViewDataColumn.AggregateFunctions>

</telerik:GridViewDataColumn>

</telerik:RadGridView.Columns>

</telerik:RadGridView>

</Grid>

</Window>

My problem is that it appears to be ignoring the style in Windows.Resources and displays the aggregated data in the group headers.

GridView

answered on 07 Nov 2013

4 answers

106 views

[Solved] Compare the Header RadTreeViewItem with the Header RadPane

I have a RadPaneGroup and RadTreeview, I compare a RadTreeViewItem Header Header with the RadPane Header and close the RadPane when RadTreeViewItem is selected. How do I?

TreeView
<telerik:RadTreeView  x:Name="tvConfiguracao" IsOptionElementsEnabled="True" Checked="tvConfiguracao_Checked"
      <telerik:RadTreeViewItem x:Name="tviVenda" Header="VENDA" />
      <telerik:RadTreeViewItem x:Name="tviCompra"  Header="COMPRA />                
</telerik:RadTreeView>
Panels
<telerik:RadDocking x:Name="rdPrincipal"                             
            <telerik:RadSplitContainer InitialPosition="DockedBottom">
                <telerik:RadPaneGroup x:Name="rpgFiltros"
                    <telerik:RadPane x:Name="RadPaneCompra" Header="COMPRA"> </telerik:RadPane>
                    <telerik:RadPane x:Name="RadPaneVenda" Header="Venda"> </telerik:RadPane>
                </telerik:RadPaneGroup>
            </telerik:RadSplitContainer>
</telerik:RadDocking>
Event
private void tvConfiguracao_Checked(object sender, Telerik.Windows.RadRoutedEventArgs e)
       {
           var item = rdPrincipal.Panes.FirstOrDefault(i => i.Header == e.Source.Cast<RadTreeViewItem>().Header);
  
           if (item != null)
               item.Cast<RadPane>().IsHidden = true;
       }
Finds no Pane Even with Header, what is wrong?

TreeView

answered on 07 Nov 2013

2 answers

332 views

[Solved] Binding CartesianChart to a Datatable

Hi,

I am following some examples to bind a CartesianChart to a Datatable but I haven't been able to do it, this is my code:

<telerik:RadCartesianChart Name="chartTest" Margin="10" Palette="Grayscale">

<telerik:RadCartesianChart.Behaviors>

<telerik:ChartPanAndZoomBehavior PanMode="Both" ZoomMode="Both"/>

</telerik:RadCartesianChart.Behaviors>

</telerik:RadCartesianChart>

And the code behind:

public class Chemistry

{

public string DESCRIPTION { get; set; }

public double HEATS_IN_PCT { get; set; }

public double HEATS_IN_PCT_LINE { get; set; }

}

public class MainViewModel

{

public ObservableCollection<Chemistry> Data { get; private set; }

public MainViewModel()

{

this.Data = GetTestData();

}

private static ObservableCollection<Chemistry> GetTestData()

{

var result = new ObservableCollection<Chemistry>();

//Custom function to load a stored procedure data

DataTable dtChemistry = DataRetriever.ExecuteRetrieveProcedure("SB_QUALITY_CHEMISTRY");

foreach (DataRow dr in dtChemistry.Rows)

{

result.Add(new Chemistry

{

DESCRIPTION = dr["DESCRIPTION"].ToString(),

HEATS_IN_PCT = (double)dr["HEATS_IN_PCT"],

HEATS_IN_PCT_LINE = (double)dr["HEATS_IN_PCT_LINE"]

});

}

return result;

}

void Configure_Chart()

{

BarSeries barSer = new BarSeries() { Name = "barCrew" };

barSer.ShowLabels = true;

barSer.CombineMode = ChartSeriesCombineMode.Cluster;

barSer.LabelDefinitions.Clear();

barSer.LabelDefinitions.Add(new

ChartSeriesLabelDefinition() { HorizontalAlignment = HorizontalAlignment.Center, VerticalAlignment = VerticalAlignment.Center });

Telerik.Windows.Controls.ChartView.LineSeries lineSer = new Telerik.Windows.Controls.ChartView.LineSeries() { Name = "lineCrew" };

barSer.CategoryBinding = new PropertyNameDataPointBinding() { PropertyName = "DESCRIPTION" };

barSer.ValueBinding = new GenericDataPointBinding<Chemistry, double>() { ValueSelector = Chemistry => Chemistry.HEATS_IN_PCT};

//Also used PropertyNameDataPointBinding("HEATS_IN_PCT");

lineSer.CategoryBinding = new PropertyNameDataPointBinding() { PropertyName = "DESCRIPTION" };

lineSer.ValueBinding = new GenericDataPointBinding<Chemistry, double>() { ValueSelector = Chemistry => Chemistry.HEATS_IN_PCT_LINE };

//Also used PropertyNameDataPointBinding("HEATS_IN_PCT_LINE");

MainViewModel vm = new MainViewModel();

barSer.ItemsSource = vm.Data;

lineSer.ItemsSource = vm.Data;

chartTest.Series.Add(barSer);

chartTest.Series.Add(lineSer);

}

And when I run the application, the series do not appear.

I am missing something?

Thanks,

Alberto

Chart

answered on 07 Nov 2013

1 answer

122 views

Export Number To Excel

Hello!

My radGridView is filled by numbers. I export it to excel. All cells in this file has type 'Common'.
This cause some values look rounded.
For example: real number is 113199997.01, but in excel it looks like '113199997'.

How can I force cell to be 'Numeric' type?

GridView