Difference between revisions of "FR/FeaturesCalc"

From Apache OpenOffice Wiki
< FR
Jump to: navigation, search
(→‎AutoFilter)
m (Added French Category)
 
(47 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
* [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=&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&namedcmd=Chart-Unconfirmed&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query List ENHANCEMENT and FEATURE issues for Spreadsheet (Calc)]
 
−
 
−
 
 
= Sort =
 
= Sort =
 
* [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=sort&short_desc_type=allwords&long_desc=&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&namedcmd=Chart-Unconfirmed&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query All sort Issues]
 
* [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=sort&short_desc_type=allwords&long_desc=&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&namedcmd=Chart-Unconfirmed&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query All sort Issues]
Line 15: Line 12:
  
 
* [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=datapilot&short_desc_type=allwords&long_desc=&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&namedcmd=Chart-Unconfirmed&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query All DataPilot issues]
 
* [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=datapilot&short_desc_type=allwords&long_desc=&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&namedcmd=Chart-Unconfirmed&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query All DataPilot issues]
−
+
* Change datapilot source range [http://qa.openoffice.org/issues/show_bug.cgi?id=23658 23658]
 
* Allow more than 8 data fields : [http://distribution.openoffice.org/issues/show_bug.cgi?id=5759 5759]
 
* Allow more than 8 data fields : [http://distribution.openoffice.org/issues/show_bug.cgi?id=5759 5759]
 
* Cell Styles not changeable to datapilot generated cells : [http://distribution.openoffice.org/issues/show_bug.cgi?id=11103 11103] and [http://distribution.openoffice.org/issues/show_bug.cgi?id=53234 53234]
 
* Cell Styles not changeable to datapilot generated cells : [http://distribution.openoffice.org/issues/show_bug.cgi?id=11103 11103] and [http://distribution.openoffice.org/issues/show_bug.cgi?id=53234 53234]
Line 40: Line 37:
  
 
= AutoFilter =
 
= AutoFilter =
−
* [http://distribution.openoffice.org/issues/buglist.cgi?Submit+query=Submit+query&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=autofilter&short_desc_type=allwords&long_desc=&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&namedcmd=Chart-Unconfirmed&newqueryname=&order=Reuse+same+sort+as+last+time All AutoFilter issues]
+
* [http://distribution.openoffice.org/issues/buglist.cgi?Submit+query=Submit+query&issue_type=DEFECT&issue_type=ENHANCEMENT&issue_type=FEATURE&issue_type=TASK&issue_type=PATCH&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=autofilter&short_desc_type=allwords&long_desc=&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 All AutoFilter issues]  
 +
 
 
* [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=filter&short_desc_type=allwords&long_desc=&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&namedcmd=Chart-Unconfirmed&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query All Filter issues]
 
* [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=filter&short_desc_type=allwords&long_desc=&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&namedcmd=Chart-Unconfirmed&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query All Filter issues]
−
 
−
 
 
* Autofilter works just on one sheet (only one auto-range per document) : [http://distribution.openoffice.org/issues/show_bug.cgi?id=12666 12666]
 
* Autofilter works just on one sheet (only one auto-range per document) : [http://distribution.openoffice.org/issues/show_bug.cgi?id=12666 12666]
 
* Add wildcards to the standard autofilter : [http://distribution.openoffice.org/issues/show_bug.cgi?id=17993 17993]
 
* Add wildcards to the standard autofilter : [http://distribution.openoffice.org/issues/show_bug.cgi?id=17993 17993]
Line 50: Line 46:
 
* Show resulting number of rows in status bar when using autofilter : [http://distribution.openoffice.org/issues/show_bug.cgi?id=28268 28268]
 
* Show resulting number of rows in status bar when using autofilter : [http://distribution.openoffice.org/issues/show_bug.cgi?id=28268 28268]
 
* Behavior with cut/copy/paste/fill cells and autofilter :  [http://distribution.openoffice.org/issues/show_bug.cgi?id=33851 33851]
 
* Behavior with cut/copy/paste/fill cells and autofilter :  [http://distribution.openoffice.org/issues/show_bug.cgi?id=33851 33851]
 +
* Empty / Non Empty options for Autofilter meny : [http://distribution.openoffice.org/issues/show_bug.cgi?id=35578 35578]
 
* No option to permit autofilter in protected sheets when exporting as XLS :  [http://distribution.openoffice.org/issues/show_bug.cgi?id=57708 57708]
 
* No option to permit autofilter in protected sheets when exporting as XLS :  [http://distribution.openoffice.org/issues/show_bug.cgi?id=57708 57708]
 
* Autofilter does not recognize added entries : [http://distribution.openoffice.org/issues/show_bug.cgi?id=59229 59229]
 
* Autofilter does not recognize added entries : [http://distribution.openoffice.org/issues/show_bug.cgi?id=59229 59229]
 
* AutoFilter: Not intuitive : [http://distribution.openoffice.org/issues/show_bug.cgi?id=76277 76277]
 
* AutoFilter: Not intuitive : [http://distribution.openoffice.org/issues/show_bug.cgi?id=76277 76277]
 +
 +
= Multiple sheets =
 +
* [http://qa.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=&chfieldvalue=&short_desc=multi+sheet&short_desc_type=allwords&long_desc=&long_desc_type=allwords&issue_file_loc=&issue_file_loc_type=fulltext&status_whiteboard=&status_whiteboard_type=fulltext&keywords=&keywords_type=anytokens&field0-0-0=noop&type0-0-0=noop&value0-0-0=&cmdtype=doit&namedcmd=Calc-2.3&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query All issues content "Multi + Sheet"]
 +
* [http://qa.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=&chfieldvalue=&short_desc=sheet&short_desc_type=allwords&long_desc=&long_desc_type=allwords&issue_file_loc=&issue_file_loc_type=fulltext&status_whiteboard=&status_whiteboard_type=fulltext&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 All Sheet issues]
 +
* Cannot insert lines on multiple sheets : [http://qa.openoffice.org/issues/show_bug.cgi?id=23263 23263]
 +
* Add/delete rows/columns across selected sheets : [http://qa.openoffice.org/issues/show_bug.cgi?id=7088 7088]
 +
* Add "Deselect all sheet" to context menu of worksheet tab menu : [http://qa.openoffice.org/issues/show_bug.cgi?id=7921 7921]
 +
* Multi-sheet paste special with shift down broken : [http://qa.openoffice.org/issues/show_bug.cgi?id=17044 17044] or [http://qa.openoffice.org/issues/show_bug.cgi?id=29849 29849]
 +
* Range Selection Lost When Switching Between Sheet Tabs : [http://qa.openoffice.org/issues/show_bug.cgi?id=25643 25643]
 +
* Selection of multiple sheets using short-cut keys: selection works but not deselection : [http://qa.openoffice.org/issues/show_bug.cgi?id=38546 38546]
 +
* Allow to send a single sheet from multi sheet document as email : [http://qa.openoffice.org/issues/show_bug.cgi?id=71751 71751]
 +
 +
= Print =
 +
* [http://distribution.openoffice.org/issues/buglist.cgi?resort=1&Submit%20query=Submit%20query;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=print;short_desc_type=allwords;long_desc=;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=;namedcmd=Chart-Unconfirmed;newqueryname=&order=issues.votes%20desc%2C%20issues.issue_status%2C%20issues.priority%2C%20issues.issue_id All issues contain "print" sort by votes]
 +
 +
* In Calc defined print ranges/areas do not get copied if one creates a copy of a sheet : [http://distribution.openoffice.org/issues/show_bug.cgi?id=3560 3560]
 +
* Print Selection only works for selected cells, not other selected objects : [http://distribution.openoffice.org/issues/show_bug.cgi?id=3992 3992]
 +
* Printing a sheet on a specified number of pages : [http://distribution.openoffice.org/issues/show_bug.cgi?id=11336 11336]
 +
* Allows to set the page margins in the "Print Preview" dialog by dragging margin indicator lines : [http://distribution.openoffice.org/issues/show_bug.cgi?id=11395 11395]
 +
* Ability to print individual objects : [http://distribution.openoffice.org/issues/show_bug.cgi?id=14900 14900]
 +
* Page-preview under print : [http://distribution.openoffice.org/issues/show_bug.cgi?id=17787 17787]
 +
* Printing in more than one column : [http://distribution.openoffice.org/issues/show_bug.cgi?id=19124 19124]
 +
* Page preview for Selection : [http://distribution.openoffice.org/issues/show_bug.cgi?id=22762 22762]
 +
* Make printing named ranges easier : [http://distribution.openoffice.org/issues/show_bug.cgi?id=24830 24830]
 +
* Unable to select different collumns to print : [http://distribution.openoffice.org/issues/show_bug.cgi?id=24886 24886]
 +
* Moving a page break in page break preview makes only _one_ print range : [http://distribution.openoffice.org/issues/show_bug.cgi?id=27245 27245]
 +
* Current sheet pagenumbers should be shown in print dialog : [http://distribution.openoffice.org/issues/show_bug.cgi?id=27440 27440]
 +
* Print Preview Scale adjustment stays with page # not affected tab : [http://distribution.openoffice.org/issues/show_bug.cgi?id=27473 27473]
 +
* Keeping merged ranges together when printing : [http://distribution.openoffice.org/issues/show_bug.cgi?id=28433 28433]
 +
* Go to page missing in Print Preview : [http://distribution.openoffice.org/issues/show_bug.cgi?id=44032 44032]
 +
* Print active sheet as default : [http://distribution.openoffice.org/issues/show_bug.cgi?id=45046 45046]
 +
* Print notes on same page : [http://distribution.openoffice.org/issues/show_bug.cgi?id=45493 45493]
 +
* Add NOPRINTROW and NOPRINTCOL functions : [http://distribution.openoffice.org/issues/show_bug.cgi?id=54039 54039]
 +
* Adjusting Columns in Print Preview : [http://distribution.openoffice.org/issues/show_bug.cgi?id=58735 58735]
 +
* Need selection of 'current sheet' for printing : [http://distribution.openoffice.org/issues/show_bug.cgi?id=59697 59697]
 +
* Monochrome printing from OOo Calc : [http://distribution.openoffice.org/issues/show_bug.cgi?id=66845 66845]
 +
 +
 +
== Duplicate issues ==
 +
* Various printing default settings (to make things a bit slicker) : [http://distribution.openoffice.org/issues/show_bug.cgi?id=10530 10530]
 +
* Printing does't take the range of cells selected : [http://distribution.openoffice.org/issues/show_bug.cgi?id=43047 43047]
 +
 +
 +
* Backgrounds print irregardless of printer settings :  [http://distribution.openoffice.org/issues/show_bug.cgi?id=39244 39244]
 +
* Add possibility to switch on/off printing of cell background color : [http://distribution.openoffice.org/issues/show_bug.cgi?id=53426 53426]
 +
 +
= Formating =
 +
* [http://qa.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&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&short_desc=format&short_desc_type=allwords&long_desc=&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&namedcmd=Chart-Unconfirmed&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query All issues contain "format"]
 +
* More border types (dashed, dotted, etc) : [http://qa.openoffice.org/issues/show_bug.cgi?id=8275 8275]
 +
 +
= Formula =
 +
* [http://distribution.openoffice.org/issues/buglist.cgi?Submit+query=Submit+query&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=formula&short_desc_type=allwords&long_desc=&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&namedcmd=Chart-Unconfirmed&newqueryname=&order=Reuse+same+sort+as+last+time All issues contain "formula" sort by votes]
 +
 +
= Shortcut or 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]
 +
 +
 +
* 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]
 +
 +
 +
* Ctrl ; does not add Current Date : [http://distribution.openoffice.org/issues/show_bug.cgi?id=1704 1704]
 +
* Double click on register should show rename dialog : [http://distribution.openoffice.org/issues/show_bug.cgi?id=4517 4517]
 +
* Add short cut [END+Arrow Keys], for easier range selection : [http://distribution.openoffice.org/issues/show_bug.cgi?id=6490 6490]
 +
* 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]
 +
* Moving/Copying -Single- Cell using click-n-drag : [http://distribution.openoffice.org/issues/show_bug.cgi?id=10865 10865]
 +
* Enhanced formula input : [http://distribution.openoffice.org/issues/show_bug.cgi?id=20496 20496]
 +
* 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]
 +
* Extending row/column selection in calc, easier with shift - : [http://distribution.openoffice.org/issues/show_bug.cgi?id=21869 21869]
 +
* 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]
 +
* Need [ctrl]-["] to copy contents of cell above active cell : [http://distribution.openoffice.org/issues/show_bug.cgi?id=56938 56938]
 +
* Alt-key should display AutoFilter List :  [http://distribution.openoffice.org/issues/show_bug.cgi?id=74145 74145]
 +
* Keyboard shortcuts for inserting/deleting rows/cols :  [http://distribution.openoffice.org/issues/show_bug.cgi?id=76971 76971]
 +
 +
 +
* Keystroke F5 for repeat the last action (Menu Edit / Repeat)
 +
 +
= Links =
 +
* [[Calc/To-Dos/Usability]]
 +
* [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=&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&namedcmd=Chart-Unconfirmed&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query List ENHANCEMENT and FEATURE issues for Spreadsheet (Calc)] - [http://distribution.openoffice.org/issues/buglist.cgi?resort=1&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=;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=;namedcmd=Chart-Unconfirmed;newqueryname=;Submit%20query=Submit%20query&order=issues.votes%20desc%2C%20issues.issue_id Sort by votes]
 +
* http://fr.openoffice.org/Marketing/matexpo/Documents/Faiblesses_de_Calc.sxw
 +
 +
[[Category:FR/Archives]]

Latest revision as of 22:19, 8 May 2009

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

  • All DataPilot issues
  • Change datapilot source range 23658
  • 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 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

Multiple sheets

  • All issues content "Multi + Sheet"
  • All Sheet issues
  • Cannot insert lines on multiple sheets : 23263
  • Add/delete rows/columns across selected sheets : 7088
  • Add "Deselect all sheet" to context menu of worksheet tab menu : 7921
  • Multi-sheet paste special with shift down broken : 17044 or 29849
  • Range Selection Lost When Switching Between Sheet Tabs : 25643
  • Selection of multiple sheets using short-cut keys: selection works but not deselection : 38546
  • Allow to send a single sheet from multi sheet document as email : 71751

Print

  • In Calc defined print ranges/areas do not get copied if one creates a copy of a sheet : 3560
  • Print Selection only works for selected cells, not other selected objects : 3992
  • Printing a sheet on a specified number of pages : 11336
  • Allows to set the page margins in the "Print Preview" dialog by dragging margin indicator lines : 11395
  • Ability to print individual objects : 14900
  • Page-preview under print : 17787
  • Printing in more than one column : 19124
  • Page preview for Selection : 22762
  • Make printing named ranges easier : 24830
  • Unable to select different collumns to print : 24886
  • Moving a page break in page break preview makes only _one_ print range : 27245
  • Current sheet pagenumbers should be shown in print dialog : 27440
  • Print Preview Scale adjustment stays with page # not affected tab : 27473
  • Keeping merged ranges together when printing : 28433
  • Go to page missing in Print Preview : 44032
  • Print active sheet as default : 45046
  • Print notes on same page : 45493
  • Add NOPRINTROW and NOPRINTCOL functions : 54039
  • Adjusting Columns in Print Preview : 58735
  • Need selection of 'current sheet' for printing : 59697
  • Monochrome printing from OOo Calc : 66845


Duplicate issues

  • Various printing default settings (to make things a bit slicker) : 10530
  • Printing does't take the range of cells selected : 43047


  • Backgrounds print irregardless of printer settings : 39244
  • Add possibility to switch on/off printing of cell background color : 53426

Formating

Formula

Shortcut or Keystroke


  • 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


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


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

Links

Retrieved from "https://wiki.openoffice.org/w/index.php?title=FR/FeaturesCalc&oldid=124158"
Personal tools