Bug 144292 - Cannot select and adjust image in unprotected cell of protected sheet
Summary: Cannot select and adjust image in unprotected cell of protected sheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Cell-Sheet-Protection
  Show dependency treegraph
Reported: 2021-09-04 05:29 UTC by Elmar
Modified: 2021-09-06 09:15 UTC (History)
0 users

See Also:
Crash report or crash signature:
Regression By:

example with inserted image in protected sheet (14.92 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-09-04 05:31 UTC, Elmar
example ODS (15.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-09-06 09:15 UTC, Timur

Note You need to log in before you can comment on or make changes to this bug.
Description Elmar 2021-09-04 05:29:42 UTC
If I paste an image (in a form it may be a signature gif or jpg) in a protected sheet, and I want to resize it, I cannot find a way to select the image.

A suggestion on the internet help says to doubleclick the image in the Sidebar Navigator - but that is protected as well.

Steps to Reproduce:
1.open protect WB
2.select an unprotected cell
3.edit/insert image
4.try to select the image to resize it

Actual Results:
Cannot select the image

Expected Results:
It is difficult, even in an unprotected sheet. Maybe there should be a context menu item when in the cell where it is anchored;
 or an option in Edit/Select;
 or the Navigator should have the image unprotected (so doubleclick works)
All three should be allowed abut at least the first two.

Reproducible: Always

User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Comment 1 Elmar 2021-09-04 05:31:29 UTC
Created attachment 174769 [details]
example with inserted image in protected sheet
Comment 2 Elmar 2021-09-04 05:35:48 UTC
Version: / LibreOffice Community
Build ID: d5ade739771ddf06cc7ee6d4af15672bfcf09ed6
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-09-01_02:56:07
Calc: threaded

NOTE: Same occurs in Calc v6.4 

remove the protection in xml if possible
make a tiny image to insert
Comment 3 Timur 2021-09-06 09:15:46 UTC
Created attachment 174809 [details]
example ODS

I think this is a bug, if image is in unprotected cell.
Attached was XLSX but regardless, same happens with ODS, that I attach now.