Ask Your Question
0

Validity field shortened in Calc 5.4.5?

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

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
0

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

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

Comments

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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 21 times

Last updated: Feb 27 '18