"invalid variant operation" exporting to Excel 2010

Comments

• gordk St.Catherines On. Canada.

  August 2010 edited 11:18PM

  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.
• WJansen

  August 2010 edited 11:18PM

  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.
• gordk St.Catherines On. Canada.

  August 2010 edited 11:18PM

  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.
  
• WJansen

  August 2010 edited 11:18PM

  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
• gordk St.Catherines On. Canada.

  August 2010 edited 11:18PM

  i would suggest you try the latest build 4.9.106 it can be found in your dl page.