Long Text Field blows up spreadsheet

Topics: Developer Forum, User Forum
Jan 2, 2009 at 10:20 PM
This is a great tool.  I'm able to generate a everything in my spreadsheet until I get to a field that has more than 255 chars of text.  Then the spreadsheet blows up when I try to open in Excel.  Any ideas?  The line of code looks like this:

$objPHPExcel->getActiveSheet()->setCellValue('AK' . $count, "Really really really long text here (more than 255 chars)");
Developer
Jan 3, 2009 at 2:31 AM
Which writer are you using? PHPExcel_Writer_Excel2007 or PHPExcel_Writer_Excel5 ? Can you send me the broken Excel file so I can inspect? If possible, also the code you are using to generate it. (erik at phpexcel dot net)

Developer
Jan 4, 2009 at 2:32 AM
Thanks, I received the file. This is likely related to bug fixed here:
http://www.codeplex.com/PHPExcel/WorkItem/View.aspx?WorkItemId=8320

Please try with latest source and report back.

Jan 4, 2009 at 4:37 AM
Ok... I've tried with the latest source build.  Different results, but still an error.  This time, it will open completely in Excel, but it's just a bunch of binary stuff on the sheet. 
Developer
Jan 5, 2009 at 7:49 PM
This was after all not related to "Long Text Fields". Cause was identified as this:
http://www.codeplex.com/PHPExcel/WorkItem/View.aspx?WorkItemId=8810