exception during excel export or huge documents

[Jozef Balga]

Hello!

I discovered a problem during excel export of documents. I have a really huge report - more than 7500 pages on a rendered report, number of lines over 100000 -, and I am unable to export it to excel (pdf works fine). The excel export ends with the following excetion:
Unhandled Exception: System.IndexOutOfRangeException: Index was outside the bounds of the array.
at Stimulsoft.Report.Export.StiExcelExportService.dwFill(Int32 position, Byte dataValue, Int32 count)
at Stimulsoft.Report.Export.StiExcelExportService.WriteToOLEContainer()
at Stimulsoft.Report.Export.StiExcelExportService.ExportExcel(StiReport report, Stream stream, StiExcelExportSettings settings)
at Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, StiExportService exportService, Stream stream, StiExportSettings settings)
at Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, Stream stream, StiExportSettings settings)
at Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, String file, StiExportSettings settings)
Also the memory consumption was also quite high, before the exception it was over 2 GB. Could you please look at the exception? Thank you.

Jozef

[HighAley]

Hello.

Which version do you use?
Please, try the latest prerelease build. There was an improvement.

Thank you.

[Jozef Balga]

Unfortunately it did not help, I've tried the version 2013.1.1512, but the problems still persist. I tried to do the export from the designer - the same problem
----------------------------
[Customer Explanation]



----------------------------
[General Info]

Application: Stimulsoft Reports.Net
Framework: v4.0.30319
Version: Version: 2013.1.1512 from 11 March 2013
MachineName: WKS-BALGA
OSVersion: Microsoft Windows NT 6.1.7601 Service Pack 1
UserName: balga

----------------------------
[Exception Info]
Message: Index was outside the bounds of the array.

Source: Stimulsoft.Report

StackTrace:
at Stimulsoft.Report.Export.StiExcelExportService.dwFill(Int32 position, Byte dataValue, Int32 count)
at Stimulsoft.Report.Export.StiExcelExportService.WriteToOLEContainer()
at Stimulsoft.Report.Export.StiExcelExportService.ExportExcel(StiReport report, Stream stream, StiExcelExportSettings settings)
at Stimulsoft.Report.StiReport.ExportDocument(StiExportFormat exportFormat, StiExportService exportService, Stream stream, StiExportSettings settings)
at Stimulsoft.Report.Export.StiExportService.DoExport(StiExportInfo info)
at Stimulsoft.Report.Export.StiExportService.StartExport(StiReport report, Stream stream, StiExportSettings settings, Boolean sendEMail, Boolean openAfterExport, String fileName, StiGuiMode guiMode)
at Stimulsoft.Report.Export.StiExcelExportService.form_Complete(IStiFormRunner form, StiShowDialogCompleteEvetArgs e)
at Stimulsoft.Report.Export.StiExcelExportService.Export(StiReport report, String fileName, Boolean sendEMail, StiGuiMode guiMode)
at Stimulsoft.Report.Export.StiExportService.Export(StiReport report, String file, Boolean sendEMail)
at Stimulsoft.Report.Viewer.StiViewerControl.cmExport_Click(Object sender, EventArgs e)

----------------------------
[Assemblies]
mscorlib, Version = 2.0.0.0
Stimulsoft.Base, Version = 2013.1.1512.0
Stimulsoft.Report, Version = 2013.1.1512.0
Stimulsoft.Report.Design, Version = 2013.1.1512.0
System.Windows.Forms, Version = 2.0.0.0

[Jozef Balga]

Let me clarify my problem a bit more - I would like to do an export to Excel 97-2003 format. Is it possible to do that with this amount of data?
Thank you for the response.

[Alex K.]

Hello,

We couldn't reproduce this bug.
Can you please send us a sample report with test data which reproduces the issue for analysis.

Thank you.