We recently upgraded to TL 1.7.4 (involving a migration to a new system, and then an upgrade of the database). I was informed, after the fact, of the need to have "pear" and "Spreadsheet_Excel_Writer" installed to enable output in MS Excel format. Did that today, major problems.
This worked fine under 1.6.3 (installed on RHEL4 machine), but it does not work well (really, at all) on our new system (Centos 5.1)... and it appears that we are not the only site having the problem described below.
What happens is: a) we have to set output_buffering in php.ini to "On" (instead of the default 4096) and b) the resulting output is not in MS Excel format, but instead in HTML format - fortunately, OpenOffice 2.4 seems to automatically translate the portion marked up in HTML tables to spreadsheet cells. But MS Excel does not. The other site running TL 1.7.4 we spoke to has this same problem.
This is generally a problem for all non-HTML output: MS Word as well as Excel. These are an example of the errors generated:
[Sun Apr 27 19:43:05 2008] [error] [client 192.168.1.92] PHP Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/testlink/lib/functions/logging.inc.php:89) in /var/www/html/testlink/lib/results/displayMgr.php on line 84, referer: http://testlink/testlink/lib/results/re ... ort_type=1
[Sun Apr 27 22:25:22 2008] [error] [client 192.168.1.92] PHP Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/testlink/lib/functions/logging.inc.php:89) in /var/www/html/testlink/lib/print/printData.php on line 126, referer: http://testlink/testlink/lib/print/sele ... pe=testSet
Can someone clue me in as to what the misconfiguration is? Is this a known bug in testlink? I am able to generate a sample .xls file in the proper binary format using other code that references Spreadsheet_Excel_Writer.
Problem generating export files (MS Excel and Word)
The release 1.6.3 was branched by Asiel without cooperation with TestLink team. I'm not aware if Excel related functionality should work in 1.7 release. I expect that it's not available in 1.7.
The error below is because TL generates another Error message before a format specific header is sent. You must solve the initial problem at first (you can find it in log or source code of the page).
The error below is because TL generates another Error message before a format specific header is sent. You must solve the initial problem at first (you can find it in log or source code of the page).