Rank 1
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
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
Rank 1
[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.
Rank 1
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
Rank 1
Veteran
Iron
Iron
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.