Issue 85146

Summary:	Copy does not work correctly with AutoFilter
Product:	Calc	Reporter:	matagl <matagl>
Component:	programming	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	helenrussian, issues, kpalagin
Version:	OOo 2.3.1
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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.