We didn't do this, excel did. We try and smooth things like this over but in some places the file format shows its ugly head above the HSSF face mask.
-Andy
John Lloyd wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
