Product: Spreadsheet
Type: changed
Title: Behavior of cut/paste/fill/drag on filtered rows.
Posted by: [EMAIL PROTECTED]
Affected: sc
TaskId: i33851
<http://www.openoffice.org/issues/show_bug.cgi?id=33851>
Effective from: CWS filteredrows
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [ ]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
Implemented a strategy to not let the user accidentally overwrite
content of filtered rows by treating a filtered selection similar to
a multi-selection of unfiltered rows, which disables operations not
possible on a multi-selection, like cut, fill, merge. Exceptions
respectively special treatment are:
- Deletion. It was already implemented to not delete filtered rows or
cells. No change.
- Copy filtered to clipboard. Same behavior as before, range is copied
to the clipboard including filtered rows, that when pasted or
transfered to other applications are excluded and only unfiltered rows
are pasted.
- Paste from clipboard to filtered. Clipboard content is sliced and
distributed over unfiltered rows. If formulas are pasted, the
references are updated individually for each slice. The behavior
otherwise is the same as for pasting on a non-filtered range,
including cases of a possibly marked selection being larger or smaller
than the clipboard content.
Overview of menu entries and operations:
Working with multi-selection, taking filtered into account if area
selected:
- Edit
- delete contents
- delete cells
- Format
- cells
- borders
applies borders only to first contiguous area
- delete rows (also columns, but that deletes all rows of the column of
course)
Not working with multi-selection, but taking filtered into account if
area selected:
- Edit
- copy
- paste
- paste special
- input auto sum via icon, creates a SUBTOTAL() function formula
- cell input confirmed with Alt-Enter only inputs value to unfiltered
- drag & drop
- Without control key moves data, similar to cut to clipboard this is
disabled if the source range is filtered.
- Drop on filtered area is disabled.
- With control key copies unfiltered as in copy & paste via clipboard.
- Drop on filtered area is disabled.
- primary X selection
- Filtered source range will be pasted using only unfiltered rows.
- Pasting on filtered area is disabled.
The operations not working with multi-selections and hence being
disabled if a filtered range is selected:
- Edit
- cut
- fill
- all
- Insert
- cells
- rows
- columns
- names
- create
- Format
- merge cells
- auto format
- Data
- sort
- subtotals
- multiple operations
- group and outline
- all
- data pilot
- all
- auto fill by dragging the cell corner
Not working with multi-selection but taking the encompassing range in
the case of a filtered selection:
- Insert
- names
- define
- labels
- Data
- define range
Not working with multi-selection but taking the current cell in that
case:
- Insert
- names
- insert
- note
- show note
Special case of course, always available when filtered:
- Data
- filter
- auto filter
- standard filter
- advanced filter
- remove filter
- hide filter
Send feedback to [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
