Specifies the locale setting for the selected fields. With the locale set to Default, LibreOffice automatically applies the number formats associated with the system default locale. Specifies the locale setting for the selected cells. Specifies the locale setting for the selected field.
The locale setting ensures that date and currency formats, as well as decimal and thousands separators, are preserved even when the document is opened in an operating system that uses a different default locale setting.
Source format
图表使用的数字格式与包含数据的单元格相同。
Options
指定选中格式的选项。
Decimal places
输入希望显示的小数位数。
Denominator places
分数格式下,要显示的分母位数。
Leading zeroes
输入小数点前显示零的最多个数。
Negative numbers red
将负数的字体颜色改为「红色」。
Thousands separator
Inserts a separator between thousands. The type of separator that is used depends on your locale settings.
Engineering notation
对于科学计数法格式,「工程符号」确保指数是 3 的倍数。
Format code
显示选中格式的数字格式码。您也可以输入一个自定义的格式。以下选项仅适用于自定义的数字格式。
Add
将输入的数字格式码加入到自定义的类别中。
Add format
Edit Comment
为选中的数字格式添加批注。
Edit comment
Remove
Removes the selected number format. The changes are effective after you restart LibreOffice.