Validity field shortened in Calc 5.4.5?

My calc documents use the Data Validity field. Using version 5.3 I have no problem storing 835 characters in this field. In 5.4.5 it appears to have been reduced to 242 characters.

I cannot use this update when faced with this issue. Is there a work around?


Do you mean the Criteria List Entries? I’m not aware of a number of characters limit, specifically not 242, but the number of entries is limited and always was. Use Criteria Cell Range instead.

Correct. There does appear to be a character limit difference between the two versions, but your suggestion to use Cell Range instead works great. Thank you very much!