Number format: Red color for negative number

[Administrator]

Hello,

I''m wondering if there''s a way to emulate Excel''s number format for negative number, using the numberformat text.

In Excel, it''s possible to put in color text (eg. [Red]) for the number format. The end user can change that through number format text.

Is there a similar feature here?

Thanks!

[Administrator]

You will have to use an event like PrepareViewStyleInfo to dynamically change the text color.

private void gridControl1_PrepareViewStyleInfo(object sender, GridPrepareViewStyleInfoEventArgs e)
{
	double d;
	if(e.RowIndex > 0 && e.ColIndex == 2 
		&& double.TryParse(e.Style.Text, System.Globalization.NumberStyles.Any, null, out d)
		&& d < 0)
	{
		e.Style.TextColor = Color.Red;
	}
}