source/text/scalc/00/00000405.xhp | 178 +++++++++++++++++++++++++---
source/text/scalc/01/05020000.xhp | 8 -
source/text/scalc/01/05030000.xhp | 13 --
source/text/scalc/01/05030300.xhp | 28 +---
source/text/scalc/01/05030400.xhp | 21 +--
source/text/scalc/01/05080000.xhp | 13 --
source/text/scalc/01/05080100.xhp | 11 -
source/text/scalc/01/05080200.xhp | 11 -
source/text/scalc/01/05080300.xhp | 40 +++---
source/text/scalc/01/05080400.xhp | 11 -
source/text/scalc/01/hide_sheet.xhp | 2
source/text/scalc/guide/table_cellmerge.xhp | 39 +++---
source/text/scalc/main0105.xhp | 14 --
source/text/shared/00/00040503.xhp | 20 ++-
source/text/shared/01/05020000.xhp | 5
source/text/shared/01/05030000.xhp | 10 +
source/text/shared/01/05340100.xhp | 26 ++--
source/text/simpress/guide/table_insert.xhp | 2
18 files changed, 298 insertions(+), 154 deletions(-)
New commits:
commit ed8997d667fff2ab03bd2e7f1cc3d1f92f526e97
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Nov 20 21:27:26 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Nov 21 01:29:17 2023 +0100
tdf#155876 UI cmds Calc-Format menu (21)
+ merge cells, print ranges menus
+ refactoring
Change-Id: Idcdd2fb8b986700f624941662a8250bbe6aac753
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/159746
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000405.xhp
b/source/text/scalc/00/00000405.xhp
index 2f1dced7af..9b9d33525f 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -134,13 +134,96 @@
<paragraph role="paragraph" id="par_idN1077A"><variable id="foste">Choose
<emph>Format - Page Style</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id3155508"><variable id="fostel">Choose
<emph>Format - Page Style - Sheet</emph> tab.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150883"><variable id="fodrbe">Choose
<emph>Format - Print Ranges</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3156448"><variable id="fodrfe">Choose
<emph>Format - Print Ranges - Define</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3156290"><variable id="fodrhin">Choose
<emph>Format - Print Ranges - Add</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3155812"><variable id="fodbah">Choose
<emph>Format - Print Ranges - Clear</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153307"><variable id="fodbbe">Choose
<emph>Format - Print Ranges - Edit</emph>.</variable></paragraph>
-
-
+<section id="printranges">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3150883"><variable id="fodrbe">Choose
<emph>Format - Print Ranges</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id661700524225883">Choose
<menuitem>Layout</menuitem> tab.</paragraph>
+ <paragraph role="paragraph" id="par_id231700521865773">On the
<menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose
<menuitem>Print Ranges</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id951700524311206">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id251700524311207" role="paragraph"><image
src="cmd/lc_defineprintarea.svg" id="img_id51700524311208" width="1cm"
height="1cm"><alt id="alt_id231700524311209">Icon Print
Ranges</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id561700524311211" role="paragraph">Print
Ranges</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+<section id="defineprintrange">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3156448"><variable id="fodrfe">Choose
<emph>Format - Print Ranges - Define</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id191700524851592">Choose
<menuitem>Layout - Print Area</menuitem> tab.</paragraph>
+ <paragraph role="paragraph" id="par_id881700524946114">On the
<menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose
<menuitem>Print Ranges - Define</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id501700525060552">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id211700525060553" role="paragraph"><image
src="cmd/lc_defineprintarea.svg" id="img_id881700525060554" width="1cm"
height="1cm"><alt id="alt_id221700525060556">Icon Define Print
Area</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id951700525060557" role="paragraph">Define Print
Area</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+<section id="addprintrange">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3156290"><variable id="fodrhin">Choose
<emph>Format - Print Ranges - Add</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id421700526081438">Choose
<menuitem>Layout - Add Print Ranges</menuitem> tab.</paragraph>
+ <paragraph role="paragraph" id="par_id231700526084582">On the
<menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose
<menuitem>Print Ranges - Add</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id691700526048361">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id931700526048362" role="paragraph"><image
src="cmd/lc_addprintarea.svg" id="img_id371700526048363" width="1cm"
height="1cm"><alt id="alt_id611700526048364">Icon Add Print
Area</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id481700526048365" role="paragraph">Add Print
Area</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+<section id="clearprintrange">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3155812"><variable id="fodbah">Choose
<emph>Format - Print Ranges - Clear</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id991700526162503">Choose
<menuitem>Layout - Clear Print Ranges</menuitem> tab.</paragraph>
+ <paragraph role="paragraph" id="par_id931700526168487">On the
<menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose
<menuitem>Print Ranges - Clear</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id451700525434546">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id931700525434547" role="paragraph"><image
src="cmd/lc_deleteprintarea.svg" id="img_id41700525434548" width="1cm"
height="1cm"><alt id="alt_id891700525434549">Icon Clear Print Ranges
</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id251700525434551" role="paragraph">Clear Print
Ranges</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+<section id="editprintrange">
+<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3153307"><variable id="fodbbe">Choose
<emph>Format - Print Ranges - Edit</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id161700525483226">Choose
<menuitem>Layout - Edit</menuitem> tab.</paragraph>
+ <paragraph role="paragraph" id="par_id381700525487691">On the
<menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose
<menuitem>Print Ranges - Edit</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id161700525855094">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id611700525855095" role="paragraph"><image
src="cmd/lc_editprintarea.svg" id="img_id231700525855096" width="1cm"
height="1cm"><alt id="alt_id271700525855097">Icon Edit Print
Ranges</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id901700525855099" role="paragraph">Edit Print
Ranges</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
<section id="s_conditionalcondition">
<paragraph role="paragraph" id="par_id3154618"><variable
id="bedingte">Choose <menuitem>Format - Conditional -
Condition</menuitem>.</variable></paragraph>
<paragraph role="paragraph" id="par_id141663543112100">On the
<emph>Formatting</emph> bar, click</paragraph>
diff --git a/source/text/scalc/01/05080000.xhp
b/source/text/scalc/01/05080000.xhp
index 130169ab9e..054a7a7e97 100644
--- a/source/text/scalc/01/05080000.xhp
+++ b/source/text/scalc/01/05080000.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalc0105080000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Print Ranges</title>
+<title id="tit">Print Ranges</title>
<filename>/text/scalc/01/05080000.xhp</filename>
</topic>
<history>
@@ -30,15 +27,15 @@
</history>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:PrintRangesMenu" id="bm_id4606769"
localize="false"/>
+<bookmark branch="hid/.uno:PrintRangesMenu" id="bm_id4606769"
localize="false"/>
<section id="printranges">
<h1 id="hd_id3154013"><link href="text/scalc/01/05080000.xhp">Print
Ranges</link></h1>
-<paragraph role="paragraph" id="par_id3155855" xml-lang="en-US"><ahelp
hid=".">Manages print ranges. Only cells within the print ranges will be
printed.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3155855"><ahelp hid=".">Manages print
ranges. Only cells within the print ranges will be printed.</ahelp></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000405.xhp#fodrbe"/>
+ <embed href="text/scalc/00/00000405.xhp#printranges"/>
</section>
-<paragraph role="note" id="par_id3146119" xml-lang="en-US">If you do not
define any print range manually, Calc assigns an automatic print range to
include all the cells that are not empty.</paragraph>
+<note id="par_id3146119">If you do not define any print range manually, Calc
assigns an automatic print range to include all the cells that are not
empty.</note>
<embed href="text/scalc/01/05080100.xhp#define"/>
<embed href="text/scalc/01/05080400.xhp#add"/>
<embed href="text/scalc/01/05080200.xhp#clear"/>
diff --git a/source/text/scalc/01/05080100.xhp
b/source/text/scalc/01/05080100.xhp
index 0759c4634a..3ff7260907 100644
--- a/source/text/scalc/01/05080100.xhp
+++ b/source/text/scalc/01/05080100.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalc0105080100xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Define</title>
+<title id="tit">Define</title>
<filename>/text/scalc/01/05080100.xhp</filename>
</topic>
<history>
@@ -31,12 +28,12 @@
</meta>
<body>
<section id="define">
-<bookmark xml-lang="en-US" branch="hid/.uno:DefinePrintArea" id="bm_id3153561"
localize="false"/>
+<bookmark branch="hid/.uno:DefinePrintArea" id="bm_id3153561"
localize="false"/>
<h1 id="hd_id3145673"><link
href="text/scalc/01/05080100.xhp">Define</link></h1>
-<paragraph role="paragraph" id="par_id3153896" xml-lang="en-US"><ahelp
hid=".uno:DefinePrintArea">Defines an active cell or selected cell area as the
print range.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3153896"><ahelp
hid=".uno:DefinePrintArea">Defines an active cell or selected cell area as the
print range.</ahelp></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000405.xhp#fodrfe"/>
+ <embed href="text/scalc/00/00000405.xhp#defineprintrange"/>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/05080200.xhp
b/source/text/scalc/01/05080200.xhp
index c260f0ff46..9861ff23b5 100644
--- a/source/text/scalc/01/05080200.xhp
+++ b/source/text/scalc/01/05080200.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalc0105080200xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Clear</title>
+<title id="tit">Clear</title>
<filename>/text/scalc/01/05080200.xhp</filename>
</topic>
<history>
@@ -31,12 +28,12 @@
</meta>
<body>
<section id="clear">
-<bookmark xml-lang="en-US" branch="hid/.uno:DeletePrintArea" id="bm_id3150275"
localize="false"/>
+<bookmark branch="hid/.uno:DeletePrintArea" id="bm_id3150275"
localize="false"/>
<h1 id="hd_id3153562"><link href="text/scalc/01/05080200.xhp">Clear</link></h1>
-<paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><ahelp
hid=".uno:DeletePrintArea">Removes the defined print area.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3148550"><ahelp
hid=".uno:DeletePrintArea">Removes the defined print area.</ahelp></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000405.xhp#fodbah"/>
+ <embed href="text/scalc/00/00000405.xhp#clearprintrange"/>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/05080300.xhp
b/source/text/scalc/01/05080300.xhp
index fdf284ff7d..73ee1dd610 100644
--- a/source/text/scalc/01/05080300.xhp
+++ b/source/text/scalc/01/05080300.xhp
@@ -22,42 +22,42 @@
<meta>
<topic id="textscalc0105080300xml" indexer="include">
-<title id="tit" xml-lang="en-US">Edit Print Ranges</title>
+<title id="tit">Edit Print Ranges</title>
<filename>/text/scalc/01/05080300.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:EditPrintArea" id="bm_id2248794"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/printareasdialog/PrintAreasDialog"
id="bm_id3145673" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/printareasdialog/@@nowidget@@" id="bm_id3145673"
localize="false"/>
+<bookmark branch="hid/.uno:EditPrintArea" id="bm_id2248794" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/PrintAreasDialog"
id="bm_id3145673" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/@@nowidget@@"
id="bm_id3145673" localize="false"/>
<h1 id="hd_id3153088">Edit Print Ranges</h1>
-<paragraph role="paragraph" id="par_id3159488" xml-lang="en-US"><variable
id="printrangestext"><ahelp hid=".uno:EditPrintArea">Opens a dialog where you
can specify the print range.</ahelp>
+<paragraph role="paragraph" id="par_id3159488"><variable
id="printrangestext"><ahelp hid=".uno:EditPrintArea">Opens a dialog where you
can specify the print range.</ahelp>
</variable> You can also set the rows or columns which are to be repeated in
every page.</paragraph>
<section id="howtoget">
-<embed href="text/scalc/00/00000405.xhp#fodbbe"/>
+<embed href="text/scalc/00/00000405.xhp#editprintrange"/>
</section>
<embed href="text/scalc/guide/print_title_row.xhp#print_title_row"/>
-<paragraph role="paragraph" id="par_idN105AE" xml-lang="en-US"
localize="false">
+<paragraph role="paragraph" id="par_idN105AE" localize="false">
<embedvar href="text/scalc/guide/printranges.xhp#printranges"/>
</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/printareasdialog/lbprintarea" id="bm_id3154910"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/printareasdialog/edprintarea" id="bm_id3150447"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/lbprintarea"
id="bm_id3154910" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/edprintarea"
id="bm_id3150447" localize="false"/>
<h2 id="hd_id3156281">Print range</h2>
-<paragraph role="paragraph" id="par_id3147228" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/printareasdialog/edprintarea">Allows you to modify a
defined print range.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3145174" xml-lang="en-US">Select
<emph>-none-</emph> to remove a print range definition for the current
spreadsheet. Select <emph>-entire sheet-</emph> to set the current sheet as a
print range. Select <emph>-selection-</emph> to define the selected area of a
spreadsheet as the print range. By selecting <emph>-user-defined-</emph>, you
can define a print range that you have already defined using the <emph>Format -
Print Ranges - Define</emph> command. If you have given a name to a range using
the <emph>Sheet - Named Ranges and Expressions - Define</emph> command, this
name will be displayed and can be selected from the list box.</paragraph>
-<paragraph role="paragraph" id="par_id3145272" xml-lang="en-US">In the
right-hand text box, you can enter a print range by reference or by name. If
the cursor is in the <emph>Print range</emph> text box, you can also select the
print range in the spreadsheet with your mouse.</paragraph>
+<paragraph role="paragraph" id="par_id3147228"><ahelp
hid="modules/scalc/ui/printareasdialog/edprintarea">Allows you to modify a
defined print range.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3145174">Select <emph>-none-</emph> to
remove a print range definition for the current spreadsheet. Select
<emph>-entire sheet-</emph> to set the current sheet as a print range. Select
<emph>-selection-</emph> to define the selected area of a spreadsheet as the
print range. By selecting <emph>-user-defined-</emph>, you can define a print
range that you have already defined using the <emph>Format - Print Ranges -
Define</emph> command. If you have given a name to a range using the
<emph>Sheet - Named Ranges and Expressions - Define</emph> command, this name
will be displayed and can be selected from the list box.</paragraph>
+<paragraph role="paragraph" id="par_id3145272">In the right-hand text box, you
can enter a print range by reference or by name. If the cursor is in the
<emph>Print range</emph> text box, you can also select the print range in the
spreadsheet with your mouse.</paragraph>
<embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/printareasdialog/lbrepeatrow" id="bm_id3147435"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/printareasdialog/edrepeatrow" id="bm_id3153190"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/lbrepeatrow"
id="bm_id3147435" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/edrepeatrow"
id="bm_id3153190" localize="false"/>
<h2 id="hd_id3149260">Rows to repeat</h2>
-<paragraph role="paragraph" id="par_id3147426" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/printareasdialog/edrepeatrow">Choose one or more rows to
print on every page. In the right text box enter the row reference, for
example, "1" or "$1" or "$2:$3".</ahelp> The list box displays <emph>-user
defined-</emph>. You can also select <emph>-none-</emph> to remove a defined
repeating row.</paragraph>
-<paragraph role="paragraph" id="par_id3155418" xml-lang="en-US">You can also
define repeating rows by dragging the mouse in the spreadsheet, if the cursor
is in the <emph>Rows to repeat</emph> text field in the dialog.</paragraph>
+<paragraph role="paragraph" id="par_id3147426"><ahelp
hid="modules/scalc/ui/printareasdialog/edrepeatrow">Choose one or more rows to
print on every page. In the right text box enter the row reference, for
example, "1" or "$1" or "$2:$3".</ahelp> The list box displays <emph>-user
defined-</emph>. You can also select <emph>-none-</emph> to remove a defined
repeating row.</paragraph>
+<paragraph role="paragraph" id="par_id3155418">You can also define repeating
rows by dragging the mouse in the spreadsheet, if the cursor is in the
<emph>Rows to repeat</emph> text field in the dialog.</paragraph>
<embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/printareasdialog/lbrepeatcol" id="bm_id3153876"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/printareasdialog/edrepeatcol" id="bm_id3147396"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/lbrepeatcol"
id="bm_id3153876" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/edrepeatcol"
id="bm_id3147396" localize="false"/>
<h2 id="hd_id3149581">Columns to repeat</h2>
-<paragraph role="paragraph" id="par_id3155602" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/printareasdialog/edrepeatcol">Choose one or more columns
to print on every page. In the right text box enter the column reference, for
example, "A" or "AB" or "$C:$E".</ahelp> The list box then displays <emph>-user
defined-</emph>. You can also select <emph>-none-</emph> to remove a defined
repeating column.</paragraph>
-<paragraph role="paragraph" id="par_id3150749" xml-lang="en-US">You can also
define repeating columns by dragging the mouse in the spreadsheet, if the
cursor is in the <emph>Columns to repeat</emph> text field in the
dialog.</paragraph>
+<paragraph role="paragraph" id="par_id3155602"><ahelp
hid="modules/scalc/ui/printareasdialog/edrepeatcol">Choose one or more columns
to print on every page. In the right text box enter the column reference, for
example, "A" or "AB" or "$C:$E".</ahelp> The list box then displays <emph>-user
defined-</emph>. You can also select <emph>-none-</emph> to remove a defined
repeating column.</paragraph>
+<paragraph role="paragraph" id="par_id3150749">You can also define repeating
columns by dragging the mouse in the spreadsheet, if the cursor is in the
<emph>Columns to repeat</emph> text field in the dialog.</paragraph>
<embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/05080400.xhp
b/source/text/scalc/01/05080400.xhp
index b0b9413bc8..bc733c45e9 100644
--- a/source/text/scalc/01/05080400.xhp
+++ b/source/text/scalc/01/05080400.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalc0105080400xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Add</title>
+<title id="tit">Add</title>
<filename>/text/scalc/01/05080400.xhp</filename>
</topic>
<history>
@@ -31,12 +28,12 @@
</meta>
<body>
<section id="add">
-<bookmark xml-lang="en-US" branch="hid/.uno:AddPrintArea" id="bm_id3150543"
localize="false"/>
+<bookmark branch="hid/.uno:AddPrintArea" id="bm_id3150543" localize="false"/>
<h1 id="hd_id3149457"><link href="text/scalc/01/05080400.xhp">Add</link></h1>
-<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US"><ahelp
hid=".uno:AddPrintArea">Adds the current selection to the defined print
areas.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3156423"><ahelp
hid=".uno:AddPrintArea">Adds the current selection to the defined print
areas.</ahelp></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000405.xhp#fodrhin"/>
+ <embed href="text/scalc/00/00000405.xhp#addprintrange"/>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/guide/table_cellmerge.xhp
b/source/text/scalc/guide/table_cellmerge.xhp
index e107b9144a..f799806651 100644
--- a/source/text/scalc/guide/table_cellmerge.xhp
+++ b/source/text/scalc/guide/table_cellmerge.xhp
@@ -20,44 +20,45 @@
<meta>
<topic id="textscalcguidetable_cellmergexml" indexer="include"
status="PUBLISH">
- <title xml-lang="en-US" id="tit">Merge and Unmerge Cells</title>
+ <title id="tit">Merge and Unmerge Cells</title>
<filename>/text/scalc/guide/table_cellmerge.xhp</filename>
</topic>
</meta>
<body>
- <bookmark xml-lang="en-US" branch="index" id="bm_id501632012952361">
+ <bookmark branch="index" id="bm_id501632012952361">
<bookmark_value>merge/merging cells</bookmark_value>
<bookmark_value>unmerge/unmerging cells</bookmark_value>
<bookmark_value>split/splitting cells</bookmark_value>
</bookmark>
<section id="merge_unmerge_cells">
<h1 id="hd_id8005005"><variable id="table_cellmerge"><link
href="text/scalc/guide/table_cellmerge.xhp">Merge and Unmerge
Cells</link></variable></h1>
- <paragraph xml-lang="en-US" id="par_id8049867" role="paragraph">You can
select a range of cells, then merge them into a single cell. Conversely, you
can take a previously merged cell and divide it back into individual
cells.</paragraph>
+ <paragraph id="par_id8049867" role="paragraph">You can select a range of
cells, then merge them into a single cell. Conversely, you can take a
previously merged cell and divide it back into individual cells.</paragraph>
</section>
- <paragraph xml-lang="en-US" id="par_id0509200913480176" role="note">When you
copy cells into a target range containing merged cells, the target range gets
unmerged first, then the copied cells are pasted in. If the copied cells are
merged cells, they retain their merge state.</paragraph>
+ <note id="par_id0509200913480176">When you copy cells into a target range
containing merged cells, the target range gets unmerged first, then the copied
cells are pasted in. If the copied cells are merged cells, they retain their
merge state.</note>
<h2 id="hd_id235602">Merge Cells</h2>
<embed href="/text/scalc/01/05060000.xhp#mergecells_warning"/>
<section id="howtoget">
- <paragraph xml-lang="en-US" id="par_id1272927" role="paragraph">Click
and drag to select the cells to be merged then do one of the
following:</paragraph>
- <paragraph role="paragraph" id="par_id221632803290526"
xml-lang="en-US">In the Formatting toolbar click:</paragraph>
+ <paragraph id="par_id1272927" role="paragraph">Click and drag to select
the cells to be merged then do one of the following:</paragraph>
+ <paragraph role="paragraph" id="par_id221632803290526">In the Formatting
toolbar click:</paragraph>
<embed href="text/swriter/00/00000405.xhp#symerge_cells"/>
- <paragraph role="paragraph" id="par_id3154351" xml-lang="en-US">Or,
right click the selection to open the context menu and choose <menuitem>Merge
Cells</menuitem>.<br/>If <menuitem>Unmerge Cells</menuitem> is present instead
then the cell selection contains merged cells and cannot be merged
further.</paragraph>
- <paragraph role="paragraph" id="par_id931632803442925"
xml-lang="en-US">Or, in the <emph>Properties</emph> sidebar mark the
<emph>Merge Cells</emph> checkbox.</paragraph>
- <paragraph role="paragraph" id="par_id3154020" xml-lang="en-US">Or,
choose <menuitem>Format - Merge and Unmerge Cells - Merge
Cells</menuitem></paragraph>
- <paragraph xml-lang="en-US" id="par_id6424146" role="listitem">Or,
choose <menuitem>Format - Merge and Unmerge Cells - Merge and Center
Cells</menuitem></paragraph>
- <paragraph xml-lang="en-US" id="par_id961632012538771"
role="listitem">The cells will be merged and the content will be centered in
the merged cell.</paragraph>
- </section>
+ <paragraph role="paragraph" id="par_id3154351">Or, right click the
selection to open the context menu and choose <menuitem>Merge
Cells</menuitem>.<br/>If <menuitem>Unmerge Cells</menuitem> is present instead
then the cell selection contains merged cells and cannot be merged
further.</paragraph>
+ <paragraph role="paragraph" id="par_id931632803442925">Or, in the
<emph>Properties</emph> sidebar mark the <emph>Merge Cells</emph>
checkbox.</paragraph>
+ <paragraph role="paragraph" id="par_id3154020">Or, choose
<menuitem>Format - Merge and Unmerge Cells - Merge Cells</menuitem></paragraph>
+ <paragraph id="par_id6424146" role="listitem">Or, choose
<menuitem>Format - Merge and Unmerge Cells - Merge and Center
Cells</menuitem></paragraph>
+ <paragraph id="par_id961632012538771" role="listitem">The cells will be
merged and the content will be centered in the merged cell.</paragraph>
+ </section>
+
<embed href="text/scalc/01/05060000.xhp#mergenotes"/>
- <h2 id="hd_id451368">Unmerge Cells</h2>
+ <h2 id="hd_id451368">Unmerge Cells</h2>
<section id="howtoget">
- <paragraph xml-lang="en-US" id="par_id7116611" role="paragraph">Select
the cell to be unmerged, or a selection that includes the cells to be unmerged
then do one of the following:</paragraph>
- <paragraph role="listitem" id="par_id581632820903635"
xml-lang="en-US">In the Formatting toolbar, click:</paragraph>
+ <paragraph id="par_id7116611" role="paragraph">Select the cell to be
unmerged, or a selection that includes the cells to be unmerged then do one of
the following:</paragraph>
+ <paragraph role="listitem" id="par_id581632820903635">In the Formatting
toolbar, click:</paragraph>
<embed href="text/swriter/00/00000405.xhp#sysplit_cells"/>
- <paragraph xml-lang="en-US" id="par_id431632277778130"
role="paragraph">Or, right click the selection to open the context menu and
choose <menuitem>Unmerge Cells</menuitem>.<br/>If <menuitem>Merge
Cells</menuitem> is present instead then the selection does not contain any
merged cells.</paragraph>
- <paragraph xml-lang="en-US" id="par_id261632277824041"
role="paragraph">Or, in the <emph>Properties</emph> sidebar clear the
<emph>Merge Cells</emph> checkbox.</paragraph>
- <paragraph xml-lang="en-US" id="par_id9493087" role="listitem">Or,
choose <menuitem>Format - Merge and Unmerge Cells - Unmerge
Cells</menuitem>.</paragraph>
- <paragraph xml-lang="en-US" id="par_id561632820960500"
role="paragraph">Or, toggle <menuitem>Format - Merge and Unmerge Cells - Merge
and Center Cells</menuitem></paragraph>
+ <paragraph id="par_id431632277778130" role="paragraph">Or, right click
the selection to open the context menu and choose <menuitem>Unmerge
Cells</menuitem>.<br/>If <menuitem>Merge Cells</menuitem> is present instead
then the selection does not contain any merged cells.</paragraph>
+ <paragraph id="par_id261632277824041" role="paragraph">Or, in the
<emph>Properties</emph> sidebar clear the <emph>Merge Cells</emph>
checkbox.</paragraph>
+ <paragraph id="par_id9493087" role="listitem">Or, choose
<menuitem>Format - Merge and Unmerge Cells - Unmerge
Cells</menuitem>.</paragraph>
+ <paragraph id="par_id561632820960500" role="paragraph">Or, toggle
<menuitem>Format - Merge and Unmerge Cells - Merge and Center
Cells</menuitem></paragraph>
</section>
<section id="relatedtopics">
diff --git a/source/text/scalc/main0105.xhp b/source/text/scalc/main0105.xhp
index 59df51261a..9c22a7f0e0 100644
--- a/source/text/scalc/main0105.xhp
+++ b/source/text/scalc/main0105.xhp
@@ -34,26 +34,18 @@
<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/shared/01/05010000.xhp#standard"/>
<h2 id="hd_id3154732"><link href="text/scalc/01/05020000.xhp">Cells</link></h2>
<embed href="text/scalc/01/05020000.xhp#zellattributetext"/>
<embed href="text/scalc/01/05030000.xhp#row"/>
<embed href="text/scalc/01/05040000.xhp#column"/>
-<embed href="text/scalc/01/05050000.xhp#sheet"/>
-<embed href="/text/scalc/guide/table_cellmerge.xhp#merge_unmerge_cells"/>
-
+<embed href="text/scalc/01/MergeCellsMenu.xhp#merge_cells_menu"/>
+<embed href="text/shared/01/05020000.xhp#charater"/>
+<embed href="text/shared/01/05030000.xhp#paragraph"/>
<embed href="text/scalc/01/05070000.xhp#pagestyle"/>
-
<embed href="text/scalc/01/05080000.xhp#printranges"/>
-<h2 id="hd_id3145748"><link
href="text/shared/01/05020000.xhp">Character</link></h2>
-<embed href="text/shared/01/05020000.xhp#zeichentext"/>
-
-<h2 id="hd_id3154485"><link
href="text/shared/01/05030000.xhp">Paragraph</link></h2>
-<embed href="text/shared/01/05030000.xhp#absatztext"/>
-
<h2 id="hd_id3157980"><link
href="text/shared/01/AutoFormat.xhp">AutoFormat</link></h2>
<embed href="text/shared/01/AutoFormat.xhp#autoformattext"/>
diff --git a/source/text/shared/01/05020000.xhp
b/source/text/shared/01/05020000.xhp
index 44279dec13..a8c88639b7 100644
--- a/source/text/shared/01/05020000.xhp
+++ b/source/text/shared/01/05020000.xhp
@@ -30,8 +30,11 @@
<body>
<bookmark branch="hid/.uno:FontDialog" id="bm_id7592030" localize="false"/>
<bookmark branch="hid/.uno:FormatAllNotes" id="bm_id7592031" localize="false"/>
-<h1 id="hd_id3150347">Character</h1>
+<section id="charater">
+ <h1 id="hd_id3150347"><variable id="h1"><link
href="text/shared/01/05020000.xhp#character">Character</link></variable></h1>
<paragraph role="paragraph" id="par_id3153272"><variable
id="zeichentext"><ahelp hid=".uno:FontDialog">Changes the font and the font
formatting for the selected characters.</ahelp></variable></paragraph>
+</section>
+
<section id="howtoget">
<embed href="text/shared/00/00040500.xhp#character"/>
</section>
diff --git a/source/text/shared/01/05030000.xhp
b/source/text/shared/01/05030000.xhp
index e6b195bb93..167cd7f112 100644
--- a/source/text/shared/01/05030000.xhp
+++ b/source/text/shared/01/05030000.xhp
@@ -28,9 +28,13 @@
</meta>
<body>
<bookmark branch="hid/.uno:ParagraphDialog" id="bm_id1815464"
localize="false"/>
-<h1 id="hd_id3150467">Paragraph</h1>
-<paragraph role="paragraph" id="par_id3148668"><variable
id="absatztext"><ahelp hid=".">Modifies the format of the current paragraph,
such as indents and alignment.</ahelp>
-</variable> To modify the font of the current paragraph, select the entire
paragraph, choose Format - Character, and then click on the Font
tab.</paragraph>
+
+<section id="paragraph">
+ <h1 id="hd_id3150467"><variable id="h1"><link
href="text/shared/01/05030000.xhp#paragraph">Paragraph</link></variable></h1>
+ <paragraph role="paragraph" id="par_id3148668"><variable
id="absatztext"><ahelp hid=".">Modifies the format of the current paragraph,
such as indents and alignment.</ahelp></variable></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id871700518278884">To modify the font of
the current paragraph, select the entire paragraph, choose <menuitem>Format -
Character</menuitem>, and then click on the <menuitem>Font</menuitem>
tab.</paragraph>
+
<section id="howtoget">
<embed href="text/shared/00/00040500.xhp#paragraph"/>
</section>
commit d5b140914661fa472e089daeade8ec269f16e314
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Nov 20 18:33:39 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Nov 21 01:29:02 2023 +0100
tdf#155876 UI cmds Calc-Format menu (20)
+ Row/columns menus
+ refactoring
Change-Id: I434ee9975dd3029809a0ae01b15511e77fb70698
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/159745
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000405.xhp
b/source/text/scalc/00/00000405.xhp
index a978cd4be9..2f1dced7af 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -40,21 +40,90 @@
</section>
</section>
<section id="format_cells">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id3154685">Choose <menuitem>Format -
Cells</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_context"/>
+ <paragraph role="paragraph" id="par_id361700498438435">Choose
<menuitem>Format Cells</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
<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>
</section>
<paragraph role="paragraph" id="par_id3153194"><variable id="fozelstz">Choose
<emph>Format - Cells - Cell Protection</emph> tab.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3155854"><variable id="fozei">Choose
<emph>Format - Rows</emph>.</variable></paragraph>
+
+<section id="rowsopr">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3155854"><variable id="fozei">Choose
<emph>Format - Rows</emph>.</variable></paragraph>
+</section>
+
<paragraph role="paragraph" id="par_id3150012"><variable
id="fozeiophoe">Choose <emph>Format - Rows - Optimal
Height</emph>.</variable></paragraph>
<section id="hide">
-<paragraph role="paragraph" id="par_id3148645">Choose <emph>Format - Rows -
Hide</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3153728">Choose <emph>Format - Columns -
Hide</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3151114">Choose <emph>Sheet - Hide
Sheet</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3148645">Choose <emph>Format - Rows -
Hide</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3153728">Choose <emph>Format - Columns
- Hide</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_context"/>
+ <paragraph role="paragraph" id="par_id831700513819432">Click on the rows
headers to select, choose <menuitem>Hide Rows</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id321700513823426">Click on the columns
headers to select, choose <menuitem>Hide Columns</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id671700514153401">Choose <menuitem>Home
- Rows - Hide Rows</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id191700514157898">Choose <menuitem>Home
- Columns - Hide Columns</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id411700514162075">Choose
<menuitem>Layout - Rows - Hide Rows</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id861700514166156">Choose
<menuitem>Layout - Columns - Hide Columns</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id771700513853263">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id481700513853264" role="paragraph"><image
src="cmd/lc_hiderow.svg" id="img_id281700513853265" width="1cm"
height="1cm"><alt id="alt_id701700513853266">Icon Hide
Rows</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id271700513853268" role="paragraph">Hide
Rows</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <table id="tab_id631700513860256">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id991700513860257" role="paragraph"><image
src="cmd/lc_hidecolumn.svg" id="img_id901700513860258" width="1cm"
height="1cm"><alt id="alt_id661700513860259">Icon Hide
Columns</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id911700513860261" role="paragraph">Hide
Columns</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
</section>
<section id="show">
-<paragraph role="paragraph" id="par_id3148576">Choose <emph>Format - Rows -
Show</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3156286">Choose <emph>Format - Columns -
Show</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3148576">Choose <emph>Format - Rows -
Show</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3156286">Choose <emph>Format - Columns
- Show</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_context"/>
+ <paragraph role="paragraph" id="par_id701700515229874">Click on the columns
headers to select, choose <menuitem>Show Rows</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id271700515233843">Click on the columns
headers to select, choose <menuitem>Show Columns</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id451700515369771">Choose <menuitem>Home
- Rows - Show Rows</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id261700515372556">Choose <menuitem>Home
- Columns - Show Columns</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id221700515375420">Choose
<menuitem>Layout - Rows - Show Rows</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id521700515378076">Choose
<menuitem>Layout - Columns - Show Columns</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id461700515398518">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id651700515398519" role="paragraph"><image
src="cmd/lc_showrow.svg" id="img_id611700515398520" width="1cm"
height="1cm"><alt id="alt_id821700515398521">Icon Show
Rows</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id41700515398523" role="paragraph">Show
Rows</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <table id="tab_id331700515405882">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id111700515405883" role="paragraph"><image
src="cmd/lc_showcolumn.svg" id="img_id271700515405884" width="1cm"
height="1cm"><alt id="alt_id861700515405885">Icon Show
Columns</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id301700515405886" role="paragraph">Show
Columns</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
</section>
+
<paragraph role="paragraph" id="par_id3145645"><variable id="fospa">Choose
<emph>Format - Columns</emph>.</variable></paragraph>
<section id="optimal_column_width">
<paragraph role="paragraph" id="par_id3145252">Choose <emph>Format - Columns -
Optimal Width</emph>.</paragraph>
diff --git a/source/text/scalc/01/05020000.xhp
b/source/text/scalc/01/05020000.xhp
index ed2b499687..07f2ceae2b 100644
--- a/source/text/scalc/01/05020000.xhp
+++ b/source/text/scalc/01/05020000.xhp
@@ -19,7 +19,7 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc0105020000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Format Cells</title>
+<title id="tit">Format Cells</title>
<filename>/text/scalc/01/05020000.xhp</filename>
</topic>
<history>
@@ -27,14 +27,14 @@
</history>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3148663"><bookmark_value>cell attributes</bookmark_value>
+<bookmark branch="index" id="bm_id3148663"><bookmark_value>cell
attributes</bookmark_value>
<bookmark_value>attributes;cells</bookmark_value>
<bookmark_value>formatting;cells</bookmark_value>
<bookmark_value>cells;formatting dialog</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatCellDialog"
id="bm_id6056664" localize="false"/>
+<bookmark branch="hid/.uno:FormatCellDialog" id="bm_id6056664"
localize="false"/>
<h1 id="hd_id3148663">Format Cells</h1>
-<paragraph role="paragraph" id="par_id3150448" xml-lang="en-US"><variable
id="zellattributetext"><ahelp hid=".uno:FormatCellDialog">Allows you to specify
a variety of formatting options and to apply attributes to the selected
cells.</ahelp>
+<paragraph role="paragraph" id="par_id3150448"><variable
id="zellattributetext"><ahelp hid=".uno:FormatCellDialog">Allows you to specify
a variety of formatting options and to apply attributes to the selected
cells.</ahelp>
</variable></paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#format_cells"/>
diff --git a/source/text/scalc/01/05030000.xhp
b/source/text/scalc/01/05030000.xhp
index ca7efd70e3..aadf330db6 100644
--- a/source/text/scalc/01/05030000.xhp
+++ b/source/text/scalc/01/05030000.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalc0105030000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Row</title>
+<title id="tit">Row</title>
<filename>/text/scalc/01/05030000.xhp</filename>
</topic>
<history>
@@ -31,18 +28,16 @@
</meta>
<body>
<section id="row">
-<bookmark xml-lang="en-US" branch="hid/.uno:RowMenu" id="bm_id8181096"
localize="false"/>
+<bookmark branch="hid/.uno:RowMenu" id="bm_id8181096" localize="false"/>
<h1 id="hd_id3147228"><link href="text/scalc/01/05030000.xhp">Row</link></h1>
-<paragraph role="paragraph" id="par_id3154685" xml-lang="en-US"><ahelp
hid=".">Sets the row height and hides or shows selected
rows.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3154685"><ahelp hid=".">Sets the row
height and hides or shows selected rows.</ahelp></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000405.xhp#fozei"/>
+ <embed href="text/scalc/00/00000405.xhp#rowsopr"/>
</section>
<h2 id="hd_id3155132"><link
href="text/shared/01/05340100.xhp">Height</link></h2>
<embed href="text/shared/01/05340100.xhp#zeilenhoehetext"/>
-
<embed href="text/shared/01/SetOptimalRowHeight.xhp#optimal_row_height"/>
-
<embed href="text/scalc/01/05030300.xhp#hide"/>
<embed href="text/scalc/01/05030400.xhp#show"/>
</body>
diff --git a/source/text/scalc/01/05030300.xhp
b/source/text/scalc/01/05030300.xhp
index db53e49758..dea9b07c7b 100644
--- a/source/text/scalc/01/05030300.xhp
+++ b/source/text/scalc/01/05030300.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalc0105030300xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Hide</title>
+<title id="tit">Hide</title>
<filename>/text/scalc/01/05030300.xhp</filename>
</topic>
<history>
@@ -31,33 +28,30 @@
</meta>
<body>
<section id="hide">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3147265"><bookmark_value>spreadsheets; hiding
functions</bookmark_value>
+<bookmark branch="index" id="bm_id3147265">
+<bookmark_value>spreadsheets; hiding functions</bookmark_value>
<bookmark_value>hiding; rows</bookmark_value>
<bookmark_value>hiding; columns</bookmark_value>
-<bookmark_value>hiding; sheets</bookmark_value>
-<bookmark_value>sheets;hiding</bookmark_value>
<bookmark_value>columns;hiding</bookmark_value>
<bookmark_value>rows;hiding</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:HideRow" id="bm_id3154760"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:HideColumn" id="bm_id3148663"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:Hide" id="bm_id3149457"
localize="false"/>
+<bookmark branch="hid/.uno:HideRow" id="bm_id3154760" localize="false"/>
+<bookmark branch="hid/.uno:HideColumn" id="bm_id3148663" localize="false"/>
<h1 id="hd_id3147265"><link href="text/scalc/01/05030300.xhp">Hide</link></h1>
-<paragraph role="paragraph" id="par_id3156281" xml-lang="en-US"><ahelp
hid=".">Hides selected rows, columns or individual sheets.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3156281"><ahelp hid=".">Hides selected
rows or columns</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#hide"/>
</section>
-<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US">Select the
rows or columns that you want to hide, and then choose <emph>Format - Rows -
Hide </emph>or<emph> Format - Columns - Hide</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3147427" xml-lang="en-US">You can hide a
sheet by selecting the sheet tab and then choosing <emph>Format - Sheet -
Hide</emph>. Hidden sheets are not printed unless they occur within a <link
href="text/scalc/01/05080000.xhp">print range</link>.</paragraph>
-<paragraph role="note" id="par_id3153157" xml-lang="en-US">A break in the row
or column header indicates whether the row or column is hidden.</paragraph>
-<paragraph role="paragraph" id="par_id3145251" xml-lang="en-US">To display
hidden rows, columns or sheets</paragraph>
+
+<note id="par_id3153157">A break in the row or column header indicates whether
the row or column is hidden.</note>
+<paragraph role="paragraph" id="par_id3145251">To display hidden rows or
columns</paragraph>
<list type="ordered">
<listitem>
-<paragraph role="paragraph" id="par_id8337046" xml-lang="en-US">Select the
range that includes the hidden objects. You can also use the box in the corner
above row 1 and beside column A. For sheets, this step is not
necessary.<comment>UFI: fixes #i18582#</comment></paragraph>
+<paragraph role="paragraph" id="par_id8337046">Select the range that includes
the hidden objects. You can also use the box in the corner above row 1 and
beside column A.</paragraph>
</listitem>
<listitem>
-<paragraph role="paragraph" id="par_id5532090" xml-lang="en-US">Choose <link
href="text/scalc/01/05030400.xhp">Format - Rows/Columns - Show</link> or <link
href="text/scalc/01/05050300.xhp">Format - Sheet - Show</link>.</paragraph>
+<paragraph role="paragraph" id="par_id5532090">Choose <link
href="text/scalc/01/05030400.xhp">Format - Rows/Columns -
Show</link>.</paragraph>
</listitem>
</list>
</body>
diff --git a/source/text/scalc/01/05030400.xhp
b/source/text/scalc/01/05030400.xhp
index 492b093739..4855e4f09c 100644
--- a/source/text/scalc/01/05030400.xhp
+++ b/source/text/scalc/01/05030400.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalc0105030400xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Show</title>
+<title id="tit">Show</title>
<filename>/text/scalc/01/05030400.xhp</filename>
</topic>
<history>
@@ -31,20 +28,22 @@
</meta>
<body>
<section id="show">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3147264"><bookmark_value>spreadsheets; showing columns</bookmark_value>
+<bookmark branch="index" id="bm_id3147264">
+<bookmark_value>spreadsheets; showing columns</bookmark_value>
+<bookmark_value>spreadsheets; showing rows</bookmark_value>
<bookmark_value>showing; columns</bookmark_value>
<bookmark_value>showing; rows</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:ShowRow" id="bm_id3154760"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:ShowColumn" id="bm_id3149456"
localize="false"/>
+<bookmark branch="hid/.uno:ShowRow" id="bm_id3154760" localize="false"/>
+<bookmark branch="hid/.uno:ShowColumn" id="bm_id3149456" localize="false"/>
<h1 id="hd_id3147264"><link href="text/scalc/01/05030400.xhp">Show</link></h1>
-<paragraph role="paragraph" id="par_id3150447" xml-lang="en-US"><ahelp
hid=".">Choose this command to show previously hidden rows or
columns.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150447"><ahelp hid=".">Choose this
command to show previously hidden rows or columns.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#show"/>
</section>
-<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US">To show a
column or row, select the range of rows or columns containing the hidden
elements, then choose <emph>Format - Rows - Show</emph> or <emph>Format -
Columns - Show</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3155132" xml-lang="en-US">For example,
to show the column B, click on the header of the column A, expand the selection
to the column C, then chose <emph>Format - Columns - Show</emph>. To show the
column A previously hidden, click on the header of the column B, keep the mouse
button pressed and drag on the left. The selected range displayed in the name
area changes from B1:B1048576 to A1:B1048576. Choose <emph>Format - Columns -
Show</emph>. Proceed the same way with rows.</paragraph>
-<paragraph role="paragraph" id="par_id3145748" xml-lang="en-US">To show all
hidden cells, first click in the field in the upper left corner. This selects
all cells of the table.</paragraph>
+<paragraph role="paragraph" id="par_id3155131">To show a column or row, select
the range of rows or columns containing the hidden elements, then apply the
command.</paragraph>
+<paragraph role="paragraph" id="par_id3155132">For example, to show the column
B, click on the header of the column A, expand the selection to the column C,
then chose <emph>Format - Columns - Show</emph>. To show the column A
previously hidden, click on the header of the column B, keep the mouse button
pressed and drag on the left. The selected range displayed in the name area
changes from B1:B1048576 to A1:B1048576. Choose <emph>Format - Columns -
Show</emph>. Proceed the same way with rows.</paragraph>
+<paragraph role="paragraph" id="par_id3145748">To show all hidden cells, first
click in the field in the upper left corner. This selects all cells of the
table.</paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/hide_sheet.xhp
b/source/text/scalc/01/hide_sheet.xhp
index 2c8737b0f4..3424ed6f0e 100644
--- a/source/text/scalc/01/hide_sheet.xhp
+++ b/source/text/scalc/01/hide_sheet.xhp
@@ -31,7 +31,7 @@
</section>
<paragraph role="paragraph" id="par_id651684780971395">The sheet is not
visible in the workspace but it is still in the document. All references to
hidden sheet contents are valid.</paragraph>
<paragraph role="paragraph" id="par_id781684780979739">The hidden sheet
does not show in the sheet navigation bar on the bottom of the screen. However
the hidden sheets are listed in the Navigator sidebar under <emph>Sheets</emph>
category. Double clicking on a hidden sheet from the Navigator sidebar position
the viewing on the first sheet visible on the right.</paragraph>
-
+ <note id="par_id3147427">Hidden sheets are not printed unless they occur
within a <link href="text/scalc/01/05080000.xhp">print range</link>.</note>
<section id="relatedtopics">
<paragraph role="paragraph" id="par_id881684781435572"
localize="false"><embedvar href="text/scalc/01/05050300.xhp#showsheet"
markup="ignore"/></paragraph>
</section>
diff --git a/source/text/shared/00/00040503.xhp
b/source/text/shared/00/00040503.xhp
index d4684735d4..6104a9c2d4 100644
--- a/source/text/shared/00/00040503.xhp
+++ b/source/text/shared/00/00040503.xhp
@@ -62,8 +62,24 @@
</section>
</section>
<section id="row_height">
-<paragraph role="paragraph" id="par_id3147294">Choose <emph>Format - Rows -
Height</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3149551">Open context menu of a row
header in an open database table - choose <emph>Row Height</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3147294">Choose <emph>Format - Rows -
Height</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_context"/>
+ <paragraph role="paragraph" id="par_id3149551">Open context menu of a row
header in an open database table - choose <emph>Row Height</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id201700500586824">Choose
<menuitem>Layout - Row - Row Height</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id281700502637222">Choose <menuitem>Home
- Row - Row Height</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id761700500898394">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id31700500898395" role="paragraph"><image
src="cmd/lc_setminimalrowheight.svg" id="img_id791700500898396" width="1cm"
height="1cm"><alt id="alt_id601700500898397">Icon Row
Height</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id511700500898399" role="paragraph">Row
Height</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
</section>
<section id="column_width">
<paragraph role="paragraph" id="par_id3153136">Choose <emph>Format - Columns -
Width</emph>.</paragraph>
diff --git a/source/text/shared/01/05340100.xhp
b/source/text/shared/01/05340100.xhp
index 82eae3a0d4..85683033d8 100644
--- a/source/text/shared/01/05340100.xhp
+++ b/source/text/shared/01/05340100.xhp
@@ -22,30 +22,30 @@
<meta>
<topic id="textshared0105340100xml" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Row Height</title>
+ <title id="tit">Row Height</title>
<filename>/text/shared/01/05340100.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/rowheightdialog/RowHeightDialog" id="bm_id8702934"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/rowheightdialog/@@nowidget@@" 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/DBACCESS_HID_BROWSER_ROWHEIGHT"
id="bm_id3149987" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/rowheightdialog/RowHeightDialog"
id="bm_id8702934" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/rowheightdialog/@@nowidget@@"
id="bm_id8702934" localize="false"/>
+<bookmark branch="hid/.uno:RowHeight" id="bm_id3150146" localize="false"/>
+<bookmark branch="hid/DBACCESS_HID_BROWSER_ROWHEIGHT" id="bm_id3149987"
localize="false"/>
<h1 id="hd_id3154400">Row Height</h1>
- <paragraph xml-lang="en-US" id="par_id3154044"
role="paragraph"><variable id="zeilenhoehetext"><ahelp
hid="modules/scalc/ui/rowheightdialog/RowHeightDialog">Changes the height of
the current row, or the selected rows.</ahelp>
+ <paragraph id="par_id3154044" role="paragraph"><variable
id="zeilenhoehetext"><ahelp
hid="modules/scalc/ui/rowheightdialog/RowHeightDialog">Changes the height of
the current row, or the selected rows.</ahelp>
</variable></paragraph>
- <paragraph xml-lang="en-US" id="par_id3150756"
role="paragraph"><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 id="par_id3150756" role="paragraph"><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#row_height"/>
</section>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/rowheightdialog/value"
id="bm_id3146946" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/rowheight/value"
id="bm_id3083278" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/rowheightdialog/value"
id="bm_id3146946" localize="false"/>
+<bookmark branch="hid/dbaccess/ui/rowheight/value" id="bm_id3083278"
localize="false"/>
<h2 id="hd_id3149962">Height</h2>
- <paragraph xml-lang="en-US" id="par_id3144750" role="paragraph"><ahelp
hid="modules/scalc/ui/rowheightdialog/value">Enter the row height that you want
to use.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/rowheightdialog/default" id="bm_id3154840"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/rowheightdialog/automatic"
id="bm_id3150445" localize="false"/>
+ <paragraph id="par_id3144750" role="paragraph"><ahelp
hid="modules/scalc/ui/rowheightdialog/value">Enter the row height that you want
to use.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/rowheightdialog/default"
id="bm_id3154840" localize="false"/>
+<bookmark branch="hid/dbaccess/ui/rowheightdialog/automatic" id="bm_id3150445"
localize="false"/>
<h2 id="hd_id3154926">Default value</h2>
- <paragraph xml-lang="en-US" id="par_id3154894" role="paragraph"><ahelp
hid="modules/scalc/ui/rowheightdialog/default">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>
+ <paragraph id="par_id3154894" role="paragraph"><ahelp
hid="modules/scalc/ui/rowheightdialog/default">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>
diff --git a/source/text/simpress/guide/table_insert.xhp
b/source/text/simpress/guide/table_insert.xhp
index 98f9e13e8c..af43abad7e 100644
--- a/source/text/simpress/guide/table_insert.xhp
+++ b/source/text/simpress/guide/table_insert.xhp
@@ -56,7 +56,7 @@
<paragraph role="paragraph" id="par_idN10626" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Selects the current table.</ahelp></paragraph>
<comment>Row</comment>
-<bookmark xml-lang="en-US" branch="hid/.uno:RowMenu"
id="bm_id0916200803255185" localize="false"/>
+
<paragraph role="paragraph" id="par_id0916200803551734"
xml-lang="en-US"><ahelp hid="." visibility="hidden">Choose commands for the
selected or all rows.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/.uno:DistributeRows"
id="bm_id0916200803565265" localize="false"/>
<paragraph role="paragraph" id="par_id0916200804080035"
xml-lang="en-US"><ahelp hid="." visibility="hidden">Distributes the height of
the selected or all rows to the same size. The height of the table is not
changed.</ahelp></paragraph>
