search

unvell / ReoGrid

Fast and powerful .NET spreadsheet component, support data format, freeze, outline, formula calculation, chart, script execution and etc. Compatible with Excel 2007 (.xlsx) format and working on .NET 3.5 (or client profile), WPF and Android platform.
https://reogrid.net
MIT License
1.32k stars 390 forks source link

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

Closed abstractspoon closed 1 year ago

abstractspoon commented 2 years ago
  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 commented 2 years ago

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

jingwood commented 1 year ago

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

abstractspoon commented 1 year ago

Certainly