SharePoint Integration in new Collabora Online release

We’re really happy to announce that with today’s release – version 4.2.5 – Collabora Online offers another important integration: with the Microsoft document management and storage server SharePoint.

Collabora Online brings easy integration with SharePoint Server

Collabora Online is widely recognized as the perfect solution to integrate with applications for file sharing and collaboration. Now with the new integration with the popular and widely used SharePoint server, many more organizations will benefit from Collabora’s possibilities for collaboration, rich editing, expert interoperability and business support.

This is how it looks

Using your DOCX and ODT files

 

 

 

Opening e.g. Visio and Publisher files from SharePoint

 

 

What’s more in Collabora Online 4.2.5

Collabora Online also comes with various bug fixes.
All details are available on the 4.2 Release Notes page.

Configuration details

Integration of SharePoint server 2016 with Collabora Online is really easy. This blog post shows the configuration that is needed.

Read More

How to: WOPI binding for Collabora Online in SharePoint 2016 Server

All you need to do for the integration of SharePoint server 2016 with Collabora Online, is the following configuration settings. And you have to deploy a Collabora Online version 4.2.5.

Configure Collabora Online

1. SharePoint uses WOPI security and requires using a proof key to authenticate WOPI applications.
The proof key is automatically generated by postinst script of the loolwsd package, so normally no user interaction is needed to set this up.
In the unexpected case, when this automatic setup does not work, use this command to generate an RSA key:

loolwsd-generate-proof-key

In case your config dir is not /etc, you need to check loolwsd.log, which would contain a warning about missing proof-key in discovery.
The warning would contain the command line to use for manual generation of the key, like this:

ssh-keygen -t rsa -N "" -m PEM
-f "/path/to/loolwsd/config/proof-key"

2. Authorize the SharePoint server in Collabora Online. Open loolwsd.xml, and add a host element under WOPI storage element for the SharePoint WOPI host:

<host allow="true">sharepoint-host-name</host>

If you do not authorize WOPI host, this will result in failure opening documents.
The server’s name which was not matched would then be listed in loolwsd.log.

3. Start Collabora Online.

Configure SharePoint

1. Open SharePoint Management Console, and execute the command:

New-SPWOPIBinding -ServerName cool-server-name:port -Extension ODT

Execute this command for all the file extensions that you want to be handled by Collabora Online.
If you use Collabora Online in a testing environment without SSL, then you need to add -AllowHTTP to the command. Running this command requires that no binding exists for this extension in the external zone that Collabora Online uses.
You may need to remove existing bindings first; see https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/remove-spwopibinding?view=sharepoint-ps.

2. Collabora Online uses external WOPI zone.

Set-SPWOPIZone -Zone "external-http"

That’s all. Now SharePoint should use Collabora Online to open files with the configured extensions by default.
Changing the default action for any of the configured file types can be done by using SharePoint’s Get-SPWOPIBinding and Set-SPWOPIBinding commands (https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/set-spwopibinding):

Get-SPWOPIBinding -Server cool-server-name:port -Extension ODT | Set-SPWOPIBinding
-DefaultAction:$true

 

Read More

Connecting Collabora Online built-in CODE Server with Nginx

When you are using a Nginx server, you need to do a small modification to your existing configuration. For the Collabora Online app to work, you have to add a ‘richdocumentscode/proxy’ entry point as an allowed location to the config in the webroot of your nginx installation. From the documentation at Nextcloud:

location ~ ^\/nextcloud\/(?:index|remote|public|cron|core\/ajax\/update|status|ocs\/v[12]|updater\/.+|oc[ms]-provider\/.+|.+\/richdocumentscode\/proxy)\.php(?:$|\/) {

If you experience any problems, of have any questions, pls do contact us.

Read More

Collabora Online update available – version 4.2.3

New features

  • Support for drop down lists in form fields in ODT and DOCX and other text file formats
  • Handling of tabstops directly on the ruler in text documents

Most important improvements and fixes

  • Started to support WOPI proof keys (see also: https://wopi.readthedocs.io/en/latest/scenarios/proofkeys.html)
  • Packages for Ubuntu 20.04
  • Fixed Insert – Image (from storage) on Firefox and IE11
  • Fixed PDF printing of multi-page documents
  • Fixed Number format controls in Calc
  • Calc multiline formula bar improved
  • Updated translations

Read complete release notes here.




About Collabora Productivity

Collabora Productivity is the driving force behind putting LibreOffice in the cloud, providing Collabora Online and a range of products and consulting to enterprise and government. Powered by the largest team of certified LibreOffice engineers in the world, it is a leading contributor to the LibreOffice codebase and community. Collabora Office for Desktop and Collabora Online provide a business-hardened office suite with long-term, multi-platform support. Collabora Productivity is a division of Collabora, the global software consultancy dedicated to providing the benefits of Open Source to the commercial world, specializing in mobile, automotive and consumer electronics industries. For more information, visit www.collaboraoffice.com or follow @CollaboraOffice on Twitter.

Read More

Online development CI accessible via the internet

It’s now easier to check the status of your /libreoffice/online patches

Recently the CI (continuous integration) infrastructure for Online has been made accessible via the internet. Now developers from outside Collabora can directly check the status of their patches and builds.

 

Already for a while there was a Jenkins instance that checks patches on gerrit for the online-project (and our other projects), before they are submitted to cgit.freedesktop.org/libreoffice/online/
This service is now running on dedicated hardware, what allows us to make it accessible directly from the internet. Links pointing to this server in TDF gerrit will work from now on.

 

How to participate in the project

This growing  access to our development makes it easier to join the project. Which we of course encourage 🙂  Therefore… read more about participating in developing LibreOffice online here!

If you have any questions, please leave a message here.

Read More