When you select a cell whose validity is a range of cells, you can see to the right of the cell a down arrow. Now you go into any other desired spreadsheet and see the arrow next to the same cell. This ghost-arrow can not be selected if isn't filled in the same column about any cell with text. If, however, are in the same column above cells containing text, these are offered with the arrow to choose from.
In this way, you can also override the validity criteria of the cell when it would be for example a time.
Hi Günter, thanks for reporting.
I think this is a duplicate of https://bugs.documentfoundation.org/show_bug.cgi?id=61623
Please if you are not agree, reopen it.
*** This bug has been marked as a duplicate of bug 61623 ***