Hi,
How to override system separator in excel ?
here i am using Infragistics.Documents.Excel to export the excel. For ru-RU culture we need to display space as thousand separator but when we export the excel its displaying thousand separator as ,.
I tried by setting the current culture as ru-RU.
I tried by setting the current culture as ru-RU. it doesn't works.
Are you trying to override the separator used when you open a saved file in Microsoft Excel? If so, I don't believe this is possible. If not, can you give more details on what you are trying to accomplish?
my pc is in en-us(English-United states) Regional.When i export the excel from my pc for russian client(here while exporting excel i set the thread culture as ru-RU), i am not getting the excel data in russian format(example:coma is decimal separator for ru-RU culture,in excel i should get coma as decimal separator but i am getting dot as decimal separator).
Thanks,Prashantreddy
I'm still not clear on your scenario. If you are saving numbers in the Excel file, they should be displayed in your system's current culture when you open it in MS Excel. Are you saving the numbers as text? Also, are you using one of our grid exporters or are you manually populating the worksheet with data? Can you provide a small code snippet showing me what you are doing?
Is it possible to do this kind of thing with Excel? Can you create a workbook with MS Excel which will display numbers in the Russian format on a non-Russian machine? If so, can you attach a file like this?
Yes, I am saving numbers in the excel file, here numbers are displaying in system's current culture. but i want to override this system's current culture to ru-RU(Russian) so could able to display in ru-RU culture.
Here code is running fine without any error.Here i dont want to change system's current culture manually.I would like to make excel sheet to be display in ru-RU culture.
Yes, I am using grid exporter for web application(ASP.net)