General Cell Format

[Administrator]

Is there a way to format a cell like Excel's "General" format so that numbers are automatically right aligned and strings are left aligned?

[Administrator]

> Is there a way to format a cell like Excel's "General" format so that numbers are automatically right aligned and strings are left aligned?
>

No.

But you could handle PrepareViewStyleInfo, and set e.Style.HorizontalAlignment dynamically. If you have explicitly set the CellValueType for your numeric cells, you could test e.Style.CellValueType to determine how to set the alignment. If you have not set the CellValueType, you could try parsing e.Style.Text to see if it parses as a number to test what is in the cell.

[Jeff]

I need text to align right for financial numbers which seems to be a very common occurence for grids? Um can someone please create a sample for this for us not so advanced programmers? plz

>> Is there a way to format a cell like Excel''s "General" format so that numbers are automatically right aligned and strings are left aligned?
>>
>
>No.
>
>But you could handle PrepareViewStyleInfo, and set e.Style.HorizontalAlignment dynamically. If you have explicitly set the CellValueType for your numeric cells, you could test e.Style.CellValueType to determine how to set the alignment. If you have not set the CellValueType, you could try parsing e.Style.Text to see if it parses as a number to test what is in the cell.

[Administrator]

Are you using one of our grids?