mcoddington

I had a similar issue which I posted here: http://community.jaspersoft.com/questions/803819/multisheet-report-excel-changes-font-color-print-preview And here is the work around I posted over there: I still do not know the root cause or whether it's an issue with Jasper, Excel or both; I've got a work around though. I noticed that in Excel, the cells that were changing color when printing had a color set to 'Automatic' instead of #000000 (Black), as defined in the report template. Also, cells where I had a conditional style resulting in a Red color were unaffected by the color change bug. Work around to prevent this issue: I set my default style to have a forecolor of #010101 instead of #000000. This prevents the cells from having a color of 'Automatic' and prevents the color change when previewing/printing.

Over a year later I came back to this issue and finally made some progress. I still do not know the root cause or whether it's an issue with Jasper, Excel or both; I've got a work around though. New information: Noticed that in Excel, the cells that were changing color when printing had a color set to 'Automatic' instead of #000000 (Black), as defined in the report template. Also, cells where I had a conditional style resulting in a Red color were unaffected by the color change bug. Work around to prevent this issue: I set my default style to have a forecolor of #010101 instead of #000000. This prevents the cells from having a color of 'Automatic' and prevents the color change when printing.

Hi, I am having an odd problem with a report that is exported to Excel that I am unsure how to diagnose. When I open the excel report, click Print, and choose to 'Print Entire Workbook', all of the sudden the font color changes for the whole report. It changes to a seemingly random color, changes each time I do it. It doesn't change the font in the regular view of excel. If I exit the print preview the text is back to black. But if I execute the print it does print in that new color. I have a lot of different reports exported to excel, and this only seems to happen on the one report I have that creates multiple worksheets. I've removed all the coloring that I had in my template, and this still happens. Does anyone have any idea what could be causing this, or suggestions on debugging it? Thanks in advance, Mike

If I understand correctly, having two subsequent groups should accomplish the same effect: <groupExpression><![CDATA[$F{firstName}]]</groupExpression> --leave this group empty-- <groupExpression><![CDATA[$F{gender}]]</groupExpression> --show data in second group-- This will put all equal firstNames together and then within lists of the same firstName, entries will be grouped by gender. Mike

FYI - I had the same issue as RMorrisey. I tried setting the positionType and stretchType to all of their various options but then eventually figured out to set verticalAlignment="Middle". Hope that helps if anyone else gets stuck. Thanks, Mike