Re: OOo Pivoting Code Extraction

Please unsubscribe me from this letter.  I am receiving it for over 1 year now and I am not interested at all.  I'm not a programmer

 

Thank you

 

Monique Lamarre

[email protected]
 


From: [email protected]
Date: Mon, 28 Feb 2011 22:23:13 +0000
To: [email protected]
CC: [email protected]
Subject: [dev] Re: OOo Pivoting Code Extraction

Dear Niklas, 


As I'm taking this project again, I bumped into some questions that you may answer me immediately, I'm sure!


Well I'm trying to discover which and where is the function that performs the pivoting calculation.
By the hints you gave me before I'm searching for this function on dptabres.cxx, and there I found a Calculate function, but it makes me believe that it is not the function I'm searching for... 
Also I am searching for the input for this calculation, and that function takes some arguments that I can't assume as a structure holding all the data to perform such computation.


Can you give me some more hints about the form that the input takes for the calculation?
And which is the main function where the pivoting calculation starts?


Thank you very much!  


On Wed, Feb 16, 2011 at 1:17 PM, Niklas Nebel <[email protected]> wrote:


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

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



-- 
Nuno Oliveira
 		 	   		  --
------------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected] with Subject: help