Description: If a selected rang contents protected cells and user tries to move in it by Enter or Tab, the cursor shoot out from the range. Moreover, if the protected cells occupy a place from cursor position to the end of sheet in this row/column, the cursor cannot return into the selected range. Steps to Reproduce: 1. Open the file for tests 2. Select F6:J10 range 3. Press Tab a lot of tims Actual Results: the cursor shoot out from the range Expected Results: The cursor should remain in select range. Reproducible: Sometimes User Profile Reset: No Additional Info: Версия: 5.4.2.2 ID сборки: 22b09f6418e8c2d508a9eaf86b2399209b0990f4 Потоков ЦП: 4; ОС:Linux 4.13; Отрисовка ИП: по умолчанию; VCL: kde4; Локаль: ru-RU (ru_RU.UTF-8); Calc: group I mark as enhancement because the overcoming of protected cells has not been realized before in full. User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0
Created attachment 139642 [details] file for testd
File for tests: http://bugs.documentfoundation.org/attachment.cgi?id=84291
Repro, but not with 3.6.7 Arch Linux 64-bit Version: 6.1.0.0.alpha0+ Build ID: 51291f2352976b2f875197de83486a74795e86a3 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on March 1st 2018 Arch Linux 64-bit Version 3.6.7.2 (Build ID: e183d5b)
Already in 4.3 beta1 (Win 10)
It seems Eike's follow ups to bug 68290 have fixed this! Arch Linux 64-bit Version: 6.2.0.0.alpha0+ Build ID: c290f692dd28094d41dff686f3faa1c4e14b556e CPU threads: 8; OS: Linux 4.17; UI render: default; VCL: gtk3; Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded Built on July 10th 2018