From: yves_savard at uqar dot qc dot ca
Operating system: Windows 2003
PHP version: 4.3.7
PHP Bug Type: IIS related
Bug description: Spreadsheet won't open after Saveas
Description:
------------
Installed on Windows2003, Excel 2000, with IIS, the application generate
and update Spreadsheet.
It creates and opens a Spreadsheet on the client computer, this allow him
to save the Spreadsheet on his computer.
It works on a wide variety of systes, Windows 95, Windows 98, WIndows XP
and Excel 97, Excel 2000, but it doesn't work on client system where there
is something named 2003 like Windows 2003 or Excel 2003.
Reproduce code:
---------------
$exapp = new COM("Excel.application") or Die ("Did not connect");
$file = $path_to_template."\Template_results.xls";
$wkb = $exapp->Workbooks->open($file);
$sheets = $wkb->Worksheets(2); #Select the sheet
$cell = $sheets->Cells(1,1) ;
$cell->activate; #Activate the cell
$cell->value = "Hi";
$wkb->SaveAs($file_name); # saves sheet as $file_name
$exapp->Quit();
unset($exapp);
Actual result:
--------------
The spreadsheet is generated and save on the server but is not open on the
client system, which is very important because it's the only way for the
application to transfer the spreadsheet from the server to the client
system.
--
Edit bug report at http://bugs.php.net/?id=29869&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29869&r=trysnapshot4
Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=29869&r=trysnapshot50
Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=29869&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=29869&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=29869&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=29869&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=29869&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=29869&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=29869&r=support
Expected behavior: http://bugs.php.net/fix.php?id=29869&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=29869&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=29869&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=29869&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29869&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=29869&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=29869&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=29869&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=29869&r=float
