https://bugs.documentfoundation.org/show_bug.cgi?id=115081

Thomas Lendo <thomas.le...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |er...@redhat.com,
                   |                            |tietze.he...@gmail.com

--- Comment #3 from Thomas Lendo <thomas.le...@gmail.com> ---
Today I don't see any possibility to avoid overwriting a cell but I'm no Calc
expert. Protecting a sheet and its cells also protects to do anything with the
cells, including inserting valid content.

A quick web search doesn't help. Also I couldn't reproduce with MSO Excel 2013
the assertion [1] that Excel can handle what you want.

What I can imagine in the future is an exception in the "Protect Sheet" dialog
[2] for Validity and similar functions so that the user can can insert content
with the Validity selection list in protected cells but nothing else. I don't
know if this is possible in LibreOffice or in the ODF specification and if this
is a wanted feature enhancement.

@Heiko, Eike - may I ask for your opinion?

[1] https://forum.openoffice.org/en/forum/viewtopic.php?p=47780#p47780
[2] https://wiki.documentfoundation.org/File:NewSheetProtectionOptions54.png

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to