Hello,
when I export my report to excel the number values are rendered as cells that are formatted as text. Even if I set the format property on the report textbox to {0:N}. How do I get the output to register as numbers in Excel?
Here's some more information about what I'm doing.
- the datasource for the report is datatable set at runtime
- the textbox values are things like "=Fields.post_po"
- I didn't use the wizard to generate this report
- very basic report with only pageheader, detail, and pagefooter sections
Thank You,
Govinda
when I export my report to excel the number values are rendered as cells that are formatted as text. Even if I set the format property on the report textbox to {0:N}. How do I get the output to register as numbers in Excel?
Here's some more information about what I'm doing.
- the datasource for the report is datatable set at runtime
- the textbox values are things like "=Fields.post_po"
- I didn't use the wizard to generate this report
- very basic report with only pageheader, detail, and pagefooter sections
Thank You,
Govinda
1 Answer, 1 is accepted
0
Hi Govinda,
The type of the Excel cell depends on the type of the actual value of the TextBox item. If it is numeric (int, float, double, decimal, etc.) a number cell will be created otherwise it will be of type string. A possible reason for the problem could be that Fields.post_po does not return a numeric value.
If you think that this is a problem with the Excel rendering, please open a support ticket and send a sample report which reproduces the issue along with a brief description of the expected behavior.
All the best,
Chavdar
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
The type of the Excel cell depends on the type of the actual value of the TextBox item. If it is numeric (int, float, double, decimal, etc.) a number cell will be created otherwise it will be of type string. A possible reason for the problem could be that Fields.post_po does not return a numeric value.
If you think that this is a problem with the Excel rendering, please open a support ticket and send a sample report which reproduces the issue along with a brief description of the expected behavior.
All the best,
Chavdar
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.