how do I get formulas to export in xls

[jymm]

rs 2005

I want to show users the total for a column in a table AND when they export that report have Excel get the formula instead of the number.

so in RS they see (and get on the export)
10.00
20.00
Total 30.00

On export I want Excel to get
10.00
20.00
=Sum(a1:a2)

seems I have seen this before, but am drawing a blank when searching.

 

[acessn]

I would have created a duplicate report for excel exporting. I don't think it's possible to control the output of a report based on which format you are exporting it to.

Create a formula which counts the number of rows in your detail section, and let the rest be plain text.

Something like (Very pseudo, don't have a testsystem up)

="Sum(a1:a" & (Number_of_rows_from_details) & ")"