| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.9.4 |
| Bug #4329 | setBgColor not working with setNumFormat? | ||
|---|---|---|---|
| Submitted: | 2005-05-11 20:37 UTC | ||
| From: | pear at adub dot com | Assigned: | progi1984 |
| Status: | Bogus | Package: | Spreadsheet_Excel_Writer |
| PHP Version: | 5.0.4 | OS: | fedora core 3 |
| Roadmaps: | (Not assigned) | ||
[2005-05-11 20:37 UTC] pear at adub dot com
Description:
------------
setBgColor seems to create a problem for formatting the cell content. See below.
Reproduce code:
---------------
$total =& $workbook->addFormat();
$total->setNumFormat('#,##0.00 "€";-#,##0.00 "€"');
$total->setBgColor('Gray'); // take this line out and all OK
$worksheet->writeFormula(31, 1, "=SUM(B27:B31)", $total);
Expected result:
----------------
cell B32 should sum the cells above it, be formatted and have a gray background.
Actual result:
--------------
It seems OK until values are entered into the cells above at which point the bg goes black. The cell's content format (Format->Cells) can't be accessed from Excel when setBgColor is set, regardless of whether setNumFormat is set.
Comments
[2007-04-14 18:37 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2009-08-05 20:18 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!