source/text/shared/00/00000208.xhp | 3 ++- source/text/shared/00/00000401.xhp | 21 ++++++++++++++++++--- 2 files changed, 20 insertions(+), 4 deletions(-)
New commits: commit 6724b6384ee492e29ddc82ad6439474fdd8c036d Author: Olivier Hallot <[email protected]> AuthorDate: Mon Aug 17 10:07:48 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Tue Aug 18 14:00:02 2026 +0200 tdf#173165 Explain autodetection of ISO 8601 date format + update on how to get it Change-Id: Id83c4611fce1333c7e315db4392e7ecf7b8f8cab Reviewed-on: https://gerrit.libreoffice.org/c/help/+/209199 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/shared/00/00000208.xhp b/source/text/shared/00/00000208.xhp index b9e1caa4bf..a8e66d420d 100644 --- a/source/text/shared/00/00000208.xhp +++ b/source/text/shared/00/00000208.xhp @@ -31,7 +31,7 @@ <bookmark branch="hid/modules/scalc/ui/textimportcsv/@@nowidget@@" id="bm_id3148919" localize="false"/> <h1 id="hd_id3150960"><variable id="TextImporth1"><link href="text/shared/00/00000208.xhp">Text Import</link></variable></h1> -<paragraph id="par_id3149987" role="paragraph"><ahelp hid="modules/scalc/ui/textimportcsv/TextImportCsvDialog">Sets the import options for delimited data.</ahelp></paragraph> +<description id="par_id3149987"><ahelp hid="modules/scalc/ui/textimportcsv/TextImportCsvDialog">Sets the import options for delimited data.</ahelp></description> <section id="howtoget"> <embed href="text/shared/00/00000401.xhp#textimport"/> @@ -149,6 +149,7 @@ </tablecell> <tablecell> <paragraph id="par_id3155923" role="tablecontent">$[officename] determines the type.</paragraph> + <tip id="par_id651786970363868">ISO 8601 date format will be detected as date even if the <menuitem>Detect special numbers</menuitem> is not checked.</tip> </tablecell> </tablerow> <tablerow> diff --git a/source/text/shared/00/00000401.xhp b/source/text/shared/00/00000401.xhp index babdb6ec2e..e3cc47d7b5 100644 --- a/source/text/shared/00/00000401.xhp +++ b/source/text/shared/00/00000401.xhp @@ -819,11 +819,26 @@ </section> <paragraph role="paragraph" id="par_id3149328"><variable id="neuglobal">Choose <menuitem>File - New - Master Document</menuitem>.</variable></paragraph> + <section id="textimport"> -<paragraph role="paragraph" id="par_id3145827">Choose <menuitem>File - Open - File type</menuitem>, select <emph>Text CSV</emph>.</paragraph> -<paragraph role="paragraph" id="par_id6071352">Choose <menuitem>Data - Text to Columns</menuitem> (Calc).</paragraph> -<paragraph role="paragraph" id="par_id161656944575459">Copy data to clipboard, then choose <menuitem>Edit - Paste Special - Paste Special</menuitem> (Calc).</paragraph> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id3145827">Choose <menuitem>File - Open - File type</menuitem>, select <emph>Text CSV</emph>.</paragraph> + <switch select="appl"> + <case select="CALC"> + <paragraph role="paragraph" id="par_id6071352">Choose <menuitem>Data - Text to Columns</menuitem> (Calc).</paragraph> + <paragraph role="paragraph" id="par_id161656944575459">Copy data to clipboard, then choose <menuitem>Edit - Paste Special - Paste Special</menuitem> (Calc).</paragraph> + </case> + </switch> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id971786969339226">On the <menuitem>File</menuitem> tab, choose <menuitem>Open - File type</menuitem>, select <emph>Text CSV</emph>.</paragraph> + <switch select="appl"> + <case select="CALC"> + <paragraph role="paragraph" id="par_id761786971775355">On the <menuitem>Data</menuitem> tab, Choose <menuitem>Text to Columns</menuitem>.</paragraph> + <paragraph role="paragraph" id="par_id701786971779058">Copy data to clipboard, then on the <menuitem>Home</menuitem> tab do a long click on <menuitem>Paste</menuitem> and select <menuitem>Unformatted text</menuitem> or <menuitem>Unformatted text (TSV Calc)</menuitem>.</paragraph> + </case> + </switch> </section> + <paragraph role="paragraph" id="par_id3148608"><variable id="epsexport">Choose <menuitem>File - Export</menuitem>, if EPS is selected as file type, this dialog opens automatically.</variable></paragraph> <paragraph role="paragraph" id="par_id3150107"><variable id="pbmppmpgm">Choose <menuitem>File - Export</menuitem>, if PBM, PPM or PGM is selected as file type, the dialog opens automatically.</variable></paragraph>
