// create the test objects
log.println ("Getting test objects");
XDataPilotTablesSupplier DPTS = (XDataPilotTablesSupplier) UnoRuntime.queryInterface (
XDataPilotTablesSupplier.class,
oSheet);
XDataPilotTables DPT = DPTS.getDataPilotTables ();
XDataPilotDescriptor DPDsc = DPT.createDataPilotDescriptor ();
DPDsc.setSourceRange (sCellRangeAdress);
XPropertySet fieldPropSet = null;
try
{
Object oDataPilotField = DPDsc.getDataPilotFields ().getByIndex (0);
fieldPropSet = (XPropertySet) UnoRuntime.queryInterface (
XPropertySet.class, oDataPilotField);
fieldPropSet.setPropertyValue ("Orientation",
com.sun.star.sheet.DataPilotFieldOrientation.ROW);
oDataPilotField = DPDsc.getDataPilotFields ().getByIndex (1);
fieldPropSet = (XPropertySet) UnoRuntime.queryInterface (
XPropertySet.class, oDataPilotField);
fieldPropSet.setPropertyValue ("Function",
com.sun.star.sheet.GeneralFunction.SUM);
fieldPropSet.setPropertyValue ("Orientation",
com.sun.star.sheet.DataPilotFieldOrientation.DATA);
oDataPilotField = DPDsc.getDataPilotFields ().getByIndex (2);
fieldPropSet = (XPropertySet) UnoRuntime.queryInterface (
XPropertySet.class, oDataPilotField);
fieldPropSet.setPropertyValue ("Orientation",
com.sun.star.sheet.DataPilotFieldOrientation.COLUMN);
}
catch (com.sun.star.lang.WrappedTargetException e)
{
e.printStackTrace ();
throw new StatusException ("Couldn't create a test environment", e);
}
catch (com.sun.star.lang.IllegalArgumentException e)
{
e.printStackTrace ();
throw new StatusException ("Couldn't create a test environment", e);
}
catch (com.sun.star.beans.PropertyVetoException e)
{
e.printStackTrace ();
throw new StatusException ("Couldn't create a test environment", e);
}
catch (com.sun.star.beans.UnknownPropertyException e)
{
e.printStackTrace ();
throw new StatusException ("Couldn't create a test environment", e);
}
catch (com.sun.star.lang.IndexOutOfBoundsException e)
{
e.printStackTrace ();
throw new StatusException ("Couldn't create a test environment", e);
}
log.println ("Insert the DataPilotTable");
if (DPT.hasByName ("DataPilotTable"))
{
DPT.removeByName ("DataPilotTable");
}
DPT.insertNewByName ("DataPilotTable", sCellAdress, DPDsc);
XIndexAccess xIA = (XIndexAccess) UnoRuntime.queryInterface (XIndexAccess.class,DPTS.getDataPilotTables ());
XIndexAccess IA = null;
try
{
XDataPilotDescriptor xDPT = (XDataPilotDescriptor) UnoRuntime.queryInterface (XDataPilotDescriptor.class,xIA.getByIndex (0));
IA = xDPT.getRowFields ();
//getSRange(IA);
System.out.println ("COUNT: "+IA.getCount ());
datapilotfield = (XInterface) AnyConverter.toObject (
new Type (XInterface.class), IA.getByIndex (0));
}
catch (com.sun.star.lang.WrappedTargetException e)
{
e.printStackTrace ();
throw new StatusException ("Couldn't get data pilot field", e);
}
catch (com.sun.star.lang.IndexOutOfBoundsException e)
{
e.printStackTrace ();
throw new StatusException ("Couldn't get data pilot field", e);
}
catch (com.sun.star.lang.IllegalArgumentException e)
{
e.printStackTrace ();
throw new StatusException ("Couldn't get data pilot field", e);
}
try
{
XDataPilotFieldGrouping dpfg = (XDataPilotFieldGrouping) UnoRuntime.queryInterface (XDataPilotFieldGrouping.class, datapilotfield);
String[] elements = new String[]{"aName","otherName"};
dpfg.createNameGroup (elements);
DataPilotFieldGroupInfo dpgi=null;
xIA = (XIndexAccess) UnoRuntime.queryInterface (XIndexAccess.class,DPTS.getDataPilotTables ());
try
{
XDataPilotDescriptor xDPT = (XDataPilotDescriptor) UnoRuntime.queryInterface (XDataPilotDescriptor.class,xIA.getByIndex (0));
IA = xDPT.getRowFields ();
}