Hi,
I am looking for formatting numbers in a XamGrid at column level, i am using template columns and String Formatting . But I am not able to show parathesis around negative numbers . I would like to get excel like accounting format i.e -
-123456.56 should be displayed (123,456.5678)
123456.8990 should be displayed like 123,456.8990
Is it possible. ?
I am using Xamgrid 11.6 with VS studio 2010.
Thanks
Sorry for rather late reply but yes your reply put me in correct directions.
This is the solution, when you have defined the Columns in xaml.
But when u're not defining the columns and want this behavious to be default, then what should be done?
This is a major functionality, i'm looking for.
Please help.
VJ
Hello,
I am just checking if my last reply was helpful for you.
If you require any further assistance please do not hesitate to ask.
I have been looking into your post and the columns’ ‘StringFormat’ property is based on the Microsoft String Format. You can look through the following link about ‘Custom Numeric Format String ’ :
http://msdn.microsoft.com/en-us/library/0c899ak8.aspx
According to it you can set the column’s ‘StringFormat’ property to “{}{0:#,###.####;(#,###.####)}” and you will achieve the desired functionality.
If you need any further assistance, do not hesitate to ask.
Correction
XamGrid version is 11.2