Decimal point in edit dialog grid
|
<script>
ej.base.L10n.load({
'it': {
'grid': {
'EmptyRecord': 'Keine Aufzeichnungen angezeigt',
'GroupDropArea': 'Ziehen Sie einen Spaltenkopf hier, um die Gruppe ihre Spalte',
'UnGroup': 'Klicken Sie hier, um die Gruppierung aufheben',
'EmptyDataSourceError': 'DataSource darf bei der Erstauslastung nicht leer sein, da Spalten aus der dataSource im AutoGenerate Spaltenraster',
'Item': 'Artikel',
'Items': 'Artikel'
},
'pager': {
'currentPageInfo': '{0} von {1} Seiten',
'totalItemsInfo': '({0} Beiträge)',
'firstPageTooltip': 'Zur ersten Seite',
'lastPageTooltip': 'Zur letzten Seite',
'nextPageTooltip': 'Zur nächsten Seite',
'previousPageTooltip': 'Zurück zur letzten Seit',
'nextPagerTooltip': 'Zum nächsten Pager',
'previousPagerTooltip': 'Zum vorherigen Pager'
}
}
});
</script>
<div>
@Html.EJS().Grid("Grid").DataSource((IEnumerable<object>)ViewBag.datasource).Columns(col =>
{
col.Field("OrderID").HeaderText("Order ID").IsPrimaryKey(true).Width("120").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).ValidationRules(new { required = "true" }).Add();
col.Field("CustomerID").HeaderText("Customer Name").Width("150").ValidationRules(new { required = "true", minLength = 3 }).Add();
col.Field("Freight").HeaderText("Freight").Width("120").EditType("numericedit").Format("N2").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add();
col.Field("ShipName").HeaderText("Ship Name").Width("150").Add();
col.Field("ShipCountry").HeaderText("Ship Country").EditType("dropdownedit").Width("150").Add();
}).AllowPaging().EditSettings(edit => { edit.AllowAdding(true).AllowEditing(true).AllowDeleting(true).Mode(Syncfusion.EJ2.Grids.EditMode.Dialog); }).Toolbar(new List<string>() { "Add", "Edit", "Delete", "Update", "Cancel" }).Render()
</div>
|
|
<div class="container body-content">
@RenderBody()
</div>
<script>
function loadCultureFiles(name) {
var files = ['numbers.json', 'timeZoneNames.json', 'currencies.json', 'ca-gregorian.json'];
var loadCulture = function (prop) {
var val, ajax;
ajax = new ej.base.Ajax(location.origin + '/../../scripts/cldr-data/main/' + name + '/' + files[prop], 'GET', true);
ajax.onSuccess = function (value) {
val = value;
ej.base.loadCldr(JSON.parse(val));
};
ajax.send();
ej.base.setCulture('it');
ej.base.setCurrencyCode('EUR')
};
for (var prop = 0; prop < files.length; prop++) {
loadCulture(prop);
}
}
document.addEventListener('DOMContentLoaded', function () {
loadCultureFiles('it');
});
</script>
@Scripts.Render("~/bundles/jquery")
@Scripts.Render("~/bundles/bootstrap")
@RenderSection("scripts", required: false)
@Html.EJS().ScriptManager()
</body>
</html> |
- Share the complete Grid code
- Please try to replicate the issue in the given sample
- Please share the issue replicable sample (if possible)
- Share the screenshot or video demo of the issue
Hi Manivel,
unfortunately the proposed solution does not work, as you can see from the images
- Share the network tab screenshot. For example
- In the actionBegin event while the requestType is “save” log the value in console and share the screenshot
|
function onActionBegin(args) {
if (args.requestType === "save") {
var listInstance = args.form.querySelector("#CountyId").ej2_instances[0];
args.data["CountyId"] = listInstance.value;
console.log(args.data);
}
|
- Share the model class for deserializing the values in server side. Please find the model class used in your previous code example
Hi Manivel,
the example attached to your previous answer, works fine, but the same code inserted in my project returns a different result as you can see in the images.
The same problem to me with Asp.Net Core, the grid display correctly the decimal numbers.
<e-grid-column field="Prezzo" headerText="Prezzo" validationRules="@(new { required=true})" format="c2" width="150" textAlign="Right"></e-grid-column>
When I start editing in dialog the decimal is always correct.
<ejs-numerictextbox ejs-for="Prezzo" format="c2" validateDecimalOnType="true" min="0" decimals="3" blur="changeInput" change="changeInput"></ejs-numerictextbox>
When I save and close the dialog, the grid rounds all decimals. I tried with the "it" and the default "en" localization but the problem is the same.
Do you have a solution?
Thanks in advance.
Regards,
Antonio
Antonio,
We have checked your shared code examples and we could see that you are not shared the code part about definitions of locale. In our previously shared sample, we have loaded the culture files from the cldr files and set the culture and currency code. Please refer the below code example and documentation for more information.
|
<script> function loadCultureFiles(name) { var files = ['numbers.json', 'timeZoneNames.json', 'currencies.json', 'ca-gregorian.json']; var loadCulture = function (prop) { var val, ajax; ajax = new ej.base.Ajax(location.origin + '/../../scripts/cldr-data/main/' + name + '/' + files[prop], 'GET', true); ajax.onSuccess = function (value) { val = value; ej.base.loadCldr(JSON.parse(val)); }; ajax.send(); ej.base.setCulture('it'); ej.base.setCurrencyCode('EUR') }; for (var prop = 0; prop < files.length; prop++) { loadCulture(prop); } } document.addEventListener('DOMContentLoaded', function () { loadCultureFiles('it'); }); </script>
|
Also, we have checked the response which was return from the server, and it was also returned the proper value at our end. So please ensure once what values are returning from the server after your save action. Please refer the below video demo for more information.
Sample:
Video demo:
Documentation: https://ej2.syncfusion.com/aspnetcore/documentation/common/internationalization
Note: We are not able to run your application at our end, because your shared sample does not contain the EditPartial file.
So, if you still face the issue, please share the runnable application that would be helpful for us to validate or try to replicate your issue in our shared sample.
Attachment: 167681attachments_7cfda774.zip
Stefano,
After reviewing the information you provided, we understand that you're encountering an issue with the IT locale. However, the details you provided were insufficient for us to fully address your query. To assist you, we've prepared a Grid sample using the IT culture, which worked fine on our end. Please ensure that your application follows the same approach to load the IT culture. For more information, please refer to the code example, sample and documentation provided below.
|
<div> @Html.EJS().Grid("Grid").DataSource((IEnumerable<object>)ViewBag.dataSource).Columns(col => { . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
}).Locale("it").Render() </div>
<script> document.addEventListener('DOMContentLoaded', function () { loadCultureFiles('it'); });
function loadCultureFiles(name) { var files = ['numbers.json', 'timeZoneNames.json', 'currencies.json', 'ca-gregorian.json']; var loadCulture = function (prop) { var val, ajax; ajax = new ej.base.Ajax(location.origin + '/../../scripts/cldr/main/' + name + '/' + files[prop], 'GET', true); ajax.onSuccess = function (value) { val = value; ej.base.loadCldr(JSON.parse(val)); }; ajax.send(); ej.base.setCulture('it'); }; for (var prop = 0; prop < files.length; prop++) { loadCulture(prop); } } ej.base.L10n.load({ 'it': { 'grid': { "EmptyRecord": "nessun dato da visualizzare", "True": "vero", "False": "falso", "InvalidFilterMessage": "Dati filtro non validi", . . . . . . . . . . . . . . . . } } });
|
Sample:
Documentation: https://ej2.syncfusion.com/aspnetmvc/documentation/common/internationalization#loading-culture-data
Screenshot:
If you still face the issue, please share the below details that would be helpful for us to provide better solution.
1) Share your complete Grid rendering code, we would like to check how you are loading the IT culture in your application.
2) Share the issue scenario with video demonstration.
3) If possible, please try to reproduce the issue with our shared sample that would be helpful for us to provide better solution.
Attachment: 167681sample_11144e2e.zip
