summaryrefslogtreecommitdiff
path: root/source/text/shared/02/01170102.xhp
diff options
context:
space:
mode:
authorGabor Kelemen <kelemeng@gnome.hu>2019-07-02 01:05:50 +0200
committerGabor Kelemen <kelemen.gabor2@nisz.hu>2019-07-02 09:28:25 +0200
commit4b523164742b4eaffb576c0b1f507cf42f236ad5 (patch)
tree920fd0e9004bc02dfa145dc6a36c9eeb14cf060e /source/text/shared/02/01170102.xhp
parent1bd7d25c1064639add894fb4ca49b217d389b8c6 (diff)
Fix ahelp HIDs in form control Data pages
Change-Id: Iec13edc72bc5b1dbc83f73be142662917a6505cf Reviewed-on: https://gerrit.libreoffice.org/74982 Tested-by: Jenkins Reviewed-by: Gabor Kelemen <kelemen.gabor2@nisz.hu>
Diffstat (limited to 'source/text/shared/02/01170102.xhp')
-rw-r--r--source/text/shared/02/01170102.xhp20
1 files changed, 10 insertions, 10 deletions
diff --git a/source/text/shared/02/01170102.xhp b/source/text/shared/02/01170102.xhp
index 65664d9f0e..350ef10933 100644
--- a/source/text/shared/02/01170102.xhp
+++ b/source/text/shared/02/01170102.xhp
@@ -51,7 +51,7 @@
<section id="Section23">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_REFVALUE" id="bm_id3147327" localize="false"/>
<paragraph role="heading" id="hd_id3159121" xml-lang="en-US" level="2">Reference value (on)<comment>UFI: moved section from 01170101, changed name</comment></paragraph>
- <paragraph role="paragraph" id="par_id3163812" xml-lang="en-US"><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" id="par_id3163812" xml-lang="en-US"><ahelp hid="." 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" id="par_id3150225" xml-lang="en-US"><emph>Reference values for web forms</emph></paragraph>
<paragraph role="paragraph" id="par_id3147611" xml-lang="en-US">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" id="par_id3149570" xml-lang="en-US">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>
@@ -61,7 +61,7 @@
<section id="Section1">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CONTROLSOURCE" id="bm_id3157976" localize="false"/>
<paragraph role="heading" id="hd_id3148455" xml-lang="en-US" level="2">Data field</paragraph>
- <paragraph role="paragraph" id="par_id3155852" xml-lang="en-US"><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" id="par_id3155852" xml-lang="en-US"><ahelp hid="." 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" id="par_id3153224" xml-lang="en-US">You have several possibilities:</paragraph>
<list type="ordered">
<listitem>
@@ -97,7 +97,7 @@
<section id="Section2">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_BOUNDCOLUMN" id="bm_id3150297" localize="false"/>
<paragraph role="heading" id="hd_id3154664" xml-lang="en-US" level="2">Bound field</paragraph>
- <paragraph role="paragraph" id="par_id3148475" xml-lang="en-US"><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><comment>UFI: issue #i32749#</comment></paragraph>
+ <paragraph role="paragraph" id="par_id3148475" xml-lang="en-US"><ahelp hid="." 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><comment>UFI: issue #i32749#</comment></paragraph>
<paragraph role="note" id="par_idN10AD2" xml-lang="en-US">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.<comment>UFI: issue #i32749#</comment></paragraph>
<paragraph role="paragraph" id="par_id3154588" xml-lang="en-US">This property for list boxes defines which data field of a linked table is displayed in the form.</paragraph>
<paragraph role="paragraph" id="par_id3151213" xml-lang="en-US">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>
@@ -184,14 +184,14 @@
<section id="Section3">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_LISTSOURCETYPE" id="bm_id3153316" localize="false"/>
<paragraph role="heading" id="hd_id3149772" xml-lang="en-US" level="2">Type of list contents</paragraph>
- <paragraph role="paragraph" id="par_id3154419" xml-lang="en-US"><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" id="par_id3154419" xml-lang="en-US"><ahelp hid="." 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" id="par_id3153326" xml-lang="en-US">With the "Valuelist" option, all entries entered in the <emph>List entries</emph> field of the <link href="text/shared/02/01170101.xhp" name="General"><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" name=" References Using Value Lists"><emph>References Using Value Lists</emph></link> section).</paragraph>
<paragraph role="paragraph" id="par_id3153067" xml-lang="en-US">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 xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_LISTSOURCE" id="bm_id3148839" localize="false"/>
<paragraph role="heading" id="hd_id3153820" xml-lang="en-US" level="2">List content</paragraph>
- <paragraph role="paragraph" id="par_id3159171" xml-lang="en-US"><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" id="par_id3159171" xml-lang="en-US"><ahelp hid=".">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" id="par_id3168456" xml-lang="en-US">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" id="par_id3155870" xml-lang="en-US">Examples of SQL statements:</paragraph>
<paragraph role="paragraph" id="par_id3144504" xml-lang="en-US">For list boxes, an SQL statement may have the following form:</paragraph>
@@ -267,19 +267,19 @@
<section id="Section5">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_EMPTY_IS_NULL" id="bm_id3150628" localize="false"/>
<paragraph role="heading" id="hd_id3148901" xml-lang="en-US" level="2">Empty string is NULL</paragraph>
- <paragraph role="paragraph" id="par_id3145357" xml-lang="en-US"><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" id="par_id3145357" xml-lang="en-US"><ahelp hid=".">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" id="par_id0820200812403467" xml-lang="en-US">An empty string is a string of length zero (<emph>""</emph>). 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" id="par_id0820200812403455" xml-lang="en-US">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 xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_FILTERPROPOSAL" id="bm_id3149393" localize="false"/>
<paragraph role="heading" id="hd_id3161653" xml-lang="en-US" level="2">Filter proposal</paragraph>
- <paragraph role="paragraph" id="par_id3151221" xml-lang="en-US"><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 <emph>AutoComplete</emph> 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>
+ <paragraph role="paragraph" id="par_id3151221" xml-lang="en-US"><variable id="filtervorschlag"><ahelp hid=".">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 <emph>AutoComplete</emph> 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 xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_BOUND_CELL" id="bm_id4214300" localize="false"/>
<paragraph role="heading" id="par_idN10EE3" xml-lang="en-US" level="2">Linked cell</paragraph>
- <paragraph role="paragraph" id="par_idN10EE7" xml-lang="en-US"><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="paragraph" id="par_idN10EE7" xml-lang="en-US"><ahelp hid=".">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" id="par_idN10EF7" xml-lang="en-US" level="3">Check box with linked cell</paragraph>
<table id="tbl_id4947965">
<tablerow>
@@ -674,7 +674,7 @@
<section id="Section8">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CELL_EXCHANGE_TYPE" id="bm_id5563219" localize="false"/>
<paragraph role="heading" id="par_idN11163" xml-lang="en-US" level="2">Contents of the linked cell</paragraph>
- <paragraph role="paragraph" id="par_idN11167" xml-lang="en-US"><ahelp hid="HID_PROP_CELL_EXCHANGE_TYPE">Select the mode of linking a list box with a linked cell on a spreadsheet.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_idN11167" xml-lang="en-US"><ahelp hid=".">Select the mode of linking a list box with a linked cell on a spreadsheet.</ahelp></paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_idN11179" xml-lang="en-US"><emph>Linked contents:</emph> Synchronize the text contents of the selected list box entry with the cell contents. Select "The selected entry".</paragraph>
@@ -687,7 +687,7 @@
<section id="Section7">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_LIST_CELL_RANGE" id="bm_id9886165" localize="false"/>
<paragraph role="heading" id="par_idN1118B" xml-lang="en-US" level="2">Source cell range<comment>UFI: in the spec, this is "Source range of the list". Named it as seen in 680m38</comment></paragraph>
- <paragraph role="paragraph" id="par_idN111A1" xml-lang="en-US"><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>
+ <paragraph role="paragraph" id="par_idN111A1" xml-lang="en-US"><ahelp hid=".">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>