Hi,
Is there any way to make the Pivot Grid editable. That is allow user to change the cell values by typing into it. And also how can these be committed to the underlying FlatDataSource.
Thanks
Sangeetha
Yes, there is a way to make pivot grid editable.
First you have to allow cell editing - set "AllowCellEdit" property to true. "AllowCellEdit" property is in pivot grid "EditSettings" property. Second you have to mention which measures you want to edit - add a measure in "EditableMeasures" collection. "EditableMeasures" collection is in pivot grid "EditSettings" property. When you edit a cell two events are fired - CellEditing and CellEdited. The third thing is to catch these events and in their event handlers to implement your own logic. The control does not support the functionality automatically to update the source data. You can see how is implemented our sample with FlatData.
http://samples.infragistics.com/sldv/RunSamples.aspx?cn=pivot-grid#/pivot-grid/cell-editing
Hope that this will help you.
Regards,
Mircho Yovchev
Thank You for your reply Mircho.
I set "AllowCellEdit" property to true, and added a measure to "EditableMeasures" collection.
i invoke it via menu Item 'Allow Cell Edit'. Why are the cells not editable until I drag/drop a col from pivot data selector.
Seems like a refresh issue, but refresh does not seem to work either.
Could you please tell me what is the problem here.