Issue 86758

Summary: Improve categorisation of Calc functions
Product: Calc Reporter: drking <openoffice>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 2.3.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Description drking 2008-03-06 06:18:07 UTC
I raise this for the User Experience team to review, as discussed with Eike and 
Uwe.

Functions are allocated to categories in the Help and in the Function Wizard. I 
am re-writing the Help in the Wiki:
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_l
isted_by_category

and it is clear that the current categories need revision. For 
example: 'Spreadsheet' does not describe the contents of that category; some 
functions appear in different categories in the existing Help and the Function 
Wizard.

There are two candidate models for categories:
Excel:
http://office.microsoft.com/en-us/excel/CH100645021033.aspx
ODFF (not yet stable):
http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula

I prefer ODFF - with the functions listed on one page in the Wiki it's easy to 
find what you want, whether or not you know the function name.

But this should be a formal decision. Would the User Experience team put this 
on their list of things to look at please ?

Thank you
Comment 1 oc 2008-07-15 10:43:19 UTC
reassigning features and enhancements to user requirements@openoffice.org which
will be the default owner for those tasks (was introduced some time ago)
Comment 2 Edwin Sharp 2013-12-25 14:53:28 UTC
Function categories should follow those of section 6 in OASIS document.