Problem with entering values in numeric datagrid fields

Hi. I'm stating to work with Syncfusion controls. I've created very basic C# application using SfDataGrid control and this code:

DataTable dt = new DataTable();

dt.Columns.Add("Numeric1", typeof(double));
dt.Columns.Add("Numeric2", typeof(double));
sfDataGrid1.AutoGenerateColumns = false;
sfDataGrid1.AddNewRowPosition = Syncfusion.WinForms.DataGrid.Enums.RowPosition.Bottom;
sfDataGrid1.DataSource = dt;
sfDataGrid1.Columns.Add(new GridNumericColumn() { MappingName = "Numeric1" });
sfDataGrid1.Columns.Add(new GridNumericColumn() { MappingName = "Numeric2" });

Let's say that user is starting this application, he's clicking at "Click here to add new row" box, so a new row is added to the grid and focus is set to first cell in first row. Now user is entering value "345", but the result is "3,01" which is of course not expected:


Is there any property in SfDataGrid which can control this behavior?

Please note that my OS (Windows 10) is using polish language and polish regional settings (with date format set to custom). I suppose that it may be somehow related to this problem.


7 Replies 1 reply marked as answer

BT Balamurugan Thirumalaikumar Syncfusion Team July 14, 2021 10:08 AM UTC

Hi Chris, 

Thank you for interesting in Syncfusion products. 

We have checked your query “Problem with entering values in numeric datagrid fields” at our end. Based on the provided replication procedure, we have prepared the simple sample with  
*Two numeric columns, 
*Enabled add new row, 
*Changed polish language and polish regional settings.
While entering in the numeric textbox we can get the entered values. We regret to let you know that the reported issue not reproduced at our end. you can refer the following sample and video for your reference. 



Please have a look at this sample and let us know if we have missed anything you have done in your application. Try to reproduce the reported issue in this sample and revert to us with the modified sample. Otherwise please get back us with the simple video to demonstrate how you done the polish language configuration and recreate the scenario at your end. It will be more helpful for us to provide a prompt solution at earlier 

Thanks & Regards, 
Balamurugan Thirumalaikumar


PI Piotr July 14, 2021 12:49 PM UTC

Hi.

I've got exactly the same (unexpected) behavior using your sample application (please see the attached video). Can you tell me if you are single clicking on "click here to add new row" box or double clicking on it? I'm asking about this, because this is what I am exactly doing:

1) move mouse pointer to "click here to add new row" box

2) click (once) on this box

3) start typing "345" (result is "3,01")

4) press TAB key

5) start typing "345" (result is "3,01")

I've checked that on two different machines (both have polish version of Windows 10 OS) and got the same results.

Thanks,

Chris.



Attachment: SfDataGrid_Demo_20210714_144643_1984cad9.zip


BT Balamurugan Thirumalaikumar Syncfusion Team July 15, 2021 02:27 PM UTC

Hi Chris, 
 
Thank you for the update. 
 
We have checked your scenario and video at our end. We were unable to reproduce the reported issue at our end, as we had previously stated. we could not fix any issue without replicating it from our end. The reported scenario is most likely due to Polish language settings. If this is the case, we have changed the language settings and regional settings on our machine (Windows 10) to polish, as shown in our previous video on how to set the polish language configuration. Could you please double-check that and let us know if we missed anything?.  
 
Can you please check that and if there's anything else we need to do to set up the Polish language on our end. Also, could you send us a video of how you set up the Polish language settings on your end. which would be helpful us to check further and provide you the solution at the earliest. 
 
 
Please let us know if you would require any other assistance. we will be happy to assist you. 
 
Thanks & Regards, 
Balamurugan Thirumalaikumar 



PI Piotr July 16, 2021 06:42 AM UTC

Hi.

We're using polish Windows OS, so it has polish settings by default. For testing purposes I've installed new OS using Win10_21H1_English_x64.iso file (I haven't changed any regional settings, so this OS has default "US" settings). Then I installed Visual Studio Community 2019 and Synfusion Essential Studio for Windows Forms 19.2.0.44. After that I started your sample project and I repeated the same steps as before. I've made a video using program which visually captures mouse clicks and keystrokes, so you can clearly see what I was doing (please see attached file). Still got the same behavior, so this is not related to polish regional settings. OS info:





PI Piotr July 17, 2021 03:18 PM UTC

I've uploaded video file again (there was something wrong with previously uploaded file so I've deleted it).

Edit: I think that the most important thing is that I'm not using mouse clicks to activate every field. I suspect that probably you're doing the opposite - which is hard to say for sure, because mouse clicks are not visible on your video.

Please try to click only once (single-click, not double-click) to activate the grid and then do not use any more mouse clicks (to activate next field use TAB key only). This should lead to the same bahovior as mine.


Attachment: datagrid_english_video_6482c5b2.zip



BT Balamurugan Thirumalaikumar Syncfusion Team July 19, 2021 01:51 PM UTC

Hi Chris,  
  
Thank you for using Syncfusion products.  
  
We confirmed that reported scenario is a defect from our end. We have logged a bug report for this issue “Value entered in GridNumericColumn is incorrect when the cell has decimal value”. Here we have provided private feedback link, we request you to log in to view the link further      
   
  
The fix will be available in our August 3,2021 nuget release. If you have any more specification replication procedure or a scenario to be tested you can add it as a comment in the portal also. 
  
Regards,   
Balamurugan.Thirumalaikumar 


Marked as answer

BT Balamurugan Thirumalaikumar Syncfusion Team August 3, 2021 07:14 AM UTC

Hi Chris,      
     
Thanks for your patience.      
     
The fix for the issue “Value entered in GridNumericColumn is incorrect when the cell has decimal value” has been included in weekly NuGet release (v19.2.0.51). You can downloaded the package from the following link.     
     
Link : https://www.nuget.org/      
     
Regards,      
Balamurugan.Thirumalaikumar   


Loader.
Up arrow icon