![]() ![]() of the Ipad should be logged into an online account in order to use the product. It seems that it is somehow possible to tell Excel Online the exact regional format. Microsoft Excel, the spreadsheet app, lets you create, view, edit. It was 3 legal-length pages, and that was very difficult to get right. ![]() Now it will print in Excel Online, but it looks wacky in Excel. I had to spend about an hour messing with row heights. Excel is part of Microsofts Office suite. SharePoint Site Regional Setting = English (CA) -> Excel date format = YYYY/MM/DD I want to share an Excel file - one that prints correctly in Excel and Excel Online. However, you can still open XLS files in newer versions of Excel, as well as saving XLSX files into this older format. SharePoint Site Regional Setting = English (US) -> Excel date format = MM/DD/YYYY SharePoint Site Regional Setting = English (UK) -> Excel date format = DD/MM/YYYY Double-click ThisWorkbook under Microsoft Excel Objects in the Project Explorer pane on the left. Activate the Visual Basic Editor (Option+F11). You have to protect the sheet in a special way when the workbook is opened. SharePoint Site Regional Setting = Chinese (China) -> Excel date format = YYYY/MM/DD You have to create the grouping/outline while the worksheet is unprotected. SharePoint Site Regional Setting = Russian -> Excel date format = ДД.ММ.ГГГГ What is the Office 365 viewer Guests view Excel files in their original format online Keep control over the original file Keep track of engagement via. SharePoint Site Regional Setting = German -> Excel date format = TT.MM.JJJJ I also tested on SharePoint Online (Office 365) with the following results: This leads to the assumption that it is the Dropbox language setting that causes UK/AU/CA users to see wrong date formats. I tested a some cases, here is what I found out:ĭropbox Web Preferences -> Language: Direct effect on Excel Online date formatĭropbox Web Preferences -> Date format: No effect on Excel Online date formatĬhrome (Browser) Preferences -> No effect on Excel Online date formatĭropbox Display Language = German -> Excel date format = TT.MM.JJJJ (= DD.MM.YYYY)ĭropbox Display Language = Russian -> Excel date format = ДД.ММ.ГГГГ (= DD.MM.YYYY)ĭropbox Display Language = Chinese (Simpl.) -> Excel date format = YYYY/MM/DDĭropbox Display Language = English (UK) -> Excel date format = MM/DD/YYYYĭropbox Display Language = English (US) -> Excel date format = MM/DD/YYYY ![]()
0 Comments
Leave a Reply. |