Turning Number Recognition On or Off in Tables

Collabora Office can automatically recognize numbers or dates that you enter into a table cell, converting them from text to an appropriate number format. Use Table - Number Format to change the display of the entered value.

When an input cannot be recognized as a number, the number category changes to Text and the input is not changed.

If Number recognition is not marked in the Options, numbers are saved in text format and are automatically left-aligned.

To enable or disable this feature, do one of the following:

Choose Table - Number Recognition.

When this feature is on, a check mark is displayed in front of the Number Recognition command.

Choose - Collabora Office Writer - Table, and select or clear the Number Recognition check box.

This feature applies globally to all tables in all documents. When enabled, typing a date or number into a table cell will result in automatic formatting. Enabling and disabling this feature does not change existing data formatting.

- Collabora Office Writer - Table