This is a migrated thread and some comments may be shown as answers.

Report export to Excel Issue

3 Answers 249 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

tunglieh asked on 18 Dec 2018, 07:42 AM

1.png

2.png

3.png

I have a question, I use Telerik Reporting Q3 2015 SP2, after the 2018/8/13 Microsoft update, there will be attachment problems, how can I solve it?

3 Answers, 1 is accepted

answered on 20 Dec 2018, 02:21 PM

Hello tunglieh,

If you have a corrupted Excel file produced by Telerik Reporting, please check the following:

If the report can gather in the number of rows and columns allowed by MS Excel - Excel Limitations;
If you use the Format text function or TextBox.Format property and if the set formatting string is correctly used with the type of data displayed by the reporting item;
If removing styles from the report in a Report Designer resolves the problem with the produced Excel files.

Regards,
Silviya
Progress Telerik

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 Feedback Portal and vote to affect the priority of the items

answered on 24 Dec 2018, 05:52 AM

1. If the report can gather in the number of rows and columns allowed by MS Excel - Excel Limitations;

→Microsoft did not update when there was no problem, no more than Excel line limit

2. If you use the Format text function or TextBox.Format property and if the set formatting string is correctly used with the type of data displayed by the reporting item;

→did not use Format text function or TextBox.Format property, and TextBox using String(Default)

3. If removing styles from the report in a Report Designer resolves the problem with the produced Excel files.

→did not use styles.

Please confirm that telerik reporting installed the latest version, can you solve this problem?

answered on 02 Jan 2019, 03:12 PM

Hi tunglieh,

Can you specify the exact version of Microsoft Excel where the problem occurs, so that we can test to reproduce it locally. Is the problem related to .xls files only, or occurs also with .xlsx files.
Can you install our latest version and test whether the issue will be replicated also with it.

You may also open a support ticket and send us the report definition and the .xls files generated from it for local investigation.

Regards,
Todor
Progress Telerik