"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-12-20 08:16+0100\n"

"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.8\n"

#: personalization.hrc:31

msgctxt "RID_SVXSTR_PERSONA_CATEGORIES"

#: strings.hrc:348

msgctxt "RID_SVXSTR_BOLD_UNDER"

msgid "Automatic *bold*, /italic/, -strikeout- and _underline_"

#: strings.hrc:349

msgctxt "RID_SVXSTR_NO_DBL_SPACES"

#: strings.hrc:365

msgctxt "RID_SVXSTR_CONNECTOR"

msgid "Connector"

#: strings.hrc:366

msgctxt "RID_SVXSTR_DIMENSION_LINE"

msgid "Dimension line"

#: strings.hrc:367

msgctxt "RID_SVXSTR_LOAD_ERROR"

#: asiantypography.ui:79

msgctxt "asiantypography|labelLineChange"

msgid "Line Change"

#: assigncomponentdialog.ui:10

msgctxt "assigncomponentdialog|AssignComponent"

#: cellalignment.ui:40

msgctxt "cellalignment|liststoreHorzAlign"

msgid "Justified"

#: cellalignment.ui:44

msgctxt "cellalignment|liststoreHorzAlign"

#: cellalignment.ui:78

msgctxt "cellalignment|liststoreVertAlign"

msgid "Justified"

#: cellalignment.ui:82

msgctxt "cellalignment|liststoreVertAlign"

#: connectortabpage.ui:318

msgctxt "connectortabpage|label3"

msgid "Line Spacing"

#: connectortabpage.ui:342

msgctxt "connectortabpage|CTL_PREVIEW|tooltip_text"

#: pageformatpage.ui:566

msgctxt "pageformatpage|checkRegisterTrue"

msgid "Register-tr_ue"

#: pageformatpage.ui:606

msgctxt "pageformatpage|labelTblAlign"

#: paragalignpage.ui:27

msgctxt "paragalignpage|liststoreLB_LASTLINE"

msgid "Justified"

#: paragalignpage.ui:41

msgctxt "paragalignpage|liststoreLB_VERTALIGN"

#: paragalignpage.ui:169

msgctxt "paragalignpage|radioBTN_JUSTIFYALIGN"

msgid "_Justified"

#: paragalignpage.ui:185

msgctxt "paragalignpage|checkCB_EXPAND"

msgid "_Expand single word"

#: paragalignpage.ui:202

msgctxt "paragalignpage|checkCB_SNAP"

#: paraindentspacing.ui:464

msgctxt "paraindentspacing|labelFL_PROPERTIES"

msgid "Line Spacing"

#: paraindentspacing.ui:489

msgctxt "paraindentspacing|checkCB_REGISTER"

#: paraindentspacing.ui:503

msgctxt "paraindentspacing|label3"

msgid "Register-true"

#: paratabspage.ui:49

msgctxt "paratabspage|label1"

#: textflowpage.ui:391

msgctxt "textflowpage|checkKeepPara"

msgid "_Keep with next paragraph"

#: textflowpage.ui:407

msgctxt "textflowpage|checkOrphan"

msgid "_Orphan control"

#: textflowpage.ui:423

msgctxt "textflowpage|checkWidow"

msgid "_Widow control"

#: textflowpage.ui:473

msgctxt "textflowpage|labelOrphan"

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-10-04 11:48+0200\n"

"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.8\n"

#: spellmenu.ui:12

msgctxt "spellmenu|ignore"

#: editrids.hrc:61

msgctxt "RID_SVXITEMS_ITALIC_NONE"

msgid "Not Italic"

#: editrids.hrc:62

msgctxt "RID_SVXITEMS_ITALIC_OBLIQUE"

msgid "Oblique italic"

#: editrids.hrc:63

msgctxt "RID_SVXITEMS_ITALIC_NORMAL"

msgid "Italic"

#. enum FontWeight -------------------------------------------------------

#: editrids.hrc:66

#: editrids.hrc:145

msgctxt "RID_SVXITEMS_ADJUST_BLOCK"

msgid "Justify"

#: editrids.hrc:146

msgctxt "RID_SVXITEMS_ADJUST_CENTER"

#: editrids.hrc:147

msgctxt "RID_SVXITEMS_ADJUST_BLOCKLINE"

msgid "Justify"

#: editrids.hrc:148

msgctxt "RID_SOLID"

#: editrids.hrc:188

msgctxt "RID_SVXITEMS_FMTKEEP_TRUE"

msgid "Keep with next paragraph"

#: editrids.hrc:189

msgctxt "RID_SVXITEMS_FMTKEEP_FALSE"

#: editrids.hrc:221

msgctxt "RID_SVXITEMS_WIDOWS_COMPLETE"

msgid "Widow control"

#: editrids.hrc:222

msgctxt "RID_SVXITEMS_ORPHANS_COMPLETE"

msgid "Orphan control"

#: editrids.hrc:223

msgctxt "RID_SVXITEMS_HYPHEN_MINLEAD"

#: editrids.hrc:277

msgctxt "RID_SVXITEMS_HORJUST_BLOCK"

msgid "Justify"

#: editrids.hrc:278

msgctxt "RID_SVXITEMS_HORJUST_REPEAT"

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-11-22 13:53+0100\n"

"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.8\n"

#: command.hrc:29

msgctxt "RID_RSC_ENUM_COMMAND_TYPE"

#: strings.hrc:238

msgctxt "RID_STR_FONTSTYLE_BOLD_ITALIC"

msgid "Bold Italic"

#. To translators: That's the 'Italic' as used for a font style, so please use a consistent translation.

#: strings.hrc:240

msgctxt "RID_STR_FONTSTYLE_ITALIC"

msgid "Italic"

#. To translators: That's the 'Bold' as used for a font style, so please use a consistent translation."

#: strings.hrc:242

#: generalpage.ui:97

msgctxt "generalpage|chapter"

msgid "_Chapter"

#: generalpage.ui:113

msgctxt "generalpage|title"

#: mappingdialog.ui:152

msgctxt "mappingdialog|label5"

msgid "_Chapter"

#: mappingdialog.ui:167

msgctxt "mappingdialog|label6"

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-10-04 11:48+0200\n"

"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.8\n"

#: strings.hrc:25

msgctxt "STR_MENU_HEADFOOTALL"

#: strings.hrc:50

msgctxt "STR_LANGSTATUS_NONE"

msgid "None (Do not check spelling)"

#: strings.hrc:51

msgctxt "STR_RESET_TO_DEFAULT_LANGUAGE"

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-10-04 11:48+0200\n"

"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.8\n"

#: sbasic.tree

msgctxt ""

"0207\n"

"node.text"

msgid "Sections and Frames in Text Documents"

#: swriter.tree

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-12-18 12:31+0100\n"

"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.8\n"

#: 00000002.xhp

msgctxt ""

"par_id3153381\n"

"help.text"

msgid "You can set the locale used for controlling the formatting numbers, dates and currencies in $[officename] Basic in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Language Settings - Languages</emph>. In Basic format codes, the decimal point (<emph>.</emph>) is always used as <emph>placeholder</emph> for the decimal separator defined in your locale and will be replaced by the corresponding character."

#: 00000003.xhp

msgctxt ""

"par_id3152576\n"

"help.text"

msgid "Choose <emph>Tools - Macros - Organize Macros - %PRODUCTNAME Basic</emph> and click <emph>Organizer</emph> or click the <emph>Select Module</emph> icon in the Basic IDE to open the <emph>Macro Organizer</emph> dialog."

#: 01030400.xhp

msgctxt ""

"par_id3153157\n"

"help.text"

msgid "Choose <emph>Tools - Macros - Organize Macros - %PRODUCTNAME Basic</emph> and click <emph>Organizer</emph> or click the <emph>Select Module</emph> icon in the Basic IDE to open the <emph>Macro Organizer</emph> dialog."

#: 01030400.xhp

msgctxt ""

"par_id3147005\n"

"help.text"

msgid "Choose <emph>Tools - Macros - Organize Macros - %PRODUCTNAME Basic</emph> and click <emph>Organizer</emph> or click the <emph>Select Module</emph> icon in the Basic IDE to open the <emph>Macro Organizer</emph> dialog."

#: 01030400.xhp

msgctxt ""

"par_id3150086\n"

"help.text"

msgid "Choose <emph>Tools - Macros - Organize Macros - %PRODUCTNAME Basic</emph> and click <emph>Organizer</emph> or click the <emph>Select Module</emph> icon in the Basic IDE to open the <emph>Macro Organizer</emph> dialog."

#: 01030400.xhp

msgctxt ""

"par_id3154537\n"

"help.text"

msgid "Choose <emph>Tools - Macros - Organize Macros - %PRODUCTNAME Basic</emph> and click <emph>Organizer</emph> or click the <emph>Select Module</emph> icon in the Basic IDE to open the <emph>Macro Organizer</emph> dialog."

#: 01030400.xhp

msgctxt ""

"par_id3159230\n"

"help.text"

msgid "Choose <emph>Tools - Macros - Organize Macros - %PRODUCTNAME Basic</emph> and click <emph>Organizer</emph> or click the <emph>Select Module</emph> icon in the Basic IDE to open the <emph>Macro Organizer</emph> dialog."

#: 01030400.xhp

msgctxt ""

"par_id3147547\n"

"help.text"

msgid "Choose <emph>Tools - Macros - Organize Macros - %PRODUCTNAME Basic</emph> and click <emph>Organizer</emph> or click the <emph>Select Module</emph> icon in the Basic IDE to open the <emph>Macro Organizer</emph> dialog."

#: 01030400.xhp

msgctxt ""

"par_id3149319\n"

"help.text"

msgid "Choose <emph>Tools - Macros - Organize Macros - %PRODUCTNAME Basic</emph> and click <emph>Organizer</emph> or click the <emph>Select Module</emph> icon in the Basic IDE to open the <emph>Macro Organizer</emph> dialog."

#: 01030400.xhp

msgctxt ""

"par_id3146971\n"

"help.text"

msgid "Inserts a line break in multiline fields."

#: 01170100.xhp

msgctxt ""

"par_id3146816\n"

"help.text"

msgid "You can create multi-line <emph>labels</emph> by inserting manual line breaks in the label using <emph>Shift+Enter</emph>."

#: 01170101.xhp

msgctxt ""

"hd_id3149015\n"

"help.text"

msgid "Manual line break"

#: 01170101.xhp

msgctxt ""

"par_id3149893\n"

"help.text"

msgid "<ahelp hid=\".\">Select \"Yes\" to allow manual line breaks inside multiline controls.</ahelp>"

#: 01170101.xhp

msgctxt ""

"par_id3144741\n"

"help.text"

msgid "<ahelp hid=\".\">Select \"Yes\" to allow the input of multiple lines in the control. Press Enter to insert a manual line break in the control.</ahelp>"

#: 01170101.xhp

msgctxt ""

"par_id3148798\n"

"help.text"

msgid "<emph>Text</emph>: String expression displayed as a message in the dialog box. Line breaks can be inserted with Chr$(13)."

#: 03010101.xhp

msgctxt ""

"par_id3153727\n"

"help.text"

msgid "<emph>Text</emph>: String expression displayed as a message in the dialog box. Line breaks can be inserted with Chr$(13)."

#: 03010102.xhp

msgctxt ""

"par_id3154011\n"

"help.text"

msgid "If the expression to be printed exceeds a certain length, the display will automatically wrap to the next line."

#: 03010103.xhp

msgctxt ""

"par_id3153158\n"

"help.text"

msgid "Put #iNumber,, \"This is the first line of text\" ' Fill line with text"

#: 03020201.xhp

msgctxt ""

"par_id3159153\n"

"help.text"

msgid "The <emph>Input#</emph> statement reads numeric values or strings from an open file and assigns the data to one or more variables. A numeric variable is read up to the first carriage return (Asc=13), line feed (Asc=10), space, or comma. String variables are read to up to the first carriage return (Asc=13), line feed (Asc=10), or comma."

#: 03020202.xhp

msgctxt ""

"par_id3150010\n"

"help.text"

msgid "With the <emph>Line Input#</emph> statement, you can read strings from an open file into a variable. String variables are read line-by-line up to the first carriage return (Asc=13) or linefeed (Asc=10). Line end marks are not included in the resulting string."

#: 03020203.xhp

msgctxt ""

"par_id3153711\n"

"help.text"

msgid "Put #iNumber,, \"This is the first line of text\" ' Fill line with text"

#: 03020204.xhp

msgctxt ""

"par_id3148405\n"

"help.text"

msgid "Put #iNumber,, \"This is the first line of text\" REM Fill with text"

#: 03020303.xhp

msgctxt ""

"par_id3151074\n"

"help.text"

msgid "The following example uses two nested loops to sort a string array with 10 elements ( sEntry() ), that are first filled with various contents:"

#: 03090202.xhp

msgctxt ""

"par_id3152939\n"

"help.text"

msgid "For siStep = 0 To 10 ' Fill array with test data"

#: 03090406.xhp

msgctxt ""

"par_id3153158\n"

"help.text"

msgid "For siStep = 0 To 10 ' Fill array with test data"

#: 03090412.xhp

msgctxt ""

"par_id3153748\n"

"help.text"

msgid "<ahelp hid=\".\">Choose the macro that you want to execute when the selected graphic, frame, or OLE object is selected.</ahelp> Depending on the object that is selected, the function is either found on the <emph>Macro</emph> tab of the <emph>Object</emph> dialog, or in the <emph>Assign Macro</emph> dialog."

#: 05060700.xhp

msgctxt ""

"par_id3151131\n"

"help.text"

msgid "Nonprinting characters are entered from the keyboard, for example, tabs and line breaks."

#: 05060700.xhp

msgctxt ""

"par_id3147296\n"

"help.text"

msgid "Frames allow you to link events to a function, so that the function can determine if it processes the event or $[officename] Writer."

#: 05060700.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-05-09 16:45+0200\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"MIME-Version: 1.0\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

#: 06130000.xhp

msgctxt ""

"hd_id3153764\n"

"help.text"

msgid "Organizer"

#: 06130000.xhp

msgctxt ""

"par_id3148405\n"

"help.text"

msgid "<ahelp hid=\"modules/BasicIDE/ui/basicmacrodialog/organize\">Opens the <emph>Macro Organizer</emph> dialog, where you can add, edit, or delete existing macro modules, dialogs, and libraries.</ahelp>"

#: 06130000.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-05-12 14:35+0200\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"MIME-Version: 1.0\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

#: 11010000.xhp

msgctxt ""

"par_id3156414\n"

"help.text"

msgid "<ahelp visibility=\"visible\" hid=\".uno:ModuleDialog\">Click here to open the <link href=\"text/sbasic/shared/01/06130000.xhp\" name=\"Macro Organizer\"><emph>Macro Organizer</emph></link> dialog.</ahelp>"

#: 11110000.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-05-09 16:45+0200\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"MIME-Version: 1.0\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

#: main0000.xhp

msgctxt ""

"hd_id3147003\n"

"help.text"

msgid "<link href=\"text/shared/01/04160500.xhp\" name=\"Floating Frame\">Floating Frame</link>"

#: main0105.xhp

msgctxt ""

"hd_id3150400\n"

"help.text"

msgid "<link href=\"text/scalc/01/12010000.xhp\" name=\"Define Range\">Define Range</link>"

#: main0112.xhp

msgctxt ""

"hd_id3125863\n"

"help.text"

msgid "<link href=\"text/scalc/01/12020000.xhp\" name=\"Select Range\">Select Range</link>"

#: main0112.xhp

msgctxt ""

"hd_id3154754\n"

"help.text"

msgid "<link href=\"text/scalc/01/12100000.xhp\" name=\"Refresh Range\">Refresh Range</link>"

#: main0116.xhp

msgctxt ""

"hd_id3154703\n"

"help.text"

msgid "<link href=\"text/shared/01/05340300.xhp\" name=\"Justify\">Justify</link>"

#: main0202.xhp

msgctxt ""

"hd_id3147338\n"

"help.text"

msgid "<link href=\"text/shared/01/05210100.xhp\" name=\"Background Color\">Background Color</link>"

#: main0205.xhp

msgctxt ""

"par_id3151112\n"

"help.text"

msgid "<ahelp hid=\"HID_SC_TOOLBOX_DRTEXT\">The <emph>Text Formatting</emph> Bar that is displayed when the cursor is in a text object, such as a text frame or a drawing object, contains formatting and alignment commands.</ahelp>"

#: main0205.xhp

msgctxt ""

"hd_id3155115\n"

"help.text"

msgid "<link href=\"text/shared/01/05030700.xhp\" name=\"Justify\">Justify</link>"

#: main0205.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-11-22 13:53+0100\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"MIME-Version: 1.0\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

#: 00000004.xhp

msgctxt ""

"par_id3143267\n"

"help.text"

msgid "<variable id=\"bausunten\">Choose <emph>Sheet - Fill Cells - Down</emph></variable>"

#: 00000402.xhp

msgctxt ""

"par_id3153880\n"

"help.text"

msgid "<variable id=\"bausrechts\">Choose <emph>Sheet - Fill Cells - Right</emph></variable>"

#: 00000402.xhp

msgctxt ""

"par_id3151245\n"

"help.text"

msgid "<variable id=\"bausoben\">Choose <emph>Sheet - Fill Cells - Up</emph></variable>"

#: 00000402.xhp

msgctxt ""

"par_id3145068\n"

"help.text"

msgid "<variable id=\"bauslinks\">Choose <emph>Sheet - Fill Cells - Left</emph></variable>"

#: 00000402.xhp

msgctxt ""

"par_id3154910\n"

"help.text"

msgid "<variable id=\"bausreihe\">Choose <emph>Sheet - Fill Cells - Series</emph></variable>"

#: 00000402.xhp

msgctxt ""

"par_id3147399\n"

"help.text"

msgid "<variable id=\"dbrbf\">Choose <emph>Data - Define Range</emph></variable>"

#: 00000412.xhp

msgctxt ""

"par_id3145345\n"

"help.text"

msgid "<variable id=\"dbrba\">Choose <emph>Data - Select Range</emph></variable>"

#: 00000412.xhp

msgctxt ""

"par_id3150397\n"

"help.text"

msgid "<variable id=\"dndakt\">Choose <emph>Data - Refresh Range</emph></variable>"

#: 00000412.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-12-18 12:32+0100\n"

"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

#: 01120000.xhp

msgctxt ""

"hd_id3150717\n"

"help.text"

msgid "Data Range"

#: 02110000.xhp

msgctxt ""

"par_id3146919\n"

"help.text"

msgid "Data Range"

#: 02110000.xhp

msgctxt ""

"hd_id3145748\n"

"help.text"

msgid "Left Area"

#: 02120100.xhp

msgctxt ""

"hd_id3148648\n"

"help.text"

msgid "Center Area"

#: 02120100.xhp

msgctxt ""

"hd_id3154942\n"

"help.text"

msgid "Right Area"

#: 02120100.xhp

msgctxt ""

"par_id3150206\n"

"help.text"

msgid "<ahelp hid=\"modules/scalc/ui/headerfootercontent/buttonBTN_FILE\">Inserts a file name placeholder in the selected area.</ahelp> Click to insert the title. Long-click to select either title, file name or path/file name from the submenu. If a title has not be assigned (see <emph>File - Properties</emph>), the file name will be inserted instead."

#: 02120100.xhp

msgctxt ""

"par_id3148842\n"

"help.text"

msgid "<ahelp hid=\"modules/scalc/ui/headerfootercontent/buttonBTN_TABLE\">Inserts a placeholder in the selected header/footer area, which is replaced by the sheet name in the header/footer of the actual document.</ahelp>"

#: 02120100.xhp

msgctxt ""

"par_id3154960\n"

"help.text"

msgid "<ahelp hid=\"modules/scalc/ui/headerfootercontent/buttonBTN_PAGE\">Inserts a placeholder in the selected header/footer area, which is replaced by page numbering. This allows continuous page numbering in a document.</ahelp>"

#: 02120100.xhp

msgctxt ""

"par_id3153812\n"

"help.text"

msgid "<ahelp hid=\"modules/scalc/ui/headerfootercontent/buttonBTN_PAGES\">Inserts a placeholder in the selected header/footer area, which is replaced by the total number of pages in the document.</ahelp>"

#: 02120100.xhp

msgctxt ""

"par_id3153960\n"

"help.text"

msgid "<ahelp hid=\"modules/scalc/ui/headerfootercontent/buttonBTN_DATE\">Inserts a placeholder in the selected header/footer area, which is replaced by the current date which will be repeated in the header/footer on each page of the document.</ahelp>"

#: 02120100.xhp

msgctxt ""

"par_id3145638\n"

"help.text"

msgid "<ahelp hid=\"modules/scalc/ui/headerfootercontent/buttonBTN_TIME\">Inserts a placeholder in the selected header/footer area, which is replaced by the current time in the header/footer on each page of the document.</ahelp>"

#: 02120100.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Fill"

#: 02140000.xhp

msgctxt ""

"bm_id8473769\n"

"help.text"

msgid "<bookmark_value>filling;selection lists</bookmark_value> <bookmark_value>selection lists;filling cells</bookmark_value>"

#: 02140000.xhp

msgctxt ""

"hd_id3153876\n"

"help.text"

msgid "<link href=\"text/scalc/01/02140000.xhp\" name=\"Fill\">Fill</link>"

#: 02140000.xhp

msgctxt ""

"par_id3156285\n"

"help.text"

msgid "<ahelp hid=\".\">Automatically fills cells with content.</ahelp>"

#: 02140000.xhp

msgctxt ""

"par_id3147343\n"

"help.text"

msgid "The $[officename] Calc context menus have <link href=\"text/scalc/01/02140000.xhp\" name=\"other options\">additional options</link> for filling the cells."

#: 02140000.xhp

msgctxt ""

"par_id3152994\n"

"help.text"

msgid "<emph>Filling cells using context menus:</emph>"

#: 02140000.xhp

msgctxt ""

"par_id3153969\n"

"help.text"

msgid "<ahelp hid=\".uno:FillDown\" visibility=\"visible\">Fills a selected range of at least two rows with the contents of the top cell of the range.</ahelp>"

#: 02140100.xhp

msgctxt ""

"par_id3153361\n"

"help.text"

msgid "<ahelp hid=\".uno:FillRight\" visibility=\"visible\">Fills a selected range of at least two columns with the contents of the left most cell.</ahelp>"

#: 02140200.xhp

msgctxt ""

"par_id3150793\n"

"help.text"

msgid "<ahelp hid=\".uno:FillUp\" visibility=\"visible\">Fills a selected range of at least two rows with the contents of the bottom most cell.</ahelp>"

#: 02140300.xhp

msgctxt ""

"par_id3150447\n"

"help.text"

msgid "If a selected range has only one column, the content of the bottom most cell is copied into the selected cells. If several columns are selected, the contents of the bottom most cells are copied into those selected above."

#: 02140400.xhp

msgctxt ""

"par_id3150793\n"

"help.text"

msgid "<ahelp hid=\".uno:FillLeft\" visibility=\"visible\">Fills a selected range of at least two columns with the contents of the far right cell.</ahelp>"

#: 02140400.xhp

msgctxt ""

"hd_id3155131\n"

"help.text"

msgid "Filling a Sheet"

#: 02140500.xhp

msgctxt ""

"par_id3146119\n"

"help.text"

msgid "Select the entire sheet by clicking the empty gray box in the upper left of the sheet. You can also select an area of the sheet to be copied."

#: 02140500.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Fill Series"

#: 02140600.xhp

msgctxt ""

"hd_id3148664\n"

"help.text"

msgid "Fill Series"

#: 02140600.xhp

msgctxt ""

"par_id3146976\n"

"help.text"

msgid "Before filling a series, first select the cell range."

#: 02140600.xhp

msgctxt ""

"par_id3149257\n"

"help.text"

msgid "Defines the series type. Choose between <emph>Linear, Growth, Date </emph>and <emph>AutoFill</emph>."

#: 02140600.xhp

msgctxt ""

"hd_id3150300\n"

"help.text"

msgid "Comments"

#: 02150000.xhp

msgctxt ""

"par_id3154658\n"

"help.text"

msgid "<ahelp hid=\"modules/scalc/ui/deletecontents/comments\">Deletes comments added to cells. All other elements remain unchanged.</ahelp>"

#: 02150000.xhp

msgctxt ""

"par_id3154490\n"

"help.text"

msgid "<variable id=\"zellenloeschentext\"><ahelp hid=\".uno:DeleteCell\">Completely deletes selected cells, columns or rows. The cells below or to the right of the deleted cells will fill the space.</ahelp></variable> Note that the selected delete option is stored and reloaded when the dialog is next called."

#: 02160000.xhp

msgctxt ""

"par_id3153714\n"

"help.text"

msgid "<ahelp hid=\"modules/scalc/ui/deletecells/up\">Fills the space produced by the deleted cells with the cells underneath it.</ahelp>"

#: 02160000.xhp

msgctxt ""

"par_id3154702\n"

"help.text"

msgid "<ahelp hid=\"modules/scalc/ui/deletecells/left\">Fills the resulting space by the cells to the right of the deleted cells.</ahelp>"

#: 02160000.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Delete Page Break"

#: 02190000.xhp

msgctxt ""

"hd_id3150541\n"

"help.text"

msgid "<link href=\"text/scalc/01/02190000.xhp\" name=\"Delete Page Break\">Delete Page Break</link>"

#: 02190000.xhp

msgctxt ""

"par_id3154365\n"

"help.text"

msgid "<ahelp hid=\".\">Choose the type of page break that you want to delete.</ahelp>"

#: 02190100.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Row Break"

#: 02190100.xhp

msgctxt ""

"bm_id3156326\n"

"help.text"

msgid "<bookmark_value>spreadsheets; deleting row breaks</bookmark_value><bookmark_value>deleting;manual row breaks</bookmark_value><bookmark_value>row breaks; deleting</bookmark_value>"

#: 02190100.xhp

msgctxt ""

"hd_id3156326\n"

"help.text"

msgid "<link href=\"text/scalc/01/02190100.xhp\" name=\"Row Break\">Row Break</link>"

#: 02190100.xhp

msgctxt ""

"par_id3154366\n"

"help.text"

msgid "<ahelp hid=\".uno:DeleteRowbreak\">Removes the manual row break above the active cell.</ahelp>"

#: 02190100.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Column Break"

#: 02190200.xhp

msgctxt ""

"bm_id3151384\n"

"help.text"

msgid "<bookmark_value>spreadsheets;deleting column breaks</bookmark_value><bookmark_value>deleting;manual column breaks</bookmark_value><bookmark_value>column breaks;deleting</bookmark_value>"

#: 02190200.xhp

msgctxt ""

"hd_id3151384\n"

"help.text"

msgid "<link href=\"text/scalc/01/02190200.xhp\" name=\"Column Break\">Column Break</link>"

#: 02190200.xhp

msgctxt ""

"par_id3154124\n"

"help.text"

msgid "<ahelp hid=\".uno:DeleteColumnbreak\">Removes a manual column break to the left of the active cell.</ahelp>"

#: 02190200.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Value Highlighting"

#: 03080000.xhp

msgctxt ""

"bm_id3151384\n"

"help.text"

msgid "<bookmark_value>spreadsheets; value highlighting</bookmark_value> <bookmark_value>values;highlighting</bookmark_value> <bookmark_value>highlighting; values in sheets</bookmark_value> <bookmark_value>colors;values</bookmark_value>"

#: 03080000.xhp

msgctxt ""

"hd_id3151384\n"

"help.text"

msgid "<link href=\"text/scalc/01/03080000.xhp\" name=\"Value Highlighting\">Value Highlighting</link>"

#: 03080000.xhp

msgctxt ""

"par_id3154366\n"

"help.text"

msgid "<ahelp hid=\".\">Displays cell contents in different colors, depending on type.</ahelp>"

#: 03080000.xhp

msgctxt ""

"par_id3125863\n"

"help.text"

msgid "To remove the highlighting, unmark the menu entry."

#: 03080000.xhp

msgctxt ""

"par_id3149400\n"

"help.text"

msgid "<ahelp hid=\".\">Deletes all manual breaks in the current sheet.</ahelp>"

#: 03100000.xhp

msgctxt ""

"par_id3125864\n"

"help.text"

msgid "<ahelp hid=\".\">This command inserts manual row or column breaks to ensure that your data prints properly. You can insert a horizontal page break above, or a vertical page break to the left of, the active cell.</ahelp>"

#: 04010000.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Row Break"

#: 04010100.xhp

msgctxt ""

"bm_id3153821\n"

"help.text"

msgid "<bookmark_value>sheets; inserting row breaks</bookmark_value><bookmark_value>row breaks; inserting</bookmark_value><bookmark_value>inserting; manual row breaks</bookmark_value><bookmark_value>manual row breaks</bookmark_value>"

#: 04010100.xhp

msgctxt ""

"hd_id3153821\n"

"help.text"

msgid "<link href=\"text/scalc/01/04010100.xhp\" name=\"Row Break\">Row Break</link>"

#: 04010100.xhp

msgctxt ""

"par_id3149656\n"

"help.text"

msgid "<ahelp hid=\".uno:InsertRowBreak\">Inserts a row break (horizontal page break) above the selected cell.</ahelp>"

#: 04010100.xhp

msgctxt ""

"par_id3156422\n"

"help.text"

msgid "The manual row break is indicated by a dark blue horizontal line."

#: 04010200.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Column Break"

#: 04010200.xhp

msgctxt ""

"bm_id3155923\n"

"help.text"

msgid "<bookmark_value>spreadsheets; inserting column breaks</bookmark_value><bookmark_value>column breaks; inserting</bookmark_value><bookmark_value>inserting; manual column breaks</bookmark_value><bookmark_value>manual column breaks</bookmark_value>"

#: 04010200.xhp

msgctxt ""

"hd_id3155923\n"

"help.text"

msgid "<link href=\"text/scalc/01/04010200.xhp\" name=\"Column Break\">Column Break</link>"

#: 04010200.xhp

msgctxt ""

"par_id3150447\n"

"help.text"

msgid "<ahelp hid=\".uno:InsertColumnBreak\">Inserts a column break (vertical page break) to the left of the active cell.</ahelp>"

#: 04010200.xhp

msgctxt ""

"par_id3145171\n"

"help.text"

msgid "The manual column break is indicated by a dark blue vertical line."

#: 04020000.xhp

msgctxt ""

"par_id3148886\n"

"help.text"

msgid "Blue dots denote correctly entered arguments. Red dots indicate incorrect data types. For example: if the SUM function has one argument entered as text, this is highlighted in red as SUM only permits number entries."

#: 04060100.xhp

msgctxt ""

"par_id3149453\n"

"help.text"

msgid "<emph>Database</emph> is the cell range defining the database."

#: 04060101.xhp

msgctxt ""

"par_id3156090\n"

"help.text"

msgid "<emph>Reference</emph> (list of options) is the position of the cell to be examined. If <emph>Reference</emph> is a range, the cell moves to the top left of the range. If <emph>Reference</emph> is missing, $[officename] Calc uses the position of the cell in which this formula is located. Microsoft Excel uses the reference of the cell in which the cursor is positioned."

#: 04060105.xhp

msgctxt ""

"par_id3143606\n"

"help.text"

msgid "<emph>Range</emph> is the range whose cells are included."

#: 04060106.xhp

msgctxt ""

"par_id3154298\n"

"help.text"

msgid "<variable id=\"wasmatrix\">An array is a linked range of cells on a spreadsheet containing values.</variable> A square range of 3 rows and 3 columns is a 3 x 3 array:"

#: 04060107.xhp

msgctxt ""

"par_id3149787\n"

"help.text"

msgid "Use array formulas if you have to repeat calculations using different values. If you decide to change the calculation method later, you only have to update the array formula. To add an array formula, select the entire array range and then <link href=\"text/scalc/01/04060107.xhp\" name=\"make the required change to the array formula\">make the required change to the array formula</link>."

#: 04060107.xhp

msgctxt ""

"par_id3152876\n"

"help.text"

msgid "You can also create a \"normal\" formula in which the reference range, such as parameters, indicate an array formula. The result is obtained from the intersection of the reference range and the rows or columns in which the formula is found. If there is no intersection or if the range at the intersection covers several rows or columns, a #VALUE! error message appears. The following example illustrates this concept:"

#: 04060107.xhp

msgctxt ""

"par_idN10D4E\n"

"help.text"

msgid "In the following example, the >0 test of the {=IF(A1:A3>0;\"yes\";\"no\")} formula is applied to each cell in the range A1:A3 and the result is copied to the corresponding cell."

#: 04060107.xhp

msgctxt ""

"par_id3154073\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_MDET\">Returns the array determinant of an array.</ahelp> This function returns a value in the current cell; it is not necessary to define a range for the results."

#: 04060107.xhp

msgctxt ""

"par_id3158084\n"

"help.text"

msgid "As soon as you click <emph>OK</emph>, $[officename] Calc will fill the above example with the LINEST values as shown in the example."

#: 04060107.xhp

msgctxt ""

"par_id3150036\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_BEREICHE\">Returns the number of individual ranges that belong to a multiple range.</ahelp> A range can consist of contiguous cells or a single cell."

#: 04060109.xhp

msgctxt ""

"par_id3153118\n"

"help.text"

msgid "Reference represents the reference to a cell or cell range."

#: 04060109.xhp

msgctxt ""

"par_id3149434\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_DDE\">Returns the result of a DDE-based link.</ahelp> If the contents of the linked range or section changes, the returned value will also change. You must reload the spreadsheet or choose <emph>Edit - Links</emph> to see the updated links. Cross-platform links, for example from a <item type=\"productname\">%PRODUCTNAME</item> installation running on a Windows machine to a document created on a Linux machine, are not allowed."

#: 04060109.xhp

msgctxt ""

"par_id0907200910283297\n"

"help.text"

msgid "=\"abc\" & CHAR(10) & \"def\" inserts a newline character into the string."

#: 04060110.xhp

msgctxt ""

"par_id3148750\n"

"help.text"

msgid "Output: Pointer to an array of exactly 16 variables of type Paramtype. The first nParamCount entries are filled with the suitable type of parameter."

#: 04060112.xhp

msgctxt ""

"hd_id3145750\n"

"help.text"

msgid "Comments"

#: 05070500.xhp

msgctxt ""

"par_id3150010\n"

"help.text"

msgid "<ahelp hid=\"modules/scalc/ui/sheetprintpage/checkBTN_NOTES\">Prints the comments defined in your spreadsheet.</ahelp> They will be printed on a separate page, along with the corresponding cell reference."

#: 05070500.xhp

msgctxt ""

"hd_id3150202\n"

"help.text"

msgid "Fill Format Mode"

#: 05100000.xhp

msgctxt ""

"par_id3156198\n"

"help.text"

msgid "Fill Format Mode"

#: 05100000.xhp

msgctxt ""

"par_id3159098\n"

"help.text"

msgid "Click the <emph>Fill Format Mode</emph> icon."

#: 05100000.xhp

msgctxt ""

"par_id3149438\n"

"help.text"

msgid "Click the <emph>Fill Format Mode</emph> icon again to exit this mode."

#: 05100000.xhp

msgctxt ""

"par_id3154366\n"

"help.text"

msgid "You can only turn on the automatic hyphenation in $[officename] Calc when the <link href=\"text/shared/01/05340300.xhp\" name=\"row break\">row break</link> feature is active."

#: 06020000.xhp

msgctxt ""

"par_id3149260\n"

"help.text"

msgid "Mark the <emph>Wrap text automatically</emph> and <emph>Hyphenation active</emph> check boxes."

#: 06020000.xhp

msgctxt ""

"par_id3147265\n"

"help.text"

msgid "Traces are displayed in the sheet with marking arrows. At the same time, the range of all the cells contained in the formula of the current cell is highlighted with a blue frame."

#: 06030100.xhp

msgctxt ""

"par_id3148948\n"

"help.text"

msgid "The area of all cells that are used together with the active cell in a formula is highlighted by a blue frame."

#: 06030300.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Fill Mode"

#: 06030700.xhp

msgctxt ""

"bm_id3145119\n"

"help.text"

msgid "<bookmark_value>cells; trace fill mode</bookmark_value><bookmark_value>traces; precedents for multiple cells</bookmark_value>"

#: 06030700.xhp

msgctxt ""

"hd_id3145119\n"

"help.text"

msgid "<link href=\"text/scalc/01/06030700.xhp\" name=\"Fill Mode\">Fill Mode</link>"

#: 06030700.xhp

msgctxt ""

"par_id3151246\n"

"help.text"

msgid "<ahelp hid=\".uno:AuditingFillMode\">Activates the Fill Mode in the Detective. The mouse pointer changes to a special symbol, and you can click any cell to see a trace to the precedent cell.</ahelp> To exit this mode, press Escape or click the <emph>End Fill Mode</emph> command in the context menu."

#: 06030700.xhp

msgctxt ""

"par_id3151211\n"

"help.text"

msgid "The <emph>Fill Mode</emph> function is identical to the <link href=\"text/scalc/01/06030100.xhp\" name=\"Trace Precedent\">Trace Precedent</link> command if you call this mode for the first time. Use the context menu to select further options for the Fill Mode and to exit this mode."

#: 06030800.xhp

msgctxt ""

"hd_id3153954\n"

"help.text"

msgid "Comment"

#: 06050000.xhp

msgctxt ""

"par_id3151073\n"

"help.text"

msgid "<ahelp hid=\"modules/scalc/ui/scenariodialog/bordercolor\">Highlights the scenario in your table with a border. The color for the border is specified in the field to the right of this option.</ahelp> The border will have a title bar displaying the name of the last scenario. The button on the right of the scenario border offers you an overview of all the scenarios in this area, if several have been defined. You can choose any of the scenarios from this list without restrictions."

#: 06050000.xhp

msgctxt ""

"par_id3156422\n"

"help.text"

msgid "The completion text is highlighted."

#: 06130000.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-05-12 14:35+0200\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"MIME-Version: 1.0\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

#: 02130000.xhp

msgctxt ""

"hd_id4283883\n"

"help.text"

msgid "<link href=\"text/shared/01/04160500.xhp\" name=\"Floating Frame\">Floating Frame</link>"

#: 18010000.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-10-04 11:48+0200\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"MIME-Version: 1.0\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

#: 01020000.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Shortcut Keys for Spreadsheets"

#: 01020000.xhp

msgctxt ""

"bm_id3145801\n"

"help.text"

msgid "<bookmark_value>spreadsheets; shortcut keys in</bookmark_value><bookmark_value>shortcut keys; spreadsheets</bookmark_value><bookmark_value>sheet ranges; filling</bookmark_value>"

#: 01020000.xhp

msgctxt ""

"par_id3155067\n"

"help.text"

msgid "To fill a selected cell range with the formula that you entered on the <emph>Input line</emph>, press <switchinline select=\"sys\"><caseinline select=\"MAC\">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Enter. Hold down <switchinline select=\"sys\"><caseinline select=\"MAC\">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Enter+Shift to apply the cell format of the input cell to the entire cell range."

#: 01020000.xhp

msgctxt ""

"par_id3145140\n"

"help.text"

msgid "Displays the comment that is attached to the current cell"

#: 01020000.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-10-04 11:48+0200\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"MIME-Version: 1.0\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

#: address_auto.xhp

msgctxt ""

"par_id3149210\n"

"help.text"

msgid "If you do not see any change in color of the cell contents, choose <item type=\"menuitem\">View - Value Highlighting</item>."

#: autoformat.xhp

msgctxt ""

"par_id51576\n"

"help.text"

msgid "<link href=\"text/shared/guide/background.xhp\">Watermarks</link>"

#: background.xhp

msgctxt ""

"par_id1342204\n"

"help.text"

msgid "The options in the <emph>Line arrangement</emph> area can be used to apply multiple border styles."

#: borders.xhp

msgctxt ""

"par_id7251503\n"

"help.text"

msgid "Depending on the selection of cells, the area looks different."

#: borders.xhp

msgctxt ""

"par_id4677877\n"

"help.text"

msgid "Line arrangement area"

#: borders.xhp

msgctxt ""

"par_id4018066\n"

"help.text"

msgid "In the <emph>User defined</emph> area, you can click to set or remove individual lines. The preview shows lines in three different states."

#: borders.xhp

msgctxt ""

"par_id3147343\n"

"help.text"

msgid "The <item type=\"menuitem\">Format Cells</item> dialog appears. On the <item type=\"menuitem\">Numbers</item> tab, the \"Number\" category will appear already highlighted. The format is set to \"General\", which causes the result of a calculation containing date entries to be displayed as a date. To display the result as a number, set the number format to \"-1,234\" and close the dialog with the <item type=\"menuitem\">OK</item> button."

#: calc_date.xhp

msgctxt ""

"hd_id3150769\n"

"help.text"

msgid "<variable id=\"calc_series\"><link href=\"text/scalc/guide/calc_series.xhp\" name=\"Automatically Calculating Series\">Automatically Filling in Data Based on Adjacent Cells</link></variable>"

#: calc_series.xhp

msgctxt ""

"par_idN106A8\n"

"help.text"

msgid "You can automatically fill cells with data with the AutoFill command or the Series command."

#: calc_series.xhp

msgctxt ""

"par_id3145272\n"

"help.text"

msgid "Drag the fill handle in the bottom right corner of the cell across the cells that you want to fill, and release the mouse button."

#: calc_series.xhp

msgctxt ""

"par_id3145801\n"

"help.text"

msgid "The cells are filled with ascending numbers."

#: calc_series.xhp

msgctxt ""

"par_idN106EE\n"

"help.text"

msgid "To quickly create a list of consecutive days, enter <item type=\"literal\">Monday</item> in a cell, and drag the fill handle."

#: calc_series.xhp

msgctxt ""

"par_idN10737\n"

"help.text"

msgid "You can double-click the fill handle to automatically fill all empty columns of the current data block. For example, first enter Jan into A1 and drag the fill handle down to A12 to get the twelve months in the first column. Now enter some values into B1 and C1. Select those two cells, and double-click the fill handle. This fills automatically the data block B1:C12."

#: calc_series.xhp

msgctxt ""

"par_id3150749\n"

"help.text"

msgid "Select the cell range in the sheet that you want to fill."

#: calc_series.xhp

msgctxt ""

"par_id3154754\n"

"help.text"

msgid "Choose <item type=\"menuitem\">Sheet - Fill Cells - Series</item>."

#: calc_series.xhp

msgctxt ""

"bm_id3150868\n"

"help.text"

msgid "<bookmark_value>values; inserting in multiple cells</bookmark_value> <bookmark_value>inserting;values</bookmark_value> <bookmark_value>cell ranges;selecting for data entries</bookmark_value> <bookmark_value>areas, see also cell ranges</bookmark_value>"

#: cell_enter.xhp

msgctxt ""

"hd_id1867427\n"

"help.text"

msgid "Area Detection for New Rows"

#: cell_enter.xhp

msgctxt ""

"par_id6196783\n"

"help.text"

msgid "<image id=\"img_id6473586\" src=\"media/helpimg/area1.png\" width=\"4.8335in\" height=\"1.5937in\"><alt id=\"alt_id6473586\">area detection</alt></image>"

#: cell_enter.xhp

msgctxt ""

"hd_id3583788\n"

"help.text"

msgid "Area Selection"

#: cell_enter.xhp

msgctxt ""

"par_id2011780\n"

"help.text"

msgid "Use drag-and-drop to select the area where you want to input values. But start dragging from the last cell of the area and release the mouse button when you have selected the first cell. Now you can start to input values. Always press the Tab key to advance to the next cell. You will not leave the selected area."

#: cell_enter.xhp

msgctxt ""

"par_id7044282\n"

"help.text"

msgid "<image id=\"img_id2811365\" src=\"media/helpimg/area2.png\" width=\"4.8335in\" height=\"1.5937in\"><alt id=\"alt_id2811365\">area selection</alt></image>"

#: cell_enter.xhp

msgctxt ""

"par_id3232520\n"

"help.text"

msgid "Select the area from E7 to B3. Now B3 is waiting for your input. Press Tab to advance to the next cell within the selected area."

#: cell_enter.xhp

msgctxt ""

"par_id633869\n"

"help.text"

msgid "See <link href=\"text/scalc/guide/calc_series.xhp\">Automatically Filling in Data Based on Adjacent Cells</link>."

#: cell_protect.xhp

msgctxt ""

"par_id3148577\n"

"help.text"

msgid "Assume you have hidden a few rows in a cell range. Now you want to copy, delete, or format only the remaining visible rows."

#: cellcopy.xhp

msgctxt ""

"par_id3152892\n"

"help.text"

msgid "Enter the URL of the document or Web page in the dialog. The URL must be in the format: http://www.my-bank.com/table.html. The URL for local or local area network files is the path seen in the <item type=\"menuitem\">File - Open</item> dialog."

#: cellreferences_url.xhp

msgctxt ""

"par_id3151385\n"

"help.text"

msgid "If you would like to apply a formula to all cells in a selected area, you can use the <item type=\"menuitem\">Find & Replace</item> dialog."

#: cellstyle_by_formula.xhp

msgctxt ""

"par_id3144767\n"

"help.text"

msgid "All cells with contents that were included in the selection are now highlighted."

#: cellstyle_by_formula.xhp

msgctxt ""

"par_id3154944\n"

"help.text"

msgid "With conditional formatting, you can, for example, highlight the totals that exceed the average value of all totals. If the totals change, the formatting changes correspondingly, without having to apply other styles manually."

#: cellstyle_conditional.xhp

msgctxt ""

"hd_id3155766\n"

"help.text"

msgid "Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value"

#: cellstyle_conditional.xhp

msgctxt ""

"par_id3166465\n"

"help.text"

msgid "In the <emph>Selection</emph> area, check only the <emph>Formats</emph> box. All other boxes must be unchecked. Click <emph>OK</emph>."

#: cellstyle_conditional.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Highlighting Negative Numbers"

#: cellstyle_minusvalue.xhp

msgctxt ""

"bm_id3147434\n"

"help.text"

msgid "<bookmark_value>negative numbers</bookmark_value> <bookmark_value>numbers; highlighting negative numbers</bookmark_value> <bookmark_value>highlighting;negative numbers</bookmark_value> <bookmark_value>colors;negative numbers</bookmark_value> <bookmark_value>number formats;colors for negative numbers</bookmark_value>"

#: cellstyle_minusvalue.xhp

msgctxt ""

"hd_id3147434\n"

"help.text"

msgid "<variable id=\"cellstyle_minusvalue\"><link href=\"text/scalc/guide/cellstyle_minusvalue.xhp\" name=\"Highlighting Negative Numbers\">Highlighting Negative Numbers</link></variable>"

#: cellstyle_minusvalue.xhp

msgctxt ""

"par_id3153878\n"

"help.text"

msgid "You can format cells with a number format that highlights negative numbers in red. Alternatively, you can define your own number format in which negative numbers are highlighted in other colors."

#: cellstyle_minusvalue.xhp

msgctxt ""

"par_id3151073\n"

"help.text"

msgid "Open the document that contains the cell ranges to be consolidated."

#: consolidate.xhp

msgctxt ""

"par_id3147345\n"

"help.text"

msgid "From the <emph>Source data area</emph> box select a source cell range to consolidate with other areas."

#: consolidate.xhp

msgctxt ""

"par_id3149209\n"

"help.text"

msgid "If the range is not named, click in the field next to the <emph>Source data area</emph>. A blinking text cursor appears. Type a reference for the first source data range or select the range with the mouse."

#: consolidate.xhp

msgctxt ""

"par_id3155529\n"

"help.text"

msgid "Click <emph>Add</emph> to insert the selected range in the <emph>Consolidation areas</emph> field."

#: consolidate.xhp

msgctxt ""

"par_id3153816\n"

"help.text"

msgid "Select additional ranges and click <emph>Add</emph> after each selection."

#: consolidate.xhp

msgctxt ""

"par_id3149315\n"

"help.text"

msgid "Click <emph>OK</emph> to consolidate the ranges."

#: consolidate.xhp

msgctxt ""

"par_id3156400\n"

"help.text"

msgid "Select <emph>Link to source data</emph> to insert the formulas that generate the results in the target range, rather than the actual results. If you link the data, any values modified in the source range are automatically updated in the target range."

#: consolidate.xhp

msgctxt ""

"par_id3150538\n"

"help.text"

msgid "The corresponding cell references in the target range are inserted in consecutive rows, which are automatically ordered and then hidden from view. Only the final result, based on the selected function, is displayed."

#: consolidate.xhp

msgctxt ""

"par_id3147468\n"

"help.text"

msgid "The data from the consolidation ranges and target range will be saved when you save the document. If you later open a document in which consolidation has been defined, this data will again be available."

#: consolidate.xhp

msgctxt ""

"par_id3153768\n"

"help.text"

msgid "You can define a range of cells in a spreadsheet to use as a database. Each row in this database range corresponds to a database record and each cell in a row corresponds to a database field. You can sort, group, search, and perform calculations on the range as you would in a database."

#: database_define.xhp

msgctxt ""

"par_idN10654\n"

"help.text"

msgid "Choose <item type=\"menuitem\">Data - Define Range</item>."

#: database_define.xhp

msgctxt ""

"par_id3156023\n"

"help.text"

msgid "Position the cursor within a range of cells containing values, row and column headings."

#: datapilot_createtable.xhp

msgctxt ""

"par_id3150868\n"

"help.text"

msgid "Drag the desired buttons into one of the four areas."

#: datapilot_createtable.xhp

msgctxt ""

"par_id3154011\n"

"help.text"

msgid "If the button is dropped in the <emph>Data Fields</emph> area it will be given a caption that also shows the formula that will be used to calculate the data."

#: datapilot_createtable.xhp

msgctxt ""

"par_id3146974\n"

"help.text"

msgid "By double-clicking on one of the fields in the <emph>Data Fields</emph> area you can call up the <link href=\"text/scalc/01/12090105.xhp\" name=\"Data Field\"><emph>Data Field</emph></link> dialog."

#: datapilot_createtable.xhp

msgctxt ""

"par_id3150329\n"

"help.text"

msgid "The order of the buttons can be changed at any time by moving them to a different position in the area with the mouse."

#: datapilot_createtable.xhp

msgctxt ""

"par_id3153714\n"

"help.text"

msgid "Remove a button by dragging it back to the area of the other buttons at the right of the dialog."

#: datapilot_createtable.xhp

msgctxt ""

"par_id3145786\n"

"help.text"

msgid "By dragging the button to a different position in the same row you can alter the order of the columns. If you drag a button to the left edge of the table into the row headings area, you can change a column into a row."

#: datapilot_edittable.xhp

msgctxt ""

"bm_id3149456\n"

"help.text"

msgid "<bookmark_value>copying;values, to multiple sheets</bookmark_value><bookmark_value>pasting;values in multiple sheets</bookmark_value><bookmark_value>data;inserting in multiple sheets</bookmark_value> <bookmark_value>sheets; simultaneous multiple filling</bookmark_value>"

#: edit_multitables.xhp

msgctxt ""

"par_idN10663\n"

"help.text"

msgid "When you select multiple rows from an area where a filter was applied, then this selection can include rows that are visible and rows that are hidden by the filter. If you then apply formatting, or delete the selected rows, this action then applies only to the visible rows. The hidden rows are not affected."

#: filters.xhp

msgctxt ""

"par_id9363689\n"

"help.text"

msgid "In spreadsheet documents you can find words, formulas, and styles. You can navigate from one result to the next, or you can highlight all matching cells at once, then apply another format or replace the cell content by other content."

#: finding.xhp

msgctxt ""

"par_id3154018\n"

"help.text"

msgid "Position the mouse on the bottom right of the highlighted border of the cell, and continue holding down the mouse button until the pointer changes to a cross-hair symbol."

#: formula_copy.xhp

msgctxt ""

"par_id3155764\n"

"help.text"

msgid "If you are editing a formula with references, the references and the associated cells will be highlighted with the same color. You can now resize the reference border using the mouse, and the reference in the formula displayed in the input line also changes. <emph>Show references in color</emph> can be deactivated under <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href=\"text/shared/optionen/01060300.xhp\" name=\"Spreadsheet - View\">%PRODUCTNAME Calc - View</link>."

#: formula_enter.xhp

msgctxt ""

"par_id3149210\n"

"help.text"

msgid "<variable id=\"tip\">If you would like to view the calculation of individual elements of a formula, select the respective elements and press F9. For example, in the formula =SUM(A1:B12)*SUM(C1:D12) select the section SUM(C1:D12) and press F9 to view the subtotal for this area. </variable>"

#: formula_enter.xhp

msgctxt ""

"par_id3146120\n"

"help.text"

msgid "In the <emph>Display</emph> area mark the <emph>Formulas</emph> box. Click OK."

#: formula_value.xhp

msgctxt ""

"par_id3148645\n"

"help.text"

msgid "In the <emph>File type</emph> list box, in the area with the other <item type=\"productname\">%PRODUCTNAME</item> Calc filters, choose the file type \"HTML Document (<item type=\"productname\">%PRODUCTNAME</item> Calc)\"."

#: html_doc.xhp

msgctxt ""

"par_id3148576\n"

"help.text"

msgid "If you have long rows or columns of data that extend beyond the viewable area of the sheet, you can freeze some rows or columns, which allows you to see the frozen columns or rows as you scroll through the rest of the data."

#: line_fix.xhp

msgctxt ""

"hd_id3155382\n"

"help.text"

msgid "Database Ranges in Tables"

#: main.xhp

msgctxt ""

"par_id3149261\n"

"help.text"

msgid "With the mouse button pressed, drag from one corner to the diagonally opposed corner of the range."

#: mark_cells.xhp

msgctxt ""

"par_id1001200901072023\n"

"help.text"

msgid "Click the STD / EXT / ADD area in the status bar until it shows ADD. Now click all cells that you want to select."

#: mark_cells.xhp

msgctxt ""

"par_id3145252\n"

"help.text"

msgid "Select the range A1:A10, which contains the first values for the sum formula."

#: matrixformula.xhp

msgctxt ""

"par_id3145640\n"

"help.text"

msgid "The matrix area is automatically protected against modifications, such as deleting rows or columns. It is, however, possible to edit any formatting, such as the cell background."

#: move_dragdrop.xhp

msgctxt ""

"par_id3968932\n"

"help.text"

msgid "In overwrite mode you see all four borders around the selected area. In insert mode you see only the left border when target cells will be shifted to the right. You see only the upper border when target cells will be shifted down."

#: move_dragdrop.xhp

msgctxt ""

"par_id7399517\n"

"help.text"

msgid "Whether the target area will be shifted to the right or to the bottom depends on the distance between source and target cells, if you move within the same sheet. It depends on the number of horizontal or vertical cells in the moved area, if you move to a different sheet."

#: move_dragdrop.xhp

msgctxt ""

"par_id8040406\n"

"help.text"

msgid "If you move cells in insert mode within the same row (only horizontally), then after insertion of the cells, all cells will be shifted to the left to fill the source area."

#: move_dragdrop.xhp

msgctxt ""

"par_id2815637\n"

"help.text"

msgid "Cells are moved and overwrite the cells in the target area. Source cells are emptied."

#: move_dragdrop.xhp

msgctxt ""

"par_id4278389\n"

"help.text"

msgid "Cells are copied and overwrite the cells in the target area. Source cells stay as they are."

#: move_dragdrop.xhp

msgctxt ""

"par_id5369121\n"

"help.text"

msgid "Links to the source cells are inserted and overwrite the cells in the target area. Source cells stay as they are."

#: move_dragdrop.xhp

msgctxt ""

"par_id2926419\n"

"help.text"

msgid "Cells are moved and shift the cells in the target area to the right or to the bottom. Source cells are emptied, except if you move within the same rows on the same sheet."

#: move_dragdrop.xhp

msgctxt ""

"par_id4021423\n"

"help.text"

msgid "If you move within the same rows on the same sheet, the cells in the target area shift to the right, and then the whole row shifts to fill the source area."

#: move_dragdrop.xhp

msgctxt ""

"par_id2785119\n"

"help.text"

msgid "Cells are copied and shift the cells in the target area to the right or to the bottom. Source cells stay as they are."

#: move_dragdrop.xhp

msgctxt ""

"par_id5590990\n"

"help.text"

msgid "Links to the source cells are inserted and shift the cells in the target area to the right or to the bottom. Source cells stay as they are."

#: multi_tables.xhp

msgctxt ""

"par_id6478774\n"

"help.text"

msgid "<image id=\"img_id1621753\" src=\"media/helpimg/what-if.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id1621753\">what-if sheet area</alt></image>"

#: multioperation.xhp

msgctxt ""

"par_id3149731\n"

"help.text"

msgid "Expand the table shown above. D2 thru D11 contain the numbers 500, 1000 and so on, up to 5000. In E1 through H1 enter the numbers 8, 10, 15 and 20."

#: multioperation.xhp

msgctxt ""

"par_id3152810\n"

"help.text"

msgid "Select the range D1:H11."

#: multioperation.xhp

msgctxt ""

"hd_id3155600\n"

"help.text"

msgid "Undoing a Selection"

#: multitables.xhp

msgctxt ""

"par_id3155333\n"

"help.text"

msgid "You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, <item type=\"literal\">=SUM(Sheet1.A1:Sheet3.A1) </item>sums up all A1 cells on Sheet1 through Sheet3."

#: note_insert.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Inserting and Editing Comments"

#: note_insert.xhp

msgctxt ""

"bm_id3153968\n"

"help.text"

msgid "<bookmark_value>comments; on cells</bookmark_value> <bookmark_value>cells;comments</bookmark_value> <bookmark_value>remarks on cells</bookmark_value> <bookmark_value>formatting;comments on cells</bookmark_value> <bookmark_value>viewing;comments on cells</bookmark_value> <bookmark_value>displaying; comments</bookmark_value>"

#: note_insert.xhp

msgctxt ""

"hd_id3153968\n"

"help.text"

msgid "<variable id=\"note_insert\"><link href=\"text/scalc/guide/note_insert.xhp\" name=\"Inserting and Editing Comments\">Inserting and Editing Comments</link></variable>"

#: note_insert.xhp

msgctxt ""

"par_id3150440\n"

"help.text"

msgid "You can assign a comment to each cell by choosing <link href=\"text/shared/01/04050000.xhp\" name=\"Insert - Comment\"><emph>Insert - Comment</emph></link>. The comment is indicated by a small red square, the comment indicator, in the cell."

#: note_insert.xhp

msgctxt ""

"par_id3148575\n"

"help.text"

msgid "When you select the cell, you can choose <emph>Show Comment</emph> from the context menu of the cell. Doing so keeps the comment visible until you deactivate the <emph>Show Comment</emph> command from the same context menu."

#: note_insert.xhp

msgctxt ""

"par_id3149958\n"

"help.text"

msgid "To edit a permanently visible comment, just click in it. If you delete the entire text of the comment, the comment itself is deleted."

#: note_insert.xhp

msgctxt ""

"par_idN10699\n"

"help.text"

msgid "Move or resize each comment as you like."

#: note_insert.xhp

msgctxt ""

"par_idN1069D\n"

"help.text"

msgid "Format each comment by specifying background color, transparency, border style, and text alignment. Choose the commands from the context menu of the comment."

#: note_insert.xhp

msgctxt ""

"par_id3144764\n"

"help.text"

msgid "To show or hide the comment indicator, choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - View</emph> and mark or unmark the <emph>Comment indicator</emph> check box."

#: note_insert.xhp

msgctxt ""

"par_id3153707\n"

"help.text"

msgid "<link href=\"text/shared/01/04050000.xhp\" name=\"Insert - Comment\">Insert - Comment</link>"

#: numbers_text.xhp

msgctxt ""

"bm_id3154346\n"

"help.text"

msgid "<bookmark_value>printing;sheet details</bookmark_value><bookmark_value>sheets; printing details</bookmark_value><bookmark_value>grids; printing sheet grids</bookmark_value><bookmark_value>formulas; printing, instead of results</bookmark_value><bookmark_value>comments; printing</bookmark_value><bookmark_value>charts;printing</bookmark_value><bookmark_value>sheet grids; printing</bookmark_value><bookmark_value>cells; printing grids</bookmark_value><bookmark_value>borders; printing cells</bookmark_value><bookmark_value>zero values; printing</bookmark_value><bookmark_value>null values; printing</bookmark_value><bookmark_value>draw objects;printing</bookmark_value>"

#: print_details.xhp

msgctxt ""

"par_id3145273\n"

"help.text"

msgid "Comments"

#: print_details.xhp

msgctxt ""

"par_id3146916\n"

"help.text"

msgid "Select the <emph>Sheet</emph> tab. In the <emph>Print </emph>area mark the details to be printed and click OK."

#: print_details.xhp

msgctxt ""

"par_id3146974\n"

"help.text"

msgid "You will see the automatic distribution of the sheet across the print pages. The automatically created print ranges are indicated by dark blue lines, and the user-defined ones by light blue lines. The page breaks (line breaks and column breaks) are marked as black lines."

#: print_exact.xhp

msgctxt ""

"par_id3152578\n"

"help.text"

msgid "You can move the blue lines with the mouse. You will find further options in the Context menu, including adding an additional print range, removing the scaling and inserting additional manual line and column breaks."

#: print_exact.xhp

msgctxt ""

"par_id3149958\n"

"help.text"

msgid "Click the icon at the far right of the <emph>Rows to repeat</emph> area."

#: print_title_row.xhp

msgctxt ""

"par_id3153707\n"

"help.text"

msgid "Click the icon at the far right of the <emph>Rows to repeat</emph> area. The dialog is restored again."

#: print_title_row.xhp

msgctxt ""

"par_id3155443\n"

"help.text"

msgid "If you also want column A as a column to repeat, click the icon at the far right of the <emph>Columns to repeat</emph> area."

#: print_title_row.xhp

msgctxt ""

"par_id3154704\n"

"help.text"

msgid "Click the icon again at the far right of the <emph>Columns to repeat</emph> area."

#: print_title_row.xhp

msgctxt ""

"par_id3146119\n"

"help.text"

msgid "The cell in column A, row 1 is addressed as A1. You can address a range of adjacent cells by first entering the coordinates of the upper left cell of the area, then a colon followed by the coordinates of the lower right cell. For example, the square formed by the first four cells in the upper left corner is addressed as A1:B2."

#: relativ_absolut_ref.xhp

msgctxt ""

"par_id3154730\n"

"help.text"

msgid "By addressing an area in this way, you are making a relative reference to A1:B2. Relative here means that the reference to this area will be adjusted automatically when you copy the formulas."

#: relativ_absolut_ref.xhp

msgctxt ""

"par_id3147346\n"

"help.text"

msgid "What distinguishes a relative reference? Assume you want to calculate in cell E1 the sum of the cells in range A1:B2. The formula to enter into E1 would be: =SUM(A1:B2). If you later decide to insert a new column in front of column A, the elements you want to add would then be in B1:C2 and the formula would be in F1, not in E1. After inserting the new column, you would therefore have to check and correct all formulas in the sheet, and possibly in other sheets."

#: relativ_absolut_ref.xhp

msgctxt ""

"par_id3155335\n"

"help.text"

msgid "Fortunately, $[officename] does this work for you. After having inserted a new column A, the formula =SUM(A1:B2) will be automatically updated to =SUM(B1:C2). Row numbers will also be automatically adjusted when a new row 1 is inserted. Absolute and relative references are always adjusted in $[officename] Calc whenever the referenced area is moved. But be careful if you are copying a formula since in that case only the relative references will be adjusted, not the absolute references."

#: relativ_absolut_ref.xhp

msgctxt ""

"par_id3147005\n"

"help.text"

msgid "Aside from when new rows and columns are inserted, references can also change when an existing formula referring to particular cells is copied to another area of the sheet. Assume you entered the formula =SUM(A1:A9) in row 10. If you want to calculate the sum for the adjacent column to the right, simply copy this formula to the cell to the right. The copy of the formula in column B will be automatically adjusted to =SUM(B1:B9)."

#: rename_table.xhp

msgctxt ""

"par_id3154020\n"

"help.text"

msgid "Click the area of the headers on the separator below the current row, keep the mouse button pressed and drag up or down in order to change the row height."

#: row_height.xhp

msgctxt ""

"par_id3154256\n"

"help.text"

msgid "In the Navigator, you see the defined scenarios with the comments that were entered when the scenarios were created."

#: scenario.xhp

msgctxt ""

"bm_id3150870\n"

"help.text"

msgid "<bookmark_value>filling;customized lists</bookmark_value><bookmark_value>sort lists;applying</bookmark_value><bookmark_value>defining;sort lists</bookmark_value><bookmark_value>geometric lists</bookmark_value><bookmark_value>arithmetic lists</bookmark_value><bookmark_value>series;sort lists</bookmark_value><bookmark_value>lists; user-defined</bookmark_value><bookmark_value>customized lists</bookmark_value>"

#: sorted_list.xhp

msgctxt ""

"par_id3159154\n"

"help.text"

msgid "Sort lists allow you to type one piece of information in a cell, then drag it to fill in a consecutive list of items."

#: sorted_list.xhp

msgctxt ""

"par_id3148645\n"

"help.text"

msgid "For example, enter the text \"Jan\" or \"January\" in an empty cell. Select the cell and click the mouse on the lower right corner of the cell border. Then drag the selected cell a few cells to the right or downwards. When you release the mouse button, the highlighted cells will be filled with the names of the months."

#: sorted_list.xhp

msgctxt ""

"par_id3145785\n"

"help.text"

msgid "Copy the column headers of the sheet ranges to be filtered into an empty area of the sheet, and then enter the criteria for the filter in a row beneath the headers. Horizontally arranged data in a row will always be logically connected with AND, and vertically arranged data in a column will always be logically connected with OR."

#: specialfilter.xhp

msgctxt ""

"par_id3153142\n"

"help.text"

msgid "Select the cell range that you want to transpose."

#: table_rotate.xhp

msgctxt ""

"par_id3148575\n"

"help.text"

msgid "Click the cell that is to be the top left cell in the result."

#: table_rotate.xhp

msgctxt ""

"par_id3147426\n"

"help.text"

msgid "In the <emph>Text orientation</emph> area use the mouse to select in the preview wheel the direction in which the text is to be rotated. Click <emph>OK</emph>."

#: text_rotate.xhp

msgctxt ""

"bm_id3154346\n"

"help.text"

msgid "<bookmark_value>text in cells; multi-line</bookmark_value><bookmark_value>cells; text breaks</bookmark_value><bookmark_value>breaks in cells</bookmark_value><bookmark_value>multi-line text in cells</bookmark_value>"

#: text_wrap.xhp

msgctxt ""

"par_id3153142\n"

"help.text"

msgid "If you want the text to automatically break at the right border of the cell, proceed as follows:"

#: text_wrap.xhp

msgctxt ""

"par_id3153951\n"

"help.text"

msgid "Select all the cells where you want the text to break at the right border."

#: text_wrap.xhp

msgctxt ""

"par_id3148575\n"

"help.text"

msgid "In <emph>Format - Cells - Alignment</emph>, mark the <emph>Wrap text automatically</emph> option and click OK."

#: text_wrap.xhp

msgctxt ""

"bm_id3156442\n"

"help.text"

msgid "<bookmark_value>values; limiting on input</bookmark_value><bookmark_value>limits; specifying value limits on input</bookmark_value><bookmark_value>permitted cell contents</bookmark_value><bookmark_value>data validity</bookmark_value><bookmark_value>validity</bookmark_value><bookmark_value>cells; validity</bookmark_value><bookmark_value>error messages; defining for incorrect input</bookmark_value><bookmark_value>actions in case of incorrect input</bookmark_value><bookmark_value>Help tips; defining text for cell input</bookmark_value><bookmark_value>comments;help text for cells</bookmark_value><bookmark_value>cells; defining input help</bookmark_value><bookmark_value>macros; running when incorrect input</bookmark_value><bookmark_value>data; validity check</bookmark_value>"

#: validity.xhp

msgctxt ""

"par_id3156283\n"

"help.text"

msgid "Type the name of the selected area in the <emph>Name</emph> field. Click <emph>Add</emph>. The newly defined name appears in the list below. Click OK to close the dialog."

#: value_with_name.xhp

msgctxt ""

"par_id3148575\n"

"help.text"

msgid "You can use the same method to insert ranges defined by name from a Calc or Microsoft Excel spreadsheet."

#: webquery.xhp

msgctxt ""

"par_id3152990\n"

"help.text"

msgid "In the lower combo box of the Navigator select the source document. The Navigator now shows the range names and database ranges or the tables contained in the source document."

#: webquery.xhp

msgctxt ""

"par_id3144768\n"

"help.text"

msgid "If you have loaded an HTML document with the <emph>Web Page Query</emph> filter as the source document, you will find the tables in the Navigator, named continuously from \"HTML_table1\" onwards, and also two range names that have been created:"

#: webquery.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-11-22 13:53+0100\n"

"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

#: 03010000.xhp

msgctxt ""

"par_id3155268\n"

"help.text"

msgid "<ahelp hid=\"modules/schart/ui/tp_axisLabel/breakCB\">Allows a text break.</ahelp>"

#: 05020201.xhp

msgctxt ""

"par_id1911679\n"

"help.text"

msgid "Based on <emph>open, low, high</emph>, and <emph>close</emph> column Type 2 generates the traditional \"candle stick\" chart. Type 2 draws the vertical line between the bottom and top price and adds a rectangle in front, which visualizes the range between the opening and closing price. If you click on the rectangle you see more information in the status bar. %PRODUCTNAME uses different fill colors for rising values (the opening price is lower than the closing price) and falling values."

#: type_stock.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-12-20 08:16+0100\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"MIME-Version: 1.0\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

#: main0000.xhp

msgctxt ""

"hd_id3155111\n"

"help.text"

msgid "<link href=\"text/shared/01/04160500.xhp\" name=\"Floating Frame\">Floating Frame</link>"

#: main0104.xhp

msgctxt ""

"hd_id3151076\n"

"help.text"

msgid "<link href=\"text/shared/01/05210000.xhp\" name=\"Area\">Area</link>"

#: main0105.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Line and Filling Bar"

#: main0202.xhp

msgctxt ""

"hd_id3149669\n"

"help.text"

msgid "<link href=\"text/sdraw/main0202.xhp\" name=\"Line and Filling Bar\">Line and Filling Bar</link>"

#: main0202.xhp

msgctxt ""

"par_id3150543\n"

"help.text"

msgid "The Line and Filling bar contains commands for the current editing mode."

#: main0202.xhp

msgctxt ""

"hd_id3155767\n"

"help.text"

msgid "<link href=\"text/shared/01/05210100.xhp\" name=\"Area Style / Filling\">Area Style / Filling</link>"

#: main0202.xhp

msgctxt ""

"par_idN105E1\n"

"help.text"

msgid "Draws a filled rectangle where you drag in the current document. Click where you want to place a corner of the rectangle, and drag to the size you want. To draw a square, hold down Shift while you drag."

#: main0210.xhp

msgctxt ""

"par_idN105FE\n"

"help.text"

msgid "Draws a filled oval where you drag in the current document. Click where you want to draw the oval, and drag to the size you want. To draw a circle, hold down Shift while you drag."

#: main0210.xhp

msgctxt ""

"par_idN1061B\n"

"help.text"

msgid "Draws a text box where you click or drag in the current document. Click anywhere in the document, and then type or paste your text."

#: main0210.xhp

msgctxt ""

"hd_id3148870\n"

"help.text"

msgid "<link href=\"text/simpress/02/13190000.xhp\" name=\"Select Text Area Only\">Select Text Area Only</link>"

#: main0503.xhp

msgctxt ""

"par_id3149124\n"

"help.text"

msgid "You can connect objects in $[officename] Draw with special lines called \"connectors\" to show the relationship between objects. Connectors attach to glue points on drawing objects and remain attached when the connected objects are moved. Connectors are useful for creating organization charts and technical diagrams."

#: main0503.xhp

msgctxt ""

"hd_id3154705\n"

"help.text"

msgid "Gallery"

#: main0503.xhp

msgctxt ""

"par_id3154022\n"

"help.text"

msgid "The Gallery contains images, animations, sounds and other items that you can insert and use in your drawings as well as other $[officename] programs."

#: main0503.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-10-04 11:48+0200\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"MIME-Version: 1.0\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

#: 01020000.xhp

msgctxt ""

"par_id3147250\n"

"help.text"

msgid "Fits to frame."

#: 01020000.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2017-05-12 14:35+0200\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: zh_TW\n"

"MIME-Version: 1.0\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=1; plural=0;\n"

"X-Accelerator-Marker: ~\n"

#: align_arrange.xhp

msgctxt ""

"par_id3150327\n"

"help.text"

msgid "Choose <emph>Format - Area</emph> and click the <emph>Colors</emph> tab. A table of the predefined colors is displayed."

#: color_define.xhp

msgctxt ""

"par_id3157871\n"

"help.text"

msgid "If you want to expand or contract the color selection area, increase or decrease the tolerance of the <emph>Color Replacer</emph> tool and repeat your selection."

#: eyedropper.xhp

msgctxt ""

"tit\n"

"help.text"

msgid "Creating Gradient Fills"

#: gradient.xhp

msgctxt ""

"hd_id3150792\n"

"help.text"

msgid "<variable id=\"gradient\"><link href=\"text/sdraw/guide/gradient.xhp\" name=\"Creating Gradient Fills\">Creating Gradient Fills</link> </variable>"

#: gradient.xhp

msgctxt ""

"par_id3154012\n"

"help.text"

msgid "A gradient fill is an incremental blend of two different colors, or shades of the same color, that you can apply to a drawing object."

#: gradient.xhp

msgctxt ""

"par_id3154491\n"

"help.text"

msgid "Choose <emph>Format - Area</emph> and select <emph>Gradient</emph> as the <emph>Fill</emph> type."

#: gradient.xhp

msgctxt ""

"par_id3151242\n"

"help.text"

msgid "Choose <emph>Format - Area</emph> and click the <emph>Gradients</emph> tab."

#: gradient.xhp

msgctxt ""

"par_id3156396\n"

"help.text"

msgid "Click <emph>OK.</emph>"

#: gradient.xhp

msgctxt ""

"par_id3145592\n"

"help.text"

msgid "Choose <emph>Format - Area</emph> and click the <emph>Gradients</emph> tab."

#: gradient.xhp

msgctxt ""

"par_id3150659\n"

"help.text"

msgid "To adjust the transparency of an object, select the object, choose <emph>Format - Area</emph> and click the <emph>Transparency</emph> tab."

#: graphic_insert.xhp

msgctxt ""

"bm_id3145799\n"

"help.text"

msgid "<bookmark_value>draw objects; connecting lines to</bookmark_value><bookmark_value>connecting; lines</bookmark_value><bookmark_value>lines; connecting objects</bookmark_value><bookmark_value>areas; from connected lines</bookmark_value>"

#: join_objects.xhp

msgctxt ""

"par_id3150363\n"

"help.text"

msgid "You can only use the <emph>Close Object</emph> command on connected lines, <emph>Freeform Lines </emph>and unfilled <emph>Curves</emph>."