Bug 161431 - Cannot add shapes to partially protected spreadsheet
Summary: Cannot add shapes to partially protected spreadsheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on: 120680
Blocks: Cell-Sheet-Protection
  Show dependency treegraph
 
Reported: 2024-06-05 19:08 UTC by Archisman Panigrahi
Modified: 2024-06-06 14:35 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
File with partially protected cells, from Ask Ubuntu (278.64 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-06-05 19:08 UTC, Archisman Panigrahi
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Archisman Panigrahi 2024-06-05 19:08:11 UTC
Created attachment 194559 [details]
File with partially protected cells, from Ask Ubuntu

Some partially protected spreadsheet (which require filling out only specific cells) require drawing shapes on them.

LibreOffice Spreadsheet cannot draw any cells on those cells. When I try to draw a shape, nothing happens.

However, Microsoft Excel and OnlyOffice can draw shapes on such partially protected spreadsheets, as reported here: https://askubuntu.com/q/1516337/124466

Example spreadsheet: https://github.com/user-attachments/files/15542625/default.xlsx

End goal: Something like this https://i.sstatic.net/cWJKayhg.png

I am attaching a spreadsheet, which requires encircling the Male/Female option using a oval shape. It turns out that it is not possible to do so using LibreOffice.
Comment 1 m_a_riosv 2024-06-05 20:22:49 UTC
Reproducible
Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 32eaef8ddb7acbd8ab40c69acd9b8ca06a26b015
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 2 Eric 2024-06-05 23:41:44 UTC
I confirm the bug on mint mate 21.2, which is based on ubuntu 22.04, and using libre office 7.3.7.2