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

Exported Excel showing warning

5 Answers 574 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
ChungHsiang
Top achievements
Rank 1
ChungHsiang asked on 30 Jun 2017, 03:52 AM

I had exported the excel file from my report. while opening , the excel file prompt a warning message "We found a problem with some content in <filename>.xlsx . Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes" but after click Yes, the report show successfully without any problem.

what can I do to avoid the excel to prompt such warning message ?

5 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 30 Jun 2017, 06:27 AM
Hello ChungHsiang,

Such issues can occur if you use formats in the report over values of type not covered by the used format string.

Please load the report's files in a text editor or Visual Studio and run a text search for "Format". Then check which item uses the Format property or the Format built-in Text function, and if the expression displayed by the item is of a type corresponding to the used format string.


If you need further help, please open a support ticket and send us test data and the problematic report in order to perform local tests.

Regards,
Stef
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
0
ChungHsiang
Top achievements
Rank 1
answered on 03 Jul 2017, 09:23 AM

[quote]
The newly introduced TRDP files contain the same XML as TRDX files, but in a compressed state - the content cannot be read directly with a text editor like TRDX files allow.[/quote]

I canot open the file with text editor and I found out , TRDX file cannot be read directly with text editor.

0
ChungHsiang
Top achievements
Rank 1
answered on 03 Jul 2017, 10:31 AM
sorry its trdp file
0
Stef
Telerik team
answered on 03 Jul 2017, 02:27 PM
Hi,

You can save th TRDP file as a TRDX file through the Standalone Report Designer - File - Save As option. the produced TRDX file can be read with a text editor.

Regards,
Stef
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
0
Edward
Top achievements
Rank 1
Veteran
Iron
Iron
answered on 08 Apr 2020, 12:31 PM

You can easily fix Excel We found a problem with some content in <filename> error by trying these solutions:

#1: Open File Recovery Mode
#2: Set Calculation to Manual
#3: Copy XLS to Remove Unreadable Content Error
#4: Use External References to Link to the Damaged Workbook

If you want to read detail step of these fixes then check out this helpful post.

http://www.repairmsexcel.com/blog/resolve-excel-2013-content-error

Along with this I also suggest you to check whether the excel file is exported correctly or not. If it’s not then you can try some other ways to export date to Excel.


Tags
General Discussions
Asked by
ChungHsiang
Top achievements
Rank 1
Answers by
Stef
Telerik team
ChungHsiang
Top achievements
Rank 1
Edward
Top achievements
Rank 1
Veteran
Iron
Iron
Share this question
or