I am using iReport 5.6 and when I set conditional formatting for cells in a table preview in iReport works ok
When I save as xls document the table is shown the cells are colored and values are in the cells but they (values) are not displayed. If I set cell color to normal I can see the values. Any ideas how to fix it. Either in Excel or iReport (preferably)?
Print screen of excel
If I select colored cells and change the type (from cutom to any other) it solves the problem