Ask Your Question

Validity field shortened in Calc 5.4.5?

asked 2018-02-25 16:41:36 +0100

steverib gravatar image

updated 2020-07-09 14:43:28 +0100

Alex Kemp gravatar image

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?

Thanks, Steve

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-02-27 16:48:13 +0100

erAck gravatar image

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.

edit flag offensive delete link more


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!

steverib gravatar imagesteverib ( 2018-02-28 16:18:58 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-02-25 16:41:36 +0100

Seen: 33 times

Last updated: Feb 27 '18