tdf#114200 Document new Trim space feature in Text Import

Also fix some ahelps and bookmarks
Sync element references with current UI

Change-Id: I37ededca56215816d1784071f22e47f33a4a203b
Reviewed-on: https://gerrit.libreoffice.org/52140
Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com>
Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>

1 files changed, 12 insertions, 5 deletions

diff --git a/source/text/shared/00/00000208.xhp b/source/text/shared/00/00000208.xhp
index 24a6e07420..e39fa68fcf 100644
--- a/source/text/shared/00/00000208.xhp
+++ b/source/text/shared/00/00000208.xhp
@@ -88,21 +88,27 @@
 <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/inputother" id="bm_id3149801" localize="false"/>
 
 <paragraph id="hd_id3147335" role="heading" level="3" xml-lang="en-US">Other</paragraph>
-<paragraph id="par_id3156329" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/textimportcsv/inputother">Separates data into columns using the custom separator that you specify. Note: The custom separator must also be contained in your data.</ahelp></paragraph>
+<paragraph id="par_id3156329" role="paragraph" xml-lang="en-US"><ahelp hid=".">Separates data into columns using the custom separator that you specify. Note: The custom separator must also be contained in your data.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/mergedelimiters" id="bm_id3146807" localize="false"/>
 
 <paragraph id="hd_id3150978" role="heading" level="3" xml-lang="en-US">Merge delimiters</paragraph>
 <paragraph id="par_id3153827" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/textimportcsv/mergedelimiters">Combines consecutive delimiters and removes blank data fields.</ahelp></paragraph>
+
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/removespace" id="bm_id3146808" localize="false"/>
+
+<paragraph id="hd_id3150979" role="heading" level="3" xml-lang="en-US">Trim spaces</paragraph>
+<paragraph id="par_id3153828" role="paragraph" xml-lang="en-US"><ahelp hid=".">Removes starting and trailing spaces from data fields.</ahelp></paragraph>
+
 <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/textdelimiter" id="bm_id3147619" localize="false"/>
 
-<paragraph id="hd_id3155341" role="heading" level="3" xml-lang="en-US">Text delimiter</paragraph>
+<paragraph id="hd_id3155341" role="heading" level="3" xml-lang="en-US">String delimiter</paragraph>
 <paragraph id="par_id3156326" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/textimportcsv/textdelimiter">Select a character to delimit text data. You can can also enter a character in the text box.</ahelp></paragraph>
 
 <paragraph id="hd_id315538811" role="heading" level="2" xml-lang="en-US">Other options</paragraph>
 <paragraph id="par_id315366511" role="paragraph" xml-lang="en-US">Sets some other import options.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/quotedfieldastext" id="bm_id315790911" localize="false"/>
 
-<paragraph id="hd_id314847411" role="heading" level="3" xml-lang="en-US">Quoted fields as text</paragraph>
+<paragraph id="hd_id314847411" role="heading" level="3" xml-lang="en-US">Format quoted field as text</paragraph>
 <paragraph id="par_id314995711" role="paragraph" xml-lang="en-US"><ahelp hid=".">When this option is enabled, fields or cells whose values are quoted in their entirety (the first and last characters of the value equal the text delimiter) are imported as text.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/detectspecialnumbers" id="bm_id315790922" localize="false"/>
 
@@ -229,11 +235,12 @@
 
 <paragraph id="par_id3153143" role="tip" xml-lang="en-US">If you want to include the leading zero in the data you import, in telephone numbers for example, apply the "Text" format to the column.</paragraph>
 
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/scrolledwindowcolumntype" id="bm_id3157910" localize="false"/>
 <paragraph id="hd_id3149287" role="heading" level="3" xml-lang="en-US">Preview</paragraph>
-<paragraph id="par_id3147377" role="paragraph" xml-lang="en-US">Shows how the imported text will look after it is separated into columns. To apply a format to a column when it is imported, click a column and select a <emph>Column type</emph>. When you select a <emph>Column type</emph>, the column heading displays the applied format.</paragraph>
+<paragraph id="par_id3147377" role="paragraph" xml-lang="en-US"><ahelp hid=".">Shows how the imported text will look after it is separated into columns. To apply a format to a column when it is imported, click a column and select a <emph>Column type</emph>. When you select a <emph>Column type</emph>, the column heading displays the applied format.</ahelp></paragraph>
 <paragraph id="par_id3150105" role="paragraph" xml-lang="en-US">If you want to use a fixed width to separate the imported data into columns, click in the ruler to set the width boundaries.</paragraph>
 <paragraph id="par_id3155746" role="paragraph" xml-lang="en-US"><link href="text/shared/guide/keyboard.xhp" name="Navigating Without the Mouse">Navigating Without the Mouse</link></paragraph>
 <paragraph id="par_id3146120" role="paragraph" xml-lang="en-US">For more information, see <link href="text/shared/00/00000020.xhp" name="Information about Import and Export Filters">Information about Import and Export Filters</link>.</paragraph>
 </body>
 
-</helpdocument>
\ No newline at end of file
+</helpdocument>