[Solved] Different numeric formatting on each row

[Randy]

I have a grid that contains a fixed number of rows.  Each row has 13 columns - a description and a column for each month in a year.  Some of those rows contains integers, some decimals, and some percentages.  I would like to format the integers as whole numbers, the decimals as currency with the $ sign, and the percentages as decimals with 2 places but no currency symbol.  The user can enter data into each of these cells.  The entity that this data comes from has a field that is not bound to the grid that can be used to identify each row with the type of formatting it should be (i.e. 1 for int, 2 for currency, 3 for decimal).

What I need is to correctly format these cells so that the behave as close to having them in their own grids with static formatting.  I have tried Data Templates and Converters, but the only solution that seems to work is to have separate grids.  Any help would be appreciated.

-Randy

[Maya]

Hello Randy,

You can benefit from DataTemplateSelector and depending on the value of the property used for formatting it (1 for int, 2 for currency, etc.). If you want the same behavior in edit mode as well, you can use CellEditTemplaetSelector as well. Please take a look at our online documentation and demos for a reference.
Let me know in case you need any further assistance.
 

Kind regards,
Maya
the Telerik team