Apache OpenOffice (AOO) Bugzilla – Issue 85146
Copy does not work correctly with AutoFilter
Last modified: 2008-07-18 15:45:43 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.
This bug seems to be in 3.0 beta too. Please have a look
This is a duplicate Issue 33851. *** This issue has been marked as a duplicate of 33851 ***
Closed double.