RadGridview Excel filter box has tiny elements

7 posts, 0 answers
  1. Evan
    Evan avatar
    14 posts
    Member since:
    Apr 2018

    Posted 22 Jul 2018 Link to this post

    Hi all- 

    I'm using a RadGridview (Telerik Winforms version 2018.1.220.40) and am having trouble getting the excel filter grid to look right.   The radGridView seems to default to Seguoi 8.5 font, but I increased that to 14 to make it readable.   The problem I'm having is that, after I enable Excel filtering, when a user chooses to filter, the excel filter box is tiny (I think it's still 8.5 font) - all the checkboxes are tiny, and the titles are unreadable.  

    I've searched the forums and found some related posts that instruct in (c#) to run through the elements in the viewCellEditing event, but, either I haven't translated them right into VB, or they aren't doing what I expected.   

     

  2. Evan
    Evan avatar
    14 posts
    Member since:
    Apr 2018

    Posted 22 Jul 2018 in reply to Evan Link to this post

    (Accidentally posted that before it's complete.)   Anyway, I'm working in VB.net.   Is there a way to set the default font size for the ExcelFiltering pop up, in either code, or in the Designer UI?   

    My only code setings added so far are: 

                Me.MyGrid.EnableFiltering = True
                MyGrid.MasterTemplate.ShowHeaderCellButtons = True
                MyGrid.MasterTemplate.ShowFilteringRow = False

    Thanks,

  3. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    3575 posts

    Posted 23 Jul 2018 Link to this post

    Hello, Evan,    

    The RadGridView.CellFormatting event is the appropriate place to customize the grid cells. However, if you need to change the font of the Excel-like filter popup you can use the following code snippet:

    Private Sub RadForm1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        Me.RadGridView1.EnableFiltering = True
        Me.RadGridView1.MasterTemplate.ShowHeaderCellButtons = True
        Me.RadGridView1.MasterTemplate.ShowFilteringRow = False
     
        AddHandler Me.RadGridView1.FilterPopupInitialized, AddressOf Grid_FilterPopupInitialized
        Me.RadGridView1.Font = f
    End Sub
     
    Dim f As New Font("Arial", 10, FontStyle.Italic)
    Private Sub Grid_FilterPopupInitialized(sender As Object, e As Telerik.WinControls.UI.FilterPopupInitializedEventArgs)
        Dim popup As RadListFilterPopup = TryCast(e.FilterPopup, RadListFilterPopup)
        popup.Font = f
        RemoveHandler popup.MenuTreeElement.TreeView.NodeFormatting, AddressOf NodeFormatting
        AddHandler popup.MenuTreeElement.TreeView.NodeFormatting, AddressOf NodeFormatting
    End Sub
     
    Private Sub NodeFormatting(sender As Object, e As TreeNodeFormattingEventArgs)
        e.NodeElement.ContentElement.Font = f
    End Sub

    I hope this information helps. If you have any additional questions, please let me know.  
     
    Regards,
    Dess
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  4. Evan
    Evan avatar
    14 posts
    Member since:
    Apr 2018

    Posted 23 Jul 2018 in reply to Dess | Tech Support Engineer, Sr. Link to this post

    That works perfectly.   Thanks Dess!
  5. Evan
    Evan avatar
    14 posts
    Member since:
    Apr 2018

    Posted 29 Jul 2018 Link to this post

    Hi Dess (or Telerik support...)

    The above code is working great, thanks again.   The only small issue remaining is that the Sort options (when you right click the column headers) and the ExcelFilter's "Available Filters" popup menu still seem to be using the 8pt font rather than the 14 that everything else (grid, excelfilter popup etc.)  uses.. .    Is there an equivalent snippet to set these two areas?   

    --(the popup when right clicking column that shows sorting options eg- sort ascending, sort descending, clear sort etc.) 

    --(the excelfilters "available filters" popup that shows 'Equals, Not Equals, etc...) 

    Thanks again! 

  6. Evan
    Evan avatar
    14 posts
    Member since:
    Apr 2018

    Posted 30 Jul 2018 in reply to Evan Link to this post

    (moved this question to its own thread...)
  7. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    3575 posts

    Posted 31 Jul 2018 Link to this post

    Hello, Evan,    

    Your question has already been answered in the other thread you have opened on the same topic. Please, see our answer there for more information.
    We kindly ask you to use just one thread for a specific problem to contact us. Posting the same questions numerous times slows down our response time because we will need to review and address two or more tickets instead of one. Moreover, threads are handled according to license and time of posting, so if it is an urgent problem, we suggest you use a support ticket, which would be handled before a forum thread.

    Thank you for your understanding.

    Regards,
    Dess
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top