Summary: | "Select Unprotected Cells" does not work if selection active | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Timur <timur> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | jluth, stephane.guillou |
Priority: | medium | Keywords: | implementationError |
Version: | 6.0.0.3 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=151752 https://bugs.documentfoundation.org/show_bug.cgi?id=95883 https://bugs.documentfoundation.org/show_bug.cgi?id=139883 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 107450, 109139 | ||
Attachments: |
Sample ODS
unprotected and protected cells mixed where we want to erase only the unprotected ones by selecting all the cells |
Description
Timur
2024-01-15 10:53:40 UTC
I don't understand what the expectation is. - The sample document's range A4:A6 has cell protection on (the default), and Sheet Protection is not turned on anyway, so to me it makes perfect sense that nothing is selected. - Is the fact that row 5 relevant or not? Created attachment 192317 [details]
Sample ODS
Yes, sample was not OK. Please use this one with cells A14 and A16 unprotected. Mark 3 cells in range A14-A16 and Select unprotected cells, should mark A14 and A16.
IMO, Sheet Protection is not relevant here for select and copy, as Unprotected status is for cells. Sample has both Unprotected and Protected sheet for test.
Row in the middle is not hidden now and that is not relevant.
Thank you for the updated document. I reproduce as described, it's true it's unexpected. So the issue is that the command does not work if there is a range selected. I also expect what you expect: it should select the unprotected cells in the active selection (and still select _all_ unprotected cells in the sheet if there is no active selection). Same 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 let's mark as "implementation error": Created attachment 194554 [details]
unprotected and protected cells mixed where we want to erase only the unprotected ones by selecting all the cells
I am proposing a new file for testing to better visualize the request.
|