From 7488c63b40d151384e8aae67f78d804962e99c99 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Tue, 26 Oct 2021 21:28:43 -0300 Subject: Add 12th param description for Calc CSV import Change-Id: I4aeeaabe4f3894dac067556824a8c3762c273dbe Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124250 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/shared/guide/csv_params.xhp | 80 ++++++++++++++++++--------------- 1 file changed, 45 insertions(+), 35 deletions(-) (limited to 'source') diff --git a/source/text/shared/guide/csv_params.xhp b/source/text/shared/guide/csv_params.xhp index 75e87f8cfc..2ac056ad5e 100644 --- a/source/text/shared/guide/csv_params.xhp +++ b/source/text/shared/guide/csv_params.xhp @@ -24,8 +24,13 @@

CSV Filter Options

- The CSV filter accepts an option string containing five to twelve tokens, separated by commas. Tokens 6 to 12 are optional. + The CSV filter accepts an option string containing five to thirteen tokens, separated by commas. Tokens 6 to 13 are optional.
+ + Import from UTF-8, Language German, Comma separated, Text delimiter ", Quoted field as text. CSV file has columns formatted as date, number, number, number: + soffice --infilter="Text - txt - csv (StarCalc):44,34,76,1,1/5/2/1/3/1/4/1,1031,true,true" test.csv + Export to Windows-1252, Field delimiter : comma, Text delimiter : quote, Save cell contents as shown: + soffice --convert-to "Text - txt - csv (StarCalc):44,34,ANSI,1,,0,false,true,true" --outdir=/home/user test.ods @@ -57,7 +62,7 @@ Text Delimiter - The text delimiter as ASCII value, that is, 34 for double quotes and 39 for single quotes. Example: 34 (") + The text delimiter as ASCII value, that is, 34 for double quotes and 39 for single quotes. Example: 34 ("). @@ -68,7 +73,7 @@ Character Set - The character set code used in the file as described in the table below. Example: 0 (System) + The character set code used in the file as described in the table below. Example: 0 (System). @@ -76,10 +81,10 @@ 4 - Number of First Line + Number of First Row - 3 (start from third line) + Row number to start reading. Example: 3 (start from third row). @@ -90,9 +95,9 @@ Cell Format Codes for Each Column - A sequence of column/formatting code, where the formatting code is given in the table below. Example: 1/5/2/1/3/1/4/1 - If value separators are used, the form of this token is column/format[/column/format/…] where column is the number of the column, with 1 being the leftmost column. The format is explained below. - If the first token is FIX it has the form start/format[/start/format/…], where start is the number of the first character for this field, with 0 being the leftmost character in a line. The format is explained below. + A sequence of column/formatting code, where the formatting code is given in the table below. Example: "1/5/2/1/3/1/4/1". + If value separators are used, the form of this token is column/format[/column/format/…] where column is the number of the column, with 1 being the leftmost column. The format code is detailed below. + If the first token is FIX it has the form start/format[/start/format/…], where start is the number of the first character for this field, with 0 being the leftmost character in a line. The format is explained below. @@ -114,7 +119,7 @@ CSV Import, CSV Export - String, either false or true. Default value: false.This token is the equivalent of the check box "Quoted field as text". + String, either false or true. Default value: false. This token is the equivalent of the check box "Quoted field as text". @@ -134,11 +139,10 @@ 9 - CSV Import, CSV Export + CSV Export - Import: Not used: only 8 tokens are used. - Export: String, either false or true. Default value:true. This token is the equivalent of the check box "Save cell contents as shown". + String, either false or true. Default value:true. This token is the equivalent of the check box "Save cell contents as shown". @@ -146,29 +150,29 @@ 10 - CSV export + CSV Export - Export formulas + String, either false or true. Default value: false. Export cell formulas. - 11 + 11 - CSV export + CSV Import - Remove space + String, either false or true. Default value: false. Remove spaces. Trim leading and trailing spaces, when reading the file. - 12 + 12 - CSV export + CSV Export Export the entire document to individual sheets .csv files or a specified sheet. @@ -185,13 +189,19 @@ + + + 13 + + + CSV Import + + + String, either false or true. Default value: false. Determines whether formula expressions starting with a = equal sign character are to be evaluated as formulas or imported as textual data. If true evaluate formulas on input. If false formulas are input as text. If omitted (not present at all), the default value is true to keep the behaviour of old versions' options string that didn't have this token at all. If present and empty (or any other value than true) the default value is false. + +
- - Import from UTF-8, Language German, Comma separated, Text delimiter ", Quoted field as text. CSV file has columns formatted as date, number, number, number: - soffice --infilter="Text - txt - csv (StarCalc):44,34,76,1,1/5/2/1/3/1/4/1,1031,true,true" test.csv - Export to Windows-1252, Field delimiter : comma, Text delimiter : quote, Save cell contents as shown: - soffice --convert-to "Text - txt - csv (StarCalc):44,34,ANSI,1,,0,false,true,true" --outdir=/home/user test.ods -

Formatting codes for Token 5

+

Formatting Codes for Token 5

@@ -203,43 +213,43 @@ Standard - 1 + 1 Text - 2 + 2 MM/DD/YY - 3 + 3 DD/MM/YY - 4 + 4 YY/MM/DD - 5 + 5 - - 6 + 6 - - 7 + 7 - - 8 + 8 Ignore field (do not import) - 9 + 9 US-English - 10 + 10

Character Set Codes for Token 3

-- cgit