Send a blank email to [email protected] to get a copy of this message
Edit report at http://pear.php.net/bugs/bug.php?id=23759&edit=1
ID: 23759
Comment by: paqman
Reported By: dgrieser2 at gmail dot com
Summary: Data is truncated to 256 charters
Status: Open
Type: Bug
Package: Spreadsheet_Excel_Writer
Operating System: unix
Package Version: 0.9.4
PHP Version: 5.6.15
New Comment:
After dealing with this same issue for DAYS I finally found the
solution.
After creating the workbook object you must set it's version to version
8 with the SetVersion Command.
My code looks like this:
$workbook->send('Current Log.xls');
$workbook->setVersion(8);
Line 2 appears to be critical even though the manual says that it's not
needed, and will be depreciated.
I tried it in desperation and voila!!!!
I hope this helps someone.
Regards,
DG
Previous Comments:
------------------------------------------------------------------------
[2018-07-29 22:40:49] sanmai
<div id="changeset">
<span class="removed">-Summary: concatated data</span>
<span class="added">+Summary: Data is truncated to 256 charters</span>
</div>
------------------------------------------------------------------------
[2018-07-29 22:40:18] sanmai
Would you care to provide a working demo for this bug?
------------------------------------------------------------------------
[2018-07-26 13:34:50] bobby87
Description:
------------
When I am trying to export data the columns that has more than 256
characters, the data is truncated to 256 charters.
Test script:
---------------
This is my string
"This is a mouse model of 16p11.2 locus deletions and duplications
commonly observed in patients with neuropsychiatric diseases, including
autism. Mice with the deletion exhibit reduced viability, changes in
brain architecture, and behavioral abnormalities, whereas mice with the
corresponding duplication display a less severe phenotype."
it has 340 characters but while exporting the data is truncated to 256
characters.
Expected result:
----------------
This is a mouse model of 16p11.2 locus deletions and duplications
commonly observed in patients with neuropsychiatric diseases, including
autism. Mice with the deletion exhibit reduced viability, changes in
brain
architecture, and behavioral abnormalities, whereas mice with the
corresponding duplication display a less severe phenotype.
Actual result:
--------------
This is a mouse model of 16p11.2 locus deletions and duplications
commonly observed in patients with neuropsychiatric diseases, including
autism. Mice with the deletion exhibit reduced viability, changes in
brain
architecture, and behavioral abnormalities
------------------------------------------------------------------------
--
Edit this bug report at http://pear.php.net/bugs/bug.php?id=23759&edit=1