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.
Unfortunately, activation email could not send to your email. Please try again.

How to translate text values on filter in grid

Thread ID:

Created:

Updated:

Platform:

Replies:

128498 Jan 25,2017 02:55 PM Jan 27,2017 12:56 AM ASP.NET Web Forms 3
loading
Tags: Grid
Roimer Machacón Otero
Asked On January 25, 2017 02:55 PM

Hi we're using grid, now we've in spanish the grid, but when adding the excel filter for use this appear in english (Can see in attached image).

How can resolve this?

Attachment: english_filter_2c72f72f.zip

Jayaprakash Kamaraj [Syncfusion]
Replied On January 26, 2017 12:01 AM

 
Hi Roimer,

Thank you for contacting Syncfusion support.

We suspect that you have missed to define the ej.ExcelFilter.Locale object corresponding to the culture in your sample project. Please refer to the below code and document.   
 
 
 
<script type="text/javascript"> 
ej.ExcelFilter.Locale["es-ES"] = { 
    SortNoSmaller: "Ordenar de menor a mayor", 
    SortNoLarger: "Ordenar de mayor a menor", 
    SortTextAscending: "Ordenar de A a Z", 
    SortTextDescending: "Ordenar de Z a A", 
    SortDateOldest: "Ordenar por Más antiguos", 
    SortDateNewest: "Ordenar por Más reciente", 
    SortByColor: "Ordenar por color", 
    SortByCellColor: "Ordenar por color de la célula", 
    SortByFontColor: "Ordenar por Color de fuente", 
    FilterByColor: "Filtrar por color", 
    CustomSort: "Orden personalizado", 
    FilterByCellColor: "Filtrar por color de la célula", 
    FilterByFontColor: "Filtrar por color de fuente", 
    ClearFilter: "Borrar filtro", 
    NumberFilter: "Número Filtros", 
    GuidFilter: "Gud Filtros", 
    TextFilter: "Filtros de texto", 
    DateFilter: "Filtros de fecha", 
    DateTimeFilter: "Fecha filtros de tiempo", 
    SelectAll: "Seleccionar todo", 
    Blanks: "Los espacios en blanco", 
    Search: "Buscar", 
    Showrowswhere: "Mostrar filas", 
    NumericTextboxWaterMark: "introducir el valor", 
    StringMenuOptions: [{ text: "Igual", value: "equal" }, { text: "No es equal", value: "notequal" }, { text: "Comienza con", value: "startswith" }, { text: "Termina con", value: "endswith" }, { text: "contiene", value: "contains" }, { text: "Filtro personalizado", value: "customfilter" }, ], 
    NumberMenuOptions: [{ text: "Igual", value: "equal" }, { text: "No es equal", value: "notequal" }, { text: "Menos que", value: "lessthan" }, { text: "Menor o equal", value: "lessthanorequal" }, { text: "Mas grande que", value: "greaterthan" }, { text: "Mayor que o equal", value: "greaterthanorequal" }, { text: "Entre", value: "between" }, { text: "Filtro personalizado", value: "customfilter" }, ], 
    GuidMenuOptions: [{ text: "Igual", value: "equal" }, { text: "No es equal", value: "notequal" }, { text: "Filtro personalizado", value: "customfilter" }, ], 
    DateMenuOptions: [{ text: "Igual", value: "equal" }, { text: "No es equal", value: "notequal" }, { text: "Menos que", value: "lessthan" }, { text: "Menor o equal", value: "lessthanorequal" }, { text: "Mas grande que", value: "greaterthan" }, { text: "Mayor que o equal", value: "greaterthanorequal" }, { text: "Entre", value: "between" }, { text: "Filtro personalizado", value: "customfilter" }, ], 
    DatetimeMenuOptions: [{ text: "Igual", value: "equal" }, { text: "No es equal", value: "notequal" }, { text: "Menos que", value: "lessthan" }, { text: "Menor o equal", value: "lessthanorequal" }, { text: "Mas grande que", value: "greaterthan" }, { text: "Mayor que o equal", value: "greaterthanorequal" }, { text: "Entre", value: "between" }, { text: "Filtro personalizado", value: "customfilter" }, ], 
    Top10MenuOptions: [{ text: "Parte superior", value: "top" }, { text: "Fondo", value: "bottom" }, ], 
    title: "Filtro personalizado", 
    PredicateAnd: "Y", 
    PredicateOr: "O", 
    Ok: "DE ACUERDO", 
    MatchCase: "Coincidencia", 
    Cancel: "Cancelar", 
    NoResult: "No se encontraron coincidencias", 
    CheckBoxStatusMsg: "No todos los elementos que muestran", 
    DatePickerWaterMark: "Seleccione fecha", 
    DateTimePickerWaterMark: "Seleccionar fecha y hora", 
    True: "cierto", 
    False: "falso", 
}; 
</script> 
  
We can use these locale definitions in separate JS file and refer Site Master Page.

We have uploaded the predefined language packs for some commonly used cultures in the below GitHub location and refer to it for the corresponding culture. The culture file has localized texts for all the Syncfusion controls.


https://github.com/syncfusion/ej-global 

Regards, 
 
Jayaprakash K. 


Roimer Machacón Otero
Replied On January 26, 2017 02:11 PM

Hi, thanks this work correctly! :)

Ragavee U S [Syncfusion]
Replied On January 27, 2017 12:56 AM

Hi Roimer, 
  
Thanks for your update. 
 
We are happy that your requirement is achieved. 
  
Regards, 
Ragavee U S. 


CONFIRMATION

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.

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.

;