Hi,
I am evaluating xamPivotGrid and from what I have seen it seems to satisfy most of my requirements. There are couple of features that I am looking for and please let me know if it is supported.
In my case, I may be using a flat data source and allow edit capability in Pivot. So my question is:
1. Is it possible to edit a cell and programatically get the edited value and the cell context like Row & Column object?
2. Is it possible to lock certain levels or members of data that are displayed in Pivot Grid?
Thanks.
B.Manohar
Hi
The pivot grid does not support edit cell features. It is because the cell value is estimated based on many values in the datasource and it is impossible to know how to return the value back to data source .
It is possible to lock levels the grid is expanded. There is AxisExpansionChanging
Event in pivot grid where you can cancel the expansion of the grid.
Regards
Todor
Thank you for your response.
I was hoping to get edit feature with your pivot grid control. If cell edit is protected and not exposed, then could you please help me identify if any of your controls will satisfy my requirement.
Here is what I am looking...
1. A pivot like control with the ability to show hierarchical data on both row and column
2. Ability to show the selected hierarchy either in row or column
3. Ability to show Data Measures
4. I may allow or have only one hierarchy on each row or column (say Product hierarchy on Row and Time hierarchy on Column), so essentially this grid may end up as a two-dimensional table. And, enable edit cell capability.
In summary, if there is a two-dimensional table/grid that has the following capability, then that may be suffice my requirement for now.
- to show hierarchical data on row and column
- to show data measures
-to allow cell edit
You can check another our grid control called XamGrid. It is in LOB part of our product line. The control support cell edit, hierarchical data on row. In new release hierarchical data will be supported and in column, and it shows data
Here is a link for samples.
Hi All,
I just want to menton that starting from 11.1 version pivot grid support cell editing
So, in new release of XamGrid, there will be support for having hierarchical data on row and in column at the same time and cell edit as well. Will it support both homogeneous and heterogeneous datasets?
When is this release expected to be available?
Also, let me know if there is any exceptions that you have built into the XamPivotGrid using which I can enable cell edit conditionally based on Cell Click event for example.