To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=95754
------- Additional comments from [EMAIL PROTECTED] Tue Nov 4 07:04:56 +0000
2008 -------
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
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
