diff options
Diffstat (limited to 'source/text/scalc/02')
| -rw-r--r-- | source/text/scalc/02/02130000.xhp | 68 | ||||
| -rw-r--r-- | source/text/scalc/02/02140000.xhp | 74 | ||||
| -rw-r--r-- | source/text/scalc/02/02150000.xhp | 68 | ||||
| -rw-r--r-- | source/text/scalc/02/02160000.xhp | 67 | ||||
| -rw-r--r-- | source/text/scalc/02/02170000.xhp | 67 | ||||
| -rw-r--r-- | source/text/scalc/02/06010000.xhp | 72 | ||||
| -rw-r--r-- | source/text/scalc/02/06030000.xhp | 69 | ||||
| -rw-r--r-- | source/text/scalc/02/06040000.xhp | 64 | ||||
| -rw-r--r-- | source/text/scalc/02/06050000.xhp | 50 | ||||
| -rw-r--r-- | source/text/scalc/02/06060000.xhp | 67 | ||||
| -rw-r--r-- | source/text/scalc/02/06070000.xhp | 67 | ||||
| -rw-r--r-- | source/text/scalc/02/06080000.xhp | 67 | ||||
| -rw-r--r-- | source/text/scalc/02/08010000.xhp | 52 | ||||
| -rw-r--r-- | source/text/scalc/02/08080000.xhp | 65 | ||||
| -rw-r--r-- | source/text/scalc/02/10050000.xhp | 72 | ||||
| -rw-r--r-- | source/text/scalc/02/10060000.xhp | 71 | ||||
| -rw-r--r-- | source/text/scalc/02/18010000.xhp | 86 | ||||
| -rw-r--r-- | source/text/scalc/02/18020000.xhp | 67 | ||||
| -rw-r--r-- | source/text/scalc/02/makefile.mk | 69 |
19 files changed, 1282 insertions, 0 deletions
diff --git a/source/text/scalc/02/02130000.xhp b/source/text/scalc/02/02130000.xhp new file mode 100644 index 0000000000..c8ba0e12ff --- /dev/null +++ b/source/text/scalc/02/02130000.xhp @@ -0,0 +1,68 @@ +<?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="textscalc0202130000xml" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Number format: Currency</title> +<filename>/text/scalc/02/02130000.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> + + + <section id="waehrung"> + <bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatCurrency" id="bm_id9668852" localize="false"/><!-- HID added by script --> +<bookmark branch="hid/.uno:NumberFormatCurrency" xml-lang="en-US" id="bm_id3148701"/><paragraph id="hd_id3152892" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/02/02130000.xhp" name="Number format: Currency">Number format: Currency</link></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3148837" xml-lang="en-US" oldref="2"><ahelp hid=".uno:NumberFormatCurrency" visibility="visible">Applies the default currency format to the selected cells.</ahelp></paragraph> + </section> + <section id="sywaehrung"> + <table id="tbl_id3153915"> + + + + <tablerow> + <tablecell> + <paragraph l10n="E" role="paragraph" id="par_id3155267" xml-lang="en-US" oldref=""><image src="cmd/sc_currencyfield.png" id="img_id3159096"><alt xml-lang="en-US" id="alt_id3159096">Icon</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3150214" l10n="U" xml-lang="en-US" oldref="3">Number Format: Currency</paragraph> + </tablecell> + </tablerow> + + </table> + </section> + <section id="relatedtopics"> + <paragraph l10n="U" role="paragraph" id="par_id3146776" xml-lang="en-US" oldref="4"><link href="text/shared/01/05020300.xhp" name="Format - Cell - Numbers">Format - Cell - Numbers</link>.</paragraph> + </section> + </body> +</helpdocument> diff --git a/source/text/scalc/02/02140000.xhp b/source/text/scalc/02/02140000.xhp new file mode 100644 index 0000000000..d1164d563e --- /dev/null +++ b/source/text/scalc/02/02140000.xhp @@ -0,0 +1,74 @@ +<?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="textscalc0202140000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Number format: Percent</title> +<filename>/text/scalc/02/02140000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2004-08-16T11:38:54">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<section id="prozent"> +<bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatPercent" id="bm_id6598479" localize="false"/><!-- HID added by script --> +<bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatPercent" id="bm_id3153541" localize="false"/> +<paragraph role="heading" id="hd_id3156329" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/02140000.xhp" name="Number format: Percent">Number format: Percent</link></paragraph> +<paragraph role="paragraph" id="par_id3155629" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:NumberFormatPercent">Applies the percentage format to the selected cells.</ahelp></paragraph> +</section> +<section id="syprozent"> +<table id="tbl_id3154758"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3153968" xml-lang="en-US" l10n="E"> +<image id="img_id3150869" src="cmd/sc_numberformatpercent.png" width="5.64mm" height="5.64mm"><alt id="alt_id3150869" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US" l10n="U" oldref="3">Number Format: Percent</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +<bookmark xml-lang="en-US" branch="index" id="bm_id3149260"><bookmark_value>percentage calculations</bookmark_value> +</bookmark> +<paragraph role="paragraph" id="par_id3149260" xml-lang="en-US" l10n="U" oldref="5">You can also enter a percentage sign (%) after a number in a cell:</paragraph> +<paragraph role="paragraph" id="par_id3155411" xml-lang="en-US" l10n="U" oldref="6">1% corresponds to 0.01</paragraph> +<paragraph role="paragraph" id="par_id3145749" xml-lang="en-US" l10n="U" oldref="7">1 + 16% corresponds to 116% or 1.16</paragraph> +<paragraph role="paragraph" id="par_id3148575" xml-lang="en-US" l10n="U" oldref="8">1%% corresponds to 0.0001</paragraph> +<section id="relatedtopics"> +<paragraph role="paragraph" id="par_id3159153" xml-lang="en-US" l10n="U" oldref="10"><link href="text/shared/01/05020300.xhp" name="Format - Cell - Numbers">Format - Cell - Numbers</link></paragraph> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/02/02150000.xhp b/source/text/scalc/02/02150000.xhp new file mode 100644 index 0000000000..030af54843 --- /dev/null +++ b/source/text/scalc/02/02150000.xhp @@ -0,0 +1,68 @@ +<?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="textscalc0202150000xml" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Number format: Default</title> +<filename>/text/scalc/02/02150000.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> + + + <section id="standard"> + <bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatStandard" id="bm_id6331318" localize="false"/><!-- HID added by script --> +<bookmark branch="hid/.uno:NumberFormatStandard" xml-lang="en-US" id="bm_id3152996"/><paragraph id="hd_id3149182" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/02/02150000.xhp" name="Number format: Default">Number format: Default</link></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3163802" xml-lang="en-US" oldref="2"><ahelp hid=".uno:NumberFormatStandard" visibility="visible">Applies the default number format to the selected cells.</ahelp></paragraph> + </section> + <section id="systandard"> + <table id="tbl_id3156326"> + + + + <tablerow> + <tablecell> + <paragraph l10n="E" role="paragraph" id="par_id3155922" xml-lang="en-US" oldref=""><image src="cmd/sc_numberformatstandard.png" id="img_id3156024"><alt xml-lang="en-US" id="alt_id3156024">Icon</alt></image></paragraph> + + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3153361" l10n="U" xml-lang="en-US" oldref="3">Number Format: Standard</paragraph> + </tablecell> + </tablerow> + + </table> + </section> + <section id="relatedtopics"> + <paragraph l10n="U" role="paragraph" id="par_id3154908" xml-lang="en-US" oldref="4"><link href="text/shared/01/05020300.xhp" name="Format - Cell - Numbers">Format - Cell - Numbers</link>.</paragraph> + </section></body> +</helpdocument> diff --git a/source/text/scalc/02/02160000.xhp b/source/text/scalc/02/02160000.xhp new file mode 100644 index 0000000000..780596d817 --- /dev/null +++ b/source/text/scalc/02/02160000.xhp @@ -0,0 +1,67 @@ +<?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="textscalc0202160000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Number Format: Add Decimal Place</title> +<filename>/text/scalc/02/02160000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2006-02-13T15:25:27">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<section id="dezimalhin"><comment>mw copied three index entries to Calc guide format_value.xhp</comment> +<bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatIncDecimals" id="bm_id1150276" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatIncDecimals" id="bm_id3155922" localize="false"/> +<paragraph role="heading" id="hd_id3150275" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/02160000.xhp" name="Number Format: Add Decimal Place">Number Format: Add Decimal Place</link></paragraph> +<paragraph role="paragraph" id="par_id3150792" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:NumberFormatIncDecimals">Adds one decimal place to the numbers in the selected cells.</ahelp></paragraph> +</section> +<section id="sydezimalhin"> +<table id="tbl_id3156280"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3145787" xml-lang="en-US" l10n="E"> +<image id="img_id3145271" src="cmd/sc_numberformatincdecimals.png" width="5.64mm" height="5.64mm"><alt id="alt_id3145271" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3149262" xml-lang="en-US" l10n="U" oldref="3">Number Format: Add Decimal Place</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/02/02170000.xhp b/source/text/scalc/02/02170000.xhp new file mode 100644 index 0000000000..18af1208d5 --- /dev/null +++ b/source/text/scalc/02/02170000.xhp @@ -0,0 +1,67 @@ +<?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="textscalc0202170000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Number Format: Delete Decimal Place</title> +<filename>/text/scalc/02/02170000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2006-02-13T15:30:40">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<section id="dezimalweg"><comment>mw copied three index entries to Calc guide format_value.xhp</comment> +<bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatDecDecimals" id="bm_id9660963" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatDecDecimals" id="bm_id3153252" localize="false"/> +<paragraph role="heading" id="hd_id3149164" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/02170000.xhp" name="Number Format: Delete Decimal Place">Number Format: Delete Decimal Place</link></paragraph> +<paragraph role="paragraph" id="par_id3147264" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:NumberFormatDecDecimals">Removes one decimal place from the numbers in the selected cells.</ahelp></paragraph> +</section> +<section id="sydezimalweg"> +<table id="tbl_id3154365"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3145173" xml-lang="en-US" l10n="E"> +<image id="img_id3153192" src="cmd/sc_numberformatdecdecimals.png" width="5.64mm" height="5.64mm"><alt id="alt_id3153192" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3154686" xml-lang="en-US" l10n="U" oldref="3">Number Format: Delete Decimal Place</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/02/06010000.xhp b/source/text/scalc/02/06010000.xhp new file mode 100644 index 0000000000..9b170e442d --- /dev/null +++ b/source/text/scalc/02/06010000.xhp @@ -0,0 +1,72 @@ +<?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="textscalc0206010000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Sheet Area</title> +<filename>/text/scalc/02/06010000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2005-07-05T10:26:22">UFI: fixed #i28238# and "sc-features Create named ranges by typing into the name box" +dedr: reviewed</lastedited> +</history> +</meta> +<body> +<section id="tabellenbereich"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3156326"><bookmark_value>formula bar; sheet area names</bookmark_value> +<bookmark_value>sheet area names</bookmark_value> +<bookmark_value>showing; cell references</bookmark_value> +<bookmark_value>cell references; showing</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_POS" id="bm_id3153087" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/.uno:FocusCellAddress" id="bm_id2941984" localize="false"/> +<paragraph role="heading" id="hd_id3156326" xml-lang="en-US" level="1" l10n="CHG" oldref="1"><link href="text/scalc/02/06010000.xhp" name="Name Box">Name Box</link></paragraph> +<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US" l10n="CHG" oldref="2"><ahelp hid="HID_INSWIN_POS">Displays the reference for the current cell, the range of the selected cells, or the name of the area. You can also select a range of cells, and then type a name for that range into the <emph>Name Box</emph>.</ahelp><comment>UFI: fixes #i28238#</comment></paragraph> +</section> +<section id="sytabellenbereich"> +<table id="tbl_id3150870"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3163710" xml-lang="en-US" l10n="E"> +<image id="img_id3152576" src="res/helpimg/calcein.png" width="1.2398inch" height="0.2398inch" localize="true"><alt id="alt_id3152576" xml-lang="en-US">Combo box sheet area</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3151118" xml-lang="en-US" l10n="CHG" oldref="4">Name Box</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +<paragraph role="paragraph" id="par_id3152596" xml-lang="en-US" l10n="U" oldref="6">To jump to a particular cell, or to select a cell range, type the cell reference, or cell range reference in this box, for example, F1, or A1:C4.</paragraph> +</body> +</helpdocument> diff --git a/source/text/scalc/02/06030000.xhp b/source/text/scalc/02/06030000.xhp new file mode 100644 index 0000000000..5d2fea7f33 --- /dev/null +++ b/source/text/scalc/02/06030000.xhp @@ -0,0 +1,69 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + +<!-- +*********************************************************************** + * + * 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. + * + ************************************************************************ + --> + + +<meta> + <topic id="textscalc0206030000xml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Sum</title> + <filename>/text/scalc/02/06030000.xhp</filename> + </topic> + </meta> + <body> + <section id="summe"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3157909"><bookmark_value>functions;sum function icon</bookmark_value> + <bookmark_value>formula bar;sum function</bookmark_value> + <bookmark_value>sum icon</bookmark_value> + <bookmark_value>AutoSum button, see sum icon</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_SUMME" id="bm_id3151384" localize="false"/><comment>MW inserted a cross-reference</comment> +<paragraph xml-lang="en-US" id="hd_id3157909" role="heading" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06030000.xhp" name="Sum">Sum</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3150543" role="paragraph" l10n="CHG" oldref="2"><ahelp hid="HID_INSWIN_SUMME">Inserts the sum of a cell range into the current cell, or inserts sum values into selected cells. Click in a cell, click this icon, and optionally adjust the cell range. Or select some cells into which the sum values will be inserted, then click the icon.</ahelp></paragraph> + </section> + <section id="sysumme"> + <table id="tbl_id3150868"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153770" role="paragraph" l10n="E"> +<image id="img_id3147434" src="cmd/sc_autosum.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3147434">Icon</alt> + </image></paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152577" role="paragraph" l10n="U" oldref="15">Sum</paragraph> + </tablecell> + </tablerow> + </table> + + </section> + <paragraph xml-lang="en-US" id="par_id3156444" role="paragraph" l10n="U" oldref="16">$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a sum function, you can combine it with the new one to yield the total sum of the range. If the range contains filters, the Subtotal function is inserted instead of the Sum function.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153189" role="paragraph" l10n="U" oldref="3">Click the <emph>Accept</emph> icon (green check mark) to use the formula displayed in the input line.</paragraph> + </body> +</helpdocument>
\ No newline at end of file diff --git a/source/text/scalc/02/06040000.xhp b/source/text/scalc/02/06040000.xhp new file mode 100644 index 0000000000..25a9e0dc09 --- /dev/null +++ b/source/text/scalc/02/06040000.xhp @@ -0,0 +1,64 @@ +<?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="textscalc0206040000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Function</title> +<filename>/text/scalc/02/06040000.xhp</filename> +</topic> +</meta> +<body> +<section id="funktion"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3150084"><bookmark_value>formula bar; functions</bookmark_value> +<bookmark_value>functions; formula bar icon</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_FUNC" id="bm_id3145119" localize="false"/> +<paragraph role="heading" id="hd_id3150084" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06040000.xhp" name="Function">Function</link></paragraph> +<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="HID_INSWIN_FUNC">Adds a formula to the current cell. Click this icon, and then enter the formula in the <emph>Input line</emph>.</ahelp></paragraph> +</section> +<paragraph role="paragraph" id="par_id3153360" xml-lang="en-US" l10n="CHG" oldref="3">This icon is only available when the <emph>Input line</emph> box is not active.</paragraph> +<section id="syfunktion"> +<table id="tbl_id3154684"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US" l10n="E"> +<image id="img_id3145785" src="sc/imglst/sc26049.png" width="5.64mm" height="5.64mm"><alt id="alt_id3145785" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3153951" xml-lang="en-US" l10n="U" oldref="4">Function</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/02/06050000.xhp b/source/text/scalc/02/06050000.xhp new file mode 100644 index 0000000000..c9f76eb5fa --- /dev/null +++ b/source/text/scalc/02/06050000.xhp @@ -0,0 +1,50 @@ +<?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="textscalc0206050000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Input line</title> +<filename>/text/scalc/02/06050000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2005-01-17T10:40:14">FPE: Deleted screenshot</lastedited> +</history> +</meta> +<body> +<section id="eingabezeile"> +<bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_INPUT" id="bm_id3150084" localize="false"/> +<paragraph role="heading" id="hd_id3153821" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06050000.xhp" name="Input line">Input line</link></paragraph> +<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="HID_INSWIN_INPUT">Enter the formula that you want to add to the current cell. You can also click the <link href="text/scalc/01/04060000.xhp" name="Function Wizard">Function Wizard</link> icon to insert a predefined function into the formula.</ahelp></paragraph> +</section> +<embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/> +</body> +</helpdocument> diff --git a/source/text/scalc/02/06060000.xhp b/source/text/scalc/02/06060000.xhp new file mode 100644 index 0000000000..9dcf9c1329 --- /dev/null +++ b/source/text/scalc/02/06060000.xhp @@ -0,0 +1,67 @@ +<?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="textscalc0206060000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Cancel</title> +<filename>/text/scalc/02/06060000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2004-09-27T09:42:52">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<section id="verwerfen"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3154514"><bookmark_value>formula bar; canceling inputs</bookmark_value> +<bookmark_value>functions; canceling input icon</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_CANCEL" id="bm_id3153088" localize="false"/> +<paragraph role="heading" id="hd_id3154514" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06060000.xhp" name="Cancel">Cancel</link></paragraph> +<paragraph role="paragraph" id="par_id3153823" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="HID_INSWIN_CANCEL">Clears the contents of the <emph>Input line</emph>, or cancels the changes that you made to an existing formula.</ahelp></paragraph> +</section> +<section id="syverwerfen"> +<table id="tbl_id3150541"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3156281" xml-lang="en-US" l10n="E"> +<image id="img_id3156422" src="svx/res/nu08.png" width="0.2228inch" height="0.2228inch"><alt id="alt_id3156422" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3153970" xml-lang="en-US" l10n="U" oldref="3">Cancel</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/02/06070000.xhp b/source/text/scalc/02/06070000.xhp new file mode 100644 index 0000000000..6ccb9f1385 --- /dev/null +++ b/source/text/scalc/02/06070000.xhp @@ -0,0 +1,67 @@ +<?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="textscalc0206070000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Accept</title> +<filename>/text/scalc/02/06070000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2004-08-10T11:08:35">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<section id="uebernehmen"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3143267"><bookmark_value>formula bar; accepting inputs</bookmark_value> +<bookmark_value>functions; accepting input icon</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_OK" id="bm_id3149164" localize="false"/> +<paragraph role="heading" id="hd_id3143267" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06070000.xhp" name="Accept">Accept</link></paragraph> +<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="HID_INSWIN_OK">Accepts the contents of the <emph>Input line</emph>, and then inserts the contents into the current cell.</ahelp></paragraph> +</section> +<section id="syuebernehmen"> +<table id="tbl_id3154365"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3150769" xml-lang="en-US" l10n="E"> +<image id="img_id3156422" src="svx/res/nu07.png" width="5.64mm" height="5.64mm"><alt id="alt_id3156422" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3125864" xml-lang="en-US" l10n="U" oldref="3">Accept</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/02/06080000.xhp b/source/text/scalc/02/06080000.xhp new file mode 100644 index 0000000000..a3747180b2 --- /dev/null +++ b/source/text/scalc/02/06080000.xhp @@ -0,0 +1,67 @@ +<?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="textscalc0206080000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Theme Selection</title> +<filename>/text/scalc/02/06080000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2005-01-04T13:56:36">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<bookmark xml-lang="en-US" branch="hid/.uno:ChooseDesign" id="bm_id5786643" localize="false"/><!-- HID added by script --> +<bookmark xml-lang="en-US" branch="hid/.uno:ChooseDesign" id="bm_id3147335" localize="false"/> +<paragraph role="heading" id="hd_id3153087" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06080000.xhp" name="Theme Selection">Theme Selection</link></paragraph> +<paragraph role="paragraph" id="par_id3154515" xml-lang="en-US" l10n="U" oldref="2"><variable id="thementext"><ahelp hid=".uno:ChooseDesign">Applies a formatting style to the selected cells.</ahelp> +</variable> The styles include font, border, and background color information.</paragraph> +<section id="sythemen"> +<table id="tbl_id3153968"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3155132" xml-lang="en-US" l10n="E"> +<image id="img_id3145785" src="cmd/sc_choosedesign.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145785" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3153953" xml-lang="en-US" l10n="U" oldref="4">Choose Themes</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGSTYLES_LISTBOX" id="bm_id3153159" localize="false"/> +<paragraph role="paragraph" id="par_id3147127" xml-lang="en-US" l10n="U" oldref="5"><ahelp hid="HID_DLGSTYLES_LISTBOX">Click the formatting theme that you want to apply, and then click <emph>OK</emph>.</ahelp></paragraph> +<embed href="text/scalc/guide/design.xhp#design"/> +</body> +</helpdocument> diff --git a/source/text/scalc/02/08010000.xhp b/source/text/scalc/02/08010000.xhp new file mode 100644 index 0000000000..42e1235890 --- /dev/null +++ b/source/text/scalc/02/08010000.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="textscalc0208010000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Position in document</title> +<filename>/text/scalc/02/08010000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2006-04-05T11:46:30">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<section id="positionimdokument"> +<bookmark xml-lang="en-US" branch="hid/.uno:StatusDocPos" id="bm_id4735827" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/.uno:StatusDocPos" id="bm_id3151245" localize="false"/> +<paragraph role="heading" id="hd_id3145119" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/08010000.xhp" name="Position in document">Position in document</link></paragraph> +<paragraph role="paragraph" id="par_id3147265" xml-lang="en-US" l10n="CHG" oldref="2"><ahelp hid=".uno:StatusDocPos">Displays the number of the current sheet and the total number of sheets in the spreadsheet.</ahelp></paragraph> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/02/08080000.xhp b/source/text/scalc/02/08080000.xhp new file mode 100644 index 0000000000..c83eb9cd14 --- /dev/null +++ b/source/text/scalc/02/08080000.xhp @@ -0,0 +1,65 @@ +<?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="textscalc0208080000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Standard Formula, Date/Time, Error Warning</title> +<filename>/text/scalc/02/08080000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2006-12-04T14:46:22">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<section id="datumzeit"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3147335"><bookmark_value>formulas;status bar</bookmark_value> +</bookmark><comment>MW changed index entry</comment> +<bookmark xml-lang="en-US" branch="hid/SVX_HID_MNU_FUNC_NONE" id="bm_id3156327" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SVX_HID_MNU_FUNC_SUM" id="bm_id3143267" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SVX_HID_MNU_FUNC_MIN" id="bm_id3154514" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SVX_HID_MNU_FUNC_MAX" id="bm_id3150275" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SVX_HID_MNU_FUNC_COUNT" id="bm_id3153087" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SVX_HID_MNU_FUNC_COUNT2" id="bm_id3151245" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SVX_HID_MNU_FUNC_AVG" id="bm_id3156024" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/.uno:StateTableCell" id="bm_id2262199" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/.uno:StateTableCell" id="bm_id3151384" localize="false"/> +<paragraph role="heading" id="hd_id3147335" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/08080000.xhp" name="Standard Formula, Date/Time, Error Warning">Standard Formula, Date/Time, Error Warning</link></paragraph> +<paragraph role="paragraph" id="par_id3150791" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:StateTableCell">Displays information about the current document. By default, the SUM of the contents of the selected cells is displayed.</ahelp></paragraph> +</section> +<paragraph role="paragraph" id="par_id3155061" xml-lang="en-US" l10n="U" oldref="3">To change the default formula that is displayed, right-click the field, and then choose the formula that you want. The available formulas are: Average, count of values (COUNTA), count of numbers (COUNT), Maximum, Minimum, Sum, or None.</paragraph> +<section id="relatedtopics"> +<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="U" oldref="4"><link href="text/scalc/05/02140000.xhp" name="Error codes">Error codes</link></paragraph> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/02/10050000.xhp b/source/text/scalc/02/10050000.xhp new file mode 100644 index 0000000000..faebc2474d --- /dev/null +++ b/source/text/scalc/02/10050000.xhp @@ -0,0 +1,72 @@ +<?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="textscalc0210050000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Zoom In</title> +<filename>/text/scalc/02/10050000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2007-03-01T11:59:14">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<section id="massstabvergroessern"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3148491"><bookmark_value>page views; increasing scales</bookmark_value> +<bookmark_value>increasing scales in page view</bookmark_value> +<bookmark_value>zooming;enlarging page views</bookmark_value> +</bookmark><comment>mw deleted "scaling;"</comment> +<bookmark xml-lang="en-US" branch="hid/.uno:ZoomIn" id="bm_id7362949" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/.uno:ZoomIn" id="bm_id3143267" localize="false"/> +<paragraph role="heading" id="hd_id3148491" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/10050000.xhp" name="Zoom In">Zoom In</link></paragraph> +<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:ZoomIn">Enlarges the screen display of the current document. The current zoom factor is displayed on the <emph>Status Bar</emph>.</ahelp></paragraph> +</section> +<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US" l10n="U" oldref="4">The maximum zoom factor is 400%.</paragraph> +<section id="sygross"> +<table id="tbl_id3154686"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US" l10n="E"> +<image id="img_id3151116" src="cmd/sc_helpzoomin.png" width="0.222inch" height="0.222inch"><alt id="alt_id3151116" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US" l10n="U" oldref="3">Zoom In</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/02/10060000.xhp b/source/text/scalc/02/10060000.xhp new file mode 100644 index 0000000000..dc683a1cc8 --- /dev/null +++ b/source/text/scalc/02/10060000.xhp @@ -0,0 +1,71 @@ +<?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="textscalc0210060000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Zoom Out</title> +<filename>/text/scalc/02/10060000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2007-03-01T12:00:57">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<section id="massstabverkleinern"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153561"><bookmark_value>page views;reducing scales</bookmark_value> +<bookmark_value>zooming;reducing page views</bookmark_value> +</bookmark><comment>mw deleted "scaling;"</comment> +<bookmark xml-lang="en-US" branch="hid/.uno:ZoomOut" id="bm_id5729287" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/.uno:ZoomOut" id="bm_id3156329" localize="false"/> +<paragraph role="heading" id="hd_id3153561" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/10060000.xhp" name="Zoom Out">Zoom Out</link></paragraph> +<paragraph role="paragraph" id="par_id3151246" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:ZoomOut">Reduces the screen display of the current document. The current zoom factor is displayed on the <emph>Status Bar</emph>.</ahelp></paragraph> +</section> +<paragraph role="paragraph" id="par_id3150398" xml-lang="en-US" l10n="U" oldref="4">The minimum zoom factor is 20%.</paragraph> +<section id="syklein"> +<table id="tbl_id3125863"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US" l10n="E"> +<image id="img_id3155131" src="cmd/sc_zoomout.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155131" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3150440" xml-lang="en-US" l10n="U" oldref="3">Zooming Out</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/02/18010000.xhp b/source/text/scalc/02/18010000.xhp new file mode 100644 index 0000000000..bc5256f426 --- /dev/null +++ b/source/text/scalc/02/18010000.xhp @@ -0,0 +1,86 @@ +<?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="textscalc0218010000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Insert</title> +<filename>/text/scalc/02/18010000.xhp</filename> +</topic> +</meta> +<body> +<section id="einfuegen"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3156329"><bookmark_value>inserting; objects, toolbar icon</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/.uno:InsertCtrl" id="bm_id5322551" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/.uno:InsertCtrl" id="bm_id3156327" localize="false"/><paragraph role="heading" id="hd_id3156329" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/18010000.xhp" name="Insert">Insert</link></paragraph> +<paragraph role="paragraph" id="par_id3147336" xml-lang="en-US" l10n="CHG" oldref="2"><ahelp hid=".uno:InsertCtrl">Click the arrow next to the icon to open the <emph>Insert </emph>toolbar, where you can add graphics and special characters to the current sheet.</ahelp></paragraph> +</section> +<paragraph role="paragraph" id="par_id3148664" xml-lang="en-US" l10n="CHG" oldref="3">Tools bar icon:</paragraph> +<section id="syeinfuegen"> +<table id="tbl_id3154365"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US" l10n="E"> +<image id="img_id3156423" src="cmd/sc_insertgraphic.png" width="0.222inch" height="0.222inch"><alt id="alt_id3156423" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3146120" xml-lang="en-US" l10n="U" oldref="4">Insert</paragraph> +</tablecell> +</tablerow> +</table> +</section> +<paragraph role="paragraph" id="par_id3153188" xml-lang="en-US" l10n="U" oldref="6">You can select the following icons:</paragraph> +<paragraph role="heading" id="hd_id4283883" xml-lang="en-US" level="2" l10n="NEW"><link href="text/shared/01/04160500.xhp" name="Floating Frame">Floating Frame</link></paragraph> +<embed href="text/shared/01/04160500.xhp#frameeinfuegentext"/> +<embed href="text/shared/00/00000404.xhp#syframe"/> +<paragraph role="heading" id="hd_id3149410" xml-lang="en-US" level="2" l10n="CHG" oldref="8"><link href="text/shared/01/04100000.xhp" name="Special Character">Special Character</link></paragraph> +<embed href="text/shared/01/04100000.xhp#sonder"/> +<embed href="text/shared/00/00000404.xhp#sysonder"/> +<paragraph role="heading" id="hd_id3151117" xml-lang="en-US" level="2" l10n="CHG" oldref="7"><link href="text/shared/01/04140000.xhp" name="From File">From File</link></paragraph> +<embed href="text/shared/01/04140000.xhp#grafiktext"/> +<embed href="text/shared/00/00000404.xhp#sygrafik"/> +<embed href="text/shared/01/moviesound.xhp#moviesound"/> +<embed href="text/shared/00/00000404.xhp#symoviesound"/> +<paragraph role="heading" id="hd_id3633533" xml-lang="en-US" level="2" l10n="NEW"><link href="text/shared/01/04160300.xhp" name="Formula">Formula</link></paragraph> +<embed href="text/shared/01/04160300.xhp#starmath"/> +<embed href="text/shared/00/00000404.xhp#systarmath"/> +<paragraph role="heading" id="par_idN10769" xml-lang="en-US" level="2" l10n="NEW"><link href="text/schart/01/wiz_chart_type.xhp" name="Insert Chart">Chart</link></paragraph> +<embed href="text/shared/00/00000404.xhp#systarchart"/> +<paragraph role="heading" id="hd_id7581408" xml-lang="en-US" level="2" l10n="NEW"><link href="text/shared/01/04150100.xhp" name="OLE Object">OLE Object</link></paragraph> +<embed href="text/shared/01/04150100.xhp#ole"/> +<embed href="text/shared/00/00000404.xhp#syole"/> +</body> +</helpdocument> diff --git a/source/text/scalc/02/18020000.xhp b/source/text/scalc/02/18020000.xhp new file mode 100644 index 0000000000..bf7178c93e --- /dev/null +++ b/source/text/scalc/02/18020000.xhp @@ -0,0 +1,67 @@ +<?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="textscalc0218020000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Insert Cells</title> +<filename>/text/scalc/02/18020000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2005-01-06T11:00:26">converted from old format - fpe</lastedited> +</history> +</meta> +<body> +<section id="zelleneinfuegen"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3150275"><bookmark_value>inserting; cells, toolbar icon</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/.uno:InsCellsCtrl" id="bm_id3670488" localize="false"/><!-- HID added by script --> +<bookmark xml-lang="en-US" branch="hid/.uno:InsCellsCtrl" id="bm_id3156329" localize="false"/> +<paragraph role="heading" id="hd_id3150275" xml-lang="en-US" level="1" l10n="CHG" oldref="1"><link href="text/scalc/02/18020000.xhp" name="Insert Cells">Insert Cells</link></paragraph> +<paragraph role="paragraph" id="par_id3156024" xml-lang="en-US" l10n="CHG" oldref="2"><ahelp hid=".uno:InsCellsCtrl">Click the arrow next to the icon to open the <emph>Insert Cells </emph>toolbar, where you can insert cells, rows, and columns into the current sheet.</ahelp></paragraph> +</section> +<paragraph role="paragraph" id="par_id3150398" xml-lang="en-US" l10n="CHG" oldref="3">Tools bar icon:</paragraph> +<embed href="text/scalc/00/00000404.xhp#syzelleneinfuegen"/> +<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US" l10n="U" oldref="5">You can select the following icons:</paragraph> +<paragraph role="heading" id="hd_id3150439" xml-lang="en-US" level="2" l10n="U" oldref="6"><link href="text/scalc/01/04020000.xhp" name="Insert Cells Down">Insert Cells Down</link></paragraph> +<embed href="text/scalc/01/04020000.xhp#zellenuntentext"/> +<embed href="text/scalc/00/00000404.xhp#syzellenunten"/> +<paragraph role="heading" id="hd_id3146119" xml-lang="en-US" level="2" l10n="U" oldref="7"><link href="text/scalc/01/04020000.xhp" name="Insert Cells Right">Insert Cells Right</link></paragraph> +<embed href="text/scalc/01/04020000.xhp#zellenrechtstext"/> +<embed href="text/scalc/00/00000404.xhp#syzellenrechts"/> +<paragraph role="heading" id="hd_id3153190" xml-lang="en-US" level="2" l10n="CHG" oldref="8"><link href="text/scalc/01/04020000.xhp" name="Rows">Rows</link></paragraph> +<embed href="text/scalc/01/04020000.xhp#zeilenganzetext"/> +<embed href="text/scalc/00/00000404.xhp#syzeilenganze"/> +<paragraph role="heading" id="hd_id3153726" xml-lang="en-US" level="2" l10n="CHG" oldref="9"><link href="text/scalc/01/04020000.xhp" name="Columns">Columns</link></paragraph> +<embed href="text/scalc/01/04020000.xhp#spaltenganzetext"/> +<embed href="text/scalc/00/00000404.xhp#syspaltenganze"/> +</body> +</helpdocument> diff --git a/source/text/scalc/02/makefile.mk b/source/text/scalc/02/makefile.mk new file mode 100644 index 0000000000..00d35e7958 --- /dev/null +++ b/source/text/scalc/02/makefile.mk @@ -0,0 +1,69 @@ +#************************************************************************* +# +# 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/02 +# uniqe name (module wide); +# using a modified form of package should do here +TARGET = text_scalc_02 +# 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 = \ + 02130000.xhp \ + 02140000.xhp \ + 02150000.xhp \ + 02160000.xhp \ + 02170000.xhp \ + 06010000.xhp \ + 06030000.xhp \ + 06040000.xhp \ + 06050000.xhp \ + 06060000.xhp \ + 06070000.xhp \ + 06080000.xhp \ + 08010000.xhp \ + 08080000.xhp \ + 10050000.xhp \ + 10060000.xhp \ + 18010000.xhp \ + 18020000.xhp + +# --- Targets ------------------------------------------------------ + +.INCLUDE : target.mk +.INCLUDE : tg_help.mk |