- Use sample attachment 183258 [details] from bug 151752. - Select A4-A6 - Edit-Select-Select Unprotected Cells - Try to copy and paste - see selection of only the first cell. Select Unprotected Cells from bug 95883 was meant to select all such cells in a sheet (to delete), prior select does not work, we cannot select in a range. This is enhancement request to make possible copy of unprotected cells from a selected range. (MSO can do it via code or manual selection or Find-Format-Locked or add-on.)
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.