Bug 138426 - Right arrow causes a large unexpected column jump ( part 2 )
Summary: Right arrow causes a large unexpected column jump ( part 2 )
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
Depends on:
Blocks: Calc-large-spreadsheets
  Show dependency treegraph
 
Reported: 2020-11-23 11:09 UTC by Xisco Faulí
Modified: 2023-05-18 15:51 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
sample document (22.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-11-23 11:09 UTC, Xisco Faulí
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Xisco Faulí 2020-11-23 11:09:09 UTC
Created attachment 167499 [details]
sample document

This is a follow-up of bug 131455 found while writing a unittest < https://gerrit.libreoffice.org/c/core/+/106403 >

Steps to reproduce:
1. Open the attached document ( extracted from sc/qa/unit/uicalc/data/tdf126904.ods )
2. Select Sheet2.
3. Right-Click on the Row 9 header and Delete the row.
4. Return to Sheet1 - Right Arrow beyond Column "N" causes jump to "BM".

Reproduced in

Version: 7.1.0.0.alpha1+
Build ID: 2f7b5634487ac3d27777ab12a57089e71ea5216d
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 1 Xisco Faulí 2020-11-23 11:46:03 UTC
I can reproduce this issue back to 

Version: 4.4.0.0.alpha0+
Build ID: 0771823d80abadf8e7f2ccc078f3f9e2c277f8a5
Comment 2 Xisco Faulí 2020-11-23 11:55:27 UTC
@Eike, I thought you might be interested in this issue
Comment 4 Justin L 2020-11-30 09:05:06 UTC Comment hidden (no-value)
Comment 5 Justin L 2020-11-30 09:31:17 UTC
Make sure you look at the prior bug report (and note all of the "fixes to regressions") before investigating this bug. So many aspects of this are fixed in 7.1 beta, but not the specific situation mentioned here. Earlier bug reports indicate that BL is likely a traditional upper limit on columns, so BM is part of the extended range.

Note that the cursor is not supposed to be able to move past row N. Those cells are protected.

Step2. I doesn't matter which other sheet you pick. There is nothing special about Sheet2 or row 9.

So my guess is that when one sheet is extended, all sheets get extended - and now the extended columns have default values and so are unprotected.

I'm leaving this one strictly for the pros who are extending the column space.
Comment 6 QA Administrators 2022-12-01 03:47:12 UTC Comment hidden (obsolete, spam)
Comment 7 Justin L 2023-05-18 15:51:40 UTC
repro 7.6+
No need to do anything other than step 1 now. Right arrow jumps to BM after N right after initial load.