source/text/scalc/guide/csv_files.xhp | 70 +++++++++++++++-------------------
source/text/shared/00/00000207.xhp | 53 +++++++++++--------------
source/text/shared/00/00000208.xhp | 4 +
3 files changed, 60 insertions(+), 67 deletions(-)
New commits:
commit bd2469c1d06fa57348b36d9725704a2e21a7ab28
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Thu Jul 3 14:38:12 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Jul 3 20:16:02 2025 +0200
tdf#74580 Update Help page for CSV import
+ refactor
Change-Id: I7aa01b93282efb9e1e7faca739f833d196244312
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/187347
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/guide/csv_files.xhp
b/source/text/scalc/guide/csv_files.xhp
index a28dedf80a..5e3cce6fa9 100644
--- a/source/text/scalc/guide/csv_files.xhp
+++ b/source/text/scalc/guide/csv_files.xhp
@@ -21,12 +21,12 @@
<meta>
<topic id="textscalcguidecsv_filesxml" indexer="include">
-<title xml-lang="en-US" id="tit"> Importing and Exporting CSV Files </title>
+<title id="tit"> Importing and Exporting CSV Files </title>
<filename>/text/scalc/guide/csv_files.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id892361"><bookmark_value>number series import</bookmark_value>
+<bookmark branch="index" id="bm_id892361"><bookmark_value>number series
import</bookmark_value>
<bookmark_value>data series import</bookmark_value>
<bookmark_value>exporting; tables as text</bookmark_value>
<bookmark_value>importing; tables as text</bookmark_value>
@@ -41,64 +41,58 @@
</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>
<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 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 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>
<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>
-</listitem>
-<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
<emph>Filter</emph> box</paragraph>
-</listitem>
-<listitem>
-<paragraph xml-lang="en-US" id="par_idN1082D" role="listitem">Click <item
type="menuitem">Open</item>.</paragraph>
-<paragraph xml-lang="en-US" id="par_idN10834" role="listitem">The <item
type="menuitem">Text Import</item> dialog opens.</paragraph>
-</listitem>
-<listitem>
-<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 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>
+ <listitem><paragraph id="par_idN10897" role="listitem">Choose <item
type="menuitem">File - Open</item>.</paragraph></listitem>
+ <listitem>
+ <paragraph id="par_idN1089F" role="listitem">Locate the CSV file that
you want to open.</paragraph>
+ <paragraph id="par_idN108A2" role="listitem">If the file has a *.csv
extension, select the file.</paragraph>
+ <paragraph 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 id="par_id341751561571932" role="listitem">Select
<menuitem>Edit filter settings</menuitem> checkbox to open the <link
href="text/shared/00/00000208.xhp"><menuitem>Text Import</menuitem></link>
dialog and set the import options for delimited data. If the <menuitem>Edit
filter settings</menuitem> checkbox is not selected, %PRODUCTNAME Calc uses the
settings of the last text import operation.</paragraph></listitem>
+ <listitem><paragraph id="par_idN1082D" role="listitem">Click <item
type="menuitem">Open</item>.</paragraph></listitem>
+</list>
+<paragraph role="paragraph" id="par_id991751562754613">If the <menuitem>Edit
filter settings</menuitem> checkbox is selected, the <link
href="text/shared/00/00000208.xhp"><menuitem>Text Import</menuitem></link>
dialog opens. Then: </paragraph>
+<list type="unordered" bullet="circle">
+ <listitem><paragraph id="par_idN108B1" role="listitem">Specify the options
to divide the text in the file into columns.</paragraph></listitem>
+ <listitem><paragraph id="par_id8444166" role="listitem">Right-click a
column in the preview to set the format or to hide the
column.</paragraph></listitem>
+ <listitem><paragraph id="par_idN108C5" role="listitem">Click <item
type="menuitem">OK</item>.</paragraph></listitem>
</list>
+<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.</tip>
+
<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 role="note" id="par_idN107AF">Only the current sheet can be
exported.</paragraph>
+<paragraph id="par_idN10901" role="listitem">Open the Calc sheet that you want
to save as a Text CSV file.</paragraph>
+<note id="par_idN107AF">Only the current sheet can be exported.</note>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_idN10905" role="listitem">Choose <item
type="menuitem">File - Save as</item>.</paragraph>
+<paragraph id="par_idN10905" role="listitem">Choose <item type="menuitem">File
- Save as</item>.</paragraph>
</listitem>
<listitem>
-<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>
+<paragraph 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
<emph>Filter</emph> box, select "Text CSV".</paragraph>
+<paragraph 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>
-<paragraph xml-lang="en-US" id="par_idN1091C" role="listitem">Select <item
type="menuitem">Edit filter settings</item>.</paragraph>
-<paragraph xml-lang="en-US" id="par_idN107ED" role="listitem">In the <item
type="menuitem">Export of text files</item> dialog, select the options that you
want.</paragraph>
-<paragraph xml-lang="en-US" id="par_idN107F4" role="listitem">Click <item
type="menuitem">OK</item>.</paragraph>
+<paragraph id="par_idN107DD" role="listitem">(Optional) Set the field options
for the Text CSV file.</paragraph>
+<paragraph id="par_idN1091C" role="listitem">Select <item type="menuitem">Edit
filter settings</item>.</paragraph>
+<paragraph id="par_idN107ED" role="listitem">In the <item
type="menuitem">Export of text files</item> dialog, select the options that you
want.</paragraph>
+<paragraph id="par_idN107F4" role="listitem">Click <item
type="menuitem">OK</item>.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_idN107FC" role="listitem">Click <item
type="menuitem">Save</item>.</paragraph>
+<paragraph id="par_idN107FC" role="listitem">Click <item
type="menuitem">Save</item>.</paragraph>
</listitem>
</list>
<section id="relatedtopics">
<embed href="text/scalc/guide/csv_formula.xhp#csv_formula"/>
<embed href="text/shared/guide/data_im_export.xhp#data_im_export"/>
-<paragraph xml-lang="en-US" id="par_id3153487" role="paragraph"><switchinline
select="sys"><caseinline select="MAC">%PRODUCTNAME -
Preferences</caseinline><defaultinline>Tools -
Options</defaultinline></switchinline> - <link
href="text/shared/optionen/01060100.xhp">%PRODUCTNAME Calc -
View</link></paragraph>
-<paragraph xml-lang="en-US" id="par_id3153008" role="paragraph"><link
href="text/shared/00/00000207.xhp">Export text files</link></paragraph>
-<paragraph xml-lang="en-US" id="par_id3155595" role="paragraph"><link
href="text/shared/00/00000208.xhp">Import text files</link></paragraph>
+<paragraph id="par_id3153487" role="paragraph"><switchinline
select="sys"><caseinline select="MAC">%PRODUCTNAME -
Preferences</caseinline><defaultinline>Tools -
Options</defaultinline></switchinline> - <link
href="text/shared/optionen/01060100.xhp">%PRODUCTNAME Calc -
View</link></paragraph>
+<paragraph id="par_id3153008" role="paragraph"><link
href="text/shared/00/00000207.xhp">Export text files</link></paragraph>
+<paragraph id="par_id3155595" role="paragraph"><link
href="text/shared/00/00000208.xhp">Import text files</link></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/shared/00/00000207.xhp
b/source/text/shared/00/00000207.xhp
index 106c6755f7..34fbcac153 100644
--- a/source/text/shared/00/00000207.xhp
+++ b/source/text/shared/00/00000207.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,52 +16,50 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textshared0000000207xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Export text files</title>
+<title id="tit">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"/>
+<bookmark branch="hid/modules/scalc/ui/imoptdialog/ImOptDialog"
id="bm_id3154839" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/imoptdialog/@@nowidget@@"
id="bm_id3154839" localize="false"/>
<h1 id="hd_id3153116">Export text files</h1>
-<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="paragraph" id="par_id3150379">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>
<h2 id="hd_id3155577">Field options</h2>
-<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"/><h3 id="hd_id3152876">Character set</h3>
-<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"/><h3 id="hd_id3145138">Field delimiter</h3>
-<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"/><h3 id="hd_id3154682">Text delimiter</h3>
-<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>
+<paragraph role="paragraph" id="par_id3152427">Defines the field separator,
text separator and character set that is used for the text export.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/imoptdialog/charsetdropdown"
id="bm_id3154841" localize="false"/><h3 id="hd_id3152876">Character set</h3>
+<paragraph role="paragraph" id="par_id3154689"><ahelp
hid="modules/scalc/ui/imoptdialog/charsetdropdown">Specifies the character set
for text export.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/imoptdialog/field" id="bm_id3154840"
localize="false"/><h3 id="hd_id3145138">Field delimiter</h3>
+<paragraph role="paragraph" id="par_id3150838"><ahelp
hid="modules/scalc/ui/imoptdialog/field">Choose or enter the field delimiter,
which separates data fields.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/imoptdialog/text" id="bm_id3146938"
localize="false"/><h3 id="hd_id3154682">Text delimiter</h3>
+<paragraph role="paragraph" id="par_id3154863"><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"/><h3 id="hd_id783149793">Quote all text
cells</h3>
-<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 branch="hid/modules/scalc/ui/imoptdialog/quoteall"
id="bm_id314783281" localize="false"/><h3 id="hd_id783149793">Quote all text
cells</h3>
+<paragraph role="paragraph" id="par_id3152778363"><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"/><h3 id="hd_id7145298">Save cell content as
shown</h3>
-<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"/><h3 id="hd_id3149793">Fixed column width</h3>
-<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>
+<bookmark branch="hid/modules/scalc/ui/imoptdialog/asshown" id="bm_id7735831"
localize="false"/><h3 id="hd_id7145298">Save cell content as shown</h3>
+<paragraph role="paragraph" id="par_id5719779"><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>
+<warning id="par_id3541062">Depending on the number format, saving cell
content as shown may write values that during an import cannot be interpreted
as numerical values anymore.</warning>
+<bookmark branch="hid/modules/scalc/ui/imoptdialog/fixedwidth"
id="bm_id3143281" localize="false"/><h3 id="hd_id3149793">Fixed column
width</h3>
+<paragraph role="paragraph" id="par_id3152363"><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>
+<paragraph role="listitem" id="par_id3149283">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>
+<paragraph role="listitem" id="par_id3154116">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>
+<paragraph role="listitem" id="par_id3156414">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>
+<paragraph role="listitem" id="par_id3150178">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>
+<paragraph role="listitem" id="par_id3148548">The alignment Left, Centered,
and Right will be simulated by inserted blanks.</paragraph>
</listitem>
</list>
<section id="relatedtopics">
diff --git a/source/text/shared/00/00000208.xhp
b/source/text/shared/00/00000208.xhp
index d1220462a8..f3a5fdeb6f 100644
--- a/source/text/shared/00/00000208.xhp
+++ b/source/text/shared/00/00000208.xhp
@@ -244,6 +244,10 @@
<h3 id="hd_id3149287">Preview</h3>
<paragraph id="par_id3147377" role="paragraph"><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">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>
+<h3 id="hd_id511751558542938">Allways show on import</h3>
+<paragraph role="paragraph" id="par_id781751558593644">This checkbox
determines whether the dialog will appear during a CSV import or whether the
previously saved settings from the last dialog session will be applied
automatically.</paragraph>
+<paragraph role="paragraph" id="par_id931751561058469">If the checkbox is
unchecked and the dialog is suppressed, you can still display it once by
selecting the new <menuitem>Edit filter settings</menuitem> checkbox in the
File Open dialog.</paragraph>
+
<section id="relatedtopics">
<paragraph id="par_id3155746" role="paragraph"><link
href="text/shared/guide/keyboard.xhp">Navigating Without the
Mouse</link></paragraph>
<paragraph id="par_id3146120" role="paragraph"><link
href="text/shared/00/00000020.xhp">Information about Import and Export
Filters</link>.</paragraph>
