Re: Structures_DataGrid_Renderer_XLS - ** ERROR in SST **

Daniel McGreal wrote: > 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. Another user of this renderer reported this "** ERROR in SST **" problem in a German PEAR forum last year. The final solution was that the user outputted some other things (AFAIR some HTML code) in the same script. After he removed this output, his generated Excel file worked without problems. Regards, Mark -- http://www.markwiesemann.eu