Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Rows which are hidden by using AutoFilter are overwritten upon paste or delete etc. | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | debugger_pl <debugger_pl> | ||||
Component: | editing | Assignee: | spreadsheet <spreadsheet> | ||||
Status: | CLOSED DUPLICATE | QA Contact: | issues@sc <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P2 | CC: | issues, kpalagin, ooo, rainerbielefeld_ooo_qa | ||||
Version: | OOo 3.0.1 | Keywords: | oooqa | ||||
Target Milestone: | --- | ||||||
Hardware: | PC | ||||||
OS: | Windows XP | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
debugger_pl
2009-04-10 12:09:13 UTC
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. |