Hello,
Exporting a PivotGrid with RowHeadersLayout set to "Compact" results in an invalid XLS file.
The first column has an negative width. Which results in an Excel error while opening the xls file.
Christian
XML-FEHLER in Tabelle
GRUND: Ungültiger Wert
DATEI: C:\Users\...\Test.xls
GRUPPE: Table
TAG: Column
ATTRIBUT: Width
WERT: -20
Hi,
I'm trying to change the text of the checked item of a RadCheckedDropDownList by using the TextBlockFormatting event.
TokenizedTextBlockElement token = e.TextBlock
as
TokenizedTextBlockElement;
if
(token !=
null
&& token.Item.Value !=
null
)
{
token.DrawText =
false
;
token.ContentElement.Text =
string
.Format(
"{0}"
, ((Telerik.WinControls.UI.RadListDataItem)token.Item.Value).Value);
}
this works, the items are displayed correctly. However, if there are multiple checked items and one item becomes unchecked (by using the X) the complete selection is cleared. The Datasource is a Dictionary<dynamic, string>(). Without the formatting everything works fine.
I've tried CreateTextBlock without any luck. I've seen there is some code with a custom TokenizedTextBlockElement, but I hope there is a simpler way?!
There should be a XXXMember property like the DescriptionTextMember, AutoCompleteDisplayMember otherwise there is nothing about RAD in your RAD components ... last time i checked RAD was short for Rapid Application Development and not investing 2+ hours for such a simple task. And NO I don't want to format the items in the dropdown since I have some dropdowns with >2000 Items and it becomes very slow if I add the formatting.
I need to capture the row the user is adding so I can send it (or others) back to the database for insert. I have not tried the inline editing yet.
I'm using WinForms.
I've tried the following to capture when the user is done adding (Enter Key) with zero results:
void radGridViewActiveSchedules_UserAddedRow(object sender, GridViewRowEventArgs e)
void radGridViewActiveSchedules_DefaultValuesNeeded(object sender, GridViewRowEventArgs e)
void radGridViewActiveSchedules_CellBeginEdit(object sender, GridViewCellCancelEventHandler e)
What am I missing
why is the grid coloring wrong cells when i group the data? it works until you do a group by.
Imports System.ComponentModel
Imports Telerik.WinControls
Imports Telerik.WinControls.UI
Public Class Form1
Private _list As New BindingList(Of data)
Private _groups() As String = {"one", "two", "three", "four"}
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles Me.Load
GenData()
grid.DataSource = _list
End Sub
Private Sub GenData()
For i = 0 To 1000
_list.Add(New data() With {.Foo = "foo" + i.ToString,
.Bar = _groups(i Mod 4),
.Bye = "bye" + i.ToString,
.Hi = "hi" + i.ToString,
.Index = i})
Next
End Sub
Private Sub grid_CellFormatting(sender As Object, e As CellFormattingEventArgs) Handles grid.CellFormatting
If TypeOf e.Row Is GridViewDataRowInfo Then
If e.CellElement.ColumnInfo.Name.ToLower = "foo" Then
Dim b As data = CType(e.Row.DataBoundItem, data)
If b.Index Mod 2 > 0 Then
e.CellElement.DrawFill = True
e.CellElement.BackColor = Color.Pink
Console.WriteLine(e.CellElement.ColumnInfo.Name + " going pink - " + e.CellElement.RowIndex.ToString)
e.CellElement.GradientStyle = GradientStyles.Linear
Else
e.CellElement.DrawFill = False
e.CellElement.BackColor = Color.White
Console.WriteLine(e.CellElement.ColumnInfo.Name + " going white - " + e.CellElement.RowIndex.ToString)
e.CellElement.GradientStyle = GradientStyles.Solid
End If
End If
End If
End Sub
End Class
Public Class data
Public Property Foo As String = ""
Public Property Bar As String = ""
Public Property Hi As String = ""
Public Property Bye As String = ""
Public Property Index As Integer = -1
End Class
I am using Version 2016.2.608.20 of WinControls.UI.
WHERE IS PERFORMCLICK EVENT?
My client is very particular that they do not want anyone hand-typing a date into a control, so I need the date part of the DateTimePicker to be read-only. Unfortunately, all attempts to do this do not work, and it appears that is not supported. My workaround is a standard LABEL control placed OVER the date area of the DateTimePicker, with a painted border. But the client wants to be able to CLICK on that now and have the calendar appear.
I considered using a standard RadButton and RadCalendar, but then I need to do a lot of extra work to make it extend beyond the modal dialog form bounds, etc. I am hoping there is an easier way to just do a built-in PERFORMCLICK, if only I can find where it's hidden.
DISABLE SUNDAYS ON THE CALENDAR
I found other answers to this question, and it certainly makes the Sunday dates APPEAR disabled, but they can still click on them, and the date changes. I am handling in the CLOSED event, adjusting the date accordingly to the next Monday... but it would be better if the Sundays actually stayed disabled / un-clickable.
HIDE THE CLEAR BUTTON
Minor issue, I can show the footer and disable the clear button... but is there any way to completely remove it? (They like having the [TODAY] button in the footer. This is minor... they can live with a disabled button... but if there's an easy way to hide it, how?
Thanks for your help!
Here is my code:
/// PART ONE - WHERE IS THE PERFORMCLICK EVENT?
private
void
MyLabel_MouseClick(
object
sender, MouseEventArgs e)
{
// Attempts to locate the PerformClick event...
MyRadDateTimePicker.DateTimePickerElement.PerformClick();
MyRadDateTimePicker.DateTimePickerElement.ArrowButton.PerformClick();
foreach
(Telerik.WinControls.RadElement _Element
in
MyRadDateTimePicker.DateTimePickerElement.ArrowButton.Children)
_Element.PerformClick();
foreach
(Telerik.WinControls.RadElement _Element
in
MyRadDateTimePicker.DateTimePickerElement.Calendar.CalendarElement.Children)
_Element.PerformClick();
}
// PART TWO - HOW TO DISABLE SUNDAYS IN CALENDAR
private
void
MyRadDateTimePicker_Opened(
object
sender, EventArgs e)
{
MyRadDateTimePicker.DateTimePickerElement.Value =
this
.SelectedDate;
RadCalendar _Calendar = MyRadDateTimePicker.DateTimePickerElement.Calendar;
CalendarTableElement _Table
= (CalendarTableElement)_Calendar.CalendarElement.CalendarVisualElement.Children[0].Children[1];
foreach
(CalendarCellElement _Cell
in
_Table.Children)
{
if
(_Cell.Date.DayOfWeek == DayOfWeek.Sunday)
{
_Cell.Enabled =
false
;
// Disables, but still leaves it clickable
}
}
_Calendar.ClearButton.Enabled =
false
;
// Would actually prefer to HIDE this!
_Calendar.ShowFooter =
true
;
}
Hi,
if I add calculated field like below:
https://docs.telerik.com/devtools/winforms/pivotgrid/calculated-fields
and then try to rename it using FieldList - More aggrerate options...
I got an exception:
System.InvalidOperationException: Operation is not valid due to the current state of the object.
at Telerik.WinControls.UI.PivotGrid.Dialogs.AggregateOptionsDialog.get_SelectedQueryableAggregateFunction()
at Telerik.WinControls.UI.PivotFieldListVisualItem.aggregateOptionsMenuItem_Click(Object sender, EventArgs e)
at Telerik.WinControls.RadElement.OnClick(EventArgs e)
at Telerik.WinControls.UI.RadMenuItem.OnClick(EventArgs e)
at Telerik.WinControls.RadElement.DoClick(EventArgs e)
...
Is it a bug and is there a workaround?
Alex
If I have say 110 items in my list and want to bring item 67 into view, how do I go about this?
Thanks
RadLabel1.Text = "<h
tml
><
span
><
a
href
='
??'
>Link 1</
a
>,
<
a
href
='
??'
>Link 2</
a
>, <
a
href
='
??'
>Link 3</
a
>
</
span
></
html
>"
When user click on "link 1", i would show message box "Link 1" or load Form1, click on Link 2, show message box "Link 2" or load Form2 and so on. I put "??" in the href as am not sure what will go there yet.
Is this possible? I know it can be done with the LinkControl but i really like the HTML formatting available with a RadLabel.
Thanks
Don
Edit:
I do see a "Other" option in the hyperlink type option.(image attached)
Please could you tell me how to use this option? Can i use this option to load winforms?
Thanks..