Does Telerik Reporting allow the ability to export to Excel and allowing the cell contents to be a formula?
Say I have a report footer that sums all of the detail... can I insert the footer fields as Excel functions and not just data?
Say I have a report footer that sums all of the detail... can I insert the footer fields as Excel functions and not just data?
1 Answer, 1 is accepted
0
Hi Robert,
As explained in the Design Considerations for Excel Rendering help article - TextBox values are converted to string or number cells in Excel depending on the actual value but the Item binding expressions are not converted to Excel formulas. Thus excel formulas can't be used as TextBox values.
Sincerely yours,
Peter
the Telerik team
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 Public Issue Tracking system and vote to affect the priority of the items.
As explained in the Design Considerations for Excel Rendering help article - TextBox values are converted to string or number cells in Excel depending on the actual value but the Item binding expressions are not converted to Excel formulas. Thus excel formulas can't be used as TextBox values.
Sincerely yours,
Peter
the Telerik team
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 Public Issue Tracking system and vote to affect the priority of the items.