Bug 152327 - "Select unprotected cells" when no cells are unprotected makes data entry impossible
Summary: "Select unprotected cells" when no cells are unprotected makes data entry imp...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.0.3 release
Hardware: x86-64 (AMD64) All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: implementationError
Depends on:
Blocks: Cell-Sheet-Protection Cell-Selection
  Show dependency tree / graph
 
Reported: 2022-11-30 22:29 UTC by Stéphane Guillou (stragu)
Modified: 2023-09-09 10:58 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
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 Stéphane Guillou (stragu) 2022-11-30 22:29:23 UTC 
Steps:

1. Open Calc
2. Edit > Select > Select unprotected cells (nothing is selected, as expected, given that all cells a protected by default)
3. Enter any data in a cell
4. Click out or press Enter

Actual results:
Data entered in cells instantly disappears.

This issue does not happen when one or more cells are unprotected (with Edit > Cell protection).

Workarounds:
- Saving and reloading the document does restore the ability to add data to cells.
- Selecting a cell range before entering data fixes the issue.

Versions:

Version: 7.4.3.2 / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

A master build from today:

Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 01a3cc1e55034f7703219d4bbb209de7c37bf07b
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Already in:

Version: 6.3.6.2
Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Igor Piltz 2022-12-19 22:41:59 UTC 
Confirmed.
Comment 2 Stéphane Guillou (stragu) 2022-12-20 00:11:36 UTC 
Igor, please don't change the OS to Windows if I have already reported the bug being present on Linux.
What is the reasoning behind changing the severity value?
Finally, please share your version / hardware info when confirming bugs.

Bug also present in:

Version: 6.2.0.0.beta1
Build ID: d1b41307be3f8c19fe6f1938cf056e7ff1eb1d18
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded
Comment 3 Ezinne 2022-12-27 13:53:18 UTC 
Reproducible in:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 4e4a31ac7d920c71e26ca4acd18c11ec2bd015bb
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded
Comment 4 Stéphane Guillou (stragu) 2023-07-26 22:03:26 UTC 
Option appeared in the menu in 6.0 for bug 95883, reproduced in:

Version: 6.0.0.3
Build ID: 64a0f66915f38c6217de274f0aa8e15618924765
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk2; 
Locale: en-AU (en_AU.UTF-8); Calc: group

So likely an implementation error.

Still in recent master build:

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 24d0a62bd75b9a895c419aa165da648ab18f134d
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Gülşah and Eike, you worked on this feature, could you please have a look?