1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<helpdocument version="1.0">
<meta>
<topic id="textshared0000000207xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Export text files</title>
<filename>/text/shared/00/00000207.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/imoptdialog/ImOptDialog" id="bm_id3154839" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/imoptdialog/@@nowidget@@" id="bm_id3154839" localize="false"/>
<paragraph role="heading" id="hd_id3153116" xml-lang="en-US" level="1">Export text files</paragraph>
<paragraph role="paragraph" id="par_id3150379" xml-lang="en-US">The <emph>Export text files</emph> dialog allows you to define the export options for text files. The dialog will be displayed if you save spreadsheet data as file type "Text CSV", and if the <emph>Edit filter settings</emph> check box is marked in the <emph>Save As</emph> dialog.</paragraph>
<paragraph role="heading" id="hd_id3155577" xml-lang="en-US" level="2">Field options</paragraph>
<paragraph role="paragraph" id="par_id3152427" xml-lang="en-US">Defines the field separator, text separator and character set that is used for the text export.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/imoptdialog/charsetdropdown" id="bm_id3154841" localize="false"/><paragraph role="heading" id="hd_id3152876" xml-lang="en-US" level="3">Character set</paragraph>
<paragraph role="paragraph" id="par_id3154689" xml-lang="en-US"><ahelp hid="modules/scalc/ui/imoptdialog/charsetdropdown">Specifies the character set for text export.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/imoptdialog/field" id="bm_id3154840" localize="false"/><paragraph role="heading" id="hd_id3145138" xml-lang="en-US" level="3">Field delimiter</paragraph>
<paragraph role="paragraph" id="par_id3150838" xml-lang="en-US"><ahelp hid="modules/scalc/ui/imoptdialog/field">Choose or enter the field delimiter, which separates data fields.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/imoptdialog/text" id="bm_id3146938" localize="false"/><paragraph role="heading" id="hd_id3154682" xml-lang="en-US" level="3">Text delimiter</paragraph>
<paragraph role="paragraph" id="par_id3154863" xml-lang="en-US"><ahelp hid="modules/scalc/ui/imoptdialog/text">Choose or enter the text delimiter, which encloses every data field.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/imoptdialog/quoteall" id="bm_id314783281" localize="false"/><paragraph role="heading" id="hd_id783149793" xml-lang="en-US" level="3">Quote all text cells</paragraph>
<paragraph role="paragraph" id="par_id3152778363" xml-lang="en-US"><ahelp hid=".">Exports all text cells with leading and trailing quote characters as set in the Text delimiter box. If not checked, only those text cells get quoted that contain the Field delimiter character.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/imoptdialog/asshown" id="bm_id7735831" localize="false"/><paragraph role="heading" id="hd_id7145298" xml-lang="en-US" level="3">Save cell content as shown</paragraph>
<paragraph role="paragraph" id="par_id5719779" xml-lang="en-US"><ahelp hid=".">Enabled by default, data will be saved as displayed, including applied number formats. If this checkbox is not marked, raw data content will be saved, as in older versions of the software.</ahelp></paragraph>
<paragraph role="warning" id="par_id3541062" xml-lang="en-US">Depending on the number format, saving cell content as shown may write values that during an import cannot be interpreted as numerical values anymore.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/imoptdialog/fixedwidth" id="bm_id3143281" localize="false"/><paragraph role="heading" id="hd_id3149793" xml-lang="en-US" level="3">Fixed column width</paragraph>
<paragraph role="paragraph" id="par_id3152363" xml-lang="en-US"><ahelp hid="modules/scalc/ui/imoptdialog/fixedwidth">Exports all data fields with a fixed width.</ahelp></paragraph>
<list type="unordered">
<listitem>
<paragraph role="listitem" id="par_id3149283" xml-lang="en-US">The width of a data field in the exported text file is set to the current width of the corresponding column.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3154116" xml-lang="en-US">Values are exported in the format as currently seen in the cell.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3156414" xml-lang="en-US">If a value is longer than the fixed column width, it will be exported as a ### string.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3150178" xml-lang="en-US">If a text string is longer than the fixed column width, it will be truncated at the end.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3148548" xml-lang="en-US">The alignment Left, Centered, and Right will be simulated by inserted blanks.</paragraph>
</listitem>
</list>
<section id="relatedtopics">
<embed href="text/scalc/guide/csv_files.xhp#csv_files"/>
</section>
</body>
</helpdocument>
|
