Error exporting to Excel: "Excel was able to open the file..."

[Kirby Haltom]

Has anyone else had a problem exporting a report to Excel that generated a dialog box that reads:

Errors were detected in '[filename]', but Microsoft Office Excel was able to open the file by making the reports listed below. Save the file to make the changes permanent.

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.

I am building a report programmatically, not using the designer. But it is a simple, tabular report, and exports perfectly to all the other formats.

The version of Telerik reports is Q2 2008.

Has anyone seen this before?

Thanks,
Kirby

[Steve]

Hello Kirby,

How do you export the report - are you using the export button from the report viewer or are you doing it programmatically? Also what is the operating system and MS Office version that you use? Do you receive errors in excel if you export from our report demos available here?
Any additional information that you consider relevant would be highly appreciated.

All the best,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Kirby Haltom]

(I was hoping this was some simple, easily recognized user-error problem. Oh, well. :)

• I am using the export button.
• I am checking it on Microsoft Excel 2003 running on Windows XP. Every report that I have built using the designer has exported without issue.
• I can open the reports on the demo page fine.

The reports are simple. After I create a header and footer and detail, I loop through a list of column descriptions, adding the columns to the details. The report looks and works great, and exports fine to all other formats other than excel.

This is a condensed version of the code that adds columns:

double dbLeft = 0;
Telerik.Reporting.Drawing.Unit height = new Telerik.Reporting.Drawing.Unit(.20, Telerik.Reporting.Drawing.UnitType.Inch);
for(int i = 0; i < ColumnList.Count; i++)
{
 ReportColumnDescription column = ColumnList[i];    //a ReportColumnDescription has the width and format, etc.
 Telerik.Reporting.Drawing.Unit columnWidthUnit = new Telerik.Reporting.Drawing.Unit (column.columnWidth, Telerik.Reporting.Drawing.UnitType.Inch);
 Telerik.Reporting.TextBox detailbox = new Telerik.Reporting.TextBox();
 Telerik.Reporting.TextBox headerbox = new Telerik.Reporting.TextBox();

 detailbox.Width = columnWidthUnit ;
 detailbox.Height = height;
 detailbox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(dbLeft, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.0, Telerik.Reporting.Drawing. UnitType.Inch));


  headerbox.Width = columnWidthUnit ;
 headerbox.Height = height;
 headerbox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(dbLeft, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.0, Telerik.Reporting.Drawing. UnitType.Inch));

    detailbox.Value = column.ValueFormat;
    headerbox.Value = column.DisplayName;

    Detail.Items.Add(detailbox);
    HeadingSection.Items.Add(headerbox);

    dbLeft += column.columnWidth;
}

 

[Steve]

Hi Kirby,

Unfortunately your code did not help in reproducing the problem and the fact that all other formats are ok (including rtf) is also very strange. Please open a support ticket, zip and attach a working sample that shows the issue at hand. Once we review it we would be able to provide more info on the matter.

Kind regards,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Melchor]

I have the same problem.  I found out that service pack 3 (S3) was the cause of the error. 

[Steve]

Hi Melchor,

We have not released service pack 3 for any recent Reporting version - are you by any chance referring to Q3 2009? In such case is it working well with the latest official release? Any additional information on the matter would me highly appreciated.

Kind regards,
Steve
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[ALi]

Hi Steve I Have Error In Exporting Report To Pdf  Or Print this Report In web Application

The Error is :
An error has occurred while processing Table 'table1':
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index 

[Steve]

Hello Ali,

This is a generic error that could happen due to various reasons and without a runnable report that exhibits the problem, we cannot offer any concrete suggestions. It would be best if you attach a sample project so we can review it locally and advise you.

Regards,
Steve
the Telerik team

[Brad]

Have we found a solution to this? I'm using the latest and greatest version of Reporting and still getting this error.

[Nasko]

Hello Brad,

There may be different reasons for seeing this message in Excel. In order to help you further, please open a support ticket where you can provide more details, such as your report definition, screenshots, etc., so we can review them locally and advise accordingly.

Regards,
Nasko
Telerik