summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--source/text/scalc/guide/csv_files.xhp24
1 files changed, 12 insertions, 12 deletions
diff --git a/source/text/scalc/guide/csv_files.xhp b/source/text/scalc/guide/csv_files.xhp
index bb87760fc8..d0cbd01f0c 100644
--- a/source/text/scalc/guide/csv_files.xhp
+++ b/source/text/scalc/guide/csv_files.xhp
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
+
<!--
* This file is part of the LibreOffice project.
*
@@ -18,7 +18,7 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
+
<meta>
<topic id="textscalcguidecsv_filesxml" indexer="include">
<title xml-lang="en-US" id="tit"> Importing and Exporting CSV Files </title>
@@ -39,11 +39,11 @@
<bookmark_value>opening;text csv files</bookmark_value>
<bookmark_value>saving;as text csv</bookmark_value>
</bookmark><comment>MW deleted "importing;text data bases" and copied 4 index entries from scalc/guide/csv_formula.xhp</comment><comment>mw added "saving;" and "opening;"</comment>
-<paragraph xml-lang="en-US" id="par_idN10862" role="heading" level="1"><variable id="csv_files"><link href="text/scalc/guide/csv_files.xhp">Opening and Saving Text CSV Files</link>
-</variable></paragraph>
+<h1 id="par_idN10862"><variable id="csv_files"><link href="text/scalc/guide/csv_files.xhp">Opening and Saving Text CSV Files</link>
+</variable></h1>
<paragraph xml-lang="en-US" id="par_idN10880" role="paragraph">Comma Separated Values (CSV) is a text file format that you can use to exchange data from a database or a spreadsheet between applications. Each line in a Text CSV file represents a record in the database, or a row in a spreadsheet. Each field in a database record or cell in a spreadsheet row is usually separated by a comma. However, you can use other characters to delimit a field, such as a tabulator character.</paragraph>
<paragraph xml-lang="en-US" id="par_idN10886" role="paragraph">If the field or cell contains a comma, the field or cell <emph>must</emph> be enclosed by single quotes (') or double quotes (").</paragraph>
-<paragraph xml-lang="en-US" id="par_idN10890" role="heading" level="2">To Open a Text CSV File in Calc</paragraph>
+<h2 id="par_idN10890">To Open a Text CSV File in Calc</h2>
<list type="ordered">
<listitem>
<paragraph xml-lang="en-US" id="par_idN10897" role="listitem">Choose <item type="menuitem">File - Open</item>.</paragraph>
@@ -51,7 +51,7 @@
<listitem>
<paragraph xml-lang="en-US" id="par_idN1089F" role="listitem">Locate the CSV file that you want to open.</paragraph>
<paragraph xml-lang="en-US" id="par_idN108A2" role="listitem">If the file has a *.csv extension, select the file.</paragraph>
-<paragraph xml-lang="en-US" id="par_idN108A5" role="listitem">If the CSV file has another extension, select the file, and then select "Text CSV" in the <item type="menuitem">File type</item> box</paragraph>
+<paragraph xml-lang="en-US" id="par_idN108A5" role="listitem">If the CSV file has another extension, select the file, and then select "Text CSV" in the <emph>Filter</emph> box</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_idN1082D" role="listitem">Click <item type="menuitem">Open</item>.</paragraph>
@@ -61,18 +61,18 @@
<paragraph xml-lang="en-US" id="par_idN108B1" role="listitem">Specify the options to divide the text in the file into columns.</paragraph>
<paragraph xml-lang="en-US" id="par_idN108BB" role="listitem">You can preview the layout of the imported data at the bottom of the <item type="menuitem">Text Import</item> dialog. </paragraph>
<paragraph xml-lang="en-US" id="par_id8444166" role="listitem">Right-click a column in the preview to set the format or to hide the column.</paragraph>
-<paragraph xml-lang="en-US" id="par_idN108E2" role="tip">Check the text delimiter box that matches the character used as text delimiter in the file. In case of an unlisted delimiter, type the character into the input box.</paragraph>
+<paragraph role="tip" id="par_idN108E2">Check the text delimiter box that matches the character used as text delimiter in the file. In case of an unlisted delimiter, type the character into the input box.</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_idN108C5" role="listitem">Click <item type="menuitem">OK</item>.</paragraph>
</listitem>
</list>
-<paragraph xml-lang="en-US" id="par_idN108FA" role="heading" level="2">To Save a Sheet as a Text CSV File</paragraph>
-<paragraph xml-lang="en-US" id="par_idN106FC" role="note">When you export a spreadsheet to CSV format, only the data on the current sheet is saved. All other information, including formulas and formatting, is lost.</paragraph>
+<h2 id="par_idN108FA">To Save a Sheet as a Text CSV File</h2>
+<note id="par_idN106FC">When you export a spreadsheet to CSV format, only the data on the current sheet is saved. All other information, including formulas and formatting, is lost.</note>
<list type="ordered">
<listitem>
<paragraph xml-lang="en-US" id="par_idN10901" role="listitem">Open the Calc sheet that you want to save as a Text CSV file.</paragraph>
-<paragraph xml-lang="en-US" id="par_idN107AF" role="note">Only the current sheet can be exported.</paragraph>
+<paragraph role="note" id="par_idN107AF">Only the current sheet can be exported.</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_idN10905" role="listitem">Choose <item type="menuitem">File - Save as</item>.</paragraph>
@@ -81,7 +81,7 @@
<paragraph xml-lang="en-US" id="par_idN10915" role="listitem">In the <item type="menuitem">File name</item> box, enter a name for the file.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_idN1090D" role="listitem">In the <item type="menuitem">File type</item> box, select "Text CSV".</paragraph>
+<paragraph xml-lang="en-US" id="par_idN1090D" role="listitem">In the <emph>Filter</emph> box, select "Text CSV".</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_idN107DD" role="listitem">(Optional) Set the field options for the Text CSV file.</paragraph>
@@ -101,4 +101,4 @@
<paragraph xml-lang="en-US" id="par_id3155595" role="paragraph"><link href="text/shared/00/00000208.xhp" name="Import text files">Import text files</link></paragraph>
</section>
</body>
-</helpdocument> \ No newline at end of file
+</helpdocument>