Re: OOo Pivoting Code Extraction

On 16.02.2011 13:52, Nuno Oliveira wrote:
> My name is Nuno Oliveira, and me and my colleagues, we are enrolled in a
> project
> at University of Minho (Portugal), which consists in finding all the code
> related to the
> pivot tables (data pilot) operations in the calc tool. Then we want to
> extract and isolate
> that code to put it into a stand-alone 'tool' so we are able to test the
> performance of that
> code in several environmental contexts.

That sounds very interesting.

> The questions I make are the following:
> -- do you ever searched for that code or made similar searches?
> -- do you have any method to easily find that or other code (including tools
> for slicing or program comprehension in general)?
> -- can you give me some pointers, based on your experience, about where to
> search for documentation on the pivot code class?

The implementation is mostly in sc/source/core/data, in the files that 
start with "dp".

A few starting points:
- The classes in dptabsrc.cxx are the implementation of the 
DataPilotSource UNO service for table data. The actual calculation of 
the results is in dptabres.cxx.
- ScSheetDPData (dpshttab.cxx) feeds sheet data into the calculation, 
ScDatabaseDPData (dpsdbtab.cxx) uses a database connection.
- ScDPObject (dpobject.cxx) is the object that's stored in a spreadsheet 
document. It uses ScDPOutput (dpoutput.cxx) to take the results from the 
DataPilotSource service and output them into spreadsheet cells.

Niklas