ReoGrid icon indicating copy to clipboard operation
ReoGrid copied to clipboard

Importing currency value under 'English (United Kingdom' locale fails to restore currency and decimal places

Open abstractspoon opened this issue 3 years ago • 1 comments

  1. Change system locale to 'English (United Kingdom)'

image

  1. Load the attached native Excel file into Winforms Editor

image

  1. ReoGrid loses the currency symbol and 'Currency' type

image

currency.xlsx

abstractspoon avatar May 15 '22 08:05 abstractspoon

As another example, if you change the locale to 'French (France)' and import the attached native Excel document, you lose both the Currency type and the number of decimals.

Note: This requires this pull request else the number format is also lost.

french.xlsx

abstractspoon avatar May 15 '22 09:05 abstractspoon

@abstractspoon Thank you very much! Can we close this since the pull request has been merged?

jingwood avatar Jan 12 '23 04:01 jingwood

Certainly

abstractspoon avatar Jan 12 '23 05:01 abstractspoon