Formatting a number in excel export depennding on user settings
Posted on 2014-08-22
We have an application that, as part of its functionality, exports a GridView to Excel.
The issue we have is that the language of the server is set to a specific value, say French, but the user logging in is on a British set PC, so, when the export to excel happens, the formatting of numbers is incorrect.
There are two possibilities that we can think of:
2) Against the users log in account, set a format value and add it to the session so that when they export, the format is picked up and applied.
What do you think, is one option better/quicker/easier than the other or are there other possibilities?