diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-07 09:06:44 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-07 09:06:44 +0000 |
| commit | ed5640d8b587fbcfed7dd7967f3de04b37a76f26 (patch) | |
| tree | 7a5f7c6c9d02226d7471cb3cc8fbbf631b415303 /helpcontent2/source/text/scalc/00 | |
| parent | Initial commit. (diff) | |
| download | libreoffice-upstream/4%7.4.7.tar.xz libreoffice-upstream/4%7.4.7.zip | |
Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to '')
| -rw-r--r-- | helpcontent2/source/text/scalc/00/00000004.xhp | 33 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/00/00000402.xhp | 58 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/00/00000403.xhp | 35 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/00/00000404.xhp | 161 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/00/00000405.xhp | 82 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/00/00000406.xhp | 82 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/00/00000407.xhp | 34 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/00/00000412.xhp | 172 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/00/avail_release.xhp | 87 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/00/sheet_menu.xhp | 46 |
10 files changed, 790 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/00/00000004.xhp b/helpcontent2/source/text/scalc/00/00000004.xhp new file mode 100644 index 000000000..640164de3 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000004.xhp @@ -0,0 +1,33 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * 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/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + +<meta> + <topic id="textscalc0000000004xml" indexer="exclude" status="PUBLISH"> + <title id="tit" xml-lang="en-US">To access this function...</title> + <filename>/text/scalc/00/00000004.xhp</filename> + </topic> +</meta> +<body> +<paragraph role="heading" id="hd_id3155535" xml-lang="en-US" level="1"><variable id="wie">To access this function...</variable></paragraph> +<paragraph role="paragraph" id="par_idN1056E" xml-lang="en-US"><variable id="moreontop">More explanations on top of this page.</variable></paragraph> +<paragraph role="note" id="par_idN105AF" xml-lang="en-US"><variable id="optional">In the %PRODUCTNAME Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.</variable><comment>UFI: see #i43239# and #i3879#</comment></paragraph> +<paragraph role="paragraph" id="par_id9751884" xml-lang="en-US"><variable id="codes">Codes greater than 127 may depend on your system's character mapping (for example iso-8859-1, iso-8859-2, Windows-1252, Windows-1250), and hence may not be portable.</variable></paragraph> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/00/00000402.xhp b/helpcontent2/source/text/scalc/00/00000402.xhp new file mode 100644 index 000000000..60b867523 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000402.xhp @@ -0,0 +1,58 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * 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/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . +--> + +<meta> + <topic id="textscalc0000000402xml" indexer="exclude" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Edit Menu</title> + <filename>/text/scalc/00/00000402.xhp</filename> + </topic> +</meta> +<body> +<paragraph id="hd_id3147303" role="heading" level="1" xml-lang="en-US">Edit Menu</paragraph> +<paragraph id="par_id3155555" role="paragraph" xml-lang="en-US"><variable id="kopffuss">Choose <emph>Insert - Headers and Footers</emph>.</variable></paragraph> +<paragraph id="par_id3159233" role="paragraph" xml-lang="en-US"><variable id="bkopfzeile">Choose <emph>Insert - Headers and Footers - Header and Footer</emph> tabs.</variable></paragraph> +<paragraph id="par_id3150443" role="paragraph" xml-lang="en-US"><variable id="bausfullen">Choose <emph>Sheet - Fill Cells</emph>.</variable></paragraph> +<paragraph id="par_id3143267" role="paragraph" xml-lang="en-US"><variable id="bausunten">Choose <emph>Sheet - Fill Cells - Down</emph>.</variable></paragraph> +<paragraph id="par_id3153880" role="paragraph" xml-lang="en-US"><variable id="bausrechts">Choose <emph>Sheet - Fill Cells - Right</emph>.</variable></paragraph> +<paragraph id="par_id3151245" role="paragraph" xml-lang="en-US"><variable id="bausoben">Choose <emph>Sheet - Fill Cells - Up</emph>.</variable></paragraph> +<paragraph id="par_id3145068" role="paragraph" xml-lang="en-US"><variable id="bauslinks">Choose <emph>Sheet - Fill Cells - Left</emph>.</variable></paragraph> +<paragraph id="par_id3150400" role="paragraph" xml-lang="en-US"><variable id="baustab">Choose <emph>Sheet - Fill Cells - Sheets</emph>.</variable></paragraph> +<paragraph id="par_id3154910" role="paragraph" xml-lang="en-US"><variable id="bausreihe">Choose <emph>Sheet - Fill Cells - Series</emph>.</variable></paragraph> + +<section id="clear_cells"> +<paragraph id="par_id3154123" role="paragraph" xml-lang="en-US">Choose <emph>Sheet - Clear Cells</emph>.</paragraph> +<paragraph id="par_id3145785" role="paragraph" xml-lang="en-US">Backspace</paragraph> +</section> +<paragraph id="par_id3150011" role="paragraph" xml-lang="en-US"><variable id="bzelo">Choose <emph>Sheet - Delete Cells</emph>.</variable></paragraph> + +<section id="delete_sheet"> +<paragraph id="par_id3153951" role="paragraph" xml-lang="en-US">Choose <emph>Sheet - Delete Sheet</emph>.</paragraph> +<paragraph id="par_id3155306" role="paragraph" xml-lang="en-US">Open context menu for a sheet tab.</paragraph> +</section> + +<section id="move_or_copy_sheet"> +<paragraph id="par_id3146119" role="paragraph" xml-lang="en-US">Choose <emph>Sheet - Move or Copy Sheet</emph>.</paragraph> +<paragraph id="par_id3148645" role="paragraph" xml-lang="en-US">Open context menu for a sheet tab.</paragraph> +</section> +<section id="cellprotection"> + <paragraph role="paragraph" id="par_id831619443265443">Choose <menuitem>Edit - Cell Protection</menuitem> to activate sheet protection with current cell protection settings.</paragraph> +</section> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/00/00000403.xhp b/helpcontent2/source/text/scalc/00/00000403.xhp new file mode 100644 index 000000000..66c4ce3c6 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000403.xhp @@ -0,0 +1,35 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * 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/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . +--> + +<meta> + <topic id="textscalc0000000403xml" indexer="exclude" status="PUBLISH"> + <title id="tit" xml-lang="en-US">View Menu</title> + <filename>/text/scalc/00/00000403.xhp</filename> + </topic> +</meta> +<body> +<paragraph id="hd_id3145673" role="heading" level="1" xml-lang="en-US">View Menu</paragraph> +<paragraph id="par_id3150275" role="paragraph" xml-lang="en-US"><variable id="aspze">Choose <emph>View - Column & Row Headers</emph>.</variable></paragraph> +<paragraph id="par_id3154514" role="paragraph" xml-lang="en-US"><variable id="awehe">Choose <emph>View - Value Highlighting</emph>.</variable></paragraph> +<paragraph id="par_id3148947" role="paragraph" xml-lang="en-US"><variable id="rechenleiste">Choose <emph>View - Formula Bar</emph> or <emph>View - Toolbars - Formula Bar</emph>.</variable></paragraph> +<paragraph id="par_id3148663" role="paragraph" xml-lang="en-US"><variable id="seumvo">Choose <emph>View - Page Break</emph>.</variable></paragraph> +<paragraph id="par_id3155383" role="paragraph" xml-lang="en-US"><variable id="functionlist">Choose <menuitem>View - Function List</menuitem>.</variable></paragraph> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/00/00000404.xhp b/helpcontent2/source/text/scalc/00/00000404.xhp new file mode 100644 index 000000000..d9873d31c --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000404.xhp @@ -0,0 +1,161 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * 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/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + +<meta> + <topic id="textscalc0000000404xml" indexer="exclude" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Insert Menu</title> + <filename>/text/scalc/00/00000404.xhp</filename> + </topic> + <history> + <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> + </history> +</meta> +<body> +<h1 id="hd_id3149346">Insert Menu</h1> +<section id="insert_cells"> +<paragraph role="paragraph" id="par_id3149784" xml-lang="en-US">Choose <menuitem>Sheet - Insert Cells</menuitem>.</paragraph> +<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US">Choose <menuitem>View - Toolbars</menuitem> and select the <emph>Insert Cells</emph> toolbar:</paragraph> +<section id="syinsert_cells"> +<table id="tbl_id3148550"> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US"> +<image id="img_id3154365" src="cmd/sc_inscellsctrl.png" width="0.222inch" height="0.222inch"><alt id="alt_id3154365" xml-lang="en-US">Icon</alt></image></paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3151041" xml-lang="en-US">Insert Cells</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</section> +<section id="syinsert_cells_down"> +<table id="tbl_id3159486"> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US"> +<image id="img_id3145364" src="cmd/sc_insertcellsdown.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145364" xml-lang="en-US">Icon</alt></image></paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3146985" xml-lang="en-US">Insert Cells Down</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +<section id="syinsert_cells_right"> +<table id="tbl_id3148575"> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3144766" xml-lang="en-US"> +<image id="img_id3154942" src="cmd/sc_insertcellsright.png" width="0.222inch" height="0.222inch"><alt id="alt_id3154942" xml-lang="en-US">Icon</alt></image></paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3145646" xml-lang="en-US">Insert Cells Right</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +<section id="syinsert_rows"> +<table id="tbl_id3154015"> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153838" xml-lang="en-US"> +<image id="img_id3153710" src="cmd/sc_insertrows.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153710" xml-lang="en-US">Icon</alt></image></paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3150324" xml-lang="en-US">Insert Rows</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +<section id="syinsert_columns"> +<table id="tbl_id3147338"> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3147363" xml-lang="en-US"> +<image id="img_id3145232" src="cmd/sc_insertcolumns.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145232" xml-lang="en-US">Icon</alt></image></paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3155334" xml-lang="en-US">Insert Columns</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +<paragraph role="paragraph" id="par_id3149033" xml-lang="en-US"><variable id="eitab">Choose <menuitem>Sheet - Insert Sheet</menuitem>.</variable></paragraph> +<paragraph role="paragraph" id="par_idN1082F" xml-lang="en-US"><variable id="eitabfile">Choose <menuitem>Sheet - Insert Sheet from File</menuitem>.</variable></paragraph> +<section id="insert_function"> +<paragraph role="paragraph" id="par_id3155115" xml-lang="en-US">Choose <menuitem>Insert - Function</menuitem>.</paragraph> +<paragraph role="paragraph" id="par_id3152582" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph> + <paragraph role="paragraph" id="par_id3153269" xml-lang="en-US">On the <emph>Formula</emph> bar, click</paragraph> +<section id="syfunction_wizard"> +<table id="tbl_id3145258"> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3150515" xml-lang="en-US"> +<image id="img_id3150884" src="sw/res/sc20556.png" width="0.222inch" height="0.222inch"><alt id="alt_id3150884" xml-lang="en-US">Icon</alt></image></paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US">Function Wizard</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</section> +<paragraph role="paragraph" id="par_id3156288" xml-lang="en-US"><variable id="eikada"><emph>Insert - Function</emph> - Category <emph>Database</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US"><variable id="eikadaze"><emph>Insert - Function</emph> - Category <emph>Date & Time</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3151334" xml-lang="en-US"><variable id="eikafi"><emph>Insert - Function</emph> - Category <emph>Financial</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3159222" xml-lang="en-US"><variable id="eikain"><emph>Insert - Function</emph> - Category <emph>Information</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3159173" xml-lang="en-US"><variable id="logical"><emph>Insert - Function</emph> - Category <emph>Logical</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3153914" xml-lang="en-US"><variable id="eikama"><emph>Insert - Function</emph> - Category <emph>Mathematical</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3150109" xml-lang="en-US"><variable id="eikamatrix"><emph>Insert - Function</emph> - Category <emph>Array</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3157978" xml-lang="en-US"><variable id="eikasta"><emph>Insert - Function</emph> - Category <emph>Statistical</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3156016" xml-lang="en-US"><variable id="eikatext"><emph>Insert - Function</emph> - Category <emph>Text</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3147075" xml-lang="en-US"><variable id="efefft"><emph>Insert - Function</emph> - Category <emph>Spreadsheet</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US"><variable id="addin"><emph>Insert - Function</emph> - Category <emph>Add-In</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3154059" xml-lang="en-US"><variable id="addinana"><emph>Insert - Function</emph> - Category <emph>Add-In</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3153250" xml-lang="en-US"><variable id="einamen">Choose <menuitem>Insert - Named Range or Expression</menuitem>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3146776" xml-lang="en-US"><variable id="eiextdata">Choose <menuitem>Sheet - External Links</menuitem>.</variable></paragraph> +<section id="define_name"> +<paragraph role="paragraph" id="par_id3143222" xml-lang="en-US">Choose <menuitem>Sheet - Named Ranges and Expressions - Define</menuitem>.</paragraph> +<paragraph role="paragraph" id="par_id3149385" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph> +</section> +<paragraph role="paragraph" id="par_id3145214" xml-lang="en-US"><variable id="einaei">Choose <menuitem>Sheet - Named Ranges and Expressions - Insert</menuitem>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3153558" xml-lang="en-US"><variable id="einaueb">Choose <menuitem>Sheet - Named Ranges and Expressions - Create</menuitem>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3153483" xml-lang="en-US"><variable id="einabesch">Choose <menuitem>Sheet - Named Ranges and Expressions - Labels</menuitem>.</variable></paragraph> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/00/00000405.xhp b/helpcontent2/source/text/scalc/00/00000405.xhp new file mode 100644 index 000000000..13ee92fbe --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000405.xhp @@ -0,0 +1,82 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * 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/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + +<meta> + <topic id="textscalc0000000405xml" indexer="exclude" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Format Menu</title> + <filename>/text/scalc/00/00000405.xhp</filename> + </topic> + <history> + <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> + </history> +</meta> +<body> +<h1 id="hd_id3150769">Format Menu</h1> +<section id="format_cells"> + <paragraph role="paragraph" id="par_id3154685" xml-lang="en-US">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> +</section> +<paragraph role="paragraph" id="par_id3153194" xml-lang="en-US"><variable id="fozelstz">Choose <emph>Format - Cells - Cell Protection</emph> tab.</variable></paragraph> +<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US"><variable id="fozei">Choose <emph>Format - Rows</emph>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3150012" xml-lang="en-US"><variable id="fozeiophoe">Choose <emph>Format - Rows - Optimal Height</emph>.</variable></paragraph> +<section id="hide"> +<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US">Choose <emph>Format - Rows - Hide</emph>.</paragraph> +<paragraph role="paragraph" id="par_id3153728" xml-lang="en-US">Choose <emph>Format - Columns - Hide</emph>.</paragraph> +<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US">Choose <emph>Sheet - Hide Sheet</emph>.</paragraph> +</section> +<section id="show"> +<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US">Choose <emph>Format - Rows - Show</emph>.</paragraph> +<paragraph role="paragraph" id="par_id3156286" xml-lang="en-US">Choose <emph>Format - Columns - Show</emph>.</paragraph> +</section> +<paragraph role="paragraph" id="par_id3145645" xml-lang="en-US"><variable id="fospa">Choose <emph>Format - Columns</emph>.</variable></paragraph> +<section id="optimal_column_width"> +<paragraph role="paragraph" id="par_id3145252" xml-lang="en-US">Choose <emph>Format - Columns - Optimal Width</emph>.</paragraph> +<paragraph role="paragraph" id="par_id3146971" xml-lang="en-US">Double-click right column separator in column headers.</paragraph> +</section> +<paragraph role="paragraph" id="par_id3147362" xml-lang="en-US"><variable id="fot">Choose <emph>Sheet</emph>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3163805" xml-lang="en-US"><variable id="fotu">Choose <emph>Sheet - Rename Sheet</emph>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3155333" xml-lang="en-US"><variable id="fotenb">Choose <emph>Sheet - Show Sheet</emph>.</variable></paragraph> +<paragraph role="paragraph" id="par_idN1077A" xml-lang="en-US"><variable id="foste">Choose <emph>Format - Page</emph>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3155508" xml-lang="en-US"><variable id="fostel">Choose <emph>Format - Page - Sheet</emph> tab.</variable></paragraph> +<paragraph role="paragraph" id="par_id3150883" xml-lang="en-US"><variable id="fodrbe">Choose <emph>Format - Print Ranges</emph>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US"><variable id="fodrfe">Choose <emph>Format - Print Ranges - Define</emph>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3156290" xml-lang="en-US"><variable id="fodrhin">Choose <emph>Format - Print Ranges - Add</emph>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3155812" xml-lang="en-US"><variable id="fodbah">Choose <emph>Format - Print Ranges - Clear</emph>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3153307" xml-lang="en-US"><variable id="fodbbe">Choose <emph>Format - Print Ranges - Edit</emph>.</variable></paragraph> +<section id="autoformat"> +<paragraph role="paragraph" id="par_id3153916" xml-lang="en-US">Choose <emph>Format - AutoFormat Styles</emph>.</paragraph> + <paragraph role="paragraph" id="par_id3154532" xml-lang="en-US">On the <emph>Tools</emph> bar, click</paragraph> +<section id="syautoformat"> +<table id="tbl_id3148605"> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3149332" xml-lang="en-US"> +<image id="img_id3156020" src="cmd/sc_autoformat.svg" width="1cm" height="1cm"><alt id="alt_id3156020" xml-lang="en-US">AutoFormat Styles Icon</alt></image></paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3154060" xml-lang="en-US">AutoFormat</paragraph> +</tablecell> +</tablerow> +</table> +</section> +</section> +<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US"><variable id="bedingte">Choose <emph>Format - Conditional</emph>.</variable></paragraph> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/00/00000406.xhp b/helpcontent2/source/text/scalc/00/00000406.xhp new file mode 100644 index 000000000..64239b361 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000406.xhp @@ -0,0 +1,82 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * 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/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . +--> + +<meta> + <topic id="textscalc0000000406xml" indexer="exclude" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Tools Menu</title> + <filename>/text/scalc/00/00000406.xhp</filename> + </topic> +</meta> +<body> +<h1 id="hd_id3147264">Tools Menu</h1> +<paragraph id="par_id3150541" role="paragraph" xml-lang="en-US"><variable id="exdektv">Choose <emph>Tools - Detective</emph>.</variable></paragraph> + +<section id="trace_precedents"> +<paragraph id="par_id3153194" role="paragraph" xml-lang="en-US">Choose <emph>Tools - Detective - Trace Precedents</emph>.</paragraph> +<paragraph id="par_id3150447" role="paragraph" xml-lang="en-US">Shift+F9</paragraph> +</section> +<paragraph id="par_id3154123" role="paragraph" xml-lang="en-US"><variable id="silbentrennungc">Menu <emph>Tools - Language - Hyphenation</emph>.</variable></paragraph> +<paragraph id="par_id3145785" role="paragraph" xml-lang="en-US"><variable id="exdvore">Choose <emph>Tools - Detective - Remove Precedents</emph>.</variable></paragraph> + +<section id="trace_dependents"> +<paragraph id="par_id3155411" role="paragraph" xml-lang="en-US">Choose <emph>Tools - Detective - Trace Dependents</emph>.</paragraph> +<paragraph id="par_id3153363" role="paragraph" xml-lang="en-US">Shift+F5</paragraph> +</section> +<paragraph id="par_id3146984" role="paragraph" xml-lang="en-US"><variable id="exdszne">Choose <emph>Tools - Detective - Remove Dependents</emph>.</variable></paragraph> +<paragraph id="par_id3154014" role="paragraph" xml-lang="en-US"><variable id="exdase">Choose <emph>Tools - Detective - Remove All Traces</emph>.</variable></paragraph> +<paragraph id="par_id3153188" role="paragraph" xml-lang="en-US"><variable id="exdszfe">Choose <emph>Tools - Detective - Trace Error</emph>.</variable></paragraph> +<paragraph id="par_id3149410" role="paragraph" xml-lang="en-US"><variable id="fuellmodus">Choose <emph>Tools - Detective - Fill Mode</emph>.</variable></paragraph> +<paragraph id="par_id3156284" role="paragraph" xml-lang="en-US"><variable id="dateneinkreisen">Choose <emph>Tools - Detective - Mark Invalid Data</emph>.</variable></paragraph> +<paragraph id="par_id3153159" role="paragraph" xml-lang="en-US"><variable id="spurenaktualisieren">Choose <emph>Tools - Detective - Refresh Traces</emph>.</variable></paragraph> +<paragraph id="par_id3147397" role="paragraph" xml-lang="en-US"><variable id="automatisch">Choose <emph>Tools - Detective - AutoRefresh</emph>.</variable></paragraph> +<paragraph id="par_id3154018" role="paragraph" xml-lang="en-US"><variable id="exzws">Choose <emph>Tools - Goal Seek</emph>.</variable></paragraph> +<paragraph id="par_id3269142" role="paragraph" xml-lang="en-US"><variable id="solver">Choose <emph>Tools - Solver</emph>.</variable></paragraph> +<paragraph id="par_id8554338" role="paragraph" xml-lang="en-US"><variable id="solver_options">Choose <emph>Tools - Solver</emph>, click <emph>Options</emph> button.</variable></paragraph> +<paragraph id="par_id3156277" role="paragraph" xml-lang="en-US"><variable id="exsze">Choose <emph>Tools - Scenarios</emph>.</variable></paragraph> + +<paragraph role="paragraph" id="par_id971647297529392"><variable id="tools_forms">Choose <emph>Tools - Forms</emph>.</variable></paragraph> + +<paragraph role="paragraph" id="par_id371647273694433"><variable id="share_spreadsheet">Choose <menuitem>Tools - Share Spreadsheet</menuitem></variable></paragraph> + +<paragraph id="par_id3149020" role="paragraph" xml-lang="en-US"><variable id="protect_sheet">Choose <emph>Tools - Protect Sheet</emph>.</variable></paragraph> +<paragraph id="par_id3154256" role="paragraph" xml-lang="en-US"><variable id="protect_spreadsheet">Choose <emph>Tools - Protect Spreadsheet Structure</emph>.</variable></paragraph> + +<section id="recalculate"> +<paragraph id="par_id3146919" role="paragraph" xml-lang="en-US">Choose <emph>Data - Calculate - Recalculate</emph>.</paragraph> +<paragraph id="par_id3149257" role="paragraph" xml-lang="en-US">Press <keycode>F9</keycode></paragraph> +</section> + +<section id="formula_options"> +<paragraph id="par_id3146919a" role="paragraph" xml-lang="en-US">Choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Formula</emph>.</paragraph> +</section> + +<section id="recalculate_hard"> + <paragraph role="paragraph" id="par_id891645217179561">Choose <menuitem>Data - Calculate - Recalculate hard</menuitem>.</paragraph> + <paragraph role="paragraph" id="par_id21645217233263">Press <keycode>Shift</keycode>+<switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode></paragraph> +</section> + +<section id="formula2value"> + <paragraph role="paragraph" id="par_id31645223233125">Select a formula cell or a formula cell range and choose <menuitem>Data - Calculate - Formula to values</menuitem></paragraph> +</section> + +<paragraph id="par_id3150941" role="paragraph" xml-lang="en-US"><variable id="exatmb">Choose <emph>Data - Calculate - AutoCalculate</emph>.</variable></paragraph> +<paragraph id="par_id3151276" role="paragraph" xml-lang="en-US"><variable id="autoeingabe">Choose <emph>Tools - AutoInput</emph>.</variable></paragraph> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/00/00000407.xhp b/helpcontent2/source/text/scalc/00/00000407.xhp new file mode 100644 index 000000000..c6ba07932 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000407.xhp @@ -0,0 +1,34 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * 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/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . +--> + +<meta> + <topic id="textscalc0000000407xml" indexer="exclude" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Window Menu</title> + <filename>/text/scalc/00/00000407.xhp</filename> + </topic> +</meta> +<body> +<h1 id="hd_id3155628" xml-lang="en-US">Window Menu</h1> +<paragraph id="par_id3147335" role="paragraph" xml-lang="en-US"><variable id="fete">Choose <menuitem>View - Split Window</menuitem>.</variable></paragraph> +<paragraph id="par_id3153663" role="paragraph" xml-lang="en-US"><variable id="fefix">Choose <menuitem>View - Freeze Rows and Columns</menuitem>.</variable></paragraph> +<paragraph role="paragraph" id="par_id631612313719480"><variable id="freezefirstcol">Choose <menuitem>View - Freeze Cells - Freeze First Column</menuitem></variable></paragraph> +<paragraph role="paragraph" id="par_id251612313725513"><variable id="freezefirstrow">Choose <menuitem>View - Freeze Cells - Freeze First Row</menuitem></variable></paragraph> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/00/00000412.xhp b/helpcontent2/source/text/scalc/00/00000412.xhp new file mode 100644 index 000000000..50de754f2 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000412.xhp @@ -0,0 +1,172 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * 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/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + + <meta> + <topic id="textscalc0000000412xml" indexer="exclude" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Data Menu</title> + <filename>/text/scalc/00/00000412.xhp</filename> + </topic> + </meta> + <body> + <h1 id="hd_id3145136">Data Menu</h1> + <paragraph role="paragraph" id="par_id8366954" xml-lang="en-US"><variable id="text2columns">Choose <emph>Data - Text to Columns</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3147399" xml-lang="en-US"><variable id="dbrbf">Choose <emph>Data - Define Range</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3145345" xml-lang="en-US"><variable id="dbrba">Choose <emph>Data - Select Range</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3150443" xml-lang="en-US"><variable id="dnsrt">Choose <emph>Data - Sort...</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id641584647437810"><variable id="datasortascending">Choose <menuitem>Data - Sort Ascending</menuitem></variable></paragraph> + <paragraph role="paragraph" id="par_id711584647447316"><variable id="datasortdescending">Choose <menuitem>Data - Sort Descending</menuitem></variable></paragraph> + <section id="sort_criteria"> + <paragraph role="paragraph" id="par_id3148491" xml-lang="en-US">Choose <emph>Data - Sort - Sort Criteria</emph> tab.</paragraph> + <paragraph role="paragraph" id="par_id3154516" xml-lang="en-US"><variable id="onthestandardbar">On <emph>Standard</emph> bar, click</variable></paragraph> + <section id="sysort_criteria"> + <section id="sortascending"> + <table id="tbl_id3156023"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3148663" xml-lang="en-US"> + <image id="img_id3150543" src="cmd/sc_sortup.png" width="1cm" height="1cm"><alt id="alt_id3150543" xml-lang="en-US">Icon Sort Ascending</alt></image> + </paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3150767" xml-lang="en-US">Sort Ascending</paragraph> + </tablecell> + </tablerow> + </table> + </section> + <section id="sortdescending"> + <table id="tbl_id3256023"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"> + <image id="img_id3125863" src="cmd/sc_sortdown.png" width="1cm" height="1cm"><alt id="alt_id3125863" xml-lang="en-US">Icon Sort Descending</alt></image> + </paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3145364" xml-lang="en-US">Sort Descending</paragraph> + </tablecell> + </tablerow> + </table> + </section> + </section> + </section> + <paragraph role="paragraph" id="par_id3146984" xml-lang="en-US"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab.</variable></paragraph> + <paragraph role="paragraph" id="par_id3155308" xml-lang="en-US"><variable id="dnftr">Choose <emph>Data - More Filters</emph>.</variable></paragraph> + <section id="autofilter"> + <paragraph role="paragraph" id="par_id3148646" xml-lang="en-US">Choose <emph>Data - AutoFilter</emph>.</paragraph> + <paragraph role="paragraph" id="par_id3151113" xml-lang="en-US">On <emph>Tools</emph> bar or <emph>Table Data</emph> bar, click</paragraph> + <section id="syautofilter"> + <table id="tbl_id3155418"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3145799" xml-lang="en-US"> + <image id="img_id3149413" src="cmd/sc_datafilterautofilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3149413" xml-lang="en-US">Icon</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3149401" xml-lang="en-US">AutoFilter</paragraph> + </tablecell> + </tablerow> + </table> + </section> + </section> + <paragraph role="paragraph" id="par_id3156278" xml-lang="en-US"><variable id="dnfspz">Choose <emph>Data - More Filters - Advanced Filter...</emph> .</variable></paragraph> + <section id="filter_options"> + <paragraph role="paragraph" id="par_id3153764" xml-lang="en-US">Choose <emph>Data - More Filters - Standard Filter... - Options</emph> label.</paragraph> + <paragraph role="paragraph" id="par_id3155444" xml-lang="en-US">Choose <emph>Data - More Filters - Advanced Filter... - Options</emph> label.</paragraph> + </section> + <section id="reset_filter"> + <paragraph role="paragraph" id="par_id3156382" xml-lang="en-US">Choose <emph>Data - More Filters - Reset Filter</emph>.</paragraph> + <paragraph role="paragraph" id="par_id3155961" xml-lang="en-US">On <emph>Table Data</emph> bar, click <emph>Reset Filter/Sort</emph>.</paragraph> + <table id="tbl_id3146919"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3148485" xml-lang="en-US"> + <image id="img_id3145792" src="cmd/sc_removefilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145792" xml-lang="en-US">Icon</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3149207" xml-lang="en-US">Reset Filter/Sort</paragraph> + </tablecell> + </tablerow> + </table> + </section> + <paragraph role="paragraph" id="par_id3152778" xml-lang="en-US"><variable id="dnaftas">Choose <emph>Data - More Filter - Hide AutoFilter</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3166424" xml-lang="en-US"><variable id="dntegs">Choose <emph>Data - Subtotals</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3154574" xml-lang="en-US"><variable id="dntezd">Choose <emph>Data - Subtotals - 1st, 2nd, 3rd Group</emph> tabs.</variable></paragraph> + <paragraph role="paragraph" id="par_id3151277" xml-lang="en-US"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab.</variable></paragraph> + <paragraph role="paragraph" id="par_id3145133" xml-lang="en-US"><variable id="datengueltig">Choose <emph>Data - Validity</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3152992" xml-lang="en-US"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab.</variable></paragraph> + <paragraph role="paragraph" id="par_id3150367" xml-lang="en-US"><variable id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph> tab.</variable></paragraph> + <paragraph role="paragraph" id="par_id3154486" xml-lang="en-US"><variable id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph> tab.</variable></paragraph> + <paragraph role="paragraph" id="par_id3146978" xml-lang="en-US"><variable id="dnmfo">Choose <emph>Data - Multiple Operations</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3155809" xml-lang="en-US"><variable id="dnksd">Choose <emph>Data - Consolidate</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3148701" xml-lang="en-US"><variable id="dngld">Choose <emph>Data - Group and Outline</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3153815" xml-lang="en-US"><variable id="dngda">Choose <emph>Data - Group and Outline - Hide Details</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3159223" xml-lang="en-US"><variable id="dngde">Choose <emph>Data - Group and Outline - Show Details</emph>.</variable></paragraph> + <section id="data_outline_group"> + <paragraph role="paragraph" id="par_id3146870" xml-lang="en-US">Choose <emph>Data - Group and Outline - Group</emph>.</paragraph> + <paragraph role="paragraph" id="par_id3144507" xml-lang="en-US">F12</paragraph> + <paragraph role="paragraph" id="par_id3144772" xml-lang="en-US">On <emph>Tools</emph> bar, click</paragraph> + <section id="sygroup"> + <table id="tbl_id3154532"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3149438" xml-lang="en-US"> + <image id="img_id3153287" src="cmd/sc_group.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153287" xml-lang="en-US">Icon</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3150214" xml-lang="en-US">Group</paragraph> + </tablecell> + </tablerow> + </table> + </section> + </section> + <section id="data_outline_ungroup"> + <paragraph role="paragraph" id="par_id3146781" xml-lang="en-US">Choose <emph>Data - Group and Outline - Ungroup</emph>.</paragraph> + <paragraph role="paragraph" id="par_id3150892" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph> + <paragraph role="paragraph" id="par_id3155097" xml-lang="en-US">On <emph>Tools</emph> bar, click</paragraph> + <section id="syungroup"> + <table id="tbl_id3143223"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3150048" xml-lang="en-US"> + <image id="img_id3155914" src="cmd/sc_ungroup.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155914" xml-lang="en-US">Icon</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3153555" xml-lang="en-US">Ungroup</paragraph> + </tablecell> + </tablerow> + </table> + </section> + </section> + <paragraph role="paragraph" id="par_id3153008" xml-lang="en-US"><variable id="dnglagl">Choose <emph>Data - Group and Outline - AutoOutline</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3154709" xml-lang="en-US"><variable id="dnglef">Choose <emph>Data - Group and Outline - Remove Outline</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id1774346" xml-lang="en-US"><variable id="dngdrill">Choose <emph>Data - Group and Outline - Show Details</emph> (for some pivot tables).</variable></paragraph> + <paragraph role="paragraph" id="par_id3155759" xml-lang="en-US"><variable id="dndtpt">Choose <emph>Data - Pivot Table</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3154625" xml-lang="en-US"><variable id="dndpa">Choose <emph>Insert - Pivot Table</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3147558" xml-lang="en-US"><variable id="dndq">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Data source registered in $[officename]</emph>.</variable></paragraph> + <section id="insert_pivot_table"> + <paragraph role="paragraph" id="par_id3153297" xml-lang="en-US">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Current selection</emph>.</paragraph> + <paragraph role="paragraph" id="par_id3145118" xml-lang="en-US">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Data source registered in $[officename]</emph>, click <emph>OK</emph> to see <emph>Select Data Source</emph> dialog.</paragraph> + </section> + <paragraph role="paragraph" id="par_id3153294" xml-lang="en-US"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3151344" xml-lang="en-US"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3150397" xml-lang="en-US"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_idN10B8F" xml-lang="en-US"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph>.</variable></paragraph> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/00/avail_release.xhp b/helpcontent2/source/text/scalc/00/avail_release.xhp new file mode 100644 index 000000000..75383ea1a --- /dev/null +++ b/helpcontent2/source/text/scalc/00/avail_release.xhp @@ -0,0 +1,87 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * 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/. + * + --> + + <meta> + <topic id="availablerelease" indexer="include" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Available since release</title> + <filename>/text/scalc/00/avail_release.xhp</filename> + </topic> + </meta> + + <body> + <section id="3.3"> + <tip id="par_id651551701041690">This function is available since %PRODUCTNAME 3.3.</tip> + </section> + <section id="3.4"> + <tip id="par_id651551401041690">This function is available since %PRODUCTNAME 3.4.</tip> + </section> + <section id="3.5"> + <tip id="par_id651551401041635">This function is available since %PRODUCTNAME 3.5.</tip> + </section> + <section id="3.6"> + <tip id="par_id651551401041636">This function is available since %PRODUCTNAME 3.6.</tip> + </section> + <section id="4.0"> + <tip id="par_id651551401041640">This function is available since %PRODUCTNAME 4.0.</tip> + </section> + <section id="4.1"> + <tip id="par_id651551401041641">This function is available since %PRODUCTNAME 4.1.</tip> + </section> + <section id="4.2"> + <tip id="par_id651551401041642">This function is available since %PRODUCTNAME 4.2.</tip> + </section> + <section id="4.3"> + <tip id="par_id651551401041643">This function is available since %PRODUCTNAME 4.3.</tip> + </section> + <section id="4.4"> + <tip id="par_id651551401041644">This function is available since %PRODUCTNAME 4.4.</tip> + </section> + <section id="5.0"> + <tip id="par_id651551401041650">This function is available since %PRODUCTNAME 5.0.</tip> + </section> + <section id="5.1"> + <tip id="par_id651551401041651">This function is available since %PRODUCTNAME 5.1.</tip> + </section> + <section id="5.2"> + <tip id="par_id651551401041652">This function is available since %PRODUCTNAME 5.2.</tip> + </section> + <section id="5.3"> + <tip id="par_id651551401041653">This function is available since %PRODUCTNAME 5.3.</tip> + </section> + <section id="5.4"> + <tip id="par_id651551401041654">This function is available since %PRODUCTNAME 5.4.</tip> + </section> + <section id="6.0"> + <tip id="par_id651551401041660">This function is available since %PRODUCTNAME 6.0.</tip> + </section> + <section id="6.1"> + <tip id="par_id651551401041661">This function is available since %PRODUCTNAME 6.1.</tip> + </section> + <section id="6.2"> + <tip id="par_id651551401041662">This function is available since %PRODUCTNAME 6.2.</tip> + </section> + <section id="6.3"> + <tip id="par_id651551401041663">This function is available since %PRODUCTNAME 6.3.</tip> + </section> + <section id="6.4"> + <tip id="par_id651551401041664">This function is available since %PRODUCTNAME 6.4.</tip> + </section> + <section id="7.0"> + <tip id="par_id651551401041665">This function is available since %PRODUCTNAME 7.0.</tip> + </section> + <section id="7.1"> + <tip id="par_id651551401041666">This function is available since %PRODUCTNAME 7.1.</tip> + </section> + <section id="7.2"> + <tip id="par_id651551401041667">This function is available since %PRODUCTNAME 7.2.</tip> + </section> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/00/sheet_menu.xhp b/helpcontent2/source/text/scalc/00/sheet_menu.xhp new file mode 100644 index 000000000..875b1b2c6 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/sheet_menu.xhp @@ -0,0 +1,46 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * 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/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . +--> + +<meta> + <topic id="textscalc0000000404xml" indexer="exclude" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Sheet Menu</title> + <filename>/text/scalc/00/sheet_menu.xhp</filename> + </topic> +</meta> +<body> +<h1 id="hd_id160220162108024368">Sheet Menu</h1> +<paragraph id="par_id160220162106567373" role="paragraph" xml-lang="en-US"><variable id="insert_rows_above">Choose <emph>Sheet - Insert Rows - Rows Above</emph>.</variable></paragraph> +<paragraph id="par_id160220162109048207" role="paragraph" xml-lang="en-US"><variable id="insert_rows_below">Choose <emph>Sheet - Insert Rows - Rows Below</emph>.</variable></paragraph> +<paragraph id="par_id160220162107055028" role="paragraph" xml-lang="en-US"><variable id="insert_columns_left">Choose <emph>Sheet - Insert Columns - Columns Before</emph>.</variable></paragraph> +<paragraph id="par_id160220162109126013" role="paragraph" xml-lang="en-US"><variable id="insert_columns_right">Choose <emph>Sheet - Insert Columns - Columns After</emph>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3149095" xml-lang="en-US"><variable id="insert_page_break">Choose <emph>Sheet - Insert Page Break</emph>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3149398" xml-lang="en-US"><variable id="insert_page_break_row">Choose <emph>Sheet - Insert Page Break - Row Break</emph>.</variable></paragraph> +<paragraph role="paragraph" id="par_id3150084" xml-lang="en-US"><variable id="insert_page_break_column">Choose <emph>Sheet - Insert Page Break - Column Break</emph>.</variable></paragraph> +<paragraph id="par_id3153093" role="paragraph" xml-lang="en-US"><variable id="delete_page_break">Choose <emph>Sheet - Delete Page Break</emph>.</variable></paragraph> +<paragraph id="par_id3153191" role="paragraph" xml-lang="en-US"><variable id="delete_page_break_row">Choose <emph>Sheet - Delete Page Break - Row Break</emph>.</variable></paragraph> +<paragraph id="par_id3145645" role="paragraph" xml-lang="en-US"><variable id="delete_page_break_column">Choose <emph>Sheet - Delete Page Break - Column Break</emph>.</variable></paragraph> + +<paragraph role="paragraph" id="par_id281631903136031"><variable id="edit_comment">Choose <menuitem>Sheet - Cell Comments - Edit Comment</menuitem></variable></paragraph> +<paragraph role="paragraph" id="par_id641631903140705"><variable id="hide_comment">Choose <menuitem>Sheet - Cell Comments - Hide Comment</menuitem></variable></paragraph> +<paragraph role="paragraph" id="par_id611631903144777"><variable id="show_comment">Choose <menuitem>Sheet - Cell Comments - Show Comment</menuitem></variable></paragraph> +<paragraph role="paragraph" id="par_id961631903149304"><variable id="delete_comment">Choose <menuitem>Sheet - Cell Comments - Delete Comment</menuitem></variable></paragraph> +<paragraph role="paragraph" id="par_id471631903160977"><variable id="delete_all_comments">Choose <menuitem>Sheet - Cell Comments - Delete All Comments</menuitem></variable></paragraph> +</body> +</helpdocument> |