Bug 119455 - can't change cellstyles properties (soft format) if a sheet is protected
Summary: can't change cellstyles properties (soft format) if a sheet is protected
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Styles
  Show dependency treegraph
 
Reported: 2018-08-23 15:08 UTC by Oliver Brinzing
Modified: 2023-04-25 04:27 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
protected_sheet_cellstyle (8.73 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-08-23 15:08 UTC, Oliver Brinzing
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Oliver Brinzing 2018-08-23 15:08:29 UTC
Created attachment 144395 [details]
protected_sheet_cellstyle

steps to reproduce:
- open attached spreadsheet (Sheet2 is protected - and hidden)
- try to modify cellstyle "Good" via sidebar/contextmenu/Good/Modify...
- nothing will happen
- expected result: a msgbox should open explaining, that it is not
  possible to change the style, cause a sheet is protected

btw: if one tries to delete the style, a confirmation dialog opens,
selecting [YES] will not delete the style.
Comment 1 raal 2018-09-05 21:36:33 UTC
I can confirm with Version: 6.2.0.0.alpha0+
Build ID: 4b5fcd417587cfb9e6d8b61ecb037ab165eeb5b9
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; 
- try to modify cellstyle "Good" via sidebar/contextmenu/Good/Modify...
- nothing will happen

-------------------------
I can delete style Good in version 6.2
Comment 2 QA Administrators 2019-09-06 05:01:40 UTC Comment hidden (obsolete)
Comment 3 Oliver Brinzing 2019-09-06 05:33:07 UTC
still reproducible with:

Version: 6.4.0.0.alpha0+ (x64)
Build ID: 1c7fdf561bc924741a121439a6cb42f96f285b58
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded
Comment 4 QA Administrators 2021-09-06 03:49:21 UTC Comment hidden (obsolete)
Comment 5 Oliver Brinzing 2021-09-11 15:18:49 UTC
repro  with:

Version: 7.2.0.4 (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded
Comment 6 BogdanB 2023-04-25 04:27:18 UTC
In 7.5 no delete or modify of Good Style is allowed. Modifiy option is active, Delete option inactive.

Version: 7.5.2.1 (X86_64) / LibreOffice Community
Build ID: e8bf3b441b8370f8440b0339fd9490765a8d57ca
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded