1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
|
<?xml version="1.0" encoding="UTF-8"?>
<!--***********************************************************************
*
* The Contents of this file are made available subject to the terms of
* either of the following licenses
*
* - GNU Lesser General Public License Version 2.1
* - Sun Industry Standards Source License Version 1.1
*
* Sun Microsystems Inc., October, 2000
*
* GNU Lesser General Public License Version 2.1
* =============================================
* Copyright 2000 by Sun Microsystems, Inc.
* 901 San Antonio Road, Palo Alto, CA 94303, USA
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License version 2.1, as published by the Free Software Foundation.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston,
* MA 02111-1307 USA
*
*
* Sun Industry Standards Source License Version 1.1
* =================================================
* The contents of this file are subject to the Sun Industry Standards
* Source License Version 1.1 (the "License"); You may not use this file
* except in compliance with the License. You may obtain a copy of the
* License at http://www.openoffice.org/license.html.
*
* Software provided under this License is provided on an "AS IS" basis,
* WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
* WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
* MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
* See the License for the specific provisions governing your rights and
* obligations concerning the Software.
*
* The Initial Developer of the Original Code is: Sun Microsystems, Inc..
*
* Copyright: 2000 by Sun Microsystems, Inc.
*
* All Rights Reserved.
*
* Contributor(s): _______________________________________
*
*
************************************************************************-->
<helpdocument version="1.0">
<meta>
<topic id="textshared0105020300xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Numbers / Format</title>
<filename>/text/shared/01/05020300.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
<lastedited date="2004-12-10T16:47:30">converted from old format - fpe</lastedited>
</history>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3152942"><bookmark_value>formats; number formats</bookmark_value>
<bookmark_value>number formats; formats</bookmark_value>
<bookmark_value>numbers; formats</bookmark_value>
<bookmark_value>cells; number formats</bookmark_value>
<bookmark_value>currencies; number formats</bookmark_value>
<bookmark_value>defaults; number formats</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/HID_NUMBERFORMAT" id="bm_id3150146" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/FN_NUM_FORMAT_TABLE_DLG" id="bm_id2370759" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:TableNumberFormatDialog" id="bm_id3148731" localize="false"/>
<paragraph role="heading" id="hd_id3152942" xml-lang="en-US" level="1" l10n="U" oldref="1">Numbers / Format</paragraph>
<paragraph role="paragraph" id="par_id3145071" xml-lang="en-US" l10n="U" oldref="2"><variable id="zahlen"><ahelp hid=".uno:TableNumberFormatDialog">Specify the formatting options for the selected cell(s).</ahelp>
</variable></paragraph>
<paragraph role="paragraph" id="par_id3149177" xml-lang="en-US" l10n="E" localize="false"><link href="text/shared/00/00040503.xhp#zahlen"><embedvar href="text/shared/00/00000004.xhp#wie"/></link></paragraph>
<bookmark xml-lang="en-US" branch="hid/SVX:LISTBOX:RID_SVXPAGE_NUMBERFORMAT:LB_CATEGORY" id="bm_id3153312" localize="false"/>
<paragraph role="heading" id="hd_id3155392" xml-lang="en-US" level="2" l10n="U" oldref="3">Category</paragraph>
<paragraph role="paragraph" id="par_id3150774" xml-lang="en-US" l10n="U" oldref="4"><ahelp hid="SVX:LISTBOX:RID_SVXPAGE_NUMBERFORMAT:LB_CATEGORY">Select a category from the list, and then select a formatting style in the <emph>Format </emph>box.</ahelp></paragraph>
<switch select="appl">
<case select="CALC">
<paragraph role="note" id="par_id3145416" xml-lang="en-US" l10n="U" oldref="101">The default currency format for a cell is determined by the regional settings of your operating system.</paragraph>
</case>
</switch>
<bookmark xml-lang="en-US" branch="hid/HID_NUMBERFORMAT_LB_FORMAT" id="bm_id3155449" localize="false"/>
<paragraph role="heading" id="hd_id3155342" xml-lang="en-US" level="2" l10n="U" oldref="5">Format</paragraph>
<paragraph role="paragraph" id="par_id3148491" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="HID_NUMBERFORMAT_LB_FORMAT">Select how you want the contents of the selected cell(s) to be displayed.</ahelp> The code for the selected option is displayed in the <emph>Format Code</emph> box.</paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3154811"><bookmark_value>formats; currencies</bookmark_value>
<bookmark_value>numbers; currency format codes</bookmark_value>
<bookmark_value>format codes; currencies</bookmark_value>
<bookmark_value>currencies; format codes</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SVX:LISTBOX:RID_SVXPAGE_NUMBERFORMAT:LB_CURRENCY" id="bm_id3154381" localize="false"/>
<paragraph role="heading" id="hd_id3154811" xml-lang="en-US" level="3" l10n="U" oldref="97">Currency category list boxes</paragraph>
<paragraph role="paragraph" id="par_id3148563" xml-lang="en-US" l10n="U" oldref="98"><ahelp hid="SVX:LISTBOX:RID_SVXPAGE_NUMBERFORMAT:LB_CURRENCY">Select a currency, and then scroll to the top of the <emph>Format</emph> list to view the formatting options for the currency.</ahelp></paragraph>
<section id="waehrungtext">
<paragraph role="note" id="par_id3150866" xml-lang="en-US" l10n="U" oldref="99">The format code for currencies uses the form [$xxx-nnn], where xxx is the currency symbol, and nnn the country code. Special banking symbols, such as EUR (for Euro), do not require the country code. The currency format is not dependent on the language that you select in the<emph> Language</emph> box. </paragraph>
</section>
<bookmark xml-lang="en-US" branch="hid/SVX:LISTBOX:RID_SVXPAGE_NUMBERFORMAT:LB_LANGUAGE" id="bm_id3148797" localize="false"/>
<paragraph role="heading" id="hd_id3154071" xml-lang="en-US" level="2" l10n="U" oldref="23">Language</paragraph>
<paragraph role="paragraph" id="par_id3154138" xml-lang="en-US" l10n="U" oldref="24"><ahelp hid="SVX:LISTBOX:RID_SVXPAGE_NUMBERFORMAT:LB_LANGUAGE">Specifies the language setting for the selected <switchinline select="appl"><caseinline select="CALC">cells
</caseinline><defaultinline>fields</defaultinline></switchinline>. With the language set to <emph>Automatic</emph>, $[officename] automatically applies the number formats associated with the system default language. Select any language to fix the settings for the selected <switchinline select="appl"><caseinline select="CALC">cells
</caseinline><defaultinline>fields</defaultinline></switchinline>.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3157320" xml-lang="en-US" l10n="U" oldref="102">The language setting ensures that date and currency formats are preserved even when the document is opened in an operating system that uses a different default language setting.</paragraph>
<bookmark xml-lang="en-US" branch="hid/SVX_CHECKBOX_RID_SVXPAGE_NUMBERFORMAT_CB_SOURCEFORMAT" id="bm_id3145747" localize="false"/>
<paragraph role="heading" id="hd_id3155995" xml-lang="en-US" level="2" l10n="U" oldref="104">Source format</paragraph>
<paragraph role="paragraph" id="par_id3144432" xml-lang="en-US" l10n="U" oldref="105"><ahelp hid="SVX_CHECKBOX_RID_SVXPAGE_NUMBERFORMAT_CB_SOURCEFORMAT">Uses the same number format as the cells containing the data for the chart.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3148451" xml-lang="en-US" level="2" l10n="U" oldref="7">Options</paragraph>
<paragraph role="paragraph" id="par_id3148922" xml-lang="en-US" l10n="U" oldref="8">Specify the options for the selected format.</paragraph>
<bookmark xml-lang="en-US" branch="hid/SVX:NUMERICFIELD:RID_SVXPAGE_NUMBERFORMAT:ED_DECIMALS" id="bm_id3151178" localize="false"/>
<paragraph role="heading" id="hd_id3153970" xml-lang="en-US" level="3" l10n="U" oldref="9">Decimal places</paragraph>
<paragraph role="paragraph" id="par_id3154684" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="SVX:NUMERICFIELD:RID_SVXPAGE_NUMBERFORMAT:ED_DECIMALS">Enter the number of decimal places that you want to display.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SVX:NUMERICFIELD:RID_SVXPAGE_NUMBERFORMAT:ED_LEADZEROES" id="bm_id3153106" localize="false"/>
<paragraph role="heading" id="hd_id3154819" xml-lang="en-US" level="3" l10n="U" oldref="11">Leading zeroes</paragraph>
<paragraph role="paragraph" id="par_id3147352" xml-lang="en-US" l10n="CHG" oldref="12"><ahelp hid="SVX:NUMERICFIELD:RID_SVXPAGE_NUMBERFORMAT:ED_LEADZEROES">Enter the maximum number of zeroes to display in front of the decimal point.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SVX:CHECKBOX:RID_SVXPAGE_NUMBERFORMAT:BTN_NEGRED" id="bm_id3157895" localize="false"/>
<paragraph role="heading" id="hd_id3155131" xml-lang="en-US" level="3" l10n="U" oldref="13">Negative numbers in red</paragraph>
<paragraph role="paragraph" id="par_id3159252" xml-lang="en-US" l10n="U" oldref="14"><ahelp hid="SVX:CHECKBOX:RID_SVXPAGE_NUMBERFORMAT:BTN_NEGRED">Changes the font color of negative numbers to red.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SVX:CHECKBOX:RID_SVXPAGE_NUMBERFORMAT:BTN_THOUSAND" id="bm_id3148645" localize="false"/>
<paragraph role="heading" id="hd_id3147434" xml-lang="en-US" level="3" l10n="U" oldref="15">Use thousands separator</paragraph>
<paragraph role="paragraph" id="par_id3146148" xml-lang="en-US" l10n="U" oldref="16"><ahelp hid="SVX:CHECKBOX:RID_SVXPAGE_NUMBERFORMAT:BTN_THOUSAND">Inserts a separator between thousands. The type of separator that is used depends on your language settings.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3150103"><bookmark_value>format codes; number format</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SVX:EDIT:RID_SVXPAGE_NUMBERFORMAT:ED_FORMAT" id="bm_id3150961" localize="false"/>
<paragraph role="heading" id="hd_id3150103" xml-lang="en-US" level="2" l10n="U" oldref="17">Format code</paragraph>
<paragraph role="paragraph" id="par_id3159156" xml-lang="en-US" l10n="U" oldref="18"><ahelp hid="SVX:EDIT:RID_SVXPAGE_NUMBERFORMAT:ED_FORMAT">Displays the number format code for the selected format. You can also enter a custom format.</ahelp> The following options are only available for user-defined number formats.</paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_NUMBERFORMAT_TBI_ADD" id="bm_id3163717" localize="false"/>
<paragraph role="heading" id="hd_id3155311" xml-lang="en-US" level="3" l10n="U" oldref="19">Add</paragraph>
<paragraph role="paragraph" id="par_id3147219" xml-lang="en-US" l10n="U" oldref="20"><ahelp hid="HID_NUMBERFORMAT_TBI_ADD">Adds the number format code that you entered to the user-defined category.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_NUMBERFORMAT_TBI_REMOVE" id="bm_id3159181" localize="false"/>
<paragraph role="heading" id="hd_id3149263" xml-lang="en-US" level="3" l10n="U" oldref="21">Delete</paragraph>
<paragraph role="paragraph" id="par_id3154150" xml-lang="en-US" l10n="U" oldref="22"><ahelp hid="HID_NUMBERFORMAT_TBI_REMOVE">Deletes the selected number format.</ahelp> The changes are effective after you restart $[officename].</paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_NUMBERFORMAT_TBI_INFO" id="bm_id3151119" localize="false"/>
<paragraph role="heading" id="hd_id3153573" xml-lang="en-US" level="3" l10n="U" oldref="26">Edit Comment</paragraph>
<paragraph role="paragraph" id="par_id3083444" xml-lang="en-US" l10n="U" oldref="27"><ahelp hid="HID_NUMBERFORMAT_TBI_INFO">Adds a comment to the selected number format.</ahelp>.</paragraph>
<bookmark xml-lang="en-US" branch="hid/SVX:EDIT:RID_SVXPAGE_NUMBERFORMAT:ED_COMMENT" id="bm_id3154470" localize="false"/>
<paragraph role="heading" id="hd_id3150332" xml-lang="en-US" level="3" l10n="U" oldref="95">Name line</paragraph>
<paragraph role="paragraph" id="par_id3156060" xml-lang="en-US" l10n="U" oldref="96"><ahelp hid="SVX:EDIT:RID_SVXPAGE_NUMBERFORMAT:ED_COMMENT">Enter a comment for the selected number format, and then click outside this box.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#vorschau"/>
<section id="relatedtopics">
<paragraph role="paragraph" id="par_id3145364" xml-lang="en-US" l10n="C"><link href="text/shared/01/05020301.xhp" name="Number format codes">Number format codes</link></paragraph>
<paragraph role="paragraph" id="par_id3153095" xml-lang="en-US" l10n="C"><link href="text/shared/01/05020301.xhp" name="Custom format codes">Custom format codes</link></paragraph>
</section>
</body>
</helpdocument>
|
