1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski 3*b1cdbd2cSJim Jagielski 4*b1cdbd2cSJim Jagielski 5*b1cdbd2cSJim Jagielski<!--*********************************************************** 6*b1cdbd2cSJim Jagielski * 7*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 8*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 9*b1cdbd2cSJim Jagielski * distributed with this work for additional information 10*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 11*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 12*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 13*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 14*b1cdbd2cSJim Jagielski * 15*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 16*b1cdbd2cSJim Jagielski * 17*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 18*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 19*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 20*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 21*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 22*b1cdbd2cSJim Jagielski * under the License. 23*b1cdbd2cSJim Jagielski * 24*b1cdbd2cSJim Jagielski ***********************************************************--> 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski 29*b1cdbd2cSJim Jagielski <helpdocument version="1.0"> 30*b1cdbd2cSJim Jagielski<meta> 31*b1cdbd2cSJim Jagielski<topic id="textshared0000000005xml" indexer="include" status="PUBLISH"> 32*b1cdbd2cSJim Jagielski<title xml-lang="en-US" id="tit">General Glossary</title> 33*b1cdbd2cSJim Jagielski<filename>/text/shared/00/00000005.xhp</filename> 34*b1cdbd2cSJim Jagielski</topic> 35*b1cdbd2cSJim Jagielski</meta> 36*b1cdbd2cSJim Jagielski<body> 37*b1cdbd2cSJim Jagielski 38*b1cdbd2cSJim Jagielski 39*b1cdbd2cSJim Jagielski <section id="glossarallgemein"> 40*b1cdbd2cSJim Jagielski 41*b1cdbd2cSJim Jagielski 42*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3154896"><bookmark_value>common terms;glossaries</bookmark_value> 43*b1cdbd2cSJim Jagielski<bookmark_value>glossaries;common terms</bookmark_value> 44*b1cdbd2cSJim Jagielski<bookmark_value>terminology;general glossary</bookmark_value> 45*b1cdbd2cSJim Jagielski</bookmark> 46*b1cdbd2cSJim Jagielski <comment>mw changed "terminology;glossaries" and deleted one entry</comment> 47*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3154896" role="heading" level="1" l10n="U" oldref="1"><link href="text/shared/00/00000005.xhp" name="General Glossary">General Glossary</link></paragraph> 48*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154788" role="paragraph" l10n="U" oldref="2">This glossary includes explanations of some of the most important terms you will come across in $[officename].</paragraph> 49*b1cdbd2cSJim Jagielski 50*b1cdbd2cSJim Jagielski </section> 51*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154873" role="paragraph" l10n="CHG" oldref="3">Use the glossary to look up unfamiliar terms found in any $[officename] application.</paragraph> 52*b1cdbd2cSJim Jagielski 53*b1cdbd2cSJim Jagielski<sort order="asc"> 54*b1cdbd2cSJim Jagielski <section id="ascii"> 55*b1cdbd2cSJim Jagielski 56*b1cdbd2cSJim Jagielski 57*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3156192"><bookmark_value>ASCII; definition</bookmark_value> 58*b1cdbd2cSJim Jagielski</bookmark> 59*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3156192" role="heading" level="2" l10n="U" oldref="22">ASCII</paragraph> 60*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155922" role="paragraph" l10n="U" oldref="23">Abbreviation for American Standard Code for Information Interchange. ASCII is a character set for displaying fonts on personal computers. It consists of 128 characters including letters, numbers, punctuation and symbols. The extended ASCII character set contains 256 characters. Each character has been assigned a unique number, also referred to as ASCII Code.</paragraph> 61*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150823" role="paragraph" l10n="CHG" oldref="24">In HTML pages, only characters from the 7 Bit ASCII character set should appear. Other characters, such as German umlauts, are distinguished by way of a separate code. You can input extended ASCII code characters: the $[officename] export filter performs the necessary conversion.</paragraph> 62*b1cdbd2cSJim Jagielski 63*b1cdbd2cSJim Jagielski </section> 64*b1cdbd2cSJim Jagielski <section id="bezierobjekt"> 65*b1cdbd2cSJim Jagielski 66*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3151245" role="heading" level="2" l10n="U" oldref="25">Bézier Object</paragraph> 67*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154924" role="paragraph" l10n="U" oldref="26">Developed by the French mathematician Pierre Bézier, a Bézier curve is a mathematically defined curve used in two-dimensional graphic applications. The curve is defined by four points: the initial position and the terminating position, and two separate middle points. Bézier objects can be modified by moving these points with the mouse.</paragraph> 68*b1cdbd2cSJim Jagielski 69*b1cdbd2cSJim Jagielski </section> 70*b1cdbd2cSJim Jagielski <section id="ctl"> 71*b1cdbd2cSJim Jagielski 72*b1cdbd2cSJim Jagielski 73*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3146907"><bookmark_value>CTL;definition</bookmark_value> 74*b1cdbd2cSJim Jagielski<bookmark_value>complex text layout;definition</bookmark_value> 75*b1cdbd2cSJim Jagielski<bookmark_value>complex text layout, see CTL</bookmark_value> 76*b1cdbd2cSJim Jagielski</bookmark> 77*b1cdbd2cSJim Jagielski <comment>MW added a cross reference</comment> 78*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3146907" role="heading" level="2" l10n="U" oldref="169">Complex Text Layout (CTL)</paragraph> 79*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3156081" role="paragraph" l10n="U" oldref="166">Languages with complex text layout may have some or all of the following features:</paragraph> 80*b1cdbd2cSJim Jagielski <list type="unordered"> 81*b1cdbd2cSJim Jagielski <listitem> 82*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3145116" role="listitem" l10n="U" oldref="167">The language is written with characters or glyphs that are composed of several parts</paragraph> 83*b1cdbd2cSJim Jagielski </listitem> 84*b1cdbd2cSJim Jagielski <listitem> 85*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154630" role="listitem" l10n="U" oldref="168">The text direction is from right to left.</paragraph> 86*b1cdbd2cSJim Jagielski </listitem> 87*b1cdbd2cSJim Jagielski </list> 88*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148677" role="paragraph" l10n="U" oldref="170">Currently, $[officename] supports Hindi, Thai, Hebrew, and Arabic as CTL languages.</paragraph> 89*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3151176" role="paragraph" l10n="U" oldref="171">Enable CTL support using <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Language Settings - Languages</emph>.</paragraph> 90*b1cdbd2cSJim Jagielski 91*b1cdbd2cSJim Jagielski </section> 92*b1cdbd2cSJim Jagielski <section id="kontextmenue"> 93*b1cdbd2cSJim Jagielski 94*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_idN108F1" role="heading" level="2" l10n="NEW">Context Menu</paragraph> 95*b1cdbd2cSJim Jagielski <embed href="text/shared/00/00000001.xhp#par_id3156553"/> 96*b1cdbd2cSJim Jagielski 97*b1cdbd2cSJim Jagielski </section> 98*b1cdbd2cSJim Jagielski <section id="dde"> 99*b1cdbd2cSJim Jagielski 100*b1cdbd2cSJim Jagielski 101*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3147084"><bookmark_value>DDE; definition</bookmark_value> 102*b1cdbd2cSJim Jagielski</bookmark> 103*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3147084" role="heading" level="2" l10n="U" oldref="29">DDE</paragraph> 104*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3145154" role="paragraph" l10n="U" oldref="30">DDE stands for "Dynamic Data Exchange," which is a predecessor of OLE, "Object Linking and Embedding". With DDE, objects are linked through file reference, but not embedded.</paragraph> 105*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154820" role="paragraph" l10n="CHG" oldref="79">You can create a DDE link using the following procedure: Select cells from a Calc spreadsheet, copy them into the clipboard and switch to another spreadsheet and select the <emph>Edit - Paste Special</emph> dialog. Select <emph>the Link</emph> option to insert the contents as a DDE link. When activating a link, the inserted cell area will be read from its original file.</paragraph> 106*b1cdbd2cSJim Jagielski 107*b1cdbd2cSJim Jagielski </section> 108*b1cdbd2cSJim Jagielski <section id="Section7"> 109*b1cdbd2cSJim Jagielski 110*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3150439" role="heading" level="2" l10n="U" oldref="156">Direct and Style Formatting</paragraph> 111*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3159254" role="paragraph" l10n="U" oldref="34">If you format a document without Styles, it is referred to as "direct" formatting. This means modifying text or other objects, such as frames or tables, by applying various attributes directly. The format applies only to the selected area and all changes must be made separately. Styles, on the other hand, are not applied to the text directly, but rather are defined in the Styles and Formatting window and then applied. One advantage is that when you change a Style, all parts of the document to which that Style is assigned are modified at the same time.</paragraph> 112*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3147287" role="paragraph" l10n="CHG" oldref="35">You can remove direct formatting from your document by selecting the entire text with the shortcut keys <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+A and then choosing <emph>Format - Default Formatting</emph>.</paragraph> 113*b1cdbd2cSJim Jagielski 114*b1cdbd2cSJim Jagielski </section> 115*b1cdbd2cSJim Jagielski <section id="andocken"> 116*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3155132"><bookmark_value>windows; docking definition</bookmark_value> 117*b1cdbd2cSJim Jagielski<bookmark_value>docking; definition</bookmark_value> 118*b1cdbd2cSJim Jagielski</bookmark> 119*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3155132" role="heading" level="2" l10n="U" oldref="6">Docking</paragraph> 120*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154638" role="paragraph" l10n="CHG" oldref="7"><variable id="andock1">Some windows in $[officename], for example the Styles and Formatting window and the Navigator, are "dockable" windows. You can move these windows, re-size them or dock them to an edge. On each edge you can dock several windows on top of, or alongside each other; then, by moving the border lines, you can change the relative proportions of the windows. 121*b1cdbd2cSJim Jagielski</variable></paragraph> 122*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3147233" role="paragraph" l10n="CHG" oldref="127"><variable id="andock2">To undock and re-dock, holding down the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key, double-click a vacant area in the window. In the Styles and Formatting window, you can also double-click a gray part of the window next to the icons, while you hold down the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key. 123*b1cdbd2cSJim Jagielski</variable></paragraph> 124*b1cdbd2cSJim Jagielski 125*b1cdbd2cSJim Jagielski </section> 126*b1cdbd2cSJim Jagielski <section id="andock3"> 127*b1cdbd2cSJim Jagielski 128*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3155306" role="heading" level="2" l10n="U" oldref="10">Docking (AutoHide)</paragraph> 129*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155854" role="paragraph" l10n="CHG" oldref="115">On any window edge where another window is docked you will see a button which allows you to show or hide the window.<comment>UFI: fix button removed, see spec "Window Splitter"</comment></paragraph> 130*b1cdbd2cSJim Jagielski <list type="unordered"> 131*b1cdbd2cSJim Jagielski <listitem> 132*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3143274" role="listitem" l10n="CHG" oldref="161">If you click the button on the window edge to show the window, the window will remain visible until you manually hide it again (with the same button).</paragraph> 133*b1cdbd2cSJim Jagielski </listitem> 134*b1cdbd2cSJim Jagielski <listitem> 135*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153093" role="listitem" l10n="CHG" oldref="162">If you show the window by clicking the window border, but not the button, you activate the <emph>AutoHide</emph> function. The AutoHide function allows you to temporarily show a hidden window by clicking on its edge. When you click in the document, the docked window hides again.</paragraph> 136*b1cdbd2cSJim Jagielski </listitem> 137*b1cdbd2cSJim Jagielski </list> 138*b1cdbd2cSJim Jagielski 139*b1cdbd2cSJim Jagielski </section> 140*b1cdbd2cSJim Jagielski <section id="formatierung"> 141*b1cdbd2cSJim Jagielski 142*b1cdbd2cSJim Jagielski 143*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3163710"><bookmark_value>formatting; definition</bookmark_value> 144*b1cdbd2cSJim Jagielski</bookmark> 145*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3163710" role="heading" level="2" l10n="U" oldref="32">Formatting</paragraph> 146*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3163821" role="paragraph" l10n="U" oldref="33">Formatting refers to the visual layout of text using a word-processing or DTP program. This includes defining the paper format, page borders, fonts and font effects, as well as indents and spacing. You can format text <link href="text/shared/00/00000005.xhp#Section7">directly or with Styles</link> provided by $[officename].</paragraph> 147*b1cdbd2cSJim Jagielski 148*b1cdbd2cSJim Jagielski </section> 149*b1cdbd2cSJim Jagielski <section id="IME"> 150*b1cdbd2cSJim Jagielski 151*b1cdbd2cSJim Jagielski 152*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3156006"><bookmark_value>IME; definition</bookmark_value> 153*b1cdbd2cSJim Jagielski</bookmark> 154*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3156006" role="heading" level="2" l10n="U" oldref="164">IME</paragraph> 155*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3157874" role="paragraph" l10n="U" oldref="165">IME stands for Input Method Editor. A program that allows the user to enter complex characters from non-western character sets using a standard keyboard.</paragraph> 156*b1cdbd2cSJim Jagielski 157*b1cdbd2cSJim Jagielski </section> 158*b1cdbd2cSJim Jagielski <section id="jdbc"> 159*b1cdbd2cSJim Jagielski 160*b1cdbd2cSJim Jagielski 161*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3151172"><bookmark_value>JDBC; definition</bookmark_value> 162*b1cdbd2cSJim Jagielski</bookmark> 163*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3151172" role="heading" level="2" l10n="U" oldref="111">JDBC</paragraph> 164*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148386" role="paragraph" l10n="U" oldref="112">You can use the Java Database Connectivity (JDBC) API to connect to a database from %PRODUCTNAME. JDBC drivers are written in the Java programming language and are platform independent.</paragraph> 165*b1cdbd2cSJim Jagielski 166*b1cdbd2cSJim Jagielski </section> 167*b1cdbd2cSJim Jagielski <section id="kerning"> 168*b1cdbd2cSJim Jagielski 169*b1cdbd2cSJim Jagielski 170*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3151282"><bookmark_value>kerning; definition</bookmark_value> 171*b1cdbd2cSJim Jagielski</bookmark> 172*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3151282" role="heading" level="2" l10n="U" oldref="36">Kerning</paragraph> 173*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3146321" role="paragraph" l10n="U" oldref="37">Kerning means increasing or decreasing the amount of space between pairs of letters to improve the overall appearance of the text.</paragraph> 174*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3146078" role="paragraph" l10n="U" oldref="38">The kerning tables contain information on which pairs of letters require more spacing. These tables are generally a component of a font.</paragraph> 175*b1cdbd2cSJim Jagielski 176*b1cdbd2cSJim Jagielski </section> 177*b1cdbd2cSJim Jagielski <section id="verknuepfung"> 178*b1cdbd2cSJim Jagielski 179*b1cdbd2cSJim Jagielski 180*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3150592"><bookmark_value>links; definition</bookmark_value> 181*b1cdbd2cSJim Jagielski</bookmark> 182*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3150592" role="heading" level="2" l10n="U" oldref="55">Link</paragraph> 183*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150092" role="paragraph" l10n="CHG" oldref="56">The <emph>Links</emph> command is found in the <emph>Edit</emph> menu. The command can only be activated when at least one link is contained in the current document. When you insert a picture, for example, you can either insert the picture directly into the document or insert the picture as a link.</paragraph> 184*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3145730" role="paragraph" l10n="CHG" oldref="57">When an object is inserted directly into a document, the document size increases by (at least) the size in bytes of the object. You can save the document and open it on another computer, and the inserted object will still be in the same position in the document.</paragraph> 185*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3144765" role="paragraph" l10n="U" oldref="58">If you insert the object as a link, only a reference to the file name is inserted. The file size of the document increases only by the path and file reference. If you open your document on another computer, however, the linked file must be in exactly the same position as given by the reference in order to view the object in the document.</paragraph> 186*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153334" role="paragraph" l10n="CHG" oldref="59">Use <emph>Edit - Links</emph> to see which files are inserted as links. The links can be removed if required. This will break the link and insert the object directly.</paragraph> 187*b1cdbd2cSJim Jagielski 188*b1cdbd2cSJim Jagielski </section> 189*b1cdbd2cSJim Jagielski <section id="zahlensystem"> 190*b1cdbd2cSJim Jagielski 191*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3154512" role="heading" level="2" l10n="U" oldref="107">Number System</paragraph> 192*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3157846" role="paragraph" l10n="CHG" oldref="108">A number system is determined by the number of characters available for representing numbers. The decimal system, for instance is based on the ten numbers (0..9), the binary system is based on the two numbers 0 and 1, the hexadecimal system is based on 16 characters (0...9 and A...F).</paragraph> 193*b1cdbd2cSJim Jagielski 194*b1cdbd2cSJim Jagielski </section> 195*b1cdbd2cSJim Jagielski <section id="objekt"> 196*b1cdbd2cSJim Jagielski 197*b1cdbd2cSJim Jagielski 198*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3156358"><bookmark_value>objects; definition</bookmark_value> 199*b1cdbd2cSJim Jagielski</bookmark> 200*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3156358" role="heading" level="2" l10n="U" oldref="41">Object</paragraph> 201*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3144748" role="paragraph" l10n="U" oldref="42">An object is a screen element containing data. It can refer to application data, such as text or graphics.</paragraph> 202*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153839" role="paragraph" l10n="U" oldref="43">Objects are independent and do not influence each other. Any object containing data can be assigned certain commands. For example, a graphic object has commands for image editing and a spreadsheet contains calculation commands.</paragraph> 203*b1cdbd2cSJim Jagielski 204*b1cdbd2cSJim Jagielski </section> 205*b1cdbd2cSJim Jagielski <section id="odbc"> 206*b1cdbd2cSJim Jagielski 207*b1cdbd2cSJim Jagielski 208*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3152827"><bookmark_value>ODBC; definition</bookmark_value> 209*b1cdbd2cSJim Jagielski</bookmark> 210*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3152827" role="heading" level="2" l10n="U" oldref="44">ODBC</paragraph> 211*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153530" role="paragraph" l10n="U" oldref="45">Open Database Connectivity (ODBC) is a protocol norm with which applications can access database systems. The query language used is Structured Query Language (SQL). In $[officename], you can determine for each database whether to use SQL commands to run queries. Alternatively, you can use the interactive help to define your query by mouseclick and have it automatically translated into SQL by $[officename].</paragraph> 212*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153956" role="paragraph" l10n="U" oldref="75"><switchinline select="sys"><caseinline select="WIN">The 32bit ODBC functions required here can be installed on your system at any time with the help of the setup program supplied with your database. You can then amend the properties through the Control Panel. 213*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph> 214*b1cdbd2cSJim Jagielski 215*b1cdbd2cSJim Jagielski </section> 216*b1cdbd2cSJim Jagielski <section id="ole"> 217*b1cdbd2cSJim Jagielski 218*b1cdbd2cSJim Jagielski 219*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3154479"><bookmark_value>OLE; definition</bookmark_value> 220*b1cdbd2cSJim Jagielski</bookmark> 221*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3154479" role="heading" level="2" l10n="U" oldref="46">OLE</paragraph> 222*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3157840" role="paragraph" l10n="U" oldref="47">Object Linking and Embedding (OLE) objects can be linked to a target document or may also be embedded. Embedding inserts a copy of the object and details of the source program in the target document. If you want to edit the object, simply activate the source program by double-clicking on the object.</paragraph> 223*b1cdbd2cSJim Jagielski 224*b1cdbd2cSJim Jagielski </section> 225*b1cdbd2cSJim Jagielski <section id="opengl"> 226*b1cdbd2cSJim Jagielski 227*b1cdbd2cSJim Jagielski 228*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3154507"><bookmark_value>OpenGL; definition</bookmark_value> 229*b1cdbd2cSJim Jagielski</bookmark> 230*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3154507" role="heading" level="2" l10n="U" oldref="98">OpenGL</paragraph> 231*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3146879" role="paragraph" l10n="U" oldref="99">OpenGL represents a 3D graphics language, initially developed by SGI (Silicon Graphics Inc). Two dialects of this language are commonly used: Microsoft OpenGL, developed for use under Windows NT, and Cosmo OpenGL made by SGI. The latter represents an independent graphics language for all platforms and all kind of computers, even usable on machines without special 3-D graphics hardware.</paragraph> 232*b1cdbd2cSJim Jagielski 233*b1cdbd2cSJim Jagielski </section> 234*b1cdbd2cSJim Jagielski <section id="png"> 235*b1cdbd2cSJim Jagielski 236*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3155764" role="heading" level="2" l10n="U" oldref="91">PNG</paragraph> 237*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148993" role="paragraph" l10n="CHG" oldref="92">Portable Network Graphics (PNG) is a graphic file format. The files are compressed with a selectable compression factor, and, as opposed to the JPG format, PNG files are always compressed without any information loss.</paragraph> 238*b1cdbd2cSJim Jagielski 239*b1cdbd2cSJim Jagielski </section> 240*b1cdbd2cSJim Jagielski <section id="primaerschluessel"> 241*b1cdbd2cSJim Jagielski 242*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3083286" role="heading" level="2" l10n="U" oldref="103">Primary key</paragraph> 243*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150323" role="paragraph" l10n="U" oldref="104">A primary key serves as a unique identifier of database fields. The unique identification of database fields is used in <link href="text/shared/00/00000005.xhp#relational">relational databases</link>, to access data in other tables. If reference is made to a primary key from another table, this is termed a foreign key.</paragraph> 244*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148916" role="paragraph" l10n="CHG" oldref="113">In $[officename], you define the primary key in the design view of a table, by choosing the relevant command from the context menu of a row header for the selected field.</paragraph> 245*b1cdbd2cSJim Jagielski 246*b1cdbd2cSJim Jagielski </section> 247*b1cdbd2cSJim Jagielski <section id="relational"> 248*b1cdbd2cSJim Jagielski 249*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3147359" role="heading" level="2" l10n="U" oldref="100">Relational Database</paragraph> 250*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3147585" role="paragraph" l10n="U" oldref="101">A relational database is a collection of data items organized as a set of formally described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. </paragraph> 251*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154255" role="paragraph" l10n="U" oldref="163">A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. An RDBMS takes Structured Query Language (SQL) statements entered by a user or contained in an application program and creates, updates, or provides access to the database.</paragraph> 252*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3147535" role="paragraph" l10n="CHG" oldref="102">A good example of a relational database can be given with a database containing Customer, Purchase, and Invoice tables. In the Invoice table, there is no actual customer or purchasing data; however, the table contains references through a relational link, or a relation, to the respective customer and purchasing table's fields (for example, the customer ID field from the customer table).</paragraph> 253*b1cdbd2cSJim Jagielski 254*b1cdbd2cSJim Jagielski </section> 255*b1cdbd2cSJim Jagielski <section id="registerhaltigkeit"> 256*b1cdbd2cSJim Jagielski 257*b1cdbd2cSJim Jagielski 258*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3147315"><bookmark_value>register-true; definition</bookmark_value> 259*b1cdbd2cSJim Jagielski</bookmark> 260*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3147315" role="heading" level="2" l10n="U" oldref="48">Register-true</paragraph> 261*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154223" role="paragraph" l10n="CHG" oldref="49">Register-true is a typography term that is used in printing. This term refers to the congruent imprint of the lines within a type area on the front and the back side of book pages, newspaper pages and magazine pages. The register-true feature make these pages easier to read by preventing gray shadows from shining through between the lines of text. The register-true term also refers to lines in adjacent text columns that are of the same height.</paragraph> 262*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3145230" role="paragraph" l10n="CHG" oldref="50">When you define a paragraph, Paragraph Style, or a Page Style as register-true, the base lines of the affected characters are aligned to a vertical page grid, regardless of font size or of the presence of graphics. If you want, you can specify the setting for this grid as a Page Style property.</paragraph> 263*b1cdbd2cSJim Jagielski 264*b1cdbd2cSJim Jagielski </section> 265*b1cdbd2cSJim Jagielski <section id="rtf"> 266*b1cdbd2cSJim Jagielski 267*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3156710" role="heading" level="2" l10n="U" oldref="70">RTF</paragraph> 268*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3151186" role="paragraph" l10n="U" oldref="71">Rich Text Format (RTF) is a file format developed for the exchange of text files. A special feature is that the formatting is converted into directly readable text information. Unfortunately, in comparison to other file formats, this creates relatively large files.</paragraph> 269*b1cdbd2cSJim Jagielski 270*b1cdbd2cSJim Jagielski </section> 271*b1cdbd2cSJim Jagielski <section id="speichern"> 272*b1cdbd2cSJim Jagielski 273*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3156372" role="heading" level="2" l10n="U" oldref="117">Saving Relatively and Absolutely</paragraph> 274*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3146919" role="paragraph" l10n="U" oldref="67">In various dialogs (for example, <emph>Edit - AutoText</emph>) you can select whether you want to save files relatively or absolutely.</paragraph> 275*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3152946" role="paragraph" l10n="U" oldref="68">If you choose to save relatively, the references to embedded graphics or other objects in your document will be saved relative to the location in the file system. In this case, it does not matter where the referenced directory structure is recorded. The files will be found regardless of location, as long as the reference remains on the same drive or volume. This is important if you want to make the document available to other computers that may have a completely different directory structure, drive or volume names. It is also recommended to save relatively if you want to create a directory structure on an Internet server.</paragraph> 276*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148927" role="paragraph" l10n="U" oldref="69">If you prefer absolute saving, all references to other files will also be defined as absolute, based on the respective drive, volume or root directory. The advantage is that the document containing the references can be moved to other directories or folders, and the references remain valid.</paragraph> 277*b1cdbd2cSJim Jagielski 278*b1cdbd2cSJim Jagielski </section> 279*b1cdbd2cSJim Jagielski <section id="drehfeld"> 280*b1cdbd2cSJim Jagielski 281*b1cdbd2cSJim Jagielski <embed href="text/shared/00/00000001.xhp#drehfeld"/> 282*b1cdbd2cSJim Jagielski 283*b1cdbd2cSJim Jagielski </section> 284*b1cdbd2cSJim Jagielski <section id="sql"> 285*b1cdbd2cSJim Jagielski 286*b1cdbd2cSJim Jagielski 287*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3149922"><bookmark_value>SQL;definition</bookmark_value> 288*b1cdbd2cSJim Jagielski</bookmark> 289*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3149922" role="heading" level="2" l10n="U" oldref="53">SQL</paragraph> 290*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3152863" role="paragraph" l10n="U" oldref="54">Structured Query Language (SQL) is a language used for database queries. In $[officename] you can formulate queries either in SQL or interactively with the mouse.</paragraph> 291*b1cdbd2cSJim Jagielski 292*b1cdbd2cSJim Jagielski </section> 293*b1cdbd2cSJim Jagielski <section id="sqlserver"> 294*b1cdbd2cSJim Jagielski 295*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3147552" role="heading" level="2" l10n="U" oldref="120">SQL Database / SQL Server</paragraph> 296*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3159239" role="paragraph" l10n="U" oldref="121">An SQL database is a database system which offers an <link href="text/shared/00/00000005.xhp#sql">SQL</link> interface. SQL databases are often used in client/server networks in which different clients access a central server (for example, an SQL server), hence they are also called SQL server databases, or SQL servers for short.</paragraph> 297*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3159118" role="paragraph" l10n="CHG" oldref="122">In $[officename], you can integrate external SQL databases. These may be located on your local hard disk as well as on the network. Access is achieved through <link href="text/shared/00/00000005.xhp#odbc">ODBC</link>, JDBC, or a native driver integrated into $[officename].</paragraph> 298*b1cdbd2cSJim Jagielski 299*b1cdbd2cSJim Jagielski </section> 300*b1cdbd2cSJim Jagielski <section id="schuster"> 301*b1cdbd2cSJim Jagielski 302*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3166423" role="heading" level="2" l10n="U" oldref="51">Widows and Orphans</paragraph> 303*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149448" role="paragraph" l10n="U" oldref="52">Widows and orphans are historical typography terms, which have been in use for many years. A widow refers to a short line at the end of a paragraph, which when printed, appears alone at the top of the next page. An orphan is, in contrast, the first line of a paragraph printed alone at the bottom of the previous page. In a $[officename] text document you can automatically prevent such occurrences in the desired Paragraph Style. When doing so, you can determine the minimum amount of lines to be kept together on a page.</paragraph> 304*b1cdbd2cSJim Jagielski 305*b1cdbd2cSJim Jagielski </section> 306*b1cdbd2cSJim Jagielski 307*b1cdbd2cSJim Jagielski</sort> 308*b1cdbd2cSJim Jagielski </body> 309*b1cdbd2cSJim Jagielski</helpdocument> 310