Exception when using Numerical Column

Hi,

We are evaluating the SfDataGrid with Xamarin Forms.

Xamarin Forms Version: 2.5.1.444934
SfDataGrid Version: 16.1.0.37

The item source is an MvxObservableCollection. 

       private decimal _orderQuantity = 0;
         [JsonIgnore]
        public decimal OrderQuantity
        {
            get { return _orderQuantity; }
            set
            {
                _orderQuantity = value;
                RaisePropertyChanged("OrderQuantity");
            }
        }
           


The grid cell cannot be edited when used with Numeric Text Column and throws an exception. On the other hand GridTextColumn works fine. We are able to verify data is updated in the underlying object.

Please find attached an image of grid when tried to edit with numeric column.




Attachment: DataGrid_Error_64f4525a.zip

6 Replies

GV Grish V May 3, 2018 01:12 AM UTC

Here is the excerpt of grid defined in Xaml

            <sfd:SfDataGrid ItemsSource="{Binding ProductsCollection}" AutoGenerateColumns="False" EditTapAction="OnTap">
                <sfd:SfDataGrid.Columns>
                    <sfd:GridTextColumn HeaderText="SKU" Width="80" MappingName="Master.Sku" TextAlignment="Center" AllowEditing="True"/>
                    <sfd:GridTextColumn HeaderText="Name" Width="200" MappingName="Name" TextAlignment="Start" />
                    <sfd:GridNumericColumn HeaderText="OrderQuantity" FontAttribute="Bold" MappingName="OrderQuantity" AllowEditing="true" Width="100" TextAlignment="Center"/>
                </sfd:SfDataGrid.Columns>
            </sfd:SfDataGrid>


SK Suriya Kalidoss Syncfusion Team May 4, 2018 01:52 AM UTC

Hi Grish, 
Thank You for using Syncfusion Products, 
We had analyzed your query and checked your replication procedure. We had confirm that the Numeric Column Exception does not occur while editing in our side, but while edit and tapping outside the cell, blank cell issue occurs in Xamarin Forms iOS platform similarly like your attached screenshot. We recommend to use Xamarin Forms 2.4.0.280 Version in the sample. 
Please refer the below link for Xamarin Forms Compatibly map   
We need to know that your attached screenshot issue exists in which platform? so that we can provide exact solution to your query. 
  
We had prepared and attached working sample for your reference, you can download it from below link 
Regards, 
Suriya K 



GV Grish V May 4, 2018 02:17 AM UTC

Hi Kalidoss,

Thank you very much for your reply. The screenshot I sent is from Android.

As suggested, I will downgrade the Xamarin Forms to 2.4.0.280 and try again.

I will revert to you as soon as possible.

Thanks again for helping us out.

Girish


SK Suriya Kalidoss Syncfusion Team May 5, 2018 04:24 PM UTC

Hi Venkatesh, 
Thank You for using Syncfusion Products, 
We had analyzed your query and checked your replication procedure. We had confirmed that the Numeric Column Exception does not occur while editing in our side. We also recommend to use Xamarin Forms 2.4.0.280 Version in the sample. 
Please refer the below link for Xamarin Forms Compatibly map   
We need to know that your issue exists in Xamarin Android or Xamarin Forms Android? because this similar issue exists in Xamarin Android but not in Xamarin Forms Android. 
 If your requirement deviates from us, please send the sample or code that you have been facing issue 
We had prepared and attached working sample for your reference, you can download it from below link 
Regards, 
Suriya K 



SK Suriya Kalidoss Syncfusion Team May 5, 2018 04:36 PM UTC

Hi Grish, 
Please ignore the previous update. 
Regards, 
Suriya K 



GV Grish V May 16, 2018 06:34 PM UTC

I could not downgrade the Xamarin Forms version as suggested due to other dependencies.

Further, SfDataGrid works fine with Xamarin Forms 2.5.X in another project (PCL).
I have even checked the SfDataGrid on Xamarin Forms Version 3 successfully.

I have uploaded the sample code to GitHub.

https://github.com/girishv6991/GridDb

Loader.
Up arrow icon