Thanks for sample. It generally works. It has a correct view. But there is strange issue. Please look in attachments.
I wanna set cell format like in “Etalon” file, but with “style.Custom = “dd.mm.yyyy”” I’m geting cell format like in AssignmentExecutionDeadlineControl. It looks similar but not same.
I understand that russians date formats may be not popular for your customer, but it will be nice to see support of such formats in your product as standard (not Custom) in future.
Thanks for the template files and screenshots with details.
Could you try the following line if it works for your needs:
e.g
Sample code:
…
style.Number = 14;
…
Hopefully it will work for your requirements. We think it will work if the default Date separator is ‘.’ for Russian.
Please note:
1) Well, when you specify built-in numbers formatting for a cell’s data and save the Excel file, now when you open the file into MS Excel, it would be automatically converted to the numeric, DateTime, etc. value as per the locale/regional settings of the machine.
Also, see the Table on what built-in numbers formats we support for your reference:
Good to know that your issue is sorted out now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.
Thank you.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
Enables storage, such as cookies, related to analytics.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.