What’s New with OneDrive in SharePoint Server 2019
Last year at Ignite we announced that SharePoint Server 2019 was coming and with it, an updated experience for OneDrive on-premise users, including support for the latest OneDrive sync client. With the announcement yesterday of the availability of public preview, we wanted to share not only what to expect with this latest version, but how to start preparing for deployment today.
SharePoint 2019, column formatting not working
Environment: SharePoint 2019. I am trying with column formatting. It is working fine with Online. Same code is not working in SP2019. May be office fabric is not loading as expected in SP2019. Is there any option to make it enable ? When i see in console, it is giving following errors:
SharePoint 2019 - Could not load file 'Microsoft.Office.Excel.WebUI.Internal, Version=16.0.0.0
It seems that SharePoint 2019 (at least on version 16.0.10342.12113) is missing the Microsoft.Office.Excel.WebUI.Internal.dll I am not sure if this was just done on purpose or just a miss from Microsoft. Missing that dll caused Excel Web Online not to render in PerformancePoint (yes, I know. PerformancePoint.... Sigh) Error Message: Sorry, something went wrong Could not load file or assembly 'Microsoft.Office.Excel.WebUI.Internal, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. Fix: I grabbed the dll from C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.Office.Excel.WebUI.Internal\v4.0_16.0.0.0__71e9bce111e9429c on the SharePoint 2016 Server and copied to SharePoint 2019. I also modified the webconfig file with the following entries: < dependentAssembly> < assemblyIdentity name="Microsoft.Office.Excel.WebUI.Internal" publicKeyToken="71e9bce111e9429c" /> < !-- Assembly versions can be redirected in application, publisher policy, or machine configuration files. --> < bindingRedirect oldVersion="15.0.0.0" newVersion="16.0.0.0"/> < /dependentAssembly> <SafeControl Assembly="Microsoft.Office.Excel.WebUI.Internal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.Office.Excel.WebUI.Internal" TypeName="*" /> <SafeControl Assembly="Microsoft.Office.Excel.WebUI.Internal, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.Office.Excel.WebUI.Internal" TypeName="*" /> <SafeControl Assembly="Microsoft.Office.Excel.WebUI.Internal, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.Office.Excel.WebUI.Internal" TypeName="*" /> <SafeControl Assembly="Microsoft.Office.Excel.WebUI.Internal, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.Office.Excel.WebUI.Internal" TypeName="*" /> Just posting here in case might help someone else. Not sure what happened but it seems Microsoft missed that dll.
SharePoint 2019 inactive sites report
Hello everyone, Can you please tell me if there is a way to get a report of inactive/unused sites from all SharePoint 2019 sites that I have in my farm? I used PowerShell with the following two properties "LastUserModifiedDate" and"LastItemUserModifiedDate" but I don't think the .csv report that I got is that accurate. Based on the following Microsoft article, https://learn.microsoft.com/en-us/sharepoint/troubleshoot/lists-and-libraries/modified-date-site-contents-not-accurate, "LastItemUserModifiedDate" should be useful in this case. Do you know or do you have any other solutions for this subject? Thank you very much!
Background color when editing Pages in SharePoint 2019
In SharePoint 2019, when editing pages with “classic experience” there is no way to choose a background color for the background of table cells or for other elements. We are limited to what is available in existing styles. It would be useful if there was a button that would allow us to select the color that we want to apply as the background of an element, similar to what you can do in Word (office 365).
