Exporting Excel Formulas from Report to Excel

Michael_S

Good day,

I created a report with the Report Designer and would like to add some columns containing formulars with which MS Excel can work after the Export.

The idea behind this is, that I plan to export the list to MS Excel, where users should have the possibility to change and enter some Input Parameters lets say, they want to enter in Excel Table Field A1 a certain value and a column lets say B, should calculate something like B2...BN =A2...AN*A1

Its no trouble with giving such a formular into a Report texfield and have it exported. The only trouble is, that Excel gets the formular as String and doesnt recalculate/recognize it as formula in MS Excel. If you klick into the Excel field and press Enter, then this single field is being calculated.

My considerations about this is if there is a way to place the Formula so that MS Excel parses and calculates it if the document is opened. I considered to write a VBA macro so users can click somewhere on MS Excel menu and VBA recalculates/parses these Strings into formulas.

I know input parameters can be used in the Report itself, but the user expects in this case to do this in MS Excel. Is there any experience or possibility to send the field content from Report to Excel so it appears already as formular?

I am running birt-report-designer-all-in-one-2_3_2_1.zip and MS Excel 2002, a postgresql 8.1 as database.

Many thanks for your help,

Regards

Michael