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.