Currently having a column format of "{0:#}" does not infect the filters format. E.g. 5 becomes to 5.00 on blur event in filter dialog. So we have to modify filters behaviour manually which is a pain. Currently we are using this function:
function configureFilterFormatting($grid) {
var kendoGrid = $grid.getKendoGrid();
kendoGrid.bind('filterMenuInit', function (event) {
var column;
$j.each(event.sender.columns, function (index, item) {
if (item.field == event.field) {
column = item;
return;
}
})
if (!column) {
throw new Error('Invalid column');
}
if (column.format) {
// Transform '{0:#}' in '#'
var format = column.format.replace(/^{0:/, '').replace(/}$/, '');
event.container.find('[data-role=numerictextbox]').each(function () {
var $numericTextbox = $j(this);
$numericTextbox.getKendoNumericTextBox().setOptions({ format: format })
});
}
});
}
Hi,
The functionality can be achieved by providing a custom editor and setting its format option:
https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/configuration/columns.filterable.ui
Regards,
Alex Hajigeorgieva
Progress Telerik