What is causing strange tabbing behavior in a protected worksheet

asked 2020-11-21 22:52:54 +0100

Bingham JC gravatar image

updated 2020-11-21 23:06:09 +0100

I have a spreadsheet file containing 13 worksheets. The first worksheet contains a summary of information from the remaining 12 plus an area where the user can enter data from an external source. The first sheet has cell A1 (which is merged with B1), and cells C13:N16 set as not protected. The remaining 12 worksheets (one for each month have the following cells set to not protected:

T2:T3 (all)

C4:C34, J4:J34 (Jan, Mar, May, Jul, Aug, Oct, Dec)

C4:C32, J4:J32 (Feb)

C4:C33, J4:J33 (Apr, Jun, Sep, Nov)

The top three rows of the month worksheets are frozen and each month worksheet contains two charts. Protect this sheet is enabled for all the worksheets, Contents of protected cells is enabled, with Allow users to Select protected cells and Allow users to Select unprotected cells both enabled. When I load or reload this spreadsheet file the first time that I tab through the fields in the month named worksheets but not in the first (Summary) worksheet cells in columns BM through BY that are not used are entered after I tab from the rightmost cell on any given row. Once I have tabbed through the 13 cells BM through BY they are not entered again when I tab through the protected cells.

Until a cell in the BY column has been entered selecting a cell in a column before the BM column and pressing TAB will result in the cell on that row in the BM column being entered, however if a cell in a column beyond the BY is selected pressing TAB will not return to the BM column until the file is reloaded.

Also, when I select all of the cells in a month worksheet and disable cell protection then reenable it before I disable cell protection for the T2:T3 and the cells in the C and J columns the behavior of jumping to the BM cell of the current row does not occur.

This seems to be a bug and I would be happy to report it as such but I cannot replicate it in a simple two worksheet spreadsheet which does not have a chart in the second worksheet nor any data in any of the cells.

By the way I am running Version: (x64) Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 4; OS: Windows 10.0 Build 19041.630; UI render: default; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: threaded

edit retag flag offensive close merge delete