Questions on UI for WinForms Forum

4 answers

724 views

[Solved] Export Multiple Gridview to single Excel Sheet with Multiple sheet

Hello
I want to export data from multiple RadGridView to a single Excel file with multiple sheet. What I tried now it can export only 1 gridview to 1 file, if I try to export to same file, it was overwritten.

I did a search and found that it can't be done during last year. not sure what is the current status now.

http://www.telerik.com/community/forums/winforms/gridview/export-to-excel-with-gridview.aspx

Could anyone provide me an example please?

Best Regards,
Smith

GridView

answered on 22 Nov 2017

4 answers

398 views

[Solved] GanttView Time Range Day Does not display properly

I have a gantt view that I want to populate with data, but when i set it to the day range the the major timeline grid sizing seems to scale to the size of the container rather than to the secondary time line grid (see attached picture). The gantt view items are properly scaled to the major grid, but the secondary timeline markings are wrong. Is there a setting that i can use to make the major timeline grid marks stretch over all the available secondary timeline markings?

This is running on windows 10, telerik ui for winforms 2016 R3.

To replicate the issue create a new project with a gantview and use the following code in the load function.

RadGanttView1.GanttViewElement.GraphicalViewElement.TimelineRange = Telerik.WinControls.UI.TimeRange.Day
RadGanttView1.GanttViewElement.GraphicalViewElement.TimelineStart = Today
RadGanttView1.GanttViewElement.GraphicalViewElement.TimelineEnd = Today.AddHours(24)
Dim tasks As New DataTable("Tasks")
tasks.Columns.Add("Id", GetType(Integer))
tasks.Columns.Add("ParentId", GetType(Integer))
tasks.Columns.Add("Title", GetType(String))
tasks.Columns.Add("Start", GetType(DateTime))
tasks.Columns.Add("End", GetType(DateTime))
tasks.Columns.Add("Progress", GetType(Decimal))
Dim links As New DataTable("Links")
links.Columns.Add("StartId", GetType(Integer))
links.Columns.Add("EndId", GetType(Integer))
links.Columns.Add("LinkType", GetType(Integer))
Dim data As New DataSet()
data.Tables.Add(tasks)
data.Tables.Add(links)
tasks.Rows.Add(1, 0, "Summary task title", Today.AddHours(11), Today.AddHours(12), 30D)
tasks.Rows.Add(2, 1, "First child task title", Today.AddHours(11), Today.AddHours(11.5), 10)
tasks.Rows.Add(3, 1, "Second child task title", Today.AddHours(11.5), Today.AddHours(12), 20D)
tasks.Rows.Add(4, 1, "Milestone", Today.AddHours(12), Today.AddHours(12), 0D)
links.Rows.Add(2, 3, 1)
links.Rows.Add(3, 4, 1)
Me.RadGanttView1.GanttViewElement.TaskDataMember = "Tasks"
Me.RadGanttView1.GanttViewElement.ChildMember = "Id"
Me.RadGanttView1.GanttViewElement.ParentMember = "ParentId"
Me.RadGanttView1.GanttViewElement.TitleMember = "Title"
Me.RadGanttView1.GanttViewElement.StartMember = "Start"
Me.RadGanttView1.GanttViewElement.EndMember = "End"
Me.RadGanttView1.GanttViewElement.ProgressMember = "Progress"
Me.RadGanttView1.GanttViewElement.LinkDataMember = "Links"
Me.RadGanttView1.GanttViewElement.LinkStartMember = "StartId"
Me.RadGanttView1.GanttViewElement.LinkEndMember = "EndId"
Me.RadGanttView1.GanttViewElement.LinkTypeMember = "LinkType"
Me.RadGanttView1.GanttViewElement.DataSource = data
Me.RadGanttView1.Columns.Add("Start")
Me.RadGanttView1.Columns.Add("End")

GanttView

answered on 22 Nov 2017

3 answers

105 views

I want to know if a specific point is the sea or land.

Hello, I am a user using telerik winforms.
I am gratefully using radmap.
But I can not solve this problem, so I leave a post.

I am doing research to simulate drifting objects in the ocean.
But since a drifting object can not pass through the ground, I need a way to know if the specific coordinates are in the ground or in the sea.
It seems difficult to solve this method using 'Elevation'.

to sum it up,
Whether there is a way to know whether a specific point is the sea or the land.

Thank you.

Map

answered on 22 Nov 2017

4 answers

805 views

[Solved] FolderBrowserDialog in PropertyGrid

Hi,
In my application I use RadPropertyGrid and I create set of properties for it in my code using RadPropertyStore.

Before I started to use RadPropertyGrid all properties were displayed in group-boxes with different controls like text-box, drop-down and button. It was a mess.
One of the properties should contain path to some local directory. And in old implementation it was displayed by text box and browse button that was opening FolderBrowserDialog
.
As you might already imagine, my question is how can I insert FolderBrowserDialog to RadPropertyGrid?
What I have managed to do is below:

public partial class SettingsManager : UserControl

{

public SettingsManager()

{

InitializeComponent();

_propertyStore = CreateProperties();

radPropertyGrid1.SelectedObject = _propertyStore;

radPropertyGrid1.PropertySort = PropertySort.CategorizedAlphabetical;

}

private RadPropertyStore _propertyStore;

private PropertyStoreItem _defaultSaveDirectory;

private RadPropertyStore CreateProperties()

{

var result = new RadPropertyStore();

_defaultSaveDirectory = new PropertyStoreItem(typeof(string),

"DefaultSaveFolder",

Properties.Settings.Default.DefaultSaveFolderPath,

"Default directory for saving snapshot and configuration files.",

"Save Snapshot/Configuration",

false);

_defaultSaveDirectory.PropertyChanged += OnDefaultSaveDirectoryChanged;

result.Add(_defaultSaveDirectory);

return result;

}

void OnDefaultSaveDirectoryChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e)

{

var folderDialog = new FolderBrowserDialog {

Description = Resources.DefaultLocationDialogHelp,

ShowNewFolderButton = true

};

if (DialogResult.OK == folderDialog.ShowDialog())

{

_defaultSaveDirectory.PropertyChanged -= OnDefaultSaveDirectoryChanged;

_defaultSaveDirectory.Value = folderDialog.SelectedPath;

_defaultSaveDirectory.PropertyChanged += OnDefaultSaveDirectoryChanged;

Properties.Settings.Default.DefaultSaveFolderPath = folderDialog.SelectedPath;

}

But I have two problems with this implementation:
1) FolderBrowserDialog opens on initialization
2) There is no such a thing like Click event for PropertyStoreItem, so user have to really change the property value in order to FolderBrowserDialog to appear

PropertyGrid

answered on 21 Nov 2017

8 answers

429 views

Change GridViewComboBoxColumn filtering type

I have a telerik GridView contains ComboBoxcolumn, the filtering type when i search inside the Combobox Column is 'StartWith'. and I want to change it to 'Contains'. How could i do it?

GridView

answered on 21 Nov 2017

1 answer

291 views

Tool Window

Hi sir/Madam,

I am a programmer evaluating the raddock

Created the form and add raddock control.

I hv created one text box in right side tool window.

I hv a radform as a document in the dock container.

I need to access the tool window text box and pass the value to the text box from the

document form.

I am unable to access the text box control which is resided in the tool window of raddock.

Please help me for the above.

Regards

Dock

answered on 21 Nov 2017

1 answer

233 views

RadMaskedEditBox value minus mask

It's really not that complicated to manually remove "mask" characters from a string but I was curious if this control already has this ability built in?

Here's an example:

assume ctrl = RadMaskedEditBox

ctrl.Mask = "00000-9999"

ctrl.Text = "_____-____"

ctrl.MaskType = Standard

If the user gets to this input box and types in "12345" and I check ctrl.Value I get this: "12345-____" when what I really want is "12345"

If I'm missing something, please advise otherwise, i'll just grunt my way through it :)

Thanks everyone!!!

-Curtis

MaskedEditBox

answered on 21 Nov 2017

1 answer

110 views

filters in a GridComboBoxColumn

I have a GridComboBoxColumn and would like to do searches according to what is being written, right now I have it with a datasource by code, but it is not enabled for it to be written and filtered, now I digit a letter and find the first coincidence, I would like it to search for me the whole text chain what I type, not just the beginning, I would like it to be more interactive, and to be editable, not just selectable. Does anyone know how?
Thanks in advance

GridView

answered on 21 Nov 2017

1 answer

134 views

Dragging from RadDropDownList within ribbon bar

Hi,

I have a RadDropDownList as part of my ribbon bar, is it possible to drag (then drop) the selected item onto another control ?

I have done this before using a RadListControl (and RadListDataItems) on a form which has a MouseMove handler, however the RadDropDownList control in the ribbon bar does not have a mouse move handler.

In the ribbon bar mouse down handler, I have tried using

RadDropDownListEditableAreaElement b = radRibbonBar1.ElementTree.GetElementAtPoint(e.Location) as RadDropDownListEditableAreaElement;

but how do I get a reference to the original RadListDataItem which has some data in the Value and Tag fields ?

Regards

Toby

RibbonBar