https://issues.apache.org/bugzilla/show_bug.cgi?id=46938
--- Comment #12 from Karl Eilebrecht <karl.eilebre...@freenet.de> 2009-11-14 07:54:38 UTC --- Finally, my results regarding this issue are a little disappointing. The main problem cannot be fixed because the color models of Excel 2007 is simply incompatible to that of earlier versions. There are several discussions in the web, for example: http://en.allexperts.com/q/Excel-1059/Excel-2007-color-palette-1.htm http://www.eggheadcafe.com/software/aspnet/31785528/excel-2007-color-backward.aspx http://www.excelforum.com/excel-2007-help/703936-fill-color-compatibility-excel-2007-to-excel-2003-a.html Especially the last link seems to be interesting for template creators to completely avoid the problem in advance. However for my situation the attached modified Workbook-class helped. We use Excel 2007 but old Excel .xls-format (NOT .xlsx). This is far from being perfect, but I did not have the time yet to migrate to XSSF. The attached patch is experimental but I think it works. The idea is to save the positions of UnknownRecords containing the new color information, so that Excel 2007 will show the original colors when reopening a POI-modified workbook instead of replacing them with "similar colors". Unfortunately earlier versions of Excel (I tested with Excel 2000) will still show replacement colors, if a workbook contains "new color-model colors". Regards. Karl -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
