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

XLSX format warning message

6 Answers 50 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Infrastructure
Top achievements
Rank 1
Infrastructure asked on 12 Jul 2017, 02:01 PM

Hi,

I can create the report rendering to XLSX format but a message box will be displayed before the report:  How to avoid this message box?  Thanks.

6 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 12 Jul 2017, 03:34 PM
Hello,

Please elaborate on the received warning and at which moment it occurs. A screenshot of the issue will be helpful to understand better the case.

To my knowledge, in Excel files you can receive a warning about cells formatting, if in the report you use the Textbox.Format property or Format built-in Text function with a formatting string not applying correctly to the type of the visiualized content e.g. you try to format as a Date a string field.
You can check if this is the case by running a text search for "Format" in the report's files, and then checking the type of data that is formatted.

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
Infrastructure
Top achievements
Rank 1
answered on 13 Jul 2017, 01:34 PM

When I create the report, the textbox are generated automatically.  The report is generated from data source directly, not from grid.

Attached is the screenshot of a sample report and the message I received when the report is opened.

Thanks,

0
Stef
Telerik team
answered on 13 Jul 2017, 02:58 PM
Hello,

Please perform the following test:
  1. Use the Table item's Context Menu and Copy/Paste it in another empty report;
  2. Test exporting the newly created report.
    1. If the issue is not reproducible, perform text compare between the reports' Designer.cs files to pinpoint the different settings.
    2. If the issue is reproducible, test removing one column from the Table item at a time and exporting in XLSX. The purpose is to find the column with data causing the issue.
      then check the data in the given column.

We can perform local tests too, if you can post the report's Designer.cs file which contains the code for generating the report, and test data in CSV format.

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
Infrastructure
Top achievements
Rank 1
answered on 24 Jul 2017, 01:53 PM

Hi,

I follow your way to test the report.  I found the column that caused the warning message. 

The column's data if integer from the database, but it is displayed as string in the report.  For instance, if it is 1, the report display "InStock".  Please help.

Thanks,

0
Nasko
Telerik team
answered on 26 Jul 2017, 01:17 PM
Hello,

We will need a sample report and data (CSV) in order to reproduce the behavior locally and investigate, or at least information about the data type (most probably integer) of the data field and the exact expression used in the column.
Also, let us know if you apply any formatting to the text box used in the column.

Regards,
Nasko
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
Infrastructure
Top achievements
Rank 1
answered on 26 Jul 2017, 08:06 PM

Nasko,

Thank you for your reply.  I think I fix the issue.

 

Tags
General Discussions
Asked by
Infrastructure
Top achievements
Rank 1
Answers by
Stef
Telerik team
Infrastructure
Top achievements
Rank 1
Nasko
Telerik team
Share this question
or