Kendo.culture vs WebAPI/Json

[Matthijs]

Hello,

I have a Razor build-ed grid which the datasource is WebAPI. The model contains a decimal field.

In Dutch (nl-NL) the separated character for decimal is comma instead of dot.

When setting in JS the Kendo.culture to "nl-NL", and the input contains a comma as ​decimal separated character, the ​created JSON model from Kendo Grid to the WebAPI contains also the comma instead of dot. At server-side the input will bbe set without decimal.

 Example: 34,45 is in the JSON  and gives 3445. 

 If the culture is removed, the JSON contains the dot and all works fine.

Question is, can I force the generated JSON model to handle input always as default culture (dot as decimal separated)?

[Daniel]

Hello,

This is a known issue that is logged in our system for further investigation. The WebAPI uses the invariant culture formats to parse the values but the webapi dataSource serializes dates and numbers based on the current culture. The simplest option to avoid the problem is to use the request data function to convert the numbers to string e.g.

.Update(update => update.Url(Url.HttpRouteUrl("DefaultApi", new { controller = "ControllerName", id = "{0}" })).Data("serialize"))

function serialize(data) {
    for (var field in data) {
        if (typeof data[field] === "number") {
            data[field] = data[field].toString();
        }
    }
}

Regards,
Daniel
Telerik

[Matthijs]

Thank you Daniel. This show the value with the (Dutch) comma in row.

But when the row switch to edit, the value show the dot instead of comma.

Is there a manner to change this also to comma as decimal seperator?

[Daniel]

Hello again,

What editor template are you using for the field? The editor should be a numerictextbox in order for the value in edit mode to be formatted based on the culture.

Also, the problem with the format used by the webapi dataSource has been fixed and the fix will be available in the next internal build.

Regards,
Daniel
Telerik