i am using jxl to create excel sheet and writing data into it. Now my problem is when i merge cells in excel sheet the data contained in the those sheet do not get displayed into merged cell.
so is it possible to merge cells without loosing data in all cells ??
i want to print this string -- "exprName 14 : 5 : 0 " in a single cell. i want all the numbers to be in a different colors.
first i have tried to make a single label with different colors and add it to single cell. but i could not do it.
so i tried a new way to split the string in different cells with differnt colored labels and then merge these cells but after mergeing cells the merged cell contains only the top left cell value.
so i am stuck with this. so is there can anyone suggest me new solution ??
@Martin Vajsar : Thank you !! the MS excel do not allow to display hidden cell values into merged cell but Open Office Calc provides this functionality.
Just tried to create a cell manually in Excel (the application) which contains letters of different colors. That is possible, and of course it is possible for merged cells too.
I have no idea whether JExcelApi supports that, though. The API would have to provide some methods to manipulate formats of individual characters in a cell. (A cursory look at the javadoc gave me an impression this is not supported, but I may be wrong.)
subject: jxl - problem with merging cells in excel file.