Active Cell in OWC Pivot using Windows Forms

[Dinesh]

Hi,
I am trying to get the Active Cell(equivalent of PivotTable1.Selection(0))
in windows forms C#. Can some one tell me how to do this. When I use
axPivotTable1.Selection it is returning me a Com Object. I want to know to
which object should I cast this to. I tried to cast this to PivotCell but it
did not work.
I am using OWC 11.

Thanks,
Dinesh

 

[Alvin Bruney [MVP]]

I believe there is an activecell property that you can use or something
similar in name.

 

[Dorota Papiernik]

Try this:
object obj;
AxOWC10.AxPivotTable PivotTable;
OWC10.PivotAggregates pivAggrs;

obj = PivotTable.Selection;

if((obj as OWC10.PivotAggregates) != null)
{
pivAggrs = obj as OWC10.PivotAggregates;
pivAggr = pivAggrs[0];
.....
}