In my spreadsheet, I have a sample region of rows in a single column where the first row has the value "A", and the cell has a white background. The rest of the cells in the column are grey, and are in a single merged region. So, when I click on the "A" cell, it focuses on just that cell. When I click in the cell just below it, it focuses on the entire merged region.
When I parse this with HSSF, when it gets to the cell just below the cell with "A" (the top of the grey merged region), it says that the cell is BLANK, the fill pattern is 1, and the fill foreground index is 22. We'll call this cell ONE. When it gets to the cell below that, which is still in the grey merged region, seemingly identical to the cell above it, it says that the cell is BLANK, but the fill pattern is 0, and the fill foreground index is 64. We'll call this cell TWO. Why is this happening? Is there something special about the top cell in a merged region? I need to be able to tell that cells ONE and TWO are equivalent. --------------------------------------------------------------------- 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/
