Page 1 of 1

spreadsheet excel writer output truncated

Posted: Thu Mar 09, 2006 1:37 am
by spitfire_esquive
hi guys, i was just wondering if any of you experienced this truncation when using pear spreadsheet excel writer. i have this field in my mysql databas that is "text" in nature (meaning long text is to be put in in that specific column) and when i output the data using the mentioned excel writer it is truncated. i used htmlspecialchars and stripslashes hoping that it would work but unfortunately it has not. any input would be much appreciated!

thanks,
niƱo

Posted: Thu Mar 09, 2006 1:47 am
by feyd
If you're storing all this text into a single cell, I would imagine there is a (rather short) limit to how much data can be packed into a single cell. Try breaking the text up into smaller chunks.