From:  dgrieser2@gmail.com ("paqman")
Date:  27 Sep 2018 07:36:10 Hong Kong Time
Newsgroup:  news.php.net/php.pear.bugs
Subject:  

[PEAR-BUG] Bug #23759 [Com]: Data is truncated to 256 charters

NNTP-Posting-Host:  null

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

-Summary: concatated data +Summary: Data is truncated to 256 charters
------------------------------------------------------------------------ [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