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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: yves_savard at uqar dot qc dot ca
New email:
PHP Version: OS:

 

 [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: Tue Apr 23 23:01:29 2024 UTC