diff options
Diffstat (limited to 'source/text/scalc/00')
| -rw-r--r-- | source/text/scalc/00/00000004.xhp | 52 | ||||
| -rw-r--r-- | source/text/scalc/00/00000402.xhp | 70 | ||||
| -rw-r--r-- | source/text/scalc/00/00000403.xhp | 49 | ||||
| -rw-r--r-- | source/text/scalc/00/00000404.xhp | 203 | ||||
| -rw-r--r-- | source/text/scalc/00/00000405.xhp | 118 | ||||
| -rw-r--r-- | source/text/scalc/00/00000406.xhp | 100 | ||||
| -rw-r--r-- | source/text/scalc/00/00000407.xhp | 47 | ||||
| -rw-r--r-- | source/text/scalc/00/00000412.xhp | 218 | ||||
| -rw-r--r-- | source/text/scalc/00/makefile.mk | 59 |
9 files changed, 916 insertions, 0 deletions
diff --git a/source/text/scalc/00/00000004.xhp b/source/text/scalc/00/00000004.xhp new file mode 100644 index 0000000000..9dfc242af6 --- /dev/null +++ b/source/text/scalc/00/00000004.xhp @@ -0,0 +1,52 @@ +<?xml version="1.0" encoding="UTF-8"?> + + + +<!-- + *********************************************************************** + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************ + --> + + + <helpdocument version="1.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" l10n="U" oldref="1"><variable id="wie">To access this function... +</variable></paragraph> +<paragraph role="paragraph" id="par_idN1056E" xml-lang="en-US" l10n="NEW"><variable id="moreontop">More explanations on top of this page. +</variable></paragraph> +<paragraph role="note" id="par_idN105AF" xml-lang="en-US" l10n="NEW"><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" l10n="NEW"><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/source/text/scalc/00/00000402.xhp b/source/text/scalc/00/00000402.xhp new file mode 100644 index 0000000000..e60d4e1a6c --- /dev/null +++ b/source/text/scalc/00/00000402.xhp @@ -0,0 +1,70 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!--*********************************************************************** + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************--><helpdocument version="1.0"> +<meta> +<topic id="textscalc0000000402xml" indexer="exclude" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Edit Menu</title> +<filename>/text/scalc/00/00000402.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +</history> +</meta> +<body> + + + <paragraph role="heading" level="1" id="hd_id3147303" l10n="U" xml-lang="en-US" oldref="1">Edit Menu</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3155555" xml-lang="en-US" oldref="2"><variable id="kopffuss">Choose <emph>Edit - Headers & Footers</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3159233" xml-lang="en-US" oldref="3"><variable id="bkopfzeile">Choose <emph>Edit - Headers & Footers - Header/Footer</emph> tabs</variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3150443" xml-lang="en-US" oldref="4"><variable id="bausfullen">Choose <emph>Edit - Fill</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3143267" xml-lang="en-US" oldref="5"><variable id="bausunten">Choose <emph>Edit - Fill - Down</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3153880" xml-lang="en-US" oldref="6"><variable id="bausrechts">Choose <emph>Edit - Fill - Right</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3151245" xml-lang="en-US" oldref="7"><variable id="bausoben">Choose <emph>Edit - Fill - Up</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3145068" xml-lang="en-US" oldref="8"><variable id="bauslinks">Choose <emph>Edit - Fill - Left</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3150400" xml-lang="en-US" oldref="9"><variable id="baustab">Choose <emph>Edit - Fill - Sheet</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3154910" xml-lang="en-US" oldref="10"><variable id="bausreihe">Choose <emph>Edit - Fill - Series</emph></variable></paragraph> + <section id="binhalt"> + <paragraph l10n="U" role="paragraph" id="par_id3154123" xml-lang="en-US" oldref="11">Choose <emph>Edit - Delete Contents</emph></paragraph> + <paragraph role="paragraph" id="par_id3145785" l10n="U" xml-lang="en-US" oldref="20">Backspace</paragraph> + </section> + <paragraph l10n="U" role="paragraph" id="par_id3150011" xml-lang="en-US" oldref="12"><variable id="bzelo">Choose <emph>Edit - Delete Cells</emph></variable></paragraph> + <section id="btaloes"> + <paragraph l10n="U" role="paragraph" id="par_id3153951" xml-lang="en-US" oldref="13">Choose <emph>Edit – Sheet - Delete</emph></paragraph> + <paragraph role="paragraph" id="par_id3155306" l10n="U" xml-lang="en-US" oldref="18">Open context menu for a sheet tab</paragraph> + </section> + <section id="btaverko"> + <paragraph l10n="U" role="paragraph" id="par_id3146119" xml-lang="en-US" oldref="14">Choose <emph>Edit – Sheets – Move/Copy</emph></paragraph> + <paragraph role="paragraph" id="par_id3148645" l10n="U" xml-lang="en-US" oldref="19">Open context menu for a sheet tab</paragraph> + </section> + <paragraph l10n="U" role="paragraph" id="par_id3153093" xml-lang="en-US" oldref="15"><variable id="bmaumloe">Choose <emph>Edit - Delete Manual Break</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3153191" xml-lang="en-US" oldref="16"><variable id="bzeilum">Choose <emph>Edit - Delete Manual Break - Row Break</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3145645" xml-lang="en-US" oldref="17"><variable id="bspaum">Choose <emph>Edit - Delete Manual Break - Column Break</emph></variable></paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/00/00000403.xhp b/source/text/scalc/00/00000403.xhp new file mode 100644 index 0000000000..2fc66f406a --- /dev/null +++ b/source/text/scalc/00/00000403.xhp @@ -0,0 +1,49 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!--*********************************************************************** + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************--><helpdocument version="1.0"> +<meta> +<topic id="textscalc0000000403xml" indexer="exclude" status="PUBLISH"> +<title xml-lang="en-US" id="tit">View Menu</title> +<filename>/text/scalc/00/00000403.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +</history> +</meta> +<body> + + + <paragraph role="heading" level="1" id="hd_id3145673" l10n="U" xml-lang="en-US" oldref="1">View Menu</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3150275" xml-lang="en-US" oldref="2"><variable id="aspze">Choose <emph>View - Column & Row Headers</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3154514" xml-lang="en-US" oldref="3"><variable id="awehe">Choose <emph>View - Value Highlighting</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3148947" xml-lang="en-US" oldref="4"><variable id="rechenleiste">Choose <emph>View - Toolbars - Formula Bar</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3148663" xml-lang="en-US" oldref="5"><variable id="seumvo">Choose <emph>View - Page Break Preview</emph></variable></paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/00/00000404.xhp b/source/text/scalc/00/00000404.xhp new file mode 100644 index 0000000000..7a6837274d --- /dev/null +++ b/source/text/scalc/00/00000404.xhp @@ -0,0 +1,203 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!--*********************************************************************** + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************--> + + + +<helpdocument version="1.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> +<lastedited date="2005-11-10T14:06:38">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<paragraph role="heading" id="hd_id3149346" xml-lang="en-US" level="1" l10n="U" oldref="1">Insert Menu</paragraph> +<paragraph role="paragraph" id="par_id3149095" xml-lang="en-US" l10n="U" oldref="36"><variable id="eimaum">Choose <emph>Insert - Manual Break</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3149398" xml-lang="en-US" l10n="U" oldref="2"><variable id="eimaumze">Choose <emph>Insert - Manual Break - Row Break</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3150084" xml-lang="en-US" l10n="U" oldref="3"><variable id="eimaumsp">Choose <emph>Insert - Manual Break - Column Break</emph> +</variable></paragraph> +<section id="eize"> +<paragraph role="paragraph" id="par_id3149784" xml-lang="en-US" l10n="U" oldref="4">Choose <emph>Insert - Cells</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US" l10n="U" oldref="5">Open <emph>Insert Cells</emph> toolbar from Tools bar:</paragraph> +<section id="syzelleneinfuegen"> +<table id="tbl_id3148550"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US" l10n="E"> +<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 colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3151041" xml-lang="en-US" l10n="U" oldref="6">Insert Cells</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</section> +<section id="syzellenunten"> +<table id="tbl_id3159486"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US" l10n="E"> +<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 colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3146985" xml-lang="en-US" l10n="U" oldref="7">Insert Cells Down</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +<section id="syzellenrechts"> +<table id="tbl_id3148575"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3144766" xml-lang="en-US" l10n="E"> +<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 colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3145646" xml-lang="en-US" l10n="U" oldref="8">Insert Cells Right</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +<section id="syzeilenganze"> +<table id="tbl_id3154015"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3153838" xml-lang="en-US" l10n="E"> +<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 colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3150324" xml-lang="en-US" l10n="U" oldref="9">Insert Rows</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +<section id="syspaltenganze"> +<table id="tbl_id3147338"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3147363" xml-lang="en-US" l10n="E"> +<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 colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3155334" xml-lang="en-US" l10n="U" oldref="10">Insert Columns</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US" l10n="U" oldref="11"><variable id="eizei">Choose <emph>Insert - Rows</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3153200" xml-lang="en-US" l10n="U" oldref="12"><variable id="eispa">Choose <emph>Insert - Columns</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3149033" xml-lang="en-US" l10n="U" oldref="13"><variable id="eitab">Choose <emph>Insert - Sheet</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_idN1082F" xml-lang="en-US" l10n="NEW"><variable id="eitabfile">Choose <emph>Insert - Sheet from file</emph> +</variable></paragraph> +<section id="eifu"> +<paragraph role="paragraph" id="par_id3155115" xml-lang="en-US" l10n="U" oldref="14">Choose <emph>Insert - Function</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3152582" xml-lang="en-US" l10n="U" oldref="34"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph> +<paragraph role="paragraph" id="par_id3153269" xml-lang="en-US" l10n="U" oldref="15">On <emph>Formula Bar</emph>, click</paragraph> +<section id="syfunktionsautopilot"> +<table id="tbl_id3145258"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3150515" xml-lang="en-US" l10n="E"> +<image id="img_id3150884" src="sw/imglst/sc20556.png" width="0.222inch" height="0.222inch"><alt id="alt_id3150884" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US" l10n="CHG" oldref="16">Function Wizard</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</section> +<paragraph role="paragraph" id="par_id3156288" xml-lang="en-US" l10n="CHG" oldref="17"><variable id="eikada"><emph>Insert - Function</emph> - Category <emph>Database</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US" l10n="CHG" oldref="18"><variable id="eikadaze"><emph>Insert - Function</emph> - Category <emph>Date&Time</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3151334" xml-lang="en-US" l10n="CHG" oldref="19"><variable id="eikafi"><emph>Insert - Function</emph> - Category <emph>Financial</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3159222" xml-lang="en-US" l10n="CHG" oldref="20"><variable id="eikain"><emph>Insert - Function</emph> - Category <emph>Information</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3159173" xml-lang="en-US" l10n="CHG" oldref="21"><variable id="eikalo"><emph>Insert - Function</emph> - Category <emph>Logical</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3153914" xml-lang="en-US" l10n="CHG" oldref="22"><variable id="eikama"><emph>Insert - Function</emph> - Category <emph>Mathematical</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3150109" xml-lang="en-US" l10n="CHG" oldref="23"><variable id="eikamatrix"><emph>Insert - Function</emph> - Category <emph>Array</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3157978" xml-lang="en-US" l10n="CHG" oldref="24"><variable id="eikasta"><emph>Insert - Function</emph> - Category <emph>Statistical</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3156016" xml-lang="en-US" l10n="CHG" oldref="25"><variable id="eikatext"><emph>Insert - Function</emph> - Category <emph>Text</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3147075" xml-lang="en-US" l10n="U" oldref="26"><variable id="efefft"><emph>Insert - Function</emph> - Category <emph>Spreadsheet</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US" l10n="CHG" oldref="27"><variable id="addin"><emph>Insert - Function</emph> - Category <emph>Add-In</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3154059" xml-lang="en-US" l10n="CHG" oldref="38"><variable id="addinana"><emph>Insert - Function</emph> - Category <emph>Add-In</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3155383" xml-lang="en-US" l10n="U" oldref="33"><variable id="funktionsliste">Choose <emph>Insert - Function List</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3153250" xml-lang="en-US" l10n="U" oldref="28"><variable id="einamen">Choose <emph>Insert - Names</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3146776" xml-lang="en-US" l10n="CHG" oldref="37"><variable id="eiextdata">Choose <emph>Insert - Link to External data</emph> +</variable></paragraph> +<section id="einafe"> +<paragraph role="paragraph" id="par_id3143222" xml-lang="en-US" l10n="U" oldref="29">Choose <emph>Insert - Names - Define</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3149385" xml-lang="en-US" l10n="U" oldref="35"><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" l10n="U" oldref="30"><variable id="einaei">Choose <emph>Insert - Names - Insert</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3153558" xml-lang="en-US" l10n="U" oldref="31"><variable id="einaueb">Choose <emph>Insert - Names - Create</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3153483" xml-lang="en-US" l10n="U" oldref="32"><variable id="einabesch">Choose <emph>Insert - Names - Labels</emph> +</variable></paragraph> +</body> +</helpdocument> diff --git a/source/text/scalc/00/00000405.xhp b/source/text/scalc/00/00000405.xhp new file mode 100644 index 0000000000..a830371df3 --- /dev/null +++ b/source/text/scalc/00/00000405.xhp @@ -0,0 +1,118 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!-- + *********************************************************************** + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************ + --> + +<helpdocument version="1.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> +<lastedited date="2006-02-20T11:43:16">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<paragraph role="heading" id="hd_id3150769" xml-lang="en-US" level="1" l10n="U" oldref="1">Format Menu</paragraph> +<paragraph role="paragraph" id="par_id3154685" xml-lang="en-US" l10n="U" oldref="2"><variable id="fozelle">Choose <emph>Format - Cells</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3153194" xml-lang="en-US" l10n="U" oldref="3"><variable id="fozelstz">Choose <emph>Format - Cells - Cell Protection</emph> tab +</variable></paragraph> +<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US" l10n="U" oldref="4"><variable id="fozei">Choose <emph>Format - Row</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3150012" xml-lang="en-US" l10n="U" oldref="5"><variable id="fozeiophoe">Choose <emph>Format - Row - Optimal Height</emph> +</variable></paragraph> +<section id="fozeiaus"> +<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US" l10n="U" oldref="6">Choose <emph>Format - Row - Hide</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3153728" xml-lang="en-US" l10n="U" oldref="7">Choose <emph>Format - Column - Hide</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US" l10n="U" oldref="8">Choose <emph>Format - Sheet - Hide</emph> +</paragraph> +</section> +<section id="fozeiebl"> +<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US" l10n="U" oldref="9">Choose <emph>Format - Row - Show</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3156286" xml-lang="en-US" l10n="U" oldref="10">Choose <emph>Format - Column - Show</emph> +</paragraph> +</section> +<paragraph role="paragraph" id="par_id3145645" xml-lang="en-US" l10n="U" oldref="11"><variable id="fospa">Choose <emph>Format - Column</emph> +</variable></paragraph> +<section id="fospob"> +<paragraph role="paragraph" id="par_id3145252" xml-lang="en-US" l10n="U" oldref="12">Choose <emph>Format - Column - Optimal Width</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3146971" xml-lang="en-US" l10n="U" oldref="36">Double-click right column separator in column headers</paragraph> +</section> +<paragraph role="paragraph" id="par_id3147362" xml-lang="en-US" l10n="U" oldref="15"><variable id="fot">Choose <emph>Format - Sheet</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3163805" xml-lang="en-US" l10n="U" oldref="16"><variable id="fotu">Choose <emph>Format - Sheet - Rename</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3155333" xml-lang="en-US" l10n="U" oldref="17"><variable id="fotenb">Choose <emph>Format - Sheet - Show</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_idN1077A" xml-lang="en-US" l10n="NEW"><variable id="foste">Choose <emph>Format - Page</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3155508" xml-lang="en-US" l10n="U" oldref="25"><variable id="fostel">Choose <emph>Format - Page - Sheet</emph> tab +</variable></paragraph> +<paragraph role="paragraph" id="par_id3150883" xml-lang="en-US" l10n="U" oldref="26"><variable id="fodrbe">Choose <emph>Format - Print Ranges</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US" l10n="U" oldref="27"><variable id="fodrfe">Choose <emph>Format - Print Ranges - Define</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3156290" xml-lang="en-US" l10n="U" oldref="35"><variable id="fodrhin">Choose <emph>Format - Print Ranges - Add</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3155812" xml-lang="en-US" l10n="U" oldref="28"><variable id="fodbah">Choose <emph>Format - Print Ranges - Remove</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3153307" xml-lang="en-US" l10n="U" oldref="29"><variable id="fodbbe">Choose <emph>Format - Print Ranges - Edit</emph> +</variable></paragraph> +<section id="foatfo"> +<paragraph role="paragraph" id="par_id3153916" xml-lang="en-US" l10n="U" oldref="31">Choose <emph>Format - AutoFormat</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3154532" xml-lang="en-US" l10n="CHG" oldref="32">On the Tools bar, click</paragraph> +<section id="syautoformat"> +<table id="tbl_id3148605"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3149332" xml-lang="en-US" l10n="E"> +<image id="img_id3156020" src="cmd/sc_autoformat.png" width="0.222inch" height="0.222inch"><alt id="alt_id3156020" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3154060" xml-lang="en-US" l10n="U" oldref="33">AutoFormat</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</section> +<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US" l10n="U" oldref="34"><variable id="bedingte">Choose <emph>Format - Conditional Formatting</emph> +</variable></paragraph> +</body> +</helpdocument> diff --git a/source/text/scalc/00/00000406.xhp b/source/text/scalc/00/00000406.xhp new file mode 100644 index 0000000000..8796b4245c --- /dev/null +++ b/source/text/scalc/00/00000406.xhp @@ -0,0 +1,100 @@ +<?xml version="1.0" encoding="UTF-8"?> + + + +<!-- + *********************************************************************** + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************ + --> + + + <helpdocument version="1.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> +<paragraph role="heading" id="hd_id3147264" xml-lang="en-US" level="1" l10n="U" oldref="1">Tools Menu</paragraph> +<paragraph role="paragraph" id="par_id3150541" xml-lang="en-US" l10n="U" oldref="2"><variable id="exdektv">Choose <emph>Tools - Detective</emph> +</variable></paragraph> +<section id="exdszv"> +<paragraph role="paragraph" id="par_id3153194" xml-lang="en-US" l10n="U" oldref="3">Choose <emph>Tools - Detective - Trace Precedents</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3150447" xml-lang="en-US" l10n="U" oldref="29">Shift+F7</paragraph> +</section> +<paragraph role="paragraph" id="par_id3154123" xml-lang="en-US" l10n="CHG" oldref="33"><variable id="silbentrennungc">Menu <emph>Tools - Language - Hyphenation</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3145785" xml-lang="en-US" l10n="U" oldref="4"><variable id="exdvore">Choose <emph>Tools - Detective - Remove Precedents</emph> +</variable></paragraph> +<section id="exdsznf"> +<paragraph role="paragraph" id="par_id3155411" xml-lang="en-US" l10n="U" oldref="5">Choose <emph>Tools - Detective - Trace Dependents</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3153363" xml-lang="en-US" l10n="U" oldref="30">Shift+F5</paragraph> +</section> +<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US" l10n="U" oldref="6"><variable id="exdszne">Choose <emph>Tools - Detective - Remove Dependents</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3154014" xml-lang="en-US" l10n="U" oldref="7"><variable id="exdase">Choose <emph>Tools - Detective - Remove All Traces</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3153188" xml-lang="en-US" l10n="U" oldref="8"><variable id="exdszfe">Choose <emph>Tools - Detective - Trace Error</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3149410" xml-lang="en-US" l10n="U" oldref="9"><variable id="fuellmodus">Choose <emph>Tools - Detective - Fill Mode</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3156284" xml-lang="en-US" l10n="U" oldref="10"><variable id="dateneinkreisen">Choose <emph>Tools - Detective - Mark Invalid Data</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3153159" xml-lang="en-US" l10n="U" oldref="11"><variable id="spurenaktualisieren">Choose <emph>Tools - Detective - Refresh Traces</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3147397" xml-lang="en-US" l10n="U" oldref="32"><variable id="automatisch">Choose <emph>Tools - Detective - AutoRefresh</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3154018" xml-lang="en-US" l10n="U" oldref="12"><variable id="exzws">Choose <emph>Tools - Goal Seek</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3269142" xml-lang="en-US" l10n="NEW"><variable id="solver">Choose Tools - Solver +</variable></paragraph> +<paragraph role="paragraph" id="par_id8554338" xml-lang="en-US" l10n="NEW"><variable id="solver_options">Choose Tools - Solver, Options button +</variable></paragraph> +<paragraph role="paragraph" id="par_id3156277" xml-lang="en-US" l10n="U" oldref="13"><variable id="exsze">Choose <emph>Tools - Scenarios</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3145640" xml-lang="en-US" l10n="U" oldref="14"><variable id="exdos">Choose <emph>Tools - Protect Document</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3149020" xml-lang="en-US" l10n="U" oldref="15"><variable id="exdst">Choose <emph>Tools - Protect Document - Sheet</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3154256" xml-lang="en-US" l10n="U" oldref="16"><variable id="exdsd">Choose <emph>Tools - Protect Document - Document</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3147363" xml-lang="en-US" l10n="U" oldref="17"><variable id="zellinhalte">Choose <emph>Tools - Cell Contents</emph> +</variable></paragraph> +<section id="exnb"> +<paragraph role="paragraph" id="par_id3146919" xml-lang="en-US" l10n="U" oldref="18">Choose <emph>Tools - Cell Contents - Recalculate</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3149257" xml-lang="en-US" l10n="U" oldref="31">F9</paragraph> +</section> +<paragraph role="paragraph" id="par_id3150941" xml-lang="en-US" l10n="U" oldref="19"><variable id="exatmb">Choose <emph>Tools - Cell Contents - AutoCalculate</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3151276" xml-lang="en-US" l10n="U" oldref="20"><variable id="autoeingabe">Choose <emph>Tools - Cell Contents - AutoInput</emph> +</variable></paragraph> +</body> +</helpdocument> diff --git a/source/text/scalc/00/00000407.xhp b/source/text/scalc/00/00000407.xhp new file mode 100644 index 0000000000..f36bbdccd7 --- /dev/null +++ b/source/text/scalc/00/00000407.xhp @@ -0,0 +1,47 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!--*********************************************************************** + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************--><helpdocument version="1.0"> +<meta> +<topic id="textscalc0000000407xml" indexer="exclude" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Window Menu</title> +<filename>/text/scalc/00/00000407.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +</history> +</meta> +<body> + + + <paragraph role="heading" level="1" id="hd_id3155628" l10n="U" xml-lang="en-US" oldref="1">Window Menu</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3147335" xml-lang="en-US" oldref="2"><variable id="fete">Choose <emph>Window - Split</emph></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3153663" xml-lang="en-US" oldref="3"><variable id="fefix">Choose <emph>Window - Freeze</emph></variable></paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/00/00000412.xhp b/source/text/scalc/00/00000412.xhp new file mode 100644 index 0000000000..78cceb5d21 --- /dev/null +++ b/source/text/scalc/00/00000412.xhp @@ -0,0 +1,218 @@ +<?xml version="1.0" encoding="UTF-8"?> + + + +<!-- + *********************************************************************** + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2011 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************ + --> + + + <helpdocument version="1.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> +<paragraph role="heading" id="hd_id3145136" xml-lang="en-US" level="1" l10n="U" oldref="1">Data Menu</paragraph> +<paragraph role="paragraph" id="par_id8366954" xml-lang="en-US" l10n="NEW"><variable id="text2columns">Choose <emph>Data - Text to Columns</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3147399" xml-lang="en-US" l10n="U" oldref="3"><variable id="dbrbf">Choose <emph>Data - Define Range</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3145345" xml-lang="en-US" l10n="U" oldref="4"><variable id="dbrba">Choose <emph>Data - Select Range</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3150443" xml-lang="en-US" l10n="U" oldref="5"><variable id="dnsrt">Choose <emph>Data - Sort</emph> +</variable></paragraph> +<section id="dnsosk"> +<paragraph role="paragraph" id="par_id3148491" xml-lang="en-US" l10n="U" oldref="6">Choose <emph>Data - Sort - Sort Criteria</emph> tab</paragraph> +<paragraph role="paragraph" id="par_id3154516" xml-lang="en-US" l10n="CHG" oldref="7">On Standard bar, click</paragraph> +<section id="sysortieren"> +<table id="tbl_id3156023"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3148663" xml-lang="en-US" l10n="E"> +<image id="img_id3150543" src="cmd/sc_sortup.png" width="0.1665inch" height="0.1665inch"><alt id="alt_id3150543" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US" l10n="U" oldref="8">Sort Ascending</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="E"> +<image id="img_id3125863" src="cmd/sc_sortdown.png" width="0.1701inch" height="0.1701inch"><alt id="alt_id3125863" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3145364" xml-lang="en-US" l10n="U" oldref="9">Sort Descending</paragraph> +</tablecell> +</tablerow> +</table> +</section> +</section> +<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US" l10n="U" oldref="10"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab +</variable></paragraph> +<paragraph role="paragraph" id="par_id3155308" xml-lang="en-US" l10n="U" oldref="11"><variable id="dnftr">Choose <emph>Data - Filter</emph> +</variable></paragraph> +<section id="dnfiafi"> +<paragraph role="paragraph" id="par_id3148646" xml-lang="en-US" l10n="U" oldref="12">Choose <emph>Data - Filter - AutoFilter</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3151113" xml-lang="en-US" l10n="CHG" oldref="13">On Tools bar or Table Data bar, click</paragraph> +<section id="syautofilter"> +<table id="tbl_id3155418"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US" l10n="E"> +<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 colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3149401" xml-lang="en-US" l10n="U" oldref="14">AutoFilter</paragraph> +</tablecell> +</tablerow> +</table> +</section> +</section> +<paragraph role="paragraph" id="par_id3156278" xml-lang="en-US" l10n="U" oldref="17"><variable id="dnfspz">Choose <emph>Data - Filter - Advanced Filter</emph> +</variable></paragraph> +<section id="filterzus"> +<paragraph role="paragraph" id="par_id3153764" xml-lang="en-US" l10n="U" oldref="18">Choose <emph>Data - Filter - Standard Filter - More>></emph> button</paragraph> +<paragraph role="paragraph" id="par_id3155444" xml-lang="en-US" l10n="U" oldref="19">Choose <emph>Data - Filter - Advanced Filter - More>></emph> button</paragraph> +</section> +<section id="dnfief"> +<paragraph role="paragraph" id="par_id3156382" xml-lang="en-US" l10n="U" oldref="20">Choose <emph>Data - Filter - Remove Filter</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3155961" xml-lang="en-US" l10n="CHG" oldref="48">On Table Data bar, click <emph>Remove Filter/Sort</emph> +</paragraph> +<table id="tbl_id3146919"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US" l10n="E"> +<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 colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3149207" xml-lang="en-US" l10n="U" oldref="49">Remove Filter/Sort</paragraph> +</tablecell> +</tablerow> +</table> +</section> +<paragraph role="paragraph" id="par_id3152778" xml-lang="en-US" l10n="U" oldref="21"><variable id="dnaftas">Choose <emph>Data - Filter - Hide AutoFilter</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3166424" xml-lang="en-US" l10n="U" oldref="22"><variable id="dntegs">Choose <emph>Data - Subtotals</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3154574" xml-lang="en-US" l10n="U" oldref="23"><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" l10n="U" oldref="24"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab +</variable></paragraph> +<paragraph role="paragraph" id="par_id3145133" xml-lang="en-US" l10n="U" oldref="25"><variable id="datengueltig">Choose <emph>Data - Validity</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3152992" xml-lang="en-US" l10n="U" oldref="26"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab +</variable></paragraph> +<paragraph role="paragraph" id="par_id3150367" xml-lang="en-US" l10n="U" oldref="27"><variable id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph> tab +</variable></paragraph> +<paragraph role="paragraph" id="par_id3154486" xml-lang="en-US" l10n="U" oldref="28"><variable id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph> tab +</variable></paragraph> +<paragraph role="paragraph" id="par_id3146978" xml-lang="en-US" l10n="U" oldref="29"><variable id="dnmfo">Choose <emph>Data - Multiple Operations</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US" l10n="U" oldref="30"><variable id="dnksd">Choose <emph>Data - Consolidate</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3148701" xml-lang="en-US" l10n="CHG" oldref="31"><variable id="dngld">Choose <emph>Data - Group and Outline</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3153815" xml-lang="en-US" l10n="U" oldref="32"><variable id="dngda">Choose <emph>Data - Group and Outline - Hide Details</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3159223" xml-lang="en-US" l10n="U" oldref="33"><variable id="dngde">Choose <emph>Data - Group and Outline - Show Details</emph> +</variable></paragraph> +<section id="dnglgr"> +<paragraph role="paragraph" id="par_id3146870" xml-lang="en-US" l10n="U" oldref="34">Choose <emph>Data - Group and Outline - Group</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3144507" xml-lang="en-US" l10n="U" oldref="51">F12</paragraph> +<paragraph role="paragraph" id="par_id3144772" xml-lang="en-US" l10n="CHG" oldref="35">On <emph>Tools</emph> bar, click</paragraph> +<section id="sygruppieren"> +<table id="tbl_id3154532"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3149438" xml-lang="en-US" l10n="E"> +<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 colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="CHG" oldref="36">Group</paragraph> +</tablecell> +</tablerow> +</table> +</section> +</section> +<section id="dnglgra"> +<paragraph role="paragraph" id="par_id3146781" xml-lang="en-US" l10n="U" oldref="37">Choose <emph>Data - Group and Outline - Ungroup</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3150892" xml-lang="en-US" l10n="U" oldref="52"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph> +<paragraph role="paragraph" id="par_id3155097" xml-lang="en-US" l10n="CHG" oldref="38">On <emph>Tools</emph> bar, click</paragraph> +<section id="sygruppierungaufheben"> +<table id="tbl_id3143223"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3150048" xml-lang="en-US" l10n="E"> +<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 colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3153555" xml-lang="en-US" l10n="U" oldref="39">Ungroup</paragraph> +</tablecell> +</tablerow> +</table> +</section> +</section> +<paragraph role="paragraph" id="par_id3153008" xml-lang="en-US" l10n="U" oldref="40"><variable id="dnglagl">Choose <emph>Data - Group and Outline - AutoOutline</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3154709" xml-lang="en-US" l10n="U" oldref="41"><variable id="dnglef">Choose <emph>Data - Group and Outline - Remove</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id1774346" xml-lang="en-US" l10n="CHG"><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" l10n="CHG" oldref="42"><variable id="dndtpt">Choose <emph>Data - Pivot Table</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3154625" xml-lang="en-US" l10n="CHG" oldref="43"><variable id="dndpa">Choose <emph>Data - Pivot Table - Create</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3147558" xml-lang="en-US" l10n="CHG" oldref="53"><variable id="dndq">Choose <emph>Data - Pivot Table - Create</emph>, in the Select Source dialog choose the option <emph>Data source registered in $[officename]</emph>. +</variable></paragraph> +<section id="dndpaz"> +<paragraph role="paragraph" id="par_id3153297" xml-lang="en-US" l10n="CHG" oldref="50">Choose <emph>Data - Pivot Table - Create</emph>, in the Select Source dialog choose the option <emph>Current selection</emph>.</paragraph> +<paragraph role="paragraph" id="par_id3145118" xml-lang="en-US" l10n="CHG" oldref="54">Choose <emph>Data - Pivot Table - Create</emph>, in the Select Source 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" l10n="CHG" oldref="44"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3151344" xml-lang="en-US" l10n="CHG" oldref="45"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_id3150397" xml-lang="en-US" l10n="U" oldref="46"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph> +</variable></paragraph> +<paragraph role="paragraph" id="par_idN10B8F" xml-lang="en-US" l10n="CHG"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph> +</variable></paragraph> +</body> +</helpdocument> diff --git a/source/text/scalc/00/makefile.mk b/source/text/scalc/00/makefile.mk new file mode 100644 index 0000000000..cb08d8fd97 --- /dev/null +++ b/source/text/scalc/00/makefile.mk @@ -0,0 +1,59 @@ +#************************************************************************* +# +# DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. +# +# Copyright 2000, 2010 Oracle and/or its affiliates. +# +# OpenOffice.org - a multi-platform office productivity suite +# +# This file is part of OpenOffice.org. +# +# OpenOffice.org is free software: you can redistribute it and/or modify +# it under the terms of the GNU Lesser General Public License version 3 +# only, as published by the Free Software Foundation. +# +# OpenOffice.org is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU Lesser General Public License version 3 for more details +# (a copy is included in the LICENSE file that accompanied this code). +# +# You should have received a copy of the GNU Lesser General Public License +# version 3 along with OpenOffice.org. If not, see +# <http://www.openoffice.org/license.html> +# for a copy of the LGPLv3 License. +# +#************************************************************************* + +# edit to match directory level +PRJ = ..$/..$/..$/.. +# same for all makefiles in "helpcontent2" +PRJNAME = helpcontent2 +# edit to match the current package +PACKAGE = text/scalc/00 +# uniqe name (module wide); +# using a modified form of package should do here +TARGET = text_scalc_00 +# edit to match the current module +MODULE = scalc + +# --- Settings ----------------------------------------------------- + +.INCLUDE : settings.mk +.INCLUDE : $(PRJ)$/settings.pmk + +# this list matches the *.xhp files to process +XHPFILES = \ + 00000004.xhp \ + 00000402.xhp \ + 00000403.xhp \ + 00000404.xhp \ + 00000405.xhp \ + 00000406.xhp \ + 00000407.xhp \ + 00000412.xhp + +# --- Targets ------------------------------------------------------ + +.INCLUDE : target.mk +.INCLUDE : tg_help.mk |