Calc: Formula bar gets cleared when focused in protected cells.

[gohrner]

Describe the bug If a Calc cell is protected, the formula bar get cleared if focused, instead of showing the cell's content as read-only text.

To Reproduce

1. Open the attached test.ods in CODE
2. Click on Cell E7
3. Click at the formular bar.

Expected behavior Formula bar shows "Test" in readonly style.

Actual behavior Formula bar becomes empty on click.

[Ezinnem]

Thanks for reporting.

I can reproduce the issue on COOLWSD 22.05 version

[hoffmannlin]

this is a serious security problem,

which version can be repaire or is the previous version normal?

[gohrner]

this is a serious security problem,

It's only the display in the formula bar which does not match the cell's contents. No data is damaged.

So I don't think it's a security or data safety issue, however it's still somewhat annoying for sure. :)

[hoffmannlin]

sorry, i have difference problem,

i can not saw tool > protecte sheet

then i can not protecte some cell to disable modify

so i means is a security problem my version is 22.05.10.1

[timur-g]

This is minor issue with no damage, I'd rather call it enhancement to give infomration like in Core: "Protected cells cannot be modified". As explained, not a security problem. Protect is enhancment issue #551.

[timur-g]

After fixes in https://github.com/CollaboraOnline/online/pull/6768 click to Formula bar gives "Protected cells cannot be modified" which is good and the main issue here. Formula bar still remains empty whcih is not grave, but it should not be,

[cornouws]

• Indeed there is a pop-up
• the formula bar in my case shows the content of the adjacent cell (see screenshot) seen in version COOLWSD version: 23.05.11.1snapshot (git hash: 3deafda) LOKit version: Collabora Office 23.05.11.20240512 (git hash: 1f99302)

[hfiguiere]

Things have have changed since the issue was filed: we can now protect/unprotect the sheet, which enable the cell protection. Note that is the file was already like that, it didn't change.

The cell protection tab was removed sometime and added back with sheet protection.

Now selecting a protected cell and then trying to edit in the formula bar delete the content of the formula bar. It doesn't delete the data though. This is also not the behaviour in LibreOffice which should help us pinpoint where the problem it.