Description:
Dear all,
in a cell with data validity (drop down menu) sourced out of cells containing new lines, the cell content is not refreshed when the selection is changed. 

Please have a look at the file attached where I'm going through different scenarios: source with new lines in columns A:C, source without new lines in columns F:H, mixed source in columns K:M.

Cell C3 has data validity set to cells A2:A7 (source with new lines). If you change the selection in cell C3, you will see that the content of the cell is not refreshed however it is refreshed in cell C7 which contains the formula (=C3).

Cell H3 has data validity set to cells F2:F7 (source without new lines) is correctly refreshed.

Cell M3 has data validity set to cells K2:K7 (mixed source) behaves erratically.

Thanks!

Steps to Reproduce:
1. Create source for data validity with new lines
2. Create a data validity drop down menu in a new cell
3. Check that the cell is not refreshed correctly

Actual Results:
The data validity cell text is not refreshed when selecting a different option from the drop down menu

Expected Results:
The data validity text cell should refresh when selecting a different option from the drop down menu


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Please refer to the other fields.