LibreOffice 24.8 Help
In LibreOffice Calc you can give numbers any currency format. When you click the icon in the bar to format a number, the cell is given the default currency format set under .
VĂ˝mena dokumentov LibreOffice Calc medzi pouĹľĂvateÄľmi mĂ´Ĺľe viesĹĄ k nedorozumeniam, ak dokument zLibreOffice Calcu naÄŤĂta pouĹľĂvateÄľ s inĂ˝m vĂ˝chodiskovĂ˝m formátom meny.
V LibreOffice Calc je moĹľnĂ© nastaviĹĄ formát ÄŤĂsla "1,234.50 €", ktorĂ˝ zostane v Eurách i po otvorenĂ v inej zemi.
You can change the currency format in the
dialog (choose tab) by two country settings. In the combo box select the basic setting for decimal and thousands separators. In the list box you can select the currency symbol and its position.For example, if the language is set to "Default" and you are using a german locale setting, the currency format will be "1.234,00 €". A point is used before the thousand digits and a comma before the decimal places. If you now select the subordinate currency format "$ English (US)" from the
list box , you will get the following format: "$ 1.234,00". As you can see, the separators have remained the same. Only the currency symbol has been changed and converted, but the underlying format of the notation remains the same as in the locale setting.If, under
, you convert the cells to "English (US)", the English-language locale setting is also transferred and the default currency format is now "$ 1,234.00".