I'm using Telerik for ASP.NET Core Wrappers, setting culture and format for column.
Display format is correct according to culture, the problem is that when I edit the field, format is always in English culture, with dot separator for decimal. When I save it, it considers the culture and ignore the dot because it is not the culture decimal separator.
Images:
DisplayMode.PNG - Ok
EditMode.PNG - Using dot as decimal separator - Not Ok
DisplayModeAfterChange - 20.6 is recognized as 206
Culture:
<script type="text/javascript"> kendo.culture("@System.Globalization.CultureInfo.CurrentCulture.ToString()");</script>
Column:
columns.Bound(p => p.PrecoDeVenda).Width(120).Format("{0: R'$' #,###,##0.##}")
DataSource:
.DataSource(dataSource => dataSource .WebApi() .Model(model => { ... }) .Batch(true) .Culture(System.Globalization.CultureInfo.CurrentCulture.ToString()) ... )
DataSource:
columns.Bound(p => p.PrecoDeVenda).Width(120).Format("{0: R'$' #,###,##0.##}")3 Answers, 1 is accepted
Rank 1
Hi Daniel,
I noticed that you have submitted the same query in a ticket, as I have already answered in the ticket, I will post the reply here as well in case someone else has the same question.
=========================
The default editor of the grid is a plain input element. Thus, formatting is not supported with it. If you need to format the value in edit mode, you will have to create a custom editor template which contains a NumericTextBox with a specified format setting.
In other words, in the ~/Views/Shared/EditorTemplates folder, add a view with a name "Number.cshtml" and within that view create a NumericTextBox as follows:
@(Html.Kendo().NumericTextBoxFor(x=>)
.Format("c2" ) // set format here
)Please note that you will also have to decorate the field of the model with the UIHint attribute to specify that this view is its editor.
e.g.
[UIHint("Number")]Regards,
Georgi
Progress Telerik
Rank 1
Hi, Georgi,
Yes, it is already solved, thank you.
For anyone having the same problem, the code is missing this at the start of the cshtml file:
@model double?
And missing one x:
@(Html.Kendo().NumericTextBoxFor(x=> x) .Format("c2" ) // set format here )