Excel currency

dcraggs · January 2019

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

nardmoseley · January 2019

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;

dcraggs · October 2019

Still getting this and regional settings are fine. Also being reported by users.

Any more thought?

Dave Craggs

nardmoseley · October 2019

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@.

dcraggs · October 2019

Will do when I can find time.

Excel currency

Comments