php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #29869 Spreadsheet won't open after Saveas
Submitted: 2004-08-27 15:51 UTC Modified: 2004-08-27 16:31 UTC
From: yves_savard at uqar dot qc dot ca Assigned:
Status: Not a bug Package: IIS related
PHP Version: 4.3.7 OS: Windows 2003
Private report: No CVE-ID: None
 [2004-08-27 15:51 UTC] yves_savard at uqar dot qc dot ca
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.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-08-27 16:32 UTC] derick@php.net
Blame microsoft.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 15:01:29 2024 UTC