Project

General

Profile

Actions

Defect #7039

closed

CSV export. Line breaks. Excel

Added by John Yani over 13 years ago. Updated almost 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Issues
Target version:
-
Start date:
2010-12-03
Due date:
% Done:

0%

Estimated time:
Resolution:
Wont fix
Affected version:

Description

When I make csv export of issues and open the result in Excel, line breaks (CR/LF) in description field are not correctly displayed.


Files

Classeur1.csv (64 Bytes) Classeur1.csv Example CSV file Etienne Massip, 2011-03-22 17:30
csv_issue_description_eol.patch (604 Bytes) csv_issue_description_eol.patch IssueHelper change Etienne Massip, 2011-03-26 16:34
csv_text_fields_eol.patch (1.31 KB) csv_text_fields_eol.patch FasterCSV change Etienne Massip, 2011-03-26 16:34
Classeur1.csv (66 Bytes) Classeur1.csv CSV with CRLF in a cell Jean-Philippe Lang, 2011-03-27 19:39
excel2007.png (2.2 KB) excel2007.png Display in Excel 2007 Jean-Philippe Lang, 2011-03-27 19:39
excel2010.png (3.05 KB) excel2010.png Rolf Stetter, 2011-04-28 17:58
faster_csv.rb.patch (2.58 KB) faster_csv.rb.patch Patch that doesn't work Sven Müller, 2011-09-09 15:42

Related issues

Related to Redmine - Defect #7096: CSV Issues Export + Ruby 1.9 + Thin + non-ascii characters causes "invalid byte sequence in US-ASCII"Closed2010-12-11

Actions
Related to Redmine - Feature #7037: CSV export encoding and excel. UTF-8 and BOMClosedJean-Philippe Lang2010-12-03

Actions
Has duplicate Redmine - Defect #7958: Irregular CSV file (caused by "Description" field)Closed2011-03-22

Actions
Actions #1

Updated by John Yani over 13 years ago

Open Office Calc BTW handles it fine.
Excel version: 2007

Actions #2

Updated by Jonas Schulz about 13 years ago

Please review this bug, it is still open in version 1.1. The CR/LF issue in the description field will prevent the correct import under excel 07.

Are there any other chance to drop out that field without modification of the issues_helper.rb?

Thank you in advance!

Actions #3

Updated by Etienne Massip about 13 years ago

  • Category set to Issues
  • Affected version (unused) set to 1.1.0
  • Affected version set to 1.1.0
Actions #4

Updated by Etienne Massip almost 13 years ago

Data of cells containing line breaks in Excel 2003 is outputted the following way in the resulting CSV file :
  • cell content is surrounded by quotes
  • line breaks are LF only

Here's an example (separator is semi-colon).

Actions #5

Updated by Etienne Massip almost 13 years ago

  • Target version set to Candidate for next major release
Actions #6

Updated by Etienne Massip almost 13 years ago

2 patches :
  1. either simply replace \r\n EOLs with \n in issue description (IssueHelper change)
  2. or replace \r\n EOLs with \n in all text fields (FasterCSV change)
Actions #7

Updated by Jean-Philippe Lang almost 13 years ago

Works fine for me with Excel 2007. The same file with CRLF and what it gives in Excel 2007:

Display in Excel 2007

Actions #8

Updated by Etienne Massip almost 13 years ago

Gosh, right.

Excel 2003 renders the \r with a square character inside the cell :/

So that's basically an Excel version support question...

Actions #9

Updated by Etienne Massip almost 13 years ago

Jonas, could you post a sample of a non-working Excel 2007 workbook, please ?

Actions #10

Updated by Etienne Massip almost 13 years ago

  • Target version deleted (Candidate for next major release)
Actions #11

Updated by Rolf Stetter almost 13 years ago

Jean Philippe,
this is the result with Excel 2010 when opening your sample CSV:

Actions #12

Updated by Etienne Massip almost 13 years ago

Just raise the height of line 3.

Actions #13

Updated by Rolf Stetter almost 13 years ago

ups.. you are right!
So, I am very interested in getting your fix released..
Don't want to start patching.

Actions #14

Updated by Etienne Massip almost 13 years ago

This issue should probably be closed as a "Won't fix" since Excel >= 2007 opens Redmine exported CSV files containing EOLs just fine and supporting old Excel 2003 seems quite unnecessary now.

My patch simply replace CRLF inside column data with LF so it can be opened with Excel 2003.

Actions #15

Updated by Sven Müller over 12 years ago

In german Wikipedia there is a hint:

Trennzeichen ist stillschweigend Semikolon, wenn die CSV Datei nach ANSI-Norm gespeichert ist

Trennzeichen ist stillschweigend Tabulator, wenn die CSV Datei in Unicode-Format gespeichert ist

The delimiter semicolon is expected when file is in ANSI.
The delimiter TAB is expected when file is in Unicode.

So is there a way to configure Redmine, to select eigther comma or semicolon for cvs files?

Actions #16

Updated by Sven Müller over 12 years ago

I#ve tried to path one file. But in exported.csv are still comma

Any idea why?

Actions #17

Updated by Etienne Massip over 12 years ago

Sven Müller wrote:

I#ve tried to path one file. But in exported.csv are still comma

Any idea why?

Did you read the issue description?

Actions #18

Updated by Ikon Ikon about 11 years ago

Hello guys,
still problems for me in Excel 2010. You need to do this:

*Use ";" to separate fields (column separator)
*Use CR+LF for line break out of text fields (row separator)
*Use LF for line break inside text fields (these are line breaks that will break cell text on multiple lines)

In that case, Excel will be happy. Tell me please the script to edit in order to fix the bug.

Thanks!

Actions #19

Updated by Sergey Prosin about 11 years ago

Hi, lkon.
To fix column separator you could edit your regional settings in folder \config\locales. Keep in mind the language you use in interface. Tha name of parameter is general_csv_separator. I'm not a redmine expert ;) so I'm not informed about solutions of line breaks, but may be you could find somethind in these files too.

Actions #20

Updated by Doan Phuoc about 10 years ago

Hi all,
I used redmine 2.3.3 and i can't fix it. May be help me.
I want export csv whith vietnamese language.
Thanks

Actions #21

Updated by Toshi MARUYAMA almost 9 years ago

  • Status changed from New to Closed
  • Resolution set to Wont fix

Etienne Massip wrote:

This issue should probably be closed as a "Won't fix" since Excel >= 2007 opens Redmine exported CSV files containing EOLs just fine and supporting old Excel 2003 seems quite unnecessary now.

I agree.

CSV character encoding in this issue is duplicate of #11116.

Actions

Also available in: Atom PDF