Calculation exports as formula in Excel [message #382919] |
Mon, 26 January 2009 05:59 |
curufin
Messages: 1 Registered: January 2009
|
Junior Member |
|
|
I have a report that uses a calculation like this:
Column J +( Column J*Column K/100 )
When I export the report to Excel the relevant cells contain a formula e.g. =J2+(J2*K2/100).
Is there any way to cause the value to be exported to Excel rather than the formula?
If I export the report to CSV first and then open it in Excel then the values are exported but I don't want the user to have to do this when they run the report.
|
|
|