Hi experts,
I have a fancy requirement, I dont know if that is possible. I need to find a specific cell, then hightlight it, and if this row is collapsed, i need to expand it so that user can see it.
For example, in this page, http://www.igniteui.com/pivot-grid/overview , all row/columns are collapsed when initially loaded. But I'd like to hightlight row 2013/Q1, column "Elisa Longbottom". Only that row and its parent row is expanded and that row is highlighted. How to do that? Thanks in advance!!!
Hello srajagopal ,
I’m just following up to see if you’ve been able to resolve your issue. If you have any questions or concerns or if you need further assistance please let me know.
Best Regards,
Maya Kirova
Infragistics, Inc.
http://ko.infragistics.com/support
Hello srajagopal,
Unfortunately the values are calculated runtime based on the defined aggregator function as you expand rows/columns in the Pivot grid.
There’s no way out of the box in which you can find a particular value before its level is expanded.
I suggest you expand all levels and then find the cell you’re looking for. To achieve that you can use the expandTupleMember method as demonstrated in the previously attached sample.
Hi maya, thank you very much for your reply. I guess it's very close to what I need. The problem is I don't know initially which row/column I need to expand, and I don't know which cell i need to hightlight initially. It's decided by cell value. For example, I need to highlight the max value cell and expand that row.
I guess in column formatter, I can write something in cell template, and then find out that row/column/cell based on what I've written into template element's attribute. Can you please guide me how to do that? Or if you have a better way, please let me know!!
Thank you for posting in our forum.
If you initially know the path to the column and row names which you want to expand you could loop through the rows and columns and expand them using the expandTupleMember method:
http://help.infragistics.com/jQuery/2015.2/ui.igPivotGrid#methods:expandTupleMember
I’ve attached a sample in which on button click the following paths are used:
var pathToColumn = "All Sellers/Elisa Longbottom";
var pathToRow = "All Periods/2013/Q1";
The related columns/rows are expanded and the cell is highlighted in yellow.
Let me know if you’re aiming to achieve something similar.