% figures export wrong with ExcelReportFormat

rbuser

Hi,

We have a lot of reports which show a % figure in a ppDBText component where
the displayformat property is set to 0.00% or 0.##%. We have found that the
exported figure coming out is wrong.

ie report shows 65.57% >>> gets exported as 6557%

If I remove the % from the displayformat it exports fine.

I have changed one report so far so the component is now a ppLabel instead
and assign the value through the GetText function as its the only way the
figure will export and show correctly.

Am I doing something wrong or is this a bug?

Regards,

Luke.


__________ Information from ESET NOD32 Antivirus, version of virus signature database 5646 (20101124) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

nardmoseley

Thanks for reporting this - it is a bug. I created a patch for RB 12.03.
Registered customers can email support@ and request the patch.

Looks like Excel multiplies the value by 100 when the % format is used -
Delphi does not do this.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Thanks Nard,

Luke Johnston