DO NOT REPLY [Bug 17494] New: - probelem re: creating a cell with borders on a template that was read in

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17494>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17494

probelem re: creating a cell with borders on a template that was read in

           Summary: probelem re: creating a cell with borders on a template
                    that was read in
           Product: POI
           Version: 1.5.1
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Major
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: stephen@basit.com


In 1.5.1 final:
I read in an xls file that was previously created in Excel.
I add several cells with values, and then
I add several rows of cells that have a style with borders on three sides
(I am creating a table with bordered cells).
I am using a style repeatedly, which is created via this code:

private static void constructExcelShadedCellStyleAX()
{
excelShadedCellStyleAX = wb.createCellStyle();
HSSFFont f = wb.createFont();
f.setFontHeightInPoints((short) 10);
excelShadedCellStyleAX.setFont(f);
excelShadedCellStyleAX.setFillForegroundColor(HSSFColor.PALE_BLUE.index);
excelShadedCellStyleAX.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
excelShadedCellStyleAX.setBorderLeft(HSSFCellStyle.BORDER_THIN);
excelShadedCellStyleAX.setBorderRight(HSSFCellStyle.BORDER_THIN);
excelShadedCellStyleAX.setBorderBottom(HSSFCellStyle.BORDER_THIN);
}

After modifying the file, I write it out to an xls file.
Then I open it in Excel.
When I use a style WITHOUT BORDERS, it works fine.
When I use the above style, WITH BORDERS, when I open the
new Excel file, and put the cursor in any cell that touches
one of the cells where I have set the border, and then do
from the Excel menu:  Format...Cells
Nothing happens at all. I do NOT get the normal "Format Cells"
dialog box.  For other cells, it works normally. After
trying several cells, the Format...Cells function starts
to work properly -- except that it still does not work
for those cells directly above and directly below the cells
that were formatted with a border.