Excel Export (OLE)

KrugerKruger
edited 4:02PM in FastReport 4.0
I am using FR to create an Excel exportable report that contains, in some cells, Excel Calc calls (ie =A1+A2).

Using the FastExport options and formatting the cells as numeric, this works a treat. Until I start to use Excel Functions like IF or VLOOKUP and then I just get an OLE error 800A03EC. I get this error whenever I use any of the functions so I suspect it is Excel that is generating the error but I'm hoping one of the clever people here may be able to point me in the right direction. I have confirmed the validity of the formulas by entering them directly into the sheet once exported.

Anyone got any ideas? Please?

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2024