Support of date localization in excel.

Add-in Express™ Support Service
That's what is more important than anything else

Support of date localization in excel.
How to support different date localization in excel. 
Ashim Mishra


Guest


Hi Team,

I know this question is not related to add-in express, but we are having few issues with date localization in our add-in. We have few UDF which takes revision as the parameter. Revision is nothing but just a cell reference where a date exists. Now the issue comes when someone from US region downloads the sheet and tries to share the sheet with someone in UK region. For example, if someone in US downloads a sheet which contains 02/10/2019 with mm-dd-yyyy settings, shares the file with someone in UK with the dd-mm-yyyy date format, then excel identifies date as 02 Oct 2019. We tried to change this by converting the revision cell to a text format so that excel will not try to convert it by itself. But now our users have started complaining that the text format is not usable as it removes the flexibility of adding or subtracting the date.

Have you guys experienced the same issue before or is it something that can be taken care of by some add-in express function? It will be a great help if you guys can give some reading ref of date localization in excel.
Posted 08 Mar, 2019 01:35:43 Top
Andrei Smolin


Add-in Express team


Posts: 18825
 Joined: 2006-05-11
Hello Ashim,

In Excel a date is stored as the number of seconds since some date in the past; see e.g. https://support.microsoft.com/en-au/help/214330/differences-between-the-1900-and-the-1904-date-system-in-excel. That suggests that the 02-10 date interpreted as October, 2 or February, 10 is the "feature" of your code.

I assume your UDF reads the cell as date, not as a string or something?


Andrei Smolin
Add-in Express Team Leader
Posted 12 Mar, 2019 05:51:11 Top