Author Topic: Exporting formulas to excel  (Read 824 times)

Offline LucyGooda

  • Associate
  • **
  • Posts: 2
  • Forum Citizenship: +0/-0
Exporting formulas to excel
« on: 19 Sep 2005 04:25:33 am »
Hi,
I am trying to create a report to output to excel, leaving some fields blank to allow users to input their own data into the xls file.  What I would like to do is to include the formulas which will act on the data in excel in the report net output so that all the user needs to do is fill in the blank fields.
So the output will look something like:
A1                 B1                   C1                 
Value            Empty field       =A1-B1

The user would enter the relevant value in B1 and then excel would use the formula to calculate the result based on their data and the data from the original report.
The problem is that I can't get excel to recognise the text '=A1-B1' as a formula unless it is output to column A - I have been using a table in report net to get the text in the correct field in the excel output, but as soon as the text item is in a table cell in report net, then excel no longer recognises it as a formula.
Does anyone know of a way round this?
thanks,
Lucy


Darek

  • Guest
Re: Exporting formulas to excel
« Reply #1 on: 19 Sep 2005 10:16:18 am »
Would Office Connection be an alternative?

Offline LucyGooda

  • Associate
  • **
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Exporting formulas to excel
« Reply #2 on: 20 Sep 2005 03:41:07 am »
It looks like it might well be but I haven't got it at the moment.  I will have a look into this, but if you know of a workaround I could use in the meantime that would be a great help.

thanks,
Lucy

Offline qiqijx

  • Associate
  • **
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: Exporting formulas to excel
« Reply #3 on: 25 Feb 2009 12:24:29 am »
Did this Problem have been solved? I meet up the same problem.So would you like tell me the method?