On Fri, 11 Jul 2008, mjw_85uk wrote:
I may have come up with a solution myself. It is to get the cellStyle from the cellthat is being copied over. Check to see if the style exists in the new workbook the cell is being copied to. If it does exists thenapply that to the new cell and if id doesn't exist add it to the style table and then apply it to the newly created cell. Do you think that would work?
That will work, yes. To make your life easier, if you grab a recent svn checkout / nightly build from tonight on, you'll find a new method on HSSFCellStyle. The cloneStyleFrom(HSSFCellStyle base) method will copy all the style properties from one HSSFCellStyle onto another, and handle all the tricky bits if they happen to belong to different HSSFWorkbooks
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
