Collabora Office 6.2

Cambridge, December 20, 2019 – Today we release Collabora Office 6.2.0 providing businesses and professionals with the best features, interoperability, LTS and custom support in open source as well as respecting user privacy and company data security. Changes in Collabora Office 6.2 also support new and enhanced features in Collabora Online.

The Best of Features, Interoperability, and Support in Open Source

We’ve selected the following of the new possibilities and improvements, available in the new release of our office productivity suite.

Writer 6.2

  • Better language support and exchange with Word documents including support for bottom-top left-right text direction.
  • Extended support of the legacy type Microsoft form fields.

  • Table-size actions involving column/row size now behave more in line with expectations.
  • HTML export has an opt-in mode to write the ReqIF subset of XHTML.

Calc 6.2

 

Full-Sheet Previews option on the PDF Export Dialog

  • Copy & paste of spreadsheet data directly in text document tables.
  • Data Validation now supports custom formula.
  • Multivariate regression analysis is possible using the regression tool (DataStatisticsRegression).

  • Also, many more statistical measures are now available in the analysis output.

Impress/Draw 6.2

  • A whole series of improvements in animations.
  • In Draw the attributes to display and protect layers, are now compliant with ODF specifications.
  • Many layer improvements.
  • There is now a Table sub menu to menu Format.

Miscellaneous 6.2

  • The Help is improved, nice looking and completely available online, making finding information on many topics easy and fast.

Collabora Office new online Help

  • Redaction feature, with automated finding of targets, to remove sensitive content before sharing documents.

  • The new Print dialog makes handling all print tasks easier.

Collabora Office new Print dialog

  • Encryption improvements for OOXML-documents.
  • Signature Lines can be used in combination with (a signature) image and are now available in Calc too.

Integration, business

  • Improvements in COLEAT, for integration with business applications written in Microsoft Office Visual Basic.

 

  • File locking in mixed environments with Microsoft documents improved.
  • Better integration with SharePoint 2010 via ActiveX.

Series interoperability improvements

  • Microsoft OOXML charts.
  • There are many improvements in interoperability, of which quite some may look as minor, but that all together make a real difference.

User interface

  • There is a rich choice in toolbar layouts – a solution for every need and each preference via menu View > User Interface.

Collabora Office 6.2 - Rich choice in tool bars

  • Nice and clear new icon sets.

Mobile improvements 6.2

We only mention a few items here: better support for HiDPI displays, improved performance, enhanced Document signing with Verisign.
Most important are a huge amount of improvements that show in better integration on small devices, more powerful features online, better look and user-friendliness. We recommend our information on Android, Apple iOS and CODE 4.2.0 (showing what will be in Collabora Online).

About

Collabora Office 6.2 provides businesses and professionals with the best features, interoperability, LTS and L3 support. Based on upstream LibreOffice 6.2 source code, the project in which we are happy to cooperate and where all our code is contributed, and extended with improvements and backported stable features from newer releases, or features for our customers that are not yet available in the stable upstream branches.

Migrate with our demo of Collabora Office 6.2

You can try Collabora Office 6.2 yourself! Just head to the Collabora Office page and request your demo today, or just click the button below.

Try the Demo

Read More

CODE 4.2.0 Released with fresh User Interface

Clean look, feature rich Side Bar, and much more

Cambridge, United Kingdom, December 16, 2019Collabora Productivity, the driving force behind bringing LibreOffice to the cloud, is excited to announce a new, major release of our product CODE (Collabora Online Development Edition) 4.2.0 This release includes a fresh look, mobile improvements, improved inter-operability, new dialogs and functionality as well as a raft of bug fixes and polish. The release gives you an insight into our soon-to-be released enterprise version Collabora Online 4.2.0. CODE and Collabora Online offer privacy as well as the only truly open-source solution for working with and collaborating on rich documents in the cloud.

CODE logo

What’s new?

This major update of Collabora Online Development Edition (CODE) comes with a rich new user interface and is built onto of the stability and performance of our LTS version of LibreOffice: Collabora Office 6.2. It includes many improvements in functionality and user-friendliness. The most obvious new feature is the powerful sidebar on the right. Many settings for text and all kind of properties of objects in the documents can be easily updated here. The sidebar makes it much easier to change tables, colour settings and charts elements in the browser, with close to the same feature richness that is available in Collabora Office on the desktop. The status bar has been redesigned and our powerful function wizard is now available in Calc online. Copy and paste of rich text and content is added for online, and our responsive user interface adapts nicely to mobile phones and tablets.

Rich chart functions from the side bar

When charts are selected, the sidebar now gives access to a wide range of features. For example, you can easily choose chart types from bars, lines and points, pies and more, or whether the diagram should be displayed in 3D.

Other elements of charts can now also be adjusted from the sidebar. You can now determine how and where titles and legends are displayed. Furthermore, many of the visual elements of the diagram can be adjusted here. The sidebar also allows you to define the surface colour, transparency, line types and grid lines.

Click to see that in action:

Click to see the chart sidebar in action

Online function wizard: a powerful tool for formulas

Working with formulas is important and especially for the more complex types, having help with the tenth optional parameter is good. The new function wizard does that and it is new available in Calc from now on. The function wizard grants easy access to all elements of also the most complex formulas. It shows the structure and meaning of different parts of a formula, and more.

Conditions apply: Enhanced formatting options in Calc

Conditional formatting is a powerful feature in Calc. It is enables you to quickly visualize data in a spreadsheet by setting various useful rules on your sheet to adapt the cells formatting, colour, or even add icons when certain criteria are met. While a simplified set of conditional formats was previously available via an icon in the toolbar, you can now also make use of the full dialogs, to be found in the Format menu, to define and manage conditions fully.

Better display in Calc: smooth scaling of spreadsheets

The scaling of spreadsheets has been significantly improved in CODE 4.2.0. While in Calc you could previously only choose between two zoom factors of 100% and 200%, now fine adjustment is are possible to suit. Using the convenient (and redesigned) quick selector in the lower right corner, you can now choose your favourite zoom percentage between 33% and 200%.

More presentation functions in the sidebar

The new sidebar adds many useful functions to Impress. For shapes and outlines, the size, position, colours, transparency, wrapping and so on are easy to change.

The possibilities to alter the slide master and lay out, from the sidebar, are also completely new in CODE 4.2. You can now access extensive layout functionality for slides such selecting masters, layouts and even editing your own master pages. Needless to say, that character settings, fonts types, sizes, colours and spacing can also be easily adjusted from the sidebar.

Handier working with images

Working with images in all document types is easier, more convenient and more precise. The sidebar allows to adjust colour options, such as brightness, contrast or transparency or the red, blue and green portion of the image. Another handy feature is the adjustment of the layer settings of the images. Bring them to the foreground or arrange them in the background – all via the sidebar.

Rich copy and paste between docx and xlsx documents and more… in the browser

People that work online, often have many documents open simultaneously, and want to mash them together into bigger, better documents. So you’ll be glad to learn the CODE 4.2.0 introduces copying of rich formatted content along with images, charts, and other complex elements, between your online spreadsheets, documents and presentations.

New online colour picker

For certain elements there is not only the usual colour selector, offering a palette, but also the colour picker to chose any custom colours needed. Use it with text and background in presentations, lines in spreadsheets and presentations, text and background for floating frames in text documents.

Handling links in Writer has just become more pleasant

CODE 4.2.0 brings very nice enhancements when working with hyperlinks. Whenever the mouse cursor is located next to a link or on it, you will be kindly notified by a pop-up dialogue allowing the real target to be inspected and launched conveniently with a single click.

Beautiful new icons and a redesigned theme

The new design of the icons embellishes the upper toolbar. The new theme is tidier has more generous spacing, and is clearer in general. It should increase productivity and reduce friction. Buttons that are selected have a clearer and more distinct highlight too.

The status bar also benefits from our visual redesign. Not only does it look cleaner, it also improves quick access to the functions located there. The language of documents can now also be set via a popup.

Table editing in the side bar and table handles

In Writer it is now possible to manipulate tables extensively from the sidebar and we also added easy to use in-document selection handles, choose either or both. Previously the table dialog had to be used, which was far less convenient. These handles make adjusting row height and column width very user-friendly.

You want to insert rows or columns from here? Of course! Or delete some or all of them? a click! Furthermore, the sidebar also allows you to set the background colour of the cells or to fine-tune their height and width of rows and columns. It becomes even more interesting if you select several cells. Then you can also merge them from the sidebar or distribute them evenly.

 

Table of contents

In text documents, the full table of contents can now be configured with the new dialogs. So even online, you can customize your complex table of contents in a few clicks according to your wishes. For example edit the entries and change style, background or columns.

About CODE

CODE is the Collabora Online Development Edition. It contains the latest developments and is perfect for home users that want to start to run their own online office suite. It enables them to regain control of their own online documents and host them themselves in their own controlled and private environment. For them and also for tech-enthusiast, it is a low-threshold way to get involved and familiar with our online office solution. CODE gives the possibility to be the first to use new features. It will be improved continuously and our next enterprise Collabora Online product will be built from it. Note that we recommend our supported and maintained enterprise release: Collabora Online for business and production environments. CODE warns users that they might want support after 10 concurrent documents or 20 concurrent users. Find out how about the different ways to install CODE on our product page.

Get CODE 4.2.0!

Read More

New: Collabora Office for Android

Great new interface and editing – in beta

We are excited to announce a complete new version of Collabora Office for Android, available now in Google Play, with the following main improvements:

  • A great looking interface, easy to use with just one hand on your phone
  • Editing of complex office documents, not just viewing
  • Now re-uses the same technology as Collabora Online.

In common with other Collabora Productivity products, this new Android release enables people to edit their documents without compromising on privacy. There is no longer a reason to hand over your data to get rich mobile editing.
The new release marks the end of a period of rewriting important parts of the application. We now share much of the code and user experience from Collabora Online’s collaborative editor as well as Collabora Office 6.2 for displaying the documents.

 

  (minimal version Android 5.0)

What it looks like

Text file and image details – Collabora Office for Android

Typing in a text document – Collabora Office for Android

Inserting and editing tables – Collabora Office for Android

More great interface details

Text file with spreadsheet embedded – Collabora Office for Android

Image handling in text document – Collabora Office for Android

A new front end, re-using Collabora Online

The technology under the hood has changed almost completely, with only the LibreOffice core for rendering the documents remained. We removed the previous Fennec tiled renderer, and moved to re-use a our Collabora Online web view. This means our Android app can share the same features as our flagship product Collabora Online. The recently released Collabora Office for iOS uses the same approach. As a result, features and improvements and fixes made foor one solution (online, mobile, desktop) often enhance all the others. The Javascript and CSS base makes contributing to and developing and debugging the app much simpler for people to get involved with.

 

Shape editing – Collabora Office for Andoid

 

Spreadsheet in Collabora Office for Android

 

Rich documents in Collabora Office for Android

 

Getting involved

Once you have got Collabora Office (Google Play), your feedback is much appreciated. Report any problems you find to the bug tracker, and attach any documents related to the issue so developers can investigate. You can also checkout the Online code and build it yourself.

Rich history and community growth

The road to the current version of the Android app was a long one, one with many companions and some detours. The first version that brought LibreOffice to the Android platform was released in 2011 after an intensive process of cross-compiling and a number of bug fixes. This version was rather a proof of concept and by no means suitable for productive work.

Two years later, in 2013, the application had developed into a document viewer rendering entire pages and including basic user interface to handle pages. During the years 2014 to 2015, the rendering was changed to split the pages into „tiles“, the same way as other applications like Mozilla Firefox were doing. We have extracted the Mozilla’s compositing from their code and reused it in our Android app – still only a viewer. Later in this period, editing was added as an experimental feature.
Between 2016 and 2018 further features and functions were implemented thanks to community involvement, however the vision of a full editor was not realized.

In 2019 we decided to do a complete rewrite of everything above the LibreOffice rendering core. Inspiration for this was the development of the new Collabora Office for iOS app, which Collabora is driving forward together with our Swiss partner Adfinis SyGroup. The current, newly developed Android app benefits greatly from the Collabora Online code base and work for the iOS version and includes also features implemented this year during the GSoC, mentored by our engineers.

Thanks to everyone that contributed

This new Office app for Android obviously came by a huge investment from Collabora.  As with all open source projects, it has also been made possible by the open source community as a whole, by many organizations and the personal dedication of many individuals that contributed. Specifically, for this Android app we want to mention the initial Android port funded by SUSE. The initial app used the tiled rendering funded by CloudOn, and was driven by Smoose, IceWarp and many customers of Collabora Productivity. The Document Foundation’s donors also funded the initial basic editing functionality.

Without ever doing justice to the entire crowd of supporters, we would like to thank a few people whose performance in this development has been outstanding. At this point, we would like to mention the pioneering work of our fellow two collaborators Tor Lillqvist and Michael Meeks and on the initial version of the App that among others included a first loader developed by Iain Billiet, during his GSoC ‘12 program and other components by Matúš Kukan.

Tomaž Vajngerl contributed to the already mentioned tiled rendering to the app in 2014/2105. Miklos Vajna’s efforts made editing possible at that stage. Christian Lohmaier, Ximeng Zu, and Mert Tumer have made important and substantial contributions by adding more features to the toolbar in the last few years.

Tor Lillquist was also responsible for the development of the Collabora Office for iOS app, which had a significant influence on the version for Android, and was made possible thanks to the great personal commitment of Nicolas Christener of Adfinis SyGroup. Thank you to Kaishu Sahu for his large amount of features programmed during the GSoC this summer, while our team member Jan Holesovsky has been the main developer of the current release.

Would you like to be part of the story ? get involved today.

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

Collabora Online 4.0.9 – Watermark improvements in Secure View, CentOS 8/RHEL 8 support, and more!

Cambridge, United Kingdom, November 28, 2019Collabora Productivity, the driving force behind bringing LibreOffice to the cloud, providing Collabora Online and other enterprise supported products, is excited to announce a new release of our product Collabora Online 4.0.9. This release comes with interesting new features and bugfixes too.

What’s new in Collabora Online 4.0.9?

Features

  • Improved watermark rendering in Secure View.
    • It is possible to override watermarks from the config file.
    • Watermarks are 45° rotated.
    • Watermarks are not displayed outside of the document area.

  • Search results are highlighted in read-only documents.

  • Action_Save now supports ExtendedData with custom contents, which is passed to the WOPI-like Host.
  • New setting to always save documents on exit and upload to the WOPI-like Host.
  • Introduced the “TemplateSource” WOPI property (for Nextcloud’s GlobalScale architecture).
  • New platform supported: CentOS 8 / RHEL 8

Bug-fixes

  • Improved stability, shutdown, and service life-cycle management.
  • Calc’s NOW() function shows the server’s local time correctly
  • Build with latest POCO C++ Libraries 1.9.4

Getting Collabora Online 4.0.9

Collabora Online is suitable for large scale deployment, comes with an SLA, Long Term Support with signed security updates as well as a rich product management interaction helping to direct our development priorities.

Enterprises interested in using Collabora Online can check out more information on partner integrations and online demos. For tailored solutions, contact sales@collaboraoffice.com.

Hosting and Cloud businesses that wish to add Collabora Online to their product portfolio can become a partner by filling in the partner form or contacting sales@collaboraoffice.com.

Collabora Online is only one part of a larger Enterprise File Sync & Share, Groupware, or Hosting solution. Collabora is excited to go to market with a long list of Partners each of which has an integration and provides you with useful support.

Online demo

You also can get an online demo of Collabora Online and try it out yourself right now!

For more information:

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

French service company Arawa implementing Collabora Online for the University of Lille

A Customer Case Study showing how students & staffs are allowed to collaborate on common online office documents at the University of Lille, France.

Arawa, a French services company specialized in Open Source and collaborative software, has successfully delivered a Collabora Online implementation to streamline collaborative efforts and support a new generation of student services, deployed at the University of Lille, in the north of France.

Seamlessly integrated with Nextcloud, the on-premise file share and collaboration platform, the University of Lille implemented another service aiming at easing collaboration projects between students and also between staff members: they now provide potentially more than 70 000 people with Collabora Online to help them work on a common framework of online office tools.

“The University is really aiming at facilitating open standards across the whole campus. Students especially came from different IT cultures and used so many different office tools and software products, that it made sense and became crucial to put a common solution at their disposal. And following our benchmark, Collabora Online fits in perfectly with Nextcloud.”
Cédric Foll, IT Director at University of Lille

Université de Lille

Reducing the number of tools used internally had also become an important challenge. The large number of tools mainly used by students did not really help secure a Research environment, and all the confidential information that is produced in such an environment.

“The project is aligned with our ambitions for the University of Lille”, said Pierre Boulet, VP of digital transformation. “In this case, Collabora Online is helping to support a huge student community.  It will also increase the University’s attractiveness to candidates and provide extra resources to make student life easier.”
Pierre Boulet, VP of digital transformation at University of Lille

The digital transformation of the University of Lille is really about the wider picture. It will help the University team enhance the overall student experience, and in the meanwhile, it will reinforce the image of the University as one in an on-going process of improvements.

“This project is a great example of how Collabora fulfills requirements of a powerful online office suite, ideally suited within Nextcloud. Data security was a key requirement here. They needed a solution which could be hosted on premises, and where they have a total control of the data.”
Philippe Hemmel, CEO of Arawa

.

“Arawa is an excellent partner”, said Michael Meeks, General Manager, Collabora Productivity, “We love to work as part of their their expert and dedicated service for their customers, and congratulate them on this implementation of Collabora Online.”
Michael Meeks, General Manager, Collabora Productivity

About Université de Lille

The University of Lille is a multidisciplinary, research-intensive university whose researchers collaborate with many partners throughout Europe and the world. With 67,000 students (including 7,300 international students), 6,300 staff members, 66 research units, and diplomas in all fields of study, the University of Lille is a major player in the region in training, research, innovation, and its commitment to social issues.

About Arawa

Arawa is a French IT services company, distributing and implementing Open-Source software solutions. These solutions offer collaborative capabilities to edit, store and share on-premises contents, with a high-level of security and control of the data. Thanks to a combination of deep functional and technical expertise, Arawa’s consultants deliver personalized and tailor-made solutions around a suite of open-source products: Nextcloud, LibreOffice, Collabora Online, OnlyOffice et Nayego.
Visit Arawa or follow @Arawa_fr on Twitter.

About Collabora

Collabora Productivity is the driving force behind putting LibreOffice in the cloud, providing Collabora Online and a range of other 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 benefits of Open Source to the commercial world, specializing in mobile, automotive and consumer electronics industries. For more information, visit Collabora Office or follow @CollaboraOffice on Twitter

Read More