"invalid variant operation" exporting to Excel 2010

WJansenWJansen
edited 7:08PM in FastReport 4.0
Has anyone been testing to Export with fastreports to Excel Office 2010 with success?
I get the message: 'invalid variant operation'. However I am testing with a trial version of Office 2010.
What could this be?

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 7:08PM
    invalid variant operation error
    usually occurs when the expression parser can not resolve an expression.
    a typical case is a report which uses the on getvalue event (requires .exe to be running), being run from the ide by clicking on mnu-file-preview.
  • WJansenWJansen
    edited 7:08PM
    gordk wrote: »
    invalid variant operation error
    usually occurs when the expression parser can not resolve an expression.
    a typical case is a report which uses the on getvalue event (requires .exe to be running), being run from the ide by clicking on mnu-file-preview.

    I don't fully understand your answer. When I run the exact same report with Office 2010 (click-and-run) or with Office 2003. With Office 2003 the report can be displayed without any error. With Office 2010 (click-and-run) it cann't.
  • gordkgordk St.Catherines On. Canada.
    edited 7:08PM
    i am not running excel 2010 so i can't be sure about this but i vaguely remember when installing
    Delphi 2010 a choice had to be made as to which office controls were being used 2003 or a later version and have you tried exporting to open document spreadsheat.
    BTW which version build no of fr are you using.
  • WJansenWJansen
    edited 7:08PM
    I've figured that the Excel installation was not a full one but a virtual one.
    So somehow installed applications cannot open it.
    The version of Fast Report I currently use is 4.9.52
  • gordkgordk St.Catherines On. Canada.
    edited 7:08PM
    i would suggest you try the latest build 4.9.106 it can be found in your dl page.

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