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

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

Hi,

I'm trying to change the text of the checked item of a RadCheckedDropDownList by using the TextBlockFormatting event.

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:

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