Two Instances of Excel Opens on workbook.save event

Aspose.Cells Product Family
1

We are using aspose.cells v4.5.0.0 and are having an intermittent issue with our web application.

When a user runs an export, the excel file sometimes opens twice with the same document. The second instance says the file is in use and gives option to open as read-only.

This problem does not happen in the local/code environment, only on production envrironments with ssl (https). This does not happen on all user machines nor is it specific to any one version of excel installed on user machines. Has anyone had similar issues and if so is there a resolution?

The code we use on the export event is straight forward from Apose documentation:

Private Sub Export

Dim wb As Aspose.Cells.Workbook = New Aspose.Cells.Workbook
Dim exportSheet As Aspose.Cells.Worksheet = wb.Worksheets(0)
... ADD STUFF TO WORKSHEET ...

wb.Save(_CALCULATOR_EXCEL_FILE_NAME, _
FileFormatType.Excel2003, _
SaveType.OpenInExcel, _
Context.Response)

End Sub

2

Hi,

It is very strange issue, we never happens to find this issue.

Could you try the attached latest version/fix v4.9.0.5 (you may comment out the licensing code to check the issue on your environment).

Also, by the way, could you try as described in the document:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/httpsssl-issue.html

Thank you.

3

I have tried using the memory stream as suggested. Thus far, there have been no reported issues using this methodology. But, the issue seems to be intermittent and unpredictable for us at this time, also. So I really don't know if this resolved the immediate issue until some passes.

In the mean time, we have already renewed our license and have attempted to download the latest from http://www.aspose.com/community/files/51/.net-components/aspose.total-for-.net/entry87871.aspx however, the .zip file appears to be corrupted. The file size says 15mb when clicking the download link; however, the file size, as stated on the file details sections says the file should be 165.6mb. Either way, the files will not extract. Thanks.

4

Hi,

I have reported the issue (regarding download Aspose.Total for .NET package) to the concerned authorities and they will soon look into it. In the mean time, please download Aspose.Cells for .NET v4.9.0 from the following locations separately:
http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry231670.aspx
http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry232019.aspx

Thank you.