All,
I'm looking at a problem regarding colors when using HSSF to parse an Excel
spreadsheet.
The problem occurs, when I set the fg color in Excel (using Format Cell ->
Patterns) to white. This doesn't change the way the cell looks but it
causes the code below to set fgColor to 10(red). I would have expected
either no fill pattern or 9(white). The obvious answer is don't set it to
white, but unfortunately I can't prevent my users from doing this ;-(.
if (cellStyle.getFillPattern() == 1) {
fgColor = cellStyle.getFillForegroundColor();
...
}
Any comments?
John
Email * [EMAIL PROTECTED]
Phone * 919-254-8021
Snail * MZDA/062, IBM Corp., P.O. Box 12195, RTP, NC 27709-2195
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
