Issue 72555

Summary: filter: pasting onto filtered rows will affect invisible cells; inconsistent with deletion
Product: Calc Reporter: zhongqiyao <lotus>
Component: editingAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues, kpalagin
Version: OOo 2.0.4Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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