I have a data validation dropdown with a list of possible values, and if the cell is empty or has a value, the dropdown list will show correctly.
But if the cell contains a formula, the dropdown list will not show and clicking on the dropdown arrow will enter cell editing.
Is this by design?