In Excel, I can still draw on the unprotected cells, but in OnlyOffice cannot

[kuchaguangjie]

This issue is unique.

• [X] I have used the search tool and did not find an issue describing my bug.

Operating System

Linux (DEB package)

Expected Behavior

https://github.com/user-attachments/files/15542625/default.xlsx try this file, there is a male / female options which are protected cells, I can draw circle on them on windows, but can't draw anything anywhere with libreoffice calc, others tested with OnlyOffice, also can't.

Actual Behavior

Can't draw anywhere on sheet with cells partly protected.

Reproduction Steps

No response

Additional information

No response

[kuchaguangjie]

Refer: https://askubuntu.com/questions/1516337/how-to-add-a-circle-around-a-text-in-a-spreadsheet-in-ubuntu-22-04

[Rita-Bubnova]

@kuchaguangjie, Does this issue actual in the current stable version of DesktopEditors (8.0)?

[kuchaguangjie]

@kuchaguangjie, Does this issue actual in the current stable version of DesktopEditors (8.0)?

I don't know, from the askubuntu post above, 2 others tested it, and got the same issue.

I provided a sample excel in the question, anyone can simply download & test in a minute.

[archisman-panigrahi]

I confirm that this issue is present in ONLYOFFICE 8.0.1.31 (deb) in Ubuntu 24.04.

(Clarification: OP reported version 7.3.7.2, which is his LibreOffice version according to his Ask Ubuntu post, and perhaps he mistakenly wrote the LibreOffice version in this bug tracker. According to the Ask Ubuntu post, both OnlyOffice and LibreOffice have this bug, and I will shortly open a bug report to the LibreOffice bug tracker).

@kuchaguangjie Please edit and remove information specific to LibreOffice (e.g. the version number) in your original post.

[rsnegirev]

Hi @kuchaguangjie @archisman-panigrahi

You both mean that you tried to insert Shape like this but you can't. Right?

I just checked it on ONLYOFFICE 8.0.1.31 (deb) in Ubuntu 22.04 and it works.

[kuchaguangjie]

Hi @kuchaguangjie @archisman-panigrahi

You both mean that you tried to insert Shape like this but you can't. Right?

I just checked it on ONLYOFFICE 8.0.1.31 (deb) in Ubuntu 22.04 and it works.

Yes, that's what I mean, I can't do it with libre office calc 7.x version.

[rsnegirev]

With LibreOffice yes, you can't. But it works in ONLYOFFICE, isn't it?

[archisman-panigrahi]

I previously did not test OP's spreadsheet but tested with my own spreadsheet which has some protected and some unprotected cells, and all shapes are greyed out (see attached picture).

Here is my example spreadsheet (created with ONLYOFFICE) Book1.xlsx . You can edit the contents of the unprotected cells, but there is no way to add shapes.

Interestingly, I can add shapes to OP's spreadsheet (the one written in Japanese), just like this.

[archisman-panigrahi]

@kuchaguangjie This is ONLYOFFICE bug tracker, please don't mention issues with Libreoffice here.

Although OP's spreadsheet does not have an issue with ONLYOFFICE, the issue seems to be present in ONLYOFFICE in some form, see my comment above.

[rsnegirev]

@archisman-panigrahi

Here is my example spreadsheet (created with ONLYOFFICE) Book1.xlsx . You can edit the contents of the unprotected cells, but there is no way to add shapes.

Yes, that's right. It depends of the protection settings. In this case you should choose this one check-box:

In Excel it works the same.

Here is my file (from ONLYOFFICE) where you can add a shape, or a picture, or draw something: adding_shapes.xlsx

[rsnegirev]

So @kuchaguangjie do you have a problem with adding shapes in your file in the ONLYOFFICE or it's only the Libre Calc?

[archisman-panigrahi]

Yes, that's right. It depends of the protection settings. In this case you should choose this one check-box:

Thank you for the clarification, and sorry about the confusion!

[kuchaguangjie]

So @kuchaguangjie do you have a problem with adding shapes in your file in the ONLYOFFICE or it's only the Libre Calc?

I only tested on libre calc, don't have onlyoffice installed.

[archisman-panigrahi]

:facepalm: :facepalm: :facepalm: :facepalm: I guess we can close the issue.