Hi,
I'm trying to merge two workbooks using JExcelApi (basically by importing all sheets from one workbook to another) : the sheets get merged correctly, unfortunatly the background of all cells is black, except for those which already has a background color. Some background colors get changed randomly as well (e.g. blue becomes red).
First I thought it was an issue with the "WritableWorkbook.importSheet()" method, but it turns out that by simply loading a workbook and rewriting it on different location cause the problem.
I tried to use the "WritableWorkbook.setColourRGB()" to set the Colour.BLACK to white (I even tried to change all the colors to white, for debug purpose), but all the cells remain BLACK.
Can somebody help me on this issue ?
Thanks