1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 3cdf0e10cSrcweir 4cdf0e10cSrcweir 5*0ba1032bSAndrew Rist<!--*********************************************************** 6*0ba1032bSAndrew Rist * 7*0ba1032bSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 8*0ba1032bSAndrew Rist * or more contributor license agreements. See the NOTICE file 9*0ba1032bSAndrew Rist * distributed with this work for additional information 10*0ba1032bSAndrew Rist * regarding copyright ownership. The ASF licenses this file 11*0ba1032bSAndrew Rist * to you under the Apache License, Version 2.0 (the 12*0ba1032bSAndrew Rist * "License"); you may not use this file except in compliance 13*0ba1032bSAndrew Rist * with the License. You may obtain a copy of the License at 14*0ba1032bSAndrew Rist * 15*0ba1032bSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 16*0ba1032bSAndrew Rist * 17*0ba1032bSAndrew Rist * Unless required by applicable law or agreed to in writing, 18*0ba1032bSAndrew Rist * software distributed under the License is distributed on an 19*0ba1032bSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 20*0ba1032bSAndrew Rist * KIND, either express or implied. See the License for the 21*0ba1032bSAndrew Rist * specific language governing permissions and limitations 22*0ba1032bSAndrew Rist * under the License. 23*0ba1032bSAndrew Rist * 24*0ba1032bSAndrew Rist ***********************************************************--> 25*0ba1032bSAndrew Rist 26*0ba1032bSAndrew Rist 27cdf0e10cSrcweir 28cdf0e10cSrcweir 29cdf0e10cSrcweir <helpdocument version="1.0"> 30cdf0e10cSrcweir<meta> 31cdf0e10cSrcweir<topic id="textshared0000000207xml" indexer="include" status="PUBLISH"> 32cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Export text files</title> 33cdf0e10cSrcweir<filename>/text/shared/00/00000207.xhp</filename> 34cdf0e10cSrcweir</topic> 35cdf0e10cSrcweir</meta> 36cdf0e10cSrcweir<body> 37cdf0e10cSrcweir<paragraph role="heading" id="hd_id3153116" xml-lang="en-US" level="1" l10n="U" oldref="1">Export text files</paragraph> 38cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150379" xml-lang="en-US" l10n="U" oldref="7">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> 39cdf0e10cSrcweir<paragraph role="heading" id="hd_id3155577" xml-lang="en-US" level="2" l10n="U" oldref="2">Field options</paragraph> 40cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3152427" xml-lang="en-US" l10n="U" oldref="8">Defines the field separator, text separator and character set that is used for the text export.</paragraph> 41cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_IMPORTOPT:DDLB_FONT" id="bm_id3154841" localize="false"/><paragraph role="heading" id="hd_id3152876" xml-lang="en-US" level="3" l10n="U" oldref="5">Character set</paragraph> 42cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154689" xml-lang="en-US" l10n="U" oldref="11"><ahelp hid="SC:LISTBOX:RID_SCDLG_IMPORTOPT:DDLB_FONT">Specifies the character set for text export.</ahelp></paragraph> 43cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ComboBox:RID_SCDLG_IMPORTOPT:ED_FIELDSEP" id="bm_id3154840" localize="false"/><paragraph role="heading" id="hd_id3145138" xml-lang="en-US" level="3" l10n="U" oldref="3">Field delimiter</paragraph> 44cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150838" xml-lang="en-US" l10n="CHG" oldref="9"><ahelp hid="SC:COMBOBOX:RID_SCDLG_IMPORTOPT:ED_FIELDSEP">Choose or enter the field delimiter, which separates data fields.</ahelp></paragraph> 45cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ComboBox:RID_SCDLG_IMPORTOPT:ED_TEXTSEP" id="bm_id3146938" localize="false"/><paragraph role="heading" id="hd_id3154682" xml-lang="en-US" level="3" l10n="U" oldref="4">Text delimiter</paragraph> 46cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154863" xml-lang="en-US" l10n="CHG" oldref="10"><ahelp hid="SC:COMBOBOX:RID_SCDLG_IMPORTOPT:ED_TEXTSEP">Choose or enter the text delimiter, which encloses every data field.</ahelp></paragraph> 47cdf0e10cSrcweir 48cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_IMPORTOPT:CB_QUOTEALL" id="bm_id314783281" localize="false"/><paragraph role="heading" id="hd_id783149793" xml-lang="en-US" level="3" l10n="NEW">Quote all text cells</paragraph> 49cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3152778363" xml-lang="en-US" l10n="NEW"><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> 50cdf0e10cSrcweir 51cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_IMPORTOPT:CB_SAVESHOWN" id="bm_id7735831" localize="false"/><paragraph role="heading" id="hd_id7145298" xml-lang="en-US" level="3" l10n="NEW">Save cell content as shown</paragraph> 52cdf0e10cSrcweir<paragraph role="paragraph" id="par_id5719779" xml-lang="en-US" l10n="NEW"><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> 53cdf0e10cSrcweir<paragraph role="warning" id="par_id3541062" xml-lang="en-US" l10n="NEW">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> 54cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_IMPORTOPT:CB_FIXEDWIDTH" id="bm_id3143281" localize="false"/><paragraph role="heading" id="hd_id3149793" xml-lang="en-US" level="3" l10n="U" oldref="12">Fixed column width</paragraph> 55cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3152363" xml-lang="en-US" l10n="U" oldref="13"><ahelp hid="SC_CHECKBOX_RID_SCDLG_IMPORTOPT_CB_FIXEDWIDTH">Exports all data fields with a fixed width.</ahelp></paragraph> 56cdf0e10cSrcweir<list type="unordered"> 57cdf0e10cSrcweir<listitem> 58cdf0e10cSrcweir<paragraph role="listitem" id="par_id3149283" xml-lang="en-US" l10n="U" oldref="14">The width of a data field in the exported text file is set to the current width of the corresponding column.</paragraph> 59cdf0e10cSrcweir</listitem> 60cdf0e10cSrcweir<listitem> 61cdf0e10cSrcweir<paragraph role="listitem" id="par_id3154116" xml-lang="en-US" l10n="U" oldref="15">Values are exported in the format as currently seen in the cell.</paragraph> 62cdf0e10cSrcweir</listitem> 63cdf0e10cSrcweir<listitem> 64cdf0e10cSrcweir<paragraph role="listitem" id="par_id3156414" xml-lang="en-US" l10n="U" oldref="16">If a value is longer than the fixed column width, it will be exported as a ### string.</paragraph> 65cdf0e10cSrcweir</listitem> 66cdf0e10cSrcweir<listitem> 67cdf0e10cSrcweir<paragraph role="listitem" id="par_id3150178" xml-lang="en-US" l10n="U" oldref="17">If a text string is longer than the fixed column width, it will be truncated at the end.</paragraph> 68cdf0e10cSrcweir</listitem> 69cdf0e10cSrcweir<listitem> 70cdf0e10cSrcweir<paragraph role="listitem" id="par_id3148548" xml-lang="en-US" l10n="U" oldref="18">The alignment Left, Centered, and Right will be simulated by inserted blanks.</paragraph> 71cdf0e10cSrcweir</listitem> 72cdf0e10cSrcweir</list> 73cdf0e10cSrcweir<section id="relatedtopics"> 74cdf0e10cSrcweir<embed href="text/scalc/guide/csv_files.xhp#csv_files"/> 75cdf0e10cSrcweir</section> 76cdf0e10cSrcweir</body> 77cdf0e10cSrcweir</helpdocument> 78