Structures_DataGrid_Renderer_XLS - ** ERROR in SST **
| From: | Daniel McGreal | Date: | Mon, 12 Feb 2007 11:14:43 +0000 |
| Subject: | Structures_DataGrid_Renderer_XLS - ** ERROR in SST ** | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-26545@lists.php.net to get a copy of this message | ||
I'm using simple code to save an XLS render to a file.
$dgrid =& new Structures_DataGrid();
$options = array('dsn' =>
"mysql://$cfgUser:$cfgPassword@$cfgDBhost/$cfgUsedb");
$test = $dgrid->bind($sql, $options);
if (PEAR::isError($test)) {
echo $test->getMessage();} $dgrid->removeColumn($dgrid->getColumnByName("labs")); $dgrid->removeColumn($dgrid->getColumnByName("score")); $dgrid->setRenderer("XLS"); $dgrid->getRenderer()->setFilename("files/$_SESSION[login].xls", false); $dgrid->render(); When viewing in OpenOffice (in other applications the files fail to load) the test files I have generated the XLS file encounters problems around in latter rows, usually around ~95. Unfortunately, I am not allowed to share the data in this file, however, I will try to explain the symptoms. At a row in the sheet does not look as normal, it has a mixture of unintelligible data in one cell of the row where normal data should be. After this there may follow other such rows. The rows that come after this one may have further such abnormalities. Also, in the columns below the cells containing odd data the cells nearly all say "** ERROR in SST **". In other cells which are not in the same column as the cells containing the abnormal data but below the row where it was first encountered there may also be the same error, but this is infrequent. Any help anyone can give would be greatly appreciated. Dan. Any further information regarding this error is gratefully received. Dan.