Bug 136003 - PROTECT SHEET: Can't delete rows, despite of allow to deletes
Summary: PROTECT SHEET: Can't delete rows, despite of allow to deletes
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Sheet-Protection
  Show dependency tree / graph
 
Reported: 2020-08-22 00:35 UTC by sawakaze
Modified: 2020-09-06 15:52 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
ScreenCast (888.25 KB, video/x-matroska)
2020-08-22 00:36 UTC, sawakaze 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description sawakaze 2020-08-22 00:35:31 UTC 
Description:
following steps, I can't delete row on sheet.
detail is screencast.

Steps to Reproduce:
1. open calc
2. Tools - Protect Sheet
-> launch Protect Sheet dialog
3. check "Delete rows" to ON 
4. click OK
5. open Menu - Sheet - Delete Rows

Actual Results:
Menu - Sheet - Delete Rows is gray out
user can't delete rows on sheet

Expected Results:
Menu - Sheet - Delete Rows is not gray out
user can delete rows on sheet


Reproducible: Always


User Profile Reset: No



Additional Info:
I confirm 

Version: 7.1.0.0.alpha0+
Build ID: <buildversion>
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2020-08-19_02:56:36
Calc: threaded
Comment 1 sawakaze 2020-08-22 00:36:14 UTC 
Created attachment 164545 [details]
ScreenCast
Comment 3 Roman Kuznetsov 2020-08-26 06:35:40 UTC 
(In reply to himajin100000 from comment #2)
> https://opengrok.libreoffice.org/xref/core/officecfg/registry/data/org/
> openoffice/Office/UI/CalcCommands.xcu?r=7b480207#1054
> 
> https://opengrok.libreoffice.org/xref/core/sc/sdi/cellsh.sdi?r=02cac3ee#123
> 
> https://opengrok.libreoffice.org/xref/core/sc/source/ui/view/cellsh.
> cxx?r=e67657d5#123
> 
> there is no SID_DEL_ROWS in switch statement.
> 
> therefore bEditable is important.
> 
> https://opengrok.libreoffice.org/xref/core/sc/source/ui/view/cellsh.
> cxx?r=e67657d5#313
> 
> https://opengrok.libreoffice.org/xref/core/sc/source/ui/view/cellsh.
> cxx?r=e67657d5#316
> 
> https://opengrok.libreoffice.org/xref/core/sc/source/ui/view/cellsh.
> cxx?r=e67657d5#106
> 
> https://opengrok.libreoffice.org/xref/core/sc/source/core/data/table2.
> cxx?r=75f398b2#2428
> 
> while the menu items like FID_INS_ROWS_BEFORE relies on IsEditActionAllowed
> 
> https://opengrok.libreoffice.org/xref/core/sc/source/ui/view/cellsh.
> cxx?r=e67657d5#241

So can you fix it?
Comment 4 himajin100000 2020-09-06 15:52:37 UTC 
https://gerrit.libreoffice.org/c/core/+/102115