+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Last-Translator: Ingmārs Dīriņš <melhiors14@gmail.com>\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/accessibilitymessages/lv/>\n"

+"Plural-Forms: nplurals=3; plural=n%10==1 && n%100!=11 ? 0 : n != 0 ? 1 : 2;\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/avmediamessages/lv/>\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/basctlmessages/lv/>\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/basicmessages/lv/>\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/chart2messages/lv/>\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/connectivitymessages/lv/>\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"POT-Creation-Date: 2021-10-20 13:07+0200\n"

+#. ZVyum

+msgid "Firebird External"

+msgstr ""

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/dbaccessmessages/lv/>\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/editengmessages/lv/>\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"POT-Creation-Date: 2021-10-20 13:07+0200\n"

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/extensionsmessages/lv/>\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:78

+#. 3aG8b

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:85

+msgctxt "sanedialog|extended_tip|deviceInfoButton"

+msgid "Displays a popup window with information obtained from the scanner driver."

+msgstr ""

+

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:97

+#. FPGEB

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:104

+msgctxt "sanedialog|extended_tip|previewButton"

+msgid "Scans and displays the document in the preview area."

+msgstr ""

+

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:116

+#. a4hC3

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:123

+msgctxt "sanedialog|extended_tip|ok"

+msgid "Scans an image, and then inserts the result into the document and closes the dialog."

+msgstr ""

+

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:187

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:201

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:215

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:229

+#. nu6SM

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:249

+msgctxt "sanedialog|extended_tip|topSpinbutton"

+msgid "Set the top margin of the scan area."

+msgstr ""

+

+#. oDppB

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:268

+msgctxt "sanedialog|extended_tip|rightSpinbutton"

+msgid "Set the right margin of the scan area."

+msgstr ""

+

+#. EdgNn

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:287

+msgctxt "sanedialog|extended_tip|bottomSpinbutton"

+msgid "Set the bottom margin of the scan area."

+msgstr ""

+

+#. L7tZS

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:306

+msgctxt "sanedialog|extended_tip|leftSpinbutton"

+msgid "Set the left margin of the scan area."

+msgstr ""

+

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:321

+#. wECiq

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:366

+msgctxt "sanedialog|extended_tip|preview"

+msgid "Displays a preview of the scanned image. The preview area contains eight handles. Drag the handles to adjust the scan area or enter a value in the corresponding margin spin box."

+msgstr ""

+

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:379

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:413

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:427

+#. diRy3

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:444

+msgctxt "sanedialog|extended_tip|deviceCombobox"

+msgid "Displays a list of available scanners detected in your system."

+msgstr ""

+

+#. nBuc6

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:466

+msgctxt "sanedialog|extended_tip|reslCombobox"

+msgid "Select the resolution in dots per inch for the scan job."

+msgstr ""

+

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:492

+#. yXnEA

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:500

+msgctxt "sanedialog|extended_tip|advancedcheckbutton"

+msgid "Mark this checkbox to display more configuration options for the scanner device."

+msgstr ""

+

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:527

+#. 4FHyM

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:569

+msgctxt "sanedialog\\extended_tip|optionSvTreeListBox"

+msgid "Displays the list of available scanner driver advanced options. Double click an option to display its contents just below."

+msgstr ""

+

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:607

+#: extensions/uiconfig/scanner/ui/sanedialog.ui:680

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/filtermessages/lv/>\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/formsmessages/lv/>\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/formulamessages/lv/>\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"POT-Creation-Date: 2021-10-20 13:08+0200\n"

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/fpickermessages/lv/>\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+#: fpicker/uiconfig/ui/explorerfiledialog.ui:551

+#: fpicker/uiconfig/ui/explorerfiledialog.ui:589

+#: fpicker/uiconfig/ui/explorerfiledialog.ui:615

+#: fpicker/uiconfig/ui/explorerfiledialog.ui:679

+#: fpicker/uiconfig/ui/explorerfiledialog.ui:702

+#: fpicker/uiconfig/ui/explorerfiledialog.ui:715

+#: fpicker/uiconfig/ui/explorerfiledialog.ui:728

+#: fpicker/uiconfig/ui/explorerfiledialog.ui:755

+#: fpicker/uiconfig/ui/remotefilesdialog.ui:175

+#: fpicker/uiconfig/ui/remotefilesdialog.ui:203

+#: fpicker/uiconfig/ui/remotefilesdialog.ui:253

+#: fpicker/uiconfig/ui/remotefilesdialog.ui:268

+#: fpicker/uiconfig/ui/remotefilesdialog.ui:284

+#: fpicker/uiconfig/ui/remotefilesdialog.ui:389

+#: fpicker/uiconfig/ui/remotefilesdialog.ui:409

+#: fpicker/uiconfig/ui/remotefilesdialog.ui:423

+#: fpicker/uiconfig/ui/remotefilesdialog.ui:499

+#: fpicker/uiconfig/ui/remotefilesdialog.ui:513

+"PO-Revision-Date: 2021-10-18 06:08+0000\n"

+"Language-Team: Latvian <https://translations.documentfoundation.org/projects/libo_ui-master/frameworkmessages/lv/>\n"

+"X-Generator: Weblate 4.8.1\n"

+msgstr "_Pievienot"

+msgstr "_Dzēst"

+msgstr "_Izņemt"

+"POT-Creation-Date: 2021-10-20 13:08+0200\n"

+#. m2Dpj

+#: scalc.tree

+msgctxt ""

+"scalc.tree\n"

+"0815\n"

+"node.text"

+msgid "Writing Calc Macros"

+msgstr ""

+

+"POT-Creation-Date: 2021-10-20 13:08+0200\n"

+#. fRi68

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"tit\n"

+"help.text"

+msgid "Reading and Writing values to Ranges"

+msgstr ""

+

+#. 3hH3s

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"hd_id461623364876507\n"

+"help.text"

+msgid "<variable id=\"title\"><link href=\"text/sbasic/guide/read_write_values.xhp\" name=\"ReadWriteValues_h1\">Reading and Writing values to Ranges</link></variable>"

+msgstr ""

+

+#. ZKUBE

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id781633210592228\n"

+"help.text"

+msgid "Macros in %PRODUCTNAME Calc often need to read and write values from/to sheets. This help page describes the various approaches to accessing sheets and ranges to read or write their values."

+msgstr ""

+

+#. D4ZJu

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id191633214565965\n"

+"help.text"

+msgid "All examples presented in this page can be implemented both in Basic and Python."

+msgstr ""

+

+#. LfNCy

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"hd_id331633213558740\n"

+"help.text"

+msgid "Accessing a Single Cell"

+msgstr ""

+

+#. A5M3f

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id731633213581386\n"

+"help.text"

+msgid "The example below enters the numeric value 123 into cell \"A1\" of the current sheet."

+msgstr ""

+

+#. G6yWX

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id131633213887433\n"

+"help.text"

+msgid "The same can be accomplished with Python:"

+msgstr ""

+

+#. CDmg6

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id861633214219511\n"

+"help.text"

+msgid "Note that in the previous examples the cell is accessed using its range name \"A1\". It is also possible to access cells using indices as though the sheet were a matrix where columns and rows are indexed starting from zero."

+msgstr ""

+

+#. Jja4D

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id161633214461067\n"

+"help.text"

+msgid "This can be done using the <literal>getCellByPosition(colIndex, rowIndex)</literal> method, that takes in a column and a row index. The example below in Basic changes the text value in cell \"C1\" (column 2, row 0)."

+msgstr ""

+

+#. 5tsZR

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id221633214713436\n"

+"help.text"

+msgid "This example can also be implemented in Python as follows:"

+msgstr ""

+

+#. h6eq5

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id101633215142970\n"

+"help.text"

+msgid "The main difference between Python and Basic scripts lies on how to get access to the sheet object by using the <literal>XSCRIPTCONTEXT</literal> context variable. After that, all methods and properties are identical in Basic and Python."

+msgstr ""

+

+#. PmETF

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"hd_id411633215666257\n"

+"help.text"

+msgid "Values, Strings and Formulas"

+msgstr ""

+

+#. MBHDg

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id861633215682610\n"

+"help.text"

+msgid "Calc cells can have three types of values: numeric, strings and formulas. Each type has its own set and get methods:"

+msgstr ""

+

+#. RXE76

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id191633215791905\n"

+"help.text"

+msgid "Type"

+msgstr ""

+

+#. rYCuZ

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id181633215791905\n"

+"help.text"

+msgid "Numeric"

+msgstr ""

+

+#. ywHfC

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id961633215932180\n"

+"help.text"

+msgid "Text"

+msgstr ""

+

+#. KH9Ya

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id651633215984116\n"

+"help.text"

+msgid "Formula"

+msgstr ""

+

+#. nGhov

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id21633215845395\n"

+"help.text"

+msgid "Dates and currency values are considered as numeric values in Calc."

+msgstr ""

+

+#. t87Qx

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id221633216111353\n"

+"help.text"

+msgid "The following example enters numeric values into cells \"A1\" and \"A2\" and inserts a formula in cell \"A3\" that returns the multiplication of these values."

+msgstr ""

+

+#. r6BG6

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"hd_id321633216630043\n"

+"help.text"

+msgid "Accessing Ranges in Different Sheets"

+msgstr ""

+

+#. TFU8U

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id371633216672570\n"

+"help.text"

+msgid "The previous examples used only the active sheet to perform operations. It is possible to access cell ranges in different sheets by their indices or names."

+msgstr ""

+

+#. c3yhF

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id861633216843382\n"

+"help.text"

+msgid "The example below enters a numeric value into cell \"A1\" of the sheet named \"Sheet2\"."

+msgstr ""

+

+#. GpnNS

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id611633217090743\n"

+"help.text"

+msgid "This example can also be implemented in Python as follows:"

+msgstr ""

+

+#. xGQ3k

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id631633217279518\n"

+"help.text"

+msgid "Sheets can also be accessed using zero-based indices indicating which sheet considering the order they appear in the Calc file."

+msgstr ""

+

+#. tSo3e

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id291633264880172\n"

+"help.text"

+msgid "In Basic, instead of using the <literal>getByName</literal> method, use <literal>Sheets(sheetIndex)</literal> as shown next:"

+msgstr ""

+

+#. svDuj

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id891633265000047\n"

+"help.text"

+msgid "This can be done in a similar fashion in Python:"

+msgstr ""

+

+#. 6qHAn

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"hd_id451633265241066\n"

+"help.text"

+msgid "Using the ScriptForge Library"

+msgstr ""

+

+#. 8CkSe

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id731633265268585\n"

+"help.text"

+msgid "The Calc service of the ScriptForge library can be used to get and set cell values as follows:"

+msgstr ""

+

+#. DCJ2E

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id551633265526538\n"

+"help.text"

+msgid "' Loads the ScriptForge library"

+msgstr ""

+

+#. hgDyM

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id581633265527001\n"

+"help.text"

+msgid "' Gets access to the current Calc document"

+msgstr ""

+

+#. Gw4KG

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id751633265527427\n"

+"help.text"

+msgid "' Sets the value of cells A1 and A2"

+msgstr ""

+

+#. VUWVE

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id781633267324929\n"

+"help.text"

+msgid "The <literal>setValue</literal> method can be used to set both numeric and text values. To set a cell formula, use the <literal>setFormula</literal> method."

+msgstr ""

+

+#. jPRii

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id251633265634883\n"

+"help.text"

+msgid "With the Calc service, getting and setting cell values can be done with a single line of code. The example below gets the value from cell \"A1\" and shows it on a message box."

+msgstr ""

+

+#. NzUg4

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id521633608223310\n"

+"help.text"

+msgid "The ScriptForge library also makes it simpler to access ranges in different sheets, as demonstrated in the example below:"

+msgstr ""

+

+#. CCeEh

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"bas_id521633608366292\n"

+"help.text"

+msgid "' Gets cell \"A1\" from the sheet named \"Sheet1\""

+msgstr ""

+

+#. qUTqA

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"bas_id661633608366484\n"

+"help.text"

+msgid "' Gets cell \"B3\" from the sheet named \"Sheet2\""

+msgstr ""

+

+#. mCX5W

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"bas_id501633608516381\n"

+"help.text"

+msgid "' Places the result into cell \"A1\" of sheet \"Report\""

+msgstr ""

+

+#. ZdkEz

+#: read_write_values.xhp

+msgctxt ""

+"read_write_values.xhp\n"

+"par_id431633266057163\n"

+"help.text"

+msgid "The examples above can also be implemented in Python as follows:"

+msgstr ""

+

+"POT-Creation-Date: 2021-10-25 12:48+0200\n"

+#. VwSwW

+msgid "Monitoring is illustrated herewith for Basic and Python languages using object-oriented programming. Assigning <literal>OnLoad</literal> script, to the <menuitem>Open Document</menuitem> event, suffices to initiate and terminate document event monitoring. <menuitem>Tools - Customize</menuitem> menu <menuitem>Events</menuitem> tab is used to assign either scripts."

+#. mCDwK

+msgid "<literal>OnLoad</literal> and <literal>OnUnload</literal> events can be used to respectively set and unset Python programs path. They are described as <menuitem>Open document</menuitem> and <menuitem>Document closed</menuitem>."

+#. PmjAB

+#: python_document_events.xhp

+msgctxt ""

+"python_document_events.xhp\n"

+"N0602\n"

+"help.text"

+msgid "listener = UiDocument() # Initiates listening"

+msgstr ""

+

+#. mPJ3B

+#: python_document_events.xhp

+msgctxt ""

+"python_document_events.xhp\n"

+"N0638\n"

+"help.text"

+msgid "''' Grab application-based Basic script '''"

+msgstr ""

+

+#. qNVD4

+msgid "<menuitem>Start application</menuitem> and <menuitem>Close application</menuitem> events can respectively be used to set and to unset Python path for user scripts or %PRODUCTNAME scripts. In a similar fashion, document based Python libraries or modules can be loaded and released using <menuitem>Open document</menuitem> and <menuitem>Document closed</menuitem> events. Refer to <link href=\"text/sbasic/python/python_import.xhp\" name=\"Importing Python Modules\">Importing Python Modules</link> for more information."

+#. kFpxo

+#: python_shell.xhp

+msgctxt ""

+"python_shell.xhp\n"

+"par_id851633601202270\n"

+"help.text"

+msgid "From a full-featured %PRODUCTNAME installed package, use either Basic or Python:"

+msgstr ""

+

+#. 5HhXz

+msgid "Using a Basic macro"

+msgstr ""

+#. KhWLk

+msgid "Using a Python macro"

+msgstr ""

+#. 3FCJH

+msgid "Example output"

+msgstr ""

+#. MxDtE

+msgid "<image src=\"media/helpimg/python/python_interactive_console.png\" id=\"N0143\"><alt id=\"N0143\">Python Interactive Console</alt></image>"

+msgstr ""

+

+#. fk6sx

+#: python_shell.xhp

+msgctxt ""

+"python_shell.xhp\n"

+"hd_id381633446811095\n"

+"help.text"

+msgid "Using the Terminal"

+msgstr ""

+

+#. CNFdD

+#: python_shell.xhp

+msgctxt ""

+"python_shell.xhp\n"

+"par_id801633601715910\n"

+"help.text"

+msgid "From a %PRODUCTNAME copy included in a GNU/Linux platform, use the terminal as shown:"

+msgstr ""

+

+#. vWPwe

+#: python_shell.xhp

+msgctxt ""

+"python_shell.xhp\n"

+"par_id531633444780190\n"

+"help.text"

+msgid "<literal>whereis</literal> or <literal>type</literal> terminal commands help locate Python interactive console:"

+msgstr ""

+

+#. 8Ei5d

+#: python_shell.xhp

+msgctxt ""

+"python_shell.xhp\n"

+"hd_id311633513620803\n"

+"help.text"

+msgid "Alternative console"

+msgstr ""

+

+#. d8DCA

+#: python_shell.xhp

+msgctxt ""

+"python_shell.xhp\n"

+"par_id81632760673283\n"

+"help.text"

+msgid "Use <link href=\"https://extensions.libreoffice.org/extensions/apso-alternative-script-organizer-for-Python\" name=\"APSO extension\">APSO extension</link> console as an alternative:"

+msgstr ""

+

+#. 6h9CS

+#: python_shell.xhp

+msgctxt ""

+"python_shell.xhp\n"

+"N0144\n"

+"help.text"

+msgid "<image src=\"media/helpimg/python/python_shell.png\" id=\"N0144\"><alt id=\"N0144\">APSO console</alt></image>"

+msgstr ""

+

+#. DNr5W

+#: python_shell.xhp

+msgctxt ""

+"python_shell.xhp\n"

+"par_id351633599611244\n"

+"help.text"

+msgid "<link href=\"text/sbasic/shared/03/sf_exception.html?#PythonShell\" name=\"PythonShell method\"><literal>PythonShell</literal></link> function in <link href=\"text/sbasic/shared/03/sf_exception.html\" name=\"ScriptForge.Exception service\"><literal>ScriptForge.Exception</literal></link> service"

+"POT-Creation-Date: 2021-10-25 12:48+0200\n"

+#. oYudq

+msgid "The <literal>Timer</literal> function measures time in seconds. To measure time in milliseconds use the <link href=\"text/sbasic/shared/03/sf_timer.xhp\" name=\"Timer_link\">Timer service</link> available in the <literal>ScriptForge</literal> library."

+#. pipio

+msgid "<variable id=\"Type_h1\"><link href=\"text/sbasic/shared/03090413.xhp\" name=\"Type Statement\">Type Statement</link></variable>"

+#. MF9nS

+"hd_id51633474369322\n"

+msgid "<variable id=\"IsObject_h1\"><link href=\"text/sbasic/shared/03102800.xhp\" name=\"IsObject Function\">IsObject Function</link></variable>"

+#. jCmJE

+msgid "This function returns <literal>True</literal> for the following object types:"

+#. 4SsCT

+#: 03102800.xhp

+msgctxt ""

+"03102800.xhp\n"

+"par_id3156024\n"

+"help.text"

+msgid "Boolean"

+msgstr ""

+

+#. rTuwL

+#: 03102800.xhp

+msgctxt ""

+"03102800.xhp\n"

+"par_id3148552\n"

+"help.text"

+msgid "<emph>var:</emph> The variable to be tested."

+msgstr ""

+

+#. zHGh5

+msgid "<bookmark_value>Set statement</bookmark_value> <bookmark_value>Nothing object</bookmark_value>"

+msgstr "<bookmark_value>Mid funkcija</bookmark_value><bookmark_value>Mid priekšraksts</bookmark_value>"

+#. DxBM3

+"hd_id791633472607429\n"

+msgid "<variable id=\"EqualUnoObjects_h1\"><link href=\"text/sbasic/shared/03104600.xhp\" name=\"EqualUnoObjects Function\">EqualUnoObjects Function</link></variable>"

+#. Gc4cj

+msgid "Returns <emph>True</emph> if the two specified Basic variables represent the same Uno object instance."

+msgstr ""

+

+#. 9Zx4W

+#: 03104600.xhp

+msgctxt ""

+"03104600.xhp\n"

+"par_id61633530293311\n"

+"help.text"

+msgid "<emph>oObj1, oObj2:</emph> the variables to be tested."

+#. NvGLb

+"par_id771633473462939\n"

+msgid "The example below returns <emph>True</emph> because both <literal>oDoc</literal> and <literal>ThisComponent</literal> are references to the same object:"

+#. 5QGLx

+"par_id181633473874216\n"

+msgid "The example below returns <emph>False</emph> because the assignment creates a copy of the original object. Hence <literal>Struct1</literal> and <literal>Struct2</literal> refer to different object instances."

+#. 36Hj5

+"par_id81634652871848\n"

+msgid "An overflow error will occur when VBA compatibility mode is enabled and the expression value is greater than 255."

+#. dBAZR

+msgid "With Option VBASupport 1: String, with Option VBASupport 0: Variant/String"

+msgstr ""

+#. QpKCT

+msgid "<variable id=\"CreateObject_h1\"><link href=\"text/sbasic/shared/03132400.xhp\">CreateObject Function</link></variable>"

+#. SHgqs

+"par_id191633632167310\n"

+msgid "<emph>type:</emph> the type of the object to be created, as a string."

+#. zEB5S

+msgid "<bookmark_value>Round function (VBA)</bookmark_value>"

+#. oVQUL

+msgid "<variable id=\"Round_VBA_h1\"><link href=\"text/sbasic/shared/03170000.xhp\" name=\"Round Function [VBA]\">Round Function [VBA]</link></variable>"

+#. B6tFP

+msgid "Rounds a numeric value to a specified number of decimal digits."

+msgstr ""

+

+#. yUTFN

+#: 03170000.xhp

+msgctxt ""

+"03170000.xhp\n"

+"par_id741634154499890\n"

+"help.text"

+msgid "This function implements the rounding rule known as \"round-to-even\". With this rule, whenever the difference between the number to be rounded and its nearest integer is equal to 0.5, the number is rounded to the nearest even number. See the examples <link href=\"text/sbasic/shared/03170000.xhp#round_example\" name=\"round_ex_link\">below</link> to learn more about this rule."

+msgstr ""

+

+#. DfnHz

+#: 03170000.xhp

+msgctxt ""

+"03170000.xhp\n"

+"par_id691634217736290\n"

+"help.text"

+msgid "Beware that VBA's <literal>Round</literal> function works differently than %PRODUCTNAME Calc's <literal>Round</literal> function. In Calc, if the difference between the number to be rounded and the nearest integer is exactly 0.5, then the number is rounded up. Hence, in Calc the number 2.5 is rounded to 3 whereas using VBA's <literal>Round</literal> function the value 2.5 is rounded to 2 due to the \"round-to-even\" rule."

+#. GSzGj

+msgid "<emph>expression</emph>: The numeric expression to be rounded."

+#. 9E33v

+msgid "<emph>numdecimalplaces</emph>: Optional argument that specifies the number of decimal digits in the resulting rounded value. The default value is 0."

+msgstr ""

+

+#. oSEiU

+#: 03170000.xhp

+msgctxt ""

+"03170000.xhp\n"

+"par_id541634154843718\n"

+"help.text"

+msgid "The following examples illustrate the \"round-to-even\" rule:"

+msgstr ""

+

+#. 4DLZC

+#: 03170000.xhp

+msgctxt ""

+"03170000.xhp\n"

+"bas_id651634154984931\n"

+"help.text"

+msgid "' Rounding to the nearest integer (decimalplaces = 0)"

+msgstr ""

+

+#. DQwkT

+#: 03170000.xhp

+msgctxt ""

+"03170000.xhp\n"

+"bas_id651634157812537\n"

+"help.text"

+msgid "' Rounding with 2 decimal digits (decimalplaces = 2)"

+#. vSapF

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"tit\n"

+"help.text"

+msgid "Collection Object"

+msgstr ""

+

+#. 5of5h

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"bm_id3149205\n"

+"help.text"

+msgid "<bookmark_value>Collection Object</bookmark_value> <bookmark_value>Collection;Count</bookmark_value>"

+msgstr ""

+

+#. 68sg6

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"hd_id791633472607429\n"

+"help.text"

+msgid "<variable id=\"Collection_h1\"><link href=\"text/sbasic/shared/collection.xhp\" name=\"New_Operator\">Collection Object</link></variable>"

+msgstr ""

+

+#. 7xSei

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id581633961735332\n"

+"help.text"

+msgid "Collections can be used to store items of different types. Each item can be accessed by its index or by an optional key associated with it."

+msgstr ""

+

+#. 9b4kg

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id131633961959816\n"

+"help.text"

+msgid "A <literal>Collection</literal> object has the following methods:"

+msgstr ""

+

+#. XoLQr

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id331633962000259\n"

+"help.text"

+msgid "<emph>Add:</emph> inserts a new item into the collection. Optionally a string value can be defined as the key to the item."

+msgstr ""

+

+#. ddAGy

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id181633962000767\n"

+"help.text"

+msgid "<emph>Count:</emph> returns the number of items in the collection."

+msgstr ""

+

+#. ad7qY

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id521633962001072\n"

+"help.text"

+msgid "<emph>Item:</emph> returns the item in the collection by passing its index or key."

+msgstr ""

+

+#. GX6nx

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id981633962001272\n"

+"help.text"

+msgid "<emph>Remove:</emph> removes the specified item from the collection by its index or key."

+msgstr ""

+

+#. yyWx7

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id221633976539661\n"

+"help.text"

+msgid "Items in a Collection can be accessed either by their indices (as in a 1-based single-dimensional Array) or by their associated keys."

+msgstr ""

+

+#. PheLX

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id811634214809970\n"

+"help.text"

+msgid "The <link href=\"text/sbasic/shared/03/sf_dictionary.xhp\" name=\"SFDic_link\"><literal>ScriptForge Dictionary</literal></link> service extends the <literal>Collection</literal> object by providing supplemental features as key retrieval and replacement, as well as import/export to Array objects and JSON strings."

+msgstr ""

+

+#. pJAht

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"hd_id51633962353863\n"

+"help.text"

+msgid "Creating a Collection"

+msgstr ""

+

+#. 28i8B

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id491633962366024\n"

+"help.text"

+msgid "To create a <literal>Collection</literal> use the <literal>New</literal> keyword. The following example creates a <literal>Collection</literal> object and populates it with three items:"

+msgstr ""

+

+#. 8hHmz

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"hd_id421633962742512\n"

+"help.text"

+msgid "Adding Items"

+msgstr ""

+

+#. G49p7

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"bm_id591633974561425\n"

+"help.text"

+msgid "<bookmark_value>Collection;Add</bookmark_value>"

+msgstr ""

+

+#. 3qnWY

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id261633962766238\n"

+"help.text"

+msgid "The <literal>Add</literal> method can be used to add new items into the <literal>Collection</literal> object."

+msgstr ""

+

+#. htAaY

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id501633974650241\n"

+"help.text"

+msgid "<emph>item:</emph> the item to be added to the <literal>Collection</literal>. May be of any type."

+msgstr ""

+

+#. DUGrx

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id181633974650705\n"

+"help.text"

+msgid "<emph>key:</emph> string value used as the unique key used to identify this value."

+msgstr ""

+

+#. yoEzK

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id391633974651050\n"

+"help.text"

+msgid "<emph>before, after:</emph> optional keyword argument that indicates where the new item will be placed in the <literal>Collection</literal>. Only one of the arguments <literal>before</literal> or <literal>after</literal> can be specified to determine the index or key before which (or after which) the new item is to be placed."

+msgstr ""

+

+#. xcdEF

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id211633962988398\n"

+"help.text"

+msgid "The example below adds two elements into a <literal>Collection</literal>. The first has a key associated with it, whereas the second does not."

+msgstr ""

+

+#. ZKBEQ

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id71633963110632\n"

+"help.text"

+msgid "The <literal>Add</literal> method also supports keyword arguments:"

+msgstr ""

+

+#. ZhTZb

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id941633963225913\n"

+"help.text"

+msgid "Keys must be unique in a <literal>Collection</literal> object. Comparison between keys is <emph>case-insensitive</emph>. Adding duplicated keys will result in a runtime error."

+msgstr ""

+

+#. NVgmj

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id891633975568372\n"

+"help.text"

+msgid "The example below illustrates how to use the <literal>Before</literal> and <literal>After</literal> keyword arguments to determine the position of the item that is being added."

+msgstr ""

+

+#. WxjE9

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id121633976325472\n"

+"help.text"

+msgid "Items in a <literal>Collection</literal> object are assigned an integer index value that starts at 1 and corresponds to the order in which they were added."

+msgstr ""

+

+#. 2Lrc6

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"hd_id141633977141797\n"

+"help.text"

+msgid "Accessing Items"

+msgstr ""

+

+#. DDdKC

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"bm_id481633977601834\n"

+"help.text"

+msgid "<bookmark_value>Collection;Item</bookmark_value>"

+msgstr ""

+

+#. MquEn

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id431633977156315\n"

+"help.text"

+msgid "Use the <literal>Item</literal> method to access a given item by its index or key."

+msgstr ""

+

+#. DCFTg

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id261633976447187\n"

+"help.text"

+msgid "<emph>index:</emph> an integer value specifying the index of the item to be returned."

+msgstr ""

+

+#. mqA85

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id51633976782487\n"

+"help.text"

+msgid "<emph>key:</emph> a string value specifying the key of the item to be returned."

+msgstr ""

+

+#. egnJW

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"hd_id651633976030220\n"

+"help.text"

+msgid "Removing Items"

+msgstr ""

+

+#. BdBa3

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"bm_id311633977567197\n"

+"help.text"

+msgid "<bookmark_value>Collection;Remove</bookmark_value>"

+msgstr ""

+

+#. Wteju

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id391633976125206\n"

+"help.text"

+msgid "Use the <literal>Remove</literal> method to delete items from a <literal>Collection</literal> object."

+msgstr ""

+

+#. sHVAN

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id121633976268027\n"

+"help.text"

+msgid "Items can be removed either by their indices or key values."

+msgstr ""

+

+#. o9Eyd

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id261633976447289\n"

+"help.text"

+msgid "<emph>index:</emph> an integer value specifying the index of the item to be removed."

+msgstr ""

+

+#. 8TMiC

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id51633976782455\n"

+"help.text"

+msgid "<emph>key:</emph> a string value specifying the key of the item to be removed."

+msgstr ""

+

+#. WpHmn

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"hd_id491633978085731\n"

+"help.text"

+msgid "Iterating Over all Items"

+msgstr ""

+

+#. FVzmC

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id91633978099143\n"

+"help.text"

+msgid "It is possible to use a <literal>For Each ... Next</literal> statement to iterate over all items in a <literal>Collection</literal>."

+msgstr ""

+

+#. EWDWE

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"hd_id191634215349347\n"

+"help.text"

+msgid "Clearing a Collection"

+msgstr ""

+

+#. V4EZw

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"par_id891634215363485\n"

+"help.text"

+msgid "To remove all items from a <literal>Collection</literal> object call the <literal>Remove</literal> method for each item, as illustrated in the example below:"

+msgstr ""

+

+#. tUMtQ

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"bas_id681634215646028\n"

+"help.text"

+msgid "' Create a sample Collection with two entries"

+msgstr ""

+

+#. Yy5nP

+#: collection.xhp

+msgctxt ""

+"collection.xhp\n"

+"bas_id391634215647196\n"

+"help.text"

+msgid "' Removes all items in the collection"

+msgstr ""

+

+#. 6HFov

+msgid "<literal>Option Compatible</literal> extends %PRODUCTNAME Basic compiler and runtime, allowing supplemental language constructs to Basic."

+#. tYUK6

+#: is_keyword.xhp

+msgctxt ""

+"is_keyword.xhp\n"

+"tit\n"

+"help.text"

+msgid "Is Operator"

+msgstr ""

+

+#. xvBgn

+#: is_keyword.xhp

+msgctxt ""

+"is_keyword.xhp\n"

+"bm_id3149205\n"

+"help.text"

+msgid "<bookmark_value>Is Operator</bookmark_value>"

+msgstr ""

+

+#. 7otAB

+#: is_keyword.xhp

+msgctxt ""

+"is_keyword.xhp\n"

+"hd_id791633472607429\n"

+"help.text"

+msgid "<variable id=\"IsOperator_h1\"><link href=\"text/sbasic/shared/is_keyword.xhp\" name=\"Is_Operator\">Is Operator</link></variable>"

+msgstr ""

+

+#. mwGMA

+#: is_keyword.xhp

+msgctxt ""

+"is_keyword.xhp\n"

+"par_id3145090\n"

+"help.text"

+msgid "Tests if two Basic variables refer to the same object instance."

+msgstr ""

+

+#. HTVQA

+#: is_keyword.xhp

+msgctxt ""

+"is_keyword.xhp\n"

+"par_id441633531311929\n"

+"help.text"

+msgid "If <literal>oObj1</literal> and <literal>oObj2</literal> are references to the same object instance, the result will be <emph>True</emph>."

+msgstr ""

+

+#. akugg

+#: is_keyword.xhp

+msgctxt ""

+"is_keyword.xhp\n"

+"par_id771633473462939\n"

+"help.text"

+msgid "The example below first defines a new type <literal>Student</literal>. Calling <literal>TestObjects</literal> creates the object <literal>oStudent1</literal> as a new object of this type."

+msgstr ""

+

+#. mAAho

+#: is_keyword.xhp

+msgctxt ""

+"is_keyword.xhp\n"

+"par_id841633532400710\n"

+"help.text"

+msgid "The assignment <literal>oStudent2 = oStudent1</literal> actually copies the reference to the same object. Hence the result of applying the <literal>Is</literal> operator is <emph>True</emph>."

+msgstr ""

+

+#. mvVuR

+#: is_keyword.xhp

+msgctxt ""

+"is_keyword.xhp\n"

+"par_id181633473874216\n"

+"help.text"

+msgid "The example below returns <emph>False</emph> because <literal>oStudent1</literal> and <literal>oStudent2</literal> are references to two different object instances, each created with the <literal>New</literal> operator."

+msgstr ""

+

+#. 44MBv

+#: new_keyword.xhp

+msgctxt ""

+"new_keyword.xhp\n"

+"tit\n"

+"help.text"

+msgid "New Operator"

+msgstr ""

+

+#. 8iBmc

+#: new_keyword.xhp

+msgctxt ""

+"new_keyword.xhp\n"

+"bm_id3149205\n"

+"help.text"

+msgid "<bookmark_value>New Operator</bookmark_value>"

+msgstr ""

+

+#. T3AA8

+#: new_keyword.xhp

+msgctxt ""

+"new_keyword.xhp\n"

+"hd_id791633472607429\n"

+"help.text"

+msgid "<variable id=\"NewOperator_h1\"><link href=\"text/sbasic/shared/new_keyword.xhp\" name=\"New_Operator\">New Operator</link></variable>"

+msgstr ""

+

+#. BWufp

+#: new_keyword.xhp

+msgctxt ""

+"new_keyword.xhp\n"

+"par_id3145090\n"

+"help.text"

+msgid "Use the <literal>New</literal> operator to instantiate objects of user-defined types, as well as Uno services, structs and enumerations."

+msgstr ""

+

+#. uDGEZ

+#: new_keyword.xhp

+msgctxt ""

+"new_keyword.xhp\n"

+"par_id831633630704012\n"

+"help.text"

+msgid "The <literal>New</literal> operator can be used either during variable declaration or in an assignment operation."

+msgstr ""

+

+#. r6osC

+#: new_keyword.xhp

+msgctxt ""

+"new_keyword.xhp\n"

+"par_id621633630563936\n"

+"help.text"

+msgid "The following example uses the <literal>New</literal> operator to create an instance of the <literal>PropertyValue</literal> Uno struct."

+msgstr ""

+

+#. nPNvc

+#: new_keyword.xhp

+msgctxt ""

+"new_keyword.xhp\n"

+"bas_id631633630856218\n"

+"help.text"

+msgid "' Instantiating the object during variable declaration"

+msgstr ""

+

+#. Ts8iC

+#: new_keyword.xhp

+msgctxt ""

+"new_keyword.xhp\n"

+"bas_id11633631135918\n"

+"help.text"

+msgid "' The same can be accomplished with an assignment"

+msgstr ""

+

+#. 6RJcJ

+#: new_keyword.xhp

+msgctxt ""

+"new_keyword.xhp\n"

+"par_id971633631328827\n"

+"help.text"

+msgid "The example below creates a new type <literal>Student</literal> and instantiates an object of this type:"

+msgstr ""

+

+"POT-Creation-Date: 2021-10-25 12:48+0200\n"

+#. Poeai

+msgid "<bookmark_value>BASIC ScriptForge library</bookmark_value> <bookmark_value>Python scriptforge module</bookmark_value>"

+#. eotwE

+msgid "To learn more about how to create and execute Python scripts using the <literal>ScriptForge</literal> library, read the help page <link href=\"text/sbasic/shared/03/sf_intro.xhp\" name=\"sfintro_link\">Creating Python Scripts with ScriptForge</link>."

+#. LtaTT

+msgid "The Dictionary service is similar to the built-in %PRODUCTNAME Basic <literal>Collection</literal> object, however with more features. For example, <literal>Collection</literal> objects do not support the retrieval of keys. Moreover, Dictionaries provide additional capabilities as replacing keys, testing if a specific key already exists and converting the Dictionary into an Array object or JSON string."

+#. cPtYB

+msgid "Visit <link href=\"text/sbasic/python/main0000.xhp#\" name=\"pyscripts_link\">%PRODUCTNAME Python Scripts Help</link> for more information on Python scripting using %PRODUCTNAME."

+#. DxnDG

+msgid "<variable id=\"SessionService\"><link href=\"text/sbasic/shared/03/sf_session.xhp\" name=\"Session service\"><literal>ScriptForge.Session</literal> service</link></variable>"

+#. o6DUm

+msgid "Read the help page <link href=\"text/sbasic/python/python_locations.xhp\" name=\"pylocation_link\">Python Scripts Organization and Location</link> to learn more about where Python scripts can be stored."

+"POT-Creation-Date: 2021-10-25 12:48+0200\n"

+#. yvzAm

+msgid "This submenu lists the toolbars that are available in spreadsheets. This overview describes the default toolbar configuration for %PRODUCTNAME."

+"POT-Creation-Date: 2021-10-25 12:48+0200\n"

+#. BB9Ze

+msgid "<bookmark_value>matrices; functions</bookmark_value><bookmark_value>Function Wizard; arrays</bookmark_value><bookmark_value>array formulas</bookmark_value><bookmark_value>inline array constants</bookmark_value><bookmark_value>formulas; arrays</bookmark_value><bookmark_value>functions; array functions</bookmark_value><bookmark_value>editing; array formulas</bookmark_value><bookmark_value>copying; array formulas</bookmark_value><bookmark_value>deleting; array formulas</bookmark_value><bookmark_value>adjusting array ranges</bookmark_value><bookmark_value>calculating; conditional calculations</bookmark_value><bookmark_value>matrices; calculations</bookmark_value><bookmark_value>conditional calculations with arrays</bookmark_value><bookmark_value>implicit array handling</bookmark_value><bookmark_value>forced array handling</bookmark_value>"

+#. 6zGAy

+msgid "The cells in a results array are automatically protected against changes. However, you can edit, delete or copy the array formula by selecting the entire array cell range."

+#. Qi4kV

+msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> + <keycode>/</keycode>, where <keycode>/</keycode> is the division key on the numeric keypad."

+#. Tes4E

+#: 04060107.xhp

+msgctxt ""

+"04060107.xhp\n"

+"hd_id541633516074226\n"

+"help.text"

+msgid "Deleting Array Formulae"

+msgstr ""

+

+#. adAax

+#: 04060107.xhp

+msgctxt ""

+"04060107.xhp\n"

+"par_id681633516103267\n"

+"help.text"

+msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> + <keycode>/</keycode>, where <keycode>/</keycode> is the division key on the numeric keypad."

+msgstr ""

+

+#. 5xB8E

+#: 04060107.xhp

+msgctxt ""

+"04060107.xhp\n"

+"par_id61633516164519\n"

+"help.text"

+msgid "Press <keycode>Delete</keycode> to delete the array contents, including the array formula, or press <keycode>Backspace</keycode> and this brings up the <link href=\"text/scalc/01/02150000.xhp\" name=\"delete contents\">Delete Contents</link> dialog box. Select <emph>Formula</emph> or <emph>Delete All</emph> and click <emph>OK</emph>."

+msgstr ""

+

+#. BCsAA

+msgid "<image id=\"img_id811632804983642\" src=\"cmd/sc_togglemergecells.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id921632804983642\">Icon Merge and Center Cells</alt></image>"

+#. czFkz

+#: func_arabic.xhp

+msgctxt ""

+"func_arabic.xhp\n"

+"tit\n"

+"help.text"

+msgid "ARABIC Function"

+msgstr ""

+

+#. ze8wK

+#: func_arabic.xhp

+msgctxt ""

+"func_arabic.xhp\n"

+"bm_id831542233029549\n"

+"help.text"

+msgid "<bookmark_value>ARABIC function</bookmark_value> <bookmark_value>text functions;convert roman numbers</bookmark_value>"

+msgstr ""

+

+#. BNUYi

+#: func_arabic.xhp

+msgctxt ""

+"func_arabic.xhp\n"

+"hd_id881628776094597\n"

+"help.text"

+msgid "<variable id=\"Arabic_h1\"><link href=\"text/scalc/01/func_arabic.xhp\" name=\"function ARABIC\">ARABIC</link></variable>"

+msgstr ""

+

+#. xPXrU

+#: func_arabic.xhp

+msgctxt ""

+"func_arabic.xhp\n"

+"par_id541542230672101\n"

+"help.text"

+msgid "<variable id=\"func_arabic_desc\"><ahelp hid=\".\">Returns the numeric value corresponding to a Roman number expressed as text.</ahelp></variable>"

+msgstr ""

+

+#. 2UE9g

+#: func_arabic.xhp

+msgctxt ""

+"func_arabic.xhp\n"

+"par_id151634221012221\n"

+"help.text"

+msgid "The largest Roman number that can be converted is MMMCMXCIX (or one of its simplified versions), which is equivalent to 3999."

+msgstr ""

+

+#. AueXr

+#: func_arabic.xhp

+msgctxt ""

+"func_arabic.xhp\n"

+"par_id701542231253817\n"

+"help.text"

+msgid "<input>ARABIC(Text)</input>"

+msgstr ""

+

+#. sWMEb

+#: func_arabic.xhp

+msgctxt ""

+"func_arabic.xhp\n"

+"par_id621542232197446\n"

+"help.text"

+msgid "<emph>Text</emph>: text representing a Roman number."

+msgstr ""

+

+#. WcE8r

+#: func_arabic.xhp

+msgctxt ""

+"func_arabic.xhp\n"

+"par_id451628776707264\n"

+"help.text"

+msgid "<input>=ARABIC(\"MXIV\")</input> returns the numeric value 1014."

+msgstr ""

+

+#. hDmDF

+#: func_arabic.xhp

+msgctxt ""

+"func_arabic.xhp\n"

+"par_id101628778036375\n"

+"help.text"

+msgid "<input>=ARABIC(\"MMII\")</input> returns the numeric value 2002."

+msgstr ""

+

+#. XAwC8

+#: func_arabic.xhp

+msgctxt ""

+"func_arabic.xhp\n"

+"par_id101628778036134\n"

+"help.text"

+msgid "<input>=ARABIC(\"\")</input> returns 0."

+msgstr ""

+

+#. CdgXz

+msgid "Refer to the <link href=\"text/shared/01/05020300.xhp\" name=\"num_format_link\">Numbers / Format</link> help page to learn how to change the format of numbers in a cell."

+#. FuCCt

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"tit\n"

+"help.text"

+msgid "ROMAN Function"

+msgstr ""

+

+#. JqcvP

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"bm_id831542233029549\n"

+"help.text"

+msgid "<bookmark_value>ROMAN function</bookmark_value> <bookmark_value>text functions;convert to roman numbers</bookmark_value>"

+msgstr ""

+

+#. uXEPr

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"hd_id881628776094597\n"

+"help.text"

+msgid "<variable id=\"Roman_h1\"><link href=\"text/scalc/01/func_roman.xhp\" name=\"function ROMAN\">ROMAN</link></variable>"

+msgstr ""

+

+#. pdMgk

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"par_id541542230672101\n"

+"help.text"

+msgid "<variable id=\"func_roman_desc\"><ahelp hid=\".\">Converts a number into a Roman numeral. The value range must be between 0 and 3999. A simplification mode can be specified in the range from 0 to 4.</ahelp></variable>"

+msgstr ""

+

+#. tRsoC

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"par_id701542231253817\n"

+"help.text"

+msgid "<input>ROMAN(Number [; Mode])</input>"

+msgstr ""

+

+#. rz4bH

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"par_id621542232197446\n"

+"help.text"

+msgid "<emph>Number</emph>: the number that is to be converted into a Roman numeral."

+msgstr ""

+

+#. bfvWL

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"par_id621542232197337\n"

+"help.text"

+msgid "<emph>Mode</emph>: optional value ranging between 0 to 4 that indicates the degree of simplification to be used in the conversion. The higher the value, the greater is the simplification of the Roman number."

+msgstr ""

+

+#. BBUCq

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"par_id451628776707264\n"

+"help.text"

+msgid "<input>=ROMAN(999)</input> returns \"CMXCIX\" (uses simplification mode equal to zero, which is the default)."

+msgstr ""

+

+#. mBktA

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"par_id101628778036375\n"

+"help.text"

+msgid "<input>=ROMAN(999;0)</input> returns \"CMXCIX\"."

+msgstr ""

+

+#. fGqPj

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"par_id101628778036134\n"

+"help.text"

+msgid "<input>=ROMAN(999;1)</input> returns \"LMVLIV\"."

+msgstr ""

+

+#. qBbFo

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"par_id101628778036278\n"

+"help.text"

+msgid "<input>=ROMAN(999;2)</input> returns \"XMIX\"."

+msgstr ""

+

+#. AY5jP

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"par_id101628778036364\n"

+"help.text"

+msgid "<input>=ROMAN(999;3)</input> returns \"VMIV\"."

+msgstr ""

+

+#. B2aqT

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"par_id101628778036008\n"

+"help.text"

+msgid "<input>=ROMAN(999;4)</input> returns \"IM\"."

+msgstr ""

+

+#. CBuwx

+#: func_roman.xhp

+msgctxt ""

+"func_roman.xhp\n"

+"par_id101628778036019\n"

+"help.text"

+msgid "<input>=ROMAN(0)</input> returns \"\" (empty text)."

+msgstr ""

+

+"POT-Creation-Date: 2021-10-25 12:48+0200\n"

+#. dP2GC

+msgid "<bookmark_value>formats; text as numbers</bookmark_value> <bookmark_value>time format conversion</bookmark_value> <bookmark_value>date formats;conversion</bookmark_value> <bookmark_value>converting;text, into numbers</bookmark_value>"

+#. p9t4t

+msgid "The text to number conversion can be customized in the <link href=\"text/shared/optionen/detailedcalculation.xhp\" name=\"detailed_link\">Detailed Calculation Settings</link> option."

+#. 7fDQ9

+msgid "Go to <menuitem>Data - More Filters - Standard Filter</menuitem>. This opens the <link href=\"text/shared/02/12090100.xhp\" name=\"std_dialog_link\"> Standard Filter</link> dialog."

+#. FFV5z

+msgid "<bookmark_value>merge/merging cells</bookmark_value> <bookmark_value>unmerge/unmerging cells</bookmark_value> <bookmark_value>split/splitting cells</bookmark_value>"

+#. fAjCD

+msgid "Or, choose <menuitem>Format - Merge and Unmerge Cells - Merge Cells</menuitem>"

+#. 6VxQA

+msgid "Or, choose <menuitem>Format - Merge and Unmerge Cells - Merge and Center Cells</menuitem>"

+#. uiNiD

+msgid "Or, choose <menuitem>Format - Merge and Unmerge Cells - Unmerge Cells</menuitem>."

+#. HJEzN

+msgid "Or, toggle <menuitem>Format - Merge and Unmerge Cells - Merge and Center Cells</menuitem>"

+"POT-Creation-Date: 2021-10-20 13:08+0200\n"

+#. A9JMA

+msgid "<link href=\"text/sdatabase/dabawiz02text.xhp\">Set up text file connection</link>"

+#. FWLbE

+msgid "<link href=\"text/sdatabase/dabawiz02access.xhp\">Set up Microsoft Access connection</link>"

+#. LE9Go

+msgid "<link href=\"text/sdatabase/dabawiz02ado.xhp\">Set up ADO connection</link>"

+#. BU6uL

+msgid "<link href=\"text/sdatabase/dabawiz02dbase.xhp\">Set up dBASE connection</link>"

+#. TBaXt

+msgid "<link href=\"text/sdatabase/dabawiz02jdbc.xhp\">Set up JDBC connection</link>"

+#. F3Gju

+msgid "<link href=\"text/sdatabase/dabawiz02oracle.xhp\">Set up Oracle database connection</link>"

+#. atGau

+msgid "<link href=\"text/sdatabase/dabawiz02odbc.xhp\">ODBC settings</link>"

+#. wGT7W

+msgid "<link href=\"text/sdatabase/dabawiz02spreadsheet.xhp\">Set up Spreadsheet connection</link>"

+#. 9fLay

+msgid "<link href=\"text/sdatabase/dabawiz02text.xhp\">Set up text file connection</link>"

+#. DeFrC

+msgid "<link href=\"text/sdatabase/dabawiz02access.xhp\">Set up Microsoft Access or Microsoft Access 2007 connection</link>"

+#. 6qgTE

+msgid "<link href=\"text/sdatabase/dabawiz02ado.xhp\">Set up ADO connection</link>"

+#. oiGwh

+msgid "<link href=\"text/sdatabase/dabawiz02jdbc.xhp\">Set up JDBC connection</link>"

+#. N55Na

+msgid "<link href=\"text/sdatabase/dabawiz02oracle.xhp\">Set up Oracle database connection</link>"

+#. c4YLM

+msgid "<link href=\"text/sdatabase/dabawiz02odbc.xhp\">ODBC settings</link>"

+#. zpfrv

+msgid "<link href=\"text/sdatabase/dabawiz02spreadsheet.xhp\">Set up Spreadsheet connection</link>"

+msgstr ""

+

+#. SJaiE

+#: dabawiz02.xhp

+msgctxt ""

+"dabawiz02.xhp\n"

+"tit\n"

+"help.text"

+msgid "Save and proceed"

+msgstr ""

+

+#. Hjhen

+#: dabawiz02.xhp

+msgctxt ""

+"dabawiz02.xhp\n"

+"par_idN10544\n"

+"help.text"

+msgid "<link href=\"text/sdatabase/dabawiz02.xhp\">Save and proceed</link>"

+msgstr ""

+

+#. CECqo

+#: dabawiz02.xhp

+msgctxt ""

+"dabawiz02.xhp\n"

+"par_idN10554\n"

+"help.text"

+msgid "<ahelp hid=\".\">Specifies whether you want to register the database, open the database for editing, or insert a new table.</ahelp>"

+msgstr ""

+

+#. v3hCS

+#: dabawiz02.xhp

+msgctxt ""

+"dabawiz02.xhp\n"

+"par_idN10557\n"

+"help.text"

+msgid "Yes, register the Database for me"

+msgstr ""

+

+#. 6iEY2

+#: dabawiz02.xhp

+msgctxt ""

+"dabawiz02.xhp\n"

+"par_idN105B4\n"

+"help.text"

+msgid "<ahelp hid=\".\">Select to register the database within your user copy of %PRODUCTNAME. After registering, the database is displayed in the <emph>View - Data Sources</emph> window. You must register a database to be able to insert the database fields in a document (Insert - Field - More Fields) or in a mail merge.</ahelp>"

+msgstr ""

+

+#. BDPbo

+#: dabawiz02.xhp

+msgctxt ""

+"dabawiz02.xhp\n"

+"par_idN105B7\n"

+"help.text"

+msgid "No, do not register the database"

+msgstr ""

+

+#. PHFCG

+#: dabawiz02.xhp

+msgctxt ""

+"dabawiz02.xhp\n"

+"par_idN105BB\n"

+"help.text"

+msgid "<ahelp hid=\".\">Select to keep the database information only within the created database file.</ahelp>"

+msgstr ""

+

+#. xJFV8

+#: dabawiz02.xhp

+msgctxt ""

+"dabawiz02.xhp\n"

+"par_idN1055B\n"

+"help.text"

+msgid "Open the database for editing"

+msgstr ""

+

+#. 2oDVV

+#: dabawiz02.xhp

+msgctxt ""

+"dabawiz02.xhp\n"

+"par_idN105C6\n"

+"help.text"

+msgid "<ahelp hid=\".\">Select to display the database file, where you can edit the database structure.</ahelp>"

+msgstr ""

+

+#. uUaJe

+#: dabawiz02.xhp

+msgctxt ""

+"dabawiz02.xhp\n"

+"par_idN1055F\n"

+"help.text"

+msgid "Create tables using the table wizard"

+msgstr ""

+

+#. F4TTD

+#: dabawiz02.xhp

+msgctxt ""

+"dabawiz02.xhp\n"

+"par_idN105D1\n"

+"help.text"

+msgid "<ahelp hid=\".\">Select to call the <link href=\"text/shared/explorer/database/tablewizard00.xhp\">Table Wizard</link> after the Database Wizard is finished.</ahelp>"

+msgstr ""

+

+#. YnZ24

+#: dabawiz02access.xhp

+msgctxt ""

+"dabawiz02access.xhp\n"

+"tit\n"

+"help.text"

+msgid "Microsoft Access Connection"

+msgstr ""

+

+#. uUAxL

+#: dabawiz02access.xhp

+msgctxt ""

+"dabawiz02access.xhp\n"

+"bm_id2755516\n"

+"help.text"

+msgid "<bookmark_value>Access databases (base)</bookmark_value><bookmark_value>Microsoft Office;Access databases (base)</bookmark_value>"

+msgstr ""

+

+#. iPpLv

+#: dabawiz02access.xhp

+msgctxt ""

+"dabawiz02access.xhp\n"

+"par_idN1053D\n"

+"help.text"

+msgid "<variable id=\"access\"><link href=\"text/sdatabase/dabawiz02access.xhp\">Microsoft Access Connection</link></variable>"

+msgstr ""

+

+#. eMbAE

+#: dabawiz02access.xhp

+msgctxt ""

+"dabawiz02access.xhp\n"

+"par_idN10541\n"

+"help.text"

+msgid "<ahelp hid=\".\">Specifies the settings for importing a database file in Microsoft Access or Access 2007 format.</ahelp>"

+msgstr ""

+

+#. FJFQi

+#: dabawiz02access.xhp

+msgctxt ""

+"dabawiz02access.xhp\n"

+"par_id1142772\n"

+"help.text"

+msgid "See also the English Wiki page <link href=\"https://wiki.documentfoundation.org/MSA-Base_Faq\" name=\"wiki.documentfoundation.org MS Access Base FAQ\">https://wiki.documentfoundation.org/MSA-Base_Faq</link>."

+msgstr ""

+

+#. 7vvBT

+#: dabawiz02access.xhp

+msgctxt ""

+"dabawiz02access.xhp\n"

+"par_idN10544\n"

+"help.text"

+msgid "Microsoft Access database file"

+msgstr ""

+

+#. 5nSHE

+#: dabawiz02access.xhp

+msgctxt ""

+"dabawiz02access.xhp\n"

+"par_idN10548\n"

+"help.text"

+msgid "<ahelp hid=\".\">Specifies the path to the database file.</ahelp>"

+msgstr ""

+

+#. cKU7v

+#: dabawiz02access.xhp

+msgctxt ""

+"dabawiz02access.xhp\n"

+"par_idN1054B\n"

+"help.text"

+msgid "Browse"

+msgstr ""

+

+#. k4EM5

+#: dabawiz02access.xhp

+msgctxt ""

+"dabawiz02access.xhp\n"

+"par_idN1054F\n"

+"help.text"

+msgid "<ahelp hid=\".\">Click to open a file selection dialog.</ahelp>"

+msgstr ""

+

+#. gjtnv

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"tit\n"

+"help.text"

+msgid "ADO Connection"

+msgstr ""

+

+#. jJtjy

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"bm_id7565233\n"

+"help.text"

+msgid "<bookmark_value>ADO databases (Base)</bookmark_value><bookmark_value>MS ADO interface (Base)</bookmark_value><bookmark_value>databases;ADO (Base)</bookmark_value>"

+msgstr ""

+

+#. 9Yxn5

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN1054C\n"

+"help.text"

+msgid "<variable id=\"ado\"><link href=\"text/sdatabase/dabawiz02ado.xhp\">ADO Connection</link></variable>"

+msgstr ""

+

+#. Gi6xc

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN10550\n"

+"help.text"

+msgid "<ahelp hid=\".\">Specifies the options for adding an ADO (Microsoft ActiveX Data Objects) database.</ahelp>"

+msgstr ""

+

+#. pGwdA

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN10565\n"

+"help.text"

+msgid "The ADO interface is a Microsoft Windows proprietary container for connecting to databases."

+msgstr ""

+

+#. mVEj7

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN10568\n"

+"help.text"

+msgid "$[officename] requires the Microsoft Data Access Components (MDAC) to use the ADO interface. Microsoft Windows 2000 and XP include these components by default."

+msgstr ""

+

+#. CWQxx

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN1056B\n"

+"help.text"

+msgid "Data source URL"

+msgstr ""

+

+#. dEHxg

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN1056F\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter the data source URL.</ahelp>"

+msgstr ""

+

+#. AS8Ye

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN10572\n"

+"help.text"

+msgid "Example URLs"

+msgstr ""

+

+#. DGA9a

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN10576\n"

+"help.text"

+msgid "To connect to an Access 2000 file, use the format:"

+msgstr ""

+

+#. EYrtv

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN10579\n"

+"help.text"

+msgid "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:\\Access\\nwind2000.mdb"

+msgstr ""

+

+#. JrQva

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN1057C\n"

+"help.text"

+msgid "To connect with a name to a catalog on a Microsoft SQL server that has a name turner, enter:"

+msgstr ""

+

+#. HeHcf

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN1057F\n"

+"help.text"

+msgid "PROVIDER=sqloledb;DATA SOURCE=turner;INITIAL CATALOG=First"

+msgstr ""

+

+#. eqFwU

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN10582\n"

+"help.text"

+msgid "To access an ODBC driver as a provider:"

+msgstr ""

+

+#. cibKq

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN10585\n"

+"help.text"

+msgid "DSN=SQLSERVER"

+msgstr ""

+

+#. FFdf5

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN10588\n"

+"help.text"

+msgid "Browse"

+msgstr ""

+

+#. xmZQB

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN1058C\n"

+"help.text"

+msgid "<ahelp hid=\".\">Click to open a database selection dialog.</ahelp>"

+msgstr ""

+

+#. Bi3az

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN10596\n"

+"help.text"

+msgid "A user name can have a maximum of 18 characters."

+msgstr ""

+

+#. iifVJ

+#: dabawiz02ado.xhp

+msgctxt ""

+"dabawiz02ado.xhp\n"

+"par_idN10599\n"

+"help.text"

+msgid "A password must contain 3 to 18 characters."

+msgstr ""

+

+#. mxSCU

+#: dabawiz02dbase.xhp

+msgctxt ""

+"dabawiz02dbase.xhp\n"

+"tit\n"

+"help.text"

+msgid "dBASE Connection"

+msgstr ""

+

+#. vDDMj

+#: dabawiz02dbase.xhp

+msgctxt ""

+"dabawiz02dbase.xhp\n"

+"par_idN1054A\n"

+"help.text"

+msgid "<variable id=\"dbase\"><link href=\"text/sdatabase/dabawiz02dbase.xhp\">dBASE Connection</link></variable>"

+msgstr ""

+

+#. 3rzAr

+#: dabawiz02dbase.xhp

+msgctxt ""

+"dabawiz02dbase.xhp\n"

+"par_idN10556\n"

+"help.text"

+msgid "Path to the dBASE files"

+msgstr ""

+

+#. 9qfqi

+#: dabawiz02dbase.xhp

+msgctxt ""

+"dabawiz02dbase.xhp\n"

+"par_idN1055A\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter the path to the dBASE *.dbf files.</ahelp>"

+msgstr ""

+

+#. JtErQ

+#: dabawiz02dbase.xhp

+msgctxt ""

+"dabawiz02dbase.xhp\n"

+"par_idN10571\n"

+"help.text"

+msgid "Browse"

+msgstr ""

+

+#. VHbhH

+#: dabawiz02dbase.xhp

+msgctxt ""

+"dabawiz02dbase.xhp\n"

+"par_idN10575\n"

+"help.text"

+msgid "<ahelp hid=\".\">Open a path selection dialog.</ahelp>"

+msgstr ""

+

+#. n9AxK

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"tit\n"

+"help.text"

+msgid "JDBC Connection"

+msgstr ""

+

+#. BSPeu

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"bm_id3726920\n"

+"help.text"

+msgid "<bookmark_value>JDBC; databases (Base)</bookmark_value><bookmark_value>databases; JDBC (Base)</bookmark_value>"

+msgstr ""

+

+#. nSDvF

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN105FC\n"

+"help.text"

+msgid "<variable id=\"jdbc\"><link href=\"text/sdatabase/dabawiz02jdbc.xhp\">JDBC Connection</link></variable>"

+msgstr ""

+

+#. 4vvDv

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10600\n"

+"help.text"

+msgid "<ahelp hid=\".\">Specifies the options to access a <link href=\"text/shared/00/00000005.xhp#jdbc\" name=\"JDBC\">JDBC</link> database.</ahelp>"

+msgstr ""

+

+#. MAM5R

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10623\n"

+"help.text"

+msgid "JDBC Examples"

+msgstr ""

+

+#. FAkVF

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10627\n"

+"help.text"

+msgid "<item type=\"productname\">You can use a JDBC driver class to connect to a JDBC database from %PRODUCTNAME</item>. The driver class is provided by the database manufacturer. Two examples of JDBC databases are Oracle and MySQL."

+msgstr ""

+

+#. ehUZi

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN1062D\n"

+"help.text"

+msgid "The driver classes must be added to %PRODUCTNAME in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME - Advanced</menuitem>."

+msgstr ""

+

+#. KTrhC

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10634\n"

+"help.text"

+msgid "Oracle database"

+msgstr ""

+

+#. Br2JC

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10638\n"

+"help.text"

+msgid "You can use a JDBC driver to access an Oracle database from Solaris or Linux. To access the database from Windows, you need an ODBC driver."

+msgstr ""

+

+#. pei94

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN1064B\n"

+"help.text"

+msgid "On UNIX, ensure that the Oracle database client is installed with JDBC support. The JDBC driver class for the Solaris Oracle client version 8.x is located in the <Oracle client>/product/jdbc/lib/classes111.zip directory. You can also download the latest version from the Oracle web site."

+msgstr ""

+

+#. DifQh

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10661\n"

+"help.text"

+msgid "In the <emph>Data source URL</emph> box, enter the location of the Oracle database server. The syntax of the URL depends on the database type. See the documentation that came with the JDBC driver for more information."

+msgstr ""

+

+#. BBFrJ

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10668\n"

+"help.text"

+msgid "For an Oracle database, the syntax of the URL is:"

+msgstr ""

+

+#. 7tbob

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN1066B\n"

+"help.text"

+msgid "oracle:thin:@hostname:port:database_name"

+msgstr ""

+

+#. RiDDR

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10674\n"

+"help.text"

+msgid "hostname is the name of the machine that runs the Oracle database. You can also replace hostname with the IP address of the server."

+msgstr ""

+

+#. sFfhQ

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10678\n"

+"help.text"

+msgid "port is the port where the Oracle database listens. Ask your database administrator for the correct port address."

+msgstr ""

+

+#. GDkVv

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN1067C\n"

+"help.text"

+msgid "database_name is the name of the Oracle database. Ask your database administrator for the correct name."

+msgstr ""

+

+#. aQiqR

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN1067F\n"

+"help.text"

+msgid "MySQL database"

+msgstr ""

+

+#. FEV5u

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10683\n"

+"help.text"

+msgid "The driver for the MySQL database is available on the MySQL web site."

+msgstr ""

+

+#. p2v67

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10689\n"

+"help.text"

+msgid "The syntax for a MySQL database is:"

+msgstr ""

+

+#. wEDsL

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN1068C\n"

+"help.text"

+msgid "mysql://hostname:port/database_name"

+msgstr ""

+

+#. m5Kcx

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10695\n"

+"help.text"

+msgid "<ahelp hid=\".\">hostname is the name of the machine that runs the MySQL database.</ahelp> You can also replace hostname with the IP address of the server."

+msgstr ""

+

+#. LCpew

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN10699\n"

+"help.text"

+msgid "port is the default port for MySQL databases, namely 3306."

+msgstr ""

+

+#. q2DuM

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN1069D\n"

+"help.text"

+msgid "database_name is the name of the database."

+msgstr ""

+

+#. YYgSg

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN106A0\n"

+"help.text"

+msgid "Data source URL"

+msgstr ""

+

+#. EcdaK

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN106A4\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter the URL for the database. For example, for the MySQL JDBC driver, enter \"mysql://<Servername>/<name of the database>\". For more information on the JDBC driver, consult the documentation that came with the driver.</ahelp>"

+msgstr ""

+

+#. eVBSr

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN106BB\n"

+"help.text"

+msgid "JDBC Driver Class"

+msgstr ""

+

+#. vFsoP

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN106BF\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter the name of the JDBC driver.</ahelp>"

+msgstr ""

+

+#. VHjhA

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_id7953733\n"

+"help.text"

+msgid "Before you can use a JDBC driver, you need to add its class path. Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME - Advanced</menuitem>, and click the <widget>Class Path</widget> button. After you add the path information, restart %PRODUCTNAME."

+msgstr ""

+

+#. f8fUr

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN106CE\n"

+"help.text"

+msgid "Test Class"

+msgstr ""

+

+#. 8VBbq

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN106E4\n"

+"help.text"

+msgid "<ahelp hid=\".\">Tests the connection with the current settings.</ahelp>"

+msgstr ""

+

+#. FGezr

+#: dabawiz02jdbc.xhp

+msgctxt ""

+"dabawiz02jdbc.xhp\n"

+"par_idN106E7\n"

+"help.text"

+msgid "<link href=\"text/sdatabase/dabawiz03auth.xhp\">Authentication</link>"

+msgstr ""

+

+#. Y4EFA

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"tit\n"

+"help.text"

+msgid "MariaDB and MySQL Connection"

+msgstr ""

+

+#. bVNAZ

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"bm_id861587404584956\n"

+"help.text"

+msgid "<bookmark_value>MariaDB settings (Base)</bookmark_value><bookmark_value>MySQL settings (Base)</bookmark_value>"

+msgstr ""

+

+#. MseiS

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_idN10549\n"

+"help.text"

+msgid "<variable id=\"mysql\"><link href=\"text/sdatabase/dabawiz02mysql.xhp\">MariaDB and MySQL Connection</link></variable>"

+msgstr ""

+

+#. 5FPU6

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_idN1054D\n"

+"help.text"

+msgid "<ahelp hid=\".\">Specifies the options for MariaDB and MySQL databases.</ahelp>"

+msgstr ""

+

+#. Bmcwo

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"hd_id661587405298284\n"

+"help.text"

+msgid "Direct Connection for MariaDB and MySQL databases"

+msgstr ""

+

+#. vd9VD

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"hd_id321587405303769\n"

+"help.text"

+msgid "Database name"

+msgstr ""

+

+#. 6LAsi

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_id371587405314376\n"

+"help.text"

+msgid "Enter the name of the MariaDB or MySQL database. Ask your database administrator for the correct name."

+msgstr ""

+

+#. jbdZp

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"hd_id561587405334695\n"

+"help.text"

+msgid "Server URL"

+msgstr ""

+

+#. SshYk

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_id521587405341138\n"

+"help.text"

+msgid "Enter the URL for the database server. This is the name of the machine that runs the MariaDB or MySQL database. You can also replace hostname with the IP address of the server."

+msgstr ""

+

+#. MZQiq

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"hd_id171587405349438\n"

+"help.text"

+msgid "Port number"

+msgstr ""

+

+#. J2SR3

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_id1001587405358390\n"

+"help.text"

+msgid "Enter the port number for the database server. Ask your database administrator for the correct port address. The default port number for MySQL or MariaDB databases is 3306."

+msgstr ""

+

+#. ovKhU

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"hd_id121587407845730\n"

+"help.text"

+msgid "Named Pipe"

+msgstr ""

+

+#. Rq89B

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_id941587407987180\n"

+"help.text"

+msgid "If the MariaDB or MySQL database is to be accessed by a named pipe, enter its name."

+msgstr ""

+

+#. wF6bj

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"hd_id161587405553671\n"

+"help.text"

+msgid "Socket"

+msgstr ""

+

+#. e8DB2

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_id161587405561472\n"

+"help.text"

+msgid "If the MariaDB or MySQL database is to be accessed by a socket, enter the socket ID."

+msgstr ""

+

+#. fpBNu

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_idN10562\n"

+"help.text"

+msgid "Connect using ODBC (Open Database Connectivity)"

+msgstr ""

+

+#. E7sE2

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_idN10566\n"

+"help.text"

+msgid "<ahelp hid=\".\">Connects to an existing ODBC data source that was set on a system level.</ahelp>"

+msgstr ""

+

+#. AXrwJ

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_idN10569\n"

+"help.text"

+msgid "Connect using JDBC (Java Database Connectivity)"

+msgstr ""

+

+#. i9TrE

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_idN1056D\n"

+"help.text"

+msgid "<ahelp hid=\".\">Connects to an existing JDBC data source that was set on a system level.</ahelp>"

+msgstr ""

+

+#. FUG3D

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_idN10570\n"

+"help.text"

+msgid "The next wizard page depends on your choice of ODBC or JDBC:"

+msgstr ""

+

+#. VYcYK

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_idN10573\n"

+"help.text"

+msgid "<link href=\"text/sdatabase/dabawiz02odbc.xhp\">ODBC Connection</link>"

+msgstr ""

+

+#. DABkC

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_idN10582\n"

+"help.text"

+msgid "<link href=\"text/sdatabase/dabawiz02jdbc.xhp\">JDBC Connection</link>"

+msgstr ""

+

+#. ujaGF

+#: dabawiz02mysql.xhp

+msgctxt ""

+"dabawiz02mysql.xhp\n"

+"par_idN10591\n"

+"help.text"

+msgid "<link href=\"text/sdatabase/dabawiz03auth.xhp\">Authentication</link>"

+msgstr ""

+

+#. HF588

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"tit\n"

+"help.text"

+msgid "ODBC Connection"

+msgstr ""

+

+#. sGNau

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"bm_id3149031\n"

+"help.text"

+msgid "<bookmark_value>ODBC;database (Base)</bookmark_value><bookmark_value>databases;ODBC (Base)</bookmark_value>"

+msgstr ""

+

+#. SNzJc

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_idN1053D\n"

+"help.text"

+msgid "<variable id=\"odbc\"><link href=\"text/sdatabase/dabawiz02odbc.xhp\">ODBC Connection</link></variable>"

+msgstr ""

+

+#. nb3Qq

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_idN10541\n"

+"help.text"

+msgid "<ahelp hid=\".\">Specifies the settings for <link href=\"text/shared/00/00000005.xhp#odbc\" name=\"ODBC\">ODBC</link> databases.</ahelp>"

+msgstr ""

+

+#. WhLBW

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_id8856776\n"

+"help.text"

+msgid "To edit or add records to a database table in $[officename], the table must have a unique index field."

+msgstr ""

+

+#. xs2Yc

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_id8034302\n"

+"help.text"

+msgid "On Solaris and Linux platforms, try to use a JDBC driver instead of an ODBC driver. See http://www.unixodbc.org for an ODBC implementation on Solaris or Linux."

+msgstr ""

+

+#. PxZ9T

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_id8560136\n"

+"help.text"

+msgid "To connect to a Microsoft Access database on Windows, use the ADO or Access database interface, rather than ODBC."

+msgstr ""

+

+#. vme6U

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_id2082583\n"

+"help.text"

+msgid "Drivers for ODBC are supplied and supported by the manufacturer of the database. $[officename] only supports the ODBC 3 standard."

+msgstr ""

+

+#. wCexE

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_idN10552\n"

+"help.text"

+msgid "Name of the ODBC database"

+msgstr ""

+

+#. eubaF

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_idN10556\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter the path to the database file.</ahelp>"

+msgstr ""

+

+#. 7KKFy

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_idN10559\n"

+"help.text"

+msgid "Browse"

+msgstr ""

+

+#. CSCAZ

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_idN1055D\n"

+"help.text"

+msgid "<ahelp hid=\".\">Click to open an ODBC data source selection dialog:</ahelp>"

+msgstr ""

+

+#. 48ubg

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_idN10560\n"

+"help.text"

+msgid "Choose a data source"

+msgstr ""

+

+#. FhAAU

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_idN10564\n"

+"help.text"

+msgid "<ahelp hid=\".\">Select a data source to which you want to connect using ODBC. Then click <emph>OK</emph>.</ahelp>"

+msgstr ""

+

+#. WaAZB

+#: dabawiz02odbc.xhp

+msgctxt ""

+"dabawiz02odbc.xhp\n"

+"par_idN10567\n"

+"help.text"

+msgid "<link href=\"text/sdatabase/dabawiz03auth.xhp\">Authentication</link>"

+msgstr ""

+

+#. RL7sk

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"tit\n"

+"help.text"

+msgid "Oracle Database Connection"

+msgstr ""

+

+#. 8H3zh

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"bm_id5900753\n"

+"help.text"

+msgid "<bookmark_value>Oracle databases (base)</bookmark_value>"

+msgstr ""

+

+#. W6aaT

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN105A4\n"

+"help.text"

+msgid "Oracle Database Connection"

+msgstr ""

+

+#. DbqoE

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN105A8\n"

+"help.text"

+msgid "<ahelp hid=\".\">Specifies the options to access an Oracle database.</ahelp>"

+msgstr ""

+

+#. FMq7o

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN105BD\n"

+"help.text"

+msgid "Oracle database"

+msgstr ""

+

+#. 8qHyA

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN105C1\n"

+"help.text"

+msgid "You can use a JDBC driver to access an Oracle database from Solaris or Linux. To access the database from Windows, you need an ODBC driver."

+msgstr ""

+

+#. sSDYq

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN105D4\n"

+"help.text"

+msgid "On UNIX, ensure that the Oracle database client is installed with JDBC support. The JDBC driver class for the Solaris Oracle client version 8.x is located in the <Oracle client>/product/jdbc/lib/classes111.zip directory. You can also download the latest version of the driver from the Oracle web site."

+msgstr ""

+

+#. 5rxmX

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN10608\n"

+"help.text"

+msgid "Name of the Oracle database"

+msgstr ""

+

+#. DxYWQ

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN1060C\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter the name of the Oracle database. Ask your database administrator for the correct name.</ahelp>"

+msgstr ""

+

+#. WKBSR

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN1060F\n"

+"help.text"

+msgid "Server URL"

+msgstr ""

+

+#. vXDGs

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN10613\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter the URL for the database server. This is the name of the machine that runs the Oracle database. You can also replace hostname with the IP address of the server.</ahelp>"

+msgstr ""

+

+#. EEESV

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN10616\n"

+"help.text"

+msgid "Port number"

+msgstr ""

+

+#. PBuEW

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN1061A\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter the port number for the database server. Ask your database administrator for the correct port address.</ahelp>"

+msgstr ""

+

+#. rYRxW

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN1061D\n"

+"help.text"

+msgid "Oracle JDBC Driver Class"

+msgstr ""

+

+#. ouDxa

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN10621\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter the name of the JDBC driver.</ahelp>"

+msgstr ""

+

+#. JumUz

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN10630\n"

+"help.text"

+msgid "Test Class"

+msgstr ""

+

+#. NdF7k

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN10634\n"

+"help.text"

+msgid "<ahelp hid=\".\">Tests the connection with the current settings.</ahelp>"

+msgstr ""

+

+#. UwteE

+#: dabawiz02oracle.xhp

+msgctxt ""

+"dabawiz02oracle.xhp\n"

+"par_idN10637\n"

+"help.text"

+msgid "<link href=\"text/sdatabase/dabawiz03auth.xhp\">Authentication</link>"

+msgstr ""

+

+#. XoiBM

+#: dabawiz02spreadsheet.xhp

+msgctxt ""

+"dabawiz02spreadsheet.xhp\n"

+"tit\n"

+"help.text"

+msgid "Spreadsheet Database Connection"

+msgstr ""

+

+#. cwGbM

+#: dabawiz02spreadsheet.xhp

+msgctxt ""

+"dabawiz02spreadsheet.xhp\n"

+"par_idN1053A\n"

+"help.text"

+msgid "Set up Spreadsheet connection"

+msgstr ""

+

+#. fZnvG

+#: dabawiz02spreadsheet.xhp

+msgctxt ""

+"dabawiz02spreadsheet.xhp\n"

+"par_idN1053E\n"

+"help.text"

+msgid "Location and file name"

+msgstr ""

+

+#. 6TKT4

+#: dabawiz02spreadsheet.xhp

+msgctxt ""

+"dabawiz02spreadsheet.xhp\n"

+"par_idN10542\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter the path and file name to the spreadsheet file.</ahelp>"

+msgstr ""

+

+#. XtNjY

+#: dabawiz02spreadsheet.xhp

+msgctxt ""

+"dabawiz02spreadsheet.xhp\n"

+"par_idN10545\n"

+"help.text"

+msgid "Browse"

+msgstr ""

+

+#. JfUMC

+#: dabawiz02spreadsheet.xhp

+msgctxt ""

+"dabawiz02spreadsheet.xhp\n"

+"par_idN10549\n"

+"help.text"

+msgid "<ahelp hid=\".\">Click to open a file selection dialog.</ahelp>"

+msgstr ""

+

+#. JAmAi

+#: dabawiz02spreadsheet.xhp

+msgctxt ""

+"dabawiz02spreadsheet.xhp\n"

+"par_idN1054C\n"

+"help.text"

+msgid "Password required"

+msgstr ""

+

+#. 3HzmH

+#: dabawiz02spreadsheet.xhp

+msgctxt ""

+"dabawiz02spreadsheet.xhp\n"

+"par_idN10550\n"

+"help.text"

+msgid "<ahelp hid=\".\">Select to request a password from the user of the database document.</ahelp>"

+msgstr ""

+

+#. xngE4

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"tit\n"

+"help.text"

+msgid "Text File Connection"

+msgstr ""

+

+#. dfWU7

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"bm_id2517166\n"

+"help.text"

+msgid "<bookmark_value>tables in databases;importing text formats (Base)</bookmark_value><bookmark_value>text databases (Base)</bookmark_value>"

+msgstr ""

+

+#. htUUB

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN1054F\n"

+"help.text"

+msgid "Set up a connection to text files"

+msgstr ""

+

+#. MD2eT

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN10553\n"

+"help.text"

+msgid "<ahelp hid=\".\">Specifies the settings for importing a database in text format.</ahelp>"

+msgstr ""

+

+#. 6yKNw

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN10568\n"

+"help.text"

+msgid "In a text format database, data is stored in an unformatted ASCII file, where each record comprises a row. The data fields are divided by separators. Text in the data fields is divided by quotation marks."

+msgstr ""

+

+#. puYrF

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN1056B\n"

+"help.text"

+msgid "Path to text files"

+msgstr ""

+

+#. LkFcD

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN1056F\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter the path to the text file or files. If you just want one text file, you can use any extension of the file name. If you enter a folder name, the text files in that folder must have the extension *.csv to be recognized as files of the text database.</ahelp>"

+msgstr ""

+

+#. DwHAY

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN10572\n"

+"help.text"

+msgid "Browse"

+msgstr ""

+

+#. tU8mG

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN10576\n"

+"help.text"

+msgid "<ahelp hid=\".\">Click to open a file selection dialog.</ahelp>"

+msgstr ""

+

+#. MmGr4

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN10616\n"

+"help.text"

+msgid "Plain text files (*.txt)"

+msgstr ""

+

+#. ztjWn

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN1061A\n"

+"help.text"

+msgid "<ahelp hid=\".\">Click to access txt files.</ahelp>"

+msgstr ""

+

+#. E5S76

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN10643\n"

+"help.text"

+msgid "'Comma separated value' files (*.csv)"

+msgstr ""

+

+#. 2fDr2

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN10647\n"

+"help.text"

+msgid "<ahelp hid=\".\">Click to access csv files.</ahelp>"

+msgstr ""

+

+#. EVBCK

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN10666\n"

+"help.text"

+msgid "Custom"

+msgstr ""

+

+#. 3Z5fx

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN1066A\n"

+"help.text"

+msgid "<ahelp hid=\".\">Click to access custom files. Enter the extension in the text box.</ahelp>"

+msgstr ""

+

+#. rts2F

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN10581\n"

+"help.text"

+msgid "Field separator"

+msgstr ""

+

+#. 3G6QU

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN10585\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter or select the character that separates data fields in the text file.</ahelp>"

+msgstr ""

+

+#. 8rxWL

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN1059C\n"

+"help.text"

+msgid "Text separator"

+msgstr ""

+

+#. ejFpV

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN105A0\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter or select the character that identifies a text field in the text file.</ahelp> You cannot use the same character as the field separator."

+msgstr ""

+

+#. rSTcV

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN105B8\n"

+"help.text"

+msgid "Decimal separator"

+msgstr ""

+

+#. apBAu

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN105BC\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter or select the character that is used as a decimal separator in the text file, for example, a period (0.5) or a comma (0,5).</ahelp>"

+msgstr ""

+

+#. CyhGN

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN105D3\n"

+"help.text"

+msgid "Thousands separator"

+msgstr ""

+

+#. 6TTiq

+#: dabawiz02text.xhp

+msgctxt ""

+"dabawiz02text.xhp\n"

+"par_idN105D7\n"

+"help.text"

+msgid "<ahelp hid=\".\">Enter or select the character that is used as a thousands separator in the text file, for example a comma (1,000), or a period (1.000).</ahelp>"

+#. dF4Mp

+msgid "<link href=\"text/sdatabase/dabawiz02.xhp\">Save and proceed</link>"

+"POT-Creation-Date: 2021-10-20 13:08+0200\n"

+"POT-Creation-Date: 2021-10-20 13:08+0200\n"

+#. DjtXM

+#: page_menu.xhp

+msgctxt ""

+"page_menu.xhp\n"

+"par_id911634055593609\n"

+"help.text"

+msgid "<variable id=\"loadpagedesign\">Choose <menuitem>Page - Master Page - Load</menuitem></variable>"

+msgstr ""

+

+#. kCGEr

+msgid "<image id=\"img_id381556823072396\" src=\"cmd/sc_insertpage.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id381556823072396\">Icon New Page</alt></image>"

+"POT-Creation-Date: 2021-10-25 12:48+0200\n"

+#. bGEES

+msgid "Consolidation of lists requires attention to restore the list layout that has been affected by the position of the punctuation. This includes the case of numbering of style \"1.\", where the resulting list items are split after the dot."

+"POT-Creation-Date: 2021-10-20 13:08+0200\n"

+#. G7B9v

+#: 00000215.xhp

+msgctxt ""

+"00000215.xhp\n"

+"hd_id911633520416200\n"

+"help.text"

+msgid "Include byte-order mark"

+msgstr ""

+

+#. 5G2v5

+#: 00000215.xhp

+msgctxt ""

+"00000215.xhp\n"

+"par_id211633520423767\n"

+"help.text"

+msgid "For Unicode character set only, a byte order mark (BOM) is a sequence of bytes used to indicate Unicode encoding of a text file. The presence of the UTF-8 BOM is optional and may cause problems with some software, especially legacy software not designed to handle UTF-8."

+msgstr ""

+

+"POT-Creation-Date: 2021-10-25 12:48+0200\n"

+#. AJ5Lv

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"par_id661633376449596\n"

+"help.text"

+msgid "The dialog displays settings for the selected scanner and the scan job."

+msgstr ""

+

+#. t6BMj

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"hd_id721633369239013\n"

+"help.text"

+msgid "Sources"

+msgstr ""

+

+#. GvcAB

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"par_id361633369288384\n"

+"help.text"

+msgid "Displays a list of available scanners detected in your system. Click on a scanner in the list and press <emph>Select</emph> to open the scanner configuration dialog. The configuration dialog depends on the scanner driver installed."

+msgstr ""

+

+#. Caooc

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"hd_id511633368095174\n"

+"help.text"

+msgid "Scan Area"

+msgstr ""

+

+#. vYcZn

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"hd_id991633368100151\n"

+"help.text"

+msgid "Left, right, top, bottom"

+msgstr ""

+

+#. mncAH

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"par_id561633368111347\n"

+"help.text"

+msgid "Set the margins of the scan area."

+msgstr ""

+

+#. wmUp5

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"hd_id81633368116162\n"

+"help.text"

+msgid "Preview"

+msgstr ""

+

+#. GFTiz

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"par_id811633368127119\n"

+"help.text"

+msgid "Displays a preview of the scanned image. The preview area contains eight handles. Drag the handles to adjust the scan area or enter a value in the corresponding margin spin box."

+msgstr ""

+

+#. SQG8n

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"hd_id181633369359784\n"

+"help.text"

+msgid "Device used"

+msgstr ""

+

+#. vtMfF

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"par_id311633371297646\n"

+"help.text"

+msgid "Select the scanner device in the list of devices detected by your system."

+msgstr ""

+

+#. PAHaK

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"hd_id161633369549370\n"

+"help.text"

+msgid "Resolution [DPI]"

+msgstr ""

+

+#. jTyuD

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"par_id401633369701424\n"

+"help.text"

+msgid "Select the resolution in dots per inch for the scan job. The available resolutions depends on the scanner driver."

+msgstr ""

+

+#. F5SoB

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"hd_id351633369697474\n"

+"help.text"

+msgid "Show advanced options"

+msgstr ""

+

+#. Hj5EW

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"par_id771633369733491\n"

+"help.text"

+msgid "Mark this checkbox to display more configuration options for the scanner device. The set of options is displayed in the <emph>Options</emph> box and depends on the scanner driver."

+msgstr ""

+

+#. 6qqQP

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"hd_id461633370147200\n"

+"help.text"

+msgid "Options"

+msgstr ""

+

+#. JtCux

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"par_id761633371067498\n"

+"help.text"

+msgid "Displays the list of available scanner driver advanced options. Double click an option to display its contents just below. The option and its values depends on the scanner driver."

+msgstr ""

+

+#. DFbzA

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"hd_id461633371554790\n"

+"help.text"

+msgid "About Device"

+msgstr ""

+

+#. 2DSpo

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"par_id821633371816925\n"

+"help.text"

+msgid "Displays a popup window with information obtained from the scanner driver: device address, vendor, scanner model and type of scanner."

+msgstr ""

+

+#. HCSD9

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"hd_id971633371559920\n"

+"help.text"

+msgid "Create preview"

+msgstr ""

+

+#. T4Tgs

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"par_id431633375721518\n"

+"help.text"

+msgid "Scans and displays the document in the preview area. Use the <emph>Create Preview</emph> command to view a sample of the scanned document and set the scan job properties."

+msgstr ""

+

+#. YL3KE

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"hd_id151633371565195\n"

+"help.text"

+msgid "Scan"

+msgstr ""

+

+#. zWLcX

+#: 04060100.xhp

+msgctxt ""

+"04060100.xhp\n"

+"par_id851633375846639\n"

+"help.text"

+msgid "Scans an image, and then inserts the result into the document and closes the dialog."

+msgstr ""

+

+#. PjDF8

+msgid "Read the help page <link href=\"text/scalc/guide/borders.xhp\">User Defined Borders in Cells</link> to learn more on how to define custom line arrangements."

+#. KZbGT

+msgid "The vertical position of the selected objects is not affected by this command."

+msgstr ""

+

+#. yXXeh

+#: 05070200.xhp

+msgctxt ""

+"05070200.xhp\n"

+"par_id891634662083611\n"

+"help.text"

+msgid "To align the individual objects in a group, choose <menuitem>Format - Group - Enter Group</menuitem> to enter the group, select the objects, right-click, and then choose an alignment option."

+msgstr ""

+

+#. FyxcB

+#: 05070200.xhp

+msgctxt ""

+"05070200.xhp\n"

+"par_id81634662074262\n"

+"help.text"

+msgid "To align the individual objects in a group, double-click to enter the group, select the objects, right-click, and then choose an alignment option."

+#. Cb2xp

+msgid "Select the cells to be merged then do one of the following:"

+#. kBxWW

+msgid "Or, right click the selection to open the context menu and choose <menuitem>Merge Cells</menuitem>. If <menuitem>Unmerge Cells</menuitem> is present instead then the cell selection contains merged cells and cannot be merged further."

+#. CmQFq

+msgid "Or, choose <menuitem>Format - Merge and Unmerge Cells - Merge Cells</menuitem>."

+#. i8VUj

+msgid "<bookmark_value>unmerge/unmerging cells</bookmark_value><bookmark_value>split/splitting cells</bookmark_value>"

+#. vXyfX

+msgid "<ahelp hid=\".\">Divides previously merged cells back to the original cells. If the original cells had content that was kept when merged that content is restored.</ahelp>"

+#. SMhxF

+msgid "Or, right click the selection to open the context menu and choose <menuitem>Unmerge Cells</menuitem>. If <menuitem>Merge Cells</menuitem> is present instead then the cell selection does not contain any merged cells."

+#. nnwCo

+msgid "Or, choose <menuitem>Format - Merge and Unmerge Cells - Unmerge Cells</menuitem>"

+#. aAHnr

+msgid "Do one of the following:"

+#. yzi5c

+msgid "Choose <emph>Table - Split Cells</emph>."

+#. tnQ2D

+msgid "<bookmark_value>positioning;draw objects and controls</bookmark_value> <bookmark_value>draw objects;positioning and resizing</bookmark_value> <bookmark_value>controls; positions and sizes</bookmark_value> <bookmark_value>sizes;draw objects</bookmark_value> <bookmark_value>anchors;types/positions for draw objects</bookmark_value> <bookmark_value>draw objects; anchoring</bookmark_value>"

+#. EARC7

+msgid "Adapt is only available for Text Boxes. To adapt Shapes to text, use <menuitem>Format - Text</menuitem>."

+#. rBtji

+msgid "To turn off AutoCorrect in %PRODUCTNAME Writer choose <menuitem>Tools - AutoCorrect - While Typing</menuitem>. Refer to the help page <link href=\"text/swriter/guide/auto_off.xhp\" name=\"auto_off_link1\">Turning Off AutoCorrect</link> to learn more about deactivating AutoCorrect in %PRODUCTNAME Writer."

+#. 9cDF3

+msgid "To turn off AutoCorrect in %PRODUCTNAME Calc, go to <menuitem>Tools - AutoCorrect Options</menuitem> and uncheck all items in the <emph>Options</emph> and <emph>Localized Options</emph> tabs. Refer to the help page <link href=\"text/swriter/guide/auto_off.xhp\" name=\"auto_off_link2\">Turning Off AutoCorrect</link> to learn more about deactivating AutoCorrect in %PRODUCTNAME Calc."

+"POT-Creation-Date: 2021-10-25 12:49+0200\n"