poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 46938] Existing color palette is broken(or not used) when using cell styles from opened workbook and creating new
Date Sat, 14 Nov 2009 15:54:41 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=46938

--- Comment #12 from Karl Eilebrecht <Karl.Eilebrecht@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message