Apache OpenOffice (AOO) Bugzilla – Issue 104473
Cells hidden by using AutoFilter are overwritten by using copy with fill handle
Last modified: 2009-09-04 11:51:52 UTC
Cells hidden by using AutoFilter are overwritten by using copy with fill handle Test: 1) Create a blank spreadsheet with row 1 containing 2 column headers, e.g. A1='Item' and B1='What' 2) Fill columns A2 to A16 with numbers 1 to 15 3) Add a text 'XX' to columns B5, B10 and B14 only 4) Turn on AutoFilter: -standard-what=-empty- This should hide rows 5, 10 and 14 5) Add text 'ZZ' to B2, copies dragging (fill handle) into B3 to B16 6) Switch AutoFilter off (all display -all- on column B). This shows that B5, B10 and B14 have been overwritten with 'ZZ' but they should be untouched.
I checked with "Ooo 3.1.0 WIN XP multilingual version German UI activated [OOO310m11 (Build 9399)]" and can confirm the reported effect. Known problem! @dolespa: Thank you for your attention! *** This issue has been marked as a duplicate of 89232 ***
duplicate -< closed