We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Column date format and locale not being applied to excel filter datepicker and input

Thread ID:





119162 May 15,2015 07:25 PM UTC May 18,2015 01:55 PM UTC JavaScript 1
Tags: ejGrid
Asked On May 15, 2015 07:25 PM UTC


I'm setting ejGrid to "pt-BR" locale and everything is ok (translated and currency symbol), except the date filter.

When choosing a date in excel filter the format * applied in input is "MM/dd/YYYY" and literals on datepicker was not translated too.

Another thing I realized is that custom filters (in numbers columns for example) are not working properly when setting grid locale to "pt-BR".

* pt-BR date format is dd/MM/yyyy

ej.ExcelFilter.locale["pt-BR"] = {
    SortNoSmaller: "Ordenar do Menor para o Maior",
    SortNoLarger: "Ordenar do Maior para o Menor",
    SortTextAscending: "Ordenar de A para Z",
    SortTextDescending: "Ordenar de Z para A",
    SortDateOldest: "Ordenar pelo mais Antigo",
    SortDateNewest:"Ordenar pelo mais Novo",
    ClearFilter: "Limpar Filtro",
    NumberFilter: "Filtros de Número",
    TextFilter: "Filtros de Texto",
    DateFilter: "Filtros de Data",
    StringMenuOptions: [{ text: "Igual a", value: "equal" }, { text: "Diferente de", value: "notequal" }, { text: "Começa com", value: "startswith" }, { text: "Termina com", value: "endswith" }, { text: "Contém", value: "contains" }, { text: "Personalizar Filtro", value: "customfilter" }],
    NumberMenuOptions: [{ text: "Igual a", value: "equal" }, { text: "Diferente de", value: "notequal" }, { text: "Menor que", value: "lessthan" }, { text: "Menor ou igual a", value: "lessthanorequal" }, { text: "Maior que", value: "greaterthan" }, { text: "Maior ou igual a", value: "greaterthanorequal" }, { text: "Entre", value: "between" }, { text: "Personalizar Filtro", value: "customfilter" }],
    DateMenuOptions: [{ text: "Igual a", value: "equal" }, { text: "Diferente de", value: "notequal" }, { text: "Menor que", value: "lessthan" }, { text: "Menor ou igual a", value: "lessthanorequal" }, { text: "Maior que", value: "greaterthan" }, { text: "Maior ou igual a", value: "greaterthanorequal" }, { text: "Entre", value: "between" }, { text: "Personalizar Filtro", value: "customfilter" }],
    Top10MenuOptions: [{ text: "10 Primeiros", value: "top" }, { text: "Últimos 10", value: "bottom" }],
    title:"Personalizar Filtro",
    PredicateAnd: "E",
    PredicateOr: "OU",
    Ok: "OK",
    MatchCase: "Diferenciar maiúsculo de minúsculo",
    Cancel: "Cancelar",
    NoResult: "Nenhum registro encontrado",
    CheckBoxStatusMsg: "Mostrando somente alguns registros",
    DatePickerWaterMark: "Selecione uma data",
    True: "sim",
    False: "não"
                dataSource: @Html.Raw(@Model.ToJson()),
                allowPaging: true,
                allowFiltering: true,
                filterSettings: {filterType:"excel"},
                showColumnChooser: true,
                allowScrolling: true,
                scrollSettings: { width: "100%" },
                locale: "pt-BR",
                isResponsive: true,
                columns: [
                    { field: "Nome", headerText: "Nome do Proprietário", width: 200, isFrozen: true },
                    { field: "Ativo", headerText: "Ativo", width: 200 },
                    { field: "Preco", headerText: "Preço", width: 200, format: "{0:c2}" },
                    { field: "Idade", headerText: "Idade", width: 200 },
                    { field: "Data", headerText: "Data Nasc.", width: 200, format: "{0:dd/MM/yyyy}" }

Sellappandi Ramu [Syncfusion]
Replied On May 18, 2015 01:55 PM UTC

Hi Oswaldo,

We considered this requirement “Date format not set to excel filter and Custom filter is not working properly when set the locale to grid” as bug and a support incident has been created under your account to track the status of this requirement. Please log on to our support website to check for further updates.


Sellappandi R


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon