Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1850
[Excel export] Format of date & currency columns Lost
posted

I am currently working on trying to figure out why Custom formatting gets lost when exporting to excel. We use the following formatting:

aBand.Columns[OrderKeys.ContractValue].Format = "C";
aBand.Columns[OrderKeys.CancelDate].Format = "MM/dd/yyyy"; 

When we export to excel we don't get those columns in the date format or currency format. They are exported with the General Format in excel. The user has to manually change the column in excel to the expected cell format. Has anyone run into this problem before? Can it be fixed in code before I export?

 thanks   -Ken