Issue 85146 - Copy does not work correctly with AutoFilter
Summary: Copy does not work correctly with AutoFilter
Status: CLOSED DUPLICATE of issue 33851
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-01-10 21:21 UTC by matagl
Modified: 2008-07-18 15:45 UTC (History)
3 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description matagl 2008-01-10 21:21:07 UTC
When within an AutoFilter range with an active filter, rows may be hidden.  In
this case copy does not work as expected.  I noticed this when my spreadsheet
was corrupted.

I suspect this is a bug because Calc appears to mostly behave the same way as
Excel in this regard.  Here are the cases I checked:

Excel

1) Hide rows, Delete or copy to a range that spans the hidden rows, the cells in
the hidden rows are affected
2) Auto filter, Delete a range that spans the hidden rows, the cells in the
hidden rows are not affected
3) Auto filter, Copy to a range that spans the hidden rows, the cells in the
hidden rows are not affected

OpenOffice

1) Hide rows, Delete or copy to a range that spans the hidden rows, the cells in
the hidden rows are affected
2) Auto filter, Delete a range that spans the hidden rows, the cells in the
hidden rows are not affected
3) Auto filter, Copy to a range that spans the hidden rows, the cells in the
hidden rows ARE affected

Given that case 2 is the same with Calc and Excel, I suspect that case 3 should
also be the same.  I think Calc is not behaving correctly in this case.
Comment 1 grenouille_fr 2008-05-30 23:28:51 UTC
This bug seems to be in 3.0 beta too.

Please have a look
Comment 2 helenrussian 2008-07-18 15:44:24 UTC
This is a duplicate Issue 33851.

*** This issue has been marked as a duplicate of 33851 ***
Comment 3 helenrussian 2008-07-18 15:45:43 UTC
Closed double.