https://bugs.documentfoundation.org/show_bug.cgi?id=145609
mailforbugzi...@etlgr.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|1 |0
Status|NEEDINFO |UNCONFIRMED
--- Comment #4 from mailforbugzi...@etlgr.com ---
(In reply to Buovjaga from comment #1)
> (In reply to mailforbugzilla from comment #0)
> > 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)
>
> I don't know how to do step 3.
>
> Best would be, if you created an example document and attached it, so we can
> quickly test.
>
> Set to NEEDINFO.
> Change back to UNCONFIRMED after you have provided the document.
Added an example file, also the step 3 is on Menu Sheet > Sheet Events
--
You are receiving this mail because:
You are the assignee for the bug.
