OpenProjectExcel icon indicating copy to clipboard operation
OpenProjectExcel copied to clipboard

missing column header data validation list?

Open asharkin opened this issue 2 years ago • 2 comments

Getting run time error and it looks like the column headers data validation list in Attributes worksheet is missing?

asharkin avatar Nov 09 '23 07:11 asharkin

Same here without an runtime error! After syncing my project, I only see an empty filterlist.

image

Data Validation is showing the right source with the indirect formula but no dropdown menu is available.

KlaBra16F1 avatar Dec 15 '24 10:12 KlaBra16F1

I have the same Issue here. No error message and an empty filter list in Excel - just like the screen shot above.

Excel Version: Excel 2016 (no cloud version)

Edit:

That might be a Problem with Excel: If you just click at the small arrow it happens what is shown in the screenshot above. But if you click at the cell and not the arrow, a second arrow appears.

Image

If that "new" arrow is clicked, the types appear.

Image

It might be useful to add that to the documentation or the readme.md.

dagaz avatar Mar 19 '25 10:03 dagaz