Calc cell as validity range selected pick icon persists?

asked 2020-02-21 15:45:11 +0200

OldEng gravatar image

I select a cell that is configured as a pick list. The cell gets the focus and displays a down triangle icon to its right. I click on the pick icon and a list is displayed. That works fine. If I leave the cell selected with the pick icon displayed and change to a different sheet then the icon is still displayed on the different sheet. I'm using 6.4.0. I reinstalled it and also tried 6.3.1. Same issue. Anyone know how to fix?

edit retag flag offensive close merge delete


This is a very old bug doing no harm. I never searched for a related bug report. You may file one to Select anything in the second sheet and the triangle disappears

Lupp gravatar imageLupp ( 2020-02-21 16:08:36 +0200 )edit

Thanks. I'll submit it.

OldEng gravatar imageOldEng ( 2020-02-21 16:24:40 +0200 )edit

I submitted the bug report. I also have a work around for my sheet. I use the Activate Document sheet event on all sheets assigned to the function below. It forces a focus change that removes the down arrow icon.

Sub uSelectHome dim document as object dim dispatcher as object dim args1(0) as new

document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("") args1(0).Name = "ToPoint" args1(0).Value = "$A$1" dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1()) End Sub

OldEng gravatar imageOldEng ( 2020-02-22 15:33:40 +0200 )edit