exporting problem: borders and background colors

[pedror]

Hi everybody!

I have two problems related with styles

1st problem: When I try to export in PPTX format, the borders defined in iReport isn't visible in this kind of files.

2nd problem: the labels in the column header has a color (some type of grey) and in the details band I have fields with alternate colors (some kind of light red and white). When the excel file is opened I have no grey labels and the light red becomes light yellow

(Edit: I'm using JExcelApiExporter ).

All others formats it's great.

ANY IDEIAS?

Thanks in advance!!

Code:

Code:

JExcelApiExporter exporter = new JExcelApiExporter();		exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);		exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());	    exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,	Boolean.FALSE);	   exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);	       exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);	exporter.setParameter(JRXlsExporterParameter.IS_IGNORE_CELL_BACKGROUND, Boolean.FALSE);		exporter.exportReport();

Post Edited by pedror at 07/22/2010 14:44

[lucianc]

pedror
Wrote:

1st problem: When I try to export in PPTX format, the borders defined in iReport isn't visible in this kind of files.

Works fine for me.  Attach a JRXML and a PPTX file.  Which JR version are you using?

2nd problem: the labels in the column header has a color (some type of grey) and in the details band I have fields with alternate colors (some kind of light red and white). When the excel file is opened I have no grey labels and the light red becomes light yellow

See JExcelApiExporterParameter.CREATE_CUSTOM_PALETTE

Regards,

Lucian

[pedror]

Hi Lucian.

Thanks for answering and i'm sorry for replying only now, but I have been involved in other projects.

I solved my two problems according with your tips. For my second problem in iReport  I had to create before a custom palette in the export options > Excel > JExcelApiExporter.  ( http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=41846 ).

 

Thanks a lot.