Hi,
I am trying to apply the following:
uwg.DisplayLayout.Bands[0].Columns[0].Format = "###.###.###,00";
but in return I get this:
7681,25000000
To add to the confusion, if I try the following pattern:
###,###,###.00
I get the following
7 681,25
Strange indeed.
Help any one?
The first one is wrong and the second one worked fine. Here is my line of code:
this.UltraWebGrid1.DisplayLayout.Bands[0].Columns[2].Format = "###,###,###.00";
If it's not working, then I would like to know what kind of data you are getting from the database. Please let me know the version of NetAdvantage, Visual Studio and .Net Framework you are using.
Thanks
Hi!
Why is it wrong? In Denmark we use comma as decimal separator and periods as group separators. Surely You support more than US formats?
I assumed that you are trying to do something like 1,000,000.00 with the format column and it was not working the way it supposed after setting in both ways. I didn't realize about different culture settings. Thanks for pointing my mistake. The second format (###,###.00) works and for some reason the other format (###.###,00)does not. I was wondering if you have tried to set the culture info or not. If yes, then did it work or not.
Sarita
thanks. Now it works.
I was assuming that you should enter a pattern with the separators requested. Instead it seems that applying the proper cultureinfo will replace the periods and commas accordingly.
my mistake was that the cultureInfo was not properly set in the current thread combined with the faulty format.
Thank You!