Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Drop-down values in Excel cells are not specified in Data Validation rules and global search didn't find them in workbook, so where do they come from?
On top of values seemingly coming from nowhere in multiple columns, they also affect each other's behavior: In the GIF below, if the cells in the left column have no value selected, then there is no dropdown in the cells in the right column and they also don't accept arbitrary values (as a validation warning will pop up).
I know of the basic data validation drop-down methods:
Select a range of cells
Select "List" in
Source, either specify the values or select a range of cells that hold them
For the columns in the GIF,
Source shows stuff that's new to me:
- for the left column:
- for the right column:
=INDIRECT(V7)(the cell reference increments with every row)
I even listed all Data Validation rules programmatically using NPOI, but didn't find extra ones, and the ones defined on the two columns showed the same values as in the Excel app.