Issue 101011

Summary: Rows which are hidden by using AutoFilter are overwritten upon paste or delete etc.
Product: Calc Reporter: debugger_pl <debugger_pl>
Component: editingAssignee: 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.1Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Sample document none

Description debugger_pl 2009-04-10 12:09:13 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.
Comment 1 Rainer Bielefeld 2009-04-10 16:07:10 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!

Comment 2 Rainer Bielefeld 2009-04-10 16:18:24 UTC
My test also negative for 3.0.1
Comment 3 debugger_pl 2009-04-10 18:13:22 UTC
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.
Comment 4 Rainer Bielefeld 2009-04-10 18:51:02 UTC
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.
Comment 5 Rainer Bielefeld 2009-04-10 19:20:14 UTC
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.
Comment 6 wope 2009-06-14 01:42:46 UTC
It is a duplicate to Issue 33851

*** This issue has been marked as a duplicate of 33851 ***
Comment 7 wope 2009-06-14 01:43:16 UTC
closed
Comment 8 Rainer Bielefeld 2009-06-14 09:07:05 UTC
@wope:
Marking this as DUP without reopening Issue 33851 means you see the reported
behaviour "as desired"?
Comment 9 Rainer Bielefeld 2009-06-17 06:16:25 UTC
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
Comment 10 Rainer Bielefeld 2009-06-17 06:45:03 UTC
Created attachment 63034 [details]
Sample document
Comment 11 ooo 2009-06-17 09:16:21 UTC
Not forgotten, but no time in schedule, see dup issue.

*** This issue has been marked as a duplicate of 89232 ***
Comment 12 ooo 2009-06-17 09:16:47 UTC
Closing.