Number Recognition

Menjungkitkan pengaturan untuk secara otomatis mengenali angka atau tanggal yang Anda masukkan ke dalam suatu sel, mengubah mereka dari teks ke suatu format angka yang sesuai.

Untuk mengakses fungsi ini...

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.

The recognized number is displayed with default number format for table cells, and sets the cell format to the recognized category. For example, if a number is recognized as Date, the cell format category is set to Date. You can set a specific number format for the cell, for example, a date entered as 2018-03-08 displays as Thursday March 8, 2018 when the cell number format is set to "Friday, December 31, 1999" in the Number Format dialog.

note

Nomor Tanggal dan Waktu yang dikenali dikonversi ke tanggal dan nilai seri waktu internal. Persen angka dikonversi secara internal ke nilai numeriknya. Nilai Boolean dikonversi secara internal ke 0 atau 1.


Ketika input tidak dapat dikenali sebagai angka, kategori nomor berubah menjadiTeks dan inputnya tidak berubah.

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

Mohon dukung kami!