diff options
| author | Kurt Zenker <kz@openoffice.org> | 2009-12-02 16:06:49 +0100 |
|---|---|---|
| committer | Kurt Zenker <kz@openoffice.org> | 2009-12-02 16:06:49 +0100 |
| commit | 85ec1fb07c4d514bc1ebd5b34fd5a693dc6c2c42 (patch) | |
| tree | db56d7131ca487c68ba88f3826b306750eecc31f /helpcontent2/source/text/shared/01 | |
| parent | b77ca676f75658fc0c08dcca36ddc55472c353b9 (diff) | |
| parent | 31b049f371881607039c3010f7013af4f514f668 (diff) | |
CWS-TOOLING: integrate CWS hcshared24
Diffstat (limited to 'helpcontent2/source/text/shared/01')
| -rw-r--r-- | helpcontent2/source/text/shared/01/01020000.xhp | 253 | ||||
| -rwxr-xr-x | helpcontent2/source/text/shared/01/02100001.xhp | 22 | ||||
| -rw-r--r-- | helpcontent2/source/text/shared/01/05020301.xhp | 2137 | ||||
| -rw-r--r-- | helpcontent2/source/text/shared/01/05340100.xhp | 63 | ||||
| -rwxr-xr-x | helpcontent2/source/text/shared/01/06050100.xhp | 9 | ||||
| -rwxr-xr-x | helpcontent2/source/text/shared/01/06050200.xhp | 68 | ||||
| -rwxr-xr-x | helpcontent2/source/text/shared/01/formatting_mark.xhp | 4 | ||||
| -rw-r--r-- | helpcontent2/source/text/shared/01/password_dlg.xhp | 10 | ||||
| -rw-r--r-- | helpcontent2/source/text/shared/01/ref_pdf_export.xhp | 6 |
9 files changed, 1307 insertions, 1265 deletions
diff --git a/helpcontent2/source/text/shared/01/01020000.xhp b/helpcontent2/source/text/shared/01/01020000.xhp index ecaa6f6d49..c77a3b8746 100644 --- a/helpcontent2/source/text/shared/01/01020000.xhp +++ b/helpcontent2/source/text/shared/01/01020000.xhp @@ -1,9 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -11,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 01020000.xhp,v $ - * $Revision: 1.18.4.1 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -33,129 +32,157 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textshared0101020000xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Open</title> -<filename>/text/shared/01/01020000.xhp</filename> -</topic> -</meta> -<body> + <topic id="textshared0101020000xml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Open</title> + <filename>/text/shared/01/01020000.xhp</filename> + </topic> + </meta> + <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3145211"><bookmark_value>directories; creating new</bookmark_value> -<bookmark_value>folder creation</bookmark_value> -<bookmark_value>My Documents folder; opening</bookmark_value> -<bookmark_value>default directories</bookmark_value> -<bookmark_value>multiple documents; opening</bookmark_value> -<bookmark_value>opening; several files</bookmark_value> -<bookmark_value>selecting; several files</bookmark_value> -<bookmark_value>opening; files, with placeholders</bookmark_value> -<bookmark_value>regular expressions; opening files</bookmark_value> -<bookmark_value>files; opening with placeholders</bookmark_value> -<bookmark_value>placeholders;on opening files</bookmark_value> -<bookmark_value>documents; opening with templates</bookmark_value> -<bookmark_value>templates; opening documents with</bookmark_value> -<bookmark_value>documents; styles changed</bookmark_value> -<bookmark_value>styles; 'changed' message</bookmark_value> -</bookmark><comment>mw replaced "wildcards" by "regular expressions"</comment> + <bookmark_value>folder creation</bookmark_value> + <bookmark_value>My Documents folder; opening</bookmark_value> + <bookmark_value>default directories</bookmark_value> + <bookmark_value>multiple documents; opening</bookmark_value> + <bookmark_value>opening; several files</bookmark_value> + <bookmark_value>selecting; several files</bookmark_value> + <bookmark_value>opening; files, with placeholders</bookmark_value> + <bookmark_value>placeholders;on opening files</bookmark_value> + <bookmark_value>documents; opening with templates</bookmark_value> + <bookmark_value>templates; opening documents with</bookmark_value> + <bookmark_value>documents; styles changed</bookmark_value> + <bookmark_value>styles; 'changed' message</bookmark_value> +</bookmark><comment>mw replaced "wildcards" by "regular expressions"</comment><comment>mw deleted "regular expressions;" and "files;"</comment> <bookmark xml-lang="en-US" branch="hid/SID_OPENDOC" id="bm_id3908743" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:Open" id="bm_id3146765" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/HID_EXPLORERDLG_FILE" id="bm_id3147069" localize="false"/><paragraph role="heading" id="hd_id3146936" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/01/01020000.xhp" name="Open">Open</link></paragraph> -<paragraph role="paragraph" id="par_id3151191" xml-lang="en-US" l10n="U" oldref="2"><variable id="oeffnentext"><ahelp hid="HID_EXPLORERDLG_FILE">Opens or imports a file.</ahelp> +<bookmark xml-lang="en-US" branch="hid/HID_EXPLORERDLG_FILE" id="bm_id3147069" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3146936" role="heading" level="1" l10n="U" oldref="1"><link href="text/shared/01/01020000.xhp" name="Open">Open</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3151191" role="paragraph" l10n="U" oldref="2"><variable id="oeffnentext"><ahelp hid="HID_EXPLORERDLG_FILE">Opens or imports a file.</ahelp> </variable></paragraph> -<section id="howtoget"> -<embed href="text/shared/00/00000401.xhp#oeffnen"/> -</section> -<paragraph role="paragraph" id="par_id3149877" xml-lang="en-US" l10n="U" oldref="109">The following sections describe the <item type="productname">%PRODUCTNAME</item> -<emph>Open </emph>dialog. To activate the <item type="productname">%PRODUCTNAME</item> -<emph>Open</emph> and<emph> Save </emph>dialogs, choose <link href="text/shared/optionen/01010600.xhp" name="Tools - Options - %PRODUCTNAME - General"><emph>Tools - Options - %PRODUCTNAME</emph> -<emph>- General</emph></link>, and then select the <emph>Use %PRODUCTNAME</emph> -<emph>dialogs</emph> in the<emph> Open/Save dialogs</emph> area.</paragraph> -<paragraph role="note" id="par_id3150713" xml-lang="en-US" l10n="U" oldref="52">If the file that you want to open contains Styles, <link href="text/shared/01/01020000.xhp#vorlagen" name="special rules">special rules</link> apply.</paragraph> + <section id="howtoget"> + <embed href="text/shared/00/00000401.xhp#oeffnen"/> + </section> + <paragraph xml-lang="en-US" id="par_id3149877" role="paragraph" l10n="U" oldref="109">The following sections describe the <item type="productname">%PRODUCTNAME</item> + <emph>Open </emph>dialog. To activate the <item type="productname">%PRODUCTNAME</item> + <emph>Open</emph> and<emph> Save </emph>dialogs, choose <link href="text/shared/optionen/01010600.xhp" name="Tools - Options - %PRODUCTNAME - General"><emph>Tools - Options - %PRODUCTNAME</emph> + <emph>- General</emph></link>, and then select the <emph>Use %PRODUCTNAME</emph> + <emph>dialogs</emph> in the<emph> Open/Save dialogs</emph> area.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150713" role="note" l10n="U" oldref="52">If the file that you want to open contains Styles, <link href="text/shared/01/01020000.xhp#vorlagen" name="special rules">special rules</link> apply.</paragraph> <bookmark xml-lang="en-US" branch="hid/SVTOOLS_MENUBUTTON_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_UP" id="bm_id3153394" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/fpicker_MenuButton_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_UP" id="bm_id1104770" localize="false"/><paragraph role="heading" id="hd_id3147250" xml-lang="en-US" level="2" l10n="U" oldref="11">Up One Level</paragraph> -<paragraph role="paragraph" id="par_id3147226" xml-lang="en-US" l10n="CHG" oldref="12"><ahelp hid="SVTOOLS_MENUBUTTON_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_UP">Move up one directory in the directory hierarchy. Long-click to see the higher level directories.</ahelp><comment>UFI: it is still a long-click</comment></paragraph> -<embed href="text/shared/00/00000004.xhp#syuebergeordneterordner2"/> +<bookmark xml-lang="en-US" branch="hid/fpicker_MenuButton_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_UP" id="bm_id1104770" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3147250" role="heading" level="2" l10n="U" + oldref="11">Up One Level</paragraph> + <paragraph xml-lang="en-US" id="par_id3147226" role="paragraph" l10n="CHG" oldref="12"><ahelp hid="SVTOOLS_MENUBUTTON_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_UP">Move up one directory in the directory hierarchy. Long-click to see the higher level directories.</ahelp><comment>UFI: it is still a long-click</comment></paragraph> + <embed href="text/shared/00/00000004.xhp#syuebergeordneterordner2"/> <bookmark xml-lang="en-US" branch="hid/SVTOOLS_IMAGEBUTTON_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_NEWFOLDER" id="bm_id3153748" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/fpicker_ImageButton_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_NEWFOLDER" id="bm_id393993" localize="false"/><paragraph role="heading" id="hd_id3145211" xml-lang="en-US" level="2" l10n="U" oldref="13">Create New Directory</paragraph> -<paragraph role="paragraph" id="par_id3153681" xml-lang="en-US" l10n="U" oldref="14"><ahelp hid="SVTOOLS_IMAGEBUTTON_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_NEWFOLDER">Creates a new directory.</ahelp></paragraph> -<embed href="text/shared/00/00000004.xhp#syneuenordnererstellen2"/> +<bookmark xml-lang="en-US" branch="hid/fpicker_ImageButton_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_NEWFOLDER" id="bm_id393993" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3145211" role="heading" level="2" l10n="U" + oldref="13">Create New Directory</paragraph> + <paragraph xml-lang="en-US" id="par_id3153681" role="paragraph" l10n="U" oldref="14"><ahelp hid="SVTOOLS_IMAGEBUTTON_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_NEWFOLDER">Creates a new directory.</ahelp></paragraph> + <embed href="text/shared/00/00000004.xhp#syneuenordnererstellen2"/> <bookmark xml-lang="en-US" branch="hid/SVTOOLS_PUSHBUTTON_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_STANDARD" id="bm_id3147008" localize="false"/> <bookmark xml-lang="en-US" branch="hid/svtools_MenuButton_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_STANDARD" id="bm_id5397808" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/fpicker_MenuButton_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_STANDARD" id="bm_id6316721" localize="false"/><paragraph role="heading" id="hd_id3147010" xml-lang="en-US" level="2" l10n="U" oldref="38">Default Directory</paragraph> -<paragraph role="paragraph" id="par_id3109847" xml-lang="en-US" l10n="U" oldref="39"><ahelp hid="SVTOOLS_PUSHBUTTON_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_STANDARD">Displays the files in the default user directory.</ahelp></paragraph> -<embed href="text/shared/00/00000004.xhp#systandardverzeichnis2"/> -<bookmark xml-lang="en-US" branch="hid/HID_FILEDLG_STANDARD" id="bm_id3150355" localize="false"/><paragraph role="heading" id="hd_id3148538" xml-lang="en-US" level="2" l10n="U" oldref="19">Display area</paragraph> -<paragraph role="paragraph" id="par_id3156113" xml-lang="en-US" l10n="U" oldref="20"><ahelp hid="HID_FILEDLG_STANDARD">Displays the files and directories in the directory that you are in.</ahelp> To open a file, select the file, and then click <emph>Open</emph>.</paragraph> -<paragraph role="tip" id="par_id3159256" xml-lang="en-US" l10n="CHG" oldref="78">To open more than one document at the same time, each in an own window, hold <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> while you click the files, and then click <emph>Open</emph>.</paragraph> -<list type="unordered"> -<listitem> -<paragraph role="listitem" id="par_id3154514" xml-lang="en-US" l10n="U" oldref="110">Click a column header to sort the files. Click again to reverse the sort order.</paragraph> -</listitem> -<listitem> -<bookmark xml-lang="en-US" branch="hid/HID_FILEVIEW_MENU_DELETE" id="bm_id3149902" localize="false"/><paragraph role="listitem" id="par_id3149514" xml-lang="en-US" l10n="U" oldref="111"><ahelp hid="HID_FILEVIEW_MENU_DELETE">To delete a file, right-click the file, and then choose <emph>Delete</emph>.</ahelp></paragraph> -</listitem> -<listitem> -<bookmark xml-lang="en-US" branch="hid/HID_FILEVIEW_MENU_RENAME" id="bm_id3148491" localize="false"/><paragraph role="listitem" id="par_id3147618" xml-lang="en-US" l10n="U" oldref="112"><ahelp hid="HID_FILEVIEW_MENU_RENAME">To rename a file, right-click the file, and then choose <emph>Rename</emph>.</ahelp></paragraph> -</listitem> -</list> -<bookmark xml-lang="en-US" branch="hid/SVTOOLS_PUSHBUTTON_DLG_SVT_QUERYDELETE_BTN_YES" id="bm_id3151245" localize="false"/><paragraph role="paragraph" id="par_id3153331" xml-lang="en-US" l10n="U" oldref="124"><ahelp hid="SVTOOLS_PUSHBUTTON_DLG_SVT_QUERYDELETE_BTN_YES" visibility="hidden">Click to delete the file with the name shown in this dialog.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/SVTOOLS_PUSHBUTTON_DLG_SVT_QUERYDELETE_BTN_NO" id="bm_id3150822" localize="false"/><paragraph role="paragraph" id="par_id3161458" xml-lang="en-US" l10n="U" oldref="125"><ahelp hid="SVTOOLS_PUSHBUTTON_DLG_SVT_QUERYDELETE_BTN_NO" visibility="hidden">Click to cancel deletion of the file with the name shown in this dialog.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/SVTOOLS_PUSHBUTTON_DLG_SVT_QUERYDELETE_BTN_ALL" id="bm_id3154346" localize="false"/><paragraph role="paragraph" id="par_id3147531" xml-lang="en-US" l10n="U" oldref="126"><ahelp hid="SVTOOLS_PUSHBUTTON_DLG_SVT_QUERYDELETE_BTN_ALL" visibility="hidden">Click to delete all selected files.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/fpicker_MenuButton_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_STANDARD" id="bm_id6316721" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3147010" role="heading" level="2" l10n="U" + oldref="38">Default Directory</paragraph> + <paragraph xml-lang="en-US" id="par_id3109847" role="paragraph" l10n="U" oldref="39"><ahelp hid="SVTOOLS_PUSHBUTTON_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_STANDARD">Displays the files in the default user directory.</ahelp></paragraph> + <embed href="text/shared/00/00000004.xhp#systandardverzeichnis2"/> +<bookmark xml-lang="en-US" branch="hid/HID_FILEDLG_STANDARD" id="bm_id3150355" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3148538" role="heading" level="2" l10n="U" + oldref="19">Display area</paragraph> + <paragraph xml-lang="en-US" id="par_id3156113" role="paragraph" l10n="U" oldref="20"><ahelp hid="HID_FILEDLG_STANDARD">Displays the files and directories in the directory that you are in.</ahelp> To open a file, select the file, and then click <emph>Open</emph>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3159256" role="tip" l10n="CHG" oldref="78">To open more than one document at the same time, each in an own window, hold <switchinline select="sys"><caseinline select="MAC">Command +</caseinline><defaultinline>Ctrl</defaultinline></switchinline> while you click the files, and then click <emph>Open</emph>.</paragraph> + <list type="unordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3154514" role="listitem" l10n="U" oldref="110">Click a column header to sort the files. Click again to reverse the sort order.</paragraph> + </listitem> + <listitem> +<bookmark xml-lang="en-US" branch="hid/HID_FILEVIEW_MENU_DELETE" id="bm_id3149902" localize="false"/> +<paragraph xml-lang="en-US" id="par_id3149514" role="listitem" l10n="U" oldref="111"><ahelp hid="HID_FILEVIEW_MENU_DELETE">To delete a file, right-click the file, and then choose <emph>Delete</emph>.</ahelp></paragraph> + </listitem> + <listitem> +<bookmark xml-lang="en-US" branch="hid/HID_FILEVIEW_MENU_RENAME" id="bm_id3148491" localize="false"/> +<paragraph xml-lang="en-US" id="par_id3147618" role="listitem" l10n="U" oldref="112"><ahelp hid="HID_FILEVIEW_MENU_RENAME">To rename a file, right-click the file, and then choose <emph>Rename</emph>.</ahelp></paragraph> + </listitem> + </list> +<bookmark xml-lang="en-US" branch="hid/SVTOOLS_PUSHBUTTON_DLG_SVT_QUERYDELETE_BTN_YES" id="bm_id3151245" localize="false"/> +<paragraph xml-lang="en-US" id="par_id3153331" role="paragraph" l10n="U" oldref="124"><ahelp hid="SVTOOLS_PUSHBUTTON_DLG_SVT_QUERYDELETE_BTN_YES" visibility="hidden">Click to delete the file with the name shown in this dialog.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/SVTOOLS_PUSHBUTTON_DLG_SVT_QUERYDELETE_BTN_NO" id="bm_id3150822" localize="false"/> +<paragraph xml-lang="en-US" id="par_id3161458" role="paragraph" l10n="U" oldref="125"><ahelp hid="SVTOOLS_PUSHBUTTON_DLG_SVT_QUERYDELETE_BTN_NO" visibility="hidden">Click to cancel deletion of the file with the name shown in this dialog.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/SVTOOLS_PUSHBUTTON_DLG_SVT_QUERYDELETE_BTN_ALL" id="bm_id3154346" localize="false"/> +<paragraph xml-lang="en-US" id="par_id3147531" role="paragraph" l10n="U" oldref="126"><ahelp hid="SVTOOLS_PUSHBUTTON_DLG_SVT_QUERYDELETE_BTN_ALL" visibility="hidden">Click to delete all selected files.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_FILEDLG_FOLDER_FILENAME" id="bm_id3149656" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/HID_FILEDLG_AUTOCOMPLETEBOX" id="bm_id3149045" localize="false"/><paragraph role="heading" id="hd_id3154280" xml-lang="en-US" level="2" l10n="U" oldref="21">File name</paragraph> -<paragraph role="paragraph" id="par_id3161656" xml-lang="en-US" l10n="CHG" oldref="22"><ahelp hid="HID_FILEDLG_AUTOCOMPLETEBOX">Enter a file name or a path for the file. You can also enter a <link href="text/shared/00/00000002.xhp#url" name="URL">URL</link> that starts with the protocol name ftp, http, or https.</ahelp></paragraph> -<paragraph role="paragraph" id="par_id3150541" xml-lang="en-US" l10n="U" oldref="72">If you want, you can use wildcards in the <emph>File name </emph>box to filter the list of files that is displayed.</paragraph> -<paragraph role="paragraph" id="par_id3153779" xml-lang="en-US" l10n="U" oldref="24"><switchinline select="sys"><caseinline select="MAC"> +<bookmark xml-lang="en-US" branch="hid/HID_FILEDLG_AUTOCOMPLETEBOX" id="bm_id3149045" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3154280" role="heading" level="2" l10n="U" + oldref="21">File name</paragraph> + <paragraph xml-lang="en-US" id="par_id3161656" role="paragraph" l10n="CHG" oldref="22"><ahelp hid="HID_FILEDLG_AUTOCOMPLETEBOX">Enter a file name or a path for the file. You can also enter a <link href="text/shared/00/00000002.xhp#url" name="URL">URL</link> that starts with the protocol name ftp, http, or https.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="par_id3150541" role="paragraph" l10n="U" oldref="72">If you want, you can use wildcards in the <emph>File name </emph>box to filter the list of files that is displayed.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153779" role="paragraph" l10n="U" oldref="24"><switchinline select="sys"><caseinline select="MAC"> </caseinline><defaultinline>For example, to list all of the text files in a directory, enter the asterisk wildcard with the text file extension (*.txt), and then click<emph> Open</emph>. Use the question mark (?) wildcard to represent any character, as in (??3*.txt), which only displays text files with a '3' as the third character in the file name.</defaultinline></switchinline></paragraph> -<embed href="text/shared/04/01010000.xhp#autocompurl"/> -<bookmark xml-lang="en-US" branch="hid/HID_FILEOPEN_VERSION" id="bm_id3151210" localize="false"/><paragraph role="heading" id="hd_id3145117" xml-lang="en-US" level="2" l10n="U" oldref="81">Version</paragraph> -<paragraph role="paragraph" id="par_id3149291" xml-lang="en-US" l10n="U" oldref="82"><ahelp hid="HID_FILEOPEN_VERSION">If there are multiple versions of the selected file, select the version that you want to open.</ahelp> You can save and organize multiple versions of a document by choosing <emph>File - Versions</emph>. The versions of a document are opened in read-only mode.</paragraph> + <embed href="text/shared/04/01010000.xhp#autocompurl"/> +<bookmark xml-lang="en-US" branch="hid/HID_FILEOPEN_VERSION" id="bm_id3151210" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3145117" role="heading" level="2" l10n="U" + oldref="81">Version</paragraph> + <paragraph xml-lang="en-US" id="par_id3149291" role="paragraph" l10n="U" oldref="82"><ahelp hid="HID_FILEOPEN_VERSION">If there are multiple versions of the selected file, select the version that you want to open.</ahelp> You can save and organize multiple versions of a document by choosing <emph>File - Versions</emph>. The versions of a document are opened in read-only mode.</paragraph> <bookmark xml-lang="en-US" branch="hid/SVTOOLS_LISTBOX_DLG_SVT_EXPLORERFILE_LB_EXPLORERFILE_FILETYPE" id="bm_id3151176" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/fpicker_ListBox_DLG_SVT_EXPLORERFILE_LB_EXPLORERFILE_FILETYPE" id="bm_id9219641" localize="false"/><paragraph role="heading" id="hd_id3150767" xml-lang="en-US" level="2" l10n="U" oldref="25">File type</paragraph> -<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="CHG" oldref="26"><ahelp hid="SVTOOLS_LISTBOX_DLG_SVT_EXPLORERFILE_LB_EXPLORERFILE_FILETYPE">Select the file type that you want to open, or select <emph>All Files (*)</emph> to display a list of all of the files in the directory.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/fpicker_ListBox_DLG_SVT_EXPLORERFILE_LB_EXPLORERFILE_FILETYPE" id="bm_id9219641" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3150767" role="heading" level="2" l10n="U" + oldref="25">File type</paragraph> + <paragraph xml-lang="en-US" id="par_id3153969" role="paragraph" l10n="CHG" oldref="26"><ahelp hid="SVTOOLS_LISTBOX_DLG_SVT_EXPLORERFILE_LB_EXPLORERFILE_FILETYPE">Select the file type that you want to open, or select <emph>All Files (*)</emph> to display a list of all of the files in the directory.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/SVTOOLS_PUSHBUTTON_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_OPEN" id="bm_id3149810" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/svtools_PushButton_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_LOCAL" id="bm_id5172582" localize="false"/><paragraph role="heading" id="hd_id3154125" xml-lang="en-US" level="2" l10n="U" oldref="27">Open</paragraph> -<paragraph role="paragraph" id="par_id3152933" xml-lang="en-US" l10n="U" oldref="28"><ahelp hid="SVTOOLS_PUSHBUTTON_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_OPEN">Opens the selected document(s).</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/HID_FILEDLG_INSERT_BTN" id="bm_id3154948" localize="false"/><paragraph role="heading" id="hd_id3147085" xml-lang="en-US" level="2" l10n="U" oldref="88">Insert</paragraph> -<paragraph role="paragraph" id="par_id3156293" xml-lang="en-US" l10n="U" oldref="89">If you opened the dialog by choosing <emph>Insert - File</emph>, the <emph>Open</emph> button is labeled <emph>Insert</emph>. <ahelp hid="HID_FILEDLG_INSERT_BTN">Inserts the selected file into the current document at the cursor position.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/HID_FILEOPEN_READONLY" id="bm_id3156215" localize="false"/><paragraph role="heading" id="hd_id3144762" xml-lang="en-US" level="2" l10n="U" oldref="35">Read-only</paragraph> -<paragraph role="paragraph" id="par_id3145785" xml-lang="en-US" l10n="U" oldref="36"><ahelp hid="HID_FILEOPEN_READONLY">Opens the file in read-only mode.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/svtools_PushButton_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_LOCAL" id="bm_id5172582" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3154125" role="heading" level="2" l10n="U" + oldref="27">Open</paragraph> + <paragraph xml-lang="en-US" id="par_id3152933" role="paragraph" l10n="U" oldref="28"><ahelp hid="SVTOOLS_PUSHBUTTON_DLG_SVT_EXPLORERFILE_BTN_EXPLORERFILE_OPEN">Opens the selected document(s).</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FILEDLG_INSERT_BTN" id="bm_id3154948" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3147085" role="heading" level="2" l10n="U" + oldref="88">Insert</paragraph> + <paragraph xml-lang="en-US" id="par_id3156293" role="paragraph" l10n="U" oldref="89">If you opened the dialog by choosing <emph>Insert - File</emph>, the <emph>Open</emph> button is labeled <emph>Insert</emph>. <ahelp hid="HID_FILEDLG_INSERT_BTN">Inserts the selected file into the current document at the cursor position.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FILEOPEN_READONLY" id="bm_id3156215" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3144762" role="heading" level="2" l10n="U" + oldref="35">Read-only</paragraph> + <paragraph xml-lang="en-US" id="par_id3145785" role="paragraph" l10n="U" oldref="36"><ahelp hid="HID_FILEOPEN_READONLY">Opens the file in read-only mode.</ahelp></paragraph> <switch select="appl"> <case select="IMPRESS"> -<bookmark xml-lang="en-US" branch="hid/HID_FILESAVE_DOPLAY" id="bm_id3145324" localize="false"/><paragraph role="heading" id="hd_id3149984" xml-lang="en-US" level="2" l10n="U" oldref="113">Play</paragraph> -<paragraph role="paragraph" id="par_id3147289" xml-lang="en-US" l10n="U" oldref="114"><ahelp hid="HID_FILESAVE_DOPLAY">Plays the selected sound file. Click again to stop playing the sound file.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FILESAVE_DOPLAY" id="bm_id3145324" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3149984" role="heading" level="2" l10n="U" + oldref="113">Play</paragraph> + <paragraph xml-lang="en-US" id="par_id3147289" role="paragraph" l10n="U" oldref="114"><ahelp hid="HID_FILESAVE_DOPLAY">Plays the selected sound file. Click again to stop playing the sound file.</ahelp></paragraph> </case> </switch> <section id="vorlagen"> -<bookmark xml-lang="en-US" branch="hid/MSG_QUERY_LOAD_TEMPLATE" id="bm_id3151118" localize="false"/><paragraph role="heading" id="hd_id3149260" xml-lang="en-US" level="3" l10n="U" oldref="53">Opening Documents With Templates</paragraph> -<paragraph role="paragraph" id="par_id3145367" xml-lang="en-US" l10n="CHG" oldref="40"> -<item type="productname">%PRODUCTNAME</item> recognizes templates that are located in any directory from the following list:</paragraph> -<list type="unordered"> -<listitem> -<paragraph role="listitem" id="par_id3151292" xml-lang="en-US" l10n="CHG" oldref="120">the shared template directory<comment>removed path</comment></paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3144442" xml-lang="en-US" l10n="CHG" oldref="121">the user template directory <switchinline select="sys"><caseinline select="UNIX">in the home directory +<bookmark xml-lang="en-US" branch="hid/MSG_QUERY_LOAD_TEMPLATE" id="bm_id3151118" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3149260" role="heading" level="3" l10n="U" + oldref="53">Opening Documents With Templates</paragraph> + <paragraph xml-lang="en-US" id="par_id3145367" role="paragraph" l10n="CHG" oldref="40"> + <item type="productname">%PRODUCTNAME</item> recognizes templates that are located in any directory from the following list:</paragraph> + <list type="unordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3151292" role="listitem" l10n="CHG" oldref="120">the shared template directory<comment>removed path</comment></paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3144442" role="listitem" l10n="CHG" oldref="121">the user template directory <switchinline select="sys"><caseinline select="UNIX">in the home directory </caseinline><defaultinline>in the Documents and Settings directory</defaultinline></switchinline></paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3146905" xml-lang="en-US" l10n="U" oldref="122">all template folders as defined in <link href="text/shared/optionen/01010300.xhp" name="Tools - Options - %PRODUCTNAME - Paths"><emph>Tools - Options - %PRODUCTNAME</emph> -<emph>- Paths</emph></link></paragraph> -</listitem> -</list> -<paragraph role="note" id="par_id7375713" xml-lang="en-US" l10n="NEW">When you use <item type="menuitem">File - Template - Save</item> to save a template, the template will be stored in your user template directory. When you open a document that is based on such a template, the document will be checked for a changed template as decribed below. The template is associated with the document, it may be called a "sticky template".</paragraph> -<paragraph role="note" id="par_id6930143" xml-lang="en-US" l10n="NEW">When you use <item type="menuitem">File - Save As</item> and select a template filter to save a template at any other directory that is not in the list, then the documents based on that template will not be checked.</paragraph> -<paragraph role="paragraph" id="par_id3150105" xml-lang="en-US" l10n="CHG" oldref="73">When you open a document that was created from a "sticky template" (as defined above), <item type="productname">%PRODUCTNAME</item> checks to see if the template has been modified since the document was last opened. If the template was changed a dialog is shown where you can select which styles to apply to the document.</paragraph> -<paragraph role="paragraph" id="par_id3153096" xml-lang="en-US" l10n="U" oldref="74">To apply the new styles from the template to the document, click <emph>Yes</emph>.</paragraph> -<paragraph role="paragraph" id="par_id3147581" xml-lang="en-US" l10n="U" oldref="75">To retain the styles that are currently used in the document, click <emph>No</emph>.</paragraph> -<paragraph role="paragraph" id="par_id3154988" xml-lang="en-US" l10n="U" oldref="44">If a document was created using a template that cannot be found a dialog is shown that asks you how to proceed next time the document is opened.</paragraph> -<paragraph role="paragraph" id="par_id3151351" xml-lang="en-US" l10n="CHG" oldref="91">To break the link between the document and the missing template, click <emph>No</emph>, otherwise <item type="productname">%PRODUCTNAME</item> will look for the template the next time you open the document.</paragraph> -</section> -<section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3149417" xml-lang="en-US" l10n="C"><link href="text/shared/guide/doc_open.xhp" name="Opening Documents">Opening Documents</link></paragraph> -<paragraph role="paragraph" id="par_id3153848" xml-lang="en-US" l10n="C"><link href="text/shared/00/00000020.xhp" name="Import and Export Filters">Import and Export Filters</link></paragraph> -</section> -</body> -</helpdocument> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3146905" role="listitem" l10n="U" oldref="122">all template folders as defined in <link href="text/shared/optionen/01010300.xhp" name="Tools - Options - %PRODUCTNAME - Paths"><emph>Tools - Options - %PRODUCTNAME</emph> + <emph>- Paths</emph></link></paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_id7375713" role="note" l10n="NEW">When you use <item type="menuitem">File - Template - Save</item> to save a template, the template will be stored in your user template directory. When you open a document that is based on such a template, the document will be checked for a changed template as decribed below. The template is associated with the document, it may be called a "sticky template".</paragraph> + <paragraph xml-lang="en-US" id="par_id6930143" role="note" l10n="NEW">When you use <item type="menuitem">File - Save As</item> and select a template filter to save a template at any other directory that is not in the list, then the documents based on that template will not be checked.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150105" role="paragraph" l10n="CHG" oldref="73">When you open a document that was created from a "sticky template" (as defined above), <item type="productname">%PRODUCTNAME</item> checks to see if the template has been modified since the document was last opened. If the template was changed a dialog is shown where you can select which styles to apply to the document.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153096" role="paragraph" l10n="U" oldref="74">To apply the new styles from the template to the document, click <emph>Yes</emph>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3147581" role="paragraph" l10n="U" oldref="75">To retain the styles that are currently used in the document, click <emph>No</emph>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154988" role="paragraph" l10n="U" oldref="44">If a document was created using a template that cannot be found a dialog is shown that asks you how to proceed next time the document is opened.</paragraph> + <paragraph xml-lang="en-US" id="par_id3151351" role="paragraph" l10n="CHG" oldref="91">To break the link between the document and the missing template, click <emph>No</emph>, otherwise <item type="productname">%PRODUCTNAME</item> will look for the template the next time you open the document.</paragraph> + </section> + <section id="relatedtopics"> + <paragraph xml-lang="en-US" id="par_id3149417" role="paragraph" l10n="C"><link href="text/shared/guide/doc_open.xhp" name="Opening Documents">Opening Documents</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3153848" role="paragraph" l10n="C"><link href="text/shared/00/00000020.xhp" name="Import and Export Filters">Import and Export Filters</link></paragraph> + </section> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/shared/01/02100001.xhp b/helpcontent2/source/text/shared/01/02100001.xhp index 533a05b40d..79eb1411a1 100755 --- a/helpcontent2/source/text/shared/01/02100001.xhp +++ b/helpcontent2/source/text/shared/01/02100001.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -198,7 +198,8 @@ <paragraph xml-lang="en-US" id="par_id3156293" role="tablecontent" l10n="U" oldref="174">[a-e]</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149167" role="tablecontent" l10n="CHG" oldref="175">Represents any of the characters that are between a and e.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149167" role="tablecontent" l10n="CHG" oldref="175">Represents any of the characters that are between a and e, including both start and end characters</paragraph> + <paragraph xml-lang="en-US" id="par_id100520090232005" role="tablecontent" l10n="NEW">The characters are ordered by their code numbers.</paragraph> </tablecell> </tablerow> <tablerow> @@ -214,7 +215,7 @@ <paragraph xml-lang="en-US" id="par_id3145318" role="tablecontent" l10n="U" oldref="178">[^a-s]</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153351" role="tablecontent" l10n="CHG" oldref="179">Represents any character that is not between a and s.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153351" role="tablecontent" l10n="CHG" oldref="179">Represents everything that is not between a and s.</paragraph> </tablecell> </tablerow> <tablerow> @@ -231,7 +232,7 @@ <paragraph xml-lang="en-US" id="par_id3153951" role="tablecontent" l10n="U" oldref="186">|</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3154985" role="tablecontent" l10n="CHG" oldref="187">Finds the terms that occur before or after the "|". For example, "this|that" finds "this" and "that".</paragraph> + <paragraph xml-lang="en-US" id="par_id3154985" role="tablecontent" l10n="CHG" oldref="187">Finds the terms that occur before the "|" and also finds the terms that occur after the "|". For example, "this|that" finds "this" and "that".</paragraph> </tablecell> </tablerow> <tablerow> @@ -239,7 +240,7 @@ <paragraph xml-lang="en-US" id="par_id3147376" role="tablecontent" l10n="U" oldref="209">{2}</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3150103" role="tablecontent" l10n="U" oldref="210">Defines the number of times that the character in front of the opening bracket occurs. For example, "tre{2}" finds "tree".</paragraph> + <paragraph xml-lang="en-US" id="par_id3150103" role="tablecontent" l10n="U" oldref="210">Defines the number of times that the character in front of the opening bracket occurs. For example, "tre{2}" finds and selects "tree".</paragraph> </tablecell> </tablerow> <tablerow> @@ -247,7 +248,7 @@ <paragraph xml-lang="en-US" id="par_id3151289" role="tablecontent" l10n="U" oldref="211">{1,2}</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3147317" role="tablecontent" l10n="U" oldref="212">Defines the number of times that the character in front of the opening bracket can occur. For example, "tre{1,2}" finds both "tree" and "treated".</paragraph> + <paragraph xml-lang="en-US" id="par_id3147317" role="tablecontent" l10n="CHG" oldref="212">Defines the minimum and maximum number of times that the character in front of the opening bracket can occur. For example, "tre{1,2}" finds and selects "tre" and "tree".</paragraph> </tablecell> </tablerow> <tablerow> @@ -333,7 +334,7 @@ </tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3150092" role="tablecontent" l10n="CHG" oldref="231">Represents an uppercase character if <emph>Match case</emph> is selected in <emph>Options.</emph> -</paragraph> + </paragraph> </tablecell> </tablerow> </table> @@ -348,7 +349,12 @@ <paragraph xml-lang="en-US" id="par_id5806756" role="paragraph" l10n="NEW">$ means the match must end a paragraph. </paragraph> <section id="relatedtopics"> <embed href="text/shared/01/02100000.xhp#02100000"/> - <paragraph xml-lang="en-US" id="par_id1751457" role="paragraph" l10n="NEW"><link href="http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Writer">Wiki page about regular expressions in Writer</link></paragraph> +<switch select="appl"> +<case select="WRITER"><embed href="text/swriter/guide/search_regexp.xhp#search_regexp"/> + <embed href="text/swriter/guide/finding.xhp#finding"/> +</case> +</switch> +<paragraph xml-lang="en-US" id="par_id1751457" role="paragraph" l10n="NEW"><link href="http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Writer">Wiki page about regular expressions in Writer</link></paragraph> <paragraph xml-lang="en-US" id="par_id5483870" role="paragraph" l10n="NEW"><link href="http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Calc">Wiki page about regular expressions in Calc</link></paragraph> </section> </body> diff --git a/helpcontent2/source/text/shared/01/05020301.xhp b/helpcontent2/source/text/shared/01/05020301.xhp index 567c64a43b..f8045f39ba 100644 --- a/helpcontent2/source/text/shared/01/05020301.xhp +++ b/helpcontent2/source/text/shared/01/05020301.xhp @@ -10,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 05020301.xhp,v $ - * $Revision: 1.13.4.1 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -35,1082 +35,1103 @@ <meta> -<topic id="textshared0105020301xml" indexer="include"> -<title id="tit" xml-lang="en-US">Number Format Codes</title> -<filename>/text/shared/01/05020301.xhp</filename> -</topic> -</meta> -<body> + <topic id="textshared0105020301xml" indexer="include"> + <title xml-lang="en-US" id="tit">Number Format Codes</title> + <filename>/text/shared/01/05020301.xhp</filename> + </topic> + </meta> + <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3153514"><bookmark_value>format codes; numbers</bookmark_value> -<bookmark_value>conditions; in number formats</bookmark_value> -<bookmark_value>number formats; codes</bookmark_value> -<bookmark_value>currency formats</bookmark_value> -<bookmark_value>formats;of currencies/date/time</bookmark_value> -<bookmark_value>numbers; date, time and currency formats</bookmark_value> -<bookmark_value>Euro; currency formats</bookmark_value> -<bookmark_value>date formats</bookmark_value> -<bookmark_value>times, formats</bookmark_value> -</bookmark><comment>mw made "time formats" a two level entry and deleted 2x "formats;"</comment> -<paragraph role="heading" id="hd_id3153514" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="zahlenformatcodes"><link href="text/shared/01/05020301.xhp" name="Number Format Codes">Number Format Codes</link> + <bookmark_value>conditions; in number formats</bookmark_value> + <bookmark_value>number formats; codes</bookmark_value> + <bookmark_value>currency formats</bookmark_value> + <bookmark_value>formats;of currencies/date/time</bookmark_value> + <bookmark_value>numbers; date, time and currency formats</bookmark_value> + <bookmark_value>Euro; currency formats</bookmark_value> + <bookmark_value>date formats</bookmark_value> + <bookmark_value>times;formats</bookmark_value> +</bookmark><comment>mw made "time formats" a two level entry and deleted 2x "formats;"</comment><comment>mw corrected a typo in "times, formats"</comment> +<paragraph xml-lang="en-US" id="hd_id3153514" role="heading" level="1" l10n="U" oldref="1"><variable id="zahlenformatcodes"><link href="text/shared/01/05020301.xhp" name="Number Format Codes">Number Format Codes</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3150467" xml-lang="en-US" l10n="U" oldref="88">Number format codes can consist of up to three sections separated by a semicolon (;).</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id3150146" xml-lang="en-US" l10n="U" oldref="108">In a number format code with two sections, the first section applies to positive values and zero, and the second section applies to negative values.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3158442" xml-lang="en-US" l10n="CHG" oldref="109">In a number format code with three sections, the first section applies to positive values, the second section to negative values, and the third section to the value zero.</paragraph> -</listitem> -</list> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id3155069" xml-lang="en-US" l10n="U" oldref="110">You can also assign conditions to the three sections, so that the format is only applied if a condition is met.</paragraph> -</listitem> -</list> -<paragraph role="heading" id="hd_id3151262" xml-lang="en-US" level="2" l10n="U" oldref="229">Decimal Places and Significant Digits</paragraph> -<paragraph role="paragraph" id="par_id3153624" xml-lang="en-US" l10n="U" oldref="3">Use zero (0) or the number sign (#) as placeholders in your number format code to represent numbers. The (#) only displays significant digits, while the (0) displays zeroes if there are fewer digits in the number than in the number format.</paragraph> -<paragraph role="paragraph" id="par_id3153323" xml-lang="en-US" l10n="U" oldref="107">Use question marks (?) to represent the number of digits to include in the numerator and the denominator of a fraction. Fractions that do not fit the pattern that you define are displayed as floating point numbers.</paragraph> -<paragraph role="paragraph" id="par_id3148440" xml-lang="en-US" l10n="U" oldref="4">If a number contains more digits to the right of the decimal delimiter than there are placeholders in the format, the number is rounded accordingly. If a number contains more digits to the left of the decimal delimiter than there are placeholders in the format, the entire number is displayed. Use the following list as a guide for using placeholders when you create a number format code:</paragraph> -<table id="tbl_id3149760"> -<tablerow> -<tablecell> -<paragraph role="tablehead" id="par_id3150902" xml-lang="en-US" l10n="U" oldref="86">Placeholders</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id3157896" xml-lang="en-US" l10n="U" oldref="87">Explanation</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3152801" xml-lang="en-US" l10n="U" oldref="5">#</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3145090" xml-lang="en-US" l10n="U" oldref="6">Does not display extra zeros.</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3147088" xml-lang="en-US" l10n="U" oldref="7">0 (Zero)</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3150774" xml-lang="en-US" l10n="U" oldref="8">Displays extra zeros if the number has less places than zeros in the format.</paragraph> -</tablecell> -</tablerow> -</table> + <paragraph xml-lang="en-US" id="par_id3150467" role="paragraph" l10n="U" oldref="88">Number format codes can consist of up to three sections separated by a semicolon (;).</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3150146" role="listitem" l10n="U" oldref="108">In a number format code with two sections, the first section applies to positive values and zero, and the second section applies to negative values.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3158442" role="listitem" l10n="CHG" oldref="109">In a number format code with three sections, the first section applies to positive values, the second section to negative values, and the third section to the value zero.</paragraph> + </listitem> + </list> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3155069" role="listitem" l10n="U" oldref="110">You can also assign conditions to the three sections, so that the format is only applied if a condition is met.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="hd_id3151262" role="heading" level="2" l10n="U" + oldref="229">Decimal Places and Significant Digits</paragraph> + <paragraph xml-lang="en-US" id="par_id3153624" role="paragraph" l10n="U" oldref="3">Use zero (0) or the number sign (#) as placeholders in your number format code to represent numbers. The (#) only displays significant digits, while the (0) displays zeroes if there are fewer digits in the number than in the number format.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153323" role="paragraph" l10n="U" oldref="107">Use question marks (?) to represent the number of digits to include in the numerator and the denominator of a fraction. Fractions that do not fit the pattern that you define are displayed as floating point numbers.</paragraph> + <paragraph xml-lang="en-US" id="par_id3148440" role="paragraph" l10n="U" oldref="4">If a number contains more digits to the right of the decimal delimiter than there are placeholders in the format, the number is rounded accordingly. If a number contains more digits to the left of the decimal delimiter than there are placeholders in the format, the entire number is displayed. Use the following list as a guide for using placeholders when you create a number format code:</paragraph> + <table id="tbl_id3149760"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150902" role="tablehead" l10n="U" oldref="86">Placeholders</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3157896" role="tablehead" l10n="U" oldref="87">Explanation</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152801" role="code" l10n="U" oldref="5">#</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3145090" role="tablecontent" l10n="U" oldref="6">Does not display extra zeros.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147088" role="code" l10n="U" oldref="7">0 (Zero)</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150774" role="tablecontent" l10n="U" oldref="8">Displays extra zeros if the number has less places than zeros in the format.</paragraph> + </tablecell> + </tablerow> + </table> -<paragraph role="heading" id="par_idN1087E" xml-lang="en-US" level="3" l10n="NEW">Examples</paragraph> -<table id="tbl_id3153577"> -<tablerow> -<tablecell> -<paragraph role="tablehead" id="par_id3149182" xml-lang="en-US" l10n="U" oldref="9">Number Format</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id3154749" xml-lang="en-US" l10n="U" oldref="10">Format Code</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3148538" xml-lang="en-US" l10n="U" oldref="11">3456.78 as 3456.8</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3150355" xml-lang="en-US" l10n="U" oldref="12">####.#</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3154142" xml-lang="en-US" l10n="U" oldref="13">9.9 as 9.900</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3159256" xml-lang="en-US" l10n="U" oldref="14">#.000</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3147077" xml-lang="en-US" l10n="U" oldref="15">13 as 13.0 and 1234.567 as 1234.57</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3155388" xml-lang="en-US" l10n="U" oldref="16">#.0#</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3149578" xml-lang="en-US" l10n="U" oldref="17">5.75 as 5 3/4 and 6.3 as 6 3/10</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3145315" xml-lang="en-US" l10n="U" oldref="18"># ???/???</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3156152" xml-lang="en-US" l10n="U" oldref="19">.5 as 0.5</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3149762" xml-lang="en-US" l10n="U" oldref="20">0.##</paragraph> -</tablecell> -</tablerow> -</table> + <paragraph xml-lang="en-US" id="par_idN1087E" role="heading" level="3" l10n="NEW">Examples</paragraph> + <table id="tbl_id3153577"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149182" role="tablehead" l10n="U" oldref="9">Number Format</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154749" role="tablehead" l10n="U" oldref="10">Format Code</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148538" role="tablecontent" l10n="U" oldref="11">3456.78 as 3456.8</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150355" role="code" l10n="U" oldref="12">####.#</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154142" role="tablecontent" l10n="U" oldref="13">9.9 as 9.900</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3159256" role="code" l10n="U" oldref="14">#.000</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147077" role="tablecontent" l10n="U" oldref="15">13 as 13.0 and 1234.567 as 1234.57</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155388" role="code" l10n="U" oldref="16">#.0#</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149578" role="tablecontent" l10n="U" oldref="17">5.75 as 5 3/4 and 6.3 as 6 3/10</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3145315" role="code" l10n="U" oldref="18"># ???/???</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3156152" role="tablecontent" l10n="U" oldref="19">.5 as 0.5</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149762" role="code" l10n="U" oldref="20">0.##</paragraph> + </tablecell> + </tablerow> + </table> -<paragraph role="heading" id="hd_id3149276" xml-lang="en-US" level="3" l10n="U" oldref="230">Thousands Separator</paragraph> -<paragraph role="paragraph" id="par_id3154380" xml-lang="en-US" l10n="U" oldref="21">Depending on your language setting, you can use a comma or a period as a thousands separator. You can also use the separator to reduce the size of the number that is displayed by a multiple of 1000.</paragraph> -<table id="tbl_id3150244"> -<tablerow> -<tablecell> -<paragraph role="tablehead" id="par_id3154905" xml-lang="en-US" l10n="U" oldref="22">Number Format</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id3150822" xml-lang="en-US" l10n="U" oldref="23">Format Code</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3147264" xml-lang="en-US" l10n="U" oldref="24">15000 as 15,000</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3151223" xml-lang="en-US" l10n="U" oldref="25">#,###</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3154935" xml-lang="en-US" l10n="U" oldref="26">16000 as 16</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3153961" xml-lang="en-US" l10n="U" oldref="27">#,</paragraph> -</tablecell> -</tablerow> -</table> + <paragraph xml-lang="en-US" id="hd_id3149276" role="heading" level="3" l10n="U" + oldref="230">Thousands Separator</paragraph> + <paragraph xml-lang="en-US" id="par_id3154380" role="paragraph" l10n="U" oldref="21">Depending on your language setting, you can use a comma or a period as a thousands separator. You can also use the separator to reduce the size of the number that is displayed by a multiple of 1000.</paragraph> + <table id="tbl_id3150244"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154905" role="tablehead" l10n="U" oldref="22">Number Format</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150822" role="tablehead" l10n="U" oldref="23">Format Code</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147264" role="tablecontent" l10n="U" oldref="24">15000 as 15,000</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3151223" role="code" l10n="U" oldref="25">#,###</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154935" role="tablecontent" l10n="U" oldref="26">16000 as 16</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153961" role="code" l10n="U" oldref="27">#,</paragraph> + </tablecell> + </tablerow> + </table> -<paragraph role="heading" id="hd_id3154836" xml-lang="en-US" level="2" l10n="U" oldref="79">Including Text in Number Format Codes</paragraph> -<paragraph role="heading" id="hd_id3150398" xml-lang="en-US" level="3" l10n="U" oldref="231">Text and Numbers</paragraph> -<paragraph role="paragraph" id="par_id3154224" xml-lang="en-US" l10n="U" oldref="80">To include text in a number format that is applied to a cell containing numbers, place a double quotation mark (") in front of and behind the text, or a backslash (\) before a single character. For example, enter <emph>#.# "meters"</emph> to display "3.5 meters" or <emph>#.# \m</emph> to display "3.5 m".</paragraph> -<paragraph role="heading" id="hd_id3148979" xml-lang="en-US" level="3" l10n="U" oldref="232">Text and Text</paragraph> -<paragraph role="paragraph" id="par_id3153338" xml-lang="en-US" l10n="U" oldref="82">To include text in a number format that is applied to a cell that might contain text, enclose the text by double quotation marks (" "), and then add an at sign (@). For example, enter <emph>"Total for "@</emph> to display "Total for December".</paragraph> -<paragraph role="heading" id="hd_id3154330" xml-lang="en-US" level="3" l10n="U" oldref="233">Spaces</paragraph> -<paragraph role="paragraph" id="par_id3156294" xml-lang="en-US" l10n="U" oldref="81">To use a character to define the width of a space in a number format, type an underscore ( _ ) followed by the character. The width of the space varies according to the width of the character that you choose. For example, <emph>_M</emph> creates a wider space than <emph>_i</emph>.</paragraph> -<paragraph role="heading" id="hd_id3155994" xml-lang="en-US" level="2" l10n="U" oldref="234">Color</paragraph> -<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US" l10n="U" oldref="28">To set the color of a section of a number format code, insert one of the following color names in square brackets [ ]:</paragraph> -<table id="tbl_id3157321"> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3154630" xml-lang="en-US" l10n="U" oldref="29">CYAN</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3148676" xml-lang="en-US" l10n="U" oldref="30">GREEN</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3154123" xml-lang="en-US" l10n="U" oldref="31">BLACK</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3149167" xml-lang="en-US" l10n="U" oldref="32">BLUE</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3158407" xml-lang="en-US" l10n="U" oldref="33">MAGENTA</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3149560" xml-lang="en-US" l10n="U" oldref="34">RED</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3147502" xml-lang="en-US" l10n="U" oldref="35">WHITE</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3153368" xml-lang="en-US" l10n="U" oldref="36">YELLOW</paragraph> -</tablecell> -</tablerow> -</table> + <paragraph xml-lang="en-US" id="hd_id3154836" role="heading" level="2" l10n="U" + oldref="79">Including Text in Number Format Codes</paragraph> + <paragraph xml-lang="en-US" id="hd_id3150398" role="heading" level="3" l10n="U" + oldref="231">Text and Numbers</paragraph> + <paragraph xml-lang="en-US" id="par_id3154224" role="paragraph" l10n="U" oldref="80">To include text in a number format that is applied to a cell containing numbers, place a double quotation mark (") in front of and behind the text, or a backslash (\) before a single character. For example, enter <emph>#.# "meters"</emph> to display "3.5 meters" or <emph>#.# \m</emph> to display "3.5 m".</paragraph> + <paragraph xml-lang="en-US" id="hd_id3148979" role="heading" level="3" l10n="U" + oldref="232">Text and Text</paragraph> + <paragraph xml-lang="en-US" id="par_id3153338" role="paragraph" l10n="U" oldref="82">To include text in a number format that is applied to a cell that might contain text, enclose the text by double quotation marks (" "), and then add an at sign (@). For example, enter <emph>"Total for "@</emph> to display "Total for December".</paragraph> + <paragraph xml-lang="en-US" id="hd_id3154330" role="heading" level="3" l10n="U" + oldref="233">Spaces</paragraph> + <paragraph xml-lang="en-US" id="par_id3156294" role="paragraph" l10n="U" oldref="81">To use a character to define the width of a space in a number format, type an underscore ( _ ) followed by the character. The width of the space varies according to the width of the character that you choose. For example, <emph>_M</emph> creates a wider space than <emph>_i</emph>.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3155994" role="heading" level="2" l10n="U" + oldref="234">Color</paragraph> + <paragraph xml-lang="en-US" id="par_id3156423" role="paragraph" l10n="U" oldref="28">To set the color of a section of a number format code, insert one of the following color names in square brackets [ ]:</paragraph> + <table id="tbl_id3157321"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154630" role="code" l10n="U" oldref="29">CYAN</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148676" role="code" l10n="U" oldref="30">GREEN</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154123" role="code" l10n="U" oldref="31">BLACK</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149167" role="code" l10n="U" oldref="32">BLUE</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3158407" role="code" l10n="U" oldref="33">MAGENTA</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149560" role="code" l10n="U" oldref="34">RED</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147502" role="code" l10n="U" oldref="35">WHITE</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153368" role="code" l10n="U" oldref="36">YELLOW</paragraph> + </tablecell> + </tablerow> + </table> -<paragraph role="heading" id="hd_id3147435" xml-lang="en-US" level="2" l10n="U" oldref="111">Conditions</paragraph> -<paragraph role="heading" id="hd_id3148575" xml-lang="en-US" level="3" l10n="U" oldref="235">Conditional Brackets</paragraph> -<paragraph role="paragraph" id="par_id3155312" xml-lang="en-US" l10n="U" oldref="112">You can define a number format so that it only applies when the condition that you specify is met. Conditions are enclosed by square brackets [ ].</paragraph> -<paragraph role="paragraph" id="par_id3159179" xml-lang="en-US" l10n="U" oldref="115">You can use any combination of numbers and the <, <=, >, >=, = and <> operators.</paragraph> -<paragraph role="paragraph" id="par_id3159196" xml-lang="en-US" l10n="U" oldref="236">For example, if you want to apply different colors to different temperature data, enter:</paragraph> -<paragraph role="example" id="par_id3150872" xml-lang="en-US" l10n="U" oldref="113">[BLUE][<0]#,0 "°C";[RED][>30]#,0 "°C";[BLACK]#,0 "°C"</paragraph> -<paragraph role="paragraph" id="par_id3157870" xml-lang="en-US" l10n="U" oldref="114">All temperatures below zero are blue, temperatures between 0 and 30 °C are black, and temperatures higher than 30 °C are red.</paragraph> -<paragraph role="heading" id="hd_id3154833" xml-lang="en-US" level="3" l10n="U" oldref="90">Positive and Negative Numbers</paragraph> -<paragraph role="paragraph" id="par_id3147295" xml-lang="en-US" l10n="U" oldref="91">To define a number format that adds a different text to a number depending on if the number is positive, negative, or equal to zero, use the following format:</paragraph> -<paragraph role="example" id="par_id3153727" xml-lang="en-US" l10n="U" oldref="92">"plus" 0;"minus" 0;"null" 0</paragraph> -<paragraph role="heading" id="hd_id3149260" xml-lang="en-US" level="2" l10n="U" oldref="83">Percentages and Scientific Notation</paragraph> -<paragraph role="heading" id="hd_id3147218" xml-lang="en-US" level="3" l10n="U" oldref="237">Percentages</paragraph> -<paragraph role="paragraph" id="par_id3151168" xml-lang="en-US" l10n="CHG" oldref="84">To display numbers as percentages, add the percent sign (%) to the number format.</paragraph> -<paragraph role="heading" id="hd_id3156005" xml-lang="en-US" level="3" l10n="U" oldref="89">Scientific Notation</paragraph> -<paragraph role="paragraph" id="par_id3146923" xml-lang="en-US" l10n="U" oldref="85">Scientific notation lets you write very large numbers or very small fractions in a compact form. For example, in scientific notation, 650000 is written as 6.5 x 10^5, and 0.000065 as 6.5 x 10^-5. <comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment>In <item type="productname">%PRODUCTNAME</item>, these numbers are written as 6.5E+5 and 6.5E-5, respectively. To create a number format that displays numbers using scientific notation, enter a # or 0, and then one of the following codes E-, E+, e- or e+.</paragraph> -<paragraph role="heading" id="hd_id3159080" xml-lang="en-US" level="2" l10n="U" oldref="98">Number Format Codes of Currency Formats</paragraph> -<paragraph role="paragraph" id="par_id3147318" xml-lang="en-US" l10n="CHG" oldref="99">The default currency format for the cells in your spreadsheet is determined by the regional setting of your operating system. If you want, you can apply a custom currency symbol to a cell. For example, enter #,##0.00 € to display 4.50 € (Euros).<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph> -<paragraph role="paragraph" id="par_id3150032" xml-lang="en-US" l10n="U" oldref="167">You can also specify the locale setting for the currency by entering the locale code for the country after the symbol. For example, [$€-407] represents Euros in Germany. To view the locale code for a country, select the country in the <emph>Language</emph> list on the <emph>Numbers</emph> tab of the <emph>Format Cells</emph> dialog.</paragraph> -<embed href="text/shared/01/05020300.xhp#waehrungtext"/> -<paragraph role="heading" id="hd_id3157309" xml-lang="en-US" level="2" l10n="U" oldref="238">Date and Time Formats</paragraph> -<paragraph role="heading" id="hd_id3153740" xml-lang="en-US" level="3" l10n="U" oldref="37">Date Formats</paragraph> -<paragraph role="paragraph" id="par_id3152791" xml-lang="en-US" l10n="U" oldref="38">To display days, months and years, use the following number format codes. </paragraph> -<paragraph role="warning" id="par_id610980" xml-lang="en-US" l10n="NEW">Not all format codes give meaningful results for all languages.</paragraph> -<table id="tbl_id3147426"> -<tablerow> -<tablecell> -<paragraph role="tablehead" id="par_id3152376" xml-lang="en-US" l10n="U" oldref="39">Format</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id3159130" xml-lang="en-US" l10n="U" oldref="40">Format Code</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3147380" xml-lang="en-US" l10n="U" oldref="41">Month as 3.</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3146928" xml-lang="en-US" l10n="U" oldref="42">M</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3145594" xml-lang="en-US" l10n="U" oldref="43">Month as 03.</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3153052" xml-lang="en-US" l10n="U" oldref="44">MM</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3145728" xml-lang="en-US" l10n="U" oldref="45">Month as Jan-Dec</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3151073" xml-lang="en-US" l10n="U" oldref="46">MMM</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3149909" xml-lang="en-US" l10n="U" oldref="47">Month as January-December</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3155318" xml-lang="en-US" l10n="U" oldref="48">MMMM</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3151218" xml-lang="en-US" l10n="U" oldref="116">First letter of Name of Month</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3150420" xml-lang="en-US" l10n="U" oldref="117">MMMMM</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3154501" xml-lang="en-US" l10n="U" oldref="49">Day as 2</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3156181" xml-lang="en-US" l10n="U" oldref="50">D</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3146969" xml-lang="en-US" l10n="U" oldref="51">Day as 02</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3156358" xml-lang="en-US" l10n="U" oldref="52">DD</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3148495" xml-lang="en-US" l10n="U" oldref="53">Day as Sun-Sat</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3161665" xml-lang="en-US" l10n="U" oldref="54">NN or DDD</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3154272" xml-lang="en-US" l10n="U" oldref="118">Day as Sunday to Saturday</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3145164" xml-lang="en-US" l10n="U" oldref="119">NNN or DDDD</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3146791" xml-lang="en-US" l10n="U" oldref="55">Day followed by comma, as in "Sunday,"</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3146081" xml-lang="en-US" l10n="U" oldref="56">NNNN</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3156275" xml-lang="en-US" l10n="U" oldref="57">Year as 00-99</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3143236" xml-lang="en-US" l10n="U" oldref="58">YY</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3148408" xml-lang="en-US" l10n="U" oldref="59">Year as 1900-2078</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3151358" xml-lang="en-US" l10n="U" oldref="60">YYYY</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3153355" xml-lang="en-US" l10n="U" oldref="96">Calendar week</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3150744" xml-lang="en-US" l10n="U" oldref="97">WW</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3154302" xml-lang="en-US" l10n="U" oldref="103">Quarterly as Q1 to Q4</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3159266" xml-lang="en-US" l10n="CHG" oldref="104">Q</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3147583" xml-lang="en-US" l10n="U" oldref="105">Quarterly as 1st quarter to 4th quarter</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3146918" xml-lang="en-US" l10n="U" oldref="106">QQ</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3147534" xml-lang="en-US" l10n="U" oldref="120">Era on the Japanese Gengou calendar, single character (possible values are: M, T, S, H)</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3151249" xml-lang="en-US" l10n="U" oldref="121">G</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3163806" xml-lang="en-US" l10n="U" oldref="122">Era, abbreviation</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3155962" xml-lang="en-US" l10n="U" oldref="123">GG</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3151187" xml-lang="en-US" l10n="U" oldref="124">Era, full name</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3149568" xml-lang="en-US" l10n="U" oldref="125">GGG</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3147344" xml-lang="en-US" l10n="U" oldref="126">Number of the year within an era, without a leading zero for single-digit years</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3147255" xml-lang="en-US" l10n="U" oldref="127">E</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3148487" xml-lang="en-US" l10n="U" oldref="128">Number of the year within an era, with a leading zero for single-digit years</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3150298" xml-lang="en-US" l10n="U" oldref="129">EE or R</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3152861" xml-lang="en-US" l10n="U" oldref="138">Era, full name and year</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3149926" xml-lang="en-US" l10n="U" oldref="139">RR or GGGEE</paragraph> -</tablecell> -</tablerow> -</table> + <paragraph xml-lang="en-US" id="hd_id3147435" role="heading" level="2" l10n="U" + oldref="111">Conditions</paragraph> + <paragraph xml-lang="en-US" id="hd_id3148575" role="heading" level="3" l10n="U" + oldref="235">Conditional Brackets</paragraph> + <paragraph xml-lang="en-US" id="par_id3155312" role="paragraph" l10n="U" oldref="112">You can define a number format so that it only applies when the condition that you specify is met. Conditions are enclosed by square brackets [ ].</paragraph> + <paragraph xml-lang="en-US" id="par_id3159179" role="paragraph" l10n="U" oldref="115">You can use any combination of numbers and the <, <=, >, >=, = and <> operators.</paragraph> + <paragraph xml-lang="en-US" id="par_id3159196" role="paragraph" l10n="U" oldref="236">For example, if you want to apply different colors to different temperature data, enter:</paragraph> + <paragraph xml-lang="en-US" id="par_id3150872" role="example" l10n="U" oldref="113">[BLUE][<0]#,0 "°C";[RED][>30]#,0 "°C";[BLACK]#,0 "°C"</paragraph> + <paragraph xml-lang="en-US" id="par_id3157870" role="paragraph" l10n="U" oldref="114">All temperatures below zero are blue, temperatures between 0 and 30 °C are black, and temperatures higher than 30 °C are red.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3154833" role="heading" level="3" l10n="U" + oldref="90">Positive and Negative Numbers</paragraph> + <paragraph xml-lang="en-US" id="par_id3147295" role="paragraph" l10n="U" oldref="91">To define a number format that adds a different text to a number depending on if the number is positive, negative, or equal to zero, use the following format:</paragraph> + <paragraph xml-lang="en-US" id="par_id3153727" role="example" l10n="U" oldref="92">"plus" 0;"minus" 0;"null" 0</paragraph> + <paragraph xml-lang="en-US" id="hd_id3149260" role="heading" level="2" l10n="U" + oldref="83">Percentages and Scientific Notation</paragraph> + <paragraph xml-lang="en-US" id="hd_id3147218" role="heading" level="3" l10n="U" + oldref="237">Percentages</paragraph> + <paragraph xml-lang="en-US" id="par_id3151168" role="paragraph" l10n="CHG" oldref="84">To display numbers as percentages, add the percent sign (%) to the number format.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3156005" role="heading" level="3" l10n="U" + oldref="89">Scientific Notation</paragraph> + <paragraph xml-lang="en-US" id="par_id3146923" role="paragraph" l10n="U" oldref="85">Scientific notation lets you write very large numbers or very small fractions in a compact form. For example, in scientific notation, 650000 is written as 6.5 x 10^5, and 0.000065 as 6.5 x 10^-5. <comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment>In <item type="productname">%PRODUCTNAME</item>, these numbers are written as 6.5E+5 and 6.5E-5, respectively. To create a number format that displays numbers using scientific notation, enter a # or 0, and then one of the following codes E-, E+, e- or e+.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3159080" role="heading" level="2" l10n="U" + oldref="98">Number Format Codes of Currency Formats</paragraph> + <paragraph xml-lang="en-US" id="par_id3147318" role="paragraph" l10n="CHG" oldref="99">The default currency format for the cells in your spreadsheet is determined by the regional setting of your operating system. If you want, you can apply a custom currency symbol to a cell. For example, enter #,##0.00 € to display 4.50 € (Euros).<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph> + <paragraph xml-lang="en-US" id="par_id3150032" role="paragraph" l10n="U" oldref="167">You can also specify the locale setting for the currency by entering the locale code for the country after the symbol. For example, [$€-407] represents Euros in Germany. To view the locale code for a country, select the country in the <emph>Language</emph> list on the <emph>Numbers</emph> tab of the <emph>Format Cells</emph> dialog.</paragraph> + <embed href="text/shared/01/05020300.xhp#waehrungtext"/> + <paragraph xml-lang="en-US" id="hd_id3157309" role="heading" level="2" l10n="U" + oldref="238">Date and Time Formats</paragraph> + <paragraph xml-lang="en-US" id="hd_id3153740" role="heading" level="3" l10n="U" + oldref="37">Date Formats</paragraph> + <paragraph xml-lang="en-US" id="par_id3152791" role="paragraph" l10n="U" oldref="38">To display days, months and years, use the following number format codes. </paragraph> + <paragraph xml-lang="en-US" id="par_id610980" role="warning" l10n="NEW">Not all format codes give meaningful results for all languages.</paragraph> + <table id="tbl_id3147426"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152376" role="tablehead" l10n="U" oldref="39">Format</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3159130" role="tablehead" l10n="U" oldref="40">Format Code</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147380" role="tablecontent" l10n="U" oldref="41">Month as 3.</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3146928" role="code" l10n="U" oldref="42">M</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3145594" role="tablecontent" l10n="U" oldref="43">Month as 03.</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153052" role="code" l10n="U" oldref="44">MM</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3145728" role="tablecontent" l10n="U" oldref="45">Month as Jan-Dec</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3151073" role="code" l10n="U" oldref="46">MMM</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149909" role="tablecontent" l10n="U" oldref="47">Month as January-December</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155318" role="code" l10n="U" oldref="48">MMMM</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3151218" role="tablecontent" l10n="U" oldref="116">First letter of Name of Month</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150420" role="code" l10n="U" oldref="117">MMMMM</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154501" role="tablecontent" l10n="U" oldref="49">Day as 2</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3156181" role="code" l10n="U" oldref="50">D</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3146969" role="tablecontent" l10n="U" oldref="51">Day as 02</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3156358" role="code" l10n="U" oldref="52">DD</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148495" role="tablecontent" l10n="U" oldref="53">Day as Sun-Sat</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3161665" role="code" l10n="U" oldref="54">NN or DDD</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154272" role="tablecontent" l10n="U" oldref="118">Day as Sunday to Saturday</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3145164" role="code" l10n="U" oldref="119">NNN or DDDD</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3146791" role="tablecontent" l10n="U" oldref="55">Day followed by comma, as in "Sunday,"</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3146081" role="code" l10n="U" oldref="56">NNNN</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3156275" role="tablecontent" l10n="U" oldref="57">Year as 00-99</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3143236" role="code" l10n="U" oldref="58">YY</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148408" role="tablecontent" l10n="U" oldref="59">Year as 1900-2078</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3151358" role="code" l10n="U" oldref="60">YYYY</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153355" role="tablecontent" l10n="U" oldref="96">Calendar week</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150744" role="code" l10n="U" oldref="97">WW</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154302" role="tablecontent" l10n="U" oldref="103">Quarterly as Q1 to Q4</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3159266" role="code" l10n="CHG" oldref="104">Q</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147583" role="tablecontent" l10n="U" oldref="105">Quarterly as 1st quarter to 4th quarter</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3146918" role="code" l10n="U" oldref="106">QQ</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147534" role="tablecontent" l10n="U" oldref="120">Era on the Japanese Gengou calendar, single character (possible values are: M, T, S, H)</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3151249" role="code" l10n="U" oldref="121">G</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3163806" role="tablecontent" l10n="U" oldref="122">Era, abbreviation</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155962" role="code" l10n="U" oldref="123">GG</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3151187" role="tablecontent" l10n="U" oldref="124">Era, full name</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149568" role="code" l10n="U" oldref="125">GGG</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147344" role="tablecontent" l10n="U" oldref="126">Number of the year within an era, without a leading zero for single-digit years</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147255" role="code" l10n="U" oldref="127">E</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148487" role="tablecontent" l10n="U" oldref="128">Number of the year within an era, with a leading zero for single-digit years</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150298" role="code" l10n="U" oldref="129">EE or R</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152861" role="tablecontent" l10n="U" oldref="138">Era, full name and year</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149926" role="code" l10n="U" oldref="139">RR or GGGEE</paragraph> + </tablecell> + </tablerow> + </table> -<paragraph role="paragraph" id="par_id1002200811423518" xml-lang="en-US" l10n="NEW">The above listed formatting codes work with your language version of %PRODUCTNAME. However, when you need to switch the locale of %PRODUCTNAME to another locale, you will need to know the formatting codes used in that other locale. </paragraph> -<paragraph role="paragraph" id="par_id1002200811423556" xml-lang="en-US" l10n="NEW">For example, if your software is set to an English locale, and you want to format a year with four digits, you enter YYYY as a formatting code. When you switch to a German locale, you must use JJJJ instead. The following table lists only the localized differences.</paragraph> -<table id="tbl_id1002200811465915"> -<tablerow> -<tablecell> -<paragraph role="tablehead" id="par_id1002200811563044" xml-lang="en-US" l10n="NEW">Locale</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id1002200811563137" xml-lang="en-US" l10n="NEW">Year</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id1002200811563164" xml-lang="en-US" l10n="NEW">Month</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id1002200811563128" xml-lang="en-US" l10n="NEW">Day</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id1002200811563135" xml-lang="en-US" l10n="NEW">Hour</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id1002200811563289" xml-lang="en-US" l10n="NEW">Day Of Week</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id100220081156322" xml-lang="en-US" l10n="NEW">Era</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563233" xml-lang="en-US" l10n="NEW">English - en</paragraph> -<paragraph role="tablecontent" id="par_id1002200811563243" xml-lang="en-US" l10n="NEW">and all not listed locales</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563352" xml-lang="en-US" l10n="NEW">Y</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563396" xml-lang="en-US" l10n="NEW">M</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563385" xml-lang="en-US" l10n="NEW">D</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563472" xml-lang="en-US" l10n="NEW">H</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563430" xml-lang="en-US" l10n="NEW">A</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563488" xml-lang="en-US" l10n="NEW">G</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563484" xml-lang="en-US" l10n="NEW">German - de</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563518" xml-lang="en-US" l10n="NEW">J</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563735" xml-lang="en-US" l10n="NEW">T</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563823" xml-lang="en-US" l10n="NEW">Netherlands - nl</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563852" xml-lang="en-US" l10n="NEW">J</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563827" xml-lang="en-US" l10n="NEW">U</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563916" xml-lang="en-US" l10n="NEW">French - fr</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563970" xml-lang="en-US" l10n="NEW">A</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811563980" xml-lang="en-US" l10n="NEW">J</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564065" xml-lang="en-US" l10n="NEW">O</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id100220081156407" xml-lang="en-US" l10n="NEW">Italian - it</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id100220081156403" xml-lang="en-US" l10n="NEW">A</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564042" xml-lang="en-US" l10n="NEW">G</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id100220081156412" xml-lang="en-US" l10n="NEW">O</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564119" xml-lang="en-US" l10n="NEW">X</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564197" xml-lang="en-US" l10n="NEW">Portuguese - pt</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564272" xml-lang="en-US" l10n="NEW">A</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id100220081156423" xml-lang="en-US" l10n="NEW">O</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564218" xml-lang="en-US" l10n="NEW">Spanish - es</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564390" xml-lang="en-US" l10n="NEW">A</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564319" xml-lang="en-US" l10n="NEW">O</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id100220081156433" xml-lang="en-US" l10n="NEW">Danish - da</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id100220081156444" xml-lang="en-US" l10n="NEW">T</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564448" xml-lang="en-US" l10n="NEW">Norwegian - no, nb, nn</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564549" xml-lang="en-US" l10n="NEW">T</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564565" xml-lang="en-US" l10n="NEW">Swedish - sv</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564556" xml-lang="en-US" l10n="NEW">T</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564637" xml-lang="en-US" l10n="NEW">Finnish - fi</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564627" xml-lang="en-US" l10n="NEW">V</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564643" xml-lang="en-US" l10n="NEW">K</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564763" xml-lang="en-US" l10n="NEW">P</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id1002200811564715" xml-lang="en-US" l10n="NEW">T</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -</table> + <paragraph xml-lang="en-US" id="par_id1002200811423518" role="paragraph" l10n="NEW">The above listed formatting codes work with your language version of %PRODUCTNAME. However, when you need to switch the locale of %PRODUCTNAME to another locale, you will need to know the formatting codes used in that other locale. </paragraph> + <paragraph xml-lang="en-US" id="par_id1002200811423556" role="paragraph" l10n="NEW">For example, if your software is set to an English locale, and you want to format a year with four digits, you enter YYYY as a formatting code. When you switch to a German locale, you must use JJJJ instead. The following table lists only the localized differences.</paragraph> + <table id="tbl_id1002200811465915"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563044" role="tablehead" l10n="NEW">Locale</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563137" role="tablehead" l10n="NEW">Year</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563164" role="tablehead" l10n="NEW">Month</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563128" role="tablehead" l10n="NEW">Day</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563135" role="tablehead" l10n="NEW">Hour</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563289" role="tablehead" l10n="NEW">Day Of Week</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id100220081156322" role="tablehead" l10n="NEW">Era</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563233" role="tablecontent" l10n="NEW">English - en</paragraph> + <paragraph xml-lang="en-US" id="par_id1002200811563243" role="tablecontent" l10n="NEW">and all not listed locales</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563352" role="tablecontent" l10n="NEW">Y</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563396" role="tablecontent" l10n="NEW">M</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563385" role="tablecontent" l10n="NEW">D</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563472" role="tablecontent" l10n="NEW">H</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563430" role="tablecontent" l10n="NEW">A</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563488" role="tablecontent" l10n="NEW">G</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563484" role="tablecontent" l10n="NEW">German - de</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563518" role="tablecontent" l10n="NEW">J</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563735" role="tablecontent" l10n="NEW">T</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563823" role="tablecontent" l10n="NEW">Netherlands - nl</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563852" role="tablecontent" l10n="NEW">J</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563827" role="tablecontent" l10n="NEW">U</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563916" role="tablecontent" l10n="NEW">French - fr</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563970" role="tablecontent" l10n="NEW">A</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811563980" role="tablecontent" l10n="NEW">J</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564065" role="tablecontent" l10n="NEW">O</paragraph> + </tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id100220081156407" role="tablecontent" l10n="NEW">Italian - it</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id100220081156403" role="tablecontent" l10n="NEW">A</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564042" role="tablecontent" l10n="NEW">G</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id100220081156412" role="tablecontent" l10n="NEW">O</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564119" role="tablecontent" l10n="NEW">X</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564197" role="tablecontent" l10n="NEW">Portuguese - pt</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564272" role="tablecontent" l10n="NEW">A</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id100220081156423" role="tablecontent" l10n="NEW">O</paragraph> + </tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564218" role="tablecontent" l10n="NEW">Spanish - es</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564390" role="tablecontent" l10n="NEW">A</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564319" role="tablecontent" l10n="NEW">O</paragraph> + </tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id100220081156433" role="tablecontent" l10n="NEW">Danish - da</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id100220081156444" role="tablecontent" l10n="NEW">T</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564448" role="tablecontent" l10n="NEW">Norwegian - no, nb, nn</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564549" role="tablecontent" l10n="NEW">T</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564565" role="tablecontent" l10n="NEW">Swedish - sv</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564556" role="tablecontent" l10n="NEW">T</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564637" role="tablecontent" l10n="NEW">Finnish - fi</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564627" role="tablecontent" l10n="NEW">V</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564643" role="tablecontent" l10n="NEW">K</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564763" role="tablecontent" l10n="NEW">P</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id1002200811564715" role="tablecontent" l10n="NEW">T</paragraph> + </tablecell> + <tablecell> +</tablecell> + <tablecell> +</tablecell> + </tablerow> + </table> -<paragraph role="heading" id="hd_id3149929" xml-lang="en-US" level="3" l10n="U" oldref="227">Entering Dates</paragraph> -<paragraph role="paragraph" id="par_id3148397" xml-lang="en-US" l10n="U" oldref="228">To enter a date in a cell, use the Gregorian calendar format. For example, in an English locale, enter 1/2/2002 for Jan 2, 2002.</paragraph> -<paragraph role="paragraph" id="par_id3153274" xml-lang="en-US" l10n="U" oldref="137">All date formats are dependent on the locale that is set in <emph>Tools - Options - Language settings - Languages</emph>. For example, if your locale is set to 'Japanese', then the Gengou calendar is used. The default date format in <item type="productname">%PRODUCTNAME</item> uses the Gregorian Calendar.</paragraph> -<paragraph role="paragraph" id="par_id3153795" xml-lang="en-US" l10n="U" oldref="216">To specify a calendar format that is independent of the locale, add a modifier in front of the date format. For example, to display a date using the Jewish calendar format in a non-Hebrew locale, enter: [~jewish]DD/MM/YYYY.</paragraph> -<table id="tbl_id3145133"> -<tablerow> -<tablecell> -<paragraph role="tablehead" id="par_id3145764" xml-lang="en-US" l10n="U" oldref="217">Modifier</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id3152967" xml-lang="en-US" l10n="U" oldref="218">Calendar</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3148390" xml-lang="en-US" l10n="U" oldref="219">[~buddhist]</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3153781" xml-lang="en-US" l10n="U" oldref="220">Thai Buddhist Calendar</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3157969" xml-lang="en-US" l10n="U" oldref="133">[~gengou]</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3154656" xml-lang="en-US" l10n="U" oldref="134">Japanese Gengou Calendar</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3150086" xml-lang="en-US" l10n="U" oldref="131">[~gregorian]</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3146070" xml-lang="en-US" l10n="U" oldref="132">Gregorian Calendar</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3146808" xml-lang="en-US" l10n="U" oldref="221">[~hanja] or [~hanja_yoil]</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3149207" xml-lang="en-US" l10n="U" oldref="136">Korean Calendar</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3150304" xml-lang="en-US" l10n="U" oldref="222">[~hijri]</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3149238" xml-lang="en-US" l10n="U" oldref="223">Arabic Islamic Calendar, currently supported for the following locales: ar_EG, ar_LB, ar_SA, and ar_TN</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3154903" xml-lang="en-US" l10n="U" oldref="224">[~jewish]</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3151288" xml-lang="en-US" l10n="U" oldref="225">Jewish Calendar</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="code" id="par_id3166442" xml-lang="en-US" l10n="U" oldref="135">[~ROC]</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3145587" xml-lang="en-US" l10n="U" oldref="226">Republic Of China Calendar</paragraph> -</tablecell> -</tablerow> -</table> + <paragraph xml-lang="en-US" id="hd_id3149929" role="heading" level="3" l10n="U" + oldref="227">Entering Dates</paragraph> + <paragraph xml-lang="en-US" id="par_id3148397" role="paragraph" l10n="U" oldref="228">To enter a date in a cell, use the Gregorian calendar format. For example, in an English locale, enter 1/2/2002 for Jan 2, 2002.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153274" role="paragraph" l10n="U" oldref="137">All date formats are dependent on the locale that is set in <emph>Tools - Options - Language settings - Languages</emph>. For example, if your locale is set to 'Japanese', then the Gengou calendar is used. The default date format in <item type="productname">%PRODUCTNAME</item> uses the Gregorian Calendar.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153795" role="paragraph" l10n="U" oldref="216">To specify a calendar format that is independent of the locale, add a modifier in front of the date format. For example, to display a date using the Jewish calendar format in a non-Hebrew locale, enter: [~jewish]DD/MM/YYYY.</paragraph> + <table id="tbl_id3145133"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3145764" role="tablehead" l10n="U" oldref="217">Modifier</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152967" role="tablehead" l10n="U" oldref="218">Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148390" role="code" l10n="U" oldref="219">[~buddhist]</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153781" role="tablecontent" l10n="U" oldref="220">Thai Buddhist Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3157969" role="code" l10n="U" oldref="133">[~gengou]</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154656" role="tablecontent" l10n="U" oldref="134">Japanese Gengou Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150086" role="code" l10n="U" oldref="131">[~gregorian]</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3146070" role="tablecontent" l10n="U" oldref="132">Gregorian Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3146808" role="code" l10n="U" oldref="221">[~hanja] or [~hanja_yoil]</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149207" role="tablecontent" l10n="U" oldref="136">Korean Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150304" role="code" l10n="U" oldref="222">[~hijri]</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149238" role="tablecontent" l10n="U" oldref="223">Arabic Islamic Calendar, currently supported for the following locales: ar_EG, ar_LB, ar_SA, and ar_TN</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154903" role="code" l10n="U" oldref="224">[~jewish]</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3151288" role="tablecontent" l10n="U" oldref="225">Jewish Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3166442" role="code" l10n="U" oldref="135">[~ROC]</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3145587" role="tablecontent" l10n="U" oldref="226">Republic Of China Calendar</paragraph> + </tablecell> + </tablerow> + </table> -<paragraph role="paragraph" id="par_id3152419" xml-lang="en-US" l10n="U" oldref="140"><switchinline select="appl"><caseinline select="CALC">If you perform a calculation that involves one or more cells using a date format, the result is formatted according to the following mappings: + <paragraph xml-lang="en-US" id="par_id3152419" role="paragraph" l10n="U" oldref="140"><switchinline select="appl"><caseinline select="CALC">If you perform a calculation that involves one or more cells using a date format, the result is formatted according to the following mappings: </caseinline></switchinline></paragraph> <switch select="appl"> <case select="CALC"> <table id="tbl_id3150490"> -<tablerow> -<tablecell> -<paragraph role="tablehead" id="par_id3154194" xml-lang="en-US" l10n="U" oldref="141">Initial Format</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id3149787" xml-lang="en-US" l10n="U" oldref="142">Result Format</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3152993" xml-lang="en-US" l10n="U" oldref="143">Date + Date</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3150292" xml-lang="en-US" l10n="U" oldref="144">Number (Days)</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3150460" xml-lang="en-US" l10n="U" oldref="145">Date + Number</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3154371" xml-lang="en-US" l10n="U" oldref="146">Date</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3145082" xml-lang="en-US" l10n="U" oldref="147">Date + Time</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3156290" xml-lang="en-US" l10n="U" oldref="148">Date&Time</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3152456" xml-lang="en-US" l10n="U" oldref="149">Date + Date&Time</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3156169" xml-lang="en-US" l10n="U" oldref="150">Number</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3154527" xml-lang="en-US" l10n="U" oldref="151">Time + Time</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3159625" xml-lang="en-US" l10n="U" oldref="152">Time</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3146802" xml-lang="en-US" l10n="U" oldref="153">Time + Number</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3146770" xml-lang="en-US" l10n="U" oldref="154">Time</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3155500" xml-lang="en-US" l10n="U" oldref="155">Time + Date&Time</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3155128" xml-lang="en-US" l10n="U" oldref="156">Date&Time</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3152904" xml-lang="en-US" l10n="U" oldref="157">Date&Time + Date&Time</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3159143" xml-lang="en-US" l10n="U" oldref="158">Time</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3148909" xml-lang="en-US" l10n="U" oldref="159">Date&Time + Number</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3154806" xml-lang="en-US" l10n="U" oldref="160">Date&Time</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3151269" xml-lang="en-US" l10n="U" oldref="161">Number + Number</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3154951" xml-lang="en-US" l10n="U" oldref="162">Number</paragraph> -</tablecell> -</tablerow> -</table> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154194" role="tablehead" l10n="U" oldref="141">Initial Format</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149787" role="tablehead" l10n="U" oldref="142">Result Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152993" role="tablecontent" l10n="U" oldref="143">Date + Date</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150292" role="tablecontent" l10n="U" oldref="144">Number (Days)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150460" role="tablecontent" l10n="U" oldref="145">Date + Number</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154371" role="tablecontent" l10n="U" oldref="146">Date</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3145082" role="tablecontent" l10n="U" oldref="147">Date + Time</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3156290" role="tablecontent" l10n="U" oldref="148">Date&Time</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152456" role="tablecontent" l10n="U" oldref="149">Date + Date&Time</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3156169" role="tablecontent" l10n="U" oldref="150">Number</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154527" role="tablecontent" l10n="U" oldref="151">Time + Time</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3159625" role="tablecontent" l10n="U" oldref="152">Time</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3146802" role="tablecontent" l10n="U" oldref="153">Time + Number</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3146770" role="tablecontent" l10n="U" oldref="154">Time</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155500" role="tablecontent" l10n="U" oldref="155">Time + Date&Time</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155128" role="tablecontent" l10n="U" oldref="156">Date&Time</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152904" role="tablecontent" l10n="U" oldref="157">Date&Time + Date&Time</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3159143" role="tablecontent" l10n="U" oldref="158">Time</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148909" role="tablecontent" l10n="U" oldref="159">Date&Time + Number</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154806" role="tablecontent" l10n="U" oldref="160">Date&Time</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3151269" role="tablecontent" l10n="U" oldref="161">Number + Number</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154951" role="tablecontent" l10n="U" oldref="162">Number</paragraph> + </tablecell> + </tablerow> + </table> </case> </switch> -<paragraph role="paragraph" id="par_id3149174" xml-lang="en-US" l10n="U" oldref="163"><switchinline select="appl"><caseinline select="CALC">The Date&Time format displays the date and time that an entry was made to a cell with this format. +<paragraph xml-lang="en-US" id="par_id3149174" role="paragraph" l10n="U" oldref="163"><switchinline select="appl"><caseinline select="CALC">The Date&Time format displays the date and time that an entry was made to a cell with this format. </caseinline></switchinline></paragraph> <switch select="appl"> <case select="CALC"><embed href="text/shared/optionen/01010600.xhp#jahreszahlen"/> -<paragraph role="note" id="par_id3143225" xml-lang="en-US" l10n="U" oldref="164">In <item type="productname">%PRODUCTNAME</item>, a date with the value "0" corresponds to Dec 30, 1899.</paragraph> + <paragraph xml-lang="en-US" id="par_id3143225" role="note" l10n="U" oldref="164">In <item type="productname">%PRODUCTNAME</item>, a date with the value "0" corresponds to Dec 30, 1899.</paragraph> </case> </switch> -<paragraph role="heading" id="hd_id3155870" xml-lang="en-US" level="3" l10n="U" oldref="61">Time Formats</paragraph> -<paragraph role="paragraph" id="par_id3150108" xml-lang="en-US" l10n="U" oldref="62">To display hours, minutes and seconds use the following number format codes.</paragraph> -<table id="tbl_id3154830"> -<tablerow> -<tablecell> -<paragraph role="tablehead" id="par_id3149158" xml-lang="en-US" l10n="U" oldref="63">Format</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id3154341" xml-lang="en-US" l10n="U" oldref="64">Format Code</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3154557" xml-lang="en-US" l10n="U" oldref="65">Hours as 0-23</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3156348" xml-lang="en-US" l10n="U" oldref="66">h</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3143218" xml-lang="en-US" l10n="U" oldref="67">Hours as 00-23</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3155266" xml-lang="en-US" l10n="U" oldref="68">hh</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3150139" xml-lang="en-US" l10n="U" oldref="69">Minutes as 0-59</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3149588" xml-lang="en-US" l10n="U" oldref="70">m</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3150531" xml-lang="en-US" l10n="U" oldref="71">Minutes as 00-59</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3147409" xml-lang="en-US" l10n="U" oldref="72">mm</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3154854" xml-lang="en-US" l10n="U" oldref="73">Seconds as 0-59</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3156173" xml-lang="en-US" l10n="U" oldref="74">s</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3149506" xml-lang="en-US" l10n="U" oldref="75">Seconds as 00-59</paragraph> -</tablecell> -<tablecell> -<paragraph role="code" id="par_id3157981" xml-lang="en-US" l10n="U" oldref="76">ss</paragraph> -</tablecell> -</tablerow> -</table> +<paragraph xml-lang="en-US" id="hd_id3155870" role="heading" level="3" l10n="U" + oldref="61">Time Formats</paragraph> + <paragraph xml-lang="en-US" id="par_id3150108" role="paragraph" l10n="U" oldref="62">To display hours, minutes and seconds use the following number format codes.</paragraph> + <table id="tbl_id3154830"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149158" role="tablehead" l10n="U" oldref="63">Format</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154341" role="tablehead" l10n="U" oldref="64">Format Code</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154557" role="tablecontent" l10n="U" oldref="65">Hours as 0-23</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3156348" role="code" l10n="U" oldref="66">h</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3143218" role="tablecontent" l10n="U" oldref="67">Hours as 00-23</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155266" role="code" l10n="U" oldref="68">hh</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150139" role="tablecontent" l10n="U" oldref="69">Minutes as 0-59</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149588" role="code" l10n="U" oldref="70">m</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150531" role="tablecontent" l10n="U" oldref="71">Minutes as 00-59</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147409" role="code" l10n="U" oldref="72">mm</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154854" role="tablecontent" l10n="U" oldref="73">Seconds as 0-59</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3156173" role="code" l10n="U" oldref="74">s</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149506" role="tablecontent" l10n="U" oldref="75">Seconds as 00-59</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3157981" role="code" l10n="U" oldref="76">ss</paragraph> + </tablecell> + </tablerow> + </table> -<paragraph role="note" id="par_id3156039" xml-lang="en-US" l10n="U" oldref="77">To display seconds as fractions, add the decimal delimiter to your number format code. For example, enter <emph>hh:mm:ss.00</emph> to display the time as "01:02:03.45".<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph> -<paragraph role="paragraph" id="par_id3148649" xml-lang="en-US" l10n="U" oldref="102">If a time is entered in the form 02:03.45 or 01:02:03.45 or 25:01:02, the following formats are assigned if no other time format has been specified: MM:SS.00 or [HH]:MM:SS.00 or [HH]:MM:SS<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph> -<paragraph role="heading" id="hd_id3158404" xml-lang="en-US" level="2" l10n="U" oldref="169">Displaying Numbers Using Native Characters</paragraph> -<paragraph role="paragraph" id="par_id3149998" xml-lang="en-US" l10n="U" oldref="170">To display numbers using native number characters, use a [NatNum1], [NatNum2], ... [NatNum11] modifier at the beginning of a number format codes.</paragraph> -<paragraph role="paragraph" id="par_id3154600" xml-lang="en-US" l10n="U" oldref="171">The [NatNum1] modifier always uses a one to one character mapping to convert numbers to a string that matches the native number format code of the corresponding locale. The other modifiers produce different results if they are used with different locales. A locale can be the language and the territory for which the format code is defined, or a modifier such as [$-yyy] that follows the native number modifier. In this case, yyy is the hexadecimal MS-LCID that is also used in currency format codes. For example, to display a number using Japanese short Kanji characters in an English US locale, use the following number format code:</paragraph> -<paragraph role="example" id="par_id3152546" xml-lang="en-US" l10n="U" oldref="172">[NatNum1][$-411]0</paragraph> -<paragraph role="paragraph" id="par_id3147269" xml-lang="en-US" l10n="U" oldref="173">In the following list, the Microsoft Excel [DBNumX] modifier that corresponds to <item type="productname">%PRODUCTNAME</item> [NatNum] modifier is shown. If you want, you can use a [DBNumX] modifier instead of [NatNum] modifier for your locale. Whenever possible, <item type="productname">%PRODUCTNAME</item> internally maps [DBNumX] modifiers to [NatNumN] modifiers.</paragraph> -<paragraph role="paragraph" id="par_idN11234" xml-lang="en-US" l10n="NEW">Displaying dates using [NatNum] modifiers can have a different effect than displaying other types of numbers. Such effects are indicated by 'CAL: '. For example, 'CAL: 1/4/4' indicates that the year is displayed using the [NatNum1] modifier, while the day and month are displayed using the [NatNum4] modifier. If 'CAL' is not specified, the date formats for that particular modifier are not supported.</paragraph> -<paragraph role="heading" id="par_id3153111" xml-lang="en-US" level="3" l10n="CHG" oldref="174">[NatNum1] Transliterations</paragraph> -<table id="tbl_id1136841"> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3146895" xml-lang="en-US" l10n="U" oldref="175">Chinese: Chinese lower case characters; CAL: 1/7/7 [DBNum1]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3152536" xml-lang="en-US" l10n="U" oldref="176">Japanese: short Kanji characters [DBNum1]; CAL: 1/4/4 [DBNum1]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3146125" xml-lang="en-US" l10n="U" oldref="177">Korean: Korean lower case characters [DBNum1]; CAL: 1/7/7 [DBNum1]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3149945" xml-lang="en-US" l10n="U" oldref="178">Thai: Thai characters</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3153264" xml-lang="en-US" l10n="U" oldref="179">Arabic: Indic characters</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3148973" xml-lang="en-US" l10n="U" oldref="180">Indic: Indic characters</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_idN112A3" xml-lang="en-US" l10n="NEW">Hebrew: Hebrew letters<comment>UFI: api-features "Hebrew numbering"</comment></paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3147520" xml-lang="en-US" l10n="U" oldref="181">[NatNum2] Transliteration in</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3155383" xml-lang="en-US" l10n="U" oldref="182">Chinese: Chinese upper case characters; CAL: 2/8/8 [DBNum2]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3153931" xml-lang="en-US" l10n="U" oldref="183">Japanese: traditional Kanji characters; CAL: 2/5/5 [DBNum2]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3155097" xml-lang="en-US" l10n="U" oldref="184">Korean: Korean upper case characters [DBNum2]; CAL: 2/8/8 [DBNum2]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3152976" xml-lang="en-US" l10n="U" oldref="185">[NatNum3] Transliteration in</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3154353" xml-lang="en-US" l10n="U" oldref="186">Chinese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3154669" xml-lang="en-US" l10n="U" oldref="187">Japanese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3150472" xml-lang="en-US" l10n="U" oldref="188">Korean: fullwidth Arabic digits [DBNum3]; CAL: 3/3/3 [DBNum3]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3157811" xml-lang="en-US" l10n="U" oldref="189">[NatNum4] Transliteration in</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3154592" xml-lang="en-US" l10n="U" oldref="190">Chinese: lower case text [DBNum1]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3150350" xml-lang="en-US" l10n="U" oldref="191">Japanese: modern long Kanji text [DBNum2]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3150930" xml-lang="en-US" l10n="U" oldref="192">Korean: formal lower case text</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3153546" xml-lang="en-US" l10n="U" oldref="193">[NatNum5] Transliteration in</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3155612" xml-lang="en-US" l10n="U" oldref="194">Chinese: Chinese upper case text [DBNum2]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3155909" xml-lang="en-US" l10n="U" oldref="195">Japanese: traditional long Kanji text [DBNum3]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3151304" xml-lang="en-US" l10n="U" oldref="196">Korean: formal upper case text</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3155075" xml-lang="en-US" l10n="U" oldref="197">[NatNum6] Transliteration in</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="U" oldref="198">Chinese: fullwidth text [DBNum3]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3154114" xml-lang="en-US" l10n="U" oldref="199">Japanese: fullwidth text</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3155344" xml-lang="en-US" l10n="U" oldref="200">Korean: fullwidth text</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3155538" xml-lang="en-US" l10n="U" oldref="201">[NatNum7] Transliteration in</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3145123" xml-lang="en-US" l10n="U" oldref="202">Japanese: modern short Kanji text</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3149424" xml-lang="en-US" l10n="U" oldref="203">Korean: informal lower case text</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3153688" xml-lang="en-US" l10n="U" oldref="204">[NatNum8] Transliteration in</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3156122" xml-lang="en-US" l10n="U" oldref="205">Japanese: traditional short Kanji text [DBNum4]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3145602" xml-lang="en-US" l10n="U" oldref="206">Korean: informal upper case text</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3159228" xml-lang="en-US" l10n="U" oldref="207">[NatNum9] Transliteration in</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3154644" xml-lang="en-US" l10n="U" oldref="208">Korean: Hangul characters</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3155396" xml-lang="en-US" l10n="U" oldref="209">[NatNum10] Transliteration in</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3150878" xml-lang="en-US" l10n="U" oldref="210">Korean: formal Hangul text [DBNum4]; CAL: 9/11/11 [DBNum4]</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3149384" xml-lang="en-US" l10n="U" oldref="211">[NatNum11] Transliteration in</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3154213" xml-lang="en-US" l10n="U" oldref="212">Korean: informal Hangul text</paragraph> -</tablecell> -</tablerow> -</table> + <paragraph xml-lang="en-US" id="par_id3156039" role="note" l10n="U" oldref="77">To display seconds as fractions, add the decimal delimiter to your number format code. For example, enter <emph>hh:mm:ss.00</emph> to display the time as "01:02:03.45".<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph> + <paragraph xml-lang="en-US" id="par_id3148649" role="paragraph" l10n="U" oldref="102">If a time is entered in the form 02:03.45 or 01:02:03.45 or 25:01:02, the following formats are assigned if no other time format has been specified: MM:SS.00 or [HH]:MM:SS.00 or [HH]:MM:SS<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph> + <paragraph xml-lang="en-US" id="par_id0929200911242399" role="paragraph" l10n="NEW">To display hours beyond 24, use the [HH]:MM:SS format. For example, the following formula ="12:34:56"+"14:00:00" displays the time in the form of "26:34:56".</paragraph> + <paragraph xml-lang="en-US" id="hd_id3158404" role="heading" level="3" l10n="U" + oldref="169">Displaying Numbers Using Native Characters</paragraph> + <paragraph xml-lang="en-US" id="par_id3149998" role="paragraph" l10n="U" oldref="170">To display numbers using native number characters, use a [NatNum1], [NatNum2], ... [NatNum11] modifier at the beginning of a number format codes.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154600" role="paragraph" l10n="U" oldref="171">The [NatNum1] modifier always uses a one to one character mapping to convert numbers to a string that matches the native number format code of the corresponding locale. The other modifiers produce different results if they are used with different locales. A locale can be the language and the territory for which the format code is defined, or a modifier such as [$-yyy] that follows the native number modifier. In this case, yyy is the hexadecimal MS-LCID that is also used in currency format codes. For example, to display a number using Japanese short Kanji characters in an English US locale, use the following number format code:</paragraph> + <paragraph xml-lang="en-US" id="par_id3152546" role="example" l10n="U" oldref="172">[NatNum1][$-411]0</paragraph> + <paragraph xml-lang="en-US" id="par_id3147269" role="paragraph" l10n="U" oldref="173">In the following list, the Microsoft Excel [DBNumX] modifier that corresponds to <item type="productname">%PRODUCTNAME</item> [NatNum] modifier is shown. If you want, you can use a [DBNumX] modifier instead of [NatNum] modifier for your locale. Whenever possible, <item type="productname">%PRODUCTNAME</item> internally maps [DBNumX] modifiers to [NatNumN] modifiers.</paragraph> + <paragraph xml-lang="en-US" id="par_idN11234" role="paragraph" l10n="NEW">Displaying dates using [NatNum] modifiers can have a different effect than displaying other types of numbers. Such effects are indicated by 'CAL: '. For example, 'CAL: 1/4/4' indicates that the year is displayed using the [NatNum1] modifier, while the day and month are displayed using the [NatNum4] modifier. If 'CAL' is not specified, the date formats for that particular modifier are not supported.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153111" role="heading" level="3" l10n="CHG" + oldref="174">[NatNum1] Transliterations</paragraph> + <table id="tbl_id1136841"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3146895" role="paragraph" l10n="U" oldref="175">Chinese: Chinese lower case characters; CAL: 1/7/7 [DBNum1]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152536" role="paragraph" l10n="U" oldref="176">Japanese: short Kanji characters [DBNum1]; CAL: 1/4/4 [DBNum1]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3146125" role="paragraph" l10n="U" oldref="177">Korean: Korean lower case characters [DBNum1]; CAL: 1/7/7 [DBNum1]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149945" role="paragraph" l10n="U" oldref="178">Thai: Thai characters</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153264" role="paragraph" l10n="U" oldref="179">Arabic: Indic characters</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148973" role="paragraph" l10n="U" oldref="180">Indic: Indic characters</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_idN112A3" role="paragraph" l10n="NEW">Hebrew: Hebrew letters<comment>UFI: api-features "Hebrew numbering"</comment></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147520" role="paragraph" l10n="U" oldref="181">[NatNum2] Transliteration in</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155383" role="paragraph" l10n="U" oldref="182">Chinese: Chinese upper case characters; CAL: 2/8/8 [DBNum2]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153931" role="paragraph" l10n="U" oldref="183">Japanese: traditional Kanji characters; CAL: 2/5/5 [DBNum2]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155097" role="paragraph" l10n="U" oldref="184">Korean: Korean upper case characters [DBNum2]; CAL: 2/8/8 [DBNum2]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152976" role="paragraph" l10n="U" oldref="185">[NatNum3] Transliteration in</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154353" role="paragraph" l10n="U" oldref="186">Chinese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154669" role="paragraph" l10n="U" oldref="187">Japanese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150472" role="paragraph" l10n="U" oldref="188">Korean: fullwidth Arabic digits [DBNum3]; CAL: 3/3/3 [DBNum3]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3157811" role="paragraph" l10n="U" oldref="189">[NatNum4] Transliteration in</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154592" role="paragraph" l10n="U" oldref="190">Chinese: lower case text [DBNum1]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150350" role="paragraph" l10n="U" oldref="191">Japanese: modern long Kanji text [DBNum2]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150930" role="paragraph" l10n="U" oldref="192">Korean: formal lower case text</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153546" role="paragraph" l10n="U" oldref="193">[NatNum5] Transliteration in</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155612" role="paragraph" l10n="U" oldref="194">Chinese: Chinese upper case text [DBNum2]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155909" role="paragraph" l10n="U" oldref="195">Japanese: traditional long Kanji text [DBNum3]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3151304" role="paragraph" l10n="U" oldref="196">Korean: formal upper case text</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155075" role="paragraph" l10n="U" oldref="197">[NatNum6] Transliteration in</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150214" role="paragraph" l10n="U" oldref="198">Chinese: fullwidth text [DBNum3]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154114" role="paragraph" l10n="U" oldref="199">Japanese: fullwidth text</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155344" role="paragraph" l10n="U" oldref="200">Korean: fullwidth text</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155538" role="paragraph" l10n="U" oldref="201">[NatNum7] Transliteration in</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3145123" role="paragraph" l10n="U" oldref="202">Japanese: modern short Kanji text</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149424" role="paragraph" l10n="U" oldref="203">Korean: informal lower case text</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153688" role="paragraph" l10n="U" oldref="204">[NatNum8] Transliteration in</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3156122" role="paragraph" l10n="U" oldref="205">Japanese: traditional short Kanji text [DBNum4]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3145602" role="paragraph" l10n="U" oldref="206">Korean: informal upper case text</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3159228" role="paragraph" l10n="U" oldref="207">[NatNum9] Transliteration in</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154644" role="paragraph" l10n="U" oldref="208">Korean: Hangul characters</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155396" role="paragraph" l10n="U" oldref="209">[NatNum10] Transliteration in</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150878" role="paragraph" l10n="U" oldref="210">Korean: formal Hangul text [DBNum4]; CAL: 9/11/11 [DBNum4]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149384" role="paragraph" l10n="U" oldref="211">[NatNum11] Transliteration in</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154213" role="paragraph" l10n="U" oldref="212">Korean: informal Hangul text</paragraph> + </tablecell> + </tablerow> + </table> -</body> -</helpdocument> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/shared/01/05340100.xhp b/helpcontent2/source/text/shared/01/05340100.xhp index 4049929f3e..64ce51b804 100644 --- a/helpcontent2/source/text/shared/01/05340100.xhp +++ b/helpcontent2/source/text/shared/01/05340100.xhp @@ -1,7 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - -<!--*********************************************************************** +<helpdocument version="1.0"> + +<!-- +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -9,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 05340100.xhp,v $ - * $Revision: 1.7 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -29,42 +30,36 @@ * <http://www.openoffice.org/license.html> * for a copy of the LGPLv3 License. * - ************************************************************************--> + ************************************************************************ + --> + -<helpdocument version="1.0"> <meta> -<topic id="textshared0105340100xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Row Height</title> -<filename>/text/shared/01/05340100.xhp</filename> -</topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-05-26T12:09:22">converted from old format - fpe</lastedited> -</history> -</meta> -<body> -<bookmark xml-lang="en-US" branch="hid/FID_ROW_HEIGHT" id="bm_id8702934" localize="false"/><!-- HID added by script --> + <topic id="textshared0105340100xml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Row Height</title> + <filename>/text/shared/01/05340100.xhp</filename> + </topic> + </meta> + <body> +<bookmark xml-lang="en-US" branch="hid/FID_ROW_HEIGHT" id="bm_id8702934" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:RowHeight" id="bm_id3150146" localize="false"/> <bookmark xml-lang="en-US" branch="hid/HID_BROWSER_ROWHEIGHT" id="bm_id3149987" localize="false"/> -<paragraph role="heading" id="hd_id3154400" xml-lang="en-US" level="1" l10n="U" oldref="1">Row Height</paragraph> -<paragraph role="paragraph" id="par_id3154044" xml-lang="en-US" l10n="U" oldref="2"> -<variable id="zeilenhoehetext"><ahelp hid="HID_BROWSER_ROWHEIGHT">Changes the height of the current row, or the selected rows.</ahelp> +<paragraph xml-lang="en-US" id="hd_id3154400" role="heading" level="1" l10n="U" oldref="1">Row Height</paragraph> + <paragraph xml-lang="en-US" id="par_id3154044" role="paragraph" l10n="U" oldref="2"><variable id="zeilenhoehetext"><ahelp hid="HID_BROWSER_ROWHEIGHT">Changes the height of the current row, or the selected rows.</ahelp> </variable></paragraph> -<paragraph role="paragraph" id="par_id3150756" xml-lang="en-US" l10n="U" oldref="7"><switchinline select="appl"> -<caseinline select="CALC">You can also change the height of a row by dragging the divider below the row header. To fit the row height to the cell contents, double-click the divider. + <paragraph xml-lang="en-US" id="par_id3150756" role="paragraph" l10n="U" oldref="7"><switchinline select="appl"><caseinline select="CALC">You can also change the height of a row by dragging the divider below the row header. To fit the row height to the cell contents, double-click the divider. </caseinline></switchinline></paragraph> -<section id="howtoget"> - <embed href="text/shared/00/00040503.xhp#fozeihoe"/> -</section> + <section id="howtoget"> + <embed href="text/shared/00/00040503.xhp#fozeihoe"/> + </section> <bookmark xml-lang="en-US" branch="hid/SC_METRICFIELD_RID_SCDLG_ROW_MAN_ED_VALUE" id="bm_id3146946" localize="false"/> <bookmark xml-lang="en-US" branch="hid/DBACCESS_METRICFIELD_DLG_ROWHEIGHT_MF_VALUE" id="bm_id3083278" localize="false"/> -<paragraph role="heading" id="hd_id3149962" xml-lang="en-US" level="2" l10n="U" oldref="3">Height</paragraph> -<paragraph role="paragraph" id="par_id3144750" xml-lang="en-US" l10n="U" oldref="4"><ahelp hid="DBACCESS_METRICFIELD_DLG_ROWHEIGHT_MF_VALUE">Enter the row height that you want to use.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="hd_id3149962" role="heading" level="2" l10n="U" oldref="3">Height</paragraph> + <paragraph xml-lang="en-US" id="par_id3144750" role="paragraph" l10n="U" oldref="4"><ahelp hid="DBACCESS_METRICFIELD_DLG_ROWHEIGHT_MF_VALUE">Enter the row height that you want to use.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/SC_CHECKBOX_RID_SCDLG_ROW_MAN_BTN_DEFVAL" id="bm_id3154840" localize="false"/> <bookmark xml-lang="en-US" branch="hid/DBACCESS_CHECKBOX_DLG_ROWHEIGHT_CB_STANDARD" id="bm_id3150445" localize="false"/> -<paragraph role="heading" id="hd_id3154926" xml-lang="en-US" level="2" l10n="U" oldref="5"><switchinline select="appl"> -<caseinline select="CALC">Default value -</caseinline><defaultinline>Automatic</defaultinline></switchinline></paragraph> -<paragraph role="paragraph" id="par_id3154894" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="DBACCESS_CHECKBOX_DLG_ROWHEIGHT_CB_STANDARD">Automatically adjusts the row height based on the current font.</ahelp></paragraph> -</body> -</helpdocument> +<paragraph xml-lang="en-US" id="hd_id3154926" role="heading" level="2" l10n="CHG" + oldref="5">Default value</paragraph> + <paragraph xml-lang="en-US" id="par_id3154894" role="paragraph" l10n="CHG" oldref="6"><ahelp hid="DBACCESS_CHECKBOX_DLG_ROWHEIGHT_CB_STANDARD">Adjusts the row height to the size based on the default template. Existing contents may be shown vertically cropped. The height no longer increases automatically when you enter larger contents.</ahelp></paragraph> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/shared/01/06050100.xhp b/helpcontent2/source/text/shared/01/06050100.xhp index 585459e531..a1b07dac86 100755 --- a/helpcontent2/source/text/shared/01/06050100.xhp +++ b/helpcontent2/source/text/shared/01/06050100.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -58,12 +58,7 @@ <paragraph xml-lang="en-US" id="par_id3155364" role="paragraph" l10n="U" oldref="4"><ahelp hid="HID_VALUESET_BULLET">Click the bullet style that you want to use.</ahelp></paragraph> <section id="relatedtopics"> <paragraph xml-lang="en-US" id="par_id3149549" role="paragraph" l10n="CHG"><link href="text/shared/01/06050600.xhp" name="Position tab (Numbering/Bullets dialog)">Position tab (Bullets and Numbering dialog)</link></paragraph> -<switch select="appl"> -<case select="IMPRESS"> -<paragraph xml-lang="en-US" id="par_id3156042" role="paragraph" l10n="C"><link href="text/shared/01/05030100.xhp" name="Indents & Spacing tab (Numbering/Bullets dialog)">Indents & Spacing tab (Bullets and Numbering dialog)</link></paragraph> -</case> -</switch> -<paragraph xml-lang="en-US" id="par_id3154317" role="paragraph" l10n="C"><link href="text/shared/01/06050500.xhp" name="Options tab (Numbering/Bullets dialog)">Options tab (Bullets and Numbering dialog)</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3154317" role="paragraph" l10n="C"><link href="text/shared/01/06050500.xhp" name="Options tab (Numbering/Bullets dialog)">Options tab (Bullets and Numbering dialog)</link></paragraph> </section> </body> </helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/shared/01/06050200.xhp b/helpcontent2/source/text/shared/01/06050200.xhp index 1b0d268cd4..8a1be78291 100755 --- a/helpcontent2/source/text/shared/01/06050200.xhp +++ b/helpcontent2/source/text/shared/01/06050200.xhp @@ -1,7 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - -<!--*********************************************************************** +<helpdocument version="1.0"> + +<!-- +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -9,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 06050200.xhp,v $ - * $Revision: 1.7 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -29,38 +30,31 @@ * <http://www.openoffice.org/license.html> * for a copy of the LGPLv3 License. * - ************************************************************************--> + ************************************************************************ + --> + -<helpdocument version="1.0"> <meta> -<topic id="textshared0106050200xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Numbering Style</title> -<filename>/text/shared/01/06050200.xhp</filename> -</topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-09-24T14:40:59">converted from old format - fpe</lastedited> -</history> -</meta> -<body> -<section id="numerierungsart"> -<paragraph role="heading" id="hd_id3146807" xml-lang="en-US" level="1" l10n="CHG" oldref="1"><link href="text/shared/01/06050200.xhp" name="Numbering Style">Numbering</link></paragraph> -<paragraph role="paragraph" id="par_id3148765" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".">Displays the different numbering styles that you can apply.</ahelp></paragraph> -</section> -<section id="howtoget"> - <embed href="text/shared/00/00040500.xhp#numnumerierungsart"/> -</section> + <topic id="textshared0106050200xml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Numbering Style</title> + <filename>/text/shared/01/06050200.xhp</filename> + </topic> + </meta> + <body> + <section id="numerierungsart"> + <paragraph xml-lang="en-US" id="hd_id3146807" role="heading" level="1" l10n="CHG" + oldref="1"><link href="text/shared/01/06050200.xhp" name="Numbering Style">Numbering</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3148765" role="paragraph" l10n="U" oldref="2"><ahelp hid=".">Displays the different numbering styles that you can apply.</ahelp></paragraph> + </section> + <section id="howtoget"> + <embed href="text/shared/00/00040500.xhp#numnumerierungsart"/> + </section> <bookmark xml-lang="en-US" branch="hid/HID_VALUESET_SINGLENUM" id="bm_id3153255" localize="false"/> -<paragraph role="heading" id="hd_id3147000" xml-lang="en-US" level="2" l10n="U" oldref="3">Selection</paragraph> -<paragraph role="paragraph" id="par_id3151100" xml-lang="en-US" l10n="U" oldref="4"><ahelp hid="HID_VALUESET_SINGLENUM">Click the numbering style that you want to use.</ahelp></paragraph> -<section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3149355" xml-lang="en-US" l10n="C"><link href="text/shared/01/06050600.xhp" name="Position tab (Numbering/Bullets dialog)">Position tab (Bullets and Numbering dialog)</link></paragraph> -<switch select="appl"> -<case select="IMPRESS"> -<paragraph role="paragraph" id="par_id3156027" xml-lang="en-US" l10n="C"><link href="text/shared/01/05030100.xhp" name="Indents & Spacing tab (Numbering/Bullets dialog)">Indents & Spacing tab (Bullets and Numbering dialog)</link></paragraph> -</case> -</switch> -<paragraph role="paragraph" id="par_id3152918" xml-lang="en-US" l10n="C"><link href="text/shared/01/06050500.xhp" name="Options tab (Numbering/Bullets dialog)">Options tab (Bullets and Numbering dialog)</link></paragraph> -</section> -</body> -</helpdocument> +<paragraph xml-lang="en-US" id="hd_id3147000" role="heading" level="2" l10n="U" oldref="3">Selection</paragraph> + <paragraph xml-lang="en-US" id="par_id3151100" role="paragraph" l10n="U" oldref="4"><ahelp hid="HID_VALUESET_SINGLENUM">Click the numbering style that you want to use.</ahelp></paragraph> + <section id="relatedtopics"> + <paragraph xml-lang="en-US" id="par_id3149355" role="paragraph" l10n="C"><link href="text/shared/01/06050600.xhp" name="Position tab (Numbering/Bullets dialog)">Position tab (Bullets and Numbering dialog)</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3152918" role="paragraph" l10n="C"><link href="text/shared/01/06050500.xhp" name="Options tab (Numbering/Bullets dialog)">Options tab (Bullets and Numbering dialog)</link></paragraph> + </section> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/shared/01/formatting_mark.xhp b/helpcontent2/source/text/shared/01/formatting_mark.xhp index a1efd7f019..16ec61a88a 100755 --- a/helpcontent2/source/text/shared/01/formatting_mark.xhp +++ b/helpcontent2/source/text/shared/01/formatting_mark.xhp @@ -45,7 +45,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:FormattingMarkMenu" id="bm_id7235023" localize="false"/> <bookmark xml-lang="en-US" branch="index" id="bm_id9930722"><bookmark_value>CTL;(not) wrapping words</bookmark_value> <bookmark_value>words;wrapping in CTL</bookmark_value> -</bookmark><comment>MW added 2 index entries because of issue 86750</comment><comment>tried to fix i86464 by creating a new file, copy everything over, then save & overwrite as formatting_mark.xhp</comment> +</bookmark><comment>MW added 2 index entries because of issue 86750</comment><comment>tried to fix i86464 by creating a new file, copy everything over, then save & overwrite as formatting_mark.xhp</comment><comment>but this did not help</comment> <paragraph xml-lang="en-US" id="hd_id030220091035120" role="heading" level="1" l10n="NEW"><variable id="formattingmark"><link href="text/shared/01/formatting_mark.xhp">Formatting Mark</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id0302200910351248" role="paragraph" l10n="NEW"><ahelp hid=".">Opens a submenu to insert special formatting marks. Enable CTL for more commands.</ahelp></paragraph> @@ -72,4 +72,4 @@ <paragraph xml-lang="en-US" id="hd_id9420148" role="heading" level="2" l10n="NEW">Right-to-left mark</paragraph> <paragraph xml-lang="en-US" id="par_id923184" role="paragraph" l10n="NEW"><ahelp hid=".">Inserts a text direction mark that affects the text direction of any text following the mark. Available when complex text layout (CTL) is enabled.</ahelp></paragraph> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/helpcontent2/source/text/shared/01/password_dlg.xhp b/helpcontent2/source/text/shared/01/password_dlg.xhp index dbf316f75e..5bb5d2a70b 100644 --- a/helpcontent2/source/text/shared/01/password_dlg.xhp +++ b/helpcontent2/source/text/shared/01/password_dlg.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.8 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -42,20 +42,22 @@ </meta> <body> <section id="passwort"> - <paragraph xml-lang="en-US" id="hd_id3146902" role="heading" level="2" l10n="U" + <paragraph xml-lang="en-US" id="hd_id3146902" role="heading" level="1" l10n="U" oldref="63"><link href="text/shared/01/password_dlg.xhp" name="Password">Password</link></paragraph> <paragraph xml-lang="en-US" id="par_id3154350" role="paragraph" l10n="U" oldref="64">Assigns a password to prevent users from making unauthorized changes.</paragraph> <embed href="text/shared/01/password_main.xhp#password_rules"/> <bookmark xml-lang="en-US" branch="hid/SFX2_EDIT_DLG_PASSWD_ED_PASSWD_PASSWORD" id="bm_id3152876" localize="false"/> <bookmark xml-lang="en-US" branch="hid/HID_PASSWD_TABLE" id="bm_id3154044" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3146857" role="heading" level="1" l10n="U" +<bookmark xml-lang="en-US" branch="hid/uui:Edit:DLG_UUI_PASSWORD_CRT:ED_PASSWORD_CRT" id="bm_id0928200904183274" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3146857" role="heading" level="2" l10n="U" oldref="65">Password</paragraph> <paragraph xml-lang="en-US" id="par_id3150502" role="paragraph" l10n="CHG" oldref="62"><ahelp hid="HID_PASSWD_TABLE">Type a password. A password is case sensitive.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/SFX2_EDIT_DLG_PASSWD_ED_PASSWD_CONFIRM" id="bm_id3149495" localize="false"/> <bookmark xml-lang="en-US" branch="hid/HID_PASSWD_DOC" id="bm_id3154863" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/uui:Edit:DLG_UUI_PASSWORD_CRT:ED_PASSWORD_REPEAT" id="bm_id0928200904190676" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3153029" role="heading" level="2" l10n="U" oldref="66">Confirm</paragraph> - <paragraph xml-lang="en-US" id="par_id3151100" role="paragraph" l10n="U" oldref="67">Re-enter the password.</paragraph> + <paragraph xml-lang="en-US" id="par_id3151100" role="paragraph" l10n="U" oldref="67"><ahelp hid=".">Re-enter the password.</ahelp></paragraph> <paragraph xml-lang="en-US" id="hd_id3155351" role="heading" level="2" l10n="U" oldref="68">Undoing password protection</paragraph> <paragraph xml-lang="en-US" id="par_id3146109" role="paragraph" l10n="U" oldref="69">To remove a password, re-open this dialog, and then enter the password.</paragraph> diff --git a/helpcontent2/source/text/shared/01/ref_pdf_export.xhp b/helpcontent2/source/text/shared/01/ref_pdf_export.xhp index 5d47d0c2a8..57f3616cde 100644 --- a/helpcontent2/source/text/shared/01/ref_pdf_export.xhp +++ b/helpcontent2/source/text/shared/01/ref_pdf_export.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.8 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -124,7 +124,9 @@ <paragraph xml-lang="en-US" id="hd_id6585283" role="heading" level="2" l10n="NEW">Submit format</paragraph> <paragraph xml-lang="en-US" id="par_idN107F8" role="paragraph" l10n="NEW"><ahelp hid=".">Select the format of submitting forms from within the PDF file.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id0901200811454970" role="paragraph" l10n="NEW">Select the format of the data that you will receive from the submitter: FDF (Forms Data Format), PDF, HTML, or XML.</paragraph> - <paragraph xml-lang="en-US" id="par_idN10807" role="paragraph" l10n="CHG">This setting overrides the control's URL property that you set in the document.</paragraph> + <paragraph xml-lang="en-US" id="par_idN10807" role="paragraph" l10n="CHG">This setting overrides the control's URL property that you set in the document.</paragraph><comment>insert help id here</comment> +<paragraph xml-lang="en-US" id="hd_id1026200909535841" role="heading" level="2" l10n="NEW">Allow duplicate field names</paragraph> + <paragraph xml-lang="en-US" id="par_id102620090953596" role="paragraph" l10n="NEW"><ahelp hid=".">Allows to use the same field name for multiple fields in the generated PDF file. If disabled, field names will be exported using generated unique names.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/filter_CheckBox_RID_PDF_EXPORT_DLG_CB_EXPORTEMPTYPAGES" id="bm_id113223" localize="false"/> <bookmark xml-lang="en-US" branch="hid/filter_CheckBox_RID_PDF_TAB_GENER_CB_EXPORTEMPTYPAGES" id="bm_id5027619" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3946958" role="heading" level="2" l10n="NEW">Export automatically inserted blank pages</paragraph> |