Issue 67816

Summary:

Calc overwrites hidden cells

Product:

Calc

Reporter:

phervas <phervas>

Component:

editing

Assignee:

spreadsheet <spreadsheet>

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 2.0.3

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
file to try it on	none

Description phervas 2006-07-26 23:56:58 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".

Comment 1 phervas 2006-07-27 00:03:10 UTC

Created attachment 38057 [details]
file to try it on

Comment 2 frank 2006-07-27 08:13:03 UTC

double to Issue 33851

*** This issue has been marked as a duplicate of 33851 ***

Comment 3 frank 2006-07-27 08:13:39 UTC

closed double. Please use the query facilities before submitting Issues