summaryrefslogtreecommitdiff
path: root/source
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2023-11-02 12:35:04 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2023-11-03 11:13:45 +0100
commitbbdd4dfc5daee45a4b3d38a7acf698a73768173a (patch)
tree564fe777e5635519f3527912170ebabdfedddd6f /source
parenteb5efb80b63d29c6d4ec84c0c35b9b4a0298a5f7 (diff)
tdf#155876 UI cmds Calc-Format menu (19)
+ refactoring of Number formats Change-Id: Iaeb8114f6080652cd9f78ec8b2a1425056b5560d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158874 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source')
-rw-r--r--source/text/scalc/00/00000405.xhp10
-rw-r--r--source/text/scalc/01/default_number_formats.xhp292
-rw-r--r--source/text/scalc/main0105.xhp8
3 files changed, 198 insertions, 112 deletions
diff --git a/source/text/scalc/00/00000405.xhp b/source/text/scalc/00/00000405.xhp
index fb6506f971..a978cd4be9 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -29,6 +29,16 @@
</meta>
<body>
<h1 id="hd_id3150769">Format Menu</h1>
+<section id="numberformat">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id181698927976688">Choose <menuitem>Format - Number Format</menuitem>.</paragraph>
+ <section id="number_aux">
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id301698928319097">Choose <menuitem>Home</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_sidebar"/>
+ <paragraph role="paragraph" id="par_id721698928559289">Access the <menuitem>Number Format</menuitem> deck of the <menuitem>Properties Panel</menuitem>.</paragraph>
+ </section>
+</section>
<section id="format_cells">
<paragraph role="paragraph" id="par_id3154685">Choose <menuitem>Format - Cells</menuitem>.</paragraph>
<paragraph role="paragraph" id="par_id61593556839601">Press <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+1</keycode>.</paragraph>
diff --git a/source/text/scalc/01/default_number_formats.xhp b/source/text/scalc/01/default_number_formats.xhp
index 330f9e7900..7fed8f8e92 100644
--- a/source/text/scalc/01/default_number_formats.xhp
+++ b/source/text/scalc/01/default_number_formats.xhp
@@ -6,177 +6,253 @@
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalcnumberformatsubmenu" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Default Number Formats</title>
+ <title id="tit">Default Number Formats</title>
<filename>/text/scalc/01/default_number_formats.xhp</filename>
</topic>
</meta>
<body>
+ <bookmark branch="hid/.uno:NumberFormatMenu" id="bm_id201698927555554" localize="false"/>
<section id="numberformatmenu">
- <bookmark id="bm_id901674498160040" branch="hid/.uno:NumberFormat" localize="false"/>
+ <bookmark id="bm_id901674498160040" branch="hid/.uno:NumberFormat" localize="false"/>
<h1 id="hd_id111674498160040"><link href="text/scalc/01/default_number_formats.xhp">Number Format</link></h1>
- <paragraph id="par_id211674498160040" role="paragraph">Default number formats</paragraph>
+ <paragraph id="par_id211674498160040" role="paragraph">Default number formats.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000405.xhp#numberformat"/>
</section>
-
<section id="standard">
- <bookmark branch="hid/.uno:NumberFormatStandard" xml-lang="en-US" id="bm_id3152996" localize="false"/>
+ <bookmark branch="hid/.uno:NumberFormatStandard" id="bm_id3152996" localize="false"/>
<h2 id="hd_id3149182"><link href="text/scalc/01/default_number_formats.xhp">Number format: General</link></h2>
- <paragraph role="paragraph" id="par_id3163802" xml-lang="en-US"><ahelp hid=".uno:NumberFormatStandard" visibility="visible">Applies the default number format to the selected cells.</ahelp></paragraph>
- <table id="tbl_id3156326">
- <tablerow>
- <tablecell>
- <paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><image src="cmd/lc_numberformatstandard.svg" id="img_id3156024" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id3156024">Icon General Number Format</alt></image></paragraph>
- </tablecell>
- <tablecell>
- <paragraph role="paragraph" id="par_id3153361" xml-lang="en-US">Number Format: General</paragraph>
- </tablecell>
- </tablerow>
- </table>
+ <paragraph role="paragraph" id="par_id3163802"><ahelp hid=".uno:NumberFormatStandard" visibility="visible">Applies the default number format to the selected cells.</ahelp></paragraph>
+ <section id="howtoget">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id701698931147179">Choose <menuitem>Format - Number Format - General</menuitem>.</paragraph>
+ <embed href="text/scalc/00/00000405.xhp#number_aux"/>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tbl_id3156326">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3155922"><image src="cmd/lc_numberformatstandard.svg" id="img_id3156024" width="1cm" height="1cm"><alt id="alt_id3156024">Icon General Number Format</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3153361">Number Format: General</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id41698931229411"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode> + Shift + 6</keycode></paragraph>
+ </section>
</section>
<section id="decimal">
- <bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatDecimal" id="bm_id141674560695432" localize="false"/>
+ <bookmark branch="hid/.uno:NumberFormatDecimal" id="bm_id141674560695432" localize="false"/>
<h2 id="hd_id381674560759637"><link href="text/scalc/01/default_number_formats.xhp">Number format: Number</link></h2>
<paragraph role="paragraph" id="par_id741674560753997">Applies the default decimal number format to the selected cells.</paragraph>
- <table id="tab_id101674564711934">
- <tablerow>
- <tablecell>
- <paragraph id="par_id901674564711935" role="paragraph">
- <image src="cmd/lc_numberformatdecimal.svg" id="img_id841674564711937" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id191674564711938">Icon Number format: Number</alt></image>
- </paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id361674564711940" role="paragraph" xml-lang="en-US">Number format: Number</paragraph>
- </tablecell>
- </tablerow>
- </table>
+ <section id="howtoget">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id631698936613282">Choose <menuitem>Format - Number Format - Number</menuitem>.</paragraph>
+ <embed href="text/scalc/00/00000405.xhp#number_aux"/>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id101674564711934">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id901674564711935" role="paragraph">
+ <image src="cmd/lc_numberformatdecimal.svg" id="img_id841674564711937" width="1cm" height="1cm"><alt id="alt_id191674564711938">Icon Number format: Number</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id361674564711940" role="paragraph">Number format: Number</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id781698936664807"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode> + Shift + 1</keycode></paragraph>
+ </section>
</section>
<section id="percent">
- <bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatPercent" id="bm_id3153541" localize="false"/>
+ <bookmark branch="hid/.uno:NumberFormatPercent" id="bm_id3153541" localize="false"/>
<h2 id="hd_id3156329"><link href="text/scalc/01/default_number_formats.xhp">Number format: Percent</link></h2>
- <paragraph role="paragraph" id="par_id3155629" xml-lang="en-US"><ahelp hid=".uno:NumberFormatPercent">Applies the percentage format to the selected cells.</ahelp></paragraph>
- <table id="tbl_id3154758">
- <tablerow>
- <tablecell>
- <paragraph role="paragraph" id="par_id3153968" xml-lang="en-US">
- <image id="img_id3150869" src="cmd/lc_numberformatpercent.svg" width="1cm" height="1cm"><alt id="alt_id3150869" xml-lang="en-US">Icon Number Format: Percent</alt></image></paragraph>
- </tablecell>
- <tablecell>
- <paragraph role="paragraph" id="par_id3151114" xml-lang="en-US">Number Format: Percent</paragraph>
- </tablecell>
- </tablerow>
- </table>
+ <paragraph role="paragraph" id="par_id3155629"><ahelp hid=".uno:NumberFormatPercent">Applies the percentage format to the selected cells.</ahelp></paragraph>
+ <section id="howtoget">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id91698936822420">Choose <menuitem>Format - Number Format - Percent</menuitem>.</paragraph>
+ <embed href="text/scalc/00/00000405.xhp#number_aux"/>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tbl_id3154758">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3153968">
+ <image id="img_id3150869" src="cmd/lc_numberformatpercent.svg" width="1cm" height="1cm"><alt id="alt_id3150869">Icon Number Format: Percent</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3151114">Number Format: Percent</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id311698936803456"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode> + Shift + 5</keycode></paragraph>
+ </section>
</section>
<section id="currency">
- <bookmark branch="hid/.uno:NumberFormatCurrency" xml-lang="en-US" id="bm_id3148701" localize="false"/>
+ <bookmark branch="hid/.uno:NumberFormatCurrency" id="bm_id3148701" localize="false"/>
<h2 id="hd_id3152892"><link href="text/scalc/01/default_number_formats.xhp">Number format: Currency</link></h2>
- <paragraph role="paragraph" id="par_id3148837" xml-lang="en-US"><ahelp hid=".uno:NumberFormatCurrency" visibility="visible">Applies the default currency format to the selected cells.</ahelp></paragraph>
- <table id="tbl_id3153915">
- <tablerow>
- <tablecell>
- <paragraph role="paragraph" id="par_id3155267" xml-lang="en-US"><image src="cmd/lc_numberformatcurrency.svg" id="img_id3159096" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id3159096">Currency Number Format Icon</alt></image></paragraph>
- </tablecell>
- <tablecell>
- <paragraph role="paragraph" id="par_id3150214" xml-lang="en-US">Number Format: Currency</paragraph>
- </tablecell>
- </tablerow>
- </table>
+ <paragraph role="paragraph" id="par_id3148837"><ahelp hid=".uno:NumberFormatCurrency" visibility="visible">Applies the default currency format to the selected cells.</ahelp></paragraph>
+ <section id="howtoget">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id241698937039687">Choose <menuitem>Format - Number Format - Currency</menuitem>.</paragraph>
+ <embed href="text/scalc/00/00000405.xhp#number_aux"/>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tbl_id3153915">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3155267"><image src="cmd/lc_numberformatcurrency.svg" id="img_id3159096" width="1cm" height="1cm"><alt id="alt_id3159096">Currency Number Format Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3150214">Number Format: Currency</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id231698937034449"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode> + Shift + 4</keycode></paragraph>
+ </section>
</section>
<section id="date">
- <bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatDate" id="bm_id8329721" localize="false"/>
+ <bookmark branch="hid/.uno:NumberFormatDate" id="bm_id8329721" localize="false"/>
<h2 id="par_idN10843"><link href="text/scalc/01/default_number_formats.xhp">Number Format : Date</link></h2>
- <paragraph role="paragraph" id="par_idN10847" xml-lang="en-US">Applies the default date format to the selected cells.</paragraph>
- <table id="tab_id921674565406058">
- <tablerow>
- <tablecell>
- <paragraph id="par_id951674565406059" role="paragraph">
- <image src="cmd/lc_numberformatdate.svg" id="img_id291674565406060" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id871674565406062">Icon Number Format : Date</alt></image>
- </paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id691674565406063" role="paragraph" xml-lang="en-US">Number Format : Date</paragraph>
- </tablecell>
- </tablerow>
- </table>
+ <paragraph role="paragraph" id="par_idN10847">Applies the default date format to the selected cells.</paragraph>
+ <section id="howtoget">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id781698937156995">Choose <menuitem>Format - Number Format - Date</menuitem>.</paragraph>
+ <embed href="text/scalc/00/00000405.xhp#number_aux"/>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id921674565406058">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id951674565406059" role="paragraph">
+ <image src="cmd/lc_numberformatdate.svg" id="img_id291674565406060" width="1cm" height="1cm"><alt id="alt_id871674565406062">Icon Number Format : Date</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id691674565406063" role="paragraph">Number Format : Date</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id111698937176318"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode> + Shift + 3</keycode></paragraph>
+ </section>
</section>
<section id="time">
- <bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatTime" id="bm_id5950093" localize="false"/>
+ <bookmark branch="hid/.uno:NumberFormatTime" id="bm_id5950093" localize="false"/>
<h2 id="hd_id531674560537020"><link href="text/scalc/01/default_number_formats.xhp">Number Format: Time</link></h2>
<paragraph role="paragraph" id="par_id301674560577097">Applies the default time format to the selected cells.</paragraph>
- <table id="tab_id111674565650530">
- <tablerow>
- <tablecell>
- <paragraph id="par_id491674565650531" role="paragraph">
- <image src="cmd/lc_numberformattime.svg" id="img_id461674565650532" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id231674565650533">Icon Number Format: Time</alt></image>
- </paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id431674565650535" role="paragraph" xml-lang="en-US">Number Format: Time</paragraph>
- </tablecell>
- </tablerow>
- </table>
+ <section id="howtoget">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id971698937239126">Choose <menuitem>Format - Number Format - Time</menuitem>.</paragraph>
+ <embed href="text/scalc/00/00000405.xhp#number_aux"/>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id111674565650530">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id491674565650531" role="paragraph">
+ <image src="cmd/lc_numberformattime.svg" id="img_id461674565650532" width="1cm" height="1cm"><alt id="alt_id231674565650533">Icon Number Format: Time</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id431674565650535" role="paragraph">Number Format: Time</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
</section>
<section id="scientific">
- <bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatScientific" id="bm_id5850093" localize="false"/>
+ <bookmark branch="hid/.uno:NumberFormatScientific" id="bm_id5850093" localize="false"/>
<h2 id="par_idN1085E"><link href="text/scalc/01/default_number_formats.xhp">Number Format: Scientific</link></h2>
- <paragraph role="paragraph" id="par_idN10862" xml-lang="en-US">Applies the default scientific format to the selected cells.</paragraph>
- <table id="tab_id101674565759524">
- <tablerow>
- <tablecell>
- <paragraph id="par_id691674565759525" role="paragraph">
- <image src="cmd/lc_numberformatscientific.svg" id="img_id411674565759526" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id351674565759527">Icon Number Format: Scientific</alt></image>
- </paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id221674565759529" role="paragraph" xml-lang="en-US">Number Format: Scientific</paragraph>
- </tablecell>
- </tablerow>
- </table>
+ <paragraph role="paragraph" id="par_idN10862">Applies the default scientific format to the selected cells.</paragraph>
+ <section id="howtoget">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id451698937503910">Choose <menuitem>Format - Number Format - Scientific</menuitem>.</paragraph>
+ <embed href="text/scalc/00/00000405.xhp#number_aux"/>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id101674565759524">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id691674565759525" role="paragraph">
+ <image src="cmd/lc_numberformatscientific.svg" id="img_id411674565759526" width="1cm" height="1cm"><alt id="alt_id351674565759527">Icon Number Format: Scientific</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id221674565759529" role="paragraph">Number Format: Scientific</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id221698937519539"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode> + Shift + 2</keycode></paragraph>
+ </section>
+ </section>
+ <bookmark branch="hid/.uno:NumberFormatThousands" id="bm_id201698937826758" localize="false"/>
+ <section id="numberformatthousands">
+ <h2 id="hd_id561698937896512"><link href="text/scalc/01/default_number_formats.xhp">Number Format: Thousands Separator</link></h2>
+ <paragraph role="paragraph" id="par_id171698938218575">Applies the thousand separator to the number in the selected cells.</paragraph>
+ <section id="howtoget">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id541698938166667">Choose <menuitem>Format - Number Format - Thousands Separator</menuitem>.</paragraph>
+ <embed href="text/scalc/00/00000405.xhp#number_aux"/>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id391698938025703">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id741698938025705" role="paragraph"><image src="cmd/lc_numberformatthousands.svg" id="img_id71698938025706" width="1cm" height="1cm"><alt id="alt_id781698938025708">Icon Number Format: Thousands Separator</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id971698938025711" role="paragraph">Number Format: Thousands Separator</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
</section>
-
<section id="delete_decimal_place"><comment>mw copied three index entries to Calc guide format_value.xhp</comment>
- <bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatDecDecimals" id="bm_id9660963" localize="false"/>
+ <bookmark branch="hid/.uno:NumberFormatDecDecimals" id="bm_id9660963" localize="false"/>
<h2 id="hd_id3149164"><link href="text/scalc/01/default_number_formats.xhp">Number Format: Delete Decimal Place</link></h2>
- <paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><ahelp hid=".uno:NumberFormatDecDecimals">Removes one decimal place from the numbers in the selected cells.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id3147264"><ahelp hid=".uno:NumberFormatDecDecimals">Removes one decimal place from the numbers in the selected cells.</ahelp></paragraph>
<table id="tbl_id3154365">
<tablerow>
<tablecell>
- <paragraph role="paragraph" id="par_id3145173" xml-lang="en-US">
- <image id="img_id3153192" src="cmd/lc_numberformatdecdecimals.svg" width="1cm" height="1cm"><alt id="alt_id3153192" xml-lang="en-US">Icon Delete Decimal Place</alt></image></paragraph>
+ <paragraph role="paragraph" id="par_id3145173">
+ <image id="img_id3153192" src="cmd/lc_numberformatdecdecimals.svg" width="1cm" height="1cm"><alt id="alt_id3153192">Icon Delete Decimal Place</alt></image></paragraph>
</tablecell>
<tablecell>
- <paragraph role="paragraph" id="par_id3154686" xml-lang="en-US">Number Format: Delete Decimal Place</paragraph>
+ <paragraph role="paragraph" id="par_id3154686">Number Format: Delete Decimal Place</paragraph>
</tablecell>
</tablerow>
</table>
</section>
<section id="add_decimal_place"><comment>mw copied three index entries to Calc guide format_value.xhp</comment>
- <bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatIncDecimals" id="bm_id1150276" localize="false"/>
+ <bookmark branch="hid/.uno:NumberFormatIncDecimals" id="bm_id1150276" localize="false"/>
<h2 id="hd_id3150275"><link href="text/scalc/01/default_number_formats.xhp">Number Format: Add Decimal Place</link></h2>
- <paragraph role="paragraph" id="par_id3150792" xml-lang="en-US"><ahelp hid=".uno:NumberFormatIncDecimals">Adds one decimal place to the numbers in the selected cells.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id3150792"><ahelp hid=".uno:NumberFormatIncDecimals">Adds one decimal place to the numbers in the selected cells.</ahelp></paragraph>
<table id="tbl_id3156280">
<tablerow>
<tablecell>
- <paragraph role="paragraph" id="par_id3145787" xml-lang="en-US">
- <image id="img_id3145271" src="cmd/lc_numberformatincdecimals.svg" width="1cm" height="1cm"><alt id="alt_id3145271" xml-lang="en-US">Icon Add Decimal Place</alt></image></paragraph>
+ <paragraph role="paragraph" id="par_id3145787">
+ <image id="img_id3145271" src="cmd/lc_numberformatincdecimals.svg" width="1cm" height="1cm"><alt id="alt_id3145271">Icon Add Decimal Place</alt></image></paragraph>
</tablecell>
<tablecell>
- <paragraph role="paragraph" id="par_id3149262" xml-lang="en-US">Number Format: Add Decimal Place</paragraph>
+ <paragraph role="paragraph" id="par_id3149262">Number Format: Add Decimal Place</paragraph>
</tablecell>
</tablerow>
</table>
</section>
<section id="relatedtopics">
- <paragraph role="paragraph" id="par_id3154908" xml-lang="en-US"><link href="text/shared/01/05020300.xhp">Format - Cells - Numbers</link>.</paragraph>
+ <paragraph role="paragraph" id="par_id3154908"><link href="text/shared/01/05020300.xhp">Format - Cells - Numbers</link>.</paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/main0105.xhp b/source/text/scalc/main0105.xhp
index 4c2325d70c..59df51261a 100644
--- a/source/text/scalc/main0105.xhp
+++ b/source/text/scalc/main0105.xhp
@@ -20,20 +20,20 @@
<meta>
<topic id="textscalcmain0105xml" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Format</title>
+ <title id="tit">Format</title>
<filename>/text/scalc/main0105.xhp</filename>
</topic>
</meta>
<body>
<section id="format">
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatMenu" id="bm_id4623554" localize="false"/>
+<bookmark branch="hid/.uno:FormatMenu" id="bm_id4623554" localize="false"/>
<h1 id="hd_id3149669"><link href="text/scalc/main0105.xhp">Format</link></h1>
-<paragraph id="par_id3145171" role="paragraph" xml-lang="en-US"><ahelp hid=".">The <emph>Format</emph> menu contains commands for formatting selected cells, <link href="text/shared/00/00000005.xhp#object">objects</link>, and cell contents in your document.</ahelp></paragraph>
+<paragraph id="par_id3145171" role="paragraph"><ahelp hid=".">The <emph>Format</emph> menu contains commands for formatting selected cells, <link href="text/shared/00/00000005.xhp#object">objects</link>, and cell contents in your document.</ahelp></paragraph>
</section>
<embed href="text/shared/menu/submenu_text.xhp#submenu_text"/>
<embed href="text/shared/01/05080000.xhp#alignment"/>
-<embed href="text/scalc//01/default_number_formats.xhp#numberformatmenu"/>
+<embed href="text/scalc/01/default_number_formats.xhp#numberformatmenu"/>
<embed href="text/shared/01/05010000.xhp#standard"/>