Summary: | Cannot select and adjust image in unprotected cell of protected sheet | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Elmar <roberg> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | ilmari.lauhakangas, layolayo |
Priority: | medium | Keywords: | implementationError |
Version: | Inherited From OOo | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 107450 | ||
Attachments: |
example with inserted image in protected sheet
example ODS |
Description
Elmar
2021-09-04 05:29:42 UTC
Created attachment 174769 [details]
example with inserted image in protected sheet
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 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.
*** Bug 150109 has been marked as a duplicate of this bug. *** 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. 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. |