Align a string on Decimal

[Guest]

I am trying to align a column in DataGrid so the decimal's match up (not
using fixed fonts). Is there anyone who has code for doing this using
StringFormat or something else. Thanks.

 

[Ken Tucker [MVP]]

Hi,

Would setting the columns alignment to HorizontalAlignment.right
work for you?

http://msdn.microsoft.com/library/d...tingwindowsformsdatagridvisualbasicprimer.asp

http://msdn.microsoft.com/library/d...rmsdatagridcolumnstyleclassalignmenttopic.asp

Ken

 

[Guest]

It comes close but really doesn't align the decimal point for Proportional
Fonts, especially numbers like 34.11 and 45.55.

 

[Jay B. Harlow [MVP - Outlook]]

Dennis,
My understanding is numerics in proportional fonts are *always* the same
width, so a 5 is the same width as a 1, allowing number to be aligned in
columns with no effort!

So using HorizontalAlignment.right as Ken suggests should be exactly what
you want. You may want to include a

34.11
45.55

Can you post sample code or email me a picture where it is not working!

Hope this helps
Jay

It comes close but really doesn't align the decimal point for Proportional
Fonts, especially numbers like 34.11 and 45.55.

 

[Guest]

I'm sorry, I meant non-proportional that don't have fixed spacing for the
characters.

Dennis,
My understanding is numerics in proportional fonts are *always* the same
width, so a 5 is the same width as a 1, allowing number to be aligned in
columns with no effort!

So using HorizontalAlignment.right as Ken suggests should be exactly what
you want. You may want to include a

34.11
45.55

Can you post sample code or email me a picture where it is not working!

Hope this helps
Jay

It comes close but really doesn't align the decimal point for Proportional
Fonts, especially numbers like 34.11 and 45.55.

 

[Jay B. Harlow [MVP - Outlook]]

Dennis,
Numerics (0 to 9) in both proportional & non-proportional fonts are always
the same width! (within the same font of course)

My understanding is the reason that numerics are the same widths is so the
digits line up nicely.

So using HorizontalAlignment.right as Ken suggests should be exactly what
you want!! You may want to include set the Format property of the
DataGridTextBoxColumn so that all cells have the same number of decimal
places...

Again can you post sample code or email me a picture where it is not
working!

Hope this helps
Jay

 

[Guest]

You know, I never realized that this was the case and I work with Word and
Excel all the time. I just tried Times New Roman in Word with a right Aligh
tab and you are certainly correct..you've simplified mylife. Thanks a lot.