Filter with cell formatter

[swatiagarwal]

SmartClient Version: v11.0p_2017-02-11/PowerEdition Deployment (built 2017-02-11)

I have a field in ds with cell formatter applied as below.
<field name="listPrice" type="float" format="$#,##0.00"/>
I have setShowFilterEditor to true.
In filter, if i type a number like 10, the filter shows $10 and results are filtered accordingly.
But if i type $10 in filter, results are not filtered. How can i handle this case. The filter should work with both 10 and $10.

[swatiagarwal]

To deal with above problem, is there a way in which i can limit the user to enter only float values in filter editor.

[swatiagarwal]

Any update on this.