File: //lib64/libreoffice/help/en-US/shared.jar
PK
&w�X text/shared/PK
%w�X text/shared/autokorr/PK
%w�X�Tܖ ! text/shared/autokorr/01000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>AutoCorrect has been activated</title><filename>/text/shared/autokorr/01000000.xhp</filename></topic></meta><body><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_START" id="bm_id3148671"/><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_WORDENEMDASH" id="bm_id3152459"/><paragraph role="heading" level="1">AutoCorrect has been activated</paragraph><paragraph role="heading" level="3">TWo INitial CApitals have been corrected</paragraph><paragraph role="paragraph">Typing errors such as "WOrd" have been corrected and replaced by the <link href="text/shared/01/06040000.xhp">AutoCorrect</link> function to "Word".</paragraph><section id="howtoget"><embed href="text/shared/00/00000406.xhp#autokooptionen"/></section><section id="relatedtopics"><embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/auto_off.xhp#auto_off"/></case></switch></section></body></helpdocument>
PK
%w�X2�r� ! text/shared/autokorr/06000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>AutoCorrect has been activated</title><filename>/text/shared/autokorr/06000000.xhp</filename></topic></meta><body><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_CHGQUOTES" id="bm_id3156116"/><paragraph role="heading" level="1">AutoCorrect has been activated</paragraph><paragraph role="heading" level="3">Double quotation marks (") have been replaced</paragraph><paragraph role="paragraph">Your text was corrected by <link href="text/shared/01/06040000.xhp">Autocorrect</link> so that double quotation marks were replaced by <link href="text/shared/01/06040400.xhp">typographical quotation marks</link>.</paragraph><section id="howtoget"><embed href="text/shared/00/00000406.xhp#autokotyafz"/></section><section id="relatedtopics"><embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/auto_off.xhp#auto_off"/></case></switch></section></body></helpdocument>
PK
%w�X��來 � ! text/shared/autokorr/12000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>AutoCorrect has been activated</title><filename>/text/shared/autokorr/12000000.xhp</filename></topic></meta><body><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_CHGTOENEMDASH" id="bm_id3146936"/><paragraph role="heading" level="1">AutoCorrect has been activated</paragraph><paragraph role="heading" level="3">Minus signs have been replaced</paragraph><paragraph role="paragraph"><link href="text/shared/01/06040000.xhp">AutoCorrect</link> has modified your text, and minus signs have been replaced with dashes.</paragraph><section id="howtoget"><embed href="text/shared/00/00000406.xhp#autokooptionen"/></section><section id="relatedtopics"><embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/auto_off.xhp#auto_off"/></case></switch></section></body></helpdocument>
PK
%w�Xh5p� � ! text/shared/autokorr/07000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>AutoCorrect has been activated</title><filename>/text/shared/autokorr/07000000.xhp</filename></topic></meta><body><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_CHGSGLQUOTES" id="bm_id3147477"/><paragraph role="heading" level="1">AutoCorrect has been activated</paragraph><paragraph role="heading" level="3">Single quotes have been replaced</paragraph><paragraph role="paragraph">Your text was corrected by <link href="text/shared/01/06040000.xhp">Autocorrect</link> so that single quotation marks were replaced by <link href="text/shared/01/06040400.xhp">typographical quotation marks</link>.</paragraph><section id="howtoget"><embed href="text/shared/00/00000406.xhp#autokotyafz"/></section><section id="relatedtopics"><embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/auto_off.xhp#auto_off"/></case></switch></section></body></helpdocument>
PK
%w�X_��� � ! text/shared/autokorr/09000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>AutoCorrect has been activated</title><filename>/text/shared/autokorr/09000000.xhp</filename></topic></meta><body><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_INGNOREDOUBLESPACE" id="bm_id3153882"/><paragraph role="heading" level="1">AutoCorrect has been activated</paragraph><paragraph role="heading" level="3">Double spaces have been ignored</paragraph><paragraph role="paragraph"><link href="text/shared/01/06040000.xhp">AutoCorrect</link> has corrected your text so that the multiple spaces you have entered have now been reduced to one single space.</paragraph><section id="howtoget"><embed href="text/shared/00/00000406.xhp#autokooptionen"/></section><section id="relatedtopics"><embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/auto_off.xhp#auto_off"/></case></switch></section></body></helpdocument>
PK
%w�Xŏ� ! text/shared/autokorr/05000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>AutoCorrect has been activated</title><filename>/text/shared/autokorr/05000000.xhp</filename></topic></meta><body><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_ACORSENTWORD" id="bm_id3159242"/><paragraph role="heading" level="1">AutoCorrect has been activated</paragraph><paragraph role="heading" level="3">AutoCorrect has performed a replacement. The beginning of the sentence now starts with a capital letter</paragraph><paragraph role="paragraph"><link href="text/shared/01/06040000.xhp">AutoCorrect</link> has performed a replacement, and the beginning of the sentence now starts with a capital letter.</paragraph><section id="howtoget"><embed href="text/shared/00/00000406.xhp#autokooptionen"/></section><section id="relatedtopics"><embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/auto_off.xhp#auto_off"/></case></switch></section></body></helpdocument>
PK
%w�X� � ! text/shared/autokorr/10000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>AutoCorrect has been activated</title><filename>/text/shared/autokorr/10000000.xhp</filename></topic></meta><body><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_CHGWEIGHTUNDERL" id="bm_id3150618"/><paragraph role="heading" level="1">AutoCorrect has been activated</paragraph><paragraph role="heading" level="3">Bold and underline attributes have been recognized and applied</paragraph><paragraph role="paragraph"><link href="text/shared/01/06040000.xhp">AutoCorrect</link> has modified your text, and the bold and/or underline text attributes have been automatically applied.</paragraph><section id="howtoget"><embed href="text/shared/00/00000406.xhp#autokooptionen"/></section><section id="relatedtopics"><embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/auto_off.xhp#auto_off"/></case></switch></section></body></helpdocument>
PK
%w�X�4k5� � ! text/shared/autokorr/08000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>AutoCorrect has been activated</title><filename>/text/shared/autokorr/08000000.xhp</filename></topic></meta><body><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_SETINETATTR" id="bm_id3155354"/><paragraph role="heading" level="1">AutoCorrect has been activated</paragraph><paragraph role="heading" level="3">An URL has been detected and a hyperlink attribute has been set</paragraph><paragraph role="paragraph"><link href="text/shared/01/06040000.xhp">AutoCorrect</link> has modified your text. A string has been detected as an URL and is now shown as a hyperlink.</paragraph><section id="howtoget"><embed href="text/shared/00/00000406.xhp#autokooptionen"/></section><section id="relatedtopics"><embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/auto_off.xhp#auto_off"/></case></switch></section></body></helpdocument>
PK
%w�XU0�� � ! text/shared/autokorr/03000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>AutoCorrect has been activated</title><filename>/text/shared/autokorr/03000000.xhp</filename></topic></meta><body><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_SENTWORD" id="bm_id3148410"/><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_SENTWORDENEMDASH" id="bm_id3145759"/><paragraph role="heading" level="1">AutoCorrect has been activated</paragraph><paragraph role="heading" level="3">Two capital letters at the beginning of a word and a sentence have been corrected to one capital letter</paragraph><paragraph role="paragraph"><link href="text/shared/01/06040000.xhp">AutoCorrect</link> has modified your text so that a word beginning with two capital letters at the beginning of a sentence now starts with one capital letter.</paragraph><section id="howtoget"><embed href="text/shared/00/00000406.xhp#autokooptionen"/></section><section id="relatedtopics"><embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/auto_off.xhp#auto_off"/></case></switch></section></body></helpdocument>
PK
%w�X�n� � ! text/shared/autokorr/02000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>AutoCorrect has been activated</title><filename>/text/shared/autokorr/02000000.xhp</filename></topic></meta><body><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_SENT" id="bm_id3153882"/><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_SENTENEMDASH" id="bm_id3149976"/><paragraph role="heading" level="1">AutoCorrect has been activated</paragraph><paragraph role="heading" level="3">Start each sentence with a capital letter</paragraph><paragraph role="paragraph">Your text was corrected with <link href="text/shared/01/06040000.xhp">AutoCorrect</link> so that the current word began with a capital letter. AutoCorrect changes words at the beginning of a paragraph, and words after the character at the end of a sentence (period, exclamation point, question mark).</paragraph><section id="howtoget"><embed href="text/shared/00/00000406.xhp#autokooptionen"/></section><section id="relatedtopics"><embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/auto_off.xhp#auto_off"/></case></switch></section></body></helpdocument>
PK
%w�X�
U�' ' ! text/shared/autokorr/04000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>AutoCorrect has been activated</title><filename>/text/shared/autokorr/04000000.xhp</filename></topic></meta><body><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_ACORWORD" id="bm_id3153882"/><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_ACORWORDENEMDASH" id="bm_id3153679"/><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_ACORSENTWORDENEMDASH" id="bm_id3145759"/><paragraph role="heading" level="1">AutoCorrect has been activated</paragraph><paragraph role="heading" level="3">A replacement has been carried out</paragraph><paragraph role="paragraph"><link href="text/shared/01/06040000.xhp">AutoCorrect</link> has replaced a word.</paragraph><section id="howtoget"><embed href="text/shared/00/00000406.xhp#autokooptionen"/></section><section id="relatedtopics"><embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/auto_off.xhp#auto_off"/></case></switch></section></body></helpdocument>
PK
%w�XԺ�� � ! text/shared/autokorr/13000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>AutoCorrect has been activated</title><filename>/text/shared/autokorr/13000000.xhp</filename></topic></meta><body><bookmark branch="hid/EDITENG_HID_AUTOCORR_HELP_CHGORDINALNUMBER" id="bm_id3147519"/><paragraph role="heading" level="1">AutoCorrect has been activated</paragraph><paragraph role="heading" level="3">1st ... has been replaced with 1st ...</paragraph><paragraph role="paragraph"><link href="text/shared/01/06040000.xhp">AutoCorrect</link> has corrected your text so that ordinal number suffixes have been superscripted.</paragraph><section id="howtoget"><embed href="text/shared/00/00000406.xhp#autokooptionen"/></section><section id="relatedtopics"><embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/auto_off.xhp#auto_off"/></case></switch></section></body></helpdocument>
PK
%w�X text/shared/02/PK
%w�X��[<� � text/shared/02/10030000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>To Document Begin/First Page</title><filename>/text/shared/02/10030000.xhp</filename></topic></meta><body><section id="ersteseite"><bookmark branch="hid/.uno:GoToStartOfDoc" id="bm_id3121999"/><bookmark branch="hid/.uno:GoToStartOfDoc" id="bm_id3154894"/><bookmark branch="hid/.uno:FirstPage" id="bm_id6495830"/><bookmark branch="hid/.uno:FirstPage" id="bm_id3163829"/><paragraph role="heading" level="1"><switchinline select="appl"><caseinline select="WRITER"><link href="text/shared/02/10030000.xhp">To Document Begin</link></caseinline><defaultinline><link href="text/shared/02/10030000.xhp">First Page</link></defaultinline></switchinline></paragraph><paragraph role="paragraph"><ahelp hid=".uno:FirstPage" visibility="visible">Moves to the first page of the document.</ahelp> This function is only active when you select the <emph>Print Preview</emph> function on the <emph>File</emph> menu.</paragraph></section><section id="syersteseite"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_gotostartofdoc.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER">To Document Begin</caseinline><defaultinline>First Page</defaultinline></switchinline></paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X�E�� � text/shared/02/01170001.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Context Menu of a Control Field</title><filename>/text/shared/02/01170001.xhp</filename></topic></meta><body><paragraph role="heading" level="1">Context Menu of a Control Field</paragraph><paragraph role="paragraph">The context menu of a control field has the following commands.</paragraph><bookmark branch="hid/.uno:ChangeControlType" id="bm_id8904148"/><bookmark branch="hid/.uno:ChangeControlType" id="bm_id3152811"/><paragraph role="heading" level="2">Replace with</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ChangeControlType" visibility="visible">Calls a submenu where you can select a control type to replace the control selected in the document.</ahelp> As many properties as possible are adopted.</paragraph><bookmark branch="hid/.uno:ConvertToEdit" id="bm_id9919844"/><bookmark branch="hid/.uno:ConvertToEdit" id="bm_id3148678"/><paragraph role="heading" level="3">Text box</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToEdit" visibility="visible">The selected control is transformed into a text box.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToButton" id="bm_id1218496"/><bookmark branch="hid/.uno:ConvertToButton" id="bm_id3156215"/><paragraph role="heading" level="3">Button</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToButton" visibility="visible">The selected control is transformed into a button.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToFixed" id="bm_id151384"/><bookmark branch="hid/.uno:ConvertToFixed" id="bm_id3159151"/><paragraph role="heading" level="3">Label field</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToFixed" visibility="visible">The selected control is transformed into a label.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToList" id="bm_id8499609"/><bookmark branch="hid/.uno:ConvertToList" id="bm_id3147086"/><paragraph role="heading" level="3">List Box</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToList" visibility="visible">The selected control is transformed into a list box.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToCheckBox" id="bm_id4363634"/><bookmark branch="hid/.uno:ConvertToCheckBox" id="bm_id3158409"/><paragraph role="heading" level="3">Check Box</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToCheckBox" visibility="visible">The selected control is transformed into a check box.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToRadio" id="bm_id2379482"/><bookmark branch="hid/.uno:ConvertToRadio" id="bm_id3153770"/><paragraph role="heading" level="3">Radio Button</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToRadio" visibility="visible">The selected control is transformed into an option button.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToCombo" id="bm_id7250365"/><bookmark branch="hid/.uno:ConvertToCombo" id="bm_id3146923"/><paragraph role="heading" level="3">Combo Box</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToCombo" visibility="visible">The selected control is transformed into a combo box.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToImageBtn" id="bm_id7742805"/><bookmark branch="hid/.uno:ConvertToImageBtn" id="bm_id3154013"/><paragraph role="heading" level="3">Image Button</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToImageBtn" visibility="visible">The selected control is transformed into an image button.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToFileControl" id="bm_id4790396"/><bookmark branch="hid/.uno:ConvertToFileControl" id="bm_id3154472"/><paragraph role="heading" level="3">File Selection</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToFileControl" visibility="visible">The selected control is transformed into a file selection.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToDate" id="bm_id7842806"/><bookmark branch="hid/.uno:ConvertToDate" id="bm_id3151353"/><paragraph role="heading" level="3">Date Field</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToDate" visibility="visible">The selected control is transformed into a date field.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToTime" id="bm_id7456305"/><bookmark branch="hid/.uno:ConvertToTime" id="bm_id3153190"/><paragraph role="heading" level="3">Time Field</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToTime" visibility="visible">The selected control is transformed into a time field.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToNumeric" id="bm_id8809737"/><bookmark branch="hid/.uno:ConvertToNumeric" id="bm_id3154129"/><paragraph role="heading" level="3">Numerical Field</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToNumeric" visibility="visible">The selected control is transformed into a numerical field.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToCurrency" id="bm_id7001607"/><bookmark branch="hid/.uno:ConvertToCurrency" id="bm_id3154503"/><paragraph role="heading" level="3">Currency Field</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToCurrency" visibility="visible">The selected control is transformed into a currency field.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToPattern" id="bm_id3919749"/><bookmark branch="hid/.uno:ConvertToPattern" id="bm_id3154792"/><paragraph role="heading" level="3">Pattern Field</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToPattern" visibility="visible">The selected control is transformed into a pattern field.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToImageControl" id="bm_id1614856"/><bookmark branch="hid/.uno:ConvertToImageControl" id="bm_id3147126"/><paragraph role="heading" level="3">Image Control</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToImageControl" visibility="visible">The selected control is transformed into an image control.</ahelp></paragraph><bookmark branch="hid/.uno:ConvertToFormatted" id="bm_id8945182"/><bookmark branch="hid/.uno:ConvertToFormatted" id="bm_id3151060"/><paragraph role="heading" level="3">Formatted Field</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ConvertToFormatted" visibility="visible">The selected control is transformed into a formatted field.</ahelp></paragraph></body></helpdocument>
PK
%w�X��ˀB B text/shared/02/12120000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Apply Filter</title><filename>/text/shared/02/12120000.xhp</filename></topic></meta><body><section id="filteranwenden"><bookmark branch="hid/.uno:FormFiltered" id="bm_id1995746"/><bookmark branch="hid/.uno:FormFiltered" id="bm_id3151097"/><paragraph role="heading" level="1"><link href="text/shared/02/12120000.xhp">Apply Filter</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:FormFiltered" visibility="visible">Switches between the filtered and unfiltered view of the table.</ahelp></paragraph></section><section id="syfilteranwenden"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_formfiltered.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Apply Filter</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph">The<emph> Apply Filter </emph>function retains <link href="text/shared/02/12110000.xhp">form-based filters</link> that have been set. You do not need to redefine them.</paragraph></body></helpdocument>
PK
%w�X�V8r r text/shared/02/10040000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>To Document End/Last Page</title><filename>/text/shared/02/10040000.xhp</filename></topic></meta><body><section id="letzteseite"><bookmark branch="hid/.uno:GoToEndOfDoc" id="bm_id5496308"/><bookmark branch="hid/.uno:GoToEndOfDoc" id="bm_id3156183"/><bookmark branch="hid/.uno:LastPage" id="bm_id3306707"/><bookmark branch="hid/.uno:LastPage" id="bm_id3149119"/><paragraph role="heading" level="1"><switchinline select="appl"><caseinline select="WRITER"><link href="text/shared/02/10040000.xhp">To Document End</link></caseinline><defaultinline><link href="text/shared/02/10040000.xhp">Last Page</link></defaultinline></switchinline></paragraph><paragraph role="paragraph"><ahelp hid=".uno:LastPage" visibility="visible">Moves to the last page of the document.</ahelp> This function is only active when you select the <emph>Print Preview</emph> function on the <emph>File</emph> menu.</paragraph></section><section id="syletzteseite"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_gotoendofdoc.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER">To Document End</caseinline><defaultinline>Last Page</defaultinline></switchinline></paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X�^ϱ� � text/shared/02/flowcharts.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Flowchart</title><filename>/text/shared/02/flowcharts.xhp</filename></topic></meta><body><section id="flowcharts"><bookmark branch="hid/.uno:FlowChartShapes" id="bm_id3399644"/><bookmark branch="hid/.uno:FlowChartShapes" id="bm_id6240424"/><paragraph role="heading" level="1"><link href="text/shared/02/flowcharts.xhp">Flowchart</link></paragraph><paragraph role="paragraph"><ahelp hid=".">Opens the Flowchart toolbar from which you can insert graphics into your document.</ahelp></paragraph></section><section id="howtoget"><embed href="text/shared/00/00000404.xhp#syflowcharts"/></section><bookmark branch="hid/.uno:FlowChartShapes.flowchart-process" id="bm_id5283364"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-alternate-process" id="bm_id3632007"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-decision" id="bm_id3693960"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-data" id="bm_id4031495"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-predefined-process" id="bm_id3576769"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-internal-storage" id="bm_id7544785"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-document" id="bm_id5602282"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-multidocument" id="bm_id7054658"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-terminator" id="bm_id8044679"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-preparation" id="bm_id1150547"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-manual-input" id="bm_id9643848"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-manual-operation" id="bm_id1966307"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-connector" id="bm_id913418"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-off-page-connector" id="bm_id5367595"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-card" id="bm_id5879085"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-punched-tape" id="bm_id2821741"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-summing-junction" id="bm_id3252052"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-or" id="bm_id3294473"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-collate" id="bm_id3726310"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-sort" id="bm_id8809472"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-extract" id="bm_id5813776"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-merge" id="bm_id318613"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-stored-data" id="bm_id8415784"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-delay" id="bm_id3021332"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-sequential-access" id="bm_id8885158"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-magnetic-disk" id="bm_id9532151"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-direct-access-storage" id="bm_id6307565"/><bookmark branch="hid/.uno:FlowChartShapes.flowchart-display" id="bm_id464796"/><paragraph role="paragraph"><ahelp hid=".">Click an icon from the Flowchart toolbar, then drag in the document to draw the shape.</ahelp></paragraph></body></helpdocument>
PK
%w�X���� � text/shared/02/06110000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Move Down</title><filename>/text/shared/02/06110000.xhp</filename></topic></meta><body><section id="hinunterschieben"><bookmark branch="hid/.uno:OutlineDown" id="bm_id9431430"/><bookmark branch="hid/.uno:OutlineDown" id="bm_id3154894"/><bookmark branch="hid/.uno:MoveDown" id="bm_id7415824"/><bookmark branch="hid/.uno:MoveDown" id="bm_id3149495"/><paragraph role="heading" level="1"><link href="text/shared/02/06110000.xhp">Move Down</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:MoveDown">Positions the selected paragraph after the one below it.</ahelp></paragraph></section><paragraph role="paragraph">If you have numbered paragraphs and click the<emph> Move Down </emph>icon, the numbers will be adjusted to the current order. <switchinline select="appl"><caseinline select="WRITER">The <emph>Move Down </emph>icon is only visible when the cursor is positioned in a bulleted or numbered list.
</caseinline></switchinline><switchinline select="appl"><caseinline select="IMPRESS">The <emph>Move Down </emph>icon appears on the <emph>Text Formatting</emph> Bar when you use the outline view.
</caseinline></switchinline></paragraph><paragraph role="paragraph">This function can be called by pressing <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Down Arrow.</paragraph><section id="syhinunterschieben"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_outlinedown.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Move Down</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X���)
)
text/shared/02/09070000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Hyperlink Dialog</title><filename>/text/shared/02/09070000.xhp</filename></topic></meta><body><section id="hyperlink"><bookmark branch="hid/.uno:HyperlinkDialog" id="bm_id4087126"/><bookmark branch="hid/.uno:HyperlinkDialog" id="bm_id3149748"/><bookmark branch="hid/.uno:EditHyperlink" id="bm_id6121214"/><bookmark branch="hid/.uno:EditHyperlink" id="bm_id3151097"/><paragraph role="heading" level="1"><variable id="hyperdia"><link href="text/shared/02/09070000.xhp">Hyperlink</link></variable></paragraph><paragraph role="paragraph"><variable id="hyperdiatext"><ahelp hid=".uno:EditHyperlink">Opens a dialog that enables you to create and edit hyperlinks.</ahelp></variable></paragraph></section><section id="syhyperdia"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_hyperlinkdialog.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Hyperlink Dialog</paragraph></tablecell></tablerow></table></section><bookmark branch="hid/CUI_HID_ICCDIALOG_CHOICECTRL" id="bm_id3149177"/><paragraph role="paragraph"><ahelp hid="HID_ICCDIALOG_CHOICECTRL">Select the type of hyperlink to be inserted.</ahelp></paragraph><bookmark branch="hid/.uno:OpenHyperlinkOnCursor" id="bm_id7868083"/><bookmark branch="hid/.uno:OpenHyperlinkOnCursor" id="bm_id3145345"/><paragraph role="paragraph"><ahelp hid=".uno:OpenHyperlinkOnCursor" visibility="hidden">Opens the hyperlink in your default web browser.</ahelp></paragraph><bookmark branch="hid/.uno:EditHyperlink" id="bm_id0122200902201484"/><bookmark branch="hid/.uno:EditHyperlink" id="bm_id0122200902201587"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Opens the Hyperlink dialog.</ahelp></paragraph><bookmark branch="hid/.uno:CopyHyperlinkLocation" id="bm_id0122200902224858"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Copies the URL to the clipboard.</ahelp></paragraph><bookmark branch="hid/.uno:RemoveHyperlink" id="bm_id0122200902230774"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Removes the hyperlink, leaving plain text.</ahelp></paragraph><embed href="text/shared/02/09070100.xhp#internet"/><embed href="text/shared/02/09070200.xhp#mailnews"/><embed href="text/shared/02/09070300.xhp#dokument"/><embed href="text/shared/02/09070400.xhp#neuesdokument"/><bookmark branch="hid/CUI_HID_ICCDIALOG_OK_BTN" id="bm_id3149811"/><paragraph role="heading" level="3">Apply</paragraph><paragraph role="paragraph"><ahelp hid="HID_ICCDIALOG_OK_BTN">Applies the data to your document.</ahelp></paragraph><bookmark branch="hid/CUI_HID_ICCDIALOG_CANCEL_BTN" id="bm_id3159166"/><paragraph role="heading" level="3">Close</paragraph><paragraph role="paragraph"><ahelp hid="HID_ICCDIALOG_CANCEL_BTN">Closes the dialog without saving.</ahelp></paragraph><paragraph role="heading" level="3">Help</paragraph><paragraph role="paragraph">Opens the Help.</paragraph><bookmark branch="hid/CUI_HID_ICCDIALOG_RESET_BTN" id="bm_id3155434"/><paragraph role="heading" level="3">Reset</paragraph><paragraph role="paragraph"><ahelp hid="HID_ICCDIALOG_RESET_BTN">Resets the entries in the dialog to their original state.</ahelp></paragraph><section id="relatedtopics"><embed href="text/shared/guide/hyperlink_insert.xhp#hyperlink_insert"/></section></body></helpdocument>
PK
%w�XUpS�� � text/shared/02/01170904.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Combo Box Wizard: Database Field</title><filename>/text/shared/02/01170904.xhp</filename></topic></meta><body><section id="seite3b"><paragraph role="heading" level="1"><link href="text/shared/02/01170904.xhp">Combo Box Wizard: Database Field</link></paragraph><paragraph role="paragraph">With the combination fields, you can either save the value of a field in a database or display this value in a form.</paragraph></section><paragraph role="paragraph">The user values entered in the combination field or selected in the list can be saved in the database table that is accessed in the form. Note that the saving of values in another table is not possible. If the values are not to be saved in a database, they will be saved only in the form. This is especially helpful in HTML forms, where the user's entered or selected values are to be assigned to a server.</paragraph><section id="howtoget"><embed href="text/shared/00/00040501.xhp#aupikomli3b"/></section><paragraph role="heading" level="2">Do you want to save the value in a database field?</paragraph><paragraph role="paragraph">Two options are available for this question:</paragraph><paragraph role="heading" level="3">Yes, I want to save it in the following database field</paragraph><paragraph role="paragraph"><ahelp hid="modules/sabpilot/ui/optiondbfieldpage/yesRadiobutton">Specifies whether the user's entered or selected combination field value should be saved in a database field.</ahelp> Several database table fields are offered which can be accessed in the current form.</paragraph><paragraph role="paragraph">In <link href="text/shared/02/01170102.xhp">Control - Properties</link> the selected field appears as an entry in the <emph>Data</emph> tab page under <emph>Data field</emph>.</paragraph><paragraph role="heading" level="3">List field</paragraph><paragraph role="paragraph"><ahelp hid="modules/sabpilot/ui/optiondbfieldpage/storeInFieldCombobox">Specifies the data field where the combination field value should be saved.</ahelp></paragraph><paragraph role="heading" level="3">No, I only want to save the value in the form</paragraph><paragraph role="paragraph"><ahelp hid="modules/sabpilot/ui/optiondbfieldpage/noRadiobutton">Specifies that the value of this combination field will not be written in the database and will only be saved in the form.</ahelp></paragraph></body></helpdocument>
PK
%w�X'|��� � text/shared/02/06060000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Promote One Level</title><filename>/text/shared/02/06060000.xhp</filename></topic></meta><body><section id="hochstufen"><bookmark branch="hid/.uno:OutlineLeft" id="bm_id1102480"/><bookmark branch="hid/.uno:OutlineLeft" id="bm_id3154094"/><bookmark branch="hid/.uno:IncrementLevel" id="bm_id8156328"/><bookmark branch="hid/.uno:IncrementLevel" id="bm_id3154863"/><paragraph role="heading" level="1"><switchinline select="appl"><caseinline select="WRITER"><link href="text/shared/02/06060000.xhp">Promote One Level</link></caseinline><defaultinline><link href="text/shared/02/06060000.xhp">Promote</link></defaultinline></switchinline></paragraph><paragraph role="paragraph"><ahelp hid=".uno:IncrementLevel">Moves the selected paragraph up one level in the numbering or bullets hierarchy.</ahelp></paragraph></section><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER">The<emph> Promote One Level </emph>icon is on the <emph>Bullets and Numbering</emph> bar, which appears when the cursor is positioned on a numbering or bullets item.
</caseinline><caseinline select="IMPRESS">The<emph> Promote </emph>icon is on the <emph>Text Formatting</emph> bar, which appears when working in the outline view.
</caseinline></switchinline></paragraph><section id="syhochstufen"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_outlineleft.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER">Promote One Level
</caseinline><defaultinline>Promote</defaultinline></switchinline></paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�XtjzO� � text/shared/02/24080000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Gamma</title><filename>/text/shared/02/24080000.xhp</filename></topic></meta><body><section id="gamma"><bookmark branch="hid/.uno:GrafGamma" id="bm_id211906"/><bookmark branch="hid/.uno:GrafGamma" id="bm_id3149031"/><paragraph role="heading" level="1"><link href="text/shared/02/24080000.xhp">Gamma</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:GrafGamma">Specifies the gamma value for the view of the selected object, which affects the brightness of the midtone values.</ahelp> Values from 0.10 (minimum Gamma) to 10 (maximum Gamma) are possible.</paragraph></section><section id="sygamma"><table><tablerow><tablecell><paragraph role="paragraph"><image src="res/sc10868.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Gamma</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X�N�Ń � text/shared/02/20060000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Document Modification</title><filename>/text/shared/02/20060000.xhp</filename></topic></meta><body><section id="dokumentveraenderung"><bookmark branch="hid/.uno:ModifiedStatus" id="bm_id8313236"/><bookmark branch="hid/.uno:ModifiedStatus" id="bm_id3151262"/><bookmark branch="hid/.uno:Modified" id="bm_id1803964"/><bookmark branch="hid/.uno:Modified" id="bm_id3156183"/><bookmark branch="hid/.uno:ModifyStatus" id="bm_id3154682"/><paragraph role="heading" level="1"><link href="text/shared/02/20060000.xhp">Document Modification</link></paragraph><paragraph role="paragraph"><ahelp hid="SID_MODIFYSTATUS">If changes to the document have not yet been saved, a "*" is displayed in this field on the Status Bar. This also applies to new, not yet saved documents.</ahelp></paragraph></section></body></helpdocument>
PK
%w�XȈԝ � text/shared/02/more_controls.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>More Controls</title><filename>/text/shared/02/more_controls.xhp</filename></topic></meta><body><section id="more_controls"><bookmark branch="index" id="bm_id5941343"/><paragraph role="heading" level="1"><link href="text/shared/02/more_controls.xhp">More Controls</link></paragraph><paragraph role="paragraph"><ahelp hid=".">The More Controls toolbar opens when you click the More Controls icon on the <link href="text/shared/02/01170000.xhp">Form Controls</link> toolbar.</ahelp></paragraph></section><embed href="text/shared/02/01170000.xhp#more_controls"/></body></helpdocument>
PK
%w�X��m�f �f text/shared/02/01170000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Form Controls</title><filename>/text/shared/02/01170000.xhp</filename></topic></meta><body><section id="formularfunktionen"><bookmark branch="index" id="bm_id3154142"/><bookmark branch="hid/.uno:Config" id="bm_id4029443"/><bookmark branch="hid/.uno:Config" id="bm_id3153252"/><paragraph role="heading" level="1"><link href="text/shared/02/01170000.xhp">Form Controls</link></paragraph><paragraph role="paragraph"><variable id="formulartext"><ahelp hid=".uno:Config">The Form Controls toolbar contains tools that you need to create an interactive form.</ahelp></variable> You can use the toolbar to add controls to a form in a text, spreadsheet, presentation, or HTML document, for example a button that runs a macro.</paragraph></section><section id="howtoget"><paragraph role="paragraph">Choose <item type="menuitem">View - Toolbars - Form Controls</item>.</paragraph><paragraph role="paragraph">Icon on the <emph>Insert</emph> toolbar (you may need to enable this initially invisible icon):</paragraph><section id="syformular"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_config.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Form Controls</paragraph></tablecell></tablerow></table></section></section><paragraph role="note"><link href="text/shared/guide/xforms.xhp">XML Form documents</link> (XForms) use the same controls.</paragraph><paragraph role="paragraph">To create a form, open a document and use the Form Controls toolbar to add and define the form controls. If you want, you can also link the form to a database, so that you can use the controls to manipulate a database.</paragraph><paragraph role="paragraph">When you create a form in an HTML document, you can use the form to send data over the Internet.</paragraph><paragraph role="note">%PRODUCTNAME only exports the form properties that are supported by the HTML version that you export to. To specify the HTML version, choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Load/Save - HTML Compatibility</emph>.</paragraph><paragraph role="heading" level="2">To add a control to a document</paragraph><list type="ordered"><listitem><paragraph role="paragraph">On the Form Controls toolbar, click the icon of the control that you want to add.</paragraph></listitem><listitem><paragraph role="paragraph">In the document, drag to create the control. </paragraph><paragraph role="paragraph">To create a square control field, hold down the Shift key while you drag.</paragraph></listitem></list><paragraph role="tip">To add a field from the field list of a table or query to a form, drag a cell into the form. In a text document, you can also drag a column header to add a field to a form. To include a label for the field, hold down the <switchinline select="sys"><caseinline select="MAC">Command
</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift key down when you drag a column head.</paragraph><paragraph role="heading" level="2">Modifying a Control</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Right-click the control and choose <emph>Control</emph>. A dialog opens where you can define the properties of the control.</paragraph></listitem><listitem><paragraph role="paragraph">To specify a accelerator key for a control, add a tilde (~) in front of the character in the label for the control.</paragraph></listitem><listitem><paragraph role="paragraph">You can drag and drop controls from one document to another document. You can also copy and paste controls between documents. When you insert a control from another document, $[officename] analyzes the data source, content type, and content properties of the control so that the control fits the logical structure in the target document. For example, a control that displays contents from an address book continues to display the same contents after you copy the control to a different document. You can view these properties on the <emph>Data</emph> tab page of the <emph>Form properties</emph> dialog. </paragraph></listitem></list><section id="Section3"><paragraph role="heading" level="2">Select</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_drawselect.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">This icon switches the mouse pointer to the select mode, or deactivates this mode. The select mode is used to select the controls of the current form.</paragraph></tablecell></tablerow></table><embed href="text/shared/02/01170500.xhp#designmodus"/><embed href="text/shared/00/00040501.xhp#sydesign"/><embed href="text/shared/02/01170100.xhp#control"/><embed href="text/shared/00/00040501.xhp#sycontroleigenschaften"/><embed href="text/shared/02/01170200.xhp#formular"/><embed href="text/shared/00/00040501.xhp#syformulareigenschaften"/></section><section id="Section19"><bookmark branch="hid/.uno:Checkbox" id="bm_id8176164"/><bookmark branch="hid/.uno:CheckBox" id="bm_id3150751"/><paragraph role="heading" level="2">Check Box</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_checkbox.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:CheckBox">Creates a check box.</ahelp> Check boxes allow you to activate or deactivate a function in a form.</paragraph></tablecell></tablerow></table></section><section id="Section16"><bookmark branch="hid/.uno:Edit" id="bm_id7355178"/><bookmark branch="hid/.uno:Edit" id="bm_id3153785"/><paragraph role="heading" level="2">Text Box</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_edit.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:Edit">Creates a text box.</ahelp> Text boxes are fields in which the user can enter text. In a form, text boxes display data or allow for new data input.</paragraph></tablecell></tablerow></table></section><section id="Section7"><bookmark branch="hid/.uno:FormattedField" id="bm_id6606960"/><bookmark branch="hid/.uno:FormattedField" id="bm_id3155526"/><paragraph role="heading" level="2">Formatted Field</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_formattedfield.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:FormattedField">Creates a formatted field.</ahelp> A formatted field is a text box in which you can define how the inputs and outputs are formatted, and which limiting values apply.</paragraph></tablecell></tablerow></table><paragraph role="paragraph">A formatted field has <link href="text/shared/02/01170002.xhp">special control properties</link> (choose <emph>Format - Control</emph>).</paragraph></section><section id="Section21"><bookmark branch="hid/.uno:Pushbutton" id="bm_id6486131"/><bookmark branch="hid/.uno:Pushbutton" id="bm_id3153878"/><paragraph role="heading" level="2">Push Button</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_insertpushbutton.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:Pushbutton">Creates a push button.</ahelp> This function can be used to execute a command for a defined event, such as a mouse click.</paragraph><paragraph role="paragraph">You can apply text and graphics to these buttons.</paragraph></tablecell></tablerow></table></section><section id="Section20"><bookmark branch="hid/.uno:Radiobutton" id="bm_id3862451"/><bookmark branch="hid/.uno:RadioButton" id="bm_id3153418"/><paragraph role="heading" level="2">Option Button</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_radiobutton.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:RadioButton">Creates an option button.</ahelp> Option buttons enable the user to choose one of several options. Option buttons with the same functionality are given the same name (<link href="text/shared/02/01170101.xhp"><emph>Name</emph></link>
<emph>property</emph>). Normally, they are given a <link href="text/shared/02/01170000.xhp">group box</link>.</paragraph></tablecell></tablerow></table></section><section id="Section15"><bookmark branch="hid/.uno:ListBox" id="bm_id7238352"/><bookmark branch="hid/.uno:ListBox" id="bm_id3154475"/><paragraph role="heading" level="2">List Box</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_listbox.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:ListBox">Creates a list box.</ahelp> A list box lets users select an entry from a list. If the form is linked to a database and the database connection is active, the<link href="text/shared/02/01170900.xhp"><emph>List Box Wizard</emph></link> will automatically appear after the list box is inserted in the document. This wizard helps you create the list box.</paragraph></tablecell></tablerow></table></section><section id="Section14"><bookmark branch="hid/.uno:Combobox" id="bm_id5504530"/><bookmark branch="hid/.uno:ComboBox" id="bm_id3156169"/><paragraph role="heading" level="2">Combo Box</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_combobox.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:ComboBox">Creates a combo box.</ahelp> A combo box is a single-line list box with a drop-down list from which users choose an option. You can assign the "read-only" property to the combo box so that users cannot enter other entries than those found in the list. If the form is bound to a database and the database connection is active, the <link href="text/shared/02/01170900.xhp"><emph>Combo Box Wizard</emph></link> will automatically appear after you insert the combo box in the document.</paragraph></tablecell></tablerow></table></section><section id="Section18"><bookmark branch="hid/.uno:Label" id="bm_id7047484"/><bookmark branch="hid/.uno:Label" id="bm_id3154255"/><paragraph role="heading" level="2">Label Field</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_insertfixedtext.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:Label">Creates a field for displaying text.</ahelp> These labels are only for displaying predefined text. Entries cannot be made in these fields.</paragraph></tablecell></tablerow></table></section><bookmark branch="hid/.uno:MoreControls" id="bm_id1433643"/><bookmark branch="hid/.uno:MoreControls" id="bm_id4851832"/><paragraph role="heading" level="2">More Controls</paragraph><paragraph role="paragraph"><ahelp hid=".">Opens the <link href="text/shared/02/more_controls.xhp"><emph>More Controls</emph></link> toolbar.</ahelp></paragraph><bookmark branch="hid/.uno:FormDesignTools" id="bm_id6078501"/><bookmark branch="hid/.uno:FormDesignTools" id="bm_id3258766"/><paragraph role="heading" level="2">Form Design</paragraph><paragraph role="paragraph"><ahelp hid=".">Opens the <link href="text/shared/main0226.xhp"><emph>Form Design</emph></link> toolbar.</ahelp></paragraph><section id="Section25"><paragraph role="heading" level="2">Wizards On/Off</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_usewizards.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Turns on and turns off the automatic form controls wizards.</paragraph><paragraph role="paragraph">These wizards help you to enter the properties of list boxes, table controls, and other controls.</paragraph></tablecell></tablerow></table></section><paragraph role="heading" level="2"><link href="text/shared/02/01170001.xhp">Context Menu Commands</link></paragraph><switch select="sys"><case select="HIDE_HERE"><section id="more_controls"><section id="Section22"><bookmark branch="hid/.uno:Spinbutton" id="bm_id8342120"/><bookmark branch="hid/.uno:SpinButton" id="bm_id5568102"/><paragraph role="heading" level="2">Spin Button</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_spinbutton.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:SpinButton">Creates a spin button.</ahelp></paragraph></tablecell></tablerow></table><paragraph role="paragraph">If you add a spin button to a Calc spreadsheet, you can use the Data tab page to create a two-way link between the spin button and a cell. As a result, when you change the contents of a cell, the contents of the spin button are updated. Conversely, if you change the value of the spin button, the contents of the cell are updated.</paragraph></section><section id="Section23"><bookmark branch="hid/.uno:ScrollBar" id="bm_id633802"/><bookmark branch="hid/.uno:ScrollBar" id="bm_id8119449"/><paragraph role="heading" level="2">Scrollbar</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_scrollbar.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:ScrollBar">Creates a scrollbar.</ahelp></paragraph></tablecell></tablerow></table><paragraph role="paragraph">You can specify the following properties for a scrollbar:</paragraph><table><tablerow><tablecell><paragraph role="tablehead">UI name</paragraph></tablecell><tablecell><paragraph role="tablehead">Semantics</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Scroll value min</paragraph></tablecell><tablecell><paragraph role="tablecontent">Specifies the minimum height or the minimum width of a scrollbar.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Scroll value max</paragraph></tablecell><tablecell><paragraph role="tablecontent">Specifies the maximum height or the maximum width of a scrollbar.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Default scroll value</paragraph></tablecell><tablecell><paragraph role="tablecontent">Specifies the default value of a scrollbar, used when the form is reset.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Orientation</paragraph></tablecell><tablecell><paragraph role="tablecontent">Specifies the orientation of a scrollbar, that is, horizontal or vertical.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Small change</paragraph></tablecell><tablecell><paragraph role="tablecontent">Specifies the minimum amount by which you can scroll a scrollbar, for example, by clicking an arrow.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Large change</paragraph></tablecell><tablecell><paragraph role="tablecontent">Specifies the amount that a large step scrolls a scrollbar, for example, when you click between the scrollbar thumb and a scrollbar arrow.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Delay</paragraph></tablecell><tablecell><paragraph role="tablecontent">Specifies the delay in milliseconds between scrollbar trigger events. For example, the delay that occurs when you click an arrow button on the scrollbar and hold down the mouse button.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Symbol color</paragraph></tablecell><tablecell><paragraph role="tablecontent">Specifies the color of the arrows on the scrollbar.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Visible Size</paragraph></tablecell><tablecell><paragraph role="tablecontent">Specifies the size of the scrollbar thumb in "value units". For example, a value of ("Scroll value max." minus "Scroll value min.") / 2 results in a scrollbar thumb that occupies half of the scrollbar.</paragraph><paragraph role="tablecontent">To make the width of the scrollbar equal to the height of the scrollbar, set the Visible Size to zero.</paragraph></tablecell></tablerow></table><paragraph role="paragraph">In a Calc spreadsheet, you can use the Data tab page to create a two-way link between a scrollbar and a cell.</paragraph></section><section id="Section13"><bookmark branch="hid/.uno:Imagebutton" id="bm_id2102401"/><bookmark branch="hid/.uno:Imagebutton" id="bm_id3151373"/><paragraph role="heading" level="2">Image Button</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_imagebutton.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:Imagebutton">Creates a button displayed as an image.</ahelp> Aside from the graphic representation, an image button has the same properties as a "normal" button.</paragraph></tablecell></tablerow></table></section><section id="Section12"><bookmark branch="hid/.uno:ImageControl" id="bm_id7383386"/><bookmark branch="hid/.uno:ImageControl" id="bm_id3150947"/><paragraph role="heading" level="2">Image Control</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_objectcatalog.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:ImageControl">Creates an image control. It can only be used to add images from a database.</ahelp> In the form document, double-click one of these controls to open the <emph>Insert Graphic</emph> dialog to insert the image. There is also a context menu (not in design mode) with commands for inserting and deleting the image.</paragraph><paragraph role="paragraph">Images from a database can be displayed in a form, and new images can be inserted in the database as long as the image control is not write-protected. The control must refer to a database field of the image type. Therefore, enter the data field into the properties window on the <emph>Data</emph> tab page.</paragraph></tablecell></tablerow></table></section><section id="Section10"><bookmark branch="hid/.uno:DateField" id="bm_id4810502"/><bookmark branch="hid/.uno:DateField" id="bm_id3145656"/><paragraph role="heading" level="2">Date Field</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_adddatefield.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:DateField">Creates a date field.</ahelp> If the form is linked to a database, the date values can be adopted from the database.</paragraph></tablecell></tablerow></table><paragraph role="paragraph">If you assign the "Dropdown" property to the date field, the user can open a calendar to select a date under the date field. This also applies to a date field within a Table Control field.</paragraph><paragraph role="tip">Date fields can be easily edited by the user with the up arrow and down arrow keys. Depending on the cursor position, the day, month, or the year is can be increased or decreased using the arrow keys.</paragraph><paragraph role="paragraph"><link href="text/shared/02/01170003.xhp">Specific Remarks on Date Fields</link>.</paragraph></section><section id="Section9"><bookmark branch="hid/.uno:TimeField" id="bm_id4739584"/><bookmark branch="hid/.uno:TimeField" id="bm_id3154541"/><paragraph role="heading" level="2">Time Field</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_timefield.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:TimeField">Creates a time field.</ahelp> If the form is linked to a database, the time values for the form can be adopted from the database.</paragraph></tablecell></tablerow></table><paragraph role="tip">Time fields can be easily edited by the user with the up and down arrow keys. Depending on the cursor position, the hours, minutes, or the seconds are increased or decreased using the arrow keys.</paragraph></section><section id="Section11"><bookmark branch="hid/.uno:FileControl" id="bm_id1460134"/><bookmark branch="hid/.uno:FileControl" id="bm_id3154859"/><paragraph role="heading" level="2">File Selection</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_filecontrol.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:FileControl">Creates a button that enables file selection.</ahelp></paragraph></tablecell></tablerow></table></section><section id="Section8"><bookmark branch="hid/.uno:NumericField" id="bm_id3301501"/><bookmark branch="hid/.uno:NumericField" id="bm_id3154211"/><paragraph role="heading" level="2">Numerical Field</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_insertnumericfield.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:NumericField">Creates a numerical field.</ahelp> If the form is linked to a database, the numerical values in the form can be adopted from the database.</paragraph></tablecell></tablerow></table></section><section id="Section6"><bookmark branch="hid/.uno:CurrencyField" id="bm_id9766539"/><bookmark branch="hid/.uno:CurrencyField" id="bm_id3151327"/><paragraph role="heading" level="2">Currency Field</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_currencyfield.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:CurrencyField">Creates a currency field.</ahelp> If the form is linked to a database, the currency field contents for in the form can be adopted from the database.</paragraph></tablecell></tablerow></table></section><section id="Section5"><bookmark branch="hid/.uno:PatternField" id="bm_id1317017"/><bookmark branch="hid/.uno:PatternField" id="bm_id3155746"/><paragraph role="heading" level="2">Pattern Field</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_insertpatternfield.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:PatternField">Creates a pattern field.</ahelp> Pattern fields consist of an edit mask and a literal mask. The edit mask determines which data can be entered. The literal mask determines the contents of the pattern field when loading the form.</paragraph></tablecell></tablerow></table><paragraph role="note">Please note that pattern fields are not exported into HTML format.</paragraph></section><section id="Section17"><bookmark branch="hid/.uno:Groupbox" id="bm_id3430892"/><bookmark branch="hid/.uno:GroupBox" id="bm_id3147364"/><paragraph role="heading" level="2">Group Box</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_groupbox.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:GroupBox">Creates a frame to visually group several controls.</ahelp> Group boxes allow you to group option buttons in a frame.</paragraph><paragraph role="paragraph">If you insert a group frame into the document, the <link href="text/shared/autopi/01120000.xhp">Group Element Wizard</link> starts, which allows you to easily create an option group.</paragraph></tablecell></tablerow></table><paragraph role="paragraph"><emph>Note:</emph> When you drag a group box over already existing controls and then want to select a control, you have to first open the context menu of the group box and choose <emph>Arrange - Send to Back</emph>. Then select the control while pressing <switchinline select="sys"><caseinline select="MAC">Command
</caseinline><defaultinline>Ctrl</defaultinline></switchinline>.</paragraph><paragraph role="note">Group boxes are used only for a visual effect. A functional grouping of option fields can be made through the name definition: under the <link href="text/shared/02/01170101.xhp"><emph>Name</emph></link> properties of all option fields, enter the same name in order to group them.</paragraph></section><section id="Section4"><bookmark branch="hid/.uno:Grid" id="bm_id74623"/><bookmark branch="hid/.uno:Grid" id="bm_id3147372"/><paragraph role="heading" level="2">Table Control</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_grid.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".">Creates a table control to display a database table.</ahelp> If you create a new table control, the <link href="text/shared/02/01170800.xhp">Table Element Wizard</link> appears.</paragraph></tablecell></tablerow></table><paragraph role="paragraph"><link href="text/shared/02/01170004.xhp">Special information about Table Controls</link>.</paragraph></section><section id="Section24"><bookmark branch="hid/.uno:NavigationBar" id="bm_id8951689"/><bookmark branch="hid/.uno:NavigationBar" id="bm_id9112521"/><paragraph role="heading" level="2">Navigation bar</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_navigationbar.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid="SID_FM_NAVIGATIONBAR">Creates a navigation bar.</ahelp></paragraph></tablecell></tablerow></table><paragraph role="paragraph">The navigation bar allows you to move through the records of a database or a database form. The controls on this navigation bar work the same way as the controls on the default <link href="text/shared/main0213.xhp">navigation bar</link> in $[officename].</paragraph></section></section></case></switch><switch select="sys"><case select="HIDE_HERE"><section id="Section1"><bookmark branch="hid/.uno:AutoControlFocus" id="bm_id8170669"/><bookmark branch="hid/.uno:AutoControlFocus" id="bm_id3149198"/><paragraph role="heading" level="2">Automatic Control Focus</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_autocontrolfocus.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph"><ahelp hid=".uno:AutoControlFocus">If<emph> Automatic Control Focus </emph>is activated, the first form control will be selected when you open the document. If the button is not activated, the text will be selected after opening. The <link href="text/shared/02/01170300.xhp">Tab Order</link> that you have specified determines which is the first form control.</ahelp></paragraph></tablecell></tablerow></table></section></case></switch></body></helpdocument>
PK
%w�X{ͦ�� � text/shared/02/12140000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Data Source of Current Document</title><filename>/text/shared/02/12140000.xhp</filename></topic></meta><body><section id="aktdokdat"><bookmark branch="index" id="bm_id3151262"/><bookmark branch="hid/.uno:DataSourceBrowser/DocumentDataSource" id="bm_id3154230"/><bookmark branch="hid/.uno:DSBDocumentDataSource" id="bm_id9344157"/><paragraph role="heading" level="1"><link href="text/shared/02/12140000.xhp">Data Source of Current Document</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DataSourceBrowser/DocumentDataSource">Displays, in the data source browser, the table that is linked to the current document.</ahelp></paragraph></section><section id="syaktdokdat"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_dsbdocumentdatasource.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Data Source of Current Document</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph">Choose <emph>Edit - Exchange Database</emph> to select another table.</paragraph></body></helpdocument>
PK
%w�X\O�I I text/shared/02/12070100.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Table</title><filename>/text/shared/02/12070100.xhp</filename></topic></meta><body><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/astable" id="bm_id3109850"/><paragraph role="heading" level="1">Table</paragraph><bookmark branch="index" id="bm_id3156183"/><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/astable" visibility="hidden">Inserts data selected from the data source browser into the document as a table.</ahelp> In the <emph>Insert Database Columns</emph> dialog, select the <emph>Table</emph> option to insert the selected data into the document as a table. In the dialog, you can decide which database fields or columns are transferred, and how the text table is formatted.</paragraph><paragraph role="heading" level="2">Table</paragraph><paragraph role="paragraph">In the <emph>Table</emph> area, use the arrow keys to select the columns of the database table that you want to apply to the text table.</paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/tabledbcols" id="bm_id3155805"/><paragraph role="heading" level="3">Database columns</paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/tabledbcols">Specifies the database columns to be inserted into the text table.</ahelp> All database table columns that have not been accepted in the <emph>Table column(s)</emph> list box are listed here. The entries are sorted alphabetically. </paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/tablecols" id="bm_id3157959"/><paragraph role="heading" level="3">Table column(s)</paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/tablecols">Lists all database columns to be inserted into the document.</ahelp> A column will be assigned to each corresponding entry in the table. The entry order in the <emph>Table column(s)</emph> list box determines the data order in the text table.</paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/allright" id="bm_id3159234"/><paragraph role="heading" level="3">>></paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/allright">Moves all listed database fields into the <emph>Table column(s)</emph> list box.</ahelp> All fields listed in the <emph>Table column(s)</emph> list box are inserted into the document.</paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/oneright" id="bm_id3148539"/><paragraph role="heading" level="3">></paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/oneright">Moves the selected database field into the <emph>Table column(s)</emph> list box. </ahelp> You can also double click an entry to move it to the <emph>Table column(s)</emph> list box. All fields listed in the <emph>Table column(s)</emph> list box are inserted into the document.</paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/oneleft" id="bm_id3148992"/><paragraph role="heading" level="3"><</paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/oneleft">Removes the selected database field from the<emph> Table column(s)</emph> list box</ahelp> The removed field is not inserted into the document.</paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/allleft" id="bm_id3154286"/><paragraph role="heading" level="3"><<</paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/allleft">Removes all database fields from the <emph>Table column(s)</emph> list box.</ahelp></paragraph><section id="format"><paragraph role="heading" level="2">Format</paragraph><paragraph role="paragraph">Specifies the format for inserting the database fields into the document.</paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/fromdatabase" id="bm_id3146948"/><paragraph role="heading" level="3">From database</paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/fromdatabase">Accepts the database formats.</ahelp></paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/userdefined" id="bm_id3151378"/><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/userdefined" id="bm_id3159177"/><paragraph role="heading" level="3">Select</paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/numformat">Specifies a format from the list, if the format information of certain data fields is not accepted.</ahelp> The formats supplied here are only available for certain database fields, such as numeric or Boolean fields. If you select a database field in text format, you will not be able to select any format from the selection list, since the text format will be automatically maintained.</paragraph><paragraph role="paragraph">If the format you want is not listed, select "Other Formats..." and define the desired format in the <link href="text/shared/01/05020300.xhp"><emph>Number Format</emph></link> dialog.</paragraph><paragraph role="paragraph">The number format assigned using the selection list always refers to the database field selected in the <emph>Database columns</emph> list box.</paragraph></section><paragraph role="note">To insert the data into the document in the form of a table, the correct <emph>Table</emph> option must be active. You can then select a database field from the <emph>Table column(s)</emph> list box to define the formatting of the database field. The changes to the number formats will be applied to the last selection. It does not matter whether the database field was selected from the <emph>Database columns</emph> list box or from the <emph>Table column(s)</emph> list box.</paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/tableheading" id="bm_id3149167"/><paragraph role="heading" level="3">Insert table heading</paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/tableheading">Specifies whether to insert a heading line for the columns in the text table.</ahelp></paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/columnname" id="bm_id3145606"/><paragraph role="heading" level="3">Apply column name</paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/columnname">Uses the field names of the database table as headings for each of the text table columns.</ahelp></paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/rowonly" id="bm_id3148920"/><paragraph role="heading" level="3">Create row only</paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/rowonly">Inserts an empty heading line into the text table.</ahelp> Using the<emph> Create row only </emph>option, you can define headings in the document, which do not correspond to the database field names.</paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/tableformat" id="bm_id3155133"/><paragraph role="heading" level="3">Properties</paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/tableformat">Opens the <switchinline select="appl"><caseinline select="WRITER"><link href="text/swriter/01/05090000.xhp"><emph>Table Format</emph></link></caseinline><defaultinline><emph>Table Format</emph></defaultinline></switchinline> dialog, which enables you to define the table properties such as borders, background, and column width.</ahelp></paragraph><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/autoformat" id="bm_id3155411"/><paragraph role="heading" level="3">AutoFormat</paragraph><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/autoformat">Opens the <switchinline select="appl"><caseinline select="WRITER"><link href="text/swriter/01/05150101.xhp"><emph>AutoFormat</emph></link></caseinline><defaultinline><emph>AutoFormat</emph></defaultinline></switchinline> dialog, in which you can select format styles that are immediately applied when inserting the table.</ahelp></paragraph></body></helpdocument>
PK
%w�XQ� a
a
text/shared/02/09070400.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>New Document</title><filename>/text/shared/02/09070400.xhp</filename></topic></meta><body><section id="neuesdokument"><bookmark branch="hid/CUI_HID_HYPERLINK_NEWDOCUMENT" id="bm_id3159224"/><paragraph role="heading" level="1"><link href="text/shared/02/09070400.xhp">New Document</link></paragraph><paragraph role="paragraph">Use the <emph>New Document</emph> tab from the <link href="text/shared/02/09070000.xhp">Hyperlink dialog</link> to set up a hyperlink to a new document and create the new document simultaneously.</paragraph></section><section id="howtoget"><embed href="text/shared/00/00000403.xhp#hypdianeudok"/></section><paragraph role="heading" level="2">New Document</paragraph><paragraph role="paragraph">Specifies the name, path and type of the new document in this area.</paragraph><bookmark branch="hid/cui:RadioButton:RID_SVXPAGE_HYPERLINK_NEWDOCUMENT:RB_EDITNOW" id="bm_id3153394"/><paragraph role="heading" level="3">Edit now</paragraph><paragraph role="paragraph"><ahelp hid="SVX:RADIOBUTTON:RID_SVXPAGE_HYPERLINK_NEWDOCUMENT:RB_EDITNOW">Specifies that the new document is created and immediately opened for editing.</ahelp></paragraph><bookmark branch="hid/cui:RadioButton:RID_SVXPAGE_HYPERLINK_NEWDOCUMENT:RB_EDITLATER" id="bm_id3153683"/><paragraph role="heading" level="3">Edit later</paragraph><paragraph role="paragraph"><ahelp hid="SVX:RADIOBUTTON:RID_SVXPAGE_HYPERLINK_NEWDOCUMENT:RB_EDITLATER">Specifies that the document is created but it is not immediately opened.</ahelp></paragraph><bookmark branch="hid/cui:Edit:RID_SVXPAGE_HYPERLINK_NEWDOCUMENT:ED_PATH_NEWDOC" id="bm_id3149182"/><paragraph role="heading" level="3">File</paragraph><paragraph role="paragraph"><ahelp hid=".">Enter a URL for the file that you want to open when you click the hyperlink.</ahelp></paragraph><bookmark branch="hid/cui:ImageButton:RID_SVXPAGE_HYPERLINK_NEWDOCUMENT:BTN_CREATE" id="bm_id3166460"/><paragraph role="heading" level="3">Select Path</paragraph><paragraph role="paragraph"><ahelp hid="SVX:IMAGEBUTTON:RID_SVXPAGE_HYPERLINK_NEWDOCUMENT:BTN_CREATE">Opens the <emph>Select Path</emph> dialog, where you can select a path.</ahelp></paragraph><bookmark branch="hid/cui:ListBox:RID_SVXPAGE_HYPERLINK_NEWDOCUMENT:LB_DOCUMENT_TYPES" id="bm_id3153698"/><paragraph role="heading" level="3">File type</paragraph><paragraph role="paragraph"><ahelp hid="SVX:LISTBOX:RID_SVXPAGE_HYPERLINK_NEWDOCUMENT:LB_DOCUMENT_TYPES">Specifies the file type for the new document.</ahelp></paragraph><embed href="text/shared/02/09070100.xhp#weitere"/></body></helpdocument>
PK
%w�X��c�n n text/shared/02/01170700.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>HTML Filters and Forms</title><filename>/text/shared/02/01170700.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3163829"/><paragraph role="heading" level="1">HTML Filters and Forms</paragraph><paragraph role="paragraph">You can use all control elements and form events in HTML documents. There have been numerous events to date (for example, focus events), which have not been changed. They will continue to be imported and exported as ONFOCUS, ONBLUR, and so on for JavaScript and as SDONFOCUS, SDONBLUR, and so on for $[officename] Basic.</paragraph><paragraph role="paragraph">Generic names that consist of the Listener interface and the method name of the event are used for all other events: An event registered as XListener::method is exported as</paragraph><paragraph role="paragraph">SDEvent-XListener-method = "/* event-code */"</paragraph><paragraph role="paragraph">Note that the XListener- and method components of this option are case sensitive.</paragraph><paragraph role="paragraph">Event handling of controls is performed using the $[officename] API. If you assign an event to a control, an object registers itself internally as a "Listener" for a specific control event. To do this, the object must use a specific interface, for example the XFocusListener Interface, so that it can react to focus events. When the event occurs, the control then invokes a special method of the Listener interface when the control receives the focus. The internally registered object then invokes the JavaScript or $[officename] Basic code, which was assigned to the event.</paragraph><paragraph role="paragraph">The HTML filter now uses precisely these listener interfaces and method names so that it can import and export events as desired. You can register a focus event through</paragraph><paragraph role="paragraph"><INPUT TYPE=text ONFOCUS="/* code */"</paragraph><paragraph role="paragraph">rather than through the</paragraph><paragraph role="paragraph"><INPUT TYPE=text SDEvent-XFocusListener-focusGained="/* code */"</paragraph><paragraph role="paragraph">register. Events can therefore be registered as desired, including those not offered in the list boxes. To define the script language of events, you can write the following line in the document header:</paragraph><paragraph role="paragraph"><META HTTP-EQUIV="content-script-type" CONTENT="..."></paragraph><paragraph role="paragraph">As CONTENT you can, for example, use "text/x-StarBasic" for $[officename] Basic or a "text/JavaScript" for JavaScript. If no entry is made, JavaScript is assumed.</paragraph><paragraph role="paragraph">During exporting, the default script language will be defined based on the first module found in macro management. For events, only one language can be used per document.</paragraph></body></helpdocument>
PK
%w�X��H, , text/shared/02/10020000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Next Page</title><filename>/text/shared/02/10020000.xhp</filename></topic></meta><body><section id="naechsteseite"><bookmark branch="hid/.uno:PageDown" id="bm_id9254284"/><bookmark branch="hid/.uno:PageDown" id="bm_id3150476"/><bookmark branch="hid/.uno:NextPage" id="bm_id5265684"/><bookmark branch="hid/.uno:NextPage" id="bm_id3148520"/><paragraph role="heading" level="1"><link href="text/shared/02/10020000.xhp">Next Page</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:NextPage" visibility="visible">Moves forward to the next page in the document.</ahelp> This function is only active when you select the <emph>Print Preview</emph> function on the <emph>File</emph> menu.</paragraph></section><section id="synaechsteseite"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_pagedown.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Next Page</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�XZ���
�
text/shared/02/14020100.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Add Tables</title><filename>/text/shared/02/14020100.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3154788"/><bookmark branch="hid/.uno:AddTable" id="bm_id8385907"/><bookmark branch="hid/.uno:AddTable" id="bm_id3143284"/><bookmark branch="hid/dbaccess/ui/tablesjoindialog/tablelist" id="bm_id3159224"/><paragraph role="heading" level="1">Add Tables</paragraph><paragraph role="paragraph"><variable id="tabellehinzufuegentext"><ahelp hid="dbaccess/ui/tablesjoindialog/tablelist" visibility="hidden">Specifies the tables to be inserted into the design window.</ahelp> In the<emph> Add Tables </emph>dialog, select the tables you need for your current task.
</variable> When creating a query or a new table presentation, select the corresponding table to which the query or table presentation should refer. When working with relational databases, select the tables between which you want to build relationships.</paragraph><paragraph role="paragraph">The inserted tables appear in a separate window in the query design or relational windows, along with a list of the fields contained in the table. You can determine the size and order of this window.</paragraph><section id="howtoget"><embed href="text/shared/00/00000450.xhp#tabellehinzu"/></section><paragraph role="heading" level="2">Table</paragraph><bookmark branch="hid/dbaccess/ui/tablesjoindialog/tables" id="bm_id0305200912070094"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Shows only tables.</ahelp></paragraph><bookmark branch="hid/dbaccess/ui/tablesjoindialog/queries" id="bm_id0305200912074475"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Shows only queries.</ahelp></paragraph><paragraph role="heading" level="3">Table name</paragraph><paragraph role="paragraph"><ahelp hid="dbaccess/ui/tablesjoindialog/tablelist">Lists the available tables.</ahelp> To insert a table, select one from the list and click <emph>Add</emph>. You can also double-click the table name, and a window will be displayed containing the table fields at the top of the query design or the relational window.</paragraph><bookmark branch="hid/dbaccess/ui/tablesjoindialog/add" id="bm_id3155941"/><paragraph role="heading" level="2">Add</paragraph><paragraph role="paragraph"><ahelp hid="dbaccess/ui/tablesjoindialog/add">Inserts the currently selected table.</ahelp></paragraph><bookmark branch="hid/dbaccess/ui/tablesjoindialog/close" id="bm_id3153311"/><paragraph role="heading" level="2">Close</paragraph><paragraph role="paragraph"><ahelp hid="dbaccess/ui/tablesjoindialog/close">Closes the <emph>Add Tables</emph> dialog.</ahelp></paragraph></body></helpdocument>
PK
%w�X�=Eۅ � text/shared/02/01170500.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Design Mode On/Off</title><filename>/text/shared/02/01170500.xhp</filename></topic></meta><body><section id="designmodus"><bookmark branch="hid/.uno:SwitchControlDesignMode" id="bm_id8145432"/><bookmark branch="hid/.uno:SwitchControlDesignMode" id="bm_id3153255"/><bookmark branch="hid/.uno:SwitchXFormsDesignMode" id="bm_id6806897"/><bookmark branch="hid/.uno:SwitchXFormsDesignMode" id="bm_id1942197"/><paragraph role="heading" level="1"><link href="text/shared/02/01170500.xhp">Design Mode On/Off</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:SwitchControlDesignMode">Toggles the Design mode on or off. This function is used to switch quickly between <link href="text/shared/explorer/database/04030000.xhp">Design</link> and User mode. Activate to edit the form controls, deactivate to use the form controls.</ahelp></paragraph></section><section id="howtoget"><embed href="text/shared/00/00040501.xhp#design"/></section><paragraph role="note">Please note the <link href="text/shared/02/01171000.xhp"><emph>Open in Design Mode</emph></link> function. If <emph>Open in Design Mode</emph> is activated, the document is always opened in Design mode, regardless of the state in which it is saved.</paragraph><paragraph role="paragraph">If your form is linked to a database and you turn off the Design mode, the <link href="text/shared/main0213.xhp">Form Bar</link> is displayed at the lower margin of the document window. You can edit the link to the database in the <link href="text/shared/02/01170201.xhp">Form Properties</link>.</paragraph></body></helpdocument>
PK
%w�X��Vj\ \ text/shared/02/03130000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Borders</title><filename>/text/shared/02/03130000.xhp</filename></topic></meta><body><section id="umrandung"><bookmark branch="hid/.uno:SetBorderStyle" id="bm_id5165835"/><bookmark branch="hid/.uno:SetBorderStyle" id="bm_id3154228"/><paragraph role="heading" level="1"><link href="text/shared/02/03130000.xhp">Borders</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:SetBorderStyle">Click the <emph>Borders</emph> icon to open the <emph>Borders</emph> toolbar, where you can modify the border of a sheet area or an object.</ahelp></paragraph></section><paragraph role="paragraph"><switchinline select="appl"><caseinline select="CALC"/><defaultinline>This object can be the border of a text frame, a graphic or a table. The icon will only be visible if a graphic, table, object or frame has been selected.</defaultinline></switchinline></paragraph><paragraph role="paragraph"><switchinline select="appl"><caseinline select="CALC">To apply a particular type of border to a single cell, position the cursor in the cell, open the <emph>Border</emph> toolbar and select a border.
</caseinline><defaultinline>Whenever you insert graphics or tables, they already have a complete border. To remove that border, select the graphic object or the entire table and click the "no border" icon on the <emph>Border</emph> toolbar.</defaultinline></switchinline></paragraph><section id="syumrandung"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_setborderstyle.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Borders</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph">Further information can be found in the Help in <link href="text/shared/01/05030500.xhp"><emph>Borders</emph></link>. You can also find information on how to <link href="text/shared/guide/border_table.xhp">format a text table</link> with the <emph>Borders</emph> icon.</paragraph><section id="relatedtopics"><switch select="appl"><case select="WRITER"><embed href="text/swriter/guide/border_object.xhp#border_object"/><embed href="text/swriter/guide/border_page.xhp#border_page"/></case></switch><embed href="text/shared/guide/border_paragraph.xhp#border_paragraph"/><embed href="text/shared/guide/border_table.xhp#border_table"/></section></body></helpdocument>
PK
%w�X(��ڝ � text/shared/02/24060000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Brightness</title><filename>/text/shared/02/24060000.xhp</filename></topic></meta><body><section id="helligkeit"><bookmark branch="hid/.uno:GrafLuminance" id="bm_id2776804"/><bookmark branch="hid/.uno:GrafLuminance" id="bm_id3147000"/><paragraph role="heading" level="1"><link href="text/shared/02/24060000.xhp">Brightness</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:GrafLuminance" visibility="visible">Specifies the brightness for the selected graphic object.</ahelp> Values from -100% (only black) to +100% (only white) are possible.</paragraph></section><section id="syhelligkeit"><table><tablerow><tablecell><paragraph role="paragraph"><image src="res/sc10863.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Brightness</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X�v-�j j text/shared/02/01170201.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>General</title><filename>/text/shared/02/01170201.xhp</filename></topic></meta><body><section id="allgemein"><bookmark branch="index" id="bm_id3152551"/><paragraph role="heading" level="1"><link href="text/shared/02/01170201.xhp">General</link></paragraph></section><section id="howtoget"><embed href="text/shared/00/00040501.xhp#formulareigenschaftenallgemein"/></section><paragraph role="paragraph">A form is a text document or spreadsheet with different form controls. If you create a form for a Web page, the user can enter data into it to send over the Internet. The data from the form controls of a form is transmitted to a server by specifying a URL and can be processed on the server.</paragraph><paragraph role="heading" level="2">Name</paragraph><paragraph role="paragraph">Specifies a name for the form. This name is used to identify the form in the <link href="text/shared/02/01170600.xhp">Form Navigator</link>.</paragraph><paragraph role="heading" level="2">URL</paragraph><paragraph role="paragraph">Specifies the URL to which the data of the completed form is to be transmitted.</paragraph><paragraph role="heading" level="2">Frame</paragraph><paragraph role="paragraph">Defines the target frame in which the loaded URL is to appear.</paragraph><embed href="text/shared/02/01170101.xhp#fuerformulareigenschaft"/><bookmark branch="hid/EXTENSIONS_HID_PROP_SUBMIT_METHOD" id="bm_id3145313"/><paragraph role="heading" level="2">Type of submission</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_SUBMIT_METHOD">Specifies the method to transfer the completed form information.</ahelp></paragraph><paragraph role="paragraph">Using the "Get" method, the data of every control is transmitted as an environment variable. They are appended to the URL in the form "?Control1=Content1&Control2=Content2&..."; the character string is analyzed by a program on the recipient's server.</paragraph><paragraph role="paragraph">Using the "Post" method, a document is created from the content of the form that is sent to the specified URL.</paragraph><bookmark branch="hid/EXTENSIONS_HID_PROP_SUBMIT_ENCODING" id="bm_id3154047"/><paragraph role="heading" level="2">Submission encoding</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_SUBMIT_ENCODING">Specifies the type for encoding the data transfer.</ahelp></paragraph><paragraph role="heading" level="2">Data transfer of control information</paragraph><paragraph role="paragraph">When sending a form, all controls available in $[officename] are taken into consideration. The name of the control and the corresponding value, if available, are transmitted.</paragraph><paragraph role="paragraph">Which values are transmitted in each case depends on the respective control. For text fields, the visible entries are transmitted; for list boxes, the selected entries are transmitted; for check boxes and option fields, the associated reference values are transmitted if these fields were activated.</paragraph><paragraph role="paragraph">How this information is transmitted depends on the selected transfer method (Get or Post) and the coding (URL or Multipart). If the Get method and URL encoding are selected, for example, value pairs in the form <Name>=<Value> are sent.</paragraph><paragraph role="paragraph">In addition to the controls that are recognized in HTML, $[officename] offers other controls. It should be noted that, for fields with a specific numerical format, the visible values are not transmitted but rather fixed default formats. The following table shows how the data of the $[officename]-specific controls is transmitted:</paragraph><table><tablerow><tablecell><paragraph role="tablehead">Control</paragraph></tablecell><tablecell><paragraph role="tablehead">Value Pair</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Numeric field, currency field</paragraph></tablecell><tablecell><paragraph role="tablecontent">A decimal separator is always displayed as a period.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Date field</paragraph></tablecell><tablecell><paragraph role="tablecontent">The date format is sent in a fixed format (MM-DD-YYYY), regardless of the user's local settings.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Time field</paragraph></tablecell><tablecell><paragraph role="tablecontent">The time format is sent in a fixed format (HH:MM:SS), regardless of the user's local settings.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Pattern field</paragraph></tablecell><tablecell><paragraph role="tablecontent">The values of pattern fields are sent as text fields, that is, the value visible in the form is sent.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Table control</paragraph></tablecell><tablecell><paragraph role="tablecontent">From the table control, the individual columns are always transmitted. The name of the control, the name of the column, and the value of the column are sent. Using the Get method with URL encoding, the transmission is done in the form <Name of the table control>.<Name of the column>=<Value>, for example, with the value being dependent on the column.</paragraph></tablecell></tablerow></table></body></helpdocument>
PK
%w�X�4� � text/shared/02/01170903.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>List Box Wizard: Field Link</title><filename>/text/shared/02/01170903.xhp</filename></topic></meta><body><section id="seite3a"><bookmark branch="hid/modules/sabpilot/ui/fieldlinkpage/FieldLinkPage" id="bm_id3150808"/><paragraph role="heading" level="1"><link href="text/shared/02/01170903.xhp">List Box Wizard: Field Link</link></paragraph><paragraph role="paragraph">Indicates through which fields tables of values and list tables are linked.</paragraph></section><paragraph role="paragraph">The value table is the table of the current form where the list field is inserted. The list table is the table whose data is to be shown in the list field. Both tables must be linked over a mutual data field. These links are to be entered on this page of the wizard. The field names must not necessarily be the same (this depends upon how the field names are defined in both tables), but both fields must have the same field type.</paragraph><section id="howtoget"><embed href="text/shared/00/00040501.xhp#aupikomli3a"/></section><paragraph role="heading" level="2">Value table field</paragraph><paragraph role="paragraph"><ahelp hid="modules/sabpilot/ui/fieldlinkpage/valuefield">Specifies the current form data field which should be related to a field in the linked table.</ahelp> In addition, click the desired data field in the list field below.</paragraph><paragraph role="paragraph">In <link href="text/shared/02/01170102.xhp">Control - Properties</link>, the specified field will appear as an entry in the <emph>Data</emph> tab page under <emph>Data field</emph>.</paragraph><paragraph role="heading" level="2">List table field</paragraph><paragraph role="paragraph"><ahelp hid="modules/sabpilot/ui/fieldlinkpage/listtable">Specifies the linked table data field, which is related to the specified value table field.</ahelp> In addition, click the data field in the lower list field.</paragraph><paragraph role="paragraph">In <link href="text/shared/02/01170102.xhp">Control - Properties</link>, the specified field will appear in the <emph>Data</emph> tab page of a SQL statement under <emph>List Contents</emph>.</paragraph></body></helpdocument>
PK
%w�Xu���) ) text/shared/02/01170800.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Table Element Wizard</title><filename>/text/shared/02/01170800.xhp</filename></topic></meta><body><paragraph role="heading" level="1"><link href="text/shared/02/01170800.xhp">Table Element Wizard</link></paragraph><paragraph role="paragraph">If you insert a table control in a document, the <emph>Table Element Wizard</emph> starts automatically. In this wizard, you can interactively specify which information is displayed in the table control.</paragraph><section id="howtoget"><embed href="text/shared/00/00040501.xhp#aupitab"/></section><paragraph role="note">You can use the <link href="text/shared/02/01171100.xhp"><emph>Wizards On/Off</emph></link> icon to keep the wizard from starting automatically.</paragraph><embed href="text/shared/02/01170801.xhp#seite1"/><embed href="text/shared/02/01170802.xhp#seite2"/><bookmark branch="hid/EXTENSIONS_HID_GRIDWIZARD_CANCEL" id="bm_id3155552"/><embed href="text/shared/00/00000001.xhp#abbrechen"/><bookmark branch="hid/EXTENSIONS_HID_GRIDWIZARD_PREVIOUS" id="bm_id3154094"/><embed href="text/shared/00/00000001.xhp#zurueckautopi"/><bookmark branch="hid/EXTENSIONS_HID_GRIDWIZARD_NEXT" id="bm_id3147226"/><embed href="text/shared/00/00000001.xhp#weiterautopi"/></body></helpdocument>
PK
%w�X���# # text/shared/02/03150000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Border Color</title><filename>/text/shared/02/03150000.xhp</filename></topic></meta><body><section id="linienfarbe"><bookmark branch="hid/.uno:FrameLineColor" id="bm_id3109850"/><paragraph role="heading" level="1"><link href="text/shared/02/03150000.xhp">Border Color</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:FrameLineColor">Click the <emph>Line Color (of the border)</emph> icon to open the <emph>Border Color</emph> toolbar, which enables you to change the border color of an object.</ahelp></paragraph></section><section id="sylinienfarbe"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_framelinecolor.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Line Color (of the border)</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph">For more information, see the <link href="text/shared/01/05030500.xhp">Borders</link> section in the Help.</paragraph></body></helpdocument>
PK
%w�XL�@�� � text/shared/02/10100000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Close Window</title><filename>/text/shared/02/10100000.xhp</filename></topic></meta><body><section id="schliessen"><bookmark branch="hid/.uno:CloseWin" id="bm_id8159155"/><bookmark branch="hid/.uno:CloseWin" id="bm_id3148520"/><paragraph role="heading" level="1"><link href="text/shared/02/10100000.xhp">Close Window</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:CloseWin">Closes the current window.</ahelp> Choose <emph>Window - Close Window</emph>, or press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F4. In the print preview of $[officename] Writer and Calc, you can close the current window by clicking the <emph>Close Preview</emph> button.</paragraph></section><paragraph role="paragraph">If additional views of the current document were opened by <emph>Window - New Window</emph>, this command will close only the current view.</paragraph><section id="relatedtopics"><paragraph role="paragraph"><link href="text/shared/01/01050000.xhp">Close the current document</link></paragraph></section></body></helpdocument>
PK
%w�Xj�� � text/shared/02/01170600.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Form Navigator</title><filename>/text/shared/02/01170600.xhp</filename></topic></meta><body><section id="formex"><bookmark branch="index" id="bm_id3143284"/><bookmark branch="hid/.uno:ShowFmExplorer" id="bm_id7827565"/><bookmark branch="hid/.uno:ShowFmExplorer" id="bm_id3144740"/><paragraph role="heading" level="1"><link href="text/shared/02/01170600.xhp">Form Navigator</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:ShowFmExplorer">Opens the <emph>Form Navigator</emph>. The <emph>Form Navigator</emph> displays all forms and subforms of the current document with their respective controls.</ahelp></paragraph></section><paragraph role="paragraph">When using several forms, the Form Navigator gives an overview of all forms, and also provides various functions for editing them.</paragraph><section id="howtoget"><embed href="text/shared/00/00040501.xhp#formex"/></section><bookmark branch="hid/SVX_HID_FORM_NAVIGATOR" id="bm_id3153748"/><paragraph role="paragraph"><ahelp hid="HID_FORM_NAVIGATOR">The <emph>Form Navigator</emph> contains a list of all created (logical) forms with the corresponding control fields.</ahelp> You can see whether a form contains control fields by the plus sign displayed before the entry. Click the plus sign to open the list of the form elements.</paragraph><paragraph role="paragraph">You can change how the different controls are arranged by dragging and dropping them in the <emph>Form Navigator</emph>. Select one or more controls and drag them into another form. Alternatively use <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+X or the context menu command <emph>Cut</emph> to move a control to the clipboard and <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V or the command <emph>Insert</emph> to insert the control into another position.</paragraph><paragraph role="paragraph">To edit the name in the <emph>Form Navigator</emph>, click on the name and enter a new name, or use the command in the context menu.</paragraph><paragraph role="paragraph">If you select a control in the <emph>Form Navigator</emph>, the corresponding element is selected in the document.</paragraph><paragraph role="paragraph">If you call the context menu of a selected entry, the <emph>Form Navigator</emph> offers the following functions:</paragraph><bookmark branch="hid/SVX_HID_FM_NEW" id="bm_id3154285"/><paragraph role="heading" level="2">New</paragraph><paragraph role="paragraph"><ahelp hid="SID_FM_NEW">Adds new elements to the form. The<emph> Add </emph>function can only be called if a form is selected in the <emph>Form Navigator</emph>.</ahelp></paragraph><bookmark branch="hid/SVX_HID_FM_NEW_FORM" id="bm_id3156326"/><paragraph role="heading" level="3">Form</paragraph><paragraph role="paragraph"><ahelp hid="SID_FM_NEW_FORM">Creates a new form in the document. </ahelp> To create a <link href="text/shared/02/01170203.xhp">subform</link>, add the new form under the desired parent form.</paragraph><bookmark branch="hid/SVX_HID_FM_NEW_HIDDEN" id="bm_id3147618"/><paragraph role="heading" level="3">Hidden Control</paragraph><paragraph role="paragraph"><ahelp hid="SID_FM_NEW_HIDDEN">Creates a hidden control in the selected form that is not displayed on the screen. A hidden control serves to include data that is transmitted together with the form.</ahelp> It contains additional information or clarifying text that you can specify when creating the form through the <link href="text/shared/02/01170101.xhp">Special Properties</link> of the control. Select the entry of the hidden control in the <emph>Form Navigator</emph> and select the <emph>Properties</emph> command.</paragraph><paragraph role="paragraph">You can copy controls in the document through the clipboard (shortcut keys <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C for copying and <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V for inserting). You can copy hidden controls in the <emph>Form Navigator</emph> by using drag-and-drop while keeping the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key pressed.</paragraph><paragraph role="paragraph">Drag and drop to copy controls within the same document or between documents. Open another form document and drag the hidden control from the <emph>Form Navigator</emph> into the <emph>Form Navigator</emph> of the target document. Click a visible control directly in the document, rest the mouse for a moment so that a copy of the control is added to the drag-and-drop clipboard, then drag the copy into the other document. If you want a copy in the same document, press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> while dragging.</paragraph><bookmark branch="hid/SVX_HID_FM_DELETE" id="bm_id3154073"/><paragraph role="heading" level="2">Delete</paragraph><paragraph role="paragraph"><ahelp hid="SID_FM_DELETE">Deletes the selected entry.</ahelp> This allows you to delete individual form components as well as whole forms with one mouse click.</paragraph><paragraph role="heading" level="2">Tab order</paragraph><paragraph role="paragraph">When a form is selected, it opens the <link href="text/shared/02/01170300.xhp"><emph>Tab Order</emph></link> dialog, where the indices for focusing the control elements on the Tab key are defined.</paragraph><bookmark branch="hid/SVX_HID_FM_RENAME_OBJECT" id="bm_id3153180"/><paragraph role="heading" level="2">Rename</paragraph><paragraph role="paragraph"><ahelp hid="SID_FM_RENAME_OBJECT">Renames the selected object.</ahelp></paragraph><bookmark branch="hid/.uno:ShowPropertyBrowser" id="bm_id4632447"/><bookmark branch="hid/.uno:ShowPropertyBrowser" id="bm_id3153970"/><paragraph role="heading" level="2">Properties</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ShowPropertyBrowser">Starts the <emph>Properties</emph> dialog for the selected entry.</ahelp> If a form is selected, the <link href="text/shared/02/01170200.xhp">Form Properties</link> dialog opens. If a control is selected, the <link href="text/shared/02/01170100.xhp">Control Properties</link> dialog opens.</paragraph><embed href="text/shared/02/01171000.xhp#imentwurfsmodusoeffnen"/></body></helpdocument>
PK
%w�Xer�t> > text/shared/02/stars.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Stars and Banners</title><filename>/text/shared/02/stars.xhp</filename></topic></meta><body><section id="stars"><bookmark branch="hid/.uno:StarShapes" id="bm_id8048189"/><bookmark branch="hid/.uno:StarShapes" id="bm_id833460"/><paragraph role="heading" level="1"><link href="text/shared/02/stars.xhp">Stars and Banners</link></paragraph><paragraph role="paragraph"><ahelp hid=".">Opens the Stars and Banners toolbar from which you can insert graphics into your document.</ahelp></paragraph></section><section id="howtoget"><embed href="text/shared/00/00000404.xhp#systars"/></section><bookmark branch="hid/.uno:StarShapes.bang" id="bm_id4433729"/><bookmark branch="hid/.uno:StarShapes.star4" id="bm_id8384044"/><bookmark branch="hid/.uno:StarShapes.star5" id="bm_id1719718"/><bookmark branch="hid/.uno:StarShapes.star6" id="bm_id4883571"/><bookmark branch="hid/.uno:StarShapes.star8" id="bm_id3749198"/><bookmark branch="hid/.uno:StarShapes.star12" id="bm_id5319376"/><bookmark branch="hid/.uno:StarShapes.star24" id="bm_id4196905"/><bookmark branch="hid/.uno:StarShapes.concave-star6" id="bm_id6884365"/><bookmark branch="hid/.uno:StarShapes.vertical-scroll" id="bm_id8509475"/><bookmark branch="hid/.uno:StarShapes.horizontal-scroll" id="bm_id3536179"/><bookmark branch="hid/.uno:StarShapes.signet" id="bm_id9791558"/><bookmark branch="hid/.uno:StarShapes.doorplate" id="bm_id4991302"/><paragraph role="paragraph"><ahelp hid=".">Click an icon on the Stars and Banners toolbar, and then drag in the document to draw the shape.</ahelp></paragraph><paragraph role="note">Some shapes have a special handle which you can drag to change the properties of the shape. The mouse pointer changes to a hand symbol over these special handles.</paragraph></body></helpdocument>
PK
%w�XY���$ $ text/shared/02/01170202.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Events</title><filename>/text/shared/02/01170202.xhp</filename></topic></meta><body><section id="ereignisse"><bookmark branch="index" id="bm_id3150499"/><paragraph role="heading" level="1"><link href="text/shared/02/01170202.xhp">Events</link></paragraph><paragraph role="paragraph">The<emph> Events </emph>tab page, allows you to assign a macro to certain events which occur in a form.</paragraph></section><section id="howtoget"><embed href="text/shared/00/00040501.xhp#formulareigenschaftenereignisse"/></section><paragraph role="paragraph">To link an event with a macro, first write a macro that contains all the commands to be executed when the event happens. Then assign this macro to the respective event by clicking the <emph>... </emph>button beside the corresponding event. The<emph> Assign Macro </emph>dialog opens, where you can select the macro.</paragraph><paragraph role="paragraph">The following actions can be configured individually, meaning that you can use your own dialogs to depict an action:</paragraph><list type="ordered"><listitem><paragraph role="listitem">Displaying an error message,</paragraph></listitem></list><list type="ordered"><listitem><paragraph role="listitem">Confirming a delete process (for data records),</paragraph></listitem></list><list type="ordered"><listitem><paragraph role="listitem">Querying parameters,</paragraph></listitem></list><list type="ordered"><listitem><paragraph role="listitem">Checking input when saving a data record.</paragraph></listitem></list><paragraph role="paragraph">For example, you can issue a "confirm deletion" request such as "Really delete customer xyz?" when deleting a data record.</paragraph><paragraph role="note">The events that are shown in the Events dialog cannot be edited directly. You can delete an event from the list by pressing the Del key.</paragraph><paragraph role="paragraph">The following lists and describes all events in a form that can be linked to a macro:</paragraph><sort order="asc"><section id="reset_update"><paragraph role="heading" level="2">Before update</paragraph><paragraph role="paragraph"><ahelp hid=".">The Before update event occurs before the control content changed by the user is written into the data source.</ahelp> The linked macro can, for example, prevent this action by returning "FALSE".</paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_AFTERUPDATE" id="bm_id3154073"/><paragraph role="heading" level="2">After update</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_AFTERUPDATE">The After update event occurs after the control content changed by the user has been written into the data source.</ahelp></paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_APPROVERESETTED" id="bm_id3154851"/><paragraph role="heading" level="2">Prior to reset</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_APPROVERESETTED">The<emph> Prior to reset </emph>event occurs before a form is reset.</ahelp> The linked macro can, for example, prevent this action by returning "FALSE".</paragraph><paragraph role="paragraph">A form is reset if one of the following conditions is met:</paragraph><list type="ordered"><listitem><paragraph role="listitem">The user presses an (HTML) button that is defined as a reset button.</paragraph></listitem><listitem><paragraph role="listitem">A new and empty record is created in a form that is linked to a data source. For example, in the last record, the <emph>Next Record</emph> button may be pressed.</paragraph></listitem></list><bookmark branch="hid/EXTENSIONS_HID_EVT_RESETTED" id="bm_id3152473"/><paragraph role="heading" level="2">After resetting</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_RESETTED">The<emph> After resetting </emph>event occurs after a form has been reset.</ahelp></paragraph></section><section id="Section13"><bookmark branch="hid/EXTENSIONS_HID_EVT_SUBMITTED" id="bm_id3147084"/><paragraph role="heading" level="2">Before submitting</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_SUBMITTED">The<emph> Before submitting </emph>event occurs before the form data is sent.</ahelp></paragraph></section><section id="Section12"><bookmark branch="hid/EXTENSIONS_HID_EVT_LOADED" id="bm_id3151383"/><paragraph role="heading" level="2">When loading</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_LOADED">The<emph> When loading </emph>event occurs directly after the form has been loaded.</ahelp></paragraph></section><section id="Section11"><bookmark branch="hid/EXTENSIONS_HID_EVT_RELOADING" id="bm_id3157320"/><paragraph role="heading" level="2">Before reloading</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_RELOADING">The<emph> Before reloading </emph>event occurs before the form is reloaded.</ahelp> The data content has not yet been refreshed.</paragraph></section><section id="Section10"><bookmark branch="hid/EXTENSIONS_HID_EVT_RELOADED" id="bm_id3154946"/><paragraph role="heading" level="2">When reloading</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_RELOADED">The<emph> When reloading </emph>event occurs directly after the form has been reloaded.</ahelp> The data content has already been refreshed.</paragraph></section><section id="Section9"><bookmark branch="hid/EXTENSIONS_HID_EVT_UNLOADING" id="bm_id3151116"/><paragraph role="heading" level="2">Before unloading</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_UNLOADING">The<emph> Before unloading </emph>event occurs before the form is unloaded; that is, separated from its data source.</ahelp></paragraph></section><section id="Section8"><bookmark branch="hid/EXTENSIONS_HID_EVT_UNLOADED" id="bm_id3152938"/><paragraph role="heading" level="2">When unloading</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_UNLOADED">The<emph> When unloading </emph>event occurs directly after the form has been unloaded; that is, separated from its data source.</ahelp></paragraph></section><section id="Section7"><bookmark branch="hid/EXTENSIONS_HID_EVT_CONFIRMDELETE" id="bm_id3154127"/><paragraph role="heading" level="2">Confirm deletion</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_CONFIRMDELETE">The<emph> Confirm deletion </emph>event occurs as soon as data has been deleted from the form.</ahelp> For example, the linked macro can request confirmation in a dialog.</paragraph></section><section id="Section6"><bookmark branch="hid/EXTENSIONS_HID_EVT_APPROVEROWCHANGE" id="bm_id3151351"/><paragraph role="heading" level="2">Before record action</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_APPROVEROWCHANGE">The<emph> Before record action </emph>event occurs before the current record is changed.</ahelp> For example, the linked macro can request confirmation in a dialog.</paragraph></section><section id="Section5"><bookmark branch="hid/EXTENSIONS_HID_EVT_ROWCHANGE" id="bm_id3150685"/><paragraph role="heading" level="2">After record action</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_ROWCHANGE">The<emph> After record action </emph>event occurs directly after the current record has been changed.</ahelp></paragraph></section><section id="Section4"><bookmark branch="hid/EXTENSIONS_HID_EVT_POSITIONING" id="bm_id3155413"/><paragraph role="heading" level="2">Before record change</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_POSITIONING">The<emph> Before record change </emph>event occurs before the current record pointer is changed.</ahelp> For example, the linked macro can prevent this action by returning "FALSE".</paragraph></section><section id="Section3"><bookmark branch="hid/EXTENSIONS_HID_EVT_POSITIONED" id="bm_id3150420"/><paragraph role="heading" level="2">After record change</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_POSITIONED">The<emph> After record change </emph>event occurs directly after the current record pointer has been changed.</ahelp></paragraph></section><section id="Section2"><bookmark branch="hid/EXTENSIONS_HID_EVT_APPROVEPARAMETER" id="bm_id3149298"/><paragraph role="heading" level="2">Fill parameters</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_APPROVEPARAMETER">The<emph> Fill parameters </emph>event occurs when the form to be loaded has parameters that must be filled out.</ahelp> For example, the data source of the form can be the following SQL command:</paragraph><paragraph role="paragraph">SELECT * FROM address WHERE name=:name</paragraph><paragraph role="paragraph">Here :name is a parameter that must be filled out when loading. The parameter is automatically filled out from the parent form if possible. If the parameter cannot be filled out, this event is called and a linked macro can fill out the parameter.</paragraph></section><section id="Section1"><bookmark branch="hid/EXTENSIONS_HID_EVT_ERROROCCURRED" id="bm_id3148387"/><paragraph role="heading" level="2">Error occurred</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_ERROROCCURRED">The<emph> Error occurred </emph>event is activated if an error occurs when accessing the data source.</ahelp> This applies to forms, list boxes and combo boxes.</paragraph></section></sort></body></helpdocument>
PK
%w�Xzy� � text/shared/02/14010000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Run</title><filename>/text/shared/02/14010000.xhp</filename></topic></meta><body><section id="abfrage"><bookmark branch="hid/.uno:SbaExecuteSql" id="bm_id940934"/><bookmark branch="hid/.uno:SbaExecuteSql" id="bm_id3149495"/><paragraph role="heading" level="1"><link href="text/shared/02/14010000.xhp">Run Query</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:SbaExecuteSql">Runs the SQL query and displays the query result.</ahelp> The <emph>Run Query</emph> function does not save the query.</paragraph></section><paragraph role="paragraph">The<emph> Run Query </emph>function allows you to check the query. When you save the query, it is stored in the <emph>Query</emph> tab page.</paragraph><paragraph role="tip">Choose <emph>View - Preview</emph> to run the query from the menu bar of a query design window.</paragraph><section id="syabfrage"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_sbaexecutesql.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Run Query</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X{�
�� � text/shared/02/07080000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Stop Loading</title><filename>/text/shared/02/07080000.xhp</filename></topic></meta><body><section id="stop"><bookmark branch="hid/SID_BROWSE_STOP" id="bm_id1158113"/><bookmark branch="hid/.uno:Stop" id="bm_id3148520"/><paragraph role="heading" level="1"><link href="text/shared/02/07080000.xhp">Stop Loading</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:Stop">Click to interrupt the current loading process, <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>-click to interrupt all loading processes.</ahelp></paragraph></section></body></helpdocument>
PK
%w�X�F � text/shared/02/01171100.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Wizards On/Off</title><filename>/text/shared/02/01171100.xhp</filename></topic></meta><body><section id="autopilotenanaus"><bookmark branch="hid/.uno:UseWizards" id="bm_id2211707"/><bookmark branch="hid/.uno:UseWizards" id="bm_id3156211"/><paragraph role="heading" level="1"><link href="text/shared/02/01171100.xhp">Wizards On/Off</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:UseWizards">Specifies whether to start the wizard automatically when inserting a new control.</ahelp> This setting applies globally to all documents.</paragraph></section><section id="howtoget"><embed href="text/shared/00/00040501.xhp#autopilotenanaus"/></section><paragraph role="paragraph">There are wizards for inserting a list box or combo box, a table element and group boxes.</paragraph></body></helpdocument>
PK
%w�XL�_ _ text/shared/02/12130000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Data source as table</title><filename>/text/shared/02/12130000.xhp</filename></topic></meta><body><section id="datenquelletab"><bookmark branch="index" id="bm_id3152895"/><bookmark branch="hid/.uno:ViewFormAsGrid" id="bm_id1551702"/><bookmark branch="hid/.uno:ViewFormAsGrid" id="bm_id3148983"/><paragraph role="heading" level="1"><link href="text/shared/02/12130000.xhp">Data source as table</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:ViewFormAsGrid">Activates an additional table view when in the form view.</ahelp> When the<emph> Data source as table</emph> function is activated, you see the table in an area above the form.</paragraph></section><section id="sydatenquelletab"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_viewformasgrid.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Data source as table</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph">The table view and form view reflect the same data. Changes made in the table are also visible in the form, and changes to the form are visible in the table.</paragraph><paragraph role="paragraph">If there are several logical forms in a document, the table is only able to show one at a time.</paragraph></body></helpdocument>
PK
%w�X;��H H text/shared/02/09070200.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Mail</title><filename>/text/shared/02/09070200.xhp</filename></topic></meta><body><section id="mailnews"><bookmark branch="hid/CUI_HID_HYPERLINK_MAIL" id="bm_id3152918"/><paragraph role="heading" level="1"><link href="text/shared/02/09070200.xhp">Mail</link></paragraph><paragraph role="paragraph">On the <emph>Mail</emph> page in the <link href="text/shared/02/09070000.xhp">Hyperlink dialog</link> you can edit hyperlinks for e-mail addresses.</paragraph></section><section id="howtoget"><embed href="text/shared/00/00000403.xhp#hypdiamailnews"/></section><paragraph role="heading" level="2">Mail</paragraph><bookmark branch="hid/cui:RadioButton:RID_SVXPAGE_HYPERLINK_MAIL:RB_LINKTYP_MAIL" id="bm_id3153311"/><paragraph role="heading" level="3">E-mail</paragraph><paragraph role="paragraph"><ahelp hid="SVX_RADIOBUTTON_RID_SVXPAGE_HYPERLINK_MAIL_RB_LINKTYP_MAIL">Assigns the specified e-mail address to the hyperlink.</ahelp> Clicking the new hyperlink in the document will open a new message document, addressed to the receiver specified in the <emph>Recipient</emph> field.</paragraph><bookmark branch="hid/CUI_HID_HYPERDLG_MAIL_PATH" id="bm_id3144438"/><paragraph role="heading" level="3">Recipient</paragraph><paragraph role="paragraph"><ahelp hid="HID_HYPERDLG_MAIL_PATH">Specifies the full URL of the addressee, in the form mailto:name@provider.com or news:group.server.com.</ahelp> You can also use drag-and-drop.</paragraph><bookmark branch="hid/cui:ImageButton:RID_SVXPAGE_HYPERLINK_MAIL:BTN_ADRESSBOOK" id="bm_id3155449"/><paragraph role="heading" level="3">Data Sources</paragraph><paragraph role="paragraph"><ahelp hid="SVX_IMAGEBUTTON_RID_SVXPAGE_HYPERLINK_MAIL_BTN_ADRESSBOOK">Hides or shows the data source browser.</ahelp> Drag the receiver's <emph>E-mail</emph> data field from the data source browser into the <emph>Recipient</emph> text field.</paragraph><bookmark branch="hid/cui:Edit:RID_SVXPAGE_HYPERLINK_MAIL:ED_SUBJECT" id="bm_id3154852"/><paragraph role="heading" level="3">Subject</paragraph><paragraph role="paragraph"><ahelp hid="SVX_EDIT_RID_SVXPAGE_HYPERLINK_MAIL_ED_SUBJECT">Specifies the subject that is inserted in the subject line of the new message document.</ahelp></paragraph><embed href="text/shared/02/09070100.xhp#weitere"/></body></helpdocument>
PK
%w�X�{�G� � text/shared/02/14040000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Functions</title><filename>/text/shared/02/14040000.xhp</filename></topic></meta><body><section id="funktionen"><bookmark branch="hid/.uno:DBViewFunctions" id="bm_id3154840"/><paragraph role="heading" level="1"><link href="text/shared/02/14040000.xhp">Functions</link></paragraph><paragraph role="paragraph"><ahelp visibility="visible" hid=".uno:DBViewFunctions">Displays the "Function" row in the lower part of the design view of the <link href="text/shared/explorer/database/02010100.xhp">Query Design</link> window.</ahelp></paragraph></section><section id="syfunktionen"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_dbviewfunctions.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Functions</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�XF�/;� � text/shared/02/24100000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Crop</title><filename>/text/shared/02/24100000.xhp</filename></topic></meta><body><section id="zuschneiden"><bookmark branch="hid/.uno:GrafAttrCrop" id="bm_id9106091"/><bookmark branch="hid/.uno:GrafAttrCrop" id="bm_id3154840"/><paragraph role="heading" level="1"><link href="text/shared/02/24100000.xhp">Crop</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:GrafAttrCrop">Allows to crop the display of an inserted picture. Only the display gets cropped, the inserted picture is not changed.</ahelp> A picture must be selected to enable cropping.</paragraph><bookmark branch="hid/.uno:Crop" id="bm_id0514200804065077"/><paragraph role="paragraph">In Impress and Draw no dialog is shown when you click the icon, but you see eight cropping handles. Open the context menu of a selected picture and choose <item type="menuitem">Crop Image</item>, if you want to use the <link href="text/shared/01/05030800.xhp">dialog</link> for cropping.</paragraph><paragraph role="paragraph"><ahelp hid=".">Drag any of the eight cropping handles to crop the picture.</ahelp></paragraph></section><section id="sycut"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_crop.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Crop</paragraph></tablecell></tablerow></table></section><embed href="text/shared/01/05030800.xhp#pixelcut"/></body></helpdocument>
PK
%w�X�J� � text/shared/02/12100100.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Sort Order</title><filename>/text/shared/02/12100100.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3147000"/><bookmark branch="hid/dbaccess/ui/sortdialog/SortDialog" id="bm_id3154788"/><bookmark branch="hid/.uno:OrderCrit" id="bm_id3154682"/><section id="sortorder"><paragraph role="heading" level="1"><variable id="sortierung"><link href="text/shared/02/12100100.xhp">Sort Order</link></variable></paragraph><paragraph role="paragraph"><variable id="sortierentext"><ahelp hid=".uno:OrderCrit">Specifies the sort criteria for the data display.</ahelp></variable></paragraph></section><section id="howtoget"><embed href="text/shared/00/00000450.xhp#sortieren"/></section><paragraph role="paragraph">While the functions <link href="text/shared/02/12010000.xhp"><emph>Sort in Ascending Order</emph></link> and <link href="text/shared/02/12020000.xhp"><emph>Sort in Descending Order</emph></link> sort by one criterion only, you can combine several criteria in the<emph> Sort Order </emph>dialog.</paragraph><paragraph role="paragraph">You can remove a sorting that has been performed with the <link href="text/shared/02/12040000.xhp"><emph>Reset Filter/Sorting</emph></link> icon.</paragraph><paragraph role="heading" level="2">Sorting</paragraph><paragraph role="paragraph">Use this area to enter sorting criteria. If you enter additional sorting criteria under <emph>and then</emph>, the data matching the content of the higher-order criterion is ordered according to the next criterion.</paragraph><paragraph role="paragraph">If you sort the field name "First name" in ascending order and the field name "last name" in descending order, all records will be sorted in ascending order by first name, and then within the first names, in descending order by last name.</paragraph><paragraph role="heading" level="3">Field name</paragraph><paragraph role="paragraph"><ahelp hid=".uno:OrderCrit">Specifies the data field name whose content will determine the sort order.</ahelp></paragraph><paragraph role="heading" level="3">Order</paragraph><paragraph role="paragraph"><ahelp hid=".uno:OrderCrit">Specifies the sort order (either ascending or descending).</ahelp></paragraph><paragraph role="heading" level="3">and then</paragraph><paragraph role="paragraph">Specifies additional subordinate sort criteria from the other fields.</paragraph></body></helpdocument>
PK
%w�X�Hb� � text/shared/02/fontwork.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Fontwork</title><filename>/text/shared/02/fontwork.xhp</filename></topic></meta><body><section id="fontwork"><bookmark branch="hid/.uno:FontworkGalleryFloater" id="bm_id7113864"/><paragraph role="heading" level="1"><link href="text/shared/02/fontwork.xhp">Fontwork</link></paragraph><paragraph role="paragraph"><ahelp hid=".">Opens the Fontwork dialog from which you can insert styled text not possible through standard font formatting into your document.</ahelp></paragraph></section><section id="howtoget"><embed href="text/shared/00/00000404.xhp#syfontworkgallery"/></section><paragraph role="heading" level="2">Fontwork Gallery</paragraph><paragraph role="paragraph"><ahelp hid=".">The Fontwork Gallery displays previews of Fontwork objects. To insert an object into your document, select the object, and then click OK.</ahelp></paragraph><section id="relatedtopics"><paragraph role="paragraph"><embedvar href="text/shared/guide/fontwork.xhp#fontwork"/></paragraph><paragraph role="paragraph"><link href="text/shared/fontwork_toolbar.xhp">Fontwork toolbar</link></paragraph></section></body></helpdocument>
PK
%w�X�5�� � text/shared/02/querypropdlg.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Query Properties Dialog</title><filename>/text/shared/02/querypropdlg.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3154788"/><bookmark branch="hid/dbaccess/ui/querypropertiesdialog/QueryPropertiesDialog" id="bm_id3143280"/><paragraph role="heading" level="1">Query Properties Dialog</paragraph><paragraph role="paragraph">In the <emph>Query Properties</emph> dialog you can set two properties of the SQL Query, i.e. whether to return distinct values, and whether to limit the result set.</paragraph><section id="howtoget"><paragraph role="paragraph">In the Query Design View, choose <emph>Edit</emph> - <emph>Query Properties</emph>.
</paragraph></section><paragraph role="heading" level="2">Distinct Values</paragraph><bookmark branch="hid/dbaccess/ui/querypropertiesdialog/distinct" id="bm_id0305200912070090"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Use distinct values in query.</ahelp></paragraph><bookmark branch="hid/dbaccess/ui/querypropertiesdialog/nondistinct" id="bm_id0305200912074470"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Not use distinct values in query.</ahelp></paragraph><paragraph role="paragraph">Expands the created select statement of the SQL Query in the current column by the parameter DISTINCT. The consequence is that identical values occurring multiple times are listed only once.</paragraph><bookmark branch="hid/dbaccess/ui/querypropertiesdialog/limitbox" id="bm_id3155940"/><paragraph role="heading" level="2">Limit</paragraph><paragraph role="paragraph">Adds a Limit to set the maximum number of records to return.</paragraph></body></helpdocument>
PK
%w�X�)��
text/shared/02/02020000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Font Name</title><filename>/text/shared/02/02020000.xhp</filename></topic></meta><body><section id="schriftart"><bookmark branch="index" id="bm_id3148983"/><paragraph role="paragraph"/><bookmark branch="hid/.uno:CharFontName" id="bm_id4814517"/><bookmark branch="hid/.uno:CharFontName" id="bm_id3150789"/><paragraph role="heading" level="1"><link href="text/shared/02/02020000.xhp">Font Name</link></paragraph><paragraph role="paragraph"><variable id="schriftarttext"><ahelp hid=".uno:CharFontName">Allows you to select a font name from the list or enter a font name directly.</ahelp></variable></paragraph><paragraph role="paragraph">You can enter several fonts, separated by semicolons. $[officename] uses each named font in succession if the previous fonts are not available.</paragraph></section><paragraph role="paragraph">Any font changes apply to the selected text or word in which the cursor is positioned. If no text has been selected, the font applies to text typed afterwards.</paragraph><paragraph role="paragraph">The last five font names that have been selected are shown in the top part of the combo box.</paragraph><section id="syschriftart"><table><tablerow><tablecell><paragraph role="paragraph"><image src="res/helpimg/swh00055.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Font Name</paragraph></tablecell></tablerow></table></section><paragraph role="note">In $[officename] you see the available fonts only if a printer is installed as the default printer in your system. <switchinline select="sys"><caseinline select="UNIX">With the <link href="text/shared/guide/spadmin.xhp">spadmin</link> program you can define a printer as the default printer. </caseinline><defaultinline>In order to install a printer as the default printer please refer to your operating system documentation.</defaultinline></switchinline></paragraph><paragraph role="paragraph"><variable id="vorschautext">You can see the name of the fonts formatted in their respective font if you mark the <emph>Preview in fonts lists</emph> field in <link href="text/shared/optionen/01010800.xhp">$[officename] - View</link> in the Options dialog box.</variable></paragraph><switch select="sys"><case select="WIN"><paragraph role="warning">If you receive an error message that states that certain fonts have not been found, you can install them with <emph>$[officename] Setup</emph> in the <emph>Repair</emph> mode if it is a $[officename] font.</paragraph></case></switch></body></helpdocument>
PK
%w�Xd��0d d text/shared/02/12070300.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Text</title><filename>/text/shared/02/12070300.xhp</filename></topic></meta><body><bookmark branch="hid/modules/swriter/ui/insertdbcolumnsdialog/astext" id="bm_id3146938"/><paragraph role="heading" level="1">Text</paragraph><bookmark branch="index" id="bm_id3143284"/><paragraph role="paragraph"><ahelp hid="modules/swriter/ui/insertdbcolumnsdialog/astext" visibility="hidden">Inserts data selected from the data source browser into the document as text.</ahelp> If you select the <emph>Text</emph> option in the <emph>Insert Database Columns</emph> dialog, the content of the data selected in the data source browser is inserted into the document as text. In the dialog, you can decide which database fields or columns are transferred, and how the text is formatted.</paragraph><paragraph role="paragraph">If several records are selected when you choose the <emph>Data to Text</emph> function, the mail merge fields will be inserted according to the number of records.</paragraph><paragraph role="heading" level="2">Text</paragraph><paragraph role="paragraph">In the <emph>Text</emph> area, use the arrow button to select the database table columns into which you want to insert field contents.</paragraph><embed href="text/shared/02/12070200.xhp#ankerfuertextoption"/></body></helpdocument>
PK
%w�X���K� � text/shared/02/24090000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Transparency</title><filename>/text/shared/02/24090000.xhp</filename></topic></meta><body><section id="transparenz"><bookmark branch="hid/.uno:GrafTransparence" id="bm_id196900"/><bookmark branch="hid/.uno:GrafTransparence" id="bm_id3143284"/><paragraph role="heading" level="1"><link href="text/shared/02/24090000.xhp">Transparency</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:GrafTransparence">Specifies the transparency in the graphic object.</ahelp> Values from 0% (fully opaque) to +100% (fully transparent) are possible.</paragraph></section><section id="sytransparenz"><table><tablerow><tablecell><paragraph role="paragraph"><image src="res/sc10869.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Transparency</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�XsR��� � text/shared/02/02130000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Decrease Indent</title><filename>/text/shared/02/02130000.xhp</filename></topic></meta><body><section id="einzvermindern"><bookmark branch="hid/.uno:DecrementIndent" id="bm_id8935294"/><bookmark branch="hid/.uno:DecrementIndent" id="bm_id3153089"/><paragraph role="heading" level="1"><link href="text/shared/02/02130000.xhp">Decrease Indent</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DecrementIndent">Click the <emph>Decrease Indent</emph> icon to reduce the left indent of the current paragraph or cell content and set it to the previous default tab position.</ahelp></paragraph></section><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER">If you previously increased the indentation for several collectively selected paragraphs, this command can decrease the indentation for all of the selected paragraphs.
</caseinline><caseinline select="CALC">The cell content refers to the current value under <link href="text/shared/01/05340300.xhp"><emph>Format - Cell - Alignment</emph></link>.
</caseinline></switchinline></paragraph><section id="syeinzvermindern"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_decrementindent.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Decrease Indent</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER">If you click the <emph>Decrease Indent</emph> icon while holding down the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key, the indent for the selected paragraph is moved by the default tab stop that has been set under <link href="text/shared/optionen/01040200.xhp"><emph>%PRODUCTNAME Writer - General</emph></link> in the Options dialog box.</caseinline></switchinline></paragraph></body></helpdocument>
PK
%w�XX��� � text/shared/02/01170102.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Data</title><filename>/text/shared/02/01170102.xhp</filename></topic></meta><body><section id="daten"><bookmark branch="index" id="bm_id3145641"/><paragraph role="heading" level="1"><link href="text/shared/02/01170102.xhp">Data</link></paragraph><paragraph role="paragraph">The<emph> Data </emph>tab page allows you to assign a data source to the selected control.</paragraph></section><section id="howtoget"><embed href="text/shared/00/00040501.xhp#controleigenschaftendaten"/></section><paragraph role="note">For forms with database links, the associated database is defined in the <link href="text/shared/02/01170200.xhp">Form Properties</link>. You will find the functions for this on the <link href="text/shared/02/01170203.xhp"><emph>Data</emph></link> tab page.</paragraph><paragraph role="paragraph">The possible settings of the <emph>Data</emph> tab page of a control depend on the respective control. You will only see the options that are available for the current control and context. The following fields are available:</paragraph><sort order="asc"><section id="Section10"><bookmark branch="hid/EXTENSIONS_HID_PROP_UNCHECKEDREFVALUE" id="bm_id7939695"/><paragraph role="heading" level="2">Reference value (off)</paragraph><paragraph role="paragraph"><ahelp hid=".">Check boxes and radio buttons in spreadsheets can be bound to cells in the current document. If the control is enabled, the value you enter in Reference value (on) is copied to the cell. If the control is disabled, the value from Reference value (off) is copied to the cell.</ahelp></paragraph></section><section id="Section23"><bookmark branch="hid/EXTENSIONS_HID_PROP_REFVALUE" id="bm_id3147327"/><paragraph role="heading" level="2">Reference value (on)</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_REFVALUE" visibility="hidden">You can enter a reference value for the web form, which will be remitted to a server when sending the form. With database forms, the value entered is written in the database field, assigned to the control field.</ahelp> You can assign a reference value to option buttons and check boxes. The reference value will be remitted to a server when sending the web form. With database forms the value entered here will be written in the database assigned to the control field.</paragraph><paragraph role="paragraph"><emph>Reference values for web forms</emph></paragraph><paragraph role="paragraph">Reference values are useful if you design a web form and the information on the status of the control is to be transmitted to a server. If the control is clicked by the user, the corresponding reference value is sent to the server.</paragraph><paragraph role="paragraph">For example, if you have two control fields for the options "feminine" and "masculine", and assign a reference value of 1 to the field "feminine" and the value 2 to the "masculine" field, the value 1 is transmitted to the server if a user clicks the "feminine" field and value 2 is sent if the "masculine" field is clicked.</paragraph><paragraph role="paragraph"><emph>Reference values for database forms</emph></paragraph><paragraph role="paragraph">For database forms, you can also characterize the status of an option or a check box by a reference value, storing it in the database. If you have a set of three options, for example "in progress", "completed", and "resubmission", with the respective reference values, "ToDo", "OK", and "RS", these reference values appear in the database if the respective option is clicked.</paragraph></section><section id="Section1"><bookmark branch="hid/EXTENSIONS_HID_PROP_CONTROLSOURCE" id="bm_id3157976"/><paragraph role="heading" level="2">Data field</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_CONTROLSOURCE" visibility="hidden">Specifies the field of the data source table to which the control refers.</ahelp> With database forms, you can link controls with the data fields.</paragraph><paragraph role="paragraph">You have several possibilities:</paragraph><list type="ordered"><listitem><paragraph role="listitem">First case: There is only one table in the form.</paragraph><paragraph role="listitem">Under <emph>Data field</emph>, specify the field of the data source table whose contents you want to be displayed.</paragraph></listitem><listitem><paragraph role="listitem">Second case: The control belongs to a subform that is created by an SQL query.</paragraph><paragraph role="listitem">Under <emph>Data field</emph>, specify the field of the SQL statement whose contents you want to be displayed.</paragraph></listitem></list><list type="ordered"><listitem><paragraph role="listitem">Third case: <link href="text/shared/02/01170900.xhp">Combo Boxes</link></paragraph><paragraph role="listitem">For combo boxes, the field of the data source table in which the values entered or selected by the user should be stored is specified under <emph>Data field</emph>. The values displayed in the list of the combo box are based on an SQL statement, which is entered under <emph>List content</emph>.</paragraph></listitem><listitem><paragraph role="listitem">Fourth case: <link href="text/shared/02/01170900.xhp">List Boxes</link></paragraph><paragraph role="listitem">The data source table does not contain the data to be displayed, but rather a table linked to the data source table through a common data field.</paragraph><paragraph role="listitem">If you want a list box to display data from a table that is linked to the current data source table, under <emph>Data field</emph> specify the field of the data source table to which the content of the list box refers. Or you can specify the database field that controls the display of the data in the form. This data field provides the link to the other table if both tables can be linked through a common data field. It is usually a data field in which unique identification numbers are stored. The data field whose contents are displayed in the form is specified by an SQL statement under <emph>List content</emph>.</paragraph></listitem></list><paragraph role="paragraph">List boxes work with references. They can either be implemented with linked tables by SQL statements (fourth case) or through value lists:</paragraph><paragraph role="paragraph"><emph>References through linked tables (SQL statements)</emph></paragraph><paragraph role="paragraph">If you want a list box to display data from a database table that is linked by a common data field to the table on which the form is based, the link field of the form table is specified under <emph>Data field</emph>.</paragraph><paragraph role="paragraph">The link is created with an SQL Select, which, if you selected "SQL" or "Native SQL", is specified under <emph>Type of list contents</emph> in the field <emph>List content</emph>. As an example, a table "Orders" is linked to the current form control, and in the database a table "Customers" is linked to the "Orders" table. You can use an SQL statement as follows:</paragraph><paragraph role="paragraph">SELECT CustomerName, CustomerNo FROM Customers,</paragraph><paragraph role="paragraph">where "CustomerName" is the data field from the linked table "Customers", and "CustomerNo" is the field of the table "Customers" that is linked to a field of the form table "Orders" specified under <emph>Data field</emph>.</paragraph><paragraph role="paragraph"><emph>References Using Value Lists</emph></paragraph><paragraph role="paragraph">For list boxes, you can use value lists. Value lists are lists that define reference values. In this way, the control in the form does not directly display the content of a database field, but rather values assigned in the value list.</paragraph><paragraph role="paragraph">If you work with reference values of a value list, the contents of the data field that you specified under <emph>Data Field</emph> in the form are not visible, but rather the assigned values. If you chose "Valuelist" on the <emph>Data</emph> tab under <emph>Type of list contents</emph> and assigned a reference value to the visible list entries in the form under <emph>List entries</emph> (entered in the <link href="text/shared/02/01170101.xhp"><emph>General</emph></link> tab), then the reference values are compared with the data content of the given data field. If a reference value corresponds to the content of a data field, the associated list entries are displayed in the form.</paragraph></section><section id="Section2"><bookmark branch="hid/EXTENSIONS_HID_PROP_BOUNDCOLUMN" id="bm_id3150297"/><paragraph role="heading" level="2">Bound field</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_BOUNDCOLUMN" visibility="hidden">Use an index to specify the table field or table SQL query to link to the field that is provided under <emph>Data field</emph>. Valid values for this property are 1, 2, 3, and so on.</ahelp></paragraph><paragraph role="note">If you delete the contents of the <emph>Bound field</emph> cell in the property browser, the first field of the result set is used to display and to exchange data.</paragraph><paragraph role="paragraph">This property for list boxes defines which data field of a linked table is displayed in the form.</paragraph><paragraph role="paragraph">If a list box in the form is to display contents of a table linked to the form table, then define in the <emph>Type of list contents</emph> field if the display is determined by an SQL command or the (linked) table is accessed. With the <emph>Bound field</emph> property, you use an index to specify to which data field of the query or of the table the list field is linked. </paragraph><paragraph role="note">The property <emph>Bound field</emph> is only for forms that are used to access more than one table. If the form is based on only one table, the field to be displayed in the form is specified directly under <emph>Data field</emph>. However, if you want the list box to display data from a table that is linked to the current table over a common data field, the linked data field is defined by the property <emph>Bound field</emph>.</paragraph><paragraph role="paragraph">If you selected "SQL" under <emph>Type of list contents</emph>, the SQL command determines the index to be specified. Example: If you specify an SQL command such as "SELECT Field1, Field2 FROM tablename" under <emph>List content</emph>, refer to the following table:</paragraph><table><tablerow><tablecell><paragraph role="tablehead">Bound field</paragraph></tablecell><tablecell><paragraph role="tablehead">Link</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="code">-1</paragraph></tablecell><tablecell><paragraph role="tablecontent">The index of the selected entry in the list is linked to the field specified under <emph>Data field</emph>.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="code">{empty} or 0</paragraph></tablecell><tablecell><paragraph role="tablecontent">The database field "Field1" is linked to the field specified under <emph>Data field</emph>.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="code">1</paragraph></tablecell><tablecell><paragraph role="tablecontent">The database field "Field2" is linked to the field specified under <emph>Data field</emph>.</paragraph></tablecell></tablerow></table><paragraph role="paragraph">If you selected "Table" under <emph>Type of list contents</emph>, the table structure defines the index to be specified. Example: If a database table is selected under <emph>List content</emph>, refer to the following table:</paragraph><table><tablerow><tablecell><paragraph role="tablehead">Bound field</paragraph></tablecell><tablecell><paragraph role="tablehead">Link</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="code">-1</paragraph></tablecell><tablecell><paragraph role="tablecontent">The index of the selected entry in the list is linked to the field specified under <emph>Data field</emph>.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="code">{empty} or 0</paragraph></tablecell><tablecell><paragraph role="tablecontent">The 1st column of the table is linked to the field specified under <emph>Data field</emph>.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="code">1</paragraph></tablecell><tablecell><paragraph role="tablecontent">The 2nd column of the table is linked to the field specified under <emph>Data field</emph>.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="code">2</paragraph></tablecell><tablecell><paragraph role="tablecontent">The 3rd column of the table is linked to the field specified under <emph>Data field</emph>.</paragraph></tablecell></tablerow></table></section><section id="Section3"><bookmark branch="hid/EXTENSIONS_HID_PROP_LISTSOURCETYPE" id="bm_id3153316"/><paragraph role="heading" level="2">Type of list contents</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_LISTSOURCETYPE" visibility="hidden">Determines the data to fill the lists in list and combo boxes.</ahelp> Determines the data to fill the lists in list and combo boxes.</paragraph><paragraph role="paragraph">With the "Valuelist" option, all entries entered in the <emph>List entries</emph> field of the <link href="text/shared/02/01170101.xhp"><emph>General</emph></link> tab appear in the control. For database forms, you can use reference values (see the <link href="text/shared/02/01170102.xhp"><emph>References Using Value Lists</emph></link> section).</paragraph><paragraph role="paragraph">If the content of the control is read from a database, you can determine the type of the data source with the other options. For example, you can choose between tables and queries.</paragraph></section><section id="Section4"><bookmark branch="hid/EXTENSIONS_HID_PROP_LISTSOURCE" id="bm_id3148839"/><paragraph role="heading" level="2">List content</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_LISTSOURCE">With database forms, specifies the data source for the list content of the form-element. This field can be used to define a value list for documents without a database connection.</ahelp></paragraph><paragraph role="paragraph">In the case of database forms, the data source determines the entries of the list or combo box. Depending on the selected type, you have a choice between different data sources under <emph>List content</emph>, provided that these objects exist in your database. All available database objects of the type selected under <emph>Type of list contents</emph> are offered here. If you have selected the "Value List" option as the type, you can use references for database forms. If the display of the control is controlled by an SQL command, the SQL statement is entered here.</paragraph><paragraph role="paragraph">Examples of SQL statements:</paragraph><paragraph role="paragraph">For list boxes, an SQL statement may have the following form:</paragraph><paragraph role="code">SELECT field1, field2 FROM table,</paragraph><paragraph role="paragraph">Here "table" is the table whose data is displayed in the list of the control (list table). "field1" is the data field that defines the visible entries in the form; its content is displayed in the list box. "field2" is the field of the list table that is linked to the form table (value table) through the field specified under <emph>Data field</emph> if <emph>Bound field</emph> = 1 was selected.</paragraph><paragraph role="paragraph">For combo boxes, an SQL statement may take the following form:</paragraph><paragraph role="code">SELECT DISTINCT field FROM table,</paragraph><paragraph role="paragraph">Here "field" is a data field from the list table "table" whose content is displayed in the list of the combo box.</paragraph><paragraph role="paragraph"><emph>Value lists for HTML documents</emph></paragraph><paragraph role="paragraph">For HTML forms, you can enter a value list under <emph>List content</emph>. Select the option "Valuelist" under <emph>Type of list contents</emph>. The values entered here will not be visible in the form, and are used to assign values to the visible entries. The entries made under <emph>List content</emph> correspond to the HTML tag <OPTION VALUE=...>.</paragraph><paragraph role="paragraph">In the data transfer of a selected entry from a list box or a combo box, both the list of the values displayed in the form, which was entered on the <link href="text/shared/02/01170101.xhp"><emph>General</emph></link> tab under <emph>List entries</emph>, and the value list entered on the <emph>Data</emph> tab under <emph>List content</emph>, are taken into consideration: If a (non-empty) text is at the selected position in the value list (<OPTION VALUE=...>), it will be transmitted. Otherwise, the text displayed in the (<OPTION>) control is sent.</paragraph><paragraph role="paragraph">If the value list is to contain an empty string, enter the value "$$$empty$$$" under <emph>List content</emph> at the corresponding position (note uppercase/lowercase). $[officename] interprets this input as an empty string and assigns it to the respective list entry.</paragraph><paragraph role="paragraph">The following table shows the connections between HTML, JavaScript, and the $[officename] field <emph>List content</emph> using an example list box named "ListBox1". In this case, "Item" designates a list entry visible in the form:</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><emph>HTML Tag</emph></paragraph></tablecell><tablecell><paragraph role="paragraph"><emph>JavaScript</emph></paragraph></tablecell><tablecell><paragraph role="paragraph"><emph>Entry in value list of the control (List content)</emph></paragraph></tablecell><tablecell><paragraph role="paragraph"><emph>Transmitted data</emph></paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="code"><OPTION>Item</paragraph></tablecell><tablecell><paragraph role="paragraph">Not possible</paragraph></tablecell><tablecell><paragraph role="paragraph">""</paragraph></tablecell><tablecell><paragraph role="paragraph">the visible list entry ("ListBox1=Item")</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="code"><OPTION VALUE="Value">Item</paragraph></tablecell><tablecell><paragraph role="code">ListBox1.options[0].value="Value"</paragraph></tablecell><tablecell><paragraph role="code">"Value"</paragraph></tablecell><tablecell><paragraph role="paragraph">The value assigned to the list entry ("ListBox1=Value")</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="code"><OPTION VALUE="">Item</paragraph></tablecell><tablecell><paragraph role="code">ListBox1.options[0].value=""</paragraph></tablecell><tablecell><paragraph role="code">"$$$empty$$$"</paragraph></tablecell><tablecell><paragraph role="paragraph">An empty string ("ListBox1=")</paragraph></tablecell></tablerow></table></section><section id="Section5"><bookmark branch="hid/EXTENSIONS_HID_PROP_EMPTY_IS_NULL" id="bm_id3150628"/><paragraph role="heading" level="2">Empty string is NULL</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_EMPTY_IS_NULL">Defines how an empty string input should be handled. If set to Yes, an input string of length zero will be treated as a value NULL. If set to No, any input will be treated as-is without any conversion.</ahelp></paragraph><paragraph role="paragraph">An empty string is a string of length zero (""). Normally, a value NULL is not the same as an empty string. In general, a term NULL is used to denote an undefined value, an unknown value, or "no value has been entered yet."</paragraph><paragraph role="paragraph">Database systems vary and they might handle a value NULL differently. Refer to documentations of the database that you are using.</paragraph></section><section id="Section6"><bookmark branch="hid/EXTENSIONS_HID_PROP_FILTERPROPOSAL" id="bm_id3149393"/><paragraph role="heading" level="2">Filter proposal</paragraph><paragraph role="paragraph"><variable id="filtervorschlag"><ahelp hid="HID_PROP_FILTERPROPOSAL">While designing your form, you can set the "Filter proposal" property for each text box in the <emph>Data</emph> tab of the corresponding <emph>Properties</emph> dialog. In subsequent searches in the filter mode, you can select from all information contained in these fields.</ahelp> The field content can then be selected using the AutoComplete function. Note, however, that this function requires a greater amount of memory space and time, especially when used in large databases and should therefore be used sparingly.
</variable></paragraph></section><section id="Section9"><bookmark branch="hid/EXTENSIONS_HID_PROP_BOUND_CELL" id="bm_id4214300"/><paragraph role="heading" level="2">Linked cell</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_BOUND_CELL">Specifies the reference to a linked cell on a spreadsheet. The live state or contents of the control are linked to the cell contents.</ahelp> The following tables list the controls and their corresponding link type:</paragraph><paragraph role="heading" level="3">Check box with linked cell</paragraph><table><tablerow><tablecell><paragraph role="tablehead">Action</paragraph></tablecell><tablecell><paragraph role="tablehead">Result</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Select the check box</paragraph></tablecell><tablecell><paragraph role="tablecontent">TRUE is entered into the linked cell</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Deselect the check box</paragraph></tablecell><tablecell><paragraph role="tablecontent">FALSE is entered into the linked cell</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Tri-state check box is set to "undetermined" state</paragraph></tablecell><tablecell><paragraph role="tablecontent">#NV is entered into the linked cell</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Enter a number or a formula that returns a number in the linked cell</paragraph></tablecell><tablecell><paragraph role="tablecontent">If entered value is TRUE or not 0: Check box is selected<br/>If entered value is FALSE or 0: Check box is deselected</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Clear the linked cell, or enter text, or enter a formula that returns text or an error</paragraph></tablecell><tablecell><paragraph role="tablecontent">Check box is set to "undetermined" state if it is a tri-state check box, else check box is deselected.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Select the box. The Reference value box contains text.</paragraph></tablecell><tablecell><paragraph role="tablecontent">The text from the Reference value box is copied to the cell.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Deselect the box. The Reference value box contains text.</paragraph></tablecell><tablecell><paragraph role="tablecontent">An empty string is copied to the cell.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">The Reference value box contains text. Enter the same text into the cell.</paragraph></tablecell><tablecell><paragraph role="tablecontent">The check box is selected.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">The Reference value box contains text. Enter another text into the cell.</paragraph></tablecell><tablecell><paragraph role="tablecontent">The check box is deselected.</paragraph></tablecell></tablerow></table><paragraph role="heading" level="3">Option button (radio button) with linked cell</paragraph><table><tablerow><tablecell><paragraph role="tablehead">Action</paragraph></tablecell><tablecell><paragraph role="tablehead">Result</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Select the option button</paragraph></tablecell><tablecell><paragraph role="tablecontent">TRUE is entered into the linked cell</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Option button is deselected by selecting another option button</paragraph></tablecell><tablecell><paragraph role="tablecontent">FALSE is entered into the linked cell</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Enter a number or a formula that returns a number in the linked cell</paragraph></tablecell><tablecell><paragraph role="tablecontent">If entered value is TRUE or not 0: Option button is selected<br/>If entered value is FALSE or 0: Option button is deselected</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Clear the linked cell, or enter text, or enter a formula that returns text or an error</paragraph></tablecell><tablecell><paragraph role="tablecontent">Option button is deselected</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Click the option button. The Reference value box contains text.</paragraph></tablecell><tablecell><paragraph role="tablecontent">The text from the Reference value box is copied to the cell.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Click another option button of the same group. The Reference value box contains text.</paragraph></tablecell><tablecell><paragraph role="tablecontent">An empty string is copied to the cell.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">The Reference value box contains text. Enter the same text into the cell.</paragraph></tablecell><tablecell><paragraph role="tablecontent">The option button is selected.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">The Reference value box contains text. Enter another text into the cell.</paragraph></tablecell><tablecell><paragraph role="tablecontent">The option button is cleared.</paragraph></tablecell></tablerow></table><paragraph role="heading" level="3">Text box with linked cell</paragraph><table><tablerow><tablecell><paragraph role="tablehead">Action</paragraph></tablecell><tablecell><paragraph role="tablehead">Result</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Enter text into the text box</paragraph></tablecell><tablecell><paragraph role="tablecontent">Text is copied into the linked cell</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Clear the text box</paragraph></tablecell><tablecell><paragraph role="tablecontent">Linked cell is cleared</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Enter text or a number in the linked cell</paragraph></tablecell><tablecell><paragraph role="tablecontent">Text or number is copied into the text box</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Enter a formula into the linked cell</paragraph></tablecell><tablecell><paragraph role="tablecontent">Formula result is copied into the text box</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Clear the linked cell</paragraph></tablecell><tablecell><paragraph role="tablecontent">Text box is cleared</paragraph></tablecell></tablerow></table><paragraph role="heading" level="3">Numerical field and formatted field with linked cell</paragraph><table><tablerow><tablecell><paragraph role="tablehead">Action</paragraph></tablecell><tablecell><paragraph role="tablehead">Result</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Enter a number into the field</paragraph></tablecell><tablecell><paragraph role="tablecontent">Number is copied into the linked cell</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Clear the field</paragraph></tablecell><tablecell><paragraph role="tablecontent">Value 0 is set in the linked cell</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Enter a number or a formula that returns a number in the linked cell</paragraph></tablecell><tablecell><paragraph role="tablecontent">Number is copied into the field</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Clear the linked cell, or enter text, or enter a formula that returns text or an error</paragraph></tablecell><tablecell><paragraph role="tablecontent">Value 0 is set in the field</paragraph></tablecell></tablerow></table><paragraph role="heading" level="3">List box with linked cell</paragraph><paragraph role="paragraph">List boxes support two different linking modes, see the property "Contents of the linked cell".</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Linked contents: Synchronize the text contents of the selected list box entry with the cell contents.</paragraph></listitem><listitem><paragraph role="paragraph">Linked selection position: The position of the single selected item in the list box is synchronized with the numerical value in the cell.</paragraph></listitem></list><table><tablerow><tablecell><paragraph role="tablehead">Action</paragraph></tablecell><tablecell><paragraph role="tablehead">Result</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Select a single list item</paragraph></tablecell><tablecell><paragraph role="tablecontent">Contents are linked: Text of the item is copied into the linked cell.</paragraph><paragraph role="tablecontent">Selection is linked: Position of the selected item is copied into the linked cell. For example, if the third item is selected, the number 3 will be copied.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Select several list items</paragraph></tablecell><tablecell><paragraph role="tablecontent">#NV is entered into the linked cell</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Deselect all list items</paragraph></tablecell><tablecell><paragraph role="tablecontent">Contents are linked: Linked cell is cleared</paragraph><paragraph role="tablecontent">Selection is linked: Value 0 is entered in the linked cell</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Enter text or a number into the linked cell</paragraph></tablecell><tablecell><paragraph role="tablecontent">Contents are linked: Find and select an equal list item</paragraph><paragraph role="tablecontent">Selection is linked: The list item at the specified position (starting with 1 for the first item) is selected. If not found, all items are deselected.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Enter a formula into the linked cell</paragraph></tablecell><tablecell><paragraph role="tablecontent">Find and select a list item that matches the formula result and link mode</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Clear the linked cell</paragraph></tablecell><tablecell><paragraph role="tablecontent">Deselect all items in the list box</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Change the contents of the list source range</paragraph></tablecell><tablecell><paragraph role="tablecontent">List box items are updated according to the change. The selection is preserved. This may cause an update to the linked cell.</paragraph></tablecell></tablerow></table><paragraph role="heading" level="3">Combo box with linked cell</paragraph><table><tablerow><tablecell><paragraph role="tablehead">Action</paragraph></tablecell><tablecell><paragraph role="tablehead">Result</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Enter text into the edit field of the combo box, or select an entry from the drop-down list</paragraph></tablecell><tablecell><paragraph role="tablecontent">Text is copied into the linked cell</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Clear the edit field of the combo box</paragraph></tablecell><tablecell><paragraph role="tablecontent">Linked cell is cleared</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Enter text or a number into the linked cell</paragraph></tablecell><tablecell><paragraph role="tablecontent">Text or number is copied into the edit field of the combo box</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Enter a formula into the linked cell</paragraph></tablecell><tablecell><paragraph role="tablecontent">Formula result is copied into the edit field of the combo box</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Clear the linked cell</paragraph></tablecell><tablecell><paragraph role="tablecontent">Edit field of the combo box is cleared</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Change the contents of the list source range</paragraph></tablecell><tablecell><paragraph role="tablecontent">Drop-down list items are updated according to the change. The edit field of the combo box and the linked cell are not changed.</paragraph></tablecell></tablerow></table></section><section id="Section8"><bookmark branch="hid/EXTENSIONS_HID_PROP_CELL_EXCHANGE_TYPE" id="bm_id5563219"/><paragraph role="heading" level="2">Contents of the linked cell</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_CELL_EXCHANGE_TYPE">Select the mode of linking a list box with a linked cell on a spreadsheet.</ahelp></paragraph><list type="ordered"><listitem><paragraph role="paragraph">Linked contents: Synchronize the text contents of the selected list box entry with the cell contents. Select "The selected entry"</paragraph></listitem><listitem><paragraph role="paragraph">Linked selection position: The position of the single selected item in the list box is synchronized with the numerical value in the cell. Select "Position of the selected entry"</paragraph></listitem></list></section><section id="Section7"><bookmark branch="hid/EXTENSIONS_HID_PROP_LIST_CELL_RANGE" id="bm_id9886165"/><paragraph role="heading" level="2">Source cell range</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_LIST_CELL_RANGE">Enter a cell range that contains the entries for a list box or combo box on a spreadsheet.</ahelp> If you enter a multi-column range, only the contents of the leftmost column are used to fill the control.</paragraph></section></sort></body></helpdocument>
PK
%w�X1�> text/shared/02/05090000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Rotate</title><filename>/text/shared/02/05090000.xhp</filename></topic></meta><body><section id="drehen"><bookmark branch="hid/.uno:ToggleObjectRotateMode" id="bm_id1686319"/><bookmark branch="hid/.uno:ToggleObjectRotateMode" id="bm_id3148520"/><paragraph role="heading" level="1"><link href="text/shared/02/05090000.xhp">Rotate</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:ToggleObjectRotateMode">Rotates the selected object.</ahelp></paragraph></section><paragraph role="paragraph"><switchinline select="appl"><caseinline select="IMPRESS">Select an object and click the<emph> Rotate</emph> icon on the<emph> Drawing</emph> toolbar.
</caseinline><caseinline select="DRAW">Select an object and click the Rotate icon on the Drawing toolbar.
</caseinline><defaultinline>Select an object and click the<emph> Rotate</emph> icon on the <emph>Drawing Object Properties</emph> toolbar.</defaultinline></switchinline> Drag a corner handle of the object in the direction you want to rotate it.</paragraph><section id="sydrehen"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_toggleobjectrotatemode.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Rotate</paragraph></tablecell></tablerow></table></section><section id="relatedtopics"><paragraph role="paragraph"><link href="text/shared/01/05230300.xhp"><emph>Format - Position and Size - Rotate</emph></link>. </paragraph></section></body></helpdocument>
PK
%w�X�5o�� � text/shared/02/02040000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Text running from left to right</title><filename>/text/shared/02/02040000.xhp</filename></topic></meta><body><section id="textlire"><bookmark branch="hid/.uno:TextdirectionLeftToRight" id="bm_id4510932"/><bookmark branch="hid/.uno:TextdirectionLeftToRight" id="bm_id3148520"/><paragraph role="heading" level="1"><link href="text/shared/02/02040000.xhp">Text running from left to right</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:TextdirectionLeftToRigh" visibility="visible">Specifies the horizontal direction of the text.</ahelp></paragraph></section><section id="sytextlire"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_textdirectionlefttoright.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Text direction from left to right</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X��y�� � text/shared/02/01170801.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Table Element / List Box / Combo Box Wizard: Data</title><filename>/text/shared/02/01170801.xhp</filename></topic></meta><body><section id="seite1"><bookmark branch="hid/modules/sabpilot/ui/tableselectionpage/TableSelectionPage" id="bm_id3150808"/><paragraph role="heading" level="1"><link href="text/shared/02/01170801.xhp">Table Element / List Box / Combo Box Wizard: Data</link></paragraph><paragraph role="paragraph">Select the data source and table to which the form field corresponds. If you insert the form field in a document that is already linked to a data source, this page becomes invisible.</paragraph></section><section id="howtoget"><embed href="text/shared/00/00040501.xhp#aupitab1"/></section><paragraph role="heading" level="2">Data source</paragraph><paragraph role="paragraph"><ahelp hid="modules/sabpilot/ui/tableselectionpage/datasource">Specifies the data source that contains the desired table.</ahelp></paragraph><paragraph role="heading" level="2">Table</paragraph><paragraph role="paragraph"><ahelp hid="modules/sabpilot/ui/tableselectionpage/table">Specifies the desired table.</ahelp></paragraph></body></helpdocument>
PK
%w�X=Ad� text/shared/02/02160000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Highlight Color</title><filename>/text/shared/02/02160000.xhp</filename></topic></meta><body><section id="zeichenhintergrund"><bookmark branch="hid/.uno:BackColor" id="bm_id2500913"/><bookmark branch="hid/.uno:BackColor" id="bm_id3153323"/><paragraph role="heading" level="1"><link href="text/shared/02/02160000.xhp">Highlight Color</link></paragraph><paragraph role="paragraph"><variable id="zeichenhintergrundtext"><ahelp hid=".uno:BackColor">Applies the current highlight color to the background of a text selection. If no text is selected, click the <emph>Highlight Color</emph> icon, select the text that you want to highlight, and then click the <emph>Highlight Color</emph> icon again. To change the highlight color, click the arrow next to the <emph>Highlight Color</emph> icon, and then click the color that you want.</ahelp></variable></paragraph></section><section id="syzeichenhintergrund"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_backcolor.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Highlight Color</paragraph></tablecell></tablerow></table></section><paragraph role="heading" level="2">To Apply Highlighting</paragraph><list type="ordered"><listitem><paragraph role="paragraph">On the <emph>Formatting</emph> bar, click the <emph>Highlight Color</emph> icon.</paragraph><paragraph role="note">To change the highlighting color, click the arrow next to the <emph>Highlight Color</emph> icon, and then click the color that you want.</paragraph></listitem><listitem><paragraph role="paragraph">Select the text that you want to highlight.</paragraph><paragraph role="tip">To apply highlighting to a single word, double-click the word.</paragraph></listitem><listitem><paragraph role="paragraph">To turn off highlighting, press Esc.</paragraph></listitem></list><paragraph role="heading" level="2">To Remove Highlighting</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Select the highlighted text.</paragraph></listitem><listitem><paragraph role="paragraph">On the <emph>Formatting</emph> bar, click the arrow next to the <emph>Highlight Color</emph> icon, and then click <emph>No Fill</emph>.</paragraph></listitem></list></body></helpdocument>
PK
%w�X��Ui i text/shared/02/14030000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Run SQL command directly</title><filename>/text/shared/02/14030000.xhp</filename></topic></meta><body><section id="native"><paragraph role="paragraph"/><bookmark branch="hid/.uno:SbaNativeSql" id="bm_id9820973"/><bookmark branch="hid/.uno:SbaNativeSql" id="bm_id3143284"/><paragraph role="heading" level="1"><link href="text/shared/02/14030000.xhp">Run SQL command directly</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:SbaNativeSql">In Native SQL mode you can enter SQL commands that are not interpreted by $[officename], but are instead passed directly to the data source.</ahelp> If you do not display these changes in the design view, you cannot change back to the design view.</paragraph></section><paragraph role="paragraph">For native SQL, the SQL string is forwarded directly to the connected database system without a previous evaluation by $[officename]. For example, if you access a database through an ODBC interface, the SQL string is passed to the ODBC driver and processed by it.</paragraph><section id="synative"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_sbanativesql.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Run SQL command directly</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph">Click the icon again to return to normal mode, in which the changes in the <link href="text/shared/explorer/database/02010100.xhp">New Query Design</link> are synchronized with the permitted changes through SQL.</paragraph></body></helpdocument>
PK
%w�Xɺ��; ; text/shared/02/10010000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Previous Page</title><filename>/text/shared/02/10010000.xhp</filename></topic></meta><body><section id="vorigeseite"><bookmark branch="hid/.uno:PageUp" id="bm_id9937792"/><bookmark branch="hid/.uno:PageUp" id="bm_id3154682"/><bookmark branch="hid/.uno:PreviousPage" id="bm_id4244582"/><bookmark branch="hid/.uno:PreviousPage" id="bm_id3143284"/><paragraph role="heading" level="1"><link href="text/shared/02/10010000.xhp">Previous Page</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:PreviousPage" visibility="visible">Moves back to the previous page in the document.</ahelp> This function is only active when you select the <emph>Print Preview</emph> function on the <emph>File</emph> menu.</paragraph></section><section id="syvorigeseite"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_pageup.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Previous Page</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�Xl0�, text/shared/02/03200000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Change Anchor</title><filename>/text/shared/02/03200000.xhp</filename></topic></meta><body><section id="verankerung"><bookmark branch="index" id="bm_id3153323"/><bookmark branch="hid/.uno:ToggleAnchorType" id="bm_id571270"/><bookmark branch="hid/.uno:ToggleAnchorType" id="bm_id3147399"/><paragraph role="heading" level="1"><link href="text/shared/02/03200000.xhp">Change Anchor</link></paragraph></section><paragraph role="paragraph"><variable id="verankerungtext"><ahelp hid=".uno:ToggleAnchorType">Allows you to switch between anchoring options.</ahelp></variable> The<emph> Change Anchor </emph>icon is only visible when an object such as a graphic or control field<switchinline select="appl"><caseinline select="WRITER"> or frame
</caseinline></switchinline> is selected. </paragraph><paragraph role="paragraph">Further information about the anchoring is contained in the <link href="text/shared/01/05260000.xhp"><emph>Anchoring</emph></link> Help section.</paragraph><switch select="appl"><case select="WRITER"><embed href="text/shared/00/00040501.xhp#syverankerung"/></case></switch><switch select="appl"><case select="CALC"><embed href="text/shared/00/00040501.xhp#ankcalc"/></case></switch></body></helpdocument>
PK
%w�X����� � text/shared/02/12050000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Refresh</title><filename>/text/shared/02/12050000.xhp</filename></topic></meta><body><section id="aktualisieren"><bookmark branch="hid/.uno:Refresh" id="bm_id5563940"/><bookmark branch="hid/.uno:Refresh" id="bm_id3154894"/><paragraph role="heading" level="1"><link href="text/shared/02/12050000.xhp">Refresh</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:Refresh">Refreshes the displayed data.</ahelp> In a multi-user environment, refreshing the data ensures that it remains current.</paragraph></section><section id="syaktualisieren"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_reload.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Refresh</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph">Click the arrow next to the <emph>Refresh </emph>icon to open a submenu with the following commands:</paragraph><list type="unordered"><listitem><paragraph role="listitem"><emph>Refresh</emph> - Displays the refreshed contents of the database table.</paragraph></listitem><listitem><bookmark branch="hid/DBACCESS_HID_BROWSER_REFRESH_REBUILDVIEW" id="bm_id3154317"/><paragraph role="listitem"><emph>Rebuild</emph> - <ahelp hid="HID_BROWSER_REFRESH_REBUILDVIEW">Rebuilds the view of the database table. Use this command when you have changed the structure of the table.</ahelp></paragraph></listitem></list></body></helpdocument>
PK
%w�X���' ' text/shared/02/12020000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Sort Descending</title><filename>/text/shared/02/12020000.xhp</filename></topic></meta><body><section id="absteigend"><bookmark branch="hid/.uno:SortDown" id="bm_id5470183"/><bookmark branch="hid/.uno:SortDown" id="bm_id3159242"/><paragraph role="heading" level="1"><link href="text/shared/02/12020000.xhp">Sort Descending</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:SortDown" visibility="hidden">Sorts the data of the selected field in descending order.</ahelp> Text fields are sorted alphabetically, number fields are sorted by number.</paragraph></section><section id="syabsteigend"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_sortdescending.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Sort Descending</paragraph></tablecell></tablerow></table></section><embed href="text/shared/02/12010000.xhp#selektionsortieren"/><embed href="text/shared/02/12010000.xhp#dialogsortieren"/></body></helpdocument>
PK
%w�X��T� � text/shared/02/20090000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Time</title><filename>/text/shared/02/20090000.xhp</filename></topic></meta><body><bookmark branch="hid/.uno:CurrentTime" id="bm_id3150620"/><paragraph role="heading" level="1"><link href="text/shared/02/20090000.xhp">Time</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:CurrentTime" visibility="visible">Displays the current time.</ahelp></paragraph></body></helpdocument>
PK
%w�X��LI
I
text/shared/02/20050000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Selection Mode</title><filename>/text/shared/02/20050000.xhp</filename></topic></meta><body><section id="selektionsmodus"><bookmark branch="index" id="bm_id3148668"/><bookmark branch="hid/.uno:SelectionMode" id="bm_id7365159"/><bookmark branch="hid/.uno:SelectionMode" id="bm_id3144740"/><bookmark branch="hid/.uno:StatusSelectionMode" id="bm_id2039489"/><bookmark branch="hid/.uno:StatusSelectionMode" id="bm_id3149495"/><paragraph role="heading" level="1"><link href="text/shared/02/20050000.xhp">Selection Mode</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:StatusSelectionMode">Here you can switch between different selection modes.</ahelp></paragraph></section><paragraph role="paragraph">When you click in the field, a popup menu comes up with the available options:</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><emph>Mode</emph></paragraph></tablecell><tablecell><paragraph role="paragraph"><emph>Effect</emph></paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">Standard selection</paragraph></tablecell><tablecell><paragraph role="paragraph">Click in text where you want to position the cursor; click in a cell to make it the active cell. Any other selection is then deselected.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">Extending selection (<item type="keycode">F8</item>)</paragraph></tablecell><tablecell><paragraph role="paragraph">Clicking in the text extends or crops the current selection.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">Adding selection (<item type="keycode">Shift+F8</item>)</paragraph></tablecell><tablecell><paragraph role="paragraph">A new selection is added to an existing selection. The result is a multiple selection.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">Block selection (<switchinline select="sys"><caseinline select="MAC"><item type="keycode">Command</item></caseinline><defaultinline><item type="keycode">Ctrl</item></defaultinline></switchinline><item type="keycode">+Shift+F8</item>)</paragraph></tablecell><tablecell><paragraph role="paragraph">A block of text can be selected.</paragraph></tablecell></tablerow></table><switch select="sys"><case select="WIN"><paragraph role="paragraph">On Windows systems, you can hold down the <item type="keycode">Alt</item> key while dragging to select a block of text. You don't need to enter the block selection mode.</paragraph></case></switch></body></helpdocument>
PK
%w�X�4� � text/shared/02/01170400.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Add Field</title><filename>/text/shared/02/01170400.xhp</filename></topic></meta><body><bookmark branch="hid/.uno:AddField" id="bm_id2298449"/><bookmark branch="hid/.uno:AddField" id="bm_id3149182"/><paragraph role="heading" level="1"><link href="text/shared/02/01170400.xhp">Add Field</link></paragraph><paragraph role="paragraph"><variable id="text"><ahelp hid=".uno:AddField">Opens a window where you can select a database field to add to the form or report.</ahelp></variable></paragraph><section id="howtoget"><embed href="text/shared/00/00040501.xhp#feldhinzu"/></section><bookmark branch="hid/SVX_HID_FIELD_SEL" id="bm_id3155503"/><paragraph role="paragraph"><ahelp hid="HID_FIELD_SEL">The field selection window lists all database fields of the table or query that was specified as the data source in the <link href="text/shared/02/01170201.xhp">Form Properties</link>.</ahelp></paragraph><paragraph role="paragraph">You can insert a field into the current document by dragging and dropping. A field is then inserted which contains a link to the database.</paragraph><paragraph role="paragraph">If you add fields to a form and you switch off the <link href="text/shared/02/01170500.xhp">Design Mode</link>, you can see that $[officename] adds a labeled input field for every inserted database field.</paragraph></body></helpdocument>
PK
%w�X*�=� � text/shared/02/12080000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Data to Fields</title><filename>/text/shared/02/12080000.xhp</filename></topic></meta><body><section id="dateninfelder"><bookmark branch="hid/.uno:DataSourceBrowser/InsertContent" id="bm_id3147588"/><bookmark branch="hid/.uno:DSBInsertContent" id="bm_id901211"/><paragraph role="heading" level="1"><link href="text/shared/02/12080000.xhp">Data to Fields</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DataSourceBrowser/InsertContent">Updates the contents of the existing database fields by the marked records.</ahelp> The <emph>Data to Fields </emph>icon is only available if the current document is a text document.</paragraph></section><section id="sydateninfelder"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_dsbinsertcontent.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Data to Fields</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�XR.r text/shared/02/12000000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Explorer On/Off</title><filename>/text/shared/02/12000000.xhp</filename></topic></meta><body><section id="explorer"><bookmark branch="hid/.uno:DSBrowserExplorer" id="bm_id6761446"/><bookmark branch="hid/.uno:DSBrowserExplorer" id="bm_id3154682"/><paragraph role="heading" level="1"><link href="text/shared/02/12000000.xhp">Explorer On/Off</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DSBrowserExplorer">Turns on and off the view of the data source explorer.</ahelp> The <emph>Explorer On/Off</emph> icon is visible on the <link href="text/shared/main0212.xhp">Table Data bar</link>.</paragraph></section><section id="syexplorer"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_dsbrowserexplorer.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Explorer On/Off</paragraph></tablecell></tablerow></table></section><embed href="text/shared/guide/database_main.xhp#database_main"/><paragraph role="paragraph">In the data source explorer you see the data sources registered in $[officename] with their queries and tables.</paragraph><paragraph role="paragraph"><emph>Establishing a connection</emph> - As soon as you select an individual table or query, a connection to the data source is established. Once the connection is opened, the name of the data source, the Queries or Tables entry, and the name of the query or table selected is shown in bold type.</paragraph><section id="kontextmenue"><bookmark branch="hid/DBACCESS_HID_BROWSER_CLOSECONN" id="bm_id3155135"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Closes the connection to the data source. See <emph>%PRODUCTNAME Base - Connections</emph> in the Options dialog box.</ahelp></paragraph><bookmark branch="hid/DBACCESS_HID_BROWSER_RENAME_ENTRY" id="bm_id3156192"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">To rename an entry, call this command and enter the new name. You can also do this by selecting the entry and pressing F2. The database must support renaming, otherwise this command is not enabled.</ahelp></paragraph><bookmark branch="hid/DBACCESS_HID_BROWSER_EDIT_DATABASE" id="bm_id189826"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Opens the selected database file for editing.</ahelp></paragraph><bookmark branch="hid/DBACCESS_HID_BROWSER_ADMINISTRATE" id="bm_id321665"/><bookmark branch="hid/DBACCESS_HID_BROWSER_ADMINISTRATE" id="bm_id5135044"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Opens a dialog to add/edit/remove a database file from the list of registered databases. The same dialog opens by choosing <emph>%PRODUCTNAME Base - Databases</emph> in the Options dialog box.</ahelp></paragraph></section></body></helpdocument>
PK
%w�X>�o� � text/shared/02/12090100.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Standard Filter</title><filename>/text/shared/02/12090100.xhp</filename></topic></meta><body><bookmark branch="hid/.uno:DataFilterStandardFilter" id="bm_id9065823"/><bookmark branch="hid/modules/scalc/ui/standardfilterdialog/StandardFilterDialog" id="bm_id3154232"/><paragraph role="heading" level="1">Standard Filter</paragraph><paragraph role="paragraph"><ahelp hid=".uno:DataFilterStandardFilter">Specifies the logical conditions to filter your table data.</ahelp> This dialog is available for spreadsheet documents, database tables and database forms. The dialog for databases does not contain the <emph>More Options</emph> button.</paragraph><section id="howtoget"><embed href="text/shared/00/00000409.xhp#dnfitdf"/></section><switch select="appl"><case select="CALC"><paragraph role="paragraph"><embedvar href="text/scalc/guide/filters.xhp#filters"/></paragraph></case></switch><paragraph role="heading" level="2">Filter criteria</paragraph><paragraph role="paragraph">You can define a filter by indicating the type of line, the name of the field, a logical condition and a value or a combination of arguments.</paragraph><bookmark branch="hid/modules/scalc/ui/standardfilterdialog/connect1" id="bm_id3153683"/><bookmark branch="hid/modules/scalc/ui/standardfilterdialog/connect2" id="bm_id3147577"/><bookmark branch="hid/dbaccess/ui/queryfilterdialog/op2" id="bm_id3155892"/><bookmark branch="hid/dbaccess/ui/queryfilterdialog/op3" id="bm_id3150774"/><paragraph role="heading" level="2">Operator</paragraph><paragraph role="paragraph"><ahelp hid="dbaccess/ui/queryfilterdialog/op3">For the following arguments, you can choose between the logical operators AND / OR.</ahelp></paragraph><bookmark branch="hid/modules/scalc/ui/standardfilterdialog/field1" id="bm_id3153682"/><bookmark branch="hid/modules/scalc/ui/standardfilterdialog/field2" id="bm_id3155942"/><bookmark branch="hid/modules/scalc/ui/standardfilterdialog/field3" id="bm_id3150693"/><bookmark branch="hid/dbaccess/ui/queryfilterdialog/field1" id="bm_id3153345"/><bookmark branch="hid/dbaccess/ui/queryfilterdialog/field2" id="bm_id3155535"/><bookmark branch="hid/dbaccess/ui/queryfilterdialog/field3" id="bm_id3148538"/><paragraph role="heading" level="2">Field name</paragraph><paragraph role="paragraph"><ahelp hid="dbaccess/ui/queryfilterdialog/field3">Specifies the field names from the current table to set them in the argument.</ahelp> You will see the column identifiers if no text is available for the field names.</paragraph><bookmark branch="hid/modules/scalc/ui/standardfilterdialog/cond1" id="bm_id3149811"/><bookmark branch="hid/modules/scalc/ui/standardfilterdialog/cond2" id="bm_id3153760"/><bookmark branch="hid/modules/scalc/ui/standardfilterdialog/cond3" id="bm_id3153126"/><bookmark branch="hid/dbaccess/ui/queryfilterdialog/cond1" id="bm_id3159270"/><bookmark branch="hid/dbaccess/ui/queryfilterdialog/cond2" id="bm_id3148990"/><bookmark branch="hid/dbaccess/ui/queryfilterdialog/cond3" id="bm_id3153252"/><paragraph role="heading" level="2">Condition</paragraph><paragraph role="paragraph"><ahelp hid="dbaccess/ui/queryfilterdialog/cond3">Specifies the <link href="text/shared/02/12090101.xhp">comparative operators</link> through which the entries in the <emph>Field name</emph> and <emph>Value</emph> fields can be linked.</ahelp></paragraph><bookmark branch="hid/modules/scalc/ui/standardfilterdialog/val1" id="bm_id3155136"/><bookmark branch="hid/modules/scalc/ui/standardfilterdialog/val2" id="bm_id3148492"/><bookmark branch="hid/modules/scalc/ui/standardfilterdialog/val3" id="bm_id3150276"/><bookmark branch="hid/dbaccess/ui/queryfilterdialog/value1" id="bm_id3146949"/><bookmark branch="hid/dbaccess/ui/queryfilterdialog/value2" id="bm_id3153700"/><bookmark branch="hid/dbaccess/ui/queryfilterdialog/value3" id="bm_id3159400"/><paragraph role="heading" level="2">Value</paragraph><paragraph role="paragraph"><ahelp hid="dbaccess/ui/queryfilterdialog/value3">Specifies a value to filter the field.</ahelp></paragraph><paragraph role="paragraph">The<emph> Value </emph>list box contains all possible values for the specified <emph>Field name</emph> . Choose the value to be used in the filter. You can also choose the <emph>- empty -</emph> or <emph>-not empty -</emph> entries..</paragraph><paragraph role="paragraph">If you use the filter function in database tables or forms, then type the value in the <emph>Value </emph>text box to be used for filtering.</paragraph><switch select="appl"><case select="CALC"><paragraph role="heading" level="2"><link href="text/scalc/01/12040201.xhp">More Options</link></paragraph><embed href="text/scalc/01/12040201.xhp#zusaetzetext"/></case></switch></body></helpdocument>
PK
%w�X-��1? 1? text/shared/02/01170203.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Data</title><filename>/text/shared/02/01170203.xhp</filename></topic></meta><body><section id="daten"><bookmark branch="index" id="bm_id3150040"/><paragraph role="heading" level="1"><link href="text/shared/02/01170203.xhp">Data</link></paragraph><paragraph role="paragraph">The<emph> Data </emph>tab page defines the form properties that refer to the database that is linked to the form.</paragraph></section><paragraph role="paragraph">Defines the data source on which the form is based, or specifies whether the data can be edited by the user. Apart from the sort and filter functions, you will also find all the necessary properties to create a <link href="text/shared/02/01170203.xhp">subform</link>.</paragraph><section id="howtoget"><embed href="text/shared/00/00040501.xhp#formulareigenschaftendaten"/></section><sort><section id="Section1"><bookmark branch="hid/EXTENSIONS_HID_PROP_DATASOURCE" id="bm_id3153146"/><paragraph role="heading" level="2">Data source</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_DATASOURCE">Defines the data source to which the form should refer.</ahelp> If you click the <emph>...</emph> button, you call the <link href="text/shared/01/01020000.xhp"><emph>Open</emph></link> dialog, where you can choose a data source.</paragraph></section><section id="Section2"><bookmark branch="hid/EXTENSIONS_HID_PROP_CURSORSOURCE" id="bm_id3150275"/><paragraph role="heading" level="2">Content</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_CURSORSOURCE">Determines the content to be used for the form. The content can be an existing table or a query (previously created in the database), or it can be defined by an SQL-statement. Before you enter a content you have to define the exact type in <emph>Content type</emph>.</ahelp></paragraph><paragraph role="paragraph">If you have selected either "Table" or "Query" in <emph>Content type</emph>, the box lists all the tables and queries set up in the selected database.</paragraph></section><section id="Section3"><bookmark branch="hid/EXTENSIONS_HID_PROP_CURSORSOURCETYPE" id="bm_id3153381"/><paragraph role="heading" level="2">Content type</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_CURSORSOURCETYPE">Defines whether the data source is to be an existing database table or query, or if the form is to be generated based on an SQL statement.</ahelp></paragraph><paragraph role="paragraph">If you choose "Table" or "Query", the form will refer to the table or query that you specify under <emph>Content</emph>. If you want to create a new query or a <link href="text/shared/02/01170203.xhp">subform</link>, then you have to choose the "SQL" option. You can then enter the statement for the SQL query or the subform directly in the <emph>List content</emph> box on the Control properties Data tab page.</paragraph></section><section id="Section4"><bookmark branch="hid/EXTENSIONS_HID_PROP_ESCAPE_PROCESSING" id="bm_id3144433"/><paragraph role="heading" level="2">Analyze SQL command</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_ESCAPE_PROCESSING">Specifies whether the SQL statement is to be analyzed by %PRODUCTNAME.</ahelp> If set to Yes, you can click the <emph>...</emph> button next to the <emph>Content</emph> list box. This will open a window where you can graphically create a database query. When you close that window, the SQL statement for the created query will be inserted in the <emph>Content</emph> list box.</paragraph></section><section id="Section5"><paragraph role="heading" level="2">Filter</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_FILTER_CRITERIA">Enter the required conditions for filtering the data in the form. The filter specifications follow SQL rules without using the WHERE clause.</ahelp> For example, if you want to display all records with the "Mike" forename, type into the data field: Forename = 'Mike'. You can also combine conditions: Forename = 'Mike' OR Forename = 'Peter'. All records matching either of these two conditions will be displayed.</paragraph><paragraph role="paragraph">The filter function is available in user mode through the <link href="text/shared/02/12030000.xhp"><emph>AutoFilter</emph></link> and <link href="text/shared/02/12090000.xhp"><emph>Default Filter</emph></link> icons on the <link href="text/shared/main0213.xhp"><emph>Form Navigation</emph> Bar</link>.</paragraph></section><section id="Section6"><bookmark branch="hid/EXTENSIONS_HID_PROP_SORT_CRITERIA" id="bm_id3151353"/><paragraph role="heading" level="2">Sort</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_SORT_CRITERIA">Specifies the conditions to sort the data in the form. The specification of the sorting conditions follows SQL rules without the use of the ORDER BY clause.</ahelp> For example, if you want all records of a database to be sorted in one field in an ascending order and in another field in a descending order, enter Forename ASC, Name DESC (presuming Forename and Name are the names of the data fields).</paragraph><paragraph role="paragraph">The appropriate icons on the <link href="text/shared/main0213.xhp"><emph>Form Navigation</emph> Bar</link> can be used in User mode to sort: <link href="text/shared/02/12010000.xhp"><emph>Sort Ascending</emph></link>, <link href="text/shared/02/12020000.xhp"><emph>Sort Descending</emph></link>, <link href="text/shared/02/12100100.xhp"><emph>Sort</emph></link>.</paragraph></section><section id="Section7"><bookmark branch="hid/EXTENSIONS_HID_PROP_DATAENTRY" id="bm_id3154129"/><paragraph role="heading" level="2">Add data only</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_DATAENTRY">Determines if the form only allows the addition of new data (Yes) or if it allows other properties as well (No).</ahelp></paragraph><paragraph role="note">If <emph>Add data only</emph> is set to "Yes", changing or deleting data is not possible.</paragraph></section><section id="Section8"><bookmark branch="hid/EXTENSIONS_HID_PROP_NAVIGATION" id="bm_id3155418"/><paragraph role="heading" level="2">Navigation bar</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_NAVIGATION">Specifies whether the navigation functions in the lower form bar can be used.</ahelp></paragraph><paragraph role="paragraph">The "Parent Form" option is used for subforms. If you choose this option for a subform, you can navigate using the records of the main form if the cursor is placed in the subform. A subform is linked to the parent form by a 1:1 relationship, so navigation is always performed in the parent form.</paragraph></section><section id="Section9"><bookmark branch="hid/EXTENSIONS_HID_PROP_CYCLE" id="bm_id3151282"/><paragraph role="heading" level="2">Cycle</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_CYCLE">Determines how the navigation should be done using the tab key.</ahelp> Using the tab key, you can move forward in the form. If you simultaneously press the Shift key, the navigation will follow the opposite direction. If you reach the last (or the first) field and press the tab key again, it can have various effects. Define the key control with the following options:</paragraph><table><tablerow><tablecell><paragraph role="tablehead">Option</paragraph></tablecell><tablecell><paragraph role="tablehead">Meaning</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">Default</paragraph></tablecell><tablecell><paragraph role="paragraph">This setting automatically defines a cycle which follows an existing database link: If the form contains a database link, the Tab key will, by default, initiate a change to the next or previous record on exit from the last field (see All Records). If there is no database link the next/previous form is shown (see Current Page).</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">All records</paragraph></tablecell><tablecell><paragraph role="paragraph">This option applies to database forms only and is used to navigate through all records. If you use the Tab key to exit from the last field of a form, the current record is changed.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">Active record</paragraph></tablecell><tablecell><paragraph role="paragraph">This option applies to database forms only, and is used to navigate within the current record. If you use the Tab key to exit from the last field of a form, the current record is changed.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">Current page</paragraph></tablecell><tablecell><paragraph role="paragraph">On exit from the last field of a form, the cursor skips to the first field in the next form. This is standard for HTML forms; therefore, this option is especially relevant for HTML forms.</paragraph></tablecell></tablerow></table></section><section id="Section10"><bookmark branch="hid/EXTENSIONS_HID_PROP_ALLOW_ADDITIONS" id="bm_id3155445"/><paragraph role="heading" level="2">Allow additions</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_ALLOW_ADDITIONS">Determines if data can be added.</ahelp></paragraph></section><section id="Section11"><bookmark branch="hid/EXTENSIONS_HID_PROP_ALLOW_EDITS" id="bm_id3083286"/><paragraph role="heading" level="2">Allow modifications</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_ALLOW_EDITS"> Determines if the data can be modified.</ahelp></paragraph></section><section id="Section12"><bookmark branch="hid/EXTENSIONS_HID_PROP_ALLOW_DELETIONS" id="bm_id3153924"/><paragraph role="heading" level="2">Allow deletions</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_ALLOW_DELETIONS">Determines if the data can be deleted.</ahelp></paragraph></section><section id="Section13"><bookmark branch="hid/EXTENSIONS_HID_PROP_MASTERFIELDS" id="bm_id3147097"/><paragraph role="heading" level="2">Link master fields</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_MASTERFIELDS">If you create a <link href="text/shared/02/01170203.xhp">subform</link>, enter the data field of the parent form responsible for the synchronization between parent and subform.</ahelp> To enter multiple values, press Shift + Enter after each input line.</paragraph><paragraph role="paragraph">The subform is based on an <link href="text/shared/00/00000005.xhp#sql">SQL</link> query; more specifically, on a <link href="text/shared/explorer/database/02010100.xhp">Parameter Query</link>. If a field name is entered in the <emph>Link master fields</emph> box, the data contained in that field in the main form is read to a variable that you must enter in <emph>Link slave fields</emph>. In an appropriate SQL statement, this variable is compared to the table data that the subform refers to. Alternatively, you can enter the column name in the <emph>Link master fields</emph> box.</paragraph><paragraph role="paragraph">Consider the following example:</paragraph><paragraph role="paragraph">The database table on which the form is based is, for example, a customer database ("Customer"), where every customer has been given a unique number in a data field named "Cust_ID". A customer's orders are maintained in another database table. You now want to see each customer's orders after entering them into the form. In order to do this you should create a subform. Under <emph>Link master fields</emph> enter the data field from the customer database which clearly identifies the customer, that is, Cust_ID. Under <emph>Link slave fields</emph> enter the name of a variable which is to accept the data of the field Cust_ID, for example, x.</paragraph><paragraph role="paragraph">The subform should show the appropriate data from the orders table ("Orders") for each customer ID (Customer_ID -> x). This is only possible if each order is uniquely assigned to one customer in the orders table. Alternatively, you can use another field called Customer_ID; however, to make sure that this field is not confused with the same field from the main form, the field is called Customer_Number.</paragraph><paragraph role="paragraph">Now compare the Customer_Number in the "Orders" table with the Customer_ID from the "Customers" table, which can be done, for example, using the x variable with the following SQL statement:</paragraph><paragraph role="paragraph">SELECT * FROM Orders WHERE Customer_Number =: x (if you want the subform to show all data from the orders table)</paragraph><paragraph role="paragraph">or:</paragraph><paragraph role="paragraph">SELECT Item FROM Orders WHERE Customer_Number =: x (if you want the subform from the orders table to show only the data contained in the "Item" field)</paragraph><paragraph role="paragraph">The SQL statement can either be entered in the <emph>Data source</emph> field, or you can create an appropriate parameter query, which can be used to create the subform.</paragraph></section><section id="Section14"><bookmark branch="hid/EXTENSIONS_HID_PROP_SLAVEFIELDS" id="bm_id3145789"/><paragraph role="heading" level="2">Link slave fields</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_SLAVEFIELDS">If you create a subform, enter the variable where possible values from the parent form field can be stored.</ahelp> If a subform is based on a query, enter the variable that you defined in the query. If you create a form using an SQL statement entered in the <emph>Data source</emph> field, enter the variable you used in the statement. You can choose any variable name. If you want to enter multiple values, press Shift + Enter.</paragraph><paragraph role="paragraph">If, for example, you specified the Customer_ID database field as a parent field under <emph>Link master fields</emph>, then you can define under <emph>Link slave fields</emph> the name of the variable in which the values of the Customer_ID database field are to be stored. If you now specify an SQL statement in the <emph>Data source</emph> box using this variable, the relevant values are displayed in the subform.</paragraph></section></sort><paragraph role="heading" level="2">What is a subform?</paragraph><paragraph role="paragraph">Forms are created based on a database table or database query. They display the data in a visually pleasant fashion and can be used to enter data or edit data.</paragraph><paragraph role="paragraph"><variable id="wozu">If you require a form that can refer to the data in a table or query and can additionally display data from another table, you should create a subform.
</variable> For example, this subform can be a text box that displays the data of another database table.</paragraph><paragraph role="paragraph">A subform is an additional component of the main form. The main form can be called the "parent form" or "master". Subforms are needed as soon as you want to access more than one table from a form. Each additional table requires its own subform.</paragraph><paragraph role="paragraph">After creating a form, it can be changed into a subform. To do this, enter Design Mode, and open the Form Navigator. In the Form Navigator, drag a form (that will become a subform) onto any other form (that will become a master).</paragraph><paragraph role="paragraph">The user of your document will not see that a form has subforms. The user only sees a document in which data is entered or where existing data is displayed.</paragraph><paragraph role="paragraph">Specify the Link master field from the data fields in the master form. In the subform, the Link slave field can be set as a field which will be matched to the contents of the Link master field.</paragraph><paragraph role="paragraph">When the user navigates through the data, the form always displays the current data record. If there are subforms defined, the contents of the subforms will be displayed after a short delay of approximate 200 ms. This delay enables you to quickly browse through the data records of the master form. If you navigate to the next master data record within the delay limit, the subform data need not be retrieved and displayed.</paragraph></body></helpdocument>
PK
%w�XN�X� � text/shared/02/09070300.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Document</title><filename>/text/shared/02/09070300.xhp</filename></topic></meta><body><section id="dokument"><bookmark branch="hid/CUI_HID_HYPERLINK_DOCUMENT" id="bm_id3154094"/><paragraph role="heading" level="1"><link href="text/shared/02/09070300.xhp">Document</link></paragraph><paragraph role="paragraph">Hyperlinks to any document or targets in documents can be edited using the <emph>Document</emph> tab from the <link href="text/shared/02/09070000.xhp">Hyperlink dialog</link>.</paragraph></section><section id="howtoget"><embed href="text/shared/00/00000403.xhp#hypdiadok"/></section><paragraph role="heading" level="2">Document</paragraph><bookmark branch="hid/CUI_HID_HYPERDLG_DOC_PATH" id="bm_id3155552"/><paragraph role="heading" level="3">Path</paragraph><paragraph role="paragraph"><ahelp hid=".">Enter a URL for the file that you want to open when you click the hyperlink. If you do not specify a target frame, the file opens in the current document or frame.</ahelp></paragraph><bookmark branch="hid/cui:ImageButton:RID_SVXPAGE_HYPERLINK_DOCUMENT:BTN_FILEOPEN" id="bm_id3147571"/><paragraph role="heading" level="3">Open File</paragraph><paragraph role="paragraph"><ahelp hid="SVX:IMAGEBUTTON:RID_SVXPAGE_HYPERLINK_DOCUMENT:BTN_FILEOPEN">Opens the <emph>Open dialog,</emph> where you can select a file.</ahelp></paragraph><paragraph role="heading" level="2">Target in document</paragraph><bookmark branch="hid/cui:Edit:RID_SVXPAGE_HYPERLINK_DOCUMENT:ED_TARGET_DOC" id="bm_id3150693"/><paragraph role="heading" level="3">Target</paragraph><paragraph role="paragraph"><ahelp hid="SVX:EDIT:RID_SVXPAGE_HYPERLINK_DOCUMENT:ED_TARGET_DOC">Specifies a target for the hyperlink into the document specified under <emph>Path</emph>.</ahelp></paragraph><bookmark branch="hid/cui:ImageButton:RID_SVXPAGE_HYPERLINK_DOCUMENT:BTN_BROWSE" id="bm_id3151110"/><paragraph role="heading" level="3">Target in Document</paragraph><paragraph role="paragraph"><ahelp hid="SVX:IMAGEBUTTON:RID_SVXPAGE_HYPERLINK_DOCUMENT:BTN_BROWSE">Opens the <emph>Target in Document</emph> dialog.</ahelp></paragraph><paragraph role="heading" level="3">URL</paragraph><paragraph role="paragraph">Specifies the URL, which results from the entries in <emph>Path</emph> and <emph>Destination</emph>.</paragraph><embed href="text/shared/02/09070100.xhp#weitere"/></body></helpdocument>
PK
%w�X���� � text/shared/02/18010000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Selection</title><filename>/text/shared/02/18010000.xhp</filename></topic></meta><body><section id="auswahl"><bookmark branch="hid/.uno:SelectObject" id="bm_id8570964"/><bookmark branch="hid/.uno:SelectObject" id="bm_id3153255"/><paragraph role="heading" level="1"><link href="text/shared/02/18010000.xhp">Selection</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:SelectObject">Allows you to select objects in the current document.</ahelp></paragraph></section><section id="syauswahl"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_drawselect.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Selection</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph">To select an object, click the object with the arrow. To select more than one object, drag a selection frame around the objects. To add an object to a selection, press Shift, and then click the object. <switchinline select="appl"><caseinline select="WRITER"/><caseinline select="CALC"/><caseinline select="CHART"/><caseinline select="MATH"/><defaultinline>The objects selected together can then be defined as a <link href="text/shared/01/05290000.xhp">group</link>, turning them into a single group object.</defaultinline></switchinline></paragraph><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER"/><caseinline select="CALC"/><caseinline select="CHART"/><caseinline select="MATH"/><defaultinline>You can edit individual elements of a group. You can also delete elements from a group with <switchinline select="sys"><caseinline select="MAC">Command
</caseinline><defaultinline>Shift</defaultinline></switchinline>+click.</defaultinline></switchinline></paragraph><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER"/><caseinline select="CALC"/><caseinline select="CHART"/><caseinline select="MATH"/><defaultinline>You can select single objects from a group by double-clicking, if you first disable the <emph>Double-click to edit Text</emph> icon on the <emph>Option</emph> Bar.</defaultinline></switchinline></paragraph></body></helpdocument>
PK
%w�XTҖ� � text/shared/02/05020000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Arrow Style</title><filename>/text/shared/02/05020000.xhp</filename></topic></meta><body><section id="linienendenstil"><bookmark branch="hid/.uno:LineEndStyle" id="bm_id727567"/><bookmark branch="hid/.uno:LineEndStyle" id="bm_id3109850"/><paragraph role="heading" level="1"><link href="text/shared/02/05020000.xhp">Arrow Style</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:LineEndStyle">Opens the <emph>Arrowheads</emph> toolbar. Use the symbols shown to define the style for the end of the selected line.</ahelp></paragraph></section><paragraph role="paragraph">The <emph>Arrow Style</emph> icon is only displayed when you create a drawing with the drawing functions. For more information, see the <link href="text/shared/01/05200300.xhp"><emph>Line Styles</emph></link> section of the Help.</paragraph><section id="sylinienendenstil"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_lineendstyle.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Arrow Style</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�Xo,[>+� +� text/shared/02/01170101.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>General</title><filename>/text/shared/02/01170101.xhp</filename></topic></meta><body><section id="allgemein"><paragraph role="heading" level="1"><link href="text/shared/02/01170101.xhp">General</link></paragraph><paragraph role="paragraph">This <emph>General </emph>tab enables you to define the general properties of a form control. These properties differ, depending on the control type. Not all of the following properties are available for every control.</paragraph></section><section id="howtoget"><embed href="text/shared/00/00040501.xhp#controleigenschaftenallgemein"/></section><paragraph role="note">If you export the current form document to HTML format, the default control values are exported, not the current control values. Default values are determined - depending on the type of control - by the properties' Default value (for example, in text fields), Default status (for check boxes and option fields), and Default selection (for list boxes).</paragraph><sort><section id="Section1"><bookmark branch="hid/EXTENSIONS_HID_PROP_ENABLED" id="bm_id3154897"/><paragraph role="heading" level="2">Enabled</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_ENABLED">If a control field has the property "Enabled" (Yes), the form user will be able to use the control field.</ahelp> If the property is disabled, it will not be enabled (No) and will be displayed in a gray color.</paragraph></section><section id="Section63"><bookmark branch="hid/EXTENSIONS_HID_PROP_LINECOUNT" id="bm_id3146948"/><paragraph role="heading" level="2">Line count</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_LINECOUNT" visibility="hidden">Specifies how many lines should be displayed in the dropdown list. This setting is only active if you chose "Yes" in the "Dropdown" option.</ahelp> For combo boxes with the Dropdown property, you can specify how many lines should be displayed in the dropdown list. With control fields which do not have the Dropdown option, the line's display will be specified by the size of the control field and the font size.</paragraph></section><section id="Section62"><bookmark branch="hid/EXTENSIONS_HID_PROP_BUTTONTYPE" id="bm_id3156152"/><paragraph role="heading" level="2">Action</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_BUTTONTYPE" visibility="hidden">The Action property determines the action that occurs when you activate a button.</ahelp> You can use navigation actions to design your own database navigation buttons.</paragraph><paragraph role="paragraph">The following table describes the actions that you can assign to a button.</paragraph><table><tablerow><tablecell><paragraph role="tablehead">Action</paragraph></tablecell><tablecell><paragraph role="tablehead">Description</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">None</paragraph></tablecell><tablecell><paragraph role="tablecontent">No action occurs.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Submit form</paragraph></tablecell><tablecell><paragraph role="tablecontent">Sends the data that is entered in other control fields of the current form to the address that is specified in <link href="text/shared/02/01170200.xhp">Form Properties</link> under <link href="text/shared/02/01170201.xhp"><emph>URL</emph></link>. </paragraph><paragraph role="tablecontent">Enter the URL into the form's data property "URL" text box when you export to a PDF file.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Reset form</paragraph></tablecell><tablecell><paragraph role="tablecontent">Resets the settings in other control fields to the predefined defaults (Default Status, Default Selection, Default Value).</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Open document / web page</paragraph></tablecell><tablecell><paragraph role="tablecontent">Opens the URL that is specified under <emph>URL</emph>. You can use <emph>Frame</emph> to specify the target frame.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">First record</paragraph></tablecell><tablecell><paragraph role="tablecontent">Moves the current form to the first record.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Previous record</paragraph></tablecell><tablecell><paragraph role="tablecontent">Moves the current form to the previous record.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Next record</paragraph></tablecell><tablecell><paragraph role="tablecontent">Moves the current form to the next record.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Last record</paragraph></tablecell><tablecell><paragraph role="tablecontent">Moves the current form to the last record.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Save record</paragraph></tablecell><tablecell><paragraph role="tablecontent">Saves the current record, if necessary.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Undo data entry</paragraph></tablecell><tablecell><paragraph role="tablecontent">Reverses the changes in the current record.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">New record</paragraph></tablecell><tablecell><paragraph role="tablecontent">Moves the current form to the insert row.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Delete record</paragraph></tablecell><tablecell><paragraph role="tablecontent">Deletes the current record.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">Refresh form</paragraph></tablecell><tablecell><paragraph role="tablecontent">Reloads the most recently saved version of the current form.</paragraph></tablecell></tablerow></table></section><section id="Section61"><bookmark branch="hid/EXTENSIONS_HID_PROP_DROPDOWN" id="bm_id3146148"/><paragraph role="heading" level="2">Dropdown</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_DROPDOWN" visibility="hidden">Specifies whether the combo box should dropdown (Yes) or not (No).</ahelp> A control field with the dropdown property has an additional arrow button which opens the list of the existing form entries per mouse click. Under <emph>Line count</emph>, you can specify how many lines (or rows) should be displayed in the dropdown state. Combination fields can have the dropdown property.</paragraph><paragraph role="paragraph">Combo boxes that were inserted as columns in a table control are always dropdown as the default.</paragraph></section><section id="Section60"><bookmark branch="hid/EXTENSIONS_HID_PROP_ALIGN" id="bm_id3150116"/><bookmark branch="hid/EXTENSIONS_HID_PROP_IMAGEPOSITION" id="bm_id2524491"/><paragraph role="heading" level="2">Alignment / Graphics alignment</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_ALIGN" visibility="hidden">Specifies the alignment option for text or graphics that are used on a control.</ahelp> The alignment options are left-aligned, right-aligned, and centered. These options are available for the following elements:</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Title of Label fields</paragraph></listitem><listitem><paragraph role="paragraph">Content of text fields</paragraph></listitem><listitem><paragraph role="paragraph">Content of table fields in the columns of a table control</paragraph></listitem><listitem><paragraph role="paragraph">Graphics or text that are used in buttons</paragraph><paragraph role="note">The <emph>Alignment</emph> option for buttons is called <emph>Graphics alignment</emph>.</paragraph></listitem></list></section><section id="Section59"><bookmark branch="hid/EXTENSIONS_HID_PROP_AUTOCOMPLETE" id="bm_id3154790"/><paragraph role="heading" level="2">AutoFill</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_AUTOCOMPLETE" visibility="hidden">Assigns the AutoFill function to a combo box.</ahelp> The AutoFill function displays a list of previous entries after you start to type an entry.</paragraph></section><section id="Section58"><bookmark branch="hid/EXTENSIONS_HID_PROP_CONTROLLABEL" id="bm_id3151053"/><paragraph role="heading" level="2">Label field</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_CONTROLLABEL">Specifies the source for the label of the control.</ahelp> The text of the label field will be used instead of the name of a database field. For example, in the <emph>Filter Navigator</emph>, <emph>Search</emph> dialog, and as a column name in the table view.</paragraph><paragraph role="paragraph">To define one character of the label as a mnemonic, so that the user can access this control by pressing the character on the keyboard, insert a tilde (~) character in front of the character in the label.</paragraph><paragraph role="paragraph">Only the text of a group frame can be used as the label field when using radio buttons. This text applies to all of the radio buttons of the same group.</paragraph><paragraph role="paragraph">If you click on the <emph>...</emph> button next to the text field, you will see the <emph>Label Field Selection</emph> dialog. Select a label from the list.</paragraph><paragraph role="paragraph"><ahelp hid="modules/spropctrlr/ui/labelselectiondialog/LabelSelectionDialog">Check the <emph>No assignment </emph>box to remove the link between a control and the assigned label field.</ahelp></paragraph></section><section id="Section57"><bookmark branch="hid/EXTENSIONS_HID_PROP_WIDTH" id="bm_id3156356"/><paragraph role="heading" level="2">Width</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_WIDTH" visibility="hidden">Sets the column width in the table control field.</ahelp> Sets the column width in the table control field in the units that are specified in the %PRODUCTNAME module options. If you want, you can enter a value followed by a valid measurement unit, for example, 2 cm.</paragraph></section><section id="Section56"><bookmark branch="hid/EXTENSIONS_HID_PROP_REPEAT" id="bm_id2982573"/><paragraph role="heading" level="2">Repeat</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_REPEAT">Specifies if the action of a control such as a spin button repeats when you click the control and hold the mouse button down.</ahelp></paragraph></section><section id="Section55"><bookmark branch="hid/EXTENSIONS_HID_PROP_REPEAT_DELAY" id="bm_id1620227"/><paragraph role="heading" level="2">Delay</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_REPEAT_DELAY">Specifies the delay in milliseconds between repeating events.</ahelp> A repeating event occurs when you click an arrow button or the background of a scrollbar, or one of the record navigation buttons of a Navigation Bar, and you keep the mouse button pressed for some time. You can enter a value followed by a valid time unit, for example, 2 s or 500 ms.</paragraph></section><section id="Section54"><bookmark branch="hid/EXTENSIONS_HID_PROP_RECORDMARKER" id="bm_id3154272"/><paragraph role="heading" level="2">Record marker</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_RECORDMARKER">Specifies whether the first column is displayed with row labels, in which the current record is marked by an arrow.</ahelp></paragraph></section><section id="Section53"><bookmark branch="hid/EXTENSIONS_HID_PROP_DATEFORMAT" id="bm_id3158419"/><paragraph role="heading" level="2">Date format</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_DATEFORMAT" visibility="hidden">Here, you can determine the format you want for the date readout.</ahelp> With date fields you can determine the format for the date readout.</paragraph><paragraph role="note"><variable id="hinweis">All format fields (date, time, currency, numeric) are formatted automatically in the selected format as soon as you leave them regardless of how you entered the input.
</variable></paragraph></section><section id="Section52"><bookmark branch="hid/EXTENSIONS_HID_PROP_SPIN" id="bm_id3145642"/><paragraph role="heading" level="2">Spin Button</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_SPIN" visibility="hidden">The "Yes" option transforms the control field into a spin button, where corresponding arrow buttons are added.</ahelp> Numerical fields, currency fields, date and time fields can be introduced as spin buttons in the form.</paragraph></section><section id="Section51"><bookmark branch="hid/EXTENSIONS_HID_PROP_TRISTATE" id="bm_id3150386"/><paragraph role="heading" level="2">Tristate</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_TRISTATE">Specifies whether a check box can also represent ZERO values of a linked database apart from the TRUE and FALSE values.</ahelp> This function is only available if the database accepts three states: TRUE, FALSE and ZERO.</paragraph><paragraph role="note">The<emph> Tristate </emph>property is only defined for database forms, not for HTML forms.</paragraph></section><section id="Section50"><bookmark branch="hid/EXTENSIONS_HID_PROP_PRINTABLE" id="bm_id3145228"/><paragraph role="heading" level="2">Printable</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_PRINTABLE">Specifies whether you want the control field to appear in a document's printout.</ahelp></paragraph></section><section id="Section88"><bookmark branch="hid/EXTENSIONS_HID_PROP_POSITIONX" id="bm_id3145229"/><paragraph role="heading" level="2">PositionX</paragraph><paragraph role="paragraph"><ahelp hid=".">Defines the X position of the control, relative to the anchor.</ahelp></paragraph></section><section id="Section87"><bookmark branch="hid/EXTENSIONS_HID_PROP_POSITIONY" id="bm_id3145230"/><paragraph role="heading" level="2">PositionY</paragraph><paragraph role="paragraph"><ahelp hid=".">Defines the Y position of the control, relative to the anchor.</ahelp></paragraph></section><section id="Section86"><bookmark branch="hid/EXTENSIONS_HID_PROP_ANCHOR_TYPE" id="bm_id3145231"/><paragraph role="heading" level="2">Anchor</paragraph><paragraph role="paragraph"><ahelp hid=".">Defines where the control will be anchored.</ahelp></paragraph></section><section id="Section85"><bookmark branch="hid/EXTENSIONS_HID_PROP_WIDTH" id="bm_id3145238"/><paragraph role="heading" level="2">Width</paragraph><paragraph role="paragraph"><ahelp hid=".">Defines the width of the control.</ahelp></paragraph></section><section id="Section84"><bookmark branch="hid/EXTENSIONS_HID_PROP_HEIGHT" id="bm_id3145248"/><paragraph role="heading" level="2">Height</paragraph><paragraph role="paragraph"><ahelp hid=".">Defines the height of the control.</ahelp></paragraph></section><section id="Section49"><bookmark branch="hid/EXTENSIONS_HID_PROP_EDITMASK" id="bm_id3147001"/><paragraph role="heading" level="2">Edit mask</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_EDITMASK" visibility="hidden">Defines the edit mask. By specifying a character code you can determine what the user can enter in the control field.</ahelp> By specifying the character code in pattern fields, you can determine what the user can enter in the pattern field.</paragraph><paragraph role="paragraph">The length of the edit mask determines the number of the possible input positions. If the user enters characters that do not correspond to the edit mask, the input is rejected when the user leaves the field. You can enter the following characters to define the edit mask:</paragraph><table><tablerow><tablecell><paragraph role="tablehead"> Character </paragraph></tablecell><tablecell><paragraph role="tablehead">Meaning</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">L</paragraph></tablecell><tablecell><paragraph role="tablecontent">A text constant. This position cannot be edited. The character is displayed at the corresponding position of the Literal Mask.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">a</paragraph></tablecell><tablecell><paragraph role="tablecontent">The characters a-z and A-Z can be entered. Capital characters are not converted to lowercase characters.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">A</paragraph></tablecell><tablecell><paragraph role="tablecontent">The characters A-Z can be entered. If a lowercase letter is entered, it is automatically converted to a capital letter</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">c</paragraph></tablecell><tablecell><paragraph role="tablecontent">The characters a-z, A-Z, and 0-9 can be entered. Capital characters are not converted to lowercase characters.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">C</paragraph></tablecell><tablecell><paragraph role="tablecontent">The characters A-Z and 0-9 can be entered. If a lowercase letter is entered, it is automatically converted to a capital letter</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">N</paragraph></tablecell><tablecell><paragraph role="tablecontent">Only the characters 0-9 can be entered.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">x</paragraph></tablecell><tablecell><paragraph role="tablecontent">All printable characters can be entered.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">X</paragraph></tablecell><tablecell><paragraph role="tablecontent">All printable characters can be entered. If a lowercase letter is used, it is automatically converted to a capital letter.</paragraph></tablecell></tablerow></table><paragraph role="paragraph">For the literal mask "__.__.2000", for example, define the "NNLNNLLLLL" edit mask so that the user can only enter four digits when entering a date.</paragraph></section><section id="Section48"><bookmark branch="hid/EXTENSIONS_HID_PROP_STRICTFORMAT" id="bm_id3145588"/><paragraph role="heading" level="2">Strict format</paragraph><paragraph role="paragraph">You can have a format check with control fields that accept formatted contents (date, time, and so on). <ahelp hid="HID_PROP_STRICTFORMAT">If the strict format function is activated (Yes), only the allowed characters are accepted.</ahelp> For example, in a date field, only numbers or date delimiters are accepted; all alphabet entries typed with your keyboard are ignored.</paragraph></section><section id="targetframe"><bookmark branch="hid/EXTENSIONS_HID_PROP_TARGET_FRAME" id="bm_id3149491"/><paragraph role="heading" level="2">Frame</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_TARGET_FRAME" visibility="hidden">Specifies the target frame to display the document that is opened by the "Open document / web page" action.</ahelp> You can also specify the target frame to display a <emph>URL</emph> that you open when you click a button that has been assigned the Open document or web page action).</paragraph><section id="fuerformulareigenschaft"><paragraph role="paragraph">If you click the field, you can select an option from the list that specifies into which frame the next document should be loaded. The following possibilities exist:</paragraph><table><tablerow><tablecell><paragraph role="tablehead">Entry</paragraph></tablecell><tablecell><paragraph role="tablehead">Meaning</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">_blank</paragraph></tablecell><tablecell><paragraph role="paragraph">The next document is created in a new empty frame.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">_parent</paragraph></tablecell><tablecell><paragraph role="paragraph">The next document is created in a parent frame. If no parent exists, the document is created in the same frame.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">_self</paragraph></tablecell><tablecell><paragraph role="paragraph">The next document is created in the same frame.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">_top</paragraph></tablecell><tablecell><paragraph role="paragraph">The next document is created in a top-level window, that is, in the highest frame of the hierarchy; if the current frame is already a top window, the document is created in the current frame.</paragraph></tablecell></tablerow></table></section><paragraph role="note">The Frame property is relevant for HTML forms, but not for database forms.</paragraph></section><section id="Section46"><bookmark branch="hid/EXTENSIONS_HID_PROP_IMAGE_URL" id="bm_id3156191"/><paragraph role="heading" level="2">Graphics</paragraph><paragraph role="paragraph">An image button has a <emph>Graphics </emph>property. <ahelp hid="HID_PROP_IMAGE_URL">The<emph> Graphics</emph> property specifies the graphic's path and file name that you want to have displayed on the button.</ahelp> If you select the graphic file with the <emph>...</emph> button, the path and file name will be automatically included in the text box.</paragraph></section><section id="Section44"><bookmark branch="hid/EXTENSIONS_HID_PROP_HELPTEXT" id="bm_id3151131"/><paragraph role="heading" level="2">Help text</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_HELPTEXT">Provides the option of entering a help text that will be displayed as a tip on the control.</ahelp> The tip shows the text in user mode when the mouse is moved over the control.</paragraph><paragraph role="paragraph">For URL type buttons, the help text appears as the extended tip instead of the URL address entered under URL.</paragraph></section><section id="Section43"><bookmark branch="hid/EXTENSIONS_HID_PROP_HELPURL" id="bm_id3156336"/><paragraph role="heading" level="2">Help URL</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_HELPURL">Specifies a batch label in URL spelling which refers to a help document and which can be called with the help of the control field.</ahelp> The help for the control field help can be opened if the focus is positioned on the control field and the user presses F1.</paragraph></section><section id="Section42"><bookmark branch="hid/EXTENSIONS_HID_PROP_BACKGROUNDCOLOR" id="bm_id3149545"/><paragraph role="heading" level="2">Background color</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_BACKGROUNDCOLOR" visibility="hidden">Sets the background color of the control field.</ahelp> A background color is available for most control fields. If you click on <emph>Background color</emph>, a list will open which enables you to select among various colors. The "Standard" option adopts the system setting. If the desired color is not listed, click the <emph>...</emph> button to define a color in the <link href="text/shared/optionen/01010501.xhp"><emph>Color</emph></link> dialog.</paragraph></section><section id="Section41"><bookmark branch="hid/EXTENSIONS_HID_PROP_HSCROLL" id="bm_id3149895"/><bookmark branch="hid/EXTENSIONS_HID_PROP_VSCROLL" id="bm_id3149517"/><bookmark branch="hid/EXTENSIONS_HID_PROP_SHOW_SCROLLBARS" id="bm_id6053651"/><paragraph role="heading" level="2">Scrollbar</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_HSCROLL" visibility="hidden">Adds the scrollbar type that you specify to a text box.</ahelp> Adds the scrollbar type that you specify to a text box.</paragraph></section><section id="Section78"><bookmark branch="hid/EXTENSIONS_HID_PROP_SPININCREMENT" id="bm_id3022247"/><paragraph role="heading" level="2">Incr./decrement value</paragraph><paragraph role="paragraph"><ahelp hid=".">Determines intervals to add or subtract with each activation of the spin button control.</ahelp></paragraph></section><section id="Section40"><bookmark branch="hid/EXTENSIONS_HID_PROP_VALUESTEP" id="bm_id3150624"/><paragraph role="heading" level="2">Value step</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_VALUESTEP" visibility="hidden">Determines spin button intervals.</ahelp> You can preset the value intervals for numerical and currency spin buttons. Use the up and down arrows of the spin button to increase or decrease the value.</paragraph></section><section id="Section39"><bookmark branch="hid/EXTENSIONS_HID_PROP_STRINGITEMLIST" id="bm_id3153975"/><paragraph role="heading" level="2">List entries</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_STRINGITEMLIST" visibility="hidden">Defines the list entries visible in the document. Open this list and type your text. Use Shift+Enter for a new line. With list and combo boxes, you can define the list entries that will be visible in the document. Open the <emph>List entries</emph> field and type your text.</ahelp> Please note the <link href="text/shared/02/01170100.xhp">tips</link> referring to the keyboard controls.</paragraph><paragraph role="paragraph">The predefined default list entry is entered into the <emph>Default selection combo</emph> box.</paragraph><paragraph role="note">Note that the list entries entered here are only incorporated into the form if, on the <emph>Data</emph> tab under <emph>List Content Type</emph>, the option "Value List" is selected.</paragraph><paragraph role="paragraph">If you do not want the list entries to be written to the database or transmitted to the recipient of the Web form, but rather assigned values that are not visible in the form, you can assign the list entries to other values in a value list. The value list is determined on the <link href="text/shared/02/01170102.xhp"><emph>Data</emph></link> tab. Under <emph>Type of List Contents</emph>, select the option "Value List". Then enter the values under <emph>List Contents</emph> that are to be assigned to the corresponding visible list entries of the form. For the correct assignment, the order in the value list is relevant.</paragraph><paragraph role="note">For HTML documents, a list entry entered on the <emph>General</emph> tab corresponds to the HTML tag <OPTION>; an entry of the value list entered on the <emph>Data</emph> tab under <emph>List Contents</emph> corresponds to the <OPTION VALUE=...> tag.</paragraph></section><section id="Section38"><bookmark branch="hid/EXTENSIONS_HID_PROP_DATEMAX" id="bm_id3154336"/><paragraph role="heading" level="2">Date max</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_DATEMAX" visibility="hidden">Determines a date which can not be exceeded by another value introduced by the user.</ahelp> Determines a date which can not be exceeded by another value introduced by the user.</paragraph></section><section id="Section37"><bookmark branch="hid/EXTENSIONS_HID_PROP_MAXTEXTLEN" id="bm_id3149391"/><paragraph role="heading" level="2">Max text length</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_MAXTEXTLEN" visibility="hidden">Defines the maximum number of characters that the user can enter.</ahelp> For text and combo boxes, you can define the maximum number of characters that the user can enter. If this control field property is uncertain, the default setting will be zero.</paragraph><paragraph role="paragraph">If the control is linked to a database and the text length is to be accepted from the field definition of the database, you must not enter the text length here. The settings are only accepted from the database if the control property was not defined ("Not Defined" state).</paragraph></section><section id="Section36"><bookmark branch="hid/EXTENSIONS_HID_PROP_VALUEMAX" id="bm_id3145145"/><bookmark branch="hid/EXTENSIONS_HID_PROP_EFFECTIVEMAX" id="bm_id3155345"/><bookmark branch="hid/EXTENSIONS_HID_PROP_SPINVALUE_MAX" id="bm_id5229956"/><paragraph role="heading" level="2">Value max</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_EFFECTIVEMAX" visibility="hidden">Defines a value for the control field which can not be exceeded by another value introduced by the user.</ahelp> For numerical and currency fields, you can determine the maximum value that the user can enter.</paragraph></section><section id="Section35"><bookmark branch="hid/EXTENSIONS_HID_PROP_TIMEMAX" id="bm_id3154712"/><paragraph role="heading" level="2">Time max</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_TIMEMAX" visibility="hidden">Determines a time which can not be exceeded by another value introduced by the user.</ahelp> Determines a time which can not be exceeded by another value introduced by the user.</paragraph></section><section id="Section34"><bookmark branch="hid/EXTENSIONS_HID_PROP_MULTISELECTION" id="bm_id3154168"/><paragraph role="heading" level="2">Multiselection</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_MULTISELECTION" visibility="hidden">Allows you to select more than one item in a list box.</ahelp> Allows you to select more than one item in a list box.</paragraph></section><section id="Section33"><bookmark branch="index" id="bm_id4040955"/><bookmark branch="hid/EXTENSIONS_HID_PROP_MULTILINE" id="bm_id3156370"/><bookmark branch="hid/EXTENSIONS_HID_PROP_TEXTTYPE" id="bm_id6511734"/><paragraph role="heading" level="2">Text type</paragraph><paragraph role="paragraph"><ahelp hid="37933">Allows you to use line breaks and formatting in a control field, such as a text box or label. To manually enter a line break, press the Enter key. Select "Multi-line with formatting" to enter formatted text.</ahelp></paragraph><paragraph role="warning">If you select the text type "Multi-line with formatting", you cannot bind this control to a database field.</paragraph><paragraph role="note">This control is named "Multiline input" for a text column inside a table control.</paragraph></section><section id="Section47"><bookmark branch="hid/EXTENSIONS_HID_PROP_WORDBREAK" id="bm_id1313516"/><paragraph role="heading" level="2">Word break</paragraph><paragraph role="paragraph"><ahelp hid=".">Displays text on more than one line.</ahelp> Allows you to use line breaks in a text box, so that you can enter more than one line of text. To manually enter a line break, press the Enter key.</paragraph></section><section id="Section64"><bookmark branch="hid/EXTENSIONS_HID_PROP_TOGGLE" id="bm_id9645680"/><paragraph role="heading" level="2">Toggle</paragraph><paragraph role="paragraph"><ahelp hid=".">Specifies if a Push Button behaves as a Toggle Button. If you set Toggle to "Yes", you can switch between the "selected" and "not selected" control states when you click the button or press the spacebar while the control has the focus. A button in the "selected" state appears "pressed in".</ahelp></paragraph></section><section id="Section65"><bookmark branch="hid/EXTENSIONS_HID_PROP_FOCUSONCLICK" id="bm_id6996978"/><paragraph role="heading" level="2">Take Focus on Click</paragraph><paragraph role="paragraph"><ahelp hid=".">If you set this option to "Yes", the Push Button receives the focus when you click the button.</ahelp></paragraph></section><section id="Section66"><bookmark branch="hid/EXTENSIONS_HID_PROP_HIDEINACTIVESELECTION" id="bm_id9755546"/><paragraph role="heading" level="2">Hide selection</paragraph><paragraph role="paragraph"><ahelp hid="37965">Specifies whether a text selection on a control remains selected when a the focus is no longer on a control.</ahelp> If you set <emph>Hide selection</emph> to "No", the selected text remains selected when the focus is no longer on the control that contains the text.</paragraph></section><section id="Section67"><bookmark branch="hid/EXTENSIONS_HID_PROP_VISUALEFFECT" id="bm_id7896664"/><paragraph role="heading" level="2">Style</paragraph><paragraph role="paragraph"><ahelp hid="37966">Specifies whether Check boxes and Option buttons are displayed in a 3D look (default) or a flat look.</ahelp></paragraph></section><section id="Section68"><bookmark branch="hid/EXTENSIONS_HID_PROP_BORDERCOLOR" id="bm_id6106448"/><paragraph role="heading" level="2">Border color</paragraph><paragraph role="paragraph"><ahelp hid="37967">Specifies the border color for controls that have the Border property set to "flat".</ahelp></paragraph></section><section id="Section79"><bookmark branch="hid/EXTENSIONS_HID_PROP_SYMBOLCOLOR" id="bm_id9707632"/><paragraph role="heading" level="2">Symbol color</paragraph><paragraph role="paragraph"><ahelp hid=".">Specifies the color for symbols on controls, for example the arrows on a scrollbar.</ahelp></paragraph></section><section id="Section32"><bookmark branch="hid/EXTENSIONS_HID_PROP_DATEMIN" id="bm_id3155750"/><paragraph role="heading" level="2">Date min</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_DATEMIN" visibility="hidden">Determines the earliest date that a user can enter.</ahelp> Determines the earliest date that a user can enter.</paragraph></section><section id="Section31"><bookmark branch="hid/EXTENSIONS_HID_PROP_VALUEMIN" id="bm_id3145321"/><bookmark branch="hid/EXTENSIONS_HID_PROP_EFFECTIVEMIN" id="bm_id3147499"/><bookmark branch="hid/EXTENSIONS_HID_PROP_SPINVALUE_MIN" id="bm_id3649403"/><paragraph role="heading" level="2">Value min</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_EFFECTIVEMIN" visibility="hidden">You can determine here a value for the control field to prevent the user from entering a smaller value.</ahelp> For numerical and currency fields you can determine a minimum value to prevent the user from entering a smaller value.</paragraph></section><section id="Section30"><bookmark branch="hid/EXTENSIONS_HID_PROP_TIMEMIN" id="bm_id3148825"/><paragraph role="heading" level="2">Time min</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_TIMEMIN" visibility="hidden">Determines the minimum time that a user can enter.</ahelp> Determines the minimum time that a user can enter.</paragraph></section><section id="Section29"><bookmark branch="hid/EXTENSIONS_HID_PROP_DECIMAL_ACCURACY" id="bm_id3154402"/><paragraph role="heading" level="2">Decimal accuracy</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_DECIMAL_ACCURACY" visibility="hidden">Determines the number of digits displayed to the right of the decimal point.</ahelp> With numerical and currency fields you can determine the number of digits displayed to the right of the decimal point.</paragraph></section><section id="Section28"><bookmark branch="hid/EXTENSIONS_HID_PROP_NAME" id="bm_id3152469"/><paragraph role="heading" level="2">Name</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_NAME" visibility="hidden">On the <emph>Properties</emph> tab page, this option specifies the name for the control field. On the <emph>Form Properties </emph>tab page, this option specifies the name for the form.</ahelp> Each control field and each form has a <emph>Name </emph>property through which it can be identified. The name will appear in the <link href="text/shared/02/01170600.xhp">Form Navigator</link> and, using the name, the control field can be referred to from a macro. The default settings already specify a name which is constructed from using the field's label and number.</paragraph><paragraph role="note">If you work with macros, make sure that the names of the controls are unique.</paragraph><bookmark branch="index" id="bm_id3146325"/><paragraph role="paragraph">The name is also used to group different controls that belong together functionally, such as radio buttons. To do so, give the same name to all members of the group: controls with identical names form a group. Grouped controls can be represented visually by using a <link href="text/shared/02/01170000.xhp">Group Box</link>.</paragraph></section><section id="Section27"><bookmark branch="hid/EXTENSIONS_HID_PROP_NAVIGATIONBAR" id="bm_id3153020"/><paragraph role="heading" level="2">Navigation bar</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_NAVIGATIONBAR" visibility="hidden">Specifies whether to display the navigation bar on the lower border of the table control.</ahelp> Specifies whether to display the navigation bar on the lower border of table controls.</paragraph></section><section id="Section26"><bookmark branch="hid/EXTENSIONS_HID_PROP_READONLY" id="bm_id3151173"/><paragraph role="heading" level="2">Read-only</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_READONLY" visibility="hidden">Determines if the control is read-only (Yes) or if it can be edited (No).</ahelp> The<emph> Read-only </emph>property can be assigned to all controls in which the user can enter text. If you assign the read-only property to an image field which uses graphics from a database, the user will not be able to insert new graphics into the database.</paragraph></section><section id="Section25"><bookmark branch="hid/EXTENSIONS_HID_PROP_BORDER" id="bm_id3154414"/><paragraph role="heading" level="2">Border</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_BORDER" visibility="hidden">Determines if the field's border should be displayed "Without frame", with a "3-D look" or "Flat".</ahelp> With control fields that have a frame, you can determine the border display on the form using the <emph>Border </emph>property. You can select among the "Without frame", "3-D look" or "Flat" options.</paragraph></section><section id="Section24"><bookmark branch="hid/EXTENSIONS_HID_PROP_TABINDEX" id="bm_id3157872"/><paragraph role="heading" level="2">Tab order</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_TABINDEX">The <emph>Tab order</emph> property determines the order in which the controls are focused in the form when you press the Tab key.</ahelp> In a form that contains more than one control, the focus moves to the next control when you press the Tab key. You can specify the order in which the focus changes with an index under <emph>Tab order</emph>.</paragraph><paragraph role="note">The <emph>Tab order</emph> property is not available to <link href="text/shared/02/01170600.xhp">Hidden Controls</link>. If you want, you can also set this property for image buttons and image controls, so that you can select these controls with the Tab key.</paragraph><paragraph role="paragraph">When creating a form, an index is automatically assigned to the control fields that are added to this form; every control field added is assigned an index increased by 1. If you change the index of a control, the indices of the other controls are updated automatically. Elements that cannot be focused (Tabstop = No) are also assigned a value. However, these controls are skipped when using the Tab key.</paragraph><paragraph role="paragraph">You can also easily define the indices of the different controls in the <link href="text/shared/02/01170300.xhp"><emph>Tab Order</emph></link> dialog.</paragraph></section><section id="Section89"><bookmark branch="hid/EXTENSIONS_HID_PROP_WHEEL_BEHAVIOR" id="bm_id0509200912044845"/><paragraph role="heading" level="2">Mouse wheel scroll</paragraph><paragraph role="paragraph"><ahelp hid=".">Sets whether the value changes when the user scrolls a mouse wheel. Never: No change of the value. When focused: (default) The value changes when the control has the focus and the wheel is pointing at the control and gets scrolled. Always: The value changes when the wheel is pointing at the control and gets scrolled, no matter which control has the focus.</ahelp></paragraph></section><section id="Section22"><paragraph role="heading" level="2">Default status</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_DEFAULT_CHECKED">Specifies whether an option or a check box is selected by default.</ahelp></paragraph><paragraph role="paragraph">For a reset type button, you can define the status of the control if the reset button is activated by the user.</paragraph><paragraph role="paragraph">For grouped option fields, the status of the group corresponding to the default setting is defined by the <emph>Default Status</emph> property.</paragraph></section><section id="Section21"><bookmark branch="hid/EXTENSIONS_HID_PROP_DEFAULT_SELECT_SEQ" id="bm_id3147220"/><paragraph role="heading" level="2">Default selection</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_DEFAULT_SELECT_SEQ" visibility="hidden">Specifies the list box entry to mark as the default entry.</ahelp> Specifies the list box entry to mark as the default entry.</paragraph><paragraph role="paragraph">For a Reset type button, the<emph> Default selection</emph> entry defines the status of the list box if the reset button is activated by the user.</paragraph><paragraph role="paragraph">For a List box that contains a value list, you can click the <emph>...</emph> button to open the <emph>Default selection</emph> dialog.</paragraph><paragraph role="paragraph">In the <emph>Default selection</emph> dialog, select the entries that you want to mark as selected when you open the form that contains the list box.</paragraph></section><section id="Section20"><bookmark branch="hid/EXTENSIONS_HID_PROP_DEFAULTVALUE" id="bm_id3153100"/><bookmark branch="hid/EXTENSIONS_HID_PROP_EFFECTIVEDEFAULT" id="bm_id3143231"/><bookmark branch="hid/EXTENSIONS_HID_PROP_DEFAULT_SPINVALUE" id="bm_id4093447"/><paragraph role="heading" level="2">Default value</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_EFFECTIVEDEFAULT">Sets the default value for the control field.</ahelp> For example, the default value will be entered when a form is opened.</paragraph><paragraph role="paragraph">For a Reset type button, the<emph> Default value entry </emph>defines the status of the control if the reset button is activated by the user.</paragraph></section><section id="Section45"><bookmark branch="hid/EXTENSIONS_HID_PROP_DEFAULT_SCROLLVALUE" id="bm_id6967986"/><paragraph role="heading" level="2">Default scroll value</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_DEFAULT_SCROLLVALUE">Sets the default value for the scrollbar.</ahelp></paragraph></section><section id="Section72"><bookmark branch="hid/EXTENSIONS_HID_PROP_SCROLLVALUE_MAX" id="bm_id3148873"/><paragraph role="heading" level="2">Scroll value max.</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_SCROLLVALUE_MAX">Specify the maximum value of a scrollbar control.</ahelp></paragraph></section><section id="Section71"><bookmark branch="hid/EXTENSIONS_HID_PROP_SCROLLVALUE_MIN" id="bm_id6626483"/><paragraph role="heading" level="2">Scroll value min.</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_SCROLLVALUE_MIN">Specify the minimum value of a scrollbar control.</ahelp></paragraph></section><section id="Section80"><bookmark branch="hid/EXTENSIONS_HID_PROP_LINEINCREMENT" id="bm_id6233100"/><paragraph role="heading" level="2">Small change</paragraph><paragraph role="paragraph"><ahelp hid=".">Specify the value to add or subtract when the user clicks the arrow icon on the scrollbar.</ahelp></paragraph></section><section id="Section81"><bookmark branch="hid/EXTENSIONS_HID_PROP_BLOCKINCREMENT" id="bm_id1151463"/><paragraph role="heading" level="2">Large change</paragraph><paragraph role="paragraph"><ahelp hid=".">Specify the value to add or subtract when the user clicks next to the slider on the scrollbar.</ahelp></paragraph></section><section id="Section19"><bookmark branch="hid/EXTENSIONS_HID_PROP_DEFAULT_TIME" id="bm_id3146878"/><paragraph role="heading" level="2">Default time</paragraph><paragraph role="paragraph"><ahelp hid=".">Sets the default time.</ahelp></paragraph></section><section id="Section18"><bookmark branch="hid/EXTENSIONS_HID_PROP_DEFAULT_DATE" id="bm_id3146874"/><paragraph role="heading" level="2">Default date</paragraph><paragraph role="paragraph"><ahelp hid=".">Sets the default date.</ahelp></paragraph></section><section id="Section17"><bookmark branch="hid/EXTENSIONS_HID_PROP_TEXT" id="bm_id8406628"/><paragraph role="heading" level="2">Default text</paragraph><paragraph role="paragraph"><ahelp hid=".">Sets the default text for a text box or a combo box.</ahelp></paragraph></section><section id="Section16"><bookmark branch="hid/EXTENSIONS_HID_PROP_DEFAULT_BUTTON" id="bm_id3156300"/><paragraph role="heading" level="2">Default button</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_DEFAULT_BUTTON" visibility="hidden">The<emph> Default button</emph> property specifies that the corresponding button will be operated when you press the Return key.</ahelp> The<emph> Default button</emph> property specifies that the corresponding button will be operated when you press the Return key. If you open the dialog or form and do not carry out any further action, the button with this property is the default button.</paragraph><paragraph role="note">This property should be assigned only to a single button within the document.</paragraph><paragraph role="paragraph">When using Web page forms, you might come across this property in search masks. These are edit masks that contain a text field and a Submit type button. The search term is entered in the text field and the search is started by activating the button. If the button is defined as the default button, however, simply hit Enter after entering the search term in order to start the search.</paragraph></section><section id="Section15"><bookmark branch="hid/EXTENSIONS_HID_PROP_CURRSYM_POSITION" id="bm_id3150265"/><paragraph role="heading" level="2">Prefix symbol</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_CURRSYM_POSITION">Determines if the currency symbol is displayed before or after the number when using currency fields.</ahelp> The default setting is currency symbols are not prefixed.</paragraph></section><section id="Section14"><bookmark branch="hid/EXTENSIONS_HID_PROP_TABSTOP" id="bm_id3148938"/><paragraph role="heading" level="2">Tabstop</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_TABSTOP">The <emph>Tabstop </emph>property determines if a control field can be selected with the tab key.</ahelp> The following options are available:</paragraph><table><tablerow><tablecell><paragraph role="paragraph">No</paragraph></tablecell><tablecell><paragraph role="paragraph">When using the tab key, focusing skips the control.</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph">Yes</paragraph></tablecell><tablecell><paragraph role="paragraph">The control can be selected with the Tab key.</paragraph></tablecell></tablerow></table></section><section id="Section13"><bookmark branch="hid/EXTENSIONS_HID_PROP_SHOWTHOUSANDSEP" id="bm_id3154931"/><paragraph role="heading" level="2">Thousands separator</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_SHOWTHOUSANDSEP" visibility="hidden">Inserts a thousands separator.</ahelp> With numerical and currency fields you can determine whether thousands separators are used.</paragraph></section><section id="Section12"><bookmark branch="hid/EXTENSIONS_HID_PROP_LABEL" id="bm_id3159212"/><paragraph role="heading" level="2">Label</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_LABEL" visibility="hidden">The Label property sets the label of the control field that is displayed in the form.</ahelp> The Label property sets the label of the control field that is displayed in the form. This property determines the visible label or the column header of the data field in table control forms.</paragraph><paragraph role="paragraph">When you create a new control, the description predefined in the <emph>Name</emph> property is used as the default for labeling the control. The label consists of the control field name and an integer numbering the control (for example, CommandButton1). With the <emph>Title</emph> property, you can assign another description to the control so that the label reflects the function of the control. Change this entry in order to assign an expressive label to the control that is visible to the user.</paragraph><bookmark branch="index" id="bm_id3163820"/><paragraph role="paragraph">To create a multi-line title, open the combo box using the arrow button. You can enter a line break by pressing Shift+<switchinline select="sys"><caseinline select="MAC">Command
</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter.</paragraph><paragraph role="note">The <emph>Title</emph> property is only used for labeling a form element in the interface visible to the user. If you work with macros, note that at runtime, a control is always addressed through the <emph>Name</emph> property.</paragraph></section><section id="Section11"><bookmark branch="hid/EXTENSIONS_HID_PROP_TARGET_URL" id="bm_id3154726"/><paragraph role="heading" level="2">URL</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_TARGET_URL" visibility="hidden">Specifies the URL address that opens when you click an "Open document / web page" button.</ahelp> Enter the URL address for a Open document or web page button type in the <emph>URL</emph> box. The address opens when you click the button.</paragraph><paragraph role="paragraph">If you move the mouse over the button in User mode, the URL appears as the extended tip, provided that no other Help text was entered.</paragraph></section><section id="Section10"><bookmark branch="hid/EXTENSIONS_HID_PROP_CURRENCYSYMBOL" id="bm_id3145154"/><paragraph role="heading" level="2">Currency symbol</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_CURRENCYSYMBOL" visibility="hidden">You can enter a character or a string for the currency symbol.</ahelp> In a currency field, you can pre-define the currency symbol by entering the character or string in the <emph>Currency symbol</emph> property.</paragraph></section><section id="Section9"><bookmark branch="hid/EXTENSIONS_HID_PROP_HIDDEN_VALUE" id="bm_id3156100"/><paragraph role="heading" level="2">Value</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_HIDDEN_VALUE" visibility="hidden">You can enter the data that is inherited by the hidden control.</ahelp> In a <link href="text/shared/02/01170600.xhp">hidden control</link>, under <emph>Value</emph>, you can enter the data which is inherited by the hidden control. This data will be transferred when sending the form.</paragraph></section><section id="Section8"><bookmark branch="hid/EXTENSIONS_HID_PROP_ECHO_CHAR" id="bm_id3148694"/><paragraph role="heading" level="2">Password characters</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_ECHO_CHAR" visibility="hidden">If the text box is used as a password input, enter the ASCII-code of the display character. This character is displayed instead of the characters typed by the user for the password.</ahelp> If the user enters a password, you can determine the characters that will be displayed instead of the characters typed by the user. Under <emph>Password character</emph>, enter the ASCII code of the desired character. You can use the values from 0 to 255.</paragraph><paragraph role="tip">The characters and their ASCII codes can be seen in the <emph>Special Characters</emph> dialog (Insert - Special Character).</paragraph></section><section id="Section7"><bookmark branch="hid/EXTENSIONS_HID_PROP_LITERALMASK" id="bm_id3157547"/><paragraph role="heading" level="2">Literal mask</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_LITERALMASK" visibility="hidden">Defines the literal mask. The literal mask contains the initial values and is always visible after downloading a form.</ahelp> With masked fields you can specify a literal mask. A literal mask contains the initial values of a form, and is always visible after downloading a form. Using a character code for the Edit mask, you can determine the entries that the user can type into the masked field.</paragraph><paragraph role="note">The length of the literal mask should always correspond to the length of the edit mask. If this is not the case, the edit mask is either cut off or filled with blanks up to the length of the edit mask.</paragraph></section><section id="Section6"><bookmark branch="hid/EXTENSIONS_HID_PROP_FONT" id="bm_id3151032"/><paragraph role="heading" level="2">Font</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_FONT" visibility="hidden">Select the font for the text that is in the control field.</ahelp> For control fields which have visible text or titles, select the display font that you want to use. To open the <link href="text/shared/01/05020100.xhp"><emph>Font</emph></link> dialog, click the <emph>...</emph> button. The selected font is used in control fields names and to display data in table control fields.</paragraph></section><section id="Section5"><bookmark branch="hid/EXTENSIONS_HID_PROP_ROWHEIGHT" id="bm_id3160449"/><paragraph role="heading" level="2">Row height</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_ROWHEIGHT" visibility="hidden">Specifies the row height of a table control field.</ahelp> In table controls, enter a value for the row height. If you want, you can enter a value followed by valid measurement unit, for example, 2 cm.</paragraph></section><section id="Section77"><bookmark branch="hid/EXTENSIONS_HID_PROP_LINEEND_FORMAT" id="bm_id396130"/><paragraph role="heading" level="2">Text lines end with</paragraph><paragraph role="paragraph"><ahelp hid=".">For text fields, select the line end code to be used when writing text into a database column.</ahelp></paragraph></section><section id="Section4"><bookmark branch="hid/EXTENSIONS_HID_PROP_TIMEFORMAT" id="bm_id3145181"/><paragraph role="heading" level="2">Time format</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_TIMEFORMAT" visibility="hidden">You can define the desired format for the time display.</ahelp> You can define the desired format for the time display.</paragraph></section><section id="Section3"><bookmark branch="hid/EXTENSIONS_HID_PROP_TAG" id="bm_id3158205"/><paragraph role="heading" level="2">Help text</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_TAG" visibility="hidden">Specifies additional information or a descriptive text for the control field.</ahelp> In each control field you can specify additional information or a descriptive text for the control field. This property helps the programmer to save additional information that can be used in the program code. This field can be used, for example, for variables or other evaluation parameters.</paragraph></section><section id="Section2"><bookmark branch="hid/EXTENSIONS_HID_PROP_FORMATKEY" id="bm_id3157839"/><paragraph role="heading" level="2">Formatting</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_FORMATKEY">Specifies the format code for the control. Click the <emph>...</emph> button to select the format code.</ahelp></paragraph></section><section id="Section69"><bookmark branch="hid/EXTENSIONS_HID_PROP_SCALEIMAGE" id="bm_id1145054"/><paragraph role="heading" level="2">Scale</paragraph><paragraph role="paragraph"><ahelp hid="HID_PROP_SCALEIMAGE">Resizes the image to fit the size of the control.</ahelp></paragraph></section><section id="Section23"><bookmark branch="hid/EXTENSIONS_HID_PROP_SHOW_RECORDACTIONS" id="bm_id7442243"/><paragraph role="heading" level="2">Acting on a record</paragraph><paragraph role="paragraph"><ahelp hid="37930">Specifies to show or hide the action items in a selected Navigation Bar control.</ahelp> Action items are the following: Save record, Undo, New record, Delete record, Refresh.</paragraph></section><section id="Section70"><bookmark branch="hid/EXTENSIONS_HID_PROP_SHOW_POSITION" id="bm_id9985961"/><paragraph role="heading" level="2">Positioning</paragraph><paragraph role="paragraph"><ahelp hid="37928">Specifies to show or hide the positioning items in a selected Navigation Bar control.</ahelp> Positioning items are the following: Record label, Record position, Record count label, Record count.</paragraph></section><section id="Section74"><bookmark branch="hid/EXTENSIONS_HID_PROP_SHOW_NAVIGATION" id="bm_id1122775"/><paragraph role="heading" level="2">Navigation</paragraph><paragraph role="paragraph"><ahelp hid="37929">Specifies to show or hide the navigation items in a selected Navigation Bar control.</ahelp> Navigation items are the following: First record, Previous record, Next record, Last record.</paragraph></section><section id="Section75"><bookmark branch="hid/EXTENSIONS_HID_PROP_SHOW_FILTERSORT" id="bm_id7137363"/><paragraph role="heading" level="2">Filtering / Sorting</paragraph><paragraph role="paragraph"><ahelp hid="37931">Specifies to show or hide the filtering and sorting items in a selected Navigation Bar control.</ahelp> Filtering and sorting items are the following: Sort ascending, Sort descending, Sort, Automatic filter, Default filter, Apply filter, Reset filter/sort.</paragraph></section><section id="Section76"><bookmark branch="hid/EXTENSIONS_HID_PROP_ICONSIZE" id="bm_id7815790"/><paragraph role="heading" level="2">Icon Size</paragraph><paragraph role="paragraph"><ahelp hid="37927">Specifies whether the icons in a selected Navigation Bar should be small or large.</ahelp></paragraph></section><section id="Section73"><bookmark branch="hid/EXTENSIONS_HID_PROP_ENABLE_VISIBLE" id="bm_id7815890"/><paragraph role="heading" level="2">Visible</paragraph><paragraph role="paragraph"><ahelp hid=".">Defines whether the control will be visible in live mode. In design mode, the control is always visible.</ahelp></paragraph><paragraph role="paragraph">Note that if this property is set to "Yes" (the default), this does not necessarily mean the control will really appear on the screen. Additional constraints are applied when calculating a control's effective visibility. For instance, a control placed in a hidden section in Writer will never be visible at all, until at least the section itself becomes visible.</paragraph><paragraph role="paragraph">If the property is set to "No", then the control will always be hidden in live mode.</paragraph><paragraph role="paragraph">Older OpenOffice.org versions up to 3.1 will silently ignore this property when reading documents which make use of it.</paragraph></section><section id="Section82"><bookmark branch="hid/EXTENSIONS_HID_PROP_VISIBLESIZE" id="bm_id5840937"/><paragraph role="heading" level="2">Visible size</paragraph><paragraph role="paragraph"><ahelp hid=".">Specifies the size of scrollbar thumb in "value units". A value of ("Scroll value max." minus "Scroll value min." ) / 2 would result in a thumb which occupies half of the background area.</ahelp></paragraph><paragraph role="paragraph">If set to 0, then the thumb's width will equal its height.</paragraph></section><section id="Section83"><bookmark branch="hid/EXTENSIONS_HID_PROP_ORIENTATION" id="bm_id4076967"/><paragraph role="heading" level="2">Orientation</paragraph><paragraph role="paragraph"><ahelp hid=".">Specifies the horizontal or vertical orientation for a scrollbar or spin button.</ahelp></paragraph></section></sort></body></helpdocument>
PK
%w�X�ގ � text/shared/02/20030000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Zoom</title><filename>/text/shared/02/20030000.xhp</filename></topic></meta><body><section id="maszstab"><bookmark branch="index" id="bm_id3155619"/><bookmark branch="hid/.uno:StateZoom" id="bm_id3165732"/><bookmark branch="hid/.uno:StateZoom" id="bm_id3149748"/><paragraph role="heading" level="1"><link href="text/shared/02/20030000.xhp">Zoom</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:StateZoom">Specifies the current page display zoom factor.</ahelp></paragraph></section><paragraph role="paragraph">Double-clicking this field opens the <link href="text/shared/01/03010000.xhp">Zoom</link> dialog, where you can change the current zoom factor.</paragraph><paragraph role="paragraph">Open the context menu on this field to see a selection of available zoom factors.</paragraph></body></helpdocument>
PK
%w�XVb�R� � text/shared/02/03140000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Line Style</title><filename>/text/shared/02/03140000.xhp</filename></topic></meta><body><section id="linienstil"><bookmark branch="hid/.uno:LineStyle" id="bm_id3154545"/><paragraph role="heading" level="1"><link href="text/shared/02/03140000.xhp">Line Style</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:LineStyle">Click this icon to open the <emph>Line Style</emph> toolbar, where you can modify the border line style.</ahelp></paragraph></section><paragraph role="paragraph">This border can be the border of a frame, graphic or table. The <emph>Line Style</emph> icon will only be visible if a graphic, table, chart object or frame has been selected.</paragraph><section id="sylinienstil"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_linestyle.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Line Style</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph">For more information, see the <link href="text/shared/01/05030500.xhp">Borders</link> section of the Help.</paragraph></body></helpdocument>
PK
%w�X�� text/shared/02/01170103.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Events</title><filename>/text/shared/02/01170103.xhp</filename></topic></meta><body><section id="ereignisse"><bookmark branch="index" id="bm_id3148643"/><paragraph role="heading" level="1"><link href="text/shared/02/01170103.xhp">Events</link></paragraph><paragraph role="paragraph">On the<emph> Events </emph>tab page you can link macros to events that occur in a form's control fields.</paragraph></section><paragraph role="paragraph">When the event occurs, the linked macro will be called. To assign a macro to an event, press the <emph>...</emph> button. An <switchinline select="appl"><caseinline select="WRITER"><link href="text/swriter/01/05060700.xhp">Assign Macro</link></caseinline><defaultinline>dialog</defaultinline></switchinline> opens.</paragraph><section id="howtoget"><embed href="text/shared/00/00040501.xhp#controleigenschaftenereignisse"/></section><paragraph role="paragraph">Depending on the control, different events are available. Only the available events for the selected control and context are listed on the <emph>Events</emph> tab page. The following events are defined:</paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_APPROVEACTIONPERFORMED" id="bm_id3153252"/><paragraph role="heading" level="2">Approve action</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_APPROVEACTIONPERFORMED">This event takes place before an action is triggered by clicking the control.</ahelp> For example, clicking a "Submit" button initiates a send action; however, the actual "send" process is started only when the <emph>When initiating</emph> event occurs. The <emph>Approve action</emph> event allows you to kill the process. If the linked method sends back FALSE, <emph>When initiating</emph> will not be executed.</paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_ACTIONPERFORMED" id="bm_id3155923"/><paragraph role="heading" level="2">Execute action</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_ACTIONPERFORMED">The <emph>Execute action</emph> event occurs when an action is started.</ahelp> For example, if you have a "Submit" button in your form, the send process represents the action to be initiated.</paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_CHANGED" id="bm_id3154924"/><paragraph role="heading" level="2">Changed</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_CHANGED">The<emph> Changed </emph>event takes place when the control loses the focus and the content of the control has changed since it lost the focus.</ahelp></paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_TEXTCHANGED" id="bm_id3147084"/><paragraph role="heading" level="2">Text modified</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_TEXTCHANGED">The<emph> Text modified </emph>event takes place if you enter or modify a text in an input field.</ahelp></paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_ITEMSTATECHANGED" id="bm_id3154910"/><paragraph role="heading" level="2">Item status changed</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_ITEMSTATECHANGED" visibility="hidden">The<emph> Item status changed </emph>event takes place if the status of the control field has changed.</ahelp> The<emph> Item status changed</emph> event takes place if he status of the control field has changed.</paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_FOCUSGAINED" id="bm_id3158407"/><paragraph role="heading" level="2">When receiving focus</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_FOCUSGAINED">The<emph> When receiving focus </emph>event takes place if a control field receives the focus.</ahelp></paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_FOCUSLOST" id="bm_id3154684"/><paragraph role="heading" level="2">When losing focus</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_FOCUSLOST">The <emph>When losing focus</emph> event takes place if a control field loses the focus.</ahelp></paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_KEYTYPED" id="bm_id3145787"/><paragraph role="heading" level="2">Key pressed</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_KEYTYPED">The <emph>Key pressed </emph>event occurs when the user presses any key while the control has the focus.</ahelp> This event may be linked to a macro for checking entries.</paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_KEYUP" id="bm_id3145264"/><paragraph role="heading" level="2">Key released</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_KEYUP">The<emph> Key released </emph>event occurs when the user releases any key while the control has the focus.</ahelp></paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_MOUSEENTERED" id="bm_id3155368"/><paragraph role="heading" level="2">Mouse inside</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_MOUSEENTERED">The<emph> Mouse inside </emph>event takes place if the mouse is inside the control field.</ahelp></paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_MOUSEDRAGGED" id="bm_id3159180"/><paragraph role="heading" level="2">Mouse moved while key pressed</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_MOUSEDRAGGED">The<emph> Mouse moved while key pressed </emph>event takes place when the mouse is dragged while a key is pressed.</ahelp> An example is when, during drag-and-drop, an additional key determines the mode (move or copy).</paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_MOUSEMOVED" id="bm_id3147443"/><paragraph role="heading" level="2">Mouse moved</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_MOUSEMOVED">The<emph> Mouse moved </emph>event occurs if the mouse moves over the control.</ahelp></paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_MOUSEPRESSED" id="bm_id3145366"/><paragraph role="heading" level="2">Mouse button pressed</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_MOUSEPRESSED">The<emph> Mouse button pressed </emph>event occurs if the mouse button is pressed while the mouse pointer is on the control.</ahelp></paragraph><paragraph role="note">Note that this event is also used for notifying requests for a popup context menu on the control.</paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_MOUSERELEASED" id="bm_id3144766"/><paragraph role="heading" level="2">Mouse button released</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_MOUSERELEASED">The<emph> Mouse button released </emph>event occurs if the mouse button is released while the mouse pointer is on the control.</ahelp></paragraph><bookmark branch="hid/EXTENSIONS_HID_EVT_MOUSEEXITED" id="bm_id3150094"/><paragraph role="heading" level="2">Mouse outside</paragraph><paragraph role="paragraph"><ahelp hid="HID_EVT_MOUSEEXITED">The<emph> Mouse outside </emph>event takes place when the mouse is outside the control field.</ahelp></paragraph><embed href="text/shared/02/01170202.xhp#reset_update"/></body></helpdocument>
PK
%w�X�S<�$ $ text/shared/02/01230000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Styles and Formatting</title><filename>/text/shared/02/01230000.xhp</filename></topic></meta><body><section id="stylist"><bookmark branch="hid/.uno:DesignerDialog" id="bm_id5100462"/><bookmark branch="hid/.uno:DesignerDialog" id="bm_id3154894"/><paragraph role="heading" level="1"><link href="text/shared/02/01230000.xhp">Styles and Formatting</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DesignerDialog">Specifies whether to show or hide the Styles and Formatting window, which is where you can assign and organize Styles.</ahelp></paragraph></section><paragraph role="paragraph">Each $[officename] application has its own Styles and Formatting window. Hence there are separate windows for <switchinline select="appl"><caseinline select="WRITER"><link href="text/swriter/01/05140000.xhp">text documents</link></caseinline><defaultinline>text documents</defaultinline></switchinline>, for <switchinline select="appl"><caseinline select="CALC"><link href="text/scalc/01/05100000.xhp">spreadsheets</link></caseinline><defaultinline>spreadsheets</defaultinline></switchinline> and for <switchinline select="appl"><caseinline select="IMPRESS"><link href="text/simpress/01/05100000.xhp">presentations/drawing documents</link></caseinline><caseinline select="DRAW"><link href="text/simpress/01/05100000.xhp">presentations/drawing documents</link></caseinline><defaultinline>presentations/drawing documents</defaultinline></switchinline>.</paragraph><section id="systylist"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_designerdialog.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Styles and Formatting</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X��i� � text/shared/02/24040000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Green</title><filename>/text/shared/02/24040000.xhp</filename></topic></meta><body><section id="gruenanteil"><bookmark branch="hid/.uno:GrafGreen" id="bm_id4972033"/><bookmark branch="hid/.uno:GrafGreen" id="bm_id3154094"/><paragraph role="heading" level="1"><link href="text/shared/02/24040000.xhp">Green</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:GrafGreen">Specifies the proportion of green RGB color components for the selected graphic object.</ahelp> Values from -100% (no green) to +100% (full green) are possible.</paragraph></section><section id="sygruenanteil"><table><tablerow><tablecell><paragraph role="paragraph"><image src="res/sc10866.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Green</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X%/\ text/shared/02/18030000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Automatic Spell Checking On/Off</title><filename>/text/shared/02/18030000.xhp</filename></topic></meta><body><section id="pruefung"><paragraph role="heading" level="1"><link href="text/shared/02/18030000.xhp">Automatic Spell Checking On/Off</link></paragraph><embed href="text/shared/optionen/01010400.xhp#automatisch"/></section><section id="sypruefung"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_spellonline.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Automatic Spell Checking On/Off</paragraph></tablecell></tablerow></table></section><embed href="text/shared/optionen/01010400.xhp#automatischweiter"/></body></helpdocument>
PK
%w�Xeupݽ � text/shared/02/01171300.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Snap to Grid</title><filename>/text/shared/02/01171300.xhp</filename></topic></meta><body><paragraph role="heading" level="1"><link href="text/shared/02/01171300.xhp">Snap to Grid</link></paragraph><paragraph role="paragraph"><ahelp hid=".">Specifies whether to move frames, drawing elements, and controls only between grid points.</ahelp></paragraph><section id="syrafang"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_griduse.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Snap to Grid</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X�a�]� � text/shared/02/04210000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Optimize Size</title><filename>/text/shared/02/04210000.xhp</filename></topic></meta><body><section id="optimieren"><bookmark branch="hid/.uno:OptimizeTable" id="bm_id6810577"/><bookmark branch="hid/.uno:OptimizeTable" id="bm_id3149292"/><paragraph role="heading" level="1"><link href="text/shared/02/04210000.xhp">Optimize Size</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:OptimizeTable">Opens a toolbar that contains functions for optimizing the rows and columns in a table.</ahelp></paragraph></section><section id="syoptimieren"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_optimizetable.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Optimize Size</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph">You can select from the following functions:</paragraph><embed href="text/shared/01/05120600.xhp#gleichverteilen"/><embed href="text/shared/01/05120600.xhp#syverteilentext"/><embed href="text/shared/01/05110600m.xhp#gleichverteilen"/><embed href="text/shared/01/05110600m.xhp#syverteilenzeile"/><switch select="appl"><case select="WRITER"><paragraph role="heading" level="2"><link href="text/swriter/01/05110200.xhp">Optimal Height</link></paragraph><embed href="text/swriter/01/05110200.xhp#zeilenhoehetext"/><embed href="text/swriter/00/00000405.xhp#syoptimalzeile"/><paragraph role="heading" level="2"><link href="text/swriter/01/05120200.xhp">Optimal Column Width</link></paragraph><embed href="text/swriter/01/05120200.xhp#spaltenbreitetext"/><embed href="text/swriter/00/00000405.xhp#syoptimalspalte"/></case></switch></body></helpdocument>
PK
%w�X~}��� � text/shared/02/01170802.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Table Element Wizard: Field Selection</title><filename>/text/shared/02/01170802.xhp</filename></topic></meta><body><section id="seite2"><bookmark branch="hid/modules/sabpilot/ui/contentfieldpage/FieldSelectionPage" id="bm_id3150808"/><paragraph role="heading" level="1"><link href="text/shared/02/01170802.xhp">Table Element Wizard: Field Selection</link></paragraph><paragraph role="paragraph">Specifies which fields in the table control field should be displayed.</paragraph></section><section id="howtoget"><embed href="text/shared/00/00040501.xhp#aupitab2"/></section><embed href="text/shared/autopi/01090100.xhp#vorhandenefelder"/><embed href="text/shared/autopi/01090100.xhp#uebernehmen"/><embed href="text/shared/autopi/01090100.xhp#uebernehmealle"/><embed href="text/shared/autopi/01090100.xhp#entfernen"/><embed href="text/shared/autopi/01090100.xhp#entfernealle"/><paragraph role="heading" level="2">Selected Fields</paragraph><paragraph role="paragraph"><ahelp hid="modules/sabpilot/ui/contentfieldpage/selectfield">Displays the data fields that are accepted into the form field.</ahelp></paragraph></body></helpdocument>
PK
%w�X� �� text/shared/02/01170200.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Form Properties</title><filename>/text/shared/02/01170200.xhp</filename></topic></meta><body><section id="formular"><bookmark branch="index" id="bm_id3147285"/><bookmark branch="hid/.uno:FormProperties" id="bm_id1953557"/><bookmark branch="hid/.uno:FormProperties" id="bm_id3145669"/><paragraph role="heading" level="1"><link href="text/shared/02/01170200.xhp">Form Properties</link></paragraph><paragraph role="paragraph"><variable id="form"><ahelp hid=".uno:FormProperties" visibility="visible">In this dialog you can specify, among others, the data source and the events for the whole form.</ahelp></variable></paragraph></section><section id="howtoget"><embed href="text/shared/00/00040501.xhp#formulareigenschaften"/></section><embed href="text/shared/02/01170100.xhp#spezialfelder"/><embed href="text/shared/02/01170201.xhp#allgemein"/><embed href="text/shared/02/01170203.xhp#daten"/><embed href="text/shared/02/01170202.xhp#ereignisse"/></body></helpdocument>
PK
%w�X���� text/shared/02/06120000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Bullets On/Off</title><filename>/text/shared/02/06120000.xhp</filename></topic></meta><body><section id="aufzaehlung"><bookmark branch="hid/.uno:DefaultBullet" id="bm_id5921827"/><bookmark branch="hid/.uno:DefaultBullet" id="bm_id3151100"/><paragraph role="heading" level="1"><link href="text/shared/02/06120000.xhp">Bullets On/Off</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DefaultBullet">Assigns bullet points to the selected paragraphs, or removes them from bulleted paragraphs.</ahelp></paragraph></section><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER">Bullet options such as type and position are defined in the <link href="text/shared/01/06050000.xhp"><emph>Bullets and Numbering</emph></link> dialog. To open this dialog, click the <emph>Bullets and Numbering</emph> icon on the <link href="text/swriter/main0206.xhp">Bullets and Numbering Bar</link></caseinline></switchinline></paragraph><paragraph role="paragraph"><switchinline select="appl"><caseinline select="IMPRESS">Bullet options such as type and position are defined in the <link href="text/shared/01/06050000.xhp">Bullets and Numbering</link> dialog. To open this dialog, click the <emph>Bullets and Numbering</emph> icon on the <emph>Text Formatting</emph> Bar.
</caseinline></switchinline></paragraph><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER">In the <link href="text/swriter/01/03120000.xhp">Web Layout</link>, some numbering/bullet options are not available.
</caseinline></switchinline></paragraph><paragraph role="paragraph"><switchinline select="appl"><caseinline select="IMPRESS">The distance between the text and the left text frame and the position of the bullets can be determined in the dialog under <link href="text/shared/01/05030100.xhp"><emph>Format - Paragraph</emph></link> by entering the left indent and the first-line indent.
</caseinline></switchinline></paragraph><section id="syaufzaehlung"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_defaultbullet.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Bullets On/Off</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X��� text/shared/02/08010000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Document Information</title><filename>/text/shared/02/08010000.xhp</filename></topic></meta><body><section id="dokumentinformationen"><bookmark branch="hid/.uno:StatusGetTitle" id="bm_id8948819"/><bookmark branch="hid/.uno:StatusGetTitle" id="bm_id3149991"/><paragraph role="heading" level="1"><link href="text/shared/02/08010000.xhp">Document Information</link></paragraph><paragraph role="paragraph"><ahelp visibility="visible" hid=".uno:StatusGetTitle">Displays information about the active <item type="productname">%PRODUCTNAME</item> Basic document.</ahelp> The names of the document, the library, and the module are displayed, separated by dots.</paragraph></section></body></helpdocument>
PK
%w�X���y y text/shared/02/24050000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Blue</title><filename>/text/shared/02/24050000.xhp</filename></topic></meta><body><section id="blauanteil"><bookmark branch="hid/.uno:GrafBlue" id="bm_id5123550"/><bookmark branch="hid/.uno:GrafBlue" id="bm_id3154682"/><paragraph role="heading" level="1"><link href="text/shared/02/24050000.xhp">Blue</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:GrafBlue">Specifies the proportion of blue RGB color components for the selected graphic.</ahelp> Values from -100% (no blue) to +100% (full blue) are possible.</paragraph></section><section id="syblauanteil"><table><tablerow><tablecell><paragraph role="paragraph"><image src="res/sc10867.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Blue</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X���g� � text/shared/02/02030000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Font Size</title><filename>/text/shared/02/02030000.xhp</filename></topic></meta><body><section id="schriftgroesse"><bookmark branch="hid/.uno:FontHeight" id="bm_id3154545"/><paragraph role="heading" level="1"><link href="text/shared/02/02030000.xhp">Font Size</link></paragraph><paragraph role="paragraph"><variable id="schriftgroessetext"><ahelp hid=".uno:FontHeight" visibility="visible">Allows you to choose between different font sizes from the list, or to enter a size manually.</ahelp></variable></paragraph></section><section id="syschriftgroesse"><switch select="appl"><case select="CALC"><table><tablerow><tablecell><paragraph role="paragraph"><image src="res/helpimg/swh00056.png" localize="true"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Font Size</paragraph></tablecell></tablerow></table></case><default><table><tablerow><tablecell><paragraph role="paragraph"><image src="res/helpimg/swh00056.png" localize="true"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Font Size</paragraph></tablecell></tablerow></table></default></switch></section></body></helpdocument>
PK
%w�X��D�� � text/shared/02/01170003.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Special Tips for Date Fields</title><filename>/text/shared/02/01170003.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3150445"/><paragraph role="heading" level="1">Special Tips for Date Fields</paragraph><paragraph role="paragraph">When you enter a year using two digits, the corresponding four digit value is determined by a setting in <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - $[officename] - General</emph>. For example, if 1935 is set as the lower limiting value and you enter 34 as a date value, then the result is 2034 instead of 1934.</paragraph><paragraph role="paragraph">The pre-set limit value will be saved for each document.</paragraph><embed href="text/shared/optionen/01010600.xhp#jahreszahlen"/></body></helpdocument>
PK
%w�X�~ ~ text/shared/02/07090000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Export Directly as PDF</title><filename>/text/shared/02/07090000.xhp</filename></topic></meta><body><section id="exportpdf"><bookmark branch="hid/.uno:ExportDirectToPDF" id="bm_id4234075"/><bookmark branch="hid/.uno:ExportDirectToPDF" id="bm_id3154545"/><paragraph role="heading" level="1"><link href="text/shared/02/07090000.xhp">Export Directly as PDF</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:ExportDirectToPDF" visibility="visible">Exports the current document directly as PDF. No settings dialog is shown.</ahelp></paragraph></section><embed href="text/shared/00/00000401.xhp#syexportpdf"/><section id="relatedtopics"><embed href="text/shared/01/ref_pdf_export.xhp#ref_pdf_export"/><embed href="text/shared/01/ref_pdf_send_as.xhp#ref_pdf_send_as"/></section></body></helpdocument>
PK
%w�X� � text/shared/02/20020000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Current Page Style</title><filename>/text/shared/02/20020000.xhp</filename></topic></meta><body><section id="aktuelleseitenvorlage"><bookmark branch="index" id="bm_id3083278"/><bookmark branch="hid/.uno:PageStyleName" id="bm_id5848088"/><bookmark branch="hid/.uno:PageStyleName" id="bm_id3155069"/><bookmark branch="hid/.uno:StatusPageStyle" id="bm_id3325105"/><bookmark branch="hid/.uno:StatusPageStyle" id="bm_id3154840"/><bookmark branch="hid/.uno:LayoutStatus" id="bm_id2005580"/><bookmark branch="hid/.uno:LayoutStatus" id="bm_id3155934"/><paragraph role="heading" level="1"><link href="text/shared/02/20020000.xhp">Current Page Style</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:LayoutStatus">Displays the current Page Style. Double-click to edit the style, right-click to select another style.</ahelp></paragraph></section><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER">Double-click the<emph> Page Style field </emph>to open the <link href="text/swriter/01/05040000.xhp">Page Style</link> dialog, in which you can edit the style for the current page. In the context menu of this field, you can apply a Page Style.
</caseinline></switchinline></paragraph><paragraph role="paragraph"><switchinline select="appl"><caseinline select="CALC">Double-click the <emph>Page Style</emph> field to open the <link href="text/scalc/01/05070000.xhp">Page Style</link> dialog, in which you can edit the style for the current page.
</caseinline></switchinline></paragraph><paragraph role="paragraph"><switchinline select="appl"><caseinline select="IMPRESS">Double-click this field to open the <link href="text/simpress/01/05120000.xhp">Slide Design</link> dialog in which you can select the style for the current slide. You can select a different paper format or background.
</caseinline></switchinline></paragraph><paragraph role="paragraph"><switchinline select="appl"><caseinline select="DRAW">Double-click this field to open the <link href="text/simpress/01/05120000.xhp">Slide Design</link> dialog in which you select the style for the current page. You can select a different paper format or background.
</caseinline></switchinline></paragraph></body></helpdocument>
PK
%w�X;��2 2 text/shared/02/14020000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Clear query</title><filename>/text/shared/02/14020000.xhp</filename></topic></meta><body><section id="abfrageleeren"><bookmark branch="hid/.uno:DBClearQuery" id="bm_id3147000"/><paragraph role="heading" level="1"><link href="text/shared/02/14020000.xhp">Clear query</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DBClearQuery" visibility="visible">Clears the query and removes all tables from the design window.</ahelp></paragraph></section><section id="syabfrageleeren"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_dbclearquery.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Clear query</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X�͚U U text/shared/02/01170002.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Special properties of a formatted field</title><filename>/text/shared/02/01170002.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3150774"/><paragraph role="heading" level="1">Special properties of a formatted field</paragraph><paragraph role="paragraph"><emph>Formatting</emph>: You can set the <emph>Formatting </emph>property by clicking the <emph>... </emph>button in the <emph>Formatting</emph> line of the <emph>Properties: Formatted Field</emph> dialog. The <emph>Number Format</emph> dialog appears.</paragraph><paragraph role="paragraph">If the formatted field is connected to the text field of a database, the entries in this field will be treated as text. If the formatted field is connected to a field of the database that can be displayed as a number, the input is treated as numbers. The date and time are also handled internally as numbers.</paragraph><paragraph role="paragraph"><emph>Min. value</emph> and <emph>Max. value</emph>: You can enter the minimum and maximum numeric value for a formatted field. The min and max values determine the output of existing data (Example: Min. value is 5, the connected database field contains the integer value 3. The output is 5, but the value in the database is not modified) and the input of new data (Example: Max. value is 10 and you enter 20. The input is corrected and 10 is written in the database). If the fields are not filled in for <emph>Min. value </emph>and <emph>Max. value</emph>, no limits will be applied. For formatted fields that are connected to a database text field, these two values and the <emph>Default value</emph> do not apply.</paragraph><paragraph role="paragraph"><emph>Default value</emph>: This value is set for new records as the default value.</paragraph></body></helpdocument>
PK
%w�X��"� � text/shared/02/12070000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Insert Database Columns</title><filename>/text/shared/02/12070000.xhp</filename></topic></meta><body><bookmark branch="hid/.uno:SbaBrwInsert" id="bm_id6269470"/><bookmark branch="hid/.uno:SbaBrwInsert" id="bm_id3156183"/><paragraph role="heading" level="1">Insert Database Columns</paragraph><paragraph role="paragraph"><ahelp hid=".uno:SbaBrwInsert"><variable id="datenintext">Inserts all fields of the marked record into the current document at the cursor position.
</variable></ahelp> The icon is only visible if the current document is a text document or a spreadsheet.</paragraph><section id="sydatenintext"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_sbabrwinsert.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Data to Text</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph"><switchinline select="appl"><caseinline select="CALC">In the data source browser, select the record that you want to insert into the document and then click the <emph>Data to Text</emph> icon. The record is inserted in the document at the cursor position, with the contents of each individual field of the record copied to a table column. You can also select multiple records and transfer them into the document by clicking the <emph>Data to Text </emph>icon. Each individual record is then written to a new row.
</caseinline></switchinline></paragraph><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER">In the data source browser, select the records that you want to insert into the document and then click the <emph>Data to Text</emph> icon, or drag-and-drop data from the data source browser into the document. This opens the <emph>Insert Database Columns </emph>dialog. Select whether the data should be inserted as a <link href="text/shared/02/12070100.xhp">table</link>, as <link href="text/shared/02/12070200.xhp">fields</link> or as <link href="text/shared/02/12070300.xhp">text</link>.
</caseinline></switchinline></paragraph><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER">The preferences you set in the<emph> Insert Database Columns </emph>dialog are saved and will be active the next time the dialog is called. This save process is independent of the database and can record the preferences for a maximum of 5 databases.
</caseinline></switchinline></paragraph><paragraph role="paragraph"><switchinline select="appl"><caseinline select="WRITER">If data is inserted into the document as a table, the table properties are not saved along with the data in the document. If you select the <emph>AutoFormat</emph> function for formatting the table, $[officename] will note the name of the format template. This template will then be used automatically if you insert data as a table again, unless the preferences have been changed.
</caseinline></switchinline></paragraph></body></helpdocument>
PK
%w�Xc��'V V text/shared/02/14020200.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Switch Design View On / Off</title><filename>/text/shared/02/14020200.xhp</filename></topic></meta><body><section id="designansicht"><bookmark branch="hid/.uno:DBChangeDesignMode" id="bm_id3151262"/><paragraph role="heading" level="1"><link href="text/shared/02/14020200.xhp">Switch Design View On / Off</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DBChangeDesignMode">Displays the design view or the SQL view of the query.</ahelp></paragraph></section><section id="sydesignansicht"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_dbchangedesignmode.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Switch Design View On / Off</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X<Lҋ � text/shared/02/01171400.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Helplines While Moving</title><filename>/text/shared/02/01171400.xhp</filename></topic></meta><body><paragraph role="heading" level="1">Helplines While Moving</paragraph><embed href="text/shared/optionen/01070100.xhp#verschieb"/><embed href="text/shared/optionen/01070100.xhp#vertext"/><section id="syhline"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_helplinesmove.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Helplines While Moving</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X��s�� � text/shared/02/blockarrows.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Block Arrows</title><filename>/text/shared/02/blockarrows.xhp</filename></topic></meta><body><section id="blockarrows"><bookmark branch="hid/.uno:ArrowShapes" id="bm_id2847514"/><bookmark branch="hid/.uno:ArrowShapes" id="bm_id943327"/><paragraph role="heading" level="1"><link href="text/shared/02/blockarrows.xhp">Block Arrows</link></paragraph><paragraph role="paragraph"><ahelp hid=".">Opens the Block Arrows toolbar from which you can insert graphics into your document.</ahelp></paragraph></section><section id="howtoget"><embed href="text/shared/00/00000404.xhp#syblockarrows"/></section><bookmark branch="hid/.uno:ArrowShapes.left-arrow" id="bm_id1811578"/><bookmark branch="hid/.uno:ArrowShapes.right-arrow" id="bm_id9935911"/><bookmark branch="hid/.uno:ArrowShapes.up-arrow" id="bm_id4753868"/><bookmark branch="hid/.uno:ArrowShapes.down-arrow" id="bm_id4744407"/><bookmark branch="hid/.uno:ArrowShapes.left-right-arrow" id="bm_id6054261"/><bookmark branch="hid/.uno:ArrowShapes.up-down-arrow" id="bm_id2744224"/><bookmark branch="hid/.uno:ArrowShapes.up-right-arrow" id="bm_id9631946"/><bookmark branch="hid/.uno:ArrowShapes.up-right-down-arrow" id="bm_id8774071"/><bookmark branch="hid/.uno:ArrowShapes.quad-arrow" id="bm_id3334757"/><bookmark branch="hid/.uno:ArrowShapes.corner-right-arrow" id="bm_id1479842"/><bookmark branch="hid/.uno:ArrowShapes.split-arrow" id="bm_id4281746"/><bookmark branch="hid/.uno:ArrowShapes.striped-right-arrow" id="bm_id7469100"/><bookmark branch="hid/.uno:ArrowShapes.notched-right-arrow" id="bm_id1883907"/><bookmark branch="hid/.uno:ArrowShapes.pentagon-right" id="bm_id4129459"/><bookmark branch="hid/.uno:ArrowShapes.chevron" id="bm_id1279946"/><bookmark branch="hid/.uno:ArrowShapes.right-arrow-callout" id="bm_id2808618"/><bookmark branch="hid/.uno:ArrowShapes.left-arrow-callout" id="bm_id6133610"/><bookmark branch="hid/.uno:ArrowShapes.up-arrow-callout" id="bm_id1405072"/><bookmark branch="hid/.uno:ArrowShapes.down-arrow-callout" id="bm_id8649555"/><bookmark branch="hid/.uno:ArrowShapes.left-right-arrow-callout" id="bm_id8895229"/><bookmark branch="hid/.uno:ArrowShapes.up-down--arrow-callout" id="bm_id324716"/><bookmark branch="hid/.uno:ArrowShapes.up-right-arrow-callout" id="bm_id1066927"/><bookmark branch="hid/.uno:ArrowShapes.quad-arrow-callout" id="bm_id2419202"/><bookmark branch="hid/.uno:ArrowShapes.circular-arrow" id="bm_id7043671"/><bookmark branch="hid/.uno:ArrowShapes.split-round-arrow" id="bm_id2651448"/><bookmark branch="hid/.uno:ArrowShapes.s-sharped-arrow" id="bm_id3717154"/><paragraph role="paragraph"><ahelp hid=".">Click an icon from the Block Arrows toolbar, then drag in the document to draw the shape.</ahelp></paragraph><paragraph role="note">Some shapes have a special handle which you can drag to change properties of the shape. The mouse pointer changes to a hand symbol over these special handles.</paragraph></body></helpdocument>
PK
%w�Xe��U| | text/shared/02/03110000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Increase Spacing</title><filename>/text/shared/02/03110000.xhp</filename></topic></meta><body><section id="abstanderhoehen"><bookmark branch="hid/.uno:ParaspaceIncrease" id="bm_id7509975"/><bookmark branch="hid/.uno:ParaspaceIncrease" id="bm_id3150445"/><paragraph role="heading" level="1"><link href="text/shared/02/03110000.xhp">Increase Spacing</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:ParaspaceIncrease">Click the<emph> Increase Spacing </emph>icon to increase the paragraph spacing above the selected paragraph.</ahelp></paragraph></section><section id="syabstanderhoehen"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_paraspaceincrease.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Increase Spacing</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph">You can make additional adjustments to the spacing by selecting <link href="text/shared/01/05030100.xhp"><emph>Format - Paragraph - Indents & Spacing</emph></link></paragraph></body></helpdocument>
PK
%w�X�jZ Z text/shared/02/14060000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Alias</title><filename>/text/shared/02/14060000.xhp</filename></topic></meta><body><section id="aliasname"><bookmark branch="hid/.uno:DBViewAliases" id="bm_id3151299"/><paragraph role="heading" level="1"><link href="text/shared/02/14060000.xhp">Alias</link></paragraph><paragraph role="paragraph"><ahelp visibility="visible" hid=".uno:DBViewAliases">Displays the "Alias" row in the lower part of the <link href="text/shared/explorer/database/02010100.xhp">Query Design</link>.</ahelp></paragraph></section><section id="syaliasname"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_dbviewaliases.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Alias</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
%w�X��Bl�'