How to Limit the Amount of Characters in OpenOffice

Black iphone 4 on brown wooden table.jpg

When working with Apache OpenOffice Calc, you can limit the amount of characters in certain cells by setting the validity criteria. Used in conjunction with a custom error alert message, you can specify a character limit and display a message if this limit is exceeded. Use the validation feature to ensure that other people stick to the guidelines that you have specified for entering information or to remind yourself of character limits you imposed on certain cells.

1 Open Apache OpenOffice

Open Apache OpenOffice, and then select "Spreadsheet" from the splash screen to create a new document or "Open" to select a previously created spreadsheet file.

2 Click the cell

Click the cell for which you want to limit the amount of characters, click "Data" from the menu bar, and then select "Validity" to open the Validity window.

3 Click the Criteria'' tab

Click the "Criteria" tab, and then select "Text length" from the "Allow" drop-down list.

4 Select less than

Select "less than or equal to" from the "Data" drop-down list, and then type the character limit you want to impose in the Maximum input box.

5 Click the Input Help'' tab

Click the "Input Help" tab, and then click the "Show input help when cell is selected" check box.

6 Type a reminder

Type "Attention" or "Warning" in the title field, and then type a reminder, such as "This cell has a 20 character limit," in the Input Help field. The input help message is displayed when the cell is clicked to inform the user of the character limit.

7 Click the Error Alert'' tab

Click the "Error Alert" tab, and then click the check box next to "Show error message when invalid values are entered."

8 Select Stop

Select "Stop" from the "Action" drop down list, and then type an error message, such as "You have exceeded the character limit for this cell," in the Error Message input box. The error message is displayed if the user disregards the reminder message and exceeds the character limit you imposed.

9 Click to save the changes

Click "OK" to save the changes that you have made.

  • Information in this article applies to Apache OpenOffice 4. Procedures may vary with other versions or products.

Virtually growing up in a computer repair shop, Naomi Bolton has held a passion for as long as she can remember. After earning a diploma through a four year course in graphic design from Cibap College, Bolton launched her own photography business. Her work has been featured on Blinklist, Gameramble and many others.

×