Map Coordinates Export to Excel Localization

[Jason]

I am trying to make an Excel document from a Grid. The Excel export needs to work in multiple international locations. It currently works fine when viewed from a en-US computer, but when viewed from a it-IT computer the format of the latitude and longitude are incorrect. See the example below. I am not explicitly setting the culture either at page load or during the export. I have tried setting an invariant culture, but that doesn't appear to work either.

In grid on the website
en-US Latitude = -33.85563
it-IT Latitude = -33.85563
In exported Excel
en-US Latitude = -33.85563
it-IT Latitude = -3385563,00 (this should be -33,85563)

[Kostadin]

Hello Jason,

This issue is related with Excel and the way it is parsing the grid's values. When using HTML-Based Export format and the decimal separator is comma it is ignored by Excel and the value is represented as integer. You could try using a Biff export format where the decimal separator is recognized by the Excel no matter the sign, but in the exported file is always represented as dot.

Regards,
Kostadin
Telerik

[Jason]

Thank you for the reply. The information about the HTML output got me thinking about simply replacing the period decimal separator from the database with the appropriate decimal separator based on the language preference of the client's browser. Something like the sample below. Do you see anything wrong with this solution?

decimal lat = -33.85563;
e.Item.Cells[7].Text = lat.ToString().Replace(".", CultureInfo.GetCultureInfo(Request.UserLanguages[0]).NumberFormat.NumberDecimalSeparator.ToString());

[Kostadin]

Hi Jason,

If you want to use HTML export format you have to replace the Culture format with a dot ".". In case you are using Biff format it is not neccesary to replace anything as the Excel will recognize the decimal separator and it will display it as a dot.

Regards,
Kostadin
Telerik

[Jason]

Once again thank you for the reply. Just to clarify, is the code below correct if I am using HTML export.

decimal lat = -33.85563;

e.Item.Cells[7].Text = lat.ToString().Replace(".", CultureInfo.GetCultureInfo(Request.UserLanguages[0]).NumberFormat.NumberDecimalSeparator.ToString());

[Kostadin]

Hi Jason,

You have to use the following approach. This way if the decimal separator is ",", it will be replaced with "." which is correctly recognized by Excel.

decimal lat = -33.85563;
e.Item.Cells[7].Text = lat.ToString().Replace(",", ".");

Regards,
Kostadin
Telerik