Graphics.MeasureString - Having trouble with CellPainting with DataGridView

Hello,

I am trying to display a column in a datagridview, so that it looks like the currency format in excel.

By this, I mean that the currency sign or symbol ("$") is in the same place, on the left hand sign in each cell, but if the cell value is negative then it will have a negative sign in front, and then the value following this but on the right hand side of the cell.

My problem is that I cannot figure out how to line up the symbol.
This is the code I have written so far

private void DataGridView1_CellPainting(object sender, DataGridViewCellPaintingEventArgs e)

{

Decimal Value;

String Symbol;

RectangleF Bounds;

StringFormat Format;

if (e.ColumnIndex == 1 && e.RowIndex >= 0 && e.Value != null)

{

e.PaintBackground(e.ClipBounds, true);

Value = Convert.ToDecimal(e.Value);

Format = new StringFormat();

Format.Alignment = StringAlignment.Near;

Format.FormatFlags = StringFormatFlags.NoWrap;

Bounds = e.CellBounds;

if (Value >= 0)

{

Symbol = "$";

float CharWidth = e.Graphics.MeasureString("-", e.CellStyle.Font).Width; // Make a space where the negative sign would be

Bounds.X += CharWidth;

Bounds.Width -= CharWidth;

}

else

{

Symbol = "-$";

Value = 0 - Value;

}

e.Graphics.DrawString(Symbol, e.CellStyle.Font, new SolidBrush(e.CellStyle.ForeColor), Bounds, Format);

Bounds.X += Bounds.Width;

Bounds.Width = e.CellBounds.Width - (Bounds.X - e.CellBounds.X);

if (Bounds.Width >= 0)

e.Graphics.DrawString(Value.ToString(), e.CellStyle.Font, new SolidBrush(e.CellStyle.ForeColor), Bounds, Format);

e.Handled = true;

}

}

Unfortunatly the measure string gives a larger result than expected, almost like it has a space after it
Any ideas as to how to get it around this?

Thanks

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Grant McConville15y ago
Because I want the currency sign to be all lined up on the left hand side of the column
eg
-$ 1,403.25
$ 25.62
-$ 128.32
Suthish Nair15y ago
I didn't worked on this event or logic, but just want to know why don't just concatenate currency sign to your output instead of calling CellPainting event. I meant to say why you need that event.
Grant McConville15y ago
I thought about replacing this line

float CharWidth = e.Graphics.MeasureString("-", e.CellStyle.Font).Width; // Make a space where the negative sign would be

with this one

float CharWidth = e.Graphics.MeasureString("-$", e.CellStyle.Font).Width - e.Graphics.MeasureString("$", e.CellStyle.Font).Width

However, this does not line either.

I'm a little bit stumped as to why this does not work
Grant McConville15y ago
I don't see how this would work
Suthish Nair15y ago
can we do this in simple like this: string s = "-1".Replace("-", "- $");