Regarding #SCL and NAN Error in dhtmlXGridObject

[bhavdip.shah]

Hello Team :-

We are using dhtmlXGridObject to render the grid but we are facing one issue as shown in the attached screenshot (dhtmlXGridError.png)

As shown in the attached screenshot when we have apostrophe symbol in task name under the resource name we get #SCL error in that row and the sum formula then gives NAN error in parent row.

The complete xml file returned from the server to render this grid is as follows:-

- #master_checkbox - - - - - - - - - - <![CDATA[ Mon
23 ]]> - - <![CDATA[ Tue
24 ]]> - - <![CDATA[ Wed
25 ]]> - - <![CDATA[ Thu
26 ]]> - - <![CDATA[ Fri
27 ]]> Total - Dhaval (Dhaval Upadyaya) b5b24e95-63d3-42c4-87d1-e43fa71047b8 - - <![CDATA[ ]]> - 2 Testing Tasks - Shared Task - multiple assignments - - <![CDATA[ ]]> 0 0 0 0 0 0 - HR System - test task 2 - - <![CDATA[ ]]> 0 0 0 0 0 0 - test task 1 - - <![CDATA[ ]]> 0 0 0 0 0 0 - Bhavdip123 Shah (Bhavdip Shah) 6d1ee776-3337-4e8b-9e65-87094779ac74 - - <![CDATA[ ]]> - Apostrophe TS's test - TestWithout - - <![CDATA[ ]]> 0 0 0 0 0 0 - Europol Test 1 - T1 - - <![CDATA[ ]]> 0 0 0 0 0 0 - Individual_1_Tasks - Indiv-1-Task - - <![CDATA[ ]]> 0 1 0 0 0 1 - TestEPML4242 - T1 - - <![CDATA[ ]]> 3 0 0 0 0 3 - T2 - - <![CDATA[ ]]> 2.22 0 0 0 0 2.22 - T3 - - <![CDATA[ ]]> 0 0 0 0 0 0 - Without Apostrophe - Test without - - <![CDATA[ ]]> 0 0 0 0 0 0

Can you please look into this and get back to us with relevant solution.

Your early response would be greatly appreciated.

Thanks & Regards,
Bhavdip

[sematik]

I apologize for the delay.
Pleas,e try to update the version of your dhtmlxGrid. It should solve the problem.