Home General

% figures export wrong with ExcelReportFormat

edited November 2010 in General
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

Comments

  • edited November 2010
    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



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited November 2010
    Thanks Nard,

    Luke Johnston

This discussion has been closed.