https://bugs.documentfoundation.org/show_bug.cgi?id=145609
Bug ID: 145609
Summary: When selected cell is in a frozen row/column, the
sheet right click event gets the wrong cell
Product: LibreOffice
Version: 7.2.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The right click event is offset by the frozen rows/columns height/width when
the selected cell is in those frozen ranges and the right clicked cell is not
or vice versa, changing the height/width changes the cell referenced by the
event even when clicked on the same position.
Steps to Reproduce:
1. Freeze one or more rows/columns
2. Write a BASIC macro like this one:
Function RightClick (oEvent As Variant) As Boolean
MsgBox "Right clicked: " & oEvent.AbsoluteName
RightClick = True
End Function
3. Assign the macro to the Sheet's right click event
4. Select a cell inside the frozen range (left click), and right click any cell
outside.
5. The address shown will be from the cell in the position clicked minus total
height/width of frozen cells where the selected cell is. (properties like
oEvent.String, oEvent.CellAddress and probably any other property has data from
the wrong cell)
Actual Results:
get the wrong cell address
Expected Results:
get the correct cell address
Reproducible: Always
User Profile Reset: Yes
Additional Info:
If you freeze 1st row and 1st column and select A1, it will be offset by both,
for B1 only row height and A2 only column width
This also happens in reverse (select outside frozen cells and right click
inside)
Version: 7.1.7.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 4; OS: Linux 5.14; UI render: default; VCL: kf5
Locale: pt-BR (en_US.UTF-8); UI: en-US
7.1.7-1
Calc: threaded
Same thing happens on OpenOffice 4.1.11 and Windows 7 with LibreOffice 7.2.2
--
You are receiving this mail because:
You are the assignee for the bug.
