Blogs

Woody Pewitt - DevExpress Analytics Blog

WPF PivotGrid - Field Value Appearance Customization (available in v2011.1)

     

In the upcoming release of the WPF PivotGrid control we have added a new event that will allow you to customize the appearance of field value cells. From this event you can specify the brushes used to paint the background and foreground of the processed field value cell.

In past versions there was a similar event that when combined with this new event gives many new ways to conditionally customize the visual presentation of WPF Pivot Grid elements.

You can see in the example How to customize the appearance of cells that with the existing event, CustomCellAppearance, how you can use the PivotCustomCellAppearanceEventArgs argument witch will give you the PivotCellBaseEventArgs class to modify properties related to the Cell. Now with the new CustomValueAppearance event you will get the PivotCustomValueAppearanceEventArgs argument witch will give you the PivotFieldValueEventArgs class to customize column and row headers.

You can see from the table below that each event gives you different sets of properties that when used together can be used to create rich data presentations for your users like the image blow the table.

CustomCellAppearance

 

CustomValueAppearance

PivotCustomCellAppearanceEventArgs

PivotCustomValueAppearanceEventArgs

  • Foreground
  • Background
  • IsExporting
  • ColumnCustomTotal
  • ColumnField
  • ColumnFieldIndex
  • ColumnIndex
  • ColumnValueType
  • Data
  • DataField
  • DisplayText
  • Focused
  • Item
  • RowCustomTotal
  • RowField
  • RowFieldIndex
  • RowIndex
  • RowValueType
  • Selected
  • SummaryType
  • SummaryValue
  • Value

  • Foreground
  • Background
  • IsExporting
  • CustomTotal
  • Data
  • DataField
  • FieldIndex
  • IsCollapsed
  • IsColumn
  • IsOthersValue
  • Item
  • MaxIndex
  • MinIndex
  • Value
  • ValueType
  • Field

We hope you can use this new functionality to bring better and richer solutions to your users.

Published May 25 2011, 09:30 AM by Woody Pewitt (DevExpress)
Bookmark and Share

Comments

 

James Foye said:

Is this what I would use to do percent bars in cells?

May 25, 2011 2:07 PM
 

Woody Pewitt (DevExpress) said:

James, have you looked at the Cell Templates demo that we ship in demo center? It shows how to create percent bars in cells. This has been available for some time. The new functionality with the CustomValueAppearance event will allow you to modify the appearance of cells and Row and Column headers without having to create cell templates.

Thank you and please let me know if I can help with anything you need.

-- Woody

May 26, 2011 4:37 PM
 

James Foye said:

Woody, thanks, I will check that out.

May 29, 2011 12:45 PM
More from DevExpress
Live Chat
Have a pre-sales question?
Need assistance with your evaluation?
We are here to help.
Chat is one of the many ways you can contact members of the DevExpress Team. We are available Monday-Friday between 8:30am and 5:00pm Pacific Time.
If you need additional product information, require pre-sales assistance, or want help with your order, write to us at info@devexpress.com or call us at
+1 (818) 844-3383.