Issue/bug with the Regional setting sync between Office and Dropbox
Im in Sweden and we use "," (comma) as a separator when you type the currency. For example 123,45 sek. In office 365 i have edited to Regional Settings to reflect this. But when i open up an excel sheet from dropbox in excel online it doenst recognise the comma sign. It only accept a dot. But when i login to office 365 the regional settings in office is working as expected and the comma is working.
The same with the excel button with a $ sign that let you quickly format the cell to a currency cell. In Office 365 i have the "kr Sweden" available, but when i do the same in the excel file stored in dropbox and opened with excel online i dont have this lokal currency option.
I have spoken to the microsoft office support and they can not see that there is any setting issue. It seem to be the setting sync between microsoft and dropbox that is the issue.
I have also attached 3 screen shots showing 1. The regional settings, 2. What it looks like when opening the file from dropbox, 3. What it looks like when uploading the same file to Onedrive and open the file from there.
Having the same issue when creating a new excel file from dropbox. Seem to use US settings rather than the settings i have in my 365 account. And in dropbox there is no setting for what formats to use.
The same issue is for Word documents created in dropbox. They are using US Letter size rather than A4 that is my standard.