[Libreoffice-bugs] [Bug 132057] New: Calc jumping to "protected cells" during data entry in spreadsheets

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132057

            Bug ID: 132057
           Summary: Calc jumping to "protected cells" during data entry in
                    spreadsheets
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: steven at sbennettsolutions.com

Description:
I have built several spreadsheets and set certain cells to be selected for
input. Recently, when pressing enter or tab, cell focus has jumped to protected
cells outside the format area. I have checked the formatting several times and
have gone so far as to select all (except desired area), clear contents, delete
entire columns and rows. The problem still remains, when entering data into the
spreadsheets, using enter or tab goes "off sheet" to undesirable locations
which is extremely annoying. This "problem started a few months ago (used to
work fine). Hoped the recent upgrade would fix the issue, however it has not. I
am using Libreoffice 6.4.2.2 in Windows 10. The problem persists on both my
desktop and my laptop so it is not machine specific. Thanks in advance for any
help or insight you may be able to provide.

Steps to Reproduce:
1.Create sheet and format desired cells as unprotected
2.Protect sheet
3.enter data into first first data cell press enter or tab

Actual Results:
After selecting the first unprotected cell in the first row, entering data and
pressing "Enter" or "Tab", focus moves to next unprotected cell to the right
for data entry if in the same row. If there are no more "unprotected cells in
the current row, pressing "Enter" or "Tab" will jump to an "protected cell"
outside the formatted sheet area. It will keep selecting cells to the right for
several cells, then jump back into the formatted area at which time it will
then stay within the formatted area until the document is closed and reopened.
If I select the first cell in the top row and hold the "Enter" key until it
runs through selecting "outside the formatted area" and returns to the
unprotected cells, I can then begin entering data and jump to each cell in
sequence as expected.
The issue reasserts itself every time the document is opened for data entry.

Expected Results:
select first cell for data entry, move to next unprotected cell to the right
for data entry on "Enter". Continue to the right until last unprotected cell is
entered, then move to the first unprotected cell in the next row for data
entry. Continue until entering data in all cells across each row is complete,
then return to first data cell in the top row when pressing "Enter".


Reproducible: Always


User Profile Reset: Yes



Additional Info:
If I select the first cell in the top row and hold the "Enter" key until it
runs through selecting "outside the formatted area" and returns to the
unprotected cells, I can then begin entering data and jump to each cell in
sequence as expected.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200411/99c8cab4/attachment.htm>