number format cells in xml

Discontinued products Uncategorized discussions
#1

hi, i am creating a grid with xml and need to set indivdual cell types to the number formats.



i have looked at your examples which show how to do with it javascript: dhtmlx.com/docs/products/doc … ndex.shtml



but how do i do this in the xml document please?



also i have tried setting the cell types to what you state in your example… edncl, and ednro but they dont do anything, do i have these types correct?



thanks

#2

edncl, and ednro
I’m not pretty sure to which example you are reffering, but there is no excells with such name. Formating can be applied to “ron” and “edn” column types

>>but how do i do this in the xml document please?
format can be defined as part of column configuration




<column type=“ron” format=“0,000.00” …


#3

hi

i need to add the types to cells instead of columns. in each cell tag i have type=“edn” and format="0"

yet when i run the grid it first displays a 0 in the cell and then if i type 0.9 then it doesnt do any formatting on it at all

am i doing this right?

thanks

#4

Format is column specific and can’t be assigned to specific cells only.
If you need to have format for some cells in column and have not it for others you can define format for whole column ( by setNumberFormat ) and use type attribute of cell.
Cells with “edn” type will have format applied, cells with “ed” type will not have formatting.

#5

very neat solution, thanks very much