Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.9.4

Bug #12779 Restricted max characters (255) for cell data
Submitted: 2007-12-27 09:34 UTC
From: pratikthakkar Assigned:
Status: Open Package: Spreadsheet_Excel_Writer (version 0.9.1)
PHP Version: 5.1.6 OS: Fedora Linux
Roadmaps: (Not assigned)    
Subscription  


 [2007-12-27 09:34 UTC] pratikthakkar (Pratik Thakkar)
Description: ------------ I am trying to generate an excel document where cell data could be more than 255 characters. But even after specifying the version as mentioned in one of the previous posts, the problem still persists. I get the error as mentioned below. It would be great if anyone can help me with this problem of cell data being truncated at 255 characters. Test script: --------------- $workbook = new Spreadsheet_Excel_Writer(); $workbook->setVersion(8); // Use Excel97/2000 Format $worksheet =& $workbook->addWorksheet(ucwords($vpack_arr[$ctr])); $worksheet->setRow(0,22); $worksheet->write(0, 0, "A", $columnHeading); $worksheet->write(0, 1, "B", $columnHeading); $workbook->send("WB.xls"); $workbook->close(); Expected result: ---------------- An excel document where cell data with more than 255 characters. Actual result: -------------- But after generation of the excel document, when I try to open the document in MS Excel 2003, I get the following message: "Excel found unreadable content in 'xyz.xls'. Do you want to recover the contents of this workbook? If you trust the source of this work book, cilck Yes." On clicking Yes, I get the following error "Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted." And all the formatting is lost. But the cell data wasn't truncated at 255 characters.

Comments

 [2009-11-30 09:24 UTC] cschmitz (Carsten Schmitz)
-Status: Open +Status: Feedback
Thank you for taking the time to report a problem with the package. Unfortunately you are not using a current version of the package -- the problem might already be fixed. Please download a new version from http://pear.php.net/packages.php If you are able to reproduce the bug with one of the latest versions, please change the package version on this bug report to the version you tested and change the status back to "Open". Again, thank you for your continued support of PEAR.
 [2010-08-11 22:33 UTC] barbariangeek (Daryl Gubler)
Confirmed to exist with 0.9.2 on Debian.
 [2011-09-29 14:15 UTC] doconnor (Daniel O'Connor)
-Status: Feedback +Status: Open