Hi,
Once again trying to ensure this control will do everything we need, we want to be able to differentiate changes between different Phases on our Grid. We are pivoting across Phases (1, 2, 3) and on each Phase we want to be able to indicate (Red / Green) if the costs have gone Up / Down. See an example below
Never mind I was able to figure it out, within the Initialize Row Event
for(int i =1; i < e.Row.Cells.Count;i=i+2) { if(i>2) { if ((decimal)e.Row.Cells[i].Value > (decimal)e.Row.Cells[i - 2].Value) e.Row.Cells[i].Appearance.Normal.BackColor = Color.Red; else if ((decimal)e.Row.Cells[i].Value < (decimal)e.Row.Cells[i - 2].Value) e.Row.Cells[i].Appearance.Normal.BackColor = Color.Green;
} }
Hello Jose,
I’m glad you were able to execute the functionality you were looking for. If you have any other questions, please let me know.
We are able to recreate this issue, and are currently looking into a fix for it. The issue seems to be involved with the order in which events fire within the UltraPivotGrid.
I will update you with our progress on the issue as we develop the situation.
Jose,
While we are still looking into the root cause of the issue, we have developed a viable workaround for the time being.
If you call the UltraPivotGrid.BeginUpdate() within the UltraPivotGrid.DataSource.ExpandAxisTupleMemberAsyncCompleted and UltraPrivotGrid.DataSource.CollapseAxisTupleMemberAsyncCompleted events, and then call EndUpdate() at the end of your InitializeRow event, this will prevent the PivotGrid from painting until all cells' colors have been determined and applied. This will cease the white flickering you are seeing.
Please take a look at the sample I've attached here to see how I implemented this workaround as an example, and please let me know if you have any questions regarding the workaround.
Thanks John,
I'll give it a shot
We completed and verified the fix for this issue. Please take a look at your support case activity at Infragistics.com to find the link I sent you to our bi-weekly build including this fix.
The fix for development issue is in the service release that we released on June 24th, 2016.
To download the latest service release follow these steps:1. View My Keys and Downloads: https://www.infragistics.com/my-account/keys-and-downloads2. Log in to the Infragistics web site if you are not already logged in.3. Select the product you would like to download a service release for.4. Select the “Service Releases” tab.5. Select the download (e.g. Infragistics Xamarin.Forms 2015 - Service Release)