Steps to reproduce: - Fill in some cells. - Set the sheet to password protected. - Save and close the document. - Open document again. - Click one of the filled cells in the password-protected sheet. - Click the formula bar and try to select text from it. Expected behavior: should allow selecting text from there in order to copy it, without having to copy the whole cell along. Actual behavior: does not allow selection within the formula bar.
Works for me Version: 6.2.4.2 (x64) Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc:
Created attachment 152269 [details] Test file
Ok I see, it's possible with edit mode disable.
Created attachment 152270 [details] cannot_select Added a screen capture showing how it looks when I try to select a cell in the attached file.
Could you please paste the info from Help - about LibreOffice ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the information has been provided
Info is as follows: Version: 6.2.2.2 (x64) Build ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d CPU threads: 8; OS: Windows 10.0; UI render: GL; VCL: win; Locale: en-US (en_US); UI-Language: en-GB Calc: threaded
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Bug is still present in the latest version.
I can reproduce this bug in Version: 6.3.0.0.alpha0+ Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87 CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04 Locale: en-US (en_US); UI-Language: en-US Calc: threaded and in LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
Created attachment 152398 [details] another test file
Hi David, Password for "another test file" is "aaa". Default for cell(s) is "protected", as you can see it by selecting Format > Cells > Cell Protection, in a unprotected sheet. If you can select one cell or the cells range B3:B6, copy and paste them in a new sheet, there is no bug. This is the only selection available. You cannot change the cell content, nor therefore select the input line, in a protected sheet, when cells are also protected. Jacques
(In reply to Jacques Guilleron from comment #11) > Hi David, > > Password for "another test file" is "aaa". > Default for cell(s) is "protected", as you can see it by selecting > Format > Cells > Cell Protection, in a unprotected sheet. > If you can select one cell or the cells range B3:B6, copy and paste them in > a new sheet, there is no bug. This is the only selection available. You > cannot change the cell content, nor therefore select the input line, in a > protected sheet, when cells are also protected. > > Jacques But then let's say you want to select only part of what shows in cell. Suppose the cell is a text saying "these are 4 words". I can copy-paste the whole text, therefore copying it is no issue from a security perspective. However, if I only want to copy "these are", then I need to paste the whole text elsewhere and select it again in there - instead, I could just select the part that I want, without modifying the cell, and copy that.
Request is: Cannot select and copy text of protected cells via Formula Bar input line. I can reproduce the behavior with 6.4+ but I'm not sure it should be confirmed. Text of protected cells can be copied from OO as a cell or later from LO via selection in edit mode (double click). I see no need to modify input line. My take is WontFix. I add UX.