.I am having problems entering a null value into a numeric cell during cell editing. We use custom editors (so a custom element and value generator) to deal with things like currency symbols and percent signs. When attempting to enter a simple blank value into the cell, it is treated as if the cell editing was canceled.
As a workaround for this, I’ve started storing “secret values” such as “-999999999” and then rendering that as blank in our custom element, but that is definitely sub-optimal.
I have tried using the EditOption “NullIfEmpty”, but it seems to have no effect at all.
Is this a known problem? Is there something I am not understanding about null handling? Thanks in advance.
Hello,
” When attempting to enter a simple blank value into the cell, it is treated as if the cell editing was canceled.”
This depend on your code, since you have a custom functions defined.
Where you want to store the null – in the server or in the clientArray data?
Currently we have missed null if empty in cell edit and we have added it
If yo want to store the null value to the server you can use serializeCellData.
IMPORTANT NOTE: To use both features (serielizeCellData and NullIfEmpty), please download the latest build from gitHub
Suppose the user enter empty value, then
|
1 2 3 4 5 6 7 8 9 10 |
... jqGrid({ ... // the name parameter was added just now in github serializeCellData : function( postdata, name ) { if(postdata[name] && postdata[name] === "" { postdata[name] = 'null'; } return postdata; } |
Please, let us know if this solved the problem.
Thank you
Kind Regards,
Will
Guriddo Support Team
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
