If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Exporting formulas to excel

Started by LucyGooda, 19 Sep 2005 05:25:33 AM

Previous topic - Next topic

LucyGooda

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

Would Office Connection be an alternative?

LucyGooda

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

qiqijx

Did this Problem have been solved? I meet up the same problem.So would you like tell me the method?