no floating point numbers appear in grid column

Suite and Optimus Suite 5
#1

Hello,

i have the problem that floating point numbers are not shown in my grid, when i am filtering the grid with a numeric filter.
The floating point numbers are correctly shown in my grid columns, but when i am using the numeric filter, i get only shown integer value in the filtered column.

e.g in the column i have numers like
8
9,5
10
When i am using a filter like “9…11” or “>8” in the attachHeader i get only the row containing the 10 back, but not the row containing the 9,5.

i am using the following ColTypes, ColSorting and attachHeaders.

grid_2.setColTypes(“ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro”);
grid_2.setColSorting(‘na,str,str,str,str,str,int,str,int,int,int,int,str’);
grid_2.attachHeader(",#text_filter,#text_filter,#select_filter,#text_filter,#select_filter,#text_filter,#text_filter,#numeric_filter,#numeric_filter,#numeric_filter,#numeric_filter,#text_filter");

I have tried to use “.setNumberFormat” on my columns, but it did not work.

Does anyone know, how i can the floating point numbers shown correctly?

best regards,

Harald

#2

unfortunately the issue cannot be reproduced for us with the “ro” exCell type.
The following sample also works well:
dhtmlx.com/docs/products/dht … r_num.html
If issue still occurs for you - please, provide with a complete demo, where the issue can be reconstructed locally.