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]
