Issue 86758 - Improve categorisation of Calc functions
Summary: Improve categorisation of Calc functions
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-03-06 06:18 UTC by drking
Modified: 2013-12-25 14:53 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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.