diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/guide/csv_formula.xhp')
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/csv_formula.xhp | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/helpcontent2/source/text/scalc/guide/csv_formula.xhp b/helpcontent2/source/text/scalc/guide/csv_formula.xhp index 5e29c0ea5b..906c6e28ce 100755 --- a/helpcontent2/source/text/scalc/guide/csv_formula.xhp +++ b/helpcontent2/source/text/scalc/guide/csv_formula.xhp @@ -53,16 +53,16 @@ oldref="15">To Import a CSV File</paragraph> <list type="ordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3153709" role="listitem" l10n="U" oldref="16">Choose <item type="menuitem">File - Open</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153709" role="listitem" l10n="U" oldref="16">Choose <emph>File - Open</emph>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3155445" role="listitem" l10n="U" oldref="17">In the <item type="menuitem">File type</item> field, select the format "Text CSV". Select the file and click <item type="menuitem">Open</item>. When a file has the .csv extension, the file type is automatically recognized.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155445" role="listitem" 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 xml-lang="en-US" id="par_id3149565" role="listitem" l10n="U" oldref="18">You will see the <item type="menuitem">Text Import</item> dialog. Click <item type="menuitem">OK</item>.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id3149255" role="tip" l10n="CHG" oldref="19">If the csv file contains formulas, but you want to import the results of those formulas, then choose <item type="menuitem">Tools - Options - %PRODUCTNAME Calc - View</item> and clear the <item type="menuitem">Formulas</item> check box.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149255" role="tip" 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 xml-lang="en-US" id="hd_id3154022" role="heading" level="2" l10n="U" oldref="3">To Export Formulas and Values as CSV Files</paragraph> <list type="ordered"> <listitem> @@ -70,26 +70,26 @@ </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3166423" role="listitem" 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 xml-lang="en-US" id="par_id3155111" role="listitem" l10n="U" oldref="6">Choose <item type="menuitem">Tools - Options - %PRODUCTNAME Calc - View</item>.</paragraph> - <paragraph xml-lang="en-US" id="par_id3150200" role="listitem" l10n="U" oldref="7">Under <item type="menuitem">Display</item>, mark the <item type="menuitem">Formulas</item> check box. Click <item type="menuitem">OK</item>.</paragraph> - <paragraph xml-lang="en-US" id="par_id3154484" role="listitem" l10n="U" oldref="8">If you want to export the calculation results instead of the formulas, do not mark <item type="menuitem">Formulas</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155111" role="listitem" l10n="U" oldref="6">Choose <emph>Tools - Options - %PRODUCTNAME Calc - View</emph>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150200" role="listitem" l10n="U" oldref="7">Under <emph>Display</emph>, mark the <emph>Formulas</emph> check box. Click <emph>OK</emph>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154484" role="listitem" 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 xml-lang="en-US" id="par_id3148702" role="listitem" l10n="U" oldref="9">Choose <item type="menuitem">File - Save as</item>. You will see the <item type="menuitem">Save as</item> dialog.</paragraph> + <paragraph xml-lang="en-US" id="par_id3148702" role="listitem" l10n="U" oldref="9">Choose <emph>File - Save as</emph>. You will see the <emph>Save as</emph> dialog.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3153912" role="listitem" l10n="U" oldref="10">In the<emph/> <item type="menuitem">File type</item> field select the format "Text CSV".</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3157978" role="listitem" l10n="U" oldref="13">Enter a name and click <item type="menuitem">Save</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3157978" role="listitem" l10n="U" oldref="13">Enter a name and click <emph>Save</emph>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3152869" role="listitem" l10n="U" oldref="23">From the <item type="menuitem">Export of text files</item> dialog that appears, select the character set and the field and text delimiters for the data to be exported, and confirm with <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3152869" role="listitem" 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 xml-lang="en-US" id="par_id3146781" role="warning" l10n="U" oldref="12">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 xml-lang="en-US" id="par_id3150050" role="listitem" l10n="U" oldref="14">If necessary, after you have saved, clear the <item type="menuitem">Formulas</item> check box to see the calculated results in the table again.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150050" role="listitem" 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"> |