Ask Your Question

Character Limit in Cells

asked 2015-07-10 15:06:56 +0100

JennNurse gravatar image


I keep in encountering a problem in some of my spread sheets where I receive an error stating "Max 20 Characters Allowed" in the cells of one particular column. The spreadsheet was originally an Excel file that I downloaded for work related use. Is there any way to remove that limitation?


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-07-10 16:29:57 +0100

Alex Kemp gravatar image

It looks like you may have set Data Validation on that column. To check this in LO/OO:-

  1. (select range of cells)
  2. Menu:-Data Validity... tab:Error Alert
  3. Is your error message in there?

If so, you can reverse/adjust the validation & alerts.

If this helps then please tick the answer (✔).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-07-10 15:06:56 +0100

Seen: 2,448 times

Last updated: Jul 10 '15