Bug 139608 - Calc Named range: add option to be protected with sheet
Summary: Calc Named range: add option to be protected with sheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Sheet-Protection
  Show dependency treegraph
 
Reported: 2021-01-14 14:13 UTC by Yam
Modified: 2021-04-29 12:41 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
example (16.04 KB, text/plain)
2021-04-27 16:44 UTC, Yam
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Yam 2021-01-14 14:13:15 UTC
Description:
I need to protect somme of the cell named ranges I create (as administrator). Even with protections on cells, even with protection on file, users can always modify the cell named ranges, doing the command "manage the names". 
Could it be possible to add a protection for that ?


Actual Results:
no protection on cell named ranges. 

Expected Results:
being able to choose to protect (or not) cell name ranges when it's created.


Reproducible: Always


User Profile Reset: No



Additional Info:
I think excel does, already
Comment 1 Xisco Faulí 2021-02-09 12:14:53 UTC Comment hidden (obsolete)
Comment 2 Timur 2021-04-26 13:38:35 UTC Comment hidden (obsolete)
Comment 3 Yam 2021-04-27 16:44:01 UTC
Created attachment 171460 [details]
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.
Comment 4 Yam 2021-04-27 16:44:18 UTC Comment hidden (me-too)
Comment 5 Timur 2021-04-29 12:41:32 UTC
I confirm as enhancement. 
Guess there should be a checkbox "Protected" in Manage Names / Range Options.