[Libreoffice-bugs] [Bug 133257] New: The protection icon does not show in front of sheeet name when lock a sheet from LibreOffice BASIC.

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri May 22 03:49:43 UTC 2020


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

            Bug ID: 133257
           Summary: The protection icon does not show in front of sheeet
                    name when lock a sheet from LibreOffice BASIC.
           Product: LibreOffice
           Version: 6.2.8.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: nukool at gmail.com

Description:
Option Explicit
Sub LockThisSheet
    LockSheet("Sheet1")
End Sub

Function LockSheet(passedSheetname) 
    Dim oDoc        As Object : oDoc    = ThisComponent
    Dim oSheet      As Object : oSheet  =
oDoc.Sheets.getByName(passedSheetname)
    Dim pPassword   As String
    If IsMissing(pPassword) Then pPassword = ""
    oSheet.UnProtect(pPassword)
    oSheet.Protect(pPassword)
End Function

Cells are locked as needed but the protection icon does not show in front of
sheeet name unless the sheet is moved to another position.

Steps to Reproduce:
1.Run
Option Explicit
Sub LockThisSheet
    LockSheet("Sheet1")
End Sub

Function LockSheet(passedSheetname) 
    Dim oDoc        As Object : oDoc    = ThisComponent
    Dim oSheet      As Object : oSheet  =
oDoc.Sheets.getByName(passedSheetname)
    Dim pPassword   As String
    If IsMissing(pPassword) Then pPassword = ""
    oSheet.UnProtect(pPassword)
    oSheet.Protect(pPassword)
End Function
2. Cells are locked as needed.
3. The protection icon does not show in front of sheeet name.

Actual Results:
1. Cells are locked as needed.
2. The protection icon does not show in front of sheeet name.
3. The protection icon will show in front of sheeet name if the sheet is moved
to another position.

Expected Results:
The protection icon shows in front of sheeet name.


Reproducible: Always


User Profile Reset: No



Additional Info:
https://ask.libreoffice.org/en/question/245509/lo-basic-calc-the-protection-icon-does-not-show/

-- 
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/20200522/6529384d/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list