Jul 23, 2014, 3:17 AM
Bug Drag/Drop Excel to Grid MVC DateTime Column
My DateTime column in grid
Html.X().DateColumn().Text(Util.GetLang("IssuedOn" )).DataIndex("IssuedOn").Width(100).Format("dd-MMM-yy").Editor(Html.X().DateField().Format("dd-MMM-yy").AllowBlank(false).Editable(false))
My row in Excel
YY IssuedOn Warranty No Issued by Code Customer Amt Credit days Expiry date Last day
2014 29-May-14 C42 MB-CN 28 CTY TNHH 500 60 14-Nov-14 31-Aug-14
In File DataDrop.js
If column YY or WarrantyNo or Issued by it can drag and drop ok but when it is IssuedOn
this code data[fldName] = fld ? fld.convert(vals[k]) : vals[k]; have bug
fld.convert(vals[k]) undefined >>>> data[fidName] undefined
>>>> var newRec = new Record(data); newRec got IssuedOn = null
What can I do to fix this bug
Html.X().DateColumn().Text(Util.GetLang("IssuedOn" )).DataIndex("IssuedOn").Width(100).Format("dd-MMM-yy").Editor(Html.X().DateField().Format("dd-MMM-yy").AllowBlank(false).Editable(false))
My row in Excel
YY IssuedOn Warranty No Issued by Code Customer Amt Credit days Expiry date Last day
2014 29-May-14 C42 MB-CN 28 CTY TNHH 500 60 14-Nov-14 31-Aug-14
In File DataDrop.js
If column YY or WarrantyNo or Issued by it can drag and drop ok but when it is IssuedOn
this code data[fldName] = fld ? fld.convert(vals[k]) : vals[k]; have bug
fld.convert(vals[k]) undefined >>>> data[fidName] undefined
>>>> var newRec = new Record(data); newRec got IssuedOn = null
What can I do to fix this bug