Difference between revisions of "Calc/To-Dos/Usability"

From Apache OpenOffice Wiki
< Calc‎ | To-Dos
Jump to: navigation, search
(UX To Do List for OOo 3.x)
 
(47 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
{{User Experience}}
 
{{User Experience}}
This page documents the usability activities for OOo. The page has been created in July 2007 and will be updated on a regular basis.  
+
This page documents the usability activities for OOo. The page has been created in July 2007 and will be updated on a regularly basis.  
 +
== UX To Do List for OOo 3.x==
 +
# Issue no.: [https://issues.apache.org/ooo/show_bug.cgi?id=120071 120071]: Better Number Format management
 +
# Issue no.: [https://issues.apache.org/ooo/show_bug.cgi?id=120024 120024]: Form Controls & Form Design -- why not join them?
 +
# Issue no.: [https://issues.apache.org/ooo/show_bug.cgi?id=119668 119668]: Tab rows for better organizing sheets
 +
# Issue no.: [https://issues.apache.org/ooo/show_bug.cgi?id=119669 119669]: UI more like Google Docs
 +
# Issue no.: [https://issues.apache.org/ooo/show_bug.cgi?id=119670 119670]: Form fonts should be the same as default font
 +
# Issue no.: [https://issues.apache.org/ooo/show_bug.cgi?id=119671 119671]: Easier to lay out form elements
 +
# Issue no.: [https://issues.apache.org/ooo/show_bug.cgi?id=119672 119672]: New comments indicator
 +
# Issue no.: [https://issues.apache.org/ooo/show_bug.cgi?id=119673 119673]: "Snap to grid" that snaps to the actual cell grid
 +
# Issue no.: [https://issues.apache.org/ooo/show_bug.cgi?id=119674 119674]: Configurable default column width
 +
# Issue no.: [https://issues.apache.org/ooo/show_bug.cgi?id=119675 119675]: Fixing the text inside Comments
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=20857 20857]: (55) R1C1 notation for the spreadsheet
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5759 5759]: (57) DataPilot: allow more than 8 data fields
  
== UX To Do List for OOo 3.0==
+
== UX To Do List for OOo 3.3==
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60406 60406]: Column & Row Headers: No feedback on switching off
+
# Issue no.: [http://qa.openoffice.org/issues/show_bug.cgi?id=3687 3687]: Make CSV import/export filter settings persistent [patch]: Done
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5560 5560]: (75) Spreadsheet Sheet Labels (change Color and Font): Done
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=30215 30215]: (57) Further thoughts on row limits: Done
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=35579 35579]: (42) Standard filter requires more options: Done
  
 +
== UX To Do List for OOo 3.2==
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=8302 8302]: (111 Votes) Want to be able to insert into the middle of merged cells: Done
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60401 60401]: Calc does not support all users' strategies regarding sorting data: Done
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=25855 25855]: (38) Copy multiple separated rows: Done
 +
 +
== UX To Do List for OOo 3.1==
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=59745 59745]: (44) Cell notes do not move when cells are sorted in Calc : Done
 +
 +
== UX To Do List for OOo 3.0==
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60406 60406]: Column & Row Headers: No feedback on switching off: Done
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=33851 33851]: Behavior with cut/copy/paste/fill cells and autofilter: [[Calc/Drafts/Issue_33851|Specification draft]]: Done
 +
# Issue no.: [http://qa.openoffice.org/issues/show_bug.cgi?id=8811 8811]: Allow multiple users to edit the same spreadsheet [http://specs.openoffice.org/calc/features/Collaboration.odt Specification]: Done
  
 
== UX To Do List for OOo 2.4==
 
== UX To Do List for OOo 2.4==
Line 17: Line 45:
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=82071 82071]: Flaws in print logic: [http://specs.openoffice.org/appwide/printing/Print_Dialog.odt Specification]: Done OOo 2.4
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=82071 82071]: Flaws in print logic: [http://specs.openoffice.org/appwide/printing/Print_Dialog.odt Specification]: Done OOo 2.4
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=24372 24372]: Individual per Tab Percent View: [http://specs.openoffice.org/calc/dialogs/Options_Dialog.odt Specification]: Done OOo 2.4
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=24372 24372]: Individual per Tab Percent View: [http://specs.openoffice.org/calc/dialogs/Options_Dialog.odt Specification]: Done OOo 2.4
 +
# Issue no.: [http://qa.openoffice.org/issues/show_bug.cgi?id=59697 59697]: Need selection of 'current sheet' for printing:</strike>: OOo 2.4 Done
 +
# Issue no.: [http://qa.openoffice.org/issues/show_bug.cgi?id=75766 75766]: View Properties per Sheet in Calc: OOo 2.4 Done
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=4695 4695]: INDIRECT function fails with named cells
  
 
== UX To Do List for OOo 2.3==
 
== UX To Do List for OOo 2.3==
Line 27: Line 58:
  
 
== UX Issue Sources ==
 
== UX Issue Sources ==
 +
=== High Votes Issues in December 2010 ===
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=93613 93613]:NEW (310 Votes) Solver does not save its model
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=103580 103580]:NEW (202 Votes) Add Sensitivity Analysis to Linear Solver
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5930 5930]:NEW (143) Engineering Notation
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=89232 89232]:NEW (111) Fill operations should not touch filtered rows.
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=33723 33723]:NEW (99) NF-DATE: Ability to turn off Number Recognition for incomple
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=15773 15773]:NEW (98) Currency symbol left justified, while amount right justified
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=12666 12666]:NEW (96) autofilter works just on one sheet (only one auto-range per
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=20857 20857]:STARTE (96) R1C1 notation for the spreadsheet
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=21280 21280]:NEW (75) When cut/copy rows/columns & paste-special, shift down/right
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=2131 2131]:NEW (69) RFE: ability to merge cells already merged
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5759 5759]:NEW (57) DataPilot: allow more than 8 data fields
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5736 5736]:NEW (54) Create chart as a sheet (chart only sheet, chartsheet)
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=22762 22762]:NEW (52) Page preview for Selection
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=10864 10864]:NEW (50) Border/Backgroundcolor button on toolbar is not 'sticky'
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=87999 87999]:NEW (36) In "standard" data type csv import should never convert item
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=106958 106958]:NEW (35) Build GRG Method into solver
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=18748 18748]:NEW (33) At autocompletion TAB-key-use no longer leads to cell travel
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=19440 19440]:STARTE (30) Increase number of sheets and columns
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=53182 53182]:NEW (30) Select visible cells only button
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=7357 7357]:NEW (30) Paste into nonadjacent random cells
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=26009 26009]:NEW (29) Calc sheets should *all* be formatted RTL by default in Hebr
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=8812 8812]:NEW (28) Conditional formating
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=44828 44828]:NEW (27) tools-detective-trace for cross-sheet formulae
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=23839 23839]:NEW (27) Underlines in user defined number format, accounting underli
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=64604 64604]:NEW (24) Allow Calc DataProvider to handle named ranges (new chart)
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=32785 32785]:STARTE (23) Excel Export BIFF5: missing character encoding
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5460 5460]:NEW (23) Corel Quattro Pro import filter/file open
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=7722 7722]:STARTE (23) Cells Columns that are larger than screen jump when scrollin
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=64851 64851]:STARTE (23) sum precision differs for inline and cell arguments
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=38494 38494]:STARTE (22) Copy/Paste numbers from Writer to Calc: decimal separator in
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=69830 69830]:NEW (22) Opening .tsv files in calc
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=10865 10865]:NEW (21) Moving/Copying -Single- Cell using click-n-drag
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=72191 72191]:STARTE (21) Support variable formula conventions
 +
 +
=== High Votes Issues in April 2008 ===
 +
The following issues are the top 20 high voted Calc issues in April 2008.
 +
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=8302 8302]: (111 Votes) Want to be able to insert into the middle of merged cells </strike>
 +
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5560 5560]: (75) Spreadsheet Sheet Labels (change Color and Font)</strike>
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5930 5930]: (71) Engineering Notation
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=12666 12666]: (61) Autofilter works just on one sheet (only one auto-range per
 +
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=30215 30215]: (57) Further thoughts on row limits </strike>
 +
# Issue no.: <strike>[http://www.openoffice.org/issues/show_bug.cgi?id=20857 20857]: (55) R1C1 notation for the spreadsheet </strike>
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=21280 21280]: (50) Automatic Insert (shift down or shift right) of cells, colum
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=2131 2131]: (47) Ability to merge cells already merged
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=15773 15773]: (45) Currency symbol left justified, while amount right justified
 +
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=59745 59745]: (44) Cell notes do not move when cells are sorted in Calc </strike>
 +
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=35579 35579]: (42) Standard filter requires more options.</strike>
 +
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=6087 6087]: (40) ODF: Allow all characters in sheet names: </strike> Done OOo 3.0
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=25855 25855]: (38) Copy multiple separated rows
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=22762 22762]: (33) Page preview for Selection
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=33723 33723]: (31) Ability to turn off Number Recognition in Calc
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5658 5658]: (24) Spreadsheet thinks a number is a string (text)
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=87970 87970]: (22) Hebrew Characters in Spreadsheet Names Became Misdisplayed
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=38494 38494]: (21) Copy/Paste numbers from Writer to Calc: decimal separator in
 +
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5759 5759]: (19) DataPilot: allow more than 8 data fields
 +
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=3687 3687]: (18) Make CSV import/export filter settings persistent (e.g. the </strike>
 +
 
=== High Votes Issues in July 2007 ===
 
=== High Votes Issues in July 2007 ===
 
The following issues are the top 17 high voted Calc issues in July 2007.
 
The following issues are the top 17 high voted Calc issues in July 2007.
 
# Issue <strike>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]:</strike> Done OOo 2.4
 
# Issue <strike>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]:</strike> Done OOo 2.4
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=33851 33851]: Behavior with cut/copy/paste/fill cells and autofilter: [[Calc/Drafts/Issue_33851|Specification draft]]
+
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=33851 33851]: Behavior with cut/copy/paste/fill cells and autofilter: </strike> [[Calc/Drafts/Issue_33851|Specification draft]]: Done OOo 3.0
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=8811 8811]: Allow multiple users to edit the same spreadsheet through workbook sharing
+
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=8811 8811]: Allow multiple users to edit the same spreadsheet through workbook sharing</strike>: Done OOo 3.0
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=8275 8275]: More border types (dashed, dotted, etc)
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=8275 8275]: More border types (dashed, dotted, etc)
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=4040 4040]: Convert text to columns:</strike> Done
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=4040 4040]: Convert text to columns:</strike> Done
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5560 5560]: Spreadsheet Sheet Labels (change Color and Font)
+
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5560 5560]: Spreadsheet Sheet Labels (change Color and Font)</strike>
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=27745 27745]: Basing autofiltering on the result set, not all rows.:</strike> Done
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=27745 27745]: Basing autofiltering on the result set, not all rows.:</strike> Done
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5930 5930]: Engineering Notation
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5930 5930]: Engineering Notation
Line 42: Line 131:
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=12666 12666]: Autofilter works just on one sheet (only one auto-range per document)
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=12666 12666]: Autofilter works just on one sheet (only one auto-range per document)
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=20496 20496]: Enhanced formula input:</strike> Done
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=20496 20496]: Enhanced formula input:</strike> Done
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=59745 59745]: Cell notes do not move when cells are sorted in Calc
+
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=59745 59745]: Cell notes do not move when cells are sorted in Calc</strike>
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=25855 25855]: Copy multiple seperated rows
+
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=25855 25855]: Copy multiple separated rows: </strike>Done
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=4695 4695]: INDIRECT function fails with named cells
+
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=4695 4695]: INDIRECT function fails with named cells </strike>
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=15546 15546]: Enter-Key behaves not as expected:</strike> Done
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=15546 15546]: Enter-Key behaves not as expected:</strike> Done
  
Line 50: Line 139:
 
The following ux-ctest issue have been recorded during usability sessions.
 
The following ux-ctest issue have been recorded during usability sessions.
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60408 60408]: Sum Icon in Calc not Found: [http://specs.openoffice.org/calc/ease-of-use/sum_button_enhancements.odt Specification]
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60408 60408]: Sum Icon in Calc not Found: [http://specs.openoffice.org/calc/ease-of-use/sum_button_enhancements.odt Specification]
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60406 60406]: Column & Row Headers: No feedback on switching off
+
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60406 60406]: Column & Row Headers: No feedback on switching off</strike>: Done OOo 3.0
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60403 60403]: Edit menu: Expected menu command to duplicate sheets
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60403 60403]: Edit menu: Expected menu command to duplicate sheets
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60402 60402]: German terminology in context menu for sheet controls could be misunderstood
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60402 60402]: German terminology in context menu for sheet controls could be misunderstood
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60401 60401]: Calc does not support all users' strategies regarding sorting data
+
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60401 60401]: Calc does not support all users' strategies regarding sorting data </strike>
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60400 60400]: Spreadsheet handling wording table vs. spreadsheet
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60400 60400]: Spreadsheet handling wording table vs. spreadsheet
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60399 60399]: Delete Columns/Rows in the context menu is missing if the cursor is not positioned on Column/Row Header
+
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60399 60399]: Delete Columns/Rows in the context menu is missing if the cursor is not positioned on Column/Row Header</strike>
 
# Issue<strike> no.: [http://www.openoffice.org/issues/show_bug.cgi?id=51564 51564]: Sum function does not automatically recognize target cell for result: [http://specs.openoffice.org/calc/ease-of-use/autosum.odt Specification]:</strike> Done OOo 2.3
 
# Issue<strike> no.: [http://www.openoffice.org/issues/show_bug.cgi?id=51564 51564]: Sum function does not automatically recognize target cell for result: [http://specs.openoffice.org/calc/ease-of-use/autosum.odt Specification]:</strike> Done OOo 2.3
  
Line 64: Line 153:
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=25278 25278]: Print only selected spreadsheet:</strike> Done OOo 2.3
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=25278 25278]: Print only selected spreadsheet:</strike> Done OOo 2.3
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=78488 78488]: New Error Message when print output is empty:</strike> OOo 2.3 Done
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=78488 78488]: New Error Message when print output is empty:</strike> OOo 2.3 Done
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=7269 7269]: Page Down Should Switch Pages if there is nothing to scroll:</strike> Done OOo 2.4
+
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=7269 7269]: Page Down Should Switch Pages if there is nothing to scroll:</strike> Done OOo 2.4  
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=51656 51656]: Edit columns width and page margins:</strike> Done OOo 2.3
 
# Issue <strike>no.: [http://www.openoffice.org/issues/show_bug.cgi?id=51656 51656]: Edit columns width and page margins:</strike> Done OOo 2.3
 
# Issue no.: ??????: Add Color Picker and Link to Color Dialog to Color Float
 
# Issue no.: ??????: Add Color Picker and Link to Color Dialog to Color Float
Line 70: Line 159:
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5432 5432] F4 should repeat last command
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5432 5432] F4 should repeat last command
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=10864 10864]: Color chooser do not show latest color
 
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=10864 10864]: Color chooser do not show latest color
# Issue no.: [http://qa.openoffice.org/issues/show_bug.cgi?id=59697 59697]: Need selection of 'current sheet' for printing
+
# Issue <strike>no.: [http://qa.openoffice.org/issues/show_bug.cgi?id=59697 59697]: Need selection of 'current sheet' for printing:</strike> Done OOo 2.4
# Issue no.: [http://qa.openoffice.org/issues/show_bug.cgi?id=75766 75766]: View Properties per Sheet in Calc
+
# Issue <strike>no.: [http://qa.openoffice.org/issues/show_bug.cgi?id=75766 75766]: View Properties per Sheet in Calc</strike> Done OOo 2.4
# Issue no.: [http://qa.openoffice.org/issues/show_bug.cgi?id=3687 3687]: Make CSV import/export filter settings persistent [patch]
+
# Issue <strike>no.: [http://qa.openoffice.org/issues/show_bug.cgi?id=3687 3687]: Make CSV import/export filter settings persistent </strike>[patch]: Done OOo 2.4
  
  
Line 120: Line 209:
 
[[Category:User_Experience]]
 
[[Category:User_Experience]]
 
[[Category:Calc|Usability Activities]]
 
[[Category:Calc|Usability Activities]]
 +
[[Category:Outdated]]

Latest revision as of 12:05, 24 June 2012

ux-ooo-logo-rgb-129-61.png

ux.openoffice.org

Quick Navigation

Team

Communication

Activities


This page documents the usability activities for OOo. The page has been created in July 2007 and will be updated on a regularly basis.

UX To Do List for OOo 3.x

  1. Issue no.: 120071: Better Number Format management
  2. Issue no.: 120024: Form Controls & Form Design -- why not join them?
  3. Issue no.: 119668: Tab rows for better organizing sheets
  4. Issue no.: 119669: UI more like Google Docs
  5. Issue no.: 119670: Form fonts should be the same as default font
  6. Issue no.: 119671: Easier to lay out form elements
  7. Issue no.: 119672: New comments indicator
  8. Issue no.: 119673: "Snap to grid" that snaps to the actual cell grid
  9. Issue no.: 119674: Configurable default column width
  10. Issue no.: 119675: Fixing the text inside Comments
  11. Issue no.: 20857: (55) R1C1 notation for the spreadsheet
  12. Issue no.: 5759: (57) DataPilot: allow more than 8 data fields

UX To Do List for OOo 3.3

  1. Issue no.: 3687: Make CSV import/export filter settings persistent [patch]: Done
  2. Issue no.: 5560: (75) Spreadsheet Sheet Labels (change Color and Font): Done
  3. Issue no.: 30215: (57) Further thoughts on row limits: Done
  4. Issue no.: 35579: (42) Standard filter requires more options: Done

UX To Do List for OOo 3.2

  1. Issue no.: 8302: (111 Votes) Want to be able to insert into the middle of merged cells: Done
  2. Issue no.: 60401: Calc does not support all users' strategies regarding sorting data: Done
  3. Issue no.: 25855: (38) Copy multiple separated rows: Done

UX To Do List for OOo 3.1

  1. Issue no.: 59745: (44) Cell notes do not move when cells are sorted in Calc : Done

UX To Do List for OOo 3.0

  1. Issue no.: 60406: Column & Row Headers: No feedback on switching off: Done
  2. Issue no.: 33851: Behavior with cut/copy/paste/fill cells and autofilter: Specification draft: Done
  3. Issue no.: 8811: Allow multiple users to edit the same spreadsheet Specification: Done

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: Done OOo 2.4
  2. Issue no.: 4040: Convert text to columns: Specification: Done OOo 2.4
  3. Issue no.: 27745: Basing autofiltering on the result set, not all rows: Specification: Done OOo 2.4
  4. Issue no.: 20496: Enhanced formula input: Specification: Done OOo 2.4
  5. Issue no.: 15546: Enter-Key behaves not as expected: Specification: Done OOo 2.4
  6. Issue no.: 66857: Control+Enter to create line breaks doesn't always work: OOo 2.4?
  7. Issue no.: 7269: Page Down Should Switch Pages if there is nothing to scroll: Done OOo 2.4
  8. Issue no.: 82071: Flaws in print logic: Specification: Done OOo 2.4
  9. Issue no.: 24372: Individual per Tab Percent View: Specification: Done OOo 2.4
  10. Issue no.: 59697: Need selection of 'current sheet' for printing:</strike>: OOo 2.4 Done
  11. Issue no.: 75766: View Properties per Sheet in Calc: OOo 2.4 Done
  12. Issue no.: 4695: INDIRECT function fails with named cells

UX To Do List for OOo 2.3

The following UX issues have been solved for OOo 2.3.

  1. Issue no.: 78661: Auto-capitalization in Calc cells is perceived as very annoying: Specification: Done OOo 2.3
  2. Issue no.: 25278: Print only selected spreadsheet: Done OOo 2.3
  3. Issue no.: 78488: New Error Message when print output is empty: Done OOo 2.3
  4. Issue no.: 51564: Sum function does not automatically recognize target cell for result: Specification: Done OOo 2.3
  5. Issue no.: 38108: Calc K/B shortcuts: Done OOo 2.3

UX Issue Sources

High Votes Issues in December 2010

  1. Issue no.: 93613:NEW (310 Votes) Solver does not save its model
  2. Issue no.: 103580:NEW (202 Votes) Add Sensitivity Analysis to Linear Solver
  3. Issue no.: 5930:NEW (143) Engineering Notation
  4. Issue no.: 89232:NEW (111) Fill operations should not touch filtered rows.
  5. Issue no.: 33723:NEW (99) NF-DATE: Ability to turn off Number Recognition for incomple
  6. Issue no.: 15773:NEW (98) Currency symbol left justified, while amount right justified
  7. Issue no.: 12666:NEW (96) autofilter works just on one sheet (only one auto-range per
  8. Issue no.: 20857:STARTE (96) R1C1 notation for the spreadsheet
  9. Issue no.: 21280:NEW (75) When cut/copy rows/columns & paste-special, shift down/right
  10. Issue no.: 2131:NEW (69) RFE: ability to merge cells already merged
  11. Issue no.: 5759:NEW (57) DataPilot: allow more than 8 data fields
  12. Issue no.: 5736:NEW (54) Create chart as a sheet (chart only sheet, chartsheet)
  13. Issue no.: 22762:NEW (52) Page preview for Selection
  14. Issue no.: 10864:NEW (50) Border/Backgroundcolor button on toolbar is not 'sticky'
  15. Issue no.: 87999:NEW (36) In "standard" data type csv import should never convert item
  16. Issue no.: 106958:NEW (35) Build GRG Method into solver
  17. Issue no.: 18748:NEW (33) At autocompletion TAB-key-use no longer leads to cell travel
  18. Issue no.: 19440:STARTE (30) Increase number of sheets and columns
  19. Issue no.: 53182:NEW (30) Select visible cells only button
  20. Issue no.: 7357:NEW (30) Paste into nonadjacent random cells
  21. Issue no.: 26009:NEW (29) Calc sheets should *all* be formatted RTL by default in Hebr
  22. Issue no.: 8812:NEW (28) Conditional formating
  23. Issue no.: 44828:NEW (27) tools-detective-trace for cross-sheet formulae
  24. Issue no.: 23839:NEW (27) Underlines in user defined number format, accounting underli
  25. Issue no.: 64604:NEW (24) Allow Calc DataProvider to handle named ranges (new chart)
  26. Issue no.: 32785:STARTE (23) Excel Export BIFF5: missing character encoding
  27. Issue no.: 5460:NEW (23) Corel Quattro Pro import filter/file open
  28. Issue no.: 7722:STARTE (23) Cells Columns that are larger than screen jump when scrollin
  29. Issue no.: 64851:STARTE (23) sum precision differs for inline and cell arguments
  30. Issue no.: 38494:STARTE (22) Copy/Paste numbers from Writer to Calc: decimal separator in
  31. Issue no.: 69830:NEW (22) Opening .tsv files in calc
  32. Issue no.: 10865:NEW (21) Moving/Copying -Single- Cell using click-n-drag
  33. Issue no.: 72191:STARTE (21) Support variable formula conventions

High Votes Issues in April 2008

The following issues are the top 20 high voted Calc issues in 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: Done OOo 3.0
  13. Issue no.: 25855: (38) Copy multiple separated 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

High Votes Issues in July 2007

The following issues are the top 17 high voted Calc issues in July 2007.

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

UX-ctest Issues

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

  1. Issue no.: 60408: Sum Icon in Calc not Found: Specification
  2. Issue no.: 60406: Column & Row Headers: No feedback on switching off: Done OOo 3.0
  3. Issue no.: 60403: Edit menu: Expected menu command to duplicate sheets
  4. Issue no.: 60402: German terminology in context menu for sheet controls could be misunderstood
  5. Issue no.: 60401: Calc does not support all users' strategies regarding sorting data
  6. Issue no.: 60400: Spreadsheet handling wording table vs. spreadsheet
  7. Issue no.: 60399: Delete Columns/Rows in the context menu is missing if the cursor is not positioned on Column/Row Header
  8. Issue no.: 51564: Sum function does not automatically recognize target cell for result: Specification: Done OOo 2.3

Customer UX Issues and Patches

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

  1. Issue no.: 78661: Auto-capitalization in Calc cells is perceived as very annoying: Specification: Done OOo 2.3
  2. Issue no.: 969: Auto-Correct on leaving cells does not work:
  3. Issue no.: 25278: Print only selected spreadsheet: Done OOo 2.3
  4. Issue no.: 78488: New Error Message when print output is empty: OOo 2.3 Done
  5. Issue no.: 7269: Page Down Should Switch Pages if there is nothing to scroll: Done OOo 2.4
  6. Issue no.: 51656: Edit columns width and page margins: Done OOo 2.3
  7. Issue no.: ??????: Add Color Picker and Link to Color Dialog to Color Float
  8. Issue no.: 66484 Missing Range Chooser Issue
  9. Issue no.: 5432 F4 should repeat last command
  10. Issue no.: 10864: Color chooser do not show latest color
  11. Issue no.: 59697: Need selection of 'current sheet' for printing: Done OOo 2.4
  12. Issue no.: 75766: View Properties per Sheet in Calc Done OOo 2.4
  13. Issue no.: 3687: Make CSV import/export filter settings persistent [patch]: Done OOo 2.4


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

  1. Issue no.: 2131: Ability to merge cells already merged
  2. 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 as well as duplicate data introduced trough copying the same data predisposes to multiple errors. If one wrong value is discovered, correcting every occurrence of that data value, if multiple copies of the same data are present, 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
ALL users work on the same spreadsheet, therefore NO duplicate data
  • issue 66817: Paste as bidirectional references, aka HARD-LINKS (Unix style hard links)
e.g. cell B1 contains: = A1; if the user spots an error in the value displayed in B1 and corrects that value, this correction is propagated back into cell A1
  • issue 34213: Paste as (simple) reference (though hard-links are more powerful)
  • further features regarding tracking changes and versioning the document (not filed yet)
    • in a multi-user environment, a specific user is interested in tracking changes only in a limited portion of the document; therefore, one should have the ability to define functional areas in the spreadsheet
    • track only changes in these functional areas: see issue 80325 for further details
    • most often the user needs to track changes in computed values, although this is currently not possible (only direct changes are displayed, see issue 80325)
    • the watch window (issue 28386) goes in that direction
    • mediawiki is another program where one can learn some additional track changes features (e.g. one edits only one functional area)
Discoleo 20:41, 28 July 2007 (CEST)


Send feedback to: Frank Loehmann

Personal tools