Questions on UI for WPF Forum

1 answer

128 views

Format % but do not multiply by 100 and show empty when null

Hello,

How do I format data (e.g. in GridViewDataColumn) to have a "%" prefix?
We do not want the value to be multiplied by 100 (e.g. when user enters "1", it should show "1%" instead of "100%")

Also, when data is null, it should show an empty field, "", instead of "%".

Thank you,

Jan

GridView

answered on 12 Dec 2018

2 answers

228 views

[Solved] Event when user pins/unpins a row

Hello,

I have a grid with a GridViewPinRowColumn and I need to detect, when the user has pinned or unpinned a row. Is there an event which I can subscribe?

Best regards,
Thomas

GridView

answered on 12 Dec 2018

1 answer

179 views

Show certain Group Aggregate depending on groupings

Is there a way of changing what group headers are shown depending on which columns have been grouped?

I have a small banking application which displays a breakdown of all fees.

AllFees.PNG shows all of the fees ungrouped

GroupedByDesk.PNG shows the desired behaviour of grouping on any column other than currency (sums all of the rows 'Amount' values exchanged into a single currency)

GroupedByCurrency shows the desired behaviour of grouping by currency alone (sums all of the amounts in that currency)

Where it gets more interesting is if you group by Currency and another column. The desired behaviour is to show ONLY the exchanged sum in the header down in each group, and child group etc., until the Currency grouping, where you ONLY display the currency sum, as demonstrated in GroupByDeskThenCurrency.PNG

I have some working code that prevents the exchanged sum aggregate being displayed (as long as the Currency is the first grouping), but it's still not quite what the desired outcome is. Said code:

private void GridView_Grouped(object sender, Telerik.Windows.Controls.GridViewGroupedEventArgs e)
{
foreach (Telerik.Windows.Controls.GridViewColumn col in this.GridView.Columns)
{
col.AggregateFunctions.Clear();
}

bool groupedByCurrency = false;
bool addedFxdSumAggregate = false;

foreach (ColumnGroupDescriptor gd in this.GridView.GroupDescriptors)
{
if (gd.DisplayContent.ToString() == "Currency")
{
groupedByCurrency = true;
this.GridView.Columns["Currency"].AggregateFunctions.Add(this.currSumFunction);
}

if (!groupedByCurrency && !addedFxdSumAggregate)
{
this.GridView.Columns[gd.DisplayContent.ToString()].AggregateFunctions.Add(this.fxableSumFunction);
addedFxdSumAggregate = true;
}
}

GridView

answered on 11 Dec 2018

9 answers

1.1K+ views

How to build multi level hierarchy with unknown levels?

Hi,

I'm having difficulty trying to build a multi level hierarchy that has unknown levels.
I've read loads and loads of examples but they all assume the number of levels are known. However, in my case I may have "x" number of nodes, which may have "x" number of child nodes, which may have "x" number of grandchild nodes etc etc.

My data is drawn from an SQL database where I use the SQL 2008 HierarchyID data type to represent my hierarchy in the database.

I've built the following class for my products:

public class Products : INotifyPropertyChanged, IDataErrorInfo

{

private Int64 m_ID;

private SqlHierarchyId m_Hierarchy;

private string m_Name;

private Int16 m_Level;

private ObservableCollection<Products> m_ChildProducts;

// Default Constructor

public Products()

{

ChildProducts = new ObservableCollection<Products>();

}

//Properties

public Int64 ID

{

get

{

return m_ID;

}

set

{

m_ID = value;

OnPropertyChanged(new PropertyChangedEventArgs("ID"));

}

public SqlHierarchyId Hierarchy

{

get

{

return m_Hierarchy;

}

set

{

m_Hierarchy = value;

OnPropertyChanged(new PropertyChangedEventArgs("Hierarchy"));

}

public Int16 Level

{

get

{

return m_Level;

}

set

{

m_Level = value;

OnPropertyChanged(new PropertyChangedEventArgs("Level"));

}

public String Name

{

get

{

return m_Name;

}

set

{

m_Name = value;

OnPropertyChanged(new PropertyChangedEventArgs("Name"));

}

public ObservableCollection<Products> ChildProducts

{

get

{

return m_ChildProducts;

}

set

{

m_ChildProducts = value;

OnPropertyChanged(new PropertyChangedEventArgs("ChildProducts"));

}

//INotifyPropertyChanged Event

public event PropertyChangedEventHandler PropertyChanged;

public void OnPropertyChanged(PropertyChangedEventArgs e)

{

if (PropertyChanged != null)

PropertyChanged(this, e);

}

I then have the following method to download data from the database which I need to some how construct an ObservableCollection() which contains nodes "x" number of levels deep. Please note that some nodes may be 2 levels deep, others may be 3 levels deep, so forth and so forth.

public static ObservableCollection<Products> GetProductsHierarchy()

{

ObservableCollection<Products> products = new ObservableCollection<Products>();

SqlConnection connection = new SqlConnection(DBConnection.GetConnection().ConnectionString);

string selectStatement = "SELECT ID, Hierarchy, Name " +

"FROM SpecProducts " +

"WHERE (EnableDisable IS NULL)" +

"ORDER BY Hierarchy";

SqlCommand selectCommand = new SqlCommand(selectStatement, connection);

try

{

connection.Open();

SqlDataReader reader = selectCommand.ExecuteReader();

while (reader.Read())

{

Products product = new Products();

product.ID = (Int64)reader["ID"];

product.Name = reader["Name"].ToString();

product.Hierarchy = (SqlHierarchyId)reader["Hierarchy"];

product.Level = (Int16)product.Hierarchy.GetLevel();

//**** How to create recursive loop to add unknown levels to nodes???? ****

products.Add(product);

}

return products;

}

catch (SqlException ex)

{

throw ex;

}

finally

{

connection.Close();

}

I've found a post that discusses unlimited nodes, http://www.telerik.com/community/forums/wpf/treeview/templated-node-multiple-parent.aspx , but in the example given it has the following lines of code to build up unlimited levels:

ObservableCollection<Node> nodes = new ObservableCollection<Node>();

nodes.Add(new Node("Company"));

nodes[0].Nodes.Add(new Node("Department"));

nodes[0].Nodes[0].Nodes.Add(new Node("here are you"));

nodes[0].Nodes[0].Nodes[0].Nodes.Add(new Node("even deeper"));

radTreeView1.ItemsSource = nodes;

Surely this is only valid providing you know the number of levels before runtime?

I guess I'm essentially looking for a generic hierarchy builder where the number of levels are unknown until runtime, i.e. when data is download from database.

Any help would be greatly appreciated.

Thanks for your time.

TreeView

answered on 11 Dec 2018

1 answer

150 views

Bug in external row details

Hello,

This big can be reproduced in your demo application:

Open the GridView examples
In the available examples, select "Selection and Usability | Row Details"
Select a rowin the grid view
In the external Details Presenter, select Visible: nothing is displayed in the bottom. You have to select another row and then come back to show the details.

Also another problem: if the external details is inside a ContentPresenter (collapsed at the beginning), it can't find the gridview.

To test this, replace your Border with a ContentPresenter.

GridView

answered on 10 Dec 2018

10 answers

264 views

Pixelated view not working

I am currently using RAD shapes and Text on Rad Diagram Canvas in WPF

I would like to know I can get pixel view for two color Displays, like attached Image [296x128.PNG].

Currently I can see different effects are supported, can you please let me know how can I modify rad diagram canvas to display two color (Black and White) mode, and also I need to then export it to monochrome bitmap.

Thanks.

Diagram

answered on 10 Dec 2018

1 answer

106 views

Use RadChartView into WPF

Hello Expertise,

I want to use RadChartView control into my new project WPF.

But problem is that i can't see "RadChartView" into VS 20017 ToolBox. please need assistance.

Thanks,

Maksud

ChartView

answered on 10 Dec 2018

2 answers

205 views

Overlapping RadPanes

Hi,

I've got a problem with overlapping RadPanes when using RadDocking Root Compass.

The case is that when I'm dragging RadPanes to the one side of the Root Compass, the Rad Panes on the other side gets overlapped by the dragged ones.
Description may not be clear, so here is simple gif showing the problem:

Pane "Inner Pane C" get overlapped, when dragging new panes to the left side of the Root Compass. It works for every side of the Root Compass.

Is there a simple solution for this issue? Ex. modifying the docked Panes width, to fit them all in the RadDocking control? I've searched on this forum and in the documentation, and couldn't find the solution.

Best regards,

Mateusz

Docking

answered on 07 Dec 2018

2 answers

453 views

RadRichTextBox "invisible" caret

Hello,

Could you, please, help me to make RadRichTextBox's caret visible?

I've tried to use solution with custom CaretFactory from this post... No results, unfortunately

Is it possible to make caret visible?

Here is some code examples of RadRichTextBox usage (my telerik version: 2018.3.911.45):

<telerik:RadRichTextBox x:Name="descriptionRichBox"

Grid.Row="0" Grid.Column="1" Margin="0,2,0,5" MinHeight="70"

BorderThickness="{Binding IsReadOnly, Converter={localConverters:BoolToBorderThicknessConverter}}"

FontSize="{Binding Source={StaticResource MediumNormal}, Path=Size}"

FontFamily="{Binding Source={StaticResource MediumNormal}, Path=Family}"

IsReadOnly="{Binding IsReadOnly}" GotFocus="RichTextBox_GotFocus"

DocumentInheritsDefaultStyleSettings="True" IsSpellCheckingEnabled="False"

/>

<telerik:HtmlDataProvider RichTextBox="{Binding ElementName=descriptionRichBox}"

Html="{Binding EditableObject.Description, Mode=TwoWay}"

/>

<Style TargetType="telerik:Caret">

<Setter Property="Template">

<Setter.Value>

<ControlTemplate TargetType="telerik:Caret" >

<Grid x:Name="RootElement" >

<ScrollViewer x:Name="ContentElement" BorderThickness="0" Padding="0" />

<Rectangle x:Name="Rectangle" />

</Grid>

</ControlTemplate>

</Setter.Value>

</Setter>

<Setter Property="HorizontalAlignment" Value="Left" />

<Setter Property="VerticalAlignment" Value="Top" />

<Setter Property="AcceptsReturn" Value="True" />

<Setter Property="CaretBrush" Value="Black"/>

<Setter Property="Padding" Value="0" />

<Setter Property="Foreground" Value="Transparent" />

</Style>

public class DescriptionCaretFactory : ICaretFactory

{

public Caret CreateCaret()

{

return new Caret { Width = 2, MinWidth = 2, Height=5,

IsBlinking = true, IsEnabled = true,

Visibility = System.Windows.Visibility.Visible,

ToolTip = "test caret",

CaretBrush = System.Windows.Media.Brushes.Black, };

}

Best regards,

Ivan.

RichTextBox

answered on 07 Dec 2018

1 answer

441 views

Print Workbook wihout use of RadSpreadsheet

I have created a Telerik.Windows.Documents.Spreadsheet.Model.Workbook (with a single Worksheet) programmatically. I can export it to Excel no problem.

How can I print it?

I have found the following article: https://docs.telerik.com/devtools/wpf/controls/radspreadsheet/features/ui-printing#How_to_print_RadSpreadsheet

...but this would force me to work with the UI Control, which I don't want to do. Is it possible to print the Worksheet without the use of the UI control. I still want all the printing options, such as setting a header and footer, forcing the first row to be repeated on every page, control over portrait vs. landscape printing, etc.

Is there any way to do this?

Thanks in advance,

Bartek

Spreadsheet

answered on 06 Dec 2018