Summary: | Calc Named range: add option to be protected with sheet | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Yam <myriamdidier86> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | myriamdidier86, xiscofauli |
Priority: | low | ||
Version: | 7.0.4.2 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=141913 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 107450 | ||
Attachments: | example |
Description
Yam
2021-01-14 14:13:15 UTC
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone else confirms it. Please write exact steps. Do not assume it's self evident, not all use it. 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.
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. I confirm as enhancement. Guess there should be a checkbox "Protected" in Manage Names / Range Options. |