We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to solve the Row alignment behavior which changes anonymously

Platform: Silverlight |
Control: PivotGridControl |
Published Date: November 26, 2014 |
Last Revised Date: November 26, 2014

Row alignment behavior can be solved by handling codes considering ShowCalculationsAsColumns, PivotCalculations. The following code explains the same.


this.pivotGridControl1.InternalGrid.PrepareRenderCell += (s, eventArgs) =>


if (eventArgs.Cell.RowIndex > (pivotGridControl1.PivotColumns.Count - (this.pivotGridControl1.ShowCalculationsAsColumns ? 0: 1) - (this.pivotGridControl1.PivotCalculations.Count == 1 ? 1:0) + (!this.pivotGridControl1.ShowCalculationsAsColumns && this.pivotGridControl1.PivotCalculations.Count==1? 1:0 ) ))


//For Row headers and value cells

eventArgs.Style.HorizontalAlignment = System.Windows.HorizontalAlignment.Left;


else if (eventArgs.Style.CellType.Equals("ExpanderCell"))


//For Column Headers that has only expander cells

(eventArgs.Style as GridStyleInfo).HorizontalAlignment = System.Windows.HorizontalAlignment.Center;




//For Column Headers that has static cells

eventArgs.Style.HorizontalAlignment = System.Windows.HorizontalAlignment.Right;





C:\Users\labuser\Dropbox\Screenshots\Screenshot 2014-06-10 18.29.28.png

Figure: Pivot Grid shows customized row alignment



You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon