Revision as of 14:35, 25 April 2008

Review of the OpenOffice.org Spreadsheet project (April/May 2008)

Review schedule

• start of review: April 28th
• review of collected issues: May 5th, 3pm UTC, #ooocalc on freenode
• start of sorting priorities and assignments May 5th
• review of final list: May 12th, 3pm UTC, #ooocalc on freenode

Status of the project

what are the most severe issues in the current release

High voted issues April 2008:

1. Issue no.: 8302: (111 Votes) Want to be able to insert into the middle of merged cells
2. Issue no.: 5560: (75) Spreadsheet Sheet Labels (change Color and Font)
3. Issue no.: 5930: (71) Engineering Notation
4. Issue no.: 12666: (61) Autofilter works just on one sheet (only one auto-range per
5. Issue no.: 30215: (57) Further thoughts on row limits
6. Issue no.: 20857: (55) R1C1 notation for the spreadsheet
7. Issue no.: 21280: (50) Automatic Insert (shift down or shift right) of cells, colum
8. Issue no.: 2131: (47) Ability to merge cells already merged
9. Issue no.: 15773: (45) Currency symbol left justified, while amount right justified
10. Issue no.: 59745: (44) Cell notes do not move when cells are sorted in Calc
11. Issue no.: 35579: (42) Standard filter requires more options..
12. Issue no.: 6087: (40) ODF: Allow all characters in sheet names
13. Issue no.: 25855: (38) Copy multiple seperated rows
14. Issue no.: 22762: (33) Page preview for Selection
15. Issue no.: 33723: (31) Ability to turn off Number Recognition in Calc
16. Issue no.: 5658: (24) Spreadsheet thinks a number is a string (text)
17. Issue no.: 87970: (22) Hebrew Characters in Spreadsheet Names Became Misdisplayed
18. Issue no.: 38494: (21) Copy/Paste numbers from Writer to Calc: decimal separator in
19. Issue no.: 5759: (19) DataPilot: allow more than 8 data fields
20. Issue no.: 3687: (18) Make CSV import/export filter settings persistent (e.g. the

which are the most requested (or needed) features (in the press, user forums, issues, other feedback)

The following ux-ctest issues have been recorded during usability sessions.

1. Issue no.: 60408: Sum Icon in Calc not Found: Specification
2. Issue no.: 60403: Edit menu: Expected menu command to duplicate sheets
3. Issue no.: 60402: German terminology in context menu for sheet controls could be misunderstood
4. Issue no.: 60401: Calc does not support all users' strategies regarding sorting data
5. Issue no.: 60400: Spreadsheet handling wording table vs. spreadsheet
6. Issue no.: 60399: Delete Columns/Rows in the context menu is missing if the cursor is not positioned on Column/Row Header

The following issues have been recorded during expert talks with customers.

1. Issue no.: 969: Auto-Correct on leaving cells does not work
2. Issue no.: ??????: Add Color Picker and Link to Color Dialog to Color Float
3. Issue no.: 66484: Missing Range Chooser Issue
4. Issue no.: 5432: F4 should repeat last command
5. Issue no.: 10864: Color chooser do not show latest color
6. Issue no.: ??????: [1]: Print Output Scaling Factor

short term planning

which defect needs to go into the next release

which features will be worked on for the half year

which issues needs an assignment

mid/long term planning

which features/bugfixes needs to be addressed in the next two/three years

unassigned feature/bugfixes