[How to edit a cell of an Excel Report??]

*double post, apologies

Post edited by: wohshon, at: 2007/08/17 08:55

[How to edit a cell of an Excel Report??]

found the problem:

 

I am using JExcelapi. You may want to read about the problem of formating bordered cells in their yahoo user group here.

Post edited by: wohshon, at: 2007/08/22 07:58

[forecolor of text in xls]

I encountered a different problem with forecolor with xls files. Actually not sure if this is related to jasper generated xls or with hardware.

 

When my report is fitted into a A3 size and printed in color, the black fonts (on a white background) sometimes appear in green, yellow or red. The other colors are not affected.

If I save the file and reprint, the color seems ok but this is not an ideal solution for my users who are generating reports via a web application and would like to print the report with the minimum number of clicks.

 

and of course, printing in pdf is ok.

 

Note that I have used only colors that are excel-friendly / no overlapping cells etc as listed in the faqs. Wonder anyone else ever encountered this problem?

 

Thanks!