The return value is set if the specified worksheet is protected.

CALL METHOD spreadsheet->get_protection
       EXPORTING sheetname = sheetname
                 no_flush  = no_flush
       IMPORTING protect   = protect
                 error     = error
                 retcode   = retcode.