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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2008 by Sun Microsystems, Inc.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: csv_formula.xhp,v $
* $Revision: 1.10.4.1 $
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************
-->
<meta>
<topic id="textscalcguidecsv_formulaxml" indexer="include">
<title id="tit" xml-lang="en-US">Importing and Exporting Text Files</title>
<filename>/text/scalc/guide/csv_formula.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3153726"><bookmark_value>csv files;formulas</bookmark_value>
<bookmark_value>formulas; importing/exporting as csv files</bookmark_value>
<bookmark_value>exporting;formulas as csv files</bookmark_value>
<bookmark_value>importing;csv files with formulas</bookmark_value>
</bookmark><comment>mw deleted "inserting;", copied 4 index entries to scalc/guide/csv_files.xhp, changed "csv files;" and "formulas;" and added 2 index entries</comment>
<paragraph role="heading" id="hd_id3153726" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="csv_formula"><link href="text/scalc/guide/csv_formula.xhp" name="Importing and Exporting Text Files">Importing and Exporting CSV Text Files with Formulas</link>
</variable></paragraph>
<paragraph role="paragraph" id="par_id3149402" xml-lang="en-US" l10n="U" oldref="2">Comma separated values (CSV) files are text files that contain the cell contents of a single sheet. Commas, semicolons, or other characters can be used as the field delimiters between the cells. Text strings are put in quotation marks, numbers are written without quotation marks.</paragraph>
<paragraph role="heading" id="hd_id3150715" xml-lang="en-US" level="2" l10n="U" oldref="15">Importing a CSV File</paragraph>
<list type="ordered">
<listitem>
<paragraph role="listitem" id="par_id3153709" xml-lang="en-US" l10n="U" oldref="16">Choose <emph>File - Open</emph>.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3155445" xml-lang="en-US" l10n="U" oldref="17">In the <emph>File type</emph> field, select the format "Text CSV". Select the file and click <emph>Open</emph>. When a file has the .csv extension, the file type is automatically recognized.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3149565" xml-lang="en-US" l10n="U" oldref="18">You will see the <emph>Import text files</emph> dialog. Click <emph>OK</emph>.</paragraph>
</listitem>
</list>
<paragraph role="tip" id="par_id3149255" xml-lang="en-US" l10n="CHG" oldref="19">If the csv file contains formulas, but you want to import the results of those formulas, then choose <emph>Tools - Options - %PRODUCTNAME Calc - View</emph> and clear the <emph>Formulas</emph> check box.</paragraph>
<paragraph role="heading" id="hd_id3154022" xml-lang="en-US" level="2" l10n="U" oldref="3">Exporting Formulas and Values as CSV Files</paragraph>
<list type="ordered">
<listitem>
<paragraph role="listitem" id="par_id3150342" xml-lang="en-US" l10n="U" oldref="4">Click the sheet to be written as a csv file.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3166423" xml-lang="en-US" l10n="U" oldref="5">If you want to export the formulas as formulas, for example, in the form =SUM(A1:B5), proceed as follows:</paragraph>
<paragraph role="listitem" id="par_id3155111" xml-lang="en-US" l10n="U" oldref="6">Choose <emph>Tools - Options - %PRODUCTNAME Calc - View</emph>.</paragraph>
<paragraph role="listitem" id="par_id3150200" xml-lang="en-US" l10n="U" oldref="7">Under <emph>Display</emph>, mark the <emph>Formulas</emph> check box. Click <emph>OK</emph>.</paragraph>
<paragraph role="listitem" id="par_id3154484" xml-lang="en-US" l10n="U" oldref="8">If you want to export the calculation results instead of the formulas, do not mark <emph>Formulas</emph>.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3148702" xml-lang="en-US" l10n="U" oldref="9">Choose <emph>File - Save as</emph>. You will see the <emph>Save as</emph> dialog.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3153912" xml-lang="en-US" l10n="U" oldref="10">In the<emph> File type</emph> field select the format "Text CSV".</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3157978" xml-lang="en-US" l10n="U" oldref="13">Enter a name and click <emph>Save</emph>.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3152869" xml-lang="en-US" l10n="U" oldref="23">From the <emph>Export of text files</emph> dialog that appears, select the character set and the field and text delimiters for the data to be exported, and confirm with <emph>OK</emph>.</paragraph>
<paragraph role="listitem" id="par_id3146781" xml-lang="en-US" l10n="U" oldref="12">Caution: If the numbers use commas as decimal separators or thousands separators, do not select the comma as the field delimiter. If the text contains double quotation marks, you must select the single quotation mark as separator.<comment>not possible to have a table here because that would break the numbering in XML.</comment></paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3150050" xml-lang="en-US" l10n="U" oldref="14">If necessary, after you have saved, clear the <emph>Formulas</emph> check box to see the calculated results in the table again.</paragraph>
</listitem>
</list>
<section id="relatedtopics">
<embed href="text/scalc/guide/csv_files.xhp#csv_files"/>
<paragraph role="paragraph" id="par_id3153487" xml-lang="en-US" l10n="U" oldref="20"><link href="text/shared/optionen/01060100.xhp" name="Tools - Options - Spreadsheet - View">Tools - Options - %PRODUCTNAME Calc - View</link></paragraph>
<paragraph role="paragraph" id="par_id3153008" xml-lang="en-US" l10n="U" oldref="21"><link href="text/shared/00/00000207.xhp" name="Export text files">Export text files</link></paragraph>
<paragraph role="paragraph" id="par_id3155595" xml-lang="en-US" l10n="U" oldref="22"><link href="text/shared/00/00000208.xhp" name="Import text files">Import text files</link></paragraph>
</section>
</body>
</helpdocument>
|
