How do I change formatting of a cell in datagrid based on the value in the cell?

Question

0.00/5 (No votes)

See more:

I have following datagrid

XML

<DataGrid x:Name="dataGrid" ScrollViewer.CanContentScroll="True" SelectionUnit="Cell" 
                    Height="Auto" Margin="5,58,5,50" ScrollViewer.VerticalScrollBarVisibility="Visible" 
                    AutoGenerateColumns="True" AlternatingRowremoved="#FF9BEEE2" IsReadOnly="True" AutoGeneratingColumn="dataGrid_AutoGeneratingColumn" SelectionMode="Single">
 </DataGrid>

Some of the columns contain floating number and I would like to format the number with fixed number of decimals.

Second question:

I would also like to change the background color of a cell based on the value.

Posted 17-Jan-15 21:50pm

Tommy Jensen

Updated 17-Jan-15 21:51pm

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

InbarBarkai · Answer 1 · 2015-01-17T22:40:00

Solution 1

Hi Tommy,

As far as I know, you can't do this with autogenerated columns via xaml.
You have several options to do it:

Iterate through the columns after the binding and set either the CellStyle or the CellTemplate.
Create the columns in advance and then override the CellStyle or CellTemplate.
Replace the data binding of each column with a new binding with a string format.

If I'll come up with another option I'll comment again.

Good luck,
Inbar

Posted 17-Jan-15 22:40pm

InbarBarkai

Updated 24-Jan-15 18:28pm

v2

Comments

Tommy Jensen 24-Jan-15 4:24am

Hmm I was able to change the collumn headers during generation of the grid with the AutoGeneratedCollumn method so would have hoped it would possible to change alignment for example also. At minimum I would like to change cell alignment to right on some of the collumns.

InbarBarkai 25-Jan-15 0:27am

Try to assign a style to the column's cell style property

How do I change formatting of a cell in datagrid based on the value in the cell?

1 solution

Solution 1

Add your solution here

Preview 0

How do I change formatting of a cell in datagrid based on the value in the cell?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us