Home » File Formats » Spreadsheet_Excel_Writer » Bug #6201

[2005-12-09 00:10 UTC] mike at shortgrass dot com

Description:
------------
When I try to set a bgcolor for a particular cell, it will always set color to black if I use a pattern of 0 or 1.

Test script:
---------------
$brdrUnderline_hlight =& $xls->addFormat();
$brdrUnderline_hlight->setPattern(1);
$brdrUnderline_hlight->setBgColor(5);

$cart->write(1,1, "Test: ", $brdrUnderline_hlight);

Expected result:
----------------
Should create a cell will bgcolor of 5 (Which is Yellow)
and place text "Test" into the cell.

Actual result:
--------------
Creates background color of black.

If I put a pattern > 1, then it will use that color and pattern.

[2006-02-09 18:33 UTC] mike at jupps dot co dot uk

It's consistent! I get the same effect on a Windows box.