[Libreoffice-bugs] [Bug 139608] cell named range can't be protected

[bugzilla-daemon at bugs.documentfoundation.org]

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

Yam <myriamdidier86 at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |UNCONFIRMED
                 CC|                            |myriamdidier86 at gmail.com
           Assignee|libreoffice-bugs at lists.free |myriamdidier86 at gmail.com
                   |desktop.org                 |
     Ever confirmed|1                           |0

--- Comment #3 from Yam <myriamdidier86 at gmail.com> ---
Created attachment 171460
  --> https://bugs.documentfoundation.org/attachment.cgi?id=171460&action=edit
example

Thanks Timur,
I don't really know how to technically express myself in English (I'm French)
without making any mistakes in meaning, so I try:

- I am creating a range named A1: A3000, for example, named "list". I wish
people could enter data on this range (it remains scalable). So the cells from
A1 to A3000 are not protected.

I am using this named range in many formulas in my workbook (multiple sheets)

My file contains a lot of sheets, a lot of named ranges, and a lot of formulas.
The user must not be able to modify the formulas. I therefore protect all the
cells to be protected, I also protect my entire binder. All of these
protections are OK.

Despite this, if a person goes to the "manage names" area, they can modify the
range I created: either rename it (from "list" to "list", for example): it is
not still very serious, and does not affect the results of the formulas.
But they can also modify the range itself: (from A1: A3000 to A100: A300, for
example). And there: the formulas will work, but all the results will be wrong,
which is even worse.

I've asked the community before, it doesn't appear that cell named range
protection exists yet.

It's easy for you to try on the example file that I upload: on this file, just
go to the name box, and modify the length of the named range. despite all the
protections I put on, you can do it ... and give false results.
I find this to be a very serious security breach.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210427/c531d97c/attachment-0001.htm>