How do I Switch the settings for the thousand separator and the decimal separator?

currently the decimal value : 2510.012 is displayed as 2,510.012

I want to make it so it is displayed as: 2.510,012

Hello,

I have a grid with collapsible rows and the grid also allows Filtering and Sorting. When I have a few rows collapsed and click on a column to sort, all the collapsed rows  expand. Is there a way to retain the collapsed state of rows on Sorting/ Filtering?

Thanks!

1)  I noticed the grid read action is being called when the grid-filter image is clicked on the column header.    Is there a reason it is being called when .ServerOperation(false) is specified ?

2)  Is there a way to remove the grid-filter from the column header when the grid has no rows  to prevent the user from filtering an empty grid ?

Thanks,

Irwin

Hi,

I have a form with a MultiSelect displaying 'Exercises'. When the form is submitted the Exercise data is passed to the model as part of the form data (e.g.Exercises:"f86a60ce-04dc-4208-a2b6-a5ee00a1990f")

However when nothing is selected in the list, the 'Exercises' parameter is excluded from the post data. As the Exercise data is not included, the model.Entity.Exercises remains unchanged and contains the original selected values.

Is there any way the Kendo MultiSelect can pass in a null value when posting an empty list, so that the form data includes the Exercise parameter? e.g. Exercises:Null 

Hi I´m using the Kendo.Mvc.dll version 2014.1.318.440, I have some problems adding the action of Export to Excel on my grid, 

Does not recognize the tools.Excel(), it is possible to use this statement with this Kendo version, or am I missing a reference for example a js file needed to bound??

Here's the code of the grid. 

  @(Html.Kendo().Grid<Project.Models.GridModel>()
                    .Name("Grid")
                    .Scrollable()
                    .EnableCustomBinding(true)
                    .HtmlAttributes(new { style = "height:auto;" })
                    .DataSource(dataSource => dataSource
                        .Ajax()
                        .Model(model =>
                        {
                            model.Id(x => x.NumOP);
                        })
                        .ServerOperation(false)
                        .PageSize(20)
                        .Read(read => read.Action("LoadGrid", "GridController"))
                        )

                    .Columns(columns =>
                    {
                        columns.Bound(p => p.Name).Title("Name").Width(80);
                        columns.Bound(p => p.Description).Title("Description").Width(200);
                        columns.Bound(p => p.Amount).Title("Amount").Format("{0:0,0.0}").Width(100);

                    })
                    .ToolBar(tools => tools.Excel())
                    .Excel(excel => excel
                        .FileName("ExcelFile.xlsx")
                        .ProxyURL(@UrlAction("Excel_Export_Save", "CreditosActivos"))
                        )
                    )

Thanks for help

I have a categories dropdown list in the grid that i am populating very similar to the 'Editing custom editor' example. I populate the default categories in the index() method of my controller, just like the example shows and it works fine. When a 'organization dropdownlist' is chosen, I want to repopulate the categories based on what organization was chosen, but when I try to 'Add new record' in the grid, the old categories remain bound to the grid and it doesn't save properly.

I have in my grid something similar to this defined for the default value:

model.Field(p => p.Category).DefaultValue(ViewData["defaultCategory"] as Kendo.Mvc.Examples.Models.CategoryViewModel);

Every time a new organization dropdown item is chosen, and a read operation occurs, how would I update or rebind the model to reflect the new defaultCategory?

Thanks in advance,

Dave

The official 2016 Q2 Release (2016.2.504) release will export Excel files with grid lines disabled.

The change is not intentional and will be reverted in the following hotfix and service pack releases.

As a workaround you can turn on the grid lines explicitly in the ExcelExport event:

Hello, 

I have a column in my Grid with a custom filter which has pre-populated values in a dropdown. When user opens the page I want the default value to be set to a value that I pass from the Controller in ViewData. I'm able to set the grid filtered to a value on page load but the dropdown in the filter does not have the value selected.

Grid has the below column

 columns.Bound(c => c.DealYear).Filterable(filterable => filterable.UI("yearFilter")).Width(70);

with the below options set

.Filterable(filterable => filterable
        .Extra(false)
        .Operators(operators => operators
           .ForString(str => str.Clear()
               .StartsWith("Starts with")
               .IsEqualTo("Is equal to")
               .IsNotEqualTo("Is not equal to")
           ))
        )

And on page load I filter the grid with a value passed from Controller  - This works fine.

  .Filter(f =>f.Add(p => p.DealYear).Equals(ViewData["DealYear"]))

But in my javascript, how do I set the value to the Filter Dropdown?

function yearFilter(element) {
        element.kendoDropDownList({
            dataSource: {
                transport: {
                    read: "@Url.Action("FilterMenuCustomization_DealYear")"
            }
        },
            optionLabel: "--Select Year--"
        });
    }

The page loads with a predefined filter but the dropdown in the Filter shows 'Select Year'.

Thanks!