You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2006/02/02 11:19:45 UTC
DO NOT REPLY [Bug 38486] New: - Error retrieving cell background colour in Excel 2003
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
Summary: Error retrieving cell background colour in Excel 2003
Product: POI
Version: 2.5
Platform: PC
OS/Version: Windows XP
Status: UNCONFIRMED
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: poi-dev@jakarta.apache.org
ReportedBy: thestonefox@hotmail.com
When I try and use the getFillBackgroundColor() method it does not return the
correct index
it returns 64 if the cell has a colour (regardless of what the colour is)
and it returns 65 if the cell has no colour
getFillForegroundColor() returns the correct colour index though, so I assume
this is a bug in getFillBackgroundColour()
I am using this on Excel 2003 if that makes any difference.
example code
int maxRows=sheet.getPhysicalNumberOfRows();
for (int i=0;i<maxRows;i++)
{
//check background colour
HSSFRow checkRow = sheet.getRow(i);
HSSFCell checkCell = checkRow.getCell((short)0);
HSSFCellStyle bgCol=checkCell.getCellStyle();
String myCol=String.valueOf(bgCol.getFillBackgroundColor());
System.out.println(i+" "+myCol+ " : "+checkCell.getNumericCellValue());
}
--
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/
DO NOT REPLY [Bug 38486] - Error retrieving cell background colour in Excel 2003
Posted by 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/