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.
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)
Hello Prashantreddy,
I am checking about the progress of this issue. Please let me know If you need any further assistance on this and please if possible attach a small sample project of your own, reproducing your scenario, if the issue still persists.
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?
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