Number Recognition

Toggles the setting for automatically recognizing numbers or dates that you enter into a table cell, converting them from text to an appropriate number format.

要访问此命令...

From the menu bar:

Choose Table - Number Recognition.


note

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


Specifies that numbers entered into a text table cell are recognized and formatted as numbers. Table cells in LibreOffice Writer can recognize a number when it is represented in one of the number formats available in categories of Numbers, Percent, Currency, Date, Time, Scientific, Fraction and Boolean.

识别的数字以表格单元格默认的数字格式显示,并将单元格格式设为识别出的类别。例如,如果数字被识别为「日期」,单元格格式类别也将设为「日期」。您也可以为单元格设置特定的数字格式,例如在单元格的「数字格式」对话框中的格式设为「Friday, December 31, 1999」时,输入日期「8/3/2018」将显示为「Thursday, March 8, 2018」。

note

识别的「日期」与「时间」数字将转换为内部日期与时间序列值。百分比将在内部转换为其数字值。布尔值将在内部转换为 0 或 1。


当输入无法识别为数字时,数字类别将更改为「文本」,输入内容不会发生改变。

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

请支持我们!