[Libreoffice-bugs] [Bug 125106] New: Calc Cell Protection - unable to change protection state of a mixed group of cells

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125106

            Bug ID: 125106
           Summary: Calc Cell Protection - unable to change protection
                    state of a mixed group of cells
           Product: LibreOffice
           Version: 6.2.0.1 rc
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rosma at uk2.net

Description:
With the sheet protection turned off, selecting a group which contains both
protected and unprotected cells, then trying to use Format Cells - Cell
Protection to either change all cells to the protected or unprotected state
does not work.

The Protected box in the Cell Protection menu is fixed as a horizontal dash, in
earlier versions of LibreOffice this could be toggled between ticked and
cleared so all cells were changed to the same protection state.

Steps to Reproduce:
1. Use Tools and untick Protect Sheet...
2. Select some cells which have been protected and some which are unprotected.
3. Select Format Cells.. and then Cell Protection.
4. Click on the Protected box.

Actual Results:
The Protected box shows a fixed horizontal dash (-). This does not change if
you keep clicking on it.

Expected Results:
When you repeatedly click on the Protected box this cycles through a clear
state (all cells unprotected), a dash (some cells in both states) and a ticked
state (all cells protected).


Reproducible: Always


User Profile Reset: Yes



Additional Info:
All of the boxes - Hide All, Protected, Hide formula and Hide when printing -
show the same problem.

Earliest release version with the problem is
Version: 6.2.0.1
Build ID: 0412ee99e862f384c1106d0841a950c4cfaa9df1
CPU threads: 2; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); UI-Language: en-GB
Calc: threaded

Problem still exists on the two versions shown below.

Version: 6.2.4.0.0+
Build ID: df02927207ad19532f5c1ac5a5cf745559e47c22

Version: 6.3.0.0.alpha0+
Build ID: 96ab20756316b25b7f2343a15596bc5114ea5a68

Version 6.1.5.2 works correctly as expected.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190503/6821f360/attachment-0001.html>