To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115360 Issue #|115360 Summary|New function for Calc / Indenting and summing up lines Component|Spreadsheet Version|1.0.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P1 Subcomponent|editing Assigned to|spreadsheet Reported by|guirec
------- Additional comments from gui...@openoffice.org Tue Nov 2 15:37:51 +0000 2010 ------- Dear developpers, Based on some working experience with planning software I have an idea of a completely new function for spreadsheets that does not exist until now. I like the idea because it is usefull in spreadsheet applications and has no equivalent in MS. This new function would allow to easily create sub-total lines in the spreadsheet by simply opening an empty line and defining that it is a summary or subtotal line that takes into account the lines of lower levels - indented lines .- The summary line would have an independent, manually-defined, wording and would automatically sum up the figures contained in the inferior levels. We would be able to create several sub-levels and to collapse some selected lines to hide a part of the lower level's information, showing only the summaries. Some approaching solution does exist currently with the "sub-totals" but it not as powerfull mainly because you have to define the subtotals manually. All this is inspired by the possibilities offered by planing softwares. I had prepared an example to show the idea with a small "arrow" that allows showing or hiding lines. I currently use AEC's Fastrack Schedule for profesional reasons but equivalent program exist such as MS Project and the OpenProject - I do not know whether this is feasible but I would of course be most interested to further discuss this and to participate to the definition of the specification of such a function if possible. Unfortunately I am really not a developper but I would be really pleased to participate to a part of the Ooo project with my possibilities, like this special function specification or translations. Currently I am contributing, making sure that as many people as possible know about the project and accept to convert to Ooo in their work. I am sure that there are many ideas like this and would appreciate to know at least that my proposal is received and considered. Thanks for your consideration. Guirec --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org