Number format in schema model field

[Ian]

HI,

I have a Kendo UI spreadsheet control bound to a datasource. I need to format the currency fields within to include a thousand separator as follows 13,000,000. How is this possible in the schema/model/fields. Here is my code:

schema: {
                    model: {
                        id: "ItemId",
                        fields: {
                            ItemAmount: { type: "number", format: "#,#" }
                        }
                    }
                }

 

This doesn't work and the number is displayed as 13000000

 

[Martin]

Hello, Ian,

As stated in the DataSource binding documentation, formats, formulas and styles are not persisted when binding to a dataSource. A possible approach would be to use the format method for a specific range and set the desired format. Here is a small example for reference.

Let me know if you have any further questions.

Regards,
Martin
Progress Telerik

[Ian]

Hi Martin

Thanks so much for this answer, i will give it a try

Ian