Difference between revisions of "FR/FeaturesCalc"
From Apache OpenOffice Wiki
< FR
Tonygalmiche (Talk | contribs) (→Print) |
m (Added French Category) |
||
(7 intermediate revisions by 4 users not shown) | |||
Line 12: | 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 67: | Line 67: | ||
* 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] | * 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] | * 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] | * 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] | * 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] | ||
Line 88: | Line 82: | ||
* Print active sheet as default : [http://distribution.openoffice.org/issues/show_bug.cgi?id=45046 45046] | * 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] | * 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] | * 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] | * Add possibility to switch on/off printing of cell background color : [http://distribution.openoffice.org/issues/show_bug.cgi?id=53426 53426] | ||
− | |||
− | |||
− | |||
= Formating = | = Formating = | ||
Line 131: | Line 131: | ||
= Links = | = 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://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 | * http://fr.openoffice.org/Marketing/matexpo/Documents/Faiblesses_de_Calc.sxw | ||
+ | |||
+ | [[Category:FR/Archives]] |
Latest revision as of 22:19, 8 May 2009
Contents
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
- 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
- All issues contain "format"
- More border types (dashed, dotted, etc) : 8275
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)