Using PalOOCa you can create new queries to Palo and show the result data in OpenOffice.org Calc. Beyond that you can modify the data strucure of Palo. For example you could create a new cube via PalOOCa and add dimensions and elements.
You can work with the result data like with every other data in Calc. This means that you can format the data or add i.e. charts.
PalOOCa comes with translations in English and German. The selected language depends on the language of OpenOffice.org.