Grid in batch edit mode, DateTimePicker dirty state

[Gama System]

Hello

I have a problem configuring and editing datetime values in Grid when in batch edit mode.

I receive datetime values from server in UTC format and bind it on column, that is dynamically generated.

Transforming UTC date string received from server into Date object is not feasible, because large data sets. 

As soon as I double click into cell, it is marked as dirty. I can not cancel edit and cell stays marked as dirty.

Attached is a sample project (asp .net core, angular 11, syncfusion 19.2.55).

- run project
- manualy run command "npm start" from ClientApp folder because proxy is in use
- double click into "Date" column
- move focus away from column
- column is marked as dirty (green background)
- cancel button does nothing
P.S.: clicking "Edit" does nothing after row is selected (perhaps missing configuration)

Please help.

Thank you

Attachment: SyncfusionDemo_82d84efc.zip

[Thiyagu Subramani]

Hi Matevž, 

Thanks for contacting Syncfusion support. 

We looked over the sample and believe you're utilizing date values that are in string format. The date string should be parsed into date Object by default to perform editing, filtering, and sorting on date values. To fix this, we'll need to convert the date string values into date objects in the data(To be assigned to the Grid). 

This can be achieved by using the Syncfusion data component’s DataUtil.parse.parseJson method. It will parse the data before assigning it to the Grid’s dataSource as demonstrated in the below code snippet, 

import { DataUtil } from "@syncfusion/ej2-data"; 

. . . . . . 

 

this.dataSource = new DataManager({ 

      json: DataUtil.parse.parseJson(this._dataSource) 

    }); 

Please get back to us, if you need any further assistance. 

Regards, 

Thiyagu S 

[Gama System]

Than you for fast reply.

I tested the utility on +100k records and for now the performance is ok.

[Thiyagu Subramani]

Hi Matevž, 

Thanks for the update. 

We are happy to hear that the provided solution works at your end.  

Please get back to us if you need further assistance. 

Regards, 

Thiyagu S