[
https://issues.apache.org/jira/browse/SANDBOX-210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12625734#action_12625734
]
pcsri1956 edited comment on SANDBOX-210 at 8/26/08 6:54 AM:
------------------------------------------------------
The CSV that Excel outputs differs from the standard in several respects:
Leading and trailing whitespace is significant.
A backslash is not a special character and is not used to escape anything.
Quotes inside quoted strings are escaped with a double quote rather than a
backslash.
Quoted from here :
http://www.ssg.uab.edu/hdbstat/reports/api/hdbstat/reports/ExcelCSVPrinter.html
was (Author: pcsri1956):
The CSV that Excel outputs differs from the standard in several respects:
Leading and trailing whitespace is significant.
A backslash is not a special character and is not used to escape anything.
Quotes inside quoted strings are escaped with a double quote rather than a
backslash.
> Commons CSV EXCELL_STRATEGY is reading CSV files with double quote and comma
> properly but not writing them back the same way
> ----------------------------------------------------------------------------------------------------------------------------
>
> Key: SANDBOX-210
> URL: https://issues.apache.org/jira/browse/SANDBOX-210
> Project: Commons Sandbox
> Issue Type: Bug
> Components: CSV
> Reporter: Ilya Egoshin
> Attachments: CSVPrinter.java
>
>
> original line: My line is containing ", symbols
> line in CSV file after "Save as CSV" in Excell: "My line containing "",
> symbols"
> line is CSV file as output from CSVPrinter with EXCELL_STRATEGY: "My line
> containing \", symbols"
> as a result when you will try to open that file in the excell you see text
> inside two cells:
> 1 cell: My line containing \
> 2 cell: symbols
> is it again Microsoft "features", that are "improving" RFC?
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
