mcoddington
-
Posts
5 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Everything posted by mcoddington
-
Help,font color changed when preview in MS Excel
mcoddington replied to achui_1980's topic in Products
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. -
Multisheet Report in Excel changes Font Color in Print Preview
mcoddington replied to mcoddington's topic in Products
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
