diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:54:39 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:54:39 +0000 |
| commit | 267c6f2ac71f92999e969232431ba04678e7437e (patch) | |
| tree | 358c9467650e1d0a1d7227a21dac2e3d08b622b2 /helpcontent2/source/text/scalc/02 | |
| parent | Initial commit. (diff) | |
| download | libreoffice-267c6f2ac71f92999e969232431ba04678e7437e.tar.xz libreoffice-267c6f2ac71f92999e969232431ba04678e7437e.zip | |
Adding upstream version 4:24.2.0.upstream/4%24.2.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'helpcontent2/source/text/scalc/02')
| -rw-r--r-- | helpcontent2/source/text/scalc/02/06010000.xhp | 61 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/06030000.xhp | 86 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/06040000.xhp | 55 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/06050000.xhp | 40 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/06060000.xhp | 57 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/06070000.xhp | 57 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/06080000.xhp | 41 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/08010000.xhp | 39 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/08080000.xhp | 45 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/10050000.xhp | 58 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/10060000.xhp | 58 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/18010000.xhp | 75 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/18020000.xhp | 56 |
13 files changed, 728 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/02/06010000.xhp b/helpcontent2/source/text/scalc/02/06010000.xhp new file mode 100644 index 0000000000..cfc1b577c7 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06010000.xhp @@ -0,0 +1,61 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + +<helpdocument version="1.0"> +<meta> +<topic id="textscalc0206010000xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Name Box</title> +<filename>/text/scalc/02/06010000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +</history> +</meta> +<body> +<section id="name_box"> +<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"/> +<h1 id="hd_id3156326"><link href="text/scalc/02/06010000.xhp">Name Box</link></h1> +<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US"><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="syname_box"> +<table id="tbl_id3150870"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3163710" xml-lang="en-US"> +<image id="img_id3152576" src="media/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">Name Box</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +<paragraph role="paragraph" id="par_id3152596" xml-lang="en-US">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. You can also enter full name of a sheet; the tooltip then changes to "Go To Sheet", and pressing Enter switches to that sheet.</paragraph> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/02/06030000.xhp b/helpcontent2/source/text/scalc/02/06030000.xhp new file mode 100644 index 0000000000..9a3c5a151a --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06030000.xhp @@ -0,0 +1,86 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + + +<meta> + <topic id="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="sum"> +<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> +<h1 id="hd_id3157909"><link href="text/scalc/02/06030000.xhp">Select Function</link></h1> + <paragraph xml-lang="en-US" id="par_id3150543" role="paragraph"><ahelp hid="HID_INSWIN_SUMME">Insert a function of a cell range into the current cell. The function can be Sum, Average, Minimum, Maximum and Count. Click in a cell, click this icon, select the function in the drop down list and optionally adjust the cell range. Or select some cells into which the function value will be inserted, then click the icon. The function result is added at the bottom of the range.</ahelp></paragraph> + </section> + <section id="sysum"> + <table id="tbl_id3150868"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153770" role="paragraph"> +<image id="img_id3147434" src="cmd/sc_autosum.svg" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id3147434">Icon Select Function</alt> + </image></paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152577" role="paragraph">Select Function</paragraph> + </tablecell> + </tablerow> + </table> +</section> +<h2 id="hd_id161592658402954">Select Function applied with no selected range</h2> +<paragraph xml-lang="en-US" id="par_id3156444" role="paragraph">$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a function, you can combine it with the new one to yield the function applied to the range data. If the range contains filters, the Subtotal function is inserted instead of the selected function.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153189" role="paragraph">Click the <emph>Accept</emph> icon to use the formula displayed in the input line or <emph>Cancel</emph>.</paragraph> +<table id="tab_id891592663499228"> + <tablerow> + <tablecell> + <paragraph role="image" id="par_id231592663499228"> +<image src="cmd/sc_ok.svg" id="img_id521592663499228" width="1cm" height="1cm"><alt id="alt_id171592663499228">Accept Icon</alt></image> + </paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id481592663499228" role="paragraph">Accept</paragraph> + </tablecell> + </tablerow> +</table> +<table id="tab_id591592663828848"> + <tablerow> + <tablecell> + <paragraph role="image" id="par_id311592663828848"> +<image src="cmd/sc_cancel.svg" id="img_id641592663828848" width="1cm" height="1cm"><alt id="alt_id111592663828848">Icon Cancel</alt></image> + </paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id431592663828848" role="paragraph">Cancel</paragraph> + </tablecell> + </tablerow> +</table> + +<h2 id="hd_id261592658395518">Select Function applied on a selected range</h2> +<paragraph role="paragraph" id="par_id911592658130888">When the selected range has two or more rows, the function is calculated for each column. The results are placed in empty cells on the first available row below the range, one result per column.</paragraph> +<paragraph role="paragraph" id="par_id991592658144387">When the selected range has one row, the function result is placed in the first available cell on the right of the selected range.</paragraph> + </body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/02/06040000.xhp b/helpcontent2/source/text/scalc/02/06040000.xhp new file mode 100644 index 0000000000..d61770b3b7 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06040000.xhp @@ -0,0 +1,55 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + +<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="function"> +<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"/> +<h1 id="hd_id3150084"><link href="text/scalc/02/06040000.xhp">Function</link></h1> +<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US"><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">This icon is only available when the <emph>Input line</emph> box is not active.</paragraph> +<section id="syfunction"> +<table id="tbl_id3154684"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US"> +<image id="img_id3145785" src="sc/res/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">Function</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/02/06050000.xhp b/helpcontent2/source/text/scalc/02/06050000.xhp new file mode 100644 index 0000000000..906e346752 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06050000.xhp @@ -0,0 +1,40 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + +<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> +</history> +</meta> +<body> +<section id="input_line"> +<bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_INPUT" id="bm_id3150084" localize="false"/> +<h1 id="hd_id3153821"><link href="text/scalc/02/06050000.xhp">Input line</link></h1> +<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><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">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/helpcontent2/source/text/scalc/02/06060000.xhp b/helpcontent2/source/text/scalc/02/06060000.xhp new file mode 100644 index 0000000000..44f2acdc3b --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06060000.xhp @@ -0,0 +1,57 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + +<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> +</history> +</meta> +<body> +<section id="cancel"> +<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"/> +<h1 id="hd_id3154514"><link href="text/scalc/02/06060000.xhp">Cancel</link></h1> +<paragraph role="paragraph" id="par_id3153823" xml-lang="en-US"><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="sycancel"> +<table id="tbl_id3150541"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3156281" xml-lang="en-US"> +<image id="img_id3156422" src="svx/res/nu02.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">Cancel</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/02/06070000.xhp b/helpcontent2/source/text/scalc/02/06070000.xhp new file mode 100644 index 0000000000..b144b8fc9c --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06070000.xhp @@ -0,0 +1,57 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + +<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> +</history> +</meta> +<body> +<section id="accept"> +<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"/> +<h1 id="hd_id3143267"><link href="text/scalc/02/06070000.xhp">Accept</link></h1> +<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US"><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="syaccept"> +<table id="tbl_id3154365"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3150769" xml-lang="en-US"> +<image id="img_id3156422" src="svx/res/nu01.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">Accept</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/02/06080000.xhp b/helpcontent2/source/text/scalc/02/06080000.xhp new file mode 100644 index 0000000000..e9d5f19c67 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06080000.xhp @@ -0,0 +1,41 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> +<helpdocument version="1.0"> +<meta> +<topic id="textscalc0206080000xml" indexer="include" status="PUBLISH"> +<title id="tit">Theme Selection</title> +<filename>/text/scalc/02/06080000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +</history> +</meta> +<body> +<bookmark branch="hid/.uno:ChooseDesign" id="bm_id3147335" localize="false"/> +<h1 id="hd_id3153087"><link href="text/scalc/02/06080000.xhp">Theme Selection</link></h1> +<paragraph role="paragraph" id="par_id3154515"><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="howtoget"> + <embed href="text/scalc/00/00000405.xhp#themes"/> +</section> +<bookmark branch="hid/WIZARDS_HID_DLGSTYLES_LISTBOX" id="bm_id3153159" localize="false"/> +<paragraph role="paragraph" id="par_id3147127"><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/helpcontent2/source/text/scalc/02/08010000.xhp b/helpcontent2/source/text/scalc/02/08010000.xhp new file mode 100644 index 0000000000..91c796e0ec --- /dev/null +++ b/helpcontent2/source/text/scalc/02/08010000.xhp @@ -0,0 +1,39 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + +<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> +</history> +</meta> +<body> +<section id="position_in_document"> +<bookmark xml-lang="en-US" branch="hid/.uno:StatusDocPos" id="bm_id4735827" localize="false"/> +<h1 id="hd_id3145119"><link href="text/scalc/02/08010000.xhp">Position in document</link></h1> +<paragraph role="paragraph" id="par_id3147265" xml-lang="en-US"><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/helpcontent2/source/text/scalc/02/08080000.xhp b/helpcontent2/source/text/scalc/02/08080000.xhp new file mode 100644 index 0000000000..a75e9c4185 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/08080000.xhp @@ -0,0 +1,45 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + +<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> +</history> +</meta> +<body> +<section id="date_time"> +<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/.uno:StateTableCell" id="bm_id2262199" localize="false"/> +<h1 id="hd_id3147335"><link href="text/scalc/02/08080000.xhp">Standard Formula, Date/Time, Error Warning</link></h1> +<paragraph role="paragraph" id="par_id3150791" xml-lang="en-US"><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">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"><link href="text/scalc/05/02140000.xhp">Error codes</link></paragraph> +</section> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/02/10050000.xhp b/helpcontent2/source/text/scalc/02/10050000.xhp new file mode 100644 index 0000000000..c476f361a2 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/10050000.xhp @@ -0,0 +1,58 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> +<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> +</history> +</meta> +<body> +<section id="zoom_in"> +<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"/> +<h1 id="hd_id3148491"><variable id="h1"><link href="text/scalc/02/10050000.xhp">Zoom In</link></variable></h1> +<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US"><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_id71678262942683" xml-lang="en-US"> + <image src="media/helpimg/scalc/calczoomslider.png" id="img_id721678262942684" width="282px" height="40px"><alt xml-lang="en-US" id="alt_id461678262942685">Calc Zoom Slider</alt></image> + </paragraph> +<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US">The maximum zoom factor is 400%.</paragraph> +<section id="syzoom_in"> +<table id="tbl_id3154686"> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US"> +<image id="img_id3151116" src="cmd/lc_zoomin.svg" width="1cm" height="1cm"><alt id="alt_id3151116" xml-lang="en-US">Icon Zoom In</alt></image></paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US">Zoom In</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/02/10060000.xhp b/helpcontent2/source/text/scalc/02/10060000.xhp new file mode 100644 index 0000000000..03007b5705 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/10060000.xhp @@ -0,0 +1,58 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> +<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> +</history> +</meta> +<body> +<section id="zoom_out"> +<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"/> +<h1 id="hd_id3153561"><variable id="h1"><link href="text/scalc/02/10060000.xhp">Zoom Out</link></variable></h1> +<paragraph role="paragraph" id="par_id3151246" xml-lang="en-US"><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_id71678262942683" xml-lang="en-US"> + <image src="media/helpimg/scalc/calczoomslider.png" id="img_id721678262942684" width="282px" height="40px"><alt xml-lang="en-US" id="alt_id461678262942685">Calc Zoom Slider</alt></image> + </paragraph> +<paragraph role="paragraph" id="par_id3150398" xml-lang="en-US">The minimum zoom factor is 20%.</paragraph> +<section id="syzoom_out"> +<table id="tbl_id3125863"> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US"> +<image id="img_id3155131" src="cmd/lc_zoomout.svg" width="1cm" height="1cm"><alt id="alt_id3155131" xml-lang="en-US">Icon</alt> + </image></paragraph> +</tablecell> +<tablecell> +<paragraph role="paragraph" id="par_id3150440" xml-lang="en-US">Zooming Out</paragraph> +</tablecell> +</tablerow> +</table> + +</section> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/02/18010000.xhp b/helpcontent2/source/text/scalc/02/18010000.xhp new file mode 100644 index 0000000000..3754fbf1de --- /dev/null +++ b/helpcontent2/source/text/scalc/02/18010000.xhp @@ -0,0 +1,75 @@ +<?xml version="1.0" encoding="UTF-8"?> + + + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + + + <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="insert"> +<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"/> +<h1 id="hd_id3156329"><link href="text/scalc/02/18010000.xhp">Insert</link></h1> +<paragraph role="paragraph" id="par_id3147336" xml-lang="en-US"><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">Tools bar icon:</paragraph> +<section id="syinsert"> +<table id="tbl_id3154365"> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US"> +<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">Insert</paragraph> +</tablecell> +</tablerow> +</table> +</section> +<paragraph role="paragraph" id="par_id3153188" xml-lang="en-US">You can select the following icons:</paragraph> +<h2 id="hd_id4283883"><link href="text/shared/01/04160500.xhp">Floating Frame</link></h2> +<embed href="text/shared/01/04160500.xhp#frameeinfuegentext"/> +<embed href="text/shared/00/00000404.xhp#syframe"/> +<h2 id="hd_id3149410"><link href="text/shared/01/04100000.xhp">Special Character</link></h2> +<embed href="text/shared/01/04100000.xhp#sonder"/> +<embed href="text/shared/00/00000404.xhp#syspecial_char"/> +<h2 id="hd_id3151117"><link href="text/shared/01/04140000.xhp">From File</link></h2> +<embed href="text/shared/01/04140000.xhp#grafiktext"/> +<embed href="text/shared/00/00000404.xhp#syimage"/> +<embed href="text/shared/01/moviesound.xhp#moviesound"/> +<embed href="text/shared/00/00000404.xhp#symoviesound"/> +<h2 id="hd_id3633533"><link href="text/shared/01/04160300.xhp">Formula</link></h2> +<embed href="text/shared/01/04160300.xhp#starmath"/> +<embed href="text/shared/00/00000404.xhp#systarmath"/> +<h2 id="par_idN10769"><link href="text/schart/01/wiz_chart_type.xhp">Chart</link></h2> +<embed href="text/shared/00/00000404.xhp#systarchart"/> +<h2 id="hd_id7581408"><link href="text/shared/01/04150100.xhp">OLE Object</link></h2> +<embed href="text/shared/01/04150100.xhp#ole"/> +<embed href="text/shared/00/00000404.xhp#syole"/> +</body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/02/18020000.xhp b/helpcontent2/source/text/scalc/02/18020000.xhp new file mode 100644 index 0000000000..7aa65c9839 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/18020000.xhp @@ -0,0 +1,56 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + +<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> +</history> +</meta> +<body> +<section id="insert_cells"> +<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_id3156329" localize="false"/> +<h1 id="hd_id3150275"><link href="text/scalc/02/18020000.xhp">Insert Cells</link></h1> +<paragraph role="paragraph" id="par_id3156024" xml-lang="en-US"><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">Tools bar icon:</paragraph> +<embed href="text/scalc/00/00000404.xhp#syinsert_cells"/> +<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US">You can select the following icons:</paragraph> +<h2 id="hd_id3150439"><link href="text/scalc/01/04020000.xhp">Insert Cells Down</link></h2> +<embed href="text/scalc/01/04020000.xhp#zellenuntentext"/> +<embed href="text/scalc/00/00000404.xhp#syinsert_cells_down"/> +<h2 id="hd_id3146119"><link href="text/scalc/01/04020000.xhp">Insert Cells Right</link></h2> +<embed href="text/scalc/01/04020000.xhp#zellenrechtstext"/> +<embed href="text/scalc/00/00000404.xhp#syinsert_cells_right"/> +<h2 id="hd_id3153190"><link href="text/scalc/01/04020000.xhp">Rows</link></h2> +<embed href="text/scalc/01/04020000.xhp#zeilenganzetext"/> +<embed href="text/scalc/00/00000404.xhp#syinsert_rows"/> +<h2 id="hd_id3153726"><link href="text/scalc/01/04020000.xhp">Columns</link></h2> +<embed href="text/scalc/01/04020000.xhp#spaltenganzetext"/> +<embed href="text/scalc/00/00000404.xhp#syinsert_columns"/> +</body> +</helpdocument> |