Brother International WP230B Owners Manual - English - Page 202

Maximum Length of Alphanumeric Data The maximum length of alphanumeric data is 55 characters (the total length of the input area). If the data cannot fit in the cell, it uses the next cells on the grid unless these cells are already occupied. This convenient feature is used for long titles, when you do not want to disturb the layout of the spreadsheet by increasing the width of a column. It should be noted that entering many long alphanumeric data may cause the memory to become full before all cells are used. Also, adjusting the width of many columns to display long alphanumeric data may cause the rows to be cut off in the printout. Numeric Data Numeric data are direct numbers or formulas and are calculated. When data is not recognized as alphanumeric, the word processor interprets it as numeric data. In that case, the word processor checks whether or not the data is valid. NOTES: • If the data is valid, the result (a number) is calculated. If the number can fit in the cell, it is automatically right-justified. If the number cannot fit in the cell, a string of asterisks (*) fill the cell. The correct number is, however, kept in memory and will be displayed if you adjust the width of the column. • If the data is not valid, ERROR is displayed in the cell, and a message such as one of the following tells you what is going wrong. Example 1: If a denominator is zero: Division by zero. Example 2: If a result is positive and contains more than 13 digits: Numeric overflow. Example 3: If a result is negative and contains more than 13 digits: Numeric underilow. Example 4: If a number contains characters other than numerics and decimal point (e.g. 1,000, 100$, 1A2): Invalid entry. 190 Spreadsheet