DO NOT REPLY [Bug 38486] - Error retrieving cell background colour in Excel 2003

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=38486>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=38486


jheight@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |FIXED




------- Additional Comments From jheight@apache.org  2006-07-24 12:18 -------
Ok i have looked into the issue and committed a change to svn.

>From experiments, i have found that the value 64 (dec) is a special case. It is
 actually the AUTOMATIC or default color in excel. This is true for everything
except the font color (Doh!) which retains 7FFF as its default color.

HOWEVER, for some reason excel uses 65 (dec) for the background when a
foreground is set to AUTOMATIC ie No Fill. Wierd.

I have added a HSSFColor.AUTOMATIC class with the 64 special case. In addition i
have "hidden" the 65 case in the HSSFCellStyle, it will not return 64 when 65
and perform the necessary conversion automatically and internally. A byproduct
of the conversion is that Foreground needs to be set before Background. this is
noted in the javadoc.

Seems to work OK, reopen if you have any issues.

Jason

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/