how to batch edit decimal in grid

[Aleqsandre]

Toolbar="@(new List() { "Cancel", "Update", "Save" })">

public IEditorSettings PriceEditParams = new NumericEditCellParams

{

Params = new NumericTextBoxModel

[Vignesh Natarajan]

Hi Aleqsandre,  

 

Greetings from Syncfusion support.  

 

Query: “ I am not able to enter decimal number in batch edit mode for the Price column in above grid ” 

 

We have analyzed the reported query with provided code example and found that EditorSettings is not properly defined for NumericTextBox Column. We have modified the provided code example and ensured the reported issue with batch editing. We are able to enter decimals using (.) operator and save the changes in Grid properly.  

 

Refer the below code example.  

 

<SfGrid DataSource="@OrderData" Toolbar=@ToolbarItems> 

    <GridEditSettings AllowEditing="true" AllowAdding="true" Mode="EditMode.Batch" AllowDeleting="true"></GridEditSettings> 

    <GridColumns> 

        <GridColumn Field=@nameof(Order.OrderID) HeaderText="Order ID" IsPrimaryKey="true" TextAlign="TextAlign.Center" Width="120"></GridColumn> 

        <GridColumn Field=@nameof(Order.CustomerID) HeaderText="Customer ID" TextAlign="TextAlign.Center" Width="130"></GridColumn> 

        <GridColumn Field=@nameof(Order.Freight) HeaderText="Freight" Format="n3" EditType="EditType.NumericEdit" EditorSettings="@PriceEditParams" TextAlign="TextAlign.Center" Width="130"></GridColumn> 

        <GridColumn Field=@nameof(Order.ShipName) HeaderText="Ship Name" TextAlign="TextAlign.Center" EditType="EditType.DropDownEdit" Width="120"></GridColumn> 

        <GridColumn Field=@nameof(Order.Verified) HeaderText="Verified" EditType="EditType.BooleanEdit" TextAlign="TextAlign.Center" DisplayAsCheckBox="true" Width="120"></GridColumn> 

    </GridColumns> 

</SfGrid> 

  

@code{ 

    public string[] ToolbarItems = new string[] { "Add", "Edit", "Delete", "Update", "Cancel" }; 

  

    public IEditorSettings PriceEditParams = new NumericEditCellParams 

    { 

        Params = new NumericTextBoxModel<object>() { Min = 0, ShowSpinButton = false, Decimals = 3,Format = "n3" ,ValidateDecimalOnType = true } 

    }; 

 

      

Kindly download the sample which we have prepared from below  

 

Sample: https://www.syncfusion.com/downloads/support/forum/156663/ze/BlazorApp1-213787093  

 

Refer our UG documentation for your reference 

 

https://blazor.syncfusion.com/documentation/datagrid/editing/#numericedit  

 

Kindly get back to us with more details if you are still facing the issue.  

 

Regards, 

Vignesh Natarajan 

[Aleqsandre]

thank you for support.

[Vignesh Natarajan]

Hi Aleqsandre,  

Thanks for the update.  

We hope you have resolved your query using our solution.  

Please get back to us if you have further queries.   

Regards, 

Vignesh Natarajan