Home General

Excel currency

Hi,

When saving to file the total at the bottom of the report all show the currency correct for us as £. But when saving to Excel, the currency is showing as $.

Is there a setting we need to change?

Regards

Dave Craggs

Comments

  • Hi Dave,

    I'm not able to recreate the issue. As a test I set my Windows Regional settings to English UK. The currency is displayed correctly in Excel.

    If the application contains code that is changing the Delphi FormatSettings, then try the code below. If that does not help send an example .rtm file to support@ and include steps to create.

    uses
    ppUtils;

    // sync RB format settings with Delphi format settings
    ppFormatSettings := FormatSettings;

    ppReport1.Print;


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • Still getting this and regional settings are fine. Also being reported by users.

    Any more thought?

    Dave Craggs
  • Hi Dave,

    Please create a simple example - either an .rtm file or a simple Delphi project we can build and run in the debugger. Use only standard Delphi components and RB. Copy data to ClientDataSet. Include only .pas, .dfm, .dpr. Send in zip format to support@.

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • Will do when I can find time.
Sign In or Register to comment.