To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33851
User er changed the following: What |Old value |New value ================================================================================ Summary|Paste/delete/modify cells |Behavior with cut/copy/pas |and autofilter like MS Exc|te/fill cells and autofilt |el |er -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Fri Aug 18 14:18:39 -0700 2006 ------- Let's recapitulate some scenarios to show that yet it isn't even agreed upon how the behavior should be: 1. Copy cells This sounds easy: just copy the cells that are not filtered out. - BUT: what to do on paste (on a non-filtered range) if the cells contain formulas with relative references? How to adjust? - Excel 2003 in this case doesn't paste the formulas, but only the values. 2. Cut cells Sounds the same as #1, just cut the cells that are not filtered out. Though the paste case may be easier, probably the references should be adjusted the same way as usual in a cut/paste scenario. - BUT: Excel 2003 in this case cuts _all_ cells, including filtered. 3. Paste cells Again sounds easy: just paste on the non-filtered rows. - BUT: what should happen with the gaps? Should the cells to be copied be skipped, or should they go in the next non-filtered row? - AGAIN: how to adjust relative references then? - Excel 2003 in this case pastes also to filtered rows if the cells were copied from a non-filtered range. It only does not paste to filtered rows if the cells were copied from the same filtered range _and_ rows. It does paste to filtered rows if the source rows were different. 4. Fill cells Sounds easy: fill only non-filtered rows. - Excel 2003 does that. 5. Fill Series Fill continuous in the non-filtered rows? Or fill with gaps, leaving out the values that would go into the filtered rows? Or do nothing? - Excel 2003 disables Fill Series on filtered ranges. You see, especially from #2 and #3 the argument "do it like Excel" is at least half-moot. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]