Telerik Forums
UI for WinForms Forum
2 answers
309 views

Hello,

Have a gridview that I want to export to excel  using the radcontrol for winforms 2010 q2 sp1.

I’m using the ExportToExcelML class.

The problem is that in excel the time is added like for example  2001-05-09T00:00:00.000

On the gridview column I’m setting the export format string.

GridViewDataColumn gridviewColumn;

PropertyInfo propertie = Helper.GetProductieMonitorPropertie(kolom);

if (propertie.PropertyType == typeof(DateTime))

{

   gridviewColumn = new GridViewDateTimeColumn();

   gridviewColumn.ExcelExportFormatString = "dd.MM.yyyy";

   gridviewColumn.ExcelExportType = DisplayFormatType.Text;

   gridviewColumn.FormatString = "{0:d}";

}

 

Any suggestion?

 

Kind regards,

 

Tim van Rooijen

IT Development
Top achievements
Rank 1
 answered on 25 Aug 2010
4 answers
151 views
Hi,
Another problem with 2010 Q2, when I 'Hide column', it doesn't show in the column chooser. Any ideas?
Jack
Telerik team
 answered on 25 Aug 2010
1 answer
211 views
Hi.
I want to store in my database all appointments that are created with the help of telerik scheduler.
I have found all the fields that I need in databse, but I don't know the type of fields that I will use in my MSSQL Database.
The fields that I have found are:

-         Start

-         End

-         Duration

-         Summary

-         Description

-         Location

-         Visible

-         AllDay

-         AllowDelete

-         AllowEdit

-         UniqueID

-         BackgroundID

-         StatusID

-         RecurrenceRule

-         MasterEventID

-         ResourceID

-         Resource

Any suggestion from you about the field type for using them in MSSQL?
Dobry Zranchev
Telerik team
 answered on 24 Aug 2010
1 answer
306 views
I just bought the premium telerik package for the latest version.

I have allready work on the trial version 2010.1.10.504
and i dont want to upgrade now to the latest version.

How can i get rid of the trial popup?
Peter
Telerik team
 answered on 24 Aug 2010
7 answers
512 views
Hi:

How can I change the row height for the dropdown items? The default is too spaced out; I'd like to reduce the height.  Also, the defaul background color of a selected row is orange. Kind'a gross.   How can I change that?  Finally, I know for teach column, we can use bestfit() to set it's width.  Is there a way to set the dropdown width so that is will automatically fit according the the columns.  All I see as examples are giving the dropdown width a fixed value (e.g.: = 500). That is dissatisfactory because I have no way of know how wide by individual columns will be - it depends on the subset of data returned.  So, I may have lots of extra whit space sometimes (when the combined column with is less that what I've set for the dropdown width). Other times, I need to horizontal scroll to see all the columns because the dropdown width is not set large enough. Neither situation is desired. . .

Thanks!
Peter
Telerik team
 answered on 23 Aug 2010
3 answers
266 views
Hello,

I have a grid with a status column in which I want to place a red o green ball depending the bound value. I've tried to do that with the next code:


Private Sub Grid_CellFormatting(ByVal sender As Object, ByVal e As Telerik.WinControls.UI.CellFormattingEventArgs) _
        Handles gridPedidos.CellFormatting, _
                gridChrono.CellFormatting, _
                gridCentros.CellFormatting, _
                gridIncidencias.CellFormatting, _
                gridIncidenciasPFR.CellFormatting, _
                gridPedidosWeb.CellFormatting
    e.CellElement.Image = Nothing
    Dim column As GridViewCommandColumn = TryCast(e.CellElement.ColumnInfo, GridViewCommandColumn)
    If column IsNot Nothing Then
        Select Case column.UniqueName
            Case "Txt"
                CType(e.CellElement.Children(0), RadButtonElement).Image = My.Resources.document_text
                CType(e.CellElement.Children(0), RadButtonElement).ImageAlignment = ImageLayout.Center
            Case "Datos"
                CType(e.CellElement.Children(0), RadButtonElement).Image = My.Resources.table_view
                CType(e.CellElement.Children(0), RadButtonElement).ImageAlignment = ImageLayout.Center
        End Select
    End If
    If e.CellElement.ColumnInfo.Name = "Status" AndAlso TypeOf e.CellElement.RowInfo Is GridViewDataRowInfo Then
        Dim Status As Integer = CInt(e.CellElement.RowInfo.Cells("Status").Value)
        If Status = 0 Then
            e.CellElement.Image = My.Resources.button_green
        Else
            e.CellElement.Image = My.Resources.button_red
        End If
        e.CellElement.Text = ""
    End If
End Sub

Executing the program the status column is draw right as you can see in the image1 attached. But scrolling horizontally right and left, the red and green balls are showed in other columns (image2)

Thanks in advance
Blas

Jack
Telerik team
 answered on 23 Aug 2010
1 answer
173 views
I am using Visual Studio 2008 with the latest Telerik Winforms. If, for example, I drag a RadTextBox from the toolbox, and click "Edit UI Elements". Then, I choose FillPrimitive and attempt to set SmoothingMode to something like, say, "Invalid" (among other options)

Then immediately Visual Studio would say RadTextBox has thrown an exception in the designer and has been disabled. Error message is "Parameter is not valid" and no stack trace is available. The "element hierarchy editor " dialog is closed and VS hangs with 100% CPU usage (I have to terminate devenv.exe task to recover).

I know this is not a valid use case but should this be handled more gracefully? The exception dialog is OK but at least VS should not hang.
Peter
Telerik team
 answered on 23 Aug 2010
1 answer
141 views
I am trying to change the filter element behavior of a ComboBoxColumn. I would like the ComboBoxColumn filter element to behave identical to the filter element for a TextBoxColumn. I need the filtering to be textbased instead of a drop down and I need the DisplayElement to be filtered as opposed to filtering the ValueMember. Is this possible?
Martin Vasilev
Telerik team
 answered on 23 Aug 2010
3 answers
190 views
When we have the scheduler set to show the Timeline view, the AppointmentSelected and AppointmentSelecting events are not firing.  Anyone have a solution to this?

Thanks!
Matthew Link
Top achievements
Rank 1
 answered on 20 Aug 2010
3 answers
260 views
hi,
I recently upgraded to 2010 Q2 and since then I get an error: 'Object Reference not set to an instance of an object' on this line:

e.RowElement.BackColor =

CType(_colourConvert.ConvertFromString(e.RowElement.RowInfo.Cells(_StatusColour).Value().ToString), System.Drawing.Color)

 


Any help would b appreciated.
Hilda Kenny
Top achievements
Rank 1
 answered on 20 Aug 2010
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
PdfViewer and PdfViewerNavigator
CommandBar
ListControl
Carousel
GanttView
Diagram, DiagramRibbonBar, DiagramToolBox
Panorama
New Product Suggestions
VirtualGrid
Toolstrip (obsolete as of Q3 2010)
Label
AutoCompleteBox
Spreadsheet
ContextMenu
Panel
Visual Studio Extensions
TitleBar
SplitContainer
Documentation
Map
DesktopAlert
CheckedDropDownList
ProgressBar
MessageBox
TrackBar
Rotator
SpinEditor
CheckedListBox
StatusStrip
SyntaxEditor
Wizard
CollapsiblePanel
LayoutControl
ShapedForm
TextBoxControl
Conversational UI, Chat
DateTimePicker
TabbedForm
CAB Enabling Kit
WaitingBar
GroupBox
DataEntry
ScrollablePanel
ScrollBar
ImageEditor
Tools - VSB, Control Spy, Shape Editor
BrowseEditor
DataFilter
FileDialogs
ColorDialog
Gauges (RadialGauge, LinearGauge, BulletGraph)
ApplicationMenu
RangeSelector
CardView
WebCam
NavigationView
BindingNavigator
RibbonForm
Styling
Barcode
PopupEditor
TaskBoard
Callout
ColorBox
PictureBox
FilterView
Accessibility
VirtualKeyboard
DataLayout
Licensing
ToastNotificationManager
ValidationProvider
CalculatorDropDown
Localization
TimePicker
BreadCrumb
ButtonTextBox
FontDropDownList
BarcodeView
Overlay
Security
LocalizationProvider
Dictionary
TreeMap
StepProgressBar
SplashScreen
Flyout
Separator
SparkLine
ToolbarForm
NotifyIcon
DateOnlyPicker
AI Coding Assistant
Rating
TimeSpanPicker
Calculator
OfficeNavigationBar
TaskbarButton
HeatMap
SlideView
PipsPager
AIPrompt
TaskDialog
TimeOnlyPicker
SpeechToTextButton
SmartPasteButton
+? more
Top users last month
Jake
Top achievements
Rank 1
RBarnes
Top achievements
Rank 1
Iron
Iron
Rami
Top achievements
Rank 1
Iron
Veteran
Nathan
Top achievements
Rank 1
Kumeri
Top achievements
Rank 1
Iron
Veteran
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Jake
Top achievements
Rank 1
RBarnes
Top achievements
Rank 1
Iron
Iron
Rami
Top achievements
Rank 1
Iron
Veteran
Nathan
Top achievements
Rank 1
Kumeri
Top achievements
Rank 1
Iron
Veteran
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?