Could you please elaborate what you would expect from such functionality how it
should work in spreadsheet context?

Hello,

Motivation:
In my activities I found this necessity to have more flexibility regarding the
structure of data & calculus.
This tree will permit to easy rearrange data and easy merge other data structure.

Functionality expected:
- Each file in the tree can be any Calc Object (range of cells even sheet;
charts and so on);
- Tree specific methods (view modes, view tree structure exploding sub folders
..., referencing/select/copy/paste/create/erase/import folder, editing cell
specific data or formula and so on directly in file (in tree));
- Extend group of Statistical formulas also for tree structure (example: countif
counting the number of sub folders named ".." or number of cells/rages inside
files from sub folders and so on) a would like to name this ("Collectors")
- Additional implementation of conditional formatting
- Recode formula auditing for entirely tree to avoid circular references;
- Intuitive assistant for referencing folders or files in formula (like:
/MyProject/Faze1/Activity1/Consumables.... or possibility pointing on tree
structure);
- Include in the list of insertable objects neighbor the sheet, chart and so on;

Advantages (example):
- Let's say that I would like to have the sum of cost in Faze1 than I write in
formula this:
=SUM(/MyProject/Faze1) .....easy:) may be will be necessary implement more
complex (SUMIF correlated with name of file which colects data below it) when I
would like have this statistical on each level in tree but not alter the value
of statistical above (in tree)
- My Project structure is part of the Company Management tree calculus and then,
MyProject will be imported or more rafinated linked in the branch of my
department in Company Management and so on.....

If additional information will be necessary do not hesitate to contact me,

With hope that this ~4 years old idea will become real in a day for all benefit
......
Marius Darie

Is first time participating on mailing lists.

--- On Wed, 5/11/08, Eike Rathke <erack@sun.com> wrote:

    From: Eike Rathke <erack@sun.com>
    Subject: Re: [dev] Fw: Re: proposal for contribution to Calc ("Calc for tree
calculus too")
    To: "Marius Darie" <marius_darie@yahoo.co.uk>
    Date: Wednesday, 5 November, 2008, 12:39 PM

    Hi Marius,

    Please don't continue public threads as personal mail. One reason for
    this is that a news group or mailing list offers the possibility for
    other people than me to answer questions. Another reason is that this
    way other people interested may participate in the discussion.

    So please accept my apologies for not answering personal mails sent to
    me, even if the answer could be very simple. Instead I would like to ask
    you to continue the thread on dev@openoffice.org

    Regards
    Eike

    On Wednesday, 2008-11-05 09:34:23 +0000, Marius Darie wrote:

    > Hello,
    > 
    > First of all excuse my English.
    > I think that Spreadsheet generally constrict to a matrix structure of data
    but adding additional functionality offered by tree, many calculus will be
    facile and intuitive.
    > The spreadsheet calculus is near by the tree calculus and because 
    spreadsheet calculus is very used, tree calculus will be very useful as a new
    functionality.
    > Of course no other spreadsheet calculus software support tree calculus.
    This is not a problem, others will step on our way. We can be different
    (originals).
    > 
    > 
    > Please, do not hesitate contact me for any questions regarding this,
    > 
    > Best regards,
    > Marius Darie
    > 
    > 
    > --- On Tue, 4/11/08, Eike Rathke <erl@sun.com> wrote:
    > From: Eike Rathke <erl@sun.com>
    > Subject: Re: [dev] Fw: Re: proposal for contribution to Calc ("Calc
    for tree calculus too")
    > To: dev@openoffice.org
    > Date: Tuesday, 4 November, 2008, 1:25 PM
    > 
    > Hi Marius,
    > 
    > On Saturday, 2008-11-01 22:02:06 +0000, Marius Darie wrote:
    > 
    > > > I do not know where subscribe this idea:
    > > > To use Calc facilities also for tree calculus, in which each
    label  
    > > > could be any Calc object.
    > 
    > You did in
    > http://qa.openoffice.org/issues/show_bug.cgi?id=95754  ;-)
    > 
    > However, it's not clear to me what a spreadsheet implementation should
    > actually do to support tree calculus, therefor I asked in the issue if
    > you could elaborate on that.
    > 
    > Thanks
    >   Eike
    > 
    > -- 
    >  OOo/SO Calc core developer. Number formatter stricken i18n
    transpositionizer.
    >  SunSign   0x87F8D412 : 2F58 5236 DB02 F335 8304  7D6C 65C9 F9B5 87F8 D412
    >  OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS
    >  Please don't send personal mail to the erl@sun.com account, which I
    use
    > for
    >  mailing lists only and don't read from outside Sun. Use erack@sun.com
    > Thanks.
    > 
    > 
    > 
    >       



    -- 
     SunSign   0x87F8D412 : 2F58 5236 DB02 F335 8304  7D6C 65C9 F9B5 87F8 D412
     OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS
     -- Necessary legal stuff according to German laws:
     Sun Microsystems GmbH
     Nagelsweg 55, D-20097 Hamburg
     Sitz der Gesellschaft: Sonnenallee 1, D-85551 Kirchheim-Heimstetten
     Amtsgericht München: HRB 161028
     Geschäftsführer: Thomas Schröder, Wolfgang Engels, Dr. Roland Bömer
     Vorsitzender des Aufsichtsrates: Martin Häring

What you are referring to are probably multidimensional spreadsheets. These are
for some 20 years around, and more and more companies use such custom solutions,
but it seems open source projects are not yet open to these ideas.

Another concept are hierarchical databases. These are indeed extensively used
e.g. in clinical trials, and it would fit well in your description of the
organization of a department:
HEAD
 |- DEPT 1
 |   |_ SUBDEPT 1: <actual sheet>
 |
 |- DEPT 2
 |   |- SUBDEPT 1: <actual sheet>
 |   |- SUBDEPT 2: <actual sheet>
 |   |- SUBDEPT 3: <actual sheet>
 |   |_ SUBDEPT 4: <actual sheet>
 |
 |_ DEPT 1
     |- SUBDEPT 1: <actual sheet>
     |- SUBDEPT 2: <actual sheet>
     |_ SUBDEPT 3: <actual sheet>

I think that this tree structure can be solved with a multidimensional spreadsheet.

Duplicate bug

*** This issue has been marked as a duplicate of issue 83219 ***