Difference between revisions of "FR/FeaturesCalc"

From Apache OpenOffice Wiki
< FR
Jump to: navigation, search
(→‎Shortcut or Keystroke)
(→‎Shortcut or Keystroke)
Line 56: Line 56:
 
* [http://distribution.openoffice.org/issues/buglist.cgi?issue_type=ENHANCEMENT&issue_type=FEATURE&component=Spreadsheet&issue_status=UNCONFIRMED&issue_status=NEW&issue_status=STARTED&issue_status=REOPENED&issue_status=RESOLVED&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&short_desc=&short_desc_type=allwords&long_desc=keystroke&long_desc_type=allwords&issue_file_loc=&issue_file_loc_type=substring&status_whiteboard=&status_whiteboard_type=substring&keywords=&keywords_type=anytokens&field0-0-0=noop&type0-0-0=noop&value0-0-0=&cmdtype=doit&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query Issues contain Keystroke]
 
* [http://distribution.openoffice.org/issues/buglist.cgi?issue_type=ENHANCEMENT&issue_type=FEATURE&component=Spreadsheet&issue_status=UNCONFIRMED&issue_status=NEW&issue_status=STARTED&issue_status=REOPENED&issue_status=RESOLVED&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&short_desc=&short_desc_type=allwords&long_desc=keystroke&long_desc_type=allwords&issue_file_loc=&issue_file_loc_type=substring&status_whiteboard=&status_whiteboard_type=substring&keywords=&keywords_type=anytokens&field0-0-0=noop&type0-0-0=noop&value0-0-0=&cmdtype=doit&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query Issues contain Keystroke]
 
* [http://distribution.openoffice.org/issues/buglist.cgi?issue_type=ENHANCEMENT&issue_type=FEATURE&component=Spreadsheet&issue_status=UNCONFIRMED&issue_status=NEW&issue_status=STARTED&issue_status=REOPENED&issue_status=RESOLVED&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&short_desc=&short_desc_type=allwords&long_desc=Shortcut&long_desc_type=allwords&issue_file_loc=&issue_file_loc_type=substring&status_whiteboard=&status_whiteboard_type=substring&keywords=&keywords_type=anytokens&field0-0-0=noop&type0-0-0=noop&value0-0-0=&cmdtype=doit&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query Issues contain Shortcut]
 
* [http://distribution.openoffice.org/issues/buglist.cgi?issue_type=ENHANCEMENT&issue_type=FEATURE&component=Spreadsheet&issue_status=UNCONFIRMED&issue_status=NEW&issue_status=STARTED&issue_status=REOPENED&issue_status=RESOLVED&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&short_desc=&short_desc_type=allwords&long_desc=Shortcut&long_desc_type=allwords&issue_file_loc=&issue_file_loc_type=substring&status_whiteboard=&status_whiteboard_type=substring&keywords=&keywords_type=anytokens&field0-0-0=noop&type0-0-0=noop&value0-0-0=&cmdtype=doit&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query Issues contain Shortcut]
−
 
−
 
−
* Automatic Insert (shift down or shift right) of cells, columns, or rows when cut, or copied, and pasted : [http://distribution.openoffice.org/issues/show_bug.cgi?id=21280 21280]
 
  
  
Line 66: Line 63:
  
  
 +
* Provide keyboard shortcuts for Edit->Fill as default : [http://distribution.openoffice.org/issues/show_bug.cgi?id=63727 63727]
 +
* Wish: predefine shortcuts for CALC->MENU:edit->MENU:fill options : [http://distribution.openoffice.org/issues/show_bug.cgi?id=75881 75881]
 +
* Fill Commands behavior not compatible with Excel : [http://distribution.openoffice.org/issues/show_bug.cgi?id=44649 44649]
 +
 +
 +
* Please implement CTRL-+ for INSERT : [http://distribution.openoffice.org/issues/show_bug.cgi?id=30590 30590]
 +
* Keyboard shortcuts for inserting/deleting rows/cols :  [http://distribution.openoffice.org/issues/show_bug.cgi?id=76971 76971]
 +
* Key shortcut for inserting lines : [http://distribution.openoffice.org/issues/show_bug.cgi?id=2842 2842]
 +
 +
 +
* Automatic Insert (shift down or shift right) of cells, columns, or rows when cut, or copied, and pasted : [http://distribution.openoffice.org/issues/show_bug.cgi?id=21280 21280]
 
* Moving/Copying -Single- Cell using click-n-drag : [http://distribution.openoffice.org/issues/show_bug.cgi?id=10865 10865]
 
* Moving/Copying -Single- Cell using click-n-drag : [http://distribution.openoffice.org/issues/show_bug.cgi?id=10865 10865]
 
* Pressing the "delete" button on a selected cell should not necessarily bring up the "Delete Contents" : [http://distribution.openoffice.org/issues/show_bug.cgi?id=9392 9392]
 
* Pressing the "delete" button on a selected cell should not necessarily bring up the "Delete Contents" : [http://distribution.openoffice.org/issues/show_bug.cgi?id=9392 9392]
Line 71: Line 79:
 
* Add short cut [END+Arrow Keys], for easier range selection : [http://distribution.openoffice.org/issues/show_bug.cgi?id=6490 6490]
 
* Add short cut [END+Arrow Keys], for easier range selection : [http://distribution.openoffice.org/issues/show_bug.cgi?id=6490 6490]
 
* Enter key, as a shortcut, to paste something from the clipboard : [http://distribution.openoffice.org/issues/show_bug.cgi?id=28535 28535]
 
* Enter key, as a shortcut, to paste something from the clipboard : [http://distribution.openoffice.org/issues/show_bug.cgi?id=28535 28535]
−
 
−
 
 
* Request keyboard shortcut "Alt + =" for AutoSum : [http://distribution.openoffice.org/issues/show_bug.cgi?id=45563 45563]
 
* Request keyboard shortcut "Alt + =" for AutoSum : [http://distribution.openoffice.org/issues/show_bug.cgi?id=45563 45563]
 
* Extending row/column selection in calc, easier with shift - : [http://distribution.openoffice.org/issues/show_bug.cgi?id=21869 21869]  
 
* Extending row/column selection in calc, easier with shift - : [http://distribution.openoffice.org/issues/show_bug.cgi?id=21869 21869]  
−
 
−
 
 
* Need [ctrl]-["] to copy contents of cell above active cell : [http://distribution.openoffice.org/issues/show_bug.cgi?id=56938 56938]
 
* Need [ctrl]-["] to copy contents of cell above active cell : [http://distribution.openoffice.org/issues/show_bug.cgi?id=56938 56938]
−
 
−
 
−
* Provide keyboard shortcuts for Edit->Fill as default : [http://distribution.openoffice.org/issues/show_bug.cgi?id=63727 63727]
 
−
* Wish: predefine shortcuts for CALC->MENU:edit->MENU:fill options : [http://distribution.openoffice.org/issues/show_bug.cgi?id=75881 75881]
 
−
* Fill Commands behavior not compatible with Excel : [http://distribution.openoffice.org/issues/show_bug.cgi?id=44649 44649]
 
−
 
−
 
 
* Alt-key should display AutoFilter List :  [http://distribution.openoffice.org/issues/show_bug.cgi?id=74145 74145]
 
* Alt-key should display AutoFilter List :  [http://distribution.openoffice.org/issues/show_bug.cgi?id=74145 74145]
−
 
−
 
−
* Please implement CTRL-+ for INSERT : [http://distribution.openoffice.org/issues/show_bug.cgi?id=30590 30590]
 
−
* Keyboard shortcuts for inserting/deleting rows/cols :  [http://distribution.openoffice.org/issues/show_bug.cgi?id=76971 76971]
 
−
* Key shortcut for inserting lines : [http://distribution.openoffice.org/issues/show_bug.cgi?id=2842 2842]
 
  
  
 
* Keystroke F5 for repeat the last action (Menu Edit / Repeat)
 
* Keystroke F5 for repeat the last action (Menu Edit / Repeat)

Revision as of 07:32, 22 July 2007


Sort

  • 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

  • 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

  • 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
  • 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


  • Ctrl ; does not add Current Date : 1704
  • Add keyboard shortcut "ctrl+:" and "ctrl+;" to add the date : 77716
  • Request for Time and Date Shortcut Keys in Calc : 14392


  • 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


  • 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)
Retrieved from "https://wiki.openoffice.org/w/index.php?title=FR/FeaturesCalc&oldid=40017"
Personal tools