Problems when exporting a numeric column to excel

magoicocheamagoicochea
edited December 2010 in FastReport 4.0
Hello

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.

Comments

  • PetraPetra
    edited 9:25PM
    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
  • PetraPetra
    edited 9:25PM
    New version, problem is still there.

    Excel 2007, FastReport v4.10.9: numeric will be exported as text

    Petra
  • b0bikb0bik
    edited February 2011
    Is there any chance that this will be fixed soon ?!?!?
  • DraedenDraeden
    edited 9:25PM
    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.
  • technisofttechnisoft
    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.
  • jeryjery
    edited 9:25PM
    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..
  • technisofttechnisoft
    edited 9:25PM
    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.

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