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)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: implementationError
: 150109 (view as bug list)
Depends on:
Blocks: Cell-Sheet-Protection
  Show dependency tree / graph
 
Reported: 2021-09-04 05:29 UTC by Elmar
Modified: 2024-02-08 08:47 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
example with inserted image in protected sheet (14.92 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-09-04 05:31 UTC, Elmar 		Details
example ODS (15.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-09-06 09:15 UTC, Timur 		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 Elmar 2021-09-04 05:29:42 UTC 
Description:
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: 7.3.0.0.alpha0+ / 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 

Workaround:
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.
Comment 4 Buovjaga 2023-01-26 09:18:57 UTC 
*** Bug 150109 has been marked as a duplicate of this bug. ***
Comment 5 Buovjaga 2023-01-26 09:25:30 UTC 
Inserting images to unprotected cells in protected sheets was implemented in 26030f92629b310e66b2335c2cec0413bb7ec828 as part of bug 97357. I checked the commit and selecting the image was not possible even then, so this has always been the case.
Comment 6 Mike Kaganski 2024-02-08 08:47:51 UTC 
It definitely is an "implementationError", but completely unrelated to the fix of bug 97357. The important thing is that it is impossible to select a to-cell-anchored image, when its anchor cell is unprotected. This could be arranged in any previous version as well, including OOo 2.4.3: just insert the image to a cell, while the sheet is not yet protected. Then, after protect, it's impossible to select (and otherwise interact with) the image.

The said fix may possibly serve as a rough code pointer.