Problems when exporting a numeric column to excel

magoicochea

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.

Petra

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

New version, problem is still there.

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

Petra

b0bik

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

Draeden

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

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

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

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.