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?
This is a very old bug doing no harm. I never searched for a related bug report. You may file one to https://bugs.libreoffice.org. Select anything in the second sheet and the triangle disappears
Thanks. I’ll submit it.
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 com.sun.star.beans.PropertyValue
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService(“com.sun.star.frame.DispatchHelper”)
args1(0).Name = “ToPoint”
args1(0).Value = “$A$1”
dispatcher.executeDispatch(document, “.uno:GoToCell”, “”, 0, args1())
End Sub