https://bugs.freedesktop.org/show_bug.cgi?id=63649

mariosv <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WORKSFORME
                 CC|                            |[email protected]

--- Comment #1 from mariosv <[email protected]> ---
Hi AriF,

I think to avoid your issue, you can address unprotected cells, with function
like OFFSET(), INDEX() or even INDIRECT().
OFFSET() is a good option, you can reference from a protected cell to a
protected and hidden column near the unprotected cells.
To get the value in C4 you can use OFFSET(A4;0;2), if A is a hidden and/or
protected column the user cannot cut on it, and cut C4 does not modify the
formula.

I think this is not bug, if you are not agree please REOPEN it.

Maybe you want a new functionality, please open a new bug with the second
option importance as "enhancement", change the title with a brief summary with
your request, explaining in the comment what you want achieve.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to