Stephen,
I had the same problem you are having and I couldn't solve it
using the Xls Exporter. Instead I used the CSV exporter. The report
will not look like the PDF report, but it is much more functional than
the XLS file.
The reason why I didn't want to use the the XLS format is because in
XLS it only looks nice, but it's not functional. It adds lots of extra
columns and it doesn't treat currency as number, but as text. That
makes it difficult for the user to manipulate the data.
That's why I decided to use CSV, the format is simpler and all the
data is treated as it should.
Try reading the "Making HTML, XLS or CSV friendly reports" section of
the Jasper Reports Tips & Tricks article, so that the CSV files you
generate have no extra columns.
http://jasperreports.sourceforge.net/tips.tricks.html
This is a link to a question I posted a few days ago about the same topic:
http://www.mail-archive.com/jasperreports-questions@lists.sourceforge.net/msg00572.html
Hope it helps.
Laura.
> Message: 1
> Date: Mon, 28 Aug 2006 15:26:24 -0400
> From: "Wetzelberger, Stephen" <[EMAIL PROTECTED] >
> Subject: [jasperreports-questions] Excel-friendly report
> To: <jasperreports-questions@lists.sourceforge.net>
> Message-ID:
> < [EMAIL PROTECTED]>
> Content-Type: text/plain; charset="iso-8859-1"
>
> All, I am trying to download a report to Excel. I have used the Excel
> exporter. This works well, and looks like the report from a visual
> standpoint. But the data is unusable in Excel. Formulas do not work etc. Any
> ideas? Thanks in advance...
>
> Stephen Wetzelberger
> Sr. Software Engineer
> TBB Global Logistics
> (717)227-5725
> [EMAIL PROTECTED]
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://sourceforge.net/mailarchive/forum.php?forum=jasperreports-questions/attachments/20060828/74792542/attachment.html
>
> ------------------------------
>
> Message: 2
> Date: Tue, 29 Aug 2006 10:37:41 +0300
> From: Lucian Chirita < [EMAIL PROTECTED]>
> Subject: Re: [jasperreports-questions] Excel-friendly report
> To: jasperreports-questions@lists.sourceforge.net
> Message-ID: < [EMAIL PROTECTED] >
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> If you use JR 1.2.5, you could try setting the
> JRXlsExporterParameter.IS_DETECT_CELL_TYPE flag when exporting. This
> would ensure that text fields that have numerical/date expressions
> produce numerical/date Excel cells.
>
> HTH,
> Lucian
>
> Wetzelberger, Stephen wrote:
> >
> > All, I am trying to download a report to Excel. I have used the Excel
> > exporter. This works well, and looks like the report from a visual
> > standpoint. But the data is unusable in Excel. Formulas do not work
> > etc. Any ideas? Thanks in advance...
> >
> > /Stephen Wetzelberger/
> > /Sr. Software Engineer/
> > /TBB Global Logistics/
> > /(717)227-5725/
> > /[EMAIL PROTECTED]/
> >
> >
> > ------------------------------------------------------------------------
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
