Bug 67352 - Editing: Permit to change cell width/height on protected cell
Summary: Editing: Permit to change cell width/height on protected cell
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Sheet-Protection
  Show dependency treegraph
 
Reported: 2013-07-26 12:57 UTC by piviul
Modified: 2020-06-28 15:04 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description piviul 2013-07-26 12:57:11 UTC
When you protect a sheet the user can't change the width and the eight of the cells. In my opinion the sheet protection would be concern only to cell content not to the layout of the sheet. 

Any way I would like to ask you if it is possible to add in the dialog for protecting the sheet (Tools->Protect Document->Sheet) two more options:

- Change the width of columns
- Change the height of rows

after (or before) the two options already present:

- Select protected cells
- Select unprotected cells 

Thanks in advance

Piviul
Comment 1 piviul 2017-03-02 07:43:17 UTC
I have changed the status again in new: why you changed it in unconfirmed? Do you mean that you can change column or row dimension in a protect sheet?

Piviul
Comment 2 Johnny_M 2017-03-02 21:41:40 UTC
(In reply to piviul from comment #1)
> I have changed the status again in new: why you changed it in unconfirmed?
> Do you mean that you can change column or row dimension in a protect sheet?
> 
> Piviul

Hi Paviul,
No, I haven't tested it. I changed it because a bug normally starts as "UNCONFIRMED". It's later changed to "NEW" when someone tests it (with the current master code branch) and confirms it (usually the members of the QA team). They check the "UNCONFIRMED" bugs and request for missing information, etc. (Like, e.g, the copy-paste of the content of the menu Help -> About Libreoffice.) Or, if it's not a bug, the may point out what's wrong with the reported use case.
Comment 3 piviul 2017-03-03 08:57:44 UTC
ok, I have revert to unconfirmed the status fo the bug. Thank you

Piviul
Comment 4 Buovjaga 2017-03-04 18:54:45 UTC
Eike: does this request make sense?
Comment 5 piviul 2017-03-06 08:00:31 UTC
(In reply to Buovjaga from comment #4)
> Eike: does this request make sense?
Like MSExcel, normally if you want to protect a sheet you want to protect the content of a sheet not the layout... any way in my opinion if a user can choose to protect only the content or the layout too it's the better way!

Have a great day

Piviul
Comment 6 Eike Rathke 2017-03-06 18:15:39 UTC
A valid request in general. Excel has a more fine grained protection mechanism. There, if "Format columns" is allowed the column width can be changed as well, likewise with "Format rows" the row height. However, Calc doesn't have this granularity yet.
Comment 7 johnks 2020-06-28 15:04:17 UTC
this feature needs to be implemented. i would add, how about allowing a protected cell to overflow with a setting so that it does not cause the XXXXXXXXX which then requires to type in the password, resize the column and save it again.