summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGabor Kelemen <kelemeng@gnome.hu>2018-03-30 01:37:06 +0200
committerGabor Kelemen <kelemeng@ubuntu.com>2018-03-31 13:23:13 +0200
commit29f6ad0004e6f49481ae32c577b394ec709b43f0 (patch)
tree69bcc9ea1204aad06bdf5c95345deac203e20b17
parenta86659f64cb346127159064202d9b6d3513ffe3e (diff)
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>
-rw-r--r--source/text/shared/00/00000208.xhp17
1 files changed, 12 insertions, 5 deletions
diff --git a/source/text/shared/00/00000208.xhp b/source/text/shared/00/00000208.xhp
index 24a6e0742..e39fa68fc 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>