Unable to format cell from exported excel file

[kiran_raja]

Hi,

I have generated/exported  the jasper report to an excel file. When i open in MSExcel an try to format the cell format manually there is no change at all. That is I first try to bold the cell value, then try to Italized the font in the cell, there is no changes. Also if i right click the cell value with the mouse and select "Format Cells" from the menu, then no popup appears.

Now If i first underline the value in the cell and then select to bold the text in the cell. Then it works fine. that is, all the formatting works :) , only if i first underline the cell value and then apply other formatting changes.  So i have to first underline and then do other changes.This is a work around only. I want to know how i can bold the text in the cell at first selection only.

Thanks in advance.

Post Edited by kiran_raja at 04/06/2010 03:52

[kiran_raja]

i am using jasper reports 3.1.0

Found that if we use forecolor="black" for report element in TextField , then this issue is faced. So i changed the forecolor to "#060404" and the issue was solved.