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 [EMAIL PROTECTED] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution| |FIXED ------- Additional Comments From [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
