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, 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