Difference between revisions of "Calc/To-Dos/Usability"
m (Calc Usability Activities moved to Calc/To-Dos/Usability: Bring more structure to the OOo site. Move ALL Calc issues to Calc wiki.) |
|||
Line 5: | Line 5: | ||
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=7180 7180]: Need ability to move columns/rows in spreadsheet: [http://specs.openoffice.org/calc/ease-of-use/Insertion_of_Cells.odt Specification]: Done OOo 2.4 | # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=7180 7180]: Need ability to move columns/rows in spreadsheet: [http://specs.openoffice.org/calc/ease-of-use/Insertion_of_Cells.odt Specification]: Done OOo 2.4 | ||
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=4040 4040]: Convert text to columns: [http://specs.openoffice.org/calc/ease-of-use/Text_to_Columns.odt Specification] | # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=4040 4040]: Convert text to columns: [http://specs.openoffice.org/calc/ease-of-use/Text_to_Columns.odt Specification] | ||
− | # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=27745 27745]: Basing autofiltering on the result set, not all rows | + | # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=27745 27745]: Basing autofiltering on the result set, not all rows: [http://specs.openoffice.org/calc/ease-of-use/AutoFilter_Behavior.odt Specification] |
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=20496 20496]: Enhanced formula input | # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=20496 20496]: Enhanced formula input | ||
− | # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=15546 15546]: Enter-Key behaves not as expected | + | # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=15546 15546]: Enter-Key behaves not as expected: [http://specs.openoffice.org/calc/ease-of-use/Enhanced_Data_Input.odt Specification] |
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=7269 7269]: Page Down Should Switch Pages if there is nothing to scroll: Done OOo 2.4 | # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=7269 7269]: Page Down Should Switch Pages if there is nothing to scroll: Done OOo 2.4 | ||
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=51656 51656]: Edit columns width and page margins: Done OOo 2.4 | # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=51656 51656]: Edit columns width and page margins: Done OOo 2.4 |
Revision as of 15:23, 2 August 2007
|
---|
Quick Navigation Team Communication Activities |
This page documents the usability activities for OOo. 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:
- Issue no.: 7180: Need ability to move columns/rows in spreadsheet: Specification: Done OOo 2.4
- Issue no.: 4040: Convert text to columns: Specification
- Issue no.: 27745: Basing autofiltering on the result set, not all rows: Specification
- Issue no.: 20496: Enhanced formula input
- Issue no.: 15546: Enter-Key behaves not as expected: Specification
- Issue no.: 7269: Page Down Should Switch Pages if there is nothing to scroll: Done OOo 2.4
- Issue no.: 51656: Edit columns width and page margins: Done OOo 2.4
UX To Do List for OOo 2.3
The following UX issues have been solved for OOo 2.3.
- Issue no.: 78661: Auto-capitalization in Calc cells is perceived as very annoying: Specification: Done OOo 2.3
- Issue no.: 25278: Print only selected spreadsheet: Done OOo 2.3
- Issue no.: 78488: New Error Message when print output is empty: Done: OOo 2.3
- Issue no.: 51564: Sum function does not automatically recognize target cell for result: Specification Done OOo 2.3
- Issue no.: 38108: Calc K/B shortcuts: Done OOo 2.3
UX Issue Sources
High Votes Issues in July 2007
The following issues are the top 17 high voted Calc issues in July 2007.
- Issue no.: 7180: Need ability to move columns/rows in spreadsheet: Specification: Done OOo 2.4
- Issue no.: 33851: Behavior with cut/copy/paste/fill cells and autofilter: Specification draft
- Issue no.: 8811: Allow multiple users to edit the same spreadsheet through workbook sharing
- Issue no.: 8275: More border types (dashed, dotted, etc)
- Issue no.: 4040: Convert text to columns
- Issue no.: 5560: Spreadsheet Sheet Labels (change Color and Font)
- Issue no.: 27745: Basing autofiltering on the result set, not all rows.
- Issue no.: 5930: Engineering Notation
- Issue no.: 15773: Currency symbol left justified, while amount right justified in a cell.
- Issue no.: 21280: Automatic Insert (shift down or shift right) of cells, columns, or rows when cut, or copied, and pasted
- Issue no.: 20857: R1C1 notation for the spreadsheet
- Issue no.: 12666: Autofilter works just on one sheet (only one auto-range per document)
- Issue no.: 20496: Enhanced formula input
- Issue no.: 59745: Cell notes do not move when cells are sorted in Calc
- Issue no.: 25855: Copy multiple seperated rows
- Issue no.: 4695: INDIRECT function fails with named cells
- Issue no.: 15546: Enter-Key behaves not as expected
UX-ctest Issues
The following ux-ctest issue have been recorded during usability sessions.
- Issue no.: 60408: Sum Icon in Calc not Found
- Issue no.: 60406: Column & Row Headers: No feedback on switching off
- Issue no.: 60403: Edit menu: Expected menu command to duplicate sheets
- Issue no.: 60402: German terminology in context menu for sheet controls could be misunderstood
- Issue no.: 60401: Calc does not support all users' strategies regarding sorting data
- Issue no.: 60400: Spreadsheet handling wording table vs. spreadsheet
- Issue no.: 60399: Delete Columns/Rows in the context menu is missing if the cursor is not positioned on Column/Row Header
- Issue no.: 51564: Sum function does not automatically recognize target cell for result: Specification Done OOo 2.3
Customer UX Issues
The following issue have been recorded during expert talks with customers.
- Issue no.: 78661: Auto-capitalization in Calc cells is perceived as very annoying: Specification: Done OOo 2.3
- Issue no.: 969: Auto-Correct on leaving cells does not work:
- Issue no.: 25278: Print only selected spreadsheet: Done OOo 2.3
- Issue no.: 78488: New Error Message when print output is empty: Done: OOo 2.3 Done
- Issue no.: 7269: Page Down Should Switch Pages if there is nothing to scroll: Done OOo 2.4
- Issue no.: 51656: Edit columns width and page margins: Done OOo 2.3
- Issue no.: ??????: Add Color Picker and Link to Color Dialog to Color Float
- Issue no.: 66484 Missing Range Chooser Issue
- Issue no.: 5432 F4 should repeat last command
- Issue no.: 10864: Color chooser do not show latest color
Further UX Issues
Issue List from the French Community
The French community has also build an issue list for Calc. This list will also be taken into account when determining which issues have to be fixed in future versions.
Issues Proposed by flaime
- Issue no.: 2131: Ability to merge cells already merged
- Issue no.: 8302: Want to be able to insert into the middle of merged cells
Issues Proposed by Discoleo
Data Typing
1. Strong Data Typing See issue 79924. Every decent programming language implements a data typing mechanism in order to reduce the error rate during programming. However, spreadsheets have failed to introduce any typing, although a significant number of errors could be prevented IF such a mechanism was built in place.
2. CURRENCY Calc should implement a strong typing system. In a first phase, I advocate implementing a separate data-type for currency and a typing system handling currency operations (a generic currency type first), later expanding it to further units (more currency subtypes and probably 'time-units' being next, followed by other units). For full details, see issue 79924.
- ADVANTAGES
- This would allow catching errors of type <currency> + <scalar> or <currency> * <currency> early up, thereby mitigating potential disastrous financial outcomes and lots of hours of spreadsheet debugging.
Discoleo 20:29, 23 July 2007 (CEST)
Duplicate Data
3. DUPLICATE DATA Duplicate spreadsheets and data introduce a lot of errors and correcting every occurrence of the errors is a daunting task. Various features allow reducing duplicate data entries. These are more fully discussed in issue 80139.
- This is an extension of
- issue 8811: collaborative editing of spreadsheets
- issue 66817: Paste as HARD-LINKS (Unix style hard links)
- issue 34213: Paste as (simple) reference (though hard-links are more powerful)
- further features regarding tracking changes and versioning the document (not filed yet)
Discoleo 20:41, 28 July 2007 (CEST)
Send feedback to: Frank Loehmann