Calc/To-Dos/Usability

This page documents the usability activities for OOo 2.4. The page has been created in July 2007.

UX To Do List for OOo 2.4

The following issues have been selected from the top-17 and the ux-ctest list below.
1. Issue no.: 7180: Need ability to move columns/rows in spreadsheet: Specification
2. Issue no.: 4040: Convert text to columns
3. Issue no.: 27745: Rasing autofiltering on the result set, not all rows.
4. Issue no.: 20496: Enhanced formula input
5. Issue no.: 15546: Enter-Key behaves not as expected

High Votes Issues in July 2007

The following issues are the top 17 high voted Calc issues in July 2007.
1. Issue: 7180: Need ability to move columns/rows in spreadsheet
2. Issue: 33851: Behavior with cut/copy/paste/fill cells and autofilter
3. Issue: 8811: Behavior with cut/copy/paste/fill cells and autofilter
4. Issue: 8275: Allow multiple users to edit the same spreadsheet through workbook sharing
5. Issue: 4040: Convert text to columns
6. Issue: 5560: Spreadsheet Sheet Labels (change Color and Font)
7. Issue: 27745: Rasing autofiltering on the result set, not all rows.
8. Issue: 5930: Engineering Notation
9. Issue: 15773: Currency symbol left justified, while amount right justified in a cell.
10. Issue: 21280: Automatic Insert (shift down or shift right) of cells, columns, or rows when cut, or copied, and pasted
11. Issue: 20857: R1C1 notation for the spreadsheet
12. Issue: 12666: Autofilter works just on one sheet (only one auto-range per document)
13. Issue: 20496: Enhanced formula input
14. Issue: 59745: Cell notes do not move when cells are sorted in Calc
15. Issue: 25855: Copy multiple seperated rows
16. Issue: 4695: INDIRECT function fails with named cells
17. Issue: 15546: Enter-Key behaves not as expected

UX-ctest Issues

The following ux-ctest issue have been recorded during usability sessions.
1. Issue 60408: Sum Icon in Calc not Found
2. Issue 60406: Column & Row Headers: No feedback on switching off
3. Issue 60403: Edit menu: Expected menu command to duplicate sheets
4. Issue 60402: German terminology in context menu for sheet controls could be misunderstood
5. Issue 60401: Calc does not support all users' strategies regarding sorting data
6. Issue 60400: Spreadsheet handling wording table vs. spreadsheet
7. Issue 60399: Delete Columns/Rows in the context menu is missing if the cursor is not positioned on Column/Row Header
8. Issue 60397: Calc does not support all users' strategies regarding AutoSum
9. Issue 51564: Sum function does not automatically recognize target cell for result

Other UX Issues

The following ux-ctest issue have been recorded during expert talks with customers.