Questions on UI for WinForms Forum

10 answers

229 views

The column changes and has a date format.
how to hang an event is not a change to ValueChanged?
I want to apply this code:
private void dateTime_ValueChanged (object sender, EventArgs e)
{
SendKeys.Send (".");
}

GridView

answered on 12 Mar 2018

1 answer

191 views

Find Selected Cell Range in RadPivotGridView

I need to find the selected range of cells in a radPivotGridView.

After I load the radPivotGrid with appropriate DataSources' binding, I need to find when the user has made a selection(i.e. once he releases the left mouse button) on the data displayed under it. I tried to use the MouseCapture event but was unable to access the selected info. in any way.

Kindly help.

General Discussions

answered on 12 Mar 2018

1 answer

129 views

autocompletebox problem

i have autocompletebox that is connected to a database to get autocomplete items

the problem is that i can't search with what i type unless i start with the the first letters of the value as an example :

hot tea

i have to type hot to find the value what i want is that i type tea or even 2 letters ea to find the value

AutoCompleteBox

answered on 12 Mar 2018

1 answer

869 views

INotifyPropertyChanged thread safe binding

Dear support,

i my application in use two classes who implements INotifyPropertyChanged to reflect the changes on them automaticly in gridview.

These is working quit nice, when using the gui thread.

my application is listening to multiple comports and starts adding new entry's from another thread to this classes.

INotifyPropertyChanged of courses raises an update for the gridview, so that the grid raises an exception because of the wrong thread

where must in place the invoke to make this call thread safe. in the form itself or on the gridview.

Thank you

Martin Gartmann

GridView

answered on 12 Mar 2018

1 answer

105 views

visible by PageViewItemType.GroupHeaderItem

Hi,

I have RadPageView with a lot of items, which are organized by categories.

I'd like that when I click on a category title (PageViewItemType.GroupHeaderItem?) I display the pages which are related to this GroupHeaderItem.

Eg.

Organisation (GroupHeaderItem)

- Page1

- Page 2

Administration (GroupHeaderItem)

- Admin 1

- Admin 2

I don't see how to accomplish that with RadPageView.

I chose RadPageView over RadTreeView because the management of the forms that are shown are managed perfectly with RadPageView.

Thank you for your help.

PageView

answered on 12 Mar 2018

9 answers

1.2K+ views

RadGridView GridViewTemplate

Hey guys,

My issue is to show some field value (readonly) from parent object in child view template, so that the first comes parent's field value and below it goes detail rows as usual.

In my example I had to add unnecessary public List<string> Details { get; } = new List<string>(); property to make second tab.

Is it possible to add some control to GridViewTemplate without using multiple child views?

Prepared example:

public sealed class Student

{

public int Id { get; set; }

public string FirstName { get; set; }

public string LastName { get; set; }

public string AdditionalInfo { get; set; }

public List<Award> Awards { get; } = new List<Award>();

public List<string> Details { get; } = new List<string>();

public static List<Student> GenerateList()

{

var students = new List<Student>();

for (int studentIndex = 1; studentIndex <= 5; studentIndex++)

{

var student = new Student()

{

Id = studentIndex,

FirstName = $"FirstName {studentIndex}",

LastName = $"LastName {studentIndex}",

AdditionalInfo = $"blah blah blah.... {studentIndex}"

};

for (int awardIndex = 1; awardIndex <= 5; awardIndex++)

{

var award = new Award()

{

FundName = $"FundName {awardIndex}",

Amount = studentIndex * 100 + awardIndex,

};

student.Awards.Add(award);

}

student.Details.Add($"unused text {studentIndex}");

students.Add(student);

}

return students;

}

public sealed class Award

{

public string FundName { get; set; }

public double Amount { get; set; }

}

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

radGridView1.ReadOnly = true;

radGridView1.Columns.Add(new GridViewTextBoxColumn("FirstName"));

radGridView1.Columns.Add(new GridViewTextBoxColumn("LastName"));

GridViewTemplate childTemplate2 = CreateChildTemplate2();

GridViewRelation relation2 = new GridViewRelation(this.radGridView1.MasterTemplate, childTemplate2);

relation2.ChildColumnNames.Add("Details");

this.radGridView1.Relations.Add(relation2);

GridViewTemplate childTemplate1 = CreateChildTemplate1();

GridViewRelation relation = new GridViewRelation(this.radGridView1.MasterTemplate, childTemplate1);

relation.ChildColumnNames.Add("Awards");

this.radGridView1.Relations.Add(relation);

this.radGridView1.DataSource = Student.GenerateList();

radGridView1.AutoGenerateColumns = false;

radGridView1.CellFormatting += RadGridView1_CellFormatting;

this.radGridView1.TableElement.PageViewMode = PageViewMode.ExplorerBar;

var aa = this.radGridView1.TableElement.PageViewProvider;

}

private void RadGridView1_CellFormatting(object sender, CellFormattingEventArgs e)

{

GridViewDataColumn column = e.CellElement.ColumnInfo as GridViewDataColumn;

if (column != null && column.OwnerTemplate.Caption == "aa")

{

e.CellElement.TableElement.Visibility = Telerik.WinControls.ElementVisibility.Hidden;

RadPageViewContentAreaElement content = e.CellElement.TableElement.Parent as RadPageViewContentAreaElement;

RadLabelElement radLabelElement = new RadLabelElement();

if (content.FindDescendant<RadLabelElement>() == null)

{

content.Children.Add(radLabelElement);

var row = (GridViewHierarchyRowInfo)e.CellElement.RowInfo.Parent;                         

                           var student = (Student)row.DataBoundItem;

                           radLabelElement.Text = student.AdditionalInfo;

}

else

{

e.CellElement.TableElement.Visibility = Telerik.WinControls.ElementVisibility.Visible;

RadPageViewContentAreaElement content = e.CellElement.TableElement.Parent as RadPageViewContentAreaElement;

if (content != null)

{

RadLabelElement el = content.FindDescendant<RadLabelElement>();

if (el != null)

{

content.Children.Remove(el);

el.Dispose();

}

private GridViewTemplate CreateChildTemplate1()

{

GridViewTemplate childTemplate = new GridViewTemplate();

this.radGridView1.Templates.Add(childTemplate);

GridViewTextBoxColumn column = new GridViewTextBoxColumn("FundName");

childTemplate.Columns.Add(column);

column = new GridViewTextBoxColumn("Amount");

childTemplate.Columns.Add(column);

childTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;

childTemplate.Caption = "11";

return childTemplate;

}

private GridViewTemplate CreateChildTemplate2()

{

GridViewTemplate childTemplate = new GridViewTemplate();

this.radGridView1.Templates.Add(childTemplate);

GridViewTextBoxColumn column = new GridViewTextBoxColumn();

childTemplate.Columns.Add(column);

childTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;

childTemplate.Caption = "aa";

return childTemplate;

}

Thanks

GridView

answered on 12 Mar 2018

9 answers

774 views

Excel export number format

Hi,

If I apply a Number Format to aggregate values, e.g. #.00 €, this also applies to Print, but not to Export to xlsx (but applies to export to XML). Is is possible to apply number format to xlsx Export as well?

Thanks,

Alex

PivotGrid and PivotFieldList

answered on 12 Mar 2018

3 answers

179 views

Excel-like filtering doesn't preload the CompositeFilterForm appropriately

We use a RadGridView on our WinForms application. We are trying to add filtering, but nothing behaves the way we want it to.

When I go to the filter -> Available Filters -> Equals, I would expect it to load the form with the appropriate options prefilled (i.e., equal to today). However, the form lacks values and does not adapt for which filter I select.

Here's my code so far:

Private Sub radGridView1_CreateCompositeFilterDialog(e As GridViewCreateCompositeFilterDialogEventArgs, senderName As String, column As GridViewDataColumn)

Dim filterDialog As CompositeFilterForm

Dim compositeFilterDescriptor As CompositeFilterDescriptor

If senderName.ToLower() = "equals" Then

compositeFilterDescriptor = New CompositeFilterDescriptor()

compositeFilterDescriptor.LogicalOperator = FilterLogicalOperator.Or

compositeFilterDescriptor.IsFilterEditor = True

compositeFilterDescriptor.FilterDescriptors.Add(New DateFilterDescriptor("colReceived", FilterOperator.IsEqualTo, Date.Now) With {

.IsFilterEditor = True,

.IgnoreTimePart = True

})

compositeFilterDescriptor.FilterDescriptors.Add(New DateFilterDescriptor("colReceived", FilterOperator.IsEqualTo, Date.Now) With {

.IsFilterEditor = True,

.IgnoreTimePart = True

})

ElseIf senderName.ToLower() = "not equal to" Then

compositeFilterDescriptor = New CompositeFilterDescriptor()

compositeFilterDescriptor.LogicalOperator = FilterLogicalOperator.And

compositeFilterDescriptor.NotOperator = True

compositeFilterDescriptor.IsFilterEditor = True

compositeFilterDescriptor.FilterDescriptors.Add(New FilterDescriptor("colReceived", FilterOperator.IsEqualTo, Date.Now))

compositeFilterDescriptor.FilterDescriptors.Add(New FilterDescriptor("colReceived", FilterOperator.None, Nothing))

ElseIf

....

End If

If compositeFilterDescriptor IsNot Nothing Then

filterDialog = New CompositeFilterForm(column, compositeFilterDescriptor)

Else

filterDialog = New CompositeFilterForm()

End If

AddHandler filterDialog.FormClosing, AddressOf test2

e.Dialog = filterDialog

End Sub

This is subscribed to in the MouseUp event of any of the Available Filter menu items (which has some custom values passed in through a lambda):

Private Sub item_MouseUp(sender As Object, column As GridViewDataColumn)

AddHandler radGridView1.CreateCompositeFilterDialog, Sub(s As Object, e2 As GridViewCreateCompositeFilterDialogEventArgs)

radGridView1_CreateCompositeFilterDialog(e2, CType(sender, RadItem).AccessibleName, column)

End Sub

How can I load the window with the appropriate filters prefilled to the form?

It looks like we're on Telerik version 2017.3.1017.

GridView

answered on 09 Mar 2018

1 answer

264 views

Is it possible to hide a floating document window?

How can I hide a floating document window? Right now it seems as though if you right-click, it gives you the option to be able to hide the window, but when you click on it, it doesn't really hide it, it closes it instead. When I switch the closeAction propery to hide, it seems like you can hide the window now. But when it's on the default behavior for closeaction which is closeanddispose, it just closes it. Is that what it's supposed to do? Is there a way to close the window when I hit the x and if I hide it, it actually hides it? I noticed that if I disable the option to hide (which AutoHide is already disabled), it disables the x in the corner of the window too.

Dock

answered on 09 Mar 2018

2 answers

223 views

Columns width on export

Hi,

when I manually resize columns on PivotGrid and then run Export to Excel (or PDF) - row descriptor columns (Day, Aggregates) are same size in Excel, but aggregates columns somehow resized. Is it by design or there is a way to export row descriptor columns width as well?

Alex

PivotGrid and PivotFieldList

answered on 09 Mar 2018