Issue 72555 - filter: pasting onto filtered rows will affect invisible cells; inconsistent with deletion
Summary: filter: pasting onto filtered rows will affect invisible cells; inconsistent ...
Status: CLOSED DUPLICATE of issue 33851
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.4
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2006-12-14 05:34 UTC by zhongqiyao
Modified: 2008-05-17 23:29 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description zhongqiyao 2006-12-14 05:34:34 UTC 
Related:

Issue 364 about filtered cells.

***

OpenOffice 2.0.4, Chinese (Traditional characters).
Windows XP Home SP2, Chinese (Traditional characters).

1. If you say this is technical correct, could you compare with the
   "Backspace" or "Delete" action?

2. Do row filtering, so that only row 2 and 4 are visible.

3. For any column,
   At row 2, drag the lower right corner to row 4 so that it will copy
   the content of row 2 to row 4.  Now row 3 is also affected.

4. ALTERNATIVELY, for any column,
   At row 2, do "copy". Then highlight both row 2 and
   row 4 and do "paste".  Now row 3 is also affected.

5. HOWEVER, For any column,
   If you select row 2 and row 4, and do either "backspace" or 
   "delete", it will not delete row 3.  (Same as Microsoft Office.)

6. Therefore, I personally think that if "5" is correct, then "3"
   and "4" are wrong.

Thanks.

Qiyao

------- Additional comments from zhongqiyao Wed Dec 13 21:14:38 -0800 2006 -------

I would also like to comment that showing a warning when the
user wants to paste does not really work, because:

1. The user may overwrite an empty cell.

2. The user may think that the paste is on non-empty cells
visible in the filter.

Thanks.

Qiyao
Comment 1 kpalagin 2006-12-17 16:53:59 UTC 
Seems to be duplicate of http://www.openoffice.org/issues/show_bug.cgi?
id=33851. Closing.

zhongqiyao,
please vote for issue 33851. 
It has Wiki page at 
http://wiki.services.openoffice.org/wiki/Calc/Drafts/Issue_33851

*** This issue has been marked as a duplicate of 33851 ***
Comment 2 ace_dent 2008-05-17 21:25:48 UTC 
The Issue you raised has been marked as 'Resolved' and not updated within the
last 1 year+. I am therefore setting this issue to 'Verified' as the first step
towards Closing it. If you feel this is incorrect, please re-open the issue and
add any comments.

Many thanks,
Andrew
 
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html
Comment 3 ace_dent 2008-05-17 23:29:04 UTC 
As per previous posting: Verified -> Closed.
A Closed Issue is a Happy Issue (TM).

Regards,
Andrew