How to Limit the Amount of Characters in OpenOffice
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.