Telerik Forums
UI for WinForms Forum
1 answer
381 views

I'm running into an issue with format of a datetime column when exporting to excel.

What I am trying to do is export  datetime column to excel and format as the full datetime on excel, how the various approaches i have tried do not seem to work.

I can get the export to appear to show up as a datetime by:
column.ExcelFormatString = "M/d/yyyy h:mm tt"
column.ExcelExportType = DisplayFormatType.Text;

 

The problem with this is, that when i put I put a filter on the column in excel, it only sorts alphabetically not by date.

The closest I am able to get behavior wise is this:
column.ExcelFormatString = "M/d/yyyy h:mm"
column.ExcelExportType = DisplayFormatType.Custom;

 

This allows me to sort by date, but makes the time portion 24 hr format. If I try this with "M/d/yyyy h:mm tt" it ignores the AM/PM indicator and just writes "tt" at the end.

Ideally what I would like is a away to get the datetime to show up in 12 hour format in excel ("M/d/yyyy h:mm tt") while still being able to sort by Earliest/Latest instead of Alphabetically.

Any help would be appreciated, thanks.

 



Dess | Tech Support Engineer, Principal
Telerik team
 answered on 07 Apr 2016
3 answers
301 views

 

I've got some weird custom logic to implement on a text field, for which the best solution seems to be a Custom Editor using a RadDropDownListEditorElement. I want the Enter key to commit the current selection and end editing.  The default behavior when Enter is pressed is to close the Popup, but leave the editor focused in edit mode.

I tried the following (inside the Custom Editor class I defined):

radDropDownListEditorElement.KeyDown += (o, args) =>
{
    if (args.KeyCode == Keys.Enter)
    {
        var cell = parentGridView.CurrentCell;
        parentGridView.EndEdit();
        cell.ViewInfo.Refresh();
    }
};

 

This works fine if the popup is already closed (for example, by pressing Enter twice, or clicking the mouse and THEN pressing Enter).  But when the popup is open, KeyDown never gets fired.  I've tried capturing radDropDownListEditorElement.Popup.KeyDown and PopupForm.KeyDown, with no luck.  Any idea how to get keypresses when the Popup is open, or a better way to achieve this functionality?  Using a Custom Editor is required for other reasons.

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 07 Apr 2016
1 answer
702 views

When a user changes their screen scaling either by resolution or DPI settings the following works for native windows controls but not for Telerik -- why is this?

 

            this.AutoScaleMode = AutoScaleMode.None;
            foreach (Control c in Controls)
            {
                c.Font = new Font("Segoe UI", 9);
            }

Thanks in advance

Hristo
Telerik team
 answered on 07 Apr 2016
25 answers
2.7K+ views
How do I set the selected item (without using the index) from code? With combo box I just set SelectedItem to a string containing one of the items. I don't seem to be able to do that with DropDownList?

Steve
Vitaly
Top achievements
Rank 1
 answered on 07 Apr 2016
2 answers
395 views

I am using the WinForms 2016 version.

I have discovered that selecting the first item in the combobox in code is not calling the SelectedIndexChanged of the same control.

<b>mcc_Scaffold_Tag.SelectedIndex = 0 </b>

 

Am I using the right event?

 

 

 

 

 

Speedy
Top achievements
Rank 1
 answered on 06 Apr 2016
5 answers
142 views
Hi,

I have a grid with 3 Cols: Player, Team, Points.
When I group to Teams, it sums the point from each player to the team result.

Now i want the best team on the first group and so on.

How can I do that?

Greetings

Konrad
Dess | Tech Support Engineer, Principal
Telerik team
 answered on 06 Apr 2016
3 answers
155 views

Hi,

how to Group by Day and not by Resource?

Is there a way to do that?

We like to have a "DayView" where all Resources are listed at one Day/Date.

 

Regards

Hardy

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 06 Apr 2016
3 answers
166 views

Hi

I'm using a RadOffice2007ScreenTipElement with a RadTreeView, showing it using ScreenTipNeeded and everything is working as expected.

I do have a slight issue - if i start to Drag&Drop, the screen tip will remain visible the whole time (and block my view of other tree elements). I haven't been able to make it disappear. Is there a way to manually remove a screentip while the TreeView is still pressed/active (due to dragging)? 

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 06 Apr 2016
4 answers
227 views

I am trying to create a treeview with hierarchical structure.

CIK

|__Series

      |__Class 

Series will be populated from the database based on the currently selected CIK value member(Id). Class will be populated from the database based on the Series ID selected. 

I couldn't find the right sample in the documentation to do this. Please point me in the right direction. Thank you for your help. 

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 06 Apr 2016
2 answers
147 views

I'm trying to implement a sample like this here

http://docs.telerik.com/devtools/winforms/gridview/cells/creating-custom-cells

In Progress OpenEdge. Unfortunately the ABL does not support overriding of properties, so I cannot achieve this here:

 

 protected override Type ThemeEffectiveType

{

    get { return typeof(GridDataCellElement);}

}

 

Is there any other way of inheriting the style from the base element type?

Mike
Top achievements
Rank 1
 answered on 05 Apr 2016
Narrow your results
Selected tags
Tags
GridView
General Discussions
Scheduler and Reminder
Treeview
Dock
RibbonBar
Themes and Visual Style Builder
ChartView
Calendar, DateTimePicker, TimePicker and Clock
DropDownList
Buttons, RadioButton, CheckBox, etc
ListView
ComboBox and ListBox (obsolete as of Q2 2010)
Form
Chart (obsolete as of Q1 2013)
PageView
MultiColumn ComboBox
TextBox
RichTextEditor
PropertyGrid
Menu
RichTextBox (obsolete as of Q3 2014 SP1)
Panelbar (obsolete as of Q2 2010)
PivotGrid and PivotFieldList
Tabstrip (obsolete as of Q2 2010)
MaskedEditBox
CommandBar
PdfViewer and PdfViewerNavigator
ListControl
Carousel
GanttView
Diagram, DiagramRibbonBar, DiagramToolBox
Panorama
New Product Suggestions
VirtualGrid
Toolstrip (obsolete as of Q3 2010)
AutoCompleteBox
Label
Spreadsheet
ContextMenu
Panel
Visual Studio Extensions
TitleBar
Documentation
SplitContainer
Map
DesktopAlert
CheckedDropDownList
ProgressBar
MessageBox
TrackBar
Rotator
SpinEditor
CheckedListBox
StatusStrip
LayoutControl
ShapedForm
SyntaxEditor
Wizard
TextBoxControl
CollapsiblePanel
Conversational UI, Chat
DateTimePicker
TabbedForm
CAB Enabling Kit
GroupBox
WaitingBar
DataEntry
ScrollablePanel
ScrollBar
ImageEditor
Tools - VSB, Control Spy, Shape Editor
BrowseEditor
DataFilter
FileDialogs
ColorDialog
Gauges (RadialGauge, LinearGauge, BulletGraph)
ApplicationMenu
RangeSelector
CardView
WebCam
BindingNavigator
Styling
Barcode
PopupEditor
RibbonForm
TaskBoard
Callout
NavigationView
ColorBox
PictureBox
FilterView
Accessibility
VirtualKeyboard
DataLayout
Licensing
ToastNotificationManager
ValidationProvider
CalculatorDropDown
Localization
TimePicker
BreadCrumb
ButtonTextBox
FontDropDownList
BarcodeView
Overlay
Security
LocalizationProvider
Dictionary
SplashScreen
Flyout
Separator
SparkLine
TreeMap
StepProgressBar
ToolbarForm
NotifyIcon
DateOnlyPicker
AI Coding Assistant
Rating
TimeSpanPicker
Calculator
OfficeNavigationBar
TaskbarButton
HeatMap
SlideView
PipsPager
AIPrompt
TaskDialog
TimeOnlyPicker
+? more
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?