| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.9.4 |
| Bug #2261 | Excel 2002 crashes when use write() with @ as first value of the text | ||
|---|---|---|---|
| Submitted: | 2004-08-31 17:08 UTC | ||
| From: | b-egner at t-online dot de | Assigned: | progi1984 |
| Status: | Closed | Package: | Spreadsheet_Excel_Writer |
| PHP Version: | Irrelevant | OS: | Debian Woody |
| Roadmaps: | (Not assigned) | ||
[2004-08-31 17:08 UTC] b-egner at t-online dot de
Description:
------------
Excel 2002 crashes when using worksheet::write() with @ as first value of the text
Example:
$worksheet->write("@test");
Result:
Excel 2002 (XP) crashes if you open an exported file...
Reproduce code:
---------------
$workbook = new Spreadsheet_Excel_Writer();
$workbook->send("test.xls");
$worksheet =& $workbook->addWorksheet("Mytitle");
$worksheet->write(0, 0, "@test"); // <-- Here's the "@"
$workbook->close();
Expected result:
----------------
- test.xls exported
- Opening with Excel 2002 shows in Column 0, 0 the value "@test"
Actual result:
--------------
- test.xls exported
- Opening with Excel 2002 will crash Excel
Comments
[2006-01-12 16:15 UTC] anicoll at dundeecity dot gov dot uk
I have similar problem. Using MS Excel 2000 with Verion 2.1 (I Think). Doesnt crash but passes what seems to be an error from the package through when I try to write a text string '@'. The value comes through to the spreadsheet as
"Syntax error: , lookahead: , current char: 0"
(my double quotes).
[2006-01-12 16:32 UTC] anicoll at dundeecity dot gov dot uk
Solved my problem by specifically calling the writeString() method rather than the generic write() method. The write() (I Think) matches anything beginning with an '@' to a Formula and proceeds to use the writeFormula() method behind the scenes.
I dont know if this helps with the problem causing a crash.
[2009-07-31 13:14 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:59 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:23 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 15:55 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-08 13:02 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!