Hi
In my pivotgrid I have the following hierarchies :
On Columns - Geographies (e.g. World, Regions, Countries )On Rows - Items (e.g. Item Level 1, Item Level 2, Item Level 3)
and a single measure (Percentage Improvement) which has a custom aggregator which works out the weighted average improvement.
So the geographies hierarchy could contain:
World Europe UK Ireland France
and the items hierarchy:
Items Group 1 Items Group 2 Item 1 Item 2
I have implemented cell editing which is working but when I try to fine-tune it, I begin to get a little stuck so am hoping you'll be able to give me some direction.
1. In the example above, let's say that Item 1 can only have an improvement entered against the region level and so we need to disable direct user editing for UK, Ireland & France for Item 1. I have trapped the CellEnterEdit event but can't see anyway of cancelling the edit (or disallowing it). Is there a way?
2. Assuming the user has entered 10% against Europe for Item 1, I pass this value down to each of the child countries to keep the aggregator working but I don't want to display the value at country level for this item. Is this possible?
Thanks
Keith
HI,
As far as canceling editing of a cell, you could wire up the CelEditing Event and cancel it.
Here a link on CellEditing Event.http://help.infragistics.com/NetAdvantage/WPF/2012.1/CLR4.0/?page=InfragisticsWPF4.Controls.Grids.XamPivotGrid.v12.1~Infragistics.Controls.Grids.XamPivotGrid~CellEditing_EV.html
Sincerely,
Matt Developer Support Engineer
Hello Matt.
As far as I can see, CellEditing event is fired when cell is exiting editing, but the author was talking about CellEnterEdit event.
So, this is completely different cases: to cancel start of editing or to cancel editing.
I have an urgent requirement to restrict editing for certain cells too. How can I archieve this? All that I have came up with is to replace CustomEditor with Label in CellEnterEdit event, but the cell still enters edit mode, which cancels keyboard navigation.
P.S. It's so strange than this control doesn't have such trivial functionality as conditional read-only cells or double-click editing :(