Description: In a partially protected sheet, a right arrow causes a large and unexpected column jump into a protected area of the sheet. This result is virtually indiscernible from the behavior of Bug 126904. The main difference being that the unexpected behavior does not occur upon first opening of the sheet, but does occur after execution of a particular macro. I will describe that step below. Steps to Reproduce: 1.Open the workbook to Sheet 1 (in TimeSpreader file). 2. Press - Right Arrow to column "N". Further Right Arrows do nothing (expected). 3. Execute "End of Day" macro, then return to Sheet1. 4. Right Arrows beyond column "N" cause a large jump to column "BM" (unexpected) Actual Results: Right Arrows beyond column "N" cause a large jump to column "BM" (unexpected) after executing the "End of Day" macro. This end result is very much like the previous Bug 126904. Expected Results: Right arrows beyond column "N" should be ignored (i.e. do nothing). Reproducible: Always User Profile Reset: No Additional Info: The unexpected result occurs in the versions listed below, but NOT in v6.2.8.2 Version: 6.4.2.2 (x64) Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: threaded Version: 6.4.2.2 Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3 CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded Version: 7.0.0.0.alpha0+ (x64) Build ID: c63148ba139bd6b9ae7a0f9e24e51f29e5370963 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: threaded
Created attachment 158842 [details] Partially protected ODS workbook with macros. This file can demonstrate the bug per the "steps to reproduce" provided.
It's your macro and protected, please test in the macro when the modification happens, and right places to find help: https://ask.libreoffice.org/en/questions/ https://ask.libreoffice.org/es/questions/
Created attachment 158843 [details] This is the full text of the macro that triggers the issue. This file is the full text of the macro that triggers the issue. I hope it will be useful in diagnosing the problem. While it seems to have been suggested that the macro is at fault, this exact macro works in LO version 6.2.8.2 and earlier without causing the problem. If it seems likely that I will have to reconstruct and test numerous macros every time there is a new LO release, I hope someone will at least acknowledge that so that I can decide whether or not it makes sense to continue investing time in this.
Here is a way to trigger the unexpected behavior without using any macros whatsoever: 1. Open the workbook. 2. Select Sheet2. 3. Right-Click on the Row 9 header and Delete the row. (Rows below 7 are not protected and intentionally deletable) 4. Return to Sheet1 - Right Arrow beyond Column "N" causes jump to "BM".
Also: I find the tone and content of Comment 2 to be needlessly glib, dimissive and inappropriate.
I can confirm the behaviour of Comment 5, but is this a bug? LO jumps to the first non protected cell in that line, which is BM. If you protect the whole row then no jump occurs.
(In reply to Daniel Baran from comment #4) > Here is a way to trigger the unexpected behavior without using any macros > whatsoever: > > 1. Open the workbook. > 2. Select Sheet2. > 3. Right-Click on the Row 9 header and Delete the row. > (Rows below 7 are not protected and intentionally deletable) > 4. Return to Sheet1 - Right Arrow beyond Column "N" causes jump to "BM". Reproduced in Version: 7.0.0.0.alpha0+ Build ID: 9163755e9f64a0b1dd5f2090e0702c19e31c12c9 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded
Regression introduced by: https://cgit.freedesktop.org/libreoffice/core/commit/?id=7282014e362a1529a36c88eb308df8ed359c2cfa author Noel Grandin <noel.grandin@collabora.co.uk> 2019-02-01 15:15:16 +0100 committer Mike Kaganski <mike.kaganski@collabora.com> 2019-04-05 13:43:52 +0200 commit 7282014e362a1529a36c88eb308df8ed359c2cfa (patch) tree 2776ad9601f494330076ac58c08554e719c6ab3a parent df30a4515b1303b0891baa53754fa9b3e47e0c02 (diff) tdf#50916 Makes numbers of columns dynamic. Bisected with: bibisect-linux64-6.3 Adding Cc: to Noel Grandin
Greetings, I've been following this bug since 126904. As a matter of fact I first reported this as 127246, lately merged to the already assigned 126904 by Daniel Baran. Not far from now I got a mail saying the bug was sorted out and the fix would be available in a developing alpha version. I`m afraid the bug still there. I had one of my spreadsheets installed in a Linux Mint machine of a friend and the problem appeared there. He was using the latest stable version of LibreOffice (6.4.3). I then copied my spreadsheets to my own Linux machine that had an older version (6.3.0) and the same bug. I tried to get it updated to the last developing versions so I find one without the problem. No joy. :( From the version 6.4.4 to the latest 7.0.0 alpha-1, all of them had the bug, so I had to uninstall them and get version 6.2.8 from the archives to have a working set of LibreOffice for Linux as I have for Windows 7. I'm not sure if I send a sample to you on the bug 127246 thread, but I'm sure those sent by Daniel Baran should suffice. Hope you get it sorted soon. Thanks for your efforts.
Hello All, Hoping for some news on this one. Stay well and best regards, DB
Steps in comment #4 no longer cause jump to BM column since: https://git.libreoffice.org/core/+/0ae68cfb76ea38ffefb79eb27e2329475f8bc71b author Noel Grandin <noelgrandin@gmail.com> Sat Sep 12 18:21:44 2020 +0200 committer Xisco Fauli <xiscofauli@libreoffice.org> Mon Sep 14 12:17:22 2020 +0200 tdf#133327 fix calc loading background color with many cols Bibisected with bibisect-linux-64-7.0 *** This bug has been marked as a duplicate of bug 133327 ***
Not understanding this status change (comment 11). The behavior described in comment 4 is still present when I test on the following: Version: 6.4.7.2 (x64) Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: default; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: threaded Version: 7.1.0.0.alpha1+ (x64) Build ID: 418c63dff5db2005bbc4dbfc92b56778f89cea8b CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
When I test on Linux, the problem remains there also. (steps in comment 4) Version: 6.4.7.2 Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded
Further testing on a second machine seems to validate the fix in 6.4.7 (Windows) I will continue testing on other machines and report back.
I can now report - Works for me! After testing on multiple machines, I am no longer seeing this bug. Version: 6.4.7.2 (x64) Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: default; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: threaded I was seeing it initially (comments 12 & 13), but repeating the test several hours later, I could not trigger the bug again. I do not have any idea as to why the result changed without any intervening steps. Sorry if the "false positives" caused any distraction. Much thanks to all of you who have worked on this.
(In reply to Gabor Kelemen from comment #11) > Steps in comment #4 no longer cause jump to BM column since: > > https://git.libreoffice.org/core/+/0ae68cfb76ea38ffefb79eb27e2329475f8bc71b > > author Noel Grandin <noelgrandin@gmail.com> Sat Sep 12 18:21:44 2020 +0200 > committer Xisco Fauli <xiscofauli@libreoffice.org> Mon Sep 14 12:17:22 2020 > +0200 > > tdf#133327 fix calc loading background color with many cols > > Bibisected with bibisect-linux-64-7.0 > > *** This bug has been marked as a duplicate of bug 133327 *** Hi Gabor, Thanks for bisecting this. I've created a unittest for this in https://gerrit.libreoffice.org/c/core/+/106403 However, while writing the unittest, I found the issue is still reproducible with sc/qa/unit/uicalc/data/tdf126904.ods. I'll create a follow-up report
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b2bfe6c18aeb2530a8d1e1c4336707b1fcd5715a tdf#131455: sc_uicalc: Add unittest It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.