Hi,
We are using Aspose.excel in our internet web application to export data in pre-selected Excel templates which after being populated are loaded in a IE child window.
This application has been running on production for several months without any problems with the following config:
- server (IIS, COM+) - Win XP SP1 – ASPOSE.EXCEL v2.0.0.0
- client - Win XP SP1 - Office 2000 or 2003.
However, this functionality does not work when the client is running Win XP SP2 (release scheduled this week by MS).<?xml:namespace prefix = o ns = "urnchemas-microsoft-comfficeffice" /><o></o>
The unexpected behavior is the following: The child window opens and closes immediately with a beep sound.
<o></o>
More precisely, if you connect to your local machine (same domain), then the child windows opens and the content is loaded properly.<o></o>
However if you access a web site which is not running under the same domain than your local machine forcing the IE popup blocker to act, then the child window will open and close immediately.<o></o>
<o> </o>
This issue has been reproduced consistently with several clients using XP SP2.<o></o>
This bug is critical and I hope you can support us in finding a fix or a work around.<o></o>
<o> </o>
Thank you.<o></o>
<o> </o>
Olivier<o></o>
<o> </o>
<o> </o>
Here is the code:
-------------------------------------------------------------------------------
ASP code
-------------------------------------------------------------------------------
' New COM+ Service
Set ExcelReport = Server.CreateObject("Serviced.Reports")
' adjust license file
ExcelReport.LicenseFile = Server.MapPath("/Member/Licenses/Aspose.Excel.lic")
' prepare template name
template = Server.MapPath("/Member/Templates/Text.xls")
' use binary write method to populate the content of the page <o></o>
Response.BinaryWrite ExcelReport.AsExcel(template)
-------------------------------------------------------------------------------
.NET Code
-------------------------------------------------------------------------------<o></o>
[return: MarshalAs(UnmanagedType.SafeArray)]<o></o>
public byte[] AsExcel(string template)
{<o></o>
Excel excel;
// Do some work
....
....
// get a temporary memory stream to keep content of the report
MemoryStream stream = null; <o></o>
// save document to temporary
stream=excel.Save("Report.xls", FileFormatType.Default, out stream);<o></o>
// get the content in byte array
byte[] result = new byte[stream.Length];<o></o>
// prepare array
stream.Read(result, 0, (int)stream.Length);
// get result
return result;
}<o></o>