In LO Calc: Right click on a row number shows expected pull down menu, but only on
the first instance after opening the file. On the second instance several commands are no longer present. For example, "Delete Rows" disappears entirely.
This is a partially protected sheet, but the rows in question should allow deletion.
This problem does not occur in LO v6.2.5.
Steps to Reproduce:
1.Open the file and select "Sheet2".
2.Right-click on row 9 - "Delete Rows" option is seen.
3.Press "Escape" to close the menu, then right-click again - "Delete Rows" option is gone.
Same as above!
The "Delete Rows" option should remain present in the menu and functional as a command.
User Profile Reset: Yes
OpenGL enabled: Yes
Created attachment 153368 [details]
Partially protected spreadsheet file with macros.
The attached file can demonstrate the behavior described in the bug report.
This file is publicly available on my website, and therefore has no associated privacy concerns.
I reprodce with
LO 220.127.116.11.alpha0+ Build ID: f6a64f9bdce16cc18bb086b0de894fba7e1538c3
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win;
Locale: fr-FR (fr_FR); UI-Language: en-US Calc: CL
and above versions
But not with
LO 18.104.22.168.alpha0+ Build ID: 1aa37aa6bee19099b57555a6d839992b054aa405
CPU threads: 2; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@42, Branch:master, Time: 2018-09-23_10:17:54
Locale: fr-FR (fr_FR); Calc: threaded
Thank you to have reported it.
This seems to have begun at the below commit.
Adding Cc: to Noel Grandin ; Could you possibly take a look at this one?
c5a668eb55c0000fe9b5ac32b4bf250325e12a67 is the first bad commit
Author: Jenkins Build User <firstname.lastname@example.org>
Date: Fri Apr 5 17:05:02 2019 +0200
author Noel Grandin <email@example.com> 2019-02-01 15:15:16 +0100
committer Mike Kaganski <firstname.lastname@example.org> 2019-04-05 13:43:52 +0200
commit 7282014e362a1529a36c88eb308df8ed359c2cfa (patch)
parent df30a4515b1303b0891baa53754fa9b3e47e0c02 (diff)
tdf#50916 Makes numbers of columns dynamic.
Testing on both 6.3.4 and 6.4.0 seems to indicate this issue has been corrected.
(at least in my specific test workbook)
Maybe someone can do additional independent confirmation.
Sorry. Due to the macros (?) I can't use mouse right-clicks or left-clicks on row and column headers in the attached file at all.
Version: 22.214.171.124 (x64)
CPU-Threads: 4; BS: Windows 10.0; UI-Render: GL; VCL: win
Created attachment 158287 [details]
Macro-Enabled Workbook with Partially Protected Sheets
This is an newer version of the original test case for this bug.
Oddly, I do not reproduce the "no clicks" scenario on the same file on my Windows 10 / LO 126.96.36.199.
It's not clear to me if this bug occurs in workbooks other than mine (i.e. your macro suggestion), though it does not occur when in LO 188.8.131.52 with the same macros.
However, I have an updated version of the workbook (attached with this post).
This file does not seem to have issues with deletion of unprotected rows in 184.108.40.206.
I hope you will consider testing this one for comparison (especially regarding the "no-clicks" issue, which seems to be a new problem).
Thomas, just now realizing that you were probably working on "Sheet 1" of the workbook. That has some protected cells in all the rows, and so the "no-click" issue
you are seeing is expected. The original bug issue applies to "Sheet 2" only, specifically
for Rows 8 and below. Those rows are fully unprotected and should be deletable via a
right-click on the row number. Previously, the right-click "delete row" option was not
showing in the drop-down list. As of now, it appears to be working as expected with the
Windows 10 Pro, LO 220.127.116.11 (x64), and the attached workbook (3-1-2020).
It seems like this bug may be resolved if you can confirm per above.
Sorry for any confusion (and this rather long post).
Daniel, thanks for the new file and description.
I can reproduce that there are missing some commands in the right-click menu of row 8 and above. I assume this is because of some kind of protection on sheet/cells. Cut and paste are also not working (but deactivated intead of missing).
As you are the bug reporter, it is OK if you close this bug as WORKSFORME if you think that the original problem is not available anymore.