| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.9.4 |
| Bug #2405 | Text concat operator & truncate formula | ||
|---|---|---|---|
| Submitted: | 2004-09-27 08:34 UTC | ||
| From: | erik at eldata dot se | Assigned: | progi1984 |
| Status: | Closed | Package: | Spreadsheet_Excel_Writer |
| PHP Version: | 4.3.0 | OS: | Linux |
| Roadmaps: | (Not assigned) | ||
[2004-09-27 08:34 UTC] erik at eldata dot se
Description:
------------
Formulas trying to concat text using the & operator appear to truncate the formula. A formula like
=A1&A2
becomes
=A1
when opened in Excel.
(noted on two different Linux machines, not working on any machine tested with either version 0.6 or 0.8)
Reproduce code:
---------------
<?
require_once ('Spreadsheet/Excel/Writer.php');
$workbook = new Spreadsheet_Excel_Writer("textbug.xls");
$worksheet =& $workbook->addWorksheet('SheetOne');
$worksheet->write(0, 0, "ONE");
$worksheet->write(1, 0, "TWO");
$worksheet->write(2, 0, "=A1&A2"); // Concat two cells
$worksheet->write(3, 0, "=\"ONE\"&\"TWO\""); // Concat two constant texts
$workbook->close();
?>
Expected result:
----------------
Four Excel cells with
ONE
TWO
ONETWO
ONETWO
where the last two are concatenations
Actual result:
--------------
Both concatenations result in cells with only the first value:
ONE
The formulas are truncated to
=A1
="ONE"
Comments
[2008-03-24 00:00 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-03 19:13 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-04 03:00 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 13: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 14:21 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-06 13:06 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!