I saw a similar post about this issue with a PDF, but I didn't see the option for setting the same property that fixed the issue for PDF in CSV.
I have a report that I've created exclusively for outputing to CSV (the end goal being that I need to export raw data from a JNDI datasource outside of our network into a SQL server on our domain). The output data is 56 columns (every column from a single table) and I created it from the wizard because I didn't want to manually place all 56 columns from the source (and 56 headers). I've already removed the page and report headers and footers, page numbers and whatnot. The only access that I'm aware that the data owners have given me to the data model itself (table or field names, column widths, data types, etc.) is through the GUI in the Pentaho query designer.
When I open up a Preview from the query, I see data. When I open up the CSV output in Excel, I see this (first two rows are completely blank, so I excluded them):
A B C D E F G etc. 3 .. .. .. .. .. .. .. etc. 4 .. .. .. etc. 5 .. .. .. August 1, 2012 .. .. etc. 6 .. .. .. etc. 7 .. .. .. Feb 22,2012 .. etc. etc. etc. etc. etc. etc. etc. etc. etc. etc.
The first column is an ID number - how can this be into overflow when there is room for an entire spelled-out date 3 columns over?
Please be patient with me - I try to be well-versed in a lot of things, but Pentaho reporting is not one of them (yet).