[
https://issues.apache.org/jira/browse/CSV-219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16286119#comment-16286119
]
Charles Honton commented on CSV-219:
------------------------------------
The quoting of the first row probably has something to do with excel misreading
certain prefixes. For example, [if the first field starts with 'ID', then
excel will interpret the file as SYLK
format|https://support.microsoft.com/en-us/help/323626/-sylk-file-format-is-not-valid-error-message-when-you-open-file].
I'm not sure that this is a bug. Just a different, more conservative format.
I'd suggest making sure there is a unit test with first field containing "ID"
> The behavior of quote char using is not similar as Excel does when the first
> string contains CJK char(s)
> --------------------------------------------------------------------------------------------------------
>
> Key: CSV-219
> URL: https://issues.apache.org/jira/browse/CSV-219
> Project: Commons CSV
> Issue Type: Bug
> Components: Printer
> Affects Versions: 1.5
> Reporter: Zhang Hongda
> Attachments: diff.patch
>
>
> When using CSVFormat.EXCEL to print a CSV file, the behavior of quote char
> using is not similar as Microsoft Excel does when the first string contains
> Chinese, Japanese or Korean (CJK) char(s).
> e.g.
> There are 3 data members in a record, with Japanese chars: "あ", "い", "う":
> Microsoft Excel outputs:
> あ,い,う
> Apache Common CSV outputs:
> "あ",い,う
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
