Problems when exporting a numeric column to excel

Comments

• Petra

  January 2011 edited 3:24AM

  magoicochea wrote: »

  I have the following problem when I try to make an export using the option "Excel table (OLE)". I have a column whose display format is set as numeric and the column is imported without using an apostrophe to make the number a string, but excel still does not recognize it as text. What could be causing this?
  
  Also, the clients say that this was not happening before we updated the FastReport version.

  
  I have the same problem. It depends on the versions of Excel and FastReport.
  I have tested the following cases (Delphi 6 and Delphi 2010):
  
  Excel 2002, FastReport v4.9.59: ok
  Excel 2002, FastReport v4.9.99: ok
  Excel 2002, FastReport v4.10.8: ok
  
  Excel 2007, FastReport v4.9.59: ok
  Excel 2007, FastReport v4.9.99: numeric will be exported as text
  Excel 2007, FastReport v4.10.8: numeric will be exported as text
  
  The fastest way to reproduce: FastReport 4 Demo -> Basic reports -> Nested groups -> Export excel table (OLE)
  
  Petra
  
• Petra

  January 2011 edited 3:24AM

  New version, problem is still there.
  
  Excel 2007, FastReport v4.10.9: numeric will be exported as text
  
  Petra
  
• b0bik

  February 2011 edited February 2011

  Is there any chance that this will be fixed soon ?!?!?
• Draeden

  February 2011 edited 3:24AM

  When the export converts texts like "123,56" to numbers it reads values DecimalSeparator from the text object and SysUtils.DecimalSeparator - the system decimal separator. If these values are blank or don't match the actual separator you use in reports, then you'll get texts instead of numbers.
• technisoft

  February 2011 edited February 2011

  Draeden wrote: »

  When the export converts texts like "123,56" to numbers it reads values DecimalSeparator from the text object and SysUtils.DecimalSeparator - the system decimal separator. If these values are blank or don't match the actual separator you use in reports, then you'll get texts instead of numbers.

  Does that not mean it would be impossible to export integer values, not having a decimal separator, as numbers?
  
  Doesn't the report use the SysUtils.DecimalSeparator by default?
  Unless the user does some fancy stuff with the report there should never be a mismatch.
  
• jery

  May 2011 edited 3:24AM

  Excel 2002, FastReport v4.9.59: ok
  Excel 2002, FastReport v4.9.99: ok
  Excel 2002, FastReport v4.10.8: ok
  
  Excel 2007, FastReport v4.9.59: ok
  Excel 2007, FastReport v4.9.99: numeric will be exported as text
  Excel 2007, FastReport v4.10.8: numeric will be exported as text
  
  where I can download the component above fastreport..
• technisoft

  May 2011 edited 3:24AM

  In my experience EXCEL exports from a report have alwyas been unsatisfactory, no matter whether it was Fastreport of Pragnaan export components.
  I am now using Mike Skolnic's export suite components (scalabium.com) and never looked back. It costs a little money but that is probably less than 2 hours of labour.