Description: ------------ When using writeFormula() function on a cell with Thick Borders format, the bottom border of that cell has a thin border. Also tried without success: - changing the border, background and text colours - increasing the height of the cell - drawing a TOP thick border in the cell directly below Fyi, writeNumber(), writeString(), write() works correctly Test script: --------------- $workbook = new Spreadsheet_Excel_Writer(); $workbook->setVersion(8); $workbook->setTempDir("./tmp"); $workbook->send('test.xls'); $worksheet =& $workbook->addWorksheet('test'); $formats = array(); $common_format = array('font' => 'Arial'); $formats[0] =& $workbook->addformat($common_format); $formats[0]->setBorderColor('gray'); // border styling $formats[0]->setTop(2); $formats[0]->setBottom(2); $formats[0]->setLeft(2); $formats[0]->setRight(2); $formats[0]->setLocked(); $worksheet->writeNumber(1, 1, 1000, $formats[0]); // write a number $worksheet->writeFormula(3, 1, '=A1', $formats[0]); // formula to get that number Expected result: ---------------- Both cells (number and formula) should have thick borders all around. Actual result: -------------- Only the cell with the number has all thick borders. Cell with the formula has thick top-left-right borders, but a thin bottom border.

Also scrolling to the right and back left (wide spreadsheet upto 'AA') corrects the bug. Using Windows XP Pro SP2, Firefox 2.0.0.14, MS Excel 2003 SP3