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
Hello,
Thank you for your post. I have been looking into it and I created a sample project with the functionality you want. Basically I handled the XamPivotGrid's CellControlAttached event and in the handler I handle the CellControl's PreviewMouseLeftButtonDown event. In its handler you are able to get the current Cell and handle the event if a condition is met, which won't put the cell in edit mode. You can also suggest a product idea for adding "CellEnteringEditMode event" here:
http://ideas.infragistics.com/
Hello? I really need SOME way to restrict edit in certain cells of PivotGrid. As topic starter said, there is no way to cancel CellEnterEdit event, so cell enters edit mode on click. How can I overcome this?
This is really urgent.
Thanks!
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 :(
HI,
Can you elablorate more on your 2nd issue?
Is it that you dont' want to display a value at all or is it just not display the newly updated values?.
Sincerely, Matt Developer Support Engineer