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
Would Office Connection be an alternative?
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
Did this Problem have been solved? I meet up the same problem.So would you like tell me the method?