Ask Your Question
0

Character Limit in Cells

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

JennNurse gravatar image

Hi,

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?

Thanks!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

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

Stats

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

Seen: 1,990 times

Last updated: Jul 10 '15