| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.9.4 |
| Bug #5347 | using writeNote() causes excel crash | ||
|---|---|---|---|
| Submitted: | 2005-09-09 09:39 UTC | ||
| From: | patrick dot douret at edf dot fr | Assigned: | |
| Status: | Analyzed | Package: | Spreadsheet_Excel_Writer |
| PHP Version: | 4.3.3 | OS: | Windows 2000 Professionnal |
| Roadmaps: | (Not assigned) | ||
[2005-09-09 09:39 UTC] patrick dot douret at edf dot fr
Description:
------------
I need to create an excel sheet in which I would like to add notes for some cells.
So I am using the function writeNote.
When opening the xls document, excel crashes.
My version are:
PHP 4.3.3
EXCEL 2000 SR1 (FRENCH)
Spreadsheet_Excel_Writer-0.8
OLE-0.5
Test script:
---------------
<?php
require_once('php/v1_1/classes/Excel/pear/Worksheet.php');
require_once('php/v1_1/classes/Excel/pear/Workbook.php');
$fname = tempnam("./tmp", "laf.xls");
$workbook =& new Spreadsheet_Excel_Writer_Workbook($fname);
$workbook->setVersion(8); //I need this for some reasons
$worksheet =& $workbook->addworksheet('test');
$worksheet->writeString( 5, 1, "ceci n'est qu'un test totalement bidon", $fTxtCell_2);
$worksheet->writeNote( 5, 1, "ceci n'est qu'un test de note totalement bidon");
$workbook->close();
?>
Expected result:
----------------
The created xls document should open correctly.
The cell (5,1) should contain "ceci n'est qu'un test totalement bidon" and it's associated note should be "ceci n'est qu'un test de note totalement bidon".
Actual result:
--------------
I've got a lovely message box saying that memory cannot be read and excel will be closed
Comments
[2006-03-23 05:59 UTC] ajones at ca dot umces dot edu
(Adrian Jones)
Would like to add that I have the same problem, when using SetVersion(8) and the writeNote function, Excel 2003 crashes and says there are too many problems to fix. Once I remove the writeNote function it works perfectly.
[2006-11-09 12:58 UTC] tomgu at hotmail dot com
(Tom G.)
I have the same problem (using Spreadsheet_Excel_Writer 0.9.0).
The problem only occurs when using excel format version 8 and the writeNote-method:
$workbook = new Spreadsheet_Excel_Writer();
$workbook->setVersion(8);
$worksheet =& $workbook->addWorksheet('myTitle');
$worksheet->setInputEncoding('utf-8'); //Not needed to provoke bug
$worksheet->writeNote('myNote');
PHP 4.3.4
MS EXCEL XP (2003) SP2
Spreadsheet_Excel_Writer 0.9.0
OLE-0.5
[2007-09-18 14:38 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!
[2007-09-18 15:05 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:22 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-12 12:49 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!