Revision as of 17:13, 22 July 2007

Sort

• All sort Issues

• Sorting should default to selected column : 7277
• Data sorting by using more than 3 items (columns) : 10933 and 22884
• Sort by number groups : 22419
• Title lines are sorted as data : 22758 and 54748
• Cell notes do not move when cells are sorted : 59745
• Ability to sort subtotals : 70873

DataPilot

• All DataPilot issues

• Allow more than 8 data fields : 5759
• Cell Styles not changeable to datapilot generated cells : 11103 and 53234
• Allow to change labels : 22029
• Copies of Datapilot are non-functional : 27611
• Keep formatting associated with items : 32303
• Consolidation areas as source : 32306
• Display of empty results and errors : 32308
• Double-click in Datapilot cell should provide calculation data of that cell : 57030
• Sorting by dataField : 72304

Merge cells

• All Merge Cells issues

• Ability to merge cells already merged : 2131
• Copying across fromulas from one merged cell to another : 7500
• Allow deleting from merged ranges : 8363
• Merge Contain Cells : 40686
• Validity/Input Help Does NOT Work With Merged Cells : 43818
• Calc - "column optimal width" does not work on merged cells : 50193
• Merged cells do not drag-fill properly : 66028
• Recording changes should not disable merge cell : 68742
• Unexpected behavior when extending merged cells : 72178

AutoFilter

• All AutoFilter issues

• All Filter issues
• Autofilter works just on one sheet (only one auto-range per document) : 12666
• Add wildcards to the standard autofilter : 17993
• Up standard autofilter fields from 3 to 4 : 17995
• Basing autofiltering on the result set, not all rows : 27745
• Show resulting number of rows in status bar when using autofilter : 28268
• Behavior with cut/copy/paste/fill cells and autofilter : 33851
• Empty / Non Empty options for Autofilter meny : 35578
• No option to permit autofilter in protected sheets when exporting as XLS : 57708
• Autofilter does not recognize added entries : 59229
• AutoFilter: Not intuitive : 76277

Shortcut or Keystroke

• Issues contain Keystroke
• Issues contain Shortcut

• Provide keyboard shortcuts for Edit->Fill as default : 63727
• Wish: predefine shortcuts for CALC->MENU:edit->MENU:fill options : 75881
• Fill Commands behavior not compatible with Excel : 44649

• Please implement CTRL-+ for INSERT : 30590
• Keyboard shortcuts for inserting/deleting rows/cols : 76971
• Key shortcut for inserting lines : 2842

• Ctrl ; does not add Current Date : 1704
• Automatic Insert (shift down or shift right) of cells, columns, or rows when cut, or copied, and pasted : 21280
• Moving/Copying -Single- Cell using click-n-drag : 10865
• Pressing the "delete" button on a selected cell should not necessarily bring up the "Delete Contents" : 9392
• Double click on register should show rename dialog : 4517
• Add short cut [END+Arrow Keys], for easier range selection : 6490
• Enter key, as a shortcut, to paste something from the clipboard : 28535
• Request keyboard shortcut "Alt + =" for AutoSum : 45563
• Extending row/column selection in calc, easier with shift - : 21869
• Need [ctrl]-["] to copy contents of cell above active cell : 56938
• Alt-key should display AutoFilter List : 74145

• Keystroke F5 for repeat the last action (Menu Edit / Repeat)

Links

• http://wiki.services.openoffice.org/wiki/Calc_Usability_Activities
• List ENHANCEMENT and FEATURE issues for Spreadsheet (Calc)
• Sort by votes
• http://fr.openoffice.org/Marketing/matexpo/Documents/Faiblesses_de_Calc.sxw