Apache OpenOffice (AOO) Bugzilla – Issue 101011
Rows which are hidden by using AutoFilter are overwritten upon paste or delete etc.
Last modified: 2009-06-17 09:16:47 UTC
columns which are hidden by using AutoFilter are overwritten upon paste or delete etc. I have compared this with Excel 97 and it does not change such columns. Try the following 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, copy it and paste 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 RC1 multilingual version German UI WIN XP: [OOO310m9 (Build 9396)]" and can NOT confirm the reported effect. For step 5 I moved cell cursor to B2, pressed <cntrl>+<c>, marked B3 -> B16 with mousepointer + pushed left mouse button, then pressed <cntrl>+<v>. Result: only visible Cells contained "zz". I will test with 3.0.1 additionally. @debugger_pl: Pls. specify your OS and platform and contribute a more detailed instruction how to reproduce the problem, especially for item 5!
My test also negative for 3.0.1
Copy & Paste using Ctrl + C / Ctrl + V is working, but when we select B2 cell and copy its value by dragging (when the cursor will change to cross) then all values will be overwritten (not only visible ones). We use copying by dragging when we want to fill series of cells with numbers for example, which are growing.
I can confirm, using the "fill down dragging control point" no idea how that function is called overwrites hidden cells. I will check for other reports concerning this problem, soon.
May be Issue 33851 isn't a complete fix for all requirements? It will take some time to read again all correspondence concerning these "overwrite hidden cells" issues.
It is a duplicate to Issue 33851 *** This issue has been marked as a duplicate of 33851 ***
closed
@wope: Marking this as DUP without reopening Issue 33851 means you see the reported behaviour "as desired"?
No response, so reopened, because the current behaviour is unexpected and can cause dataloss. The current behaviour is at least inconsistent. Steps to reproduce: 1. open attached "mysample.ods" 2. Mark 'B2:B25' using pushed mouse button 3. Menu 'Edit -> fill -> series' As expected, you can use that function 4. now close dialogue for further tests 11. (Auto-) Filter column 'A', so that only rows with "a" remain 12. Mark 'B2:B24' using pushed mouse button 13. Menu 'Edit -> fill' As expected, all fill items are greyed out and kinactive 14. close menue pulldown for further tests 20. Data still is filtered by step 11 21. click on 'B2' 22. Move mouse pointer to control point at bottom right corner of cell 'B2', so that pointer will change to little cross line 23. Drag control point to cell 'B24' Automatic fill will fill all cells "hidden ones" included with series 1, 2, 3, ... That function should be blocked for filtered data ranges as it is for Menu 'Edit -> fill' Of course, this issue is related to Issue 33851, but the problem is definitively not fixed with Issue 33851. Unfortunately, this aspect seems to be forgotten in specification sheets listed in Issue 33851
Created attachment 63034 [details] Sample document
Not forgotten, but no time in schedule, see dup issue. *** This issue has been marked as a duplicate of 89232 ***
Closing.