https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292010-12-03T19:17:35ZRedmineRedmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=229752010-12-03T19:17:35ZJohn Yani
<ul></ul><p>Open Office Calc BTW handles it fine.<br />Excel version: 2007</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=250872011-02-10T16:34:44ZJonas Schulz
<ul></ul><p>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.</p>
<p>Are there any other chance to drop out that field without modification of the issues_helper.rb?</p>
<p>Thank you in advance!</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=253242011-02-18T15:53:40ZEtienne Massip
<ul><li><strong>Category</strong> set to <i>Issues</i></li><li><strong>Affected version (unused)</strong> set to <i>1.1.0</i></li><li><strong>Affected version</strong> set to <i>1.1.0</i></li></ul> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=267232011-03-22T16:30:33ZEtienne Massip
<ul><li><strong>File</strong> <a href="/attachments/5624">Classeur1.csv</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/5624/Classeur1.csv">Classeur1.csv</a> added</li></ul>Data of cells containing line breaks in Excel 2003 is outputted the following way in the resulting CSV file :
<ul>
<li>cell content is surrounded by quotes</li>
<li>line breaks are LF only</li>
</ul>
<p>Here's an example (separator is semi-colon).</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=267252011-03-22T16:31:55ZEtienne Massip
<ul><li><strong>Target version</strong> set to <i>Candidate for next major release</i></li></ul> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=271732011-03-26T15:34:12ZEtienne Massip
<ul><li><strong>File</strong> <a href="/attachments/5674">csv_issue_description_eol.patch</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/5674/csv_issue_description_eol.patch">csv_issue_description_eol.patch</a> added</li><li><strong>File</strong> <a href="/attachments/5675">csv_text_fields_eol.patch</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/5675/csv_text_fields_eol.patch">csv_text_fields_eol.patch</a> added</li></ul>2 patches :
<ol>
<li>either simply replace \r\n EOLs with \n in issue description (<code>IssueHelper</code> change)</li>
<li>or replace \r\n EOLs with \n in all text fields (<code>FasterCSV</code> change)</li>
</ol> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=271952011-03-27T17:39:22ZJean-Philippe Langjp_lang@yahoo.fr
<ul><li><strong>File</strong> <a href="/attachments/5686">Classeur1.csv</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/5686/Classeur1.csv">Classeur1.csv</a> added</li><li><strong>File</strong> <a href="/attachments/5687">excel2007.png</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/5687/excel2007.png">excel2007.png</a> added</li></ul><p>Works fine for me with Excel 2007. The same file with CRLF and what it gives in Excel 2007:</p>
<p><img src="https://www.redmine.org/attachments/download/5687/excel2007.png" title="Display in Excel 2007" alt="Display in Excel 2007" /></p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=271972011-03-27T20:50:58ZEtienne Massip
<ul></ul><p>Gosh, right.</p>
<p>Excel 2003 renders the \r with a square character inside the cell :/</p>
<p>So that's basically an Excel version support question...</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=272032011-03-28T07:19:39ZEtienne Massip
<ul></ul><p>Jonas, could you post a sample of a non-working Excel 2007 workbook, please ?</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=272202011-03-28T14:04:30ZEtienne Massip
<ul><li><strong>Target version</strong> deleted (<del><i>Candidate for next major release</i></del>)</li></ul> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=283952011-04-28T15:58:31ZRolf Stetter
<ul><li><strong>File</strong> <a href="/attachments/5889">excel2010.png</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/5889/excel2010.png">excel2010.png</a> added</li></ul><p>Jean Philippe, <br />this is the result with Excel 2010 when opening your sample CSV:<br /><img src="https://www.redmine.org/attachments/download/5889/excel2010.png" alt="" /></p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=283972011-04-28T16:01:37ZEtienne Massip
<ul></ul><p>Just raise the height of line 3.</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=284012011-04-28T17:10:38ZRolf Stetter
<ul></ul><p>ups.. you are right!<br />So, I am very interested in getting your fix released..<br />Don't want to start patching.</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=284022011-04-28T17:27:07ZEtienne Massip
<ul></ul><p>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.</p>
<p>My patch simply replace CRLF inside column data with LF so it can be opened with Excel 2003.</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=321112011-09-09T12:45:52ZSven Müller
<ul></ul><p>In <a href="http://de.wikipedia.org/wiki/CSV_%28Dateiformat%29#Besonderheiten_beim_Import" class="external">german Wikipedia</a> there is a hint:</p>
<blockquote>
<p>Trennzeichen ist stillschweigend Semikolon, wenn die CSV Datei nach ANSI-Norm gespeichert ist</p>
</blockquote>
<blockquote>
<p>Trennzeichen ist stillschweigend Tabulator, wenn die CSV Datei in Unicode-Format gespeichert ist</p>
</blockquote>
<p>The delimiter <code>semicolon</code> is expected when file is in ANSI.<br />The delimiter <code>TAB</code> is expected when file is in Unicode.</p>
<p>So is there a way to configure Redmine, to select eigther <code>comma</code> or <code>semicolon</code> for cvs files?</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=321142011-09-09T13:42:09ZSven Müller
<ul><li><strong>File</strong> <a href="/attachments/6528">faster_csv.rb.patch</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/6528/faster_csv.rb.patch">faster_csv.rb.patch</a> added</li></ul><p>I#ve tried to path one file. But in exported.csv are still <code>comma</code></p>
<p>Any idea why?</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=321152011-09-09T13:44:35ZEtienne Massip
<ul></ul><p>Sven Müller wrote:</p>
<blockquote>
<p>I#ve tried to path one file. But in exported.csv are still <code>comma</code></p>
<p>Any idea why?</p>
</blockquote>
<p>Did you read the issue description?</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=442012013-01-13T16:07:47ZIkon Ikon
<ul></ul><p>Hello guys,<br />still problems for me in Excel 2010. You need to do this:</p>
<p>*Use ";" to separate fields (column separator)<br />*Use CR+LF for line break out of text fields (row separator)<br />*Use LF for line break inside text fields (these are line breaks that will break cell text on multiple lines)</p>
<p>In that case, Excel will be happy. Tell me please the script to edit in order to fix the bug.</p>
<p>Thanks!</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=449182013-01-24T12:07:16ZSergey Prosin
<ul></ul><p>Hi, lkon.<br />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.</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=540232013-12-27T07:10:29ZDoan Phuoc
<ul></ul><p>Hi all,<br />I used redmine 2.3.3 and i can't fix it. May be help me.<br />I want export csv whith vietnamese language.<br />Thanks</p> Redmine - Defect #7039: CSV export. Line breaks. Excelhttps://www.redmine.org/issues/7039?journal_id=631942015-04-18T03:52:36ZToshi MARUYAMA
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>Wont fix</i></li></ul><p>Etienne Massip wrote:</p>
<blockquote>
<p>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.</p>
</blockquote>
<p>I agree.</p>
<p>CSV character encoding in this issue is duplicate of <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Defect: CSV export encoding problem when issues and interface languages are not equal (Closed)" href="https://www.redmine.org/issues/11116">#11116</a>.</p>