Ask Your Question

misbehaving data validity

asked 2020-12-01 12:31:32 +0200

morphingstar gravatar image

updated 2020-12-01 12:34:13 +0200

I use Validity with cell range. I do not want to see white lines (fields) in Validity cell if there is nothing visible in the cell of the covered range. I have a range of >100 cells of which about 10% contain visible data. The data is concatenated. If I refer to a cell with "nothing" as a date source the date formula returns the zero value of win10 date, implicit cell containing 0, which it does not! If Data Validity refers to an "empty" looking cell which contains a formula the Validity cell shows an empty menu line as a nuisance. The setting of Allow Empty Cells is ignored, does not matter. The invisible formula is treated as an entry. Compare the logic! I use the validity cell to see where there is a column with an entry. The entry consist of a date Dec-31 and a action note, concatenated. The range of applicable columns is >100. LO has been distributed for many years already. I can not understand why SoftWarriors operating as Trouble-Hunters have not corrected this matter.

I spent considerable time to prepare an example sheet. There seems to be no upload here. I'll try OpenOffice with the sheet.

edit retag flag offensive close merge delete


There seems to be no upload here.

image description

PKG gravatar imagePKG ( 2020-12-01 12:48:11 +0200 )edit

Cross posted at

If you cross post, please note that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.

robleyd gravatar imagerobleyd ( 2020-12-06 00:47:56 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-12-05 23:21:06 +0200

morphingstar gravatar image

here is the file, and thanks for the upload pointer }C:\fakepath\Validity failure LO Forum 20201129.ods

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-12-01 12:31:32 +0200

Seen: 39 times

Last updated: Dec 05 '20