Apache OpenOffice (AOO) Bugzilla – Issue 67816
Calc overwrites hidden cells
Last modified: 2006-07-27 08:13:39 UTC
Hi. While using autofilters, I realized that calc wont respect hidden cells. If I select some cells using the autofilter, make a change on one cell and copy that cell down, Calc will overwrite the hidden cells also. I think Calc should copy only to visible cells by default to prevent data loss and because it is the logical functionality. Also, it would be great if there was an option to select "All cells" or "only visible cells" or "only invisible cells".
Created attachment 38057 [details] file to try it on
double to Issue 33851 *** This issue has been marked as a duplicate of 33851 ***
closed double. Please use the query facilities before submitting Issues